# NTSB investigations, 2017: Unknown

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA18WA051](https://openairdocs.org/ntsb/ERA18WA051.md): Beech A36 · Itapua, Paraguay · Accident · 1 fatal · Foreign investigation · Dec 17, 2017 · ZP-BHU · Destroyed
- [NTSB WPR18WA078](https://openairdocs.org/ntsb/WPR18WA078.md): Beech 58 · Qaroun Lake, Egypt · Accident · 3 fatal · Foreign investigation · Dec 15, 2017 · SU-BLD · Substantial damage
  > On 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…
- [NTSB ERA18WA042](https://openairdocs.org/ntsb/ERA18WA042.md): Robinson R44 · Dubovaya Balka, Russia · Accident · 2 fatal · Foreign investigation · Dec 5, 2017 · RA-04308 · Substantial damage
  > The 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…
- [NTSB ERA18LA039](https://openairdocs.org/ntsb/ERA18LA039.md): Kevin Leue Sparrow Hawk · Hernando, MS · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2017 · N481ZK · Destroyed
  > Impact with trees and terrain for reasons that could not be determined based on available evidence.
- [NTSB ERA18RA045](https://openairdocs.org/ntsb/ERA18RA045.md): Piper PA28 · Vereda El Mortillo, Colombia · Accident · 2 fatal · Foreign investigation · Nov 30, 2017 · HK1573G · Destroyed
  > import
- [NTSB WPR18WA019](https://openairdocs.org/ntsb/WPR18WA019.md): Cessna T310 · Kew, New South Wales, Australia · Accident · 2 fatal · Foreign investigation · Oct 28, 2017 · VH-JMW · Destroyed
  > On 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…
- [NTSB WPR18WA024](https://openairdocs.org/ntsb/WPR18WA024.md): Cessna 210L · Darwin Aerodrome, Australia · Accident · 2 fatal · Foreign investigation · Oct 23, 2017 · VH-HWY · Destroyed
  > On 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…
- [NTSB GAA18CA020](https://openairdocs.org/ntsb/GAA18CA020.md): Cessna 150 · Pottsville, PA · Accident · No injuries · Data collection · Final report · Oct 22, 2017 · N22092 · Substantial damage
  > The failure of the right rudder cable and subsequent loss of directional control during landing.
- [NTSB CEN18WA016](https://openairdocs.org/ntsb/CEN18WA016.md): Avid Mark IV · Jüterborg, Germany · Accident · 1 fatal · Foreign investigation · Oct 16, 2017 · F-JAGB
  > On 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…
- [NTSB DCA17WA196](https://openairdocs.org/ntsb/DCA17WA196.md): Boeing 737 · Leon, Mexico · Incident · No injuries · Foreign investigation · Sep 3, 2017 · XA-MAI
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ERA17WA343](https://openairdocs.org/ntsb/ERA17WA343.md): Cessna 182 · Ivano-Frankivsk, Ukraine · Accident · Serious injuries · Foreign investigation · Jul 22, 2017 · UR-ORV · Substantial damage
  > On July 22, 2017, about 1305 coordinated universal time, a Cessna 182, Ukrainian registration UR-ORV, was substantially damaged during a forced landing near Ivano-Frankiivsk region, Ukraine. There were 5 people on board, of which 3 were seriously injured. The…
- [NTSB CEN17WA296](https://openairdocs.org/ntsb/CEN17WA296.md): Cessna 182 · Aeródromo de la Isla de Utila, Honduras · Accident · No injuries · Foreign investigation · Jul 1, 2017 · HR-AXI · Substantial damage
- [NTSB CEN17WA269](https://openairdocs.org/ntsb/CEN17WA269.md): Cessna TU206 · Surutato, Mexico · Accident · 1 fatal · Foreign investigation · Jun 30, 2017 · XB-NWL · Substantial damage
  > On 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…
- [NTSB WPR17WA129](https://openairdocs.org/ntsb/WPR17WA129.md): Airparts NZ FU 24 Stallion · Bathurst, Australia · Accident · 1 fatal · Foreign investigation · Jun 16, 2017 · VH-EUO · Substantial damage
- [NTSB WPR17WA127](https://openairdocs.org/ntsb/WPR17WA127.md): Cessna 172 · Ballina, Australia · Accident · 1 fatal · Foreign investigation · Jun 16, 2017 · VH-FYN · Destroyed
- [NTSB ANC17WA029](https://openairdocs.org/ntsb/ANC17WA029.md): Bell 206 · Fengbin, Taiwan · Accident · 3 fatal · Foreign investigation · Jun 10, 2017 · B-31118 · Destroyed
  > On 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…
- [NTSB WPR17WA115](https://openairdocs.org/ntsb/WPR17WA115.md): Cessna 441 · Renmark, Australia · Accident · 3 fatal · Foreign investigation · May 30, 2017 · VH-XMJ · Substantial damage
  > On 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…
- [NTSB CEN17WA203](https://openairdocs.org/ntsb/CEN17WA203.md): Cessna 182 · Palmar Norte de Osa, Puntarenas, Costa Rica · Accident · 1 fatal · Foreign investigation · May 28, 2017 · HP-1760FT · Destroyed
  > On 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…
- [NTSB CEN17WA199](https://openairdocs.org/ntsb/CEN17WA199.md): Piper PA28R · Skipness/Kintyre, Scotland, United Kingdom · Accident · 2 fatal · Foreign investigation · May 25, 2017 · G-CEOF · Destroyed
  > On 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…
- [NTSB ERA17WA198](https://openairdocs.org/ntsb/ERA17WA198.md): Cessna 206 · Cerro Azul, Ecuador · Accident · 2 fatal · Foreign investigation · May 18, 2017 · HC-CEG · Destroyed
  > On 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…
- [NTSB CEN17WA175](https://openairdocs.org/ntsb/CEN17WA175.md): Socata-Groupe Aerospatiale TB 20 · Malaga, Spain · Accident · 3 fatal · Foreign investigation · Apr 29, 2017 · D-ECJP · Substantial damage
  > On April 29, 2017, at 1632 UTC, a Socata TB-20, D-ECJP, impacted terrain near Canillas de Aceituno in Malaga, Spain. The aircraft was destroyed, and the pilot and two passengers were fatally injured. The flight departed Mutxamel Airfield (LEMU) in Alicante,…
- [NTSB ERA17WA179](https://openairdocs.org/ntsb/ERA17WA179.md): Piper PA30 · Sao Paulo, Brazil · Accident · 2 fatal · Foreign investigation · Apr 28, 2017 · PT-CHT · Substantial damage
  > On April 28, 2017, about 1930 coordinated universal time, a Piper PA30, Brazilian registration PT-CHT, was substantially damaged when it impacted terrain during an instructional flight near Sao Paulo, Brazil. The pilot and copilot were fatally injured. The…
- [NTSB ERA17WA159](https://openairdocs.org/ntsb/ERA17WA159.md): Cessna 172 · Cassilandia, Brazil · Accident · 2 fatal · Foreign investigation · Apr 14, 2017 · PR-LPW · Substantial damage
  > On 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…
- [NTSB ERA17WA147](https://openairdocs.org/ntsb/ERA17WA147.md): Piper PA-42 · Sorocaba, Brazil · Accident · 2 fatal · Foreign investigation · Mar 31, 2017 · PP-EPB · Destroyed
  > On 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),…
- [NTSB CEN17WA137](https://openairdocs.org/ntsb/CEN17WA137.md): Cessna 152 · St-Bruno, Quebec, Canada · Accident · 1 fatal · Foreign investigation · Mar 17, 2017 · C-FGOI · 2 aircraft · Destroyed
- [NTSB CEN17FA132](https://openairdocs.org/ntsb/CEN17FA132.md): Cessna 210B · Opal, SD · Accident · 1 fatal · Field investigation · Final report · Mar 16, 2017 · N9581X · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined due to a lack of evidence.
- [NTSB CEN17WA133](https://openairdocs.org/ntsb/CEN17WA133.md): Cessna 172P · Manitouwadge, Canada · Accident · No injuries · Foreign investigation · Mar 15, 2017 · N230TX · Substantial damage
  > On March 15, 2017, at an unknown time, a Cessna 172P airplane, N230TX, owned and operated by the University of Michigan Flyers Inc. was substantially damaged when it collided with wooded terrain near Manitouwadge, Ontario, Canada. No pilot or occupant was…
- [NTSB CEN17WA130](https://openairdocs.org/ntsb/CEN17WA130.md): Bell 206 · Figeac, France · Accident · 1 fatal · Foreign investigation · Mar 15, 2017 · F-GPPH · Destroyed
  > On March 15, 2017, about 2100 universal coordinated time (UTC), a Bell 206 helicopter, F-GPPH, impacted terrain near Figeac, France. The pilot was fatally injured and the helicopter was destroyed. The flight originated from Poiters Biard (LFBI), France, and…
- [NTSB CEN17CA140](https://openairdocs.org/ntsb/CEN17CA140.md): Cessna 172R · Cahokia, IL · Accident · No injuries · Data collection · Final report · Feb 23, 2017 · N51827 · Substantial damage
  > A hard landing for reasons that could not be determined based on the available evidence.
- [NTSB ERA17WA104](https://openairdocs.org/ntsb/ERA17WA104.md): Robinson R66 · Lake Teletskoye, Russia · Accident · 5 fatal · Foreign investigation · Feb 12, 2017 · RA-06375 · Substantial damage
  > On February 12, 2017, at 1319 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-06375, was substantially damaged when it crashed into Lake Teletskoye, Republic of Altai, Russia. The pilot and four passengers were fatally injured.…
- [NTSB CEN17WA102](https://openairdocs.org/ntsb/CEN17WA102.md): MD Helicopter 600 · Guatemala City, Guatemala · Accident · 4 fatal · Foreign investigation · Feb 7, 2017 · N245SE · Substantial damage
  > On February 7, 2017, about 1253 local time, a United States-registered MD 600N helicopter, N245SE, impacted terrain at the La Aurora International Airport, Guatemala City, Guatemala. The pilot and three passengers were fatally injured. The investigation is…
- [NTSB ERA17WA350](https://openairdocs.org/ntsb/ERA17WA350.md): Beech 58 · Puerto la Cruz, Venezuela · Accident · 6 fatal · Foreign investigation · Jan 28, 2017 · YV-1513 · Destroyed
  > The government of Venezuela has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on January 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…
- [NTSB CEN17WA083](https://openairdocs.org/ntsb/CEN17WA083.md): Robinson R44 · Salinas Victoria, Mexico · Accident · 2 fatal · Foreign investigation · Jan 21, 2017 · XA-CSJ · Destroyed
  > On January 21, 2017, about 1800 universal coordinated time, a Robinson R44 helicopter, XA-CSJ, impacted terrain near Salinas Victoria, Mexico. The pilot and one passenger were fatally injured and the helicopter was destroyed by impact and fire damage. The…
- [NTSB ERA17WA094](https://openairdocs.org/ntsb/ERA17WA094.md): Cessna 172 · Araucania, Chile · Accident · 2 fatal · Foreign investigation · Jan 20, 2017 · CC-AGK · Substantial damage
  > On January 20, 2017, about 2120 coordinated universal time, a Cessna 172S, Chilean registration CC-AGK, was substantially damaged when it impacted terrain near Araucania, Chile. The pilot and one passenger were fatally injured, while two other passengers were…
- [NTSB ERA17WA093](https://openairdocs.org/ntsb/ERA17WA093.md): Hawker Beechcraft C90GT · Parati, Brazil · Accident · 5 fatal · Foreign investigation · Jan 19, 2017 · PR-SOM · Substantial damage
  > On January 19, 2017, about 1530 UTC, A Beechcraft C90GT, Brazilian registration PR-SOM, was destroyed when it impacted the sea after departing from Campo de Marte Airport (SBMT), Sao Paulo, Brazil. The five occupants were fatally injured.This accident…
- [NTSB CEN17WA077](https://openairdocs.org/ntsb/CEN17WA077.md): Piper Piper PA-30 · Oxfordshire, United Kingdom · Accident · 1 fatal · Foreign investigation · Jan 15, 2017 · G-ATMT · Destroyed
  > On January 15, 2017, a Piper PA-30 airplane, (G-ATMT, s/n 30-439), crashed into woodland near Oxfordshire, United Kingdom. There was one person on board, who was fatally injured, and the aircraft was destroyed.This investigation is under the jurisdiction and…
- [NTSB ERA17WA082](https://openairdocs.org/ntsb/ERA17WA082.md): Cessna A188 · Michiragua, Colombia · Accident · 1 fatal · Foreign investigation · Jan 7, 2017 · HK714
  > On January 7, 2017, about 1315 UTC, a Cessna A188A; HK714 was lost at sea after takeoff from La Guajira, Columbia. The wreckage was not recovered and the pilot was presumed fatally injured.The investigation is under the jurisdiction of the Government of…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?year=2017

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
