NTSB investigations, 1964, Outside the U.S.

38 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1964, 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\") = 1964
    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 UNK65X1120Accident · No injuriesClosedBeechcraft R-35 · Utila Is, HODec 24, 1964 · N9713F · Substantial damageNTSB UNK65X1096Accident · Minor injuriesClosedAeronca 11BC · Ft Francis, CanadaDec 22, 1964 · N86236 · Substantial damageNTSB UNK65X0862Accident · No injuriesClosedCessna 182 · San Quintin, MexicoNov 27, 1964 · N9095X · Substantial damageNTSB UNK65X0682Accident · No injuriesClosedTaylorcraft BC-12D · Nellingen, GeorgiaNov 13, 1964 · N96259 · Substantial damageNTSB UNK65X0527Accident · No injuriesClosedAero Cmdr 680 · Baja Calif, MexicoNov 2, 1964 · N6217D · Substantial damageNTSB UNK65X0336Accident · No injuriesClosedDornier 28A1 · Thathom, LaosOct 19, 1964 · N4222G · Substantial damageNTSB UNK65X0335Accident · No injuriesClosedCessna 205 · Ragged Is, Burkina FasoOct 19, 1964 · N4808U · DestroyedNTSB UNK65X0159Accident · No injuriesClosedPiper PA-23 · Nairobi E Africa, KenyaOct 6, 1964 · N616F · Substantial damageNTSB UNK65X0101Accident · No injuriesClosedCessna 180 · Aira, EthiopiaOct 1, 1964 · N5053E · Substantial damageNTSB UNK64X3992Accident · No injuriesClosedPiper PA-24 · Baja, MexicoSep 15, 1964 · N7610P · Substantial damageNTSB UNK64X3879Accident · No injuriesClosedCessna 180B · St Pierre, CanadaSep 9, 1964 · N9134R · DestroyedNTSB UNK64X3619Accident · No injuriesClosedPine Air Superv · Penticton Bc, CanadaAug 27, 1964 · N3124V · Substantial damageNTSB UNK64X3114Accident · Minor injuriesClosedStinson 108-1 · Mulege Baja, MexicoJul 30, 1964 · N801 · DestroyedNTSB UNK64X3097Accident · No injuriesClosedBeechcraft C-18S · West End Grd Baha, Burkina FasoJul 29, 1964 · N6691C · Substantial damageNTSB UNK64X3075Accident · No injuriesClosedLockheed PV-2 · Aruba Antilles, AAJul 27, 1964 · N7270C · Substantial damageNTSB UNK64X2574Accident · No injuriesClosedLockheed L-18 · St Maria Azores, POJun 30, 1964 · N280Y · Substantial damageNTSB UNK64X2362Accident · No injuriesClosedCessna 172 · Anglemont Bc, CanadaJun 19, 1964 · N3578S · Substantial damageNTSB UNK64X2276Accident · No injuriesClosedCessna 180 · Haines Jct, CanadaJun 14, 1964 · N2932A · Substantial damageNTSB UNK64X2185Accident · No injuriesClosedPiper PA-24 · Quatro Palms, MexicoJun 8, 1964 · N7857P · DestroyedNTSB UNK64X2121Accident · No injuriesClosedBeechraft D-35 · Baja Calif, MexicoJun 5, 1964 · N2993B · Substantial damageNTSB UNK64X2041Accident · No injuriesClosedCessna 170B · Kenora, CanadaMay 31, 1964 · N4360B · Substantial damageNTSB UNK64X1997Accident · No injuriesClosedPiper PA-18 · Clark Field, RPMay 29, 1964 · N8076D · Substantial damageNTSB UNK64X1711Accident · Minor injuriesClosedBeechraft M-35 · San Lucas, MexicoMay 10, 1964 · N9339Y · Substantial damageNTSB UNK64X1710Accident · No injuriesClosedCessna 195 · Baja Calif, MexicoMay 10, 1964 · N2165C · Substantial damageNTSB UNK64X1418Accident · No injuriesClosedBeechraft J-35 · Hermosillo, MexicoApr 23, 1964 · N7245B · Substantial damageNTSB UNK64X1154Accident · No injuriesClosedDouglas DC-3 · Symours, Burkina FasoApr 4, 1964 · N821C · Substantial damageNTSB UNK64X1138Accident · No injuriesClosedDornier DO28A1 · Moung Hiem, LaosApr 3, 1964 · N4228G · Substantial damageNTSB UNK64X1131Accident · No injuriesClosedBeechraft 35 · El Rosario, MexicoApr 2, 1964 · N495T · Substantial damageNTSB UNK64X1039Accident · No injuriesClosedAero Cmdr 520 · Grand Bahamas, Burkina FasoMar 26, 1964 · N1952 · Substantial damageNTSB UNK64X0879Accident · No injuriesClosedDehavilland DH104 · Cabo San Lucas, MexicoMar 11, 1964 · N1579V · Substantial damageNTSB UNK64X0803Accident · Minor injuriesClosedBellanca 14-19 · Valledupar, ColombiaMar 4, 1964 · N4964V · Substantial damageNTSB NYC64I0104Incident · No injuriesClosedCanadair CL-44 · Gander Newfoundld, CanadaFeb 11, 1964 · N229SW · Minor damageNTSB UNK64X0407Accident · No injuriesClosedCessna 205 · Baja Calif, MexicoJan 31, 1964 · N8236Z · Substantial damageNTSB UNK64X0379Accident · No injuriesClosedPiper PA-24 · Mexicali, MexicoJan 27, 1964 · N8050P · Substantial damageNTSB UNK64X0324Accident · No injuriesClosedCessna 210 · Durango, MexicoJan 23, 1964 · N9629T · Substantial damageNTSB UNK64X0309Accident · No injuriesClosedBeechcraft D-18S · Africa, LibyaJan 21, 1964 · N178L · Substantial damageNTSB UNK64X0196Accident · No injuriesClosedNavion G · Mazatlan, MexicoJan 9, 1964 · N2428T · Substantial damageNTSB UNK64X0124Accident · No injuriesClosedPiper PA-24 · Toluca, MexicoJan 3, 1964 · N6934P · Substantial damage