NTSB investigations: Lycoming 0-235 series, MO

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

19822026
NTSB investigations: Lycoming 0-235 series, MO per year, 1982–2026: 11 cases
19821
19861
19871
19891
19901
19911
19951
19971
19981
20051
20071

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\" = 'MO' 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 CHI07CA247Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Kansas City, MOThe pilot's failure to manitain directional control during landing which resulted in the airplane striking a taxiway sign during the aborted landing. The crosswind and the sign were factors.Jul 26, 2007 · N197T · Substantial damageNTSB CHI06CA017Accident · No injuriesData collectionFinal reportBellanca 7ECA · Cuba, MOThe pilot's failure to maintain directional control of the airplane during the landing roll.Oct 26, 2005 · N5065N · Substantial damageNTSB CHI98LA234Accident · No injuriesLimited investigationFinal reportAmerican AA-1TW · Point Lookout, MOthe failure of the tailwheel assembly due to corrosion. A factor associated with the accident was the overload failure of the right main landing gear.Jul 1, 1998 · N5643L · Substantial damageNTSB CHI97LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe student pilot's failure to maintain directional control of the airplane by overcompensating with the rudder. Factors associated with the accident were the excessive airspeed and the soft terrain.May 30, 1997 · N66980 · Substantial damageNTSB CHI95LA113Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Higginsville, MOthe pilot's inadequate compensation for wind conditions during the attempted takeoff. The gusty crosswind was a factor.Apr 2, 1995 · N2598Z · Substantial damageNTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.Sep 7, 1991 · N11BA · Substantial damageNTSB MKC90LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOFailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind condition, the student's lack of total experience, and the building (hangar).Jan 8, 1990 · N6095M · Substantial damageNTSB MKC90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · St Louis, MODirectional control not maintained by the pilot in command. A contributing factor was the gusty crosswind.Oct 16, 1989 · N4904B · Substantial damageNTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…Apr 27, 1987 · N2595B · Substantial damageNTSB MKC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fulton, MOThe pilot and his passenger were on a short flight to check the operation of a VOR receiver. While they were on the landing roll, a gust of wind turned the nose of the airplane to the left and the airplane ran off the runway and the right gear hit a runway…May 1, 1986 · N3XX · Substantial damageNTSB MKC82DA029Accident · No injuriesFinal reportCessna 152 · Cape Girardeau, MODuring his second solo flight, the student pilot landed in a slight left quartering headwind. He stated that he had left rudder applied on touchdown and the aircraft veered left into a snowbank and nose over.Feb 7, 1982 · N5272B · Substantial damage