When was the last time a US Navy ship was sunk during battle?

The last time a U.S. Navy ship was sunk in combat was during World War II. The USS Indianapolis (CA-35) was a heavy cruiser that played a crucial role in delivering components of the atomic bomb to the island of Tinian. After completing this mission, it was torpedoed by a Japanese submarine, the I-58, on 30 July 1945. Tragically, the ship sank with the loss of a significant number of crew members.

https://en.wikipedia.org/wiki/USS_Indianapolis_(CA-35)

Additional info: The death toll of the USS Indianapolis was 883.

https://en.wikipedia.org/wiki/List_of_ships_sunk_by_submarines_by_death_toll

Sorry, but the last major U.S. ship sunk during WWII was the USS Bullhead (SS-332), sunk on August 6, 1945.

http://www.oneternalpatrol.com/uss-bullhead-332-loss.htm

Sarsi (AT-111) Sank after striking a mine, 27 August, 1952.

On the 20th, typhoon -Karen- hit the coast. For the next week, Sarsi towed various vessels; carried light cargo and personnel; relocated buoys and conducted nighttime, close-inshore anti-mining and anti-junk patrols. On the afternoon of the 27th, she refueled from Cimarron (AO-22); and, at 1847, moved north to patrol along the edge of the mineswept waters between Wonsan and Hungnam. At 2200, all unnecessary lights were extinguished. She reached Hungnam without incident; but, as she turned to return to Wonsan, a drifting mine, probably cut loose by the typhoon, exploded against her hull. Damage control efforts proved futile, and Sarsi sank in twenty minutes.

https://www.history.navy.mil/research/histories/ship-histories/danfs/s/sarsi.html