NTSB investigations: Bellanca 8GCBC, 1995
6 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.
Cases per year
| 1974 | 6 |
|---|---|
| 1975 | 10 |
| 1976 | 7 |
| 1977 | 18 |
| 1978 | 7 |
| 1979 | 12 |
| 1980 | 7 |
| 1981 | 6 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 6 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 5 |
| 2008 | 3 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 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\") = 1995
AND 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 year(c."eventDate") = 1995
AND 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" 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 ANC96LA014Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Yakutat, AKThe pilot's attempt to fly into known adverse weather, not maintaining a proper forward visual lookout, and not maintaining a proper altitude while maneuvering the airplane for landing.NTSB ANC96TA011Accident · Minor injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's inadequate recovery from a bounced landing. The snow-covered landing surface and the pilot's decision not to perform a go-around were factors.NTSB BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.NTSB FTW95LA279Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Wellington, COFatigue failure of the left main landing gear (spring strut), due to the improper maintenance (grinding) by unknown maintenance personnel.NTSB ANC95TA054Accident · No injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to verify the position of the parking brake knob prior to landing.NTSB ANC95LA033Accident · No injuriesLimited investigationFinal reportChampion 8GCBC · Fairbanks, AKThe pilot's inadequate pre-flight planning. A short takeoff area that was covered with soft snow were factors in the accident.