NTSB investigations: Lycoming 0-320 series, 2005, FL
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 | 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\") = 2005
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") = 2005
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 MIA06CA032Accident · No injuriesData collectionFinal reportCessna 172P · Hialeah, FLThe failure of the CFI to perform a go-around following a long landing resulting in overrun, on ground encounter with soft terrain, and subsequent nose over.NTSB MIA06CA011Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with runway signs.NTSB MIA06FA007Accident · 1 fatalField investigationFinal reportCessna 172P · La Belle, FLThe student pilot's failure to maintain airspeed during the initial takeoff climb, resulting in an inadvertent stall/spin and uncontrolled descent to ground impact. A contributing factor was the failure of the wing flap control, which resulted in the flaps…NTSB MIA06CA009Accident · No injuriesData collectionFinal reportCessna 172N · Punta Gorda, FLThe in-flight collision with a bird resulting in substantial damage to the airplane.NTSB MIA05LA157Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Ponte Vedra, FLA loss of engine power for undetermined reasons, which resulted in the airplane being ditched in a marsh.NTSB MIA05LA148Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lantana, FLThe CFI's delayed remedial action to recover from a practice autorotation with planned power recovery resulting in a hard landing.NTSB ATL05CA112Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dunnellon, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB MIA05CA100Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Fort Pierce, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. A contributing factor in the accident was the pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply was available for the intended flight.NTSB MIA05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe pilot's poorly planned approach during a precautionary landing following partial loss of engine power resulting in a go-around and subsequent in-flight collision with trees. A contributing factor in the accident was the inadequate maintenance by the…NTSB ANC05FA037Accident · 1 fatalField investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed during an abrupt maneuver to avoid a power line, which resulted in an inadvertent stall, a loss of control, and subsequent collision…NTSB MIA05CA064Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ocala, FLThe pilot-rated passengers improper use of the rudder control and his failure to maintain directional control resulting in a loss of control on the ground.NTSB MIA05LA046Accident · 1 fatalLimited investigationFinal reportCessna 172M · Orlando, FLThe failure of the CFI to initiate a precautionary landing after noticing zero oil pressure with corresponding oil temperature increase, resulting in total loss of engine power due to oil exhaustion. A contributing factor in the accident was the failure of…NTSB MIA05FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Leesburg, FLThe pilot's decision to continue VMC flight into IMC conditions.