Turn NTSB airplane crash database "CSV" into usable airplane accident / crash data with actual working CSV

ntsbcsv.py

import requests

import csv
import re

hosturl = "http://app.ntsb.gov/aviationquery/Download.ashx?type=csv"
targetraw = "ntsbdb.raw"
targetcsv = "ntsbdb.csv"

r = requests.get(hosturl)
with open(targetraw, "wb") as f:
    f.write(r.content)

with open(targetraw, "r") as f:
    core = f.read().splitlines()

with open(targetcsv, "w", newline="") as f:
    writer = csv.writer(f)
    for row in core:
        row = re.sub(r" \| $", "", row)
        row = row.split(" | ")
        writer.writerow(row)