NTSB investigations: Lycoming 0-235 series, MA

6 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

19862026
NTSB investigations: Lycoming 0-235 series, MA per year, 1986–2026: 6 cases
19861
19892
19901
19951
20001

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\" = 'MA' 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 IAD00LA048Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Northampton, MAThe student pilot's failure to maintain directional control during takeoff.Jun 4, 2000 · N6340L · Substantial damageNTSB NYC95LA180Accident · No injuriesLimited investigationFinal reportWright JUNGSTER-I · Mansfield, MAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and subsequent uncontrolled descent and collision with the terrain.Jul 31, 1995 · N26241 · Substantial damageNTSB NYC90LA203Accident · 2 fatalLimited investigationFinal reportCessna 152 · Provincetown, MAThe failure of the pilot to maintain adequate airspeed, which resulted an inadvertent stall/spin. Probable factors related to the accident were: failure of the pilot to follow procedures/directives, and his lack of proper certification (qualification) for…Aug 28, 1990 · N24894 · DestroyedNTSB NYC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Sterling, MAInflight loss of control due to inadvertent retraction of the wing flaps during a go around.Oct 7, 1989 · N69169 · Substantial damageNTSB NYC89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bedford, MAImproper use of throttle and flight controls by the student and inadequate supervision by the CFI which resulted in a stall. The student's lack of total flying experience and the instructor's lack of experience in the type of operation (instructing) were…Apr 10, 1989 · N94822 · Substantial damageNTSB NYC87LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Haverhill, MAThe student plt was on an approved solo x-counrty flt when he became lost. He attempted a landing at an arpt 10 sm away from his arpt of intended landing. Realizing he was high on his first apch, he made a go-around. While making a 360 deg turn with full…Nov 3, 1986 · N49427 · Substantial damage