In CTOur 2022 rankings contain 2 Connecticut schools granting astrophysics and astronomy bachelor's degrees, and Yale University is the best option.
Check both Connecticut schools providing astronomy and astrophysics bachelor's degrees and physics colleges offering similar programs in the nearby states or narrow your search by city or consider other physics major or diploma.