After a few failed attempted at getting tramp working in NTEmacs the solution ended up being pretty simple.

1) Download Plink.exe.

2) Place Plink.exe somewhere in your windows PATH, doesn’t matter where but you have to be able to run in from a command line anywhere on your system.

3) Add the following line somewhere in your .emacs.
(setq tramp-default-method "plink")

From there you should be able to use find-file (C-x C-f) and a command like the following to bring up a remote file:
/user@host.com:/path/to/file.ext