NTSB investigations, 2020, Outside the U.S.

71 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2020, Outside the U.S. per year, 1962–2026: 1,774 cases
19623
19632
196423
196521
196618
196726
19689
196922
197015
197111
197219
197316
197414
197519
19763
19778
19788
19794
19812
19823
19843
19861
19871
19886
19891
19901
19912
19941
19972
19981
20001
20022
20032
20041
20071
200810
200930
201031
201139
201253
201357
201451
201571
201689
201777
2018100
2019124
202071
2021119
2022106
2023112
2024152
2025138
202672

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 = 400)
  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 GAA21WA006Accident · 4 fatalClass 4 · ForeignCessna 177 · Rancador, PR, BrazilDec 29, 2020 · PT-KCK · DestroyedNTSB ENG21WA010IncidentClass 5 · ForeignAirbus A330 · Keflavik, IcelandDec 28, 2020 · N810NW · No damageNTSB ENG21WA009IncidentClass 5 · ForeignBoeing 737 · Johannesburg, South AfricaDec 25, 2020 · ZS-SJR · No damageNTSB ENG21WA008Incident · No injuriesClass 5 · ForeignBoeing 737 · Katowice, PolandDec 5, 2020 · LZ-CGU · Minor damageNTSB ENG21WA007IncidentClass 4 · ForeignBoeing 777 · Naha, JapanDec 4, 2020 · JA8978 · Minor damageNTSB DCA21WA041IncidentClass 5 · ForeignBoeing 757 · Silao, MexicoDec 1, 2020 · N6706Q · No damageNTSB WPR21WA063Accident · 2 fatalClass 5 · ForeignGrob 120A-1 · Beer-Sheba, IsraelNov 24, 2020 · 4X-DGA · DestroyedNTSB DCA21WA033IncidentClass 5 · ForeignBoeing 737 · Capetown, South AfricaNov 22, 2020 · ZS-OAF · No damageNTSB CEN21WA056Accident · 2 fatalClass 5 · ForeignQuest Kodiak 100 · Guatemala City, GuatemalaNov 8, 2020 · TG-SMT · DestroyedNTSB CEN21WA061Accident · 3 fatalClass 5 · ForeignCessna 182 · Durango, MexicoNov 7, 2020 · XB-QOX · Substantial damageNTSB DCA21WA028IncidentClass 5 · ForeignBoeing 737 · Lusaka, RwandaOct 30, 2020 · 9XR-WJ · No damageNTSB GAA21WA128Incident · No injuriesClass 5 · ForeignCessna 525 · Port Moresby, Papua New GuineaOct 29, 2020 · P2-MEH · Minor damageNTSB WPR21WA089Accident · 1 fatalClass 5 · ForeignCessna 182 · Cheworez, ZimbabweOct 23, 2020 · Z-YXY · Substantial damageNTSB ENG21WA050Incident · No injuriesClass 5 · ForeignSikorsky S92 · Sola, NorwayOct 20, 2020 · LN-OMI · No damageNTSB GAA21WA115Accident · No injuriesClass 5 · ForeignRobinson R44 · Melili, KenyaOct 17, 2020 · 5Y-MEP · Substantial damageNTSB GAA21WA002Accident · 2 fatalClass 5 · ForeignRobinson R44 · Passa Tres, Rio Claro, BrazilOct 15, 2020 · PR-ESK · Substantial damageNTSB GAA21WA001Accident · 3 fatalClass 3 · ForeignPiper PA28RT · Ubate-Cundinamarca, ColombiaOct 13, 2020 · HK2335G · Substantial damageNTSB GAA21WA003Accident · 1 fatalClass 5 · ForeignPiper PA25 · Juan Jose Rios, MexicoOct 9, 2020 · XB-OKQ · Substantial damageNTSB CEN21WA011Accident · No injuriesClass 5 · ForeignCirrus SR22 · Langdorp, BelgiumOct 8, 2020 · D-EPBS · Substantial damageNTSB DCA21WA001Incident · No injuriesClass 5 · ForeignBoeing 787 · London, United KingdomOct 2, 2020 · G-ZBKFNTSB ENG21WA002IncidentClass 5 · ForeignAirbus A330 · Nawabshah, PakistanOct 1, 2020 · AP-BNE · No damageNTSB CEN20WA418Incident · No injuriesClass 4 · ForeignSikorsky S92 · Sola, NorwaySep 25, 2020 · LN-ONQ · No damageNTSB DCA21WA017IncidentClass 5 · ForeignBombardier CL600 2C10 · Chihuahua City, MexicoSep 19, 2020 · N770SK · No damageNTSB GAA20WA137Accident · 2 fatalForeign investigationRans S6 · Lasne, BelgiumThe government of Belgium has notified the NTSB of an accident involving a RANS S6 airplane that occurred on September 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…Sep 13, 2020 · 62-ALK · DestroyedNTSB DCA27WA007Incident · No injuriesClass 5 · ForeignFairchild SA227-AC · Gyor, HungarySep 13, 2020 · EC-NIPNTSB GAA20WA147Incident · No injuriesClass 5 · ForeignBellanca 8KCAB · Roskilde, DenmarkSep 10, 2020 · OY-LUN · No damageNTSB DCA20WA141Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…Aug 24, 2020 · N806NN · No damageNTSB CEN20WA434IncidentClass 5 · ForeignRaytheon Hawker · Le Bourget, FranceAug 21, 2020 · F-HREX · No damageNTSB WPR21WA103AccidentClass 5 · ForeignCessna 150 · Kenitra, MoroccoAug 20, 2020 · CN-TCG · Substantial damageNTSB GAA20WA129Accident · No injuriesForeign investigationHawker SEA Fury · Button End, Harston, Cambridgeshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a HAWKER SEA FURY airplane that occurred on August 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…Aug 8, 2020 · G-INVN · Substantial damageNTSB CEN20WA376Accident · 1 fatalForeign investigationCanadair CL215 1A10 · Lobios (Ourense), PortugalThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Canadair CL-215-1A10 airplane, which occurred on August 8, 2020. The NTSB has appointed a U.S Accredited…Aug 8, 2020 · EC-HET · Substantial damageNTSB GAA20WA128Accident · 1 fatalForeign investigationRans S6 · Heathfield East Sussex, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a RANS S6 airplane that occurred on August 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…Aug 4, 2020 · G-BUWK · DestroyedNTSB GAA20WA125Accident · 1 fatalForeign investigationCessna R172 · Tarapaca-Amazonas, ColombiaJul 30, 2020 · HK2129 · DestroyedNTSB ANC20WA073Accident · 1 fatalForeign investigationCessna 140 · Abbotsford, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 140 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…Jul 28, 2020 · C-GOFKNTSB GAA20WA126Accident · 4 fatalForeign investigationCessna 172 · Blatten - VS, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Jul 25, 2020 · HB-TLF · DestroyedNTSB WPR20WA241Incident · No injuriesForeign investigationCessna 441 · Djugun, AustraliaThe government of Australia has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on July 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…Jul 22, 2020 · VH-LBY · Minor damageNTSB GAA20WA118Accident · 1 fatalForeign investigationRobinson R44 · Thorburn Lake, CanadaThe government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…Jul 20, 2020 · C-FPBL · Substantial damageNTSB ENG20WA039Incident · No injuriesForeign investigationHawker Siddeley HS125 · Port Harcourt, NigeriaOn July 16, 2020 a Hawker-Siddeley (Textron Aviation), powered by two Honeywell TFE731 5R-1H turbofan engines experienced a No. 1 (left engine) audible fire warning during cruise. The flight crew declared an emergency and made an uneventful landing at Port…Jul 16, 2020 · 5N-BOONTSB DCA20WA131Accident · Serious injuriesForeign investigationBoeing 737 · Durban, South AfricaThe CAA of South Africa has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 14, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of ICAO…Jul 14, 2020 · ZS-SJB · No damageNTSB DCA20WA132Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC of Mexico's investigation under the provisions of ICAO Annex…Jul 11, 2020 · XA-MCG · No damageNTSB CEN20WA293Accident · Serious injuriesForeign investigationCessna FR172 · Galway, IrelandThe government of the Ireland has notified the NTSB of an accident involving a Cessna FR172K airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…Jul 11, 2020 · EI-EZU · DestroyedNTSB GAA20WA121Accident · 1 fatalForeign investigationBeech 58 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…Jul 8, 2020 · PR-OFI · Substantial damageNTSB GAA20WA122Accident · Minor injuriesClass 4 · ForeignRobinson R22 · Rio De Janeiro, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on July 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Jul 6, 2020 · PR-OEA · Substantial damageNTSB CEN20WA437Accident · No injuriesClass 4 · ForeignPiper PA28 · Pointe-à-Pitre, GuadeloupeJul 4, 2020 · N5352F · DestroyedNTSB GAA20WA113Accident · 2 fatalForeign investigationRobinson R22 · Strzegom city, PolandThe government of Poland has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Poland's investigation under the provisions…Jun 30, 2020 · SP-HBOG · DestroyedNTSB CEN20WA246Accident · No injuriesForeign investigationBell 407 · Long Marston, United KingdomThe government of the United Kingdom has notified the NTSB of an accident involving a Bell 407 helicopter that occurred on June 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation…Jun 24, 2020 · N120HH · DestroyedNTSB GAA20WA114Accident · 5 fatalForeign investigationCessna TU206 · Balleza, Chihuahua, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA TU206 airplane that occurred on June 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Jun 23, 2020 · XB-PWE · DestroyedNTSB GAA20WA112Accident · 1 fatalForeign investigationPiper PA25 · Vereda Brisas de Guaiquitia, ColombiaJun 22, 2020 · HK-1042 · DestroyedNTSB GAA20WA116Accident · No injuriesForeign investigationCessna FA150 · Doub, FranceThe government of France has notified the NTSB of an accident involving a CESSNA FA150 airplane that occurred on June 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…Jun 20, 2020 · F-BXNO · Substantial damageNTSB CEN20WA237Accident · 1 fatalForeign investigationPiper PA34 · Reinsfeld, GermanyThe government of Germany has notified the NTSB of an accident involving a Piper PA-34 220T airplane, German registration D-GEMZ, that occurred on June 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's…Jun 17, 2020 · D-GEMZ · Destroyed