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 GAA16CA212Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.NTSB GAA16CA209Accident · No injuriesData collectionFinal reportCessna 152 · Palo Alto, CAThe student pilot's decision to takeoff in wind conditions that exceeded his certificated flight instructor's maximum wind endorsement, and the student pilot's failure to maintain pitch control during the touchdown, resulting in abnormal runway contact, and…NTSB ERA16LA177Accident · No injuriesLimited investigationFinal reportMaher Daniel J Velocity · Worcester, MAThe overstress failure of the nose landing gear fork assembly.NTSB ERA16LA174Accident · No injuriesLimited investigationFinal reportAmerican Champion 7AC · Keene, NHThe disengagement of the tailwheel locking mechanism during the landing roll due to wear, and a subsequent loss of directional control. Contributing was the pilot's inadequate remedial action, which resulted in a runway excursion.NTSB ERA16LA173Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108 · Calverton, NYThe pilot's failure to maintain directional control during the landing roll.NTSB ERA16LA172Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Tyrone, GAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB CEN16LA189Accident · No injuriesLimited investigationFinal reportPiper PA 31P · Killeen, TXThe pilot’s failure to extend the landing gear due to his distraction with the flaps, his misinterpretation of the landing gear warning horn, and his failure to verify that the landing gear were down, which resulted in a landing with the gear retracted.NTSB WPR16LA099Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 5 · San Ardo, CAThe failure of the pin in the outboard end of the lateral flight control torque tube.NTSB WPR16IA100Incident · No injuriesIncident investigationFinal reportPiper PA28 · San Carlos, CAThe failure of maintenance personnel to properly install and secure the input swivel boot on the swivel joint, which resulted in excessive vibration that led to fatigue cracks and failure of the throttle cable.NTSB GAA16CA207Accident · No injuriesData collectionFinal reportCessna U206 · Port Alsworth, AKThe pilot's failure to maintain an appropriate descent rate during the landing flare in gusty crosswind conditions, which resulted in a hard landing, aerodynamic stall, impact with terrain, nose gear collapse, and nose over.NTSB DCA16CA139Accident · No injuriesData collectionFinal reportBombardier CL 600 2B19 · San Francisco, CAThe tug driver's failure to comply with the wing walkers direction to stop, which resulted in the towed airplane colliding with N961SW.NTSB CEN16LA170Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine 582 · Fortville, INThe collapse of the powered parachute's canopy for a reason that could not be determined, because postaccident examination revealed no anomalies with the parachute.NTSB GAA16CA211Accident · No injuriesData collectionFinal reportCessna 152 · Hayward, CAThe student pilot's high descent rate during the landing flare, which resulted in a hard landing, nose landing gear collapse, and runway excursion during an aborted landing.NTSB ERA16WA196Accident · No injuriesForeign investigationSikorsky S76 · Campos dos Goytacazes, BrazilOn April 28, 2016, about 1330 coordinated universal time, a Sikorsky S76A, Brazilian registration PR-EMR, was substantially damaged during an emergency landing after a fire indication and precautionary engine shutdown on the right engine followed shortly by a…NTSB DCA16WA155Accident · No injuriesForeign investigationEmbraer ERJ190 · Cuenca, EcuadorThe Ecuador Direccion General de Aviacion Civil (DGAC) has notified the NTSB of an accident involving an Embraer E-190 that occurred on April 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…NTSB CEN16LA177Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Osage City, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA208Accident · No injuriesData collectionFinal reportCessna 172 · Durant, OKThe pilot candidate's incorrect action performance by pulling the throttle off early and the subsequent failure to maintain the descent rate, resulting in a hard landing.NTSB DCA16WA160Incident · No injuriesForeign investigationBoeing 737 · Guangzhou, ChinaThe Civil Aviation Administration of China (CAAC) has notified the NTSB of an accident involving a Boeing 737 that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC's investigation under the provisions of…NTSB DCA16WA143Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe South African CAA has notified the NTSB of an accident involving a Robinson R44 helicopter and Aeroprakt A-22 Foxbat ultralight that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…NTSB GAA16CA203Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Maryville, MOThe pilot's unintentional brake application during the landing roll, which resulted in a nose over.NTSB ERA16LA265Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PAMaintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.NTSB ERA16LA171Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Foley, ALThe pilot's failure to obtain proper takeoff speed before breaking ground, which resulted in the airplane’s failure to gain altitude and a collision with trees and terrain.NTSB CEN16WA179Accident · No injuriesForeign investigationSwearingen SA 226T · Andorra, Lleida, Spain, SpainOn April 26, 2016, about 1535 hours universal coordinated time, a Swearingen SA-226T airplane, United States registration N125WG, was substantially damaged during landing at the Andorra – La Seu d'Urgell Airport (LESU); Andorra, Lleida, Spain. The airplane…NTSB WPR16LA096Accident · No injuriesLimited investigationFinal reportDG Flugzeugbau DG 800B · Clements, CAThe motorglider pilot's decision to perform an in-flight engine start with insufficient altitude, which resulted in an off-airport landing and collision with trees after the engine did not start. Contributing to the accident was the pilot's distraction by the…NTSB GAA16CA200Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Madison, KSThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB ERA16FA170Accident · Serious injuriesField investigationFinal reportBeech 76 · Pompano Beach, FLThe flight instructor's failure to maintain airplane control while demonstrating a simulated engine failure. Contributing to the accident was the pilot's improper response to the simulated engine failure.NTSB ERA16FA169Accident · 1 fatalField investigationFinal reportPiper PA32 · Boone, NCThe pilot's delayed decision to conduct a go-around following an unstabilized landing approach and his subsequent failure to maintain clearance from trees near the end of the runway.NTSB CEN16LA168Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 206 L4 · Houston, TXThe pilot's failure to maintain directional control during takeoff in varying wind conditions, which resulted in a hard landing.NTSB GAA16CA210Accident · Minor injuriesData collectionFinal reportPiper PA18S · Talkeetna, AKThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose over.NTSB GAA16CA205Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Marana, AZThe glider's loss of lift as a result of unfavorable wind conditions for glider operations, consequently resulting in a collision with trees.NTSB GAA16CA198Accident · No injuriesData collectionFinal reportCessna 150 · Sterling City, TXThe pilot's failure to establish a climb and maintain directional control during takeoff in quartering tailwind conditions, which resulted in a loss of directional control, aborted takeoff, collision with a wire fence, and nose over.NTSB ERA16LA181Accident · No injuriesLimited investigationFinal reportMaule M 7-235B · Littleton, NCThe pilot's improper landing flare, which resulted in a hard landing and subsequent damage to the left float.NTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB DCA16WA142Incident · No injuriesForeign investigationBoeing 767 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 767 that occurred on April 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the…NTSB CEN16LA167Accident · No injuriesLimited investigationFinal reportProbst Zenair 601XL · Hempstead, TXA loose output connection from the generator voltage regulator, which resulted in a loss of power to the electronic ignition system, a total loss of engine power, and a subsequent forced landing, during which the airplane impacted a sign pole.NTSB CEN16FA169Accident · 1 fatalField investigationFinal reportCessna 182L · Carrollton, OHAn in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.NTSB GAA16LA199Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · Culver, INThe noncertificated pilot’s failure to attain a climb in the powered-parachute and its subsequent impact with a tree.NTSB GAA16CA239Accident · No injuriesData collectionFinal reportLogan Jerry L GN 1 Aircamper · Defuniak Springs, FLThe pilot's loss of directional control during the landing in gusting crosswind conditions resulting in a runway excursion, and the pilot's failure to attain a positive climb rate during the aborted landing and subsequent ground collision.NTSB GAA16CA197Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Ramona, CAThe pilot's failure to maintain directional control during takeoff in variable wind conditions.NTSB ERA16CA178Accident · No injuriesData collectionFinal reportChampion 7AC · Jasper, ALThe pilot's inadequate compensation for the wind which resulted in a loss of directional control at touchdown and collapse of the landing gear.NTSB DCA16WA244Incident · No injuriesForeign investigationBoeing 737 · Apia, AntarcticaThe government of American Samoa has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of American Samoa's investigation under the…NTSB CEN16LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brimfield, ILA loss of engine power for reasons that could not be determined, as postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ANC16LA021Accident · No injuriesLimited investigationFinal reportJim Riggs AK Ridge Runner · Wasilla, AKThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA16CA201Accident · Minor injuriesData collectionFinal reportHelicycle/Morrisey RR RM-1 · Denver, COThe pilot's failure to maintain control of the helicopter yaw while operating in conditions conducive to loss of tail rotor effectiveness, resulting in an uncommanded rapid right yaw and ground impact.NTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…NTSB GAA16CA251Accident · No injuriesData collectionFinal reportCirrus SR22 · Church Hill, MDThe pilot's decision to land on an unlighted grass airstrip at night, resulting in landing long, a loss of directional control, and collapsed landing gear producing substantial damage to the landing gear attachment point and left wing.NTSB CEN16LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sand Springs, OKA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB CEN16LA163Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Zionsville, INThe flight instructor’s improper decision to depart on a local instructional flight in rapidly deteriorating weather conditions, including thunderstorms and hail, which resulted in subsequent impact with terrain during a go-around.NTSB CEN16LA162Accident · No injuriesLimited investigationFinal reportCessna 150J · Bixby, OKA total loss of engine power for reasons that could not be determined, as the fuel state of the airplane at the time of the accident could not be verified, and postaccident examination of the engine did not provide adequate information.NTSB CEN16LA161Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Los Fresnos, TXThe pilot's inability to see and avoid the power lines because of trees obscuring his view.