NTSB investigations: Lycoming 0-235 series, VA

10 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

19832026
NTSB investigations: Lycoming 0-235 series, VA per year, 1983–2026: 10 cases
19831
19841
19921
19962
19981
20002
20011
20061

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\" = 'VA' 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 NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.Jun 16, 2006 · N5045Z · Substantial damageNTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.Jul 2, 2001 · N5286P · Substantial damageNTSB IAD00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Lynchburg, VAPilot's failure to maintain directional control during the landing roll-out.Aug 14, 2000 · N189T · Substantial damageNTSB NYC00LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · West Point, VAThe student pilot's failure to maintain directional control during the landing roll.Jul 1, 2000 · N68910 · Substantial damageNTSB IAD98LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAFailure to maintain directional control during the takeoff roll. A related factor was wind gusts.Aug 1, 1998 · N89074 · Substantial damageNTSB IAD96LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ashland, VAan undetermined braking anomaly and/or failure of the pilot to maintain directional control of the airplane during the landing.Aug 11, 1996 · N2598G · Substantial damageNTSB IAD96LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAthe student pilot's failure to maintain adequate control of the aircraft during the touch and go landing. Related factors were the crosswind condition and the student pilot's lack of experience.May 14, 1996 · N67557 · Substantial damageNTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.Apr 5, 1992 · N67658 · Substantial damageNTSB ATL84LA195Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, VAThe plt practiced several landings, then made a soft field apch with 20 deg of flaps. During the 1st part of the landing roll, he held the nosewheel off the rwy, then lowered the nose & applied the brakes. At that time, the acft veered right, went off the rwy…Jun 9, 1984 · N5342M · Substantial damageNTSB ATL83LA329Accident · No injuriesLimited investigationFinal reportCessna A 152 · Lynchburg, VAThe acft ran off the rwy and collided with a ditch during takeoff. The student pilot was practicing touch and go landings. During one running takeoff after full power was applied the plt noticed that full flaps were still extended. While retracting the flaps…Aug 19, 1983 · N47281 · Substantial damage