Ongoing NTSB investigations, WI

8 cases where the sequence of events included Loss of engine power (total).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20262026

Ongoing NTSB investigations, WI per year, 2026–2026: 8 cases
2026	8

Where

Open the map

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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 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 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 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 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 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