NTSB investigations, 1972, Outside the U.S.

26 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1972, 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\") = 1972
    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 JAM73AB781Accident · Serious injuriesClosedCessna 337 · Trelawny, JamaicaDec 3, 1972 · N1319M · Substantial damageNTSB UNK73X0103Incident · No injuriesClosedBeech 65-80 · Ora, LibyaNov 28, 1972 · N2613 · Minor damageNTSB OAK73FJZ02Accident · No injuriesClosedCessna 150F · Yongju, St. Kitts & NevisSep 22, 1972 · N7849F · Substantial damageNTSB MIA73OM021Incident · No injuriesClosedPiper PA-23 · Virgin Gorda, U.S. Virgin IslandsAug 21, 1972 · N4444P · Minor damageNTSB EU173DYZ01Accident · Minor injuriesClosedConsolidate 28-5AC · Monte Carlo, MongoliaAug 15, 1972 · N190 · Substantial damageNTSB MIA73OKA02Accident · Serious injuriesClosedBeech D18S · St Maarten, NTAug 4, 1972 · N103P · DestroyedNTSB OAK73DJY03Accident · No injuriesClosedGrumman G44 · Majuro, MontserratAug 1, 1972 · N4452 · DestroyedNTSB MIA73OKT07Accident · Minor injuriesClosedPiper PA-28 · Spanish Wells, Burkina FasoJul 10, 1972 · N9091J · Substantial damageNTSB LAX73OL001Accident · No injuriesClosedCessna 175 · San Felipe, MexicoJul 5, 1972 · N7601M · Substantial damageNTSB OAK73DJY09Accident · No injuriesClosedDouglas A-26B · Manila, RPJul 4, 1972 · N4000K · Substantial damageNTSB UNK72X0109Accident · Serious injuriesClosedBeech 50 · Elk Is, CanadaJun 24, 1972 · N3674B · DestroyedNTSB CAN73P0902Accident · No injuriesClosedPiper PA-28 · Tsacha Lk, CanadaJun 11, 1972 · N4521T · Substantial damageNTSB OAK73OJA02Accident · No injuriesClosedCessna 150G · Clark Afbase, RPApr 11, 1972 · N3843S · Substantial damageNTSB IFO72DYZ04Accident · No injuriesClosedCessna 140 · Hanau, GeorgiaApr 9, 1972 · N76938 · Substantial damageNTSB FTW72DRG64Accident · No injuriesClosedCessna 210T · Cabo San Lucs, MexicoApr 8, 1972 · N6763R · Substantial damageNTSB FTW72DRG63Accident · 1 fatalClosedCessna 210 · Novillo Cueva, MexicoApr 6, 1972 · N9438X · Substantial damageNTSB OAK72FJZ00Accident · No injuriesClosedBoeing 707 · Tokyo, JAMar 20, 1972 · N307WA · Substantial damageNTSB OAK72DJY17Accident · No injuriesClosedPilatus PC6CH2 · Nong Kha, LaosMar 20, 1972 · N365F · Substantial damageNTSB FTW72DRG53Accident · No injuriesClosedCessna 172 · Puerto Penaso, MexicoMar 3, 1972 · N84308 · Substantial damageNTSB OAK72FJA03Accident · No injuriesClosedRepublic RC-3 · Kasumiga-Ur, JAFeb 15, 1972 · N114N · Substantial damageNTSB MIA72OKT67Accident · Minor injuriesClosedBeech D18S · Pitts Twn, Burkina FasoFeb 13, 1972 · N90291 · Substantial damageNTSB OAK72DJY09Accident · No injuriesClosedCessna 172 · Castillejos, RPFeb 12, 1972 · N8422U · Substantial damageNTSB MIA72/M081Accident · No injuriesClosedLockheed Ga 382E · Montalvo, EcuadorFeb 10, 1972 · N9232R · Substantial damageNTSB FTW72DRG57Accident · No injuriesClosedBeech C-18S · Santa Rosalin, MexicoFeb 1, 1972 · N7939C · Substantial damageNTSB MIA72OM076Accident · No injuriesClosedPiper PA-23 · St.Maarten, NTJan 31, 1972 · N19273 · DestroyedNTSB LAX72DUJ76Accident · No injuriesClosedCessna T210K · Kino Bay, MexicoJan 14, 1972 · N9442M · Substantial damage