Do you need a passport to fly to cabo san lucas Mexico?

Although it was not always necessary, currently (as of January 2012), yes it is necessary. UNLESS you are a frequent traveller or live in a contiguous border state, then there are special ID cards issued which can take the place of a US Passport.