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.

NTSB CHI72ACO96Accident · 1 fatalClosedCessna 207 · Cochrane, WIJun 2, 1972 · N91005 · DestroyedNTSB CHI72FEP43Accident · No injuriesClosedCessna 140 · Lafarge, WIMay 18, 1972 · N2353N · Substantial damageNTSB CHI72FEP42Accident · No injuriesClosedCessna 182P · Bloomer, WIMay 17, 1972 · N7412Q · Substantial damageNTSB CHI72FEP45Accident · 1 fatalClosedBensen B-8 · Wiscnsin Rpds, WIMay 16, 1972 · N2362 · DestroyedNTSB CHI72DEP39Accident · No injuriesClosedPiper PA-28 · Portage, WIMay 7, 1972 · N6218W · Substantial damageNTSB CHI73AC085Accident · 5 fatalClosedBeech 65-A90 · Racine, WIMay 1, 1972 · N295X · DestroyedNTSB CHI72DEP41Accident · No injuriesClosedMooney M20C · Weston, WIApr 30, 1972 · N6821N · Substantial damageNTSB CHI72FER03Accident · No injuriesClosedBeech 35-C33 · Star Prairie, WIApr 27, 1972 · N3724Q · Substantial damageNTSB CHI72DEP40Accident · No injuriesClosedCessna 210 · Withee, WIApr 20, 1972 · N3935Y · Substantial damageNTSB CHI72FEP37Accident · No injuriesClosedPiper PA-20 · Twin Lakes, WIApr 15, 1972 · N6978K · Substantial damageNTSB CHI72AC083Accident · 1 fatalClosedShort Bros SC-7-3 · Lacrosse, WIApr 14, 1972 · N725R · DestroyedNTSB CHI72DEP38Accident · No injuriesClosedCessna 182K · Green Bay, WIApr 6, 1972 · N3135Q · Substantial damageNTSB CHI72FEP35Accident · Serious injuriesClosedMustang M-1 · Appleton, WIMar 26, 1972 · N5RK · DestroyedNTSB CHI72DEP36Accident · No injuriesClosedPiper PA-28 · Ashland, WIMar 23, 1972 · N7290F · Substantial damageNTSB CHI72DEP33Accident · No injuriesClosedCessna 177 · Racine, WIMar 11, 1972 · N3134T · Substantial damageNTSB CHI72FEP32Accident · Minor injuriesClosedCessna 172G · Thorp, WIMar 10, 1972 · N3664L · Substantial damageNTSB CHI72DEP34Accident · No injuriesClosedCessna 172G · Burlington, WIMar 7, 1972 · N3623L · Substantial damageNTSB CHI72IC063Incident · No injuriesClosedBeech 95-B55 · Milwaukee, WIFeb 5, 1972 · N48034 · Minor damageNTSB CHI72FEP31Accident · Minor injuriesClosedMooney M20C · Franksville, WIJan 23, 1972 · N6449U · Substantial damageNTSB CHI72FEP30Accident · 1 fatalClosedCessna 337 · Woodruff, WIJan 20, 1972 · N2140 · DestroyedNTSB CHI72AC060Accident · No injuriesClosedBeech D18S · Madison, WIJan 20, 1972 · N80390 · Substantial damageNTSB CHI72DEP29Accident · No injuriesClosedCessna 150D · Viroqua, WIJan 18, 1972 · N4178U · Substantial damageNTSB CHI72FEP27Accident · No injuriesClosedCessna 172A · Fall Creek, WIJan 9, 1972 · N7406T · Substantial damageNTSB CHI72FEP25Accident · No injuriesClosedCessna 172 · Delavan, WIJan 9, 1972 · N5875A · Substantial damage