NTSB investigations: Cessna R172K, 1988
7 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\") = 1988
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") = 1988
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 ANC88LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Chignik, AKDuring the takeoff roll on the beach the pilot lost directional control of the aircraft. The aircraft nosed over on its back.NTSB LAX88LA259Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Corona, CADuring takeoff the engine failed to develop full power & the acft collided with trees located approx 500 ft beyond the runway. Exam of the engine revealed the mixture control arm at its fuel pump housing attachment point had restricted movement & was…NTSB MKC88LA100Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Bismark, MOThe accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as .14 percent…NTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…NTSB MIA88FA179Accident · 1 fatalField investigationFinal reportCessna 172K · Lake City, FLThe acft, while on a local flight, struck a telephone transmission line on the approach end of runway 1. Witnesses stated that they saw the acft takeoff to the west and make a right turn and go out of sight. Aprx three to five minutes later, they heard the…NTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…NTSB SEA88LA071Accident · No injuriesLimited investigationFinal reportCessna 172XP · Walla Walla, WADuring descent for landing the pilot noted a surge coming from the engine area, accompanied by an increase in rpm's. both the oil temperature and the oil pressure gauges were reading zero. The cylinder head temperature had reached 500 degrees and smoke was…