NTSB investigations: Bellanca 7GCBC

6 cases on aircraft the registry lists as Bellanca 7GCBC, where the first occurrence was “Loss of engine power(partial) - nonmechanical”. 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

19832026

NTSB investigations: Bellanca 7GCBC per year, 1983–2026: 6 cases
1983	2
1985	1
2003	1
2006	1
2007	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" = 354)) 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\" = 354))
  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" = 354))
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 DEN07LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Basin, WYThe carburetor icing causing a partial loss of engine power, and the pilot's failure to maintain aircraft control leading to the inadvertent stall. A factor contributing to the accident was the conditions conducive for carburetor icing.Jul 25, 2007 · N88247 · Substantial damage NTSB NYC06LA167Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Toms River, NJCarburetor icing, and the pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent force landing. A factor in the accident was carburetor icing conditions.Jul 1, 2006 · N50619 · Substantial damage NTSB FTW03LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Houston, TXThe flight instructor's poor decision to initiate a simulated emergency without having a suitable area for a forced landing.May 10, 2003 · N711JJ · Substantial damage NTSB ANC85LA075Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Holitna River, AKDuring takeoff the plt noted a partial loss of power, the plt elected precautionary landing on the remaining frozen lake. During the turn the acft stalled and crashed. The fuel system was found contaminated with ice and water.Apr 27, 1985 · N31282 · Substantial damage NTSB NYC84LA050Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC Citabria · Nantucket, MAThe acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied…Dec 10, 1983 · N5041N · Substantial damage NTSB ANC83LA130Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7GCBC · Seward, AKThe pilot stated that he was flying at 200 feet AGL, at about 65 mph in a left turn, spotting fish for a fishing vessel when a map that was on his lap fell to the floor. When he reached for it his left hand hit the throttle, reducing power. Before he could…Jul 23, 1983 · N50509 · Substantial damage