NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 GAA19CA456Accident · No injuriesData collectionFinal reportPiper PA46 · Sparta, TNThe pilot's failure to maintain the runway heading during an aborted takeoff, which resulted in a runway excursion and collision with a sign and terrain. Contributing to the need to abort the takeoff was the pilot's improper decision to take off with the…NTSB CEN19WA294Accident · 1 fatalForeign investigationAir Tractor AT400 · Namiquipa, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIR TRACTOR AT400 airplane that occurred on July 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB CEN19LA251Accident · No injuriesClass 3 · LimitedFinal reportRyan Navion · Chicago, ILThe failure of the left main landing gear upper side brace assembly during landing due to reverse bending fatigue as a result of the incomplete penetration of the circumferential weld during initial production of the component.NTSB CEN19LA246Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · El Paso, TXFailure of the left main landing gear to fully extend due to a lack of hydraulic fluid and during emergency extension procedures, which resulted in the collapse of the landing gear during landing and the subsequent runway excursion and collision with a sign.NTSB CEN19LA242Accident · Serious injuriesLimited investigationFinal reportIcon A5 · Lake, MIThe pilot's improper decision to operate the airplane in exceedance of the airplane manufacturer’s operating limitations, which led to an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue attempting the takeoff…NTSB CEN19LA240Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Blair, NEThe failure of the lower actuator bearing support bracket, which resulted in the misalignment of the clutch actuator, the loss of belt tension on the main rotor drive system, and the subsequent forced landing on sloped terrain.NTSB GAA19CA469Accident · No injuriesData collectionFinal reportSchempp Hirth Ventus 2A · Wurtsboro, NYThe pilot's failure to properly secure the glider’s canopy before flight, which resulted in it opening in flight and the pilot's inability to maintain an appropriate final approach path and altitude, which resulted in impact with a shipping container.NTSB CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…NTSB CEN19LA241Accident · No injuriesClass 3 · LimitedFinal reportStoddard-Hamilton GlaStar · Mitchell, SDA loss of directional control on landing for undetermined reasons.NTSB ANC19WA043Accident · 4 fatalForeign investigationCessna 208 · Bella Bella, CanadaOn July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…NTSB ERA19TA235Accident · No injuriesClass 3Final reportCessna 152 · Wakefield, VAThe pilot's inadequate preflight inspection, which failed to detect and remove all water from fuel, and maintenance personnel’s unapproved repair of the right wing fuel cap, which resulted in fuel contamination and a subsequent partial loss of engine power…NTSB ERA19LA238Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Cuthbert, GAThe failure of the No. 1 bearing due to fatigue which resulted in a partial loss of engine power. The reason for the bearing failure could not be determined based on the available information.NTSB ENG19IA029Incident · No injuriesClass 3 · IncidentFinal reportAirbus A220 · Perrigny-sur-Armançon, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed as a result of a…NTSB CEN19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportCulver LCA · Viroqua, WIA total loss of engine power due to fuel exhaustion.NTSB GAA19WA458Incident · No injuriesForeign investigationSikorsky S92 · Sable Island, CanadaThe government of Canada has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on July 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.NTSB GAA19CA454Accident · No injuriesData collectionFinal reportCessna T188 · Deshler, NEThe pilot's failure to maintain clearance from wires during low-altitude maneuvering.NTSB GAA19CA453Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Stanton, TXThe pilot's failure to maintain clearance from wires during an agricultural application flight.NTSB GAA19CA452Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Welsh, LAThe pilot's failure to maintain clearance from a telephone pole during an agricultural application flight.NTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…NTSB CEN19LA244Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Walls, MSThe improper fuel servicing of the airplane, which resulted in water contamination of the airplane's fuel supply and a subsequent loss of engine power.NTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.NTSB ANC19LA040Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Farewell, AKA reported partial loss of engine power during takeoff for reasons that could not be determined.NTSB WPR19WA203Accident · No injuriesForeign investigationRIchards Heavylift UH-1H · Limpopo Province, South AfricaOn July 23, 2019, about 1107 coordinated universal time, a Richards Heavylift Helo Inc., UH-1H, South African registration ZS-HLJ, operated for fire fighting, and equipped with a Textron Lycoming T-53 engine, reported a loss of engine power near Woodbush…NTSB GAA19CA448Accident · No injuriesData collectionFinal reportCessna 172 · Van Nuys, CAThe pilot's failure to maintain directional control during landing with a left quartering crosswind, which resulted in a runway excursion and impact with runway lighting.NTSB DCA19CA186Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · San Francisco, CAfailure of the ground crew to maintain clearance from the parked airplane during pushback.NTSB WPR19WA199Accident · 1 fatalForeign investigationCessna 172 · Cangkring, IndonesiaOn July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…NTSB WPR19LA198Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Madras, ORA partial loss of power during final approach for undetermined reasons as postaccident examinations did not reveal any preimpact anomalies with the airplane or engine.NTSB OPS19WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A-321-231, which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB ERA19WA236Accident · 2 fatalForeign investigationRobinson R66 · Gorgona Island, ItalyThe government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ENG19WA036Incident · No injuriesForeign investigationAirbus A330 · Islamabad, PakistanThe Aircraft Accident Investigation Board (AAIB) of Pakistan has notified the NTSB of an incident involving an Airbus A330-200 airplane which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB DCA19CA189Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · San Juan, PRAn encounter with convective turbulence during cruise flight.NTSB CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.NTSB ANC19LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boise, IDA ductile overstress fracture failure of the right main landing gear bell crank assembly pivot bolt, which resulted in a collapse of the right main landing gear.NTSB WPR19LA202Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Port Townsend, WAThe loss of engine power for reasons that could not be determined based on available information.NTSB WPR19LA201Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · King City, CAA landing gear collapse following an undetermined loss of electrical power, which prevented the landing gear from fully extending.NTSB GAA19WA460Accident · 1 fatalForeign investigationDe Havilland DH82 · Hythe, United KingdomNTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.NTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.NTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.NTSB CEN19LA231Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Breckenridge, MIA total loss of engine power due to a lack of oil in the engine. The source of the inflight oil leak could not be determined based on the available information.NTSB CEN19LA230Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Ida Grove, IAA total loss of engine power during an aerial application flight for undetermined reasons.NTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.NTSB CEN19IA234Incident · No injuriesClass 3 · IncidentFinal reportMooney M20J · Oshkosh, WIThe failure of both pilots to remain clear of the other while flying in formation.NTSB ANC19TA037Accident · Serious injuriesClass 4Final reportPiper PA19 · Skwentna, AKThe pilot’s loss of directional control during a go-around and his failure to assess the wind conditions appropriately before a landing attempt.NTSB WPR19LA200Accident · No injuriesClass 3 · LimitedFinal reportBeech 33 · Battleground, WAA failure of the throttle control assembly for reasons that could not be determined based on available evidence, which resulted in a runway overrun and impact with an obstacle.NTSB WPR19CA197Accident · Minor injuriesData collectionFinal reportAvid Avid Magnum · Yellow Pine, IDThe pilot's improper decision to land on a rough, grass airstrip, which resulted in the nose landing gear collapsing and a subsequent nose-over.NTSB GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.NTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.