Fatal NTSB investigations, 2017

63 cases where the sequence of events included Unknown or undetermined.

Cases per year

20082026
Fatal NTSB investigations, 2017 per year, 2008–2026: 1,013 cases
200813
200916
201032
201131
201227
201332
201446
201559
201672
201763
201880
201956
202047
202143
202258
202354
202455
202580
2026149

Latest cases

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 year(c.\"eventDate\") = 2017
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ERA18WA051Accident · 1 fatalForeign investigationBeech A36 · Itapua, ParaguayDec 17, 2017 · ZP-BHU · DestroyedNTSB ANC18WA015Accident · 1 fatalForeign investigationPiper PA23 · Baldur, CanadaOn December 16, 2017, about 0037 Coordinated Universal Time, a Piper PA-23 airplane, CFIPK, impacted terrain near Baldur, Manitoba, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries.The Transportation Safety Board (TSB) of…Dec 16, 2017 · CFIPK · Substantial damageNTSB WPR18WA078Accident · 3 fatalForeign investigationBeech 58 · Qaroun Lake, EgyptOn December 15, 2017, about 0930 Coordinated Universal time, a Textron/Beech Model 58 Baron twin engine airplane, SU-BLD, was substantially damaged when it impacted desert terrain about 18 kilometers north of Qaroun Lake, Egypt. The training pilot and the two…Dec 15, 2017 · SU-BLD · Substantial damageNTSB CEN18WA055Accident · 3 fatalForeign investigationCessna 510 · Waldburg, GermanyOn December 14, 2017, about 1620 coordinated universal time, a Cessna 510 airplane, OE-FWD, impacted terrain near Waldburg, Germany. The pilots and passenger were all fatally injured and the airplane was destroyed.The accident investigation is under the…Dec 14, 2017 · OE-FWD · DestroyedNTSB ERA18WA042Accident · 2 fatalForeign investigationRobinson R44 · Dubovaya Balka, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…Dec 5, 2017 · RA-04308 · Substantial damageNTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.Dec 2, 2017 · N481ZK · DestroyedNTSB ERA18RA045Accident · 2 fatalForeign investigationPiper PA28 · Vereda El Mortillo, ColombiaimportNov 30, 2017 · HK1573G · DestroyedNTSB WPR18WA019Accident · 2 fatalForeign investigationCessna T310 · Kew, New South Wales, AustraliaOn October 28, 2017, at 1600 local time, a Cessna T310R, VH-JMW, was destroyed when it collided with terrain near Kew, New South Wales, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The pilot and…Oct 28, 2017 · VH-JMW · DestroyedNTSB WPR18WA024Accident · 2 fatalForeign investigationCessna 210L · Darwin Aerodrome, AustraliaOn October 23, 2017, at 1332 local time, a Cessna 210L, VH-HWY, collided with terrain near Darwin Aerodrome, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The two occupants were fatally injured. The…Oct 23, 2017 · VH-HWY · DestroyedNTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…Oct 21, 2017 · N414MT · DestroyedNTSB CEN18WA016Accident · 1 fatalForeign investigationAvid Mark IV · Jüterborg, GermanyOn October 16, 2017, about 1123 UTC, an amateur-built Avid Mark IV airplane, French registration F-JAGB, owned and operated by a private individual, crashed during a test flight near Jüterborg, Germany. The pilot on board was fatally injured and the airplane…Oct 16, 2017 · F-JAGBNTSB CEN18WA005Accident · 1 fatalForeign investigationPiper PA25 · Cerro de Ortega, MexicoOct 5, 2017 · XB-DLL · Substantial damageNTSB ANC18RA001Accident · 1 fatalForeign investigationRobinson R44 · Campbell River, CanadaOct 1, 2017 · C-FMBO · Substantial damageNTSB ERA17WA344Accident · 2 fatalForeign investigationCessna 150 · BahamasOn September 26, 2017, a Cessna 150G, N3214X, went missing and was presumed to be substantially damaged. The private pilot and passenger were also missing, and presumed to be fatally injured. As of October 30, 2017, the airplane had not been found. A visual…Sep 26, 2017 · N3214X · Substantial damageNTSB CEN17WA369Accident · 1 fatalForeign investigationMD Helicopter 369 · Norrbotten, Sweden, SwedenOn September 26, 2017, about 1154 hours universal coordinated time, an MD Helicopters 369D, Swedish registration SE-JVI, impacted terrain about one-third mile from the Alvsbyn Airport (ESUV), Norrbotten, Sweden. One pilot was fatally injured and the second…Sep 26, 2017 · SE-JVI · DestroyedNTSB ERA17WA320Accident · 2 fatalForeign investigationCessna 182 · Pontinia, ItalyOn September 3, 2017 about 1030 universal coordinated time, a Cessna 182P, I-SCAP, impacted terrain during initial climb after takeoff, from Pegaso Club 2000 Airfield, Pontinia, Italy. The airplane was destroyed by impact forces and a post crash fire. Five…Sep 3, 2017 · I-SCAP · Substantial damageNTSB WPR17LA195Accident · 1 fatalLimited investigationFinal reportWalker Edgar E Glastar · Cascade, IDThe pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…Sep 2, 2017 · N65EW · DestroyedNTSB CEN17WA378Accident · 1 fatalForeign investigationPiper PA25 · Sueco, Chihuahua, Mexico, MexicoOn September 2, 2017, about 1700 hours universal coordinated time, a Piper PA25-235, Mexican registration XB-EXZ, was substantially damaged when it impacted powerlines near Sueco, Chihuahua, Mexico. The pilot was seriously injured. The local flight departed…Sep 2, 2017 · XB-EXZ · Substantial damageNTSB ERA17WA308Accident · 1 fatalForeign investigationMaule M7 · Zhideli, KazakhstanOn August 25, 2017, about 0450 coordinated universal time, a Maule M7-260C airplane, Kazakhstan registration UP-ML003, impacted terrain during a forced landing near Zhideli, Kazakhstan. The pilot was fatally injured and the passenger sustained serious…Aug 25, 2017 · UP-ML003 · Substantial damageNTSB ANC17FA047Accident · 1 fatalField investigationFinal reportRockwell International S 2R · Calipatria, CAA loss of control for reasons that could not be determined because of the extensive thermal damage from the postcrash fire.Aug 22, 2017 · N5022X · DestroyedNTSB ERA17WA283Accident · 1 fatalForeign investigationRobinson R66 · Maly Utrish, RussiaOn July 21, 2017, about 1832 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-05750, was substantially damaged when it impacted mountainous terrain near Maly Utrish township, while on a night flight from Anapa, Russia, to…Aug 21, 2017 · RA-05750 · Substantial damageNTSB ANC17WA048Accident · 2 fatalForeign investigationSocata TBM 700 · Zemyo, JapanOn Aug 14, 2017, at 1215 Japan standard time, a United States registered Socata TBM 700 airplane, N702AV, operated by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Zemyo in Nara Prefecture, Japan.…Aug 14, 2017 · N702AV · DestroyedNTSB ANC17WA045Accident · 1 fatalForeign investigationAir Tractor AT502 · La Crete, CanadaOn August 10, 2017, about 0320 Coordinated Universal Time, an Air Tractor AT-502B airplane, C-FWAS, impacted terrain while conducting an aerial application repositioning turn near La Crete, Alberta, Canada. The pilot sustained fatal injuries. The…Aug 10, 2017 · C-FWAS · Substantial damageNTSB CEN17WA269Accident · 1 fatalForeign investigationCessna TU206 · Surutato, MexicoOn June 30, 2017, about 1907 hours universal coordinated time, a Cessna TU206G single-engine airplane, serial number U20606684, Mexican registration XB-NWL, collided with terrain near Surutato, Mexico. The pilot was fatally injured. The flight's origin and…Jun 30, 2017 · XB-NWL · Substantial damageNTSB WPR17WA135Accident · 3 fatalForeign investigationSocata TB10 · Suttontown, AustraliaJun 28, 2017 · VH-YTM · Substantial damageNTSB ERA17WA224Accident · 2 fatalForeign investigationMD Helicopter 500 · Schinias Marathonas, GreeceOn June 23, 2017, about 0645 universal coordinated time, a MD Helicopter 500E, Greek registration SX-HBB, was substantially damaged when it struck a power line and impacted terrain near Schinias Marathonas, Greece. The Greek certificated pilot and one…Jun 23, 2017 · SX-HBB · Substantial damageNTSB WPR17WA129Accident · 1 fatalForeign investigationAirparts NZ FU 24 Stallion · Bathurst, AustraliaJun 16, 2017 · VH-EUO · Substantial damageNTSB WPR17WA127Accident · 1 fatalForeign investigationCessna 172 · Ballina, AustraliaJun 16, 2017 · VH-FYN · DestroyedNTSB ANC17WA029Accident · 3 fatalForeign investigationBell 206 · Fengbin, TaiwanOn June 10, 2017, about 1255 Taipei local time (0455 UTC), a Taiwanese registered Bell 206B3 helicopter, B-31118, operated by Emerald Pacific Airlines, impacted remote mountainous terrain about 8 miles south of Fengbin, Hualien County, under unknown…Jun 10, 2017 · B-31118 · DestroyedNTSB CEN17WA349Accident · 1 fatalForeign investigationPiper PA31 · Caernarfon, Gwynedd, United KingdomOn June 9, 2017, at 1705 coordinated universal time, a Piper PA31, N250AC, impacted terrain during landing at Caernarfon Airport (EGCK), Caernarfon, Gwynedd, Wales. The airplane was destroyed by impact forces and fire. The pilot, who was the sole occupant,…Jun 9, 2017 · N250AC · DestroyedNTSB ANC17WA027Accident · 4 fatalForeign investigationCessna 172 · Tateyama, JapanOn June 3, 2017, about 1450 Japan standard time (UTC +9), a Japanese registered Cessna 172P airplane, JA3989, operated by New Central Air Service, impacted snow-covered mountainous terrain near Tateyama, Toyama Prefecture, under unknown circumstances about 27…Jun 3, 2017 · JA3989 · Substantial damageNTSB WPR17WA115Accident · 3 fatalForeign investigationCessna 441 · Renmark, AustraliaOn May 30, 2017, about 1630 Australian central standard time, a Cessna 441, equipped with Garret TPE331 series turboprop engines, registration VH-XMJ, collided with terrain shortly after takeoff from Renmark Aerodrome, Renmark, SA, Australia. The three crew…May 30, 2017 · VH-XMJ · Substantial damageNTSB ERA17WA199Accident · 2 fatalForeign investigationPiper PA34 · Coxim Municipality, BrazilOn May 28, 2017, about 1540 coordinated universal time, a Piper PA-34-220T, Brazilian registration PT-WPD, was destroyed when it impacted terrain in Coxim Municipality, State of Mato Grosso so Sul, Brazil. The Brazilian pilot and passenger were fatally…May 28, 2017 · PT-WPD · DestroyedNTSB CEN17WA203Accident · 1 fatalForeign investigationCessna 182 · Palmar Norte de Osa, Puntarenas, Costa RicaOn May 28, 2017, a Panamanian-flagged Cessna 182, serial number FT34567, and reported false registration HP-1760FT, was located crashed in an African palm seeding field on a farm near Palmar Norte of Osa, Puntarenas, Costa Rica. The pilot, the sole person on…May 28, 2017 · HP-1760FT · DestroyedNTSB CEN17WA199Accident · 2 fatalForeign investigationPiper PA28R · Skipness/Kintyre, Scotland, United KingdomOn May 25, 2017, about 1300 hours universal coordinated time, a Piper PA-28R-201, United Kingdom registration G-CEOF, impacted the sea near Skipness/Kintyre, Scotland, United Kingdom. The two occupants on-board were fatally injured. The flight departed Oban…May 25, 2017 · G-CEOF · DestroyedNTSB ERA17WA198Accident · 2 fatalForeign investigationCessna 206 · Cerro Azul, EcuadorOn May 18, 2017, at an unknown time, a Cessna 206H, Ecuadorian registration HC-CEG, was destroyed when it impacted terrain in Cerro Azul, Ecuador. The foreign certificated pilot and one passenger were fatally injured. The flight departed Jose Joaquin de…May 18, 2017 · HC-CEG · DestroyedNTSB CEN17WA187Accident · 2 fatalForeign investigationLearjet 25 · Toluca, MexicoOn May 17, 2017, at 2025 hours universal coordinated time, a Lear 25B airplane, Mexican registration XA-VMC, impacted terrain near Toluca, Mexico. The pilot-in-command and co-pilot were fatally injured. The airplane was destroyed by impact forces and a…May 17, 2017 · XA-VMC · DestroyedNTSB CEN17WA189Accident · 1 fatalForeign investigationMonocoupe 90AF · Plattsville, CanadaOn May 13, 2017, a Monocoupe 90F-100 airplane, C-FJGA, impacted short of the threshold at Lubitz Flying Field (CLB2), Plattsville, Ontario. The pilot was fatally injured.This investigation is under the jurisdiction and control of the government of Canada. Any…May 13, 2017 · C-FJGA · Substantial damageNTSB ERA17WA183Accident · 1 fatalForeign investigationEnstrom Helicopter 480B · Fundres, ItalyOn May 10, 2017, about 1143 universal coordinated time,an Enstrom 480B, N480W, was destroyed during an infight break-up near Fundres, Italy. The flight departed from Bolzano, Italy, and was destined for Linz, Italy. The pilot was fatally injured. This…May 10, 2017 · N480W · DestroyedNTSB CEN17RA191Accident · 2 fatalForeign investigationBell 429 · Presov, SlovakiaOn May 10, 2017, about 1430 local time, a Bell 429 helicopter, Slovakia registration OM-BYM, impacted terrain shortly after takeoff near Presov, Slovakia. There were four people on board; two people received fatal injuries and two people received serious…May 10, 2017 · OM-BYM · Substantial damageNTSB ERA17WA173Accident · 3 fatalForeign investigationRobinson R44 · Beloretsk, RussiaOn May 4, 2017, about 1020 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04156, was substantially damaged when it impacted mountainous terrain during a fire monitoring mission after departing from Beloretsk, Bashkortostan,…May 4, 2017 · RA-04156 · Substantial damageNTSB CEN17WA172Accident · 2 fatalForeign investigationPiper PA31 · Schefferville, CanadaOn April 30, 2017, a Piper PA-31 airplane, C-FQQB, impacted terrain near Schefferville, Quebec. The two pilots were fatality injured. The accident investigation is under the jurisdiction and control of the Canadian government. This report is for information…Apr 30, 2017 · C-FQQB · Substantial damageNTSB CEN17FA170Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Hollis, OKAn impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.Apr 28, 2017 · N604RH · Substantial damageNTSB ERA17WA159Accident · 2 fatalForeign investigationCessna 172 · Cassilandia, BrazilOn April 14, 2017, about 2045 coordinated universal time, a privately owned and operated Cessna 172N, Brazilian registration PR-LPW, was substantially damaged after it struck a tree about 400 meters from the threshold of runway 13 at the Aeroporto de…Apr 14, 2017 · PR-LPW · Substantial damageNTSB WPR17WA123Accident · 1 fatalForeign investigationCessna 208 · Anem Mountain, Oksibil, IndonesiaOn April 12, 2017, about 0340 universal coordinated time, a Cessna 208C, PK-FSO, operated by PT. Spirit Avia Sentosa as an unscheduled cargo flight under the pertinent civil regulations of the government of Indonesia, collided with mountainous terrain 7…Apr 12, 2017 · PK-FSO · DestroyedNTSB ERA17WA147Accident · 2 fatalForeign investigationPiper PA-42 · Sorocaba, BrazilOn March 31, 2017, about 1745 coordinated universal time (1445 local time), a Piper PA-42, Brazilian registration PP-EPB, operated by a private individual, was destroyed after it impacted the ground while on approach to Barra Do Garcas Airport (SBBW),…Mar 31, 2017 · PP-EPB · DestroyedNTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.Mar 28, 2017 · N643RJ · Substantial damageNTSB WPR17WA083Accident · 1 fatalForeign investigationRobinson R22 · Reefton, New ZealandOn March 27, 2017, about 0345 Universal Time, a Robinson R22, New Zealand registration ZK-IHA, impacted forested terrain about 5.5 miles north of Reefton, West Coast. The pilot, the sole occupant was fatally injured, and the helicopter was substantially…Mar 27, 2017 · ZK-IHA · Substantial damageNTSB CEN17FA138Accident · 1 fatalField investigationFinal reportBeech V35 · Union City, OKThe pilot's improper recovery from a spin.Mar 24, 2017 · N2053Y · DestroyedNTSB CEN17RA131Accident · 4 fatalForeign investigationSikorsky S92 · Blacksod Bay, IrelandOn March 14, 2017, about 1719 universal coordinated time (UTC), a Sikorsky S-92 helicopter, Irish registration EI-ICR, crashed offshore near Blackrock Island West of Blacksod Bay, Ireland. There were 4 occupants. The pilot was fatally injured and 3…Mar 14, 2017 · EI-ICR · Destroyed