NTSB investigations, 1967, Outside the U.S.

26 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 1967, 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\") = 1967
    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 UNK68X0114Accident · No injuriesClosedCessna 150 · Buckner B Okinawa, JADec 20, 1967 · N2290J · Substantial damageNTSB MIA68O0005Accident · 1 fatalClosedCessna 182 · Apartado, ColombiaNov 19, 1967 · N5506B · DestroyedNTSB LAX68O0361Accident · No injuriesClosedMooney M20E · Mazatlan, MexicoOct 23, 1967 · N1237X · Substantial damageNTSB MIA68D0274Accident · No injuriesClosedLake LA-4 · Bimini, Burkina FasoOct 22, 1967 · N1113L · DestroyedNTSB LAX68O0296Accident · No injuriesClosedCessna 120 · Rosarita Bch, MexicoOct 21, 1967 · N2798N · Substantial damageNTSB UNK68X0104Accident · Serious injuriesClosedPiper PA-23 · Shingle Pt, CanadaOct 13, 1967 · N93411 · Substantial damageNTSB UNK67X0160Accident · Serious injuriesClosedPorter PC-6C · Ta Vieng, LaosSep 30, 1967 · N197X · Substantial damageNTSB OAK68A0031Accident · Serious injuriesClosedBoeing 707 · Ubon, ThailandSep 29, 1967 · N417PA · No damageNTSB UNK67X0157Accident · No injuriesClosedBell 47G3B1 · Dhahran, Saudi ArabiaSep 20, 1967 · N1341X · DestroyedNTSB MIA68O0002Accident · No injuriesClosedBell 206A · Andros Tw, Burkina FasoSep 7, 1967 · N7827S · Substantial damageNTSB MIA68O0001Accident · No injuriesClosedHiller UH12E4 · Santa Fe, RPAug 29, 1967 · N44B · DestroyedNTSB UNK67X0149Accident · 4 fatalClosedBeech C-45 · Danang, VMAug 21, 1967 · N9475Z · DestroyedNTSB OAK68A0013Accident · Serious injuriesClosedBoeing 707 · Manila, RPAug 18, 1967 · N17322 · No damageNTSB OAK68D0234Accident · Serious injuriesClosedCurtis-Wrt C-46 · Phu Cum, LaosAug 13, 1967 · N9473Z · DestroyedNTSB UNK67X0136Accident · Serious injuriesClosedRepublic RC-3 · Thaddeus Lake, CanadaJul 6, 1967 · N6058K · Substantial damageNTSB UNK67X0131Accident · No injuriesClosedBeech C-45 · Udorn, ThailandJun 18, 1967 · N9577Z · Substantial damageNTSB FTW68O0077Accident · Minor injuriesClosedBellanca 14-19 · Point Chivato, MexicoMay 21, 1967 · N7669B · Substantial damageNTSB FTW67D0673Accident · No injuriesClosedCessna 172 · San Lucas, MexicoMay 17, 1967 · N2383U · Substantial damageNTSB UNK67X0123Accident · Minor injuriesClosedPilatus PC-6C · B.Chanuman, ThailandApr 11, 1967 · N153L · Substantial damageNTSB UNK67X0120Accident · No injuriesClosedPilatus PC-6C · Saigon, VMMar 29, 1967 · N9444 · Substantial damageNTSB MIA67S0008Incident · No injuriesClosedDouglas DC-8 · Port Of Spain Wi, SPMar 6, 1967 · N806PA · Minor damageNTSB UNK67X0116Accident · No injuriesClosedLockheed 402-2 · Gusman Jal., MexicoFeb 28, 1967 · N3382G · Substantial damageNTSB UNK67X0114Accident · No injuriesClosedCessna 175 · San Felipe, MexicoFeb 24, 1967 · N7677M · Substantial damageNTSB UNK67X0111Accident · Serious injuriesClosedBell 204-B · Ghinnir, EthiopiaFeb 10, 1967 · N1901R · DestroyedNTSB OAK67O0061Accident · No injuriesClosedLockheed 1049H · Da Nang, VMFeb 10, 1967 · N6924C · Substantial damageNTSB UNK67X0108Accident · 1 fatalClosedBeech 18 · Plumpton, United KingdomJan 18, 1967 · N102S · Destroyed