Hang around an airport that caters to general aviation. Ask who's planning to see the eclipse from the air. Offer to pay for gas.

Can you just rent a car and drive? With a second person you wouldn't really need anywhere to sleep.