Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 CHI78FEP07Accident · No injuriesClosedCessna 177 · Madison, WIDec 26, 1977 · N2011Q · Substantial damage NTSB CHI78FEP10Accident · No injuriesClosedCessna 402 · Milwaukee, WIDec 13, 1977 · N15096 · Substantial damage NTSB CHI78FA008Accident · 1 fatalClosedCessna 310P · Eagle River, WINov 7, 1977 · N5861M · Destroyed NTSB CHI78FA007Accident · 1 fatalClosedCessna 310Q · Watertown, WINov 6, 1977 · N7701Q · Destroyed NTSB CHI78FEP09Accident · Serious injuriesClosedPiper PA-31 · Manitowoc, WINov 3, 1977 · N9273Y · Destroyed NTSB CHI78FER01Accident · No injuriesClosedBeech D18S · Osceola, WIOct 30, 1977 · N273C · Substantial damage NTSB CHI78FEP08Accident · No injuriesClosedGrum Amer AA1B · Racine, WIOct 28, 1977 · N888IL · Substantial damage NTSB CHI78FEP06Accident · No injuriesClosedBeech C23 · Milwaukee, WIOct 25, 1977 · N2252L · Substantial damage NTSB CHI78FEP05Accident · No injuriesClosedPiper PA-24 · Green Bay, WIOct 19, 1977 · N5837P · Substantial damage NTSB CHI78FEP04Accident · Minor injuriesClosedCessna 172M · Elkhorn, WIOct 17, 1977 · N20011 · Destroyed NTSB CHI78DEP03Accident · No injuriesClosedHawk DSK-1 · Mosinee, WIOct 16, 1977 · N9FK · Substantial damage NTSB CHI78DEP02Accident · Serious injuriesClosedSemco Chlngr · Mauston, WIOct 16, 1977 · N14550 · No damage NTSB CHI78FEP01Accident · Minor injuriesClosedHughes 269C · Cottage Grove, WIOct 6, 1977 · N7436F · Substantial damage NTSB CHI77DEP64Accident · No injuriesClosedCessna 337 · Wilmot, WISep 28, 1977 · N6304F · Substantial damage NTSB CHI77FEP61Accident · No injuriesClosedCessna 172L · West Bend, WISep 18, 1977 · N1TA · Substantial damage NTSB CHI77DEP62Accident · No injuriesClosedPiper PA-28 · Middleton, WISep 18, 1977 · N15953 · Substantial damage NTSB CHI77FEP63Accident · Serious injuriesClosedCessna 150L · Winneconne, WISep 14, 1977 · N19257 · Substantial damage NTSB CHI78FA071Accident · 2 fatalClosedCessna 320 · Milwaukee, WISep 11, 1977 · N5719X · Destroyed NTSB CHI77FEP60Accident · No injuriesClosedCessna 170 · Mosinee, WISep 5, 1977 · N2667V · Substantial damage NTSB CHI77FEP59Accident · Minor injuriesClosedBell 47J2A · Plymouth, WISep 5, 1977 · N6769D · Substantial damage NTSB CHI77DEP57Accident · No injuriesClosedCessna 150 · New Holstein, WIAug 27, 1977 · N704RP · Substantial damage NTSB CHI77FEP58Accident · No injuriesClosedBeech 95-A55 · Milwaukee, WIAug 25, 1977 · N200KL · Substantial damage NTSB CHI77FA069Accident · 4 fatalClosedCessna 170 · Florence, WIAug 23, 1977 · N4052V · Destroyed NTSB CHI77DEP56Accident · No injuriesClosedCessna 172M · Dodgeville, WIAug 21, 1977 · N5240R · Substantial damage NTSB CHI77DEP55Accident · Minor injuriesClosedChampion 7EC · Waukesha, WIAug 20, 1977 · N8569E · Substantial damage NTSB CHI77DEP51Accident · No injuriesClosedGR Lakes 2T-1A2 · Menomonee, WIAug 14, 1977 · N6018L · Substantial damage NTSB CHI77DEP50Accident · No injuriesClosedSchweizer 1-26B · West Bend, WIAug 14, 1977 · N2780Z · Substantial damage NTSB CHI77FEP53Accident · Serious injuriesClosedPietenpol GN1 · Wis.Rapids, WIAug 8, 1977 · N83951 · Substantial damage NTSB CHI77DEP54Accident · No injuriesClosedStarduster BR-2 · Pardeeville, WIAug 5, 1977 · N9BR · Substantial damage NTSB CHI77FA063Accident · 3 fatalClosedAero Comdr 720 · Wausau, WIAug 4, 1977 · N688R · Destroyed NTSB CHI77FEP49Accident · Serious injuriesClosedHughes 269B · Waupaca, WIAug 2, 1977 · N9448F · Substantial damage NTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WIAug 1, 1977 · N12204 · 2 aircraft · Destroyed NTSB CHI77FEP47Accident · Serious injuriesClosedCessna 172 · Lake Geneva, WIJul 31, 1977 · N7409A · Substantial damage NTSB CHI77EEP48Accident · 1 fatalClosedBellanca 14-13 · Prairie Du Chn, WIJul 30, 1977 · N86709 · Substantial damage NTSB CHI77DEP52Accident · No injuriesClosedBeech B-19 · Milwaukee, WIJul 30, 1977 · N1990L · Substantial damage NTSB CHI77DEP46Accident · No injuriesClosedGrum Amer AA1B · Waunakee, WIJul 25, 1977 · N9698L · Substantial damage NTSB CHI77FEP45Accident · No injuriesClosedBellanca 17-30A · Milwaukee, WIJul 18, 1977 · N39867 · Substantial damage NTSB CHI77DEP44Accident · No injuriesClosedCessna 182 · Burlington, WIJul 16, 1977 · N2683G · Substantial damage NTSB CHI77FER04Accident · 1 fatalClosedPiper PA-24 · Superior, WIJul 4, 1977 · N8898 · Substantial damage NTSB CHI77FEP42Accident · No injuriesClosedCessna 188B · Nekoosa, WIJul 4, 1977 · N4915Q · Substantial damage NTSB CHI77DEP40Accident · No injuriesClosedBellanca 7AC · Kaukauna, WIJun 26, 1977 · N85118 · Substantial damage NTSB CHI77FEP43Accident · No injuriesClosedMaule M4220C · Hayward, WIJun 25, 1977 · N7622E · Substantial damage NTSB CHI77FEP41Accident · No injuriesClosedSnow S2C · Nekoosa, WIJun 25, 1977 · N1670S · Substantial damage NTSB CHI77FEP38Accident · Minor injuriesClosedBeech A23 · Portage, WIJun 19, 1977 · N1479L · Substantial damage NTSB CHI77FEP39Accident · No injuriesClosedPiper PA-32 · Madison, WIJun 17, 1977 · N15635 · Substantial damage NTSB CHI77DEP35Accident · Serious injuriesClosedReplica BE-2C · Neenah, WIJun 14, 1977 · N1914B · Substantial damage NTSB CHI77FA049Accident · 4 fatalClosedPiper PA-24 · Grafton, WIJun 11, 1977 · N6349P · Destroyed NTSB CHI77FEP37Accident · No injuriesClosedCessna 172A · Sturgeon Bay, WIJun 7, 1977 · N9712T · Substantial damage NTSB CHI77DEP36Accident · Minor injuriesClosedPiper PA-32 · Clam Lake, WIJun 2, 1977 · N8383C · Substantial damage NTSB CHI77FA046Accident · 4 fatalClosedPiper PA-24 · Evansville, WIMay 27, 1977 · N9326P · Destroyed