NTSB investigations, 2023, Outside the U.S.

112 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2023, 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\") = 2023
    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 GAA24WA077Accident · No injuriesClass 5 · ForeignVans RV6 · Smaalandsfarvandet, DenmarkDec 27, 2023 · OY-RVA · Substantial damageNTSB GAA24WA059Accident · No injuriesClass 5 · ForeignPiper PA28 · Carmo da Cachoeira, BrazilDec 26, 2023 · PT-DYV · Substantial damageNTSB ENG24WA007Incident · Minor injuriesClass 5 · ForeignGrumman G21 · Bella Bella, CanadaDec 18, 2023 · C-GDDJ · Substantial damageNTSB GAA24WA056Accident · No injuriesClass 5 · ForeignCessna F150 · Budapest, HungaryDec 15, 2023 · HA-BHI · Substantial damageNTSB DCA24WA149Accident · 1 fatalClass 5 · ForeignRobinson R22 · Tindal, AustraliaDec 7, 2023 · VH-DLD · Substantial damageNTSB GAA24WA050Accident · Serious injuriesClass 5 · ForeignPiper PA30 · Villejuif, FranceDec 4, 2023 · F-BPIR · DestroyedNTSB GAA24WA041Accident · No injuriesClass 4 · ForeignPiper 32 · Mhlambanyatsi, WZNov 23, 2023 · ZS-EIX · Substantial damageNTSB DCA24WA027Incident · No injuriesClass 5 · ForeignBoeing 737 · Surat Thani, ThailandNov 17, 2023 · HS-DBT · Minor damageNTSB GAA24WA035AccidentClass 5 · ForeignCessna 152 · Licab Zaragosa, PhilippinesNov 13, 2023 · RP-C8840 · Substantial damageNTSB ENG24LA009IncidentClass 3 · LimitedPreliminary reportAirbus A319 · Schiphol, NetherlandsOn November 10, 2023 at 0713 UTC, a Lufthansa Airbus A319, registration D-AIBG, experienced the loss of both electrical generators during approach to Amsterdam Airport Schiphol, Netherlands. The airplane’s ram air turbine deployed automatically. The airplane…Nov 10, 2023 · D-AIBG · No damageNTSB ENG24WA004IncidentClass 5 · ForeignBoeing 787 · Addis Ababa, EthiopiaNov 7, 2023 · ET-AXK · Minor damageNTSB GAA24WA028Accident · 3 fatalClass 5 · ForeignGulfstream 695A · Cloncurry, AustraliaNov 4, 2023 · VH-HPY · DestroyedNTSB GAA24WA125Accident · No injuriesClass 5 · Foreignreims F406 · Farm Erindi, NamibiaOct 24, 2023 · V5-WAI · Substantial damageNTSB ENG24WA005Accident · No injuriesClass 5 · ForeignSikorsky S76 · Sidney, CanadaOct 24, 2023 · C-GXHJ · Substantial damageNTSB DCA24WA013IncidentClass 5 · ForeignBoeing 737 · Stocksbridge, United KingdomOct 17, 2023 · G-TAWDNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyOct 10, 2023 · T7-HZM · DestroyedNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainOct 10, 2023 · CO493 · Substantial damageNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaOct 6, 2023 · C-GTYH · DestroyedNTSB DCA24WA012Accident · No injuriesClass 5 · ForeignAirbus A321 · Essex, United KingdomOct 5, 2023 · G-OATW · Substantial damageNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, GermanySep 30, 2023 · D-EDDHNTSB DCA23WA463Incident · No injuriesClass 5 · ForeignBoeing 737 · Guayaquil, EcuadorSep 24, 2023 · HC-CUH · No damageNTSB GAA23WA278Accident · No injuriesClass 3 · ForeignDe Havilland DHC2 · Campbel River, CanadaSep 20, 2023 · C-GSBA · Substantial damageNTSB ENG23WA041IncidentClass 3 · ForeignAirbus A320 · Almaty, KazakhstanSep 17, 2023 · EI-KBK · Minor damageNTSB ENG23WA042Incident · No injuriesClass 5 · ForeignAirbus A320 · Enroute Bogota - Barranquilla, ColombiaSep 13, 2023 · N740AV · No damageNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaSep 10, 2023 · RA-05823 · Substantial damageNTSB ENG23WA037IncidentClass 5 · ForeignAirbus A321 · Changi, Singapore, SingaporeSep 10, 2023 · B305J · Minor damageNTSB DCA23WA455IncidentClass 5 · ForeignBoeing 737 · Ballina, AustraliaSep 6, 2023 · VH-YQR · No damageNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayAug 29, 2023 · N · DestroyedNTSB DCA23WA429IncidentClass 4 · ForeignBoeing 737 · Palma de Mallorca, SpainAug 27, 2023 · G-DRTW · No damageNTSB DCA23WA423Incident · No injuriesClass 5 · ForeignDouglas DC9 · Maturin, VenezuelaAug 24, 2023 · YV648T · No damageNTSB GAA23WA243Accident · 2 fatalClass 5 · ForeignGulfstream 690C · Las Velas, VenezuelaAug 23, 2023 · YV2915 · DestroyedNTSB GAA23WA245Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · Enstone-, United KingdomAug 22, 2023 · G-CLHJ · DestroyedNTSB ENG23WA035OccurrenceClass 5 · ForeignAirbus A321 · Jeddah, Saudi ArabiaAug 22, 2023 · VT-IUD · No damageNTSB DCA23WA438IncidentClass 5 · ForeignEmbraer 190 · Armidale, AustraliaAug 20, 2023 · VH-UZI · No damageNTSB GAA23WA239AccidentClass 3 · ForeignCessna 402 · BahamasAug 19, 2023 · C6-SPK · DestroyedNTSB DCA23WA456IncidentClass 5 · ForeignBoeing 787 · Santiago, ChileAug 15, 2023 · CC-BGI · No damageNTSB DCA23WA414Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaAug 7, 2023 · YV3158 · No damageNTSB GAA23WA231Accident · 2 fatalClass 5 · ForeignHawker Beechcraft G58 · Vilhena, BrazilJul 29, 2023 · PR-ITE · Substantial damageNTSB ENG23WA043Incident · No injuriesClass 5 · ForeignATR ATR72 · Brazzavillec, Congo - KinshasaJul 29, 2023 · TN-AKA · No damageNTSB DCA23WA385Incident · Minor injuriesClass 5 · ForeignAirbus A330-941 · Seoul, South KoreaJul 27, 2023 · N407DX · No damageNTSB DCA23WA394Accident · No injuriesClass 5 · ForeignBoeing 767-332 · Fuimicino, ItalyJul 24, 2023 · N189DN · Minor damageNTSB DCA23WA377OccurrenceClass 5 · ForeignBoeing 737 · Le Mans, FranceJul 21, 2023 · EC-NGC · No damageNTSB GAA23WA211Accident · 6 fatalClass 5 · ForeignCessna 210 · San Luis Gaceno, ColombiaJul 19, 2023 · HK5138G · Substantial damageNTSB GAA23WA213Accident · 1 fatalClass 5 · ForeignCessna FR182 · Ferrara di Monte Baldo, ItalyJul 16, 2023 · D-EEMN · Substantial damageNTSB GAA23WA218Accident · Minor injuriesClass 4 · ForeignCessna 152 · União da Vitória, BrazilJul 14, 2023 · PR-CDI · Substantial damageNTSB GAA23WA277Accident · Serious injuriesClass 5 · ForeignCessna 172 · Novosibirsk,, RussiaJul 13, 2023 · RA-2018G · Substantial damageNTSB DCA23WA386IncidentClass 5 · ForeignBoeing 737 · Antalya, JordanJul 13, 2023 · JY-SOA · No damageNTSB DCA23WA472Incident · No injuriesClass 5 · ForeignAirbus A330 · overflying English Channel, United KingdomJul 11, 2023 · HB-JHL · No damageNTSB GAA23WA210Incident · No injuriesClass 5 · ForeignCessna 206 · Esrum Sø, DenmarkJul 4, 2023 · LN-TEP · Minor damageNTSB GAA23WA205Accident · 3 fatalClass 5 · ForeignPiper PA28R · GUaratuba, BrazilJul 3, 2023 · PT-JZC · Substantial damage