NTSB investigations: Lycoming 0-235 series, 2006

7 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

19822026
NTSB investigations: Lycoming 0-235 series, 2006 per year, 1982–2026: 251 cases
198220
198322
198425
198512
19864
198720
198814
198912
19906
19917
19925
19938
19945
19956
199610
19978
19986
19997
20007
20017
20027
20037
20045
200511
20067
20073

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\") = 2006
    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 DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.Nov 23, 2006 · N67503 · Substantial damageNTSB MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.Nov 5, 2006 · N5657L · Substantial damageNTSB NYC07CA013Accident · No injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's inadequate flare, which resulted in a nosegear collapse during landing.Oct 27, 2006 · N68727 · Substantial damageNTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.Sep 18, 2006 · N24403 · Substantial damageNTSB LAX06CA209Accident · No injuriesData collectionFinal reportCessna 152 · Concord, CAthe student pilot's unstabilized approach, misjudged landing flare, inadequate recovery from a bounced landing, and failure to maintain directional control. A contributing factor to the accident was the in-flight distraction.Jun 22, 2006 · N5534M · Substantial damageNTSB SEA06CA093Accident · No injuriesData collectionFinal reportZenair CH 2000 · Tooele, UTThe flight instructor's inadequate supervision of the student pilot during the landing flare, which resulted in a hard landing. A contributing factor was the student pilot's failure to maintain aircraft control during the landing flare.Apr 22, 2006 · N8503J · Substantial damageNTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.Feb 15, 2006 · N47105 · Substantial damage