The most common mode of failure is overloading: Operating forces of the application produce loads that exceed the clamp load, causing the joint to loosen over time or fail catastrophically.
Overtorquing might cause failure by damaging the threads and deforming the fastener, though this can happen over a very long time.