NTSB investigations
261 cases where the sequence of events included Roll over.
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN12LA013Accident · No injuriesLimited investigationFinal reportWilhelm Calidus · Thompsonville, MIThe pilot 's inability to maintain control of the gyrocraft during the landing roll for undetermined reasons.NTSB ERA11CA505Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Clearwater, FLThe certified flight instructor's delayed remedial action, which resulted in a loss of control and subsequent rollover.NTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.NTSB WPR11LA423Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters UH-1H · Stockton, CAA total loss of engine power due to the separation of a tooth from the starter-generator drive gear, which resulted in failure of the engine oil pump and subsequent oil starvation.NTSB CEN11LA506Accident · No injuriesLimited investigationFinal reportGottschalk John R John 1 · Oshkosh, WIThe pilot's inadequate preflight planning, which led to the power required exceeding the power available and resulted in a loss of lift and subsequent hard landing.NTSB CEN11CA445Accident · Minor injuriesData collectionFinal reportSkytrails Lsa Predator · Coldspring, TXThe pilot's inadequate consideration of obstructions on his flight path and inability to maintain altitude following an unexplained loss of lift.NTSB CEN11LA356Accident · Minor injuriesLimited investigationFinal reportBell 206 · Walton, KSA loss of engine power for undetermined reasons because postaccident examination of the airframe and engine revealed no anomalies.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB CEN11LA200Accident · No injuriesLimited investigationFinal reportHughes 369D · Henryetta, OKFailure of the cyclic control system for reasons undetermined.NTSB WPR11CA121Accident · No injuriesData collectionFinal reportRobinson R44 · Ogden, UTThe certified flight instructor’s failure to maintain adequate main rotor blade rpm during a practice autorotation, resulting in a hard landing and rollover.NTSB WPR11GA115Accident · 1 fatalFinal reportMcdonnell Douglas Heli 369FF · Marana, AZAn inadvertent tail rotor strike during an attempted pinnacle landing, which resulted in the pilot's loss of control of the helicopter. Inhospitable terrain/topography contributed to the severity of the accident.NTSB ERA11WA122Accident · No injuriesForeign investigationBell 212 · Cuzco, PeruOn January 17, 2011, at 1940 universal coordinated time, a Bell 212 helicopter, Peruvian registration OB-1767-P, registered to Helicopters Service, and operated by Heliamerica S.A.C., experienced an un-commanded roll over during takeoff from a remote helipad…NTSB WPR11CA031Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe student pilot's failure to maintain the proper airspeed and the certificated flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing and rollover.NTSB ERA10CA495Accident · No injuriesData collectionFinal reportSkykits Savannah · Springville, TNCollision with an unknown object during landing.NTSB CEN10CA545Accident · Serious injuriesData collectionFinal reportAerospatiale AS 355F1 · Pikes Peak, COThe helicopter's encounter with an unexpected downdraft, which resulted in a hard landing.NTSB CEN10LA477Accident · No injuriesLimited investigationFinal reportBell 206B · Rocky Mount, MOA dynamic rollover inadvertently induced by the pilot during landing.NTSB ERA10CA407Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Aguadilla, PRThe pilot's inadequate preflight performance calculations, which resulted in the overweight helicopter's lack of hover capability out of ground effect.NTSB CEN10LA408Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Minden, NEThe pilot's inadequate flare during an autorotation, which resulted in a hard landing and subsequent rollover.NTSB CEN10CA371Accident · No injuriesData collectionFinal reportBrantly B-2B · East Troy, WIThe pilot's failure to maintain control during landing.NTSB WPR10CA278Accident · No injuriesData collectionFinal reportRobinson R22 · La Verne, CAA loss of engine power due to the pilot's inadvertent movement of the mixture control.NTSB WPR10CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kona, HIThe student pilot's improper use of the anti-torque controls and failure to maintain directional control during takeoff.NTSB WPR10LA232Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Mendon, UTA loss of engine power due to a failure of the magnetos as a result of inadequate maintenance.NTSB WPR10CA218Accident · No injuriesData collectionFinal reportCessna 172 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions during taxi.NTSB ERA10LA216Accident · No injuriesLimited investigationFinal reportSmith Richard D JR Revolution Mini 500 · Middleboro, MAA loss of engine coolant, which resulted in a loss of engine power during the pilot’s attempt to cushion a precautionary landing. Contributing to the accident was a disconnected engine coolant hose and the pilot's inadequate preflight inspection.NTSB CEN10CA183Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Idledale, COThe flight instructor's delayed remedial actions to regain rotor rpm, resulting in a rapid descent and hard landing.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB ERA10CA051Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Morovis, PRThe pilot’s delayed attempt to go around.NTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.NTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.NTSB WPR09LA373Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Riverdale, CAThe partial loss of engine power due to the failure of the engine's supercharger-blower.NTSB WPR09CA339Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Marysville, CAThe pilot’s failure to maintain adequate clearance from the power line wires.NTSB ERA09CA349Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot's failure to maintain control of the helicopter during hover, resulting in a rollover.NTSB WPR09LA213Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Las Vegas, NVLoss of engine power during approach for undetermined reasons.NTSB WPR09LA161Accident · No injuriesLimited investigationFinal reportBrown Barnett J4B · Sheridan, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.NTSB CEN09LA202Accident · Serious injuriesLimited investigationFinal reportHughes 269C · El Indio, TXThe pilot's failure to maintain control of the helicopter while attempting to land on a transport trailer in heavy rain and gusting winds.NTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.NTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.NTSB CEN09CA133Accident · Minor injuriesData collectionFinal reportBrantly B-2B · Cement, OKThe pilot's failure to maintain proper airspeed and descent rate during approach, which resulted in a hard landing. Contributing to the accident were the nearby power lines.NTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.NTSB CEN09CA068Accident · No injuriesData collectionFinal reportBrantly B-2B · Cedar Hill, TXThe pilot's improper decision to takeoff downwind. A contributing factor was the gusty conditions.NTSB WPR09CA023Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Temecula, CAThe certified flight instructor's failure to maintain adequate rotor rpm during a simulated approach to landing under variable wind, and high density altitude conditions.NTSB WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB SEA08LA213Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woods Landing-Jelm, WYThe pilot's encounter with a loss of tail rotor effectiveness event and his failure to maintain directional control while maneuvering. Contributing to the accident were the tailwind condition and the sloping, uneven terrain.NTSB LAX08CA298Accident · Minor injuriesData collectionFinal reportRobinson R22B · Prescott, AZThe student pilot's failure to maintain adequate main rotor rpm and the instructor's inadequate supervision and delayed remedial action.NTSB CHI08CA267Accident · No injuriesData collectionFinal reportHughes 269A · Bremen, OHThe pilot's failure to maintain sufficient main rotor speed during the quick-stop maneuver. Contributing to the accident was the drainage ditch.NTSB LAX08LA200Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Santa Maria, CAThe copilot's misjudged clearance from an object during a hovering turn for landing. Contributing to the accident were the inadequately marked heliport surface and the close proximity of an obstruction near the landing area.NTSB ANC08LA076Accident · No injuriesLimited investigationFinal reportEurocopter AS-350 BA · Chickaloon, AKThe pilot's incorrect actions during an out-of ground-effect hover, which resulted in the helicopter entering a main rotor ring vortex state, and a settling with power condition, producing an excessive descent rate and collision with terrain.