Skip to content

NTSB investigations: Bellanca 7GCBC, WY

13 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

19732026

Where

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" = 'WY' 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\" = 'WY' 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" = 'WY' 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 WPR22LA244Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Afton, WYThe pilot's inadequate flare and bounced landing which resulted in loss of directional control of the airplane during the landing roll.Jul 10, 2022 · N50678 · Substantial damage NTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.Sep 7, 2019 · N5502S · Destroyed NTSB WPR10LA406Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Douglas, WYThe pilot's failure to maintain clearance from the terrain while maneuvering during an aerial observation flight.Aug 16, 2010 · N5034K · Substantial damage 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 SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.Sep 28, 1991 · N5505H · Substantial damage NTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.Jun 24, 1991 · N5530K · Substantial damage NTSB DEN83LA169Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Cody, WYThe acft groundlooped during landing and damaged the landing gear. The pilot had 80 hours in tailwheel acft but only 1.6IN the accident make and model. The landing was on rwy 22 and the wind was from 130 degrees at 10 to 12 KTS. The plt slipped the acft on…Jul 20, 1983 · N88399 · Substantial damage NTSB DEN82FTC06Accident · Serious injuriesFinal reportBellance 7GCBC · Pinedale, WYDuring a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over.Jun 23, 1982 · N57508 · Destroyed NTSB DEN82DA041Accident · No injuriesFinal reportBellanca 7GCBC · Thermopolis, WYDuring a landing in a hay meadow the pilot touched down long, due to a tailwind, and turned uphill to avoid hitting a fence and ditch. The aircraft ground looped breaking the right wheel strut.Mar 11, 1982 · N88247 · Substantial damage NTSB DEN79FTC03Accident · No injuriesClosedBellanca 7GCBC · Laramie, WYNov 11, 1978 · N8802 · Substantial damage NTSB DEN76DTC45Accident · No injuriesClosedBellanca 7GCBC · Saratoga, WYAug 19, 1976 · N53966 · Substantial damage NTSB DEN76DTC44Accident · No injuriesClosedBellanca 7GCBC · Glenrock, WYAug 12, 1976 · N8752 · Substantial damage NTSB DEN73DTC24Accident · No injuriesClosedBellanca 7GCBC · Rock River, WYApr 27, 1973 · N222WY · Substantial damage