Ongoing NTSB investigations

9 cases where the sequence of events included Miscellaneous/other.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20252026

Ongoing NTSB investigations per year, 2025–2026: 9 cases
2025	4
2026	5

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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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.\"completionStatus\" = 'Ongoing'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' 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."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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 WPR26LA322Accident · Serious injuriesClass 4 · LimitedInvestigation openKrugh Patrick M Steen Skybolt · Big Bear, CAAug 28, 2026 · N43PK · Substantial damage NTSB WPR26FA284Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Blackfoot, IDOn August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The…Aug 2, 2026 · N1166F · Substantial damage NTSB WPR26LA275Accident · Minor injuriesClass 3 · LimitedPreliminary reportCzech Aircraft Works Mermaid Skeeter 2 · Cougar, WAOn July 22, 2026, about 1129 Pacific daylight time, an experimental amateur built Czech Aircraft Works Mermaid Skeeter 2 airplane, N42SK, was substantially damaged when it was involved in an accident near Cougar, Washington. The pilot was seriously injured.…Jul 22, 2026 · N42SK · Substantial damage NTSB CEN26LA264Accident · Serious injuriesClass 4 · LimitedInvestigation openBell 206B · Saint Joseph, ILJul 17, 2026 · N297CA · Substantial damage NTSB WPR26FA233Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 195 · Pasco, WAOn June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…Jun 24, 2026 · N3877V · Substantial damage NTSB WPR26LA064Accident · Serious injuriesClass 3 · LimitedPreliminary reportMooney M20J · Silver Springs, NVOn December 17, 2025, about 1230 Pacific standard time, a Mooney M20J, N87PM, was substantially damaged when it was involved in an accident near Silver Springs, Nevada. The pilot and passenger sustained serious injuries. The airplane was operated as a Title…Dec 17, 2025 · N87PM · Substantial damage NTSB DCA26LA012Accident · Minor injuriesClass 3 · LimitedPreliminary reportBoeing 737 · Moab, UTOn October 16, 2025, at 0643 mountain daylight time (MDT), United Airlines (UAL) flight 1093, a Boeing 737-8, N17327, was involved in a midair collision with an object while in cruise flight near Moab, Utah. Although the captain sustained minor injuries, none…Oct 16, 2025 · N17327 · Substantial damage NTSB ERA25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportHiller UH12E · Rockledge, FLOn April 6, 2025, about 1020 eastern daylight time, a Hiller UH-12E, N48263, was substantially damaged when it was involved in an accident near Rockledge, Florida. The private pilot and passenger sustained serious injuries. The helicopter was operated as a…Apr 6, 2025 · N48263 · Substantial damage NTSB ERA25LA155Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SF50 · Kissimmee, FLOn March 24, 2025 about 0804 eastern daylight time, a Cirrus Design Corporation SF50, N56GY, was substantially damaged when it was involved in an accident at Kissimmee Gateway Airport (ISM), Orlando, Florida. The commercial pilot was not injured. The airplane…Mar 24, 2025 · N56GY · Substantial damage