This past Saturday Austin and I went to the 11th annual Jack-O-Launch in nearby Aurora.  We saw frustrated engineers try their pumpkin throwing machines of all varieties.  Some were pneumatic, others were traditional trebuchets.  Check out this video - it is a catapult powered only by counterweights.  The pumpkin goes close to 1/2 mile.