Skip to content

NTSB investigations, 1981, 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, 1981, 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") = 1981 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\") = 1981
    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") = 1981
  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 CHI82DEP14Accident · No injuriesClosedCessna 152 · Pewaukee, WIDec 16, 1981 · N6464L · Substantial damage NTSB CHI82FEP13Accident · No injuriesClosedCessna 210C · Baraboo, WIDec 11, 1981 · N3677Y · Destroyed NTSB CHI82DEP11Accident · No injuriesClosedCessna 152 · Monroe, WINov 29, 1981 · N47808 · Substantial damage NTSB CHI82DEP12Accident · No injuriesClosedCessna 140 · Hayward, WINov 27, 1981 · N3174N · Substantial damage NTSB CHI82FA016Accident · 2 fatalClosedCessna 182E · Platteville, WINov 26, 1981 · N2860Y · Destroyed NTSB CHI82FEP09Accident · 1 fatalClosedOsprey 2 · Madison, WINov 14, 1981 · N209DW · Destroyed NTSB CHI82FEP08Accident · No injuriesClosedPiper PA-28 · Dodgeville, WINov 8, 1981 · N1UK · Substantial damage NTSB CHI81DEP07Accident · No injuriesClosedBellanca 7ECA · Neenah, WIOct 27, 1981 · N1195E · Substantial damage NTSB CHI82DEP06Accident · No injuriesClosedCessna 152 · Monroe, WIOct 24, 1981 · N4609B · Substantial damage NTSB CHI82FEP05Accident · No injuriesClosedPiper PA-28 · Waukesha, WIOct 20, 1981 · N6327W · Substantial damage NTSB CHI82FEP03Accident · Serious injuriesClosedCessna 402B · Park Falls, WIOct 4, 1981 · N4613N · Destroyed NTSB CHI82FEP02Accident · No injuriesClosedCessna 150 · Hamburg, WIOct 4, 1981 · N60052 · Substantial damage NTSB CHI82DEP04Accident · No injuriesClosedCessna TR182 · Lake Geneva, WIOct 3, 1981 · N736WH · Substantial damage NTSB CHI82FEP01Accident · No injuriesClosedCessna 150J · Waukesha, WIOct 1, 1981 · N51046 · Substantial damage NTSB CHI81FA104Accident · 3 fatalClosedCessna 210 · Mosinee, WISep 25, 1981 · N9582T · Destroyed NTSB CHI81DER40Accident · Minor injuriesClosedPiper PA-32 · Crivitz, WISep 14, 1981 · N39628 · Substantial damage NTSB CHI81DEP46Accident · No injuriesClosedPiper PA-22 · La Pointe, WISep 14, 1981 · N3551P · Substantial damage NTSB CHI81DEP47Accident · No injuriesClosedBensen B-8M · Manitowoc, WISep 12, 1981 · N513DE · Substantial damage NTSB CHI81FEP45Accident · Minor injuriesClosedPiper PA-30 · Racine, WISep 7, 1981 · N8786Y · Substantial damage NTSB CHI81FEP44Accident · 1 fatalClosedSteen Skyblt · Hartford, WISep 5, 1981 · N81GS · Destroyed NTSB CHI81FA095Accident · 2 fatalClosedPiper PA-18 · Chippewa Falls, WISep 2, 1981 · N99053 · Destroyed NTSB CHI81FA091Accident · 3 fatalClosedMooney M20J · La Pointe, WIAug 20, 1981 · N1098Y · Destroyed NTSB CHI81DEP42Accident · No injuriesClosedMooney M20C · Dodgeville, WIAug 9, 1981 · N5892Q · Substantial damage NTSB CHI81FEP41Accident · No injuriesClosedDehavilland DHC-1 · Mequon, WIAug 6, 1981 · N1114V · Substantial damage NTSB CHI81FEP43Accident · Minor injuriesClosedMooney M20J · Oshkosh, WIAug 1, 1981 · C-GYJW · 2 aircraft · Minor damage NTSB CHI81FER54Accident · No injuriesClosedCessna A185E · Superior, WIJul 26, 1981 · N70049 · Substantial damage NTSB CHI81FER53Accident · No injuriesClosedBeech A23 · Superior, WIJul 25, 1981 · N1470L · Substantial damage NTSB CHI81DEP39Accident · No injuriesClosedLuscombe 8A · Egg Harbor, WIJul 19, 1981 · N21996 · Substantial damage NTSB CHI81DEP38Accident · No injuriesClosedCessna 172RG · Greenbay, WIJul 19, 1981 · N5207U · Substantial damage NTSB CHI81DEP37Accident · No injuriesClosedWaco UPF-7 · Stoughton, WIJul 18, 1981 · N29903 · Substantial damage NTSB CHI81DEP35Accident · No injuriesClosedPiper PA-24 · Washington Is, WIJul 17, 1981 · N9249P · Substantial damage NTSB CHI81DEP36Accident · No injuriesClosedGulfstream AA-5A · Juneau, WIJul 16, 1981 · N26784 · Substantial damage NTSB CHI81DEP33Accident · No injuriesClosedCessna 152 · Milwaukee, WIJul 11, 1981 · N5355P · Substantial damage NTSB CHI81DEP32Accident · No injuriesClosedCessna 172M · Prt Washington, WIJul 11, 1981 · N1483V · Substantial damage NTSB CHI81DEP31Accident · No injuriesClosedCessna 172A · Franklin, WIJul 9, 1981 · N9896Q · Substantial damage NTSB CHI81DEP29Accident · Minor injuriesClosedGrumman AA-5 · Summit Lake, WIJul 5, 1981 · N9564L · Substantial damage NTSB CHI81FEP30Accident · Minor injuriesClosedCessna 172I · Oconomowoc, WIJul 4, 1981 · N35491 · Destroyed NTSB CHI81FEP27Accident · Minor injuriesClosedCessna 172N · Hartford, WIJul 4, 1981 · N8913G · Destroyed NTSB CHI81FEP34Accident · No injuriesClosedSikorsky HRS-1 · Rosedale, WIJul 2, 1981 · N4782S · Destroyed NTSB CHI81DEP26Accident · No injuriesClosedGrumman AA-5A · Rio, WIJun 28, 1981 · N9820U · Substantial damage NTSB CHI81DEP25Accident · No injuriesClosedPiper PA-28 · Wonewoc, WIJun 27, 1981 · N671FL · Destroyed NTSB CHI81DEP28Accident · No injuriesClosedCessna 152 · Pewaukee, WIJun 26, 1981 · N48990 · Substantial damage NTSB CHI81DEP24Accident · No injuriesClosedPiper PA-28 · Franksville, WIJun 22, 1981 · N1845T · Substantial damage NTSB CHI81DEP20Accident · No injuriesClosedCessna 152 · Medford, WIJun 22, 1981 · N67435 · Substantial damage NTSB CHI81DEP22Accident · No injuriesClosedBell 47G-5 · Coloma, WIJun 12, 1981 · N1315X · Substantial damage NTSB CHI81DEP21Accident · Minor injuriesClosedPiper PA-28 · Genoa City, WIJun 7, 1981 · N8459F · Substantial damage NTSB CHI81FEP19Accident · No injuriesClosedPiper PA-12 · Spring Green, WIMay 25, 1981 · N78459 · Substantial damage NTSB CHI81DEP18Accident · No injuriesClosedCessna 150K · La Crosse, WIMay 25, 1981 · N6265G · Substantial damage NTSB CHI81FA054Accident · 1 fatalClosedPiper PA-28 · Johnstown Ctr, WIMay 9, 1981 · N6921W · Destroyed NTSB CHI81DER34Accident · No injuriesClosedCessna 152 · Boyceville, WIMay 1, 1981 · N67613 · Substantial damage