NTSB investigations, 2023, Outside the U.S.

61 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2023, Outside the U.S. per year, 1962–2026: 646 cases
19621
19649
19658
19666
19675
19689
19696
19705
19714
19725
19734
19747
19755
19762
19772
19781
19792
19801
19951
19961
20071
20089
20097
20108
201115
201211
20139
201418
201529
201629
201742
201829
201932
202030
202139
202241
202361
202471
202555
202626

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 = 300)
  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 DCA24WA067IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsDec 19, 2023 · EI-STW · No damageNTSB DCA24WA059IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaDec 17, 2023 · TN-AKCNTSB ENG24WA041OccurrenceClass 5 · ForeignBoeing 777 · Karachi, PakistanDec 2, 2023 · AP-BMH · No damageNTSB GAA24WA048AccidentClass 5 · ForeignEnstrom 280 · Madrid, SpainDec 1, 2023 · F-HPUX · Substantial damageNTSB DCA24WA040OccurrenceClass 5 · ForeignBoeing 737 · East Midlands, United KingdomDec 1, 2023 · G-JMCV · No damageNTSB GAA24WA054Accident · No injuriesClass 5 · ForeignCessna A188 · Ipiranga do Norte, BrazilNov 30, 2023 · SCF-PP · Substantial damageNTSB DCA24WA084IncidentClass 5 · ForeignBoeing 747 · Frankfurt, GermanyNov 30, 2023 · TF-AMKNTSB DCA24WA041OccurrenceClass 5 · ForeignBoeing 737 · Alger, AlgeriaNov 21, 2023 · 7T-VJJNTSB GAA24WA026Accident · No injuriesClass 5 · ForeignAerospatiale SA341G Gazelle · Spalding, United KingdomNov 5, 2023 · N150SF · Substantial damageNTSB GAA24WA021IncidentClass 5 · ForeignCessna 525 · Paris, FranceOct 28, 2023 · F-HMSG · Minor damageNTSB GAA24WA029Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaOct 22, 2023 · VT-RBT · Substantial damageNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaOct 21, 2023 · ZS-JKE · Substantial damageNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaOct 21, 2023 · ZK-JKE · Substantial damageNTSB GAA24WA030Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaOct 19, 2023 · VT-RBC · DestroyedNTSB DCA24WA018Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Frankfurt am Main, GermanyOct 18, 2023 · D-ABKM · No damageNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeOct 16, 2023 · V3-HIN · DestroyedNTSB GAA24WA004Accident · 3 fatalClass 5 · ForeignBeech 90 · Cuiaba, BrazilOct 4, 2023 · PS-JCO · DestroyedNTSB GAA23WA270Accident · Serious injuriesClass 5 · ForeignCessna 172 · Monacalieri, ItalySep 23, 2023 · I-FFSW · Substantial damageNTSB DCA23WA460Incident · Serious injuriesClass 5 · ForeignBoeing 787 · Melbourne, AustraliaSep 18, 2023 · VN-A819 · No damageNTSB GAA23WA262AccidentClass 5 · ForeignBeech 36 · San Luis, ArgentinaSep 17, 2023 · LV-GLQ · Substantial damageNTSB GAA23WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Bamberg, GermanySep 17, 2023 · D-EOLP · Substantial damageNTSB GAA23WA261Accident · Serious injuriesClass 5 · ForeignExtra EA300 · Graz, AustriaSep 13, 2023 · D-EXJW · Substantial damageNTSB DCA23WA450IncidentClass 5 · ForeignBoeing 757 · Manchester, United KingdomSep 8, 2023 · G-LSAA · No damageNTSB ENG24WA002IncidentClass 5 · ForeignBoeing 737 · Rio de Janeiro, BrazilSep 2, 2023 · PR-GUM · Minor damageNTSB GAA23WA237Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Borroloola, AustraliaAug 7, 2023 · VH-HRB · Substantial damageNTSB GAA23WA216Accident · Minor injuriesClass 5 · ForeignCessna 152 · Drásov, CzechiaJul 22, 2023 · OK-PAV · DestroyedNTSB GAA23WA222Accident · No injuriesClass 5 · ForeignPiper PA23 · Governors Harbour, BahamasJul 21, 2023 · C6-PAANTSB DCA23WA479IncidentClass 5 · ForeignBoeing 777 · Ciaro, EgyptJul 21, 2023 · not reported · Minor damageNTSB GAA23WA208AccidentClass 5 · ForeignCessna 208B · Chrcynno, PolandJul 17, 2023 · SP-WAW · DestroyedNTSB GAA23WA212Accident · No injuriesClass 5 · ForeignBell 206 · Tumbarumba, AustraliaJul 16, 2023 · VH-ZDI · Substantial damageNTSB DCA23WA366Incident · Minor injuriesClass 5 · ForeignAirbus A320 · Barcelona, SpainJul 16, 2023 · EC-JTR · Minor damageNTSB GAA23WA202Incident · No injuriesClass 5 · ForeignCessna 150H · Cayo District, BelizeJul 9, 2023 · N8473U · Minor damageNTSB GAA23WA203Accident · No injuriesClass 5 · ForeignPiper PA25 · Arnborg, DenmarkJul 7, 2023 · OY-CYY · Substantial damageNTSB GAA23WA283Accident · No injuriesClass 5 · ForeignRobinson R44 · Warszawa, PolandJul 6, 2023 · OK-LUK · Substantial damageNTSB GAA23WA220Accident · No injuriesClass 5 · ForeignPiper PA18 · Biscarosse, France, FranceJul 3, 2023 · F-HYHB · Substantial damageNTSB GAA23WA189AccidentClass 5 · ForeignCygnet sea & Sky · Açores, PortugalJul 3, 2023 · CS-UTFNTSB GAA23WA185AccidentClass 5 · ForeignMooney M20E · Andrewsfield, United KingdomJun 30, 2023 · N7423V · Substantial damageNTSB GAA23WA217Accident · 3 fatalClass 5 · ForeignGippsAero GA-8 · Ghanzi, BotswanaJun 29, 2023 · A2-MBENTSB DCA23WA471IncidentClass 5 · ForeignBoeing 737 · Santa Clara, CubaJun 26, 2023 · C-FFPH · Minor damageNTSB DCA23WA351OccurrenceClass 5 · ForeignBoeing 737 · Dubai, United Arab EmiratesJun 26, 2023 · A6-FNC · Minor damageNTSB DCA23WA470OccurrenceClass 5 · ForeignAirbus A320 · Vilnius, LithuaniaJun 21, 2023 · OO-SNI · Minor damageNTSB DCA23WA334Incident · No injuriesClass 5 · ForeignBoeing 737 · Shiraz, IranJun 20, 2023 · EP-SIR · No damageNTSB GAA23WA179Accident · Minor injuriesClass 4 · ForeignCessna 170 · Santiago, BrazilJun 19, 2023 · PT-KUM · Substantial damageNTSB DCA23WA327Accident · No injuriesClass 5 · ForeignBoeing 787 · Taipei, TaiwanJun 18, 2023 · 9V-OJF · Minor damageNTSB GAA23WA168Accident · No injuriesClass 5 · ForeignMooney M20R · Toledo, SpainJun 17, 2023 · N192JM · Substantial damageNTSB GAA23WA167Accident · No injuriesClass 5 · ForeignSocata TBM 700 · Narsarsuaq, GreenlandJun 17, 2023 · N44WN · Substantial damageNTSB DCA23WA317IncidentClass 5 · ForeignBoeing 737 · Perth Airport, AustraliaJun 11, 2023 · VH-IWQ · No damageNTSB DCA23WA311IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoJun 10, 2023 · CN-RGVNTSB GAA23WA157Accident · No injuriesClass 5 · ForeignPiper PA46-500TP · Saint-Tropez, FranceMay 29, 2023 · N149C · DestroyedNTSB GAA23WA158Accident · 2 fatalClass 5 · ForeignCessna 172 · Monagas, VenezuelaMay 27, 2023 · YV179E · Destroyed