Skip to content

NTSB investigations: Cessna 172K, CO

21 cases on aircraft the registry lists as Cessna 172K. 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

19692026

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 ('2072430')) 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 ('2072430'))
  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 ('2072430'))
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 DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.Jul 31, 2002 · N7383G · Destroyed NTSB DEN02FA017Accident · 1 fatalField investigationFinal reportCessna 172K · Boulder, COthe pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.Jan 5, 2002 · N78035 · Destroyed NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.Jun 21, 2000 · N84105 · Destroyed NTSB FTW97LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Glenwood Spgs, COThe pilot's failure to maintain airplane directional control, and his use of excessive rudder control.Mar 28, 1997 · N7273G · Destroyed 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.Mar 25, 1997 · N686JF · Substantial damage NTSB FTW96LA203Accident · No injuriesLimited investigationFinal reportCessna 172K · Leadville, COthe pilot's failure to adequately compensate for the wind conditions and to maintain directional control. Factors were: the gusting cross wind and the pilot's lack of total experience in make and model of aircraft.May 8, 1996 · N79212 · Substantial damage NTSB DEN89FA083Accident · 4 fatalField investigationFinal reportCraven'S Quickie Q2 · Watkins, COFailure of both pilot's to maintain visual lookout.Mar 8, 1989 · N3278C · 2 aircraft · Destroyed NTSB DEN86LA251Accident · No injuriesLimited investigationFinal reportCessna 172K · Monte Vista, COThe flt departed winslow, AZ, and was en route to erie, CO, when the accident occurred. The plt said he decided to divert to Monte Vista to 'take a break' and visit with his parents who lived nearby. The plt said the winds were light and variable with some…Sep 7, 1986 · N79910 · Substantial damage NTSB DEN83LA061Accident · No injuriesLimited investigationFinal reportCessna 172K · Dove Creek, COThe acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…Feb 15, 1983 · N84631 · Substantial damage NTSB DEN80FTE68Accident · Minor injuriesClosedCessna 172K · Aspen, COAug 5, 1980 · N79208 · Substantial damage NTSB DEN76FTE62Accident · Serious injuriesClosedCessna 172K · Woodland Park, COApr 26, 1976 · N78674 · Substantial damage NTSB DEN74DTE83Accident · Serious injuriesClosedCessna 172 · Pueblo, COMay 8, 1974 · N79470 · No damage NTSB DEN74DTE44Accident · No injuriesClosedCessna 172 · Fort Lupton, COJan 15, 1974 · N84631 · Substantial damage NTSB DEN74FTE35Accident · No injuriesClosedCessna 172G · Broomfield, CODec 29, 1973 · N7128G · Substantial damage NTSB DEN73FTE48Accident · No injuriesClosedCessna 172 · Boulder, COJan 21, 1973 · N686JF · Substantial damage NTSB DEN73DTE17Accident · No injuriesClosedCessna 172K · Glenwood Spg, COAug 10, 1972 · N79529 · Substantial damage NTSB DEN70FXD44Accident · Serious injuriesClosedCessna 172K · Littleton, COJun 28, 1970 · N78677 · Destroyed NTSB DEN70FXD18Accident · Minor injuriesClosedCessna 172 · Hudson, COMar 24, 1970 · N46746 · Substantial damage NTSB DEN70FXD12Accident · Serious injuriesClosedCessna 172K · Otis, COMar 9, 1970 · N78552 · Substantial damage NTSB DEN70A0022Accident · 1 fatalClosedCessna 172 · Walsenburg, COSep 27, 1969 · N78284 · Substantial damage NTSB DEN69D0202Accident · No injuriesClosedCessna 172 · Ft.Carson, COJan 30, 1969 · N46482 · Substantial damage