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 ERA14CA398Accident · No injuriesData collectionFinal reportCessna 172F · Oxford, NCThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's improper compensation for wind conditions.NTSB ANC14CA064Accident · No injuriesData collectionFinal reportCessna 182A · Gustavus, AKThe pilot's unstable landing approach which resulted in a long landing, and subsequent collision with terrain.NTSB WPR14LA345Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-236 · Salmon, IDMaintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…NTSB WPR14LA343Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Rimrock, AZThe pilot's failure to maintain control of the airplane during the landing roll on a wet sloping runway and his decision to go around before the airplane was configured for takeoff.NTSB WPR14CA344Accident · No injuriesData collectionFinal reportCessna 177 · Pine Bluffs, WYThe pilot's inadequate flare and failure to maintain aircraft control while landing.NTSB ERA14RA384Accident · 7 fatalForeign investigationCessna 560XL · Santos, BrazilOn August 13, 2014, about 1003 hours local, a Cessna 560 XL, Brazilian Registration PR-AFA, impacted a densely populated residential area, first colliding with a building then the ground in Santos, SP, Brazil, following an approach to Base Aerea De Santos…NTSB CEN14LA432Accident · No injuriesLimited investigationFinal reportCessna 188 - Undesignat · Columbus, NMThe pilot’s failure to release the load of agricultural product before the landing approach and his failure to maintain aircraft control during an initial climb after an aborted landing, which resulted in the airplane exceeding its critical angle of attack…NTSB CEN14LA425Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Braithwaite, LAThe pilot's mismanagement of the fuel system, which resulted in a total loss of engine power due to fuel starvation and the subsequent forced landing.NTSB CEN14CA427Accident · Serious injuriesData collectionFinal reportAir Tractor AT 401B · Cimarron, KSThe pilot's failure to maintain clearance from the antenna guy wire during an aerial application pass.NTSB CEN14CA426Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Lancaster, WIThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during an aerial application flight.NTSB WPR14LA341Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Idaho Falls, IDThe pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA14LA383Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S · Sarasota, FLA total loss of engine power due to fuel exhaustion, which resulted from the flight instructor's inadequate preflight fuel planning.NTSB CEN15WA115Accident · No injuriesForeign investigationRans S7 · Cambaie, Reunion Island, FranceNTSB CEN14WA538Incident · No injuriesForeign investigationPiper PA12 · Reykjavik, IcelandNTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.NTSB WPR14LA340Accident · No injuriesLimited investigationFinal reportHughes 269C · Darrington, WAMaintenance personnel’s failure to secure the throttle mount bracket during a recent engine installation, which resulted in the loss of throttle movement and an inability to control engine power.NTSB ERA14CA406Accident · No injuriesData collectionFinal reportPiper PA 34-200T · Gainesville, FLThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB CEN14LA419Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · South Haven, MIThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.NTSB ANC14CA063Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilots excessive use of the airplanes brakes during the landing roll, which resulted in a nose over. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.NTSB WPR14LA338Accident · No injuriesClass 3 · LimitedFinal reportNelson RV 3M · North Plains, ORA partial loss of engine power for undetermined reasons which resulted in a landing gear collapse during the precautionary landing to a field.NTSB WPR14LA337Accident · No injuriesLimited investigationFinal reportRyan Navion · Fresno, CAA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14LA336Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · West Jordan, UTA partial loss of engine power during initial climb for reasons that could not be determined due to the severity of the damage to the engine.NTSB WPR14LA335Accident · No injuriesLimited investigationFinal reportCessna 180A · Salmon, IDA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…NTSB ERA14LA378Accident · Minor injuriesLimited investigationFinal reportBirchler Boyd Eagle 540 · Standish, METhe total loss of engine power due to fuel starvation 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 ERA14CA438Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Block Island, RIA loss of control during the attempted go-around, which resulted in an aerodynamic stall and impact with trees.NTSB DCA14CA147Accident · No injuriesData collectionFinal reportDehavilland DHC 8 102 · Harrisburg, PAthe airplanes collision with geese during the takeoff roll.NTSB CEN14LA431Accident · Serious injuriesLimited investigationFinal reportAeronca S11AC · Boulder Junction, WIThe pilot’s improper runway selection, which resulted in a tailwind landing, and his subsequent failure to maintain directional control.NTSB CEN14LA415Accident · 1 fatalLimited investigationFinal reportBell 47G 2 · Jeanerette, LAThe pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN14CA482Accident · No injuriesData collectionFinal reportBeech 95 B55 (T42A) · Bremond, TXMismanagement of fuel, which resulted in a total loss of power due to fuel starvation.NTSB ANC14FA062Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Big Lake, AKThe pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from trees.NTSB WPR14CA333Accident · Minor injuriesData collectionFinal reportKitfox Series 5 · Kamiah, IDA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.NTSB ERA14WA442Accident · 1 fatalForeign investigationCessna 182 - P · Mitu, ColombiaOn September 8, 2014, about 2120 coordinated universal time, a Cessna 182P, Colombian registration HK-1921, was substantially damaged while ditching into the Vaupes River near Mitu, Columbia. The pilot sustained minor injuries, one passenger was seriously…NTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.NTSB ERA14CA400Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Stow, MAThe flight instructor/pilot's failure to recover from a bounced landing, which resulted in a hard landing and the subsequent collapse of the nose landing gear. Contributing to the accident was the flight instructor's lack of total experience in the make and…NTSB ERA14CA379Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Lakeville, NYThe pilot's decision to favor the right side of the relatively narrow turf runway while landing, resulting in inadvertent contact with tall grass and a berm.NTSB CEN14WA516Accident · Minor injuriesForeign investigationSchweizer 269C · Stockerau, AustriaOn August 9, 2014, at 0916 universal coordinated time, a Schweizer model 269C helicopter, Austrian registration OE-XRL, serial number S1716, sustained substantial damage during landing at the Stockerau Airport (LOAU), near Stockerau, Austria. The pilot and…NTSB CEN14LA430Accident · No injuriesLimited investigationFinal reportBombardier CL600 2D24 - 900 · San Antonio, TXFailure of the tow bar shear pin, which resulted in the tug operator’s loss of control of the airplane during pushback operations. Contributing to the accident was the tug operator’s inability to communicate to the flight crew to apply the airplane’s brakes.NTSB CEN14LA424Accident · 2 fatalLimited investigationFinal reportBarger Steve M RV-7A · Russell, IAThe noninstrument-rated pilot’s inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.NTSB CEN14FA414Accident · 2 fatalField investigationFinal reportPiper PA 28R-201 · Steamboat Springs, COThe pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…NTSB WPR14CA339Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Lysite, WYThe pilot's failure to ensure the airplane was configured for takeoff.NTSB WPR14CA334Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Bakersfield, CAThe pilot's failure to maintain an adequate approach which resulted in a long landing and runway overrun.NTSB WPR14CA332Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Apple Valley, CAThe pilot's failure to adequately secure the airplane while hand-starting the engine.NTSB ERA14WA381Accident · Serious injuriesForeign investigationPiper PA-25-260 · Tolima, ColombiaOn August 8, 2014, about 2215 coordinated universal time, a Piper PA-25-260, Colombian registration HK1680, was substantially damaged when it impacted terrain near Tolimo, Colombia. The pilot was seriously injured. The local aerial application flight was…NTSB CEN14WA420Accident · 1 fatalForeign investigationQuicksilver MXL Sport II · Cuenca, SpainOn August 8, 2014, about 1920 coordinated universal time, a Quicksilver MXL Sport II, motorized ultralight (ULM) aircraft, registry EC-FL8, was substantially damaged after impacting terrain during takeoff. The pilot was fatally injured. At the time of the…NTSB CEN14WA416Accident · 3 fatalForeign investigationCessna 182P · Lake of the Woods, CanadaNTSB CEN14TA421Accident · Minor injuriesFinal reportPiper PA 28-180 · Sulphur, LAThe pilot’s failure to properly manage the airplane’s fuel supply, which led to fuel starvation and a total loss of engine power.NTSB CEN14LA412Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28F · Tomah, WIA loss of engine power due to the malfunction of the No. 4 cylinder intake valve.NTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.NTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…