NTSB investigations: Lycoming 0-320 series, OK

7 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

19882026
NTSB investigations: Lycoming 0-320 series, OK per year, 1988–2026: 7 cases
19881
19911
20011
20032
20061
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\" = 'OK' 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 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.Nov 28, 2007 · N6555D · Substantial damageNTSB DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.May 21, 2006 · N9419C · Substantial damageNTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.Sep 11, 2003 · N9651Q · Substantial damageNTSB 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.Jan 21, 2003 · N47257 · DestroyedNTSB FTW01FA129Accident · 1 fatalField investigationFinal reportCessna 150 · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.May 26, 2001 · N5617E · 2 aircraft · DestroyedNTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.Apr 15, 1991 · N75759 · Substantial damageNTSB FTW88FA104Accident · 2 fatalField investigationFinal reportCessna 172P · Le Flore, OKThe acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep…May 18, 1988 · N212FR · Destroyed