SATA Hat Fan at 100% when Pi is shutdown


I am powering my Hat with the barrel connector and when I plug it in without powering on the Pi, the fan runs at 100%. When the Pi is powered on, then the fan spins down and works perfectly.

I do want to mention that this is a v1.2 board.

I need that when the Pi is powered down, the fan on the Hat also powers down or turns off. Is there any way to achieve this?