List of Starfleet ships that are no longer in active service
Ship Name
Registry
Class
Status/Episode/Notes
Captian
S.S. Huron NCC-F1313  Independence Class Freighter Star Trek: TAS  "The Pirates Of Orion." Lt. Commander Michael O'Shea, deceased
S.S. Tsiolkovsky NCC-53911 Oberth Destroyed (41209.3+, 2364) by stellar fragment in the Star Trek: TNG  "The Naked Now" .
U.S.S. Ahwahnee NCC-71620  Cheyenne Class Exploration Cruiser Destroyed (2367) by Borg cube 
during battle at Wolf 359
.
U.S.S. Antares NCC-F1312 Independence Class Freighter Destroyed (1535.8, 2260) by Charles Evans. TOS "Charlie X." Captain Thomas Ramart, deceased
U.S.S. Archon  NCC-1370 Archon Class Cruiser  Destroyed (2167) by computer (Landru) in the atmosphere of Beta III. 
TOS "Return of the Archons."
.
U.S.S. Arcos NCC-6237 Deneva Class (Freighter) Destroyed (44215.2, 2367) by warp core breach over Turkana IV
Star Trek: TNG "Legacy."
.
U.S.S. Bellerophon NCC-62048  Nebula Class Tactical Cruiser Destroyed (2367) by Borg cube during battle at Wolf 359 .
U.S.S. Biko NCC-50331 Hope Class (Supply Ship) Presumed decommissioned. Seen in the 
Star Trek: TNG  "A Fistful Of Datas."
.
U.S.S. Bonestell NCC-31600 Oberth  Destroyed (2367) by Borg cube during battle at Wolf 359 .
U.S.S. Bozeman NCC-1841 Soyuz Class Attack Frigate Presumed decommissioned. Seen in the 
Star Trek: TNG  "Cause and Effect." 
Captain Morgan Bateson
U.S.S. Buran  NCC-57580 Challenger Destroyed (2367) by Borg cube during battle at Wolf 359 .
U.S.S. Cairo NCC-42136 Excelsior Destroyed (237x) by Jem'Hadar?? in the Star Trek: DS9  "In The Pale Moonlight." .
U.S.S. Carolina NCC-F1306 Independence Class Freighter Decommissioned; 
TOS "Friday's Child."
.
U.S.S. Chekhov NCC-53702 Springfield  Destroyed (2367) by Borg cube during battle at Wolf 359 .
U.S.S. Columbia NCC-621 Cygnus Class Scout Presumed decommissioned. Star Trek: The Motion Picture .
U.S.S. Constantinople NCC-34852 Istanbul Class (Transport Ship) Destroyed (2365) by hull breach suffered near "Gravesworld".
Star Trek: TNG  "The Schizoid Man."
.
U.S.S. Constellation NCC-1017 Bonhomme Richard 
Heavy Cruiser
Destroyed (2262) by detonation of impulse engines TOS  "The Doomsday Machine." Commodore Matthew Decker, deceased
U.S.S. Constitution NCC-1700 Constitution (II) Class Heavy
Cruiser
Decommissioned  TOS  "Space Seed" .
U.S.S. Cortez . . Destroyed (2374) by the Jem'Hadar 
Star Trek: DS9  "Far Beyond The Stars" 
Also in "Favor The Bold"
Captain Quenton Swaford deceased
U.S.S. Defiant NCC-1717 Bonhomme Richard Class Heavy Cruiser Phased into dimensional rift in 2263 in the 
TOS  "The Tholian Web"
.
U.S.S. Defiant NX-74205 Defiant Class Escort Destroyed (2375) by the Breen (Dominion) during fleetwide battle in the Chin'toka System Star Trek: DS9 "The Changing Face Of Evil" Captain Benjamin Sisko
U.S.S. Denver NCC-54927/
37893
Yorkshire Destroyed (2368) from striking gravitic mine left over from the CardassianWars. Crash-landed in the Mericor System after sustaining heavy damage. Star Trek: TNG "Ethics." .
U.S.S. Drake NCC-20381 Wambundu Class Light Cruiser Destroyed (2364) by automated defense system (Echo Papa 607) over planet Minos in the Lorenze Cluster 
Star Trek: TNG "The Arsenal of Freedom"
Captain Paul Rice, deceased
U.S.S. Entente NCC-2120 Federation Class Dreadnought Presumed decommissioned. 
Star Trek: The Motion Picture
.
U.S.S. Enterprise NCC-1701 Enterprise Class Heavy Cruiser Destroyed (2287) by auto-destruct sequence over planet Genesis.
Star Trek III: The Search For Spock
(former) Admiral James T. Kirk
U.S.S. Enterprise NCC-1701-A Enterprise (II) Class Heavy
Cruiser
Recieved order to be decommissioned in Star Trek VI: The Undiscovered Country. Captain James T. Kirk
U.S.S. Enterprise NCC-1701-B Excelsior Class Upgrade Decommissioned. Star Trek: Generations. Captain John Harriman
U.S.S. Enterprise NCC-1701-C Ambassador Class Heavy Cruiser Destroyed (2344) by three Romulan Warbirds over Klingon outpost on Narendra III; 
Star Trek: TNG  "Yesterday's Enterprise."
Rachel Garrett, deceased
U.S.S. Enterprise NCC-1701-D Galaxy Class Explorer   Destroyed (2371) by warp core breach due to battle with a Klingon Bird of Prey. Saucer section crash-landed on Veridian III 
Star Trek: Generations.
Jean-Luc Picard
U.S.S. Equinox NCC-72381 Nova Class Science Vessel   Destroyed (2376) by the U.S.S. Voyager in the Star Trek: Voyager "Equinox, Part II." Rudolph Ransom, deceased
U.S.S. Essex NCC-173 Daedalus Class Exploration Ship Destroyed (2167) near Mab-Bu VI. 
Star Trek: TNG "Power Play."
Bryce Shumar, deceased
U.S.S. Excalibur NCC-1705 Enterprise (II) Class Heavy Cruiser Disabled by the U.S.S. Enterprise during the M-5 computer test; 
TOS "The Ultimate Computer."
Harris, deceased
U.S.S. Exeter NCC-1706 Enterprise (II) Class Heavy Cruiser The Exeter was in automatic orbit of planet Omega IV. Crew was killed by an engineered pathogen. TOS "The Omega Glory." Ronald Tracy, deceased
U.S.S. Farragut NCC-1702 Enterprise (II) Class Heavy Cruiser  Presumed decommissioned. 
TOS "Obsession."
Garrovick, deceased
U.S.S. Farragut NCC-60597 Nebula Class Tactical Cruiser Destroyed (2373) by Klingons
DS9  "...Nor The Battle To The Strong."
.
U.S.S. Firebrand NCC-68723 Freedom Destroyed (2367) by Borg cube during battle at Wolf 359. .
U.S.S. Fleming NCC-20316 Oberth (Medical Transport) Presumed destroyed. Abandoned in subspace rift in the Hekarus Corridor in 2370; 
Star Trek: TNG "Force of Nature."
.
U.S.S. Gage NCC-11672 Apollo Destroyed (2367) by Borg cube during battle at Wolf 359;  .
U.S.S. Gander . Danube Class Runabout Destroyed (2375) by the Jem'Hadar over planet Goralis Prime Star Trek: DN9 "Penumbra." .
U.S.S. Ganges NCC-72454 Danube Class Runabout Destroyed (2370) by a T'Lani cruiser
Star Trek: DS9 "Armageddon Game."
.
U.S.S. Gettysburg NCC-3890 Constellation Class Star Cruiser Presumed decommissioned. 
Star Trek: TNG "Too Short A Season."
Adm (former) Captain Mark Jameson
U.S.S. Grissom NCC-638 Gagarin Destroyed (8210.3+, 2287) by a Klingon Bird of Prey. Star Trek III: The Search For Spock. J.T. Esteban, deceased
U.S.S. Grissom NCC-42857 Excelsior Destroyed (236x) by the Jem'Hadar during the battle of Ricktor Prime.
Star Trek: DS9 "Field of Fire."
.
U.S.S. Hathaway NCC-2593 Constellation Class Star Cruiser Decommissioned, Last seen used as a tactical simulation ship
Star Trek: TNG "Peak Performance."
.
U.S.S. Hera NCC-62006 Nebula Class Tactical Cruiser Presumed destroyed (2370)
Star Trek: TNG "Interface."
Silva LaForge, deceased
U.S.S. Honshu NCC-63426 Nebula Class Tactical Cruiser Destroyed (2374) by Cardassians
Star Trek: DS9  "Waltz"
.
U.S.S. Hood NCC-1707 Enterprise Class Heavy Cruiser Decommissioned; last seen in the TOS "The Ultimate Computer" .
U.S.S. Horatio NCC-10532 Ambassador Class Heavy Cruiser Destroyed (2364) near Dytallix B.
Star Trek: The Next Generation "Conspiracy."
Walker Keel, deceased
U.S.S. Horizon NCC-1000 Horizon Class Cruiser  Presumed decommissioned. 
Star Trek "A Piece Of  The Action."
.
U.S.S. Intrepid NCC-1708 Bonhomme Richard Class Heavy Cruiser Destroyed (2262) by massive space ameoba. TOS "The Immunity Syndrome." .
U.S.S. Intrepid NCC-38907 Excelsior Star Trek: TNG  "Sins Of The
  Father", and "Family".....
