Skip to content

Ongoing NTSB investigations, MI

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

20222026

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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CEN27LA026Accident · No injuriesClass 4 · LimitedInvestigation openPiper J3C-65 · Eagle Harbor, MIOct 17, 2026 · N3368N · Substantial damage NTSB CEN27LA012Accident · No injuriesClass 4 · LimitedInvestigation openDiamond Aircraft Ind DA20-C1 · Flint, MIOct 10, 2026 · N96YY · Substantial damage NTSB CEN27LA008Accident · No injuriesClass 4 · LimitedInvestigation openCessna 175A · Hastings, MIOct 8, 2026 · N6741E · Substantial damage NTSB CEN26LA329Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-181 · Mason, MISep 26, 2026 · N8086G · Substantial damage NTSB CEN26LA320Accident · No injuriesClass 4 · LimitedInvestigation openDiamond Aircraft Ind DA20-C1 · Howell, MISep 13, 2026 · N942RM · Substantial damage NTSB CEN26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportBeech 99 · Belleville, MIOn September 10, 2026, about 1545 eastern daylight time, a Beech 99 airplane, N799CZ, and a Diamond DA20 airplane, N84VV were involved in a ground collision accident at the Willow Run Airport, Belleville, Michigan. N799CZ received minor damage and N84VV…Sep 10, 2026 · N799CZ · 2 aircraft · Minor damage NTSB CEN26LA293Accident · No injuriesClass 3 · LimitedInvestigation openGildea William D Jabiru Calypso · Lake Isabella, MIAug 14, 2026 · N495JG NTSB CEN26LA292Accident · Serious injuriesClass 3 · LimitedInvestigation openTaylorcraft DCO-65 · Copper City, MIAug 14, 2026 · N48446 NTSB CEN26LA285Accident · Serious injuriesClass 3 · LimitedPreliminary reportStaudacher Jon ZZ 102 · Vicksburg, MIOn August 12, 2026, about 1906 eastern daylight time, a Staudacher ZZ 102 experimental airplane, N134ZZ, was substantially damaged when it was involved in an accident near Vicksburg, Michigan. The airline transport pilot and one passenger were seriously…Aug 12, 2026 · N134ZZ · Substantial damage NTSB CEN26LA213Accident · No injuriesClass 3 · LimitedPreliminary reportTextron 182T · Newberry, MIOn January 22, 2026, about 18:40 eastern standard time, a Cessna 182T, N116D was substantially damaged when it was involved in an accident near Newberry, Michigan. The pilot was not injured. The airplane was operated under the provisions of Title 14 Code of…Jan 22, 2026 · N116D · Substantial damage NTSB CEN26LA052Accident · Minor injuriesClass 3 · LimitedPreliminary reportGray RG12 · Benton Harbor, MIOn November 26, 2025, at 0920 eastern standard time, a RG12 airplane, C-FGEW, sustained substantial damage when it was involved in an accident near Benton Harbor, Michigan. The pilot and a passenger sustained minor injuries. The airplane was operated under…Nov 26, 2025 · C-FGEW · Substantial damage NTSB ANC26FA002Accident · 3 fatalClass 3 · FieldPreliminary reportRaytheon Hawker 800XP · Bath, MIOn October 16, 2025, about 1728 eastern standard time, a Raytheon Hawker 800XP airplane, Mexican registration XA-JMR, was destroyed when it was involved in an accident near Bath Township, Michigan. The captain, co-pilot, and passenger were fatally injured.…Oct 16, 2025 · XA-JMR · Destroyed NTSB CEN25LA357Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-24-250 · Gregory, MIOn August 28, 2025, at about 1550 eastern daylight time, a Piper PA-24-250 airplane, N7412P, was substantially damaged when it was involved in an accident near Gregory, Michigan. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…Aug 28, 2025 · N7412P · Substantial damage NTSB CEN25FA270Accident · 2 fatalClass 3 · FieldPreliminary reportVan's RV-14 · Lowell, MIOn July 21, 2025, about 1627 eastern daylight time, a Van’s Aircraft RV-14A airplane, N21KL, was destroyed when it was involved in an accident near Lowell, Michigan. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was operated…Jul 21, 2025 · N21KL · Destroyed NTSB OPS25LA054Incident · No injuriesClass 3 · LimitedPreliminary reportBombardier CL-600-2D24 · Freeland, MIOn July 16, 2025, about 1542 eastern daylight time (EDT), SkyWest Airlines (SKW) flight 3751, a Bombardier CL-600-2D24, N833SK, departed from a closed runway at MBS International Airport (MBS), Freeland, Michigan. The flight continued without further incident…Jul 16, 2025 · N833SK · No damage NTSB ERA25FA248Accident · 1 fatalClass 3 · FieldPreliminary reportRobert Fidler Lancair 320/360 · Zeeland, MIOn June 29, 2025, at 10:49 eastern daylight time, an experimental, amateur-built Lancair 360, N360RF, was destroyed when it was involved in an accident near Zeeland, Michigan. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…Jun 29, 2025 · N360RF · Destroyed NTSB CEN25LA186Accident · No injuriesClass 3 · LimitedPreliminary reportAeronca 7AC · Westphalia, MIOn May 24, 2025, at 1300 eastern daylight time, an Aeronca 7AC, N2659E, was substantially damaged when it was involved in an accident near Westphalia, Michigan. The commercial pilot was not injured. The airplane was operated under Title 14 Code of Federal…May 24, 2025 · N2659E · Substantial damage NTSB CEN22LA442Accident · No injuriesClass 3 · LimitedInvestigation openPiper PA-18 · Battle Creek, MISep 27, 2022 · N7207