NTSB investigations: Bellanca 8KCAB
12 cases on aircraft the registry lists as Bellanca 8KCAB, where the first occurrence was “In flight collision with terrain/water”. 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 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 2000 | 1 |
| 2007 | 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 ('1220801')
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\" = 230))
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 ('1220801')
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" = 230))
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 ANC07LA036Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Girdwood, AKThe pilot's failure to maintain sufficient altitude/clearance from terrain while maneuvering, which resulted in an in-flight collision with a glacier. Factors contributing to the accident were snow-covered terrain, and flat light conditions.NTSB CHI00FA186Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Capron, ILThe pilot attempting an aerobatic maneuver at a low altitude and the pilot not maintaining clearance from the terrain. A factor to the accident was the pilot disregarding the federal aviation regulations concerning the minimum altitudes required for aerobatic…NTSB SEA96FA133Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pomeroy, WAThe pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.NTSB LAX96FA114Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New River, AZfailure of the pilot to maintain proper altitude/clearance above the terrain, while performing an aerobatic maneuver.NTSB FTW94FA023Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Saratoga, ARThe pilot-in-command's performance of aerobatics at an altitude where it was not possible to maintain clearance.NTSB LAX93LA030Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Pahrump, NVThe pilot misjudged the pull up altitude.NTSB DEN91FA013Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Belen, NMThe pilot misjudged the aircraft's altitude (ground clearance) above the desert terrain.NTSB LAX90LA158Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Phoenix, AZThe pilot failed to maintain control of the airplane.NTSB LAX88DVD04Accident · 1 fatalFinal reportBellanca 8KCAB · Geyserville, CADuring an aerobatic maneuver in front of family and friends the pilot entered an intentional spin starting at approximately 500 ft AGL. The aircraft collided with the ground in a nose low, wings level attitude. Witnesses stated that the aircraft did not…NTSB ATL86FA040Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Springfield, TNThe acft collided with the ground inverted. Witnesses stated that the acft was performing loops prior to the accident. Reportedly, the plt was giving a female companion a 'joy ride'. The plt had recently received his commercial cert. Instrument rating & CFI…NTSB ATL82FLQ06Accident · 1 fatalFinal reportBellanca 8KCAB · Mayfield, KYThe aircraft crashed while the pilot was performing an aerobatic routine at an airshow. After about 7 minutes in an 8 minute act, the pilot performed an 8-point roll at about 200 ft AGL, then pulled up into a hammerhead stall. After a hammerhead turn to the…NTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…