NTSB investigations: Cessna 172RG, 1982
7 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\") = 1982
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") = 1982
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 NYC83LA031Accident · No injuriesLimited investigationFinal reportCessna 172RG · Middletown, PAAfter landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the…NTSB LAX83IA036Incident · Minor injuriesIncident investigationFinal reportCessna 172RG · Santa Ana, CAWhile cruising at 6500 MSL during a night cross country, the cabin filled with smoke. The pilot declared an emergency and landed after securing all of the electrical equipment. The pilot required hospitalization due to smoke inhalation and an irregular…NTSB ATL82DA272Accident · No injuriesFinal reportCessna 172RG · Prospect, KYThe plt was returning to his departure point due to encountering rough wx. While descending to 4,000 ft for an ILS approach the plt experienced a total electrical failure. The plt elected to descend to VFR conditions & broke out about 100 ft AGL. The plt…NTSB MIA82FKT10Accident · Minor injuriesFinal reportCessna 172RG · Labelle, FLThe pilot and two passengers planned to depart on a flight to spot hogs for hunters. The aircraft was loaded with about 50 gallons of fuel and was near its maximum gross weight. Before takeoff, the pilot noted the wind. He reported that it was light and…NTSB SEA82DA033Accident · No injuriesFinal reportCessna 172RG · Plush, ORThe pilot departed lakeview, Oregon on a local flight with two passengers on board. After a stopover at a private airstrip, he began a short field takeoff from a grass/gravel/dirt runway that was 2500 ft in length. The density altitude was approximately 4600…NTSB NYC82DA042Accident · No injuriesFinal reportCessna 172RG · Palmer, MAThe pilot initiated a takeoff on runway 04. He reported the wind was from 300 to 330 degrees at 10 gusting 25 KTS. During the takeoff roll, a bump in the runway was encountered and the aircraft became airborne. The pilot reported that a gust of wind from the…NTSB CHI82FEE12Accident · No injuriesFinal reportCessna 172RG · Wheeling, ILThe pilot stated that after the aircraft was started and warmed up approximately five to ten minutes the engine was shut down to investigate frozen brake pads. After the brake pads were freed the engine was restarted and during cranking the pilot noticed…