NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 CHI66F0475Accident · No injuriesClosedErcoupe 415-C · Stevens Pt, WIDec 16, 1965 · N94196 · Substantial damageNTSB CHI66F0521Accident · Serious injuriesClosedCessna 172D · Walworth, WIDec 10, 1965 · N2085Y · DestroyedNTSB CHI66F0497Accident · No injuriesClosedCulver LCA · Superior, WINov 30, 1965 · N20988 · Substantial damageNTSB CHI66F0505Accident · Minor injuriesClosedTaylorcraft DCO-65 · Waupaca, WINov 26, 1965 · N53514 · Substantial damageNTSB CHI66F0467Accident · No injuriesClosedPiper PA-24 · Eau Claire, WINov 13, 1965 · N5352P · Substantial damageNTSB CHI66D0436Accident · Minor injuriesClosedStinson 108-3 · Portage, WIOct 24, 1965 · N1000M · Substantial damageNTSB CHI66F0480Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIOct 17, 1965 · N7326W · 2 aircraft · Substantial damageNTSB CHI66A0038Accident · 2 fatalClosedCessna 310F · Minocqua, WIOct 17, 1965 · N188RT · DestroyedNTSB CHI66A0033Accident · 1 fatalClosedBeech 35 · Delton, WIOct 8, 1965 · N3847N · DestroyedNTSB CHI66D0463Accident · No injuriesClosedChampion 7FC · Coon Valley, WIOct 2, 1965 · N7534B · Substantial damageNTSB CHI66F0435Accident · Minor injuriesClosedCessna 172 · Lake Geneva, WISep 22, 1965 · N6287E · Substantial damageNTSB CHI66D0460Accident · No injuriesClosedPiper PA-28 · Cashton, WISep 19, 1965 · N7742W · Substantial damageNTSB CHI66A0028Accident · 1 fatalClosedAeronca 7AC · Whitewater, WISep 17, 1965 · N2334E · DestroyedNTSB CHI66A0026Accident · No injuriesClosedDouglas DC-3 · Stevens Pt., WISep 14, 1965 · N28341 · Substantial damageNTSB CHI66D0442Accident · No injuriesClosedCessna 210 · Delavan, WISep 11, 1965 · N9492T · Substantial damageNTSB CHI66A0022Accident · 2 fatalClosedCessna 182 · Burlington, WIAug 25, 1965 · N2402G · DestroyedNTSB CHI66F0178Accident · No injuriesClosedCessna 140 · Milwaukee, WIAug 23, 1965 · N76465 · Substantial damageNTSB CHI66D0493Accident · No injuriesClosedPiper PA-24 · Crivitz, WIAug 20, 1965 · N5630P · Substantial damageNTSB CHI66A0019Accident · 1 fatalClosedMooney M-20C · Beloit, WIAug 20, 1965 · N6701U · DestroyedNTSB CHI66F0300Accident · Serious injuriesClosedNardi FN333 · Three Lakes, WIAug 19, 1965 · N624 · DestroyedNTSB CHI66D0362Accident · No injuriesClosedBeechcraft F35 · Seymour, WIAug 18, 1965 · N3386C · Substantial damageNTSB CHI66F0424Accident · Serious injuriesClosedPiper J-3 · De Pere, WIAug 17, 1965 · N23413 · Substantial damageNTSB CHI66D0411Accident · No injuriesClosedBeechcraft F35 · Baraboo, WIAug 16, 1965 · N3844B · Substantial damageNTSB CHI66F0216Accident · Minor injuriesClosedPiper PA-28 · Delavan, WIAug 13, 1965 · N7280W · Substantial damageNTSB CHI66F0168Accident · Serious injuriesClosedComonwealth 185 · Baraboo, WIAug 13, 1965 · N92834 · DestroyedNTSB CHI66I0016Incident · No injuriesClosedBoeing B-720 · Milwaukee, WIAug 11, 1965 · N466US · Minor damageNTSB CHI66F0423Accident · No injuriesClosedCessna 310B · Milwaukee, WIAug 10, 1965 · N493JE · Substantial damageNTSB CHI66A0015Accident · 4 fatalClosedBeech B35 · Boulder Jct, WIAug 7, 1965 · N5091C · DestroyedNTSB CHI66A0011Accident · 1 fatalClosedAircoupe A-2 · Langlade, WIJul 30, 1965 · N5480E · DestroyedNTSB CHI65D0151Accident · No injuriesClosedBeechcraft H35 · Madison, WIJul 28, 1965 · N5475D · Substantial damageNTSB CHI66F0189Accident · No injuriesClosedBeechcraft A-35 · Green Bay, WIJul 24, 1965 · N8681A · Substantial damageNTSB CHI66F0152Accident · Minor injuriesClosedStinson 108-2 · Beaver Dam, WIJul 24, 1965 · N286C · DestroyedNTSB CHI66A0009Accident · 1 fatalClosedCessna 150C · Wausau, WIJul 18, 1965 · N7936Z · DestroyedNTSB CHI66F0170Accident · No injuriesClosedCessna 195 · Oshkosh, WIJul 15, 1965 · N4381V · Substantial damageNTSB CHI66F0428Accident · Minor injuriesClosedFairchild M-62A3 · Pulaski, WIJul 13, 1965 · N64551 · Substantial damageNTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WIJul 10, 1965 · N89657 · Substantial damageNTSB CHI66F0166Accident · No injuriesClosedStinson 108 · Lac Duflambeu, WIJul 8, 1965 · N6865M · Substantial damageNTSB CHI66F0364Accident · No injuriesClosedPiper PA-12 · Dallas, WIJul 4, 1965 · N4227M · Substantial damageNTSB CHI66A0002Accident · 1 fatalClosedPiper PA-16 · Lake Delton, WIJul 4, 1965 · N6866K · DestroyedNTSB CHI66A0001Accident · 2 fatalClosedTaylorcraft BC-12D · Mineral Point, WIJul 3, 1965 · N96648 · DestroyedNTSB CHI66F0047Accident · Minor injuriesClosedNo American SNJ-5 · Hales Corner, WIJun 28, 1965 · N3262G · Substantial damageNTSB CHI66F0141Accident · Serious injuriesClosedComonwealth 7000 · Sparta, WIJun 26, 1965 · N20734 · Substantial damageNTSB CHI66F0471Accident · No injuriesClosedBeechcraft H35 · Delavan, WIJun 24, 1965 · N5493D · Substantial damageNTSB CHI66F0113Accident · Minor injuriesClosedStinson 108-2 · Kenosha, WIJun 24, 1965 · N9519K · DestroyedNTSB CHI66D0348Accident · No injuriesClosedPiper PA-24 · Wausau, WIJun 24, 1965 · N6188P · DestroyedNTSB CHI66F0163Accident · No injuriesClosedNavion B · Portage, WIJun 23, 1965 · N5436K · Substantial damageNTSB CHI66F0142Accident · No injuriesClosedLuscombe 8F · Milwaukee, WIJun 21, 1965 · N2036K · Substantial damageNTSB CHI66D0162Accident · No injuriesClosedPiper PA-22 · Lake Geneva, WIJun 20, 1965 · N4568A · Substantial damageNTSB CHI65A0106Accident · No injuriesClosedHughes 269B · Gile, WIJun 20, 1965 · N9355F · Substantial damageNTSB CHI66D0112Accident · No injuriesClosedAeronca 15AC · Wisconsin Dls, WIJun 19, 1965 · N1314H · Substantial damage