NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…NTSB WPR17FA108Accident · 2 fatalField investigationFinal reportPiper PA 30 · Haines, AKThe pilot's decision to turn toward the inoperative engine after conducting a low-level pass, which resulted in an aerodynamic stall at too low an altitude to recover. Contributing to the accident was the pilot's decision to perform the flight and the engine…NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB GAA17CA310Accident · No injuriesData collectionFinal reportCessna A185 · Fall River Mills, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA308Accident · Minor injuriesData collectionFinal reportRobert Hamblin Autogyro Gmbh Cavalo · Fort Worth, TXThe pilot’s failure to maintain clearance from terrain.NTSB ERA17LA194Accident · No injuriesLimited investigationFinal reportAvions Mudry Cie CAP 231 · Lebanon, PAThe partial separation of one counterweight and the subsequent seizure of the engine due to mechanical interference. Contributing to the partial separation of the counterweight was the overstress fracture of a retaining ring and the fatigue fracture of the…NTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.NTSB ANC17FA026Accident · 2 fatalField investigationFinal reportArctic S 1B2 · Salcha, AKThe pilot's failure to maintain adequate airspeed while maneuvering in high winds, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the…NTSB WPR17LA113Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rockville, IDThe in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of engine power and a subsequent hard landing.NTSB WPR17LA110Accident · Minor injuriesLimited investigationFinal reportJohnson Glastar · Concord, CAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR17FA107Accident · 1 fatalField investigationFinal reportSchleicher ASW 28 18E · Ephrata, WAThe pilot's failure to maintain glider control while attempting to conduct an off-airport landing, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA17CA305Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Maxwell, CAThe pilot's failure to visually check the fuel quantity during the preflight inspection and ensure that sufficient fuel was onboard for the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA17WA193Accident · 1 fatalForeign investigationCessna 172 · Chernihiv, UkraineOn May 26, 2017, about 1200 coordinated universal time, a Cessna 172M, Ukrainian registration UR-WTA, was substantially damaged when it impacted a one-story building after takeoff from the Pivtsi Airport, Chernihiv, Ukraine. The pilot was fatally injured. The…NTSB CEN17LA205Accident · No injuriesLimited investigationFinal reportAmstutz Curtis J BD-5B · Portland, INA failure of the wiring between the engine control unit and the fuel injector, which resulted in a total loss of engine power.NTSB CEN17LA204Accident · Minor injuriesLimited investigationFinal reportAviat A-1B · Tomahawk Lake, WIThe pilot's failure to maintain a proper approach path, which resulted in the airplane’s hard landing and nose over after the water landing.NTSB CEN17FA197Accident · 2 fatalField investigationFinal reportAerotek Pitts S 2A · Sheboygan Falls, WIThe pilot's failure to maintain airplane control following a partial loss of engine power during a low-level aerobatic maneuver; the reason for the loss of engine power could not be determined during postaccident examination of the engine. Contributing to the…NTSB CEN17CA218Accident · Minor injuriesData collectionFinal reportCessna 177 · Plainwell, MIThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overrun.NTSB WPR17WA132Accident · No injuriesForeign investigationSikorsky S76 · Nilanga, IndiaOn May 25, 2017, at 0625 Universal Coordinated Time, a Sikorsky S76, VT-CMM, was substantially damaged when it impacted the ground following a collision with powerlines near the Nilana Helipad, Nilanga, Maharashtra, India. The helicopter was operated under…NTSB GAA17CA344Accident · No injuriesData collectionFinal reportEurocopter EC130 · Peach Springs, AZThe ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.NTSB ERA17FA190Accident · 1 fatalField investigationFinal reportEurocopter Deutschland EC 135 · New Castle, DEThe pilot's loss of helicopter control during a missed approach in instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB DCA17WA132Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions of…NTSB CEN17WA199Accident · 2 fatalForeign investigationPiper PA28R · Skipness/Kintyre, Scotland, United KingdomOn May 25, 2017, about 1300 hours universal coordinated time, a Piper PA-28R-201, United Kingdom registration G-CEOF, impacted the sea near Skipness/Kintyre, Scotland, United Kingdom. The two occupants on-board were fatally injured. The flight departed Oban…NTSB GAA17CA332Accident · No injuriesData collectionFinal reportCessna 208 · Elfin Cove, AKThe pilot’s failure to recognize the magnitude of the swell size during landing, which resulted in a tail-low hard water landing.NTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.NTSB ERA17LA189Accident · No injuriesLimited investigationFinal reportBeech 58 · Augusta, GAThe pilot’s failure to properly configure the airplane for landing. Contributing to the accident were the pilot’s fatigue and self-induced distractions.NTSB CEN17FA196Accident · 1 fatalField investigationFinal reportPiper J3C · Chetek, WIThe pilot's failure to maintain control of the airplane while flying at a low altitude, which resulted in the airplane exceeding the critical angle of attack and a subsequent aerodynamic stall.NTSB GAA17CA304Accident · No injuriesData collectionFinal reportMaule MX7 · Sidney, METhe pilot’s delayed application of rudder and failure to maintain directional control during takeoff.NTSB DCA17WA126Incident · No injuriesForeign investigationBoeing 777 · Multan, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on May 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…NTSB ANC17LA025Accident · Minor injuriesClass 3 · LimitedFinal reportAirbus AS350 · Juneau, AKThe pilot's decision to depart into an area of degraded visual meteorological and flat light conditions, which resulted in a loss of visual references and subsequent controlled flight into terrain.NTSB ANC17LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Noatak, AKA fire in the airplane's cabin, which initiated for reasons that could not be determined due to extensive thermal damage.NTSB GAA17CA311Accident · No injuriesData collectionFinal reportCessna 208 · Skagway, AKAn in-flight collision with a goose.NTSB GAA17CA296Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Eden Prairie, MNThe student pilot's loss of lateral control while practicing autorotations from a hover and the flight instructor's delayed remedial action, which resulted in a bounced landing and dynamic roll-over.NTSB DCA17CA123Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 132 · South Toledo Bend, TXan encounter with convective turbulence.NTSB GAA17CA306Accident · Minor injuriesData collectionFinal reportCessna 150 · Zepp, VAA partial loss of engine power due to the formation of carburetor icing, which resulted from the student pilot’s failure to apply carburetor heat and the flight instructor’s delayed response in applying carburetor heat while operating in conditions conducive…NTSB GAA17CA299Accident · No injuriesData collectionFinal reportThomas E Hudzinski Backcountry Super CR · Talkeetna, AKThe pilot’s failure to maintain a proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA17CA295Accident · Minor injuriesData collectionFinal reportFairchild 24R · Catlett, VAThe pilot’s selection of an unsuitable landing area, which resulted in the airplane impacting wheat stalks and a subsequent nose-over.NTSB GAA17CA292Accident · Minor injuriesData collectionFinal reportAirtime Cygnet · Casa Grande, AZThe flight instructor's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB ERA17LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · West Chester, PAAn engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.NTSB ERA17CA186Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Bristow, VAThe flight instructor’s and pilot’s mismanagement of the available fuel, which resulted in exhaustion of the fuel in the selected fuel tank and a subsequent total loss of engine power.NTSB DCA17LA122Accident · No injuriesLimited investigationFinal reportBoeing 757 · Raleigh, NCthe first officer's failure to attain a proper landing flare, which resulted in a tail strike.NTSB WPR17LA116Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/S · Pendelton, ORThe pilot’s failure to follow checklists to ensure the canopy was secured before takeoff.NTSB GAA17CA302Accident · No injuriesData collectionFinal reportCessna 175 · Prospect, ORThe flight instructor’s failure to attain an adequate climb rate during takeoff, which resulted in impact with trees.NTSB GAA17CA298Accident · No injuriesData collectionFinal reportSchweizer SGS233 · Springfield, VTThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway in trees.NTSB GAA17CA291Accident · No injuriesData collectionFinal reportCessna T182 · Carson City, NVThe pilot’s unstabilized approach during the landing flare and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA17WA192Accident · 1 fatalForeign investigationRobinson R22 · Kwa-Zulu Natal, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on May 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB ERA17LA188Accident · Minor injuriesLimited investigationFinal reportMaule M7 · Colton, NYThe pilots' initiation of an uncoordinated right turn with the fuel selector positioned to the right main fuel tank, which had a low quantity of fuel in it and resulted in a total loss of engine power due to the unporting of the fuel and subsequent fuel…NTSB ERA17CA187Accident · No injuriesData collectionFinal reportRobinson R22 · Linden, NJThe flight instructor's failure to maintain helicopter control while hovering, which resulted in skid contact with the ground and a dynamic roll-over.NTSB CEN17WA193Accident · 1 fatalForeign investigationQuicksilver GT500 · Barcelona, SpainOn May 20, 2017, at 1000 local time, a Quicksilver GT-500, EC-BQ3, impacted terrain after making a steep left turn during takeoff from Gurb Aerodrome in Barcelona, Spain. The aircraft was destroyed, and the pilot was fatally injured. The flight was being…NTSB CEN17LA192Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Canon City, COThe pilot’s loss of helicopter control on approach to land due to a vortex ring state (settling with power) condition, which resulted in a hard landing.NTSB WPR17LA106Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182P · Anderson, CALoss of engine power for reasons that could not be determined based on the available information.