# NTSB investigations: Cessna 170, 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 CEN20LA415](https://openairdocs.org/ntsb/CEN20LA415.md): Cessna 170 · San Antonio, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 20, 2020 · N4019V · Substantial damage
  > The pilot’s inadequate compensation for gusting crosswind conditions while landing, which resulted a loss of lateral control and impact with a fence.
- [NTSB FTW90LA056](https://openairdocs.org/ntsb/FTW90LA056.md): Cessna 170 · Crockett, TX · Accident · No injuries · Limited investigation · Final report · Jan 13, 1990 · N6303D · Substantial damage
  > The failure of the main landing gear axle due to fatigue which led to a loss of control after touchdown.
- [NTSB FTW88LA128](https://openairdocs.org/ntsb/FTW88LA128.md): Cessna 170 · Marble Falls, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1988 · N2642V · Substantial damage
  > The pilot lost directional control during the lndg on runway 17. The aircraft collided with the terrain and trees after veering off the right side of the runway. The pilot reported a left quartering headwind of 25 knots gusting to 35 knots. The acft was…
- [NTSB FTW84LA232](https://openairdocs.org/ntsb/FTW84LA232.md): Cessna 170 · Victoria, TX · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N2539V · Substantial damage
  > The pilot stated that while on a long final approach power was reduced for descent. Shortly thereafter the throttle was applied but the engine failed to respond. The aircraft landed 100 yards short of rwy 17. The pilot stated after the accident that he…
- [NTSB FTW80DRG12](https://openairdocs.org/ntsb/FTW80DRG12.md): Cessna 170 · Johnson City, TX · Accident · No injuries · Closed · Dec 15, 1979 · N4153V · Substantial damage
- [NTSB FTW78DPA30](https://openairdocs.org/ntsb/FTW78DPA30.md): Cessna 170 · Sherman, TX · Accident · No injuries · Closed · Aug 11, 1978 · N4149V · Substantial damage
- [NTSB FTW77FRG66](https://openairdocs.org/ntsb/FTW77FRG66.md): Cessna 170 · Robstown, TX · Accident · No injuries · Closed · Aug 31, 1977 · N4108V · Substantial damage
- [NTSB FTW76AF083](https://openairdocs.org/ntsb/FTW76AF083.md): Cessna 170 · College Sta, TX · Accident · 4 fatal · Closed · Apr 4, 1976 · N5532C · Destroyed
- [NTSB FTW73FQG02](https://openairdocs.org/ntsb/FTW73FQG02.md): Cessna 170 · Dalhart, TX · Accident · Minor injuries · Closed · Jul 5, 1972 · N3923V · Substantial damage
- [NTSB FTW69D0427](https://openairdocs.org/ntsb/FTW69D0427.md): Cessna 170 · Cleburne, TX · Accident · No injuries · Closed · Mar 23, 1969 · N4289V · Substantial damage
- [NTSB FTW68F0564](https://openairdocs.org/ntsb/FTW68F0564.md): Cessna 170A · Shiro, TX · Accident · Minor injuries · Closed · Apr 28, 1968 · N5545A · Substantial damage
- [NTSB FTW68D0555](https://openairdocs.org/ntsb/FTW68D0555.md): Cessna 170 · Booker, TX · Accident · No injuries · Closed · Apr 17, 1968 · N3963V · Substantial damage
- [NTSB FTW67D0178](https://openairdocs.org/ntsb/FTW67D0178.md): Cessna 170A · Seminole, TX · Accident · No injuries · Closed · Aug 13, 1966 · N5532C · Substantial damage

## 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 ('2072302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072302&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.