Fatal 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 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 WPR10LA307Accident · 1 fatalLimited investigationFinal reportCessna 172N · Angels Camp, CAThe pilot’s failure to maintain airplane control while maneuvering.NTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…NTSB CEN10LA334Accident · 1 fatalLimited investigationFinal reportDrone Paul E Pulsar III · Carmi, ILThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB DCA10WA070Accident · 11 fatalForeign investigationDima, Congo - KinshasaOn June 20, 2010, about 0900 UTC, a CASA C-212 airplane, TN-AFA, crashed under unknown circumstances near Dima, Republic of Congo (ROC). The 2 crew and 11 passengers were fatally injured. The airplane was destroyed. The chartered flight was en route from…NTSB ANC10LA053Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Unalaska, AKThe pilot's inappropriate low altitude maneuvering, which resulted in a collision with terrain.NTSB WPR10LA299Accident · 1 fatalLimited investigationFinal reportOliver Vans RV-9A · May, IDThe pilot's failure to maintain control of the airplane during maneuvering flight due to spatial disorientation. Contributing to the accident was the pilot's ingestion of an impairing level of over-the-counter medication.NTSB WPR10FA305Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Seligman, AZThe pilot's failure to maintain clearance from mountainous terrain in the dark night.NTSB ERA10WA338Accident · 2 fatalForeign investigationBolkow BO105 · Buenos Aires, ArgentinaOn June 18, 2010, about 1118 universal Coordinated Time (UTC),an Bolkow BO-105, Argentina registration LV-WJX, operated by a private owner on a business flight, to photograph a automobile accident, collided with tall trees, overhead power lines, and struck…NTSB WPR10LA297Accident · 2 fatalLimited investigationFinal reportBernhard Vans RV8 · Truckee, CAThe pilot's failure to maintain airplane control during a steep turn to final approach, which resulted in an inadvertent aerodynamic stall.NTSB CEN10FA324Accident · 5 fatalField investigationFinal reportCessna T310R · Ruidoso, NMThe pilot did not maintain proper airspeed on final approach for landing, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s limited experience in the airplane make and model.NTSB CEN10FA322Accident · 3 fatalField investigationFinal reportPiper PA-23 · Rochester, MNThe loss of engine power and the pilot's subsequent loss of control for undetermined reasons.NTSB WPR10FA295Accident · 1 fatalField investigationFinal reportKaman Aerospace K-1200 · Donnelly, IDThe collision of two counter-rotating main rotor blades for undetermined reasons, which resulted in a loss of control.NTSB WPR10LA293Accident · 2 fatalLimited investigationFinal reportRans Coyote II S6 · Lincoln, CAThe pilot’s failure to maintain adequate airspeed while in a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the increased drag on the airplane with the doors removed.NTSB WPR10LA292Accident · 1 fatalLimited investigationFinal reportAir Creation GTE · Springville, UTThe pilot's inadequate preflight planning and his failure to maintain clearance from obstacles during takeoff. Contributing to the accident was the pilot's lack of experience.NTSB CEN10RA319Accident · 9 fatalForeign investigationCessna 208 · Felipe Carrillo Puerto, MexicoOn June 13, 2010, approximately 1800 central daylight time, a Cessna 208B, XA-TWK, was substantially damaged upon impact with terrain following a loss of control during the initial climb from the Felipe Carrillo Puerto airstrip, Felipe Carrillo Puerto,…NTSB CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB WPR10FA287Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Eagar, AZThe pilot's operation of the aircraft outside of the manufacturer’s specified performance limitations, which resulted in the pilot's failure to maintain clearance from buildings and terrain during takeoff initial climb.NTSB ERA10LA302Accident · 1 fatalLimited investigationFinal reportBeech 60 · Edenton, NCThe flight instructor’s initiation of a simulated single engine scenario at or below the airplane’s minimum single engine control speed, resulting in a loss of airplane control. Contributing to the accident was the flight instructor’s failure to set full…NTSB CEN10FA310Accident · 1 fatalField investigationFinal reportAir Tractor AT602 · Knobel, ARThe pilot did not maintain control of the airplane while maneuvering at low altitude.NTSB CEN10FA299Accident · 1 fatalField investigationFinal reportBeech G35 · Marble, COThe pilot’s miscalculation of the airplane's turn radius and climb capabilities at high altitude, resulting in controlled flight into terrain. Contributing to the accident was the pilot's lack of mountain flying experience and restricted visibility due to the…NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB CEN10FA291Accident · 2 fatalField investigationFinal reportBell 222 · Midlothian, TXThe fracture of a swashplate drive pin as a result of hydrogen embrittlement due to an unknown source, which resulted in an in-flight breakup of the main rotor system during cruise flight.NTSB ANC10FA048Accident · 1 fatalField investigationFinal reportCessna U206F · Anchorage, AKThe pilot’s decision to load the airplane well beyond its allowable weight and center of gravity limits, resulting in a loss of control during the initial climb. Contributing to the severity of the injuries was the pilot’s decision to allow two child…NTSB CEN10WA293Accident · 4 fatalClass 5 · ForeignCirrus SR22 · Bielefeld, GermanyOn May 31, 2010, at 0852 coordinated universal time, a Cirrus SR-22, SP-AVC, was substantially damaged upon impact with terrain following a loss of control while on approach to the Bielefeld-Windelsbleiche airport (EDLI), Nordrhein-Westfalen, Germany. The…NTSB WPR10FA273Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Lincoln, MTThe pilot’s decision to continue flight into an area of low ceilings and low visibility and his failure to maintain sufficient clearance from mountainous terrain.NTSB CEN10WA379Accident · 2 fatalForeign investigationBeech E-55 · Ciutadella de Menorca, SpainNTSB CEN10LA276Accident · 2 fatalLimited investigationFinal reportCovell Kevin Scott Vans RV-4 · Collinsville, OKA loss of engine power shortly after takeoff for undetermined reasons. Contributing to the accident was the pilot's decision to make a 180-degree turn at low level.NTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.NTSB CEN10FA278Accident · 1 fatalField investigationFinal reportEvektor Aerotechnik Sportstar Plus · Richmond, TXThe opening of the cockpit canopy in-flight due to improper latching, which resulted in a loss of control and impact with terrain.NTSB CEN10LA274Accident · 1 fatalLimited investigationFinal reportHenney Michael A Vans RV-6A · Granbury, TXThe loss of control for undetermined reasons.NTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…NTSB ERA10WA281Accident · 2 fatalForeign investigationPiper PA23 · North Bimini, BahamasOn May 25, 2010, at approximately 1830 eastern daylight time, a twin engine, Piper PA-23-250 airplane, N1526T, collided with power lines and crashed into the sea while flying at a low altitude shortly after takeoff from South Bimini Airport, South Bimini,…NTSB WPR10LA258Accident · 1 fatalLimited investigationFinal reportRice GN-1 AIR Campier · Paulden, AZThe pilot's loss of airplane control for undetermined reasons while on final approach to land.NTSB ERA10LA280Accident · 1 fatalLimited investigationFinal reportGardner Douglas P VAN/RV8A · Sebring, FLThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10WA273Accident · 4 fatalForeign investigationFairchild Hiller FH-1100 · Görkwitz, GermanyNTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB DCA10RA063Accident · 158 fatalForeign investigationBoeing 737 · Manglaore, IndiaOn May 22, 2010 at about 6:10 am local time (0040 UTC), Air India Express flight 812 (VT-AXV), a Boeing 737-800 equipped with CFM56 engines, overran the runway into a valley during landing at the Mangalore International Airport, Mangalore, India. Of the 166…NTSB ERA11WA051Accident · 2 fatalForeign investigationCessna 182 · Rio Negro, Bolivar, VenezuelaOn May 21, 2010, about 1737 universal coordinated time, a Cessna 182F, Venezuelan registration YV158E, operated by Corona's Pilot Escuela de Aviacion, was destroyed after it impacted an electrical cable during a training flight in Rio Negro, Estado Bolivar,…NTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…NTSB WPR10WA249Accident · 1 fatalForeign investigationBell 206 · Traralgon, Australia, AustraliaOn May 20, 2010, about 0415 Universal Coordinated Time, a Bell 206 L-3, VH-OSU, operated by a pilot from New Zealand doing crop spraying operations struck a power line and subsequently collided with terrain near Latrobe Valley Aerodrome, Traralgon, Australia.…NTSB WPR10WA245Accident · 4 fatalForeign investigationRobinson R44 · Lucena City, Philippines, PhilippinesOn May 17, 2010, about 0715 Universal Time Coordinated (UTC), a Robinson R-44 II helicopter, RP-C2550, impacted a home in the Jael Subdivision Brgy Iyam, Lucena City, Philippines. The pilot and his three passengers were killed in the accident, along with one…NTSB CEN10LA250Accident · 1 fatalLimited investigationFinal reportAyres S2R · Rushville, NEThe pilot did not maintain clearance from a power line while maneuvering at low altitude.NTSB ERA10LA266Accident · 2 fatalLimited investigationFinal reportAerostar S A YAK-52 · Jensen Beach, FLThe pilot's decision to perform an aerobatic maneuver at a low altitude, which resulted in insufficient clearance from the water to conduct a recovery. Contributing to the accident was the airplane’s extended landing gear, which resulted in a degradation of…NTSB WPR10FA239Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Redmond, ORThe pilot's failure to maintain airspeed, which resulted in a stall and collision with terrain.NTSB ANC10FA038Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Willow, AKThe pilot's failure to maintain clearance from a tree due to the effects of impairment from alcohol consumption.NTSB ERA10WA272Accident · 6 fatalForeign investigationEmbraer EMB-810C · Manaus, BrazilOn May 13, 2010, about 1900 coordinated universal time, an Embraer EMB-810C , Brazilian registration PT-EUJ, was destroyed when it impacted terrain during a forced landing near Manaus, Brazil. The pilot and five passenger were killed. The flight originated…NTSB DCA10RA059Accident · 103 fatalForeign investigationAirbus A330 · Tripoli, LibyaOn May 12, 2010, at approximately 0600 local time (0400 UTC), Afriqiyah Airways flight number 771, an Airbus A330-200 equipped with General Electric CF6-8E1 engines, tail number 5A-ONG, crashed short of the runway in Tripoli, Libya. The flight originated in…NTSB ERA10FA259Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tuscaloosa, ALThe pilot's failure to maintain adequate airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin and collision with the ground.NTSB WPR10FA234Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Livermore, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with obstacles and terrain.