NTSB investigations: Lycoming 0-235 series, MI

7 cases on aircraft whose registry engine model is Lycoming 0-235 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-235 series, MI per year, 1988–2026: 7 cases
19881
19901
19951
20011
20021
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
      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 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 CHI02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hastings, MIThe failure to attain airspeed, inadequate supervision of the flight, and delayed remedial action which resulted in a stall.May 4, 2002 · N2494B · Substantial damageNTSB CHI02LA046Accident · No injuriesLimited investigationFinal reportMiller Lancair 235 · Tecumseh, MIThe pilot's failure to maintain aircraft control during the takeoff. Factors relating to the accident were the crosswind and the wind gusts.Dec 5, 2001 · N417EM · Substantial damageNTSB CHI96LA004Accident · No injuriesLimited investigationFinal reportCessna 152II · Troy, MIthe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was the quartering tailwind condition and the pilot's selection of the wrong runway on which to land.Oct 9, 1995 · N6469P · Substantial damageNTSB CHI91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MIThe pilot-in-command (CFI)'s inadequate supervision of the dual student.Dec 26, 1990 · N67401 · Substantial damageNTSB 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 · Destroyed