Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 CHI73DEP34Accident · No injuriesClosedCessna 310 · Lake Geneva, WIDec 15, 1972 · N6886T · Substantial damage NTSB CHI73FEP33Accident · No injuriesClosedCessna 172C · New Holstein, WIDec 14, 1972 · N1535Y · Substantial damage NTSB CHI73FEP32Accident · No injuriesClosedBeech B23 · Prentice, WINov 15, 1972 · N9139T · Substantial damage NTSB CHI73FEP31Accident · Minor injuriesClosedCessna 172L · Antigo, WINov 8, 1972 · N7662G · Substantial damage NTSB CHI73FEP30Accident · Minor injuriesClosedCessna 120 · Hartford, WINov 5, 1972 · N2425N · Substantial damage NTSB CHI73FEP28Accident · Minor injuriesClosedCessna 172D · Franklin, WINov 4, 1972 · N2841U · Substantial damage NTSB CHI73AC045Accident · 2 fatalClosedPiper PA-22 · Wisconsn Rpds, WINov 1, 1972 · N5728Z · Destroyed NTSB CHI73DEP26Accident · No injuriesClosedCessna 172 · Michicot, WIOct 8, 1972 · N6259E · Substantial damage NTSB CHI73FEP73Accident · No injuriesClosedPiper PA-24 · Burlington, WIOct 4, 1972 · N6459P · Substantial damage NTSB CHI73DEP25Accident · No injuriesClosedLuscombe 8A · Waunakee, WISep 22, 1972 · N71318 · Substantial damage NTSB CHI73FEP20Accident · No injuriesClosedNaval Fcty N3N-3 · Cross Plains, WISep 19, 1972 · N6358T · Substantial damage NTSB CHI73DEP22Accident · No injuriesClosedCessna 150 · Elkhorn, WISep 17, 1972 · N8778G · Substantial damage NTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WISep 14, 1972 · N2348L · Destroyed NTSB CHI73FEP10Accident · Serious injuriesClosedPiper PA-25 · Suring, WISep 12, 1972 · N4598Y · Substantial damage NTSB CHI73DEP27Accident · No injuriesClosedGrumman G-164 · Antigo, WISep 11, 1972 · N73W · Substantial damage NTSB CHI73FER04Accident · No injuriesClosedPitts SPL S1C · Osceola, WISep 4, 1972 · N51AC · Substantial damage NTSB CHI73DEP21Accident · No injuriesClosedCessna 172 · Lake Geneva, WISep 4, 1972 · N172KA · Substantial damage NTSB CHI73FEP29Accident · No injuriesClosedCessna 177 · Sullivan, WISep 3, 1972 · N3281T · Destroyed NTSB CHI73DEP19Accident · No injuriesClosedPiper PA-28 · Endeavor, WISep 3, 1972 · N6218W · Substantial damage NTSB CHI73FEP17Accident · No injuriesClosedCessna 150K · Janesville, WIAug 25, 1972 · N6466G · 2 aircraft · Substantial damage NTSB CHI73FER03Accident · Minor injuriesClosedAlon A-2 · Elk Mound, WIAug 17, 1972 · N6525Q · Substantial damage NTSB CHI73DEP24Accident · No injuriesClosedCessna 150 · Palmyra, WIAug 14, 1972 · N1710Q · Substantial damage NTSB CHI73DEP18Accident · No injuriesClosedCessna 140 · New Glarus, WIAug 14, 1972 · N9461A · Substantial damage NTSB CHI73DEP13Accident · No injuriesClosedCessna 310Q · Necedah, WIAug 14, 1972 · N7588Q · Substantial damage NTSB CHI73FEP12Accident · No injuriesClosedCessna 175 · Kansasville, WIAug 13, 1972 · N9320B · Substantial damage NTSB CHI73FEP14Accident · Serious injuriesClosedChampion 7GCBC · Baraboo, WIAug 8, 1972 · N577RF · Destroyed NTSB CHI73FEP08Accident · Minor injuriesClosedMooney M20E · Waukesha, WIAug 4, 1972 · N6967U · Substantial damage NTSB CHI73FEP07Accident · No injuriesClosedBeech D17R · Milwaukee, WIAug 4, 1972 · N35E · Substantial damage NTSB CHI73FER02Accident · Serious injuriesClosedTaylorcraft BL-65 · Rice Lake, WIAug 1, 1972 · N29570 · Substantial damage NTSB CHI73FEP16Accident · No injuriesClosedTravel Air 4000 · Redgranite, WIAug 1, 1972 · N241 · Substantial damage NTSB CHI73FEP05Accident · Serious injuriesClosedGanagobie 3 · Oshkosh, WIAug 1, 1972 · N1949 · Substantial damage NTSB CHI73DER01Accident · No injuriesClosedCessna 150G · New Richmond, WIJul 31, 1972 · N3998J · Substantial damage NTSB CHI73DEP15Accident · No injuriesClosedPiper PA-28 · Rio, WIJul 28, 1972 · N5450W · Substantial damage NTSB CHI73FEP09Accident · 1 fatalClosedCessna 150F · Lakewood, WIJul 22, 1972 · N7109F · Substantial damage NTSB CHI73FEP06Incident · No injuriesClosedSiai-Marche 20522R · Juneau, WIJul 22, 1972 · N732W · Minor damage NTSB CHI73FEP11Accident · No injuriesClosedCessna 172G · North Freedom, WIJul 21, 1972 · N5885R · Substantial damage NTSB CHI73FEP04Accident · No injuriesClosedCessna 150G · Genoa City, WIJul 21, 1972 · N3794J · Substantial damage NTSB CHI73FEP03Accident · Serious injuriesClosedPiper PA-22 · Arkdale, WIJul 16, 1972 · N5622Z · Destroyed NTSB CHI73FEP02Accident · No injuriesClosedCessna 172F · Lake Geneva, WIJul 14, 1972 · N8236U · Substantial damage NTSB CHI73FEP01Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIJul 4, 1972 · N4472T · Substantial damage NTSB CHI73AC002Accident · 3 fatalClosedCessna 172K · Hales Corners, WIJul 4, 1972 · N79022 · Destroyed NTSB DCA72AZ012Accident · 13 fatalClosedDehavilland DHC-6 · Appleton, WIJun 29, 1972 · N4043B · 2 aircraft · Destroyed NTSB CHI72FEP51Accident · Minor injuriesClosedPiper J3C-65 · Fond Du Lac, WIJun 27, 1972 · N40609 · Substantial damage NTSB CHI72FEP50Accident · Serious injuriesClosedBensen B8M · Waterford, WIJun 27, 1972 · N7195 · Substantial damage NTSB CHI72DEP52Accident · No injuriesClosedCessna 172 · Sturtevant, WIJun 19, 1972 · N7514X · Substantial damage NTSB CHI72FER04Accident · Minor injuriesClosedPiper J3C · Menomonie, WIJun 13, 1972 · N3607K · Substantial damage NTSB CHI72FEP48Accident · No injuriesClosedCessna 180 · Menomonee Fls, WIJun 10, 1972 · N3129D · Substantial damage NTSB CHI72FEP49Accident · Minor injuriesClosedScooter RH-1 · Neenah, WIJun 7, 1972 · N3505 · Substantial damage NTSB CHI72FEP46Accident · No injuriesClosedLake LA-4 · Waukesha, WIJun 6, 1972 · N5034L · Substantial damage NTSB CHI72DEP47Accident · No injuriesClosedChampion 7ECA · Dousman, WIJun 6, 1972 · N11852 · Substantial damage