USB disks are identified as SCSI devices in FreeBSD and all SCSI devices can be told to spin-down by issuing following command:
camcontrol stop -n da -u 0
The spin-up is then again done automatically when there is a request issued for the particular device.