NTSB investigations: Cessna 172RG, TX
13 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
| 1980 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2016 | 1 |
| 2022 | 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\" = 'TX' 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" = 'TX' 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 CEN22LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pearland, TXThe flight instructor's failure to extend the landing gear and perform a before landing checklist.NTSB GAA16CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Stamford, TXThe pilot's failure to maintain clearance from a hangar during taxi for departure.NTSB CEN09CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Brownwood, TXAn in-flight collision with a large bird while on the downwind leg of a traffic pattern.NTSB DFW06CA106Accident · No injuriesData collectionFinal reportCessna 172RG · Bridgeport, TXThe flight instructor's delayed remedial action to regain control of the airplane while landing in a crosswind, and the inadvertent retraction of the landing gear by the pilot receiving instruction while executing a go-around. A factor was the prevailing…NTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA216Accident · No injuriesLimited investigationFinal reportCessna 172RG · Celina, TXThe failure of the pilot in command to use all of the available runway for takeoff.NTSB FTW97LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rio Hondo, TXfailure of the pilot to use all of the available runway during landing, and his resultant failure to attain a proper touchdown point for a safe rollout. Factors relating to the accident were: the wet runway with hydroplaning conditions, the uneven terrain…NTSB FTW95LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Weston, TXThe pilot receiving instruction's failure to maintain clearance with power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. A factor was the instructor's decision to allow the simulation to continue to such a low…NTSB FTW95LA117Accident · No injuriesLimited investigationFinal reportCessna 172RG · Plano, TXThe disengagement of the crankshaft gear due to the loosening of the gear retaining bolt and the subsequent fracture of the gear alignment dowel. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW88FA009Accident · 2 fatalField investigationFinal reportCessna 172RG · Llano, TXThe pilot departed lubbock, Texas in VFR conditions. As the flight progressed the ceiling and visibility deteriorated and the pilot encountered instrument meteorological conditions. No evidence was found to indicate that the pilot obtained a weather briefing…NTSB FTW85LA355Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mineral Wells, TXThe main landing gear colapsed during a touch and go landing. The landing gear warning circuit breaker had popped, and the instructor pilot received no warning that the gear was not fully extended.NTSB FTW83LA077Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Angelo, TXThe acft had reached an alt of 3500 ft MSL when the engine started to lose power. The pilot turned back toward his departure airport. The engine then lost all power and the pilot elected to land in a plowed field with landing gear down. When the acft touched…NTSB FTW80DQG16Accident · No injuriesClosedCessna 172RG · Snyder, TX