Skip to content

Ongoing NTSB investigations, WI

180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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

20252026

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 c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Ongoing' 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 c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Ongoing'
  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 c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Ongoing'
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 CEN27FA016Accident · 5 fatalClass 3 · FieldInvestigation openPiper PA 46-350P · Reedsburg, WIOct 14, 2026 · N931TT NTSB CEN27LA009Accident · Serious injuriesClass 3 · LimitedInvestigation openSimpson Arthur Monnett Sonerai Iilt · Sextonville, WIOct 12, 2026 · N473AS NTSB CEN26LA326Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 35-A33 · East Troy, WIOn September 27, 2026, about 1333 central daylight time, a Beech A33 airplane, N1288Z, was substantially damaged when it was involved in an accident near East Troy, Wisconsin. The pilot and three passengers sustained minor injuries. The airplane was operated…Sep 27, 2026 · N1288Z · Substantial damage NTSB CEN26LA319Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech K35 · Wausau, WIOn September 12, 2026, about 2049 central daylight time, a Beech K35 airplane, N6071E, was substantially damaged when it was involved in an accident near Wausau, Wisconsin. The pilot and passenger suffered minor injuries. The flight was operated as a Title 14…Sep 13, 2026 · N6071E · Substantial damage NTSB CEN26LA308Accident · Serious injuriesClass 3 · LimitedPreliminary reportSix Chuter SR7 XL · Amery, WIOn September 2, 2026, about 2007 central daylight time, a Six Chuter SR7XL experimental light-sport powered parachute, N5617X, was involved in an accident near Amery, Wisconsin. The pilot was seriously injured. The powered parachute was operated as a Title 14…Sep 3, 2026 · N5617X · Substantial damage NTSB CEN26LA277Accident · Serious injuriesClass 3 · LimitedPreliminary reportTaylorcraft BC12-D · Boyceville, WIOn August 2, 2026, about 1223 central daylight time, a Taylorcraft BC12-D airplane, N43665 was substantially damaged when it was involved in an accident near Boyceville, Wisconsin. Both the pilot and passenger were seriously injured. The airplane was operated…Aug 2, 2026 · N43665 · Substantial damage NTSB CEN26LA273Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172F · Antigo, WIJul 28, 2026 · N7978U · Substantial damage NTSB CEN26LA268Accident · No injuriesClass 3 · LimitedPreliminary reportKitfox III · Ephraim, WIOn July 26, 2026, at 1941 central daylight time, an experimental Kitfox III airplane, N573TB, sustained substantial damage when it was involved in an accident near Ephraim, Wisconsin. The private pilot and a passenger were uninjured. The airplane was operated…Jul 27, 2026 · N573TB · Substantial damage NTSB CEN26LA262Accident · No injuriesClass 4 · LimitedInvestigation openBeech F33A · Janesville, WIJul 20, 2026 · N933A · Substantial damage NTSB CEN26LA258Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV-8A · Mineral Point, WIOn July 17, 2026, at 1748 central daylight time, an experimental amateur-built Vans Aircraft Inc RV-8A, N22SZ, sustained substantial damage when it was involved in an accident in Mineral Point, Wisconsin. The commercial pilot was uninjured. The airplane was…Jul 17, 2026 · N22SZ · Substantial damage NTSB CEN26LA263Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Baraboo, WIOn July 16, 2026, about 1508 central daylight time, a Piper PA-24-260 airplane, N8606P, sustained substantial damage when it was involved in an accident near Baraboo, Wisconsin. The pilot sustained serious injuries. The airplane was operated as a Title 14…Jul 16, 2026 · N8606P · Substantial damage NTSB CEN26LA231Accident · 1 fatalClass 3 · LimitedPreliminary reportBailey-Moyes Dragonfly · Whitewater, WIOn June 22, 2026, about 1915 central daylight time, a Bailey-Moyes Dragonfly, N3849A, was involved in an accident near Whitewater, Wisconsin. The pilot of the Dragonfly was not injured. The pilot of the hang glider in tow was fatally injured. The tow…Jun 23, 2026 · N3849A · No damage NTSB CEN26LA208Accident · Minor injuriesClass 3 · LimitedPreliminary reportAmerican AA-1A · Amery, WIOn May 30, 2026, about 1113 central daylight time, a Grumman AA-1A airplane, N6416L, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…May 30, 2026 · N6416L · Substantial damage NTSB CEN26LA094Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172K · Amery, WIOn January 16, 2026, about 1130 central standard time, a Cessna 172 airplane, N79118, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Jan 16, 2026 · N79118 · Substantial damage NTSB CEN26FA050Accident · 2 fatalClass 3 · FieldPreliminary reportSocata TBM 700 · Monroe, WIOn November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…Nov 24, 2025 · N700PT · Substantial damage NTSB CEN25LA265Accident · No injuriesClass 3 · LimitedPreliminary reportQuestair Venture · Oshkosh, WIOn July 20, 2025, about 1545 central daylight time, a Questair Venture airplane, N53TL, sustained substantial damage when it was involved in an accident at Oshkosh, Wisconsin. The pilot and passenger were not injured. The airplane was operated under the…Jul 20, 2025 · N53TL · Substantial damage