Where do trains go when they die?

What does the City of New York do with its rolling stock when the carriages have reached the end of the line? Believe it or not, they end up getting buried at sea. How bizarre!