As part of Admiral Leyton's attempted coup d'état, the Lakota served to coordinate and deploy Starfleet Security forces on Earth during the period of martial law and received a refit that included upgraded phasers and a supply of quantum torpedoes. (DS9: "Homefront")
During the climax of the coup, the Lakota, under the command of the newly transferred Captain Erika Benteen, intercepted the USS Defiant to prevent the strengthening of anti-coup elements under Sisko. The resulting engagement was indecisive with both vessels reluctant to do more than attempt to disable the other.
When Leyton revised his orders and commanded Lakota to destroy Defiant, with quantum torpedoes if necessary, Benteen refused and instead stood down her ship and allowed Defiant to pass to Earth. (DS9: "Paradise Lost")
|USS Berlin • USS Cairo • USS Charleston • USS Crazy Horse • USS Enterprise-B • USS Excelsior • USS Farragut • USS Fearless • USS Fredrickson • USS Gorkon • USS Hood • USS Lakota • USS Malinche • USS Melbourne • USS Potemkin • USS Repulse • USS Valley Forge • Unnamed|
Background information Edit
Named for the Native American tribe, the Lakota was a re-use of the adapted USS Excelsior studio model of the USS Enterprise-B from Star Trek Generations. (Star Trek Encyclopedia 2nd ed., p. 257) Its appearance as the Lakota marked the last of many uses of the model. For more information on the model see here.
Benteen's captaincy of the Lakota was an in-joke by Ira Steven Behr; there was a Frederick Benteen who was in command of a 7th Cavalry battalion under the command of Lt. Col. George Armstrong Custer when Custer and his battalion of men were decimated by Lakota Sioux. (AOL chat, 1998)
The original Excelsior model was still marked with the Lakota's name and registry number when it was sold as Lot #998 at Christie's 40 Years of Star Trek: The Collection auction on 7 October 2006 for US$132,000 including the buyer's premium (the winning bid was US$110,000).
The model is now part of ScienceFictionArchives.com collections. 
The Lakota is depicted as still being in service in 2409 in Star Trek Online. She appears in two missions, "Under the Cover of Night" and "War Games". She is also one of several starships seen in orbit near the Earth Spacedock.