It could have also been dropped while firing or laid down and lost.

Check the Official Records to find out if any battles happened at the location where you found it. Is it still loaded?

As for interest for a collector, I don't think it would make much difference in value if it were cocked or not.