Fatal 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 WHERE c.\"highestInjuryLevel\" = 'Fatal' 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 WHERE c."highestInjuryLevel" = 'Fatal' 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 ERA19WA271Accident · 7 fatalForeign investigationPiper PA31 · Popayan, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB GAA19WA595Accident · 2 fatalForeign investigationCozy Mark IV · Rio Verda, GO, BrazilThe government of Brazil has notified the NTSB of an accident involving a COZY Mark IV airplane that occurred on September 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.NTSB CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.NTSB GAA19WA553Accident · 1 fatalForeign investigationCessna 208 · Gransee, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on September 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…NTSB CEN19LA308Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Whitehall, MIThe pilot’s flight into a water tower while operating below minimum safe altitudes for reasons that could not be determined based on the available evidence for this investigation.NTSB WPR19FA256Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · La Grande, ORThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB WPR19FA252Accident · 2 fatalClass 3 · FieldFinal reportBeech C24 · Las Vegas, NVThe pilot’s operation of the airplane over its maximum gross weight and outside of center of gravity limits at a high-density altitude, which resulted in the exceedance of the airplane's critical angle of attack while maneuvering and subsequent aerodynamic…NTSB ERA19FA266Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.NTSB CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…NTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.NTSB WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…NTSB ERA19FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Lady Lake, FLThe pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.NTSB GAA19WA565Accident · 1 fatalForeign investigationCessna 172 · Racine, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO…NTSB WPR19FA250Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Henefer, UTThe pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.NTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.NTSB WPR19WA272Accident · 9 fatalForeign investigationBeech B300 · Calamba, PhilippinesOn September 1, 2019 about 0541 universal coordinated time, a Beech B-300, RP-C2296, collided with terrain near Brgy. Pansol, Calamba, Laguna, Philippines. The two flight crew and seven passengers were fatally injured. Two persons on the ground received minor…NTSB GAA19WA594Accident · 1 fatalForeign investigationAirbus A350 · Alta city, NorwayThe government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB WPR19WA260Accident · 1 fatalForeign investigationAir Tractor AT502 · Gusap, Papua New GuineaOn August 29, 2019, an Air Tractor AT-502B aircraft, registered P2-SET, operated by Ramu Agriculture Industries, collided with a tree near Gusap, Papua New Guinea. The pilot was fatally injured and the airplane was destroyed. The Papua New Guinea (PNG)…NTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.NTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…NTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.NTSB GAA19WA540Accident · 3 fatalForeign investigationRobinson R44 · Buriti Alegre, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN19WA287Accident · 3 fatalForeign investigationPiper PA28RT · Simplon Pass, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB CEN19WA283Accident · 7 fatalForeign investigationBell 206 · Inca, Mallorca, SpainOn June 25, 2019, about 1335 local time, a Bell 206L-3 helicopter, D-HOTT, and an Aeroprakt A22L airplane collided in mid-air, near Inca, Mallorca, Spain. The pilot and four passengers aboard the helicopter and the two people on the airplane, received fatal…NTSB WPR19FA235Accident · 1 fatalClass 3 · FieldFinal reportMeyers Midget 0100 · Big Spring, TXThe pilot’s failure to maintain situational awareness while conducting a roll, which resulted in his inability to recover from the maneuver before the airplane impacted the ground. Contributing to the accident was his inexperience in both aerobatic maneuvers…NTSB CEN19WA286Accident · 2 fatalForeign investigationPitts S2 · Stonor Oxforshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB CEN19WA285Accident · 1 fatalForeign investigationRotorway Exec 162F · Herisau, SwitzerlandOn August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…NTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB ERA19FA256Accident · 1 fatalClass 3 · FieldFinal reportMoriarty Marvin Aventura II · Minneola, FLThe pilot’s improper modifications to the airplane’s engine, which resulted in the partial loss of engine power. Contributing to the outcome was the pilot's exceedance of the airplane’s critical angle of attack during an attempted return to the airport…NTSB CEN19WA289Accident · 1 fatalForeign investigationCapella XS · San Juan del Puerto, SpainOn August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…NTSB CEN19WA284Accident · 1 fatalForeign investigationReims F172 · Schneizlreuth, GermanyThe government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB CEN19WA282Accident · 1 fatalForeign investigationCessna 150 · Diepholz, GermanyOn August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on…NTSB ERA19WA261Accident · 3 fatalForeign investigationAgusta A109 · Poros, GreeceThe government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's…NTSB CEN19FA279Accident · 2 fatalClass 3 · FieldFinal reportAero Commander 200 · Howell, MIThe improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN19FA276Accident · 1 fatalClass 2 · FieldFinal reportShirley Carl Sportcopter Vortex · Viroqua, WIThe noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…NTSB ERA19FA250Accident · 2 fatalClass 3 · FieldFinal reportBeech 95B55 · Wilmington, DEThe pilots’ failure to place the left fuel selector into the proper position, which resulted in a total loss of the left engine’s power due to fuel starvation. Contributing was their failure to properly secure the left engine and their failure to maintain…NTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.NTSB ERA19FA249Accident · 2 fatalClass 3 · FieldFinal reportCessna T303 · Lagrangeville, NYA partial loss of engine power in both engines during initial climb for reasons that could not be determined based on the available information.NTSB WPR19WA274Accident · 2 fatalForeign investigationCessna 172 · Pretoria, South AfricaOn August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the…NTSB CEN19FA270Accident · 2 fatalClass 3 · FieldFinal reportPitts S2 · New Orleans, LAA loss of control for undetermined reasons.NTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…NTSB ERA19LA247Accident · 1 fatalClass 3 · LimitedFinal reportFantasy Air Allegro · Boone, NCThe reported total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.NTSB ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.NTSB CEN19FA259Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Sumner, IAThe pilot’s impairment by medical conditions and/or medications, which resulted in the airplane’s impact with power lines and terrain.