NTSB investigations: Bellanca 17-30A, 1991

5 cases on aircraft the registry lists as Bellanca 17-30A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19692026
NTSB investigations: Bellanca 17-30A, 1991 per year, 1969–2026: 255 cases
19691
19702
19712
19725
19738
197412
19759
19768
197715
19787
19796
198010
19816
19825
19835
19846
19856
19865
19874
19886
19894
19903
19915
19927
19933
19945
19954
19966
19975
19984
19994
20008
20014
20026
20031
20042
20054
20062
20073
20083
20091
20101
20113
20122
20133
20145
20152
20164
20175
20193
20201
20212
20222
20233
20244
20251
20262

Latest cases

Query with SQL
duckdb -csv -c "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\") = 1991
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220433'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB FTW92FA015Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Cotulla, TXThe pilot's failure to maintain aircraft control. Factors related to the accident were: darkness, and a short in the electrical system which resulted in partial failure of the instrument lights and a malfunction of the autopilot.Oct 28, 1991 · N6307Y · Substantial damageNTSB SEA91FA220Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Arlington, WYThe loss of engine power for an undetermined reason. Factors contriubting to the accident were trees and the pilot's failure to maintain adequate clearance above the trees.Aug 23, 1991 · N14698 · DestroyedNTSB CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..Aug 13, 1991 · N6704V · Substantial damageNTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.Feb 26, 1991 · N8290R · Substantial damageNTSB DEN91FA037Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Olton, TXThe pilot exceeded the design stress limits of the airframe and the performance of aerobatics at an altitude insufficient for recovery.Jan 26, 1991 · N4035B · Destroyed