NTSB investigations: Lycoming 0-235 series, 2008

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

20082026
NTSB investigations: Lycoming 0-235 series, 2008 per year, 2008–2026: 43 cases
20088
20093
20102
20113
20122
20134
20142
20153
20162
20183
20193
20204
20221
20231
20262

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 year(c.\"eventDate\") = 2008
    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\" = '092'))
  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 CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.Nov 3, 2008 · N47221 · Substantial damageNTSB MIA08CA113Accident · No injuriesData collectionFinal reportCessna 152 · Okeechobee, FLThe student pilot's improper recovery from a bounced landing.Jun 6, 2008 · N6173L · Substantial damageNTSB DFW08CA162Accident · No injuriesData collectionFinal reportCessna CE-152 · Castroville, TXAn improper flare during landing. Contributing to the accident was a porpoise induced oscillation.May 29, 2008 · N4789P · Substantial damageNTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.May 7, 2008 · N4912H · Substantial damageNTSB SEA08CA125Accident · No injuriesData collectionFinal reportCessna 152 · Redding, CAThe pilot's misjudged landing flare, which resulted in a hard landing.May 6, 2008 · N68353 · Substantial damageNTSB LAX08CA090Accident · No injuriesData collectionFinal reportCessna 152 · El Cajon, CAthe student pilot's inadequate compensation for gusty, crosswind conditions, and failure to maintain an adequate airspeed.Apr 1, 2008 · N64938 · Substantial damageNTSB DFW08CA093Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe student pilot's improper landing flare resulting in a hard landing. Contributing to the accident were the gusty surface winds and the student pilot's inadequate preflight planning.Feb 8, 2008 · N24768 · Substantial damageNTSB LAX08LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CALoss of engine power during the takeoff initial climb due to lack of compression to a cylinder.Feb 1, 2008 · N49811 · Substantial damage