NTSB investigations: Lycoming 0-235 series, MO

6 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Hard landing”. 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, MO per year, 1983–2026: 6 cases
19831
19841
19871
19881
19971
19991

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\" = 200))
  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 CHI00LA005Accident · No injuriesLimited investigationFinal reportZenair CH 2000 · St. Louis, MOthe student pilot misjudged the landing flare which resulted in a hard landing. A factor associated with the accident was the student's lack of total experience.Oct 6, 1999 · N25ZA · Substantial damageNTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.Jun 21, 1997 · N7506F · Substantial damageNTSB MKC89LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Creve Coeur, MOThe student pilot said that after practicing locally and returning to the base airport, he discovered the winds to be greater than anticipated. On his third attempt to land, he bounced twice, then lost control and hit nose first on the runway. An eighty…Dec 18, 1988 · N757YE · Substantial damageNTSB MKC87LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirksville, MODrg a night landing, the plt did not get the acft flared before touchdown. Subsequently, it contacted the rwy with the nose wheel. Drg the occurrence, the nose gear, prop & eng fire wall were damaged.Apr 9, 1987 · N5515Q · Substantial damageNTSB MKC84LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOThe acft bounced during a touch and go landing. The plt was unable to control the bouncing and the acft received damage to the nose gear, propeller and wing tips.Jan 22, 1984 · N6377B · Substantial damageNTSB MKC83LA198Accident · No injuriesLimited investigationFinal reportCessna C-152 · Kansas City, MOThe student pilot had made 3 solo touch and go landings. On the 4th landing the aircraft floated and then landed nose gear first. The nose gear collapsed.Aug 22, 1983 · N67544 · Substantial damage