NTSB investigations, 1972, WI
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1972
AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1972 AND c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI72ACO96Accident · 1 fatalClosedCessna 207 · Cochrane, WINTSB CHI72FEP43Accident · No injuriesClosedCessna 140 · Lafarge, WINTSB CHI72FEP42Accident · No injuriesClosedCessna 182P · Bloomer, WINTSB CHI72FEP45Accident · 1 fatalClosedBensen B-8 · Wiscnsin Rpds, WINTSB CHI72DEP39Accident · No injuriesClosedPiper PA-28 · Portage, WINTSB CHI73AC085Accident · 5 fatalClosedBeech 65-A90 · Racine, WINTSB CHI72DEP41Accident · No injuriesClosedMooney M20C · Weston, WINTSB CHI72FER03Accident · No injuriesClosedBeech 35-C33 · Star Prairie, WINTSB CHI72DEP40Accident · No injuriesClosedCessna 210 · Withee, WINTSB CHI72FEP37Accident · No injuriesClosedPiper PA-20 · Twin Lakes, WINTSB CHI72AC083Accident · 1 fatalClosedShort Bros SC-7-3 · Lacrosse, WINTSB CHI72DEP38Accident · No injuriesClosedCessna 182K · Green Bay, WINTSB CHI72FEP35Accident · Serious injuriesClosedMustang M-1 · Appleton, WINTSB CHI72DEP36Accident · No injuriesClosedPiper PA-28 · Ashland, WINTSB CHI72DEP33Accident · No injuriesClosedCessna 177 · Racine, WINTSB CHI72FEP32Accident · Minor injuriesClosedCessna 172G · Thorp, WINTSB CHI72DEP34Accident · No injuriesClosedCessna 172G · Burlington, WINTSB CHI72IC063Incident · No injuriesClosedBeech 95-B55 · Milwaukee, WINTSB CHI72FEP31Accident · Minor injuriesClosedMooney M20C · Franksville, WINTSB CHI72FEP30Accident · 1 fatalClosedCessna 337 · Woodruff, WINTSB CHI72AC060Accident · No injuriesClosedBeech D18S · Madison, WINTSB CHI72DEP29Accident · No injuriesClosedCessna 150D · Viroqua, WINTSB CHI72FEP27Accident · No injuriesClosedCessna 172A · Fall Creek, WINTSB CHI72FEP25Accident · No injuriesClosedCessna 172 · Delavan, WI