Final NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE c.\"completionStatus\" = 'Completed' 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 WHERE c."completionStatus" = 'Completed' 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 ANC26LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Centennial, COThe student pilot’s failure to maintain adequate airspeed during the flare which resulted in the airplane exceeding its critical angle of attack and aerodynamic stall at a low altitude and loss of airplane control.NTSB WPR26LA173Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Salinas, CAThe flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA165Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7FC · Bend, ORThe pilot’s failure to maintain directional control during landing roll. Contributing to the accident was the rotor wash from a nearby helicopter.NTSB ERA26LA182Accident · No injuriesClass 4 · LimitedFinal reportDonald E Johnston Velocity XL-RG · Crestview, FLThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.NTSB CEN26LA168Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mount Blanco, TXThe pilot’s failure to maintain proper main rotor rpm during a low-level turn, which resulted in the main rotor rpm drooping, a loss of control at an altitude too low for recovery, and a subsequent impact with terrain.NTSB CEN26LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Topeka, KSThe student pilot’s failure to maintain situational awareness while taxiing which resulted in a collision with fence poles on either side of a gate which was not intended for airplanes.NTSB ERA26LA181Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Mfg SP Z O O A32 · Lexington, KYThe flight instructor’s improper in-flight fuel management, which resulted in fuel starvation, a total loss of engine power, and a forced landing to rough terrain.NTSB DCA26LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Providence, RIThe airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant.NTSB ANC26LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna U206F · Juneau, AKA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB ERA26LA176Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Levittown, PRAn oil line separation at a barbed fitting in an experimental airplane, which resulted in a total loss of engine power due to oil starvation.NTSB CEN26LA165Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Peyton, COThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.NTSB WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.NTSB ERA26LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · The Rock, GAThe pilot’s improper landing flare, which resulted in a hard, porpoised landing.NTSB ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB ERA26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Naples, FLThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA26LA173Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Stevensville, MDThe pilot’s inadvertent retraction of the landing gear lever during the landing roll, which resulted in a gear collapse and runway excursion.NTSB ERA26LA170Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Jacksonville, FLThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.NTSB WPR26LA156Accident · No injuriesClass 4 · LimitedFinal reportMarshall Daniel R L-21 · Cody, WYThe pilot's failure to maintain control of the airplane during the landing rollout, which resulted in a nose-over.NTSB CEN26LA166Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Colorado Springs, COMaintenance personnel's installation of an oversized tire, which prevented the left main landing gear from extending resulting in a precautionary gear up landing.NTSB ANC26LA025Accident · No injuriesClass 4 · LimitedFinal reportAvid Avid Flyer · Anchorage, AKThe pilot’s failure to maintain directional control while maneuvering onto the runway for takeoff. Contributing to the accident was the presence of heavy, wet snow adjacent to the runway.NTSB CEN26LA161Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Seguin, TXThe failure of the landing gear weldment that resulted in separation of the right main landing gear.NTSB CEN26LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tahlequah, OKThe student pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.NTSB CEN26LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Burke, TXThe airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.NTSB WPR26LA146Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Chimney Rock, MTThe pilot’s failure to maintain adequate clearance from the terrain while performing a low altitude circling takeoff maneuver, which resulted in a dynamic rollover.NTSB ERA26LA193Accident · No injuriesClass 4 · LimitedFinal reportBell UH1 · Enterprise, ALThe in-flight separation of a turn lock fastener stud, which resulted in substantial damage to one tail rotor blade.NTSB CEN26LA163Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Wichita, KSThe flight crew’s failure to ensure that the rear cargo door was properly latched before flight.NTSB CEN26LA158Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Luverne, MNThe pilot’s failure to maintain directional control during a gusting crosswind landing, and the flight instructor’s delayed remedial action.NTSB ERA26LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Fellsmere, FLAn in-flight collision with a bird while descending to land at an airport.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 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 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 ERA26LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Greenville, SCAn in-flight collision with a bird during cruise flight.NTSB 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 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 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 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 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 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 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.NTSB WPR26LA137Accident · No injuriesClass 4 · LimitedFinal reportSalt Lake Gyrocopters Calidus · Fairfield, UTThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was nose wheel misalignment at touchdown.