NTSB investigations, Outside the U.S.

171 cases where the phase of flight was Taxi.

Cases, newest first

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 c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 250)
  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 DCA23WA369Incident · No injuriesClass 5 · ForeignBoeing 757-232 · San Salvador, El SalvadorJul 17, 2023 · N684DANTSB DCA23WA387Incident · No injuriesClass 5 · ForeignBoeing 737 · Corrientes, ArgentinaJul 14, 2023 · LV-KCE · No damageNTSB DCA23WA303Incident · No injuriesClass 5 · ForeignBoeing 777 · Abu Dhabi, United Arab EmiratesMay 19, 2023 · A6-ETPNTSB DCA23WA241IncidentClass 5 · ForeignBoeing 757-232 · Mexico City, MexicoApr 17, 2023 · N694DL · Minor damageNTSB DCA24WA007Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Nairobi, KenyaFeb 26, 2023 · 5Y-KYT · Minor damageNTSB DCA23WA138Incident · No injuriesClass 5 · ForeignBoeing 737 · Merauke-Papua Island, IndonesiaJan 26, 2023 · PK-LFO · Minor damageNTSB DCA23WA137Accident · No injuriesClass 5 · ForeignBoeing 767 · Narita, JapanJan 25, 2023 · JA603A · Substantial damageNTSB ENG23WA010Incident · No injuriesClass 5 · ForeignDassault/Sud FAN JET Falcon SER D · Toluca, Mex, MexicoNov 22, 2022 · N229CK · Minor damageNTSB GAA23WA030Incident · No injuriesClass 5 · ForeignCessna 680 · Abu Dhabi, United Arab EmiratesNov 21, 2022 · SU-SML · No damageNTSB DCA23WA069IncidentClass 5 · ForeignBeech 1900 · Fortnam, AustraliaNov 17, 2022 · VH-YNA · Minor damageNTSB DCA23WA081OccurrenceClass 5 · ForeignBoeing 737 · Sydney, AustraliaNov 14, 2022 · VH-IWQ · No damageNTSB GAA23WA016Incident · No injuriesClass 5 · ForeignBell 206 · Kitakyushu, JapanOct 15, 2022 · JA6113 · No damageNTSB DCA22WA214Accident · No injuriesClass 5 · ForeignBoeing 777 · London, GabonSep 28, 2022 · HL-7782 · 2 aircraft · Substantial damageNTSB GAA22WA305Accident · No injuriesClass 5 · ForeignCessna C172 · Yao, JapanSep 22, 2022 · JA3969 · Substantial damageNTSB DCA22WA158IncidentClass 5 · ForeignAirbus A330-323 · Barcelona, SpainJul 2, 2022 · N803NW · 2 aircraft · No damageNTSB GAA22WA223Incident · No injuriesClass 5 · ForeignCirrus SR22 · Kagoshima, JapanJun 25, 2022 · JA74MD · No damageNTSB DCA22WA173IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomMar 17, 2022 · EI-ENFNTSB ENG22WA012Incident · No injuriesClass 5 · ForeignSwearingen SA226 · San Andrés, ColombiaFeb 16, 2022 · HK5225 · Substantial damageNTSB GAA22WA205AccidentClass 5 · ForeignCessna 560 · South Ruislip, United KingdomJan 6, 2022 · EC-KPBNTSB DCA22WA008Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Hong Kong, Hong Kong SAR ChinaOct 13, 2021 · VP-BEN · No damageNTSB DCA21WA215IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainAug 20, 2021 · EC-MUZNTSB DCA21WA185AccidentClass 5 · ForeignBoeing 737 · Dubai, United Arab EmiratesJul 21, 2021 · A6-FER · 2 aircraft · Minor damageNTSB ENG22WA010IncidentClass 5 · ForeignCessna 750 · Cyprus, GreeceJul 2, 2021 · SX-ECI · Minor damageNTSB DCA21WA159Accident · No injuriesClass 5 · ForeignBoeing 737 · Derbyshire, United KingdomJun 16, 2021 · EC-MIENTSB GAA21WA141Accident · No injuriesClass 5 · ForeignBell 407 · Siaya County, KenyaMay 30, 2021 · 5Y-PSM · Substantial damageNTSB ENG21WA049Accident · No injuriesClass 5 · ForeignATR ATR72 · Democritus, GreeceMay 30, 2021 · SX-THR · Minor damageNTSB DCA21WA105IncidentClass 5 · Foreign777 FF2 · Bogota, ColombiaMar 24, 2021 · TC-LJN · No damageNTSB DCA21WA097IncidentClass 5 · ForeignBoeing 747 · Mexico City, MexicoMar 15, 2021 · B-LJE · No damageNTSB DCA21WA086Accident · No injuriesClass 5 · ForeignBoeing 737 · Vijayawada, IndiaFeb 20, 2021 · VT-GHE · Substantial damageNTSB DCA21WA103IncidentClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaJan 26, 2021 · LV-HFR · No damageNTSB GAA21WA160Accident · No injuriesClass 5 · ForeignSocata TB10 · Salamanca, SpainJan 12, 2021 · EC-FTJ · Minor damageNTSB DCA21WA062Accident · No injuriesClass 5 · ForeignBeech 1900 · Johannesburg, South AfricaDec 31, 2020 · ZS-JCT · Minor damageNTSB DCA21WA057IncidentClass 5 · ForeignBoeing 737-8EH · Sao Paulo, BrazilDec 3, 2020 · PR-GUD · No damageNTSB DCA21WA045Incident · No injuriesClass 5 · ForeignBoeing 737 · Singapore, SingaporeNov 27, 2020 · PK-YGW · No damageNTSB DCA21WA098IncidentClass 5 · ForeignAirbus A320-214 · Bogata, ColombiaOct 4, 2020 · N740AV · Substantial damageNTSB DCA21WA065IncidentClass 5 · ForeignBoeing 737 · Khartoum, SudanSep 12, 2020 · C5-BDB · Minor damageNTSB DCA20WA084Incident · No injuriesForeign investigationBoeing 757 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 757 airplane that occurred on January 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…Jan 1, 2020 · N687DL · No damageNTSB ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…Dec 15, 2019 · N22905 · Substantial damageNTSB DCA19WA195Incident · No injuriesForeign investigationBoeing 737 · El Alto, BoliviaThe government of Bolivia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions…Aug 3, 2019 · CP-3077 · Minor damageNTSB CEN19WA203Incident · No injuriesForeign investigationCessna 560 · Elche, SpainThe government of Spain has notified the NTSB of an accident involving a CESSNA 560XL airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…May 30, 2019 · D-CGAANTSB DCA19WA099Accident · No injuriesForeign investigationBeech 1900 · Ourgla, AlgeriaThe Civil Aviation Directorate (CAD) of Algeria has notified the NTSB of an accident involving a Beech 1900D, which occurred on March 3, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAD investigation under the provisions of ICAO…Mar 3, 2019 · 7T-VIO · Substantial damageNTSB DCA19WA020AccidentClass 5 · ForeignAirbus A330 · Paris, FranceOct 31, 2018 · N817NW · 2 aircraft · Minor damageNTSB DCA21WA225AccidentClass 5 · ForeignBoeing 787 · Istanbul, TürkiyeAug 9, 2018 · CN-RGT · 2 aircraft · Substantial damageNTSB CEN18WA393Accident · Minor injuriesForeign investigationAerospatiale AS350 · Wolfsberg, AustriaJul 20, 2018 · N36033 · Substantial damageNTSB DCA18WA161Incident · No injuriesForeign investigationBoeing 737 · Perth, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…Apr 28, 2018 · VH-XZM · 2 aircraft · No damageNTSB DCA18WA156Incident · No injuriesForeign investigationBoeing 767 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 767 airplane that occurred on March 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Mar 27, 2018 · C-GHLV · No damageNTSB WPR18WA115Accident · No injuriesForeign investigationRobinson R22 · Bloemfontein, South AfricaMar 19, 2018 · ZS-HAI · Substantial damageNTSB ENG18RA012Incident · No injuriesForeign investigationEmbraer ERJ190 · Mar Del Plata, ArgentinaThe Junta de Investigacion de Accidentes de Avicion Civil (JIAAC) Republica Argentina has notified the NTSB of an incident involving an Embraer ERJ 190 which occurred on January 29, 2018. The NTSB has appointed a US Accredited Representative to assist the…Jan 29, 2018 · LV-CID · Minor damageNTSB DCA18WA076Incident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 737, which occurred on January 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Jan 10, 2018 · 9H-BBJ · Minor damageNTSB DCA18WA077Incident · No injuriesForeign investigationBoeing 767 · Almaty, KazakhstanKazakhstan's Aviation Accident Investigation Department has notified the NTSB of an incident involving a Boeing 767, which occurred on December 9, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as…Dec 9, 2017 · 4P-KEC · Minor damage