Despite the fact that superhydrophobic surfaces possess useful and unique properties, their practical application has remained limited by durability issues. Among those, the wetting transition, whereby a surface gets impregnated by the liquid and permanently loses its superhydrophobicity, certainly constitutes the most limiting aspect under many realistic conditions. In this study, we revisit this so-called Cassie-to-Wenzel transition (CWT) under the broadly encountered situation of liquid drop impact. Using model hydrophobic micropillar surfaces of various geometrical characteristics and high speed imaging, we identify that CWT can occur through different mechanisms, and at different impact stages. At early impact stages, right after contact, CWT occurs through the well established dynamic pressure scenario of which we provide here a fully quantitative description. Comparing the critical wetting pressure of surfaces and the theoretical pressure distribution inside the liquid drop, we provide not only the CWT threshold but also the hardly reported wetted area which directly affects the surface spoiling. At a later stage, we report for the first time to our knowledge, a new CWT which occurs during the drop recoil toward bouncing. With the help of numerical simulations, we discuss the mechanism underlying this new transition and provide a simple model based on impulse conservation which successfully captures the transition threshold. By shedding light on the complex interaction between impacting water drops and surface structures, the present study will facilitate designing superhydrophobic surfaces with a desirable wetting state during drop impact.