I have only had very few incident with ill-behaved passengers, and none that escalated. Ill passengers is a different story, especially on longer flights! With no hard data to back this up, I think that medical emergencies are probably the most common form of abnormal event that we encounter.