Skip to content

NTSB investigations: Cessna 172F, TX

42 cases on aircraft the registry lists as Cessna 172F. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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 ('2072414')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072414'))
  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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN25LA377Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Lancaster, TXThe pilot’s inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion.Sep 13, 2025 · N7774A · Substantial damage NTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…Aug 6, 2024 · N7905U · Substantial damage NTSB GAA19CA269Accident · No injuriesData collectionFinal reportCessna 172 · Tomball, TXThe student pilot's failure to maintain directional control during landing with a left crosswind, which resulted in a runway excursion and subsequent nose-over.May 14, 2019 · N8159U · Substantial damage NTSB FTW00LA049Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Worth, TXThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise.Dec 18, 1999 · N8250U · Substantial damage NTSB FTW89LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksboro, TXFailure of the pilot to go around, when she did not attain the proper touchdown point (landed long) and had excessive airspeed to stop on the runway. A factor related to the accident was the unfavorable wind condition (sudden wind shift).Feb 26, 1989 · N8643U · Substantial damage NTSB FTW88FA100Accident · Serious injuriesField investigationFinal reportCessna 172F · Golden, TXAcft was operating on an aerial photography flt at 200 to 500' AGL and 70 to 80 mph. The commercial plt stated that as he was in a bank the acft seemed to be 'pushed' into the 60 to 80' trees over which he was flying and that it 'fell out of the air'. He also…May 13, 1988 · N5577R · Destroyed NTSB FTW88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leona, TXThe plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…Apr 3, 1988 · N8775U · Substantial damage NTSB FTW86LRA03Accident · No injuriesFinal reportCessna 172F · Saratoga, TXPilot was enroute from rocksprings, TX. To hardin county airport near kountz, TX. As pilot appoached Saratoga, TX., the engine quit due to fuel exhaustion. Pilot landed in field near Saratoga causing substantial damage to the aircraft. No injuries were…Jan 5, 1986 · N8267U · Destroyed NTSB FTW83FA362Accident · 3 fatalField investigationFinal reportCessna 172F · El Paso, TXTwo plts & 2 passengers departed san angelo, TX, on a x-country flt, one of the plts, who had 95 hrs of flying time, was the pilot-in-command (PIC) for the 1st leg of the x-country to El Paso, TX. On the next leg, the other plt assumed duties as PIC & signed…Aug 7, 1983 · N5259F · Destroyed NTSB FTW82DA379Accident · Minor injuriesFinal reportCessna 172 · Corpus Christi, TXAircraft landed short after engine quit on final approach. The fuel was down to minimum usable quantity.Sep 12, 1982 · N8233U · Substantial damage NTSB FTW82DA333Accident · No injuriesFinal reportCessna 172F · Springlake, TXThe student pilot reported that during a landing, he flared too high. The aircraft then stalled onto the runway and was substantially damaged. Reportedly, he had a 3 kt tail wind and the density altitude was about 6000 ft.Aug 13, 1982 · N8239U · Substantial damage NTSB FTW81FRA45Accident · Minor injuriesClosedCessna 172 · Palacios, TXJul 11, 1981 · N7851U · Substantial damage NTSB FTW79FPD04Accident · No injuriesClosedCessna 172F · Pilot Point, TXOct 19, 1978 · N8186U · Substantial damage NTSB FTW77FRA36Accident · No injuriesClosedCessna 172F · Pearland, TXSep 26, 1977 · N8400U · Substantial damage NTSB FTW73FPA26Accident · No injuriesClosedCessna 172F · Trenton, TXMar 11, 1973 · N1117T · Substantial damage NTSB FTW73AF032Accident · 1 fatalClosedCessna 172F · Cleveland, TXDec 20, 1972 · N8589U · Destroyed NTSB FTW72FRG65Accident · No injuriesClosedCessna 172 · Pearsall, TXApr 7, 1972 · N8643U · Destroyed NTSB FTW72FPD25Accident · No injuriesClosedCessna 172F · Cisco, TXDec 27, 1971 · N8179U · Substantial damage NTSB FTW72AF017Accident · 2 fatalClosedCessna 172F · Boerne, TXSep 22, 1971 · N5510R · Destroyed NTSB FTW71FRA68Accident · No injuriesClosedCessna 172F · Tomball, TXJun 18, 1971 · N8854U · Substantial damage NTSB FTW71FQG62Accident · No injuriesClosedCessna 172 · Midland, TXFeb 18, 1971 · N7984U · Substantial damage NTSB FTW71FRA36Accident · Minor injuriesClosedCessna 172F · Bryan, TXJan 11, 1971 · N8232U · Substantial damage NTSB FTW71FRA28Accident · Minor injuriesClosedCessna 172F · Baytown, TXDec 3, 1970 · N8556U · Substantial damage NTSB FTW71FPD17Accident · No injuriesClosedCessna 172F · Weatherford, TXSep 15, 1970 · N8622U · Substantial damage NTSB FTW70FPA05Accident · No injuriesClosedCessna 172 · Waco, TXFeb 2, 1970 · N8668U · Substantial damage NTSB FTW69D0404Accident · No injuriesClosedCessna 172 · Shallowater, TXFeb 9, 1969 · N7921U · Substantial damage NTSB FTW69D0233Accident · Minor injuriesClosedCessna 172F · Athens, TXOct 13, 1968 · N7861U · Substantial damage NTSB FTW68A0107Accident · Minor injuriesClosedCessna 172 · Amarillo, TXJun 23, 1968 · N8261U · Substantial damage NTSB FTW68F0616Accident · No injuriesClosedBoeing A75N1 · Beaumont, TXJun 1, 1968 · N60885 · 2 aircraft · Substantial damage NTSB FTW68D0508Accident · Minor injuriesClosedCessna 172 · Austin, TXMar 12, 1968 · N8233U · Substantial damage NTSB FTW68F0302Accident · Minor injuriesClosedCessna 172F · Waco, TXOct 23, 1967 · N7877U · Substantial damage NTSB FTW68S0001Incident · 1 fatalClosedCessna 172 · Lk.Jackson, TXJul 17, 1967 · N5577R · No damage NTSB FTW67F0422Accident · No injuriesClosedCessna 172 · Buchanon Dam, TXJan 21, 1967 · N7921U · Substantial damage NTSB FTW67F0366Accident · No injuriesClosedCessna 172 · Dallas, TXJan 6, 1967 · N8627U · Substantial damage NTSB FTW67A0040Accident · 2 fatalClosedCessna 172F · Hempstead, TXSep 30, 1966 · N5306R · Destroyed NTSB FTW67F0195Accident · No injuriesClosedCessna 172F · Lubbock, TXSep 2, 1966 · N7832U · Substantial damage NTSB FTW67F0110Accident · No injuriesClosedCessna 172 · Amarillo, TXJul 24, 1966 · N8368U · Substantial damage NTSB FTW67F0229Accident · No injuriesClosedCessna 172 · Grand Prairie, TXJul 21, 1966 · N8261U · Substantial damage NTSB FTW66F0550Accident · No injuriesClosedCessna 172 · Amarillo, TXMar 1, 1966 · N8136U · Substantial damage NTSB FTW66F0421Accident · No injuriesClosedCessna 172 · Corpus Christi, TXNov 2, 1965 · N5646R · Substantial damage NTSB FTW66D0234Accident · No injuriesClosedCessna 172 · Odessa, TXJul 29, 1965 · N7830U · Substantial damage NTSB FTW66F0203Accident · No injuriesClosedCessna 172 · Houston, TXMar 5, 1965 · N8491U · Substantial damage