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.

NTSB CHI73FEP55Accident · No injuriesClosedCessna 310C · Burlington, WIMay 9, 1973 · N55KM · Substantial damageNTSB CHI73FEP54Accident · No injuriesClosedTaylorcraft BC1265 · Waunakee, WIMay 5, 1973 · N36466 · Substantial damageNTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WIMay 3, 1973 · N18690 · Substantial damageNTSB CHI73FEP50Accident · Serious injuriesClosedBeech 35-A33 · West Bend, WIApr 30, 1973 · N563T · Substantial damageNTSB CHI73DEP56Accident · Minor injuriesClosedCessna 177 · Rhinelander, WIApr 30, 1973 · N3174T · DestroyedNTSB CHI73FEP52Accident · No injuriesClosedMaule M-4 · Batavia, WIApr 29, 1973 · N4622T · Substantial damageNTSB CHI73FEP51Accident · No injuriesClosedPiper PA-28 · Sturtevant, WIApr 28, 1973 · N5024T · Substantial damageNTSB CHI73DER07Accident · No injuriesClosedPiper PA-28 · Boyceville, WIApr 26, 1973 · N8440R · Substantial damageNTSB CHI73AC085Accident · 1 fatalClosedAeronca 7AC · Rice Lake, WIApr 25, 1973 · N85010 · DestroyedNTSB CHI73DEP53Accident · No injuriesClosedCessna 150 · Tony, WIApr 24, 1973 · N8654G · Substantial damageNTSB CHI73DEP49Accident · No injuriesClosedCessna 172 · Bristol, WIApr 14, 1973 · N2692U · Substantial damageNTSB CHI73DEP48Accident · No injuriesClosedCessna 150K · Rhinelander, WIApr 13, 1973 · N6243G · Substantial damageNTSB CHI73FEP47Accident · Serious injuriesClosedPiper PA-28 · Independence, WIApr 6, 1973 · N4451J · DestroyedNTSB CHI73DEP46Accident · No injuriesClosedPiper PA-22 · Phillips, WIMar 30, 1973 · N7814D · Substantial damageNTSB CHI73DEP45Accident · No injuriesClosedPiper PA-28 · Middleton, WIMar 30, 1973 · N686FL · Substantial damageNTSB CHI73FEP43Accident · Serious injuriesClosedCessna 150G · Monroe, WIMar 29, 1973 · N2418J · DestroyedNTSB CHI73DEP44Accident · No injuriesClosedPiper PA-22 · Middleton, WIMar 26, 1973 · N2849P · Substantial damageNTSB CHI73DER06Accident · Serious injuriesClosedCessna 177 · Baldwin, WIMar 25, 1973 · N2352Y · DestroyedNTSB CHI73AC071Accident · 4 fatalClosedCessna 421B · Brookfield, WIFeb 19, 1973 · N1536T · DestroyedNTSB CHI73AC070Accident · 2 fatalClosedBeech B35 · Sheboygan, WIFeb 17, 1973 · N5209C · DestroyedNTSB CHI73FEP38Accident · Serious injuriesClosedCassutt Sport · Waukesha, WIFeb 11, 1973 · N219 · Substantial damageNTSB CHI73DEP40Accident · Minor injuriesClosedChampion 7ECA · Stevens Point, WIFeb 10, 1973 · N9576S · Substantial damageNTSB CHI73FEP39Accident · No injuriesClosedMooney M20C · Middleton, WIFeb 8, 1973 · N6520U · Substantial damageNTSB CHI73DER05Accident · No injuriesClosedCessna 182 · River Falls, WIFeb 3, 1973 · N2100R · Substantial damageNTSB CHI73DEP36Accident · No injuriesClosedCessna 182M · Waukesha, WIJan 28, 1973 · N70938 · Substantial damageNTSB CHI73FEP35Accident · No injuriesClosedPiper PA-32 · Racine, WIJan 12, 1973 · N4191R · Substantial damageNTSB CHI73DEP37Accident · No injuriesClosedPiper PA-28 · Shawano, WIJan 7, 1973 · N8700N · Substantial damage