Well surely, as Evo says, it must depend upon conditions.
Once formed what is there to cause failure of a hole?
What actually sometimes fails is the material around the hole perhaps because of chemical degradation or Earth movement.
Sometimes the material does not fail, it is simply removed by an external agent such as the sea in the case of coastal caves, removing a whole cliff including a cave.
Sometimes the cave creating agent widens the cavern until it can no longer span the gap so the roof falls in. This happens in the case of acidic groundwaters waters in limestone regions.
go well