Skip to content

NTSB investigations: Bellanca 8KCAB

182 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."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

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.\"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."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

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 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…Jun 4, 1983 · N111UD · Destroyed 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…Apr 23, 1983 · N86948 · Substantial damage NTSB FTW83LA141Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Roswell, NMDuring arrival, the engine began to lose power as the acft was on base leg for landing. The plt was unable to restore full power and made a forced landing in an umimproved area aprx 2 mi from the airport. During the landing roll-out, the right wing tip hit a…Mar 7, 1983 · N5042J · Substantial damage NTSB ATL83LA051Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Atkinson, NCThe pilot decided to land on a private strip due to strong gusty winds and thunderstorms. The pilot landed without incident and began to back taxi on the runway when the left main landing gear went into a mud hole off the side of the runway. The aircraft…Dec 5, 1982 · N57423 · Substantial damage NTSB NYC82DA197Accident · No injuriesFinal reportBellanca 8KCAB · Hanover, NJThe pilot stated that during the landing, the right brake failed after he touched down about midway on the runway at night. He stated that he tried to stop by using a combination of right rudder and left brake. However, the aircraft veered off the left side…Aug 8, 1982 · N2502Z · Substantial damage NTSB LAX82FA225Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Westley, CAThe plt made a low pass over a ranch house traveling from nw to se. He then made a second low pass over the swimming pool area traveling in a NE direction, & waved to those standing by the pool. The acft began a 180 reversal turn, entered a steep nose down…Jun 20, 1982 · N2661Z · Destroyed NTSB ATL82FLQ06Accident · 1 fatalFinal reportBellanca 8KCAB · Mayfield, KYThe aircraft crashed while the pilot was performing an aerobatic routine at an airshow. After about 7 minutes in an 8 minute act, the pilot performed an 8-point roll at about 200 ft AGL, then pulled up into a hammerhead stall. After a hammerhead turn to the…Jun 13, 1982 · N50352 · Destroyed NTSB MKC82DA074Accident · No injuriesFinal reportBellanca 8KCAB · Hayitt, MOThe pilot stated that he came in slightly low on final to avoid crossing a road that ran through the center of the airstrip. The wheat field at the south end of the strip blended in with the colors and texture of the runway. The landing gear caught the tall…May 9, 1982 · N5067K · Substantial damage NTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…Apr 26, 1982 · N5035N · Substantial damage 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…Mar 23, 1982 · N50468 · Destroyed NTSB CHI82DA063Accident · Serious injuriesFinal reportBellanca 8KCAB · Franklin, WIAfter a 1.8 hour flight, the fixed base operator serviced the aircraft with 15 gallons of fuel. The pilot stated that he drained the sumps as part of his preflight. The pretakeoff checks and takeoff roll were normal. At about 75 to 100 feet AGL, the engine…Feb 21, 1982 · N1218E · Substantial damage NTSB FTW82DRA13Accident · Minor injuriesClosedBellanca 8KCAB · League City, TXDec 22, 1981 · N77180 · Destroyed NTSB LAX81FA110Accident · 2 fatalClosedBellanca 8KCAB · San Carlos, CAJul 25, 1981 · N4112Y · Destroyed NTSB CHI81FEC31Accident · Serious injuriesClosedBellanca 8KCAB · Hillsdale, MIJul 4, 1981 · N2692Z · Destroyed NTSB DEN81FA039Accident · 1 fatalClosedBellanca 8KCAB · Langdon, NDJun 5, 1981 · N31258 · Destroyed NTSB LAX81FUA07Accident · Minor injuriesClosedBellanca 8KCAB · San Pedro, CAApr 21, 1981 · N2576Z · Substantial damage NTSB CHI81FA041Accident · 1 fatalClosedBellanca 8KCAB · Maria Stein, OHApr 2, 1981 · N2754Z · Destroyed NTSB LAX81DUJ46Accident · No injuriesClosedBellanca 8KCAB · Scottsdale, AZMar 27, 1981 · N7667S · Substantial damage NTSB LAX81FUJ11Accident · 1 fatalClosedBellanca 8KCAB · Bouse, AZNov 27, 1980 · N50409 · Destroyed NTSB ATL81FA010Accident · 1 fatalClosedBellanca 8KCAB · Woodland, GAOct 30, 1980 · N4108Y · Destroyed NTSB MIA81FA006Accident · 2 fatalClosedBellanca 8KCAB · Ft Lauderdale, FLOct 21, 1980 · N99AM · Destroyed NTSB ATL80DIA13Accident · No injuriesClosedBellanca 8KCAB · Washington, VAAug 9, 1980 · N5044U · Substantial damage NTSB LAX80DVD30Accident · No injuriesClosedBellanca 8KCAB · Schelleville, CAJul 11, 1980 · N5507R · Substantial damage NTSB DEN80FTK13CaseClosedBellanca 8KCAB · Spearfish, SDJun 25, 1980 · N5030N NTSB CHI80FA049Accident · 2 fatalClosedBellanca 8KCAB · Clifton, ILJun 22, 1980 · N4PM · Destroyed NTSB MIA80FA067Accident · 2 fatalClosedBellanca 8KCAB · Marathon, FLJun 8, 1980 · N4127Y · Destroyed NTSB LAX80FA031Accident · 2 fatalClosedBellanca 8KCAB · San Fernando, CADec 22, 1979 · N5032K · Substantial damage NTSB IAD80FA012Accident · 1 fatalClosedBellanca 8KCAB · Churchton, MDNov 25, 1979 · N444HG · Destroyed NTSB LAX80FUA01Accident · No injuriesClosedBellanca 8KCAB · San Pedro, CAOct 4, 1979 · N8716V · Destroyed NTSB IAD79FA038Accident · 1 fatalClosedBellanca 8KCAB · Queenstown, MDMar 7, 1979 · N31278 · Destroyed NTSB OAK79FVD09Accident · No injuriesClosedBellanca 8KCAB · Fremont, CAJan 20, 1979 · N8622V · Substantial damage NTSB IAD79DKM06Accident · No injuriesClosedBellanca 8KCAB · Greensboro, NCJan 9, 1979 · N55034 · Substantial damage NTSB OAK79FVM09Accident · No injuriesClosedBellanca 8KCAB · Palo Alto, CAJan 6, 1979 · N2596Z · Substantial damage NTSB IAD79FA022Accident · 1 fatalClosedBellanca 8KCAB · Wade, NCDec 11, 1978 · N5026C · Destroyed NTSB OAK78FA051Accident · 2 fatalClosedBellanca 8KCAB · Truckee, CANov 1, 1978 · N4180Y · Destroyed NTSB LAX79FUQ05Accident · No injuriesClosedBellanca 8KCAB · Los Alamos, CAOct 22, 1978 · N76KF · Substantial damage NTSB OAK79FA002Accident · 2 fatalClosedBellanca 8KCAB · Palo Alto, CAOct 12, 1978 · N88321 · Destroyed NTSB OAK78FA043Accident · 1 fatalClosedBellanca 8KCAB · Caruthers, CAAug 18, 1978 · N5506Y · Destroyed NTSB LAX78DA068Accident · No injuriesClosedBellanca 8KCAB · Elcentro, CAAug 18, 1978 · N68557 · Substantial damage NTSB IAD78FA114Accident · 1 fatalClosedBellanca 8KCAB · Princeton, KYAug 10, 1978 · N205HL · Destroyed NTSB IAD78FID18Accident · Serious injuriesClosedBellanca 8KCAB · Norfolk, VAAug 6, 1978 · N5537K · 2 aircraft · Destroyed NTSB FTW78FA062Accident · 2 fatalClosedBellanca 8KCAB · Lake Dallas, TXJul 22, 1978 · N68513 · Destroyed NTSB OAK78FVD48Accident · No injuriesClosedBellanca 8KCAB · Sonoma, CAJul 20, 1978 · N8734V · Substantial damage NTSB FTW78DPG48Accident · No injuriesClosedBellanca 8KCAB · Tupelo, ARJun 30, 1978 · N1159E · Substantial damage NTSB IAD78FID09Accident · Serious injuriesClosedBellanca 8KCAB · Mechanicsville, VAJun 24, 1978 · N68546 · Destroyed NTSB FTW78FRG51Accident · 1 fatalClosedBellanca 8KCAB · Brady, TXJun 18, 1978 · N5541K · Destroyed NTSB DEN78FA047Accident · 2 fatalClosedBellanca 8KCAB · Green River, WYJun 8, 1978 · N777DW · Substantial damage NTSB MKC78FA033Accident · 1 fatalClosedBellanca 8KCAB · Council Bluffs, IAJun 2, 1978 · N57463 · Destroyed NTSB NYC78FNE20Accident · Minor injuriesClosedBellanca 8KCAB · Simsbury, CTApr 29, 1978 · N9178L · Substantial damage NTSB MKC78FA008Accident · 2 fatalClosedBellanca 8KCAB · Inwood, IANov 28, 1977 · N12PG · Destroyed