Skip to content

NTSB investigations: Cessna 172D, TX

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

19642026

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 ('2072410')) 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 ('2072410'))
  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 ('2072410'))
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 CEN26LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 172D · Post, TXThe pilot’s failure to see the blockage in the fuel tank vent tube during the preflight inspection which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the deterioration of the right fuel cap vent to the point…Dec 19, 2025 · N2536U · Substantial damage NTSB CEN15LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Shenandoah, TXThe pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.Jul 3, 2015 · N2320U · Substantial damage NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.Feb 15, 2007 · N2629U · Substantial damage NTSB FTW98LA133Accident · No injuriesLimited investigationFinal reportCessna 172D · El Paso, TXThe pilots improper compensation for the wind conditions and his failure to maintain control of the aircraft. A factor was the high wind condition.Feb 25, 1998 · N2526U · Substantial damage NTSB FTW93LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Lampasas, TXFuel exhaustion engine power loss due to an inadequate preflight preparation. A factor was the lack of suitable terrain for the forced landingJul 2, 1993 · N2446U · Substantial damage NTSB FTW83LA344Accident · No injuriesLimited investigationFinal reportCessna 172D · New Braunfels, TXThe acft made a hard landing which was hard enough to blow the nose gear tire and collapse the nose gear assembly.Apr 20, 1983 · N2419U · Substantial damage NTSB FTW82FA030Accident · 1 fatalClosedCessna 172 · Venus, TXDec 10, 1981 · N2894U · Destroyed NTSB FTW80DRJ29Accident · Minor injuriesClosedCessna 172 · Lindale, TXJul 12, 1980 · N2605U · Substantial damage NTSB FTW80DQG07Accident · No injuriesClosedCessna 172 · Spearman, TXDec 23, 1979 · N2662U · Substantial damage NTSB FTW73AF008Accident · 2 fatalClosedCessna 172D · Farwell, TXAug 12, 1972 · N2328U · Destroyed NTSB FTW72FRA30Accident · No injuriesClosedCessna 172 · Katy, TXJan 10, 1972 · N2501U · Substantial damage NTSB FTW71DRG35Accident · No injuriesClosedCessna 172 · San Antonio, TXOct 11, 1970 · N2539U · Substantial damage NTSB FTW68F0237Accident · No injuriesClosedCessna 172 · Houston, TXSep 17, 1967 · N2802U · Destroyed NTSB FTW67F0267Accident · Minor injuriesClosedCessna 172 · Fort Worth, TXNov 11, 1966 · N2320U · Substantial damage NTSB FTW66D0436Accident · No injuriesClosedCessna 172D · Dallas, TXJan 16, 1966 · N2497Y · Substantial damage NTSB FTW66F0427Accident · No injuriesClosedCessna 172 · Megargel, TXNov 29, 1965 · N2916U · Substantial damage NTSB UNK65X0912Accident · No injuriesClosedCessna 172 · Westherford, TXDec 4, 1964 · N2360U · Substantial damage NTSB UNK65X0646Accident · No injuriesClosedCessna 172B · Lubbock, TXNov 10, 1964 · N2182Y · Substantial damage NTSB UNK65X0392Accident · 4 fatalClosedCessna 172 · Houston, TXOct 23, 1964 · N2142Y · Destroyed NTSB UNK64X1325Accident · No injuriesClosedCessna 172 · El Campo, TXApr 15, 1964 · N2630U · Substantial damage NTSB UNK64X0287Accident · No injuriesClosedCessna 172D · Dallas, TXJan 19, 1964 · N2485Y · Substantial damage