# NTSB investigations, 2018, Outside the U.S.: Approach

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 DCA19WA044](https://openairdocs.org/ntsb/DCA19WA044.md): Boeing 737 · Tijuana, Mexico · Incident · No injuries · Foreign investigation · Dec 12, 2018 · XA-ADV · Minor damage
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ENG19RA007](https://openairdocs.org/ntsb/ENG19RA007.md): Airbus A330 · Brussels, Belgium · Incident · No injuries · Foreign investigation · Dec 11, 2018 · OO-SFU · No damage
  > The Air Accident Investigation Unit of Belgium has notified the NTSB of a serious incident involving an Airbus A330-223 that occurred on December 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation Unit…
- [NTSB ENG19WA011](https://openairdocs.org/ntsb/ENG19WA011.md): Airbus A320 · Jaipur, India · Incident · No injuries · Foreign investigation · Dec 10, 2018 · VT-ITR · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on December 10, 2018. An Indigo Airbus A320 experienced an ECAM warning for 'Lavatory Smoke' while descending through FL170 to land Kolkata Airport…
- [NTSB CEN19WA043](https://openairdocs.org/ntsb/CEN19WA043.md): Cessna 177 · Spain, Spain · Accident · 2 fatal · Foreign investigation · Dec 7, 2018 · D-ECGS · Destroyed
  > The government of Spain has notified the NTSB of an accident involving a CESSNA 177 airplane that occurred on December 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB ERA19WA058](https://openairdocs.org/ntsb/ERA19WA058.md): Cessna 525 · Jequitaí County, Brazil · Accident · 4 fatal · Foreign investigation · Nov 26, 2018 · PP-OEG · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Cessna 525 airplane that occurred on November 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB ERA19WA054](https://openairdocs.org/ntsb/ERA19WA054.md): Eurocopter EC120 · La Romana, Dominican Republic · Accident · 5 fatal · Foreign investigation · Nov 22, 2018 · N124ML · Destroyed
  > The government of Dominican Republic has notified the NTSB of an accident involving a Eurocopter EC120 helicopter that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…
- [NTSB GAA19WA419](https://openairdocs.org/ntsb/GAA19WA419.md): Socata TB20 · Dinard Pleurtuit, France · Accident · 2 fatal · Foreign investigation · Nov 17, 2018 · F-GKVZ · Destroyed
  > The government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB ERA19WA040](https://openairdocs.org/ntsb/ERA19WA040.md): Piper PA23 · Nassau, Bahamas · Accident · 1 fatal · Foreign investigation · Nov 8, 2018 · N8383C · Substantial damage
  > The government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…
- [NTSB ERA19WA046](https://openairdocs.org/ntsb/ERA19WA046.md): Garlick UH1D · Valparaiso, Chile · Accident · Serious injuries · Foreign investigation · Oct 24, 2018 · CC-CPU · Destroyed
  > The government of Chile has notified the NTSB of an accident involving a GARLICK UH1D helicopter that occurred on October 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions…
- [NTSB DCA19WA008](https://openairdocs.org/ntsb/DCA19WA008.md): Boeing 787 · Perth, Australia · Incident · No injuries · Foreign investigation · Oct 11, 2018 · 9V-OJE · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on October 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB DCA19WA011](https://openairdocs.org/ntsb/DCA19WA011.md): Boeing 737 · Brisbane, Australia · Incident · No injuries · Foreign investigation · Oct 9, 2018 · VH-YFW · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on October 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB WPR19WA004](https://openairdocs.org/ntsb/WPR19WA004.md): Cessna 172 · Midrand, South Africa · Accident · 2 fatal · Foreign investigation · Oct 8, 2018 · ZS-PZT · Substantial damage
  > On October 8, 2018, at 0920 coordinated universal time, a Cessna 172L airplane, registration ZS-PZT, sustained substantial damage after colliding with the ground during the landing approach at Grand Central Airport, Midrand, South Africa. The pilot and one…
- [NTSB ERA19WA038](https://openairdocs.org/ntsb/ERA19WA038.md): Siai Marchetti SF260 · Caorle, Italy · Accident · 2 fatal · Foreign investigation · Oct 3, 2018 · I-ISAE · Destroyed
  > The government of Italy has notified the NTSB of an accident involving a Siai Marchetti SF260 airplane that occurred on October 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…
- [NTSB DCA18RA292](https://openairdocs.org/ntsb/DCA18RA292.md): Boeing 737 · Chuuk, Micronesia · Accident · 1 fatal · Foreign investigation · Sep 28, 2018 · P2-PXE · Substantial damage
  > The government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…
- [NTSB DCA18WA288](https://openairdocs.org/ntsb/DCA18WA288.md): Boeing 747 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Sep 16, 2018 · TC-ACM · Minor damage
  > The BFU of Germany has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on September 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the BFU of Germany's investigation under the provisions of ICAO…
- [NTSB WPR18WA254](https://openairdocs.org/ntsb/WPR18WA254.md): Cessna 182M · Leshiba Wilderness, South Africa · Accident · Serious injuries · Foreign investigation · Sep 1, 2018 · ZS-IAM · Substantial damage
  > On September 1, 2018, at 1247 universal coordinated time, a Cessna 182M, ZS-IAM, collided with trees while on final approach to land at Leshiba Wilderness, South Africa. The pilot and passenger were seriously injured. The airplane was substantially damaged.…
- [NTSB DCA18WA278](https://openairdocs.org/ntsb/DCA18WA278.md): Airbus A321-271N · Tapachula, Mexico · Incident · No injuries · Foreign investigation · Aug 20, 2018 · N535VL · Minor damage
  > The government of Mexico has notified the NTSB of an accident involving a AIRBUS A321-271N airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…
- [NTSB CEN18WA394](https://openairdocs.org/ntsb/CEN18WA394.md): Piper PA28 · Décines, France · Accident · No injuries · Foreign investigation · Aug 2, 2018 · F-GKEC · Substantial damage
  > On August 2, 2018, about 1930 UTC, a Piper PA-28-181 airplane, French registration F-GKEC, sustained a loss of engine power while on approach to the Lyon-Bron Airport (LFLY), near Décines, France. The two occupants onboard sustained no injury. The airplane…
- [NTSB ERA18WA209](https://openairdocs.org/ntsb/ERA18WA209.md): Beech 90 · Sao Paulo, Brazil · Accident · 1 fatal · Foreign investigation · Jul 29, 2018 · PP-SZN · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Beech C90 that occurred on July 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO Annex…
- [NTSB CEN18WA264](https://openairdocs.org/ntsb/CEN18WA264.md): Cessna 152 · Ponte de Sor, Portugal · Accident · 1 fatal · Foreign investigation · Jul 10, 2018 · CS-DGU · Destroyed
  > The government of Portugal has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…
- [NTSB ENG18WA039](https://openairdocs.org/ntsb/ENG18WA039.md): Mcdonnell Douglas MD80 · Songshan, Taipei, China, Taiwan · Incident · No injuries · Foreign investigation · Jul 2, 2018 · B28035 · No damage
  > On July 2, 2018, Far Eastern Air Transport, flight FE8026, an MD82 aircraft, registration number B-28035, took off from Penghu Airport for Songsang Airport. The aircraft declared PAN PAN at 7 miles from the runway of Songshan Airport at an altitude of 2,800…
- [NTSB WPR18WA187](https://openairdocs.org/ntsb/WPR18WA187.md): Cessna 172 · Moorabbin, Australia · Accident · 1 fatal · Foreign investigation · Jun 8, 2018 · VH-EWE · Substantial damage
- [NTSB CEN18WA169](https://openairdocs.org/ntsb/CEN18WA169.md): Cessna 208B · Clonbullogue, Ireland · Accident · 2 fatal · Foreign investigation · May 13, 2018 · G-KNYS · Destroyed
- [NTSB WPR18WA281](https://openairdocs.org/ntsb/WPR18WA281.md): Zenith CH610 HD · Germiston, South Africa · Accident · No injuries · Foreign investigation · May 12, 2018 · ZU-FFA · Substantial damage
  > On May 12, 2018, about 0730 Universal Coordinated time, a Zenith Zodiac CH 610 HD airplane, ZU-FFA, touched down and overturned about 100 meters short of runway 11 at Rand Airport, Germiston, South Africa, following a loss of engine power. The pilot sustained…
- [NTSB DCA18WA173](https://openairdocs.org/ntsb/DCA18WA173.md): Boeing 767 323 · Guayaquil, Ecuador · Incident · No injuries · Foreign investigation · May 3, 2018 · N396AN · No damage
  > The government of Ecuador has notified the NTSB of an incident involving a BOEING 767 323 airplane that occurred on May 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…
- [NTSB CEN18WA399](https://openairdocs.org/ntsb/CEN18WA399.md): Cessna 172 · Hamilton, Bermuda · Accident · Minor injuries · Foreign investigation · Apr 30, 2018 · N9085H · Substantial damage
  > On April 30, 2018, about 2045 universal coordinated time (UTC), a Cessna 172 M airplane, N9085H, was substantially damaged during a landing at the L. F. Wade International Airport, near Hamilton, Bermuda. The pilot sustained minor injuries.The accident…
- [NTSB CEN18WA141](https://openairdocs.org/ntsb/CEN18WA141.md): Cirrus SR20 · Adolf Wurth Airport, Germany · Accident · 2 fatal · Foreign investigation · Apr 15, 2018 · D-EWTG · 2 aircraft · Destroyed
  > On April 15, 2018, at 1300 UTC, a Cirrus SR-20, D-EWTG, and a Dallach D4b Fascination, D-MJEK, encountered a midair collision under unknown circumstances near Adolf Würth Airport (EDTY), Schwäbisch Hall, Germany. Both aircraft were destroyed; and the pilots,…
- [NTSB DCA18WA123](https://openairdocs.org/ntsb/DCA18WA123.md): Boeing 737 · Osaka, Japan · Accident · No injuries · Foreign investigation · Apr 9, 2018 · HL7725 · Substantial damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…
- [NTSB ENG18WA021](https://openairdocs.org/ntsb/ENG18WA021.md): Boeing 747 · Chek Lap Kok, Hong Kong SAR China · Incident · No injuries · Foreign investigation · Mar 29, 2018 · JA18KZ · No damage
  > The Hong Kong Civil Aviation Department (HKCAD) has notified the NTSB of an incident involving a Boeing 747-8F airplane which occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the HKCAD investigation under the…
- [NTSB WPR18WA110](https://openairdocs.org/ntsb/WPR18WA110.md): Eurocopter EC120 · Hardy Reef, Queensland, Australia · Accident · 2 fatal · Foreign investigation · Mar 21, 2018 · VH-WII · Substantial damage
  > On March 21, 2018, about 1500 local time, a Eurocopter (Airbus Helicopters) EC120B helicopter, VH-WII, sustained substantial damage when it impacted water during an aborted landing attempt on a floating helicopter landing site (HLS) located between Hardy Reef…
- [NTSB ENG18RA018](https://openairdocs.org/ntsb/ENG18RA018.md): Cessna 441 · Broome, Australia, Australia · Incident · No injuries · Foreign investigation · Mar 2, 2018 · VH-LBY · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Cessna 441 which occurred on March 2, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…
- [NTSB DCA18WA088](https://openairdocs.org/ntsb/DCA18WA088.md): Boeing 757 23A · Tel Aviv, Israel · Incident · No injuries · Foreign investigation · Jan 30, 2018 · N919FD · No damage
  > The Israel's Ministry of Transport has notified the NTSB of an incident involving a Boeing 757, which occurred on January 30, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State 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") = 2018
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=OF&year=2018

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
