NTSB investigations: Lycoming 0-320 series, 1985, MI
5 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 | 8 |
|---|---|
| 1965 | 11 |
| 1966 | 11 |
| 1967 | 15 |
| 1968 | 15 |
| 1969 | 14 |
| 1970 | 10 |
| 1971 | 9 |
| 1972 | 13 |
| 1973 | 8 |
| 1974 | 12 |
| 1975 | 7 |
| 1976 | 15 |
| 1977 | 10 |
| 1978 | 8 |
| 1979 | 9 |
| 1980 | 8 |
| 1981 | 8 |
| 1982 | 10 |
| 1983 | 16 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 8 |
| 1987 | 5 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 4 |
| 1991 | 9 |
| 1992 | 7 |
| 1993 | 7 |
| 1994 | 6 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 6 |
| 2007 | 6 |
| 2008 | 1 |
| 2010 | 5 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 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\" = 'MI' 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" = 'MI' 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 CHI85LA371Accident · No injuriesLimited investigationFinal reportCessna 172P · Ann Arbor, MIThe right main tire blew and the left main landing gear was damaged during a hard landing. Aprx 1 foot of the lower half of the firewall was wrinkled.NTSB CHI85LA375Accident · No injuriesLimited investigationFinal reportCessna 172P II · Detroit, MIThe pilot was on a VFR VASI approach to the ATC controlled arpt 5091 ft runway. During ld round out the pilot said it feld like the acft was 'pushed' down onthe runway. The acft bounced and then ld on the nose wheel. The pilot said a helicopter was in a hover…NTSB CHI85LA206Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · New Hudson, MIThe pilot inadvertently attempted to take off with at least 21 deg. Of flaps. The acft climbed to approximately 30-50 8T. AGL and passed over a hangar on the left side of the runway. Once past the hangar the acft began a rapid descent. Post impact fire…NTSB CHI85LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pontiac, MIThe acft nosed over after a loss of control during landing roll portion of a touch & go lndg. The low flt time student plt was practicing endings solo when control was lost and the acft left the rwy. The plt reported that he was resetting the carb heat &…NTSB CHI85LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Troy, MIThe acft collided with a sign during a forced lndg after a loss of power that occurd during initial climb at an alt of 400 ft AGL. The plt stated that the eng began to run rough and with the application of carb heat the eng quit. A post accident eng run-up…