Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 CHI71AC044Accident · 3 fatalClosedCessna 402 · Waukesha, WIDec 19, 1970 · N4045Q · 2 aircraft · Destroyed NTSB CHI71IC051Incident · No injuriesClosedBoeing 707 · Janesville, WIDec 18, 1970 · N386US · No damage NTSB CHI71DDJ33Accident · No injuriesClosedAero Comdr 560A · Milwaukee, WIDec 18, 1970 · N2759B · Substantial damage NTSB CHI71DDJ34Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WIDec 15, 1970 · N7347J · Substantial damage NTSB CHI71FDJ32Accident · Serious injuriesClosedCessna 150 · Strum, WIDec 12, 1970 · N6770G · Destroyed NTSB CHI71FDJ30Accident · Serious injuriesClosedCessna 172 · Milwaukee, WIDec 5, 1970 · N8071L · Substantial damage NTSB CHI71DDJ79Accident · No injuriesClosedCessna 172 · Milwaukee, WIDec 5, 1970 · N46024 · Substantial damage NTSB CHI71DDJ31Accident · No injuriesClosedCessna 172 · Juneau, WIDec 5, 1970 · N5686T · Substantial damage NTSB CHI71DDJ28Accident · No injuriesClosedCessna 172 · Reedsburg, WIDec 5, 1970 · N8164U · Substantial damage NTSB CHI7IIC037Incident · No injuriesClosedBeech B99 · Marshfield, WIDec 3, 1970 · N8899M · Minor damage NTSB CHI71AC034Accident · 4 fatalClosedPiper PA-24 · Weston, WINov 18, 1970 · N7880P · Destroyed NTSB CHI71AC031Accident · Serious injuriesClosedDehavilland DHC-6 · Lacrosse, WINov 9, 1970 · N956SM · Destroyed NTSB CHI71FDJ24Accident · Minor injuriesClosedCessna 195 · Franklin, WINov 8, 1970 · N3878V · Substantial damage NTSB CHI71DDJ27Accident · No injuriesClosedBensen B8M · Waterford, WINov 7, 1970 · N2434 · Substantial damage NTSB CHI71DDJ21Accident · Minor injuriesClosedCessna 180A · Tony, WINov 6, 1970 · N5395D · Substantial damage NTSB CHI71FDM04Accident · No injuriesClosedPiper PA-28 · Chetek, WINov 1, 1970 · N4363J · Substantial damage NTSB CHI71AC026Accident · 3 fatalClosedCessna 310D · Watertown, WIOct 20, 1970 · N6765T · Destroyed NTSB CHI71FDJ23Accident · 2 fatalClosedConvair PBY-5A · Rhinelander, WIOct 15, 1970 · N610FF · Destroyed NTSB CHI71FDJ22Accident · No injuriesClosedCessna 182 · Middleton, WIOct 15, 1970 · N3018Y · 2 aircraft · Substantial damage NTSB CHI71DDJ25Accident · No injuriesClosedPiper PA-22 · Niagara, WIOct 6, 1970 · N5815Z · Substantial damage NTSB CHI71DDJ20Accident · No injuriesClosedCessna 172E · Madison, WIOct 6, 1970 · N5785T · Substantial damage NTSB CHI71FDJ19Accident · Serious injuriesClosedCessna 150J · Eau Claire, WIOct 5, 1970 · N61357 · Destroyed NTSB CHI71IC024Incident · No injuriesClosedBoeing 727 · Milwaukee, WIOct 1, 1970 · N7424U · No damage NTSB CHI71DDJ18Accident · No injuriesClosedCessna 210 · Eleva, WISep 25, 1970 · N7484E · Substantial damage NTSB CHI71DDJ26Accident · No injuriesClosedStinson V-77 · Neenah, WISep 22, 1970 · N69856 · Substantial damage NTSB CHI72DDJ17Accident · Minor injuriesClosedStinson 108-3 · Bruce, WISep 20, 1970 · N960C · Substantial damage NTSB CHI71AC020Accident · No injuriesClosedBeech E18S · Lyndon Sta, WISep 15, 1970 · N387W · Substantial damage NTSB CHI71DDJ16Accident · No injuriesClosedCessna 177 · Black Rvr Fls, WISep 12, 1970 · N2870X · Substantial damage NTSB CHI71FDJ15Accident · No injuriesClosedCessna 150 · East Troy, WISep 9, 1970 · N7900E · Substantial damage NTSB CHI71DDJ12Accident · Serious injuriesClosedBeech C-45H · Lakewood, WISep 7, 1970 · N9961Z · Destroyed NTSB CHI71AC018Accident · 4 fatalClosedBeech J35 · Plain, WISep 6, 1970 · N622T · Destroyed NTSB CHI71DDJ14Accident · No injuriesClosedPiper PA-28 · Delavan, WISep 5, 1970 · N7864N · Substantial damage NTSB CHI71FDM03Accident · No injuriesClosedBeech A35 · L.Nebagamon, WIAug 25, 1970 · N8509A · Substantial damage NTSB CHI71DDJ11Accident · No injuriesClosedBell 47D1 · Manitowish, WIAug 21, 1970 · N4252A · Substantial damage NTSB CHI71FDJ13Accident · No injuriesClosedLuscombe 8E · Cottage Grove, WIAug 19, 1970 · N39028 · Substantial damage NTSB CHI71FDJ10Accident · No injuriesClosedCessna 172C · Madison, WIAug 12, 1970 · N1582Y · Substantial damage NTSB CHI71AC012Accident · Serious injuriesClosedCessna 402 · Watertown, WIAug 8, 1970 · N8139F · Destroyed NTSB CHI71FDJ09Accident · No injuriesClosedHughes 269B · Green Bay, WIAug 5, 1970 · N9308F · Destroyed NTSB CHI71FDJ06Accident · Minor injuriesClosedGlobe GC-1B · Franklin, WIAug 2, 1970 · N11HR · Substantial damage NTSB CHI71AC010Accident · No injuriesClosedBeech 95-A55 · Green Bay, WIJul 28, 1970 · N9618Y · Substantial damage NTSB CHI71FDJ08Accident · Serious injuriesClosedTaylorcraft BC12-D · Land O Lakes, WIJul 25, 1970 · N43009 · Substantial damage NTSB CHI71FDJ07Accident · Serious injuriesClosedBeech E18S · Delavan, WIJul 25, 1970 · N3333C · Destroyed NTSB CHI71DDM01Accident · No injuriesClosedCessna 150C · River Falls, WIJul 23, 1970 · N1907Z · Substantial damage NTSB CHI71FDJ05Accident · Minor injuriesClosedPiper PA-28 · Green Bay, WIJul 21, 1970 · N6667J · Substantial damage NTSB CHI71FDM02Accident · No injuriesClosedCessna 172G · Mondovi, WIJul 20, 1970 · N3616L · Substantial damage NTSB CHI71AC003Accident · 4 fatalClosedCessna 177 · Wild Rose, WIJul 12, 1970 · N2277Y · Destroyed NTSB CHI71FDJ03Accident · Minor injuriesClosedBeech C-18 · Waukesha, WIJul 10, 1970 · N2391C · Substantial damage NTSB CHI71DDJ04Accident · No injuriesClosedCessna 150 · Platteville, WIJul 10, 1970 · N3679J · Substantial damage NTSB CHI71DDJ02Accident · Minor injuriesClosedCessna 180F · Friendship, WIJul 3, 1970 · N2157Z · Substantial damage NTSB CHI71FDJ01Accident · Serious injuriesClosedMooney M20C · Union Grove, WIJul 2, 1970 · N9384V · Destroyed