# NTSB investigations: Cessna 170B: 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 ANC06CA050](https://openairdocs.org/ntsb/ANC06CA050.md): Cessna 170B · Chickaloon, AK · Accident · No injuries · Data collection · Final report · May 7, 2006 · N2396D · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor associated with the accident was the snow on the runway.
- [NTSB ANC04LA061](https://openairdocs.org/ntsb/ANC04LA061.md): Cessna 170B · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Jun 6, 2004 · N2631D · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing flare/touchdown. A factor contributing to the accident was soft tundra terrain.
- [NTSB ANC04LA008](https://openairdocs.org/ntsb/ANC04LA008.md): Cessna 170B · Manley Hot Sprg, AK · Accident · No injuries · Limited investigation · Final report · Nov 10, 2003 · N4448B · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was snow covered terrain at the landing strip.
- [NTSB ANC00LA031](https://openairdocs.org/ntsb/ANC00LA031.md): Cessna 170B · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Mar 5, 2000 · N2814C · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft, snow-covered terrain, and an inadvertent ground loop.
- [NTSB ANC97LA050](https://openairdocs.org/ntsb/ANC97LA050.md): Cessna 170 · Manley Hot Sprn, AK · Accident · No injuries · Limited investigation · Final report · Mar 31, 1997 · N4549C · Substantial damage
  > The pilot's selection of an unsuitable landing area. A factor was the soft snow.
- [NTSB ANC96LA153](https://openairdocs.org/ntsb/ANC96LA153.md): Cessna 170B · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1996 · N2989D · Substantial damage
  > the pilot's selection of unsuitable terrain for taxiing.
- [NTSB ANC92LA074](https://openairdocs.org/ntsb/ANC92LA074.md): Cessna 170B · Old Minto, AK · Accident · No injuries · Limited investigation · Final report · May 14, 1992 · N1805C · Substantial damage
  > The pilot's selection of unsuitable terrain. A factor relating to the accident was the ditch in the landing area.
- [NTSB SEA89LA108](https://openairdocs.org/ntsb/SEA89LA108.md): Cessna 170B · Gerlach, NV · Accident · No injuries · Limited investigation · Final report · Jun 12, 1989 · N2873C · Substantial damage
  > The pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.
- [NTSB ANC87LA054](https://openairdocs.org/ntsb/ANC87LA054.md): Cessna 170B · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Mar 19, 1987 · N3439D · Substantial damage
  > As the plt was taking off from a frozen lake with a ski equipped acft, it collided with a snowbank & was damaged. The plt rprtd that he had just landed a few minutes earlier & that the wind was blowing differently when he took off again. After the acdnt,…
- [NTSB MKC87LA014](https://openairdocs.org/ntsb/MKC87LA014.md): Cessna 170B · Hyannis, NE · Accident · No injuries · Limited investigation · Final report · Nov 3, 1986 · N8173A · Substantial damage
  > The pilot stated that he was servicing customers while on this business trip. On his next call, the pilot further stated, he was to land in a hay field that he had previously used but, due to water in the area, he elected to land on higher grounds. Upon…

## 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 ('2072306', '2072307')
    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=2072306&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.
