NTSB investigations: Bellanca 8KCAB, TX
13 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
| 1976 | 2 |
|---|---|
| 1978 | 2 |
| 1981 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2009 | 1 |
| 2014 | 1 |
| 2019 | 1 |
Where
Latest 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\" = 'TX' 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" = 'TX' 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 CEN19LA153Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 8KCAB · Fredericksburg, TXA total loss of engine power due to fuel exhaustion.NTSB CEN15CA213Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Mesquite, TXThe pilot's loss of directional control while landing in gusting crosswind conditions, which exceeded the airplane's maximum demonstrated crosswind velocity.NTSB CEN09CA450Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Waring, TXThe pilot's failure to maintain directional control during landing roll-out. Contributing to the accident was the worn left main landing gear brake.NTSB FTW99LA145Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Lufkin, TXThe loss of control due to the separation of the left main landing gear as a result of the fatigue failure of the U-bolt which attaches the landing gear to the airframe.NTSB FTW97LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Laporte, TXThe pilot's diminished ability to maintain control of the airplane due to a jammed elevator control as result of inadequate maintenance procedures by the operator's mechanic.NTSB FTW95FA232Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Joaquin, TXThe performance of aerobatics at low altitude and the inadvertent stall.NTSB FTW93FA187Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Texas City, TXThe pilot's failure to recover from the intentional maneuver for undetermined reasons.NTSB FTW90LA047Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Stephenville, TXImproper planning/decision by the pilot.NTSB FTW82DRA13Accident · Minor injuriesClosedBellanca 8KCAB · League City, TXNTSB FTW78FA062Accident · 2 fatalClosedBellanca 8KCAB · Lake Dallas, TXNTSB FTW78FRG51Accident · 1 fatalClosedBellanca 8KCAB · Brady, TXNTSB FTW76AF114Accident · 2 fatalClosedBellanca 8KCAB · Amarillo, TXNTSB FTW76FQG94Accident · Serious injuriesClosedBellanca 8KCAB · Acuff, TX