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

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.

Page 1 of 2 · 100 cases

## Latest cases

- [NTSB ENG19IA008](https://openairdocs.org/ntsb/ENG19IA008.md): Airbus A220 · Busan, South Korea · Incident · Class 3 · Incident · Final report · Dec 26, 2018 · HL8314 · No damage
  > The manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…
- [NTSB ERA19RA077](https://openairdocs.org/ntsb/ERA19RA077.md): Agusta A109 · Santa Maria Coronango, State of Puebla, Mexico · Accident · 5 fatal · Foreign investigation · Dec 24, 2018 · XA-BON · Destroyed
  > The government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…
- [NTSB DCA19WA057](https://openairdocs.org/ntsb/DCA19WA057.md): Boeing 747-428 · Delhi Airspace, India · Incident · No injuries · Foreign investigation · Dec 21, 2018 · N919CA · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on December 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…
- [NTSB CEN19WA080](https://openairdocs.org/ntsb/CEN19WA080.md): Cirrus SR22 · Toussus-Le-Noble, France · Accident · No injuries · Foreign investigation · Dec 18, 2018 · N842CD · Destroyed
  > The government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB CEN19WA102](https://openairdocs.org/ntsb/CEN19WA102.md): Cirrus SR22 · Beauberry, France · Accident · 3 fatal · Foreign investigation · Dec 10, 2018 · F-HUGE · Substantial damage
  > The government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB DCA19CA034](https://openairdocs.org/ntsb/DCA19CA034.md): Boeing 767 · SUNNS intersection, Osaka, Japan · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 4, 2018 · N193DN · No damage
  > The airplane’s encounter with severe turbulence.
- [NTSB CEN19WA040](https://openairdocs.org/ntsb/CEN19WA040.md): Cessna U206 · Culiacan, Sinaloa, Mexico · Accident · 4 fatal · Foreign investigation · Dec 3, 2018 · XB-NGU · Substantial damage
- [NTSB WPR19WA033](https://openairdocs.org/ntsb/WPR19WA033.md): Cessna U206 · Machadodorp, South Africa · Accident · Serious injuries · Foreign investigation · Nov 29, 2018 · ZS-DIV · Substantial damage
  > On November 29, 2018, about 1606 universal coordinated time, a Cessna U206D airplane, South African registration ZS-DIV, impacted terrain near the Skoonman Kloff in the Machadodorp area in Mpumalanga Province, South Africa. The pilot and 4 passengers were…
- [NTSB WPR19WA038](https://openairdocs.org/ntsb/WPR19WA038.md): Bell 407 GX · West Bangkala, Indonesia · Accident · No injuries · Foreign investigation · Nov 28, 2018 · PK-JPB · Substantial damage
  > On November 28, 2018, about 0850 coordinated universal time, a Bell Helicopter 407 GX, PK-JPB, executed a precautionary landing following the illumination of the engine chip detector caution light near West Bangkala, Indonesia. There were no injuries to the…
- [NTSB ERA19WA104](https://openairdocs.org/ntsb/ERA19WA104.md): Agusta AW109 · Campos do Jordao, Brazil · Accident · 6 fatal · Foreign investigation · Nov 24, 2018 · PT-FPS · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB WPR19WA081](https://openairdocs.org/ntsb/WPR19WA081.md): Cessna U206 · Chemajenjera Hill, Zimbabwe · Accident · 5 fatal · Foreign investigation · Nov 23, 2018 · Z-BRS · Destroyed
  > On November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…
- [NTSB ERA19WA053](https://openairdocs.org/ntsb/ERA19WA053.md): Cessna TU206 · Puente Alto, Chile · Accident · 2 fatal · Class 5 · Foreign · Nov 21, 2018 · CC-CXS · Destroyed
- [NTSB DCA21WA112](https://openairdocs.org/ntsb/DCA21WA112.md): Boeing 737 · Buenos Aires, Argentina · Incident · No injuries · Class 5 · Foreign · Nov 17, 2018 · LV-HFR · No damage
- [NTSB ERA19WA045](https://openairdocs.org/ntsb/ERA19WA045.md): Piper PA25 · Ezperanza, Dominican Republic · Accident · No injuries · Foreign investigation · Nov 14, 2018 · HI191 · Substantial damage
  > The government of the Dominican Republic has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Dominican Republic's…
- [NTSB CEN19WA041](https://openairdocs.org/ntsb/CEN19WA041.md): Cessna T206H · Tampico, Mexico · Accident · 2 fatal · Foreign investigation · Nov 12, 2018 · XB-ILM · Substantial damage
  > On November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…
- [NTSB DCA19WA023](https://openairdocs.org/ntsb/DCA19WA023.md): Embraer 190 · Bara, Portugal · Incident · No injuries · Foreign investigation · Nov 11, 2018 · P4-KCJ · No damage
  > The GPIA of Portugal has notified the NTSB of an incident involving a Embraer 190 airplane that occurred on November 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GPIA of Portugal's investigation under the provisions of ICAO…
- [NTSB CEN19WA038](https://openairdocs.org/ntsb/CEN19WA038.md): Piper PA25 · Pachuca, Mexico, Mexico · Accident · 1 fatal · Foreign investigation · Nov 8, 2018 · XB-FRC
  > The government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB CEN19WA037](https://openairdocs.org/ntsb/CEN19WA037.md): Rotorway Exec · Saint Pierre, St. Pierre & Miquelon · Accident · 1 fatal · Foreign investigation · Nov 5, 2018 · F-PSPM · Destroyed
- [NTSB CEN19WA042](https://openairdocs.org/ntsb/CEN19WA042.md): Piper PA34 · Uk, United Kingdom · Accident · No injuries · Foreign investigation · Nov 2, 2018 · G-OXFF
  > The government of United Kingdom has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on November 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…
- [NTSB DCA19WA015](https://openairdocs.org/ntsb/DCA19WA015.md): Boeing 787 · Hong Kong, China · Incident · No injuries · Foreign investigation · Oct 20, 2018 · VT-ANE · No damage
  > The government of China has notified the NTSB of an accident involving a BOEING 787 airplane that occurred on October 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…
- [NTSB DCA19WA027](https://openairdocs.org/ntsb/DCA19WA027.md): Boeing 737 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · Oct 19, 2018 · HS-LTJ · No damage
  > The AAIC of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIC of Thailand's investigation under the provisions of ICAO…
- [NTSB WPR19WA012](https://openairdocs.org/ntsb/WPR19WA012.md): Hughes 369 · Wanaka, New Zealand · Accident · 3 fatal · Class 5 · Foreign · Oct 17, 2018 · ZK-H0J · Destroyed
- [NTSB DCA19WA071](https://openairdocs.org/ntsb/DCA19WA071.md): Boeing 747 · Kolkata, India · Incident · No injuries · Foreign investigation · Oct 16, 2018 · N578UP · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…
- [NTSB DCA19WA013](https://openairdocs.org/ntsb/DCA19WA013.md): Boeing 737 · East Midlands, United Kingdom · Incident · No injuries · Foreign investigation · Oct 12, 2018 · G-JMCR · No damage
  > The government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…
- [NTSB DCA19WA009](https://openairdocs.org/ntsb/DCA19WA009.md): Boeing 737 · Zagreb, Croatia · Incident · Minor injuries · Foreign investigation · Oct 2, 2018 · TC-AMP · No damage
  > The AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…
- [NTSB CEN19WA001](https://openairdocs.org/ntsb/CEN19WA001.md): Cessna 210 5 · Yécora, Mexico · Accident · 3 fatal · Foreign investigation · Oct 1, 2018 · N8388Z · Substantial damage
  > On October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…
- [NTSB DCA18WA300](https://openairdocs.org/ntsb/DCA18WA300.md): Boeing 737 · Diagoras, Hungary · Incident · No injuries · Foreign investigation · Sep 28, 2018 · N917XA · No damage
  > The government of Hungary has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Hungary's investigation under the…
- [NTSB ANC18WA078](https://openairdocs.org/ntsb/ANC18WA078.md): Cessna 208 · Narita, Japan · Accident · 1 fatal · Foreign investigation · Sep 27, 2018 · VH-FAY · Destroyed
  > On September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…
- [NTSB DCA18WA296](https://openairdocs.org/ntsb/DCA18WA296.md): Airbus A320 · Tijuana, Mexico · Incident · Minor injuries · Foreign investigation · Sep 26, 2018 · XA-VOW
  > The government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB CEN18WA390](https://openairdocs.org/ntsb/CEN18WA390.md): Robinson R44 · Buttonville, Canada · Accident · 1 fatal · Foreign investigation · Sep 25, 2018 · C-GMCT · Substantial damage
  > On September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…
- [NTSB WPR18WA282](https://openairdocs.org/ntsb/WPR18WA282.md): Bell 206 · Yarraden, Australia · Accident · Minor injuries · Foreign investigation · Sep 22, 2018 · VH-HZO · Substantial damage
  > On September 22, 2018, at 2045 coordinated universal time, a Bell 206B helicopter, registration VH-HZO, sustained substantial damage after colliding with the ground following a total loss of power near Yarraden, Australia. The pilot was not injured. The three…
- [NTSB ERA18WA252](https://openairdocs.org/ntsb/ERA18WA252.md): Beech C90 · Ipumirim County, Brazil · Accident · 1 fatal · Foreign investigation · Sep 15, 2018 · PR-RFB. · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on September 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB DCA18WA302](https://openairdocs.org/ntsb/DCA18WA302.md): Boeing 737 · Edinburgh, United Kingdom · Incident · No injuries · Foreign investigation · Sep 10, 2018 · EI-GJT · No damage
  > The Air Accidents Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…
- [NTSB ERA18WA245](https://openairdocs.org/ntsb/ERA18WA245.md): Bell 430 · Bostanci, Türkiye · Accident · 1 fatal · Foreign investigation · Sep 6, 2018 · TC-HYU · Substantial damage
  > The government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…
- [NTSB CEN18WA403](https://openairdocs.org/ntsb/CEN18WA403.md): Robin DR400 · Benodet, France · Accident · No injuries · Foreign investigation · Sep 3, 2018 · F-GSBK · Destroyed
  > On September 3, 2018, about 1005 UTC, a Robin DR400 airplane, French registration F-GSBK, sustained a loss of engine power while in cruise flight near Benodet, France. The three occupants onboard sustained no injury. The airplane was destroyed. The accident…
- [NTSB ERA18WA247](https://openairdocs.org/ntsb/ERA18WA247.md): Beech 33 · Taquaraçu de Minas, Brazil · Accident · 1 fatal · Foreign investigation · Sep 1, 2018 · PT-OCB · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Beech 33 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB DCA18WA313](https://openairdocs.org/ntsb/DCA18WA313.md): Harbin Y12 · Antioq, Colombia · Incident · No injuries · Foreign investigation · Aug 26, 2018 · HK5036 · Minor damage
  > The Civil Aviation Authority (CAA) of Colombia has notified the NTSB of an incident involving a HAIC Harbin Y12E, which occurred on August 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…
- [NTSB CEN18WA353](https://openairdocs.org/ntsb/CEN18WA353.md): Piper PA34 · Loma Linda, Costa Rica · Accident · 1 fatal · Foreign investigation · Aug 22, 2018 · TI-BDH · Substantial damage
- [NTSB DCA18WA279](https://openairdocs.org/ntsb/DCA18WA279.md): Boeing 737 · Guadalajara, Mexico · Incident · No injuries · Foreign investigation · Aug 20, 2018 · N520AM · No damage
  > The government of Mexico has notified the NTSB of an accident involving a Boeing 737 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 provisions of…
- [NTSB DCA18WA271](https://openairdocs.org/ntsb/DCA18WA271.md): Boeing 737 · Narrandera, Australia · Incident · No injuries · Foreign investigation · Aug 15, 2018 · VH-XMO · No damage
  > The ATSB of Australia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO Annex 13 as…
- [NTSB DCA24WA108](https://openairdocs.org/ntsb/DCA24WA108.md): Boeing 737 · Casablanca, Morocco · Incident · Class 5 · Foreign · Aug 6, 2018 · CN-RNJ · No damage
- [NTSB CEN18WA318](https://openairdocs.org/ntsb/CEN18WA318.md): Cessna 172 · Puy-de-Dome Mazoires, France · Accident · 3 fatal · Foreign investigation · Aug 6, 2018 · F-GTNV · Destroyed
  > On August 6, 2018, about 1045 coordinated universal time, a Cessna 172S airplane, French registration F-GTNV, lost radio and radar contact; the wreckage was located near Puy-de-Dôme Mazoires, France. The airplane was destroyed, and the three occupants…
- [NTSB ANC18WA061](https://openairdocs.org/ntsb/ANC18WA061.md): Piper PA-31 · Calgary, Canada · Accident · 2 fatal · Foreign investigation · Aug 1, 2018 · C-FNCI
  > On August 1, 2018, at 1336 mountain daylight time, a Canadian registered Piper PA-31, C-FNCI, operated by Aries Aviation Services Corp., was substantially damaged after impacting terrain under unknown circumstances 35 miles southwest of Calgary, Canada. The…
- [NTSB CEN18WA304](https://openairdocs.org/ntsb/CEN18WA304.md): Quad City Challenger · North Bay, Canada · Accident · 1 fatal · Foreign investigation · Jul 30, 2018 · C-IGKT · Substantial damage
  > On July 30, 2018, about 1500 Coordinated Universal Time, a Quad City Challenger II airplane, Canadian registration C-IGKT, crashed near Talon Lake, North Bay, Ontario, Canada. The pilot was fatally injured. The flight departed North Bay (CYYB), Ontario, and…
- [NTSB ERA18WA218](https://openairdocs.org/ntsb/ERA18WA218.md): Piper PA34 · Irineopolis, Brazil · Accident · 3 fatal · Foreign investigation · Jul 26, 2018 · PR-DMC · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Piper PA-34-220T that occurred on July 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…
- [NTSB DCA18WA243](https://openairdocs.org/ntsb/DCA18WA243.md): Boeing 737 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Jul 13, 2018 · EI-ENM
  > The government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…
- [NTSB ERA18WA216](https://openairdocs.org/ntsb/ERA18WA216.md): Cessna 501 · Catamarca, Argentina · Incident · No injuries · Foreign investigation · Jul 12, 2018 · LV-CGO · Minor damage
  > The government of Argentina has notified the NTSB of an incident involving a CESSNA 501 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…
- [NTSB DCA18WA232](https://openairdocs.org/ntsb/DCA18WA232.md): Boeing 737 · Multan, Pakistan · Incident · Class 5 · Foreign · Jul 12, 2018 · A6-FGB · No damage
- [NTSB DCA18WA247](https://openairdocs.org/ntsb/DCA18WA247.md): Douglas DC9 · Chichen Itza, Mexico · Incident · No injuries · Foreign investigation · Jul 11, 2018 · N802WA · No damage
  > The Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a Douglas DC9 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…
- [NTSB CEN18WA327](https://openairdocs.org/ntsb/CEN18WA327.md): Columbia LC41-550FG · Vallecillos, Mexico · Accident · No injuries · Foreign investigation · Jul 4, 2018 · XB-OHG · Substantial damage
  > On July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2018&state=OF&page=2

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.
