NTSB investigations, IL
8 cases where the defining event was Nose over/nose down.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 1 |
| 2022 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '096')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '096') 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 CEN22LA393Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Harvard, ILThe pilot’s failure to maintain directional control during take-off, which resulted in a collision with crop and terrain.NTSB CEN18LA043Accident · No injuriesLimited investigationFinal reportRutten Phil J Pietenpol · De Kalb, ILThe pilot’s excessive rudder and brake applications during landing, which caused the airplane to nose over.NTSB GAA16CA397Accident · No injuriesData collectionFinal reportOlmsted Charles A RV · Dwight, ILThe pilot's delayed action to perform an aborted landing, which resulted in a nose over and substantial damage to the firewall, fuselage, and empennage.NTSB CEN15LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Nutwood, ILA partial loss of engine power due to the undetected loosening of the four carburetor bolts that connect the throttle body to the bowl assembly.NTSB CEN15LA334Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Chicago, ILAn encounter with a wind gust during ground maneuvering and the captain’s improper flight control positioning to account for wind conditions, which resulted in the airplane being blown onto its left wing.NTSB GAA15CA087Accident · No injuriesData collectionFinal reportSmith Vilas Kitfox · McLeansboro, ILThe pilot's failure to maintain attitude control during the landing roll. A contributing factor was the pilot's lack of training and experience in this airplane make and model.NTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.NTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.