CAR:
Unfortunately, you'll need a car during your visit to Connecticut. It's a rural area with no public transportation.
PLANE:
Bradley International Airport in Hartford, CT is closest. It's a little over an hour by car to Riverbend.
New York City area airports, JFK, LGA and Newark, may have cheaper flights and are about a 2-hour drive to Riverbend. If you do choose to fly to NYC, remember that it will be more expensive to rent a car at LGA or JFK (slightly cheaper at Newark).