NTSB investigations, 1978, 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\") = 1978
    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 CHI78DEP44Accident · No injuriesClosedPiper PA-28 · Gleason, WIJul 10, 1978 · N541F1 · Substantial damageNTSB CHI78DEP43Accident · Minor injuriesClosedCessna 172 · Arbor Vitae, WIJul 10, 1978 · N6607H · Substantial damageNTSB CHI78FEP41Accident · No injuriesClosedPiper PA-32 · Lakewood, WIJul 8, 1978 · N5524F · Substantial damageNTSB CHI78DEP42Accident · No injuriesClosedCessna 210M · Mercer, WIJul 7, 1978 · N732UE · Substantial damageNTSB CHI78FEP40Accident · No injuriesClosedBeech B-23 · Lacrosse, WIJul 4, 1978 · N4003T · Substantial damageNTSB CHI78DER05Accident · No injuriesClosedGrumman AA-5B · Birchwood, WIJun 24, 1978 · N28402 · Substantial damageNTSB CHI78DEP39Accident · No injuriesClosedMustang II · East Troy, WIJun 22, 1978 · N81M · Substantial damageNTSB CHI78DEP38Accident · No injuriesClosedPiper PA-18 · Lake Winnebego, WIJun 15, 1978 · N9843Q · Substantial damageNTSB CHI78FEP37Accident · No injuriesClosedDehavilland DHC-2 · Chippewa Falls, WIMay 28, 1978 · N5163G · Substantial damageNTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WIMay 28, 1978 · N9376U · DestroyedNTSB CHI78FA041Accident · 4 fatalClosedCessna T210M · Bloomer, WIMay 27, 1978 · N761GV · DestroyedNTSB CHI78FEP36Accident · Serious injuriesClosedPiper PA-28 · Portage, WIMay 22, 1978 · N9436J · Substantial damageNTSB CHI78DEP35Accident · Minor injuriesClosedMustang II · Lancaster, WIMay 21, 1978 · N4790 · Substantial damageNTSB CHI78DEP34Accident · Minor injuriesClosedHughes 269 · B1rchwood, WIMay 21, 1978 · N7449F · Substantial damageNTSB CHI78DEP32Accident · Minor injuriesClosedCessna 150 · Baileys Harbor, WIMay 16, 1978 · N60536 · Substantial damageNTSB CHI78DEP33Accident · No injuriesClosedCessna 185 · Clyman, WIMay 10, 1978 · N7591H · Substantial damageNTSB CHI78DER04Accident · No injuriesClosedCessna 150L · Grantsburg, WIApr 30, 1978 · N150L · Substantial damageNTSB CHI78FEP30Accident · No injuriesClosedCessna 172 · Middleton, WIApr 29, 1978 · N8969B · Substantial damageNTSB CHI78DEP31Accident · No injuriesClosedCessna 172 · Middleton, WIApr 13, 1978 · N73362 · Substantial damageNTSB CHI78FEP29Accident · No injuriesClosedPiper PA-36 · Neenah, WIMar 22, 1978 · N9992P · Substantial damageNTSB CHI78DEP27Accident · No injuriesClosedCessna 150 · Black River, WIMar 22, 1978 · N18162 · Substantial damageNTSB CHI78FEP28Accident · No injuriesClosedCessna 177RG · Dodgeville, WIMar 21, 1978 · N2011Q · Substantial damageNTSB CHI78DEP25Accident · No injuriesClosedCessna 152 · Milwaukee, WIMar 12, 1978 · N24337 · Substantial damageNTSB CHI78DEP26Accident · No injuriesClosedCessna 150 · Delavan, WIMar 11, 1978 · N3639J · Substantial damageNTSB CHI78FEP23Accident · No injuriesClosedGrumman AA1-B · Waukesha, WIMar 6, 1978 · N8871L · Substantial damageNTSB CHI78FEP24Accident · No injuriesClosedPiper PA-28 · Lacrosse, WIMar 4, 1978 · N4547F · Substantial damageNTSB CHI78FEP22Accident · No injuriesClosedCessna 182E · East Troy, WIMar 4, 1978 · N2860Y · Substantial damageNTSB CHI78FEP19Accident · No injuriesClosedTaylorcraft BL-65 · Hartford, WIFeb 25, 1978 · N29504 · Substantial damageNTSB CHI78DEP18Accident · No injuriesClosedCessna 150F · Necedah, WIFeb 20, 1978 · N8617G · Substantial damageNTSB CHI78FEP21Accident · No injuriesClosedCessna 172H · Fond Du Lac, WIFeb 17, 1978 · N2760L · Substantial damageNTSB CHI78FEP20Accident · Minor injuriesClosedPiper PA-28R · Pewaukee, WIFeb 16, 1978 · N1394T · Substantial damageNTSB CHI78DEP16Accident · No injuriesClosedCessna 150 · Kenosha, WIFeb 9, 1978 · N10428 · Substantial damageNTSB CHI78FEP14Accident · Minor injuriesClosedBell 47-J · Wilmot, WIFeb 5, 1978 · N6780D · Substantial damageNTSB CHI78DEP12Accident · No injuriesClosedCessna 150L · Sun Prairie, WIJan 31, 1978 · N10735 · Substantial damageNTSB CHI78FEP13Accident · No injuriesClosedCessna 150-J · Necedha, WIJan 29, 1978 · N51042 · Substantial damageNTSB CHI78FEP13Accident · No injuriesClosedPiper PA-32 · Watertown, WIJan 28, 1978 · N7726J · Substantial damageNTSB CHI78FEP11Accident · No injuriesClosedCessna 172L · Waukesha, WIJan 15, 1978 · N7699G · Substantial damageNTSB CHI78DER03Accident · No injuriesClosedCessna 150 · Superior, WIJan 10, 1978 · N6039K · Substantial damageNTSB CHI78DER02Accident · No injuriesClosedPiper PA-28 · Amery, WIJan 9, 1978 · N8005W · Substantial damageNTSB CHI78FA034Accident · 1 fatalClosedPiper PA-28 · Mellen, WIJan 2, 1978 · N8215C · Destroyed