NTSB investigations: Lycoming 0-320 series, 1986, IL
7 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\") = 1986
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") = 1986
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 CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…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 CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…NTSB CHI86LA116Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Seneca, ILThe plt was landing on a 2300 ft rwy with a 80 degree x-wind. The acft bounced hard on touchdown and the plt attempted a go-around with 25 degrees of flaps extended. The airspeed was deteriorating so the plt elected to re-land. During the roll-out the acft…NTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.NTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…NTSB CHI86FA100Accident · 2 fatalField investigationFinal reportCessna 172M · Lafox, ILAn instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was…