Skip to content

NTSB investigations: Continental C145 series, CO

28 cases on aircraft whose registry engine model is Continental C145 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

19642026

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 ('17012')) 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 ('17012'))
  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 ('17012'))
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 CEN27LA033AccidentClass 4 · LimitedInvestigation openCessna 170B · Englewood, COOct 28, 2026 · N3187B NTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.Jun 15, 2025 · N1996C · Substantial damage NTSB GAA15CA286Accident · No injuriesData collectionFinal reportCessna 170A · Springfield, COThe pilot's failure to maintain directional control during the landing flare, which resulted in a collision with terrain, and a nose over.Oct 1, 2015 · N9775A · Substantial damage NTSB GAA15CA167Accident · No injuriesData collectionFinal reportCessna 170B · Durango, COThe pilot's decision to taxi behind a turbojet airplane into jet blast, which resulted in the airplane being blown off an active taxiway and flipped upside down onto terrain.Jun 28, 2015 · N170MW · Substantial damage NTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.Jan 20, 2013 · N2323D · Substantial damage NTSB DEN08CA073Accident · No injuriesData collectionFinal reportCessna 170B · Fort Collins, COthe pilot's failure to maintain directional control during takeoff.Apr 6, 2008 · N2232D · Substantial damage NTSB DEN07CA086Accident · No injuriesData collectionFinal reportCessna 170A · Watkins, COA total failure during landing roll of the right brake caused by severely worn shoes, causing the caliper pins to engaged misaligned. A contributing factor was the pilot's inability to maintain directional control.Apr 11, 2007 · N1258D · Substantial damage NTSB DEN05LA013Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Glenwood Spring, COthe pilot's failure to use carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Related factors were conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.Oct 23, 2004 · N9176A · Substantial damage NTSB DEN99LA115Accident · No injuriesLimited investigationFinal reportCessna 170 · Durango, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A factor was the high density altitude and the high vegetation (sagebrush).Jun 22, 1999 · N4163V · Substantial damage NTSB DEN91LA038Accident · No injuriesLimited investigationFinal reportCessna 170A · Holly, COThe pilot's failure to maintain directional control. Factors were: a gusty crosswind condition and the pilot's lack of familiarity with the aircraft.Feb 2, 1991 · N1437D · Substantial damage NTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.Jun 3, 1990 · N3944V · Substantial damage NTSB DEN90LA096Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COThe pilot's failure to maintain directional control of the airplane during the landing. The crosswind condition was a factor related to the accident.Apr 22, 1990 · N8074A · Substantial damage NTSB DEN87LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COAn 85 hour private plt was flying for proficiency in his Cessna 170. At the last landing of the flt, an apparently normal touchdown was completed. During the landing roll, the acft swerved to the left and the plt corrected to the right. The acft continued to…Apr 3, 1987 · N2323D · Substantial damage NTSB DEN86LA240Accident · No injuriesLimited investigationFinal reportCessna 170B · Greeley, COPlt was ferrying acft from glenwood springs, CO to troy, MO. Acft was out of annual (3-84) and a special airworthiness certificate was issued. Plt likewise had not flown for 2 years. Plt accomplished the mandatory biennial flight review the day before the…Aug 23, 1986 · N2790D · Substantial damage NTSB DEN83LA023Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Durango, COThe pilot landed at a private airstrip and lost control of aircraft in a crosswind. The aircraft departed the runway and collided with a ditch. The pilot believed he lost control of his aircraft because of the wet runway and strong crosswind.Nov 11, 1982 · N9164A · Substantial damage NTSB DEN81DTE43Accident · No injuriesClosedCessna 170 · Monte Vista, COJun 5, 1981 · N1618D · Substantial damage NTSB DEN78FTE37Accident · No injuriesClosedCessna 170B · Idalia, COMar 9, 1978 · N3187B · Substantial damage NTSB DEN73DTE56Accident · Minor injuriesClosedGlobe GC-1B · Silt, COFeb 18, 1973 · N78116 · Substantial damage NTSB DEN73DTE35Accident · No injuriesClosedCessna 170B · Woodrow, COOct 29, 1972 · N8251A · Substantial damage NTSB DEN69D0051Accident · No injuriesClosedCessna 170A · Grand Junctn, COJan 25, 1968 · N9077A · Substantial damage NTSB DEN67D0032Accident · No injuriesClosedCessna 170 · Uravan, COJul 4, 1966 · N1924C · Substantial damage NTSB DEN66D0348Accident · Minor injuriesClosedCessna 170B · Otis, COMay 22, 1966 · N2783D · Substantial damage NTSB DEN66F0243Accident · No injuriesClosedCessna 170 · Aurora, COJan 11, 1966 · N4151V · Substantial damage NTSB DEN66F0004Accident · No injuriesClosedAeronca 15AC · Loveland, COJun 19, 1965 · N1403H · Substantial damage NTSB UNK64X4207Accident · No injuriesClosedCessna 170 · Broomfield, COSep 29, 1964 · N4154V · Substantial damage NTSB UNK64X1974Accident · Minor injuriesClosedCessna 170 · Denver, COMay 27, 1964 · N4189V · Substantial damage NTSB UNK64X1252Accident · No injuriesClosedCessna 170 · Hiwatha, COApr 11, 1964 · N4068V · Substantial damage NTSB UNK64X0538Accident · No injuriesClosedCessna 170B · Broomfield, COFeb 11, 1964 · N1877C · Substantial damage