NTSB investigations: Bellanca 7GCBC, 1985
7 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.
Cases per year
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 5 |
| 1973 | 13 |
| 1974 | 13 |
| 1975 | 10 |
| 1976 | 21 |
| 1977 | 16 |
| 1978 | 20 |
| 1979 | 19 |
| 1980 | 8 |
| 1981 | 11 |
| 1982 | 12 |
| 1983 | 10 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 10 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 2 |
| 1995 | 8 |
| 1996 | 1 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 2 |
| 2007 | 5 |
| 2008 | 7 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 2 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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" DESCRun 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 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…NTSB MKC86LA007Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dumas, AROn landing at a pvt sod strip near Dumas, the plt stated he encountered a strong crosswind. The crosswind forced his acft to veer off the side of the rwy. After veering off the rwy the right wing struck the ground sustaining substantial damage to the wing…NTSB ANC86LA001Accident · Serious injuriesLimited investigationFinal reportChampion Citabria 7GCBC · Ptarmigan Pass, AKThe pilot-in-command stated that just after departure. He spotted a moose and made a low circle above the moose. He leveled off and attempted to pull the aircraft up. The nose of the aircraft pitched down and the airplane crashed to the ground.NTSB SEA85LA172Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Moses Lake, WAA ground loop occurred during landing roll on rwy 36. The wind at touchdown was from 210 degs at 5 KTS. The twr did give the plt the current wind when the controller cleared him to land. The plt was aware that he would be landing with a left quartering tail…NTSB SEA85LA115Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCB · Yakutat, AKDuring arrival, the plt extended his traffic pattern to allow another acft to depart. He reported that after he turned on final apch, his acft encountered a downdraft & hit the ground short of the rwy.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.NTSB SEA85LA075Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bremerton, WAThe acft bounced during landing and adequate recovery was not made. The acft came to rest inverted.