Skip to content

NTSB investigations: Cessna 170B, CO

23 cases on aircraft the registry lists as Cessna 170B. 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.aircraft_model_code IN ('2072306', '2072307')) 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.aircraft_model_code IN ('2072306', '2072307'))
  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.aircraft_model_code IN ('2072306', '2072307'))
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 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 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 DEN86LA013Accident · No injuriesLimited investigationFinal reportCessna 170B · Coloradosprings, COThe pilot took off on runway 17. The wind was reported to be from 130 degrees at 10 knots. After liftoff the left wing rose abruptly and the aircraft veered to the right. The pilot stated that because of his low altitude he could not regain control of the…Oct 23, 1985 · N170CE · Substantial damage NTSB DEN85LA156Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COOn June 15, 1985, a Cessna 170B ground looped during a touch and go landing at contennial arpt, Englewood, CO. The plt said a gust of wing caught him by surprise. The acft departed the runway and flipped over on its back. The plt was not injured.Jun 15, 1985 · N3475D · Substantial damage NTSB DEN80DTE80Accident · No injuriesClosedCessna 170B · Durango, COSep 19, 1980 · N4468B · Substantial damage NTSB DEN78FTE37Accident · No injuriesClosedCessna 170B · Idalia, COMar 9, 1978 · N3187B · Substantial damage NTSB DEN73DTE42Accident · No injuriesClosedCessna 170B · Leadville, COJan 6, 1973 · N8327A · Substantial damage NTSB DEN73DTE35Accident · No injuriesClosedCessna 170B · Woodrow, COOct 29, 1972 · N8251A · Substantial damage NTSB DEN71DXD46Accident · No injuriesClosedCessna 170B · Aspen, COJan 15, 1971 · N3056A · Substantial damage NTSB DEN68D0036Accident · No injuriesClosedCessna 170B · Sterling, COJun 11, 1967 · N2442D · Substantial damage NTSB DEN67D0251Accident · Serious injuriesClosedCessna 170B · Ft.Collins, COApr 10, 1967 · N3521D · Destroyed 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 DEN66D0244Accident · Serious injuriesClosedCessna 170B · Leadville, COFeb 6, 1966 · N3507C · Destroyed NTSB DEN66D0189Accident · No injuriesClosedCessna 170 · Montrose, CONov 30, 1965 · N3517C · Substantial damage NTSB UNK64X3722Accident · Minor injuriesClosedCessna 170 · St Marys Gla, COSep 1, 1964 · N2540C · Substantial damage NTSB UNK64X0538Accident · No injuriesClosedCessna 170B · Broomfield, COFeb 11, 1964 · N1877C · Substantial damage