Bowing to pressure from community groups upset by the noise of whirring rotors, city officials have banned most types of helicopter sightseeing flights leaving from Manhattan.