NTSB investigations: Bellanca 8KCAB, MA
7 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
| 1974 | 1 |
|---|---|
| 1977 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1996 | 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.\"eventStateOrRegion\" = 'MA' 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" = 'MA' 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 IAD97LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Sheffield, MAThe pilot's abrupt control of the airplane, which resulted in an inadvertent stall, uncontrolled descent, and subsequent in-flight collision with water.NTSB NYC96LA029Accident · Serious injuriesLimited investigationFinal reportBellanca 8-KCAB · Sheffield, MAthe pilot's inadequate preflight and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel.NTSB NYC91LA024Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Buckland, MAThe pilot's failure to execute an aerobatic maneuver at an altitude sufficient to clear the stand of trees.NTSB NYC85FA185Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Fall River, MAWitnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a…NTSB NYC83LA100Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Ashley Falls, MAThe pilot stated that he was about a half mile from the airport when the engine quit. He restarted it but it quit a 2nd time and would not restart. By this time the acft was down to about 200 ft. a right turn was made to land on an island. The acft landed…NTSB NYC77FA063Accident · 1 fatalClosedBellanca 8KCAB · Haverhill, MANTSB NYC75AN033Accident · 1 fatalClosedBellanca 8KCAB · S Weymouth, MA