NTSB investigations, 1971, Outside the U.S.

18 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1971, 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\") = 1971
    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 MIA72OM063Accident · No injuriesClosedBrittnorman BN-2A · Dajabon, DRDec 22, 1971 · N42JA · Substantial damageNTSB FTW72DRG39Accident · No injuriesClosedPiper PA-32 · Estacion Coah, MexicoNov 28, 1971 · N3435W · Substantial damageNTSB MIA72OKT27Accident · No injuriesClosedBeech D18S · Nassau, Burkina FasoOct 30, 1971 · N980WL · Substantial damageNTSB SIR72I7102Incident · No injuriesClosedBoeing 747 · Sydney, American SamoaJul 18, 1971 · N652PA · No damageNTSB MIA72RKA01Accident · No injuriesClosedBensen BM8 · Aruba, AAJun 29, 1971 · N10VB · Substantial damageNTSB MIA71OKT66Accident · No injuriesClosedCessna 207 · Ragged Is, Burkina FasoJun 15, 1971 · N1536U · Substantial damageNTSB MIA71OKT65Accident · Minor injuriesClosedPiper PA-28 · Chitre, St. Pierre & MiquelonJun 15, 1971 · N5857U · Substantial damageNTSB UNK71X0109Accident · No injuriesClosedBell 47G-4A · Angola, AngolaJun 8, 1971 · N4002G · Substantial damageNTSB MIA71OM109Accident · No injuriesClosedGrumman G-21A · Fish Cay, Burkina FasoJun 6, 1971 · N1621A · Substantial damageNTSB MIA71OKT64Accident · No injuriesClosedCessna 172 · Coco Solo, St. Pierre & MiquelonMay 26, 1971 · N7474G · DestroyedNTSB OAK72DJY03Accident · No injuriesClosedCessna 172 · Cubi Point, RPMay 6, 1971 · N8841U · Substantial damageNTSB UNK71X0107Accident · No injuriesClosedCessna 337 · Hewanorra, WNApr 17, 1971 · N86379 · Substantial damageNTSB EU171DYZ07Accident · No injuriesClosedPiper PA-28 · Lohrbach, GeorgiaMar 28, 1971 · N8864W · Substantial damageNTSB FTW71DRH11Accident · No injuriesClosedCessna 205 · San Felipe, MexicoMar 26, 1971 · N8472Z · Substantial damageNTSB FTW71DRG99Accident · No injuriesClosedCessna 182 · Bahia De L A, MexicoMar 12, 1971 · N1965X · Substantial damageNTSB FTW71DRH01Accident · No injuriesClosedCessna 182 · Santa Rosalia, MexicoFeb 15, 1971 · N2700Q · Substantial damageNTSB MIA710KT41Accident · No injuriesClosedCessna 182B · Staniel Cay, Burkina FasoFeb 10, 1971 · N2724G · Substantial damageNTSB FTW71DQG77Accident · No injuriesClosedCessna 320 · San Miguel, MexicoJan 5, 1971 · N3495Q · Substantial damage