# NTSB investigations: Bellanca 17-31A: Loss of engine power(total) - nonmechanical

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 SEA92LA063](https://openairdocs.org/ntsb/SEA92LA063.md): Bellanca 17-31A · Eugene, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1992 · N8266R · Substantial damage
  > An improper fuel boost pump selector position, and incorrect procedures. Factors include an improper fuel tank selector position, and fuel starvation.
- [NTSB NYC90LA163](https://openairdocs.org/ntsb/NYC90LA163.md): Bellanca 17-31A · Wilmington, OH · Accident · No injuries · Limited investigation · Final report · Jul 16, 1990 · N93666 · Substantial damage
  > A power loss caused by fuel exhaustion when the pilot took off with the fuel selector on the empty fuel tank.
- [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…

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

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

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