Fatal NTSB investigations: Lycoming 0-235 series, MI

11 cases on aircraft whose registry engine model is Lycoming 0-235 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

19772026
Fatal NTSB investigations: Lycoming 0-235 series, MI per year, 1977–2026: 11 cases
19771
19781
19793
19821
19831
19881
20001
20031
20061

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\" = 'MI' AND c.\"eventCountry\" = 'USA'
    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 ('41505'))
  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 CHI06LA073Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Pontiac, MIThe excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.Jan 27, 2006 · N55CW · DestroyedNTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.Sep 25, 2003 · N25787 · DestroyedNTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.Sep 18, 2000 · N5943H · DestroyedNTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.Aug 3, 1988 · N2956Z · DestroyedNTSB CHI84FA037Accident · 2 fatalField investigationFinal reportCessna 152 II · Decatur, MIThe acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was…Nov 6, 1983 · N5528L · DestroyedNTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…Jul 5, 1982 · N4698L · DestroyedNTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MIOct 29, 1979 · N4437J · 2 aircraft · DestroyedNTSB CHI79FEC57Accident · 2 fatalClosedBreezy RLU-1 · Frazer, MISep 22, 1979 · N9369 · DestroyedNTSB CHI79FEM33Accident · 2 fatalClosedBreezy FGC100 · Grand Haven, MIAug 5, 1979 · N219TC · 2 aircraft · Minor damageNTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MIJan 31, 1978 · N757PQ · DestroyedNTSB CHI77FEM22Accident · 1 fatalClosedAmer Avco AA1 · East Tawas, MIApr 11, 1977 · N5706L · Destroyed