NTSB investigations: Lycoming 0-235 series, KS

5 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, KS per year, 1982–2026: 5 cases
19821
19831
19841
19871
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\" = 'KS' 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 CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…Jun 13, 2004 · N70718 · Substantial damageNTSB MKC87LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Coffeyville, KSThe student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip…Jan 22, 1987 · N4924H · Substantial damageNTSB MKC84LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear.Jan 28, 1984 · N24531 · Substantial damageNTSB MKC83LA217Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrence, KSThe pilot stated that he was taking off for his fourth touch and go landing when the acft weathervaned and he lost control of the acft. The nose wheel struck a concrete drainage ditch.Sep 12, 1983 · N2327G · Substantial damageNTSB MKC82DA040Accident · No injuriesFinal reportCessna 152 · Mcpherson, KSAfter returning from a local flight, the student pilot landed on runway 36 with a wind from 070 degrees at 13 knots. He reported that he lost control on the landing roll and departed the left side of the runway. The aircraft ran into muddy terrain and nosed…Feb 26, 1982 · N757PF · Substantial damage