Fatal NTSB investigations: Lycoming O&VO-360 series, 1997
11 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 8 |
| 1967 | 5 |
| 1968 | 9 |
| 1969 | 5 |
| 1970 | 6 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 5 |
| 1975 | 7 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 26 |
| 1979 | 19 |
| 1980 | 20 |
| 1981 | 20 |
| 1982 | 15 |
| 1983 | 9 |
| 1984 | 14 |
| 1985 | 8 |
| 1986 | 8 |
| 1987 | 17 |
| 1988 | 9 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 9 |
| 1994 | 11 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 17 |
| 2002 | 21 |
| 2003 | 25 |
| 2004 | 18 |
| 2005 | 14 |
| 2006 | 11 |
| 2007 | 6 |
| 2008 | 9 |
| 2009 | 11 |
| 2010 | 9 |
| 2011 | 8 |
| 2012 | 13 |
| 2013 | 6 |
| 2014 | 11 |
| 2015 | 2 |
| 2016 | 7 |
| 2017 | 13 |
| 2018 | 9 |
| 2019 | 16 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 7 |
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
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 MIA98FA039Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Lansing, NCthe pilot's failure to maintain clearance from a wire.NTSB MIA98LA033Accident · 1 fatalLimited investigationFinal reportMooney M20C · Sparta, TNThe pilot's inadequate preflight and inflight decision and his inadvertent VFR flight into instrument meteorological conditions. Contributing factors are self induced pressure, mountainous terrain, and low clouds.NTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.NTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.NTSB LAX97FA328Accident · 4 fatalField investigationFinal reportBeech C23 · Torrance, CAThe failure of the pilot to attain and maintain adequate airspeed during the initial takeoff climb, which resulted in a stall/spin and subsequent collision with a building.NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.NTSB FTW97FA295Accident · 2 fatalField investigationFinal reportLancair 320 · Dillon, COthe pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…NTSB FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.NTSB CHI97FA196Accident · 2 fatalField investigationFinal reportMooney M20A · White Bear, MNpilot incapacitation due to a stroke.NTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…NTSB FTW97WA133Accident · 3 fatalForeign investigationPiper PA-28-181 · Tejupilco, Mexico