No one will spend the sort of money that is needed to make a nuclear power station, if they were not reasonably assured that the risk from such an event is very small. and plants can be designed (as they are in Japan) to ride out a seismic event, and maintain containment.