.
U.S.S. Jenolen NCC-2010 Sydney Class Transport Destroyed (2369) by the U.S.S. Enterprise NCC-1701-D Star Trek: TNG "Relics." .
U.S.S. Kyushu NCC-65491 New Orleans Destroyed (2367) by Borg cube during battle at Wolf 359. Star Trek: TNG "The Best of Both Worlds Part II." .
U.S.S. Lalo NCC-43837 Mediterranean Class (Freighter) Destroyed (2366) by Borg Cube near Zeta Alpha II. Star Trek: TNG "The Best of Both Worlds Part I." .
U.S.S. Langley NCC-1915-B Leavenworth Destroyed (2367) by Borg cube during battle at Wolf 359. .
U.S.S. Lantree NCC-1837 Miranda  (Class 6 Supply Ship) Destroyed (42494+, 2365) by the U.S.S. Enterprise NCC-1701-D
Star Trek: TNG "Unnatural Selection."
L. Isao Telaka(sp?), deceased
U.S.S. Lexington NCC-1703 Enterprise (II) Class Heavy Cruiser Presumed decommissioned. 
Star Trek "The Ultimate Computer."
(former) Commodore Robert Wesley
U.S.S. Majestic NCC-31860 Miranda Destroyed during retake of DS9 .
U.S.S. Mekong NCC-72914 Danube Class Runabout Destroyed (2371) in the Gamma Quadrant. .
U.S.S. Melbourne NCC-62043 Excelsior Destroyed (2367) by Borg cube during battle at Wolf 359;
Star Trek: TNG "The Best of Both Worlds Part II."
.
U.S.S. Odyssey NCC-71832 Galaxy Class Explorer Destroyed (2370) by Jem'Hadar vessel in collision in the Gamma Quadrant near  Bajoran wormhole. Star Trek DS9 "The  Jem'Hadar." Keogh Rammed (sp?)
U.S.S. Olympia . . Destroyed (2371) by metrion surge and crash-landing; referred to in the
Star  Trek: DS9 "The Sound Of Her Voice."
Lisa Cusack, deceased
U.S.S. Orinoco NCC-72905 Danube Class Runabout Destroyed (2371) by a warp core breach.
Star Trek: Deep Space Nine "Our Man Bashir."
.
U.S.S. Pegasus NCC-53847 Oberth Materialized inside asteroid rock due to malfunction of prototype phasing cloak device.  Star Trek: TNG  "The Pegasus." Erik Pressman
U.S.S. Potemkin NCC-1711 Constitution Class Heavy Cruiser Decommissioned (2295);
TOS "The Ultimate Computer"  and "Turnabout Intruder."
.
U.S.S. Princeton NCC-59804 Niagara Destroyed (2367) by Borg cube during battle at Wolf 359. .
U.S.S. Prometheus NCC-71201 Nebula Class Tactical Cruiser Presumed destroyed.Star Trek: DS9
"Second  Sight"
.
U.S.S. Raman NCC-29487 Oberth Class (Science vessel) Destroyed (2370) in atmosphere of Marijne VII.
Star Trek: TNG "Interface."
.
U.S.S. Reliant NCC-1864 Avenger Class Heavy Frigate Destroyed (8141+, 2287) by Genesis Device detonation.Star Trek II: The  Wrath of Kahn. Clark Terrell, deceased
U.S.S. Republic NCC-1371 Constitution Class Heavy Cruiser Presumed decommissioned. 
TOS   "Court-Martial."
.
U.S.S. Revere NCC-595 Hermes Class Scout Presumed decommissioned. 
Star Trek: The Motion Picture.
.
U.S.S. Righteous . Excelsior Destroyed (2367) by Borg cube during battle at Wolf 359 .
U.S.S. Roosevelt NCC-2573 Excelsior Destroyed (2367) by Borg cube during battle at Wolf 359. .
U.S.S. Rutledge NCC-57295 New Orleans Presumed decommissioned. 
Star Trek: TNG  "The Wounded."
(former) Captain Benjamin Maxwell
U.S.S. Sao Paulo NCC-75633 Defiant Class Escort Decommissioned (2375); recommissioned as the U.S.S. Defiant NX-74205
(second ship of the same name and class)
Star Trek: DS9 "The Dogs Of War"
(former) Captain Benjamin Sisko
U.S.S. Saratoga  NCC-1892 Cyane Class Heavy Frigate Disabled by Cetacean Probe in 2286 while patrolling the Neutral Zone.
Star Trek IV: The Voyage Home.
.
U.S.S. Saratoga NCC-31911 Miranda Destroyed (2367) by Borg cube during (was it mentioned in Bobw??) battle at Wolf 359 Star Trek: TNG "The Best of Both Worlds Part II"
Star Trek: DS9 "Emissary"
Storil, deceased
U.S.S. Shenandoah NCC-73024/1?? Danube Class Runabout Destroyed (2374) by the Jem'Hadar 
Star Trek: DS9  "Valiant."
.
U.S.S. Sitak . Miranda Destroyed during retake of DS9. .
U.S.S. Stargazer NCC-2893 Constellation Class Star Cruiser Lost at Battle of Maxia, later recovered, decommissioned Star Trek: TNG "The Battle." Jean-Luc Picard
U.S.S. Tian An Men NCC-21382 Miranda Star Trek: TNG "Redemption II."
Reported missing near the Cardassian border.
Star Trek: DS9 "In The Cards" (2373).
.
U.S.S. Tolstoy NCC-62095 Rigel Destroyed (2367) by Borg cube during battle at Wolf 359 Star Trek: TNG "The Best of Both Worlds Part" .
U.S.S. Tombaugh (sp?) . . Assimilated by the Borg. Star Trek: Voyager "Infinite Regress." Blackwood, deceased
U.S.S. Tripoli NCC-19386 Hokule'a Decommissioned; Star Trek: TNG  "Unification, Part II" Ref "Datalore" .
U.S.S. Valiant NCC-1709 Constituition Class Heavy Cruiser Destroyed (2225) by sonic weapon on planet Eminiar VII;  Star Trek "A Taste of Armageddon." .
U.S.S. Valiant NCC-74210 Defiant Class Escort Destroyed (2374) by Dominion vessel. Star Trek: DS9 "Valiant." .
U.S.S. Yamaguchi NCC-26510 Ambassador Class Heavy Cruiser Destroyed (2367) by Borg cube during battle at Wolf 359 Star Trek: TNG "The Best of Both Worlds Part" .
U.S.S. Yamato NCC-71807 Galaxy Class Explorer Formerly NCC-1305-E; Destroyed (42609.1, 2365) by an ancient Iconian computer virus in the Neutral Zone Star Trek: TNG "Contagion." Donald Varley, deceased
U.S.S. Yangtzee Kiang NCC-72453 Danube Class Runabout Crashed landed (2369) on penal colony moon in the Gamma Quadrant Star Trek: DS9 "Battle Lines." .
U.S.S. Yorktown NCC-1704 Constitution (II) Class Heavy Cruiser Presumed decommissioned; 
TOS "Obsession"
Star Trek IV: The Voyage Home.
Garrovick deceased
U.S.S. Yosemite NCC-19002 Oberth Trapped in solar plasma streamer in the Igo Sector Star Trek:  TNG "Realm of Fear." .
U.S.S. Yukon NCC-74602 Danube Class Runabout Destroyed (2373) by the U.S.S. Defiant NX-74205 
Star Trek: DS9 "By Inferno's Light."
.

