NTSB investigations, 2013
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\") = 2013 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") = 2013 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 ERA14CA001Accident · No injuriesData collectionFinal reportCessna 172P · Christmas, FLAn inflight collision with a bird during cruise flight.NTSB CEN14WA029Accident · 14 fatalForeign investigationCessna 208B · Loreto, BCS, MexicoOn October 14, 2013, about 1401 universal time coordinated, a Cessna 208B, XA-TXM, was destroyed when it impacted terrain near Loreto, Baja California Sur, Mexico. The pilot and thirteen passengers on board were fatally injured. The flight originated from the…NTSB CEN14LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-300 · Hector, ARAn engine failure due to crankshaft fatigue cracking for reasons that could not be determined based on the available evidence.NTSB ERA14WA029Accident · 2 fatalForeign investigationRobinson R44 - II · Beles, KazakhstanOn October 13, 2013, at an unknown time, a Robinson R44-II helicopter, 22L2, Russian registration UP-RB002, operated by a private individual impacted flat terrain near Beles, Kazakhastan, Russia. Night visual meteorological conditions prevailed, and flight…NTSB ERA14WA020Accident · 1 fatalForeign investigationBell 407 - NO Series · Gobierno, ArgentinaOn October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…NTSB CEN14CA018Accident · No injuriesData collectionFinal reportBeech A36 · Telluride, COThe pilot's decision to take off in gusting tailwinds resulting in exceeding the performance capabilities of the airplane and subsequent loss of control.NTSB WPR14LA051Accident · No injuriesLimited investigationFinal reportPiper PA 31P · Calexico, CAThe pilot’s failure to maintain the proper pitch attitude during the landing, which resulted in the nose landing gear contacting the surface hard and then separating from the airplane.NTSB WPR14CA016Accident · No injuriesData collectionFinal reportChampion 7ECA · Willows, CAThe pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.NTSB WPR14CA015Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Rio Verde, AZThe pilot's failure to maintain directional control during the takeoff roll on a rough and rutted surface.NTSB CEN14WA115Accident · No injuriesForeign investigationGulfstream 550 · London, United KingdomOn October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…NTSB CEN14WA013Accident · 2 fatalForeign investigationEnstrom 280 - FX · Wolica Kozia, PolandOn October 12, 2013, about 0928 hours universal coordinated time, an Enstrom 280FX, Poland registration SP-GMB, impacted trees and terrain near Wolica Kozia, Poland. The pilot and passenger were fatally injured. The accident investigation is under the…NTSB CEN14LA053Accident · No injuriesLimited investigationFinal reportCessna 525A · Lincoln, NEThe airplane’s encounter with a flock of American White Pelicans, which resulted in one bird striking the right outboard wing during en route climb from the departure airport.NTSB WPR14LA014Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L 1 · Seeley, CAThe total loss of engine power due to the failure of the No. 4 bearing.NTSB WPR14CA013Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Cody, WYA loss of engine power during climb to cruise for reasons that could not be determined due to no postaccident examination.NTSB CEN14LA045Accident · No injuriesLimited investigationFinal reportSutphin Rans S-12 · French Lick, INThe pilot's failure to maintain adequate airspeed while in a steep turn, which resulted in an aerodynamic stall/mush at a low altitude.NTSB ERA14LA006Accident · 4 fatalLimited investigationFinal reportCessna 340A · Hampton Roads, VAThe pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.NTSB ENG14WA002Incident · No injuriesForeign investigationAirbus A330 - 302 · Caines, Australia, AustraliaOn October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…NTSB CEN14CA023Accident · No injuriesData collectionFinal reportCessna 172R · Tomball, TXThe student pilot delay in aborting the takeoff which resulted in the airplane going off the end of the runway and impacting trees.NTSB ANC14CA004Accident · No injuriesData collectionFinal reportPiper J3C 65 · Talkeetna, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.NTSB WPR14FA012Accident · 2 fatalField investigationFinal reportMooney M20E · Julian, CAThe pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.NTSB CEN14LA007Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US V 77 · Rio Rancho, NMThe pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.NTSB CEN14LA006Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Xenia, OHThe nose landing gear failure as a result of a fatigue fracture of the engine mount nose gear actuator feet in an area detailed in a service bulletin. Contributing to the accident was maintenance personnel’s inadequate completion of the inspection specified…NTSB CEN14FA004Accident · 1 fatalField investigationFinal reportBell 206L 3 · Venice, LAA total loss of engine power due to the liberation of a second stage turbine blade near the blade root due to a high-cycle fatigue crack and subsequent overload. Although extensive testing and materials analysis was performed, the reason for crack initiation…NTSB CEN14CA026Accident · No injuriesData collectionFinal reportCessna 310R · Onaway, MIAn inadvertent collision with a deer during landing.NTSB WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.NTSB ERA14LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Ridgely, MDA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA14IA019Incident · No injuriesIncident investigationFinal reportPiper PA 46 350P · Tallahassee, FLThe failure of the nose landing gear (NLG) actuator attachment bolt due to fatigue for reasons that could not be determined during postincident examination, which resulted in the NLG collapsing during landing.NTSB CEN14LA002Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Brownwood, TXA loss of engine power due to fuel starvation, which resulted from a foreign material in the fuel system blocking the fuel flow to the engine.NTSB CEN14LA003Accident · Serious injuriesLimited investigationFinal reportKenneth M Franz Ultra PUP · Belleville, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while turning back to the airport instead of landing straight ahead following a partial loss of engine power, which resulted in an aerodynamic…NTSB ANC14CA001Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Iliamna, AKThe pilot's failure to maintain aircraft control during the landing roll with a tailwind.NTSB WPR14LA008Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas Heli 369 · Paducah, TXThe pilot’s failure to maintain clearance from a power transmission line tower while maneuvering to pick up a rope in gusting wind conditions.NTSB WPR14LA007Accident · 3 fatalLimited investigationFinal reportPiper PA32 - 300 · Tinian IslandThe pilot’s failure to maintain terrain clearance while maneuvering at low altitude in dark night conditions.NTSB WPR14CA009Accident · Serious injuriesData collectionFinal reportBeech A36 · Tilden, TXThe pilot's decision to continue the takeoff from a wet and soft airstrip which resulted in his failure to maintain adequate airspeed and aircraft control during the takeoff initial climb.NTSB ERA14LA007Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-8 · Culebra, PRThe pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.NTSB WPR14WA098Accident · 1 fatalForeign investigationAmateur Built KR-2 · Tumut, New South Wales, AustraliaOn October 5, 2013, at 0900 local time, an amateur built aircraft, KR-2, VH-CTE, collided with the terrain shortly after takeoff from a private airstrip near Tumut, New South Wales. The flight was operated by the pilot under the pertinent civil regulations of…NTSB WPR14CA006Accident · Minor injuriesData collectionFinal reportSiemens Rotorway Exec 162F · Nampa, IDA flight control malfunction during cruise flight for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.NTSB ERA14LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 - F · Gainesville, FLA total loss of engine power for reasons that could not be determined because a postaccident engine examination and test run revealed no anomalies.NTSB CEN14LA005Accident · Serious injuriesLimited investigationFinal reportCameron N105 - NO Series · Albuquerque, NMThe pilot's decision to land the balloon from a high approach altitude due to high winds, which resulted in a hard landing.NTSB WPR14LA005Accident · 4 fatalLimited investigationFinal reportCessna 340A · Paulden, AZThe pilot’s failure to maintain sufficient altitude to clear a radio tower while maneuvering at low altitude and his decision to make a high-speed, low pass over the gun club.NTSB ERA14LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Selinsgrove, PAThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during postmaintenance checks and the pilot's inadequate preflight check.NTSB CEN14WA536Accident · No injuriesForeign investigationSikorsky S92 · Stavanger, NorwayOn October 4, 2013, at 1435 coordinated universal time (UTC), a Sikorsky S-92A helicopter, Norwegian registration LN-ONW, made an emergency landing on the unmanned and decommissioned Yme oil rig. The two crew members and 12 passengers were uninjured. The…NTSB CEN14WA083Accident · No injuriesForeign investigationRockwell Commander · Stockholm, Sweden, SwedenOn October 4, 2013, about 1250 UTC, a Rockwell Commander 112, SE-FLS (s/n 350) was involved in a runway excursion after landing when the pilot was unable to maintain directional control during roll out. The airplane was substantially damaged and there were no…NTSB CEN14WA001Accident · Minor injuriesForeign investigationBell 206 - B · Upper Edgebold, United KingdomOn October 4, 2013, at 1715 UTC, a Bell 206B, United Kingdom registration G-BPWI, was substantially damaged when it impacted terrain and rolled over following a loss of engine power near Upper Edgebold near Shrewsbury, Shopshire, England. The pilot, the sole…NTSB WPR14CA004Accident · Minor injuriesData collectionFinal reportVenables Zenith CH701 · Snohomish, WAA jammed rudder control while maneuvering in the pattern for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.NTSB ERA14LA035Accident · Serious injuriesLimited investigationFinal reportAirborne Edge Executive · Eustis, FLThe pilot's inadvertent stalling of the wing following a total loss of engine power for reasons that could not be determined during postaccident examinations, which resulted in a hard landing.NTSB DCA14WA177Accident · No injuriesForeign investigationEmbraer EMB120 · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving an Embraer120 airplane that occurred on October 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…NTSB DCA14WA004Incident · No injuriesForeign investigationBoeing 777-200 · Changi, SingaporeThe Air Accident Investigation Bureau of Singapore has notified the NTSB of an incident involving a Boeing 777-200, 9V-SWG, which occurred on October 3, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB WPR14CA003Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Wellton, AZThe pilot’s distracted attention and failure to maintain sufficient altitude to clear terrain while maneuvering in dark night conditions.NTSB CEN14CA041Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Benton Harbor, MIThe pilot's failure to maintain aircraft control during engine start.NTSB CEN14CA017Accident · No injuriesData collectionFinal reportRobinson R22 - Beta · Chicago, ILThe flight instructor's failure to take remedial action in a timely manner.