# NTSB investigations: Cessna 170A: In flight collision with terrain/water

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 SEA98LA119](https://openairdocs.org/ntsb/SEA98LA119.md): Cessna 170A · Renton, WA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1998 · N1296D · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Failure to jettison the external load and downdrafts were factors.
- [NTSB FTW88FA160](https://openairdocs.org/ntsb/FTW88FA160.md): Cessna 170A · El Paso, TX · Accident · 4 fatal · Field investigation · Final report · Sep 3, 1988 · N9101A · Destroyed
  > Pilot's impairment due to the influence of alcohol.
- [NTSB NYC85LA253](https://openairdocs.org/ntsb/NYC85LA253.md): Cessna C-170A · Marathon, NY · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N5709C · Substantial damage
  > During an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel…
- [NTSB SEA85FA049](https://openairdocs.org/ntsb/SEA85FA049.md): Cessna 170A · Lopez, WA · Accident · 3 fatal · Field investigation · Final report · Jan 27, 1985 · N3845V · Destroyed
  > Shortly after departure N3845V joined up with another acft and was flying aprx 200-300 ft AGL in formation. The plt of N3845V then pulled up into what witnesses described as a wing over maneuver after which the acft descended to ground impact. One witness,…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072304')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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