NTSB investigations, 1976, 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, 1976, 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\") = 1976
    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 CHI77FEP12Accident · Serious injuriesClosedPiper PA-30A · Madison, WIDec 27, 1976 · N7184Y · DestroyedNTSB CHI77FEP13Accident · No injuriesClosedPiper PA-28 · Cable, WIDec 24, 1976 · N210KB · Substantial damageNTSB CHI77DEP11Accident · No injuriesClosedPiper PA-22 · West Bend, WIDec 21, 1976 · N5835Z · Substantial damageNTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WIDec 15, 1976 · N2973E · Substantial damageNTSB CHI77FEP10Accident · Serious injuriesClosedBeech C55 · Eau Claire, WIDec 9, 1976 · N551U · Substantial damageNTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WIDec 4, 1976 · N3526J · DestroyedNTSB CHI77FEP09Accident · No injuriesClosedCessna 310 · Janesville, WIDec 2, 1976 · N188GS · Substantial damageNTSB CHI77FEP07Accident · No injuriesClosedPiper PA-32R · Ashippun, WINov 27, 1976 · N6273J · Substantial damageNTSB CHI77FEP08Accident · No injuriesClosedStinson 108-1 · Burlington, WINov 25, 1976 · N97849 · Substantial damageNTSB CHI77FEP06Accident · No injuriesClosedBeech V35R · Cottage Grove, WINov 20, 1976 · N3016V · Substantial damageNTSB CHI77DEP05Accident · Minor injuriesClosedCessna 140 · Brookfield, WINov 20, 1976 · N2168V · Substantial damageNTSB CHI77DEP03Accident · Minor injuriesClosedCessna 172 · Middleton, WINov 10, 1976 · N1582Y · Substantial damageNTSB CHI77FEP02Accident · No injuriesClosedCessna 210T · Eau Claire, WIOct 21, 1976 · N3006R · Substantial damageNTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WIOct 20, 1976 · N704PN · DestroyedNTSB CHI77DEP01Accident · No injuriesClosedMooney M20 · Franklin, WIOct 3, 1976 · N6500B · Substantial damageNTSB CHI76DEP51Accident · Minor injuriesClosedCessna 150 · Boscobel, WISep 22, 1976 · N11106 · DestroyedNTSB CHI76DEP50Accident · No injuriesClosedPiper PA-28 · Ladysmith, WISep 13, 1976 · N6113J · Substantial damageNTSB CHI76DEP48Accident · No injuriesClosedCessna 210 · Big Falls, WISep 11, 1976 · N9450T · Substantial damageNTSB CHI76AC089Accident · 2 fatalClosedCessna 150L · Stevens Point, WISep 5, 1976 · N6986G · Substantial damageNTSB CHI76DEP49Accident · No injuriesClosedBeech B24R · Walworth, WISep 4, 1976 · N2518W · Substantial damageNTSB CHI76DEP47Accident · Minor injuriesClosedBellanca 8GCBC · West Bend, WISep 4, 1976 · N88089 · Substantial damageNTSB CHI76FEP45Accident · Serious injuriesClosedCessna 210 · Hales Corner, WIAug 28, 1976 · N3911Y · DestroyedNTSB CHI76DEP46Accident · Serious injuriesClosedCessna 172 · Dodgeville, WIAug 28, 1976 · N9626V · Substantial damageNTSB CHI76DEP44Accident · No injuriesClosedPiper PA-24 · La Crosse, WIAug 18, 1976 · N9390P · Substantial damageNTSB CHI76AC086Accident · 2 fatalClosedCessna 207 · East Troy, WIAug 17, 1976 · N91061 · DestroyedNTSB CHI76FEP43Accident · No injuriesClosedPiper PA-28R · Withee, WIAug 13, 1976 · N4375X · Substantial damageNTSB CHI76FEP42Accident · Minor injuriesClosedMooney M20E · Grafton, WIAug 13, 1976 · N5753Q · Substantial damageNTSB CHI76AC085Accident · 1 fatalClosedPiper PA-18 · Tomahawk, WIAug 9, 1976 · N3697Z · DestroyedNTSB CHI76AC083Accident · 1 fatalClosedPiper PA-28R · Oshkosh, WIAug 7, 1976 · N55765 · DestroyedNTSB CHI77DEP04Accident · No injuriesClosedCessna 310B · Bristol, WIJul 25, 1976 · N5396A · Substantial damageNTSB CHI76FEP38Accident · Minor injuriesClosedHughes 269A · Abbotsford, WIJul 25, 1976 · N8929F · Substantial damageNTSB CHI76FEP39Accident · Minor injuriesClosedPiper PA-28 · Sturtevant, WIJul 24, 1976 · N44553 · Substantial damageNTSB CHI76DEP41Accident · No injuriesClosedBoeing A75N1 · Hartford, WIJul 24, 1976 · N73878 · Substantial damageNTSB CHI76FEP40Accident · No injuriesClosedCessna 180J · Rhinelander, WIJul 22, 1976 · N9906N · Substantial damageNTSB CHI76FEP37Accident · No injuriesClosedSnow 600S2C · Plainfield, WIJul 21, 1976 · N1629S · DestroyedNTSB CHI76FEP35Accident · Serious injuriesClosedCessna 210 · Schofield, WIJul 13, 1976 · N9416T · DestroyedNTSB CHI76DEP36Accident · No injuriesClosedPiper PA-28 · Ojibwa, WIJul 5, 1976 · N44604 · Substantial damageNTSB CHI76DEP34Accident · No injuriesClosedPiper J3C · Cottage Grove, WIJul 3, 1976 · N30714 · Substantial damageNTSB CHI76FEP33Accident · No injuriesClosedCessna 180A · Milwaukee, WIJun 6, 1976 · N7769A · Substantial damageNTSB CHI76FEP31Accident · Serious injuriesClosedLuscombe 8A · West Bend, WIMay 24, 1976 · N1037K · DestroyedNTSB CHI76DEP30Accident · Minor injuriesClosedCessna 150 · Albany, WIMay 9, 1976 · N2931S · Substantial damageNTSB CHI76AC059Accident · 1 fatalClosedBoeing A75N1 · Lake Geneva, WIMay 4, 1976 · N56945 · DestroyedNTSB CHI76FEP29Accident · Minor injuriesClosedCessna 182K · Lake Geneva, WIApr 27, 1976 · N2898R · Substantial damageNTSB CHI76FEP28Accident · No injuriesClosedPiper PA-28R · Pulaski, WIApr 20, 1976 · N4508J · Substantial damageNTSB CHI76DEP27Accident · No injuriesClosedCessna 170A · Hartford, WIApr 3, 1976 · N1332D · Substantial damageNTSB CHI76AC052Accident · 1 fatalClosedBeech E18S · Burlington, WIMar 1, 1976 · N386 · DestroyedNTSB CHI76DER07Accident · No injuriesClosedCessna 150 · Amery, WIFeb 26, 1976 · N3596L · Substantial damageNTSB CHI76DEP26Accident · No injuriesClosedPiper PA-18 · Milwaukee, WIFeb 23, 1976 · N326T · Substantial damageNTSB CHI76AC050Accident · 1 fatalClosedPiper PA-32 · Cable, WIFeb 20, 1976 · N3947W · DestroyedNTSB CHI76DEP24Accident · No injuriesClosedPiper PA-20 · Baraboo, WIFeb 8, 1976 · N7354K · Substantial damage