NTSB investigations, 1980, WI

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19642026
NTSB investigations, 1980, WI per year, 1964–2026: 3,022 cases
196470
196575
196688
196799
196881
196993
197087
197165
197274
197377
197481
197569
197655
197775
197890
197989
198062
198169
198254
198360
198464
198559
198655
198748
198847
198956
199047
199146
199239
199355
199441
199541
199635
199733
199844
199944
200034
200146
200237
200332
200437
200538
200621
200732
200840
200923
201026
201131
201235
201318
201422
201530
201628
201725
201826
201919
202014
202125
202223
202325
202424
202524
202620

Latest cases

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\") = 1980
    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 CHI81FEP06Accident · No injuriesClosedCessna U206G · Kenosha, WIDec 30, 1980 · N5397X · Substantial damageNTSB CHI81FA014Accident · 2 fatalClosedBeech G35 · Harding, WIDec 30, 1980 · N190B · DestroyedNTSB CHI81FEP07Accident · No injuriesClosedCessna 150L · Spencer, WINov 2, 1980 · N6773G · Substantial damageNTSB CHI81FA005Accident · 1 fatalClosedCessna 172 · Westfield, WINov 2, 1980 · N7686G · DestroyedNTSB CHI81FEP05Accident · No injuriesClosedCessna 150L · Rhinelander, WIOct 11, 1980 · N7730G · Substantial damageNTSB CHI81DEP04Accident · No injuriesClosedPiper PA-28 · Cottage Grove, WIOct 7, 1980 · N4817L · Substantial damageNTSB CHI81DEP03Accident · Serious injuriesClosedCessna 150F · Elkhorn, WIOct 7, 1980 · N7856F · No damageNTSB CHI81DEP02Accident · No injuriesClosedCessna 172N · Phillips, WIOct 6, 1980 · N75951 · Substantial damageNTSB CHI81FEP01Accident · No injuriesClosedPiper PA-28 · Lakewood, WIOct 5, 1980 · N5267T · Substantial damageNTSB CHI80FEP58Accident · No injuriesClosedPiper PA-25 · Evansville, WISep 26, 1980 · N7627Z · Substantial damageNTSB CHI80FEP56Accident · Serious injuriesClosedPitts S-1S · Burlington, WISep 24, 1980 · N17BE · Substantial damageNTSB CHI80DER68Accident · No injuriesClosedCessna 150 · Osceola, WISep 22, 1980 · N8582J · Substantial damageNTSB CHI80DEP57Accident · No injuriesClosedCessna 170A · Iola, WISep 21, 1980 · N401P · Substantial damageNTSB CHI80DEP59Accident · No injuriesClosedGrum-Amer AA-1B · Wilmot, WISep 20, 1980 · N89816 · Substantial damageNTSB CHI80FEP55Accident · 1 fatalClosedBensen B-8M · Franksville, WISep 14, 1980 · N37512 · Substantial damageNTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WISep 13, 1980 · N7801D · Substantial damageNTSB CHI80FEP53Accident · Serious injuriesClosedBell 206 · Grafton, WISep 8, 1980 · N256DE · Substantial damageNTSB CHI80FEP52Accident · No injuriesClosedCessna 180 · Bevent, WISep 2, 1980 · N180FS · Substantial damageNTSB CHI80FEP60Accident · No injuriesClosedPiper PA-28 · Cornucopia, WISep 1, 1980 · N33444 · Substantial damageNTSB CHI80FA066Accident · 1 fatalClosedPiper PA-28 · Antigo, WIAug 29, 1980 · N1807J · DestroyedNTSB CHI80FEP49Accident · Minor injuriesClosedVarga 2150A · Fort Atkinson, WIAug 19, 1980 · N5083V · Substantial damageNTSB CHI80FEP51Accident · Serious injuriesClosedPitts S-1C · Fond Du Lac, WIAug 15, 1980 · N2271 · Substantial damageNTSB CHI80DEP47Accident · No injuriesClosedPiper PA-28 · Chippewa Falls, WIAug 15, 1980 · N2264M · Substantial damageNTSB CHI80FEP48Accident · No injuriesClosedBeech A23-19 · Winneconne, WIAug 12, 1980 · N4737J · Substantial damageNTSB CHI80DEP50Accident · No injuriesClosedPiper PA-32 · Dodgeville, WIAug 9, 1980 · N3954W · Substantial damageNTSB CHI80FEP44Accident · Minor injuriesClosedPiper PA-28 · Collins, WIAug 7, 1980 · N6796W · Substantial damageNTSB CHI80FEP43Accident · No injuriesClosedPiper PA-28R · Green Bay, WIAug 7, 1980 · N7695J · Substantial damageNTSB CHI80DEP42Accident · No injuriesClosedSikorsky CH-19E · Plover, WIAug 3, 1980 · N94475 · Substantial damageNTSB CHI80FEP46Accident · 1 fatalClosedSkyhopper 20 · Oshkosh, WIAug 2, 1980 · N45802 · Substantial damageNTSB CHI80FEP45Accident · 2 fatalClosedVari-Eze 01 · Oshkosh, WIAug 1, 1980 · N7EJ · DestroyedNTSB CHI80DEP41Accident · No injuriesClosedBlanik L-13 · Middleton, WIJul 16, 1980 · N90889 · Substantial damageNTSB CHI80FEP40Accident · No injuriesClosedPitts S-1C · Wyocena, WIJul 13, 1980 · N2761 · Substantial damageNTSB CHI80FEP38Accident · Minor injuriesClosedCessna 177RG · New Lisbon, WIJul 7, 1980 · N34365 · Substantial damageNTSB CHI80FEP39Accident · No injuriesClosedCessna 182K · Wilmot, WIJul 3, 1980 · N3013Q · Substantial damageNTSB CHI80DEP36Accident · No injuriesClosedBell 47G-3B · Plainfield, WIJun 11, 1980 · N73995 · Substantial damageNTSB CHI80DEP35Accident · No injuriesClosedCessna 172D · Delavan, WIJun 8, 1980 · N2413Y · Substantial damageNTSB CHI80FER45Accident · No injuriesClosedBeech 23 · Deerpark, WIJun 2, 1980 · N8738M · Substantial damageNTSB CHI80DEP34Accident · No injuriesClosedCessna 152 · Watertown, WIMay 27, 1980 · N4809A · Substantial damageNTSB CHI80FEP31Accident · Serious injuriesClosedTomcat MARK5A · Stockbridge, WIMay 23, 1980 · N19JM · Substantial damageNTSB CHI80FA042Accident · 2 fatalClosedGrum-Amer AA-1C · Portage, WIMay 23, 1980 · N9524U · DestroyedNTSB CHI80DEP32Accident · No injuriesClosedStearman A75-N1 · City Point, WIMay 23, 1980 · N63111 · Substantial damageNTSB CHI80FEP29Accident · No injuriesClosedCassutt 111M · Stevens Pt, WIMay 21, 1980 · N5JJ · Substantial damageNTSB CHI80DEP33Accident · No injuriesClosedPiper PA-28 · Bristol, WIMay 17, 1980 · N4327T · Substantial damageNTSB CHI80DEP30Accident · Minor injuriesClosedCessna 172M · Ixonia, WIMay 17, 1980 · N73362 · Substantial damageNTSB CHI80DEP37Accident · No injuriesClosedCessna 152 · Platteville, WIMay 12, 1980 · N25990 · Substantial damageNTSB CHI80DEP28Accident · No injuriesClosedCessna 152 · Tilden, WIMay 4, 1980 · N757SV · Substantial damageNTSB CHI80DEP27Accident · Minor injuriesClosedBensen B-8M · Manitowoc, WIApr 27, 1980 · N2264A · Substantial damageNTSB CHI80DEP26Accident · Serious injuriesClosedCessna 172F · Stone Lake, WIApr 22, 1980 · N5583R · Substantial damageNTSB CHI80DEP23Accident · No injuriesClosedPiper PA-12 · Mount Vernon, WIApr 22, 1980 · N3181M · Substantial damageNTSB CHI80DEP24Accident · No injuriesClosedCessna 172K · Waunakee, WIApr 21, 1980 · N7301G · Substantial damage