NTSB investigations: Bellanca 7GCBC, FL

12 cases on aircraft the registry lists as Bellanca 7GCBC. 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

19792026

NTSB investigations: Bellanca 7GCBC, FL per year, 1979–2026: 12 cases
1979	4
1981	2
1982	1
1987	1
1991	1
1998	1
2009	1
2018	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 ('1220601')) 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 ('1220601'))
  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 ('1220601'))
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 GAA18CA517Accident · No injuriesData collectionFinal reportChampion 7GCBC · Ocklawaha, FLThe pilot’s failure to maintain directional control during landing.Aug 25, 2018 · N7618S · Substantial damage NTSB ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.Dec 24, 2009 · N8634V · Substantial damage NTSB ATL98LA071Accident · Serious injuriesLimited investigationFinal reportBellanca 7-GCBC · Sebring, FLThe pilot's improper handling of the airplane which led to an inadvertent stall. A factor was the loss of engine power for undetermined reasons.May 3, 1998 · N4ME · Destroyed NTSB MIA92FA008Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Key West, FLFailure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin at an altitude that was too low for recovery. A factor related to the accident was: the pilot's failure to jettison the banner when the stall was encountered.Oct 8, 1991 · N4155Y · Substantial damage NTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…Apr 5, 1987 · N8678V · Substantial damage NTSB MIA83LA052Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · New Port Richey, FLAccording to the instructor (CFI), the tail wheel equipped aircraft veered left and headed toward trees after the tail rose, but while the main wheels were still on the ground. He attempted to recover with right rudder and brakes. Fearing a ground loop, the…Dec 18, 1982 · N88214 · Substantial damage NTSB MIA81DLA28Accident · Minor injuriesClosedBellanca 7GCBC · New Smyrna Bch, FLJun 6, 1981 · N87069 · Substantial damage NTSB MIA81FA066Accident · 2 fatalClosedBellanca 7GCBC · St Augustine, FLApr 18, 1981 · N5063K · Destroyed NTSB MIA80FLD23Accident · No injuriesClosedBellanca 7GCBC · Tampa, FLNov 18, 1979 · N5045G · Substantial damage NTSB MIA79FLA46Accident · Serious injuriesClosedBellanca 7GCBC · Ormond Beach, FLAug 24, 1979 · N53753 · Destroyed NTSB MIA79FLA32Accident · Serious injuriesClosedBellanca 7GCBC · Daytona Beach, FLJun 19, 1979 · N57498 · Destroyed NTSB MIA79FKT62Accident · Serious injuriesClosedBellanca 7GCBC · Miami, FLApr 28, 1979 · N2670Z · Destroyed