NTSB investigations: Lycoming 0-320 series, 2023, FL
9 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 | 7 |
|---|---|
| 1965 | 8 |
| 1966 | 17 |
| 1967 | 16 |
| 1968 | 16 |
| 1969 | 11 |
| 1970 | 15 |
| 1971 | 18 |
| 1972 | 13 |
| 1973 | 9 |
| 1974 | 15 |
| 1975 | 16 |
| 1976 | 11 |
| 1977 | 18 |
| 1978 | 16 |
| 1979 | 19 |
| 1980 | 21 |
| 1981 | 20 |
| 1982 | 17 |
| 1983 | 10 |
| 1984 | 15 |
| 1985 | 15 |
| 1986 | 15 |
| 1987 | 11 |
| 1988 | 11 |
| 1989 | 11 |
| 1990 | 10 |
| 1991 | 11 |
| 1992 | 16 |
| 1993 | 10 |
| 1994 | 13 |
| 1995 | 10 |
| 1996 | 11 |
| 1997 | 14 |
| 1998 | 12 |
| 1999 | 13 |
| 2000 | 18 |
| 2001 | 15 |
| 2002 | 12 |
| 2003 | 15 |
| 2004 | 19 |
| 2005 | 14 |
| 2006 | 13 |
| 2007 | 6 |
| 2008 | 16 |
| 2009 | 14 |
| 2010 | 6 |
| 2011 | 13 |
| 2012 | 9 |
| 2013 | 10 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 13 |
| 2017 | 9 |
| 2018 | 19 |
| 2019 | 16 |
| 2020 | 10 |
| 2021 | 13 |
| 2022 | 11 |
| 2023 | 9 |
| 2024 | 10 |
| 2025 | 10 |
| 2026 | 11 |
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\") = 2023
AND c.\"eventStateOrRegion\" = 'FL' 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") = 2023
AND c."eventStateOrRegion" = 'FL' 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 ERA24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Miami, FLThe business jet flight crew’s failure to appropriately position their airplane to mitigate the impact of their extended duration, high-power engine run, and their failure to adequately communicate these factors to air traffic control, which resulted in the…NTSB ERA24LA059Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Zephyrhills, FLAn aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.NTSB ERA24LA030Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Pembroke Pines, FLThe pilot’s loss of airplane control and descent into terrain due to spatial disorientation during a solo night cross country flight. Contributing to the accident was the pilot’s self-reported fatigue.NTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.NTSB ERA23FA340Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Fort Pierce, FLThe left seat instructor’s intentional maneuvering of the airplane in an aerobatic steep turn for which it was not approved, which resulted in an exceedance of the structural limitations of the airplane and an inflight breakup.NTSB ERA23FA323Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Pembroke Pines, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent rapid descent into terrain.NTSB ERA23LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Miami, FLA total loss of engine power due to a lack of oil lubrication.NTSB ERA23FA142Accident · 4 fatalClass 3 · FieldFinal reportPiper J3C · Winter Haven, FLThe failure of both flight crews to see and avoid each other while operating in the airport environment.NTSB ERA23LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Opa-locka, FLThe flight instructor’s decision to taxi behind a large multi-engine airplane, which resulted in an encounter with propeller blast and a loss of airplane control on the ground.