Skip to content

NTSB investigations, 1974, WI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1974, WI per year, 1964–2026: 3,021 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	19

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") = 1974 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\") = 1974
    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") = 1974
  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 CHI75FEP36Accident · No injuriesClosedCessna 170B · Waukesha, WIDec 28, 1974 · N3120B · Substantial damage NTSB CHI75DEP38Accident · No injuriesClosedCessna 150H · Wilmot, WIDec 24, 1974 · N50169 · Substantial damage NTSB CHI75DEP39Accident · No injuriesClosedBeech 95-B55 · Milwaukee, WIDec 19, 1974 · N7981K · Substantial damage NTSB CHI75DEP34Accident · No injuriesClosedBeech A23-19 · Delavan, WINov 28, 1974 · N6971Q · Substantial damage NTSB CHI75DEP35Accident · No injuriesClosedCessna 172F · Crandon, WINov 27, 1974 · N5583R · Substantial damage NTSB CHI75AC040Accident · No injuriesClosedPiper J3C-65 · Pickett, WINov 9, 1974 · N26046 · No damage NTSB CHI75DEP32Accident · No injuriesClosedCessna 175 · Brooklyn, WINov 3, 1974 · N1100S · Substantial damage NTSB CHI75FEP33Accident · 2 fatalClosedCessna 150L · Slinger, WIOct 30, 1974 · N10430 · Destroyed NTSB CHI75FEP31Accident · Serious injuriesClosedCessna 182P · Racine, WIOct 28, 1974 · N21534 · Substantial damage NTSB CHI75AC036Accident · 1 fatalClosedBellanca 17-30A · Lakewood, WIOct 24, 1974 · N14746 · Destroyed NTSB CHI75FEP28Accident · Serious injuriesClosedPiper PA-23 · Wautoma, WIOct 20, 1974 · N1450P · Substantial damage NTSB CHI75DEP30Accident · No injuriesClosedCessna 172L · Crivitz, WIOct 13, 1974 · N19644 · Substantial damage NTSB CHI75DEP27Accident · No injuriesClosedMaule M4220C · Eagle River, WIOct 8, 1974 · N51436 · Substantial damage NTSB CHI75FEP25Accident · No injuriesClosedStinson V-77 · Belleville, WISep 28, 1974 · N69856 · Substantial damage NTSB CHI75FEP29Accident · Serious injuriesClosedPiper PA-30 · Chippewa Fls, WISep 21, 1974 · N8753Y · Destroyed NTSB CHI75DEP26Accident · Minor injuriesClosedStinson 108-3 · Kenosha, WISep 21, 1974 · N899C · Substantial damage NTSB CHI75FEP23Accident · Serious injuriesClosedCessna 150E · Milwaukee, WISep 14, 1974 · N4069U · Substantial damage NTSB CHI75FEP22Accident · 1 fatalClosedCessna 182H · West Bend, WISep 13, 1974 · N8533S · Substantial damage NTSB CHI75DEP24Accident · No injuriesClosedBoeing A75 · Lone Rock, WISep 8, 1974 · N55898 · Substantial damage NTSB CHI75FEP19Accident · 1 fatalClosedBoeing A75N1 · Plover, WISep 1, 1974 · N60334 · Destroyed NTSB CHI75FEP20Accident · Serious injuriesClosedStinson SR-8C · Shawand, WIAug 29, 1974 · N956AL · Substantial damage NTSB CHI75DER03Accident · No injuriesClosedPiper PA-12 · Amery, WIAug 25, 1974 · N221U · Substantial damage NTSB CHI75DEP18Accident · Minor injuriesClosedCessna 182P · Delavan, WIAug 21, 1974 · N52715 · Destroyed NTSB CHI75AC019Accident · 1 fatalClosedAeronca 7AC · Bloomer, WIAug 19, 1974 · N82532 · Destroyed NTSB CHI75FEP21Accident · Serious injuriesClosedFairchild M-62A · Oostburg, WIAug 18, 1974 · N192P · Destroyed NTSB CHI75AC017Accident · 1 fatalClosedAmer Avco AA-1A · New Richmond, WIAug 18, 1974 · N9262L · Destroyed NTSB CHI75DEP16Accident · No injuriesClosedBoeing A75N1 · Friendship, WIAug 17, 1974 · N61836 · Destroyed NTSB CHI75FEP11Accident · 2 fatalClosedThorpe T-18 · Oshkosh, WIAug 6, 1974 · N193N · Destroyed NTSB CHI74FEP13Accident · No injuriesClosedBell 47D1 · Centerville, WIAug 6, 1974 · N3655F · Substantial damage NTSB CHI75FEP15Accident · No injuriesClosedCessna 182A · Appleton, WIAug 5, 1974 · N2010G · Substantial damage NTSB CHI75FEP12Accident · Minor injuriesClosedWalts Wings S1 · Hartford, WIAug 5, 1974 · N7748 · Substantial damage NTSB CHI75FER02Accident · No injuriesClosedN. American P-51 · River Falls, WIAug 4, 1974 · N6519D · Substantial damage NTSB CHI75DEP17Accident · No injuriesClosedPiper PA-30 · Madison, WIAug 4, 1974 · N7690Y · Substantial damage NTSB CHI75FER01Accident · Minor injuriesClosedVollmer Sprts · Webster, WIAug 3, 1974 · N4646T · Substantial damage NTSB CHI75FEP08Accident · 1 fatalClosed3 Roadable Bryan · Oshkosh, WIAug 2, 1974 · N2714C · Destroyed NTSB CHI75DEP14Accident · No injuriesClosedCessna 140 · Shawano, WIAug 2, 1974 · N77253 · Substantial damage NTSB CHI75FEP07Accident · Serious injuriesClosedBeech 23 · Dodgeville, WIAug 1, 1974 · N2397Z · Substantial damage NTSB CHI75FEP04Accident · Minor injuriesClosedPiper PA-18 · Hazelhurst, WIJul 29, 1974 · N7092D · Substantial damage NTSB CHI75FEP09Accident · No injuriesClosedPitts S1S · Fon Du Lac, WIJul 28, 1974 · N66JS · Substantial damage NTSB CHI75FEP10Accident · No injuriesClosedAcro Duster SA-700 · Fond Du Lac, WIJul 27, 1974 · N181J · Substantial damage NTSB CHI75FEP06Accident · No injuriesClosedPiper PA-28 · Beloit, WIJul 27, 1974 · N56978 · Destroyed NTSB CHI75FEP05Accident · Minor injuriesClosedCessna 180 · Three Lakes, WIJul 23, 1974 · N3460Y · Substantial damage NTSB CHI75DEP03Accident · No injuriesClosedCessna A188 · Nekoosa, WIJul 22, 1974 · N3545Q · Destroyed NTSB CHI75DEP02Accident · No injuriesClosedCessna 172 · Summit Lake, WIJul 21, 1974 · N4225Q · Substantial damage NTSB CHI75DEP44Accident · No injuriesClosedPiper PA-28R · Darlington, WIJul 20, 1974 · N2712R · Substantial damage NTSB CHI75AC008Accident · 3 fatalClosedCessna 310L · Land O' Lakes, WIJul 17, 1974 · N69939 · Destroyed NTSB CHI75AC003Accident · No injuriesClosedCessna 310C · Middleton, WIJul 9, 1974 · N1799H · Substantial damage NTSB CHI74DEP01Accident · No injuriesClosedPiper PA-22 · Menomonee Fls, WIJul 9, 1974 · N57260 · Substantial damage NTSB CHI74FER05Accident · No injuriesClosedCessna 170A · Horse Creek, WIJun 30, 1974 · N9546A · Substantial damage NTSB CHI74FEP50Accident · Minor injuriesClosedPiper PA-24 · Madison, WIJun 22, 1974 · N6847P · Substantial damage