NTSB investigations: Lycoming 0-235 series, NC

11 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, NC per year, 1984–2026: 11 cases
19841
19851
19871
19883
19951
19971
19991
20052

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\" = 'NC' 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 ATL05CA120Accident · No injuriesData collectionFinal reportGrumman American AA-1B · Durham, NCThe pilot's failure to maintain directional control. Factors were soft and wet terrain.Jul 3, 2005 · N100XX · DestroyedNTSB ATL05CA070Accident · No injuriesData collectionFinal reportCessna 152 · Goose Creek, NCThe student pilot's failure to maintain direction control, which resulted in a loss of control and collision with a berm.Mar 30, 2005 · N714TK · Substantial damageNTSB MIA99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, NCThe student pilots failure to maintain directional control during an attempted touch and go landing. This resulted in the airplane veering off the left side of the runway, and subsequent on-ground collision with a ditch and nosed over inverted..Feb 8, 1999 · N6294M · Substantial damageNTSB ATL97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Swansboro, NCThe pilot's failure to maintain directional control. A factor was the gusting winds.Jul 5, 1997 · N7799H · Substantial damageNTSB ATL95LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe pilot's failure to adequately compensate for wind conditions during landing, which resulted in a loss of directional control.Apr 8, 1995 · N25502 · Substantial damageNTSB ATL89LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe accident occurred during the student pilot's first supervised-solo flight. The student reported that she pushed the acft's nose down while on final appch after realizing she was too high, which led to an increase in airspeed. The student's instructor…Nov 30, 1988 · N68001 · Substantial damageNTSB ATL89LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe student plt reported that the airplane nose '...was wanting to come up sooner than it should' during the takeoff roll on his first solo flt; he checked the elevator trim and found it properly set. He elected to abort the takeoff. He reduced the pwr and…Oct 26, 1988 · N4713B · Substantial damageNTSB ATL88LA224Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reidsville, NCThe student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right…Aug 2, 1988 · N26045 · Substantial damageNTSB ATL87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay Varina, NCThe student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest…Feb 1, 1987 · N64823 · Substantial damageNTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.May 27, 1985 · N2378M · Substantial damageNTSB ATL84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rockingham, NCN92792 was being taxied from a tie down area when the prop struck the right wing on an unoccupied B-35, N8813A. The plt stated the brakes failed as he was attempting to taxi between two rows of parked acft and directional control was lost.Mar 4, 1984 · N92792 · Substantial damage