NTSB investigations: Lycoming 0-320 series, 1985, PA
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 | 9 |
|---|---|
| 1965 | 14 |
| 1966 | 12 |
| 1967 | 17 |
| 1968 | 9 |
| 1969 | 14 |
| 1970 | 13 |
| 1971 | 14 |
| 1972 | 7 |
| 1973 | 9 |
| 1974 | 11 |
| 1975 | 12 |
| 1976 | 14 |
| 1977 | 11 |
| 1978 | 15 |
| 1979 | 8 |
| 1980 | 8 |
| 1981 | 6 |
| 1982 | 9 |
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 10 |
| 1988 | 6 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 8 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 1 |
| 1997 | 5 |
| 1998 | 5 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 4 |
| 2004 | 7 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 4 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2022 | 4 |
| 2024 | 1 |
| 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\" = 'PA' 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" = 'PA' 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 NYC86FA048Accident · 2 fatalField investigationFinal reportPiper PA-28 · Selinsgrove, PAThe afct was seen flying at low alt before it collided with unmarked transmission lines at a height of 170 ft AGL. The acft pitched up and then descended to the ground. The top of the rudder and vertical stabilator were severed from the acft. The collision…NTSB NYC86LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bloomsburg, PAThe acft was on an IFR flt en route to allegheny county arpt at 6000 ft when an electrical failure occurred. The plt executed a precautionary landing in a muddy fld. The nose wheel caught in mud and the acft nosed over. Examination of the electrical system…NTSB NYC85LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Doylestown, PAAccording to the plt, on touchdown the acft braking was ineffective due to morning dew on the grass rwy. The acft slid off the end of the rwy and collided with bushes.NTSB NYC85FGM05Accident · 2 fatalFinal reportJames Postlewait RV-4 · Zelienople, PAA witness reported that when the acft was departing, the takeoff run & beginning of the climb appeared to be normal. However, at about 300 to 400 ft AGL, the left wing dropped & the acft pivoted to the left, then the plane crashed in a steep nose down…