Skip to content

NTSB investigations: Cessna 172B, TX

19 cases on aircraft the registry lists as Cessna 172B. 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 ('2072406')) 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 ('2072406'))
  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 ('2072406'))
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 CEN23LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 172B · San Angelo, TXA partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.Jun 17, 2023 · N7509X · Substantial damage NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.Jul 8, 2002 · N7550X · Substantial damage NTSB FTW00LA217Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Olney, TXThe pilot's inadequate compensation for wind conditions. A factor was the gusty crosswind.Jul 27, 2000 · N7501X · Substantial damage NTSB FTW00LA023Accident · No injuriesLimited investigationFinal reportCessna 172B · Beaumont, TXFuel exhaustion as a result of the flight instructor's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Nov 1, 1999 · N7833X · Substantial damage NTSB FTW95LA062Accident · No injuriesLimited investigationFinal reportCessna 172B · Seguin, TXThe pilot's failure to attain proper touchdown point.Dec 7, 1994 · N7697X · Substantial damage NTSB FTW92LA088Accident · No injuriesLimited investigationFinal reportCessna 172B · Scottsville, TXPilots' inadequate compensation for unfavorable windshift. A facator was the unfavorable wind.Apr 1, 1992 · N7492X · Substantial damage NTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.Mar 8, 1992 · N6938X · Substantial damage NTSB FTW90LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXFailure to maintain directional control.Jun 29, 1990 · N8190X · Substantial damage NTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.Dec 3, 1988 · N7917X · Substantial damage NTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…Dec 28, 1985 · N6876X · 2 aircraft · Destroyed NTSB FTW83LA203Accident · No injuriesLimited investigationFinal reportCessna 172B · Spearman, TXThe acft swerved off the right side of the rwy and collided with a ditch. The acft nose gear collapsed during the sequence. The landing was on rwy 20 and during the approach the plt noticed that the wind was out of the south and that the wind sock was…Apr 24, 1983 · N6992X · Substantial damage NTSB FTW70D0110Accident · No injuriesClosedCessna 172 · Taft, TXJun 26, 1969 · N7556X · Destroyed NTSB FTW68A0037Accident · 2 fatalClosedCessna 172 · Paris, TXSep 28, 1967 · N8210X · Destroyed NTSB FTW67F0632Accident · Minor injuriesClosedCessna 172B · Franklin, TXApr 25, 1967 · N6999X · Substantial damage NTSB FTW67A0091Accident · 3 fatalClosedCessna 172 · Matagorda Is., TXMar 10, 1967 · N8016X · Destroyed NTSB FTW66F0036Accident · Minor injuriesClosedCessna 172 · Poth, TXMay 8, 1965 · N7724X · Substantial damage NTSB UNK65X0852Accident · Serious injuriesClosedCessna 172B · Uvalde, TXNov 27, 1964 · N7857X · Destroyed NTSB UNK65X0774Accident · Minor injuriesClosedCessna 172 · Lorenzo, TXNov 21, 1964 · N8111X · Substantial damage NTSB UNK64X0412Accident · Minor injuriesClosedCessna 172B · Killeen, TXJan 31, 1964 · N6940X · Substantial damage