NTSB investigations: Lycoming 0-320 series, OH

10 cases on aircraft whose registry engine model is Lycoming 0-320 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-320 series, OH per year, 1982–2026: 10 cases
19822
19871
19881
19932
19941
19962
20011

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\" = 'OH' 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 ('41508')
      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 NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.Jul 23, 2001 · N52012 · Substantial damageNTSB IAD96LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Tremont City, OHthe student pilot's misjudged flare which resulted in a hard landing.Jul 19, 1996 · N9731V · Substantial damageNTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.May 13, 1996 · N73664 · Substantial damageNTSB NYC94LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHthe pilot's improper flare, which resulted in the nose gear collapsing and the subsequent nose over of the airplane.May 28, 1994 · N6153D · Substantial damageNTSB NYC93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe improper flare by the pilot allowing the airplane to balloon and land hard. A factor in this accident was pilot's lack of recent flying experience.Apr 23, 1993 · N734QF · Substantial damageNTSB BFO93LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Napoleon, OHThe intentional stall resulting in a hard landing. Contributing to the accident was the premature flare which led to an exceeded proper touchdown point and the student pilot's lack of overall experience.Feb 28, 1993 · N5220W · Substantial damageNTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…May 7, 1988 · N5495K · Substantial damageNTSB ATL87DEI11Accident · No injuriesFinal reportCessna 172P · Stow, OHThe pilot flared too high on landing and the aircraft bounced on touchdown. The pilot did not use the proper technique to recover from the bounced landing and lost control of the aircraft. The aircraft departed from the runway and struck two taxi lights and a…Aug 8, 1987 · N62953 · Substantial damageNTSB CHI83LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Cincinnati, OHThe student pilot touched down on runway 06, bounced, the nose gear collapsed and the pilot loss direction control. The aircraft nosed over.Dec 12, 1982 · N62332 · Substantial damageNTSB CHI82DA142Accident · No injuriesFinal reportPiper PA-22-150 · Lancaster, OHThe pilot was practicing takeoffs and landings on runway 10. On the second landing the aircraft bounced and drifted. The aircraft touched down on the runway a second time collapsing the nose gear. The wind was reported as 010 degrees at 13 KTS. Gusts to 15…Apr 27, 1982 · N6739B · Substantial damage