Skip to content

Fatal NTSB investigations: Bellanca 17-30

26 cases on aircraft the registry lists as Bellanca 17-30. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

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

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 c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220432', '1250020'))
  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.

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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220432', '1250020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX00FA324Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Scottsdale, AZthe pilot's failure to maintain adequate terrain clearance during a cruise descent, which resulted in controlled flight into mountainous terrain during dark night conditions. Contributing factors were the rain, thuderstorm, and dust storm weather conditions,…Aug 23, 2000 · N4905V · Destroyed NTSB DEN00FA135Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Lake City, COthe pilot's inadequate flight planning and preparation, and his inadvertent flight into adverse weather during a cross-country flight over mountainous terrain. Contributing factors were, the cloudy obscuration weather condition, the high density altitude, and…Nov 10, 1999 · N6691V · Destroyed NTSB CHI98LA059Accident · 2 fatalLimited investigationFinal reportBellanca 17-30 · Independence, KSthe pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.Dec 8, 1997 · N4854V · Destroyed NTSB FTW92FA061Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Oklahoma City, OKThe second pilot's (left seat) failure to attain a positive rate-of-climb during an instrument takeoff, and inadequate supervision by the pilot-in-command. Factors were: the weather, and the copilot's lack of instrument flight time and training.Jan 29, 1992 · N4869V · Substantial damage NTSB ATL86FA223Accident · 2 fatalField investigationFinal reportBellanca 17-30 · West Green, GAThe plt took off at 1259 EDT, & at 1318, he reported level at 10,000'. There was no further comm with the acft. At about 1342, radar contact was lost. Subsequently, the acft wreckage was fnd scattered over a 425 yd area, along a sw azmith, aprx 1/2 mi from…Aug 21, 1986 · N6655V · Destroyed NTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNov 19, 1978 · N7320V · Destroyed NTSB LAX78FUG46Accident · 1 fatalClosedCessna 150B · Rialto, CAAug 4, 1978 · N1161Y · 2 aircraft · Destroyed NTSB LAX78FA005Accident · 2 fatalClosedBellanca 17-30 · Fullerton, CANov 13, 1977 · N6572V · Destroyed NTSB LAX77FA068Accident · 2 fatalClosedBellanca 17-30 · San Dimas, CAAug 30, 1977 · N4889V · Destroyed NTSB DEN77FA021Accident · 1 fatalClosedBellanca 17-30 · Acomita, NMJan 21, 1977 · N7352V · Destroyed NTSB FTW77FA007Accident · 1 fatalClosedBellanca 17-30 · Seguin, TXOct 15, 1976 · N4819V · Destroyed NTSB FTW76AF124Accident · 1 fatalClosedBellanca 17-30 · Eagletown, OKSep 18, 1976 · N4885V · Destroyed NTSB SEA76AS034Accident · 3 fatalClosedBellanca 17-30 · Orofino, IDJan 15, 1976 · N7385V · Destroyed NTSB FTW75AF058Accident · 4 fatalClosedBellanca 17-30 · Mena, ARMar 12, 1975 · N4930V · Destroyed NTSB NYC75AN088Accident · 2 fatalClosedBellanca 17-30 · Newton, NJMar 2, 1975 · N4723V · Destroyed NTSB FTW74AF070Accident · 2 fatalClosedBellanca 17-30 · N.Little Rock, ARApr 3, 1974 · N6678V · Destroyed NTSB MIA72AM078Accident · 3 fatalClosedBellanca 17-30 · Venice, FLFeb 5, 1972 · N7323V · Destroyed NTSB DEN72AD008Accident · 4 fatalClosedBellanca 17-30 · Hachita, NMAug 28, 1971 · N7307V · Destroyed NTSB LAX71AL041Accident · 5 fatalClosedPiper PA-24 · Sacaton, AZDec 28, 1970 · N6664P · 2 aircraft · Destroyed NTSB LAX71AL038Accident · 3 fatalClosedBellanca 17-30 · Queen Creek, AZDec 13, 1970 · N7384V · Destroyed NTSB OAK70AP051Accident · 1 fatalClosedBellanca 17-30 · San Rafael, CAApr 18, 1970 · N4804V · Destroyed NTSB FTW70AF062Accident · 2 fatalClosedBellanca 17-30 · Leander, TXMar 27, 1970 · N6565V · Destroyed NTSB MIA70A0025Accident · 3 fatalClosedBellanca 17-30 · Brooksville, FLSep 30, 1969 · N6673V · Destroyed NTSB MIA69A0065Accident · 2 fatalClosedBellanca 17-30 · Daytona Beach, FLApr 12, 1969 · N4868V · Destroyed NTSB MKC69A0004Accident · 2 fatalClosedBellanca 17-30 · Lees Summit, MOJul 25, 1968 · N4746V · Destroyed NTSB LAX68A0094Accident · 2 fatalClosedBellanca 17-30 · Kayenta, AZApr 21, 1968 · N4816V · Destroyed