NTSB investigations: Lycoming 0-320 series, IL
8 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with terrain/water”. 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 2 |
| 2001 | 1 |
| 2004 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB CHI95FA012Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Winfield, ILCollision with the ground for an undetermined reason. The pilot's psychological condition was a probable factor.NTSB CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.NTSB CHI90DEV02Accident · Serious injuriesFinal reportPiper PA-25-150 · Sullivan, ILThe pilot-in-command's failure to maintain adequate terrain clearance during a turn at low altitude, resulting in ground collision. Contributing to the severity of the pilot's injury was his failure to use the installed shoulder harness.NTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…NTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…NTSB CHI85LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Champaign, ILDuring a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…