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 ERA16LA115Accident · Serious injuriesLimited investigationFinal reportBeech 95 C55 · Plymouth, MAThe pilot's failure to maintain control of the airplane during an aborted takeoff in gusting wind conditions.NTSB CEN16LA119Accident · No injuriesLimited investigationFinal reportBeech 95 C55 · Casey, ILThe pilot's inadvertent landing on a taxiway after a reported loss of engine power in both engines, which resulted in an overrun of the paved surface. The reason for the loss of engine power could not be determined because a postaccident test run of the…NTSB CEN16LA115Accident · No injuriesLimited investigationFinal reportBeech V35 · Seymour, INThe pilot's improper placement of the fuel selector handle between two tank positions, which resulted in a restricted fuel flow to the engine and the initial loss of engine power, and his improper decision to use the high-boost auxiliary fuel pump for an…NTSB OPS16IA009IncidentClass 3 · IncidentFinal reportCessna 172S · Honolulu, HIThe air traffic controller's decision to clear an aircraft to land on a runway occupied by another aircraft that had previously been instructed to line up and wait. Contributing to the runway incursion was the failure of the air traffic controller to visually…NTSB ENG16WA019Incident · No injuriesForeign investigationBoeing 767 · Domodedovo, RussiaInitial Notification sent to NTSB by the Ministry of Transport of the Russian Federation. The Ministry of Transport of the Russian Federation has appointed Federal Air Transport Agency (FATA) to investigate the incident of an Azurair Airlines B767-300…NTSB WPR16CA077Accident · No injuriesData collectionFinal reportStinson 108 3 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was maintenance personnel's failure to detect the worn tailwheel assembly during the airplane's annual inspection.NTSB WPR16LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's improper landing approach, which resulted in a hard landing and the subsequent overstress failure of the nose landing gear.NTSB GAA16CA138Accident · No injuriesData collectionFinal reportCessna 170 · Enumclaw, WAThe pilot's incorrect brake application during taxi, which resulted in a nose over.NTSB ERA16WA129Accident · 1 fatalForeign investigationEnstrom F28 · Globitsy, RussiaOn February 24, 2016, about 1754 hours local, an Enstrom F-28A, RA-2348G, registered to the City of Saint-Petersburg, Russia, operated by a private individual, impacted terrain near Globitsy Township, Lomonosov District, Leningrad Region, Russia. Visual…NTSB ERA16LA111Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pembroke Pines, FLThe loss of engine power while on approach for reasons that could not be determined based on the available evidence.NTSB ENG16WA018Accident · 25 fatalForeign investigationViking Air DHC-6 · Soli Ghoptevir, NepalNTSB DCA16WA101Incident · No injuriesForeign investigationBoeing 737 · a Mitad de la Pista del Aeropuerto, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on February 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA16LA100Accident · No injuriesLimited investigationFinal reportEmbraer EMB145 · St Louis, MOthe flight crews' failure to consider all available runways for landing to minimize the gusty crosswind component. Contributing to the accident was the captain's reduction of the engine thrust for about 1 second at low altitude immediately after the first…NTSB CEN16LA108Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Grand Junction, COFailure of the right main tire for reasons that could not be determined because the tire was not available for examination.NTSB WPR16LA075Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Torrance, CAA vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…NTSB ERA16LA110Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Palatka, FLA partial loss of engine power for reasons that could not be determined because engine examination, an engine test run, and review of engine monitor data did not reveal any evidence of preimpact anomalies that would have precluded normal operation.NTSB DCA16WA097Accident · Serious injuriesForeign investigationBoeing 737 · Chitose, JapanThe government of Japan has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB CEN16WA109Accident · 1 fatalForeign investigationPiper PA28 · Palin, GuatemalaOn February 23, 2016, at 1805 coordinated universal time, a Piper PA28-140, Guatemalian registration TG-PEW, was destroyed when it impacted the terrain near Palin, Guatemala. The pilot was fatally injured. The flight originated from La Aurora Airport,…NTSB WPR16LA074Accident · No injuriesLimited investigationFinal reportMooney M20J · Pacoima, CAA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation.NTSB ERA16LA119Accident · No injuriesLimited investigationFinal reportPiper PA28 151 · St. Augustine, FLThe flight instructor's overpriming of the engine during start, which resulted in a carburetor fire. Contributing to the severity of accident was the flight instructor's failure to follow the Pilot Operating Handbook's engine fire during start emergency…NTSB CEN16WA110Accident · No injuriesForeign investigationPiper PA23 · Saint François, GuadeloupeOn February 22, 2016, a Piper PA-23-250 airplane, N539EG, sank after ditching near the Saint François Airport (TFFC), Saint François, Guadeloupe (France). The pilot was not injured.This investigation is under the jurisdiction and control of the French…NTSB GAA16CA139Accident · No injuriesData collectionFinal reportCessna 172 · Willoughby, OHThe student pilot's failure to reduce pitch attitude during a simulated engine failure during takeoff initial climb, resulting in a high descent rate and hard landing. Contributing to the accident was the flight instructor's delayed remedial action during the…NTSB ERA16LA113Accident · No injuriesLimited investigationFinal reportLiberty Aerospace Liberty XL · Orlando, FLA failure of the right brake for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's decision to continue the flight after experiencing a braking anomaly due to his perceived need for an…NTSB ERA16LA109Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Port Jefferson, NYThe flight instructor's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA16WA102Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB ERA16FA108Accident · 1 fatalField investigationFinal reportBeech A36 · Marshville, NCThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the severity of the pilot's injuries was his failure to have a properly secured shoulder harness at the time of the accident.NTSB WPR16FA072Accident · 1 fatalField investigationFinal reportBell 206B · Honolulu, HIThe in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.NTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.NTSB GAA16CA134Accident · No injuriesData collectionFinal reportCessna 172 · Newport News, VAThe student pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and impact with terrain.NTSB DCA16CA094Accident · No injuriesData collectionFinal reportBoeing 737 · Detroit, MIN925NN flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the winglet with the horizontal stabilizer and elevator of N784SW.NTSB WPR16LA071Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Buckeye, AZThe pilot's improper decision to operate the high-performance aircraft despite warnings from a flight instructor that he did not have the experience to operate the aircraft that had different and more sensitive handling characteristics than the…NTSB CEN16LA107Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Bryan, TXA failure of the crankshaft due to improper torque of the crankcase through bolts.NTSB GAA16CA131Accident · No injuriesData collectionFinal reportFoxworthy Roy Christen Eagle · Bell City, LAThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a runway excursion and a nose over.NTSB DCA16CA089Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 132 · Minneapolis, MNan encounter with turbulence that resulted in a serious injury to a passenger who was standing when the fasten seatbelt sign was illuminated.NTSB ANC16CA014Accident · No injuriesData collectionFinal reportCessna 180 · Sleetmute, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.NTSB WPR16LA070Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Petaluma, CAThe pilot's inadequate compensation for wind during the landing approach, which resulted in the balloon’s basket impacting a metal fence and a passenger sustaining serious injuries.NTSB WPR16LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G 3B 1 · Carson City, NVThe pilot's failure to maintain sufficient main rotor rpm, which resulted in a loss of helicopter control and a dynamic rollover.NTSB WPR16LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Independence, ORThe failure of the left main landing gear wheel axle due to a fatigue crack.NTSB GAA16CA141Accident · No injuriesData collectionFinal reportMaule M 4 · Anchorage, AKThe inadvertent rudder input by the passenger, resulting in a runway excursion during takeoff and collision with a taxiway sign.NTSB GAA16CA132Accident · No injuriesData collectionFinal reportConsolidated Vultee BT 15 · Chino, CAThe taxiing pilot's failure to remain a safe distance from the stopped airplane while taxiing to the run-up area, resulting in a ground collision and substantial damage.NTSB GAA16CA125Accident · No injuriesData collectionFinal reportSocata Tampico TB 9 · Fort Smith, ARThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in runway excursion, impact with terrain and an airport sign, and a postimpact fire.NTSB ERA16LA106Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Destin, FLThe noninstrument-rated pilot's decision to turn the airplane away from the lighted airport at low altitude, over water, with no visible horizon, in dark night conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ANC16WA070Accident · No injuriesForeign investigationPiper PA-28-140 · St Andrews, CanadaOn February 13, 2016, about 2039 Coordinated Universal Time (UTC), a Piper PA-28-140 airplane, (Canadian Registration C-GQPN) was on approach to St. Andrews, MB (CYAV) with an instructor and a student on board. Prior to touch down at approximately 50 feet…NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.NTSB GAA16CA127Accident · No injuriesData collectionFinal reportCessna 150 · Santa Paula, CAThe tailwheel pilot's failure to see and avoid a stationary airplane performing a run-up, which resulted in a ground collision.NTSB GAA16CA124Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe pilot's failure to maintain adequate terrain clearance while landing, which resulted in a collision with a snow berm, nose gear collapse, and postimpact fire.NTSB DCA16LA096Accident · No injuriesLimited investigationFinal reportLockheed 382G · Iliamna, AKThe fatigue failure of the forward pressure bulkhead canted web that originated from stress corrosion cracking areas. Contributing to the failure were inspection procedures and intervals inadequate to identify the crack.NTSB CEN16LA105Accident · No injuriesLimited investigationFinal reportEnstrom TH-180 · Menominee, MIThe failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.NTSB WPR16FA067Accident · 2 fatalField investigationFinal reportFlight Design Ctls · Springville, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…NTSB GAA16CA130Accident · Minor injuriesData collectionFinal reportCessna 182 · Hudson Oaks, TXThe pilot's decision to continue the high approach, resulting in excessive speed during the landing roll, a loss of directional control, runway excursion, and nose over.