NTSB investigations, 2023, Outside the U.S.

49 cases where the phase of flight was Approach.

Cases per year

19622026
NTSB investigations, 2023, Outside the U.S. per year, 1962–2026: 596 cases
19623
19649
196511
196613
19678
196810
19698
19706
19718
197213
197310
19745
19752
19763
19772
19784
19791
19802
19841
19881
19931
19951
19972
19991
20021
20041
20083
200915
20107
201115
201211
201330
201418
201516
201634
201723
201832
201930
202016
202135
202232
202349
202439
202543
202621

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 = 500)
  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 GAA24WA063AccidentClass 5 · ForeignCessna 172 · Buenos Aires, ArgentinaDec 30, 2023 · LV-GSL · Substantial damageNTSB DCA24WA060IncidentClass 5 · ForeignBoeing 737 · Sydney, AustraliaDec 23, 2023 · VH-VOL · No damageNTSB DCA24WA052IncidentClass 5 · ForeignBoeing 737 · Billund, DenmarkDec 21, 2023 · OY-JZN · No damageNTSB DCA24WA045IncidentClass 5 · ForeignBoeing 737 · Quito, EcuadorDec 19, 2023 · HK-5434 · No damageNTSB DCA24WA036OccurrenceClass 5 · ForeignBoeing 737 Max 8-200 · London, United KingdomDec 4, 2023 · EI-HET · No damageNTSB GAA24WA046Accident · Serious injuriesClass 5 · ForeignCessna 170 · Quebec, CanadaNov 28, 2023 · C-FZHI · Substantial damageNTSB DCA24WA029Incident · No injuriesClass 5 · ForeignBoeing 787 · Bogotá, ColombiaNov 6, 2023 · PH-BKA · No damageNTSB DCA24WA066IncidentClass 5 · ForeignAirbus A320 · Geneva, SwitzerlandNov 5, 2023 · G-UZLO, · No damageNTSB DCA24WA044OccurrenceClass 5 · ForeignDe Havilland Dash 8 · Val-d'Or, CanadaOct 26, 2023 · C-FLSX · No damageNTSB DCA23WA480IncidentClass 5 · ForeignBoeing 737 · Stuttgart, GermanyOct 23, 2023 · TC-SOR · 2 aircraft · No damageNTSB ENG24WA006Incident · No injuriesClass 5 · ForeignViking DHC-6-200 · Hulhulé Island, MaldivesOct 6, 2023 · 8Q-RAL · No damageNTSB GAA24WA001Accident · No injuriesClass 3 · ForeignRobinson R44 · Vamdrup, DenmarkOct 4, 2023 · OY-HFS · Substantial damageNTSB GAA24WA007Accident · No injuriesClass 5 · ForeignCessna 210 · Campo Grande, BrazilOct 2, 2023 · PR-XIC · Substantial damageNTSB GAA23WA258Accident · No injuriesClass 5 · ForeignCessna 205 · La Paragua, VenezuelaSep 14, 2023 · L1PL · Substantial damageNTSB ENG23WA036Incident · No injuriesClass 5 · ForeignAirbus A320 · Chihuahua, MX, MexicoSep 3, 2023 · XA-VSE · No damageNTSB GAA24WA027Incident · No injuriesClass 5 · ForeignFokker F28 · Adelaide Aerodrome, AustraliaAug 30, 2023 · VH-FGB · No damageNTSB GAA23WA246Accident · Minor injuriesClass 5 · ForeignCessna 150 · Ad. Alto Paraná, El Dorado, ArgentinaAug 25, 2023 · LV-CLJ · Substantial damageNTSB DCA23WA437IncidentClass 5 · ForeignEmbraer 190 · Alice Springs, AustraliaAug 24, 2023 · VH-UYN · No damageNTSB DCA23WA416Accident · 10 fatalClass 5 · ForeignRaytheon 390 · Elmina, MalaysiaAug 17, 2023 · N28JV · DestroyedNTSB DCA23WA413Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomAug 9, 2023 · G-NPTHNTSB GAA23WA230Accident · 2 fatalClass 5 · ForeignCessna 172 · Trujillo, PeruJul 28, 2023 · OB-1334 · DestroyedNTSB DCA23WA410IncidentClass 5 · ForeignBoeing 737 · Rio De Janeiro, BrazilJul 28, 2023 · PR-GXM · No damageNTSB GAA23WA234Accident · No injuriesClass 5 · ForeignCessna 172 · Kohnan, JapanJul 14, 2023 · JA10AZ · Minor damageNTSB GAA23WA198Accident · 1 fatalClass 4 · ForeignPiper 23 · Thirsk, United KingdomJul 6, 2023 · G-BKJW · DestroyedNTSB GAA23WA175AccidentForeign investigationPiper PA28 · Bournemouth, United KingdomJun 26, 2023 · G-AVLGNTSB GAA23WA214Accident · No injuriesClass 5 · ForeignBell 206B · Thetford Mines, CanadaJun 23, 2023 · N717LM · Substantial damageNTSB GAA23WA181Accident · No injuriesClass 5 · ForeignCessna 310 · Derby, AustraliaJun 20, 2023 · VH-DAW · Substantial damageNTSB ENG24WA001IncidentClass 5 · ForeignDe Havilland DHC8 · Timaru, New ZealandJun 13, 2023 · ZK-NEM · No damageNTSB DCA23WA318IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomJun 12, 2023 · G-FDZX · No damageNTSB GAA23WA166Accident · No injuriesClass 5 · ForeignBeech A36 · Teresina, Pi, BrazilJun 11, 2023 · PT-DLO · Substantial damageNTSB DCA23WA314Incident · No injuriesClass 5 · ForeignBoeing 717 · Cambridge, AustraliaJun 6, 2023 · VH-NXM · No damageNTSB DCA23WA419Incident · No injuriesClass 5 · ForeignEmbraer 190 · Napier, New ZealandMay 25, 2023 · VH-IKJ · No damageNTSB GAA23WA162AccidentClass 5 · ForeignPiper PA18 · Oldenburg, GermanyMay 18, 2023 · D-EJIM · DestroyedNTSB DCA23WA291Incident · No injuriesClass 5 · ForeignAirbus A320-233 · Monterrey, MexicoMay 11, 2023 · N518VL · Minor damageNTSB GAA23WA147Accident · 2 fatalClass 5 · ForeignCessna 182 · Shell, EcuadorMay 8, 2023 · HC-CJL · Substantial damageNTSB GAA23WA129Accident · 1 fatalClass 5 · ForeignLancair 360 · Taurages, LithuaniaApr 21, 2023 · LY-BRS · Substantial damageNTSB GAA23WA197AccidentClass 5 · ForeignPiper PA-31-350 · Archerfield, AustraliaApr 7, 2023 · VH-HJE · Substantial damageNTSB DCA23WA229Occurrence · No injuriesClass 5 · ForeignAirbus A320 · Sao Paulo, BrazilMar 30, 2023 · PT-MZL · 2 aircraft · No damageNTSB GAA23WA114Accident · Serious injuriesClass 5 · ForeignPiper PA-28-140 · Scottsdene, South AfricaMar 28, 2023 · ZS-JNN · Substantial damageNTSB GAA23WA105Accident · No injuriesClass 4 · ForeignPiper PA25 · Corupa, BrazilMar 21, 2023 · PT-BII · Substantial damageNTSB GAA23WA104Accident · 4 fatalClass 4 · ForeignRobinson R44 · Sao Paulo, BrazilMar 17, 2023 · PR-PGC · Substantial damageNTSB DCA23WA476Incident · No injuriesClass 4 · ForeignBoeing 787 · Dubai, United Arab EmiratesMar 10, 2023 · AC9-FG · No damageNTSB DCA23WA475IncidentClass 4 · ForeignBoeing 737 · Dubai, QatarMar 10, 2023 · AC9-FG · No damageNTSB GAA23WA081AccidentClass 5 · ForeignBeech 1900 · Winnipeg, CanadaFeb 23, 2023 · C-FJXO · Substantial damageNTSB DCA23WA206IncidentClass 5 · ForeignBoeing 787 · Sydney, AustraliaFeb 18, 2023 · VH-?? · No damageNTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilFeb 9, 2023 · PR-PLF · Substantial damageNTSB DCA23WA174AccidentClass 5 · ForeignATR ATR72 · Pokhara, NepalJan 15, 2023 · 9N-ANC · DestroyedNTSB GAA23WA057Incident · No injuriesClass 5 · ForeignRobinson R44 · Hamilton Island, AustraliaJan 8, 2023 · UNKN · No damageNTSB DCA23WA135Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Miyazaki, JapanJan 7, 2023 · JA307J · No damage