NTSB investigations, 2014
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\") = 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 WPR14CA317Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hazelton, IDThe pilot's failure to maintain aircraft control during takeoff roll in variable wind conditions.NTSB ERA14LA363Accident · 1 fatalLimited investigationFinal reportTemco GC 1B · Yulee, FLThe pilot’s failure to maintain airplane control, which resulted in subsequent impact with terrain.NTSB ANC14LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot’s failure to maintain directional control during the landing due to his decision to attempt a landing with a quartering tailwind, which resulted in a ground loop and impact with the runway surface.NTSB WPR14LA315Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 C · Susanville, CAThe pilot’s failure to follow the checklist while starting the engine and to lock the engine primer plunger, which resulted in the partial loss of engine power during cruise flight in high density altitude conditions.NTSB ERA14LA362Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s…NTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.NTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.NTSB CEN14LA393Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Pueblo, COA total loss of engine power due to fuel starvation, which resulted from the pilot’s improper fuel management and resulted in a forced landing on unsuitable terrain.NTSB CEN14FA389Accident · 2 fatalField investigationFinal reportFedersen Walter Lancair IVP · Findlay, OHAn in-flight fire for reasons that could not be determined due to the extent of impact and fire damage.NTSB WPR14LA312Accident · Minor injuriesLimited investigationFinal reportRoscher Frederick Thunder Mustang · Spanish Springs, NVA complete loss of engine power during climb for reasons that could not be determined due to the severity of postcrash fire damage to the airplane.NTSB WPR14CA314Accident · No injuriesData collectionFinal reportCessna 182Q · Warren, IDThe pilot's attempt to depart on an unpaved road, which he mistook for the unpaved runway. Contributing to the accident was the fact that the road and the runway were conjoined for the first few hundred feet of the runway.NTSB ERA14LA361Accident · No injuriesLimited investigationFinal reportHiller UH 12E · Wadesboro, NCA partial loss of engine power due to the failure of the No. 2 engine accessory gearbox bearing for reasons that could not be determined based on the available information.NTSB ERA14LA360Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Newnan, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.NTSB CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.NTSB CEN14CA392Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Caputa, SDThe student pilot's improper takeoff procedure and the flight instructor's failure to take control of the airplane and abort the takeoff.NTSB ANC14CA061Accident · No injuriesData collectionFinal reportAviat A 1 · Ketchikan, AKThe pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.NTSB WPR14LA313Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVThe airplane flight crew’s failure to exercise the necessary vigilance and precautions and yield the right of way to the landing helicopter, which resulted in the airplane colliding with the helicopter. Contributing to the accident was the helicopter pilot’s…NTSB ERA14LA368Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C G-164B · Bonifay, FLA partial blockage of the No. 2 bearing oil nozzle jet by bearing material, which resulted in oil starvation and the subsequent failure of the No. 2 bearing and total loss of engine power.NTSB ERA14LA358Accident · Serious injuriesLimited investigationFinal reportWinder Robert S VP1 · Grove City, PAA collision with terrain during the landing approach for reasons that could not be determined based on available information.NTSB CEN14LA397Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US A-180 · Questa, NMThe hard landing after both burner pilot lights extinguished during the landing approach. Contributing to the accident was the pilot's inability to relight the burner pilot lights.NTSB CEN14CA391Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Osage, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…NTSB ERA14CA357Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lafollette, TNThe pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.NTSB DCA14RA129Accident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Gossi, MaliThe Mali Commission d'Enquete Accident et Incident d'Aviation Civile (CEAIAC) has notified the NTSB of an accident involving a McDonald Douglas DC-9-83 that occurred on July 24, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB WPR14FA310Accident · 1 fatalField investigationFinal reportBell 206A · Wenatchee, WAThe pilot's failure to maintain a proper decent rate and path, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's impairment by a sedating medication.NTSB ERA14WA356Accident · 2 fatalForeign investigationRobinson R44 · Ivashka Township, RussiaOn July 23, 2014, at 0809 Coordinated Universal Time (UTC), a Robinson R44, Russian registration RA-1975G, impacted the waters of the Ivashka River, under unknown circumstances, near Ivashka Township, Russia. The pilot and one passenger were fatally injured.…NTSB ERA14LA351Accident · Serious injuriesLimited investigationFinal reportSiler Ronald E Ultrastar · Halifax, PAA total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…NTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…NTSB ERA14CA353Accident · No injuriesData collectionFinal reportJannakos Gregory P Zodiac 601 HDS · Lawrenceville, GAThe pilot's inadequate flare, which resulted in a hard landing.NTSB ENG14WA021Accident · 58 fatalForeign investigationATR 72-500 · Makung, TaiwanThe Aviation Safety Council of Taiwan provided this information: On July 23, 2014, an ATR 72-212A, registered B-22810, operated by Transasia, took off from Kaohsiung bound for Magong. The crew was directed to enter a holding pattern because of reported…NTSB CEN14CA395Accident · No injuriesData collectionFinal reportCessna A188B · Milford, NEThe pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.NTSB WPR14LA309Accident · 2 fatalLimited investigationFinal reportBeech A36 · Pago Pago, AntarcticaA loss of airplane control during the initial climb in gusting wind conditions for reasons that could not be determined because the wreckage was not recovered from the ocean.NTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…NTSB WPR14LA307Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Auburn, WAA collapse of the nose landing gear for reasons that could not be determined based on the available information.NTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.NTSB CEN14LA387Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Flushing, MIThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…NTSB WPR14LA305Accident · 1 fatalLimited investigationFinal reportCessna 150M · Russian Flat, MTThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…NTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.NTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.NTSB WPR14CA306Accident · No injuriesData collectionFinal reportBosco Don Searey · Mount Vernon, WAThe pilot's failure to maintain lateral control while taxiing. Contributing to the accident was the incorrect decision to takeoff once the sponson had been damaged.NTSB ERA14CA348Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Titusville, FLThe student pilot's failure to initiate the decelerative flare during autorotation and the CFI's delayed remedial action, which resulted in a hard landing.NTSB CEN14CA381Accident · No injuriesData collectionFinal reportCessna 150D · Greenfield, INThe student pilot failed to maintain directional control while landing with a crosswind.NTSB WPR14WA304Accident · 1 fatalForeign investigationCessna 182 - L · Albury Aerodrome, AustraliaOn July 20, 2014 about 1600 local time, a Cessna 182L airplane, Australian registration VH-TRS, collided with terrain near Albury Aerodrome, New South Wales, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane…NTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.NTSB ERA14LA347Accident · Serious injuriesLimited investigationFinal reportColt Balloons 160A · Clinton, MAThe pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…NTSB ERA14LA346Accident · 1 fatalLimited investigationFinal reportCessna 172N · Elliott Key, FLThe airplane’s vertical descent into water for reasons that could not be determined because postaccident airplane examinations revealed no mechanical anomalies.NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN14FA377Accident · 1 fatalField investigationFinal reportOden Weldon Pat Kitfox IV Speedster · Blackwell, TXThe pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14CA386Accident · No injuriesData collectionFinal reportBlack Christopher Sparrow Sport Spec · Moriarty, NMThe pilot's loss of directional control while landing in gusty crosswind conditions. Contributing to the accident was the pilot's operation of the engine above its normal temperature limit on takeoff.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.