NTSB investigations: Lycoming 0-320 series, 2020

9 cases on aircraft whose registry engine model is Lycoming 0-320 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-320 series, 2020 per year, 2008–2026: 133 cases
200815
200910
20108
201110
201213
20135
20149
20156
20165
20178
20185
20194
20209
20215
20227
20232
20243
20255
20264

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\") = 2020
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
      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 ERA21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Williston, FLThe pilot’s improper landing flare, which resulted in a hard landing.Oct 13, 2020 · N6158G · Substantial damageNTSB ERA20LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Laconia, NHThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.Sep 20, 2020 · N18778 · Substantial damageNTSB WPR20CA300Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Stuart Island, WAThe pilot’s improper approach airspeed and landing flare, which resulted in a hard, bounced landing and nose over.Sep 7, 2020 · N172CS · Substantial damageNTSB ERA20CA318Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Wilmington, DEThe student pilot’s improper landing flare, which resulted in a hard bounced landing.Sep 7, 2020 · N19813 · Substantial damageNTSB CEN20CA340Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Englewood, COThe student pilot misjudged the landing flare which resulted in a loss of control and a hard bounced landing.Aug 8, 2020 · N79110 · Substantial damageNTSB ERA20CA256Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Wellington, FLThe pilot’s inadequate compensation for a wind gust during landing.Jul 19, 2020 · N1655V · Substantial damageNTSB CEN20CA257Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Reedsburg, WIThe student pilot's improper landing flare, which resulted a hard, bounced landing.Jun 12, 2020 · N738VY · Substantial damageNTSB CEN20CA241Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Bowling Green, MOThe pilot's improper flare, which resulted in a hard, bounced landing.Jun 12, 2020 · N65773 · Substantial damageNTSB WPR20CA209Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lubbock, TXThe pilot's improper approach and descent rate, which resulted in a hard landing.Jun 8, 2020 · N92356 · Substantial damage