NTSB investigations: Bellanca 7GCBC

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

19822026

NTSB investigations: Bellanca 7GCBC per year, 1982–2026: 8 cases
1982	1
1983	2
1984	1
1986	1
1993	1
1995	1
1999	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" = 353)) 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\" = 353))
  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" = 353))
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 ANC00LA001Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. A factor associated with the accident was an unsuitable terrain condition for landing.Oct 3, 1999 · N4156Y · Substantial damage NTSB NYC95LA179Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Farmingdale, NJthe pilot's improper inflight decision and inaccurate fuel consumption calculations, resulting in a loss of engine power due to fuel exhaustion and a forced landing over unsuitable terrain.Jul 30, 1995 · N8610V · Substantial damage NTSB CHI93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bismarck, NDThe pilot's failure to refuel the airplane en route to ensure adequate fuel to complete the flight.Mar 11, 1993 · N88384 · Substantial damage NTSB ANC86LA061Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Valdez, AKExamination of the aircraft fuel system revealed that water was found in the fuel lines.May 24, 1986 · N8671V · Substantial damage NTSB ATL84LA192Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Tunica, MSThe non-rated plt stated that during a local flt, he flew over a water well drilling operation to survey the area. He reported that he circled at 500 ft 'indicate'. After surveying the area, he initiated a climb, but the eng lost power. Shortly after that,…Jun 2, 1984 · N4211Y · Substantial damage NTSB LAX83LA437Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Santa Barbara, CAWhile circling an area near Santa cruise island, CA. During aerial fish spotting operations, the acft eng began to lose pwr. As the acft apchd the island the eng sustained a complete pwr loss and nosed over drng the ensuing forced lndg. An eng exam revealed…Sep 12, 1983 · N8741V · Substantial damage NTSB NYC83LA108Accident · No injuriesLimited investigationFinal reportBellanca 7GBC · Middleboro, MAThe acft landed short of the runway after experiencing a power loss on the approach. The pilot had carburetor heat on and when he experienced a downdraft on final he said he opened the throttle and the engine quit. The acft was landed in the bushes short of…Apr 18, 1983 · N4163Y · Substantial damage NTSB FTW82DA190Accident · No injuriesFinal reportBellanca 7GCBC · Mt. Pleasant, TXAfter takeoff from runway 17, the pilot departed the traffic pattern and was about 1.5 miles north of the airport when the engine coughed. He immediately turned back toward the airport, but shortly thereafter, the engine lost all power. He decided to land on…May 22, 1982 · N5045G · Substantial damage