Does Director Vance die in the 2009 season finale of NCIS?

No, Director Vance does not die in the 2009 season finale of NCIS.

While he was shot by a sniper in the episode titled "Judgment Day," he survives the attack.