The Adams is a transport ship that was in service until 2378. In that year, it, and its escort, the USS Dauntless, were destroyed in the Serris system. (TNG video game: Bridge Commander)
Last Cargo and Destination
Quantum torpedos en route to Starbase 12.
It is speculated that there are live torpedos on on the hull.