It mainly has to do with how fast your body gets rid of heat to the surrounding medium. Water can whisk heat away from your body nearly four times faster than air, so it feels cooler to your body. Also, a factor with air is going to be humidity. The more humidity in the air, the less sweat evaporating from you skin and thus the hotter (and stickier) it feels.