NTSB investigations: Cessna 172M, 2017
19 cases on aircraft the registry lists as Cessna 172M. 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
| 1972 | 3 |
|---|---|
| 1973 | 24 |
| 1974 | 59 |
| 1975 | 82 |
| 1976 | 104 |
| 1977 | 99 |
| 1978 | 92 |
| 1979 | 80 |
| 1980 | 59 |
| 1981 | 50 |
| 1982 | 53 |
| 1983 | 34 |
| 1984 | 35 |
| 1985 | 34 |
| 1986 | 38 |
| 1987 | 29 |
| 1988 | 28 |
| 1989 | 38 |
| 1990 | 37 |
| 1991 | 36 |
| 1992 | 31 |
| 1993 | 37 |
| 1994 | 24 |
| 1995 | 29 |
| 1996 | 23 |
| 1997 | 35 |
| 1998 | 30 |
| 1999 | 22 |
| 2000 | 22 |
| 2001 | 30 |
| 2002 | 26 |
| 2003 | 24 |
| 2004 | 18 |
| 2005 | 16 |
| 2006 | 18 |
| 2007 | 16 |
| 2008 | 24 |
| 2009 | 14 |
| 2010 | 15 |
| 2011 | 13 |
| 2012 | 18 |
| 2013 | 20 |
| 2014 | 20 |
| 2015 | 9 |
| 2016 | 10 |
| 2017 | 19 |
| 2018 | 14 |
| 2019 | 13 |
| 2020 | 16 |
| 2021 | 8 |
| 2022 | 24 |
| 2023 | 12 |
| 2024 | 14 |
| 2025 | 12 |
| 2026 | 8 |
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\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
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") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
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 WPR18FA063Accident · 2 fatalField investigationFinal reportCessna 172M · Ogden, UTThe pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.NTSB GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.NTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.NTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA17FA272Accident · 1 fatalField investigationFinal reportCessna 172 · New Milford, CTThe flight instructor's failure to ensure that the wing flaps were properly configured for takeoff, which resulted in an aerodynamic stall and loss of control during the initial climb.NTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…NTSB GAA17CA448Accident · No injuriesData collectionFinal reportCessna 172 · Manassas, VAThe student pilot’s improper landing flare, which resulted in a porpoised landing.NTSB GAA17CA394Accident · No injuriesData collectionFinal reportCessna 172 · TamuningThe pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA17CA341Accident · No injuriesData collectionFinal reportCessna 172 · Galena, IDThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.NTSB ERA17LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Suffolk, NYA loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.NTSB GAA17CA318Accident · Minor injuriesData collectionFinal reportCessna 172 · Payson, AZThe pilot’s inadequate preflight planning that did not account for high-density altitude conditions and his subsequent attempted go-around in conditions that prevented the airplane from attaining a positive climb rate and resulted in its subsequent descent…NTSB GAA17CA254Accident · No injuriesData collectionFinal reportCessna 172 · Columbia, KYThe pilot’s failure to maintain a flare during landing in variable, gusting wind conditions.NTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.NTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.NTSB GAA17CA140Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, NCThe pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.NTSB CEN17LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hobart, INThe pilot's failure to abort the landing when he recognized the airplane was traveling too fast, which resulted in impact with trees off the end of the runway.