If you threw a knife at the door, and it stopped and hit the ground before it reached the door, the knife would be in front of the door (location).
If you threw the knife so hard that it hit the door, it would be stuck in the front of the door. (as a result of an action).
If you threw the knife as in the first example and someone asked you where their knife was, you could say it's in front of the door, or it's AT the front of the door - both describe a location.