NTSB investigations
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 DCA25WA154Incident · No injuriesClass 5 · ForeignBoeing 737-400 · Bogotá, ColombiaNTSB DCA25LA156Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · San Diego, CAAn encounter with an area of moderate clear air turbulence associated with the jet stream during cruise.NTSB ANC25LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain an appropriate airspeed during the landing approach, which resulted in exceedance of the critical angle of attack and an aerodynamic stall, during gusting wind conditions.NTSB GAA25WA110Accident · No injuriesClass 5 · ForeignBeech C90 · Araguatins, BrazilNTSB ERA25LA132Accident · No injuriesClass 3 · LimitedPreliminary reportTextron 172 · New Smyrna Beach, FLOn March 1, 2025, about 1138 eastern standard time, a Cessna 172S, N923EP, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB DCA25FA148Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 767 · Newark, NJOn March 1, 2025, at 0800 eastern standard time, FedEx flight 3609, a Boeing 767-300F, powered by two General Electric CF6-80C2 turbofan engines, registration number N178FE, struck birds during initial climb after takeoff from Newark Liberty International…NTSB CEN25FA106Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV7 · Matheson, COOn March 1, 2025, about 1215 mountain daylight time, a Vans RV7 experimental airplane, N902T, was destroyed when it was involved in an accident near Matheson, Colorado. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB GAA25WA112Accident · Serious injuriesClass 5 · ForeignJodel D140 · Chamonix, FranceNTSB ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.NTSB CEN25LA107Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Alvord, TXA total loss of engine power for a reason that could not be determined.NTSB ANC25LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchor Point, AKA complete loss of engine power as a result of carburetor ice due to the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ANC25LA021Accident · Minor injuriesClass 3 · LimitedFinal reportGippsland GA-8 · Lihue, HIThe failure of the right landing gear leg due to a fatigue crack, which resulted in its separation from the airplane during taxi. Contributing to the accident, was the mechanic’s inadequate inspection of the landing gear leg during the last maintenance…NTSB WPR25LA106Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Heber City, UTThe pilot’s loss of directional control during landing, which resulted in a collision with a snowbank.NTSB GAA25WA101Accident · No injuriesClass 5 · ForeignCessna 210 · Santa Ana, Beni, BoliviaNTSB CEN25LA105Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Edgemont, SDThe pilot’s failure to properly identify the proper anchor point for the supplemental harness and the crew’s incorrect use of the restraint system structure as an anchor point, which resulted in the separation of the structure.NTSB CEN25FA104Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Uvalde, TXOn February 27, 2025, about 1319 central standard time, a Robinson Helicopter Company (RHC) R44 helicopter, N144SG, sustained substantial damage when it was involved in an accident near Uvalde, Texas. The commercial pilot and the passenger sustained fatal…NTSB OPS25LA025IncidentClass 4 · LimitedInvestigation openBoeing 737-823 · Goodyear, AZNTSB GAA25WA103Accident · No injuriesClass 5 · ForeignCessna 150 · Landshut, GermanyNTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.NTSB ERA25LA130Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Manchester, VTThe pilot’s improper decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall/spin.NTSB DCA25WA150IncidentClass 5 · ForeignAirbus A330-343 · Hong Kong, Hong Kong SAR ChinaNTSB GAA25WA111Accident · No injuriesClass 5 · ForeignPiper PA-25-150 · Pinzon, ArgentinaNTSB GAA25WA102Accident · No injuriesClass 5 · ForeignCessna 152 · San Rafael, ArgentinaNTSB ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB ERA25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportIcon A5 · Smithville, TNThe pilot’s failure to retract the landing gear prior to landing in water. Contributing to the accident was the pilot’s failure to use the manufacturer’s provided checklist.NTSB ERA25LA131Accident · No injuriesClass 4 · LimitedFinal reportMallory Horton AQUA-BEE · Miami, FLThe pilot’s failure to lower the landing gear before touchdown.NTSB ERA25LA126Accident · Serious injuriesClass 3 · LimitedPreliminary reportEurocopter Deutschland EC 135 P2+ · Hampstead, NCOn February 24, 2025, about 1945 eastern standard time, a Eurocopter Deutschland GMBH EC 135P2+, N930NH, was destroyed when it was involved in an accident near Hampstead, North Carolina. The pilot, flight paramedic, and flight nurse were seriously injured.…NTSB DCA25LA141Occurrence · No injuriesClass 3 · LimitedPreliminary reportBoeing 737-800 · Chicago, ILOn February 25, 2025, about 0848 central standard time (CST), Flexjet flight 560 (LXJ 560), a Bombardier Challenger 350 CL-35, registration N560FX and Southwest Airlines flight 2504 (SWA2504), a Boeing 737-800, registration N8517F, were involved in a runway…NTSB DCA25LA139Incident · Minor injuriesClass 3 · LimitedPreliminary reportBoeing 717 · Atlanta, GAOn February 24, 2025, at 0848 eastern standard time, Delta Air Lines flight 876, a Boeing 717-200, N942AT, experienced smoke in the cabin and cockpit during takeoff from Atlanta Hartsfield/Jackson International Airport (ATL), Atlanta Georgia. The airplane…NTSB CEN25LA103Accident · Minor injuriesClass 3 · LimitedPreliminary reportStarduster II · Azle, TXOn February 24, 2025, at 1430 central standard time, a Starduster II airplane, N78WT, was destroyed when it was involved in an accident near Azle, Texas. The private pilot and a passenger received minor injuries. The airplane was operated as a Title 14 Code…NTSB CEN25LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Iron River, MIThe airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.NTSB WPR25LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · La Verne, CAThe failure of the right main landing gear tubular spring due to a fatigue crack that originated at the airframe connecting bolt hole and progressed to an overstress fracture.NTSB ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.NTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB ERA25LA125Accident · No injuriesClass 4 · LimitedFinal reportC K ING Adventure CCX-2000 · Okeechobee, FLA separation of the left main landing gear during landing.NTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.NTSB WPR25LA101Accident · No injuriesClass 3 · LimitedFinal reportHughes OH-6A · Santa Teresa, NMThe flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.NTSB ERA25LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Mayo, MDA total loss of engine power at low altitude due to an accumulation of carburetor ice while in a cruise-power descent, which resulted in a forced landing.NTSB DCA25WA158IncidentClass 5 · ForeignBoeing 737-8MAX 200 · Marrakesh, MadagascarNTSB WPR25LA103Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.NTSB ANC25LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKA total loss of engine power for undetermined reasons.NTSB WPR25LA105Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Cottonwood, AZThe pilot undergoing instructions’ loss of aircraft control during landing, and the flight instructor’s failure to promptly intervene.NTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.NTSB WPR25FA100Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 505 · Ririe, IDThe pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.NTSB GAA25WA107AccidentClass 5 · ForeignCessna C185-A · Samburu, KenyaNTSB GAA25WA099Accident · 2 fatalClass 5 · ForeignVans RV7 · Nizhny Novgorodr, RussiaNTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB ENG25WA025Incident · No injuriesClass 5 · ForeignLeonardo AW139 · Rio de Janeiro, BrazilNTSB CEN25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Farlinville, KSA loss of engine power that resulted from fuel contamination when it was treated with a 70% isopropyl alcohol solution (antiseptic) that contained water. Contributing to the accident were vague fuel treatment instructions provided by the operator.NTSB ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.