NTSB investigations
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 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.NTSB ERA26FA214Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-25-235 · Saratoga Springs, NYOn May 26, 2026, about 1347 eastern daylight time, a Piper PA-25-235 airplane, N8656L, was substantially damaged when it was involved in an accident near Saratoga Springs, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB CEN26FA197Accident · 1 fatalClass 3 · FieldPreliminary reportFokker DR1 Replica · Frankston, TXOn May 26, 2026, about 0810 central daylight time, an experimental Fokker DR1 airplane, N54517, was destroyed when it was involved in an accident near Frankston, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA201Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican AA1 · Cowley, WYThe pilot's improper landing flare and subsequent loss of directional control during landing.NTSB CEN26LA201Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172H · Berryville, ARThe pilot in command’s decision to continue the takeoff when the airplane was not airborne at midfield, and the student pilot’s likely improper technique that resulted in a lack of sufficient climb performance and subsequent loss of control.NTSB ANC26LA044Accident · Minor injuriesClass 3 · LimitedPreliminary reportSling Sling LSA · Makanalua, HIOn May 25, 2026, about 1110 Hawaii-Aleutian Standard time, a Sling Aircraft LSA, N83PF, was substantially damaged when it was involved in an accident near Kalaupapa, Hawaii Airport (LUP). The two pilots onboard sustained minor injuries. The airplane was…NTSB GAA26WA244Accident · 2 fatalClass 5 · ForeignMaxair MU582 · Tel Adashim, IsraelNTSB ENG26LA023IncidentClass 4 · LimitedInvestigation openBombardier BD-700-1A10 · Atlantic City, NJNTSB DCA26WA221OccurrenceClass 5 · ForeignAirbus A321 · Stuarts Creek, AustraliaNTSB CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA196Accident · No injuriesClass 4 · LimitedFinal reportGuenther Glen A Searey LSX · Briarcliff, TXThe pilot's failure to maintain sufficient altitude and aircraft control during the base to final turn, which resulted in the airplane impacting the water. Contributing to the accident was reported downdraft wind conditions.NTSB WPR26LA203Accident · No injuriesClass 4 · LimitedFinal reportPzl-Swidnik PW-5 · Soap Lake, WAThe pilot’s failure to ensure the proper preflight assembly of the glider's wing attachment system, which resulted in substantial damage to the wing structure during flight.NTSB WPR26LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206-L4 · Cedar City, UTThe flight instructor's failure to maintain helicopter control while manipulating the engine governor reference rpm adjustment during hover operations, which resulted in a loss of control and impact with the ground.NTSB WPR26FA198Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Woodlake, CAOn May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91…NTSB ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.NTSB ERA26LA216Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Doerun, GAOn May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26LA198Accident · No injuriesClass 4 · LimitedFinal reportCommander 114TC · Woodruff, WIThe pilot’s failure to maintain airplane control during the go-around.NTSB ERA26LA215Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron 172S · Jupiter Farms, FLOn May 22, 2026, about 1518 eastern daylight time, a Textron Aviation 172S, N294PL, was substantially damaged when it was involved in an accident near Jupiter Farms, Florida. The flight instructor and student pilot were not injured. The airplane was operated…NTSB DCA26WA222OccurrenceClass 5 · ForeignBoeing 737 · Marrakech, MoroccoNTSB CEN26LA202Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-32R-300 · Comanche, TXOn May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA195Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Littlefield, TXThe pilot's excessive approach speed, which resulted in a hard, bounced landing and nose-over.NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB GAA26WA247Accident · No injuriesClass 5 · ForeignPiper PA28 · Roszczep, PolandNTSB GAA26WA215Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pomerode, BrazilNTSB ERA26LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGranito Joseph R RV-7A · Jaffrey, NHThe pilot’s failure to maintain directional control of the airplane during landing, which resulted in a touchdown off the paved runway surface and a collision with terrain during the subsequent aborted landing.NTSB GAA26WA211Accident · No injuriesClass 5 · ForeignNew Glasair Glasair Super II · Aquidauana, BrazilNTSB CEN26LA221Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S-2R · Gause, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the separated wing fuel tank screen and sealant debris in the fuel tank.NTSB CEN26LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Northport, MIThe pilot's decision to resume taxiing on a turf runway that was unable to adequately support the airplane's weight, which resulted in the nose landing gear sinking into the soft ground and the propeller striking the terrain.NTSB CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN26LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rice Lake, WIThe pilot’s failure to maintain directional control during landing.NTSB ANC26LA043Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18A 150 · Tyonek, AKNTSB WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.NTSB ERA26LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Statesville, NCThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB CEN26FA192Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172N · Westerly, RIOn May 18, 2026, about 1205 eastern daylight time, a Cessna 172N, N733CP, was substantially damaged when it was involved in an accident near Westerly, Rhode Island. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…