NTSB investigations, 1965, Outside the U.S.

37 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1965, 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\") = 1965
    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 UNK66X0114Accident · No injuriesClosedCessna 210 · Ft Williams, CanadaDec 7, 1965 · N4918U · Substantial damageNTSB FTW66S0002Accident · 2 fatalClosedErco 415-C · Saltillo, MexicoNov 28, 1965 · N94332NTSB MIA66D0356Accident · No injuriesClosedCessna 150 · West End, Burkina FasoNov 24, 1965 · N6200T · Substantial damageNTSB UNK66X0108Accident · No injuriesClosedBeech 65 · Franfurt, GeorgiaNov 4, 1965 · N141 · Substantial damageNTSB UNK66X0107Accident · No injuriesClosedDehaviland DHC-2 · El Adem, LibyaOct 31, 1965 · N7904C · Substantial damageNTSB CAN65C0038Accident · No injuriesClosedBeech 35 · Dryden Ont., CanadaOct 20, 1965 · N3007V · Substantial damageNTSB UNK66X0104Accident · No injuriesClosedGrumman G-164 · Wad Ek Mansi, RussiaOct 15, 1965 · N625U · Substantial damageNTSB FTW66D0401Accident · No injuriesClosedBeechcraft 35 · Mazatlan, MexicoOct 15, 1965 · N2800V · Substantial damageNTSB UNK66X0100Accident · No injuriesClosedCessna 210 · Sinaloa, MexicoOct 3, 1965 · N9672T · Substantial damageNTSB UNK65X1538Accident · No injuriesClosedBeech A23 · Wallacebrg, CanadaSep 30, 1965 · N8886M · Substantial damageNTSB OAK66D0112Accident · No injuriesClosedTaylorcraft BC-12D · Yomitan Okinawa, JASep 25, 1965 · N34062 · Substantial damageNTSB FTW66A0028Accident · No injuriesClosedBoeing B-720 · Mexico City, MexicoSep 11, 1965 · N7078 · Substantial damageNTSB UNK65X1524Accident · No injuriesClosedGrumman JRF-5 · Hay River, CanadaAug 5, 1965 · N749 · Substantial damageNTSB UNK65X1521Accident · No injuriesClosedBeechcraft P-35 · Chihuahua, MexicoAug 2, 1965 · N9675Y · Substantial damageNTSB UNK65X1520Accident · No injuriesClosedBeechcraft F-35 · Walkers Cay, Burkina FasoJul 29, 1965 · N72JC · DestroyedNTSB UNK65X1515Accident · No injuriesClosedPiper PA-28 · Tascha Lake, CanadaJul 7, 1965 · N8644W · Substantial damageNTSB UNK65X1513Accident · No injuriesClosedMooney M20A · Scum Lake Bc, CanadaJul 4, 1965 · N1090B · Substantial damageNTSB DEN66D0047Accident · No injuriesClosedPiper PA-28 · Bahia Kino, MexicoJul 3, 1965 · N8947W · Substantial damageNTSB UNK65X1511Accident · No injuriesClosedPiper PA-28 · Coyame Chuaha, MexicoJul 2, 1965 · N7869W · Substantial damageNTSB UNK65X1506Accident · No injuriesClosedCessna 182 · Ensenada, MexicoJun 26, 1965 · N6139B · DestroyedNTSB UNK65X1501Accident · No injuriesClosedCessna 337 · Nuevo Laredo, MexicoJun 14, 1965 · N2122X · Substantial damageNTSB UNK65X1500Incident · No injuriesClosedDouglas DC-8 · Santiago Chile Sa, Côte d’IvoireJun 14, 1965 · N8274H · Minor damageNTSB UNK65X1499Accident · No injuriesClosedCessna 180 · Mexicali, MexicoJun 13, 1965 · N9002C · Substantial damageNTSB MKC66D0122Accident · Minor injuriesClosedLake LA-4 · Lac La Croix, CanadaMay 18, 1965 · N1128L · Substantial damageNTSB UNK65X1491Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoMay 1, 1965 · N8679W · Substantial damageNTSB UNK65X1490Accident · No injuriesClosedMooney M21 · Freeport, Burkina FasoApr 30, 1965 · N7836V · Substantial damageNTSB UNK65X1489Accident · Minor injuriesClosedCessna 182 · De Los Angels, MexicoApr 24, 1965 · N8572T · Substantial damageNTSB MIA66S0007Accident · No injuriesClosedBoeing 707 · Merida, MexicoApr 23, 1965 · N710PA · Substantial damageNTSB LAX66D0084Accident · No injuriesClosedCessna 182 · Mulege, MexicoApr 12, 1965 · N1834X · Substantial damageNTSB OAK65A0061Accident · No injuriesClosedBoeing 707 321 · Saigon, VMMar 26, 1965 · N716PA · Substantial damageNTSB UNK65X1476Accident · No injuriesClosedMooney M20 · Mulege, MexicoMar 18, 1965 · N6690U · Substantial damageNTSB UNK65X1475Accident · No injuriesClosedCessna 210 · Kitchener, CanadaMar 18, 1965 · N9648X · Substantial damageNTSB UNK65X1466Accident · No injuriesClosedMooney M21 · Tesapoco, MexicoMar 5, 1965 · N74956 · Substantial damageNTSB UNK65X1452Accident · No injuriesClosedBeechcraft E18S · San Lucas, MexicoFeb 24, 1965 · N952F · DestroyedNTSB UNK65X1451Accident · No injuriesClosedPiper PA-18 · Kitaka Afri, KenyaFeb 24, 1965 · N39782 · Substantial damageNTSB UNK65X1443Accident · Minor injuriesClosedCessna 120 · Kalarskona Lk, CanadaFeb 21, 1965 · N3134N · Substantial damageNTSB UNK65X1409Accident · No injuriesClosedBeechcraft A-35 · Caicos Is, Burkina FasoFeb 8, 1965 · N1875A · Substantial damage