Check out the town of Carova Beach, North Carolina. Accessible only by driving on the beach or by water.
There’s A Facebook page dedicated to taking pictures of people getting stuck. Apparently all you have to do is air down your tires to like 12 psi and keep to a reasonable speed, but a lot of people think their car, truck, or SUV can handle sand without those precautions.