NTSB investigations: Cessna 172S, 2006
25 cases on aircraft the registry lists as Cessna 172S. 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
| 1967 | 2 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1979 | 3 |
| 1987 | 1 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 20 |
| 2002 | 22 |
| 2003 | 29 |
| 2004 | 27 |
| 2005 | 28 |
| 2006 | 25 |
| 2007 | 26 |
| 2008 | 31 |
| 2009 | 22 |
| 2010 | 27 |
| 2011 | 20 |
| 2012 | 29 |
| 2013 | 24 |
| 2014 | 18 |
| 2015 | 18 |
| 2016 | 29 |
| 2017 | 24 |
| 2018 | 22 |
| 2019 | 23 |
| 2020 | 18 |
| 2021 | 22 |
| 2022 | 9 |
| 2023 | 13 |
| 2024 | 14 |
| 2025 | 18 |
| 2026 | 14 |
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\") = 2006
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442'))
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") = 2006
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442'))
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 DFW07CA048Accident · No injuriesData collectionFinal reportCessna 172S · Spicewood, TXThe pilot's failure to compensate for the existing wind conditions resulting in a loss of directional control. Factors were the gusty crosswind and the muddy terrain.NTSB DFW07LA056Accident · No injuriesLimited investigationFinal reportCessna 172S · Tulsa, OKThe pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.NTSB CHI07CA027Accident · Serious injuriesData collectionFinal reportCessna 172S · Warroad, MNThe propeller striking the individual who was positioning the propeller in anticipation of hand-propping the engine.NTSB MIA07CA019Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna, FLThe student pilot's improper recovery from a bounced landing.NTSB DFW07FA019Accident · 2 fatalField investigationFinal reportCessna 172S · Hominy, OKThe pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.NTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…NTSB MIA07CA008Accident · No injuriesData collectionFinal reportCessna 172S · Ormond Beach, FLThe failure of the student pilot to initiate a recovery from the bounced landing resulting in a hard landing.NTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.NTSB SEA06CA187Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's failure to adequately compensate for wind conditions during the landing roll. A drainage ditch and wind were contributing factors.NTSB ANC06CA114Accident · No injuriesData collectionFinal reportCessna 172 · Palatka, FLThe student's failure to maintain adequate airspeed to preclude a stall while maneuvering over the runway, and the instructor's inadequate supervision of the student pilot, which resulted in a collision with the runway. A factor in the accident was an…NTSB ATL06CA117Accident · No injuriesData collectionFinal reportCessna 172S · Thomson, GAThe student pilot's failure to maintain directional control during the landing roll resulting in an on-ground collision with an embankment.NTSB CHI06CA183Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, OHThe pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.NTSB NYC06CA159Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's misjudged speed/distance which resulted in an overrun.NTSB NYC06IA143Incident · No injuriesIncident investigationFinal reportCessna 172S · Lawrence, MAForeign object damage to the leading edge of the propeller blade, which resulted in fatigue cracking and subsequent blade failure.NTSB MIA06IA110Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Augustine, FLThe loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.NTSB LAX06CA174Accident · No injuriesData collectionFinal reportCessna 172S · Madera, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB NYC06CA116Accident · No injuriesData collectionFinal reportCessna 172S · Louisville, KYThe student pilot's failure to maintain directional control during the takeoff roll.NTSB ATL06CA075Accident · No injuriesData collectionFinal reportCessna C172S · Muscle Shoals, ALThe student pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB SEA06CA081Accident · No injuriesData collectionFinal reportCessna 172 S · Malad City, IDThe private pilot's improper touchdown point during landing and the certified flight instructors delayed remedial action. Ditches and fences were factors in the accident.NTSB ATL06CA068Accident · No injuriesData collectionFinal reportCessna 172S · Gainsville, GAThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA062Accident · No injuriesData collectionFinal reportCessna C-172S · Sanford, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB DFW06CA098Accident · No injuriesData collectionFinal reportCessna 172S · Denton, TXThe student pilot's failure to maintain directional control during the takeoff roll.NTSB ANC06CA036Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's improper recovery from a bounced landing, which resulted in structural damage to the firewall and fuselage.NTSB NYC06CA077Accident · No injuriesData collectionFinal reportCessna 172S · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point, which resulted in an overrun of the runway.