NTSB investigations: Bellanca 8GCBC
10 cases on aircraft the registry lists as Bellanca 8GCBC, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220803')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX05LA241Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Beaumont, CAthe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall/mush. The pilot's delayed decision to release the banner was also causal.NTSB CHI04CA169Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Mankato, MNThe pilot's improper decision to initiate the flight given the crosswind wind condition. Additional causes were the pilot's inadequate compensation for the crosswind and his subsequent failure to maintain aircraft control. The crosswind and the runway light…NTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.NTSB ATL97LA106Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Bunnell, FLthe pilot's failure to ensure the airplane had adequate airspeed for banner pickup/towing operations, which resulted in a stall/mush and subsequent contact with the terrain.NTSB IAD97LA010Accident · Minor injuriesLimited investigationFinal reportBellanca BL28 · Ledbetter, KYthe pilot's delay in executing a go-around, and his failure to obtain/maintain adequate airspeed, which resulted in a stall and collision with the ground.NTSB ATL94LA112Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Summerdale, ALThe pilot's failure to maintain airspeed during takeoff.NTSB FTW94GA076Accident · 2 fatalFinal reportBellanca 8GCBC · Usaf Academy, COLoss of control in flight for an undetermined reason.NTSB BFO93FA119Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Berlin, MDFailure of the pilot to maintain airspeed during pullup from an attempted banner pickup, which resulted in a stall.NTSB ATL88LA170Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNThe flt was being accomplished to refamiliarize the commercial plt with the airplane prior to completing the remainder of the training curriculum. One takeoff and ldg had been completed without incident. During the second approach to landing, it was related…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,…