NTSB investigations: Cessna R172K, CO
15 cases on aircraft the registry lists as Cessna R172K. 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
| 1978 | 2 |
|---|---|
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2008 | 1 |
| 2016 | 1 |
Where
Open the mapLatest 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.aircraft_model_code IN ('2072431'))
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 ('2072431'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 GAA16CA327Accident · No injuriesData collectionFinal reportCessna R172 · Craig, COThe student pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and the nose wheel impacting the runway edge and substantial damage to the firewall.NTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.NTSB DEN00LA167Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.NTSB DEN00LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Larkspur, COA forced landing on soft unsuitable terrain. Factors were improper wiring of the electric fuel boost pump, which produce high pressure when either on position was selected causing the engine to flood during the practice engine out approach.NTSB FTW96LA256Accident · No injuriesLimited investigationFinal reportCessna R172K · Watkins, COan improper flare by the pilot, which resulted in a hard landing.NTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.NTSB DEN88LA011Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aspen, COThe plt rprtd that the flt was headed northeast toward mt yeckel when the acft encountered wind shear & downdrafts & was forced into trees. Rprtdly, the acft was flying over rising terrain in a canyon area at an elev of about 11,000' when the acdnt occurred.…NTSB DEN85LA178Accident · No injuriesLimited investigationFinal reportCessna R172K · Leadville, CODuring the landing roll on rwy 34, a deer ran in front of the acft. The deer was struck and killed by the right wing strut.NTSB DEN85LA022Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Longmont, COThe pilot stated that he encountered a strong gust of wind from the right and lost directional control. The acft struck the ground with the left wing tip and nose and flipped over.NTSB DEN83FA214Accident · 1 fatalField investigationFinal reportCessna R172K · Silverton, COThe plt departed longmont, CO at about 0520 MDT. At 0617 MDT, he contacted the denver en route flt advisory service & received wx info. The location of the acft at that time was not determined. No further radio communications were received from the plt. A…NTSB DEN83LA085Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe aircraft collided with a snowbank during landing. The pilot stated that he had contacted flt service and asked aboutthe runway conditions. Nothing was reported and no NOTAMS were posted. Upon arrival the pilot tried to contact UNICOM atcolumbine. Someone…NTSB DEN82DA162Accident · No injuriesFinal reportCessna 172XP · 3 Miles Sw Of D, COThe aircraft was cruising at 11000 ft when the engine began to run rough. Attempts to enrich and then lean the mixture, throttle adjustments and switching the fuel tanks did not alleviate the engine roughness. The engine then lost all power. Another plt…NTSB DEN80FTE14Accident · Minor injuriesClosedCessna R172K · Montrose, CONTSB DEN78FTF02Accident · No injuriesClosedCessna 172 · Mancos, CONTSB DEN78FTE25Accident · No injuriesClosedCessna 172 · Idaho Springs, CO