NTSB investigations: Bellanca 17-30A, FL

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19722026

NTSB investigations: Bellanca 17-30A, FL per year, 1972–2026: 12 cases
1972	1
1976	1
1977	1
1978	2
1986	1
1987	1
1988	2
2007	1
2015	1
2024	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 ('1220433')) 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 ('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.

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 ('1220433'))
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 ERA24LA122Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Cape Coral, FLA total loss of engine power due to fuel starvation as a result of the pilot’s failure to properly secure a fuel supply line.Feb 24, 2024 · N282SV · Substantial damage NTSB GAA15CA209Accident · No injuriesData collectionFinal reportBellanca 17 30A · Tallahassee, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a forced landing on a road where the left wing impacted vegetation and sustained substantial damage.Jul 30, 2015 · N93582 · Substantial damage NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.Feb 17, 2007 · N6641V · Destroyed NTSB MIA88FA234Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Daytona Beach, FLThe acft departed spruce creek arpt and aprx 2 minutes later lost power and crashed into trees just west of the volusia county landfill aprx 4 miles northeast of the Daytona Beach regional arpt. Postcrash examination of the engine revealed the drain line on…Jul 24, 1988 · N28140 · Destroyed NTSB MIA88FA214Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Clearwater, FLThe private pilot experienced a rough running engine on takeoff roll and continued the takeoff. After liftoff the engine failed and he crashed into a residence. The engine fuel control and fuel divider block were found to have water, rust and sand in them.…Jul 5, 1988 · N399AC · Destroyed NTSB MIA87FA205Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Palatka, FLWitnesses stated that they heard the acft's eng sounding rough just before it crashed into the trees. Another witness stated that he noticed that there were flames & smoke coming from the left side of the plane. A tail pipe assembly was found on the ramp at…Jul 13, 1987 · N93664 · Destroyed NTSB MIA86LA107Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ft. Lauderdale, FLThe non-certificated student plt was making an unauthorized night solo x-country flt. He attempted a landing at his destination with a left 60 deg, 12 kt x-wind. During the landing roll the acft veered to the right and the plt correctedby applying 'extreme'…Mar 29, 1986 · N28007 · Substantial damage NTSB MIA79DLD12Accident · No injuriesClosedBellanca 17-30A · Orlando, FLNov 2, 1978 · N39832 · Substantial damage NTSB MIA78FKJ78Accident · No injuriesClosedBellanca 300 · Pensacola, FLAug 19, 1978 · N39842 · Substantial damage NTSB MIA77FLA44Accident · 1 fatalClosedBellanca 17-30A · Jacksonville, FLAug 4, 1977 · N14761 · Destroyed NTSB MIA76DLA57Accident · Minor injuriesClosedBellanca 17-30A · Vernon, FLSep 26, 1976 · N4089B · Substantial damage NTSB MIA73AM035Accident · 3 fatalClosedBellanca 17-30A · Lake Wales, FLSep 27, 1972 · N8800V · Destroyed