NTSB investigations: Lycoming 0-320 series, 2004, FL
19 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\") = 2004
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") = 2004
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 MIA05LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, FLThe improper flare by the pilot in command resulting in a hard landing, Restricted movement of the throttle was a contributing factor.NTSB MIA05CA022Accident · No injuriesData collectionFinal reportChampion 7GCBC · Pierson, FLThe inadequate visual lookout by the pilot-in-command resulting in the airplane encountering uneven terrain, propeller contact to the ground, and subsequent nose over.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB MIA04LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · West Palm Beach, FLThe partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.NTSB MIA04FA115Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Miami, FLThe failure of company maintenance personnel to secure the push/pull tube to the left lug of the non-rotating portion of the swashplate assembly following maintenance, and the inability of the pilot to control the helicopter resulting in the in-flight…NTSB MIA04LA113Accident · Minor injuriesLimited investigationFinal reportRobinson R 22 Mariner · Lantana, FLThe failure of the pilot-in-command to maintain recommended main rotor RPM following a reported total loss of engine power due to undetermined reasons, during a practice autorotation resulting in a hard landing and subsequent roll over.NTSB MIA04CA118Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Sugar Loaf Key, FLThe failure of the pilot to attain the proper touchdown point resulting in a landing overrun and subsequent on-ground collision with trees.NTSB MIA04CA104Accident · Minor injuriesData collectionFinal reportWilliam K. Crawford Tango 2 · Williston, FLThe failure of the pilot to maintain directional control of the airplane during a high speed taxi test resulting in the airplane veering off the left side of the runway, becoming airborne, and nosing over.NTSB MIA04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lake Wales, FLThe pilot's delay in aborting the takeoff resulting in an overrun of the runway and subsequent impact with water. A finding in the accident was the pilot's failure to extend the flaps to the second notch (25 degrees).NTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.NTSB ATL04CA113Accident · No injuriesData collectionFinal reportCessna 172N · Odessa, FLThe pilot's improper landing flare that resulted in a hard landing.NTSB MIA04LA075Accident · Serious injuriesLimited investigationFinal reportRichard A. Denisar RV-4 · Spring Hill, FLThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power during takeoff/initial climb due to fuel contamination, that resulted in a forced landingNTSB MIA04FA064Accident · 2 fatalField investigationFinal reportPiper PA-30 · Fernandina Bch, FLThe failure of the pilot to feather the left propeller and his failure to maintain control of the airplane following a loss of engine power from the left engine resulting in the in-flight collision with terrain. A factor in the accident was the loss of power…NTSB MIA04CA059Accident · No injuriesData collectionFinal reportRobinson R22 · Keystone, FLThe inadequate supervision by the flight instructor by allowing the student to lose excessive altitude resulting in a skid impacting the ground and subsequent roll over of the helicopter.NTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.NTSB ANC04LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Naples, FLThe pilot's inadequate compensation for a crosswind condition during landing, which resulted in a loss of control and an on-ground encounter with terrain. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB ANC04LA022Accident · 1 fatalLimited investigationFinal reportBertrand/Warner Thorp T-18 · Crescent City, FLThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. Factors associated with the accident were fog and low ceilings.NTSB MIA04CA053Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Sebring, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane ground looping and incurring damage.NTSB MIA04FA047Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Lake Worth, FLThe pilot's inadequate control of the aircraft by his use of an excessive bank angle, and his failure to maintain airspeed which resulted in a stall and a loss of control following a loss of power in one engine. The reason for the loss of the engine power was…