Fatal NTSB investigations: Lycoming 0-320 series, 1990
18 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 | 11 |
|---|---|
| 1965 | 5 |
| 1966 | 17 |
| 1967 | 14 |
| 1968 | 16 |
| 1969 | 17 |
| 1970 | 16 |
| 1971 | 13 |
| 1972 | 10 |
| 1973 | 15 |
| 1974 | 21 |
| 1975 | 17 |
| 1976 | 17 |
| 1977 | 25 |
| 1978 | 43 |
| 1979 | 42 |
| 1980 | 36 |
| 1981 | 39 |
| 1982 | 50 |
| 1983 | 29 |
| 1984 | 26 |
| 1985 | 24 |
| 1986 | 35 |
| 1987 | 22 |
| 1988 | 38 |
| 1989 | 21 |
| 1990 | 18 |
| 1991 | 22 |
| 1992 | 21 |
| 1993 | 28 |
| 1994 | 18 |
| 1995 | 27 |
| 1996 | 17 |
| 1997 | 17 |
| 1998 | 17 |
| 1999 | 20 |
| 2000 | 15 |
| 2001 | 26 |
| 2002 | 45 |
| 2003 | 26 |
| 2004 | 32 |
| 2005 | 33 |
| 2006 | 24 |
| 2007 | 28 |
| 2008 | 27 |
| 2009 | 24 |
| 2010 | 23 |
| 2011 | 14 |
| 2012 | 23 |
| 2013 | 18 |
| 2014 | 17 |
| 2015 | 23 |
| 2016 | 19 |
| 2017 | 18 |
| 2018 | 13 |
| 2019 | 17 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 12 |
| 2023 | 22 |
| 2024 | 12 |
| 2025 | 8 |
| 2026 | 16 |
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\") = 1990
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 ('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") = 1990
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 ('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 LAX91FA037Accident · 1 fatalField investigationFinal reportRobinson R22Beta · Simi Valley, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the tailboom and cockpit.NTSB MIA91FA029Accident · 1 fatalField investigationFinal reportCessna 172M · Homestead, FLThe failure of the pilot to insure adequate fuel was present in the aircraft for the flight resulting in loss of engine power due to fuel exhaustion.NTSB LAX91FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Goleta, CAThe pilot's failure to maintain proper glidepath while on final approach. A contributing factor was sunglare.NTSB CHI91FA011Accident · 3 fatalField investigationFinal reportCessna 172P · Fort Wayne, INThe failure of the pilot to maintain an airspeed above stalling speed. Factors associated with the accident are premature rotation and the pilot's lack of recent total experience.NTSB LAX91DUM01Accident · 1 fatalFinal reportPiper PA28-140 · El Cajon, CAThe pilot's failure to maintain flying speed. Contributing to the accident was an engine power loss for undetermined reasons.NTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.NTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.NTSB LAX90FA292Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Long Beach, CAThe inadequate visual outlook of the pilots of the Cessna 172P and their failure to see and avoid the Piper pa- 28RT-201. Contributing to the accident was the azimuth and angle of the sun which was in a position at the time of the accident to impair the scan…NTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.NTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasNTSB CHI90FA145Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Wadsworth, OHThe failure of the certified flight instructor and the dual student to maintain a visual lookout during the final approach to the airport.NTSB ANC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Wasilla, AKPilot's failure to maintain control of the airplane. Contributing to the accident was the pilot's lack of total experience.NTSB BFO90FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Ona, WVThe improperly set stabilator trim and the improperly loaded aircraft.NTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.NTSB LAX90FA135Accident · 1 fatalField investigationFinal reportGardner Pitts S-1 · Eloy, AZThe pilot delayed the recovery from the inverted flat spin maneuver and misjudged his altitude.NTSB MIA90FA085Accident · 3 fatalField investigationFinal reportCessna 152 · Miramar, FLThe failure of the local controller to provide adequate traffic advisories to N7510H, the local controller's improper clearance to N7510H to descend through the traffic pattern, and the failure of the pilots of both aircraft to see and avoid each other.…NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.