NTSB investigations: Cessna 172RG
24 cases on aircraft the registry lists as Cessna 172RG, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1988 | 3 |
| 1990 | 2 |
| 1991 | 1 |
| 1994 | 5 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2002 | 1 |
| 2005 | 2 |
| 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\" = 250))
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" = 250))
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 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 LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.NTSB LAX05LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot-in-command's failure to properly lean the mixture, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush condition while departing during high density…NTSB CHI02FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Marthasville, MOThe inadequate supervision and the stall encountered by the certified flight instructor.NTSB MIA98LA142Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe inadvertent stall of the airplane and inadequate supervision of the student by the CFI-PIC while performing a soft field takeoff.NTSB SEA97LA214Accident · No injuriesLimited investigationFinal reportCessna 172RG · Monroe, WAThe failure of the flight instructor to adequately perform remedial action, and her failure to abort the takeoff. Factors contributing to the accident include the premature rotation of the airplane by the dual student, the failure of the dual student to…NTSB FTW97FA181Accident · 1 fatalField investigationFinal reportCessna 172RG · Intracoastal, LAthe pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.NTSB NYC96FA094Accident · 2 fatalField investigationFinal reportCessna 172RG · Duanesburg, NYfailure of the pilot to attain adequate airspeed (or abort the takeoff while there was sufficient runway remaining), which resulted in a stall after liftoff and collision with the terrain. A factor relating to the accident was: the pilot's distraction due to…NTSB CHI94LA325Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chicago, ILthe pilot-in-command (CFI)'s inadequate supervision. Factors were the abrupt flare by the dual student.NTSB LAX94FA353Accident · 4 fatalField investigationFinal reportCessna 172RG · Truckee, CAFailure of the pilot to obtain/maintain adequate airspeed to climb after takeoff, which resulted in a stall and subsequent collision with the ground. Factors related to the accident were: high density altitude, improper trim setting for takeoff, the…NTSB ATL94FA156Accident · 2 fatalField investigationFinal reportCessna 172RG · Atlanta, GAThe pilot's inadequate preflight planning in that he operated the aircraft at a weight which exceeded the maximum takeoff weight and his improper use of flaps during takeoff.NTSB NYC94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Pittstown, NJThe pilot's premature lift off and failure to attain adequate airspeed.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 MIA92FA053Accident · Serious injuriesField investigationFinal reportCessna 172RG · Melbourne, FLThe flight instructor pilot in command's failure to maintain airspeed while demonstrating a power off approach to the student and his improper retraction of the wing flaps during go around from the approach resulting in an inadvertent stall and inflight loss…NTSB BFO90DID01Accident · 2 fatalFinal reportCessna 172RG · Onancock, VAThe inflight loss of control because the pilot experienced spatial disorientation. Other factors related to the accident are VFR flight into IMC, night conditions.NTSB DEN90LA116Accident · No injuriesLimited investigationFinal reportCessna 172RG · Albuquerque, NMThe cfi's improper procedures during takeoff. Factors were premature liftoff and inadvertent stall/mush.NTSB NYC89LA023Accident · No injuriesLimited investigationFinal reportCessna 172RG · Robbinsville, NJFailure of the pilot to adequately correct for the crosswind and maintain control of the aircraft during a crosswind landing.NTSB BFO88LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mathew, VAThe plt stated he did a soft field takeoff using 10 degs of flaps. The acft lifted off at about 55 to 60 KTS but according to the plt, was unable to climb out of groundeffect. Since he was too FAR down the rwy to abort the takeoff the plt increased pitch to…NTSB LAX88LA141Accident · No injuriesLimited investigationFinal reportCessna 172RG · Malibu, CAThe pilot stated that the purpose of the flight was to allow the passenger to photograph some yachts sailing off the Malibu coast. The pilot said that he initiated a turn at 300 feet AGL around one of the yachts and the aircraft 'suddenly stalled' and he was…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 ATL84FA168Accident · 2 fatalField investigationFinal reportCessna 172RG · Dallas, GAApproximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…NTSB MKC83LA099Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Newton, KSThe aircraft crashed alongside the runway during an attempted go-around. The runway in use was 17 and the wind was from 250 degrees at 15 KTS gusting to 24 KTS. The pilot stated he could not get aligned with the runway so he retracted the landing gear and…NTSB LAX83LA102Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wenden, AZThe acft drifted off the runway into a plowed area of a private airstrip during landing and nosed over. The private pilot reported that as he began to flare the acft for landing to the west a gust of wind from the north caused the acft to drift southward. The…