# NTSB investigations: Cessna 170A, OK

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 CEN23LA140](https://openairdocs.org/ntsb/CEN23LA140.md): Cessna 170A · Oklahoma City, OK · Accident · No injuries · Class 4 · Limited · Final report · Mar 19, 2023 · N9254A · Substantial damage
  > The pilot’s loss of directional control during landing with wind gusts, which resulted in a runway excursion and nose over.
- [NTSB CEN18LA070](https://openairdocs.org/ntsb/CEN18LA070.md): Cessna 170 · Ponca City, OK · Accident · No injuries · Limited investigation · Final report · Jan 6, 2018 · N9972A · Substantial damage
  > The pilot's loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion.
- [NTSB FTW97LA372](https://openairdocs.org/ntsb/FTW97LA372.md): Cessna 170A · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N10433 · Substantial damage
  > The pilot's inadequate compensation for the crosswind conditions resulting in an inadvertent groundloop. Factors were the crosswind, the pilot's lack of total experience in make and model, the separation of the left main wheel due to corroded bolts, and the…
- [NTSB FTW83LA233](https://openairdocs.org/ntsb/FTW83LA233.md): Cessna 170A · Prague, OK · Accident · No injuries · Limited investigation · Final report · May 14, 1983 · N170KM · Substantial damage
  > While turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated…
- [NTSB FTW81FPM19](https://openairdocs.org/ntsb/FTW81FPM19.md): Cessna 170A · Ramona, OK · Accident · Minor injuries · Closed · Aug 12, 1981 · N9055A · Substantial damage
- [NTSB FTW70FPJ19](https://openairdocs.org/ntsb/FTW70FPJ19.md): Cessna 170A · Midwest City, OK · Accident · Serious injuries · Closed · May 17, 1970 · N9572A · Substantial damage
- [NTSB FTW70F0105](https://openairdocs.org/ntsb/FTW70F0105.md): Cessna 170 · Yukon, OK · Accident · No injuries · Closed · Jul 19, 1969 · N9526A · Substantial damage
- [NTSB FTW69F0120](https://openairdocs.org/ntsb/FTW69F0120.md): Cessna 170A · Piedmont, OK · Accident · No injuries · Closed · Jul 31, 1968 · N9572A · 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" = 'OK' 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 ('2072304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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