NTSB investigations: Cessna 172RG, 1985
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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1979 | 2 |
| 1980 | 3 |
| 1981 | 11 |
| 1982 | 7 |
| 1983 | 10 |
| 1984 | 11 |
| 1985 | 13 |
| 1986 | 3 |
| 1987 | 10 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 8 |
| 1992 | 8 |
| 1993 | 6 |
| 1994 | 12 |
| 1995 | 8 |
| 1996 | 8 |
| 1997 | 8 |
| 1998 | 5 |
| 1999 | 7 |
| 2000 | 2 |
| 2001 | 11 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 6 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 3 |
| 2008 | 10 |
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 DEN86LA055Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NMAccording to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about…NTSB NYC86LA046Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Mt. Lafayette, NHThe acft, while in cruise flt en route to lyndonville, VT, encountered a severed downdraft and the plt was unable to penetrate or climb out of the descent. The acft continued to descend until impact with a mountain occurred. The acft contacted the terrain at…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 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 MKC85LA188Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lee'S Summit, MOThe plt reported that the eng start & run-up were normal before he took off on a night currency & proficiency flt. After 2 normal takeoffs & full stops, he made a 3rd takeoff. He climbed to 1000 ft AGL on a x-wind leg, reduced power to 20' manifold pressure &…NTSB MIA85FA227Accident · 2 fatalField investigationFinal reportCessna 172RG · Cedar Key, FLThe manager of the destination arpt said the plt had called earlier in the evening & had asked to be picked up at the arpt. The plt said that he would fly over the manager's house after he arrived. The manager heard the acft fly over from east to west.…NTSB DEN85LA205Accident · No injuriesLimited investigationFinal reportCessna 172RG · Evanston, WYThe plt lost direstional control of the acft while attempting to land in gusty x-wind conditions. The acft was destroyedwhen it impacted terrain in a 50 ft deep ravine.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 MKC85FCQ03Accident · 1 fatalFinal reportCessna 172RG · Wichita, KSThe acft collided with a cushman scooter during taxi. A witness stated that when the scooter driver 'looked up' I saw the acft taxiing, he made a hard rt turn which threw him off. The scooter driver and scooter were struck separately by the acft. The scooter…NTSB CHI85LA142Accident · No injuriesLimited investigationFinal reportCessna 172RG · Portland, INUpon landing the nose gear was down & locked, but both main gear collapsed. The plt was not certain if a down & locked indication was received before touchdown. During a gear retraction/extension test after the accident, the gear operated normally. Also, the…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 CHI85LA105Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILThe private plt & his instructor were practicing instrument approaches. The instructor stated that the fuel gages were reading low & the VOR needle was oscillating, so they decided to make a straight-in landing. He stated that they lowered the gear & flaps,…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…