Skip to content

NTSB investigations, 1966, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations, 1966, WI per year, 1964–2026: 3,022 cases
1964	70
1965	75
1966	88
1967	99
1968	81
1969	93
1970	87
1971	65
1972	74
1973	77
1974	81
1975	69
1976	55
1977	75
1978	90
1979	89
1980	62
1981	69
1982	54
1983	60
1984	64
1985	59
1986	55
1987	48
1988	47
1989	56
1990	47
1991	46
1992	39
1993	55
1994	41
1995	41
1996	35
1997	33
1998	44
1999	44
2000	34
2001	46
2002	37
2003	32
2004	37
2005	38
2006	21
2007	32
2008	40
2009	23
2010	26
2011	31
2012	35
2013	18
2014	22
2015	30
2016	28
2017	25
2018	26
2019	19
2020	14
2021	25
2022	23
2023	25
2024	24
2025	24
2026	20

Where

Latest cases

Query with SQL

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") = 1966 AND c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1966
    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.

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") = 1966
  AND c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI67D0455Accident · No injuriesClosedBeech A23-24 · Winneconne, WIDec 24, 1966 · N7987L · Substantial damage NTSB CHI67D0436Accident · No injuriesClosedAeronca 15AC · Pt.Washington, WIDec 18, 1966 · N1401H · Substantial damage NTSB CHI67D0429Accident · No injuriesClosedPiper PA-23 · Madison, WIDec 15, 1966 · N3139P · Substantial damage NTSB CHI67F0434Accident · No injuriesClosedCessna 210-5 · Waupun, WIDec 6, 1966 · N8047Z · Substantial damage NTSB CHI67D0389Accident · No injuriesClosedPiper PA-28 · Superior, WIDec 3, 1966 · N7721W · Substantial damage NTSB CHI67A0067Accident · 4 fatalClosedPiper PA-28 · Madison, WINov 22, 1966 · N7901W · Destroyed NTSB MKC67D0311Accident · No injuriesClosedAeronca 7AC · Prairie Farm, WINov 20, 1966 · N85569 · Substantial damage NTSB CHI67F0354Accident · No injuriesClosedCessna 170B · Pewaukee, WINov 20, 1966 · N3120B · Substantial damage NTSB CHI67F0430Accident · Minor injuriesClosedBeech C35 · Waukesha, WINov 12, 1966 · N5979C · Substantial damage NTSB CHI67F0306Accident · No injuriesClosedPiper PA12 · Woodruff, WINov 6, 1966 · N2824M · Substantial damage NTSB CHI67D0349Accident · No injuriesClosedPiper PA-24 · Delavan, WIOct 31, 1966 · N8952P · Substantial damage NTSB CHI67D0341Accident · No injuriesClosedPiper PA-23 · Racine, WIOct 30, 1966 · N2150P · Substantial damage NTSB CHI67D0347Accident · Minor injuriesClosedChampion 7FC · Elcho, WIOct 25, 1966 · N9862Y · Substantial damage NTSB CHI67A0055Accident · 2 fatalClosedTaylorcraft BC12-D · Burlington, WIOct 23, 1966 · N39294 · Destroyed NTSB CHI67F0327Accident · No injuriesClosedPiper PA-28 · Delafield, WIOct 22, 1966 · N5582W · Substantial damage NTSB CHI67D0293Accident · No injuriesClosedNavion A · Stevens Point, WIOct 12, 1966 · N4002K · Substantial damage NTSB CHI67D0292Accident · No injuriesClosedChampion 7FC · Hales Corners, WIOct 9, 1966 · N9017B · Substantial damage NTSB CHI67D0286Accident · No injuriesClosedCessna 172 · Waukesha, WIOct 4, 1966 · N3896L · Substantial damage NTSB CHI67D0285Accident · No injuriesClosedPiper PA-24 · Sheboygan Fls, WIOct 3, 1966 · N8337P · Substantial damage NTSB CHI67F0254Accident · No injuriesClosedStinson 108-1 · Solon Springs, WIOct 2, 1966 · N40110 · Substantial damage NTSB CHI67D0352Accident · No injuriesClosedCessna 150 · La Farge, WIOct 1, 1966 · N7725F · Substantial damage NTSB CHI67D0313Accident · No injuriesClosedAeronca 11BC · Kaukauna, WISep 23, 1966 · N3948E · Substantial damage NTSB CHI67F0337Accident · No injuriesClosedChampion 7GCAA · Salem, WISep 17, 1966 · N9626S · Substantial damage NTSB CHI67F0223Accident · No injuriesClosedCessna 310K · Delevan, WISep 16, 1966 · N3801X · Substantial damage NTSB CHI67D0195Accident · No injuriesClosedCessna 150A · Stevens Point, WISep 12, 1966 · N7217X · Substantial damage NTSB CHI67F0190Accident · No injuriesClosedTaylorcraft DCO-65 · Cottage Grove, WISep 11, 1966 · N50702 · Substantial damage NTSB CHI67F0189Accident · No injuriesClosedBeech D18S · Janesville, WISep 8, 1966 · N156NA · Substantial damage NTSB CHI67F0191Accident · Minor injuriesClosedAeronca 15AC · Superior, WISep 6, 1966 · N1156H · Substantial damage NTSB CHI67D0185Accident · No injuriesClosedCessna 140 · Pewaukee, WIAug 29, 1966 · N76708 · Substantial damage NTSB CHI67F0268Accident · Minor injuriesClosedMooney M20C · Crivitz, WIAug 28, 1966 · N2799W · Destroyed NTSB CHI67F0173Accident · No injuriesClosedCessna 205 · Oak Creek, WIAug 27, 1966 · N8150Z · Substantial damage NTSB CHI67D0184Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 25, 1966 · N6428E · Substantial damage NTSB CHI67F0181Accident · Minor injuriesClosedCessna 170A · Walworth, WIAug 21, 1966 · N9217A · Substantial damage NTSB CHI67A0025Accident · 1 fatalClosedBeech 23 · Tomah, WIAug 21, 1966 · N2307J · Destroyed NTSB CHI67D0157Accident · No injuriesClosedCessna 185 · Land O Lakes, WIAug 16, 1966 · N4019Y · Substantial damage NTSB CHI67F0175Accident · Serious injuriesClosedPiper PA-18 · Mt.Hope, WIAug 11, 1966 · N3496Z · Destroyed NTSB CHI67F0162Accident · Serious injuriesClosedAeronca 15AC · Minocqua, WIAug 6, 1966 · N1377H · Destroyed NTSB CHI67D0110Accident · No injuriesClosedCessna 310B · Milwaukee, WIAug 1, 1966 · N5396A · Substantial damage NTSB CHI67F0122Accident · No injuriesClosedCessna 170B · Brookfield, WIJul 29, 1966 · N3194B · Substantial damage NTSB CHI67D0107Accident · Minor injuriesClosedPiper PA-22 · Osseo, WIJul 29, 1966 · N8803C · Substantial damage NTSB CHI67A0016Accident · 1 fatalClosedCessna 150 · Racine, WIJul 27, 1966 · N3005J · Destroyed NTSB CHI67F0127Accident · No injuriesClosedCessna 310H · Racine, WIJul 25, 1966 · N222YW · Substantial damage NTSB CHI67F0100Accident · No injuriesClosedPiper PA-28 · De Pere, WIJul 12, 1966 · N6772W · Substantial damage NTSB CHI67D0120Accident · Minor injuriesClosedPiper PA-22 · Whitewater, WIJul 10, 1966 · N8494D · Destroyed NTSB CHI67D0125Accident · Serious injuriesClosedBeech 35 · West Bend, WIJul 8, 1966 · N4465V · Substantial damage NTSB CHI67F0141Accident · Serious injuriesClosedBeech A23 · Baraboo, WIJul 5, 1966 · N1449L · Substantial damage NTSB MKC67F0118Accident · Serious injuriesClosedPitts Specl · Rice Lake, WIJul 3, 1966 · N7513U · Destroyed NTSB CHI67D0085Accident · No injuriesClosedPiper PA-28 · Viola, WIJul 3, 1966 · N5234W · Substantial damage NTSB CHI67D0035Accident · Minor injuriesClosedLuscombe 8A · Montello, WIJul 2, 1966 · N71350 · Destroyed NTSB CHI67F0087Accident · No injuriesClosedNavion B · Marshall, WIJun 28, 1966 · N29P · Substantial damage