It is almost (not entirely, but almost) impossible to get HIV from a blood transfusion in the US today. Blood is tested quite thoroughly, and that’s after pre-screening donors for high risk behaviors.
Injected drug use is another story. Lots of people still get HIV sharing needles or cotton balls or other “flash”, and if your single sex partner is, unbeknownst to you, an injected drug user, then you’re in danger, yes.
It’s also possible to contract HIV from sharing personal care items which may come into contact with blood and open skin, like razors. While the risk is much lower than for unprotected sex, it’s higher than for a blood transfusion.