Star Trek Bridge Commander

Star Trek: Bridge Commander is a tactical simulation, or flight sim, game, published by Activision, based in the Star Trek universe.

The plot revolves around a newly promoted captain who's been assigned to investigate an explosion of a star in the Maelstrom. Throughout the mystery, Captain Jean-Luc Picard and Lt. Commander Data comes by to assist the captain in the investigation.

It appears that a rogue Cardassian is responsible and is using a new weapon from an unknown race to threaten Alpha Quadrant races.

The captain and his crew take command of the USS Sovereign to combat this new threat to the Federation.

A large player Modding community based around this game is located at bcfiles.com They offer, hundreds of new ships, art, explosions, and modifications such as ejectable warp cores.

The game allows two different flavours of gameplay: history mode, and simulation mode. Simulation mode allows customizing missions for neverending playing -- from Starfleet defensive tactics, to be a shuttle craft in a cooperative assault to a Cardassian outpost.