Ongoing NTSB investigations
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.
Cases, newest first
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' 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' 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 WPR26LA314Accident · No injuriesClass 4 · LimitedInvestigation openKfa Safari · Coolin, IDNTSB WPR26LA313Accident · No injuriesClass 4 · LimitedInvestigation openStinson 108-1 · Joseph, ORNTSB CEN26LA302Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-22-150 · Brenham, TXNTSB CEN26LA299Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150M · Greenwood, ILNTSB WPR26LA316Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Bemidji, MNNTSB WPR26LA310Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172P · Gulfport, MSNTSB ERA26LA322Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-32R-300 · Thomaston, GANTSB ERA26LA312Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA24 · Fort Washington, MDNTSB WPR26LA312Accident · Serious injuriesClass 3 · LimitedPreliminary reportSchweizer G-164B · Olene, OROn August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA309Accident · 8 fatalClass 3 · FieldPreliminary reportCessna 441 · Cape Newenham, AKOn August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportDiamond Aircraft Ind DA20-A1 · Bristol, MEOn August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…NTSB CEN26LA296Accident · 1 fatalClass 3 · LimitedPreliminary reportPara-Ski VX · Westport, SDOn August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal…NTSB ERA26FA309Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 150 · Carlisle, PAOn August 19, 2026, at 1852 eastern daylight time, a Bell Helicopter Textron Canada 407, N873ST, and a Cessna 150H airplane, N23330, collided in flight near Carlisle, Pennsylvania. The two commercial pilots onboard the helicopter were seriously injured, and…NTSB ANC26LA089Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 180J · Bettles, AKNTSB ANC26LA088Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172L · Micanopy, FLOn August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…NTSB WPR26LA325Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150 · Socorro, NMNTSB CEN26LA295Accident · Minor injuriesClass 3 · LimitedPreliminary reportAviat A-1B · Pilot Grove, MNOn August 17, 2026, about 1446 central daylight time, an Aviat Aircraft Inc A-1B airplane, N299CA, was substantially damaged when it was involved in an accident near Pilot Grove, Minnesota. The two pilots received minor injuries. The airplane was operated as…NTSB WPR26LA304Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · McCall, IDNTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CANTSB ERA26LA306Accident · Serious injuriesClass 4 · LimitedInvestigation openPowrachute Pegasus · Humboldt, TNNTSB WPR26LA306Accident · No injuriesClass 4 · LimitedInvestigation openAero Rampart Steen Skybolt · Roseburg, ORNTSB ERA26LA303Accident · Serious injuriesClass 3 · LimitedPreliminary reportMcfarland Larry C Zenith 601 HDS · Ripley Landing, WVOn August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.…NTSB ENG26FA034Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 747 · Anchorage, AKOn August 15, 2026, 1755 Alaska Daylight Time, a China Airlines Flight Number CI-5265, Boeing 747-400F, registration B-18725, powered by four GE Aerospace CF6-80C2B1F turbofan engines, experienced an inflight fire indication during the initial climb from Ted…NTSB WPR26LA307Accident · Serious injuriesClass 4 · LimitedInvestigation openCirrus Design SF50 · Driggs, IDNTSB ERA26LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportBarry Lynn Kromer Zenith Cruzer · Chatham, MAOn August 14, 2026, about 1040 eastern daylight time, an experimental amateur-built Zenith Cruzer, N673BK, was substantially damaged when it was involved in an accident near Chatham, Massachusetts. The pilot and the pilot-rated passenger received minor…NTSB CEN26LA293Accident · No injuriesClass 3 · LimitedInvestigation openGildea William D Jabiru Calypso · Lake Isabella, MINTSB CEN26LA292Accident · Serious injuriesClass 3 · LimitedInvestigation openTaylorcraft DCO-65 · Copper City, MINTSB CEN26LA290Accident · No injuriesClass 3 · LimitedPreliminary reportGulfstream Aerospace G-IV · St. Louis, MOOn August 14, 2026, about 1459 central daylight time, a Gulfstream Aerospace G-IV airplane, N406JS, was substantially damaged when it was involved in an accident near St. Louis, Missouri. The three crew members and 7 passengers were not injured. The airplane…NTSB ERA26LA308Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28R-180 · Readington Township, NJNTSB CEN26LA287Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20G · Luling, TXOn August 13, 2026, about 1302 central daylight time, a Mooney M20G airplane, N6916N, sustained substantial damage when it was involved in an accident near Luling, Texas. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB ANC26LA084Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Anthony, FLOn August 12, 2026, at approximately 2305 eastern daylight time, a Robinson R44 Raven II helicopter, N861MP, was substantially damaged when it was involved in an accident near Anthony, Florida. The pilot and passenger sustained minor injuries. The helicopter…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…NTSB WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…NTSB ERA26LA302Accident · No injuriesClass 4 · LimitedInvestigation openFrank J Salomone RV10 · Stevensville, MDNTSB WPR26LA296Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 180 · La Center, WAOn August 10, 2026, about 12:55 Pacific daylight time, a Cessna 180, N180DT, was substantially damaged when it was involved in an accident near La Center, Washington. The flight instructor and pilot receiving instruction were seriously injured. The flight was…NTSB ERA26LA358Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Union City, OHOn August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a…NTSB ERA26LA298Accident · No injuriesClass 4 · LimitedInvestigation openPeckham Lloyd Zodiac CH-650B · Westerly, RINTSB CEN26LA283Accident · No injuriesClass 3 · LimitedPreliminary reportVelocity Velocity · Palmyra, ILOn August 10, 2026, about 1248 central daylight time, an experimental Velocity 173 FG Elite II airplane, N6954K, sustained substantial damage when it was involved in an accident near Palmyra, Illinois. The pilot and two passengers sustained no injuries. The…NTSB WPR26LA302Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Salmon, IDOn August 9, 2026, at 1420 mountain daylight time, a Cessna 208B airplane, N247JP, was substantially damaged when it was involved in an accident near Salmon, Idaho. The pilot and eight passengers were not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA297Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22T · Sells, AZNTSB ERA26LA296Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA32 · Dawsonville, GANTSB ERA26LA295Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20E · Conway, SCOn August 9, 2026 at 802 eastern daylight time, a Mooney M20E, N9257V, was substantially damaged when it was involved in an accident near Conway, South Carolina. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB ERA26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportBachem Fritz M Avid Mark IV · Arp, TXOn August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…NTSB ANC26LA082Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Macedonia, IANTSB ANC26LA081Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna A185F · Hope, AKNTSB WPR26LA299Accident · No injuriesClass 4 · LimitedInvestigation openJonker Sailplanes JS3 · Tehachapi, CANTSB WPR26LA298Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Reno, NVNTSB WPR26LA300Accident · No injuriesClass 4 · LimitedInvestigation openZaklad Szybowcowy Jezow PW-6U · Floriston, CANTSB WPR26LA293Accident · No injuriesClass 4 · LimitedInvestigation openP Z L -Warszawa-Cnpsl PZL-104 Wilga 35A · Ukiah, CANTSB WPR26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 172S · Provo, UTOn August 7, 2026, about 1549 mountain daylight time, a Textron Aviation Inc. 172S, N1842E, was substantially damaged when it was involved in an accident near Provo, Utah. The flight instructor sustained serious injuries, and the pilot undergoing instruction…