NTSB investigations, 1973, Outside the U.S.

18 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1973, Outside the U.S. per year, 1962–2026: 1,170 cases
19621
19631
196438
196537
196640
196735
196824
196920
197021
197118
197226
197318
197422
197518
19764
19776
197812
19794
19802
19821
19911
19931
19941
19961
19974
19991
20001
20081
200910
201021
201123
201227
201322
201421
201534
201655
201751
201860
201939
202048
202172
202275
202383
202483
202563
202624

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\") = 1973
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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 MIA74OKT42Accident · No injuriesClosedPiper PA-23 · G Bahama I, Burkina FasoNov 27, 1973 · N5ML · Substantial damageNTSB FTW74DRG38Accident · No injuriesClosedCessna 182 · San Luis Ptsi, MexicoNov 26, 1973 · N3352Y · Substantial damageNTSB OAK74DJY07Accident · Minor injuriesClosedPilatus PC6CH2 · Ling Tieng, LaosNov 25, 1973 · N5304F · DestroyedNTSB LAX74OL078Accident · No injuriesClosedPiper PA-20 · La Salina, MexicoNov 21, 1973 · N1521A · Substantial damageNTSB LAX74OL039Accident · No injuriesClosedAero Comdr 500-A · Las Cruces, MexicoOct 27, 1973 · N9392R · Substantial damageNTSB MIA74OKT35Accident · No injuriesClosedCessna 150G · Mores Is, Burkina FasoOct 26, 1973 · N3234X · Substantial damageNTSB MIA74OKA05Accident · No injuriesClosedBrittnorman BN-2A · Santo Domingo, DRSep 17, 1973 · N869JA · Substantial damageNTSB UNK73X0123Accident · No injuriesClosedLockheed 18 · Santa Lucia, MexicoSep 14, 1973 · N211W · DestroyedNTSB MIA74OKT18Accident · No injuriesClosedBeech D18S · Middle Caicos, TokelauSep 11, 1973 · N80351 · DestroyedNTSB OAK74DJY05Accident · No injuriesClosedCessna 172L · Cubi Point Nas, RPSep 7, 1973 · N7199Q · Substantial damageNTSB OAK74DJY04Accident · No injuriesClosedBell 204B · Ramasun, ThailandSep 7, 1973 · N8535F · Substantial damageNTSB MIA74DKT06Accident · Serious injuriesClosedCessna 150 · France Fld, St. Pierre & MiquelonAug 1, 1973 · N6473G · Substantial damageNTSB UNK73X0119Accident · No injuriesClosedBellanca 17-30A · Montego Bay, JamaicaJul 28, 1973 · N39818 · Substantial damageNTSB UNK73X0117Accident · Minor injuriesClosedDehavilland DHC-6 · Dhahran, Saudi ArabiaJul 16, 1973 · N660MA · Substantial damageNTSB OAK73DVD39Accident · No injuriesClosedPiper PA-32 · La Paz, MexicoMay 26, 1973 · N3852W · Substantial damageNTSB UNK73X0111Accident · 3 fatalClosedLockheed PV-1 · Chimichagua, ColombiaApr 15, 1973 · N175S · DestroyedNTSB MIA73OM088Accident · Serious injuriesClosedDouglas DC-3C · San Salvador, Burkina FasoMar 2, 1973 · N6574 · Substantial damageNTSB UNK73X0106Incident · No injuriesClosedDouglas DC-8 · Jeddah, Saudi ArabiaJan 29, 1973 · N8782R · Minor damage