NTSB investigations
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 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 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 GAA26WA289Accident · No injuriesClass 4 · ForeignBeech B200 · Rio de Janeiro, BrazilNTSB ERA26LA226Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA44 · Opa-locka, FLNTSB ERA26LA225Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper J5C-65 · East Granby, CTOn June 2, 2026, at 1151 eastern daylight time, a Piper J3C-65, N331JM, was substantially damaged when it was involved in an accident near East Granby, Connecticut. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ENG26LA026Incident · No injuriesClass 3 · LimitedPreliminary reportCirrus SF50 · Athens, GAOn June 2, 2026, at 0945 eastern daylight time, a Cirrus SF50, N129KA, powered by a Williams International FJ33-5A turbofan engine, experienced an uncontained engine failure during climb from Greene County Regional Airport (KCPP), Greensboro, Georgia. There…NTSB CEN26LA217Accident · No injuriesClass 3 · LimitedPreliminary reportAutogyro Cavalon · Coffeyville, KSOn June 2, 2026, at 0837 central daylight time, an AutoGyro Cavalon gyroplane, N113CX, was substantially damaged when it was involved in an accident near Coffeyville, Kansas. The pilot was not injured. The gyroplane was operated as a Title 14 Code of Federal…NTSB ANC26LA047Accident · No injuriesClass 4 · LimitedInvestigation openBellanca 8GCBC · Salcha, AKNTSB WPR26LA209Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Casper, WYOn June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA208Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Pasco, WAThe pilot’s inadvertent excessive braking during the landing roll, which resulted in a nose over.NTSB WPR26LA207Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2 · Mettler, CAThe pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…NTSB GAA26WA293Accident · No injuriesClass 5 · ForeignChampion 8KCAB · Stockholm, SwedenNTSB GAA26WA206Accident · 4 fatalClass 5 · ForeignCessna TU206 · La Macarena, ColombiaNTSB GAA26WA205Accident · 1 fatalClass 5 · ForeignCessna 152 · Valbrembo, ItalyNTSB CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.NTSB WPR26LA214Accident · Serious injuriesClass 3 · LimitedPreliminary reportMooney M20J · Albuquerque, NMOn May 31, 2026, at 1515 mountain daylight time, a Mooney M20J, N555ED, sustained substantial damage when it was involved in an accident near Albuquerque, New Mexico. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA202Accident · 1 fatalClass 3 · FieldPreliminary reportPipistrel D O O Sinus 912 · Columbus, MSOn May 31, 2026, about 1236 central daylight time, a Pipistrel D O O Sinus 912, N1277P, was destroyed when it was involved in an accident near Columbus, Mississippi. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA214Accident · No injuriesClass 5 · ForeignBeech 200 · Vitoria, BrazilNTSB CEN26LA215Accident · No injuriesClass 4 · LimitedFinal reportEaa Acro Sport II · Sheridan, ARThe pilot’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC26LA050Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Steele Creek, AKNTSB ANC26LA046Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-125 · South Van Horn, AKNTSB WPR26LA364Accident · No injuriesClass 3 · LimitedInvestigation openCirrus Design SR20 · Phoenix, AZNTSB WPR26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Robbins, CAOn May 30, 2026, about 0900 Pacific daylight time, an Air Tractor AT-602, N5111A, was substantially damaged when it was involved in an accident near Robbins, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB ERA26LA223Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210 · Loíza, PROn May 30, 2026, about 0744 Atlantic standard time, a Cessna T210, N210PL, was substantially damaged when it was involved in an accident near Loiza, Puerto Rico. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA209Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Jonesboro, ARThe student pilot's failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot’s decision to practice slow flight maneuvers at an…NTSB CEN26LA208Accident · Minor injuriesClass 3 · LimitedPreliminary reportAmerican AA-1A · Amery, WIOn May 30, 2026, about 1113 central daylight time, a Grumman AA-1A airplane, N6416L, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN26FA207Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Dawsonville, GAOn May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had…NTSB WPR26LA205Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 208B · Shelton, WANTSB GAA26WA331Accident · 1 fatalClass 5 · ForeignSocata Rallye 100S · Roquebrune-sur-Argens, FranceNTSB GAA26WA204Accident · No injuriesClass 5 · ForeignPiper PA28RT · Liverpool, United KingdomNTSB ERA26LA224Accident · Serious injuriesClass 3 · LimitedPreliminary reportBoeing E75 · Dresden, OHOn May 29, 2026, about 1153 eastern daylight time, a Boeing E75, N181RF, was substantially damaged when it was involved in an accident near Dresden, Ohio. The pilot and passenger were seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA221Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Pembroke Pines, FLOn May 29, 2026, at 1138 eastern daylight time, a Cessna 172P, N96100, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor sustained serious injuries. The student pilot sustained minor injuries.…NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA206Accident · No injuriesClass 4 · LimitedFinal reportPitts Special S-1S · Bartlesville, OKThe pilot’s failure to maintain control during the landing rollout and subsequent aborted landing.NTSB WPR26LA206Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cascade, IDThe pilot’s improper approach, which resulted in a faster than normal touchdown and subsequent runway overrun.NTSB GAA26WA287Incident · No injuriesClass 5 · ForeignCessna 182 · San Antonio, ColombiaNTSB GAA26WA203Incident · No injuriesClass 5 · ForeignCirrus SR22 · Nyíregyháza, HungaryNTSB ERA26LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Chesapeake, VAThe pilot’s improper decision to continue with an unstabilized approach, which resulted in a hard landing, loss of directional control, and collision with a runway marker light and sign.NTSB CEN26LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Dickinson, NDThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions which resulted in a hard landing.NTSB CEN26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportMustang Aeronautics Mustang II · Richmond, TXOn May 28, 2026, about 1440 central daylight time, a Mustang Aeronautics Mustang II airplane, N160MT, sustained substantial damage when it was involved in an accident near Richmond, Texas. The pilot sustained minor injuries. The airplane was operated as a…NTSB ANC26LA045Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · Bethel, AKNTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA26WA201Incident · No injuriesClass 5 · ForeignPiper PA28 · Aguadulce District, PanamaNTSB ERA26LA219Accident · Serious injuriesClass 3 · LimitedPreliminary reportRainbow Cheetah XLS · Knightdale, NCOn May 27, 2026, about 1420 eastern daylight time, a special light sport Rainbow Cheetah XLS airplane, N146RC, was substantially damaged when it was involved in an accident near Knightdale, North Carolina. The flight instructor and student pilot were…NTSB ERA26LA218Accident · No injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G600 · Birmingham, ALThe flight crew’s decision to continue the landing approach into adverse weather conditions, which resulted in a loss visual reference and loss airplane control during landing.NTSB ENG26WA024Incident · No injuriesClass 5 · ForeignGulfstream Aerospace G-IV · Dushanbe, TajikistanNTSB DCA26WA238IncidentClass 5 · ForeignBoeing 737 · Sidi Errabia, AlgeriaNTSB CEN26LA203Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Fort Worth, TXThe flight instructor’s delayed remedial action and the student pilot’s failure to maintain helicopter control during hover.NTSB CEN26LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Naubinway, MIThe pilot’s improper engine power application during the landing flare, which resulted in a hard, bounced landing and nose over.NTSB CEN26LA199Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Blair, NEOn May 27, 2026, about 1130 central daylight time, a Cessna A188B airplane, N84497, sustained substantial damage when it was involved in an accident near Blair, Nebraska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Fitchburg, MAThe pilot’s improper landing flare, which resulted in a hard landing.