New York Harbor had a number of "water-locked" yards, in both Manhattan and Brooklyn, which were accessed only by carfloat. Most of them closed in the last years of the 1960's, when mergers and the loss of manufactured, miscellaneous and perishable traffic made them redundant.
Two of the best known were the Bush Terminal and Brooklyn Eastern District Terminal; the latter used "fireless cooker" locomotives operating on steam generated in a stationary plant and transferred to the loco.
A number of roads based in Pennsylvania's anthracite region, such as Jersey Central and Lackawanna, also maintained "satellite" yards in Brooklyn or the Bronx.
There is a ton of material on these fascinating operations on the net; here's a link:
http://www2pb.ip-soft.net/railinfo/car- ... minal.html