NTSB investigations
181 cases where the first occurrence was “Roll over”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 10 |
| 1984 | 11 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 3 |
| 1990 | 12 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 3 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 14 |
| 2002 | 8 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 9 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 380) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 380) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA08CA002Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Lake Powell, UTThe pilot's inadequate preflight inspection and failure to remove a tie-down strap before departure.NTSB SEA07CA256Accident · Minor injuriesData collectionFinal reportRogerson Hiller RH-1100 · Stanwood, WAThe pilot's failure to execute a go-around and his failure to reduce his groundspeed to zero prior to touching down on the rough/uneven terrain. Factors include the momentary restriction of a flight control, rough/uneven terrain, and a tailwind.NTSB ATL07CA103Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Immokalee, FLThe pilot left the helicopter unattended with the engine operating which resulted in an inadvertent rollover.NTSB DFW07CA096Accident · No injuriesData collectionFinal reportRobinson R-22 Beta · Spring, TXThe student pilot's improper use of the flight controls resulting in dynamic rollover. Contributing factors were the delayed remedial action by the flight instructor and the uneven, muddy terrain conditions.NTSB LAX07CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Spanish Fork, UTThe student pilot's improper use of the flight controls, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.NTSB CHI07CA094Accident · No injuriesData collectionFinal reportMcCall Rotorway 162F · Malta, ILThe pilot's improper use of the rotorcraft flight controls resulting in a dynamic rollover during takeoff. A factor was the soft ground that the left skid encountered.NTSB LAX07CA041Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Tulare, CAThe student pilot's improper use of the collective and cyclic control, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.NTSB LAX07CA073Accident · No injuriesData collectionFinal reportRobinson R-22 Beta 2 · Salem, ORThe student pilot's improper remedial action when a dynamic rollover was encountered.NTSB MIA07CA035Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Lakeland, FLThe flight instructor's selection of an unsuitable landing site, which resulted in an inadvertent dynamic rollover during landing. A factor associated with the accident was the inadvertent dynamic rollover.NTSB MIA07CA021Accident · Minor injuriesData collectionFinal reportRobinson R22 · Lakeland, FLThe flight instructor's failure to maintain control of the helicopter during takeoff resulting in a roll over.NTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…NTSB LAX07CA034Accident · No injuriesData collectionFinal reportBell 206B · Boulder City, NVthe pilot's inadequate planning and decision in his failure to reduce the engine throttle to ground idle prior to exiting the helicopter.NTSB MIA06CA053Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe improper landing flare by the pilot-rated student and the inadequate supervision of the pilot-rated student by the certified flight instructor, resulting in the improper touchdown of the helicopter and the helicopter rolling over.NTSB LAX06CA116Accident · Minor injuriesData collectionFinal reportRobinson R22 · El Monte, CAthe pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.NTSB LAX05CA291Accident · No injuriesData collectionFinal reportRobinson R22 · Santa Clarita, CAthe pilot's improper use of the collective control while attempting to free the right skid, which induced a dynamic rollover.NTSB IAD05LA075Accident · Minor injuriesLimited investigationFinal reportHughes TH-55 · Paintsville, KYthe pilot's inadvertent encounter with ground resonance which resulted in destruction of the helicopter.NTSB SEA05CA104Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Estacada, ORThe failure of the pilot to maintain landing skid clearance during hover taxi, which resulted in a dynamic rollover. A factor was the gusty wind condition.NTSB ATL05CA077Accident · No injuriesData collectionFinal reportBell 206L 1 · Cherokee, NCThe pilot's improper use of the helicopter flight controls during a hover that resulted in a dynamic rollover.NTSB MIA05LA095Accident · Serious injuriesLimited investigationFinal reportBell 206B · Coral Springs, FLThe pilot encountered dynamic rollover while lifting off from an area in the everglades with 6-7 foot tall sawgrass nearby.NTSB LAX05LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Waddell, AZthe pilot's failure to maintain adequate rotor rpm and obstacle clearance, resulting in a dynamic rollover and collision with terrain.NTSB LAX05CA095Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lake Arrowhead, CAthe certified flight instructor's failure to adequately compensate for wind conditions and his selection of terrain unsuitable for a safe takeoff which resulted in a dynamic rollover.NTSB MIA05CA009Accident · Serious injuriesData collectionFinal reportRobinson R-22 · Vega Baja, PRThe pilot's failure to select a suitable landing area resulting in a tangled skid with vegetation during an aborted landing and subsequent dynamic roll over.NTSB LAX05CA004Accident · No injuriesData collectionFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)the pilot's inadequate preflight inspection to ensure that all tie downs were removed from the helicopter, which resulted in a dynamic rollover.NTSB DEN04LA149Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS-350-B3 · Las Cruces, NMThe pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…NTSB LAX04CA315Accident · Minor injuriesData collectionFinal reportBell 206B · Kahului, HIthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a dynamic rollover. Contributing factors were the direct crosswind and his lack of total experience in the accident helicopter make and model.NTSB ATL04LA155Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Goldsboro, NCThe pilot's failure to obtain the proper touchdown point during landing on a helipad with an exposed edge, which resulted in an in-flight collision with terrain.NTSB LAX04LA249Accident · 1 fatalLimited investigationFinal reportBell 206B · Mesa, AZthe pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.NTSB MIA04CA059Accident · No injuriesData collectionFinal reportRobinson R22 · Keystone, FLThe inadequate supervision by the flight instructor by allowing the student to lose excessive altitude resulting in a skid impacting the ground and subsequent roll over of the helicopter.NTSB LAX04CA146Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAthe student pilot's improper use of the cyclic control and the certified flight instructor's inadequate supervision, which resulted in a rollover.NTSB MIA03TA152Accident · No injuriesFinal reportBell BHT-206-B3 · Fort Myers, FLThe pilot's failure to adequately clear the right skid of obstructions which resulted in a dynamic rollover to the right during takeoff and damage to the helicopter.NTSB CHI03IA207Incident · No injuriesIncident investigationFinal reportSpiker Rotorway 162F · Creve Coeur, MOThe inadvertent dynamic rollover of the helicopter after the helicopter became airborne during an engine run-up.NTSB LAX03LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta II · Phoenix, AZThe instructor's inadequate supervision and his failure to maintain aircraft control. The wind gusts were a factor.NTSB FTW03LA140Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Ardmore, OKThe pilot's failure to maintain directional control during liftoff. A contributing factor was the inadvertent encounter of propeller blast from the other airplane starting at the time of takeoff.NTSB ATL03LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Fort Lauderdale, FLThe private pilots improper use of flight controls during a run on landing resulting in a roll over.NTSB NYC03LA045Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Pittsfield, MAThe pilot's failure to maintain control, which resulted in a rollover. Factors in this accident were the night light conditions, ice covered ramp and a snowbank.NTSB LAX03LA017Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kaaawa, Oahu, HIDynamic rollover during an attempted takeoff, due to the combined effects of the soft sloping terrain and the pilot's failure to redistribute the passengers to a more favorable lateral CG condition.NTSB FTW02LA268Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Del Rio, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the reported gusting wind conditions.NTSB CHI02CA296Accident · No injuriesData collectionFinal reportRobinson R-22 · Maryland Height, MODynamic rollover due to the flight instructor's improper control inputs and the flight instructor's unsuccessful remedial actions. A contributing factor is the passenger's inadvertent movement of the cyclic control.NTSB NYC02LA149Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Madison Heights, VAThe pilot's failure to attain the proper touchdown point on the helipad, which resulted in a rollover. A factor in this accident was pilot fatigue.NTSB LAX02LA196Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · North Las Vegas, NVthe student pilot's improper liftoff into tailwind conditions, improper use of the collective, and failure to relinquish the flight controls to the CFI, resulting in the helicopter colliding with terrain. Also causal was the CFI's inadequate supervision and…NTSB MIA02LA101Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Bunnell, FLThe failure of the student pilot to secure the rotorcraft floorboard mounted ballast, resulting in shifting of the ballast on liftoff, and the subsequent dynamic rollover.NTSB LAX02LA149Accident · No injuriesLimited investigationFinal reportSierra RAF 2000 GTX-SE · Lompoc, CAThe pilot's failure to compensate for wind condition.NTSB FTW02LA080Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Encino, TXThe pilot's failure to maintain aircraft control during lift off from a transport trailer resulting in dynamic rollover of the helicopter.NTSB LAX02LA039Accident · No injuriesLimited investigationFinal reportBell 206 B-2 · Aieia, HIThe pilot's loss of lateral control while in a hover that resulted in a rollover and collision with the ground. A factor was the unclear exit and boarding procedures provided to the work crew, who were non-aviators, during the preflight briefing.NTSB LAX02LA032Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Pacific Ocean (Pacific Ocean)A dynamic roll over due to the pilot's inadequate preflight inspection and failure to ensure that all tiedowns were removed. A factor in the accident may have been the lack of clear communications between the pilot and the shipboard helper assigned as the…NTSB CHI01LA324Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · East Troy, WIThe inadvertent dynamic rollover the student pilot encountered following his excessive control inputs during the takeoff portion of the instructional flight and the instructor not performing the remedial action necessary to reduce the excessive control inputs…NTSB NYC01LA179Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Niagara Falls, NYThe right skid getting snagged on the helicopter-dolly resulting in dynamic rollover.NTSB LAX01LA227Accident · No injuriesLimited investigationFinal reportBell 206B · Salinas, CAthe student's improper use of the cyclic controls and his failure to relinquish aircraft control, and the flight instructor's inadequate supervision.NTSB IAD01LA071Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Atwater, OHThe pilot's improper remedial response to a dynamic rollover event, which resulted in the helicopter rolling over on its side.NTSB MIA01LA153Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Double Springs, ALThe failure of the pilot to maintain clearance between the skid and trailer while attempting to lift from a trailer resulting in dynamic roll-over.