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 WPR10FA473Accident · 1 fatalField investigationFinal reportHawker Beechcraft F33 · Phoenix, AZA partial loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC10CA099Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Kenai, AKThe student pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during cruise flight.NTSB WPR10CA471Accident · No injuriesData collectionFinal reportCessna 195 · Prescott, AZThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion.NTSB WPR10CA470Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's failure to maintain tail rotor clearance while landing on a transport trailer positioned on an uneven surface.NTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ENG10IA053Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · John F. Kennedy International Airport, NYThe probable cause of the incident was the restriction of the right main landing gear door against the fuselage wheel well body fairing which prevented the extension of the right main landing gear.NTSB CEN10LA564Accident · No injuriesLimited investigationFinal reportCessna 310K · Boerne Stage, TXThe pilot’s failure to ensure that the landing gear was extended prior to landing, resulting in a landing on the partially extended landing gear.NTSB CEN10LA559Accident · No injuriesLimited investigationFinal reportBeech A36TC · Snook, TXThe pilot's failure to recognize the change in wind velocity and his decision to make a downwind takeoff from the grass airstrip, which led to the airplane's degraded climb capability.NTSB CEN10CA569Accident · Minor injuriesData collectionFinal reportCentral Ohio Dragonfly Clubllc DRAGONFLY-C · Orient, OHThe pilot's failure to disconnect the tow bridal line prior to takeoff.NTSB ERA10FA502Accident · 2 fatalField investigationFinal reportCessna 172 · Chatsworth, GAThe pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…NTSB ERA10CA505Accident · No injuriesData collectionFinal reportCessna 172S · Franconia, NHThe pilot’s delay in initiating a go-around, which resulted in an in-flight collision with a fence.NTSB CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoNTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.NTSB CEN10LA566Accident · Minor injuriesLimited investigationFinal reportHolmes Gary Don Rutan LONG-EZ · Yellow Springs, OHThe loss of engine power for undetermined reasons.NTSB CEN10LA558Accident · 1 fatalLimited investigationFinal reportWorthington Rotorway · Pattison, TXThe pilot's failure to maintain main rotor rpm, which resulted in an uncontrolled descent and collision with terrain.NTSB CEN10CA562Accident · Minor injuriesData collectionFinal reportCessna 172M · Point Lookout, MOThe pilot receiving instruction's failure to attain the proper touchdown point and execute a go-around and the CFI’s delayed remedial action, which resulted in a runway overrun.NTSB WPR10WA484Accident · 1 fatalForeign investigationChampion 8KCAB · Bandung, Indonesia, IndonesiaOn September 24, 2010, at 0312 universal coordinated time, an American Champion Super Decathlon 8KCAB, PK-NZP, collided with terrain while performing an inverted aerobatic maneuver at low altitude during an air show at Husein Sastranegara Airport, Bandung,…NTSB WPR10CA469Accident · No injuriesData collectionFinal reportPiper PA-18-150 · White Sulphur Springs, MTThe pilot's failure to maintain control of the airplane during a go-around in turbulent wind conditions, which resulted in a collision with trees.NTSB ERA10TA501Accident · Minor injuriesFinal reportEurocopter AS-350 · Covington, GAThe flight instructor's loss of control of the helicopter during the intentional demonstration of a low speed, hydraulics-off maneuver, that was warned against in the helicopter manufacturer's flight manual.NTSB ERA10LA499Accident · Serious injuriesLimited investigationFinal reportBell OH-58A · Taylorsville, MSA total loss of engine power while maneuvering at low altitude for undetermined reasons.NTSB ERA10CA500Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bealeton, VAThe pilot under instruction’s improper recovery from a bounced landing and the flight instructor’s delayed remedial action, which resulted in a ground loop and collision with trees.NTSB ENG12RA005Accident · Minor injuriesForeign investigationAirbus A319 - 132 · Palermo (Sicily), ItalyNTSB CEN10LA573Accident · No injuriesLimited investigationFinal reportCessna 152 · Tea, SDThe loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB CEN10FA557Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Woodruff, WIThe pilot's decision to attempt an instrument approach in turbulent night instrument meteorological conditions with a recently-identified deficiency with his instrument flight proficiency, which resulted in a loss of airplane control as a result of spatial…NTSB CEN10CA570Accident · Minor injuriesData collectionFinal reportSix Chuter SR7 Skye Ryder · Sarcoxie, MOThe non-rated pilot's failure to maintain aircraft control during landing.NTSB ANC10CA098Accident · No injuriesData collectionFinal reportCessna 180C · Anchorage, AKThe pilot's failure to compensate for the gusting wind during takeoff, which resulted in a loss of control and impact with water.NTSB ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicNTSB ERA10CA513Accident · No injuriesData collectionFinal reportPiper PA34 · Northampton, MAThe pilot's improper recovery from a bounced landing.NTSB ENG10RA054Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn September 25, 2010, a Southern Air Transport Boeing 747-281F, Reg. No. N758SA, experienced an uncontained LPT failure of the GE CF6-50 engine in the No. 3 position during taxi for takeoff from Frankfurt International Airport, Frankfurt, Germany. The No. 3…NTSB CEN10LA555Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pocahontas, ARThe pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the weight of the airplane and the high ambient temperature.NTSB WPR10CA467Accident · Minor injuriesData collectionFinal reportSport Plane Dynamics Lightning · Glendale, AZThe pilot's improper flare, which resulted in a bounced landing and loss of directional control.NTSB ERA10TA493Accident · Minor injuriesFinal reportBell 412 · Brooklyn, NYThe fatigue fracture of the reduction gearbox output drive gear, which resulted in the loss of power output from the engines to the helicopter rotor blade system and a subsequent forced landing. The fracture of the output drive gear was caused by a fatigue…NTSB ERA10CA497Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Castle, VAThe pilot's delayed decision to abort the takeoff, which resulted in a collision with terrain.NTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.NTSB DCA10WA098Incident · No injuriesForeign investigationMcdonnell Douglas MD-11F · Kabul, AfghanistanOn Sept 22, 2010, a World Airways MD-11 scraped the right wingtip during a go-around at Kabul Afghanistan. The aircraft had minor damage and there were no injuries. The investigation is being conducted by the Civil Aviation Authority of Afghanistan. All…NTSB CEN10LA563Accident · No injuriesLimited investigationFinal reportCessna 172S · Longmont, COThe pilot's inadequate landing flare and improper recovery from a bounced landing.NTSB WPR10LA465Accident · No injuriesLimited investigationFinal reportMooney M20C · Visalia, CAA partial loss of engine power during takeoff, which resulted from the failure of the spark plug retention mechanism.NTSB WPR10CA466Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Mecca, CAThe pilot's failure to maintain clearance from an obstacle while maneuvering.NTSB ENG10WA052Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, ChinaOn September 21, 2010, 0930 Coordinated Universal Time (UTC), an Air Cargo Germany, a Boeing B-747-412F,registered as D-ACGD, was performing a left turn to line up with Runway 25L for take-off 31C at Hong Kong International Airport. Just before finishing the…NTSB CEN10CA568Accident · No injuriesData collectionFinal reportBeech D17S · Fort Worth, TXThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN10CA553Accident · Serious injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Blessing, TXThe pilot's failure to maintain clearance from wires while maneuvering.NTSB ANC10CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's rapid application of throttle and carburetor heat causing the engine to hesitate and lose power during takeoff following an aborted landing.NTSB WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.NTSB ERA10CA495Accident · No injuriesData collectionFinal reportSkykits Savannah · Springville, TNCollision with an unknown object during landing.NTSB ERA10CA490Accident · No injuriesData collectionFinal reportPiper PA32R · Chamblee, GAA loss of engine power due to fuel starvation as a result of the pilot's improper placement of the fuel selector.NTSB DCA10WA099Incident · No injuriesForeign investigationBoeing 737 · Budapest, HungaryOn September 20, 2010 about 1:00 PM local time, a Hungarian Airlines Boeing 737-600, registration HA-LOE, experienced a yaw event at about 95 knots and aborted the takeoff from Budapest Ferihegy International Airport (LHBP), Budapest, Hungary. There were no…NTSB CEN10LA560Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Schaumburg, ILThe in-flight separation of the left aft cluster fitting assembly following the loss of torque on the lock nut due to a manufacturing defect.NTSB CEN10CA550Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Carthage, TXA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.NTSB WPR10LA468Accident · Minor injuriesLimited investigationFinal reportGiboney Thunder Mustang · Reno, NVFailure of a connecting rod bearing and two connecting rods, which resulted in a loss of engine power while maneuvering at low altitude.