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 DCA15WA009Incident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Maiquetia, Vargas, VenezuelaThe Director General para la Prevencion e Investigacion de Accidentes Aereos of the Republica Bolivariana De Venezuela has notified the NTSB of an incident involving a McDonnell Douglas MD-83, registration YV2971, which occurred on October 11, 2014. The NTSB…NTSB CEN15CA016Accident · No injuriesData collectionFinal reportCessna 180B · Coloma, MIThe pilot did not use the departure checklist, resulting in an inadvertent landing with the pontoon wheels extended.NTSB CEN15CA011Accident · No injuriesData collectionFinal reportBeech 35-B33 · Effingham, ILThe pilot's failure to lower the landing gear.NTSB WPR15LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Bend, ORA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat after takeoff and during the climb.NTSB ERA15CA013Accident · No injuriesData collectionFinal reportChampion 7FC · Reidsville, NCThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.NTSB ENG15IA037Incident · No injuriesIncident investigationFinal reportBoeing 787-8 · London, United KingdomA shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…NTSB CEN15CA013Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ann Arbor, MIThe collision with a deer during a night takeoff.NTSB CEN15LA020Accident · No injuriesLimited investigationFinal reportKovars Gary D Zenith Zodiak 601XL · Richland Center, WIThe loss of engine power due to carburetor icing.NTSB ANC15CA002Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cordova, AKThe pilots decision to land and failure to maintain control of the airplane during landing in gusty wind conditions.NTSB ANC15CA001Accident · No injuriesData collectionFinal reportCessna 180J · Gustavus, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB WPR15CA007Accident · No injuriesData collectionFinal reportCessna T182T · Van Nuys, CAThe pilot's failure to monitor the distance between the left wing and blast fence while maneuvering behind another airplane.NTSB WPR15CA006Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Big Creek, IDThe pilot's failure to maintain aircraft control while on final approach with shifting wind conditions.NTSB WPR15WA019Accident · 1 fatalForeign investigationRobinson R44 II · Mount Arthur, New Zealand, New ZealandOn October 7, 2014, at an unknown time, a Robinson R44, ZK-HBQ, collided with terrain near Mount Arthur, New Zealand. The helicopter was operated by Helicopter Charter Karamea under the pertinent civil regulations of the government of New Zealand. The pilot…NTSB WPR15GA005Accident · 1 fatalFinal reportMarsh S 2F3AT · El Portal, CAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.NTSB CEN15CA006Accident · Minor injuriesData collectionFinal reportPiper PA 31-350 · Glenham, SDThe pilot's improper fuel management, which resulted in losses of power on both engines due to fuel exhaustion.NTSB ERA15WA050Accident · No injuriesForeign investigationCessna A188B · Rozo, ColombiaNTSB ERA15CA010Accident · No injuriesData collectionFinal reportToerner Bob SEA REY · Tampa, FLThe pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.NTSB WPR15LA003Accident · No injuriesLimited investigationFinal reportCorben Baby Ace D · Lincoln, CAThe total loss of engine power due to fuel starvation, which resulted from debris restricting the fuel flow within the fuel system.NTSB WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.NTSB ERA15LA006Accident · Serious injuriesLimited investigationFinal reportSocata TBM 700 · Fayetteville, GAThe pilot’s inadvertent deactivation of the yaw damper in flight, which resulted in a prolonged side-slip condition that led to fuel starvation and the eventual total loss of engine power. Contributing to the accident was the pilot’s failure to attempt to…NTSB DCA15FA004Accident · No injuriesField investigationFinal reportEmbraer EMB 145LR · Jamaica, NYThe A340 captain's failure to maintain adequate clearance between his wing and the tail of the EMB-145.NTSB CEN15LA004Accident · 2 fatalLimited investigationFinal reportCelier Xenon R · Loma, COThe pilot’s failure to maintain clearance from a static wire and his decision to maneuver the gyroplane at low altitude.NTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.NTSB ERA15IA008Incident · No injuriesIncident investigationFinal reportCessna S550 · Tampa, FLThe lack of flat roller bearings in the two elevator trim tab actuators and maintenance personnel’s inadequate lubrication of the left elevator trim tab actuator, both of which resulted in the overstress fracture of the left internal screw and subsequent…NTSB ERA15CA012Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesboro, VAThe glider's inadvertent encounter with low altitude wind shear.NTSB ERA15CA007Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Maryville, TNThe pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.NTSB ERA15CA005Accident · No injuriesData collectionFinal reportHPH 304CZ · Pikeville, TNA loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.NTSB DCA15WA021Incident · No injuriesForeign investigationAirbus 330-200 · Karachi, PakistanThe United Arab Emirates General Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving an Emirates AIRBUS 330-200 that occurred on October 04, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA…NTSB CEN15LA021Accident · No injuriesLimited investigationFinal reportRaytheon 58 · Dixon, ILThe pilots’ improper decision to continue flight in icing conditions after the deicing boots could not shed accumulated ice, which resulted in a temporary loss of airplane control.NTSB CEN15FA003Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L 1 · Wichita Falls, TXThe pilot’s failure to maintain yaw control when he applied power to execute a go-around at a low airspeed in dark, night conditions, which resulted in a rapid, uncommanded right yaw due to a loss of tail rotor effectiveness.NTSB CEN15CA005Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe pilot's inadequate flight preparation and navigation during a training flight resulting in collision with low wires.NTSB WPR15LA001Accident · 1 fatalLimited investigationFinal reportGaston Thomas D Thunder Mustang · Council, IDThe pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.NTSB ERA15FA003Accident · 1 fatalField investigationFinal reportMiller Raymond A Sonex Waiex · Palm Coast, FLA total loss of engine power during cruise flight for reasons that could not be determined due to the postaccident condition of the engine and its associated fuel and ignition systems.NTSB DCA15WA002Accident · Serious injuriesForeign investigationBoeing 777 223 · Buenos Aires, ArgentinaNTSB CEN15CA007Accident · Serious injuriesData collectionFinal reportBell 206B · Atlanta, ARThe pilot's inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.NTSB WPR15CA012Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's failure to maintain directional control during landing.NTSB ERA15IA009Incident · No injuriesIncident investigationFinal reportFunk Ralph Velocity Xlrg · Atlanta, GAThe pilot’s failure to maintain directional control during a hard landing, which resulted in the fracture of the nose landing gear.NTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.NTSB CEN15LA002Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodsboro, TXThe pilot’s failure to recognize and correct for flight conditions conducive to a loss of tail rotor effectiveness, which resulted in a rapid, uncommanded right yaw and subsequent hard landing.NTSB ERA15WA004Accident · 5 fatalForeign investigationCessna T206H · Sarayacu, Pastaza, EcuadorOn October 1, 2014, about 2200 universal coordinated time, a Cessna T206H, Ecuadorian registration HC-CLO, was destroyed when it impacted a field while returning to land at an airstrip in Sarayacu, Pastaza, Ecuador, after a loss of engine power during initial…NTSB ERA15LA001Accident · 1 fatalLimited investigationFinal reportAir Command 582 · Monongahela, PAThe amateur-built gyroplane’s collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s decision to conduct the flight without obtaining additional training.NTSB CEN15CA001Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Yankton, SDThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.NTSB ANC14CA090Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Port Alsworth, AKThe pilots failure to maintain control of the airplane during an aborted landing in gusty wind conditions.NTSB DCA15WA042Incident · No injuriesForeign investigationBoeing 737-800 · Geneva, SwitzerlandThe Directorate General of Civil Aviation (DGCA) of the Republic of Turkey, has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 29, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA…NTSB CEN14LA526Accident · Serious injuriesLimited investigationFinal reportPreiss Vans RV-9A · Hobart, OKA loss of engine power due to fuel exhaustion, which resulted from the pilot's erroneous preflight fuel calculations and inadequate in-flight fuel management.NTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…NTSB ANC14CA089Accident · No injuriesData collectionFinal reportCessna 180 · Kodiak, AKThe pilots failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB WPR14CA397Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Rancho Murieta, CAThe student pilot's failure to maintain adequate airspeed during takeoff and the certified flight instructors delayed remedial action, which resulted in the stall.NTSB ERA14LA465Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A · Ceiba, PRThe pilot’s loss of consciousness during taxi for reasons that could not be determined based on the available information.