It's called and caused by "wind buffeting." The air enters the vehicle but cannot as easily escape, so the air "rebounds" against the incoming air to equalize the pressure. This back and forth causes the "helicopter sound." By opening the front windows, you have more means of the air escaping and the pressure equalizing.

That's my take on it, anyway.