Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 CHI68D0543Accident · No injuriesClosedPiper PA-28 · New Richmond, WIDec 31, 1967 · N7642W · Substantial damage NTSB CHI68D0523Accident · No injuriesClosedCessna 140 · Fitchburg, WIDec 24, 1967 · N1914N · Substantial damage NTSB CHI68D0524Accident · No injuriesClosedCessna 150 · Hales Corners, WIDec 23, 1967 · N6431T · Substantial damage NTSB CHI68F0495Accident · No injuriesClosedCessna 310C · Prairie D Sac, WIDec 14, 1967 · N1796H · Destroyed NTSB CHI68A0053Accident · 7 fatalClosedBeech H18 · Madison, WIDec 10, 1967 · N390R · Destroyed NTSB CHI68F0598Accident · Serious injuriesClosedPiper PA-32 · Wauwatosa, WIDec 8, 1967 · N3437W · Substantial damage NTSB CHI68D0481Accident · No injuriesClosedCessna 310F · Waukesha, WIDec 4, 1967 · N6720X · Substantial damage NTSB CHI68D0548Accident · No injuriesClosedCessna 150 · Germantown, WINov 25, 1967 · N3007J · Substantial damage NTSB CHI68D0480Accident · No injuriesClosedPiper J-3 · Randolph, WINov 25, 1967 · N1276V · Substantial damage NTSB CHI68A0049Accident · 3 fatalClosedMooney M20C · Cable, WINov 23, 1967 · N1383W · Destroyed NTSB CHI68A0041Accident · 1 fatalClosedBeech C-45H · Aurora, WIOct 29, 1967 · N956C · Destroyed NTSB CHI68A0040Accident · 1 fatalClosedMooney M20C · Athelstane, WIOct 25, 1967 · N2960L · Destroyed NTSB CHI68F0414Accident · No injuriesClosedLuscombe 8A · Arlington, WIOct 21, 1967 · N1343B · Substantial damage NTSB CHI68D0411Accident · No injuriesClosedCessna 140 · Norwalk, WIOct 21, 1967 · N89033 · Substantial damage NTSB CHI68D0385Accident · No injuriesClosedPiper PA-18 · Beaver Dam, WIOct 21, 1967 · N326T · Substantial damage NTSB CHI68D0415Accident · Serious injuriesClosedBeech J35 · Rhinelander, WIOct 20, 1967 · N8343D · Destroyed NTSB CHI68A0035Accident · 2 fatalClosedChampion 7ECA · Bloomer, WIOct 14, 1967 · N2820G · Destroyed NTSB CHI68F0351Accident · No injuriesClosedBeech D50A · Milwaukee, WIOct 11, 1967 · N510H · Substantial damage NTSB CHI68D0412Accident · No injuriesClosedCessna 150 · Pewaukee, WISep 22, 1967 · N6221T · Substantial damage NTSB CHI68D0416Accident · No injuriesClosedMooney M20E · Waupun, WISep 16, 1967 · N5807Q · Substantial damage NTSB CHI68D0417Accident · Minor injuriesClosedCessna 172 · Tomah, WISep 15, 1967 · N2400U · Substantial damage NTSB CHI68F0506Accident · No injuriesClosedBeech T-34A · Milwaukee, WISep 8, 1967 · N2969C · Substantial damage NTSB CHI68D0413Accident · No injuriesClosedCessna 337 · Crivitz, WISep 5, 1967 · N6228F · Substantial damage NTSB CHI68D0305Accident · No injuriesClosedMooney 20C · Park Falls, WISep 5, 1967 · N9685M · Substantial damage NTSB CHI68F0222Accident · Minor injuriesClosedCessna 172 · Shawano, WISep 1, 1967 · N7730 · Substantial damage NTSB CHI68D0402Accident · Minor injuriesClosedPiper PA-22 · Wonewoc, WISep 1, 1967 · N6029D · Substantial damage NTSB CHI68F0403Accident · Serious injuriesClosedTaylorcraft BL-65 · Portage, WIAug 27, 1967 · N24402 · Destroyed NTSB CHI68A0021Accident · 3 fatalClosedPiper PA-24 · Viroqua, WIAug 26, 1967 · N6834P · Destroyed NTSB CHI68D0408Accident · No injuriesClosedCessna 170B · Berlin, WIAug 13, 1967 · N43048 · Substantial damage NTSB CHI68D0192Accident · No injuriesClosedPiper J-3 · Hager City, WIAug 13, 1967 · N92477 · Destroyed NTSB CHI68D0276Accident · No injuriesClosedLockheed 12A · Montello, WIAug 10, 1967 · N4001 · Substantial damage NTSB CHI68D0401Accident · No injuriesClosedStinson 108 · Wild Rose, WIAug 5, 1967 · N9142K · Substantial damage NTSB CHI68D0275Accident · No injuriesClosedPiper PA-24 · Oshkosh, WIAug 5, 1967 · N6704P · Substantial damage NTSB CHI68F0377Accident · Serious injuriesClosedVolmer VJ-22 · Eagle River, WIAug 3, 1967 · N7511U · Destroyed NTSB CHI68A0013Accident · Minor injuriesClosedBensen B8M · Footville, WIJul 29, 1967 · N9127 · Destroyed NTSB CHI68A0012Accident · 2 fatalClosedTaylorcraft BC12-D · Holcombe, WIJul 26, 1967 · N96507 · Destroyed NTSB CHI68D0324Accident · Minor injuriesClosedCurtis Scout · Waukesha, WIJul 25, 1967 · N2021 · Substantial damage NTSB CHI68D0383Accident · No injuriesClosedCessna 172 · Milwaukee, WIJul 24, 1967 · N6078R · Substantial damage NTSB CHI68D0375Accident · No injuriesClosedCessna 172 · Ft.Atkinson, WIJul 24, 1967 · N7248T · Substantial damage NTSB CHI68A0011Accident · 2 fatalClosedChampion 7EC · Pewaukee, WIJul 19, 1967 · N8577E · Destroyed NTSB CHI68A0009Accident · Serious injuriesClosedBrantly B2A · Milwaukee, WIJul 19, 1967 · N6794D · Destroyed NTSB CHI68D0384Accident · No injuriesClosedBeech C35 · Delavan, WIJul 16, 1967 · N642D · Substantial damage NTSB CHI68F0125Accident · Minor injuriesClosedPiper PA-28 · Three Lakes, WIJul 15, 1967 · N8956W · Substantial damage NTSB CHI68D0306Accident · No injuriesClosedBeech A23 · Eau Claire, WIJul 11, 1967 · N3569R · Substantial damage NTSB CHI68A0005Accident · 1 fatalClosedPiper PA-24 · Tomah, WIJul 9, 1967 · N7650P · Destroyed NTSB CHI68D0154Accident · No injuriesClosedPiper PA-23 · Fond Du Lac, WIJul 6, 1967 · N2225P · Substantial damage NTSB CHI68F0029Accident · Minor injuriesClosedStinson 108-2 · Washington Is, WIJul 4, 1967 · N8102K · Substantial damage NTSB CHI68F0144Accident · No injuriesClosedHoward DGA-15 · Camp Lake, WIJul 2, 1967 · N74696 · Substantial damage NTSB CHI68D0087Accident · Minor injuriesClosedPiper PA-28 · Montello, WIJul 1, 1967 · N6323R · Substantial damage NTSB CHI67A0140Accident · Minor injuriesClosedHughes 269A · Onieda, WIJun 27, 1967 · N8746F · Substantial damage