NTSB investigations: Bellanca 17-30, FL

14 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

19672026

NTSB investigations: Bellanca 17-30, FL per year, 1967–2026: 14 cases
1967	1
1968	1
1969	2
1970	1
1972	2
1973	2
1974	1
1985	1
1988	1
2006	1
2008	1

Where

Open the map

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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  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 MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.Sep 12, 2008 · N4757V · Substantial damage NTSB MIA07CA015Accident · Minor injuriesData collectionFinal reportBellanca BL-17-30 · Lantana, FLThe pilot's improper preflight planning/decision which resulted in total loss of engine power due to fuel exhaustion.Nov 13, 2006 · N6663V · Substantial damage NTSB MIA88FA134Accident · Minor injuriesField investigationFinal reportBellanca 17-30 · Daytona Beach, FLThe plt stated that he had filled the main tanks and nearly filled the two aux tanks earlier and had flown for about 1 hr using one of the aux tanks for cruise. He had just taken off using the mains & when he leveled at 2600 ft, he switched to one of the aux…Mar 30, 1988 · N4927V · Destroyed NTSB MIA85LA136Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Melbourne, FLThe acft was departing on rwy 27L, when aprx 1200 ft down the rwy, on the takeoff roll, it veered off the left side of the rwy & crossed two taxiways. The acft came to rest about 350 ft off the left side of rwy 27L. A post crash exam of the landing gear…Mar 29, 1985 · N7390V · Substantial damage NTSB MIA74DKT87Accident · Minor injuriesClosedBellanca 17-30 · Pompano Beach, FLJun 12, 1974 · N7382V · Substantial damage NTSB MIA74DLD53Accident · No injuriesClosedBellanca 17-30 · Tampa, FLAug 5, 1973 · N4846V · Substantial damage NTSB MIA73FLD02Accident · Minor injuriesClosedBellanca 17-30 · Orlando, FLJul 5, 1973 · N4875V · Substantial damage NTSB MIA72FLA31Accident · No injuriesClosedBellanca 17-30 · Jacksonville, FLMar 4, 1972 · N4720V · Substantial damage NTSB MIA72AM078Accident · 3 fatalClosedBellanca 17-30 · Venice, FLFeb 5, 1972 · N7323V · Destroyed NTSB MIA70DKT11Accident · No injuriesClosedBellanca 17-30 · Summerlnd Key, FLMar 30, 1970 · N7379V · Substantial damage 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 MIA68D0373Accident · No injuriesClosedBellanca 17-30 · Lake Wales, FLJan 5, 1968 · N4757V · Substantial damage NTSB MIA68D0392Accident · No injuriesClosedBellanca 17-30 · Ft Lauderdale, FLDec 30, 1967 · N6687V · Substantial damage