NTSB investigations: Bellanca 8GCBC
10 cases on aircraft the registry lists as Bellanca 8GCBC, where the first occurrence was “Nose over”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 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\" = 300))
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" = 300))
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 LAX05LA245Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Oroville, CAa binding and/or activation of the brakes that lead to an inadvertent nose over. The underlying root cause of the brake binding/activation could not be determined.NTSB LAX01LA230Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Nixon, NVThe pilot’s failure to attain the proper touchdown point and his misjudged distance/speed during landing rollout. Factors were the tailwind condition and the downhill landing area.NTSB ATL98LA087Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Pensacola, FLThe pilot's inadvertent activation of the parking brakes which resulted in the nose over during the landing roll.NTSB SEA96LA109Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Richland, WAthe pilot's failure to perform a go-around and his subsequent excessive use of the aircraft brakes. The short airstrip length and the pilot's excessive airspeed for the approach were related factors.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 ANC95TA054Accident · No injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to verify the position of the parking brake knob prior to landing.NTSB ATL93LA094Accident · No injuriesLimited investigationFinal reportBellanca GC-BC · Panama City, FLThe failure of the pilot to maintain control of the aircraft and his poor inflight decision to attempt a downwind landing at the 975 foot airfield. A factor was the tail wind condition which existed at the airfield at the timeNTSB CHI88LA085Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Indianapolis, INFifteen minutes after the pilot had taken off on a tow plane operation he returned to the local arpt. After landing he turned downwind to taxi to the ramp. The wind raised the tail of the tailwheel acft and nosed the acft inverted. The pilot estimated the…NTSB ANC83LA081Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Twin Hills, AKThe acft nosed over during takeoff when the landing gear dug into the soft sand. The weather was VMC but the wind was gusting up to 40 mph. The pilot did not claim any problems with the wind or the acft but he did have a strong crosswind. The accident site…NTSB ANC82DAA12Accident · No injuriesFinal reportCitabria 8GCBC · Minchumina, AKThe plt selected a proposed landing site adjacent to a lake, & after 4 or 5 low passes decided to "drag" the site by rolling the main gear on the ground to determine its suitability for a landing. The plt intended to mark the ground withthe acft tires & then…