I was able to work around this by using 'sed' to replace the '0000-00-00 00:00:00' string with NULLs.

\copy tablename from program 'cat /path/to/file | sed "s/0000-00-00 00:00:00//g"' with (format csv, header true);