# NTSB investigations, 2013, 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 · 57 cases

## Latest cases

- [NTSB CEN14WA208](https://openairdocs.org/ntsb/CEN14WA208.md): Cessna 525A · Honiley, United Kingdom · Accident · No injuries · Foreign investigation · Dec 31, 2013 · N380CR · Substantial damage
- [NTSB WPR14WA085](https://openairdocs.org/ntsb/WPR14WA085.md): Bell 206 · Berastagi, Indonesia · Accident · 1 fatal · Foreign investigation · Dec 30, 2013 · PK-DAL · Destroyed
  > On December 30, 2013, at about 1030 local time, a Bell 206 helicopter, registration PK-DAL, crashed shortly after takeoff from a hospital near Berastagi, North Sumatera, Indonesia. Reports indicate that there was one fatality and two serious injuries…
- [NTSB ERA14WA069](https://openairdocs.org/ntsb/ERA14WA069.md): Britten Norman BN2A - 2 · Novo Prgresso, Brazil · Accident · 5 fatal · Foreign investigation · Dec 4, 2013 · PT-WMY · Substantial damage
  > On December 4, 2013, about 1430 coordinated universal time (UTC), a Britten Norman Aircraft, model BN-2A, Brazilian registration PT-WMY, was substantially damaged when it impacted the ground shortly after takeoff from Novo Progresso Airport (SJNP), Novo…
- [NTSB DCA14RA018](https://openairdocs.org/ntsb/DCA14RA018.md): Embraer ERJ190 - Undesignat · Rundu, Namibia · Accident · 33 fatal · Foreign investigation · Nov 30, 2013 · 9C-EMC · Destroyed
  > The Namibia Ministry of Works and Transport (MWT) has notified the NTSB of an accident involving an Embraer ERJ-190 that occurred on November 30, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the MWT investigation under the…
- [NTSB CEN14WA067](https://openairdocs.org/ntsb/CEN14WA067.md): Robinson R44 - II · Neuhausen ob Eck, Germany · Accident · 2 fatal · Foreign investigation · Nov 19, 2013 · D-HOMI · Substantial damage
  > On November 19, 2013, at 1134 coordinated universal time, a Robinson R44 II, Germany-registered D-HOMI, was substantially damaged when it impacted forested terrain near Neuhausen ob Eck, Germany. Instrument meteorological conditions prevailed at the time of…
- [NTSB CEN14WA062](https://openairdocs.org/ntsb/CEN14WA062.md): Socata TBM 700 · Mouffy, France · Accident · 6 fatal · Foreign investigation · Nov 19, 2013 · N115KC · Destroyed
- [NTSB ANC14WA006](https://openairdocs.org/ntsb/ANC14WA006.md): Sikorsky S76-C++ · Seoul, South Korea · Accident · 2 fatal · Foreign investigation · Nov 16, 2013 · HL9294 · Substantial damage
  > On November 16, 2013, about 2354 Coordinated Universal Time, a Sikorsky S76 C++ helicopter, Korean registration HL9294, operated by LG Electronics Co. Ltd., sustained substantial damage after colliding with a 26-story apartment building in Seoul, Korea. Both…
- [NTSB ERA14WA063](https://openairdocs.org/ntsb/ERA14WA063.md): Piper PA-34-220T · Parati, Brazil, Brazil · Accident · 3 fatal · Foreign investigation · Nov 10, 2013 · PR-EAG · Destroyed
  > On November 10, 2013 about 1600 universal coordinated time, a Piper PA-34-220T, Brazilian registration PR-EAG, was destroyed when it collided during a climb with the peak of Corisco Mountain, located in the Serra do Mar mountain range, near Parati…
- [NTSB DCA14WA070](https://openairdocs.org/ntsb/DCA14WA070.md): Boeing 737 · Seville Airport, Spain · Incident · No injuries · Foreign investigation · Nov 8, 2013 · EI-DPF · No damage
  > The government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 08, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB DCA14WA008](https://openairdocs.org/ntsb/DCA14WA008.md): Robinson R22 - Undesignat · Herolds Bay, South Africa · Accident · No injuries · Foreign investigation · Oct 29, 2013 · ZS-RTV · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on October 29, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB DCA14WA005](https://openairdocs.org/ntsb/DCA14WA005.md): Boeing 757 223 · Providenciales, Turks & Caicos Islands · Incident · No injuries · Foreign investigation · Oct 22, 2013 · N605AA · No damage
  > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757, which occurred on October 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…
- [NTSB DCA14WA084](https://openairdocs.org/ntsb/DCA14WA084.md): Boeing 757-200 · Dublin, Ireland · Incident · Minor injuries · Foreign investigation · Oct 20, 2013 · N41140 · Minor damage
  > The Air Accident Investigation Unit (AAIU) of Ireland, has notified the NTSB of an incident involving a Boeing 757-200 that occurred on October 20, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…
- [NTSB ERA14WA038](https://openairdocs.org/ntsb/ERA14WA038.md): Piper PA-28R-200 · Corumbá, Mato Grosso do Sul, Brazil · Accident · 5 fatal · Foreign investigation · Oct 19, 2013 · PT-NKO · Destroyed
  > On October 19, 2013, about 1105 universal coordinated time, a Piper PA-28R-200, Brazilian registration PT-NKO, was destroyed when it impacted terrain under unknown circumstances, near Corumba Municipality, Brazil. The foreign certificated pilot and four…
- [NTSB CEN14WA029](https://openairdocs.org/ntsb/CEN14WA029.md): Cessna 208B · Loreto, BCS, Mexico · Accident · 14 fatal · Foreign investigation · Oct 14, 2013 · XA-TXM · Destroyed
  > On October 14, 2013, about 1401 universal time coordinated, a Cessna 208B, XA-TXM, was destroyed when it impacted terrain near Loreto, Baja California Sur, Mexico. The pilot and thirteen passengers on board were fatally injured. The flight originated from the…
- [NTSB ERA14WA020](https://openairdocs.org/ntsb/ERA14WA020.md): Bell 407 - NO Series · Gobierno, Argentina · Accident · 1 fatal · Foreign investigation · Oct 13, 2013 · LQ-BHT · Substantial damage
  > On October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…
- [NTSB CEN14WA013](https://openairdocs.org/ntsb/CEN14WA013.md): Enstrom 280 - FX · Wolica Kozia, Poland · Accident · 2 fatal · Foreign investigation · Oct 12, 2013 · SP-GMB · Substantial damage
  > On October 12, 2013, about 0928 hours universal coordinated time, an Enstrom 280FX, Poland registration SP-GMB, impacted trees and terrain near Wolica Kozia, Poland. The pilot and passenger were fatally injured. The accident investigation is under the…
- [NTSB ENG14WA002](https://openairdocs.org/ntsb/ENG14WA002.md): Airbus A330 - 302 · Caines, Australia, Australia · Incident · No injuries · Foreign investigation · Oct 10, 2013 · B-18358 · Minor damage
  > On October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…
- [NTSB CEN14WA536](https://openairdocs.org/ntsb/CEN14WA536.md): Sikorsky S92 · Stavanger, Norway · Accident · No injuries · Foreign investigation · Oct 4, 2013 · LN-ONW · No damage
  > On October 4, 2013, at 1435 coordinated universal time (UTC), a Sikorsky S-92A helicopter, Norwegian registration LN-ONW, made an emergency landing on the unmanned and decommissioned Yme oil rig. The two crew members and 12 passengers were uninjured. The…
- [NTSB WPR13WA433](https://openairdocs.org/ntsb/WPR13WA433.md): Bell 212 - NO Series · Murbad, Thane District, India, India · Accident · 5 fatal · Foreign investigation · Sep 29, 2013 · VT-HGB · Destroyed
  > On September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…
- [NTSB ENG13WA043](https://openairdocs.org/ntsb/ENG13WA043.md): Boeing 737 - 53C · Cusco, Peru · Incident · No injuries · Class 5 · Foreign · Sep 27, 2013 · OB-2041-P · No damage
  > On September 26, 2013, about 2042 EST, a BOEING 737 - 53C airplane, OB-2041-P, experienced an in-flight engine shutdown near Cusco, Peru. The pilot was not injured. The airplane was not damaged. The investigation is under the jurisdiction of the government of…
- [NTSB WPR13WA423](https://openairdocs.org/ntsb/WPR13WA423.md): Cessna 182 - R · Hamilton Aerodrome, Australia, Australia · Accident · 1 fatal · Foreign investigation · Sep 23, 2013 · VH-AUT · Substantial damage
  > On September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…
- [NTSB DCA13WA158](https://openairdocs.org/ntsb/DCA13WA158.md): Boeing 757 223 · San Andreas, Colombia · Incident · No injuries · Foreign investigation · Sep 19, 2013 · N676AN · No damage
  > The CAA of Colombia has notified the NTSB of an incident involving a Boeing 757-223 airplane that occurred on September 19, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of Colombia's investigation under the provisions of…
- [NTSB DCA13WA159](https://openairdocs.org/ntsb/DCA13WA159.md): Boeing 787 - 8QQ · Warsaw, Poland · Incident · No injuries · Foreign investigation · Sep 18, 2013 · SP-LRB · No damage
  > On September 18, 2013, a LOT Polish Airlines, Boeing 787-8, registration number SP-LRB, powered by two Rolls-Royce Trent 100-67B turbofan engines experienced a maintenance status message “ENG FUEL FULTER R” during cruise from Beijing Capital International…
- [NTSB WPR13WA410](https://openairdocs.org/ntsb/WPR13WA410.md): Cessna U206 - G · Croydon, Australia · Accident · 2 fatal · Foreign investigation · Sep 15, 2013 · VH-WAV · Destroyed
  > On September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…
- [NTSB DCA13WA168](https://openairdocs.org/ntsb/DCA13WA168.md): Cessna 206 - H · Kodoeskop, South Africa · Accident · Minor injuries · Foreign investigation · Sep 7, 2013 · ZS-PXV · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna T206H airplane that occurred on September 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB CEN13WA527](https://openairdocs.org/ntsb/CEN13WA527.md): Cessna T303 · Jersey · Accident · 2 fatal · Foreign investigation · Sep 4, 2013 · N289CW · Substantial damage
- [NTSB DCA13WA176](https://openairdocs.org/ntsb/DCA13WA176.md): Airbus A330 - 203 · Fortaleza, Brazil · Accident · Serious injuries · Foreign investigation · Sep 1, 2013 · PT-MVL · No damage
  > The Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA) has notified the NTSB of an accident involving an Airbus A330-203, registration PT-MVL, which occurred on September 1, 2013. The NTSB has appointed a U.S. Accredited…
- [NTSB ERA13WA439](https://openairdocs.org/ntsb/ERA13WA439.md): Bell 206B · Matoes do Norte, Brazil · Accident · No injuries · Foreign investigation · Aug 30, 2013 · PT-HUE · Substantial damage
  > On August 30, 2013, at 1555 coordinated universal time (1255 local time), a Bell 206B, Brazilian registration PT-HUE, was substantially damaged following a loss of engine power and a subsequent forced landing in Matões do Norte, Maranhão, Brazil. The pilot…
- [NTSB ENG13WA042](https://openairdocs.org/ntsb/ENG13WA042.md): Boeing 737 · Auckland, New Zealand · Incident · No injuries · Foreign investigation · Aug 30, 2013 · ZK-NGI · No damage
  > The investigation is under the jurisdiction of the government of New Zealand. Further information pertaining to this accident may be obtained from:Transport Accident Investigation Commission PO Box 10323, The Terrace Wellington 6143, New Zealand. Website:…
- [NTSB ERA13WA367](https://openairdocs.org/ntsb/ERA13WA367.md): Cessna 172 · Bolzano, Italy · Accident · 4 fatal · Foreign investigation · Aug 17, 2013 · D-EDQL · Destroyed
  > On August 17, 2013, at 1400 Universal Coordinated Time (UTC), a Cessna FR172J, German registration D-EDQL, operated by a flying club, was destroyed following a collision with mountainous terrain near San Pellegrino, Italy. The local flight originated in…
- [NTSB DCA13WA157](https://openairdocs.org/ntsb/DCA13WA157.md): Boeing 777 · Melbourne, Australia · Incident · No injuries · Foreign investigation · Aug 15, 2013 · VH-VPF · No damage
  > The Australian Transportation Safety Board (ATSB) has notified the NTSB of an incident involving a Boeing 777 that occurred on August 15, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…
- [NTSB CEN13WA576](https://openairdocs.org/ntsb/CEN13WA576.md): Socata TB10 - NO Series · Zamora, Spain · Accident · No injuries · Foreign investigation · Aug 9, 2013 · EC-FPN · Substantial damage
  > On August 9, 2013, about 0930 UTC, a Socata TB-10 airplane, EC-FPN, (s/n 1485) was involved in a forced landing following an engine failure. The airplane was substantially damaged and there were no injuries. This investigation is under the jurisdiction and…
- [NTSB ERA13WA359](https://openairdocs.org/ntsb/ERA13WA359.md): Robinson R-44 · Davidovo, Russia · Accident · 2 fatal · Foreign investigation · Aug 6, 2013 · RA-06302 · Destroyed
  > On August 6, 2013, at 1506 coordinated universal time (August 7, 2013, 0006 local time), an emergency locator beacon signal was detected for a Robinson R44, RA-06302, which was subsequently found destroyed on rising terrain about 7 nautical miles southwest of…
- [NTSB DCA13WA169](https://openairdocs.org/ntsb/DCA13WA169.md): Boeing 737 - 377 · Leeds, United Kingdom · Incident · No injuries · Foreign investigation · Aug 2, 2013 · G-CELF · No damage
  > The United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on August 02, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…
- [NTSB DCA13WA134](https://openairdocs.org/ntsb/DCA13WA134.md): Boeing 737 · Batopilas, Mexico · Accident · Serious injuries · Class 5 · Foreign · Jul 31, 2013 · N173AT · No damage
- [NTSB CEN13WA577](https://openairdocs.org/ntsb/CEN13WA577.md): Cessna Cessna 525B · Paris, France · Incident · No injuries · Foreign investigation · Jul 22, 2013 · F-HCIC · Minor damage
  > On July 22, 2013, at 0610 UTC, a Cessna 525B Citation CJ3, French registration F-HCIC, experienced smoke in the cabin and cockpit while passing FL 140 during an enroute climb southeast of Paris, France. The number one engine was shut down, the crew declared…
- [NTSB ENG13WA039](https://openairdocs.org/ntsb/ENG13WA039.md): Boeing 777 - 340ER · Moscow, Russia · Incident · No injuries · Foreign investigation · Jul 21, 2013 · AP-BHV · No damage
  > The Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Boeing 777-340ER, registration number AP-BHV, powered by General Electric CF90-115BL…
- [NTSB ERA13WA356](https://openairdocs.org/ntsb/ERA13WA356.md): Beech G36 · Bonito, Brazil · Accident · 2 fatal · Foreign investigation · Jul 19, 2013 · PR- KEX · Destroyed
  > On July 19, 2013, about 1330 universal coordinated time (UTC), a Hawker Beechcraft G16, Brazilian registration PR-KEX, registered to a private owner and operated by a private individual, impacted terrain during flight in the vicinity of the Bonito…
- [NTSB DCA14WA108](https://openairdocs.org/ntsb/DCA14WA108.md): Boeing 737-800 · Perugia, Italy · Accident · Serious injuries · Foreign investigation · Jul 18, 2013 · EI-DWF · No damage
  > The Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an accident involving a Boeing 737-800 that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…
- [NTSB ERA13WA319](https://openairdocs.org/ntsb/ERA13WA319.md): Diamond DA40-180 · Ticlio, Peru · Accident · 2 fatal · Foreign investigation · Jul 11, 2013 · N293DS · Destroyed
- [NTSB ENG13IA033](https://openairdocs.org/ntsb/ENG13IA033.md): Boeing 777 · Ugolny Airport, Russia · Incident · No injuries · Incident investigation · Final report · Jul 2, 2013 · HL8275 · No damage
  > The failure of the transfer gearbox resulting from the fracture and separation of the radial gearshaft from fatigue cracking as a result of a combination of high residual tensile stresses produced by local decarburization during the manufacturing process…
- [NTSB ANC13RA061](https://openairdocs.org/ntsb/ANC13RA061.md): De Havilland DHC-2 MK 1 · Half Moon Bay, Canada · Accident · No injuries · Foreign investigation · Jun 24, 2013 · C-FPCG · Substantial damage
  > On June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…
- [NTSB ERA13WA293](https://openairdocs.org/ntsb/ERA13WA293.md): Piper PA-28-161 · Barcis, Italy · Accident · 2 fatal · Foreign investigation · Jun 18, 2013 · F-GHLY · Substantial damage
  > On June 18, 2013 at 1655 Universal Coordinated Time (UTC), a Piper PA-28, French registration F-GHLY, privately operated, was substantially damaged when it impacted with the slope of a mountain near Barcis, Italy during a cross-country flight from Locarno…
- [NTSB ERA13WA290](https://openairdocs.org/ntsb/ERA13WA290.md): Beech 58 · Albenga, Italy · Accident · 1 fatal · Foreign investigation · Jun 16, 2013 · G-CIZZ · Destroyed
- [NTSB ERA13WA289](https://openairdocs.org/ntsb/ERA13WA289.md): Bell 212 · Tefe, Brazil · Accident · 2 fatal · Foreign investigation · Jun 14, 2013 · PR-HRZ · Destroyed
  > On June 14, 2013, about 0810 universal coordinated time, a Bell 212 helicopter, Brazilian registration PR-HRZ, operated by an oil and gas exploration and production company, was destroyed when it impacted terrain shortly after takeoff from a support base…
- [NTSB CEN13WA405](https://openairdocs.org/ntsb/CEN13WA405.md): Piper PA-32R-301T · Lagunillas, Mexico · Accident · 1 fatal · Foreign investigation · May 30, 2013 · N371HP · Substantial damage
- [NTSB CEN13WA307](https://openairdocs.org/ntsb/CEN13WA307.md): Piper PA-28RT-201T · Tallard, France · Accident · 1 fatal · Foreign investigation · May 29, 2013 · N68XM · Destroyed
- [NTSB DCA13WA089](https://openairdocs.org/ntsb/DCA13WA089.md): Beech 1900 · Unkown, São Tomé & Príncipe · Accident · 1 fatal · Foreign investigation · Apr 7, 2013 · ZS-PHL · Destroyed
  > The Sao Tome and Principe Civil Aviation Authority (STPCAA) has notified the NTSB of an accident involving a Beech 1900 that occurred on April 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist STPCAA investigation under the…
- [NTSB DCA13WA087](https://openairdocs.org/ntsb/DCA13WA087.md): Boeing Boeing 757-300 · Gran Canaria, Spain · Incident · No injuries · Foreign investigation · Mar 27, 2013 · D-ABOC · No damage
- [NTSB ERA13WA162](https://openairdocs.org/ntsb/ERA13WA162.md): Beech 35 · Los Amores, Santa Fe, Argentina · Accident · 3 fatal · Foreign investigation · Mar 9, 2013 · ZP-BAM · Destroyed
  > On March 9, 2013, about 2030 coordinated universal time (UTC), a Beech 35, Paraguayan registration ZP-BAM, was destroyed when it impacted terrain in Los Amores, Santa Fe Province, Argentina. The pilot and two passengers were fatally injured. The flight…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2013&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") = 2013
  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=2013

---
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.
