# NTSB investigations: Cessna 170A: On ground/water encounter 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 ANC03LA105](https://openairdocs.org/ntsb/ANC03LA105.md): Cessna 170 · Seward, AK · Accident · No injuries · Limited investigation · Final report · Aug 30, 2003 · N1293D · Substantial damage
  > The pilot's selection of unsuitable terrain for landing which resulted in a nose over during the landing roll. A factor contribuiting to the accident was the presence of soft sand.
- [NTSB FTW99LA246](https://openairdocs.org/ntsb/FTW99LA246.md): Cessna 170A · Brady, TX · Accident · No injuries · Limited investigation · Final report · Sep 3, 1999 · N3865V · Substantial damage
  > The pilot's failure to maintain clearance from a dirt bank.
- [NTSB ANC97LA032](https://openairdocs.org/ntsb/ANC97LA032.md): Cessna 170A · Willow, AK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1997 · N1364D · Substantial damage
  > The pilot's excessive speed while taxiing. A factor in the accident was flat light conditions.
- [NTSB CHI91LA143](https://openairdocs.org/ntsb/CHI91LA143.md): Cessna 170A · Newell, SD · Accident · No injuries · Limited investigation · Final report · Apr 24, 1991 · N5720C · Substantial damage
  > The pilot's improper aircraft handling.
- [NTSB ANC82DAG18](https://openairdocs.org/ntsb/ANC82DAG18.md): Cessna 170 · Big Lake, AK · Accident · Minor injuries · Final report · Apr 25, 1982 · N170DM · Substantial damage
  > During a local flight, the pilot elected to land at the Big Lake airport. Before landing, he noted that weather was moving in from the northwest. Also, he noted that the wind sock was limp, but favored a landing to the west. He landed, and before taking off…

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

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

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