NTSB investigations: Cessna 172K, TX
47 cases on aircraft the registry lists as Cessna 172K. 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
| 1969 | 4 |
|---|---|
| 1970 | 3 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2003 | 3 |
| 2004 | 1 |
| 2007 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2022 | 1 |
Where
Latest 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 ('2072430'))
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 ('2072430'))
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 CEN22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Plains, TXThe pilot’s failure to maintain control of the airplane during taxi with a strong crosswind.NTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.NTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB CEN11CA257Accident · No injuriesData collectionFinal reportCessna 172K · San Antonio, TXThe student pilot's inadequate compensation for wind while landing in gusty wind conditions.NTSB CEN11LA073Accident · Serious injuriesLimited investigationFinal reportCessna 172K · San Antonio, TXThe pilot's failure to maintain aircraft control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to land with a tailwind.NTSB DFW07LA130Accident · No injuriesLimited investigationFinal reportCessna 172K · Amarillo, TXThe failure of the left main landing gear spring assembly as a result of an unapproved repair by an unknown person(s), which resulted in a loss of directional control during the landing roll.NTSB DFW07LA082Accident · No injuriesLimited investigationFinal reportCessna T210R · Boerne, TXThe pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.NTSB FTW04LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Angleton, TXThe unqualified person's failure to maintain clearance with the power lines. A contributing factor was the night light conditions.NTSB FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.NTSB FTW03LA100Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's inadequate preflight planning and preparation for the flight which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB FTW96LA116Accident · No injuriesLimited investigationFinal reportCessna 172K · Hedley, TXthe failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA013Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's failure to follow proper emergency procedures to troubleshoot the electrical system. A factor was an electrical system irregularity of an undetermined nature.NTSB FTW91LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Granbury, TXTotal loss of engine power due to fuel exhaustion. Factors were the pilot's improper fuel consumption calculations, and the darkness of the night.NTSB FTW90LA026Accident · No injuriesLimited investigationFinal reportCessna 172K · Fabens, TXThe pilot's improper flare during landing and inadequate recovery from the ensuing bounced landing. The unfavorable wind was a related factor.NTSB FTW88LA089Accident · No injuriesLimited investigationFinal reportCessna 172K · Houston, TXThe high-wing, tricycle gear airplane was taxiing out in winds gusting to 29 knots from about 320 degrees. While the airplane was heading 250 degrees, it was overturned to the inverted position. Owner's manual does not list any restrictions for maximum…NTSB FTW87LA172Accident · No injuriesLimited investigationFinal reportCessna 172K · Brenham, TXThe student pilot lost directional control during the landing roll. The aircraft veered off the runway and nosed over to the inverted position when the nose gear dropped into a hole hidden by tall grass.NTSB FTW86LA117Accident · No injuriesLimited investigationFinal reportCessna 172K · Weatherford, TXThe pilot reported losing control of the acft during touchdown due to the crosswind. The landing was being made on runway 16 and there was a 7 kt wind from 200 degrees.NTSB FTW84LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bridgeport, TXDuring flt, the plt noted a progressive loss of eng power. The application of carburetor heat had no effect. Subsequently, a loud noise occurred & the plt shut down the eng. During a forced landing the nose gear collapsed & the acft nosed over. An exam…NTSB FTW82DRG06Accident · Minor injuriesClosedCessna 172 · Blanco, TXNTSB FTW80DQD06Accident · No injuriesClosedCessna 172 · Dell City, TXNTSB FTW80DRA10Accident · No injuriesClosedCessna 172K · Arcola, TXNTSB FTW79FA028Accident · 3 fatalClosedCessna 172K · Austin, TXNTSB FTW78FPD31Accident · Minor injuriesClosedCessna 172K · Saginaw, TXNTSB FTW77DQD29Accident · No injuriesClosedCessna 172 · Alpine, TXNTSB FTW76FRJ18Accident · No injuriesClosedCessna 172K · Hughes Springs, TXNTSB FTW76DRA06Accident · No injuriesClosedCessna 172K · Houston, TXNTSB FTW75FPD10Accident · Serious injuriesClosedCessna 172K · Graham, TXNTSB FTW74FRG65Accident · No injuriesClosedCessna 172K · Corpus Chrsti, TXNTSB FTW74DRG39Accident · No injuriesClosedCessna 172 · Austin, TXNTSB FTW74AF035Accident · 2 fatalClosedCessna 172K · Cherokee, TXNTSB FTW73DQG38Accident · Minor injuriesClosedCessna 172K · Follett, TXNTSB FTW73AF045Accident · 1 fatalClosedCessna 172K · Startzville, TXNTSB FTW72AF055Accident · 1 fatalClosedCessna 172 · Eagle Pass, TXNTSB FTW72FRA38Accident · 1 fatalClosedCessna 172K · Sugar Land, TXNTSB FTW72DPD03Accident · No injuriesClosedCessna 172 · Bridgeport, TXNTSB FTW71FRG94Accident · Serious injuriesClosedCessna 172K · Killeen, TXNTSB FTW71FRG83Accident · No injuriesClosedCessna 172K · Corpus Chrsti, TXNTSB FTW71FRA34Accident · No injuriesClosedCessna 172K · Katy, TXNTSB FTW71FPD18Accident · No injuriesClosedCessna 172 · Arlington, TXNTSB FTW71DQG27Accident · No injuriesClosedCessna 172 · Memphis, TXNTSB FTW71DQG01Accident · No injuriesClosedCessna 172K · Sterling City, TXNTSB FTW70A0039Accident · 4 fatalClosedCessna 172K · Bellville, TXNTSB FTW70A0008Accident · 1 fatalClosedBoeing 707 · Fort Worth, TXNTSB FTW70D0090Accident · Minor injuriesClosedCessna 172K · Eagle Lake, TXNTSB FTW70D0002Accident · No injuriesClosedCessna 172 · Smithfield, TX