NTSB investigations: Cessna 172N, TX
98 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
| 1977 | 1 |
|---|---|
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 4 |
| 1982 | 6 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 1 |
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 1 |
| 2026 | 1 |
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 ('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 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 ('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 CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.NTSB CEN23LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Flower Mound, TXThe fatigue failure of the rocker arm which resulted in a partial loss of engine power. Contributing was the airplane operator’s failure to inspect the rocker arm in accordance with the engine manufacturer’s service bulletin.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB CEN20LA425Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Spring, TXThe student pilot’s failure to maintain airplane control during climb and subsequent impact with terrain.NTSB CEN20CA393Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain directional control upon landing.NTSB CEN18FA227Accident · 2 fatalField investigationFinal reportCessna 172N · Rotan, TXThe pilot's reckless decision to conduct low-level flight over a canyon, resulting in the airplane's impact with power lines and terrain.NTSB CEN16FA083Accident · 1 fatalField investigationFinal reportCessna 172N · Gilmer, TXThe pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…NTSB GAA15CA162Accident · No injuriesData collectionFinal reportCessna 172N · Lubbock, TXThe student pilot's improper flare during landing which resulted in abnormal runway contact and damage to the firewall.NTSB CEN14LA276Accident · No injuriesLimited investigationFinal reportCessna 172N · Padre Island, TXThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN13CA450Accident · No injuriesData collectionFinal reportCessna 172N · Mesquite, TXThe student pilot failed to maintain directional control during the touch-and-go landing and during the subsequent aborted takeoff during crosswind conditions.NTSB CEN13CA090Accident · No injuriesData collectionFinal reportCessna 172N · McKinney, TXThe pilot’s inadequate flare, which resulted in a hard nosewheel landing.NTSB CEN12FA154Accident · 1 fatalField investigationFinal reportCessna 172N · Floresville, TXThe medical incapacitation of the pilot due to a sudden cardiac arrhythmia or acute myocardial infarction.NTSB CEN11CA248Accident · No injuriesData collectionFinal reportCessna 172N · Graham, TXThe pilot's failure to maintain directional control during landing.NTSB CEN11LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Andrews, TXThe pilot's failure to maintain adequate airspeed during an emergency descent, following a loss of engine power, which resulted in an inadvertent stall.NTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.NTSB DFW07CA028Accident · No injuriesData collectionFinal reportCessna 172N · Spring, TXLoss of directional control for undetermined reasons.NTSB DFW06CA030Accident · No injuriesData collectionFinal reportCessna 172N · Arlington, TXThe students improper recovery from a bounced landing. A contributing factor was the pilots excessive airspeed on final approach.NTSB DFW06CA026Accident · No injuriesData collectionFinal reportCessna 172N · Sherman, TXThe pilot's failure to maintain directional control during takeoff.NTSB DFW05LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Olney, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB DFW05CA091Accident · No injuriesData collectionFinal reportCessna 172N · Rio Grande City, TXThe pilot's failure to maintain clearance from objects, and his improper compensation for wind conditions while landing. A contributing factor was the gusty wind condition.NTSB FTW04LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · New Braunfels, TXThe student pilot's failure to maintain directional control of the airplane. A contributing factor was the high wind condition.NTSB FTW04CA205Accident · No injuriesData collectionFinal reportCessna 172N · Cleveland, TXThe student pilot's improper judgment of the airplanes altitude during landing. A contributing factor was the pilot's level of anxiety/apprehension after becoming lost/disoriented.NTSB FTW04LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Decatur, TXThe student pilot's failure to follow the flight instructor's instructions and relinquish the controls, and the flight instructor's delay in initiating a go-around.NTSB FTW04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172N · La Grange, TXThe pilot's failure to properly navigate during the day VFR cross-country flight, which resulted in the pilot becoming disoriented.NTSB FTW03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Porter, TXThe loss of engine power for an undetermined reason.NTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.NTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Georgetown, TXthe pilot's failure to refuel the aircraft resulting in fuel exhaustion during cruise flight. A contributing factor was the gusty wind encountered during the forced landing.NTSB FTW01LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Marfa, TXfuel exhaustion resulting in a total loss of engine power in cruise flight due to the pilot's failure to refuel the aircraft. Contributing factors were the lack of suitable terrain for the forced landing, and the dark night condition.NTSB FTW01FA025Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXthe failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.NTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW00LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · San Antonio, TXThe flight instructor's failure to refuel the airplane, which resulted in fuel exhaustion. Contributing factors were the flight instructor's fatigued condition and diverted attention.NTSB FTW99LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Longview, TXThe pilot's improper touchdown technique, which resulted in the airplane porpoising.NTSB FTW99LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Cleburne, TXThe pilot's failure to maintain adequate altitude/ clearance from the wires.NTSB FTW99LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange, TXThe student pilot's failure to maintain directional control during landing touchdown. A factor was the muddy drainage ditch.NTSB FTW99FA033Accident · 2 fatalField investigationFinal reportCessna 172N · Bacliff, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions and his inability to maintain adequate altitude/clearance from the wire. Contributing to the accident were the fog, low ceilings and his lack of instrument time.NTSB FTW98FA307Accident · Serious injuriesField investigationFinal reportCessna 172N · Lincoln, TXThe #3 cylinder exhaust valve rocker arm fulcrum retaining stud backing out of its stud-tapped hole due to the improper tapping of the stud hole by unknown maintenance personnel. Contributing factors were the transmission wire, sign and gasoline pump.NTSB FTW98LA069Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mckinney, TXThe pilot's inadequate in-flight/planning decision which resulted in continued flight until fuel exhaustion. Related factors were incorrect fuel gauge readings and trees.NTSB FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.NTSB FTW96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Austin, TXthe partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA010Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crockett, TXfailure of both magnetos to operate properly due to inadequate maintenance by other maintenance personnel. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW95LA386Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kerrville, TXthe pilot's inadequate preflight preparation and his failure to use all the available runway. A factor was the dark night.NTSB FTW95LA375Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bonham, TXThe partial loss of engine power for undetermined reasons. Factors were the high density altitude and lack of suitable terrain for the forced landing.NTSB FTW95LA250Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXThe pilot's failure to attain runway alignment. Factors were the pilot's failure to perform a go-around and his lack of total experience in the make and model of airplane.NTSB FTW94FA060Accident · 5 fatalField investigationFinal reportPalmer Hawk BM-4 · Pearland, TXInadequate visual lookout by the pilot of the hawk BM-4, which resulted in his failure to see-and-avoid the Cessna 172. The BM-4 pilot's non-standard procedure for entering the traffic pattern was a related factor.NTSB FTW94LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Woodville, TXFailure of the pilot in command to maintain control of the aircraft during an aborted landing.NTSB FTW93FA096Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXThe pilot's failure to maintain control of the airplane for undetermined reasonsNTSB FTW93LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXFuel starvation power loss due to carburetor restriction from a foreign object, the inadequate inspection and improper overhaul of the carburetor by other maintenance personnel