NTSB investigations: Cessna 172S, TX
36 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
| 1999 | 1 |
|---|---|
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2025 | 2 |
| 2026 | 2 |
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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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 CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA187Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Denton, TXOn May 13, 2026, about 1815 central daylight time, a Cessna 172S, N2134M, sustained substantial damage when it was involved in an accident near Denton, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN25LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Rusk, TXThe pilot's failure to maintain airplane control and adequate airspeed during the go-around, resulting in an aerodynamic stall and impact with terrain.NTSB CEN25LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and her improper pitch control during the attempted recovery that resulted in a nose down pitch attitude upon the second touchdown.NTSB CEN23LA421Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, TXThe student pilot’s improper landing flare, which resulted in a hard, bounced landing, and the nose landing gear collapse.NTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.NTSB CEN20LA419Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172S · San Marcos, TXThe F1 pilot’s failure to see and avoid the lower altitude Cessna while on final approach for landing. Contributing to the accident were the restrictions to pilot visibility inherent to low- and high-wing airplanes, and both pilots’ failure to recognize the…NTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.NTSB CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB CEN19LA113Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Spring, TXThe pilot’s failure to maintain airplane directional control while taxiing at an unsafe ground speed.NTSB CEN19LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Prairie, TXThe failure of the pilots of both airplanes to see and avoid the other airplane while entering the airport traffic pattern in visual meteorological conditions. Contributing to the accident was the tower controller's failure to recognize the proximity of the…NTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.NTSB CEN18LA344Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Addison, TXThe pilot's improper flap setting for takeoff and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing was the overgross state of the airplane.NTSB GAA18CA460Accident · No injuriesData collectionFinal reportCessna 172 · Grand Prairie, TXThe student pilot’s failure to maintain the runway centerline during takeoff with a crosswind.NTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.NTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11CA158Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with terrain.NTSB CEN10CA176Accident · No injuriesData collectionFinal reportCessna 172S · Mckinney, TXThe student pilot's loss of directional control while landing with a crosswind.NTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.NTSB CEN09LA442Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Boyd, TXA total loss of engine power due to the pilot's improper leaning procedures, resulting in a forced landing and collision with a fence.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.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 DFW06CA098Accident · No injuriesData collectionFinal reportCessna 172S · Denton, TXThe student pilot's failure to maintain directional control during the takeoff roll.NTSB DFW05CA253Accident · No injuriesData collectionFinal reportCessna 172S · Batesville, TXThe pilot's failure to maintain clearance from the tree. A contributing factor was the gusty winds.NTSB FTW04CA224Accident · Minor injuriesData collectionFinal reportCessna 172S · Leakey, TXThe pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.NTSB FTW04LA178Accident · No injuriesLimited investigationFinal reportCessna 172S · San Antonio, TXThe student pilot's failure to maintain control of the airplane during landing.NTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.NTSB FTW04LA072Accident · No injuriesLimited investigationFinal reportCessna 172-SP · McKinney, TXThe student pilot's failure to maintain directional control of the aircraft during the take-off roll.NTSB FTW03FA182Accident · 2 fatalField investigationFinal reportCessna 172S · McKinney, TXThe CFI's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing. A contributing factor was the impact with a bird, which affected the performance of the airplane.NTSB FTW02LA068Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXthe student pilot's failure to maintain directional control during landing.NTSB FTW00LA050Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXThe student pilot's failure to maintain control of the airplane during the landing roll.