Okay, so it looks like the issue is that the engine code is looking specifically for \r\n patterns but the CSV file I had only had \n at the end of lines.
I added the carriage return characters, and now the import is successful. However, when I look at the imported file all I see is a blank screen.