Ongoing NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ANC26LA073Accident · No injuriesClass 4 · LimitedInvestigation openAviat A-1C-200 · Springfield, MONTSB ANC26LA072Accident · No injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-2 MK.I · Nondalton, AKOn July 19, 2026 about 1440 Alaska daylight time, a DeHavilland DHC-2 airplane, N791PW was substantially damaged when it was involved in an accident near Nondalton, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA271Accident · No injuriesClass 4 · LimitedInvestigation openLet L-23 Super Blanik · North Plains, ORNTSB WPR26LA269Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-161 · San Bernardino, CAOn July 18, 2026, about 1530 Pacific daylight time, a Piper PA-28-161, N8249B, was substantially damaged when it was involved in an accident near San Bernardino, California. The pilot and pilot rated passenger were not injured. The airplane was operated as a…NTSB CEN26LA261Accident · No injuriesClass 4 · LimitedInvestigation openBeech 35-B33 · Alton, ILNTSB CEN26LA259Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 · Adair, IAOn July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB CEN26LA264Accident · Serious injuriesClass 4 · LimitedInvestigation openBell 206B · Saint Joseph, ILNTSB CEN26LA258Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV-8A · Mineral Point, WIOn July 17, 2026, at 1748 central daylight time, an experimental amateur-built Vans Aircraft Inc RV-8A, N22SZ, sustained substantial damage when it was involved in an accident in Mineral Point, Wisconsin. The commercial pilot was uninjured. The airplane was…NTSB WPR26LA264Accident · Serious injuriesClass 4 · LimitedInvestigation openTag Aviation PTY Titanium Explorer · Cashmere, WANTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB CEN26LA263Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Baraboo, WIOn July 16, 2026, about 1508 central daylight time, a Piper PA-24-260 airplane, N8606P, sustained substantial damage when it was involved in an accident near Baraboo, Wisconsin. The pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB CEN26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportDakota Cub Super 18 · Plymouth, MAOn July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of…NTSB ANC26LA074Accident · Minor injuriesClass 4 · LimitedInvestigation openMooney M20E · Englewood, CONTSB WPR26LA279Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24 · Medford, OROn July 14, 2026, about 1725 Pacific daylight time, a Piper PA-24 airplane, N5002P, was substantially damaged when it was involved in an accident at Rogue Valley International/Medford Airport (MFR), Medford. Oregon. The two pilots were not injured. The…NTSB WPR26LA260Accident · Minor injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Auburn, CANTSB WPR26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportLuscombe 8A · Canton, TXOn July 14, 2026, sometime between 1252 and 1356 CDT, a Luscombe 8A, N1164K, was substantially damaged when it crashed in a field near Canton, Texas. The pilot, who was the sole occupant, was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA274Accident · No injuriesClass 4 · LimitedInvestigation openRobinson R22 · Monroe, NCNTSB ERA26FA271Accident · 3 fatalClass 3 · FieldPreliminary reportSmith Aerostar 601 · Lake Clear, NYOn July 13, 2026, about 2236 eastern daylight time, a Smith Aerostar 601P, N800AA was destroyed when it was involved in an accident near Lake Clear, New York. The private pilot and two passengers were fatally injured. The airplane was operated as a Title 14…NTSB CEN26FA253Accident · 1 fatalClass 3 · FieldPreliminary reportMontana Coyote · Fredericksburg, VAOn July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a…NTSB ERA26FA270Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Metter, GAOn July 13, 2026, about 1114 eastern daylight time, a Beechcraft 95-B55, twin-engine airplane, N55FD, was destroyed when it was involved in an accident near Metter, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14…NTSB CEN26LA254Accident · 1 fatalClass 3 · LimitedPreliminary reportTag Aviation PTY Titanium Explorer · Larkspur, COOn July 13, 2026, about 800 mountain daylight time, a Tag Aviation Pty Ltd Titanium Explorer gyrocopter, N665TE was substantially damaged when it was involved in an accident near Larkspur, Colorado. The pilot passed away in the hospital five days after the…NTSB WPR26LA258Accident · No injuriesClass 3 · LimitedPreliminary reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZOn July 12, 2026, at 1018 mountain standard time, a Remos GX airplane, N126GX, was substantially damaged when it was involved in an accident near Glendale, Arizona. The flight instructor and student pilot were uninjured. The airplane was operated as a Title…NTSB ERA26FA269Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 182 · Piseco, NYOn July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN26FA247Accident · 1 fatalClass 3 · FieldPreliminary reportKaman Aerospace K-1200 · Silver Jack Reservoir, COOn July 12, 2026, about 1705 mountain daylight time, a Kaman Aerospace Corporation K-1200 (K-MAX) helicopter, N40HX, was substantially damaged when it was involved in an accident at Silver Jack Reservoir, Colorado. The pilot was fatally injured. The…NTSB ANC26LA071Accident · Serious injuriesClass 4 · LimitedInvestigation openBellanca 7GCBC · Skwentna, AKNTSB WPR26LA256Accident · No injuriesClass 3 · LimitedPreliminary reportCanadair CF-5D · Mojave, CAOn July 10, 2026, about 1103 Pacific daylight time, a Canadair CF-5D, N845PS, was substantially damaged when it was involved in an accident near Mojave, California. The two pilots onboard were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR26FA254Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Waterloo, ILOn July 9, 2026, at about 2248 central daylight time, a Beech 95-B55, N202DK, was destroyed when it was involved in an accident near Waterloo, Illinois. The pilot and pilot rated passenger were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA266Accident · 1 fatalClass 3 · FieldPreliminary reportSikorsky S76 · Huntersville, WVOn July 10, 2026, about 0745 eastern daylight time, a Sikorsky S-76D helicopter, N93RT, was destroyed when it was involved in an accident near Huntersville, West Virginia. The commercial pilot was fatally injured. The helicopter was operated as a Title 14…NTSB DCA26FA274Accident · Serious injuriesClass 3 · FieldPreliminary reportBoeing 737 · Polykastro, GreeceMalta Air, doing business as Ryanair flight 1879, a Boeing 737-8AS, registration 9H-QEU, experienced a No. 2 (right) engine fan-blade-out (FBO) failure during climb out from the Thessaloniki International Airport (SKG), Thessaloniki, Greece. Engine fragments…NTSB CEN26LA251Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV-12 · Grand Junction, COOn July 10, 2026, about 1023 mountain daylight time, an experimental amateur-built Vans Aircraft Inc RV-12 airplane, N812MM, sustained substantial damage when it was involved in an accident near Grand Junction, Colorado. The pilot and a passenger were…NTSB CEN26LA250Accident · Minor injuriesClass 3 · LimitedPreliminary reportGlasair I RG · Utica, MNOn July 9, 2026, about 1805 central daylight time, a Glasair 1RG airplane, N141CG, sustained substantial damage when it was involved in an accident near Utica, Minnesota. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN26LA248Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Tulsa, OKOn July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was…NTSB ANC26LA070Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20M · Tallahassee, FLOn July 8, 2026, at 1148 eastern daylight time, a Mooney M20 airplane was substantially damaged when it was involved in an accident near Tallahassee, Florida. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA251Accident · No injuriesClass 3 · LimitedPreliminary reportLuscombe 8A · Novato, CAOn July 7, 2026, about 1200 Pacific daylight time, a Luscombe 8A, N45886, was substantially damaged when it was involved in an accident near Novato, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…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 ANC26LA069Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18-150 · Mekoryuk, AKOn July 7, 2026 about 1430 Alaska daylight time, a Piper PA-18-150 airplane, N824JT, was substantially damaged when it was involved in an accident near Mekoryuk, Alaska. The pilot and one passenger were not injured. The airplane was operated as a Title 14…NTSB DCA26LA270Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A321-231 · Somerset, CONTSB WPR26LA245Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Salome, AZOn July 5, 2026, at about 0825 Pacific daylight time, a Piper PA-28-140, N3995K, was substantially damaged when it was involved in an accident near Salome, Arizona. The pilot and passenger were uninjured. The airplane was operating as a Title 14 Code of…NTSB ANC26LA068Accident · Minor injuriesClass 4 · LimitedInvestigation openSchweizer 269C · Skwentna, AKNTSB ERA26LA258Accident · Serious injuriesClass 3 · LimitedPreliminary reportPortzline Joan M Flight Star II SC · Mulberry, FLOn July 4, 2026, about 1121 eastern daylight time, an experimental amateur-built Flight Star II SC airplane, N432JP, was substantially damaged when it was involved in an accident near Mulberry, Florida. The private pilot and a passenger were seriously…NTSB CEN26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-25-235 · Forest Lake, MNOn July 4, 2026, about 0942 central daylight time, a Piper PA-25-235 airplane, N386AB, was substantially damaged when it was involved in an accident near Forest Lake, Minnesota. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ANC26LA067Accident · No injuriesClass 4 · LimitedInvestigation openDehavilland DHC-3 · Denali National Park, AKNTSB ERA26LA257Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Lafayette, TNOn July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14…NTSB CEN26FA241Accident · Serious injuriesClass 3 · FieldPreliminary reportBeech 95-A55 · Lancaster, SCOn July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title…NTSB ERA26LA256Accident · No injuriesClass 4 · LimitedInvestigation openEmbraer Executive EMB-500 · Morrisville, NCNTSB WPR26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Paynesville, MNOn June 30, 2026, about 1745 central daylight time, a Beech A36, N8095F, was substantially damaged when it was involved in an accident at Paynesville Municipal Airport (PEX), Paynesville, Minnesota. The private pilot and one passenger were not injured. The…NTSB ERA26LA254Accident · No injuriesClass 3 · LimitedPreliminary reportRath Michael J Sonerai 2 · Cynthiana, KYOn June 30, 2026, at about 1030 eastern daylight time, an experimental Sonerai 2 airplane, N1406, was substantially damaged when it was involved in an accident near Cynthiana, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA237Accident · Serious injuriesClass 3 · LimitedPreliminary reportAutogyro MT03 · San Jose, CAOn June 29, 2026, about 1148 Pacific daylight Time, a MTO Sport gyroplane, N423AG, was substantially damaged when it was involved in an accident at Reid-Hillview Airport (RHV), San Jose, California. The pilot was seriously injured, and the passenger received…NTSB ERA26LA262Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Easton, MDNTSB ERA26FA253Accident · 2 fatalClass 3 · FieldPreliminary reportBellanca 14-19-2 · Goldsby, OKOn June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…