NTSB investigations, 2013, Outside the U.S.

30 cases where the phase of flight was Approach.

Cases per year

19622026
NTSB investigations, 2013, Outside the U.S. per year, 1962–2026: 596 cases
19623
19649
196511
196613
19678
196810
19698
19706
19718
197213
197310
19745
19752
19763
19772
19784
19791
19802
19841
19881
19931
19951
19972
19991
20021
20041
20083
200915
20107
201115
201211
201330
201418
201516
201634
201723
201832
201930
202016
202135
202232
202349
202439
202543
202621

Latest cases

Query with SQL
duckdb -csv -c "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 = 500)
  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 CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…Dec 8, 2013 · F-GEAL · Substantial damageNTSB ERA14WA047Accident · 1 fatalForeign investigationRobinson R66 · Rio de Janeiro, BrazilNov 20, 2013 · PR-MXM · Substantial damageNTSB DCA14RA012Accident · 50 fatalForeign investigationBoeing 737 - 500 · Kazan, RussiaThe Russian Interstate Aviation Committee, Accident Investigation Commission (IAC) has notified the NTSB of an accident involving a Boeing 737-500 that occurred on November 17, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the IAC…Nov 17, 2013 · VQ-BBN · DestroyedNTSB ANC14WA020Incident · No injuriesForeign investigationCessna TU206 - G · Akita City, JapanOn November 16, 2013, at 0246 coordinated universal time, a Japanese registered Cessna 206 airplane, JA4000, operated by Honda Airways, experienced a total loss of engine power near Arayamachi, Akita City, Japan. The pilot made a successful emergency landing,…Nov 16, 2013 · JA4000 · Minor damageNTSB DCA14RA009Accident · 5 fatalForeign investigationSwearingen SA227 - AC · Red Lake, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Swearingen SA227 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions…Nov 10, 2013 · C-FFZN · DestroyedNTSB DCA14WA007Accident · 10 fatalForeign investigationSwearingen SA227 · Riberalta, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a SWEARINGEN SA227 airplane that occurred on November 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the…Nov 3, 2013 · CP-2754 · DestroyedNTSB CEN14WA038Accident · 3 fatalClass 5 · ForeignPiper PA-34 · Coburg, GermanyOn November 11, 2013, at 1020 coordinated universal time, a Piper PA-34, German registration D-GRCP, impacted trees while on approach to land at the Coburg/Brandensteinsebene Airport (EDQC), Coburg, Germany. The pilot and two passengers were fatally injured.…Nov 2, 2013 · D-GRCP · DestroyedNTSB ERA14WA026Accident · 2 fatalForeign investigationLuscombe 8 - E · Buenos Aires, ArgentinaOn October 14, 2013, about 1134 coordinated universal time, a Luscombe 8E, Argentina registration LV-RTS, was substantially damaged, during descent in thick fog, when it impacted terrain in an industrial park. The flight had departed Zarate Airport (SATE),…Oct 14, 2013 · LV-RTS · Substantial damageNTSB CEN14WA115Accident · No injuriesForeign investigationGulfstream 550 · London, United KingdomOn October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…Oct 12, 2013 · HZ-A6 · Substantial damageNTSB ENG13RA041Incident · No injuriesForeign investigationATR 72-500 · Makassar, Indonesia, IndonesiaSep 18, 2013 · PK-WFV · Minor damageNTSB ERA13WA411Accident · 2 fatalForeign investigationDornier 228 · Valparaiso, ChileOn September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…Sep 9, 2013 · CC-CNW · DestroyedNTSB ENG13WA044Incident · No injuriesForeign investigationBombardier CL600 2B19 · Moscow, RussiaOn September 7, 2013 a MNG Jet charter flight, a Bombardier Canadair CL-600-2B19-7763, registration TC-EJA, landed at Vnukovo International Airport, Moscow, Russian Federation, with the nose landing gear extended and both main gear retracted. The…Sep 7, 2013 · TC-EJANTSB ERA13WA401Accident · Serious injuriesForeign investigationPiper PA-32-300 · Macas, EcuadorOn August 30, 2013, about 1630 coordinated universal time (1130 local time), a Piper PA-32-300, Ecuadorian registration HC-BOD, was substantially damaged during a forced landing while approaching Edmundo Carvajal Airport (SEMC), Macas, Ecuador. The Ecuadorian…Aug 30, 2013 · HC-BOD · Substantial damageNTSB CEN14WA225Accident · 4 fatalForeign investigationAirbus Helicopters 332L2 · Shetland Islands, United KingdomOn August 23, 2013, about 1717 UTC, an Airbus Helicopters AS332 L2, G-WNSB (s/n 2582) ditched into the North Sea near the Shetland Islands. The helicopter was destroyed and four passengers were fatally injured. This investigation is under the jurisdiction and…Aug 23, 2013 · G-WNSB · Substantial damageNTSB DCA13WA173Incident · No injuriesForeign investigationBoeing 737 · Las Palmas, SpainThe Spainish Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC). has notified the NTSB of an accident involving a BOEING 737 that occurred on August 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the…Aug 22, 2013 · G-FDZG · No damageNTSB ANC13WA103Accident · Serious injuriesForeign investigationBeech A36 - TC · Ami, JapanOn August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor…Aug 18, 2013 · JA4152 · Substantial damageNTSB CEN13WA480Accident · 3 fatalForeign investigationSocata TBM-700 · Vertaizon, FranceAug 8, 2013 · N850GC · Substantial damageNTSB ERA13WA387Accident · 1 fatalForeign investigationEmbraer 711ST · Paragominas, BrazilOn August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de…Aug 4, 2013 · PT-RHI · Substantial damageNTSB ERA13WA376Accident · 4 fatalForeign investigationBeech 58 · Jundiai Municipality, BrazilOn August 3, 2013, at 1524 Universal Coordinated Time (UTC), a Beech model 58, Brazilian registration PT-LKG, operated by a private owner, was destroyed following a collision with terrain on approach to Jundiai Airport (SBJD), State of Sao Paulo, Brazil. The…Aug 3, 2013 · PT-LKG · DestroyedNTSB DCA13WA129Accident · No injuriesForeign investigationCirrus SR20 · Randburg, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cirrus SR20 airplane that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…Jul 18, 2013 · ZS-CAP · DestroyedNTSB ERA13WA332Accident · 2 fatalForeign investigationCessna 172N · Buenos Aires, ArgentinaOn July 16, 2013, about 2007 coordinated universal time, a Cessna 172N, Argentine registration LV-BPP, was substantially damaged when it impacted terrain while on approach to land at the Quilmes Airport (SADQ), Buenos Aires, Argentina. The flight instructor…Jul 16, 2013 · LV-BPP · Substantial damageNTSB ERA13WA322Accident · Serious injuriesForeign investigationCessna 208B · Mathews Ridge, GuyanaOn July 15, 2013, about 1157 coordinated universal time, a Cessna 208B, Guyana registration 8R-AMS, operated by Air Services Limited, was substantially damaged when it impacted terrain during approach at Matthew's Ridge Airport (SYMR), Matthew's Ridge,…Jul 15, 2013 · 8R-AMS · Substantial damageNTSB CEN13WA477Accident · Minor injuriesForeign investigationBeech 100 · Saint-Mathieu-de-Beloeil, CanadaOn June 10, 2013, at 1726 eastern daylight time, a Beech model 100 (King Air 100), Canadian registration C-GJSU, serial number B-88, experienced a dual loss of engine power and collided with terrain about 1/2 mile west of St-Mathieu-De-Beloeil Airport (CSB3),…Jun 10, 2013 · C-GJSU · Substantial damageNTSB CEN13WA404Accident · Minor injuriesForeign investigationCirrus Design SR22 GTS G3 · Gloucestershire, United KingdomJun 6, 2013 · N936CT · Substantial damageNTSB DCA13WA103Incident · No injuriesForeign investigationBoeing 737-800 · Eindhoven, NetherlandsThe Dutch Safety Board (DSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on May 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DSB investigation under the provisions of ICAO Annex 13 as the…May 31, 2013 · EI-ENL · No damageNTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…Apr 26, 2013 · PR-LJI · Substantial damageNTSB WPR13WA197Accident · No injuriesForeign investigationCirrus SR22 · Zhuhai Sanzao Airport, ChinaOn March 27, 2013 about 1445 Beijing time, a Cirrus SR-22, Chinese registration B-9592, experienced a loss of engine power and subsequently ditched near Zhuhai Sanzao Airport, Guangdong Province, China. The airplane was operated as an instructional flight by…Mar 27, 2013 · B-9592 · Substantial damageNTSB CEN13WA572Accident · 1 fatalForeign investigationPiper PA28 - 161 · Persan, FranceOn March 6, 2013, about 1920 universal coordinated time, a Piper PA28-161 airplane, F-GHPN, impacted terrain during final approach to land on runway 10, at the Persan-Beaumont Airport (LFPA), near Persan, France. The pilot was fatally injured. This…Mar 6, 2013 · F-GHPN · Substantial damageNTSB DCA13WA060Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandOn 26 February 2013, at approximately 2232 UTC time, a Boeing B757-200, during a flight operated by Icelandair between Kastrup, Denmark, and Keflavik, Iceland, the flight crew received an EICAS message indicating a right hydraulic failure when at the top of…Feb 26, 2013 · TF-FIJ · No damageNTSB DCA13WA050Accident · 21 fatalForeign investigationBombardier CL600 2B19 · Almaty, KazakhstanThe Accident Investigation Department of the Ministry of Transport and Communications of the Republic of Kazakhstan has notified the NTSB of an accident involving a Bombardier Challenger CRJ-200, registration UP-CJ006, which occurred on January 29, 2013. The…Jan 29, 2013 · UP-CJ006 · Destroyed