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 ERA17WA283Accident · 1 fatalForeign investigationRobinson R66 · Maly Utrish, RussiaOn July 21, 2017, about 1832 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-05750, was substantially damaged when it impacted mountainous terrain near Maly Utrish township, while on a night flight from Anapa, Russia, to…NTSB ERA17LA293Accident · No injuriesLimited investigationFinal reportCessna 172 · Guntersville, ALThe pilot's failure to maintain directional control on takeoff.NTSB ERA17LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT 402A · Shaw, MSThe pilot’s decision to attempt takeoff at high gross weight, in high density altitude conditions, and with insufficient runway length. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA17LA284Accident · No injuriesLimited investigationFinal reportMooney M20C · Palm Coast, FLA crack in the No. 4 cylinder head, which resulted in engine roughness, a fuel leak, a loss of engine power, and the subsequent in-flight fire.NTSB CEN17WA379Incident · No injuriesForeign investigationCessna 172RG · Balchik, BulgariaOn August 21, 2017, at 1150 coordinated universal time, a Cessna 172RG, Bulgarian registration LZ-SPD, operated by Aviootryad Varna Ltd, collided with the runway during a gear-up landing at the Balchik Airfield (LBWB), Balchik, Bulgaria. The pilot and…NTSB GAA17CA495Accident · No injuriesData collectionFinal reportBell 206 · Minden, NVThe pilot’s failure to maintain helicopter control during landing due to a loss of tail rotor effectiveness.NTSB ERA17LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · St. Augustine, FLA total loss of engine power for reasons that could not be determined because examination of the airplane and engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation and because the amount…NTSB ERA17LA290Accident · No injuriesLimited investigationFinal reportCessna 180 · Newport, NHA leak in the right brake slave cylinder, which led to no fluid in the reservoir and subsequent asymmetric braking.NTSB ERA17LA285Accident · No injuriesLimited investigationFinal reportBell 47G · St Marys, PAThe student pilot's inadequate prefight planning and en route fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA17LA281Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Green Creek, NJThe pilot's exhaustion of the fuel supply in the selected tank.NTSB CEN17LA326Accident · No injuriesLimited investigationFinal reportCessna 182 · Booneville, MOThe pilot’s failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion.NTSB WPR17FA185Accident · 1 fatalField investigationFinal reportRich Wheeler Express CT · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering in the airport traffic pattern for landing, which resulted in an exceedance of the airplane's critical angle of attack, a subsequent aerodynamic stall at an altitude too low to recover.NTSB GAA17CA510Accident · No injuriesData collectionFinal reportLuscombe 8 · Angleton, TXThe pilot’s failure to maintain directional control during landing.NTSB GAA17CA503Accident · No injuriesData collectionFinal reportPiper PA 28 · Mohave, AZThe pilot’s improper airspeed and pitch control during landing in variable, gusting wind conditions, which resulted in an aerodynamic stall and hard landing.NTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.NTSB GAA17CA496Accident · Minor injuriesData collectionFinal reportMIke Reed Super Cub · Murphy, IDThe pilot’s use of excessive brake pressure during the landing roll, which resulted in a nose-over.NTSB ERA17WA289Accident · 5 fatalForeign investigationLearjet 25 · Naiguata, VenezuelaOn August 19, 2017, about 0415 universal coordinated time, a Learjet 25D, Venezuelan registration YV3191, descended and impacted the ocean about 5 nautical miles north of Naiguatá, Vargas, Venezuela. The two pilots and three passengers were fatally injured.…NTSB ERA17LA288Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Marietta, PAThe pilot's failure to maintain directional control during takeoff with a quartering tailwind. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB ERA17LA287Accident · No injuriesLimited investigationFinal reportCessna R182 · Clearwater, FLThe improper maintenance of the landing gear system and subsequent failure of the hydraulic landing gear down return line, which resulted in a loss of hydraulic fluid and the pilot’s inability to extend and lock the main landing gear.NTSB WPR17WA203Accident · No injuriesForeign investigationRobinson Helicopter R44 II · Darwin Aerodrome, AustraliaOn August 18, 2017, at 1400 local time, a Robinson R44 II, VH-LGN, was substantially damaged during a forced landing near Darwin Aerodrome, Australia. The helicopter was operated under the pertinent civil regulations of the government of Australia. The pilot…NTSB GAA17CA504Accident · No injuriesData collectionFinal reportBoeing E75 · Centerville, TNThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action.NTSB ERA17LA282Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Fairhope, ALA total loss of engine power for reasons that could not be determined because postaccident examination and a test run of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17LA280Accident · 1 fatalLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VAThe flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.NTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.NTSB ANC17LA052Accident · No injuriesLimited investigationFinal reportCessna A185 · Aniak, AKThe pilot's inadequate preflight inspection, which failed to detect a crack in the propeller blade, which led to the separation of a section of a propeller blade due to fatigue.NTSB GAA17CA501Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s use of excessive braking during the landing roll, which resulted in a nose-over.NTSB GAA17CA494Accident · No injuriesData collectionFinal reportAerotechnik L 13 SEH Vivat · Moses Lake, WAThe pilot's improper takeoff configuration due to his failure to follow the pretakeoff checklist, which resulted in a loss of lift and collision with obstacles.NTSB GAA17CA493Accident · No injuriesData collectionFinal reportBoyd Bruce RV4 · Yerington, NVThe pilot's improper landing flare, which resulted in a bounded landing and subsequent loss of directional control.NTSB CEN17LA328Accident · No injuriesLimited investigationFinal reportBeech A36 · Gonzales, LAA partial loss of engine power due to inadequate maintenance, including worn spark plugs and a leaking fuel hose fitting.NTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.NTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.NTSB ERA17LA277Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Canton, GAMaintenance personnel's failure to ensure the proper throttle linkage travel clearance after the installation of an exhaust system.NTSB DCA17CA181Accident · No injuriesData collectionFinal reportBoeing 737 832 · Queens, NYthe Delta B737 captain's failure to maintain proper clearance between his airplane and the stopped American B757.NTSB CEN17WA320Accident · 1 fatalForeign investigationPiper PA36 · Vejer de la Frontera, SpainOn August 15, 2017, a Piper PA-36-375 airplane (EC-EHB, s/n 36-8102001) impacted terrain during fumigation operations in the vicinity of Vejer de la Frontera, Spain. The pilot was fatally injured.This investigation is under the jurisdiction and control of the…NTSB GAA17CA491Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Westby, WIThe pilot's failure to see and avoid power lines while maneuvering at low altitude.NTSB GAA17CA487Accident · No injuriesData collectionFinal reportPiper PA28 · Chandler, AZThe student pilot's failure to maintain directional control during landing.NTSB ERA17LA276Accident · Minor injuriesLimited investigationFinal reportBradley Roderick W Murphy Renegade · Guilford, CTA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN17LA318Accident · Minor injuriesLimited investigationFinal reportKnapp Easy Raider · Rochester, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN17LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Beckville, TXA stuck exhaust valve, which resulted in the failure of the valve and a loss of engine power. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB ANC17WA048Accident · 2 fatalForeign investigationSocata TBM 700 · Zemyo, JapanOn Aug 14, 2017, at 1215 Japan standard time, a United States registered Socata TBM 700 airplane, N702AV, operated by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Zemyo in Nara Prefecture, Japan.…NTSB ANC17LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna T207 · Juneau, AKThe total loss of engine power due to fuel starvation.NTSB GAA17CA486Accident · No injuriesData collectionFinal reportCessna L19 · Nashville, TNThe pilot’s improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.NTSB ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.NTSB DCA17WA176Incident · Minor injuriesForeign investigationBoeing 767 332 · London, United KingdomThe Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of a serious incident involving a BOEING 767 332 airplane that occurred on August 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…NTSB GAA17CA492Accident · Minor injuriesData collectionFinal reportCessna 182 · Quitman, MSThe student pilot’s failure to maintain directional control during takeoff in gusting wind conditions after passing a large hill.NTSB GAA17CA488Accident · Minor injuriesData collectionFinal reportCharles D Walker Walker Curtiss JN4D · Bowling Green, KYThe pilot’s exceedance of the biplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall and collision with trees.NTSB GAA17CA485Accident · No injuriesData collectionFinal reportCessna 182 · Sparta, MIThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA17FA274Accident · 2 fatalField investigationFinal reportBell 407 · Charlottesville, VAThe pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB WPR17LA183Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 28R-200 · West Jordan, UTThe pilot's failure to account for operation at high density altitude at or near the airplane’s maximum gross weight, which led to degraded engine performance and prevented the airplane from achieving an adequate airspeed for a positive rate of climb,…