A few adventure ideas....
Episode: Eve of Destruction
Era: Any
Type: Time travel
The officers (eg PCs) of the ship/station are on a shuttle/runabout making their way to the planet/conference/negotiations when they hit subspace anolmaly. There is a massive increase in chronoton radiation (or other techobabble) and when the crew come round they are lightyears from where they started. Checking chronometers/starcharts etc, the crew find they have been slung decades into the past to 2156. Ahead of them is a Marshall Class Destroyer, the USS Patton (a nod to my ancient Spaceflight Chronology which has the Romulan war start in 2106, but it is not canon, so I am using the Okuda Star Trek Chronology book for dates). Any historical data base check will see that this ship will be ambushed in 12 hours, starting the war. This ambush comes after several years of Romulan activity and espionage. The shuttle is on minimal power, and there is a small gunboat heading toward the crew. The crew have got to escape and make sure the timeline is not polluted. Hopefully, one of the crew will have a distant relative that dies here.......if captured, any non-original federation race (eg: Non-Vulcan, Andorian or Tellarite) will be questioned as a possible spy, and suspected Romulan....In the game I played in, the Captain of the Patton was a career military guy, and his first officer was pretty much paranoid and convinced the PCs were saboteurs or spies. :-)
Title: Goliath Awaits
Era: Any (probably TOS/Film Era)
Type: Exploration/Rescue Mission
Whilst exploring (insert name) star system, the sensors pick up (technobabble) radiation traces. Such traces are usually from a damaged warp core. Investigation leads them to a water planet. Any database checks will show that the USS Goliath was lost here, with all hands some years ago. No trace of the ship was found. Recent upgrades in sensor technology enables the PCs to find these emmisions. Sensor readings of the planet show a large metal object beneath the waves, with heat and radiation levels showing, and at a level consistent with a small settlement. Taking a shuttlecraft down to the site shows a wreckage pattern, and then a large piece of what is obviously a starship.........lit. There is life aboard!
What has happened: The last remaining officer (Insert Name) managed to splash land the ship, and it began to sink. Sealing the bulkheads, and using the last vestiges of thruster power, he settled the ship on a shelf in a shallow sea. Too deep to be found, but shallow enough that the pressure would not collapse the hull. Being an engineer, he managed to stabilise the warp core, but with no engines or any way to make them, the crew were stranded. They managed (under his command) to create a life for themselves down here, whilst awaiting federation rescuers. That was 25 years ago. In the meantime, he has become somewhat unstable, and will be opposed to leaving, as he has total power here. The community is approximately 200 people. They have a school for the children that have inevitably been born in the past two and a half decades, a hospital (with obvious love-interest nurse: son/daughter of the leader) etc. Do the survivors want to leave? Are they happy with their independent life below the waves? Have they impacted on the planet (and possibly its non-warp capable local fish-people, thus breaking the Prime Directive?)...............'s up to you, Mr GM! :-)
I'm NOT stupid, I'm NOT expendable and I'm NOT going!