NTSB investigations: Cessna 172N, 2014
15 cases on aircraft the registry lists as Cessna 172N. 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 | 2 |
| 1967 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 26 |
| 1978 | 62 |
| 1979 | 81 |
| 1980 | 107 |
| 1981 | 86 |
| 1982 | 91 |
| 1983 | 53 |
| 1984 | 55 |
| 1985 | 40 |
| 1986 | 44 |
| 1987 | 42 |
| 1988 | 47 |
| 1989 | 45 |
| 1990 | 46 |
| 1991 | 57 |
| 1992 | 40 |
| 1993 | 51 |
| 1994 | 43 |
| 1995 | 48 |
| 1996 | 37 |
| 1997 | 40 |
| 1998 | 37 |
| 1999 | 46 |
| 2000 | 35 |
| 2001 | 32 |
| 2002 | 43 |
| 2003 | 32 |
| 2004 | 38 |
| 2005 | 26 |
| 2006 | 23 |
| 2007 | 21 |
| 2008 | 21 |
| 2009 | 20 |
| 2010 | 23 |
| 2011 | 22 |
| 2012 | 14 |
| 2013 | 20 |
| 2014 | 15 |
| 2015 | 10 |
| 2016 | 24 |
| 2017 | 19 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 25 |
| 2021 | 15 |
| 2022 | 16 |
| 2023 | 20 |
| 2024 | 13 |
| 2025 | 15 |
| 2026 | 11 |
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\") = 2014
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
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") = 2014
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
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 WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.NTSB CEN14FA435Accident · 1 fatalField investigationFinal reportCessna 172N · Natchitoches, LAThe partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…NTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…NTSB ERA14LA346Accident · 1 fatalLimited investigationFinal reportCessna 172N · Elliott Key, FLThe airplane’s vertical descent into water for reasons that could not be determined because postaccident airplane examinations revealed no mechanical anomalies.NTSB CEN14LA374Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockville, INA partial loss of engine power due to a failure of the dual magneto system. Contributing to the accident was the improper maintenance of the duel magneto system.NTSB CEN14CA457Accident · No injuriesData collectionFinal reportCessna 172N · Murphysboro, ILA hard landing by person(s) unknown.NTSB CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.NTSB ERA14CA334Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's inadvertent encounter with an unanticipated convective gust front or low-level wind shear while landing, which resulted in a loss of control and subsequent hard landing.NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB CEN14LA276Accident · No injuriesLimited investigationFinal reportCessna 172N · Padre Island, TXThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.NTSB ERA14CA160Accident · No injuriesData collectionFinal reportCessna 172N · Charlottesville, VAThe pilot's inadequate landing flare, which resulted in a bounced landing and substantial damage to the firewall.NTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.NTSB CEN14CA123Accident · Minor injuriesData collectionFinal reportCessna 172N · Boulder, COThe pilot's failure to maintain airplane control during final approach with known turbulence present.NTSB WPR14LA099Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · San Jose, CAThe pilot’s failure to sump the fuel tanks, which resulted in water contamination, a partial loss of engine power during takeoff, and collision with a taxiing airplane during the subsequent forced landing.