NTSB investigations: Cessna R172K, 1986
6 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\") = 1986
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") = 1986
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 FTW87FA031Accident · 2 fatalField investigationFinal reportCessna 172K · El Reno, OKPrivate pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…NTSB MKC87LA024Accident · No injuriesLimited investigationFinal reportCessna 177XP · Camden, ARThe pilot stated he was on approach during IMC and had the airport in sight when he flew into another cloud and had started a missed approach when he collided with a tree. He completed the missed approach and diverted to monroe, LA.NTSB NYC87FA023Accident · 1 fatalField investigationFinal reportCessna R172K · Rockwood, TNThe aircraft was observed departing at approx 2010 hours, reversing course and flying over the airport at 300-400 ft AGL. The aircraft crashed 3/4 miles south of the airport in unpopulated, mountainous/hilly terrain at an elevation of 1560 feet, which is 104…NTSB FTW86LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Waco, TXThe pilot of a Cessna 172, N758KU, over-shot his approach to a privately owned grass strip. The runway is 05/23, 3180 foot long and 100 foot wide with an approximate 300 ft. displaced threshold at east end. The wind was variable from 300 degrees at 8 knots at…NTSB SEA86FA053Accident · 1 fatalField investigationFinal reportCessna 172XP · Napa, CABefore taking off, the plt appeared to have difficulty following taxi instructions. He then took off without clearance against crossing traffic. When he returned to land, he was cleared for rgt traffic to rwy 18. The acft entered a left downwind for rwy 24…NTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…