NTSB investigations: Cessna 172RG
21 cases on aircraft the registry lists as Cessna 172RG, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 2 |
|---|---|
| 1985 | 4 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.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 IAD02LA084Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · West Milford, NJThe private pilot's excessive rotation and the flight instructor's delayed remedial action.NTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.NTSB LAX98LA226Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Manuel, AZThe failure of the certified flight instructor to maintain directional control while landing with a sudden windshift.NTSB MIA98LA146Accident · No injuriesLimited investigationFinal reportCessna 172RG · Greenville, SCThe pilot's use of full flaps while landing in a strong crosswind resulting in loss of directional control during the landing roll.NTSB NYC95LA213Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Meriden, CTthe pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.NTSB CHI94LA099Accident · No injuriesLimited investigationFinal reportCessna 172RG · Frankfort, MIThe failure of the pilot-in-command to maintain directional control. The snow covered runway was a factor.NTSB MIA92FA118Accident · Serious injuriesField investigationFinal reportCessna 172RG · Cedar Key, FLImproper recovery from the bounced landing by the pilot-in-command, and failure to maintain directional control. Contributing to the accident was the crosswind.NTSB LAX91LA285Accident · Minor injuriesLimited investigationFinal reportCessna 172RG/A · Vacaville, CAThe private pilot PIC failed to maintain directional control during landing rollout. The CFI pilot failed to take remedial action.NTSB CHI90LA111Accident · No injuriesLimited investigationFinal reportCessna 172RG · Romeoville, ILThe failure of the instructor to correct a loss of directional control during a landing roll in a timely manner.NTSB DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.NTSB NYC88LA139Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chester, PAThe pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…NTSB ANC86LA131Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Kotlik, AKThe pilot stated on approach he spotted what appeared to be the airport from several miles off. Instead of landing at the airport, he landed at a gravel bar. After touchdown the pilot lost control of the aircraft and the aircraft nosed over on its back.NTSB CHI86LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · East Liverpool, OHAccording to the plt, he was unable to stop the acft at the end of the taxiway after he had taxied through water. The acft came to rest after sliding into a drainage ditch at the end of the taxiway. The plt continued the flt although the acft was damaged. The…NTSB LAX85LA271Accident · No injuriesLimited investigationFinal reportCessna 172RG · Upland, CAThe plt stated that on the flt prior to the accident he felt a slight pull to the right as he applied brakes. On the next flt he touched down normally, lowered the nose and lightly applied brakes. The pull to the right was more severe this time. He applied…NTSB CHI85LA112Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pontiac, MIThe acft slid into a snowbank at the end of a lndg roll on an icy rwy with a x-wind. The plt said that he did not use brakes because of the icy condition of the rwy. The x-wind weathervaned the acft to the left and into the snow alongside the rwy.NTSB LAX85LA096Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe plt reported that upon landing a strong gust of wind caused the acft to deviate to the left. Application of the appropriate flight controls did not arrest the deviation. Brakes were applied but not in time to prevent the acft from exiting the rwy. The…NTSB LAX85LA021Accident · No injuriesLimited investigationFinal reportCessna 172RG · El Monte, CAThe plt landed the acft fast & lost control. Subsequently, the acft went off the right side of the rwy & struck a perimeter fence.NTSB SEA84LA059Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Grangeville, IDThe acft ground looped during landing on an icy rwy and nosed over after leaving the rwy. The landing was made with a right quartering tailwind.