NTSB investigations, 2014
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2014 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") = 2014 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 ERA15FA025Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Frederick, MDThe failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…NTSB ERA15CA027Accident · No injuriesData collectionFinal reportCessna A188B · Louisburg, NCThe pilot's failure to maintain directional control during takeoff.NTSB DCA15CA012Accident · No injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MNthe B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.NTSB CEN15TA035Accident · No injuriesFinal reportBell UH1H · San Isidro, TXThe flight crew's failure to ensure that the sliding cabin door was properly secured before the flight.NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.NTSB ERA15IA024Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Lexington, NCMaintenance personnel's improper tightening of the crankcase through bolt nuts during reassembly of the engine at the last overhaul, which resulted in the failure of the crankshaft and the subsequent total loss of engine power.NTSB DCA15WA015Incident · No injuriesForeign investigationBoeing 747 422 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Boeing 747 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under…NTSB DCA15WA013Incident · No injuriesForeign investigationBoeing 777 · Dubai, United Arab EmiratesThe GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO Annex 13 as…NTSB ERA15LA044Accident · Serious injuriesLimited investigationFinal reportItec Maverick · Dunnellon, FLA cell blowout in the fabric wing, which resulted in an asymmetrical loss of lift and a subsequent loss of aircraft control.NTSB ERA15FA023Accident · 1 fatalField investigationFinal reportBeech D95 · Bahama, NCThe pilots' failure to maintain adequate airspeed during climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor's decision to conduct a…NTSB ENG15WA002Incident · No injuriesForeign investigationBAE JETSTREAM4100 - 4100 · Medellín, Colombia, ColombiaOn October 21, 2014, at about 2005 universal coordinated time, a BAE Jetstream 41, registration HK-4503, operated by EasyFly S.A., experienced a No. 1 (left) engine stoppage during cruise after departing from Enrique Olaya Herrera Airport (EOH)- Medellin,…NTSB CEN15LA023Accident · Serious injuriesLimited investigationFinal reportTuberville Zodiac XL · Mountain Home, ARThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident engine examinations revealed no anomalies that would have precluded normal operation.NTSB WPR15FA016Accident · 1 fatalField investigationFinal reportSonex Sonex Trigear · Fawnskin, CAThe pilot's failure to maintain airspeed after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall/spin at low altitude. Contributing to the accident was the airplane's reduced climb…NTSB WPR15CA017Accident · No injuriesData collectionFinal reportIndus T-211 Thorpedo · Mountain Home, IDThe pilot's failure to maintain clearance with a parked truck while taxiing for takeoff.NTSB ERA15LA022Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warren, VTThe glider pilot’s failure to avoid the tow plane after the aborted takeoff due to both pilots’ failure to review the aborted takeoff procedure before the flight, which led to both pilots turning right after the aborted takeoff.NTSB CEN15FA022Accident · 1 fatalField investigationFinal reportCGS Hawk Arrow II Slsa · Lonoke, ARThe pilot's loss of airplane control while turning onto the base leg of the traffic pattern due to his failure to maintain sufficient speed and/or overbanking, which resulted in the airplane impacting trees. Contributing to the pilot's fatal injuries was his…NTSB CEN15WA129Accident · No injuriesForeign investigationSiai-Marchetti S.205 18R · Speck-Fehraltorf, SwitzerlandNTSB CEN15LA024Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Xenia, OHThe failure of the seat track mechanism, which led the pilot to inadvertently apply aft yoke and lift his feet off the rudder pedals and resulted in a loss of directional control during takeoff.NTSB ANC15TA003Accident · No injuriesFinal reportCub Crafters CC18-180 · Anchorage, AKThe pilot’s failure to maintain directional control while attempting to drag an off-airport landing site.NTSB WPR15LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA28 151 · Bullhead City, AZA partial loss of engine power during the initial climb 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 ERA15CA021Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Everglades City, FLThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, runway excursion, and collision with vegetation and water.NTSB ERA15CA020Accident · No injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Sebring, FLThe student pilot's inadvertent interference with the weight-shift capability of the airplane during the initial climb, resulting in a loss of airplane control and hard landing.NTSB CEN15TA019Accident · No injuriesFinal reportBAE Systems Hawk MK 67 · Oklahoma City, OKThe loss of directional control during the takeoff roll for reasons that could not be determined during postaccident examinations and testing.NTSB CEN15LA018Accident · Serious injuriesLimited investigationFinal reportViguie G/Viguie M Lancair Legacy · Livingston, TXA catastrophic and uncontained engine failure due to oil starvation. Contributing to the accident was the missing No. 3 cylinder intake rocker cover for reasons that could not be determined based on the available evidence.NTSB ERA15WA032Accident · No injuriesForeign investigationAyres Thrush S2R · Karatepe, TürkiyeOn October 17, 2014, about 0630 coordinated universal time, an Ayres S-2R, Turkish registration TC-ZEC, was substantially damaged during a forced landing following a loss of engine power near Karatepe, Turkey. The pilot was not injured. The local aerial…NTSB ENG15WA008Incident · No injuriesForeign investigationAirbus A319 - 132 · Zurich, SwitzerlandOn October 17, 2014, an Air Serbia Airbus 319-132, registration umber YU-APA, powered by two IAE V2524-A5 turbofan engines experienced a right engine oil leak shortly after departure. The flight crew performed an inflight shutdown of the engine and an air…NTSB DCA15LA011Accident · No injuriesLimited investigationFinal reportBoeing 737 330 · Lanai, HIthe improper loading and securing of the cargo pallets, which shifted on departure, resulting in substantial damage to the aft pressure bulkhead.NTSB CEN15TA017Accident · Minor injuriesFinal reportAirbus Helicopters AS 350 B3 · Lordsburg, NMThe pilot’s failure to maintain adequate drift control and skid clearance from the ground during takeoff, which resulted in a dynamic rollover when the aft right skid contacted a rock.NTSB WPR15LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Big Bear, CAA 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 ERA15LA019Accident · No injuriesLimited investigationFinal reportPiper PA32 301FT · Winona, MSA loss of directional control during takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.NTSB ERA15FA017Accident · 1 fatalField investigationFinal reportAeronca 7EC · Cordele, GAAn in-flight loss of control for reasons that could not be determined based on the available evidence.NTSB ERA15FA016Accident · 2 fatalField investigationFinal reportRockwell International 112 · Gainesville, GAThe partial loss of engine power due to the undetected blockage of the inlet and outlet ports of the manifold valve by an organic compound of an unknown source.NTSB ERA15CA018Accident · No injuriesData collectionFinal reportBell 206B · Prattville, ALThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15CA065Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Branson, MOThe pilot's failure to maintain aircraft control when executing a landing with a tailwind, resulting in impact with a retaining wall.NTSB CEN15LA015Accident · No injuriesLimited investigationFinal reportCessna P210N · West Memphis, ARA catastrophic engine failure due to an oil starvation event for reasons that could not be determined based on the available evidence.NTSB CEN15LA012Accident · No injuriesLimited investigationFinal reportCessna 182B · Orange, TXThe pilot’s failure to maintain airplane control during a go-around to avoid another airplane that was making a nonstandard approach to the opposing runway. Contributing to the accident was the other pilot’s use of a nonstandard approach while landing on the…NTSB CEN15IA014Incident · No injuriesIncident investigationFinal reportRaytheon Hawker · Denver, COThe failure of the main landing gear tire, which resulted in separation of the servo block and subsequent total loss of all hydraulic system pressure and prevented the landing gear from extending before landing.NTSB WPR15WA037Accident · 1 fatalForeign investigationAmateur Built VAN'S RV-6A · Moorabbin, Australia, AustraliaOn October 14, 2014, at 1340 local time, an amateur built Vans RV-6A, VH-JON, collided with terrain near Moorabbin, Australia. The airplane was being operated under the pertinent civil regulations of the government of Australia. The airplane was substantially…NTSB WPR15LA013Accident · No injuriesLimited investigationFinal reportBeech H35 · Bountiful, UTThe pilot's loss of directional control during a tailwind landing.NTSB ERA15CA036Accident · Serious injuriesData collectionFinal reportSix Chuter SR7 XL · Fairview, NCThe non-certificated pilot's delayed go-around procedure, which resulted in collision with trees. Contributing to the accident was the pilot's lack of total flying experience.NTSB CEN15FA008Accident · 1 fatalField investigationFinal reportPiper PA46 · Dubuque, IAThe pilot's loss of airplane control while attempting to fly a missed approach procedure in instrument meteorological conditions.NTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.NTSB WPR15FA010Accident · 2 fatalField investigationFinal reportCessna 170B · Yerington, NVThe failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…NTSB WPR15CA011Accident · Minor injuriesData collectionFinal reportFoxair Kitfox Light Sport · Nampa, IDThe instructor's inadequate supervision and the student's failure to maintain directional control.NTSB ERA15LA015Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Granville, MADeformation of the No. 1 cylinder's intake valve, which resulted in a partial loss of engine power and a subsequent off-airport precautionary landing.NTSB ERA15LA014Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Boca Raton, FLMaintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1 and 2 main bearings, loss of lubrication, failure of the crankshaft, and a subsequent total loss of engine power.NTSB DCA15RA010Accident · No injuriesForeign investigationBAE JETSTREAM3100 - 3100 · Punta Cana, Dominican RepublicThe Comisión Investigadora de Accidentes De Aviación (CIAA) of the Dominican Republic has notified the NTSB of an accident involving a BAe Jetstream 31, which occurred on October 12, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN15CA010Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesville, OHThe pilot's inadequate flare, which resulted in a hard landing.NTSB ANC15WA017Accident · Minor injuriesForeign investigationCirrus Design SR20 · Ibusuki City, JapanOn October 12, 2014, about 0530 coordinated universal time, a US registered Cirrus SR-20 airplane, N176CD, experienced a total loss of engine power near Ibusuki City, Kagoshima Prefecture, Japan. The pilot made a emergency landing, and received minor…NTSB WPR15CA009Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Mulino, ORA loss of aircraft control during approach for landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.