NTSB investigations: Cessna 172, TX
61 cases on aircraft the registry lists as Cessna 172. 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
| 1964 | 8 |
|---|---|
| 1965 | 3 |
| 1966 | 4 |
| 1967 | 3 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 4 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 3 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1997 | 1 |
| 2005 | 2 |
| 2008 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2024 | 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 ('2072402'))
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 ('2072402'))
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 CEN26LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Denton, TXThe pilot’s failure to maintain control of the airplane while in the run-up area in high wind conditions.NTSB CEN24LA117Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe pilot’s failure to maintain sufficient clearance from a large multi-engine airplane during taxi operations.NTSB CEN19FA099Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Lakeway, TXA partial loss of engine power for reasons that could not be determined, and the flight instructor's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing, which resulted in an aerodynamic stall and subsequent loss of…NTSB CEN13LA581Accident · No injuriesLimited investigationFinal reportCessna 172 · Rio Vista, TXThe student pilot’s failure to maintain adequate airspeed during the initial climb after an excessive takeoff run from a grass airstrip, which resulted in the exceedance of the airplane's critical angle-of-attack and a subsequent aerodynamic stall and loss of…NTSB CEN11CA293Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, TXThe pilot's delayed action in performing a go-around maneuver, which resulted in an impact with trees.NTSB DEN08LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Athens, TXA partial loss of engine power during initial climb due to undetermined reasons, which led to an uncontrolled descent and subsequent aerodynamic stall. Contributing to the accident was the pilot's improper preflight decision to attempt the flight with a…NTSB DFW05CA090Accident · Minor injuriesData collectionFinal reportCessna 172 · Nachogdoches, TXThe pilot's improper in-flight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA076Accident · No injuriesData collectionFinal reportCessna 172 · Marshall, TXThe pilot's improper engine starting procedure resulting in a loss of control.NTSB FTW97LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Manchaca, TXThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain obstacle clearance. A factor was the weather condition.NTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.NTSB FTW93LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hamlin, TXThe pilot's failure to switch fuel tanks and his failure to perform the prescribed emergency procedures following the fuel starvation induced engine failure. A factor was the lack of suitable terrain for the emergency landing.NTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.NTSB FTW87LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Cameron, TXDuring takeoff climb the aircraft struck a powerline then trees and impacted the ground. The aircraft was being flown bya student pilot with no medical certificate or solo endorsement.NTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.NTSB FTW86LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Weatherford, TXThe plt experienced a power loss at approximately 200 feet during the takeoff climb portion of the flight. On descent the aircraft collided with a tree before coming to rest in a field. During pre-flight the pilot noted the fuel tanks were half full and there…NTSB FTW85LA115Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Mccoy, TXThe plt stated that he had departed the gala ranch strip & was flying at aprx 100 ft AGL to show his passengers their ranch property. While in slow flight with the flaps deployed, the plt entered a downwind skidding left turn. The acft subsequently stalled &…NTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.NTSB FTW82FA006Accident · 1 fatalClosedCessna 172P · Orange, TXNTSB FTW80FPD42Accident · Serious injuriesClosedCessna 172 · Fort Worth, TXNTSB FTW80FPD33Accident · No injuriesClosedCessna 172 · Ballinger, TXNTSB FTW80FPA03Accident · No injuriesClosedCessna 172 · Terrell, TXNTSB FTW79FQG21Accident · Serious injuriesClosedCessna 172F · Crosbyton, TXNTSB FTW77FPD06Accident · Minor injuriesClosedCessna 172 · Henrietta, TXNTSB FTW77KQG04Accident · Serious injuriesClosedCessna 172 · Petersburg, TXNTSB FTW76DRA36Accident · No injuriesClosedCessna 150M · Sugarland, TXNTSB FTW76FRJ11Accident · Minor injuriesClosedCessna 172 · Lake Hawkins, TXNTSB FTW75AF075Accident · 4 fatalClosedCessna 172 · Plainview, TXNTSB FTW75FPA22Accident · Minor injuriesClosedCessna 172 · Corsicana, TXNTSB FTW74FQD23Accident · Serious injuriesClosedCessna 172 · Acala, TXNTSB FTW74FPD03Accident · No injuriesClosedCessna 172 · Iowa Park, TXNTSB FTW73FRA12Accident · Serious injuriesClosedCessna 172 · Riverside, TXNTSB FTW73DQG16Accident · No injuriesClosedCessna 172 · Wildorado, TXNTSB FTW72DRA03Accident · No injuriesClosedCessna 172 · Alice, TXNTSB FTW71FRA57Accident · Serious injuriesClosedCessna 172 · Port Bolivar, TXNTSB FTW71FPA22Accident · No injuriesClosedCessna 172 · Terrell, TXNTSB FTW71FQG52Accident · No injuriesClosedCessna 172 · Robert Lee, TXNTSB FTW71FPA07Accident · No injuriesClosedCessna 172 · Quinlan, TXNTSB FTW71FRA14Accident · No injuriesClosedCessna 172 · Alvin, TXNTSB FTW70AF083Accident · 2 fatalClosedCessna 172K · New Braunfels, TXNTSB FTW70DRA13Accident · No injuriesClosedCessna 172 · Wheelock, TXNTSB FTW69A0048Accident · 2 fatalClosedCessna 172 · Barksdale, TXNTSB FTW69D0066Accident · No injuriesClosedCessna 172 · Junction, TXNTSB FTW68D0479Accident · No injuriesClosedCessna 172 · New Braunfels, TXNTSB FTW68F0392Accident · No injuriesClosedCessna 172 · Jasper, TXNTSB FTW68F0347Accident · No injuriesClosedCessna 172 · Lubbock, TXNTSB FTW68D0123Accident · No injuriesClosedCessna 172 · Winnie, TXNTSB FTW67D0334Accident · No injuriesClosedCessna 172 · Lubbock, TXNTSB FTW67D0298Accident · No injuriesClosedCessna 172 · Tahoka, TXNTSB FTW67D0037Accident · No injuriesClosedCessna 172 · Alba, TXNTSB FTW66F0493Accident · No injuriesClosedCessna 172 · Amarillo, TX