NTSB investigations, 2017
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 GAA17CA444Accident · No injuriesData collectionFinal reportMcintosh Donald W Kitfox Series 7 · Priest River, IDThe pilot's failure to maintain lateral/bank control during the landing in variable gusting wind conditions.NTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…NTSB CEN17FA288Accident · 2 fatalField investigationFinal reportZenith CH701SP · Laddonia, MOThe pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…NTSB ANC17FA039Accident · 1 fatalClass 2 · FieldFinal reportCessna U206 · Port Alsworth, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was (1) the inadequate preflight…NTSB WPR17FA166Accident · 4 fatalField investigationFinal reportBeech A36TC · Ogden, UTA loss of control during takeoff for reasons that could not be determined.NTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17WA294Accident · No injuriesForeign investigationRaytheon Hawker · Mykonos, GreeceOn July 26, 2017, at 0727 Universal Coordinated Time (UTC), a Raytheon Aircraft Company Hawker 850XP, Turkish registration TC-MAN, operated by Genel Havacilik AS, received substantial damage following an abnormal runway contact during landing at Mykonos…NTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.NTSB WPR17LA168Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Lake Sutherlin, MTThe pilot’s transition into an out-of-ground-effect hover in high-density altitude conditions that exceeded the helicopter’s performance capabilities, which resulted in loss of rotor rpm.NTSB WPR17LA165Accident · No injuriesClass 3 · LimitedFinal reportLake LA 4 · Byron, CAThe pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…NTSB GAA17CA454Accident · Serious injuriesData collectionFinal reportAir Tractor AT 802 · Trumann, ARThe pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.NTSB ERA17RA260Accident · 1 fatalForeign investigationBritten Norman BN2A · Eteringbang, GuyanaOn July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…NTSB DCA17WA156Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Civil Aviation Safety Investigation and Analysis Center (CASIAC) of Romania has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN17LA285Accident · Serious injuriesLimited investigationFinal reportHillard Charlie R Hawker FB60 · Breckenridge, TXA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB WPR17LA163Accident · Minor injuriesClass 3 · LimitedFinal reportBritish BAC Stkmstr MK80 · Henderson, NVThe failure of the pilot to ensure that the flaps were set to the proper position for takeoff which resulted in the airplane becoming airborne and unable to climb or accelerate and subsequently impacting terrain.NTSB GAA17CA437Accident · No injuriesData collectionFinal reportCessna 172 · Powell, WYThe student pilot’s improper landing flare and subsequent failure to relinquish the flight controls, which resulted in a hard landing.NTSB GAA17CA436Accident · No injuriesData collectionFinal reportBell 47G 3B · Toterville, IAThe pilot’s failure to maintain rotor rpm while maneuvering at low altitude with low airspeed and a tailwind.NTSB ERA17WA291Accident · 3 fatalForeign investigationMitsubishi MU2B · San Fernando, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a MITSUBISHI MU2B airplane that occurred on July 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB ERA17LA257Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Myrtle Beach, SCA loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…NTSB CEN17LA282Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Wichita Falls, TXThe flight's encounter with adverse weather conditions at night, which resulted in the pilot's loss of airplane control upon landing due to standing water and a subsequent runway overrun.NTSB WPR17LA164Accident · No injuriesLimited investigationFinal reportPiper PA 28R-180 · San Jose, CAMaintenance personnel's incorrect installation of the aileron control cables and subsequent failure to verify proper aileron functionality following the maintenance, which resulted in roll control that was opposite of that commanded by the pilot, and the…NTSB GAA17CA443Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Berlin, MDThe ground crewman’s failure to visually check the runway before crossing it in a vehicle, which resulted in he and the vehicle being struck by the landing airplane.NTSB GAA17CA441Accident · No injuriesData collectionFinal reportPiper PA18S · Sterling, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB GAA17CA440Accident · No injuriesData collectionFinal reportMitchell Derryle V Rans S 7 Courier · Cordova, AKThe pilot’s improper decision to take off from a lake in gusting wind conditions, which resulted in a loss of airplane control.NTSB GAA17CA432Accident · No injuriesData collectionFinal reportCessna TU206B · Sandy, ORThe pilot’s improper bank control during landing in gusting wind conditions.NTSB GAA17CA430Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Whaleyville, VAThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA429Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Edgartown, MAThe airplane’s collision with geese during the takeoff roll.NTSB DCA17WA158Incident · No injuriesForeign investigationBoeing Boeing 777-236 · London, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 777-236 airplane that occurred on July 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation under the…NTSB CEN17WA289Accident · 7 fatalForeign investigationCessna U206 · Culiacan, MexicoNTSB CEN17FA281Accident · 1 fatalField investigationFinal reportCessna 150F · Farmerville, LAThe pilot's failure to maintain clearance from the lake during a low-level maneuver.NTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.NTSB WPR17FA161Accident · 1 fatalField investigationFinal reportApplegate Panzl S331E · Apple Valley, CAA fatigue failure of the left aileron control rod end during aerobatic flight, which resulted in the pilot's inability to maintain control of the airplane.NTSB GAA17CA449Accident · No injuriesData collectionFinal reportRadford Darrel F Christen Eagle II · Atchison, KSThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA439Accident · No injuriesData collectionFinal reportCessna A185 · Arctic Village, AKThe pilot’s failure to maintain directional control after an aborted takeoff.NTSB GAA17CA435Accident · No injuriesData collectionFinal reportGilbert Thomas Jeffrey Lancair 235 · Denison, TXThe pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA17CA433Accident · No injuriesData collectionFinal reportStinson SR9 · Bode, IAThe pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.NTSB GAA17CA428Accident · Minor injuriesData collectionFinal reportPiper L 21B · Cartersville, GAThe pilot’s loss of directional control during the landing roll and subsequent excessive brake application, which resulted in a nose-over.NTSB ERA17WA343Accident · Serious injuriesForeign investigationCessna 182 · Ivano-Frankivsk, UkraineOn July 22, 2017, about 1305 coordinated universal time, a Cessna 182, Ukrainian registration UR-ORV, was substantially damaged during a forced landing near Ivano-Frankiivsk region, Ukraine. There were 5 people on board, of which 3 were seriously injured. The…NTSB ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.NTSB DCA17WA161Incident · No injuriesForeign investigationBoeing 767 · Newcastle, United KingdomThe UK AAIB has notified the NTSB of an incident involving a Boeing767 airplane that occurred on July 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO Annex 13 as the…NTSB CEN17LA283Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…NTSB WPR17LA159Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Van Nuys, CAAn improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…NTSB GAA17CA574Accident · No injuriesData collectionFinal reportCessna 208 · New York, NYThe airplane’s encounter with boat wake and multiple swells during a water takeoff.NTSB GAA17CA434Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bozeman, MTThe flight instructor’s unstabilized autorotation, which resulted in a hard landing.NTSB GAA17CA427Accident · Minor injuriesData collectionFinal reportLet L23 · Deatsville, ALThe student pilot’s failure to maintain clearance from trees and power lines while landing.NTSB DCA17WA157Incident · No injuriesForeign investigationBoeing 737-86J · Belfast, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 737-86J airplane that occurred on July 21, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO…NTSB CEN17LA280Accident · No injuriesLimited investigationFinal reportStinson 108 · Lee's Summit, MOThe pilot’s loss of directional control during landing due to the failure of the right brake seal.NTSB ANC17CA038Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Dilllingham, AKThe pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.NTSB ERA17WA259Accident · 2 fatalForeign investigationCirrus Design SR20 · Santo Antonio do Leverger, BrazilOn July 20, 2017, at 1109 coordinated universal time, a Cirrus SR-20, Brazilian registration PR-PRF, was substantially damaged when it collided with terrain shortly after takeoff from Santa Edwiges farm, near the municipality of Santo Antônio do Leveger, Mato…NTSB ERA17LA262Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11BC · Gilbert, SCThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion.