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 WPR15LA058Accident · No injuriesLimited investigationFinal reportMcholland Glastar · Sheridan, WYA loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.NTSB CEN15IA076Incident · No injuriesIncident investigationFinal reportCessna 182S · Springfield, ILThe improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.NTSB WPR15CA057Accident · Minor injuriesData collectionFinal reportCessna P210 - N · Jeffrey, WYThe pilot's inadequate approach and excessive airspeed, which resulted in a long landing, the subsequent runway overrun, and impact with terrain. Contributing to the accident was the pilot's delay in aborting the landing.NTSB DCA15WA031Accident · No injuriesForeign investigationBeech F33 - A · Krugersdorp, South AfricaNTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…NTSB CEN15LA084Accident · Minor injuriesLimited investigationFinal reportEnstrom 280FX · Fort Lupton, COThe loss of engine power during cruise flight for reasons that could not be determined based on the available information.NTSB CEN15CA095Accident · No injuriesData collectionFinal reportCessna 152 · Mount Pleasant, TXThe pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.NTSB WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.NTSB CEN15CA071Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Minocqua, WIThe pilot did not maintain directional control of the airplane during the landing flare when a sudden wind shift occurred.NTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.NTSB ERA15WA078Accident · 2 fatalForeign investigationCessna U206F · Campo Grande, BrazilNTSB ENG15WA005Incident · No injuriesForeign investigationBoeing 757 - 236 · Magadan, RussiaOn December 6, 2014, at approximately 10:30 UTC, a Yakutia Airlines Boeing 757-236PCF, registration VQ-BPY experienced a decompression and cargo door opening approximately 4 minutes after takeoff from Magadan, Russian Federation. The Department for Inspection…NTSB CEN15CA073Accident · No injuriesData collectionFinal reportCessna 152 · Berrien Springs, MIThe pilot's failure to maintain aircraft control during the landing and his poor decision not to abort the landing before the airplane traveled off the end of the airstrip.NTSB CEN15CA072Accident · Minor injuriesData collectionFinal reportCubcrafters CC11-160 · Middleton, WIThe pilot's failure to maintain control of the airplane while braking during landing rollout.NTSB ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.NTSB ERA15CA074Accident · No injuriesData collectionFinal reportCessna R182 · Vero Beach, FLThe pilot's improper landing flare, resulting in a hard landing.NTSB CEN15WA070Accident · 2 fatalForeign investigationSchweizer 269C - 1 · Ponte de Sôr, PortugalOn December 4, 2014, at 1045 coordinated universal time, a Schweizer 269C-1 helicopter, Portuguese registered CS-HFD, impacted terrain under unknown circumstances near Ponte de Sôr, Portugal, during an instructional flight. The instructor pilot and the…NTSB WPR15CA053Accident · No injuriesData collectionFinal reportStafford Wayne H Glastar · Monroe, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and encounter with terrain.NTSB ERA15WA070Accident · 10 fatalForeign investigationPiper PA-31-350 · Mariquita, ColombiaNTSB WPR15WA065Accident · 2 fatalForeign investigationAyres Thrush S2R-T34 · Manado, Indonesia, IndonesiaOn December 2, 2014, about 0250 universal coordinated time, an Ayres Trush, S2R-T34, PK-ELR, ditched in the sea under unknown circumstances. A tail wheel tire, elevator, both main landing gears, and some personal equipment were located 1 mile from the…NTSB WPR15LA052Accident · Minor injuriesLimited investigationFinal reportNanchang CJ-6 · Mesa, AZThe total loss of engine power during takeoff following a touch-and-go landing for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15FA051Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 · Bountiful, UTThe pilot/mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and a subsequent loss of control.NTSB ERA15WA067Accident · No injuriesForeign investigationPiper PA-31-350 · Nassau, BahamasOn December 2, 2014, about 0845 eastern standard time, a Piper PA-31-350, Bahamian registration C6-REV, operated as Southern Air Flight 302, was destroyed after ditching and submerging in the ocean after a loss of engine power on its right engine while…NTSB ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…NTSB ERA15CA069Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Wachula, FLThe pilot's improper recovery from a bounced landing during gusty crosswind conditions.NTSB CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB WPR15LA048Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Somerton, AZA loss of airplane control for reasons that could not be determined based on available evidence.NTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.NTSB ENG15RA003Incident · No injuriesForeign investigationATR ATR72 - 212A · Visby, SwedenOn November 30, 2014, an ATR72-212A airplane, SE-MDB, experienced excessive vibration during approach to Visby Airport(ESSV), Gotland, Sweden. The right engine was shut down and a single-engine landing was performed. Post-incident inspection found damage to…NTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB CEN15LA062Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Addison, TXThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a hard landing adjacent to the runway.NTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…NTSB ERA15LA063Accident · No injuriesLimited investigationFinal reportCessna 182 · Hartford, CTThe partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.NTSB DCA15WA030Accident · 4 fatalForeign investigationRobinson R44 - II · Dar es Salaam, TanzaniaNTSB CEN15LA068Accident · Serious injuriesLimited investigationFinal reportRans S-14 · Kewanee, ILThe pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.NTSB WPR15FA049Accident · 1 fatalField investigationFinal reportCessna 170B · Alzada, MTThe pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.NTSB ERA15LA062Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Hampton, SCThe pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…NTSB CEN15LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Berrien Springs, MIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15CA061Accident · No injuriesData collectionFinal reportAmerican Champion 7EC · Colorado Springs, COThe loss of airplane control after encountering windshear.NTSB CEN15LA066Accident · Minor injuriesLimited investigationFinal reportMD Helicopter MD 900 · Highlandville, MOThe pilot's inability to identify the power line during the initial approach in night visual meteorological conditions and his subsequent failure to avoid the power line once he identified it on final approach.NTSB ANC15LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Nikiski, AKThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat while operating at low-power settings in an area conducive to carburetor icing.NTSB ERA15CA065Accident · No injuriesData collectionFinal reportSocata TB 20 Trinidad · Hilton Head Island, SCThe pilot's inadvertent selection of an incorrect frequency, which resulted in his inability to activate the airport lighting, and his subsequent decision to continue the approach in dark night conditions despite having not positively identified the runway…NTSB ERA15WA207Accident · No injuriesForeign investigationBeech B300 · Samara, RussiaOn November 25, 2014, about 1852 universal coordinated time, a Beechcraft Corporation B300, Russian registration RA-02778, was substantially damaged when it landed with the landing gear retracted and slid off the runway at Kurumoch International Airport…NTSB WPR15CA069Accident · No injuriesData collectionFinal reportCessna 172M · ObyanThe student pilot's loss of airplane control during the landing flare in gusting wind conditions.NTSB ERA15LA058Accident · No injuriesLimited investigationFinal reportCessna T210 · Tampa, FLThe collapse of the left main landing gear for reasons that could not be determined during postaccident examination.NTSB ERA15CA059Accident · No injuriesData collectionFinal reportHiller OH 23B · Leesburg, VAA loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.NTSB DCA15CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Valdosta, GAan inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.NTSB CEN15WA080Accident · No injuriesForeign investigationGulfstream Aerospace G 1159A · London, United Kingdom