My take on a Constitution Refit currently being used as a Starfleet Academy Training Ship in the TNG era in 2371: USS Hornet
Ignore the Ship Registry number on the miniature 
. Feel free to use the Hornet in your campaign. She has a lot of fight left in her yet.
TRAIT: Gremlins! This ship is so old that there are always a few components that haven’t been replaced and are prone to faulty performance or failure. Whenever a complication is rolled on a Task by the ship for a given system, the complication range increases by one for all subsequent Tasks using the given system until repaired. The complication also increases the difficulty of ALL SUBSEQUENT ship Tasks for that system by one for each complication rolled. A successful repair of the system ( diff = to the complication range value ) will fix the system in question and restore the complication range back to 1 ( the default complication range ).