NTSB investigations: Cessna 172RG, 1984
11 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
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 year(c.\"eventDate\") = 1984
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") = 1984
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 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 NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.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 LAX84LA364Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lee Vining, CAThe plt reported that after entering tioga pass, he made a left turn to follow the center of the pass & the acft began to sink. He applied full power & went to the best angle of climb speed, but was unable to stop the sink. The acft then hit an electrical…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 CHI84FA169Accident · 4 fatalField investigationFinal reportCessna 172RG · Woodbury, MNThe acft collided with a radio antenna support cable at aprx 171 ft AGL during low altitude maneuvering in snow showers. One witness stated that the heaviest snow showers were in the vicinity of the accident site. A policeman saw the acft over a field near…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.NTSB ATL84FA095Accident · 1 fatalField investigationFinal reportCessna 172RG · Chesapeake, VAPrior to departure, the plt was twice advised that the destination wx was below most users minimums. The non-instrument rated plt then departed dulles arpt on an IFR flt plan in IMC. After departure, he did not follow assigned headings, & for a period of…NTSB SEA84LA051Accident · No injuriesLimited investigationFinal reportCessna 172 Rgii · Seattle, WADuring a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft…NTSB NYC84LA080Accident · No injuriesLimited investigationFinal reportCessna 172RG · Marietta, PAThe acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over.NTSB ANC84LA029Accident · No injuriesLimited investigationFinal reportCessna 172RG · Big Lake, AKThe dual student and instructor were practicing emergency procedures. During the turn onto final approach the left main landing gear and left wing struck a snowbank. Flying club procedures state that no emergency practice procedure will be conducted below 500…