NTSB investigations: Bellanca 7GCBC, 1989
8 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\") = 1989
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") = 1989
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 MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB ANC89LA134Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Chitina, AKThe pilot's failure to maintain airspeed during climb out, which resulted in the acft stalling and impacting the terrain.NTSB ANC89LA116Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Killey River, AKThe pilot failed to assure sufficient alt was obtained to compensate for the downdrafts near the ridge line.NTSB ANC89FA057Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Eklutna, AKThe pilot diverted his attention and failed to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB SEA89LA063Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sitka, AKThe pilot's continuing the takeoff despite the large boat wake and gusting wind. A contributing factor was the pilot's low flight time in this type of aircraft.NTSB NYC89LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Lakewood, NJThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the crosswind conditions.NTSB ATL89FA088Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Jackson, GAThe pilot's improper handling of the airplane which resulted in an inadvertent stall/spin and subsequent collision with terrain. Factors contributing to the accident were the pilot's decision to perform aerobatic maneuvers at low altitude, and complacency…NTSB LAX89FA083Accident · Serious injuriesField investigationFinal reportPitts S2B · Ramona, CAThe Pitts pilot's inadequate visual lookout. Contributing factor(s) was: inadequate radio communications by the Pitts pilot.