Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 CHI80DEP12Accident · No injuriesClosedM.B.B. BO-209 · Johnson Creek, WIDec 29, 1979 · N209SF · Substantial damage NTSB CHI80DEP11Accident · No injuriesClosedPiper PA-28 · Rio Creek, WIDec 29, 1979 · N15651 · Substantial damage NTSB CHI80IEP10Accident · No injuriesClosedMooney M20J · Waterloo, WIDec 21, 1979 · N201UW · Substantial damage NTSB CHI80DA017Accident · 2 fatalClosedCessna 310R · Green Bay, WIDec 21, 1979 · N78ST · Destroyed NTSB CHI80FEP08Accident · No injuriesClosedBellanca 17-30A · Viroqua, WIDec 18, 1979 · N14703 · Substantial damage NTSB CHI80FEP07Accident · Minor injuriesClosedCessna 152 · Madison, WINov 29, 1979 · N714WL · Substantial damage NTSB CHI80FEP06Accident · No injuriesClosedCessna 172 · Portage, WINov 24, 1979 · N1468V · Substantial damage NTSB CHI80FEP05Accident · Serious injuriesClosedCessna 150M · Omro, WINov 11, 1979 · N45718 · Substantial damage NTSB CHI80FEP03Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIOct 27, 1979 · N40868 · Substantial damage NTSB CHI80FA006Accident · 2 fatalClosedCessna 172 · Fall Creek, WIOct 20, 1979 · N5072R · Destroyed NTSB CHI80FEP04Accident · Minor injuriesClosedCessna 152 · Lake Geneva, WIOct 19, 1979 · N714VN · Substantial damage NTSB CHI80FEP02Accident · Minor injuriesClosedBeech 56TC · Middleton, WIOct 15, 1979 · N7115N · Substantial damage NTSB CHI80DEP01Accident · No injuriesClosedBeech 19 · Big Bend, WIOct 8, 1979 · N5431M · Substantial damage NTSB CHI79FEP79Accident · 1 fatalClosedFly-Baby 1-A · Watertown, WISep 30, 1979 · N6518 · Destroyed NTSB CHI7.FEP81Accident · Minor injuriesClosedCessna 152 · Rio, WISep 28, 1979 · N714SY · Substantial damage NTSB CHI79DEP80Accident · No injuriesClosedCessna 150 · Platteville, WISep 24, 1979 · N11569 · Substantial damage NTSB CHI79FA081Accident · 2 fatalClosedCessna 150 · Porcupine, WISep 23, 1979 · N7853E · Destroyed NTSB CHI79DEP78Accident · Minor injuriesClosedPiper PA-25 · Pound, WISep 19, 1979 · N9769P · Destroyed NTSB CHI79DER08Accident · Minor injuriesClosedPiper PA-28 · Superior, WISep 17, 1979 · N2109N · Substantial damage NTSB CHI79DER07Accident · No injuriesClosedPiper PA-28 · Birchwood, WISep 15, 1979 · N1934T · Destroyed NTSB CHI79FER06Accident · Serious injuriesClosedPiper PA-24 · Menomonie, WISep 9, 1979 · N6837P · Destroyed NTSB CHI79FEP77Accident · No injuriesClosedCessna 182 · Manitowish Wtr, WISep 4, 1979 · N3VH · Substantial damage NTSB CHI79FEP76Accident · 2 fatalClosedTom Story WD-6 · Janesville, WISep 2, 1979 · N274WD · Destroyed NTSB CHI79FA072Accident · 2 fatalClosedPiper PA-24 · Bloomfield Twp, WISep 2, 1979 · N6051P · 2 aircraft · Substantial damage NTSB CHI79FEP73Accident · No injuriesClosedMustang II · Racine, WIAug 26, 1979 · N22RG · Destroyed NTSB CHI79FEP75Accident · 2 fatalClosedPiper PA-28 · Kenosha, WIAug 18, 1979 · N3016H · Destroyed NTSB CHI79FEP74Accident · 1 fatalClosedPitts Spcl S1S · Camp Douglas, WIAug 14, 1979 · N751BF · Destroyed NTSB CHI79FER05Accident · Minor injuriesClosedTaylorcraft BC12-D · Woodville, WIAug 13, 1979 · N43930 · Substantial damage NTSB CHI79FEP70Accident · Minor injuriesClosedStarduster SA-100 · Fond Du Lac, WIAug 8, 1979 · N86670 · Substantial damage NTSB CHI79DEP82Accident · Minor injuriesClosedCessna 182P · Platteville, WIAug 7, 1979 · N7400Q · Substantial damage NTSB CHI79FEP71Accident · Serious injuriesClosedMunninghoff FW-190 · Oshkosh, WIAug 5, 1979 · N14926 · Destroyed NTSB CHI79DEP72Accident · No injuriesClosedPiper PA-32 · Lakewood, WIAug 4, 1979 · N47420 · Substantial damage NTSB CHI79FEP69Accident · No injuriesClosedCessna 177 · Oshkosh, WIJul 30, 1979 · N30231 · Substantial damage NTSB CHI79FEP63Accident · No injuriesClosedCessna 182 · Green Bay, WIJul 30, 1979 · N333JB · Substantial damage NTSB CHI79FEP68Accident · No injuriesClosedBakeng Duce · Oskhosh, WIJul 29, 1979 · N9659A · Substantial damage NTSB CHI79FA063Accident · 1 fatalClosedPiper PA-32 · Spring Green, WIJul 29, 1979 · N20995 · Destroyed NTSB CHI79FEP66Accident · Serious injuriesClosedCessna 172M · Rockwood, WIJul 27, 1979 · N1862V · Substantial damage NTSB CHI79FEP61Accident · 2 fatalClosedCessna 177RG · Sheboygen, WIJul 27, 1979 · N7540V · Destroyed NTSB CHI79DEP65Accident · No injuriesClosedCessna 150 · Waukesha, WIJul 24, 1979 · N3416V · Substantial damage NTSB CHI79FEP60Accident · Minor injuriesClosedCessna 182 · Bristol, WIJul 21, 1979 · N5325B · Substantial damage NTSB CHI79DEP64Accident · No injuriesClosedBeech 23 · Appleton, WIJul 21, 1979 · N2373W · Substantial damage NTSB CHI79DEP62Accident · No injuriesClosedCessna 172 · Coleman, WIJul 20, 1979 · N9801V · Substantial damage NTSB CHI79FEP67Accident · Minor injuriesClosedPiper PA-17 · South Byron, WIJul 15, 1979 · N4839H · Substantial damage NTSB CHI79FEP58Accident · Minor injuriesClosedCessna 172N · Milwaukee, WIJul 15, 1979 · N734AD · Substantial damage NTSB CHI79DEP59Accident · No injuriesClosedBeech A23 · Dodgeville, WIJul 15, 1979 · N5780V · Substantial damage NTSB CHI79FEP53Accident · No injuriesClosedCessna 150 · Milwaukee, WIJul 6, 1979 · N7774F · Substantial damage NTSB CHI79FEP52Accident · Minor injuriesClosedDavis DA-3 · Burlington, WIJul 3, 1979 · N19MD · Substantial damage NTSB CHI79FEP51Accident · Serious injuriesClosedCessna 182P · Neillsville, WIJul 3, 1979 · N22FW · Substantial damage NTSB CHI79FA056Accident · 1 fatalClosedPiper PA-28 · Taylor, WIJul 3, 1979 · N8341C · Destroyed NTSB CHI79DER04Accident · No injuriesClosedBeech E33C · Star Prairie, WIJul 3, 1979 · N277F · Substantial damage