NTSB investigations: Lycoming 0-320 series, 1986, VA
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 | 5 |
|---|---|
| 1965 | 7 |
| 1966 | 7 |
| 1967 | 6 |
| 1968 | 10 |
| 1969 | 9 |
| 1970 | 5 |
| 1971 | 5 |
| 1972 | 6 |
| 1973 | 10 |
| 1974 | 4 |
| 1975 | 3 |
| 1976 | 8 |
| 1977 | 8 |
| 1978 | 4 |
| 1979 | 4 |
| 1980 | 6 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 3 |
| 2007 | 8 |
| 2008 | 1 |
| 2009 | 6 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 3 |
| 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\" = 'VA' 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" = 'VA' 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 BFO87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hillsville, VAAfter touchdown on the rwy, the plt held the nose wheel off for about 200 feet of travel by holding the control wheel back. According to him, the acft then veered to the left and he was unable to steer it with the rudder pedals. The acft went off the side of…NTSB BFO86FID07Accident · No injuriesFinal reportCessna 172M · Lynchburg, VAThe accident occurred as the plt was attempting to land at an unfamiliar arpt during a x-country flt because a passenger was feeling ill. The rwy was 2900 ft long with a 5% upslope at mid-field. The plt stated he misjudged his alt and airspeed during the…NTSB BFO86FA021Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake, VABefore the flt, the plt was observed drinking in a bar. He & 3 others then drove to the arpt, where rprtdly, the wx was bad & the visibility was restricted by fog. After awhile, the plt stated he was going to taxi the acft around the arpt & invited the others…NTSB BFO86FID01Accident · Minor injuriesFinal reportCessna 172L · Gordonsville, VAOn February 23, 1986, at 1621 EST, a Cessna 172L, N7191Q collided with a tree during an attempted go-around at Gordonsville airport, Gordonsville, VA., while on a pleasure flight. Visual meteorological conditions prevailed at the time and no flight plan was…NTSB BFO86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAThe student pilot stated that uneven braking during landing caused the aircraft to swerve off the side of the runway. He further added that he applied full power shortly thereafter due to the fact that the aircraft was heading for a ditch. The aircraft…