NTSB investigations: Lycoming 0-235 series, TN

7 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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

19842026
NTSB investigations: Lycoming 0-235 series, TN per year, 1984–2026: 7 cases
19841
19851
19861
19871
19911
19931
19941

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\" = 'TN' 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\" = 260))
  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 ATL94LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Linden, TNThe pilot's improper use of the rudder which resulted in a loss of directional control.Sep 21, 1994 · N5525P · Substantial damageNTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.Aug 18, 1993 · N4921H · Substantial damageNTSB ATL91LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNStudent pilot's failure to maintain directional control during the landing roll.Jun 18, 1991 · N25362 · Substantial damageNTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…Mar 13, 1987 · N25503 · Substantial damageNTSB ATL86LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNDuring landing roll the student pilot lost directional control of the aircraft and collided with a tree adjacent to the runway.Apr 3, 1986 · N93589 · Substantial damageNTSB ATL85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Memphis, TNAcft bounced during lndg in 10KT x-wind. The stu plt was on his 3rd unsupvr solo. The acft went off the rwy on the rt side & collapsed the nose lndg gear. The student had 28 hrs total flt time with a logbook restriction entered by his instructor to restrict…Mar 7, 1985 · N6489M · Substantial damageNTSB ATL84LA253Accident · No injuriesLimited investigationFinal reportCessna 152 II · Clarksville, TNThe 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the…Aug 11, 1984 · N67810 · Substantial damage