Ongoing NTSB investigations
19 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 9 |
| 2026 | 8 |
Where
Open the mapLatest cases
Query with SQL
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\" = '338' 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" = '338' 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 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…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…NTSB ERA26FA241Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 177RG · Morrison, TNOn June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…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…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…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…NTSB CEN26LA175Accident · No injuriesClass 3 · LimitedPreliminary reportHiller UH-12E · Chickasha, OKOn April 30, 2026, about 1730 central daylight time, a Hiller UH-12E, N22SP, was substantially damaged when it was involved in an accident near Chickasha, Oklahoma. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ERA26FA178Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Ironton, OHOn April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…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…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…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…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…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…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.…NTSB ERA25MA171Accident · 6 fatalClass 2 · MajorPreliminary reportBell 206L-4 · Jersey City, NJOn April 10, 2025, about 1515 eastern daylight time, a Bell 206L-4 helicopter, N216MH, was destroyed when it was involved in an accident near Jersey City, New Jersey. The pilot and five passengers were fatally injured. The helicopter was operated as a Title…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…NTSB DCA25FA148Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 767 · Newark, NJOn March 1, 2025, at 0800 eastern standard time, FedEx flight 3609, a Boeing 767-300F, powered by two General Electric CF6-80C2 turbofan engines, registration number N178FE, struck birds during initial climb after takeoff from Newark Liberty International…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…NTSB ERA24FA274Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT502 · Martin, TNOn June 25, 2024, about 0820 central daylight time, an Air Tractor, Inc. AT-502A, N325RA, was substantially damaged when it was involved in an accident near Martin, Tennessee. The commercial pilot was fatally injured. The airplane was operated as a Title…