NTSB investigations, 2024, Outside the U.S.

71 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2024, 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\") = 2024
    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 ENG25WA029IncidentClass 5 · ForeignBoeing 737 · Oslo, NorwayDec 28, 2024 · PH-BXM · Minor damageNTSB GAA25WA048Accident · 10 fatalClass 3 · ForeignPiper PA42 · Gramado, BrazilDec 22, 2024 · PR-NDN · DestroyedNTSB GAA25WA041Accident · No injuriesClass 5 · ForeignCessna 188 · Barra Bonita, BrazilDec 9, 2024 · PR-WDK · Substantial damageNTSB GAA25WA039Accident · Serious injuriesClass 5 · ForeignCessna Cessna FA 150L · Watorowo, PolandDec 8, 2024 · SP-KIKNTSB DCA25WA053IncidentClass 5 · ForeignBoeing 767 · Bogotá, ColombiaDec 8, 2024 · HP3310DAE · Minor damageNTSB DCA25WA051Incident · No injuriesClass 5 · ForeignAirbus 320 · Pereira, ColombiaNov 27, 2024 · HK5407 · Minor damageNTSB ENG25WA039AccidentClass 5 · ForeignDiamond DA42 · Ben Slimane, MoroccoNov 21, 2024 · CN-PLO · Substantial damageNTSB GAA25WA022Accident · Serious injuriesClass 5 · ForeignBell 205 · Región del Maule, ChileNov 12, 2024 · CC-ATFNTSB DCA25WA121Incident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandNov 11, 2024 · EI-IJL · 2 aircraft · No damageNTSB DCA25WA032IncidentClass 5 · ForeignBoeing 727 · Bogotá, ColombiaNov 11, 2024 · HK5216 · Minor damageNTSB ENG25WA005IncidentClass 5 · ForeignBoeing 737 · Sydney, Australia, AustraliaNov 8, 2024 · VH-VYH · Minor damageNTSB ENG25WA003Incident · No injuriesClass 5 · ForeignAirbus A320 · Barcelona, SpainNov 8, 2024 · EC-MBS · No damageNTSB GAA25WA017Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Zona-Bananera-Magdalena, ColombiaOct 29, 2024 · HK5177 · Substantial damageNTSB ENG25WA002OccurrenceClass 5 · ForeignTextron Beech G58 · Okayama, JapanOct 22, 2024 · JA60AZ · Substantial damageNTSB DCA25WA028Incident · No injuriesClass 5 · ForeignBoeing 767-332 · Ndiass, SenegalOct 19, 2024 · N199DN · No damageNTSB GAA25WA012Accident · 2 fatalClass 5 · ForeignNorth American SNJ-3 · Räyskälä, FinlandOct 16, 2024 · OH-NAT · DestroyedNTSB GAA25WA007Accident · 2 fatalClass 5 · ForeignCirrus Design SR22 · La Bretonnière la Claye, FranceOct 7, 2024 · N456AR · DestroyedNTSB GAA25WA005Accident · 3 fatalClass 5 · ForeignCessna 404 · Les Cayes, HaitiOct 3, 2024 · N404EC · Substantial damageNTSB GAA24WA303Accident · Minor injuriesClass 4 · ForeignCessna T182 · Cuiabá - Mato Grosso, BrazilSep 26, 2024 · PP-JON · Substantial damageNTSB DCA24WA306Accident · Serious injuriesClass 3 · ForeignATR ATR42 · Serui, IndonesiaSep 9, 2024 · PK-YSP · Substantial damageNTSB GAA24WA281Accident · 2 fatalClass 5 · ForeignCessna 172 · Soest, GermanySep 7, 2024 · D-ECHF · DestroyedNTSB GAA24WA270Accident · 1 fatalClass 4 · ForeignPiper PA18 · Defford, United KingdomAug 27, 2024 · G-CUBX · DestroyedNTSB GAA24WA282Accident · 2 fatalClass 5 · ForeignPartenavia P66 · LIAA (Identifier), ItalyAug 22, 2024 · I-IABS · Substantial damageNTSB GAA24WA315Accident · No injuriesClass 5 · ForeignPiper PA28 · Varberg, SwedenAug 16, 2024 · SE-LKV · Substantial damageNTSB GAA24WA262Accident · No injuriesClass 5 · ForeignPiper PA18 · Oxfordshire, United KingdomAug 16, 2024 · G-OFERNTSB DCA24WA272IncidentClass 5 · ForeignBoeing 747-400F · Narita, JapanAug 13, 2024 · N404KZ · Substantial damageNTSB GAA24WA257AccidentClass 5 · ForeignCessna 188 · Bananera, ColombiaAug 12, 2024 · HK1468 · Substantial damageNTSB GAA24WA277Incident · No injuriesClass 5 · ForeignCirrus SR22 · Dubai, United Arab EmiratesAug 9, 2024 · A6-CTJ · Substantial damageNTSB DCA24WA312Incident · No injuriesClass 5 · ForeignBoeing 727 · Curitiba, BrazilJul 27, 2024 · PR-TTO · No damageNTSB GAA24WA224AccidentClass 5 · ForeignCessna 182 · La Paragua, VenezuelaJul 22, 2024 · YV1358 · DestroyedNTSB DCA24WA247Incident · No injuriesClass 5 · ForeignBoeing 737 · Yola, NigeriaJul 21, 2024 · 5N-ADB · Minor damageNTSB GAA24WA256Accident · 2 fatalClass 5 · ForeignPiper PA34 · Carate, Costa RicaJul 16, 2024 · TI-API · DestroyedNTSB ANC24LA065Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-B80 · Woleai Atoll, MicronesiaThe pilot's selection of an unsuitable takeoff area, resulting in a loss of directional control. Contributing to the accident was a flooded runway.Jul 12, 2024 · N44MA · Substantial damageNTSB DCA24WA236AccidentClass 5 · ForeignBoeing B777 · Milan, ItalyJul 9, 2024 · PT-MUG · Substantial damageNTSB GAA24WA219Accident · No injuriesClass 5 · ForeignCessna 182 · Sapareva Banya, BulgariaJul 6, 2024 · LZ-SDB · Substantial damageNTSB GAA24WA209AccidentClass 5 · ForeignJust SuperStol · Romsey, United KingdomJul 4, 2024 · G-SSTL · DestroyedNTSB GAA24WA226Accident · Minor injuriesClass 5 · ForeignFlight Design Ctsw · Roseau, DominicaJul 3, 2024 · N7670 · Substantial damageNTSB GAA24WA200Accident · 1 fatalClass 3 · ForeignBell 212 · Fort Good Hope, CanadaJun 28, 2024 · C-FPMR · DestroyedNTSB DCA24WA223Incident · No injuriesClass 5 · ForeignBoeing 777 · London, United KingdomJun 28, 2024 · G-VIIT · No damageNTSB GAA24WA195IncidentClass 5 · ForeignTextron 208 · Bailey Town, BahamasJun 23, 2024 · N384TANTSB GAA24WA199Accident · Minor injuriesClass 5 · ForeignCessna 182 · Torres, BrazilJun 22, 2024 · PT-DYF · Substantial damageNTSB DCA24WA218OccurrenceClass 5 · ForeignATR ATR72 · Seville, SpainJun 19, 2024 · CN-COE · 2 aircraft · No damageNTSB DCA24WA211OccurrenceClass 3 · ForeignBoeing 747-400F · Hong Kong, Hong Kong SAR ChinaJun 16, 2024 · N406KZ · Minor damageNTSB GAA24WA235AccidentClass 4 · ForeignAir Tractor AT502 · Apartado, ColombiaJun 14, 2024 · HK5380NTSB DCA24WA201Incident · No injuriesClass 3 · ForeignBoeing 777FZB · Narita, JapanJun 4, 2024 · N714SANTSB GAA24WA206Incident · No injuriesClass 5 · ForeignHawker Beechcraft C90 · Biggin Hill, United KingdomJun 1, 2024 · D-IMEP · Minor damageNTSB GAA24WA208Accident · No injuriesClass 5 · ForeignCessna F152 · Maribor, SloveniaMay 28, 2024 · S5-DMI · Substantial damageNTSB ENG24WA019IncidentClass 5 · ForeignBoeing 737-852 · Merida, MexicoMay 16, 2024 · N825AM · No damageNTSB ENG24WA016Incident · No injuriesClass 3 · ForeignBoeing 747 · Sulawesi, IndonesiaMay 15, 2024 · ER-BOS · Minor damageNTSB DCA24WA182Accident · Serious injuriesClass 3 · ForeignBoeing 737 · Dakar, SenegalMay 9, 2024 · 6V-AJE · Substantial damage