NTSB investigations: Lycoming 0-235 series, FL

8 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the defining event was Abnormal runway contact. 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

20092026
NTSB investigations: Lycoming 0-235 series, FL per year, 2009–2026: 8 cases
20091
20101
20171
20182
20191
20202

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\" = 'FL' 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090'))
  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 ERA20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, and failure to recover from the ensuing bounced landing, which resulted in a subsequent nose landing gear collapse.Jun 23, 2020 · N5314M · Substantial damageNTSB ERA20CA147Accident · No injuriesData collectionFinal reportZenair CH 2000 · Ocala, FLThe student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nosewheel collapsing.Feb 28, 2020 · N677NA · Substantial damageNTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.Sep 17, 2019 · N472TC · Substantial damageNTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.Jul 16, 2018 · N5551L · Substantial damageNTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.May 7, 2018 · N699ZA · Substantial damageNTSB ERA17CA221Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper landing flare, which resulted in a bounced landing.Jun 29, 2017 · N53396 · Substantial damageNTSB ERA10CA249Accident · No injuriesData collectionFinal reportCessna 152 · Cross City, FLThe pilot's inadequate compensation for the crosswind condition resulting in the loss of directional control while landing.Apr 28, 2010 · N49007 · Substantial damageNTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.Mar 5, 2009 · N94563 · Substantial damage