NTSB investigations: Cessna R172K, 1987
4 cases on aircraft the registry lists as Cessna R172K. 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
| 1964 | 1 |
|---|---|
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 16 |
| 1979 | 10 |
| 1980 | 12 |
| 1981 | 6 |
| 1982 | 10 |
| 1983 | 7 |
| 1984 | 5 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 12 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 6 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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 ('2072431'))
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 ('2072431'))
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 FTW88LA041Accident · No injuriesLimited investigationFinal reportCessna 172XP · Godley, TXDuring a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…NTSB DEN88LA011Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aspen, COThe plt rprtd that the flt was headed northeast toward mt yeckel when the acft encountered wind shear & downdrafts & was forced into trees. Rprtdly, the acft was flying over rising terrain in a canyon area at an elev of about 11,000' when the acdnt occurred.…NTSB NYC87DNC08Accident · 1 fatalFinal reportCessna R172K · Cantebury, NHA local CFI heard the plt transmit over the UNICOM freq that he was 'north of the airport at 1100 ft & out of gas, so I guess I'm going to crash.' Attempts to contact the plt were unsuccessful. The CFI flew north of the airport & located the plane where it…NTSB CHI87LA116Accident · No injuriesLimited investigationFinal reportCessna 172XP · Superior, WIUpon landing on runway 13, pilot reports wind blowing aircraft towards the edge of runway. Aircraft went off right side, nose wheel stuck in mud and collapsed, and aircraft nosed over. Winds at duluth, MN, approx. 11 nmi northwest of accident site, were…