Notes/Comments:

The following ship classes are all of the Avenger Group Class Configuration,
and are listed in chronological order of refit/upgrade: Avenger, Cyane, Soyuz,
and Miranda. The Miranda Class does not have an official designation because
they are used for multiple purposes as Medical Supply/Transport vessels and
other Supply/Cargo vessels.

The following ship classes are all of the Constitution Group Class Heavy
Cruisers, and are listed in chronological order of refit/upgrade:
Constitution, Bonhomme Richard, Archenar, Enterprise, Constitution (II),
Endeavor, Tikopai, and Enterprise (II).

The Excelsior Class' type of ship is disputed. The U.S.S. Ingram Blueprints
call it a `Space Control Ship', while the Jackill's Manual calls it a `Heavy
Cruiser'. It is listed here as both because an Excelsior Class ship can
certainly have multiple roles.

The following ship classes are all of the Gagarin Group Class and are listed
in chronological order of refit/upgrade: Gagarin, Oberth. Like the Miranda
Class, the Oberth Class does not have an official desigantion, and is used
for Medical/Science Research and Transport.

The class listed for each ship is the final class that it was configured to.

The stardate of a ship's decommissioning/destruction is listed whenever
possible and the year is given in Terran years.

The commanding officer for each ship is the last commanding officer of
that ship or the only name given on-screen.

