NTSB investigations: Cessna 172RG, CO
15 cases on aircraft the registry lists as Cessna 172RG. 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
| 1981 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2001 | 2 |
| 2005 | 1 |
| 2011 | 1 |
| 2017 | 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 ('2072438'))
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 ('2072438'))
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 CEN17IA155Incident · No injuriesIncident investigationFinal reportCessna 172RG · Greeley, COFailure of the left main landing gear actuator assembly, which resulted in an inability to extend the left main landing gear.NTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.NTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…NTSB DEN01LA164Accident · No injuriesLimited investigationFinal reportCessna 172RG · Englewood, COthe failure of the dual student to verify that the landing gear was down and locked, and the failure of the flight instructor to adequately supervise the dual student.NTSB DEN01LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Gunnison, COthe pilot's failure to attain the proper climb rate, and his improper inflight planning/decision to attempt to cross mountainous terrain at an inadequate altitude. Contributing factors were the downdraft and the pilot's total lack of experience in mountain…NTSB FTW96LA238Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Leadville, COInadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…NTSB FTW96FA012Accident · 3 fatalField investigationFinal reportCessna 172RG · Bayfield, COThe pilot's failure to maintain adequate terrain clearance. A factor was the pilot diverting attention while looking for game.NTSB FTW94LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Englewood, COAn inadvertent stall. Factors were the airplane's maximum gross weight and climb capability were exceeded, and a high density altitude.NTSB FTW93LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Salida, COThe climb capability of the airplane being exceeded and the pilot's decision to turn into the rising terrain. A factor was the high density altitude.NTSB DEN92FA077Accident · 1 fatalField investigationFinal reportCessna 172RG · Fairplay, COThe flight instructor's operation at an altitude insufficient to clear obstacles in rising mountainous terrain. Factors were: high density altitude, diversion of the instructor's attention, and the rising terrain.NTSB DEN92LA047Accident · No injuriesLimited investigationFinal reportCessna 172RG · Elbert, COFailure of the crankshaft left accessory gear which resulted in a complete power loss. A factor was: lack of suitable terrain for a forced landing.NTSB DEN92IA014Incident · No injuriesIncident investigationFinal reportCessna 172RG · Broomfield, COFailure of the left main landing gear pivot assembly due to ductile torsional overstress.NTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.NTSB DEN84FA196Accident · 3 fatalField investigationFinal reportCessna 172RG · Red Feather Lak, COAcft departed downwind into rising terrain with density altitude calculated to be 10,935 ft. acft was observed to mush into rising terrain 300 ft higher than and 3 mi west of the rwy.NTSB DEN81FTE67Accident · Minor injuriesClosedCessna 172RG · Walden, CO