NTSB investigations, 2018, Outside the U.S.

32 cases where the phase of flight was Approach.

Cases per year

19622026
NTSB investigations, 2018, 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\") = 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"

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 DCA19WA044Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe 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…Dec 12, 2018 · XA-ADV · Minor damageNTSB ENG19RA007Incident · No injuriesForeign investigationAirbus A330 · Brussels, BelgiumThe 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…Dec 11, 2018 · OO-SFU · No damageNTSB ENG19WA011Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe 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…Dec 10, 2018 · VT-ITR · No damageNTSB CEN19WA043Accident · 2 fatalForeign investigationCessna 177 · Spain, SpainThe 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…Dec 7, 2018 · D-ECGS · DestroyedNTSB ERA19WA058Accident · 4 fatalForeign investigationCessna 525 · Jequitaí County, BrazilThe 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…Nov 26, 2018 · PP-OEG · DestroyedNTSB ERA19WA054Accident · 5 fatalForeign investigationEurocopter EC120 · La Romana, Dominican RepublicThe 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…Nov 22, 2018 · N124ML · DestroyedNTSB GAA19WA419Accident · 2 fatalForeign investigationSocata TB20 · Dinard Pleurtuit, FranceThe 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…Nov 17, 2018 · F-GKVZ · DestroyedNTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe 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…Nov 8, 2018 · N8383C · Substantial damageNTSB ERA19WA046Accident · Serious injuriesForeign investigationGarlick UH1D · Valparaiso, ChileThe 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…Oct 24, 2018 · CC-CPU · DestroyedNTSB DCA19WA008Incident · No injuriesForeign investigationBoeing 787 · Perth, AustraliaThe 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…Oct 11, 2018 · 9V-OJE · No damageNTSB DCA19WA011Incident · No injuriesForeign investigationBoeing 737 · Brisbane, AustraliaThe 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…Oct 9, 2018 · VH-YFW · No damageNTSB WPR19WA004Accident · 2 fatalForeign investigationCessna 172 · Midrand, South AfricaOn 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…Oct 8, 2018 · ZS-PZT · Substantial damageNTSB ERA19WA038Accident · 2 fatalForeign investigationSiai Marchetti SF260 · Caorle, ItalyThe 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…Oct 3, 2018 · I-ISAE · DestroyedNTSB DCA18RA292Accident · 1 fatalForeign investigationBoeing 737 · Chuuk, MicronesiaThe 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…Sep 28, 2018 · P2-PXE · Substantial damageNTSB DCA18WA288Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe 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…Sep 16, 2018 · TC-ACM · Minor damageNTSB WPR18WA254Accident · Serious injuriesForeign investigationCessna 182M · Leshiba Wilderness, South AfricaOn 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.…Sep 1, 2018 · ZS-IAM · Substantial damageNTSB DCA18WA278Incident · No injuriesForeign investigationAirbus A321-271N · Tapachula, MexicoThe 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…Aug 20, 2018 · N535VL · Minor damageNTSB CEN18WA394Accident · No injuriesForeign investigationPiper PA28 · Décines, FranceOn 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…Aug 2, 2018 · F-GKEC · Substantial damageNTSB ERA18WA209Accident · 1 fatalForeign investigationBeech 90 · Sao Paulo, BrazilThe 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…Jul 29, 2018 · PP-SZN · DestroyedNTSB CEN18WA264Accident · 1 fatalForeign investigationCessna 152 · Ponte de Sor, PortugalThe 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…Jul 10, 2018 · CS-DGU · DestroyedNTSB ENG18WA039Incident · No injuriesForeign investigationMcdonnell Douglas MD80 · Songshan, Taipei, China, TaiwanOn 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…Jul 2, 2018 · B28035 · No damageNTSB WPR18WA187Accident · 1 fatalForeign investigationCessna 172 · Moorabbin, AustraliaJun 8, 2018 · VH-EWE · Substantial damageNTSB CEN18WA169Accident · 2 fatalForeign investigationCessna 208B · Clonbullogue, IrelandMay 13, 2018 · G-KNYS · DestroyedNTSB WPR18WA281Accident · No injuriesForeign investigationZenith CH610 HD · Germiston, South AfricaOn 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…May 12, 2018 · ZU-FFA · Substantial damageNTSB DCA18WA173Incident · No injuriesForeign investigationBoeing 767 323 · Guayaquil, EcuadorThe 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…May 3, 2018 · N396AN · No damageNTSB CEN18WA399Accident · Minor injuriesForeign investigationCessna 172 · Hamilton, BermudaOn 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…Apr 30, 2018 · N9085H · Substantial damageNTSB CEN18WA141Accident · 2 fatalForeign investigationCirrus SR20 · Adolf Wurth Airport, GermanyOn 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,…Apr 15, 2018 · D-EWTG · 2 aircraft · DestroyedNTSB DCA18WA123Accident · No injuriesForeign investigationBoeing 737 · Osaka, JapanThe 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…Apr 9, 2018 · HL7725 · Substantial damageNTSB ENG18WA021Incident · No injuriesForeign investigationBoeing 747 · Chek Lap Kok, Hong Kong SAR ChinaThe 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…Mar 29, 2018 · JA18KZ · No damageNTSB WPR18WA110Accident · 2 fatalForeign investigationEurocopter EC120 · Hardy Reef, Queensland, AustraliaOn 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…Mar 21, 2018 · VH-WII · Substantial damageNTSB ENG18RA018Incident · No injuriesForeign investigationCessna 441 · Broome, Australia, AustraliaThe 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…Mar 2, 2018 · VH-LBY · No damageNTSB DCA18WA088Incident · No injuriesForeign investigationBoeing 757 23A · Tel Aviv, IsraelThe 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…Jan 30, 2018 · N919FD · No damage