Skip to content

Ongoing NTSB investigations

13 cases where the defining event was Part(s) separation from AC.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20242026

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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338')
  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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338')
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 CEN26LA318Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV4 · Harrisonville, MOOn September 13, 2026, about 0930 central daylight time, a Vans Aircraft Inc, RV-4, N254MM, was substantially damaged when it was involved in an accident near Harrisonville, Missouri. The pilot and passenger were not injured. The airplane was operated as a…Sep 13, 2026 · N254MM · Substantial damage NTSB WPR26LA249Accident · No injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-502B · Ogden, UTOn July 7, 2026, about 1259 mountain daylight time, an Air Tractor, Inc. AT-502B airplane, N647LA, was substantially damaged when it was involved in an accident near Ogden, Utah. The commercial pilot was not injured. The flight was conducted as a Title 14…Jul 7, 2026 · N647LA · Substantial damage NTSB ERA26FA239Accident · 1 fatalClass 3 · FieldPreliminary reportBlessing RV-3A · Lakeland, FLOn June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of…Jun 15, 2026 · N696DB · Substantial damage NTSB ERA26LA232Accident · No injuriesClass 3 · LimitedPreliminary reportNorth American SNJ-5C · Midland, VAOn June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…Jun 6, 2026 · N98RJ · Substantial damage NTSB CEN26LA179Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421C · Kirksville, MOOn May 4, 2026, about 1759 central daylight time, a Cessna 421C airplane, N6161X, was substantially damaged during an accident near Kirksville, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…May 4, 2026 · N6161X · Substantial damage NTSB WPR26LA041Accident · No injuriesClass 3 · LimitedPreliminary reportBessler Duane Lynn Savannah · Pacific, WAOn November 7, 2025 at 1331 Pacific standard time, an experimental amateur-built ICP Savannah amphibious airplane, N358D, was substantially damaged when it was involved in an accident near Pacific, Washington. The pilot and the passenger were not injured. The…Nov 7, 2025 · N358D · Substantial damage NTSB DCA26MA024Accident · 14 fatalClass 1 · MajorPreliminary reportMcdonnell Douglas MD-11F · Louisville, KYOn November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad…Nov 4, 2025 · N259UP · Destroyed NTSB WPR26LA026Accident · No injuriesClass 3 · LimitedPreliminary reportExtra Flugzeugbau EA 300/L · Arlington, WAOn October 14, 2025, at about 1030 Pacific daylight time, an EXTRA FLUGZEUGBAU GMBH 300L, N300EX, was substantially damaged when it was involved in an accident near Arlington, Washington. The flight instructor and private pilot receiving instruction were…Oct 14, 2025 · N300EX · Substantial damage NTSB WPR25LA236Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Silver Springs, NVOn August 3, 2025, at about 0730 Pacific daylight time, a Piper PA28-180, N8359W, was substantially damaged when it was involved in an accident near Stagecoach, Nevada. The student pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Aug 3, 2025 · N8359W · Substantial damage NTSB CEN25LA206Accident · No injuriesClass 3 · LimitedPreliminary reportXag P100 PRO · Pontiac, ILOn June 5, 2025, at 1155 central daylight time, a XAG P100 Pro, N231CU, was substantially damaged when it was involved in an accident near Pontiac, Illinois. The unmanned aerial system (UAS) was operated under Title 14 Code of Federal Regulations as a Part…Jun 5, 2025 · N231CU · Substantial damage NTSB ERA25LA305Accident · No injuriesClass 3 · LimitedPreliminary reportDassault/Sud FAN JET Falcon SER D · Mount Airy, MDOn April 15, 2025, about 0800 eastern daylight time, a Dassault/Sud Fan Jet Falcon Series D, N229CK, was substantially damaged when it was involved in an accident near Mount Airy, Maryland. The airline transport pilot and commercial copilot were not injured.…Apr 15, 2025 · N229CK · Substantial damage NTSB ANC25LA027Accident · No injuriesClass 3 · LimitedPreliminary reportPilatus PC-12/45 · Sleetmute, AKOn March 7, 2025, about 1740 Alaska standard time, a Pilatus PC-12 airplane, N304PT, sustained substantial damage when it was involved in an accident near Sleetmute, Alaska. The pilot and nine passengers were not injured. The airplane was operated as a Title…Mar 8, 2025 · N304PT · Substantial damage NTSB ERA25LA002Accident · 1 fatalClass 3 · LimitedPreliminary reportFokker D Viii Replica · Rhinebeck, NYOn October 5, 2024, about 1456 eastern daylight time, an experimental amateur-built Coughlin Fokker D-VIII Replica, N94100, was destroyed when it was involved in an accident near Old Rhinebeck Airport (NY94), Rhinebeck, New York. The commercial pilot was…Oct 5, 2024 · N94100 · Destroyed