NTSB investigations, 1964, Outside the U.S.

23 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 1964, Outside the U.S. per year, 1962–2026: 1,774 cases
19623
19632
196423
196521
196618
196726
19689
196922
197015
197111
197219
197316
197414
197519
19763
19778
19788
19794
19812
19823
19843
19861
19871
19886
19891
19901
19912
19941
19972
19981
20001
20022
20032
20041
20071
200810
200930
201031
201139
201253
201357
201451
201571
201689
201777
2018100
2019124
202071
2021119
2022106
2023112
2024152
2025138
202672

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 = 400)
  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 UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNDec 6, 1964 · N1420P · Substantial damageNTSB UNK65X0694Accident · No injuriesClosedCessna 170 · Onna Pt Okinawa, JANov 14, 1964 · N3906V · DestroyedNTSB UNK65X0550Accident · No injuriesClosedCessna 182A · Sonora, MexicoNov 4, 1964 · N2590G · Substantial damageNTSB UNK65X0341Accident · No injuriesClosedNo American F51D · Corinto, NiueOct 20, 1964 · N6162U · DestroyedNTSB UNK65X0228Accident · Minor injuriesClosedNavion B · Ottawa, CanadaOct 11, 1964 · N5229K · Substantial damageNTSB UNK64X4150Accident · No injuriesClosedRepublic F-47N · La Marina Riv, MexicoSep 26, 1964 · N6148U · Substantial damageNTSB FTWSP 0002Accident · 3 fatalClosedCessna 182 · Coahuila, MexicoSep 16, 1964 · N5959B · DestroyedNTSB UNK64X3656Accident · Minor injuriesClosedCessna 175 · West End Grd Baha, Burkina FasoAug 29, 1964 · N6569E · DestroyedNTSB UNK64X3553Accident · 4 fatalClosedCessna 180 · Baja, MexicoAug 23, 1964 · N9129C · DestroyedNTSB UNK64X3386Accident · 2 fatalClosedPiper PA-28 · Lake Athabaska, CanadaAug 15, 1964 · N5343W · DestroyedNTSB UNK64X2870Accident · 4 fatalClosedCessna 180 · Jamestown, CanadaJul 17, 1964 · N9212C · DestroyedNTSB UNK64X2629Accident · 3 fatalClosedBeechraft 23 · Linton Que, CanadaJul 4, 1964 · N2379J · DestroyedNTSB UNK64X2255Accident · No injuriesClosedNorth AM F-51 · Mateare, NiueJun 13, 1964 · N6170U · Substantial damageNTSB UNK64X1887Accident · 7 fatalClosedPiper PA-23 · Ciudad Victor, MexicoMay 22, 1964 · N5211Y · DestroyedNTSB UNK64X1852Accident · No injuriesClosedBeechraft C-45F · Bimini, Burkina FasoMay 19, 1964 · N8015H · DestroyedNTSB UNK64X1517Accident · No injuriesClosedCessna 170B · San Telmo, MexicoApr 30, 1964 · N49F · Substantial damageNTSB UNK64X1462Accident · Minor injuriesClosedHughes 269A · Madrid, SPApr 26, 1964 · N8912F · Substantial damageNTSB UNK64X1270Accident · Serious injuriesClosedDouglas DC-6B · San Jose, SerbiaApr 11, 1964 · N6520C · Substantial damageNTSB UNK64X1012Incident · Minor injuriesClosedDouglas DC-8 · Buenos Aires, ArgentinaMar 22, 1964 · N8276H · No damageNTSB UNK64X0643Accident · No injuriesClosedAeronca 7AC · Bonanza, SPFeb 22, 1964 · N2449E · Substantial damageNTSB UNK64X0582Accident · No injuriesClosedTaylorcraft BC12D · Cien Fuegos, CubaFeb 16, 1964 · N5103M · DestroyedNTSB UNK64X0474Accident · 87 fatalClosedDouglas DC-6B · Santiago, Côte d’IvoireFeb 6, 1964 · CH1 · DestroyedNTSB UNK64X0323Accident · No injuriesClosedCessna 182 · Muleje, MexicoJan 23, 1964 · N3195Y · Substantial damage