NTSB investigations: Bellanca 8KCAB, GA
4 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 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.\"eventStateOrRegion\" = 'GA' 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 ('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 c."eventStateOrRegion" = 'GA' 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 ('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 ATL83LA323Accident · No injuriesLimited investigationFinal reportBellanca 8-KCAB-150 · Kennesaw, GABoth aircraft were taxiing simultaneously, in opposite directions on the single parallel taxiway. N5500C was east bound for takeoff. N69113 was westbound on the taxiway after landing on runway 27 and a turn onto the taxiway. The pilot of N5500C stated that…NTSB ATL83FA213Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Calhoun, GAThe plt had flown to the arpt to perform aerobatic maneuvers at a fly-in. He had a low altitude waiver to perform down to 500 ft AGL. Before the flight, he told several spectators he was going to do a maneuver right after takeoff. Witnesses reported that the…NTSB ATL82FA083Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Carrollton, GAThe student completed a touch & go & was climbing out when the instructor took control. He told the student that he was going to show him what to do if the eng quit shortly after takeoff. At 150-180 ft above the rwy near the upwind numbers the instructor cut…NTSB ATL81FA010Accident · 1 fatalClosedBellanca 8KCAB · Woodland, GA