NTSB investigations: Bellanca 7GCBC

7 cases on aircraft the registry lists as Bellanca 7GCBC, where the first occurrence was “In flight collision with terrain/water”. 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

19822026

NTSB investigations: Bellanca 7GCBC per year, 1982–2026: 7 cases
1982	1
1983	1
1985	1
1986	1
1987	1
1992	1
1998	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 ('1220601') 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" = 230)) 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 ('1220601')
      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\" = 230))
  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 ('1220601')
    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" = 230))
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 LAX98LA156Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Gorman, CAThe pilot's failure to maintain airspeed and an inadvertent stall while attempting to reverse direction in low cloud conditions in mountainous terrainMay 13, 1998 · N11867 · Destroyed NTSB NYC92LA121Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bedford, NHPhysical impairment of the pilot as the result of alcohol consumption, resulting in his failure or inability to maintain control of the airplane. Factors which contributed to the accident were: the pilot's poor judgement in buzzing residences and his failure…Jun 19, 1992 · N8736V · Substantial damage NTSB DEN88LA035Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newell, SDThe plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…Dec 6, 1987 · N2562Z · Substantial damage NTSB SEA86LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harlen, ORThe acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land.Apr 12, 1986 · N88415 · Destroyed NTSB SEA86FA020Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · N.Battle Moun., NVThe aircraft impacted the ground after attempting an aerobattic maneuver at about 300 feet AGL. Several witnesses observed the aircraft enter a loop or climbing roll and diveinto the ground. No evidence of failure or malfunction of the aircraft was found…Oct 30, 1985 · N5051C · Destroyed NTSB ANC83FA161Accident · 3 fatalField investigationFinal reportBellanca 7GCBC · Kasilof, AKThe acft crashed in a vertical nose down attitude a short distance from the plt's private airstrip. According to relatives the plt was taking his girl friend's 2 children for a short flt. Investigation revealed the plt's last known medical certificate was…Sep 5, 1983 · N88374 · Substantial damage NTSB LAX82DA035Accident · Minor injuriesFinal reportBellanca 7GCBC · San Clementine, CADuring flight, the pilot observed an area of sloping terrain that appealed to him as a prospective piece of land to purchase. He stated that he got too low and slow with the sun in his eyes as he circled the area. The right wing struck the ground and the…Jan 4, 1982 · N8630V · Substantial damage