Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 CHI74DEP27Accident · No injuriesClosedCessna 172 · Kenosha, WIDec 29, 1973 · N7120G · Substantial damage NTSB CHI74DEP25Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 29, 1973 · N3907Q · Substantial damage NTSB CHI74DEP24Accident · No injuriesClosedCessna 150 · Crivitz, WIDec 10, 1973 · N10772 · Substantial damage NTSB CHI74AC040Accident · No injuriesClosedBoeing 727 · Madison, WIDec 9, 1973 · N259US · Substantial damage NTSB CHI74DEP23Accident · Minor injuriesClosedAeronca 11AC · Neshkoro, WIDec 1, 1973 · N9353E · Substantial damage NTSB CHI74AC043Accident · 4 fatalClosedPiper PA-28 · Delavan, WINov 23, 1973 · N16327 · Destroyed NTSB CHI74DEP22Accident · Minor injuriesClosedCessna 172G · Elkhorn, WINov 22, 1973 · N1346F · Substantial damage NTSB CHI74DEP21Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WINov 22, 1973 · N1783T · Substantial damage NTSB CHI74FEP20Accident · No injuriesClosedHelio Acft H-391B · Eau Claire, WIOct 17, 1973 · N8750R · Substantial damage NTSB CHI74FEP19Accident · No injuriesClosedCessna 175A · Milwaukee, WIOct 14, 1973 · N7017E · Substantial damage NTSB CHI74DER03Accident · No injuriesClosedCessna 150L · Durand, WIOct 14, 1973 · N17295 · Substantial damage NTSB CHI74AC033Accident · 1 fatalClosedBeech D35 · Aurora, WIOct 9, 1973 · N2964B · Destroyed NTSB CHI74FEP18Accident · No injuriesClosedBeech V35G · Manitowish W, WIOct 6, 1973 · N4647D · Substantial damage NTSB CHI74FEP17Accident · No injuriesClosedPiper PA-22 · Arena, WISep 22, 1973 · N6838B · Substantial damage NTSB CHI74AC025Accident · 4 fatalClosedCessna 411 · Delavan, WISep 21, 1973 · N3243R · Destroyed NTSB CHI74AC024Accident · 6 fatalClosedPiper PA-30 · Florence, WISep 21, 1973 · N7878Y · Destroyed NTSB CHI74FEP15Accident · Minor injuriesClosedErco 415C · Portage, WISep 20, 1973 · N2244H · Substantial damage NTSB CHI74FEP07Accident · Serious injuriesClosedCessna 150D · Crandon, WISep 8, 1973 · N4537U · Substantial damage NTSB CHI74DEP16Accident · No injuriesClosedPiper PA-28 · Elkhorn, WISep 2, 1973 · N3498K · Substantial damage NTSB CHI74DEP13Accident · Minor injuriesClosedBolkow 150FF · Bristol, WIAug 20, 1973 · N209AJ · Substantial damage NTSB CHI74DEP14Accident · Minor injuriesClosedCessna 177 · Shawano, WIAug 15, 1973 · N2957X · Substantial damage NTSB CHI74FEP11Accident · Minor injuriesClosedCessna 170B · Kenosha, WIAug 12, 1973 · N4670C · Substantial damage NTSB CHI74DEP12Accident · Minor injuriesClosedPiper J-3 · Neena, WIAug 12, 1973 · N98200 · Substantial damage NTSB CHI74FEP09Accident · Minor injuriesClosedCessna 120 · Okauchee, WIAug 11, 1973 · N76245 · Substantial damage NTSB CHI74FEP10Accident · Serious injuriesClosedCessna 172 · Cadott, WIAug 10, 1973 · N8595U · Destroyed NTSB CHI74FEP08Accident · Minor injuriesClosedBeech D50 · Walworth, WIAug 9, 1973 · N4977B · Destroyed NTSB CHI74FEP06Accident · Minor injuriesClosedBeech C23 · Milwaukee, WIAug 7, 1973 · N2102W · 2 aircraft · Substantial damage NTSB CHI74FEP04Accident · Serious injuriesClosedStits SA3B · Oshkosh, WIAug 3, 1973 · N3849 · Substantial damage NTSB CHI74FEP03Accident · No injuriesClosedBede BD-5J · Oshkosh, WIAug 1, 1973 · N5BD · Substantial damage NTSB CHI74FEP05Accident · Serious injuriesClosedPiper PA-28 · Wautoma, WIJul 28, 1973 · N1658J · Substantial damage NTSB CHI74DEP02Accident · Minor injuriesClosedCessna 150L · Stoughton, WIJul 25, 1973 · N1328Q · Destroyed NTSB CHI74FER01Accident · Minor injuriesClosedBeech 23 · Menomonie, WIJul 24, 1973 · N2349L · Substantial damage NTSB CHI74FEP01Accident · Serious injuriesClosedCessna 172M · Mantowish Wta, WIJul 4, 1973 · N20281 · Destroyed NTSB CHI74AC002Accident · 1 fatalClosedCessna 170A · Superior, WIJul 2, 1973 · N9745A · Destroyed NTSB CHI73DEP69Accident · No injuriesClosedCessna 140A · Milwaukee, WIJun 29, 1973 · N1116D · Substantial damage NTSB CHI73DEP68Accident · Minor injuriesClosedPiper PA-24 · Tigerton, WIJun 26, 1973 · N9287P · Destroyed NTSB CHI73FEP67Accident · No injuriesClosedFairchild F-24 · Portage, WIJun 24, 1973 · N77697 · Substantial damage NTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WIJun 24, 1973 · N7840S · Substantial damage NTSB CHI73DEP65Accident · Minor injuriesClosedPiper PA-22 · Kenosha, WIJun 15, 1973 · N7316D · Substantial damage NTSB CHI73FER09Accident · 1 fatalClosedMoonraker 100 · Prescott, WIJun 13, 1973 · N8669E · Destroyed NTSB CHI73FER08Accident · Serious injuriesClosedTaylorcraft BC12-D · Menomonie, WIJun 13, 1973 · N96584 · Substantial damage NTSB CHI73FEP64Accident · No injuriesClosedCessna 310Q · Viroqwa, WIJun 12, 1973 · N6292Q · Substantial damage NTSB CHI73DEP63Accident · No injuriesClosedPiper PA-25 · Portage, WIJun 4, 1973 · N7796Z · Substantial damage NTSB CHI73FEP62Accident · No injuriesClosedPiper PA-28 · Elkhorn, WIMay 30, 1973 · N3498K · Substantial damage NTSB CHI73FEP61Accident · 1 fatalClosedCassutt 111M · Bloomer, WIMay 28, 1973 · N143L · Destroyed NTSB CHI73AC092Accident · 1 fatalClosedCessna 172L · Crivitz, WIMay 26, 1973 · N7656G · Destroyed NTSB CHI73FEP60Accident · Serious injuriesClosedPiper PA-24 · Madison, WIMay 24, 1973 · N7068D · Substantial damage NTSB CHI73FEP59Accident · No injuriesClosedLuscombe 8A · Middleton, WIMay 20, 1973 · N71318 · Substantial damage NTSB CHI73FEP58Accident · No injuriesClosedCessna 182M · Burlington, WIMay 20, 1973 · N91835 · Substantial damage NTSB CHI73DEP57Accident · No injuriesClosedCessna 172G · Wilmot, WIMay 17, 1973 · N5767R · Substantial damage