Skip to content

NTSB investigations: Bellanca 7KCAB, CA

22 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

19722026

Where

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.Dec 2, 2010 · N11858 · Substantial damage NTSB LAX06CA215Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Carlsbad, CAthe pilot's failure to maintain runway alignment during the aborted landing, which resulted in a collision with a tree.Jun 26, 2006 · N1098E · Destroyed NTSB LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.Jan 9, 2006 · N36382 · Substantial damage NTSB LAX91LA354Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Monterey, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.Aug 11, 1991 · N31279 · Substantial damage NTSB LAX88FA023Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Red Bluff, CAThe pilot was asked to move his aircraft from a private airstrip on which he had landed without prior approval. As the aircraft climbed after takeoff the pilot made a left wingover, reversed course and buzzed the runway at an elevation of about 30 - 40 feet.…Oct 25, 1987 · N8645V · Destroyed NTSB LAX87LA224Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAWhile on final apch to lnd on rwy 28, a glider (Schweizer sgs 2-32, N242DB) & a tow plane (Bellanca 7KCAB, N88314) collided in flt at an alt of about 200' AGL. The tow plane was returning fm a LCL tow mission & the glider was returningfm a LCL sightseeing…May 30, 1987 · N88314 · 2 aircraft · Substantial damage NTSB LAX87FA136Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Lebec, CAPrior to the flt, the plt rcvd 2 wx briefings & was adzd of low ceilings, restricted visibilities & mtn obscurement along the route. Also, he was adzd that VFR flt was not recommended. The surviving pax said that after entering the mtn area, they contd 'in…Mar 6, 1987 · N8713V · Destroyed NTSB LAX86LA246Accident · No injuriesLimited investigationFinal reportBellanca Kcab · Taft, CAThe citabrea bounced on landing and ground looped on the runway. The pilot indicated that on touchdown the aircraft bounced. Throttle was advanced and on the second touchdown the aircraft veered left. The left wing rose placing the aircraft on the right main…Jun 15, 1986 · N8780 · Substantial damage NTSB LAX84FUG01Accident · Minor injuriesFinal reportBellanca 8KCAB · Riverside, CAThe plt tried to takeoff from a grassy area adjacent to the paved rwy. The takeoff was hindered by high grass. Just after takeoff the acft collided with a fence and cartwheeled.Feb 9, 1984 · N5037G · Substantial damage NTSB LAX84LA006Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAThe acft groundlooped during landing after an aerial glider tow. The plt reported that he had performed 23 glider tows that day and he may have become fatigued. He was accustumed to making a low level turn to a short final from a base leg at 100 ft AGL. This…Oct 6, 1983 · N88314 · Substantial damage NTSB LAX83FA335Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Fontana, CAThe acft impacted the terrain at 4600 ft MSL at a steep angle in brush and dirt near a fire road. According to the plts family the acft had recently been purchased by the plt and he frequently practiced aerobatics in the late afternoon. Hisaerobatic…Jul 14, 1983 · N7692S · Destroyed NTSB LAX81FA113Accident · 2 fatalClosedBellanca 7KCAB · King City, CAAug 1, 1981 · N1164E · Destroyed NTSB LAX80FUG04Accident · 1 fatalClosedBellanca 7KCAB · Corona, CAOct 27, 1979 · N88406 · Substantial damage NTSB OAK78FVM48Accident · Serious injuriesClosedBellanca 7KCAB · Half Moon Bay, CASep 21, 1978 · N7682S · Substantial damage NTSB OAK78FA007Accident · 1 fatalClosedBellanca 7KCAB · Clearlake Oaks, CADec 5, 1977 · N7908S · Destroyed NTSB LAX78FUA01Accident · Serious injuriesClosedBellanca 7KCAB · Huntington Bch, CANov 7, 1977 · N86977 · Substantial damage NTSB LAX78FUQ02Accident · No injuriesClosedBellanca 7KCAB · Santa Paula, CAOct 23, 1977 · N1164E · Substantial damage NTSB LAX76DVA61Accident · No injuriesClosedChampion 7KCAB · Terra Bella, CAMay 8, 1976 · N90998 · Substantial damage NTSB OAK76DVM03Accident · Minor injuriesClosedBellanca 7KCAB · San Martin, CAJul 27, 1975 · N88395 · Substantial damage NTSB OAK75DVG57Accident · No injuriesClosedBellanca 7KCAB · Vacaville, CAApr 26, 1975 · N88351 · Substantial damage NTSB OAK75AP016Accident · 2 fatalClosedChampion 7KCAB · Vacaville, CAOct 27, 1974 · N86839 · Destroyed NTSB OAK73FVG23Accident · No injuriesClosedBellanca 7KCAB · Pope Valley, CAOct 6, 1972 · N11706 · Substantial damage