NTSB investigations: Cessna 172N, 2022
16 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\") = 2022
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") = 2022
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 WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.NTSB ERA22LA392Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Gates Mills, OHThe instructor pilot’s decision to perform an inflight magneto check with no suitable area to land. Contributing to the accident was the pilot's failure to correctly perform a magneto check that resulted in a total loss of engine power.NTSB ERA22LA369Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jamestown, NYA partial loss of engine power for reasons that could not be definitively determined.NTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.NTSB ERA22FA318Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-350P · North Las Vegas, NVThe low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…NTSB CEN22LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Jacksonville, ILThe pilot’s failure to attain proper flare during landing, resulting in a bounced landing.NTSB CEN22LA291Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Minot, NDThe student pilot’s failure to maintain airspeed and yaw control of the airplane during an aborted takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB CEN22LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, INThe student pilot’s improper landing flare and the flight instructor’s delayed remedial response which resulted in an aerodynamic stall.NTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.NTSB ERA22LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Toms River, NJLoss of engine power due to the throttle linkage becoming disconnected in flight due to improper maintenance.NTSB ERA22LA201Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Union, SCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB CEN22LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Englewood, COThe flight instructor’s inadequate supervision of the student pilot and the student pilot’s loss of directional control during landing, which resulted in a runway excursion.NTSB WPR22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tuscon, AZThe loss of directional control during the landing roll, due to missing hardware which resulted in the separation of the nose landing gear torque links.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB ANC22LA024Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Talkeetna, AKThe pilot’s improper positioning of the fuel selector during takeoff, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.