NTSB investigations: Bellanca 7GCBC, WA
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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1992 | 1 |
| 2018 | 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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
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 GAA18CA328Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arlington, WAThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.NTSB SEA92LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wenatchee, WAThe failure of the pilot to maintain directional control during landing, resulting in a ground loop and aircraft impact with terrain. A factor relating to the accident was the gusty wind conditions.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 SEA85LA075Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bremerton, WAThe acft bounced during landing and adequate recovery was not made. The acft came to rest inverted.NTSB SEA84FA164Accident · Serious injuriesField investigationFinal reportBellanca 7GCBC · Gorst, WAAccording to witnesses the acft departed rwy 19 & initiated a climbing left turn. The acft was then observed to increase angle of bank to the left and climb rate. At about 50 to 75 ft, the acft entered a steep uncontrolled descent & collide with the ground.…NTSB SEA80DYP03Accident · No injuriesClosedBellanca 7KCAB · College Place, WANTSB SEA78DYP51Accident · Minor injuriesClosedBellanca 7GCBC · Palouse, WA