NTSB investigations, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1199Accident · No injuriesClosedCessna 180 · Rice Lake, WIDec 31, 1964 · N4930A · Substantial damageNTSB UNK65X1132Accident · No injuriesClosedPiper PA23 · Abbotsford, WIDec 25, 1964 · N3431P · Substantial damageNTSB UNK65X1055Accident · Minor injuriesClosedCessna 172 · St Nazianz, WIDec 19, 1964 · N4271F · Substantial damageNTSB UNK65X1053Accident · No injuriesClosedPiper PA22 · Marshfield, WIDec 19, 1964 · N940A · Substantial damageNTSB UNK65X0725Accident · No injuriesClosedCessna 140 · Depere, WINov 15, 1964 · N2058V · Substantial damageNTSB UNK65X0460Accident · No injuriesClosedBeech 35 · Stoughton, WIOct 28, 1964 · N2735V · Substantial damageNTSB UNK65X0438Accident · Serious injuriesClosedAeronca 11AC · Boscobel, WIOct 25, 1964 · N86390 · Substantial damageNTSB UNK65X0242Accident · No injuriesClosedCessna 140 · Palmyra, WIOct 11, 1964 · N2050V · DestroyedNTSB UNK65X0195Accident · No injuriesClosedPiper PA24 · Ladysmith, WIOct 8, 1964 · N7785P · Substantial damageNTSB UNK64X3963Accident · No injuriesClosedLuscombe 8A · Wis Rapids, WISep 13, 1964 · N2704K · Substantial damageNTSB UNK64X3953Accident · 1 fatalClosedLuscombe 8C · Marquette, WISep 13, 1964 · N28582 · DestroyedNTSB UNK64X3935Accident · No injuriesClosedCessna 182 · Eau Claire, WISep 12, 1964 · N3758D · Substantial damageNTSB UNK64X3904Accident · No injuriesClosedCessna 172 · Danbury, WISep 10, 1964 · N7586X · Substantial damageNTSB UNK64X3864Accident · 2 fatalClosedStinson 108-2 · Wis Rapids, WISep 7, 1964 · N937D · DestroyedNTSB UNK64X3808Accident · Serious injuriesClosedPiper J-3 · Muskego, WISep 5, 1964 · N78500 · DestroyedNTSB UNK64X3711Accident · No injuriesClosedCessna 172 · Delavan, WIAug 31, 1964 · N7481T · Substantial damageNTSB UNK64X3499Accident · No injuriesClosedDouglas A-26B · Madison, WIAug 20, 1964 · N4050A · Substantial damageNTSB UNK64X3494Accident · No injuriesClosedBoeing A75N1 · Delavan, WIAug 20, 1964 · N63695 · DestroyedNTSB UNK64X3423Accident · Minor injuriesClosedCessna 140 · Waukesea, WIAug 16, 1964 · N89345 · DestroyedNTSB UNK64X3382Accident · No injuriesClosedCessna 172 · Ft Atkinson, WIAug 14, 1964 · N5681T · Substantial damageNTSB UNK64X3381Accident · No injuriesClosedBeechcraft M23 · Luck, WIAug 14, 1964 · N2386Z · Substantial damageNTSB UNK64X3348AccidentClosedChampion 7FC · Coloma, WIAug 12, 1964 · N9870B · Substantial damageNTSB UNK64X3195Accident · No injuriesClosedCessna 140 · Janesville, WIAug 3, 1964 · N2084V · Substantial damageNTSB UNK64X3185Accident · No injuriesClosedHughes 269A · Oconomowoc Lk, WIAug 2, 1964 · N8924F · Substantial damageNTSB UNK64X3067Accident · Minor injuriesClosedPiper PA22 · Lake Geneva, WIJul 27, 1964 · N2816P · DestroyedNTSB UNK64X3060Accident · 2 fatalClosedTaylorcraft BC12-D · Tomahawk, WIJul 26, 1964 · N95159 · DestroyedNTSB UNK64X2963Accident · No injuriesClosedCessna 140 · Wabeno, WIJul 21, 1964 · N1894U · Substantial damageNTSB UNK64X2960Accident · No injuriesClosedCessna 172B · Middletown, WIJul 21, 1964 · N6905X · Substantial damageNTSB UNK64X2946Accident · No injuriesClosedPiper PA24 · Eagle River, WIJul 20, 1964 · N5352P · Substantial damageNTSB UNK64X2892Accident · No injuriesClosedBellanca 14132 · Hales Corners, WIJul 18, 1964 · N86806 · Substantial damageNTSB UNK64X2827Accident · No injuriesClosedTaylorcraft BC12 · Janesville, WIJul 14, 1964 · N36112 · Substantial damageNTSB UNK64X2794Accident · No injuriesClosedErcoupe 415CD · Watertown, WIJul 12, 1964 · N94712 · Substantial damageNTSB UNK64X2764Accident · Minor injuriesClosedPiper PA22 · Mukwonago, WIJul 11, 1964 · N2713D · Substantial damageNTSB UNK64X2738Accident · No injuriesClosedBeechcraft C35 · Sheboygan, WIJul 9, 1964 · N644D · Substantial damageNTSB UNK64X2643Accident · No injuriesClosedMooney MK20D · Monroe Center, WIJul 4, 1964 · N6637U · Substantial damageNTSB UNK64X2610Accident · Serious injuriesClosedPiper PA18A · Waupun, WIJul 2, 1964 · N8078C · DestroyedNTSB UNK64X2549Accident · No injuriesClosedLuscombe 8A · Cushing, WIJun 28, 1964 · N2943K · Substantial damageNTSB UNK64X2369Accident · No injuriesClosedBeechcraft 35 · Rhinderlander, WIJun 19, 1964 · N3441B · Substantial damageNTSB UNK64X2280Accident · Minor injuriesClosedBeechcraft D35 · West Bend, WIJun 14, 1964 · N2953B · Substantial damageNTSB UNK64X2180Accident · Minor injuriesClosedBell 47G2A · Montello, WIJun 7, 1964 · N73227 · Substantial damageNTSB UNK64X2173Accident · Minor injuriesClosedStinson 108-3 · Solon Springs, WIJun 7, 1964 · N644C · DestroyedNTSB UNK64X2101Accident · No injuriesClosedBeechcraft H35 · Milwaukee, WIJun 4, 1964 · N5574D · Substantial damageNTSB UNK64X2058Accident · Minor injuriesClosedAeronca 7AC · Appleton, WIMay 31, 1964 · N84555 · Substantial damageNTSB UNK64X2050Accident · Minor injuriesClosedErcoupe 415C · Mukwonago, WIMay 31, 1964 · N2043H · DestroyedNTSB UNK64X2029Accident · No injuriesClosedPiper PA12 · Withee, WIMay 30, 1964 · N98932 · Substantial damageNTSB UNK64X2005Accident · Minor injuriesClosedPiper PA18 · Sturtevant, WIMay 29, 1964 · N7077D · Substantial damageNTSB UNK64X1972Accident · No injuriesClosedBeechcraft S35 · Milwaukee, WIMay 27, 1964 · N1503S · Substantial damageNTSB UNK64X1917Accident · No injuriesClosedCessna 310 · Milwaukee, WIMay 23, 1964 · N5226A · Substantial damageNTSB UNK64X1913Accident · Minor injuriesClosedChampion 7EC · Birchwood, WIMay 23, 1964 · N8912R · Substantial damageNTSB UNK64X1850Accident · No injuriesClosedBeechcraft 35-33 · La Crosse, WIMay 19, 1964 · N918T · Substantial damage