NTSB investigations, IL
8 cases where the sequence of events included Roll over.
Cases per year
| 2012 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2018 | 2 |
| 2019 | 1 |
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.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND 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 GAA19CA149Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · Springfield, ILThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.NTSB GAA18CA401Accident · No injuriesData collectionFinal reportGrumman G164 · Rochelle, ILThe pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall.NTSB GAA18CA110Accident · Minor injuriesData collectionFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe student pilot's failure to maintain yaw control while landing in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…NTSB CEN15LA198Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunlap, ILA loss of main rotor rpm for reasons that could not be determined during postaccident examinations.NTSB CEN14LA316Accident · 1 fatalLimited investigationFinal reportGrazhopper Trike · Ottawa, ILThe noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…NTSB CEN13LA487Accident · No injuriesLimited investigationFinal reportBell 206B · Albers, ILFuel contamination, which resulted in the loss of engine power.NTSB CEN12LA309Accident · Minor injuriesLimited investigationFinal reportQuicksilver Sprint II · Lebanon, ILThe total loss of engine power due to a fatigue failure of the crankshaft, attributed to the relative movement between the crankshaft and flywheel assembly.