Below is a list of resource materials that I’ve found handy while running Star Trek Adventures. It is presented here in the hopes that it might be useful for other gamemasters running their own Star Trek roleplaying campaigns.
All of the canon, at your fingertips. As Star Trek Adventures is set in 2371 by default, the episode listing of Deep Space Nine's third season has been extremely useful in planning our campaign. The episode listing even includes stardates!
Lists, breakdowns, and analysis of the various troupes that go into each Star Trek series.
Star Trek The Next Generation Technical Manual
Rick Sternbach and Micheal Okuda
This book set the standard for discussing the fictional technology of Star Trek. It contains a wealth of detail on the Galaxy-class USS Enterprise - NCC-1701-D - and, by extension, the Federation Starfleet at the time of The Next Generation.
Star Trek Deep Space Nine Technical Manual
Herman Zimmerman, Rick Sternbach, and Doug Drexler
Essentially a supplement for The Next Generation Technical Manual, providing the reader with an update for Deep Space Nine. There are errors in the some of the values given and the book doesn’t go into the same depth as the previous book. These issues do make it fall short of the standard set by The Next Generation Technical Manual, but does offer improved production values with higher quality paper and color illustrations.
Star Trek the Magazine
An officially authorized periodical that ran from 1999 - 2003. In addition to news, interviews, and behind-the-scenes articles, it featured material presented from an in-universe perspective. Below is a list of articles that caught my eye as I was scanning for ideas and inspiration.
May 2002, Volume 3, Issue 1 - "Starfleet Technical Database: Intrepid Class Design Evolution 2361-2370"
Illustrations and technical details of the development of the Intrepid-class starship.
November 2002, Volume 3, Issue 7 - "Starfleet Technical Database: Klingon Technology Personal Weapons" R.M. Sternbach, T. Earls
Illustrations and technical details of personal weapons issued by the Klingon Defense Force.
January 2003, Volume 3, Issue 9 - "Starfleet Technical Database: Constellation Class Engineering Report 3.01" R.M. Sternbach, T. Earls
Illustrations, class history, and technical details of the Constellation-class starship.
April 2003, Volume 3, Issue 12 - "Starfleet Technical Database: Aeroshuttle Technology Engineering Report 4.1" R.M. Sternbach, T. Earls
Illustrations and technical details of the Aeroshuttle deployed aboard Intrepid-class starships.
Star Trek Ships of the Line
Edited by Doug Drexler and Margaret Clark
A good visual reference for various ship classes. Some of the captions describing the action in certain pictures may serve as inspiration.
Star Trek Starship Spotter
Adam "Mojo" Lebowitz and Robert Bonchune
Another handy visual reference for various ship classes.
Haynes Klingon Bird-of-Prey Owner's Workshop Manual
Rick Sternbach and Ben Robinson
I was going to give this book a pass when I spotted a few years ago until I saw Rick Sternbach's name on the cover. Full of background information on how the Klingon Defense Force build and operate their ships as well as technical details on a design that’s been on screen for decades. If the player characters ever end up on a Klingon Bird-of-Prey or if I need to know something about how one of these ships work on a day-to-day basis, this is the book I’ll be reaching for.
Star Trek Spaceflight Chronology
Stan Goldstein, Fred Goldstein, and Rick Sternbach (Illustrator)
A long out-of-print book published around the time of Star Trek: The Motion Picture. This book was once considered canon for the novels, but has been superseded by later material. Nevertheless, some of the ideas it presents are useful as inspiration.