NTSB investigations: Lycoming 0-320 series, 1997, 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\") = 1997
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") = 1997
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 MIA98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Clarksville, FLthe pilot's improper flare and touchdown.NTSB MIA98LA012Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Pompano Beach, FLThe improper use of collective control by the dual student which prevented the flight instructor from stopping an uncontrolled roll to the left.NTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).NTSB ATL97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during the landing, which resulted in a collision with a runway marker. The rear-quartering tailwind (crosswind) and gusts were related factors.NTSB MIA97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sanford, FLFailure of the oil cooler radiator hose which resulted in oil exhaustion and subsequent engine failure. Contributing to the accident was the failure of the FAA to require a recurrent detailed examination and or require those hoses be life limited to prevent…NTSB MIA97LA183Accident · No injuriesLimited investigationFinal reportBeech B19 · New Smyrna Bch, FLthe private pilot's improper flare, which resulted in a hard landing and subsequent collapse of the left main landing gear and the nose gear.NTSB ATL97LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLfailure of the pilot of N7617F to comply with an ATC instruction to hold short of a taxiway, and failure of the pilots in both airplanes to see-and-avoid each other's airplane.NTSB MIA97LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Vero Beach, FLfailure of the pilot to ensure all articles in the aircraft were secured before flight, and subsequently, an oil can becoming lodged under the rudder pedals and preventing her from controlling the aircraft during landing.NTSB MIA97LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Key Largo, FLthe pilot's failure to maintain directional control during a crosswind landing, which resulted in an inadvertent ground swerve and collision with bushes and terrain.NTSB MIA97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLthe pilot's improper compensation for wind conditions and failure to properly flare the airplane for landing. Factors relating to the accident were: the gusty/quartering wind conditions, and the pilot's improper use of flaps for landing.NTSB MIA97LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Pompano Beach, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear.NTSB MIA97LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLthe pilot's excessive taxispeed.NTSB ATL97LA038Accident · No injuriesLimited investigationFinal reportBeech 23 · Palatka, FLfailure of the nose gear for undetermined reason(s).NTSB MIA97LA071Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Daytona Beach, FLthe student pilot's failure to maintain direction control of the airplane during takeoff. The crosswind was a factor.