NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 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 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 CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN14FA434Accident · 1 fatalField investigationFinal reportPiper PA 32-300 · Ardmore, OKThe partial loss of engine power for reasons that could not be determined because thermal damage to the engine prevented a complete examination.NTSB ANC14CA066Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Skwentna, AKThe pilot's failure to maintain the proper approach path for landing, and his delayed remedial action, which resulted in an undershoot and collision with terrain.NTSB ENG14WA023Accident · No injuriesForeign investigationBAE JETSTREAM3100 - 3102 · Doncaster, United KingdomOn August 15, 2014 at 1736 UTC, a Jetstream 3102 experienced a failure of the left main landing gear after landing at Doncaster airport in Doncaster, Yorkshire, United Kingdom. The Air Accidents Investigation Branch (AAIB) of the United Kingdom is…NTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.NTSB WPR14LA346Accident · No injuriesLimited investigationFinal reportBoeing 737 7H4 · Salt Lake City, UTThe disconnection of baggage carts that subsequently collided with the parked airplane following the tug driving over a dip in the roadway.NTSB ERA14LA389Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Wiggins, MSA loosening of the engine throttle cable from its support clamp during flight, which resulted in a loss of throttle control.NTSB ERA14LA388Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Buffalo, NYA total loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine test run revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA14FA387Accident · 2 fatalField investigationFinal reportCessna 150 · Mount Pleasant, SCThe commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…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.