NTSB investigations, 2020, Outside the U.S.

22 cases where the phase of flight was Initial climb.

Cases per year

19642026
NTSB investigations, 2020, Outside the U.S. per year, 1964–2026: 565 cases
196417
196511
196611
196716
19686
19695
197011
19716
19728
19736
19748
19755
19761
19772
19782
19791
19851
19871
19901
19921
19971
20041
20061
200810
20095
201012
20118
201213
201313
201413
201522
201626
201724
201821
201939
202022
202140
202242
202339
202433
202541
202619

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\") = 2020
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
  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 CEN21WA094AccidentClass 5 · ForeignAficionado MINI-MAX Eros · Urbanización Bassetes, SpainDec 13, 2020 · EC-ZQJ · DestroyedNTSB GAA21WA005Accident · 1 fatalClass 5 · ForeignBeech 95B55 · Sao Pedro, SP, BrazilNov 14, 2020 · PT-OOQ · Substantial damageNTSB DCA21WA006IncidentClass 5 · ForeignBoeing 777 · Guiuan, Eastern Samar, PhilippinesOct 10, 2020 · D-ALFG · No damageNTSB CEN21WA115Accident · Serious injuriesClass 5 · ForeignCessna 185A · Romsey, United KingdomOct 7, 2020 · G-BLOS · DestroyedNTSB DCA21WA004Incident · No injuriesClass 4 · ForeignBoeing 787-800 · Amsterdam, NetherlandsOct 3, 2020 · OO-JAVNTSB GAA20WA133Accident · 4 fatalForeign investigationCommander 114 · Fur airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a COMMANDER 114 airplane that occurred on August 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…Aug 30, 2020 · D-EQCA · DestroyedNTSB DCA20WA142Accident · No injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13.All…Aug 29, 2020 · JA73NM · Substantial damageNTSB GAA20WA134Accident · 1 fatalForeign investigationBeech 35 · Teresina, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 35 airplane that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Aug 28, 2020 · PT-AFN · DestroyedNTSB GAA20WA132Accident · 2 fatalClass 5 · ForeignAviamilano Falco F8L · Sibari, ItalyAug 26, 2020 · I-CAVL · DestroyedNTSB ANC20WA079Accident · No injuriesForeign investigationCessna 172 · Valdau, RussiaThe government of Russia has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on August 02, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…Aug 2, 2020 · RA-67551NTSB ENG20WA040Incident · No injuriesForeign investigationEmbraer ERJ190 · Chihuahua, MexicoJul 23, 2020 · XA-GAI · No damageNTSB ENG20WA042Incident · No injuriesForeign investigationATR ATR72 · Ambon, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving an ATR 72-600, which occurred on July 3, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…Jul 3, 2020 · PK-WHY · No damageNTSB GAA20WA127Accident · No injuriesClass 5 · ForeignCessna 150 · Cancun, MexicoJun 26, 2020 · XB-PPF · Substantial damageNTSB ERA20WA172Accident · 1 fatalForeign investigationComp Air CA-8 · Campo Verde, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built COMP AIR CA-8 airplane that occurred on April 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…Apr 13, 2020 · PP-XLD · DestroyedNTSB ERA20WA133Accident · No injuriesForeign investigationPiper PA23 · Eleuthera, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on March 21, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions of…Mar 21, 2020 · N14178NTSB DCA20WA096Incident · No injuriesForeign investigationEmbraer ERJ170-200LR · Apodaca, MexicoMar 5, 2020 · N250NN · No damageNTSB DCA20WA089Incident · No injuriesForeign investigationBoeing 737 · Brazzaville, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…Mar 1, 2020 · CN-RNKNTSB ENG20WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomOn February 26, 2020, an Airbus A321-211, powered by two CFM International CFM56-5B3/3 turbofan engines experienced a left (No. 1) engine surge on departure from London Gatwick Airport (LGW) and an ECAM alert for the right engine (No. 2) stall condition. The…Feb 26, 2020 · G-POWN · No damageNTSB GAA20WA111Accident · 4 fatalForeign investigationPiper PA31 · Guaymaral, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on February 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…Feb 12, 2020 · HK4686 · DestroyedNTSB ENG20RA030Incident · No injuriesClass 5 · ForeignAirbus A320 · Budapest, HungaryimportFeb 3, 2020 · VP-BMF · No damageNTSB ENG20WA017Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoOn January 24, 2020, an Airbus A320-271N neo, powered by two Pratt & Whitney PW1127G-JM geared turbofan engines, experienced a right (No. 2) engine failure while climbing through 11,500 feet after takeoff from the Mexico City Intentional Airport (MMMX). The…Jan 24, 2020 · N528VL · No damageNTSB DCA20RA048Accident · 176 fatalForeign investigationBoeing 737 · Tehran, IranThe government of Iran has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on January 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iran's investigation under the provisions of…Jan 8, 2020 · UR-PSR · Destroyed