NTSB investigations: Bellanca 8KCAB, 1988
6 cases on aircraft the registry lists as Bellanca 8KCAB. 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
| 1967 | 1 |
|---|---|
| 1973 | 3 |
| 1974 | 5 |
| 1975 | 2 |
| 1976 | 11 |
| 1977 | 11 |
| 1978 | 16 |
| 1979 | 7 |
| 1980 | 8 |
| 1981 | 7 |
| 1982 | 8 |
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 8 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 8 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 1 |
| 2003 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220801'))
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 year(c."eventDate") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220801'))
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 LAX89LA056Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Twentynine Palm, CAThe pilot stated that while landing, during the flare, a gust of wind raised the left wing. The pilot corrected just prior to touchdown. When the airplane touched down it ground looped to the right. The airplane ran off the runway and collided with a berm and…NTSB LAX89LA009Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Alpine, CADuring a telephone interview, the pilot stated that he had just recovered from a one turn spin and was in level flight when he felt the airplane pitch up. He added a small amount of nose down trim and the airplane pitched down. He stated that at this point…NTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.NTSB NYC88LA207Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Quaker Street, NYThe Bellanca 8KCAB was making a takeoff when it veered to the right. The right main landing gear contacted a rock wall covered by weeds and the aircraft veered further right coming to rest on the right side of the runway. The pilot was unable to explain the…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 SEA88LA061Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Blackfoot, IDThe pilot lost directional control of the aircraft during gusting crosswinds. During landing rollout the aircraft veered from the centerline of the runway to the right striking a fence. The pilot had only 7 hours of flight time in this aircraft.