NTSB investigations, 2014
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CEN14LA519Accident · No injuriesLimited investigationFinal reportPiper PA 36-285 · Woodburn, INA loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB CEN14LA517Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Cahokia, ILThe pilot’s poor decision to take off with the clutch warning light illuminated, which resulted in the total failure of the fan assembly due to a lack of lubrication. Contributing to the accident was the mechanic’s failure to lubricate the lower actuator…NTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.NTSB CEN14FA505Accident · No injuriesField investigationFinal reportEmbraer EMB 505 · Conroe, TXThe second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…NTSB ANC14CA087Accident · No injuriesData collectionFinal reportHelio H 250 · Arctic Village, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in an inflight collision with terrain during takeoff.NTSB ENG14IA028Incident · No injuriesIncident investigationFinal reportAirbus A320 232 · Long Beach, CAThe probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…NTSB DCA14WA180Incident · No injuriesForeign investigationBoeing 737 · Eelde, NetherlandsThe government of Netherlands has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 18, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands's investigation under the…NTSB DCA14WA163Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · Stanstead, United KingdomThe Air Accidents Investigation Branch of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on September 18, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…NTSB CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.NTSB DCA15WA016Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · Malaga, SpainNTSB CEN14WA509Accident · No injuriesForeign investigationMaule M 7-235B · Le Touquet, FranceNTSB ANC14CA084Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cantwell, AKThe pilot's loss of directional control during takeoff from an off-airport site, which resulted in a collision with terrain.NTSB ERA14WA443Accident · No injuriesForeign investigationRobinson R22 - Beta · Amaga, ColombiaOn August 28, 2014, about 2040 Universal Coordinated Time (UTC), a Robinson R22, Columbian registration HK 4287, operated by Halcones Aviation Flight School, was substantially damaged when it impacted terrain and rolled over following a loss of engine power…NTSB ERA14FA455Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Fort Gaines, GAThe pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.NTSB DCA14CA161Accident · No injuriesData collectionFinal reportBoeing 757 223 · Miami, FLThe failure of the first officer to control the airplane pitch after touchdown. Contributing to the accident was the first officers inexperience in the aircraft type.NTSB CEN14WA498Accident · 2 fatalForeign investigationAgusta Bell 206B · Flamborough, United KingdomOn September 16, 2014, at 1241 coordinated universal time, an Agusta-Bell 206B helicopter, G-SUEX, impacted the water off the coast of Flamborough, Lincolnshire, United Kingdom. The pilot and passenger were both fatally injured. The helicopter was destroyed.…NTSB CEN14CA501Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Longville, MNThe pilot's loss of control during an attempted go-around following a multiple bounce landingNTSB ANC14CA083Accident · No injuriesData collectionFinal reportCessna 175 · Ambler, AKThe pilot's decision to takeoff from a rough airstrip in gusty wind conditions, which resulted in a loss of control.NTSB ANC14CA082Accident · Minor injuriesData collectionFinal reportHelio H 295 · Prospect Creek, AKThe pilot's loss of directional control during takeoff, in gusty and variable wind conditions, resulting in a collision with terrain.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB ERA14LA440Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · St. Petersburg, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning and in-flight fuel management.NTSB CEN14CA500Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Beaumont, TXThe pilot's loss tail rotor effectiveness while attempting a taxiway side-step during landing. Contributing to the accident was another pilot's failure to ensure the runway was clear before occupying the runway for takeoff.NTSB WPR14CA375Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Kahului, Maui, HIThe pilot's failure to maintain clearance from the cart while hovering. Contributing to the accident was the failure of ground personnel to remove the cart from the helipad.NTSB ERA14WA439Accident · 2 fatalForeign investigationBeech BE-300-LW · Buenos Aires, ArgentinaOn September 14, 2014, about 1520 coordinated universal time, a Beech BE-300-LW, Argentine registration LV-WLT, was destroyed while the airplane was on the initial approach in instrument meteorological conditions to Jorge Newbery Airport (SABE), Buenos Aires,…NTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB ERA14CA452Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's self-induced pressure to land due to the deteriorating weather conditions.NTSB CEN15WA102Accident · No injuriesForeign investigationBoeing PT-17 · San Jose, GuatemalaOn September 14, 2014, at 2314 coordinated universal time, a Boeing PT-17, Guatemalian registration TG-JEN, operated by KEHA S.A., was destroyed when it impacted water while performing aerobatic maneuvers near San Jose, Guatemala. The pilot was not injured.…NTSB CEN14CA514Accident · No injuriesData collectionFinal reportStanley Arthur Freeman Zodiac 601XL · Fremont, NEThe pilot's improper landing flare which resulted in a hard landing.NTSB WPR14LA394Accident · No injuriesLimited investigationFinal reportLorentzen Lancair Legacy · Reno, NVThe shearing of mounting bolts that attached the right turbocharger to its mounting bracket during an air race, which resulted in hot exhaust gases leaking into the engine compartment and starting a fire.NTSB WPR14CA396Accident · Minor injuriesData collectionFinal reportUltramagic N250 - NO Series · Phoenix, AZThe pilot's failure to maintain aircraft control while landing in downdraft and gusting wind conditions which resulted in striking trees and a subsequent hard landing.NTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.NTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…NTSB DCA14CA170Accident · Minor injuriesData collectionFinal reportEmbraer EMB 145XR · Chicago, ILThe tractor driver's failure to give way to the taxiing airplane.NTSB CEN15WA043Accident · No injuriesForeign investigationDiamond DA20 - C1 · Hveragerdi, Iceland, IcelandOn September 13, 2014, at 1007 universal coordinated time (UTC), a Diamond DA20-C1, Icelandic registration TF-FGC, was substantially damaged during an forced landing near Hveragerdi, Iceland, after experiencing a loss of power 11 minutes after takeoff. There…NTSB ANC14CA080Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Aniak, AKThe pilot's inability to maintain directional control of the airplane resulting in a separation of the wheel axle, resulting in a collision with terrain.NTSB ANC14CA079Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Susitna, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.NTSB ANC14CA078Accident · No injuriesData collectionFinal reportCessna 180H · Nenana, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, while landing during dark night conditions.NTSB WPR14LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Tombstone, AZA partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.NTSB DCA14WA172Accident · Serious injuriesForeign investigationBoeing 767 - 346 · Seoul, South KoreaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767-300, which occurred on September 12, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of…NTSB CEN14WA510Accident · 1 fatalForeign investigationCessna Reims F152 · Sagres, PortugalOn September 12, 2014, about 1000 coordinated universal time, a Cessna Reims, F152 single-engine airplane, serial number 1612, registry CS-AYH, was destroyed after ditching along the seashore of Sagres, Portugal. The pilot was fatally injured. At the time of…NTSB CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.NTSB CEN14CA503Accident · No injuriesData collectionFinal reportMaule MT 7-260 · Largo Vista, TXThe pilot's inadequate compensation for gusting wind conditions during takeoff, which resulted in the nose landing gear impacting the runway and the subsequent collapse of the nose landing gear.NTSB CEN14CA499Accident · Serious injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Newark, ILThe student pilot did not maintain proper airspeed during the simulated emergency landing and failed to relinquish control to the flight instructor when the flight instructor attempted to intervene, which resulted in the loss of control. Contributing was the…NTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.NTSB WPR14CA372Accident · Minor injuriesData collectionFinal reportFound Acft Canada FBA 2C1 · Cascade, IDThe pilot's failure to maintain directional control during landing.NTSB ERA14LA434Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spruce Creek, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilots’ improper preflight and in-flight fuel planning.NTSB CEN14WA534Incident · No injuriesForeign investigationAgustawestland AW139 · Umea, SwedenOn September 11, 2014, at 1230 coordinated universal time, an Agusta Westland AW139, SE-JRH, experienced a detachment of the slip ring assembly for anti-icing of the tail rotor, near Umea Airport (ESNU), Umea, Sweden. The helicopter landed at ESNU without…NTSB CEN14WA502Accident · 1 fatalForeign investigationDiamond Aircraft Ind DA 40 · Kulusuk, GreenlandOn September 11, 2014, about 1600 coordinated universal time, a Diamond Aircraft Industries Inc. DA 40 airplane, N39SE, owned and operated by Milou 1 LLC, was substantially damaged when it impacted terrain near Kulusuk, Greenland. Visual meteorological…NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…