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 LAX74OL034Accident · Serious injuriesClosedPiper PA-28 · Buena Vista, MexicoSep 10, 1973 · N8761W · Substantial damageNTSB MIA73OKT97Accident · No injuriesClosedPiper PA-32 · G.Harbor C, Burkina FasoMar 31, 1973 · N3945W · Substantial damageNTSB MIA73OKT41Accident · No injuriesClosedCessna 172 · Freeport, Burkina FasoNov 30, 1972 · N7213A · Substantial damageNTSB OAK72DJY02Accident · No injuriesClosedPilatus PC6CH2 · Bn Xieng Lom, LaosApr 7, 1972 · N359F · Substantial damageNTSB DCA72RZ014Accident · No injuriesClosedBoeing 747 · London, United KingdomMar 8, 1972 · N738PA · 2 aircraft · Substantial damageNTSB OAK72DJY12Accident · No injuriesClosedBell 204B · Vientiane, LaosFeb 27, 1972 · N8513F · Substantial damageNTSB EU171DYZ06Accident · No injuriesClosedCessna 421B · Dortmund, GeorgiaMar 4, 1971 · N8006Q · Substantial damageNTSB MIA710KT36Accident · No injuriesClosedBell 47G · Nassau, Burkina FasoJan 23, 1971 · N184B · Substantial damageNTSB OAK71DJW05Accident · No injuriesClosedDehaviland DHC-4A · Qui Nhon, VMNov 5, 1970 · N580PA · No damageNTSB NYC71IN051Incident · Minor injuriesClosedBoeing 747 · London, United KingdomOct 27, 1970 · N337PA · Minor damageNTSB FTW71DRG16Accident · No injuriesClosedPiper PA-24 · S.Luis Gonzga, MexicoJul 30, 1970 · N112WS · Substantial damageNTSB CAN72AW906Accident · No injuriesClosedPiper PA-16 · Fort St.John, CanadaJul 18, 1970 · N5766H · Substantial damageNTSB FSO68AE210Accident · No injuriesClosedBeech C-45H · Tripoli, LibyaMar 3, 1968 · N495F · Substantial damageNTSB LAX68O0294Accident · No injuriesClosedCessna 182 · San Pedro, MexicoDec 28, 1967 · N9354X · Substantial damageNTSB UNK66X0173Accident · No injuriesClosedCessna 310J · Chihuahua, MexicoSep 15, 1966 · N3054L · Substantial damageNTSB FTW66D0570Accident · No injuriesClosedCessna 182 · Loreto, MexicoFeb 27, 1966 · N282E · Substantial damageNTSB UNK66X0109Accident · No injuriesClosedBell 47J · Meander R., CanadaNov 12, 1965 · N5151B · Substantial damageNTSB UNK65X1512Accident · No injuriesClosedBeechcraft E-50 · Saw Mill Bay, CanadaJul 3, 1965 · N106WB · Substantial damageNTSB UNK65X1448Accident · No injuriesClosedPiper PA-22 · Pampa, Burkina FasoFeb 22, 1965 · N2612P · Substantial damageNTSB UNK65X0746Accident · No injuriesClosedDouglas DC-4 · Tangra, GreenlandNov 17, 1964 · N17 · Substantial damageNTSB UNK65X0734Accident · No injuriesClosedCessna 310 · Tabruk, Saudi ArabiaNov 16, 1964 · N1848H · Substantial damage