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 ANC17WA029Accident · 3 fatalForeign investigationBell 206 · Fengbin, TaiwanOn June 10, 2017, about 1255 Taipei local time (0455 UTC), a Taiwanese registered Bell 206B3 helicopter, B-31118, operated by Emerald Pacific Airlines, impacted remote mountainous terrain about 8 miles south of Fengbin, Hualien County, under unknown…NTSB WPR17FA125Accident · 1 fatalField investigationFinal reportBeech 95 C55 · Mountain Ranch, CAThe pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB ERA17LA204Accident · No injuriesLimited investigationFinal reportPiper PA 44-180 · Gaithersburg, MDThe failure of the right main landing gear trunnion bracket due to an undetermined overstress event.NTSB CEN17WA349Accident · 1 fatalForeign investigationPiper PA31 · Caernarfon, Gwynedd, United KingdomOn June 9, 2017, at 1705 coordinated universal time, a Piper PA31, N250AC, impacted terrain during landing at Caernarfon Airport (EGCK), Caernarfon, Gwynedd, Wales. The airplane was destroyed by impact forces and fire. The pilot, who was the sole occupant,…NTSB CEN17LA228Accident · Serious injuriesLimited investigationFinal reportThompson Angel Hawk II · Homer, LAA total loss of engine power due to the engine’s unresolved high operating temperatures, which resulted in failure of the distributor rotor and drive shaft, and the pilot’s failure to maintain airspeed during the subsequent forced landing, which resulted in…NTSB CEN17LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-301T · Dalhart, TXThe failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.NTSB CEN17LA219Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Douglas, WYThe pilot's inability to control the helicopter's descent after encountering a sudden wind shift to a tailwind while performing a near maximum gross weight landing at a high density altitude.NTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.NTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN17LA223Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7 77B · Chatsworth, ILThe balloon’s encounter with unexpected wind gusts during inflation, which resulted in the balloon becoming prematurely airborne and subsequently the pilot being ejected from the basket and one passenger receiving serious injuries while attempting to egress…NTSB CEN17LA220Accident · Serious injuriesLimited investigationFinal reportBellanca 17 30 · Watkins, COThe pilot's in-flight fuel mismanagement, which resulted in fuel starvation and a total loss of engine power.NTSB CEN17LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-235 · Harrisonville, MOThe pilot's failure to maintain a safe distance between the airplane and a person on the ground, which resulted in serious injuries to the person.NTSB ENG17IA026Incident · No injuriesIncident investigationFinal reportBoeing 747 451 · Tokyo, JapanThe PW4056 engine lost power due to the fatigue fracture of a 5th stage compressor blade. The cause of the fatigue fracture could not be determined.NTSB CEN17LA224Accident · No injuriesLimited investigationFinal reportMckenna SD-1A · Juneau, WIThe pilot’s difficulty controlling the airplane due to his incorrect reinstallation of the wings, which led to a bounced precautionary landing. Contributing to the accident was the failure of the pilot and the mechanic to verify the wings’ angle of incidence.NTSB GAA17CA353Accident · No injuriesData collectionFinal reportCessna 207 · Homer, AKThe pilot's decision to land on unsuitable terrain, which resulted in the nosewheel breaking and a subsequent noseover.NTSB GAA17CA327Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB DCA17WA136Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB ANC17LA028Accident · Minor injuriesClass 2 · LimitedFinal reportCessna 172 · Chugiak, AKThe pilot's improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA17CA323Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prosser, WAThe pilot’s abrupt maneuver to avoid hay bales during the takeoff roll, which resulted in a loss of directional control.NTSB GAA17CA321Accident · No injuriesData collectionFinal reportAg-Cat G 164 · Tulelake, CAThe pilot’s improper decision to perform a low altitude fly-by over ground equipment, which resulted in the airplane striking the equipment.NTSB WPR17LA121Accident · No injuriesLimited investigationFinal reportBob Frederick Titan T-51 · Goodyear, AZFailure of the propeller speed reduction gearbox input drive gear during the airplane’s initial climb for reasons that could not be determined due to extensive damage.NTSB WPR17FA120Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Santa Rosa Valley, CAThe pilot's exceedance of the airplane's critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB GAA17CA381Accident · No injuriesData collectionFinal reportAeronca 7AC · Soldotna, AKThe pilot’s abrupt maneuver to avoid a moose cow and calf during taxi, which resulted in an impact with a tree.NTSB GAA17CA354Accident · No injuriesData collectionFinal reportPiper PA28 · Big Bear, CAThe pilot’s improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB GAA17CA326Accident · No injuriesData collectionFinal reportCessna 150 · Newburyport, MAThe student pilot's decision to attempt to close the cockpit window during takeoff and his subsequent failure to maintain directional control.NTSB GAA17CA318Accident · Minor injuriesData collectionFinal reportCessna 172 · Payson, AZThe pilot’s inadequate preflight planning that did not account for high-density altitude conditions and his subsequent attempted go-around in conditions that prevented the airplane from attaining a positive climb rate and resulted in its subsequent descent…NTSB CEN17LA239Accident · No injuriesLimited investigationFinal reportLevy Adam V Legacy 2000 · Georgetown, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA216Accident · No injuriesLimited investigationFinal reportWilliam D Telfair/Zia Z Telfai Excalibur · Albuquerque, NMThe loss of pitch control due to the overload failure of the control rod.NTSB CEN17LA210Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Kenosha, WIThe pilot's loss of helicopter control during landing to a dolly.NTSB WPR17LA122Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Rexberg, IDA loss of engine power for reasons that could not be determined based on the available information which resulted in a landing short of the runway.NTSB WPR17LA119Accident · No injuriesClass 3 · LimitedFinal reportPaul R Seipt Sonex · Garfield, WAThe pilot’s improper torque of screws that attached the flywheel mounting flange to the crankshaft during engine assembly, which resulted in heavy vibrations and the subsequent in-flight loss of the propeller.NTSB GAA17CA330Accident · No injuriesData collectionFinal reportBoeing B75N1 · Williamson, GAThe pilot’s aggressive and early forward stick application during the landing roll, which resulted in his failure to maintain pitch control and a subsequent nose-over.NTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.NTSB GAA17CA315Accident · No injuriesData collectionFinal reportCessna T182 · San Carlos, CAThe pilot's incorrect landing flare, which resulted in a hard, bounced landing.NTSB ERA17FA195Accident · 1 fatalField investigationFinal reportPiper PA23 · San Juan, PRThe pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.NTSB ENG17IA027Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Washington, DCThe failure the control alternator gearshaft, which disconnected the accessory gearbox from the rest of the engine and resulted in an uncommanded in-flight shutdown of the left engine and subsequent flight diversion. The control alternator gearshaft failed…NTSB DCA17WA228Accident · No injuriesForeign investigationFokker F27 Mk 600 · Garbaharey, SomaliaThe Ministry of Transport for the Republic of Kenya has notified the NTSB of an accident involving a Fokker F27, which occurred on July 14, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All…NTSB DCA17WA138Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB CEN17LA212Accident · No injuriesLimited investigationFinal reportCessna 210F · Anoka, MNThe failure of the landing gear to fully extend due to insufficient hydraulic fluid in the hydraulic system as a result of inadequate maintenance by the airplane owner.NTSB CEN17FA209Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Dimmitt, TXThe pilot's incapacitation due to scarring from previous heart attacks and severe hypertrophy of the left ventricular wall which resulted in arrhythmia and a loss of control while maneuvering at low altitude.NTSB CEN17FA208Accident · 1 fatalField investigationFinal reportMichael S. Logan Kitfox · New Berlin, TXA total loss of engine power for reasons that could not be determined based on the available information, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and experiencing…NTSB ANC17WA027Accident · 4 fatalForeign investigationCessna 172 · Tateyama, JapanOn June 3, 2017, about 1450 Japan standard time (UTC +9), a Japanese registered Cessna 172P airplane, JA3989, operated by New Central Air Service, impacted snow-covered mountainous terrain near Tateyama, Toyama Prefecture, under unknown circumstances about 27…NTSB WPR17FA118Accident · 1 fatalField investigationFinal reportCessna 150M · Banning, CAThe flight instructor's decision to continue the takeoff in gusting tailwind and high density altitude conditions, which significantly reduced airplane performance, and his subsequent exceedance of the airplane's critical angle of attack during the initial…NTSB GAA17CA320Accident · No injuriesData collectionFinal reportCessna 182 · Elk City, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the wing’s angle of attack while on short final, which resulted in an aerodynamic stall.NTSB GAA17CA319Accident · Minor injuriesData collectionFinal reportMagnaghi Aeronautica SKY Arrow LSA · Chapman, KSThe pilot's failure to maintain lateral/bank control during the takeoff climb in gusting crosswind conditions.NTSB GAA17CA316Accident · No injuriesData collectionFinal reportMalinowski Walter S RV8 · Canaan Valley, WVThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB CEN17WA211Accident · 2 fatalForeign investigationLake LA-4-200 · Muskoka, Ontario, CanadaOn June 2, 2017, at 2113 coordinated universal time, a Lake LA-4-200 Buccaneer, C-GZSW, was destroyed on impact with terrain after takeoff from Muskoka Airport (CYQA), Muskoka, Ontario, Canada. After takeoff, the pilot attempted to return to the airport, and…NTSB WPR17FA117Accident · 1 fatalField investigationFinal reportCessna 180 · Ventura, CAThe pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.NTSB GAA17CA325Accident · No injuriesData collectionFinal reportCessna 182 · Ellington, CTThe pilot’s unstabilized approach and failure to go around in rainy, gusting crosswind conditions, which resulted in a runway overrun. Contributing to the accident was the pilot’s self-induced pressure to land due to the deteriorating weather conditions.