The USS Constitution is now the only commissioned US Navy ship to have actually sunk an enemy ship in combat.
And the only ship to have actually captured an enemy as well!
Technically, not true. About a week before D-Day, a German U-boat was forced to the surface off of Africa. A US destroyer crew boarded the damaged and abandoned sub.
Can't remember why the self-destruct charges didn't go off, but a US sailor closed a sea cock or two, saving it from sinking.
The code books were intact, and somebody in charge knew enough not to let the Germans know, especially so close to D-Day, so the sub was towed to the Bahamas, iirc, to minimize news of the event, otherwise letting the Germans know it might be a good time to do an early code change.
Thanks Robert A Cook PE. And she's a beauty.