Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 CHI70D0369Accident · No injuriesClosedCessna 150 · Orfordville, WIDec 30, 1969 · N6236R · Substantial damage NTSB CHI70I0038Incident · No injuriesClosedBeech 95 · Stevens Point, WINov 26, 1969 · N654Q · Minor damage NTSB CHI70F0338Accident · Serious injuriesClosedTaylorcraft BC12-D · Blck Rvr Fals, WINov 25, 1969 · N95999 · Substantial damage NTSB CHI70F0340Accident · No injuriesClosedCessna 150J · Lancaster, WINov 22, 1969 · N60713 · Substantial damage NTSB CHI70F0347Accident · No injuriesClosedPiper PA-28 · Madison, WINov 16, 1969 · N6092W · Substantial damage NTSB CHI70A0030Accident · 2 fatalClosedMooney M20E · Barron, WINov 8, 1969 · N1293X · Destroyed NTSB CHI70A0027Accident · 7 fatalClosedLear Jet 23A · Racine, WINov 6, 1969 · N1021B · Destroyed NTSB CHI70A0026Accident · 2 fatalClosedCessna 182B · Watertown, WINov 5, 1969 · N2795G · Destroyed NTSB CHI70A0025Accident · No injuriesClosedPiper PA-32 · New Berlin, WINov 4, 1969 · N3276W · Substantial damage NTSB CHI70A0023Accident · 1 fatalClosedBeech D18S · Madison, WINov 1, 1969 · N106H · Destroyed NTSB CHI70D0330Accident · No injuriesClosedCessna 150 · Platteville, WIOct 25, 1969 · N3227J · Substantial damage NTSB CHI70D0332Accident · No injuriesClosedPiper PA-28 · Woodruff, WIOct 18, 1969 · N95157 · Substantial damage NTSB MKC70A0018Accident · No injuriesClosedBeech E18S · Ashland, WIOct 12, 1969 · N3785B · Substantial damage NTSB CHI70A0021Accident · 2 fatalClosedCessna 182M · Mazomanie, WIOct 11, 1969 · N70696 · Destroyed NTSB CHI70F0341Accident · No injuriesClosedCessna 150 · Waukesha, WIOct 9, 1969 · N6526S · Substantial damage NTSB CHI70D0334Accident · No injuriesClosedPiper PA-28 · Sturtevant, WIOct 7, 1969 · N1863J · Substantial damage NTSB CHI70F0310Accident · Minor injuriesClosedCessna 180 · Reeseville, WIOct 5, 1969 · N3866C · Substantial damage NTSB CHI70F0276Accident · No injuriesClosedCessna 150 · River Falls, WIOct 5, 1969 · N7993E · Substantial damage NTSB CHI70A0019Accident · 6 fatalClosedPiper PA-32 · Bruce, WIOct 3, 1969 · N4178R · Destroyed NTSB CHI70D0335Accident · No injuriesClosedMooney M20A · Milwaukee, WIOct 2, 1969 · N6071X · Substantial damage NTSB CHI70F0282Accident · Minor injuriesClosedAeronca 11AC · Neilsville, WISep 27, 1969 · N9239E · Destroyed NTSB CHI70A0018Accident · 1 fatalClosedNavion A · Milwaukee, WISep 27, 1969 · N4393K · Destroyed NTSB CHI70F0342Accident · Serious injuriesClosedPiper J3C-65 · Niagara, WISep 23, 1969 · N42046 · Destroyed NTSB CHI70F0274Accident · No injuriesClosedPiper PA-24 · Middleton, WISep 17, 1969 · N8149P · Substantial damage NTSB CHI70A0015Accident · 3 fatalClosedPiper PA-28 · North Lake, WISep 4, 1969 · N4898L · Destroyed NTSB CHI70F0200Accident · No injuriesClosedLuscombe 8A · So Superior, WIAug 31, 1969 · N39207 · Substantial damage NTSB CHI70F0333Accident · Minor injuriesClosedPiper PA-24 · Sextonville, WIAug 30, 1969 · N7797P · Substantial damage NTSB CHI70D0278Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 30, 1969 · N46556 · Substantial damage NTSB CHI70D0283Accident · No injuriesClosedCessna 310 · Tomah, WIAug 27, 1969 · N5355A · Substantial damage NTSB CHI70F0236Accident · No injuriesClosedCessna 150 · Kansasville, WIAug 26, 1969 · N3906J · Substantial damage NTSB CHI70F0319Accident · No injuriesClosedPiper PA-25 · Peshtigo, WIAug 25, 1969 · N7796Z · Substantial damage NTSB CHI70D0298Accident · No injuriesClosedCessna 140 · Chilton, WIAug 24, 1969 · N1999V · Substantial damage NTSB CHI70F0348Accident · No injuriesClosedGlobe GC-1B · Delavan, WIAug 23, 1969 · N78137 · Substantial damage NTSB CHI70F0252Accident · Minor injuriesClosedBeech B35 · Birchwood, WIAug 20, 1969 · N5200C · Substantial damage NTSB CHI70D0204Accident · No injuriesClosedBeech A-23 · Neenah, WIAug 17, 1969 · N1423L · Substantial damage NTSB CHI70F0206Accident · No injuriesClosedCessna 190 · Omro, WIAug 10, 1969 · N4302N · Substantial damage NTSB CHI70D0153Accident · No injuriesClosedPiper PA-23 · Iola, WIJul 31, 1969 · N6708Y · Destroyed NTSB CHI70F0135Accident · No injuriesClosedPiper PA-28 · Middleton, WIJul 27, 1969 · N6743J · Substantial damage NTSB CHI70A0012Accident · Serious injuriesClosedBoeing 720 · Janesville, WIJul 26, 1969 · N7215U · No damage NTSB CHI70F0170Accident · No injuriesClosedPiper J3C-65 · Sturgeon, WIJul 25, 1969 · N9070C · Substantial damage NTSB SEA70A0004Accident · 1 fatalClosedDehavilland DHC-2 · Wenatchee, WIJul 23, 1969 · CF-MGS · Destroyed NTSB CHI70A0007Accident · Minor injuriesClosedCessna 310H · Green Bay, WIJul 19, 1969 · N1047Q · Substantial damage NTSB CHI70D0086Accident · No injuriesClosedCessna 177 · Lodi, WIJul 17, 1969 · N3415T · Substantial damage NTSB CHI70D0130Accident · Minor injuriesClosedCessna 182A · Pulaski, WIJul 12, 1969 · N3781D · Substantial damage NTSB CHI70D0279Accident · No injuriesClosedCessna 180 · Phelps, WIJul 8, 1969 · N3244D · Substantial damage NTSB CHI70D0095Accident · No injuriesClosedPiper PA-25 · Suring, WIJul 8, 1969 · N4598Y · Substantial damage NTSB CHI70D0107Accident · No injuriesClosedPiper PA-24 · Wind Lake, WIJul 7, 1969 · N5742P · Substantial damage NTSB CHI70D0094Accident · No injuriesClosedBeech A23A · Waukesha, WIJul 6, 1969 · N7996L · Substantial damage NTSB CHI70D0129Accident · Minor injuriesClosedCessna 180 · Balsam Lake, WIJul 5, 1969 · N3606C · Substantial damage NTSB CHI70D0116Accident · No injuriesClosedPiper PA-28 · Abbotsford, WIJul 4, 1969 · N7283F · Substantial damage