The supportive unit ends up on the tile where the leading unit was before s/he lost all health. I believe.

Or the closest possible, in the case of a supportive unit not being able to stand on the tile beneath, like a Pegasus carrying a Knight over the sea... ... ... I actually have no idea.