# NTSB investigations: Bellanca 17-31A, 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 MKC83LA150](https://openairdocs.org/ntsb/MKC83LA150.md): Bellanca 17-31A · Greensburg, KS · Accident · No injuries · Limited investigation · Final report · Jul 9, 1983 · N6575V · Substantial damage
  > The pilot stated that the auxiliary tank ran dry and the engine quit. He switched the tank selector to the right main fuel tank which had ample fuel but he was unable to restart the engine. He made a forced landing on a highway and after touchdown the left…
- [NTSB ATL83FA176](https://openairdocs.org/ntsb/ATL83FA176.md): Bellanca 17-31A · Waverly, GA · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1983 · N8855V · Destroyed
  > The acft crashed into trees during an instrument approach at night in stormy weather. Both the CFI, seated in the front left seat, & the new owner of the acft, were fatally injured. An IFR flt plan was filed & the CFI had obtained 2 wx briefings prior to…

## 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 ('1220435', '1250031'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1220435&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.