NTSB investigations: Cessna 172RG, 1989
8 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\") = 1989
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") = 1989
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 CHI90DEE04Accident · No injuriesFinal reportCessna 172RG · Romeoville, ILDual student's inadequate compensation for wind conditions and remedial action not attained by the CFI. A factor related to the accident was: a snow bank adjacent the runway.NTSB DEN90FA017Accident · 1 fatalField investigationFinal reportCessna 172RG · Laramie, WYThe loss of control of the airplane in instrument meteorological conditions after the pilot became spatially disoriented. Contributing to the accident was the failure of the vacuum system which rendered the vacuum/gyro instruments inoperative. Also…NTSB NYC89FA135Accident · 2 fatalField investigationFinal reportCessna 172M · Bradford, VTFailure of the rated pilots in both aircraft to see and avoid a midair collison.NTSB ATL89LA124Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miamisburg, OHIntermittant grounding of an electrical wire to the nose landing gear. The chafed wire resulted in the opening of the landing gear motor circuit breaker preventing full extension of the left main landing gear. A secondary failure of the throttle warning…NTSB NYC89LA087Accident · No injuriesLimited investigationFinal reportCessna 172RG · Durhamville, NYFailure of the pilot to extend the landing gear before landing after allowing his attention to be diverted.NTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.NTSB DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.NTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…