NTSB investigations: Bellanca 8GCBC

6 cases on aircraft the registry lists as Bellanca 8GCBC, where the first occurrence was “Airframe/component/system failure/malfunction”. 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

19842026

NTSB investigations: Bellanca 8GCBC per year, 1984–2026: 6 cases
1984	1
1986	1
1987	2
1988	1
1995	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220803') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220803')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220803')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.Aug 19, 1995 · N86587 · Destroyed NTSB LAX89LA024Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Phoenix, AZDuring the landing roll, the airplane began to veer to the right. The pilot applied hard left rudder for a few seconds, then the left main tire came off the rim. Subsequently, the left gear collapsed and the airplane came to rest partly off the runway.Oct 23, 1988 · N5504S · Substantial damage NTSB NYC87FA272Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Martha Vineyard, MAThe plt was involved in commerical fishing operations as a spotter and to direct the closing of nets around schools of tuna. While directing the closing of a net, the fish being netted reversed course and started to escape from the open net. The plt dove at a…Aug 18, 1987 · N5060K · Destroyed NTSB MKC87FA131Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Holdrege, NEWitnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the…Jul 8, 1987 · N87099 · Destroyed NTSB BFO86FA047Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Woodbine, MDWitnesses observed the aircraft nose over into a dive after the glider it had been towing released. They then saw it roll and during the roll the left wing departed the aircraft. The CFI in the glider had observed the pilot of N53899 perform what appeared to…Sep 14, 1986 · N53899 · Destroyed NTSB ANC84LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Aleknagik, AKThe acft crashed into trees short of a clearing during a forced landing following a prop failure. Post accident attemptsto identify the reasons for the failure were clouded by the impact damage. The acft was placarded warning against continuous high RPM…Aug 4, 1984 · N7662S · Substantial damage