NTSB investigations: Lycoming 0-320 series, CO

8 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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

19892026
NTSB investigations: Lycoming 0-320 series, CO per year, 1989–2026: 8 cases
19891
19951
19961
19972
19991
20011
20041

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\" = 'CO' 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\" = 350))
  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 DEN05LA041Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Steamboat Spngs, COthe loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.Dec 18, 2004 · N78AT · Substantial damageNTSB DEN02LA005Accident · No injuriesLimited investigationFinal reportIrwin Thorp T-18 · Longmont, COThe loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landingOct 26, 2001 · N2819L · Substantial damageNTSB DEN99LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA28-160B · Pueblo, COTotal loss of power during initial climb for undetermined reasons.Jul 23, 1999 · N5595W · Substantial damageNTSB FTW98LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COloss of engine power for undertermined reason(s).Nov 24, 1997 · N738LC · Substantial damageNTSB FTW97LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Fort Collins, COa total loss of power for reasons undetermined. A factor was unsuitable terrain for a forced landing.Mar 19, 1997 · N98150 · Substantial damageNTSB FTW96LA293Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Garfield, COa reported power loss for reasons undetermined.Jul 7, 1996 · N5675S · Substantial damageNTSB FTW95LA122Accident · Minor injuriesLimited investigationFinal reportMorrison, Marvin E. RV-4 · Brighton, COA total loss of power for unknown reasons. A factor was the lack of suitable terrain for a forced landing.Feb 25, 1995 · N872MM · Substantial damageNTSB DEN89LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenwood Spgs, COInadequate compensation for wind conditions by the dual student, resulting in a loss of control and a forced landing. The pilot-in-command, CFI, failed to adequately supervise the operation.Jul 8, 1989 · N2720E · Substantial damage