NTSB investigations: Lycoming 0-320 series, OR

25 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

19822026
NTSB investigations: Lycoming 0-320 series, OR per year, 1982–2026: 25 cases
19821
19891
19901
19932
19942
19952
19971
19982
20001
20011
20031
20043
20054
20062
20071

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.\"eventStateOrRegion\" = 'OR' 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')
      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.

NTSB SEA07CA269Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Bend, ORProper descent rate not obtained/maintained during a pinnacle approach.Sep 21, 2007 · N2341J · Substantial damageNTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.Dec 12, 2006 · N5618U · Substantial damageNTSB SEA07CA010Accident · No injuriesData collectionFinal reportAlexander Lancair 320 · Scappoose, ORThe pilot's failure to maintain aircraft control during a go-around.Oct 22, 2006 · N1382Y · Substantial damageNTSB SEA06CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Prineville, ORAircraft control not maintained by the private pilot during the initial takeoff climb, and the improper remedial action by the flight instructor. A factor was the wind gust.Dec 9, 2005 · N2584S · Substantial damageNTSB 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…Jun 24, 2005 · N4368R · Substantial damageNTSB SEA05CA080Accident · No injuriesData collectionFinal reportCessna 172 · Yamhill, ORThe pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.Apr 9, 2005 · N8400L · Substantial damageNTSB SEA05CA063Accident · No injuriesData collectionFinal reportJeffs J-Bird · St. Paul, ORThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain. A contributing factor was the pilot's decision to fly at low altitude.Mar 12, 2005 · N6407M · Substantial damageNTSB 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.Jul 15, 2004 · N4439P · Substantial damageNTSB SEA04CA122Accident · Minor injuriesData collectionFinal reportRobinson R22 Mariner · Hillsboro, ORThe pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.Jul 5, 2004 · N856HA · Substantial damageNTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.Jun 21, 2004 · N9827Y · Substantial damageNTSB SEA04LA012Accident · No injuriesLimited investigationFinal reportGarnett-Robert Barnett J4B · Prineville, ORThe pilot's failure to maintain airspeed which resulted in an inadvertent stall during the initial takeoff climb. A factor was the lack of pilot certification.Oct 27, 2003 · N9565A · Substantial damageNTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.May 12, 2001 · N62961 · Substantial damageNTSB SEA00LA174Accident · No injuriesLimited investigationFinal reportBeard Lancair 320 · Bend, ORThe pilot's failure to take adequate remedial action upon encountering aircraft control difficulties during landing. Factors included gusty wind conditions and the pilot's failure to maintain aircraft control during landing.Aug 31, 2000 · N6BQ · Substantial damageNTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.Oct 22, 1998 · N474BC · Substantial damageNTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.Jul 20, 1998 · N31066 · Substantial damageNTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…Jul 28, 1997 · N80222 · Substantial damageNTSB SEA95LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe student pilot's failure to maintain directional control while hovering, which resulted in the aircraft colliding with terrain. Contributing to the accident were gusting wind conditions.May 24, 1995 · N461H · Substantial damageNTSB SEA95LA065Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe dual student pilot's failure to maintain directional control of the helicopter during the practice hover autorotation to landing, and the flight instructor's failure to adequately supervise the dual student during the landing. Contributing to the accident…Mar 12, 1995 · N721HH · Substantial damageNTSB SEA94LA171Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Portland, ORTail rotor gearbox failure due to inadequate assembly and inspection procedures by the manufacturer.Jul 7, 1994 · N42WC · Substantial damageNTSB SEA94FA071Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Frenchglen, ORThe pilot's failure to maintain minimum airspeed (vs). The tailwind was a factor.Mar 2, 1994 · N82951 · DestroyedNTSB SEA94LA015Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Burns, ORPoor in-flight planning/decision and an inadvertent stall/spin. A factor to the accident was an excessive pull-up.Oct 10, 1993 · N5074V · DestroyedNTSB SEA93LA064Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Bend, ORRotor RPM was not maintained. Factors to the accident were: low ceiling and poor inflight planning.Feb 7, 1993 · N4085M · Substantial damageNTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.Sep 16, 1990 · N5332K · DestroyedNTSB SEA89LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Burns Junction, ORThe pilot did not maintain proper airspeed during takeoff.Aug 31, 1989 · N83330 · Substantial damageNTSB SEA82FYM22Accident · 3 fatalFinal reportPiper 24-140 · Enterprise, ORWitnesses observed an aircraft fly over the city of Enterprise, Oregon on a bright night with clear sky conditions. Reportedly, the aircraft was flying very erratic; and just as it disappeared from the witnesses' sight, an explosion andfireball were observed…Jul 25, 1982 · N55492 · Destroyed