Fatal NTSB investigations: Lycoming 0-320 series
229 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 13 |
|---|---|
| 1983 | 13 |
| 1984 | 8 |
| 1985 | 10 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 14 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 6 |
| 1992 | 13 |
| 1993 | 8 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 8 |
| 2000 | 8 |
| 2001 | 10 |
| 2002 | 16 |
| 2003 | 11 |
| 2004 | 6 |
| 2005 | 15 |
| 2006 | 5 |
| 2007 | 12 |
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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 DFW08FA040Accident · 2 fatalField investigationFinal reportCessna 172N · Marlow, OKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin and impact with terrain. Contributing to the accident were the low altitude for recovery and the gusty tailwind.NTSB SEA08FA036Accident · 2 fatalField investigationFinal reportCessna 177 · Auburn, CAThe pilot failed to maintain an adequate airspeed while maneuvering in the traffic pattern for landing, which resulted in a stall/spin. Contributing to the accident was the pilot's impairment during the flight from the effects of over-the-counter medications.NTSB CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.NTSB CHI07LA288Accident · 1 fatalLimited investigationFinal reportCessna 172M · Union Star, MOThe student pilot's failure to maintain adequate airspeed and the subsequent inadvertent stall while buzzing residences. Contributing to the accident was the pilot performing buzzing maneuvers.NTSB NYC07FA193Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NYThe pilot's failuire to maitain adequate airspeed during a turning maneuver which resulted in an inadvertent stall.NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB NYC07LA148Accident · 2 fatalLimited investigationFinal reportSyracuse Vans RV-4 · Wallkill, NYThe pilot's improper decision to attempt low altitude aerobatics, and his failure to maintain airspeed during the aerobatics, which resulted in an inadvertent stall while maneuvering.NTSB LAX07FA123Accident · 2 fatalField investigationFinal reportCessna 172N · Page, AZThe pilot's failure to maintain an adequate terrain clearance altitude, and, his failure to maintain an adequate airspeed while maneuvering to reverse course in a box canyon. Contributing to the accident were the rising terrain and the box canyon.NTSB CHI07LA098Accident · 2 fatalLimited investigationFinal reportWakewood Lancair O-200 · Scottsbluff, NEThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident were the low altitude at which the airplane was operating and the gusty wind conditions.NTSB NYC07FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Howell, NJThe pilot's improper decision to attempt a flight with known serious medical conditions, which resulted in impairment during cruise flight, likely due to a stroke or transient ischemic attack. A factor was the pilot providing false information on his medical…NTSB DFW07LA160Accident · 1 fatalLimited investigationFinal reportIngraham RV-6 · Carlsbad, NMThe pilot's loss of control for undetermined reasons.NTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.NTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.NTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.NTSB NYC06FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Leesburg, VAThe flight instructor's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with trees and terrain.NTSB MIA06FA007Accident · 1 fatalField investigationFinal reportCessna 172P · La Belle, FLThe student pilot's failure to maintain airspeed during the initial takeoff climb, resulting in an inadvertent stall/spin and uncontrolled descent to ground impact. A contributing factor was the failure of the wing flap control, which resulted in the flaps…NTSB SEA06FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe pilot's inadequate airspeed during his aborted landing takeoff/climb which lead to a series of stall/mushes and subsequent impact with trees. Contributing factors were the pilot's loss of aircraft control during his initial landing approach and his…NTSB ANC05FA144Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Nenana, AKThe pilot's failure to maintain minimum airspeed to avoid a stall while maneuvering, which resulted in a loss of control, a stall/spin, and impact with terrain. Factors associated with the accident were an aerobatic maneuver, and a stall/spin.NTSB LAX05LA324Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Mountain City, NVThe pilot's failure to maintain airspeed while maneuvering in mountainous terrain, which led to a stall and impact with trees and terrain.NTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.NTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…NTSB LAX05LA204Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Woodfords, CAthe pilot's failure to maintain an adequate airspeed while turning in strong wind conditions, which resulted in a stall/spin. A factor in the accident was the high density altitude.NTSB ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…NTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.NTSB ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.NTSB LAX05FA061Accident · 2 fatalField investigationFinal reportVail Lancair 235 · Sacaton, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall/spin.NTSB LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB CHI04FA197Accident · 1 fatalField investigationFinal reportRobinson R22 Alpha · Mount Clemens, MIA loss of control in flight for undetermined reasons.NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.NTSB MIA04FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Olive Branch, MSThe student pilot's failure to maintain airspeed (Vso), which resulted in an inadvertent stall/spin, an uncontrolled descent, and an impact with terrain. A factor in the accident was his failure to follow the airplane's operating checklist and retract the…NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.NTSB IAD03FA056Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Montpelier, VAThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.NTSB LAX03FA124Accident · 2 fatalField investigationFinal reportCessna 172P · North Las Vegas, NVthe applicant pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall/spin.NTSB LAX03FA109Accident · 2 fatalField investigationFinal reportCessna 172L · Rosamond, CAthe pilot's failure to maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall and impact with flat level terrain. Also causal was the pilot's impaired judgment due to recent use of cocaine, and ethanol.NTSB FTW03FA086Accident · 1 fatalField investigationFinal reportCessna 152 · Norman, OKThe pilot's failure to maintain airspeed while maneuvering, resulting in an inadvertent stall . Factors contributing to the accident were the low altitude and the prevailing high winds.NTSB MIA03FA043Accident · 4 fatalField investigationFinal reportCessna 172P · Edgewater, FLThe pilot's inflight loss of control and the pilot's failure to recover from the resultant dive for unknown reasons which resulted in flight beyond the design stress limits of the airplane and subsequent in flight airframe breakup.NTSB FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.