Fatal NTSB investigations: Lycoming 0-320 series, 2011
14 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 | 5 |
| 1966 | 17 |
| 1967 | 14 |
| 1968 | 16 |
| 1969 | 17 |
| 1970 | 16 |
| 1971 | 13 |
| 1972 | 10 |
| 1973 | 15 |
| 1974 | 21 |
| 1975 | 17 |
| 1976 | 17 |
| 1977 | 25 |
| 1978 | 43 |
| 1979 | 42 |
| 1980 | 36 |
| 1981 | 39 |
| 1982 | 50 |
| 1983 | 29 |
| 1984 | 26 |
| 1985 | 24 |
| 1986 | 35 |
| 1987 | 22 |
| 1988 | 38 |
| 1989 | 21 |
| 1990 | 18 |
| 1991 | 22 |
| 1992 | 21 |
| 1993 | 28 |
| 1994 | 18 |
| 1995 | 27 |
| 1996 | 17 |
| 1997 | 17 |
| 1998 | 17 |
| 1999 | 20 |
| 2000 | 15 |
| 2001 | 26 |
| 2002 | 45 |
| 2003 | 26 |
| 2004 | 32 |
| 2005 | 33 |
| 2006 | 24 |
| 2007 | 28 |
| 2008 | 27 |
| 2009 | 24 |
| 2010 | 23 |
| 2011 | 14 |
| 2012 | 23 |
| 2013 | 18 |
| 2014 | 17 |
| 2015 | 23 |
| 2016 | 19 |
| 2017 | 18 |
| 2018 | 13 |
| 2019 | 17 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 12 |
| 2023 | 22 |
| 2024 | 12 |
| 2025 | 8 |
| 2026 | 16 |
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\") = 2011
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2011
AND c."highestInjuryLevel" = 'Fatal'
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 CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.NTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.NTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11FA493Accident · 1 fatalField investigationFinal reportCessna 172M · Greenville, METhe pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB WPR11FA450Accident · 1 fatalField investigationFinal reportCone James A RV-6A · West Jordan, UTThe pilot’s execution of an abrupt maneuver, likely to avoid birds, which resulted in a stall and spin.NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.NTSB ERA11FA467Accident · 2 fatalField investigationFinal reportCessna 172M · Titusville, PAThe flight instructor's improper decision to attempt a visual descent into instrument meteorological conditions while approaching the destination airport, which resulted in an in-flight collision with trees and terrain.NTSB WPR11FA390Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Forsyth, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.NTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.NTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA11FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140The non-instrumented rated pilot’s flight into instrument meteorological conditions for undetermined reasons, resulting in an in-flight loss of control, uncontrolled descent, and collision with the water.NTSB ERA11FA369Accident · 2 fatalField investigationFinal reportCessna 172M · Poughkeepsie, NYThe pilot’s loss of airplane control due to impairment or incapacitation as a result of coronary artery disease in combination with atrial fibrillation. Contributing to the accident was the pilot's failure to report his paroxysmal atrial fibrillation to the…NTSB CEN11FA422Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Del Valle, TXThe divergence of the main rotor from its normal plane of rotation for reasons that cannot be determined because the pilot’s control inputs leading up to the event are unknown, resulting in mast bumping and main rotor blade separation.NTSB ERA11FA299Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Benezette, PAThe pilot's loss of airplane control for reasons that could not be determined from the available evidence.