Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 CHI72DEP28Accident · No injuriesClosedPiper PA-28 · Waukesha, WIDec 31, 1971 · N2371T · Substantial damage NTSB CHI72FEP24Accident · No injuriesClosedMitsubishi MU2B20 · East Troy, WIDec 11, 1971 · N304L · Substantial damage NTSB CHI72FEP23Accident · Minor injuriesClosedPiper PA-32 · Waukesha, WIDec 5, 1971 · N3449W · Destroyed NTSB CHI72AC048Accident · 1 fatalClosedCessna 172H · Granton, WIDec 5, 1971 · N3288L · Destroyed NTSB CHI72DEP26Accident · No injuriesClosedLuscombe 8A · Wilmot, WINov 24, 1971 · N45676 · Substantial damage NTSB CHI72AC045Accident · No injuriesClosedBoeing 727 · Milwaukee, WINov 17, 1971 · N7077U · Substantial damage NTSB CHI72FEP21Accident · Serious injuriesClosedLuscombe 8A · Stevens Pt., WINov 10, 1971 · N45431 · Substantial damage NTSB CHI72DEP22Accident · No injuriesClosedCessna 150 · Kenosha, WINov 2, 1971 · N8229F · Substantial damage NTSB CHI72DEP20Accident · No injuriesClosedMooney M20C · Dodgeville, WIOct 28, 1971 · N5953Q · Substantial damage NTSB CHI72FEP18Accident · No injuriesClosedGlobe GC-1B · Sheboygan, WIOct 5, 1971 · N80606 · Substantial damage NTSB CHI72DEP19Accident · No injuriesClosedDoers B8M · Tichigan, WIOct 2, 1971 · N7195 · Substantial damage NTSB CHI72AC031Accident · 2 fatalClosedCessna 150F · Tomahawk, WIOct 1, 1971 · N7801F · Destroyed NTSB CHI72FEP16Incident · No injuriesClosedPiper PA-28 · Dodgeville, WISep 29, 1971 · N7251W · Minor damage NTSB CHI72DEP17Accident · No injuriesClosedMooney M20 · Hayward, WISep 28, 1971 · N5247B · Substantial damage NTSB CHI72AC027Accident · 6 fatalClosedBeech 95-B55 · Milwaukee, WISep 25, 1971 · N8627Q · Destroyed NTSB CHI72FEP13Accident · No injuriesClosedCessna 175 · Dodgeville, WISep 11, 1971 · N6655E · Substantial damage NTSB CHI72DER02Accident · No injuriesClosedCassutt 3M · Durand, WISep 11, 1971 · N8156 · Substantial damage NTSB CHI72DEP15Accident · No injuriesClosedLuscombe 8A · Lyons, WISep 11, 1971 · N1323B · Substantial damage NTSB CHI72DEP11Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WIAug 27, 1971 · N1765T · Substantial damage NTSB CHI72FEP14Accident · Minor injuriesClosedPiper PA-28 · Wauwatosa Br, WIAug 22, 1971 · N7269J · Substantial damage NTSB CHI72DEP12Accident · Minor injuriesClosedCessna 150 · Gays Mills, WIAug 15, 1971 · N6872F · Substantial damage NTSB CHI72FEP09Accident · No injuriesClosedMooney M20C · La Crosse, WIAug 14, 1971 · N6837N · Substantial damage NTSB CHI72FEP08Accident · No injuriesClosedCessna 177 · Delavan, WIAug 8, 1971 · N3269T · Substantial damage NTSB CHI72FEP07Accident · Serious injuriesClosedGrumman G-32A · Pickett, WIAug 7, 1971 · N7F · Substantial damage NTSB CHI72FEP06Accident · Minor injuriesClosedDavis V-3 · Wauwatosa, WIAug 5, 1971 · NC630 · Substantial damage NTSB CHI72AC012Accident · No injuriesClosedBeech 99 · Ashland, WIAug 5, 1971 · N7099N · Substantial damage NTSB CHI72DEP10Accident · Minor injuriesClosedPiper J-3 · East Troy, WIAug 1, 1971 · N3676K · Substantial damage NTSB CHI72FER01Accident · Minor injuriesClosedPiper PA-28 · Trego, WIJul 31, 1971 · N5657U · Substantial damage NTSB CHI72FEP04Accident · No injuriesClosedBeech A23-24 · Waupaca, WIJul 25, 1971 · N4773J · Substantial damage NTSB CHI72FEP05Accident · Minor injuriesClosedCessna 182J · Wausau, WIJul 23, 1971 · N3337F · Substantial damage NTSB CHI72DEP03Accident · No injuriesClosedPiper PA-22 · Washingtn Isl, WIJul 22, 1971 · N7821D · Destroyed NTSB CHI72DEP02Accident · No injuriesClosedBoeing B75N1 · Blck Rvr Flls, WIJul 11, 1971 · N69808 · Substantial damage NTSB CHI72FEP01Accident · Serious injuriesClosedAeronca 7AC · Antigo, WIJul 9, 1971 · N84263 · Substantial damage NTSB CHI72AC001Accident · 2 fatalClosedTed Smith 601 · Woodruff, WIJul 2, 1971 · N566Y · Destroyed NTSB CHI71FEP54Accident · No injuriesClosedPietenpol GN-1 · Menomonee Fls, WIJun 19, 1971 · N4705G · Substantial damage NTSB CHI71FEP53Accident · 1 fatalClosedPiper PA-18 · Ripon, WIJun 13, 1971 · N2366P · Destroyed NTSB CHI71FEP55Accident · No injuriesClosedRearwin 8135 · Reedsburg, WIJun 6, 1971 · N25451 · Substantial damage NTSB CHI71FER09Accident · Minor injuriesClosedErco 415-C · Superior, WIMay 29, 1971 · N93989 · Destroyed NTSB CHI71DER08Accident · No injuriesClosedCessna 150 · Cochrane, WIMay 29, 1971 · N50543 · Substantial damage NTSB CHI71DEP52Accident · No injuriesClosedPiper PA-25 · Random Lake, WIMay 28, 1971 · N4421Y · Substantial damage NTSB CHI71FEP51Accident · No injuriesClosedPiper PA-28 · Janesville, WIMay 16, 1971 · N5510W · Substantial damage NTSB CHI71DER07Accident · No injuriesClosedPiper J3C · Star Prairie, WIMay 13, 1971 · N92094 · Substantial damage NTSB CHI71DEP50Accident · Minor injuriesClosedCessna 337 · Land O Lakes, WIMay 7, 1971 · N2201X · Substantial damage NTSB CHI71FDM06Accident · No injuriesClosedPiper PA-28 · Cochrane, WIApr 22, 1971 · N5979W · Substantial damage NTSB CHI71DDJ48Accident · No injuriesClosedCessna 337A · Delavan, WIApr 9, 1971 · N5327S · Substantial damage NTSB CHI71AC073Accident · 2 fatalClosedAmer Avco AA-1 · Mazomanie, WIApr 6, 1971 · N5963L · Destroyed NTSB CHI71DDJ47Accident · No injuriesClosedStinson 108-1 · Milwaukee, WIApr 4, 1971 · N9155K · Substantial damage NTSB CHI71DEP49Accident · No injuriesClosedCessna 150 · Appleton, WIMar 30, 1971 · N60049 · Substantial damage NTSB CHI71FDJ46Accident · Minor injuriesClosedCessna 150F · Racine, WIMar 23, 1971 · N8927S · Substantial damage NTSB CHI71AC066Accident · No injuriesClosedCessna 207 · Richland Cen, WIMar 23, 1971 · N91005 · Substantial damage