Skip to content

NTSB investigations: Cessna 172A, TX

21 cases on aircraft the registry lists as Cessna 172A. 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 ('2072404')) 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 ('2072404'))
  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 ('2072404'))
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 CEN11LA153Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Clarendon, TXThe pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.Jan 17, 2011 · N7262T · Substantial damage NTSB CEN09CA226Accident · No injuriesData collectionFinal reportCessna 172A · Corsicana, TXThe pilot's improper flare.Mar 20, 2009 · N7326T · Destroyed NTSB FTW89LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Bastrop, TXInadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.Mar 3, 1989 · N7407T · Substantial damage NTSB FTW88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Cleveland, TXThis acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to…Jun 8, 1988 · N7317T · Substantial damage NTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…Aug 25, 1986 · N7261T · Substantial damage NTSB FTW78FPD17Accident · No injuriesClosedCessna 172A · Brownwood, TXApr 16, 1978 · N7751T · Substantial damage NTSB FTW76DQG06Accident · No injuriesClosedCessna 172A · Rotan, TXJul 5, 1975 · N7864T · Substantial damage NTSB FTW74FPA01Accident · No injuriesClosedCessna 172 · Denison, TXJul 21, 1973 · N7821T · Substantial damage NTSB FTW73AF046Accident · 2 fatalClosedCessna 172 · Salt Flat, TXFeb 20, 1973 · N7546T · Destroyed NTSB FTW70FPA12Accident · Minor injuriesClosedCessna 172 · Addison, TXApr 20, 1970 · N7205T · Substantial damage NTSB FTW70DRA03Accident · No injuriesClosedCessna 172 · Tomball, TXJan 3, 1970 · N7574T · Substantial damage NTSB FTW70F0362Accident · No injuriesClosedCessna 172A · Bertram, TXDec 24, 1969 · N7573T · Substantial damage NTSB FTW70A0037Accident · 2 fatalClosedCessna 172 · Saginaw, TXNov 26, 1969 · N7271T · Destroyed NTSB FTW69D0311Accident · Minor injuriesClosedCessna 172 · Eldorado, TXNov 9, 1968 · N7504T · Substantial damage NTSB FTW69F0059Accident · Serious injuriesClosedCessna 172A · Sivells Bend, TXJun 29, 1968 · N7318T · Destroyed NTSB FTW68D0518Accident · No injuriesClosedCessna 172 · Everman, TXApr 7, 1968 · N7270T · Substantial damage NTSB FTW66F0460Accident · Serious injuriesClosedCessna 172A · College Sta, TXDec 19, 1965 · N7190T · Substantial damage NTSB FTW66D0306Accident · No injuriesClosedCessna 172 · Booker, TXSep 3, 1965 · N9869T · Substantial damage NTSB FTW66F0206Accident · No injuriesClosedCessna 172 · San Antonio, TXMar 26, 1965 · N7795T · Substantial damage NTSB UNK65X1345Accident · No injuriesClosedCessna 172 · Victoria, TXJan 25, 1965 · N7262T · Destroyed NTSB UNK65X0391Accident · Serious injuriesClosedCessna 172 · Ralls, TXOct 23, 1964 · N7321T · Destroyed