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 GAA26WA170Incident · No injuriesClass 5 · ForeignPiper PA28 · Bankstown, AustraliaNTSB GAA26WA152Accident · No injuriesClass 5 · ForeignCessna 150 · Corrientes, ArgentinaNTSB ERA26LA163Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA31T · Ocean City, NJOn April 1, 2026, about 1635 eastern daylight time, a Piper PA-31T1, N96MA, was substantially damaged when it was involved in an accident near Ocean City, New Jersey. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Fellsmere, FLAn in-flight collision with a bird while descending to land at an airport.NTSB ERA26LA156Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Philadelphia, PAOn April 1, 2026, about 1541 eastern daylight time, a Piper PA-28-181, N494LA, was substantially damaged when it was involved in an accident near Philadelphia, Pennsylvania. The flight instructor received minor injuries, and the student pilot received serious…NTSB CEN26LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.NTSB GAA26WA199Accident · No injuriesClass 5 · ForeignCessna CE525 · Jeju Jeong-seok, South KoreaNTSB GAA26WA184Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Yorke Island, AustraliaNTSB GAA26WA145Accident · No injuriesForeign investigationBeech B100 · Panama City, PanamaNTSB GAA26WA144Accident · No injuriesClass 5 · ForeignCessna 182 · Pucallpa, PeruNTSB ERA26LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Mount Pleasant, SCThe airplane’s encounter with uneven terrain during takeoff, which resulted in a runway excursion and impact with water.NTSB ENG26WA021Incident · No injuriesForeign investigationSikorsky S92 · Rio de Janeiro, BrazilNTSB DCA26WA172Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD80 · La Guaira, VenezuelaNTSB DCA26WA169Incident · No injuriesClass 5 · ForeignAirbus A350-941 · Antogafasta, ChileNTSB GAA26WA161AccidentClass 5 · ForeignBeech 200 · Retford, United KingdomNTSB GAA26WA153Accident · Minor injuriesClass 5 · ForeignCessna T210 · Antônio João, BrazilNTSB ENG26WA025Incident · No injuriesClass 3 · ForeignAirbus A330-323 · Sao Paulo, BrazilNTSB ANC26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportWag Aero Sportsman · Cordova, AKThe pilot’s decision to land on an unsuitable snow-covered runway and his failure to maintain directional control during the landing roll which resulted in a nose over.NTSB GAA26WA142Accident · 1 fatalClass 5 · ForeignCessna 172 · Ausnek, NamibiaNTSB ERA26LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Greenville, SCAn in-flight collision with a bird during cruise flight.NTSB DCA26WA171Accident · Minor injuriesClass 5 · ForeignBoeing 737 · Reus, SpainNTSB DCA26WA170Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Balneario de Panticosa, SpainNTSB DCA26LA167Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean (Pacific Ocean)An unanticipated encounter with clear air turbulence while in cruise flight.NTSB CEN26LA154Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28F · Oelwein, IAThe pilot's failure to maintain directional control during the hover taxi with a quartering tailwind.NTSB CEN26LA152Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Boulder, COThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB CEN26LA151Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCB · Colorado Springs, COThe pilot’s failure to maintain directional control of the airplane during takeoff in gusty wind conditions, which resulted in a hard landing.NTSB WPR26LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Spanaway, WAThe pilot’s excessive application of brakes, which resulted in the airplane tipping forward onto its nose.NTSB GAA26WA171Accident · 1 fatalForeign investigationRobinson R44 · New Brunswick, CanadaNTSB ANC26LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Skwentna, AKThe pilot’s loss of directional control during landing roll due to contact with wind hardened snow berm and subsequent failure of main landing gear.NTSB WPR26LA145Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421B · Sedona, AZOn March 27, 2026, about 1630 Pacific daylight time, a Cessna 421B, N799TF, was substantially damaged when it was involved in an accident near Sedona, Arizona. The pilot and pilot rated passenger were not injured. The airplane was operated as a Code of…NTSB WPR26LA143Accident · No injuriesClass 4 · LimitedFinal reportPaul D Cannon Kitfox Light Squared · Lincoln, CAThe pilot's failure to properly flare the airplane during landing, which resulted in a hard landing and separation of the main landing gear. Contributing to the accident was the improper installation and over torquing of the landing gear attachment hardware,…NTSB WPR26FA141Accident · 3 fatalClass 3 · FieldPreliminary reportHughes 369D · Haena, HIOn March 26, 2026, about 1539 Hawaii standard time, a Hughes 369D helicopter, N715KV, was substantially damaged when it was involved in an accident near Haena, Hawaii. The pilot and one passenger sustained serious injuries, and three passengers were fatally…NTSB ERA26LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Daytona Beach, FLAn in-flight collision with a bird while enroute.NTSB ERA26LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Bessemer, ALThe pilot’s loss of directional control during the landing roll.NTSB CEN26LA153Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Arlington, TXThe pilot’s failure to maintain clearance from terrain during the hover taxi.NTSB CEN26LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Beloit, KSThe pilot’s failure to maintain directional control during the landing with a quartering headwind. Contributing to the accident was the pilot’s runway selection based on the variable and gusting wind conditions.NTSB WPR26LA144Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Los Angeles, CAThe pilot’s failure to maintain adequate clearance from a jet blast fence during taxi.NTSB GAA26WA140Accident · 1 fatalClass 5 · ForeignThrush S2R · San Juan, EcuadorNTSB DCA26WA166Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Bari, ItalyNTSB CEN26LA149Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA28 · Atlanta, TXOn March 26, 2026, about 0720 central daylight time, a Piper PA28-140 airplane, N1653J, was substantially damaged when it was involved in an accident near Atlanta, Texas. The pilot was not injured. The flight was operated under the provisions of Title 14 Code…NTSB GAA26WA139Accident · No injuriesClass 5 · ForeignPiper PA46 · Mayaguana, BahamasNTSB ERA26LA151Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Block Island, RIMaintenance personnel’s failure to ensure that the throttle cable was properly secured to the carburetor, which resulted an inflight separation of the throttle cable and the pilots’ inability to control the engine.NTSB DCA26WA220Occurrence · No injuriesClass 5 · ForeignBoeing 737-832 · San Miguel de Cozumel, MexicoNTSB CEN26FA147Accident · 1 fatalClass 3 · FieldPreliminary reportExperimental Homebuilt Airshark · Statesboro, GAOn March 25, 2026, about 1453 eastern daylight time, an experimental homebuilt Airshark airplane, N220AS, was substantially damaged when it was involved in an accident near Statesboro, Georgia. The pilot was fatally injured. The airplane was operated as a…NTSB GAA26WA155Incident · No injuriesClass 5 · ForeignDassault Falcon 20E-5 · Kecskemét, HungaryNTSB GAA26WA143Accident · Serious injuriesClass 5 · ForeignSikorsky S61 · Cheonan, South KoreaNTSB DCA26LA164Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Dulles, VAThe tug drivers improper positioning of the airplane during pushback, which resulted in the airplane’s jet blast impacting an active gate area during taxi and the subsequent injury to a maintenance technician. Contributing to the accident was the captain’s…NTSB CEN26LA148Accident · Serious injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Stonewall, TXOn March 24, 2026, about 0930 central daylight time, a Robinson R44 II helicopter, N233JD, was substantially damaged when it was involved in an accident near Stonewall, Texas. The pilot and passenger were seriously injured. The helicopter was operated as a…NTSB CEN26LA145Accident · No injuriesClass 4 · LimitedFinal reportClassic Waco YMF · Galveston, TXThe biplane pilot’s failure to maintain an adequate visual lookout while taxiing, which included the failure to perform S-turns to compensate for limited forward visibility.NTSB WPR26LA148Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Chula Vista, CAThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent runway excursion.