Generally speaking I dont think its possible to construct a bridge that doesn’t collapse overall. The will always have a force threshold or resonance frequency that will bring it down eventually, its up to the engineer to consider the risk of such an event occuring and construct the bridge accordingly with some safety measure.