NTSB investigations, IL
5 cases where NTSB found Aircraft power plant, general.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2016 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010500'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010500')) 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 CEN16LA297Accident · No injuriesLimited investigationFinal reportCessna 172F · Newark, ILThe failure of the No. 4 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB CEN12LA455Accident · No injuriesLimited investigationFinal reportCessna 175A · Shelby, ILThe loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.NTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.NTSB CHI08LA169Accident · No injuriesLimited investigationFinal reportMorrison E-Racer · Aurora, ILAn undetermined failure in the high-pressure fuel system, and the subsequent loss of engine power and in-flight fire. Contributing to the accident were the pilot's restricted visibility due to the smoke in the cockpit, failure of the aileron control during…NTSB CHI08CA079Accident · No injuriesData collectionFinal reportCessna 172RG · Litchfield, ILThe pilot's intentional low altitude flight and his failure to maintain clearance from the static wire. Contributing to the accident were the static wire, the partial loss of engine power due to propeller vibration, and the muddy field in which the forced…