NTSB investigations: Lycoming 0-235 series, LA

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

19822026
NTSB investigations: Lycoming 0-235 series, LA per year, 1982–2026: 6 cases
19821
19891
19941
19961
19991
20031

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\" = 'LA' 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 FTW03FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-1A · Shreveport, LAThe pilot's failure to maintain adequate airspeed resulting in a stall.Jan 2, 2003 · N9226L · DestroyedNTSB FTW99LA144Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot's delayed landing flare and her subsequent improper recovery technique following the bounced landing.May 22, 1999 · N4850B · Substantial damageNTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.Mar 24, 1996 · N9385T · Substantial damageNTSB FTW94LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Rayville, LAThe pilot's failure to maintain adequate airspeed during the turn to final approach.Mar 22, 1994 · N2966M · Substantial damageNTSB FTW90LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Thibodaux, LAStudent pilot's failure to obtain or maintain airspeed during an aborted landing, which resulted in an inadvertent stall/mush. His failure to maintain runway alignment and the ditch were related factors.Oct 24, 1989 · N4973B · Substantial damageNTSB FTW82DA234Accident · No injuriesFinal reportBeech 77 · Jackson, LAWhile in the vicinity of Jackson, LA, the instructor pilot (ip) had the student make a simulated forced landing. The landing was to be to a full stop on the Jackson airport. According to the initial modification, the student allowed the aircraft to drift left…Jun 19, 1982 · N3726Z · Substantial damage