Skip to content

NTSB investigations: Bellanca 8GCBC

186 cases on aircraft the registry lists as Bellanca 8GCBC. 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, newest first

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')) 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'))
  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'))
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 ATL85LA139Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNPilot lost directional control during landing and skidded of the left side of runway. Pilot reported windshift.Apr 18, 1985 · N86756 · Substantial damage NTSB NYC85LA075Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Colts Neck, NJThe plt returned to the arpt after a glider tow flt to land. During a 3-point touchdown, the acft hit a rut & bounced in the air. The plt recovered & made another 3-point touchdown, then heard a 'loud crack' & saw the right main gear separate. He stated that…Mar 9, 1985 · N2558Z · Substantial damage NTSB DEN85LA061Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Newburg, NDPlt attempted takeoff on a slippery, snow covered field with a 45 degree x-wind. Acft veered during the takeoff ground run and left main gear sheared off after contacting a snowbank.Jan 5, 1985 · N5046C · Substantial damage NTSB SEA84LA227Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kasaan Penninsu, AKPlt attempted takeoff from glassy water with a deer tied to the left float. The right float would not come up on the step to attain lift off. The pilot's decision to abort was too late to avoid a collision with rocks at the end of the lake.Sep 13, 1984 · N86922 · Substantial damage 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 NTSB FTW84LA278Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Spiro, OKThe plt stated that while landing in an alfalfa field, he made the approach at a higher than normal speed. Subsequently, the acft overran the alfalfa field & went into a plowed field where it nosed over.Jun 20, 1984 · N5060K · Substantial damage NTSB MIA83LA194Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City, FLThe plt reported that as he was recovering from the 1st banner tow mission, he noted a line of cumulus buildups moving northerly from over the gulf toward the arpt. He elected not to pick up another banner. He planned just to drop the banner he was towing,…Aug 1, 1983 · N88477 · Destroyed NTSB LAX83LUQ05Accident · No injuriesFinal reportPiper PA-38-112 · Rosamond, CAA Piper PA-38, N9905T, and a Bellanca 8GCBC, N8667V, collided at the intersection of rwys 22 & 25, while the acft were landing. The Piper PA-38 was on a dual instructional flt while the Bellanca was being used to tow gliders. The aircrew in the PA-38 saw the…Jul 16, 1983 · N9905T · 2 aircraft · Substantial damage NTSB ANC83LA081Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Twin Hills, AKThe acft nosed over during takeoff when the landing gear dug into the soft sand. The weather was VMC but the wind was gusting up to 40 mph. The pilot did not claim any problems with the wind or the acft but he did have a strong crosswind. The accident site…May 16, 1983 · N5042Q · Substantial damage NTSB ANC83FA042Accident · 3 fatalField investigationFinal reportBellanca 8GCBC · Melozi Hot Spgs, AKAcft deptd a private airstrip with no flt plan and was later reported overdue. Acft wreckage was found on sept. 27, 1984. Debris was scattered near the bottom of a 1000 ft box canyon cliff. The main fuselage was found in a lake at the bottom of the canyon.…Feb 1, 1983 · N8639V · Destroyed NTSB ANC82DAA12Accident · No injuriesFinal reportCitabria 8GCBC · Minchumina, AKThe plt selected a proposed landing site adjacent to a lake, & after 4 or 5 low passes decided to "drag" the site by rolling the main gear on the ground to determine its suitability for a landing. The plt intended to mark the ground withthe acft tires & then…Aug 22, 1982 · N88264 · Substantial damage NTSB DEN82DA102Accident · No injuriesFinal reportBellanca 8GCBC · Philip, SDThe pilot flew to an open field where he landed to work on a truck. While he was working on the truck, the wind increased to the point that he was afraid to leave the aircraft on the ground. When he got in the plane, the wind prevented him from turning and…Jun 6, 1982 · N86993 · Substantial damage NTSB ATL82DA053Accident · Minor injuriesFinal reportBellanca 8GCBC · Stevensville, MDThe pilot landed with 10 degrees of flaps in a 10 to 15 knot, left crosswind condition. He reported that wind gusts picked up the left wing and he was unable to adequately compensate with power and aileron. The aircraft became airborne and then hit the ground…Feb 15, 1982 · N53899 · Substantial damage NTSB ANC82DAA01Accident · No injuriesClosedBellanca 8GCBC · Tanana, AKOct 19, 1981 · N2810Z · Substantial damage NTSB MIA81DKJ15Accident · No injuriesClosedBellanca 8GCBC · Destin, FLAug 21, 1981 · N86985 · Substantial damage NTSB LAX81DUQ30Accident · Minor injuriesClosedBellanca 8GCBC · California Cy, CAAug 8, 1981 · N240SS · Substantial damage NTSB DEN81FTG12Accident · 1 fatalClosedBellanca 8GCBC · Rugby, NDJun 24, 1981 · N8558V · Substantial damage NTSB ANC81FA058Accident · 1 fatalClosedBellanca 8GCBC · Palmer, AKMay 2, 1981 · N8757V · Destroyed NTSB ANC81DA026Accident · No injuriesClosedBellanca 8GCBC · Umiat, AKMar 5, 1981 · N8635V · Substantial damage NTSB ANC80FA104Accident · 2 fatalClosedBellanca 7GCBC · Anchorage, AKSep 29, 1980 · N2975E · Substantial damage NTSB ANC80FA096Accident · 2 fatalClosedBellanca 8GCBC · Glenallen, AKSep 1, 1980 · N88286 · Destroyed NTSB ATL80FA077Accident · 1 fatalClosedBellanca 8GCBC · Banks, MSJul 24, 1980 · N8652V · Destroyed NTSB ANC80DAG54Accident · No injuriesClosedBellanca 8GCBC · Kashwitna Riv, AKMay 7, 1980 · N57690 · Substantial damage NTSB FTW80FPJ17Accident · No injuriesClosedBellanca 8GCBC · Enid, OKMay 6, 1980 · N86782 · Destroyed NTSB ANC80DA042Accident · No injuriesClosedBellanca 8GCBC · Kodiak, AKApr 25, 1980 · N2975Q · Substantial damage NTSB LAX80DXQ16Accident · No injuriesClosedBellanca 8GCBC · Carson City, NVFeb 8, 1980 · N88127 · Substantial damage NTSB DEN79FTE86Accident · No injuriesClosedBellanca 8GCBC · Wellington, COSep 26, 1979 · N7871S · Destroyed NTSB DEN79DTC27Accident · No injuriesClosedBellanca 8GCBC · Jackson, WYSep 22, 1979 · N5052W · Substantial damage NTSB ANC79DA095Accident · No injuriesClosedBellanca 8GCBC · Old Harbor, AKSep 20, 1979 · N86932 · Substantial damage NTSB NYC79FNA28Accident · No injuriesClosedBellanca 8GCBC · Plymouth, MAAug 18, 1979 · N50548 · Substantial damage NTSB MIA79DLG30Accident · No injuriesClosedBellanca 8GCBC · Sycamore, SCAug 17, 1979 · N7686S · Destroyed NTSB ANC79DAG84Accident · No injuriesClosedBellanca 8GCBC · Glenallen, AKAug 17, 1979 · N88436 · Substantial damage NTSB MKC79DER61Accident · No injuriesClosedBellanca 8GCBC · Federal Dam, MNAug 5, 1979 · N7695S · Substantial damage NTSB LAX79DUQ43Accident · No injuriesClosedBellanca 8GCBC · Rosamond, CAAug 4, 1979 · N8667V · Substantial damage NTSB SEA79DYM40Accident · No injuriesClosedBellanca 8GCBC · The Dalles, ORJun 14, 1979 · N4143Y · Substantial damage NTSB ANC79DAG63Accident · Minor injuriesClosedBellanca 8GCBC · Glenallen, AKJun 4, 1979 · N7673S · Substantial damage NTSB LAX79DUJ46Accident · No injuriesClosedBellanca 8GCBC · Dateland, AZFeb 16, 1979 · N2558Z · Substantial damage NTSB DEN79DTM09Accident · No injuriesClosedBellanca 8GCBC · Thompson, UTJan 20, 1979 · N53787 · Substantial damage NTSB MIA78FLG33Accident · No injuriesClosedBellanca 8GCBC · Ulmer, SCAug 25, 1978 · N7686S · Substantial damage NTSB MIA78FLD59Accident · Minor injuriesClosedBellanca 8GCBC · Clearwater, FLJul 4, 1978 · N7659S · Substantial damage NTSB FTW78FPJ29Accident · 1 fatalClosedBellanca 8GCBC · Hinton, OKJul 1, 1978 · N86899 · Destroyed NTSB OAK78DVG40Accident · No injuriesClosedBellanca 8GCBC · Vacaville, CAMay 25, 1978 · N8599V · Substantial damage NTSB DEN78FA042Accident · 2 fatalClosedBellanca 8GCBC · Nunn, COMay 13, 1978 · N8658V · Substantial damage NTSB ANC78DAG47Accident · No injuriesClosedBellannca 8GCBC · Willow, AKApr 12, 1978 · N86922 · Substantial damage NTSB MIA78DKJ22Accident · No injuriesClosedBellanca 8GCBC · Baker, FLFeb 19, 1978 · N88432 · Substantial damage NTSB FTW78DQG06Accident · No injuriesClosedBellanca 8GCBC · Olton, TXOct 25, 1977 · N7616S · Substantial damage NTSB FTW78DPG03Accident · No injuriesClosedBellanca 8GCBC · Marianna, AROct 12, 1977 · N8558V · Substantial damage NTSB SEA77DYM61Accident · No injuriesClosedBellanca 8GCBC · Baker, ORAug 27, 1977 · N86714 · Substantial damage NTSB ANC77DAG51Accident · No injuriesClosedBellanca 8GCBC · Anchorage, AKJul 28, 1977 · N88266 · Substantial damage NTSB MKC77FA028Accident · 1 fatalClosedBellanca 8GCBC · Mound City, MOJun 22, 1977 · N88167 · Destroyed