The phrase de pilón is used when referring to the occurrence of an unplanned episode or accident. In narrating a personal story with an unhappy ending, an individual might add, "Y de pilón me caí" (and to top it off, I fell down).
The phrase de pilón is used referring to repeating accidents. In narrating a personal story with a bad ending, someone might add "Y de pilón me caí".