# NTSB investigations: Bellanca 17-31ATC, WY

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 SEA93LA145](https://openairdocs.org/ntsb/SEA93LA145.md): Bellanca 17-31ATC · Jackson Hole, WY · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1993 · N127WZ · Substantial damage
  > The pilot's selection of an empty fuel tank, and fuel starvation. Factors include rough/uneven terrain.
- [NTSB DEN84FA039](https://openairdocs.org/ntsb/DEN84FA039.md): Bellanca 17-31ATC · Moose, WY · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1983 · N107CB · Destroyed
  > The acft crashed shortly after takeoff in IFR weather. The plt failed to follow established departure procedures and in fact he did not even call in the fact that he had departed or his departure time as instructed by salt lake center. Attempts by salt lake…
- [NTSB DEN78FTC04](https://openairdocs.org/ntsb/DEN78FTC04.md): Bellanca 17-31 · Lander, WY · Accident · No injuries · Closed · Nov 8, 1977 · N1285R · 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" = 'WY' 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 ('1220437', '1250032'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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