What could have caused this SMD capacitor failure?
It could have been physically damaged- either big cracks or it could have had micro-cracks. It could simply be a random failure from a latent manufacturing defect.
From murata.com:

MLCC capacitors are available with &quot;soft&quot; electrodes for higher resistance to cracking. Image from tdk.com