NTSB investigations, 1970, Outside the U.S.

21 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1970, 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\") = 1970
    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 OAK71DJZ06Accident · No injuriesClosedCessna 170B · Iwakuni Mcs, JADec 27, 1970 · N9277 · Substantial damageNTSB UNK71X0103Accident · No injuriesClosedBeech 99 · Trinidad, ChadDec 21, 1970 · N995E · Substantial damageNTSB MIA71OKT22Accident · Minor injuriesClosedHelio Acft H-295 · Treasre C, Burkina FasoNov 26, 1970 · N6341V · Substantial damageNTSB EU170DYZ05Accident · No injuriesClosedPiper PA-28 · Lorca, SPNov 6, 1970 · N6384J · Substantial damageNTSB CAN71AW910Accident · Serious injuriesClosedCessna T337 · Fort Nelson, CanadaSep 27, 1970 · N86394 · DestroyedNTSB LAX71DUJ24Accident · No injuriesClosedCessna 150 · Puerto Pnasco, MexicoAug 9, 1970 · N6724S · Substantial damageNTSB OAK71DJW04Accident · No injuriesClosedBeech G18S · Bac Lieu, VMJul 27, 1970 · N7770B · Substantial damageNTSB LAX71DUJ09Accident · Minor injuriesClosedCessna 182 · El Cinco, MexicoJul 15, 1970 · N5308B · Substantial damageNTSB CAN71AA906Accident · Minor injuriesClosedMooney M20C · Drummond Sta, CanadaJun 30, 1970 · N6590U · Substantial damageNTSB MIA70OM099Accident · No injuriesClosedLockheed 1049G · La Rioja, ArgentinaJun 7, 1970 · N8021 · DestroyedNTSB CAN71AP901Accident · No injuriesClosedCessna 180A · Campbell Rivr, CanadaMay 13, 1970 · N9656B · Substantial damageNTSB NYC70FYZ01Accident · No injuriesClosedN.American NA-265 · Hannover, GeorgiaApr 25, 1970 · N253MZ · Substantial damageNTSB FTW70DRG39Accident · No injuriesClosedBeech E35 · Buena Vista, MexicoApr 20, 1970 · N3278C · Substantial damageNTSB MIA70DKT15Accident · No injuriesClosedBeech C18S · Sandy Pt, Burkina FasoMar 31, 1970 · N21925 · Substantial damageNTSB FTW70DQD09Accident · No injuriesClosedCessna 180 · San Carlos, MexicoMar 28, 1970 · N4706B · Substantial damageNTSB MIA70DKT12Accident · No injuriesClosedCessna 310 · Freeport, Burkina FasoFeb 26, 1970 · N4885B · Substantial damageNTSB CAN71AQ901Accident · No injuriesClosedBeech D18S · Frobisher Bay, CanadaFeb 16, 1970 · N586PA · Substantial damageNTSB MIA70DKT06Accident · No injuriesClosedBeech D18S · Sn.Andros, Burkina FasoFeb 7, 1970 · N80006 · Substantial damageNTSB MIA70DMD01Accident · No injuriesClosedCessna 337 · Guanaja, HOJan 13, 1970 · N2125X · Substantial damageNTSB UNK70X0109Accident · No injuriesClosedPiper PA-31 · San Lucas, MexicoJan 11, 1970 · N9209Y · Substantial damageNTSB MIA70DKT03Accident · No injuriesClosedBeech D18S · Freeport, Burkina FasoJan 10, 1970 · N44CA · Destroyed