NTSB investigations: Lycoming 0-320 series, CO

21 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, CO per year, 1982–2026: 21 cases
19821
19831
19842
19872
19913
19921
19932
19941
19971
19981
19991
20001
20011
20021
20051
20071

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\" = 'CO' 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 DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.Oct 24, 2007 · N1422E · Substantial damageNTSB DEN05LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Loveland, COThe dual student's improper flare and the flight instructor's inadequate supervision.. A contributing factor was the inadequate communication between the flight instructor and the dual student,Feb 2, 2005 · N618MN · Substantial damageNTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…Jun 19, 2002 · N9089H · Substantial damageNTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.Oct 8, 2001 · N2364E · Substantial damageNTSB DEN00LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe pilot prematurely flaring the airplane for landing, resulting in a hard landing, followed by an inadvertent pilot-induced porpoise and loss of directional control. A factor was the fence.Jun 30, 2000 · N4642J · Substantial damageNTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.Jun 18, 1999 · N5266J · Substantial damageNTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.Jul 16, 1998 · N172AT · Substantial damageNTSB FTW97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Telluride, COThe pilot's misjudged landing flare and his improper bounced landing recovery technique. A factor was the snow bank.Mar 25, 1997 · N686JF · Substantial damageNTSB FTW95LA036Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COThe pilot's improper landing flare, the resultant porpoise and an inadequate recovery from the bounced landing.Oct 29, 1994 · N52521 · Substantial damageNTSB DEN93LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Buena Vista, COA downdraft and the pilot's failure to maintain directional control of the airplane. Factors were: a crosswind and the inadvertent selection of additional flaps.May 23, 1993 · N4881G · DestroyedNTSB DEN93LA046Accident · No injuriesLimited investigationFinal reportCessna 172M · Meeker, COThe pilot's improper compensation for wind conditions. A factor was: gusty crosswinds.Apr 26, 1993 · N4472R · Substantial damageNTSB DEN93LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spring, COProper descent rate was not maintained by the pilot in command which resulted in a hard landing.Oct 18, 1992 · N1450U · Substantial damageNTSB DEN91LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe student pilot misjudged his landing flare. A factor was: the pilot's lack of experience.Aug 31, 1991 · N2417E · Substantial damageNTSB DEN91LA094Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot misjudging his flare.Jul 1, 1991 · N89900 · Substantial damageNTSB DEN91LA085Accident · No injuriesLimited investigationFinal reportCessna 172J · Rifle, COThe student pilot improperly flared the aircraft during landing.Jun 16, 1991 · N9885J · Substantial damageNTSB DEN87LA249Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangley, COThe student pilot was on his second supervised solo flight and was attempting a second landing on runway 24. The plt stated that the approach was normal and that the acft bounced on touchdown. The plt attempted to correct and the acft banked left. Power was…Sep 30, 1987 · N62938 · Substantial damageNTSB DEN87LA051Accident · No injuriesLimited investigationFinal reportCessna 172 M · Air Force Acade, COWhile making a landing, the acft landed hard and began to porpoise. After the third bounce, the nose gear collapsed.Feb 7, 1987 · N9582V · Substantial damageNTSB DEN84LA267Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Aurora, COPlt stated that following a hard landing, directional control was lost. Acft departed runway and collided with dirt berm.Aug 25, 1984 · N7346D · Substantial damageNTSB DEN84LA191Accident · No injuriesLimited investigationFinal reportCessna 172 · Greeley, COThe student plt stated that during a landing, the acft either ballooned or was caught in an updraft. She reacted by pushing forward on the control wheel. The nosewheel hit the rwy first, the acft bounced in the air & again landed on thenosewheel. The firewall…Jun 21, 1984 · N733LA · Substantial damageNTSB DEN83LA198Accident · No injuriesLimited investigationFinal reportBeech 23 · Rocky Ford, COThe acft landed hard & bounced. The impact wrinkled the right wing at the fuel cell position.Aug 27, 1983 · N7972L · Substantial damageNTSB DEN82FTE25Accident · No injuriesFinal reportDavenport BD-2 · Conifer, COThe pilot stated that while landing at a ranch strip the aircraft bounced. On the second bounce the right main landing gear crossed a ditch located on the right side of the runway, hit a mound of dirt and separated the wheel. The aircraft then nosed over…Sep 4, 1982 · N5131 · Substantial damage