NTSB investigations: Lycoming 0-235 series, MS

6 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

19862026
NTSB investigations: Lycoming 0-235 series, MS per year, 1986–2026: 6 cases
19861
19881
19931
19961
19981
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\" = 'MS' 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 MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.May 29, 2004 · N2484A · Substantial damageNTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.Oct 25, 1998 · N5139B · Substantial damageNTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.Jan 14, 1996 · N68172 · Substantial damageNTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.Sep 3, 1993 · N2966M · Substantial damageNTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.Apr 16, 1988 · N4830B · Substantial damageNTSB MIA87LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Polarville, MSThe plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft…Nov 10, 1986 · N89543 · Substantial damage