Fatal NTSB investigations: Lycoming 0-235 series, IL
5 cases on aircraft whose registry engine model is Lycoming 0-235 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1981 | 1 |
|---|---|
| 1986 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1999 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…NTSB CHI93DEV01Accident · 1 fatalFinal reportWalter D. Courtney Courtney TWO · Canton, ILthe pilot's failure to maintain control of the airplane during final approach to landing.NTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.NTSB CHI86FA183Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Plainfield, ILWitnesses who spoke with plt of N6135L prior to accident stated that he was acting out of character. He had a loss of appetite and his complexion was ashen grey. The plt stated that he did not feel well before the flt. Witnesses observed the acft takeoff,…NTSB CHI81FA082Accident · 2 fatalClosedBellanca 7ECA · Delevan, IL