NTSB investigations: Cessna 172R, 2005
13 cases on aircraft the registry lists as Cessna 172R. 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
| 1998 | 2 |
|---|---|
| 1999 | 12 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 8 |
| 2004 | 9 |
| 2005 | 13 |
| 2006 | 7 |
| 2007 | 18 |
| 2008 | 12 |
| 2009 | 4 |
| 2010 | 6 |
| 2011 | 12 |
| 2012 | 10 |
| 2013 | 5 |
| 2014 | 10 |
| 2015 | 5 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 10 |
| 2019 | 8 |
| 2020 | 6 |
| 2021 | 8 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 6 |
| 2025 | 4 |
| 2026 | 3 |
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\") = 2005
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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") = 2005
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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 CHI06CA053Accident · No injuriesData collectionFinal reportCessna 172R · Morris, ILThe pilot's improper in-flight decision to land with a quartering tailwind and not maintaining directional control. Factors were the quartering tailwind and the snowdrift.NTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB DFW06CA004Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe pilot's failure to maintain directional control while landing.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB LAX05CA207Accident · No injuriesData collectionFinal reportCessna 172R · Santa Maria, CAthe student pilot's improper flare and recovery from a bounced landing.NTSB MIA05CA120Accident · No injuriesData collectionFinal reportCessna 172R · Fort Myers, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Louisburg, NCThe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.NTSB ATL05CA088Accident · No injuriesData collectionFinal reportCessna 172 · Raleigh, NCThe pilot's failure to maintain adequate obstacle clearance during initial climb, which resulted in an in-flight collision with treesNTSB NYC05FA075Accident · 2 fatalField investigationFinal reportCessna 172R · Armonk, NYThe flight instructor's failure to maintain the proper altitude\clearance during the approach, which resulted in an in-flight collision with trees. Factors in this accident were low ceilings, fog, and gusty wind conditions.NTSB CHI05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Kalamazoo, MIThe pilot's failure to maintain directional control and the excessive taxispeed.NTSB IAD05LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Frederick, MDThe inadequate visual lookout of the pilots in each airplane, which resulted in a ground collision.NTSB MIA05CA065Accident · No injuriesData collectionFinal reportCessna 172 · Madison, MSThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.