Fatal NTSB investigations, IL
5 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1985 | 1 |
|---|---|
| 1987 | 2 |
| 1996 | 1 |
| 2004 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 CHI05LA014Accident · 1 fatalLimited investigationFinal reportCessna P206B · Taylorville, ILAircraft control not possible by the pilot following a premature deployment of a parachute as a parachutist exited the jump airplane during cruise flight. The inverted spin encountered by the pilot was an additional cause.NTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…NTSB CHI88DEV01Accident · 1 fatalFinal reportCessna 150L · Marion, ILPilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light.NTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…NTSB CHI85IA145Incident · 1 fatalIncident investigationFinal reportCessna T210L · Peoria, ILWhile in cruise flight the commercial rated pilot suffered a fatal heart attack. The non-rated passenger landed the aircraft safely.