NTSB investigations: Bellanca 7KCAB, AZ

10 cases on aircraft the registry lists as Bellanca 7KCAB. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

NTSB investigations: Bellanca 7KCAB, AZ per year, 1975–2026: 10 cases
1975	1
1978	2
1980	1
1986	2
1988	1
1995	1
1996	1
2004	1

Where

Open the map

Latest cases

Query with SQL

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" = 'AZ' 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 ('1220701')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'AZ' 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 ('1220701'))
  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" = 'AZ' 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 ('1220701'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX04CA252Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Casa Grande, AZthe pilot misjudged the flare resulting in a bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing resulting in a loss of directional control.Jun 29, 2004 · N8717V · Substantial damage NTSB LAX96LA176Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZfailure of the pilot to adequately compensate for gusting crosswind conditions and to maintain directional control. A factor in the accident was unattended construction equipment parked in close proximity to the runway edge.Apr 23, 1996 · N333JS · Substantial damage NTSB LAX95LA156Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZthe pilot's inadequate compensation for the prevailing wind conditions which resulted in an inadvertent ground loop. The crosswind and the pilot's lack of familiarity with the aircraft are factors in this accident.Apr 7, 1995 · N333JS · Substantial damage NTSB LAX89LA065Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Phoenix, AZThe pilot lost control during the landing roll and collided with a fence. He reported that he was completing his landing roll on runway 25L, when the aircraft was blown sideways by a gust of wind. He stated that he then applied power to avoid a ground loop.…Dec 18, 1988 · N36627 · Substantial damage NTSB LAX87LA011Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Yuma, AZA Bellanca 7KCAB lost control and veered off rwy 16. The CFI indicated that the aircraft veered right during landing roll. The student pilot applied left pedal and the aircraft swung left and ground looped. The aircraft dropped off the rwy shoulder, breaking…Oct 6, 1986 · N8727V · Substantial damage NTSB LAX86LA337Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Poston, AZAt the end of a local practice flight the plt overflew the rwy and observed the wind sock. She noted the speed and direction to be 5 KTS from the north and elected to land downwind for easy access to the fuel tanks located on the south end. On touchdown, the…Sep 4, 1986 · N68573 · Substantial damage NTSB LAX80DUJ96Accident · No injuriesClosedBellanca 7KCAB · Page, AZSep 7, 1980 · N8845 · Substantial damage NTSB LAX79DUJ31Accident · No injuriesClosedBellanca 7KCAB · Tucson, AZNov 30, 1978 · N86651 · Substantial damage NTSB LAX78FUJ45Accident · No injuriesClosedCitabria 7KCAB · Phoenix, AZApr 16, 1978 · N36414 · 2 aircraft · Substantial damage NTSB LAX76AUJ41Accident · No injuriesClosedBellanca 7KCAB · Mesa, AZOct 30, 1975 · N8727V · Substantial damage