To answer your question, your ancestor's name and residence in 1860 would be most useful information.

If the incident you have in mind took place at the end of 1864, the 1st Alabama Cavalry was not involved. At that time the regiment was serving with Wheeler's Cavalry along the Savannah River. The ill-fated escort for Hood's pontoon and supply trains belonged to General Roddey's command.