# NTSB investigations: Cessna 172A, TX

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN11LA153](https://openairdocs.org/ntsb/CEN11LA153.md): Cessna 172A · Clarendon, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2011 · N7262T · Substantial damage
  > The pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.
- [NTSB CEN09CA226](https://openairdocs.org/ntsb/CEN09CA226.md): Cessna 172A · Corsicana, TX · Accident · No injuries · Data collection · Final report · Mar 20, 2009 · N7326T · Destroyed
  > The pilot's improper flare.
- [NTSB FTW89LA063](https://openairdocs.org/ntsb/FTW89LA063.md): Cessna 172 · Bastrop, TX · Accident · No injuries · Limited investigation · Final report · Mar 3, 1989 · N7407T · Substantial damage
  > Inadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.
- [NTSB FTW88LA117](https://openairdocs.org/ntsb/FTW88LA117.md): Cessna 172A · Cleveland, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1988 · N7317T · Substantial damage
  > This 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…
- [NTSB FTW86LA155](https://openairdocs.org/ntsb/FTW86LA155.md): Cessna 172A · Gainesville, TX · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N7261T · Substantial damage
  > The 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…
- [NTSB FTW78FPD17](https://openairdocs.org/ntsb/FTW78FPD17.md): Cessna 172A · Brownwood, TX · Accident · No injuries · Closed · Apr 16, 1978 · N7751T · Substantial damage
- [NTSB FTW76DQG06](https://openairdocs.org/ntsb/FTW76DQG06.md): Cessna 172A · Rotan, TX · Accident · No injuries · Closed · Jul 5, 1975 · N7864T · Substantial damage
- [NTSB FTW74FPA01](https://openairdocs.org/ntsb/FTW74FPA01.md): Cessna 172 · Denison, TX · Accident · No injuries · Closed · Jul 21, 1973 · N7821T · Substantial damage
- [NTSB FTW73AF046](https://openairdocs.org/ntsb/FTW73AF046.md): Cessna 172 · Salt Flat, TX · Accident · 2 fatal · Closed · Feb 20, 1973 · N7546T · Destroyed
- [NTSB FTW70FPA12](https://openairdocs.org/ntsb/FTW70FPA12.md): Cessna 172 · Addison, TX · Accident · Minor injuries · Closed · Apr 20, 1970 · N7205T · Substantial damage
- [NTSB FTW70DRA03](https://openairdocs.org/ntsb/FTW70DRA03-201235.md): Cessna 172 · Tomball, TX · Accident · No injuries · Closed · Jan 3, 1970 · N7574T · Substantial damage
- [NTSB FTW70F0362](https://openairdocs.org/ntsb/FTW70F0362.md): Cessna 172A · Bertram, TX · Accident · No injuries · Closed · Dec 24, 1969 · N7573T · Substantial damage
- [NTSB FTW70A0037](https://openairdocs.org/ntsb/FTW70A0037.md): Cessna 172 · Saginaw, TX · Accident · 2 fatal · Closed · Nov 26, 1969 · N7271T · Destroyed
- [NTSB FTW69D0311](https://openairdocs.org/ntsb/FTW69D0311.md): Cessna 172 · Eldorado, TX · Accident · Minor injuries · Closed · Nov 9, 1968 · N7504T · Substantial damage
- [NTSB FTW69F0059](https://openairdocs.org/ntsb/FTW69F0059.md): Cessna 172A · Sivells Bend, TX · Accident · Serious injuries · Closed · Jun 29, 1968 · N7318T · Destroyed
- [NTSB FTW68D0518](https://openairdocs.org/ntsb/FTW68D0518.md): Cessna 172 · Everman, TX · Accident · No injuries · Closed · Apr 7, 1968 · N7270T · Substantial damage
- [NTSB FTW66F0460](https://openairdocs.org/ntsb/FTW66F0460.md): Cessna 172A · College Sta, TX · Accident · Serious injuries · Closed · Dec 19, 1965 · N7190T · Substantial damage
- [NTSB FTW66D0306](https://openairdocs.org/ntsb/FTW66D0306.md): Cessna 172 · Booker, TX · Accident · No injuries · Closed · Sep 3, 1965 · N9869T · Substantial damage
- [NTSB FTW66F0206](https://openairdocs.org/ntsb/FTW66F0206.md): Cessna 172 · San Antonio, TX · Accident · No injuries · Closed · Mar 26, 1965 · N7795T · Substantial damage
- [NTSB UNK65X1345](https://openairdocs.org/ntsb/UNK65X1345.md): Cessna 172 · Victoria, TX · Accident · No injuries · Closed · Jan 25, 1965 · N7262T · Destroyed
- [NTSB UNK65X0391](https://openairdocs.org/ntsb/UNK65X0391.md): Cessna 172 · Ralls, TX · Accident · Serious injuries · Closed · Oct 23, 1964 · N7321T · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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
```

This list as a web page: https://openairdocs.org/ntsb?model=2072404&state=TX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.