There are two primary pests which have driven me nuts with respect to the cucurbita family. The Squash Vine Borer, as LandOfOz has pointed out, bores into the vine and sucks the juice. The vine will die from where the borer gets in and will continue to die from that pount to the tip of the
plant. The best approach to dealing with the vine borer, aside from spraying pesticides, is to look for discolored spots in the vine closer to the orignal stem from the first leaf that dies. The borer will likely still be there. Slit the vine and remove the borer. Cover the vine with dirt to encourage rooting.
The other pest is the squash bug. The patters vary, but mine seem to have yellow stripes. I have not found a good way to deal with these. They don't eat the leaf, they leave a bacteria behind which causes wilting. The best I have done with these is to pick cultivars which seem to have some resistance. Butternut Squash may be a good substitute for your pumpkin if you want the taste and don't care about the Charlie Brown thing. :-)
If anyone has a good solution other than spraying for the squash bugs, I'm all ears.
Andy