All of Michael Okuda's information listed in his various published works on
the original Star Trek through Star Trek VI: The Undiscovered Country is not
recognized in this list.

References/Sources used in this ship list:

Television Series/Theatrical Motion Pictures:
Star Trek (The Original Series) (1966-1969)
Star Trek: The Animated Series (1973-1974)
Star Trek: The Motion Picture (1979)
Star Trek II: The Wrath of Kahn (1982)
Star Trek III: The Search For Spock (1984)
Star Trek IV: The Voyage Home (1986)
Star Trek V: The Final Frontier (1989)
Star Trek VI: The Undiscovered Country (1991)
Star Trek: Generations (1994)
Star Trek: First Contact (1996)
Star Trek: Insurrection (1998)
Star Trek: TNG (1987-1994)
Star Trek: Deep Space Nine (1993-1999)
Star Trek: Voyager (1995-Present)

Publications:
The Making of Star Trek (1968, Stephen E. Whitfield/Gene Roddenberry)
The Star Fleet Technical Manual (1975, Franz Joseph Designs)
The Star Trek Encyclopedia (Michael Okuda/Denise Okuda/Debbie Mirek)
Star Trek Fandom Chronology (1999, James Dixon)
Jackill's Star Fleet Reference Manual (Eric Kristiansen)
Star Fleet Officer Requirements (1985, David Schmidt)
Ships of the Star Fleet??
Heavy Cruiser Evolution Blueprints??
U.S.S. Cheyenne - Class Operations Manual

Copyright 2000 Mitchell Nozka. Last revised Terran stardate 0003.31.
Please distribute this file free of charge to anyone interested.
I encourage you to reply additions, comments, revisions, etc., but please
distribute this file in it's original form.