Skip to content

NTSB investigations: Cessna 172G, TX

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

19662026

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 ('2072420')) 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 ('2072420'))
  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 ('2072420'))
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 CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.Dec 26, 2025 · N172BX · Substantial damage NTSB CEN22LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Bynum, TXThe pilot was not able to stop the airplane on the remaining runway after an aborted takeoff, which resulted in a runway excursion and the airplane impacting a fence.Jun 17, 2022 · N2975U · Substantial damage NTSB GAA19CA267Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in impact with a ditch.May 15, 2019 · N5788R · Substantial damage NTSB GAA19CA048Accident · Minor injuriesData collectionFinal reportCessna 172 · Cleburne, TXThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.Nov 1, 2018 · N3984L · Substantial damage NTSB GAA18CA170Accident · No injuriesData collectionFinal reportCessna 172 · Vernon, TXThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.Mar 19, 2018 · N1103F · Substantial damage NTSB GAA18CA146Accident · Minor injuriesData collectionFinal reportCessna 172 · Gatesvile, TXThe pilot’s failure to maintain directional control during initial climb in a gusty condition.Feb 28, 2018 · N1118F · Substantial damage NTSB DFW07CA140Accident · No injuriesData collectionFinal reportCessna 172G · Katy, TXThe student pilot's improper flare and his failure to recover from a bounced landing.Jun 12, 2007 · N4260L · Substantial damage NTSB FTW03LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fort Stockton, TXThe pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.Nov 1, 2002 · N6072R · Substantial damage NTSB FTW98LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Van, TXfuel starvation, resulting from restricted carburetor float travel, due to improper maintenance installation. The encounter with a power line was related factor.Nov 17, 1997 · N202EX · Substantial damage NTSB FTW97LA251Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Powderly, TXThe inadvertent stall due to the pilot's diverted attention to an open service door. A factor was the inadequate preflight inspection by the pilot.Jul 4, 1997 · N3888L · Substantial damage NTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.Jul 8, 1993 · N3631L · Minor damage NTSB FTW93LA198Accident · No injuriesLimited investigationFinal reportCessna 172G · Fort Worth, TXThe power loss for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the inadvertent stall.Jun 29, 1993 · N3987L · Substantial damage NTSB FTW90LA084Accident · No injuriesLimited investigationFinal reportCessna 172G · Rio Hondo, TXOil starvation induced power loss due to improper maintenance procedures. Contributing to the accident were inadequate maintenance inspection and the soft terrain in which the forced landing was performed.Mar 17, 1990 · N4696L · Substantial damage NTSB FTW89LA144Accident · No injuriesLimited investigationFinal reportCessna 172G · Mckinney, TXTotal failure of the engine assembly/rocker arm/tappet shaft.Aug 5, 1989 · N4377L · Substantial damage NTSB FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.Oct 27, 1987 · N3931L · Substantial damage NTSB FTW87LA109Accident · No injuriesLimited investigationFinal reportCessna 172G · Houston, TXA student pilot on a solo flight in the local area, landed long and ran off the end of the runway. The pilot stated that the accident occurred due to touchdown too FAR down the runway. He further related that the presence of high tension wires influenced his…Apr 23, 1987 · N1107F · Substantial damage NTSB FTW86LA038Accident · No injuriesLimited investigationFinal reportCessna 172G · Spring, TXThe pilot continued VFR flight into IFR weather conditions which he had encountered near his destination during the last few moments of his approximate four hour, night, cross-country flight. He then turned back to houston intercontinental airport to land. He…Jan 21, 1986 · N3373B · Substantial damage NTSB FTW81FRA35Accident · No injuriesClosedCessna 172 · Beaumont, TXAug 11, 1981 · N1343F · Substantial damage NTSB FTW81FQG36Accident · No injuriesClosedCessna 172G · Shallowater, TXJun 6, 1981 · N4377L · Substantial damage NTSB FTW79FA001Accident · 1 fatalClosedCessna 172 · Bridgeport, TXOct 8, 1978 · N6018R · Destroyed NTSB FTW78DQD16Accident · No injuriesClosedCessna 172G · Imperial, TXApr 6, 1978 · N3908L · Substantial damage NTSB FTW78FPD04Accident · No injuriesClosedCessna 172 · Jacksboro, TXNov 3, 1977 · N3860L · Substantial damage NTSB FTW76DRG31Accident · No injuriesClosedCessna 172 · Eagle Pass, TXDec 20, 1975 · N3874L · Substantial damage NTSB FTW76FRG19Accident · Minor injuriesClosedCessna 172 · Victoria, TXSep 10, 1975 · N4401L · Substantial damage NTSB FTW75DQG50Accident · No injuriesClosedCessna 172 · Post, TXApr 7, 1975 · N4699L · Substantial damage NTSB FTW75DQD17Accident · No injuriesClosedCessna 172 · Candelaria, TXMar 6, 1975 · N4465L · Substantial damage NTSB FTW75FQG23Accident · Minor injuriesClosedCessna 172G · Amarillo, TXSep 11, 1974 · N5808R · Destroyed NTSB FTW72AF039Accident · 1 fatalClosedCessna 172 · Seguin, TXDec 22, 1971 · N3941L · Destroyed NTSB FTW72FQG03Accident · No injuriesClosedCessna 172G · New Home, TXJul 19, 1971 · N3866L · Substantial damage NTSB FTW71FQG48Accident · No injuriesClosedCessna 172 · Midland, TXDec 15, 1970 · N1186F · Destroyed NTSB FTW71DRG30Accident · Minor injuriesClosedCessna 172 · Lowake, TXSep 28, 1970 · N5997R · Substantial damage NTSB FTW70DRG24Accident · Serious injuriesClosedCessna 172 · San Benito, TXMar 15, 1970 · N4472L · No damage NTSB FTW70D0044Accident · Serious injuriesClosedCessna 172G · Kyle, TXApr 25, 1969 · N3790L · Substantial damage NTSB FTW69F0095Accident · Minor injuriesClosedCessna 172 · Ainesville, TXJul 15, 1968 · N1323F · Substantial damage NTSB FTW69F0043Accident · No injuriesClosedCessna 172G · Marshall, TXJun 7, 1968 · N1171F · Substantial damage NTSB FTW68D0396Accident · No injuriesClosedCessna 172 · San Marcos, TXDec 6, 1967 · N3607L · Substantial damage NTSB FTW68F0357Accident · No injuriesClosedCessna 172 · Arlington, TXOct 21, 1967 · N4204L · Substantial damage NTSB FTW67F0464Accident · Minor injuriesClosedCessna 172 · Friendswood, TXFeb 15, 1967 · N1379F · Substantial damage NTSB FTW67F0347Accident · Minor injuriesClosedCessna 172G · Pearland, TXDec 19, 1966 · N3728L · Substantial damage