NTSB investigations, 2017
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 year(c.\"eventDate\") = 2017 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 year(c."eventDate") = 2017 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 DCA17CA064Accident · No injuriesData collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCcollision with a deer during takeoff.NTSB CEN17FA103Accident · 2 fatalField investigationFinal reportBell Helicopter Textron Canada 429 · Shreveport, LAThe pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.NTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.NTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.NTSB CEN17LA121Accident · No injuriesLimited investigationFinal reportBeech C90A · Rattan, OKThe loss of electrical power due to the pilot’s inadvertent selection of the engine start switches and the subsequent fuel exhaustion to the left engine as the pilot attempted to locate visual meteorological conditions. Contributing to the accident were the…NTSB CEN17LA104Accident · No injuriesLimited investigationFinal reportBeech D55 · Columbus, OHThe partial loss of left engine power during takeoff and initial climb, which led to a hard landing in gusting crosswind conditions. The reason for the loss of engine power could not be determined because postaccident examination of the left engine revealed…NTSB GAA17CA141Accident · No injuriesData collectionFinal reportCessna 170 · Wheatland, WYThe flight instructor’s incorrect compensation for the gusting crosswind during the landing roll, which resulted in a loss of directional control and runway excursion.NTSB DCA17WA152Incident · No injuriesForeign investigationBoeing 737 · Baraloche, ArgentinaThe Junta de Investigacion de Acidentes de Aviacion Civil (JIAAC) of Argentina has notified the NTSB of an incident involving a Boeing 737-800, which occurred on February 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC…NTSB DCA17CA071Accident · Serious injuriesData collectionFinal reportBombardier DHC 8 311 · Dulles, VAan inadvertent encounter with clear air turbulence.NTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.NTSB ERA17WA104Accident · 5 fatalForeign investigationRobinson R66 · Lake Teletskoye, RussiaOn February 12, 2017, at 1319 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-06375, was substantially damaged when it crashed into Lake Teletskoye, Republic of Altai, Russia. The pilot and four passengers were fatally injured.…NTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB DCA17CA072Accident · Serious injuriesData collectionFinal reportBoeing 737 76N · Phoenix, AZthe catering agent's lack of situational awareness when exiting the airplane that resulted in a serious injury.NTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.NTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.NTSB DCA17WA070Incident · No injuriesForeign investigationBoeing 777 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau (AIB) of Saudi Arabia has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on February 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AIB's investigation under…NTSB CEN17WA107Accident · No injuriesForeign investigationCessna 402C · Virgin Gorda, British Virgin IslandsOn February 11, 2017, at 2004 UTC, a Cessna 402C, N603AB, experienced brake failure during landing roll and impacted terrain at the Virgin Gorda Airport (TUPW), British Virgin Islands. The pilot and 8 passengers on board were not injured. The airplane…NTSB ENG17WA013Incident · No injuriesForeign investigationBritish Aerospace Avro 146-RJ100 · London, United KingdomThe United Kingdom's Air Accidents Investigation Board (AAIB) has notified the NTSB of an incident involving an AVRO 146-RJ100 that occurred on February 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB CEN17WA109Accident · 3 fatalForeign investigationCessna TU206G · Tamazula, MexicoOn February 10, 2017, about 1850 hours universal coordinated time, a Cessna model TU206G single-engine airplane, serial number U20605373, Mexican registration XA-UIL, crashed shortly after takeoff from Alizal Airport (MX-0092), located near Tamazula, Durango,…NTSB ANC17RA055Incident · No injuriesForeign investigationCessna 172 · Giseong-ri, South KoreaOn February 10, 2017, about 0952 local time, a Cessna 172 airplane, Republic of Korea registration number HL1171, operated by a flight school, sustained minor damage following a forced landing in a shallow river near Giseong-ri, Republic of Korea. The pilot…NTSB CEN17LA113Accident · Serious injuriesLimited investigationFinal reportBell-Transworld Helicopters 47D1 · Archer City, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadvertent positioning of the mixture control to the “fuel cutoff” position.NTSB ANC17LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA18 · Sterling, AKThe pilot’s loss of control while maneuvering for reasons that could not be determined based on the available information.NTSB GAA17CA135Accident · No injuriesData collectionFinal reportHughes OH 6A · Price, UTThe fuel truck driver’s failure to stop before impacting the helicopter’s main rotor blades.NTSB ENG17WA012Incident · No injuriesForeign investigationAirbus A320 · Dehli, IndiaOn February 8, 2017, about 1932 local (1402 UTC), a Go Air (Indian air carrier) A320 equipped with Pratt & Whitney PW1127G engines experienced a loss of power in the No. 1 engine. The airplane had to return to Delhi immediately after takeoff because of a low…NTSB CEN17WA382Accident · 2 fatalForeign investigationCessna 152 · Praia de São João – Caparica – Portugal, PortugalOn August 2, 2017, at 1551 universal coordinated time, a Cessna 152, CS-AVA, experienced a loss of engine power during cruise flight. A forced landing was performed on a beach near Praia de São João da Caparica, Portugal. During the landing, the airplane…NTSB ERA17WA111Accident · No injuriesForeign investigationSaab 340 · Freeport, BahamasThe government of Bahamas has notified the NTSB of an accident involving a SAAB 340 airplane that occurred on February 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB ERA17LA103Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC 135 · Beattyville, KYThe pilot's failure to maintain helicopter control while landing, which resulted in a hard landing and subsequent roll over.NTSB CEN17WA380Incident · No injuriesForeign investigationSchweizer 269C · Locarno, SwitzerlandOn February 7, 2017, about 1016 universal coordinated time (UTC), a Schweizer 269C helicopter, Swiss registration HB-XFQ, conducted a precautionary landing near Locarno (LSZL), Switzerland, after the engine oil pressure was at minimum pressure and the oil…NTSB CEN17WA102Accident · 4 fatalForeign investigationMD Helicopter 600 · Guatemala City, GuatemalaOn February 7, 2017, about 1253 local time, a United States-registered MD 600N helicopter, N245SE, impacted terrain at the La Aurora International Airport, Guatemala City, Guatemala. The pilot and three passengers were fatally injured. The investigation is…NTSB CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.NTSB GAA17CA150Accident · No injuriesData collectionFinal reportBeech F90 · Poplar Bluff, MOThe pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.NTSB ERA17LA102Accident · Serious injuriesClass 3 · LimitedFinal reportShell John Super SIX · Morganton, NCA loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.NTSB ERA17LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Friendly, MDA total loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17CA101Accident · No injuriesData collectionFinal reportRobinson R22 · West Palm Beach, FLThe flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.NTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB ERA17CA099Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Fallston, MDThe student pilot's failure to relinquish the flight controls to the flight instructor, which resulted in a collision with terrain.NTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.NTSB DCA17WA067Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…NTSB CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.NTSB GAA17CA132Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206 · Carson City, NVThe pilot-in-command’s delayed remedial action to arrest the right yaw after the bounced landing while operating in a flight regime conducive to the loss of tail rotor effectiveness, which resulted in a roll-over.NTSB WPR17LA061Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 B55 (T42A) · Cameron Park, CAFailure of the landing gear to extend as a result of excessive wear within the landing gear gearbox and motor, which resulted in a gear-up landing.NTSB WPR17LA059Accident · Minor injuriesLimited investigationFinal reportBeech E 55 · Bakersfield, CAThe pilot’s failure to select the proper fuel boost pump setting for the left auxiliary fuel pump, which allowed for an excessive fuel flow to the left engine, which resulted in a total loss of engine power and airplane control during an attempted go-around.NTSB ERA17LA105Accident · No injuriesLimited investigationFinal reportS C Aerostar S A YAK 52 · St. Elmo, ALThe failure of the right main landing gear uplock actuator due to corrosion.NTSB DCA17WA069Incident · No injuriesForeign investigationBoeing 737 · Yogykarta, IndonesiaThe National Transportation Safety Committee (NTSC) of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC's…NTSB CEN17LA098Accident · No injuriesLimited investigationFinal reportRobinson Michael E Cozy Mark IV · Anthony, NMA total loss of engine power during climbout for reasons an examination of the engine and fuel system was not able to determine, which resulted in a forced landing on unsuitable terrain.NTSB GAA17CA130Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Armstrong, TXThe pilot’s failure to remove the left helicopter skid tie-down before takeoff, which resulted in dynamic roll-over.NTSB CEN17LA096Accident · Serious injuriesLimited investigationFinal reportCook Smith Aviation Repli · Justin, TXA total loss of engine power due to fuel starvation as the result of a disruption in fuel flow.NTSB CEN17FA095Accident · 1 fatalField investigationFinal reportCessna 177 · Price, TXThe pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.NTSB GAA17CA134Accident · No injuriesData collectionFinal reportCessna 180 · Tyonek, AKThe pilot’s improper decision to land on a snow-covered airstrip with a tundra tire-equipped airplane, which resulted in a nose-over.NTSB ERA17LA098Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Pottsville, PAA total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.