Some people worry that the gear will dig in and flip the plane, but
articles I've
read indicate that this rarely happens in real life.


But sometimes it does - see this movie (3.0Mbytes)...

http://www.iflypete.com/Media/Cesna-Accident.mpg


(best to turn the sound down as it's faulty).

regards,
Richard