NTSB investigations: Continental O-470 series, CO

16 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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: Continental O-470 series, CO per year, 1982–2026: 16 cases
19821
19831
19871
19891
19901
19931
19941
19971
19981
19992
20032
20041
20072

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 ('17026')
      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\" = 260))
  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 DEN07CA111Accident · No injuriesData collectionFinal reportCessna 180A · Loveland, COThe pilot's failure to maintain directional control of the airplane during landing.Jul 1, 2007 · N180EV · Substantial damageNTSB DEN07CA094Accident · Minor injuriesData collectionFinal reportCessna 180H · Grand Junction, COThe pilot's failure to maintain directional control during the take-off roll. A factor contributing to the accident was the crosswind.May 28, 2007 · N3408Y · Substantial damageNTSB DEN04CA066Accident · No injuriesData collectionFinal reportCessna 182K · Durango, COthe pilot's inadequate in-flight planning and decision making. Contributing factors include the crosswind and the crosswind component exceeded.Apr 21, 2004 · N2861R · Substantial damageNTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.Dec 28, 2003 · N5609B · Substantial damageNTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.Oct 26, 2003 · N9794G · Substantial damageNTSB DEN00LA004Accident · No injuriesLimited investigationFinal reportCessna 180D · Denver, COThe excessive taxi speed used by the pilot exiting the runway via a high-speed taxiway resulting in a loss of control. A factor was the crosswind.Oct 14, 1999 · N6425X · Substantial damageNTSB DEN99LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Watkins, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A related factor was the gusty quartering tailwind.Jul 7, 1999 · N7289E · Substantial damageNTSB FTW98LA343Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Watkins, COThe pilot's loss of control during taxi due to excessive taxi speed.Aug 3, 1998 · N5099E · Substantial damageNTSB FTW97LA143Accident · No injuriesLimited investigationFinal reportCessna 180D · Erie, COThe pilot's failure to maintain airplane directional control. A factor was the crosswind.Mar 27, 1997 · N6484X · Substantial damageNTSB FTW94LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Meeker, COFailure by the pilot to maintain directional control of the aircraft during landing roll.Feb 1, 1994 · N111RR · Substantial damageNTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.Sep 9, 1993 · N4719B · Substantial damageNTSB DEN90LA160Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Akron, COThe pilot's failure to correct a swerve during landing roll. A factor was wind gusts.Jul 12, 1990 · N59KM · Substantial damageNTSB DEN89LA215Accident · No injuriesLimited investigationFinal reportCessna 180K · Englewood, COFailure of the pilot to maintain directional control, which resulted in a ground swerve. The crosswind was a related factor.Sep 2, 1989 · N2705K · Substantial damageNTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…Nov 28, 1987 · N6547A · Substantial damageNTSB DEN83LA226Accident · No injuriesLimited investigationFinal reportBeech H35 · Salida, COThe acft touched down about 1/2 way down the rwy, left of centerline. The acft then struck a small ridge of dirt & rocks& came to rest with the left landing gear collapsed.Sep 30, 1983 · N5492D · Substantial damageNTSB DEN82FTE16Accident · No injuriesFinal reportCessna 180 · Saquache, CODuring a round-robin VFR flight the pilot landed at cochetopa strip and shut down for 1 hour. The pilot stated that at the time of takeoff the wind velocity had increased to 20-25 knots with almost a direct crosswind. During takeoff the aircraft drifted left…Jan 11, 1982 · N2332C · Substantial damage