NTSB investigations: Cessna 172RG, 1987
10 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\") = 1987
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") = 1987
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 DEN88FA023Accident · 3 fatalField investigationFinal reportCessna 172RG · Pintura, UTBfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…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 LAX88FA001Accident · 1 fatalField investigationFinal reportCessna 172RG · Calistoga, CAUpon arriving over the destination arpt the plt used an incorrect CTAF frequency to contact the arpt and he used a right hand traffic pattern approaching the 2600 foot-long rwy. Because a residential area lay west of the arpt & open fields lay to the east,…NTSB CHI87LA220Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pinckneyville, ILAccording to the instructor (CFI), he & the student confirmed the gear was extended & locked as they entered the traffic pattern. Flaps were extended & they contd in the pattern to practice a short field landing technique. Power was reduced after crossing…NTSB SEA87FA166Accident · 1 fatalField investigationFinal reportCessna 172RG · Kettle Falls, WAWhile on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.NTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.NTSB ATL87LA145Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Ozark, ALThe inst plt indicated that during airwork procedures practice in the LCL area, the right wing seemed to be heavy. He indicated that he switched the fuel selector from both to right tank. After about 20-30 minutes, they returned to the airport and entered…NTSB CHI87LA086Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Camp Douglas, WIThe passenger rprtd that about 5 min after takeoff, the plt became incapacitated & was no longer able to maintain control of the acft. The non-certificated passenger assumed control. With the assistance (instructions) from an airborne flt instructor & an…NTSB LAX87LA118Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · San Diego, CADuring a local pleasure flight, the pilot returned to the airport to practice touch-and-go landings. On take-off, ascending through 200 feet, the engine began to surge then quit. The pilot made a forced landing on an occupied road where the aircraft collided…