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 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 GAA26WA265Accident · 1 fatalClass 5 · ForeignRobinson R44 · RorainóPolis, BrazilNTSB DCA26WA297IncidentClass 5 · ForeignBoeing 737 · Barcelona, SpainNTSB 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 GAA26WA249Accident · 10 fatalClass 3 · ForeignCessna 402C · Nicholls Town, BahamasNTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.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 DCA26WA284IncidentClass 5 · ForeignAirbus A321 · San Andrés, SpainNTSB 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 CEN26LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Ellsworth, KSThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.NTSB WPR26LA253Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Marbleton, WYNTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB DCA26WA277IncidentClass 5 · ForeignAirbus A320 · Longford, United KingdomNTSB DCA26WA275IncidentClass 5 · ForeignBoeing 737 · Dorval, CanadaNTSB 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 WPR26LA273Accident · Minor injuriesClass 4 · LimitedInvestigation openSchweizer SGS 2-33A · Boulder, CONTSB WPR26LA259Accident · No injuriesClass 4 · LimitedInvestigation openNoel Simmons RV-8 · Monte Vista, CONTSB 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 WPR26LA250Accident · No injuriesClass 4 · LimitedInvestigation openAeronca 7AC · Buffalo, WYNTSB 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 GAA26WA245Accident · Serious injuriesClass 5 · ForeignAyres S2R · La Lima, HondurasNTSB DCA26WA281Accident · No injuriesClass 5 · ForeignMcdonnell Douglas MD80 · Dachi Su, KyrgyzstanNTSB DCA26WA276IncidentClass 5 · ForeignBoeing 767 · enroute, FranceNTSB DCA26WA273Accident · No injuriesClass 5 · ForeignDouglas DC9 · Dachi Su, KyrgyzstanNTSB DCA26WA272IncidentClass 5 · ForeignBoeing 787 · Pasay City, PhilippinesNTSB DCA26WA267Accident · No injuriesClass 3 · ForeignBoeing 737 · Arabian Sea, PakistanNTSB CEN26LA246Accident · Minor injuriesClass 4 · LimitedFinal reportRotec Engineering Rally 3 · Hooker, OKThe total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.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 GAA26WA259Accident · Serious injuriesClass 5 · ForeignPiper PA31T · Navegantes, BrazilNTSB ERA26LA259Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Hickman, KYThe pilot’s failure to maintain a proper glide path, which resulted in a runway undershoot.NTSB DCA26LA270Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A321-231 · Somerset, CONTSB WPR26LA252Accident · Serious injuriesClass 4 · LimitedFinal reportFairchild M-62A · Greenleaf, IDThe pilot’s failure to maintain proper airspeed during approach and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.NTSB 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 WPR26LA243Accident · No injuriesClass 4 · LimitedInvestigation openValerie Westedt Zenith Zodiac 650B · Peyton, CONTSB GAA26WA332Accident · 1 fatalClass 5 · ForeignRobin DR400 · Alençon, FranceNTSB ERA26LA263Accident · Serious injuriesClass 4 · LimitedFinal reportRyan Navion A · Newport, NHThe pilot’s failure to attain an appropriate touchdown point, which resulted in a runway overrun.NTSB ERA26LA261Accident · No injuriesClass 4 · LimitedFinal reportKodiak Kodiak 100 · New York, NYAn inadvertent collision with a large wave during touchdown on a river, which resulted in a subsequent bounce and hard landing.NTSB DCA26WA262Incident · No injuriesClass 4 · ForeignBoeing 737 · Bogotá, ColombiaNTSB CEN26LA244Accident · Serious injuriesClass 4 · LimitedFinal reportCassutt Iiim · Odessa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…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 WPR26LA248Accident · No injuriesClass 4 · LimitedFinal reportDean J Irvin KFA Safari XL · Saratoga, WYThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB WPR26LA247Accident · Serious injuriesClass 4 · LimitedInvestigation openBell 47G · Springtown, TX