NTSB investigations: Lycoming 0-320 series, 1998, FL
12 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
Open the mapLatest 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\") = 1998
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") = 1998
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 MIA99LA061Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Lauderdale, FLThe intentional operation of the airplane by the pilot with known deficiencies in equipment (fuel leakage from the carburetor), poor preflight by the pilot for his failure to visually determine that the fuel tanks were full before the initial flight. Factors…NTSB MIA99LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Immokalee, FLThe certified flight instructor's inadequate supervision and his inadequate management of the fuel, which resulted in fuel exhaustion.NTSB MIA99LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Okeechobee, FLThe inadequate visual lookout of the pilot of the Cessna airplane and of the pilot of the glider resulting in the midair collision.NTSB MIA99LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Venice, FLThe pilot's improper flare and improper recovery from a bounced landing.NTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…NTSB ATL98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Homestead, FLThe pilot's improper flare that resulted in a hard landing and porpoise, and his improper recovery from the bounced landing.NTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…NTSB MIA98LA164Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Myers, FLThe pilot's inadequate inflight decision and her selection of unsuitable terrain to conduct a precautionary landing.NTSB ATL98LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Key West, FLfailure of the student pilot to maintain directional control of the airplane during the landing roll. The student pilot's lack of experience in the make and model of airplane was a related factor.NTSB ATL98TA054Accident · No injuriesFinal reportCessna 172 · Arcadia, FLThe pilot's inadequate pre-flight and in-flight planning, which resulted in fuel exhaustion and the loss of power. Trees and rough/uneven terrain are contributing factors.NTSB MIA98LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Destin, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB MIA98LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Titusville, FLloss of engine power for undetermined reason(s), which resulted in a forced landing. Factors relating to the accident were: the lack of suitable terrain and obstructions in the emergency landing area.