# NTSB investigations: Bellanca 17-31ATC, 1983

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 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 DEN84LA024](https://openairdocs.org/ntsb/DEN84LA024.md): Bellanca 17-31ATC · Crested Butte, CO · Accident · No injuries · Limited investigation · Final report · Nov 14, 1983 · N14780 · Substantial damage
  > According to the plt, the ground was covered with about 6 inches of light snow & the wind was from the southwest at 5 to 10 KTS. A snow plow preceeded him to the rwy & had cleared a strip about 10 to 12 ft wide on the 1st 1/3 of the rwy. When the plt was…
- [NTSB NYC83FA254](https://openairdocs.org/ntsb/NYC83FA254.md): Bellanca 17-31ATC · Provincetown, MA · Accident · 3 fatal · Field investigation · Final report · Sep 11, 1983 · N28077 · Destroyed
  > The acft crashed in cape cod bay during a night x-country flt. Two sections of wooden wing identified as from the same make and model as the missing acft were recovered from the bay during the 3 days following the flt of the acft. Other identified parts of…

## 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 year(c."eventDate") = 1983
  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&year=1983

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