Skip to content

NTSB investigations: Lycoming IO-320 series, CO

27 cases on aircraft whose registry engine model is Lycoming IO-320 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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 ('41509')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('41509'))
  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 ('41509'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.Dec 6, 2023 · N7790Y · Substantial damage NTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.Aug 26, 2011 · N75BA · Substantial damage NTSB DEN06FA107Accident · 2 fatalField investigationFinal reportAmerican Champion 7KCAB · Winter Park, COThe pilot's failure to maintain adequate airspeed to avoid a stall while maneuvering at a low altitude in mountainous terrain. Factors associated with the accident are the pilot's performance of a low altitude flight maneuver, an inadvertent stall/spin, and…Jul 30, 2006 · N5232X · Destroyed NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.Feb 17, 2006 · N7743Y · Substantial damage NTSB DEN03LA037Accident · Minor injuriesLimited investigationFinal reportRothrock Cozy Mark IV · Erie, COThe pilot's failure to maintain aircraft control during landing. Contributing factors were the high crosswinds and the gusts.Jan 26, 2003 · N320FR · Destroyed NTSB DEN03LA011Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Fort Collins, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airspeed resulting in a stall.Oct 22, 2002 · N41807 · Destroyed NTSB DEN00LA013Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Grand Junction, COA failure of the left main landing gear attachment (u-bolt) due to fatigue.Oct 27, 1999 · N8707V · Substantial damage NTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.Jul 16, 1998 · N444BP · Substantial damage NTSB FTW98LA094Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Leadville, COThe failure of the pilot to maintain directional control of the airplane. Factors were a sudden windshift from a headwind to a quartering tailwind, and the snowbank.Jan 10, 1998 · N5275X · Substantial damage NTSB FTW97LA368Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Englewood, COfailure of the right main landing gear due to multiple fatigue cracks.Sep 19, 1997 · N88314 · Substantial damage NTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.Sep 28, 1994 · N53844 · Substantial damage NTSB DEN93LA014Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Boulder, COUndetermined.Dec 2, 1992 · N2751G · Substantial damage NTSB DEN92LA019Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Aurora, COThe pilot failed to maintain control of the aircraft. A factor was: improper supervision by the flight instructor.Dec 24, 1991 · N53883 · Substantial damage NTSB DEN91FA126Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ft. Carson, COThe loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.Sep 11, 1991 · N7730Y · Destroyed NTSB DEN87LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Erie, COAcft lifted off at slow airspeed and stalled/mushed back to rwy.Mar 5, 1987 · N2629G · Substantial damage NTSB DEN86LA024Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berthoud, COThe plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt…Nov 17, 1985 · N1832G · Substantial damage NTSB DEN84LA227Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Longmont, COShortly after lift off from a touch-and-go landing, the engine sputtered and lost power. A forced landing was performed in a field where the aircraft struck a dirt bank and nosed over. No reason was found for the power loss.Jul 19, 1984 · N57394 · Substantial damage NTSB DEN82FTE09Accident · 1 fatalClosedAeronca 7KCAB · Morrison, CONov 14, 1981 · N6340N · Substantial damage NTSB DEN80FTE60Accident · No injuriesClosedPiper PA-30 · Elbert, COJun 24, 1980 · N8172Y · Substantial damage NTSB DEN77DTE37Accident · No injuriesClosedBellanca 8KCAB · Loveland, COMay 1, 1977 · N36436 · Substantial damage NTSB DEN77FTE24Accident · Minor injuriesClosedBellanca 7KCAB · Mack, COFeb 26, 1977 · N41807 · Destroyed NTSB DEN76FTE76Accident · Serious injuriesClosedBellanca 8KCAB · Boulder, COJun 5, 1976 · N8751V · Substantial damage NTSB DEN73FTE62Accident · No injuriesClosedChampion 7KCAB · Boulder, COMar 4, 1973 · N11FS · Substantial damage NTSB DEN70DXD23Accident · No injuriesClosedChampion 7KCAB · Fountain, COApr 7, 1970 · N7572F · Substantial damage NTSB DEN70DXD21Accident · No injuriesClosedChampion 7KCAB · Pueblo, COApr 5, 1970 · N7572F · Substantial damage NTSB DEN69D0077Accident · No injuriesClosedPiper PA-30 · Littleton, COAug 24, 1968 · N8469Y · Substantial damage NTSB DEN67F0106Accident · No injuriesClosedPiper PA-30 · Fountain, COSep 27, 1966 · N7903Y · Substantial damage