Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 CHI76DER06Accident · No injuriesClosedAero Comdr 100 · Superior, WIDec 9, 1975 · N3877X · Substantial damage NTSB CHI76DEP20Accident · No injuriesClosedPiper PA-28 · Lancaster, WIDec 9, 1975 · N98107 · Substantial damage NTSB CHI76FEP19Accident · Serious injuriesClosedCessna 172A · Madison, WINov 22, 1975 · N7727T · Destroyed NTSB CHI76FER05Accident · No injuriesClosedCessna 150G · Rice Lake, WINov 15, 1975 · N3940J · Substantial damage NTSB CHI76FEP18Accident · Serious injuriesClosedBeech 95-B55 · Crandon, WINov 7, 1975 · N181Q · Substantial damage NTSB CHI76FEP16Accident · No injuriesClosedCessna 150H · Lake Geneva, WIOct 12, 1975 · N50127 · Substantial damage NTSB CHI76DEP15Accident · No injuriesClosedGrum Amer AA-5 · Necedah, WISep 14, 1975 · N5484L · Substantial damage NTSB CHI76AC023Accident · 2 fatalClosedPiper PA-22 · Cataract, WISep 7, 1975 · N3279B · Destroyed NTSB CHI76DEP14Accident · No injuriesClosedCessna 182 · Ft Atkinson, WIAug 30, 1975 · N71248 · Substantial damage NTSB CHI76DER04Accident · No injuriesClosedBensen B-8M · New Richmond, WIAug 28, 1975 · N8322 · Substantial damage NTSB CHI76FER03Accident · Serious injuriesClosedPiper PA-22 · Siren, WIAug 11, 1975 · N1409C · Destroyed NTSB CHI76DEP13Accident · Minor injuriesClosedStearman A75N1 · Portage, WIAug 11, 1975 · N55891 · Destroyed NTSB CHI76FEP09Accident · No injuriesClosedBreezy R201 · Oshkosh, WIAug 2, 1975 · N5AF · Substantial damage NTSB CHI76AC008Accident · 1 fatalClosedCessna 170B · Iron Ridge, WIAug 2, 1975 · N3468C · Destroyed NTSB CHI76DEP11Accident · Serious injuriesClosedPiper PA-28 · Mt Horeb, WIAug 1, 1975 · N15581 · Substantial damage NTSB CHI76FER02Accident · No injuriesClosedPiper PA-18 · Cumberland, WIJul 28, 1975 · N5404Y · Substantial damage NTSB CHI76DEP12Accident · No injuriesClosedCessna 188 · Gillman, WIJul 28, 1975 · N8135V · Substantial damage NTSB CHI76DEP08Accident · No injuriesClosedAeronca 11AC · Holmen, WIJul 28, 1975 · N9692E · Substantial damage NTSB CHI76FEP07Accident · 1 fatalClosedNieuport 17 · Milwaukee, WIJul 27, 1975 · N3603 · Destroyed NTSB CHI76FER01Accident · Minor injuriesClosedPiper PA-25 · Balsam Lake, WIJul 26, 1975 · N4799Y · Substantial damage NTSB CHI75FEP65Accident · No injuriesClosedBeech E18S · Burlington, WIJul 25, 1975 · N402FW · Substantial damage NTSB CHI76DEP06Accident · No injuriesClosedStearman A75N1 · Alma Center, WIJul 22, 1975 · N55898 · Substantial damage NTSB CHI76DEP10Accident · Minor injuriesClosedGrum Amer AA1-A · Portage, WIJul 20, 1975 · N9251L · Substantial damage NTSB CHI76FEP05Accident · Serious injuriesClosedBeech S3S · Franklin, WIJul 19, 1975 · N1478V · Substantial damage NTSB CHI76AC003Accident · 4 fatalClosedGrum Amer AA-5 · Hammond, WIJul 19, 1975 · N5875L · Destroyed NTSB CHI76DEP03Accident · No injuriesClosedPiper PA-25 · Bancroft, WIJul 15, 1975 · N4659Y · Substantial damage NTSB CHI76FEP02Accident · No injuriesClosedNavion N1A · Hales Corners, WIJul 6, 1975 · N5108K · Substantial damage NTSB CHI76DEP04Accident · No injuriesClosedCessna 182 · West Bend, WIJul 6, 1975 · N3707U · Substantial damage NTSB CHI76FEP01Accident · Serious injuriesClosedLuscombe 8A · Montello, WIJul 4, 1975 · N77887 · Substantial damage NTSB CHI75DEP71Accident · No injuriesClosedStinson 108-1 · Montello, WIJun 27, 1975 · N8784K · Substantial damage NTSB CHI75FEP69Accident · No injuriesClosedCessna 182H · Gratiot, WIJun 22, 1975 · N8454S · Substantial damage NTSB CHI75DEP72Accident · No injuriesClosedPiper PA-24 · Sturgeon Bay, WIJun 20, 1975 · N5837P · Substantial damage NTSB CHI75FEP70Accident · No injuriesClosedCessna 170B · Medford, WIJun 19, 1975 · N2352D · Substantial damage NTSB CHI75FEP46Accident · Minor injuriesClosedLuscombe 8A · Burlington, WIJun 14, 1975 · N45974 · Substantial damage NTSB CHI75FEP68Accident · Serious injuriesClosedGrum Amer AA1 · Delavan, WIJun 12, 1975 · N6543L · Substantial damage NTSB CHI75FER07Accident · Serious injuriesClosedBeech A23 · Baldwin, WIJun 7, 1975 · N4769J · Destroyed NTSB CHI75FEP66Accident · No injuriesClosedPiper PA-22 · Pewaukee, WIJun 6, 1975 · N7043D · Substantial damage NTSB CHI75FEP64Accident · Minor injuriesClosedBeech A36 · Wausaw, WIMay 31, 1975 · N9076Q · Destroyed NTSB CHI75FEP62Accident · Serious injuriesClosedSchweizer SGS2 · West Bend, WIMay 31, 1975 · N1204S · Substantial damage NTSB CHI75FEP60Accident · No injuriesClosedCessna 150L · Milwaukee, WIMay 31, 1975 · N1254Q · Substantial damage NTSB CHI75FEP55Accident · No injuriesClosedN.American Navion · Shawano, WIMay 26, 1975 · N6724C · Substantial damage NTSB CHI75DEP59Accident · No injuriesClosedGlobe GC-1B · Milwaukee, WIMay 25, 1975 · N80923 · Substantial damage NTSB CHI75FEP57Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIMay 24, 1975 · N43041 · Substantial damage NTSB CHI75DEP56Accident · No injuriesClosedCessna 140 · Reedsville, WIMay 21, 1975 · N1893V · Destroyed NTSB CHI75FEP54Accident · Minor injuriesClosedFlaglor-Hag H-1 · Merrill, WIMay 18, 1975 · N3518 · Substantial damage NTSB CHI75FEP53Accident · Minor injuriesClosedFairchild 24W-41 · Union Grove, WIMay 18, 1975 · N28504 · Substantial damage NTSB CHI75DEP61Accident · No injuriesClosedCessna 414 · Janesville, WIMay 17, 1975 · N33DS · Substantial damage NTSB CHI75DEP63Accident · No injuriesClosedCessna 150H · Middleton, WIMay 13, 1975 · N50006 · Substantial damage NTSB CHI75DEP58Accident · No injuriesClosedCessna 182 · Milwaukee, WIMay 10, 1975 · N42871 · Substantial damage NTSB CHI75AC086Accident · No injuriesClosedPiper PA-16 · Janesville, WIMay 10, 1975 · N5382H · 2 aircraft · Minor damage