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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1987 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.NTSB 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,NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.NTSB 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.NTSB 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.NTSB 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.NTSB DEN93LA046Accident · No injuriesLimited investigationFinal reportCessna 172M · Meeker, COThe pilot's improper compensation for wind conditions. A factor was: gusty crosswinds.NTSB 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.NTSB DEN91LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe student pilot misjudged his landing flare. A factor was: the pilot's lack of experience.NTSB 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.NTSB DEN91LA085Accident · No injuriesLimited investigationFinal reportCessna 172J · Rifle, COThe student pilot improperly flared the aircraft during landing.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB DEN83LA198Accident · No injuriesLimited investigationFinal reportBeech 23 · Rocky Ford, COThe acft landed hard & bounced. The impact wrinkled the right wing at the fuel cell position.NTSB 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…