Skip to content

NTSB investigations, 1968, WI

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 CHI69F0501Accident · Serious injuriesClosedTaylorcraft DCO-65 · Hortonville, WIDec 29, 1968 · N53514 · Destroyed NTSB MKC69F0303Accident · No injuriesClosedPiper PA-32 · Baldwin, WIDec 23, 1968 · N4150R · Substantial damage NTSB CHI69D0392Accident · No injuriesClosedCessna 310F · Appleton, WIDec 6, 1968 · N5814X · Substantial damage NTSB CHI69D0531Accident · No injuriesClosedCessna 172 · Ridgeland, WINov 29, 1968 · N3910S · Substantial damage NTSB CHI69D0417Accident · No injuriesClosedCessna 195A · Madison, WINov 26, 1968 · N2187C · Substantial damage NTSB CHI69F0409Accident · Minor injuriesClosedPiper PA-28 · Sturtevant, WINov 24, 1968 · N4217T · Substantial damage NTSB CHI69A0053Accident · 3 fatalClosedMooney M20C · Rhinelander, WINov 17, 1968 · N1352W · Destroyed NTSB CHI69D0411Accident · No injuriesClosedPiper PA-28 · Appleton, WINov 16, 1968 · N9675J · Substantial damage NTSB CHI69D0371Accident · No injuriesClosedCessna 182 · West Salem, WINov 9, 1968 · N2843R · Substantial damage NTSB CHI69A0048Accident · No injuriesClosedBeech C-45G · Wausaukee, WINov 9, 1968 · N2847G · Substantial damage NTSB CHI69D0331Accident · No injuriesClosedCessna 150 · Waukesha, WIOct 31, 1968 · N6422F · Substantial damage NTSB CHI69F0317Accident · Minor injuriesClosedCessna 172D · Shawano, WIOct 13, 1968 · N2522Y · Destroyed NTSB CHI69A0040Accident · 4 fatalClosedCessna 172 · Platteville, WIOct 13, 1968 · N8624B · Destroyed NTSB CHI69D0318Accident · No injuriesClosedCessna 120 · Richland Ctr, WIOct 12, 1968 · N2874N · Substantial damage NTSB CHI69D0310Accident · No injuriesClosedCessna 150 · Clintonville, WIOct 1, 1968 · N7235S · Substantial damage NTSB CHI69D0301Accident · Minor injuriesClosedCessna 182C · Waunakee, WISep 22, 1968 · N8585T · Substantial damage NTSB CHI69D0308Accident · No injuriesClosedPiper PA-28 · Albion, WISep 21, 1968 · N6114W · Substantial damage NTSB CHI69D0238Accident · No injuriesClosedChampion 7ECA · Grantsburg, WISep 14, 1968 · N11031 · Substantial damage NTSB CHI69F0233Accident · Minor injuriesClosedStinson 108-2 · Baraboo, WISep 7, 1968 · N333C · Substantial damage NTSB CHI69F0253Accident · 1 fatalClosedAeronca 0-58A · Richland Ctr, WISep 1, 1968 · N47262 · Destroyed NTSB CHI69D0300Accident · No injuriesClosedCessna 150 · Black Rvr Fls, WIAug 30, 1968 · N3679J · Substantial damage NTSB CHI69D0270Accident · No injuriesClosedPiper PA-22 · Hales Corners, WIAug 18, 1968 · N2175A · Substantial damage NTSB CHI69D0208Accident · No injuriesClosedPiper PA-28 · Washington Is, WIAug 13, 1968 · N9809W · Substantial damage NTSB CHI69F0269Accident · No injuriesClosedPiper PA-28 · Juneau, WIAug 11, 1968 · N5858W · Substantial damage NTSB CHI69F0150Accident · No injuriesClosedErco 415-CD · Rio, WIAug 11, 1968 · N3920H · Destroyed NTSB CHI69D0294Accident · Minor injuriesClosedPiper PA-22 · Platteville, WIAug 9, 1968 · N4990Z · Substantial damage NTSB CHI69D0190Accident · No injuriesClosedPiper PA-18A · Hancock, WIAug 7, 1968 · N3708A · Substantial damage NTSB CHI69D0179Accident · No injuriesClosedPiper PA-22 · Sister Bay, WIAug 7, 1968 · N3917P · Substantial damage NTSB SEA69A0010Accident · Serious injuriesClosedDouglas DC-8 · New Richmond, WIAug 6, 1968 · N8010U · Substantial damage NTSB DCA69A0001Accident · 3 fatalClosedConvair 580 · Milwaukee, WIAug 4, 1968 · N4634S · 2 aircraft · Substantial damage NTSB CHI69D0167Accident · Minor injuriesClosedCessna 150 · Franklin, WIJul 31, 1968 · N3906J · Destroyed NTSB CHI69D0172Accident · No injuriesClosedCessna 210 · Lake Geneva, WIJul 30, 1968 · N2341F · Substantial damage NTSB CHI69D0218Accident · No injuriesClosedEnstrom F-28A · Port Washngtn, WIJul 27, 1968 · N4462 · Destroyed NTSB CHI69D0393Accident · No injuriesClosedCessna 172 · Bellville, WIJul 23, 1968 · N8740U · Substantial damage NTSB CHI69D0171Accident · No injuriesClosedMooney M20 · Lyndon Sta, WIJul 21, 1968 · N5293B · Substantial damage NTSB CHI69D0291Accident · No injuriesClosedCessna 150 · Woodruff, WIJul 19, 1968 · N6127T · Substantial damage NTSB CHI69D0191Accident · No injuriesClosedAero Comdr 100 · Mattoon, WIJul 17, 1968 · N3884X · Substantial damage NTSB CHI69D0189Accident · Minor injuriesClosedPiper PA-28 · Wonewoc, WIJul 14, 1968 · N6343R · Substantial damage NTSB CHI69D0113Accident · No injuriesClosedLuscombe 8A · Green Bay, WIJul 12, 1968 · N21996 · Substantial damage NTSB CHI69D0109Accident · No injuriesClosedPiper PA-28 · Sparta, WIJul 12, 1968 · N6613W · Substantial damage NTSB CHI69D0129Accident · No injuriesClosedPiper PA-22 · Neenah, WIJul 7, 1968 · N2244A · Substantial damage NTSB CHI69F0051Accident · No injuriesClosedMooney M20D · Boscobel, WIJul 6, 1968 · N6913U · Substantial damage NTSB CHI69D0125Accident · Minor injuriesClosedBell 47G-2 · Wis.Dells, WIJul 6, 1968 · N2866B · Substantial damage NTSB CHI69A0005Accident · 2 fatalClosedLuscombe 8E · Union Grove, WIJul 6, 1968 · N1181B · Destroyed NTSB CHI69I0003Incident · No injuriesClosedDouglas DC-3A · Oshkosh, WIJul 4, 1968 · N4007C · Minor damage NTSB CHI69D0126Accident · No injuriesClosedCessna 150F · Neenah, WIJun 29, 1968 · N6970F · Substantial damage NTSB CHI68A0107Accident · 1 fatalClosedBell 47J-2 · Rice Lake, WIJun 14, 1968 · N73258 · Destroyed NTSB CHI69D0025Accident · No injuriesClosedPiper PA-24 · Merrill, WIJun 11, 1968 · N7061P · Substantial damage NTSB CHI68A0103Accident · 3 fatalClosedCessna 172 · Mount Horeb, WIJun 8, 1968 · N3837S · Destroyed NTSB CHI69D0108Accident · No injuriesClosedPiper PA-22 · Sherry, WIJun 4, 1968 · N2843Z · Substantial damage