Is there any prior warning that the B2 piston in the transmission is about to fail, or does it just go and trash the tranny?

Did these pistons fail early on or as the car aged? If the car has 99,000 miles on it, does it mean it will hold up?

Any thoughts appreciated - Ron