It's not especially common, but the Sunshine Skyway Bridge in Tampa Bay is a famous example. Similar circumstances - it collapsed after being hit by a ship.