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 GAA17CA184Accident · No injuriesData collectionFinal reportCSP Leasing Cavalon · Santa Maria, CAThe student pilot’s improper landing flare and subsequent failure to maintain crosswind correction during landing in crosswind conditions.NTSB ERA17WA127Accident · 7 fatalForeign investigationSikorsky S76 · Istanbul, TürkiyeOn March 10, 2017, at 0821 coordinated universal time, a Sikorsky S-76C++ helicopter, Turkish registration TC-HEZ, was destroyed shortly after takeoff from the Istanbul Ataturk Airport (LTBA), Istanbul, Turkey. The two pilots and the five passengers were…NTSB DCA17CA079Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · Dallas-Fort Worth (DFW), TXan inadvertent encounter with convective turbulence.NTSB GAA17CA183Accident · Minor injuriesData collectionFinal reportJohnson Jerry WAG Aero/SPT Trainer · Hendersonville, NCThe pilot’s unstabilized approach and failure to attain the proper touchdown point while attempting to land in gusting crosswind conditions, which resulted in an attempted go-around and collision with trees and power lines.NTSB GAA17CA182Accident · Serious injuriesData collectionFinal reportPedersen Bjarne Martin Sportsman GS-2 · Robbinsville, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA179Accident · No injuriesData collectionFinal reportBurkhart Grob G 109B · Mokuleia, HIThe failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.NTSB ERA17LA125Accident · Serious injuriesClass 2 · LimitedFinal reportGrob G120TP-A · Abbeville, ALThe flame-out of the engine due to a mis-set fuel control unit at the time of manufacture. Contributing to the accident was the pilots’ delayed recognition that the engine had flamed out, partially due to the operator’s requirement to disable the crew…NTSB ERA17FA123Accident · 1 fatalField investigationFinal reportJordan Bruce C Pitts S2E · Apex, NCThe pilot's failure to maintain airplane control during the final approach to the runway in gusting tailwind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB DCA17FA076Accident · Minor injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD80 · Ypsilanti, MIthe jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…NTSB WPR17FA074Accident · 1 fatalField investigationFinal reportQuicksilver MXL II · Hesperia, CAThe pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…NTSB GAA17CA192Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot’s decision to land with a crosswind that exceeded the airplane’s demonstrated capability, which resulted in the airplane banking left and the wing striking the ground.NTSB DCA17WA121Incident · No injuriesForeign investigationBoeing 737 · Sint Maarten, NTThe government of Netherlands Antilles has notified the NTSB of an accident involving a BOEING 737 that occurred on March 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands Antilles's investigation under…NTSB DCA17CA087Accident · Serious injuriesData collectionFinal reportAirbus A319 114 · Los Angeles, CAmalfunction of the parking brake electrical control valve that resulted in a sudden stop.NTSB ANC17FA018Accident · 1 fatalField investigationFinal reportCessna R172K · Nome, AKThe pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel…NTSB GAA17CA174Accident · Minor injuriesData collectionFinal reportLancair Columbia 400 · Henderson, NVThe pilot’s improper decision to land the airplane with a gusting crosswind, which resulted in a loss of airplane control.NTSB ERA17LA120Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Argyle, NYA total loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.NTSB DCA17WA075Incident · No injuriesForeign investigationBoeing 777 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on March 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB ANC17RA019Accident · 9 fatalForeign investigationBell 412 · Matsumoto, JapanimportNTSB ERA17WA124Accident · 1 fatalForeign investigationPiper PA25 · Villa Tapia, Dominican RepublicOn March 4, 2017, about 1330 coordinated universal time, a Piper PA-25-235, N8969L, was destroyed following a collision with antenna wires and terrain during an aerial application flight near Villa Tapia, Dominican Republic. The pilot was fatally injured. The…NTSB ERA17FA119Accident · 2 fatalField investigationFinal reportBeech B 60 · Duette, FLThe pilots' decision to perform flight training maneuvers at low airspeed at an altitude that was insufficient for stall recovery. Contributing to the accident was the flight instructor's inappropriate use of non-standard stall recovery techniques.NTSB ERA17FA118Accident · 1 fatalField investigationFinal reportCessna 421 · Canton, GAThe pilot's failure to maintain control of the airplane during a night visual landing approach. Contributing to the accident was the pilot's impairment due to his use of a combination of medications.NTSB CEN17LA119Accident · No injuriesLimited investigationFinal reportMooney M20F · Hebron, NEA loss of directional control during landing for reasons that could be determined based on the available information.NTSB CEN17LA117Accident · Serious injuriesLimited investigationFinal reportJude Mike C Side Winder · Paynesville, MNThe pilot’s inadequate preflight inspection, during which he failed to ensure that there was sufficient coolant in the engine reservoir, which resulted in the engine getting too hot and the engine control module shutting down the engine.NTSB CEN17CA116Accident · Serious injuriesData collectionFinal reportCessna 162 · Conway, ARThe pilot's failure to shut down the engine before exiting the airplane and his failure to focus his attention on the task at hand, which led to his walking into a rotating propeller.NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.NTSB ANC17LA017Accident · Minor injuriesLimited investigationFinal reportBeech G18 · Metlakatla, AKAn engine power loss for reasons that could not be determined because the airplane was not recovered.NTSB GAA17CA175Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot's failure to maintain directional control while taxiing in gusting crosswind conditions.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB GAA17CA170Accident · No injuriesData collectionFinal reportMaule M5 · Roxbury, KSThe pilot’s failure to maintain directional control during a go-around.NTSB ERA17LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ft Lauderdale, FLFailure of the left main landing gear downlock link, which resulted in a landing gear collapse during the landing roll.NTSB CEN17CA120Accident · Serious injuriesData collectionFinal reportAero Commander S2R · Fairmont, OKThe pilot’s failure to maintain clearance from a power line while conducting agricultural spray operations.NTSB WPR17LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Carson City, NVA total loss of engine power due to internal corrosion of the fuel manifold valve. Also causal was the pilot's decision to return to the runway following the loss of engine power shortly after takeoff, and his exceedance of the airplane's critical angle of…NTSB WPR17LA071Accident · No injuriesLimited investigationFinal reportBell 206B · Firebaugh, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge, which led the pilot to believe that there was adequate fuel onboard.NTSB GAA17CA171Accident · Minor injuriesData collectionFinal reportSmith Douglas J. Sonex · Mercey Hot Springs, CAThe sport pilot’s unstabilized approach with a tailwind, which resulted in touchdown short of the runway and a subsequent nose-over.NTSB GAA17CA168Accident · Minor injuriesData collectionFinal reportMaule MX7 · Live Oak, CAThe pilot’s failure to maintain a stabilized approach and his subsequent incorrect brake application during the landing roll, which resulted in a nose-over.NTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.NTSB ERA17LA122Accident · No injuriesLimited investigationFinal reportXtremeair XA42 · West Palm Beach, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical failures or malfunctions that would have precluded normal operation.NTSB WPR17FA066Accident · 4 fatalField investigationFinal reportCessna T310Q · Riverside, CAThe pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…NTSB GAA17CA164Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prentiss, MSThe pilot's decision to take off with a gusting tailwind and his subsequent failure to maintain directional control.NTSB ERA17FA117Accident · 1 fatalField investigationFinal reportLavender Alan P Sonex · Methuen, MAThe pilot's failure to properly secure oil and fuel line fittings during maintenance, which resulted in an inflight engine fire, and his subsequent loss of control while maneuvering for landing. Contributing to the accident was the pilot's diverted attention…NTSB DCA17WA073Accident · No injuriesForeign investigationBoeing 767 33A · Azraq, JordanNTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.NTSB GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.NTSB CEN17FA112Accident · 1 fatalField investigationFinal reportBell 407 · Chauvin, LAThe pilot's failure to maintain proper altitude resulting in a collision with water for reasons that could not be determined based on the available information.NTSB CEN17FA111Accident · 2 fatalField investigationFinal reportCessna 172S · Berthoud, COThe failure of the pilots to apply prompt and/or correct flight control inputs to adequately recover from the intentional aerodynamic spin.NTSB WPR17WA073Accident · No injuriesForeign investigationCessna 152 · Hong Kong, ChinaOn February 26, 2017, about 0314 Coordinated Universal Time, a Cessna 152, B-HHN, collided with trees and came to rest in the trees while attempting a forced landing as a result of a reported loss of engine power. The airplane was operated by Hong Kong…NTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.NTSB GAA17CA167Accident · No injuriesData collectionFinal reportEurocopter EC130 · Las Vegas, NVThe pilot's abrupt cyclic/pitch attitude control movement, which resulted in a Fenestron ground strike.NTSB GAA17CA160Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot’s failure to maintain clearance from a hangar while taxiing at night.