Skip to content

NTSB investigations, 1978, WI

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 CHI79FEP20Accident · No injuriesClosedCessna 207 · Lyndon Station, WIDec 29, 1978 · N1688U · Substantial damage NTSB CHI79FEP13Accident · No injuriesClosedCessna 150 · Sussex, WIDec 28, 1978 · N60422 · Substantial damage NTSB CHI79DEP17Accident · No injuriesClosedPiper PA-24 · Eau Claire, WIDec 28, 1978 · N6175P · Substantial damage NTSB CHI79DEP19Accident · No injuriesClosedGrumman AA-1C · Madison, WIDec 26, 1978 · N9649U · Substantial damage NTSB CHI79FEP16Accident · No injuriesClosedCessna 172K · Dodgeville, WIDec 22, 1978 · N78428 · Substantial damage NTSB CHI79DEP15Accident · No injuriesClosedPiper PA-28R · Waupun, WIDec 17, 1978 · N7607J · Substantial damage NTSB CHI79DEP14Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 17, 1978 · N6858A · Substantial damage NTSB CHI79DEP12Accident · No injuriesClosedCessna 210 · Land O'Lakes, WIDec 13, 1978 · N8110G · Substantial damage NTSB CHI79FEP09Accident · No injuriesClosedGrumman AA-5 · Portage, WIDec 9, 1978 · N1348R · Substantial damage NTSB CHI79DEP10Accident · No injuriesClosedPiper PA-22 · Middleton, WIDec 2, 1978 · N3666Z · Substantial damage NTSB CHI79DEP11Accident · No injuriesClosedPiper PA-28 · Park Falls, WIDec 1, 1978 · N55845 · Substantial damage NTSB CHI79DEP08Accident · No injuriesClosedMooney M20J · Dodgeville, WINov 19, 1978 · N201SJ · Substantial damage NTSB CHI79FEP07Accident · Minor injuriesClosedCessna P210N · Green Bay, WINov 15, 1978 · N4738P · Substantial damage NTSB CHI79FEP06Accident · Serious injuriesClosedGrumman AA1-A · Milwaukee, WINov 7, 1978 · N9424L · Substantial damage NTSB CHI79DEP05Accident · Minor injuriesClosedCessna 172 · Shawano, WIOct 30, 1978 · N8313X · Substantial damage NTSB CHI79FEP04Accident · No injuriesClosedPiper PA-28 · Tomahawk, WIOct 18, 1978 · N5629W · Substantial damage NTSB CHI79FEP03Accident · No injuriesClosedBeech V-35A · Richland Cntr, WIOct 11, 1978 · N3771Q · Substantial damage NTSB CHI79FA006Accident · 2 fatalClosedPiper PA-24 · Baraboo, WIOct 10, 1978 · N5696P · Destroyed NTSB CHI79DEP02Accident · Minor injuriesClosedThorp T-18 · Middleton, WIOct 6, 1978 · N493TK · Destroyed NTSB CHI79DEP01Accident · No injuriesClosedPiper PA-23 · Platteville, WIOct 2, 1978 · N555DG · Substantial damage NTSB CHI78FA070Accident · 1 fatalClosedCessna 150F · Portage, WISep 25, 1978 · N8815S · Destroyed NTSB CHI78FEP70Accident · No injuriesClosedPiper PA-28 · Milwaukee, WISep 15, 1978 · N32506 · Substantial damage NTSB CHI78FEP68Accident · No injuriesClosedMooney M20F · Racine, WISep 11, 1978 · N9275V · Substantial damage NTSB CHI78FA069Accident · No injuriesClosedPiper PA-28R · Markesan, WISep 7, 1978 · N4508J · Substantial damage NTSB CHI78FEP66Accident · No injuriesClosedCessna 150 · Kenosha, WISep 3, 1978 · N66238 · Substantial damage NTSB CHI78FEP65Accident · Serious injuriesClosedCessna 177B · Junction City, WISep 3, 1978 · N35121 · Destroyed NTSB CHI78FEP69Accident · No injuriesClosedCessna 172F · Sauk Prairie, WISep 1, 1978 · N8312U · Substantial damage NTSB CHI78FEP64Accident · 2 fatalClosedGrumman AA-1C · Laona, WIAug 30, 1978 · N9976U · Destroyed NTSB CHI78FEP63Accident · Minor injuriesClosedGrum Amer AA5A · Waterford, WIAug 28, 1978 · N1118A · Substantial damage NTSB CHI78FEP59Accident · Minor injuriesClosedCessna 182 · Bristol, WIAug 20, 1978 · N4759D · Substantial damage NTSB CHI78DEP62Accident · No injuriesClosedCessna 150 · Milwaukee, WIAug 20, 1978 · N3035V · Substantial damage NTSB CHI78DEP57Accident · No injuriesClosedCessna 185 · Juneau, WIAug 19, 1978 · N2638Z · Substantial damage NTSB CHI78DEP54Accident · Minor injuriesClosedBeech F35 · Wautoma, WIAug 19, 1978 · N888SM · Substantial damage NTSB CHI78FEP61Accident · 2 fatalClosedBeech C23 · Portage, WIAug 18, 1978 · N18952 · Destroyed NTSB CHI78DEP60Accident · No injuriesClosedCessna 150K · Kenosha, WIAug 18, 1978 · N6490G · Substantial damage NTSB CHI78FEP47Accident · 1 fatalClosedChampion 7ECA · Howard, WIAug 13, 1978 · N9681S · Substantial damage NTSB CHI78FEP56Accident · No injuriesClosedCessna 172M · Oshkosh, WIAug 3, 1978 · N172TC · 2 aircraft · Minor damage NTSB CHI79FEP55Accident · No injuriesClosedCessna 177 · Eagle River, WIAug 2, 1978 · N29425 · Substantial damage NTSB CHI78FEP58Accident · No injuriesClosedHughes 269C · Stoughton, WIAug 2, 1978 · N7485F · Substantial damage NTSB CHI78FA051Accident · 2 fatalClosedBeech E-33A · Prt Washington, WIJul 31, 1978 · N6275V · Destroyed NTSB CHI78FEP52Accident · 2 fatalClosedThorp T-18 · Oshkosh, WIJul 30, 1978 · N18FK · Destroyed NTSB CHI78FEP53Accident · Minor injuriesClosedCessna 195B · Oshkosh, WIJul 29, 1978 · N2117C · 2 aircraft · Substantial damage NTSB CHI78FEP51Accident · No injuriesClosedPiper PA-22 · Milwaukee, WIJul 28, 1978 · N8195C · Substantial damage NTSB CHI78FEP50Accident · No injuriesClosedCessna 172 · Tony, WIJul 28, 1978 · N3874R · Substantial damage NTSB CHI78FEP49Accident · Minor injuriesClosedCessna 172E · Pewaukee, WIJul 27, 1978 · N3845S · Substantial damage NTSB CHI78DEP48Accident · Minor injuriesClosedThorp T18 · Kenosha, WIJul 23, 1978 · N2911 · Substantial damage NTSB DCA78IA018Incident · No injuriesClosedDouglas DC-9 · Oshkosh, WIJul 21, 1978 · N959N · Minor damage NTSB CHI78DEP46Accident · No injuriesClosedCessna 150 · Kewaunee, WIJul 19, 1978 · N116DH · Substantial damage NTSB CHI78FA049Accident · 1 fatalClosedBellanca 17-30A · Rhinelander, WIJul 12, 1978 · N93627 · Destroyed NTSB CHI78FEP45Accident · Minor injuriesClosedSnow S2C · Bancroft, WIJul 11, 1978 · N1638S · Destroyed