NTSB investigations: Lycoming 0-320 series, 1984, IL
3 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
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 year(c.\"eventDate\") = 1984
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") = 1984
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 CHI85FA054Accident · No injuriesField investigationFinal reportCessna 172P · Waukegan, ILThe acft collided with the terrain during a forced landing following a loss of power during takeoff. Investigation revealed that two days previously a loss of power had occured during a test flt which was virtually identical to the power loss experienced…NTSB CHI84LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Kilbourne, ILThe student pilot stated that the nose wheel cocked in sand while taxing and the acft nosed over.NTSB CHI84LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, ILThe 2432 ft rwy had a 224 ft displaced threshold due to trees near the apch end. The plt stated that when he landed, the acft touched down 'somewhat down the rwy past the treshold' with 25 deg of flaps. He stated that braking had little effect because the…