NTSB investigations: Lycoming 0-320 series, 1985, IL
4 cases on aircraft whose registry engine model is Lycoming 0-320 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
| 1964 | 11 |
|---|---|
| 1965 | 16 |
| 1966 | 21 |
| 1967 | 23 |
| 1968 | 15 |
| 1969 | 17 |
| 1970 | 16 |
| 1971 | 21 |
| 1972 | 16 |
| 1973 | 15 |
| 1974 | 15 |
| 1975 | 20 |
| 1976 | 14 |
| 1977 | 15 |
| 1978 | 22 |
| 1979 | 13 |
| 1980 | 12 |
| 1981 | 15 |
| 1982 | 8 |
| 1983 | 8 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 7 |
| 1994 | 4 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 8 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 4 |
| 2009 | 1 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 5 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 6 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 1985
AND 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'))
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 year(c."eventDate") = 1985
AND 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'))
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 CHI85FEE01Accident · Minor injuriesFinal reportPiper PA-28-161 · Schaumburg, ILThe student plt & instructor (CFI) were practicing touch-&-go landings. The CFI reported that after about 1 hr of flt, the eng lost power after a touch-&-go as the acft was climbing thru about 200 to 300 ft AGL. A town & some bldgs were ahead, so the CFI made…NTSB CHI85LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILThe plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose…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…NTSB CHI85LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt Sterling, ILThe plt landed long at his home arpt using no flaps with a prevailing tailwind. The 2600 ft turf strip was frozen. During braking the acft skidded off the rwy and struck a snow berm before rolling inverted.