NTSB investigations: Bellanca 7GCBC
10 cases on aircraft the registry lists as Bellanca 7GCBC, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220601')
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\" = 130))
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 ('1220601')
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" = 130))
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 MIA08FA003Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Newton, GAThe failure of the right wing wooden spar due while the airplane was in cruise flight, due to the mechanic's inadequate annual inspection and his failure to comply with an airworthiness directive.NTSB LAX07CA288Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Laurel, MTCorrosion and fatigue-induced failure of the landing gear structure.NTSB SEA05LA056Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Prineville, OROther maintenance personnel's inadequate reassembly of the tail wheel assembly and the left main landing gear breaking assembly resulting in an inadvertent loss of control during the landing roll. Contributing factors were the pilot's inadvertent swerve…NTSB IAD03CA060Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Atlantic City, NJThe pilot's failure to properly secure an aerial advertising banner to the outside of the airplane.NTSB LAX01LA189Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Reno, NVFailure of the left main landing gear axle due to an improper weld repair.NTSB LAX95LA240Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Long Beach, CAthe inadvertent entanglement of the banner tow cable with the rudder control system, which resulted in a full and uncorrectable deflection of the rudder, and the pilot's inability to control the aircraft.NTSB SEA93LA038Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Arco, IDA leaking crankshaft oil seal, and snow on the landing area.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 NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…NTSB SEA87LA157Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · North Plains, ORThe plt rprtd that drg a x-wind lndg, the acft touched down on the rgt main gear, then after rolling aprx 50 to 100 ft, the left main gear touched down. As the left wheel touched down, the left axle failed, pitching the acft on its nose. The acft then skidded…