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 ERA16LA077Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Myerstown, PAThe pilot's failure to maintain control of the airplane during climbout due to his distraction with raising the landing gear.NTSB CEN16LA084Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Warrenton, MOThe noninstrument-rated pilot's continued flight into instrument meteorological conditions at night, which resulted in the loss of visual reference to the ground and his subsequent failure to maintain clearance from trees.NTSB GAA16CA102Accident · No injuriesData collectionFinal reportPiper PA 18A · Girdwood, AKFuel contamination resulting in the loss of engine power, a forced landing on a highway, and subsequent right wing impact with highway signage.NTSB GAA16CA099Accident · No injuriesData collectionFinal reportDavis Michael J MD Special · Wallace, NCThe pilot's improper fuel planning, which resulted in fuel exhaustion.NTSB DCA16WA037Incident · No injuriesForeign investigationBoeing 787 · Darwin, AustraliaThe government of Australia has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on December 21, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB GAA16CA088Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Middle River, MDThe pilot's incorrect installation of the rudder horn and failure to properly inspect the installation, which led to a loss of directional control during takeoff.NTSB GAA16CA084Accident · No injuriesData collectionFinal reportPiper PA22 · New Castle, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB ERA16FA075Accident · 1 fatalField investigationFinal reportBeech C24R · Winder, GAA total loss of engine power for reasons that could not be determined because the examination of the wreckage did not reveal any mechanical anomalies that would have precluded normal operation.NTSB WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…NTSB GAA16CA090Accident · No injuriesData collectionFinal reportStinson 108 · Portales, NMThe pilot receiving instruction's improper brake application during the flight instructor's aborted landing, which resulted in a loss of directional control and a runway excursion. Contributing to the accident was the flight instructor's decision to perform…NTSB ERA16LA076Accident · No injuriesLimited investigationFinal reportPorrata Luis G Rans S 12XL · Guanica, PRThe pilot/owner's failure to maintain the engine in accordance with manufacturer guidance, which resulted in the undetected corrosion of the power takeoff bearing, subsequent bearing failure, and a total loss of engine power.NTSB DCA16IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · Seattle, WAthe flight crew's misidentification of the taxiway as the landing runway.NTSB CEN16LA068Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Baytown, TXThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB ERA16FA074Accident · 2 fatalField investigationFinal reportHinton Paul M RV 4 · Greenville, FLThe pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation…NTSB GAA16CA083Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5A · Friendswood, TXThe student pilot's loss of directional control during an aborted landing, which resulted in a collision with a tree and impact with the ground.NTSB WPR16FA040Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350 · Superior, AZThe pilot's loss of helicopter control in mountainous terrain as the result of operating the helicopter outside the performance envelope of its hydraulic system and encountering the servo transparency phenomenon. Contributing to the accident was the pilot's…NTSB ERA16LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Charles Town, WVThe flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.NTSB DCA16WA236Accident · No injuriesForeign investigationCessna 182 · Plettenberg, Western Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…NTSB CEN16WA066Accident · Serious injuriesForeign investigationBell 407 · Mixco, GuatemalaOn December 16, 2015, about 1710 universal coordinated time, a Bell 407 helicopter, TG-PJV, sustained substantial damage on impact with terrain near Mixco, Guatemala. The pilot sustained a serious injury and the two passengers were uninjured. The local flight…NTSB ANC16LA010Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Valdez, AKThe overhaul facility’s improper and excessive use of an approved lubricant during overhaul of the fuel injection servo, which resulted in a disruption of fuel flow and a total loss of engine power.NTSB ERA16LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Brunswick, GAMaintenance personnel's failure to properly torque a No. 4 cylinder hold-down nut during engine overhaul, which resulted in the loosening of the nut and the subsequent failure of the studs and through bolts and separation of the cylinder.NTSB DCA16LA032Accident · No injuriesLimited investigationFinal reportBoeing 737 3H4 · Nashville, TNthe flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…NTSB WPR16LA039Accident · No injuriesLimited investigationFinal reportMooney M20E · Corona, CAA partial loss of engine power during initial climb for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s decision to conduct the takeoff with observed engine deficiencies.NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.NTSB GAA16CA080Accident · Minor injuriesData collectionFinal reportAviat A1 · Broadus, MTThe pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.NTSB GAA16CA079Accident · No injuriesData collectionFinal reportMcmichael Elmer L Lancair 360 · Rimrock, AZThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and a left main landing gear collapse.NTSB ERA16WA069Accident · 4 fatalForeign investigationHawker Beech A36TC · Suvorovskaya, RussiaOn December 13, 2015, about 0826 Universal Time Coordinated (UTC), a Beech A36TC, Russian registration RA-2587G, registered to and operated by a private individual, experienced an in-flight loss of control and collided with terrain near Suvorovskaya Village,…NTSB ERA16LA073Accident · No injuriesLimited investigationFinal reportCessna 310 · Kennesaw, GAInadequate inspection and rigging of the landing gear system, which resulted in the subsequent failure and collapse of the left main landing gear during landing.NTSB ERA16LA067Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T Bird II · Lenoir, NCThe pilot’s failure to maintain airspeed and a coordinated turn in the traffic pattern, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to…NTSB GAA16LA087Accident · No injuriesLimited investigationFinal reportPiper PA 31 · Clearwater, FLThe pilot's failure to extend the landing gear before landing.NTSB GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.NTSB ERA16WA072Accident · 2 fatalForeign investigationBell 206 · Mendoza Province, ArgentinaOn December 12, 2015, about 1100 coordinated universal time, a Bell-206, Argentinian registration LV-VFD, was destroyed during a low altitude cruise flight over a reservoir when the helicopter struck the water for undetermined reasons, and sank in…NTSB ERA16LA068Accident · 1 fatalLimited investigationFinal reportMccorkle Robert B Rans S-12 Airaile · Benton, TNThe pilot's failure to maintain airplane control during the initial climb, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin.NTSB ERA16LA066Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Fayetteville, NCMaintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the…NTSB ERA16LA065Accident · No injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Modena, NYA partial loss of engine power due to a stuck No. 1 cylinder exhaust valve.NTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.NTSB WPR16FA037Accident · 4 fatalField investigationFinal reportBell 407 · McFarland, CAThe pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…NTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.NTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…NTSB ENG16WA006Incident · No injuriesForeign investigationAirbus A319 · Bogota, ColombiaOn December 11, 2015, an Avianca Airbus A318-111, N593EL, equipped with CFMI CFM56-5 engines, experienced a loss of power from the No. 1 (left) engine. The airplane was operating as Avianca flight AV9398 from Bogota, Colombia to Pasto, Colombia when the…NTSB CEN16WA063Accident · 1 fatalForeign investigationCessna 208B · Pickle Lake, Ontario, Canada, CanadaOn December 11, 2015, about 0910 eastern standard time, a Canadian registered Cessna 208B, C-FKDL, impacted terrain approximately 15 nautical miles north of Pickle Lake, Ontario, Canada. The pilot, the sole occupant, was fatally injured. The investigation is…NTSB CEN16LA061Accident · Minor injuriesLimited investigationFinal reportGlobe GC 1B · Lake Elmo, MNA loss of engine power due to the carburetor’s primary venturi, fuel nozzle, or both separating after takeoff.NTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.NTSB GAA16LA086Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 390 · Wheeling, ILThe pilots' decision to conduct an approach and landing in gusting wind conditions, and their failure to maintain control of the airplane during the first approach, which resulted in a wing strike.NTSB GAA16CA076Accident · Minor injuriesData collectionFinal reportCessna 172 · Abilene, TXThe student pilot's abrupt control inputs during the flare, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's lack of over sight and delayed reaction while landing.NTSB DCA16CA030Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Great Falls, MTan encounter with turbulence during initial descent.NTSB CEN16WA065Accident · No injuriesForeign investigationEnstrom 280 · Salinas Victoria, MexicoOn December 10, 2015, about 1710 universal coordinated time, an Enstrom 280FX helicopter, XB-GRG, sustained substantial damage on impact with terrain near Salenas Victoria, Mexico. The pilot sustained a serious injury and the two passengers were uninjured.…NTSB CEN16FA062Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Council Bluffs, IAThe pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.NTSB GAA16CA075Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · West Palm Beach, FLThe student pilot's failure to maintain directional control during the landing, which resulted in a horizontal rotation of the helicopter, and abnormal runway contact.NTSB WPR16IA044Incident · No injuriesIncident investigationFinal reportCessna LC41-550FG · Seal Beach, CAImproper maintenance performed on the left magneto which led to a loss of engine power. Contributing to the incident was the pilot's failure to check the magnetos in flight in compliance with manufacturers guidance regarding rough running engine. The pilot's…