NTSB investigations: Lycoming 0-235 series, PA

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

19822026
NTSB investigations: Lycoming 0-235 series, PA per year, 1982–2026: 7 cases
19821
19831
19841
19921
19991
20021
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\" = 'PA' 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 NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.May 6, 2004 · N94577 · Substantial damageNTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.Jun 26, 2002 · N5684L · Substantial damageNTSB NYC99LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln Univ., PAThe student pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. Also causal was the certified flight instructor's inadequate supervision.Apr 3, 1999 · N2472N · Substantial damageNTSB NYC92LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Coatsville, PAThe failure of the student pilot to compensate for adverse winds during landing, which resulted in a loss of airspeed and subsequent stall and loss of control. A factor related to the accident was the student pilot's lack of total flight experience.Apr 1, 1992 · N49436 · Substantial damageNTSB NYC84LA244Accident · No injuriesLimited investigationFinal reportCessna 152 · Bally, PADuring the initial climb at aprx 10 ft AGL the airspeed dropped to 40 KTS and the stall warning horn came on. The plt pushed the nose down to prevent a stall. The right wing dropped and the acft veered off the rwy on touchdown. The acft then contacted a tree…Aug 1, 1984 · N93397 · Substantial damageNTSB NYC84FA039Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Wellsville, PAPrior to the flt, the plt stated that he would be flying foraprx 1/2 hr. Aprx 25 min after takeoff, ground witnesses northeast of the arpt observed the acft on a westerly heading, turning toward the arpt. Shortly after that, they saw the acft in an…Nov 27, 1983 · N81YB · DestroyedNTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.Mar 2, 1982 · N7378L · Destroyed