NTSB investigations, 2015
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2015 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") = 2015 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 CEN15LA341Accident · Serious injuriesLimited investigationFinal reportHughes 269B · Atkinson, ILThe pilot's improper decision to intentionally fly the helicopter at a low altitude and his subsequent failure to maintain clearance from a power line.NTSB CEN15IA337Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Denver, COThe gate lead/pushback driver's failure to recognize that the provisioning truck was within the safety zone of the gate during his walkaround due to distractions, which resulted in the subsequent collision between the airplane and the truck. Contributing to…NTSB WPR15LA230Accident · No injuriesLimited investigationFinal reportGrumman G164 - B · Princeton, CAThe loss of engine power during an agricultural application flight due to a cylinder failure.NTSB DCA15WA174Incident · No injuriesForeign investigationBombardier CL600 2D24 · Toronto, CanadaThe Transportation Safety Board of Canada (TSB-C) has notified the NTSB of an incident involving a Boeing 787 that occurred on August 03, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the TSB-C's investigation under the provisions of…NTSB CEN15WA438Accident · Minor injuriesForeign investigationHughes 369 · Ramatuelle, France, FranceOn August 4, 2015, a Hughes 369 helicopter, D-HBRM, was substantially damaged after impact with terrain near Ramatuelle, France. The pilot and passenger suffered minor injuries. This investigation is under the jurisdiction and control of the French…NTSB CEN15WA349Accident · 1 fatalForeign investigationCessna 172F · La Blanca, GuatemalaOn August 4, 2015, at 1315 coordinated universal time, a Cessna 172F, Guatemalian registration TG-ZAB, operated by AFYCO S.A., was destroyed when it impacted the terrain near La Blanca, Guatemala, during an aerial application flight. The pilot was fatally…NTSB CEN15LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Austin, TXA total loss of engine power due to an excessively rich fuel mixture as a result of the improper adjustment of the fuel pump aneroid.NTSB WPR15LA237Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · American Falls, IDThe low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.NTSB WPR15LA229Accident · No injuriesLimited investigationFinal reportCessna TU206G · Saint Ignatius, MTMaintenance personnel’s failure to tighten a fuel line, which resulted in a loss of fuel pressure and a subsequent loss of engine power during cruise flight and an off-airport landing and collision with obstacles.NTSB GAA15CA214Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe student pilot's failure to maintain pitch control resulting in a hard landing and damage to the airplane firewall.NTSB ERA15LA296Accident · No injuriesLimited investigationFinal reportBell 47G 3B 1 · Camden, ALA failure of the helicopter's hydraulic flight control systems for reasons that could not be determined due to the fire damage, and the pilot's inability to turn off the hydraulic system to relieve control pressure.NTSB WPR15LA232Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 20B · Logan, UTThe pilot’s failure to maintain glider control when it encountered a strong downdraft while maneuvering near a ridgeline.NTSB WPR15LA228Accident · No injuriesLimited investigationFinal reportHudson Zodiac CH 601 XLB · Hubbard, ORA severe propeller vibration due to the pilot's improper installation of the propeller spacer assembly, which necessitated an engine shutdown, an off-airport landing, and a collision with a sprinkler system.NTSB GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.NTSB ERA15LA293Accident · Serious injuriesLimited investigationFinal reportBeech C90B · Georgetown, KYUndetermined based on the available evidence.NTSB ERA15CA295Accident · No injuriesData collectionFinal reportStol JA30 Superstol · West Union, SCA loss of engine power while maneuvering due to water contamination in the fuel.NTSB DCA15WA170Incident · No injuriesForeign investigationAirbus A320 - 214 · Padang, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a AIRBUS A320, which occurred on August 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB CEN15LA366Accident · No injuriesLimited investigationFinal reportCessna 206 · Pecos, TXThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15LA334Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Chicago, ILAn encounter with a wind gust during ground maneuvering and the captain’s improper flight control positioning to account for wind conditions, which resulted in the airplane being blown onto its left wing.NTSB CEN15CA340Accident · Serious injuriesData collectionFinal reportThunder & Colt AX8 105S2 · Albuquerque, NMThe pilot did not properly brace herself during the landing, which resulted in a broken ankle and leg.NTSB WPR15LA226Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 12-m · Selma, CAThe pilot receiving instruction's use of an excessive pitch attitude during takeoff with the airplane near its maximum gross weight in hot and humid conditions, which degraded the airplane’s climb performance and resulted in a collision with obstacles during…NTSB WPR15FA227Accident · 1 fatalField investigationFinal reportCessna P337G · Santa Paula, CAThe noninstrument-rated pilot's decision to conduct a visual flight in instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB ERA16WA039Incident · No injuriesForeign investigationCessna 650 · Corlu, TürkiyeOn August 1, 2015, at 2317 coordinated universal time, a Cessna 650; N691BE, incurred minor damage after the main landing gear tires deflated during takeoff roll and a fire ensued in the area of the main landing gear at Tekirdag Çorlu Airport (LTBU), Corlu,…NTSB ERA15LA294Accident · No injuriesLimited investigationFinal reportCommander 114 · Reading, PAThe improper installation of the fuel supply line fitting at the fuel manifold, which resulted in the line loosening in-flight, fuel leakage, and a subsequent total loss of engine power.NTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.NTSB CEN15LA333Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Watertown, WIThe total loss of engine power due to carburetor icing.NTSB CEN15FA331Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Wilmot, ARThe pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.NTSB GAA15LA225Accident · Serious injuriesLimited investigationFinal reportUltramagic N250 - NO Series · Peoria, AZThe pilot's failure to ensure that the passengers remained secure in the basket during deflation after landing, which resulted in a passenger falling out of the basket and sustaining a serious injury when a wind gust caught the envelope and tipped the basket…NTSB ENG15WA035Incident · No injuriesForeign investigationEmbraer EMB120 · Moscow, RussiaThe government of Russia has notified the NTSB of an accident involving a Embraer EMB-120ER airplane that occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB DCA15WA163Incident · No injuriesForeign investigationBoeing 737 - 4Q8 · St Georges sur Meuse, BelgiumThe Air Accidents Investigation Unit (AAIU) of Belgium has notified the NTSB of an incident involving a Boeing 737-4Q8, which occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB CEN15WA420Accident · 4 fatalForeign investigationEmbraer EMB505 · Blackbushe Airport, United KingdomOn July 31, 2015, at 1408 universal coordinated time (UTC), a Embraer EMB-505, Phenom 300, airplane, registered HZ-IBN, impacted a terrain during landing at the Blackbushe Airport (EGLK), United Kingdom. The pilot and three passengers were fatally injured.…NTSB CEN15LA330Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Emmett, KSThe engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…NTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…NTSB GAA15CA209Accident · No injuriesData collectionFinal reportBellanca 17 30A · Tallahassee, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a forced landing on a road where the left wing impacted vegetation and sustained substantial damage.NTSB GAA15CA210Accident · No injuriesData collectionFinal reportExperimental Amat Built Kitfox III · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with terrain.NTSB GAA15CA204Accident · Minor injuriesData collectionFinal reportAirbus AS350-B2 · Tucson, AZThe flight instructor's misperception of the helicopter's altitude in relation to the runway surface during a low altitude maneuver, resulting in ground impact.NTSB ERA15LA291Accident · No injuriesLimited investigationFinal reportSontonastaso Mosquito · Winchendon, MAA partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.NTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…NTSB CEN15FA328Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Milwaukee, WIThe pilot's improper pitch control during the landing, which resulted in the propeller striking the runway, and his failure to maintain adequate airspeed during the subsequent go-around, which resulted in the airplane exceeding its critical angle of attack…NTSB CEN15FA321Accident · 3 fatalField investigationFinal reportChristensen Steve Wheeler Express · Holland, MNThe pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…NTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…NTSB DCA15WA196Incident · No injuriesForeign investigationBoeing 747 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747-400 that occurred on July 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB DCA15WA182Incident · No injuriesForeign investigationBombardier CL600 2E25 · Makassar, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…NTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.NTSB WPR15LA234Accident · No injuriesLimited investigationFinal reportCessna 180J · Dixie, IDThe failure of the right brake hydraulic line during taxi due to fatigue, which caused a loss of hydraulic fluid and rendered the brake inoperative.NTSB GAA15CA199Accident · Minor injuriesData collectionFinal reportNorton Claude C Tailwind W8 · Portales, NMThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.NTSB GAA15CA198Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Eufaula, ALThe pilot's failure to maintain direction control during takeoff, and the pilot's failure to ensure that the canopy of the airplane was secured and locked prior to departure.NTSB ERA15LA283Accident · Minor injuriesLimited investigationFinal reportCessna 195A · Iuka, MSA total loss of engine power for reasons that could not be determined because a postaccident examination of the engine and fuel system found no mechanical anomalies that would have precluded normal operation.NTSB CEN15FA316Accident · 2 fatalField investigationFinal reportBeech V35B · Colbert, OKThe pilot's failure to properly position the fuel selector, which resulted in a total loss of engine power due to fuel starvation. Contributing to the severity of the accident was the pilot's failure to select an appropriate location for a forced landing,…NTSB ANC15WA061Accident · 1 fatalForeign investigationCessna 182 · Seibert Lake, CanadaOn July 26, 2015, about 1738 mountain daylight time, a Cessna 182 airplane, C-FWVQ, impacted terrain shortly after takeoff from Seibert Lake, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…