NTSB investigations: Lycoming 0-320 series, 2016, TX
8 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 | 28 |
|---|---|
| 1965 | 25 |
| 1966 | 30 |
| 1967 | 27 |
| 1968 | 34 |
| 1969 | 33 |
| 1970 | 30 |
| 1971 | 16 |
| 1972 | 24 |
| 1973 | 14 |
| 1974 | 20 |
| 1975 | 18 |
| 1976 | 26 |
| 1977 | 23 |
| 1978 | 23 |
| 1979 | 24 |
| 1980 | 19 |
| 1981 | 22 |
| 1982 | 25 |
| 1983 | 14 |
| 1984 | 11 |
| 1985 | 11 |
| 1986 | 13 |
| 1987 | 6 |
| 1988 | 7 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 10 |
| 1992 | 11 |
| 1993 | 16 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 13 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 13 |
| 2000 | 11 |
| 2001 | 9 |
| 2002 | 17 |
| 2003 | 20 |
| 2004 | 14 |
| 2005 | 10 |
| 2006 | 14 |
| 2007 | 7 |
| 2008 | 13 |
| 2009 | 10 |
| 2010 | 11 |
| 2011 | 12 |
| 2012 | 7 |
| 2013 | 7 |
| 2014 | 10 |
| 2015 | 11 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 13 |
| 2021 | 9 |
| 2022 | 11 |
| 2023 | 10 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 11 |
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\") = 2016
AND c.\"eventStateOrRegion\" = 'TX' 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") = 2016
AND c."eventStateOrRegion" = 'TX' 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 CEN17FA026Accident · 1 fatalField investigationFinal reportRoe Cleo Wittman Tailwind W10 · Pearland, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…NTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.NTSB CEN17LA003Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Taylor, TXA total loss of engine power due to fuel starvation as a result of debris obstructing the fuel strainer screen and corrosion of the fuel strainer bowl.NTSB GAA16CA359Accident · No injuriesData collectionFinal reportPiper PA28 · Amarillo, TXThe pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.NTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…NTSB CEN16FA145Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Midlothian, TXThe flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB GAA16CA530Accident · No injuriesData collectionFinal reportRobinson R22 · Taylor, TXThe flight instructor's improper collective input during a simulated engine failure autorotation with a power recovery, which resulted in a hard, bounced landing and the main rotor blade striking the tailboom.