Skip to content

NTSB investigations: Cessna 172L, TX

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

19702026

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 ('2072432')) 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 ('2072432'))
  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 ('2072432'))
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 CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.Jun 19, 2025 · N7299Q · Substantial damage NTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…Jan 29, 2023 · N621EW · Substantial damage NTSB CEN22LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Canyon Lake, TXThe pilot’s failure to retract the flaps during a go-around, which resulted in decreased climb performance and a subsequent collision with trees and terrain.May 28, 2022 · N3842Q · Substantial damage NTSB GAA19CA192Accident · Minor injuriesData collectionFinal reportCessna 172 · Stephenville, TXThe student pilot's improper landing flare, which resulted in a hard landing, and his subsequent failure to maintain directional control in gusting crosswind conditions that exceeded the airplane’s demonstrated crosswind for landing, which resulted in a…Mar 31, 2019 · N902RA · Substantial damage NTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…Aug 17, 2018 · N2893Q · Substantial damage NTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.Jul 1, 2006 · N7943G · Substantial damage NTSB DFW05CA100Accident · No injuriesData collectionFinal reportCessna 172L · Stephenville, TXThe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the prevailing crosswind.Apr 3, 2005 · N3889Q · Substantial damage NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.Sep 6, 2003 · N7632G · Destroyed NTSB FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.Jun 22, 2003 · N912KD · Substantial damage NTSB FTW02LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Dalhart, TXThe pilot's failure to maintain aircraft control. Contributing factors were the shifting gusty winds and the ditch.Jun 2, 2002 · N4261Q · Substantial damage NTSB FTW95LA295Accident · No injuriesLimited investigationFinal reportCessna 172L · Porter, TXThe loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed resulting in overshooting the landing.Jul 13, 1995 · N3967Q · Substantial damage NTSB FTW92LA194Accident · No injuriesLimited investigationFinal reportCessna 172L · Ozona, TXThe pilot's failure to maintain obstacle clearance.Jul 25, 1992 · N9880G · Substantial damage NTSB DEN90LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Mason, TXThe failure of the pilot to maintain an adequate visual lookout.Sep 20, 1990 · N746JG · Substantial damage NTSB FTW89LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe airplane had been flown for 2.2 hours since refueling when this pilot started his flight. This pilot flew the airplane for 2.5 hours and the engine quit. During the forced landing, the airplane impacted a power pole and power lines, and then the terrain.…Oct 23, 1988 · N7185Q · Destroyed NTSB FTW87LA157Accident · No injuriesLimited investigationFinal reportCessna 172L · Houston, TXWhile lndg, the student plt had flared the acft in a rgt x-wind with gusts to 13 KTS. Subsequently, the acft drifted left & the left main gear went into soft mud. The acft then veered to the left and was damaged.Jul 3, 1987 · N3980Q · Substantial damage NTSB FTW85FA090Accident · 3 fatalField investigationFinal reportCessna 172L · Galveston, TXA recently certificated private pilot with no known instrument training was given a 'VFR not recommended' weather briefing for a return trip on a pleasure flight. Weather conditions were predicted to, and did, deteriorate rapidly. He took off and turned on…Dec 30, 1984 · N2823Q · Destroyed NTSB FTW80DRJ10Accident · No injuriesClosedCessna 172 · Milam, TXJan 27, 1980 · N4338Q · Substantial damage NTSB FTW79FPA09Accident · No injuriesClosedCessna 172L · Dallas, TXFeb 10, 1979 · N7875G · Substantial damage NTSB FTW78FPD10Accident · No injuriesClosedCessna 172 · Ft.Worth, TXDec 14, 1977 · N7960G · Substantial damage NTSB FTW75DRG90Accident · No injuriesClosedCessna 172 · Burnet, TXJun 12, 1975 · N7903G · Substantial damage NTSB FTW75FPA15Accident · No injuriesClosedCessna 172L · Greenville, TXNov 26, 1974 · N8180M · Substantial damage NTSB FTW73FRJ13Accident · No injuriesClosedCessna 172L · Garrison, TXSep 6, 1972 · N19719 · Substantial damage NTSB FTW72FQD07Accident · No injuriesClosedCessna 172L · El Paso, TXAug 25, 1971 · N7672G · Substantial damage NTSB FTW71DPD40Accident · No injuriesClosedCessna 172L · Fort Worth, TXMar 6, 1971 · N7598G · Substantial damage NTSB FTW71FRG50Accident · No injuriesClosedCessna 172L · San Antonio, TXNov 17, 1970 · N7654G · Substantial damage