NTSB investigations: Cessna R172K, 1983
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\") = 1983
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") = 1983
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 DEN83FA214Accident · 1 fatalField investigationFinal reportCessna R172K · Silverton, COThe plt departed longmont, CO at about 0520 MDT. At 0617 MDT, he contacted the denver en route flt advisory service & received wx info. The location of the acft at that time was not determined. No further radio communications were received from the plt. A…NTSB NYC83IA182Incident · No injuriesIncident investigationFinal reportCessna 172XP · Mechanicville, NYAfter starting the engine and taxiing forward the pilot stated he pushed the trottle by mistake and the acft moved rapidy forward and struck a parked acft.NTSB LAX83LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wickenburg, AZThe acft left the runway during landing and collided with a ditch which collapsed the right main gear and nose gear. Thepilot noted during final approach that the windsock did not indicate a cross-wind. The landing was made with 10 degrees of flaps. According…NTSB LAX83LA225Accident · No injuriesLimited investigationFinal reportCessna R172K · Huntington Bch, CAAfter returning from a sight-seeing flt to catalina island, the plt made an apch to rwy 19. The apch was high, so he went around. He landed on the 2nd apch, but the acft bounced, so he went around again. On the 3rd apch, he used 30 deg of flaps & had an…NTSB DEN83LA085Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe aircraft collided with a snowbank during landing. The pilot stated that he had contacted flt service and asked aboutthe runway conditions. Nothing was reported and no NOTAMS were posted. Upon arrival the pilot tried to contact UNICOM atcolumbine. Someone…NTSB ATL83LA114Accident · No injuriesLimited investigationFinal reportCessna 172K · Scottsboro, ALThe acft was damaged in a hard landing. The plt did not believe the acft was substantially damaged and has disagreed with filing an accident report. Examination of the acft by a mechinic showed a partially collapsed nose gear buckled firewall and deformed…NTSB LAX83LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · San Martin, CAThe acft made a hard landing short of the runway while practicing an approach with a simulated engine failure. On turning final, the instructor decided the acft was too low to make the runway. She estimated they would be several hundred feet short. She took…