NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 CHI73FEP55Accident · No injuriesClosedCessna 310C · Burlington, WINTSB CHI73FEP54Accident · No injuriesClosedTaylorcraft BC1265 · Waunakee, WINTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WINTSB CHI73FEP50Accident · Serious injuriesClosedBeech 35-A33 · West Bend, WINTSB CHI73DEP56Accident · Minor injuriesClosedCessna 177 · Rhinelander, WINTSB CHI73FEP52Accident · No injuriesClosedMaule M-4 · Batavia, WINTSB CHI73FEP51Accident · No injuriesClosedPiper PA-28 · Sturtevant, WINTSB CHI73DER07Accident · No injuriesClosedPiper PA-28 · Boyceville, WINTSB CHI73AC085Accident · 1 fatalClosedAeronca 7AC · Rice Lake, WINTSB CHI73DEP53Accident · No injuriesClosedCessna 150 · Tony, WINTSB CHI73DEP49Accident · No injuriesClosedCessna 172 · Bristol, WINTSB CHI73DEP48Accident · No injuriesClosedCessna 150K · Rhinelander, WINTSB CHI73FEP47Accident · Serious injuriesClosedPiper PA-28 · Independence, WINTSB CHI73DEP46Accident · No injuriesClosedPiper PA-22 · Phillips, WINTSB CHI73DEP45Accident · No injuriesClosedPiper PA-28 · Middleton, WINTSB CHI73FEP43Accident · Serious injuriesClosedCessna 150G · Monroe, WINTSB CHI73DEP44Accident · No injuriesClosedPiper PA-22 · Middleton, WINTSB CHI73DER06Accident · Serious injuriesClosedCessna 177 · Baldwin, WINTSB CHI73AC071Accident · 4 fatalClosedCessna 421B · Brookfield, WINTSB CHI73AC070Accident · 2 fatalClosedBeech B35 · Sheboygan, WINTSB CHI73FEP38Accident · Serious injuriesClosedCassutt Sport · Waukesha, WINTSB CHI73DEP40Accident · Minor injuriesClosedChampion 7ECA · Stevens Point, WINTSB CHI73FEP39Accident · No injuriesClosedMooney M20C · Middleton, WINTSB CHI73DER05Accident · No injuriesClosedCessna 182 · River Falls, WINTSB CHI73DEP36Accident · No injuriesClosedCessna 182M · Waukesha, WINTSB CHI73FEP35Accident · No injuriesClosedPiper PA-32 · Racine, WINTSB CHI73DEP37Accident · No injuriesClosedPiper PA-28 · Shawano, WI