NTSB investigations, 1967, Outside the U.S.

35 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1967, 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\") = 1967
    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 UNK68X0117Accident · No injuriesClosedBellanca 14-13 · Swift River, CanadaDec 24, 1967 · N86734 · Substantial damageNTSB UNK68X0115Incident · No injuriesClosedPiper PA-23 · Caborca, MexicoDec 21, 1967 · N5271Y · Minor damageNTSB UNK68X0112Incident · No injuriesClosedCessna 320 · Navojoa, MexicoDec 1, 1967 · N3019T · Minor damageNTSB UNK68X0111Incident · No injuriesClosedPiper PA-24 · Navojoa, MexicoDec 1, 1967 · N7971P · Minor damageNTSB OAK68F0255Accident · Minor injuriesClosedCessna 150 · Kadena, JANov 25, 1967 · N4087J · DestroyedNTSB MIA68D0318Accident · No injuriesClosedPiper PA-30 · Hawks Nest, Burkina FasoNov 25, 1967 · N8035Y · Substantial damageNTSB UNK68X0108Accident · No injuriesClosedCessna 140 · Egelsbach, GeorgiaNov 16, 1967 · N2211V · Substantial damageNTSB MIA68D0425Accident · No injuriesClosedBeech 95-55 · Corn Is, NiueNov 2, 1967 · N1391Z · Substantial damageNTSB MIA68D0324Accident · No injuriesClosedGrumman G-73 · Freeport, Burkina FasoOct 20, 1967 · N2970 · Substantial damageNTSB LAX68D0247Accident · Serious injuriesClosedCessna 210 · Tres Marias, MexicoSep 24, 1967 · N7461E · Substantial damageNTSB UNK67X0156Accident · 5 fatalClosedDehavilland DHC-2 · Whitewater Lk, CanadaSep 15, 1967 · N2118 · Substantial damageNTSB UNK67X0155Accident · No injuriesClosedBeech C-45 · Hon Quan, VMSep 12, 1967 · N9518Z · Substantial damageNTSB OAK68F0180Accident · No injuriesClosedStinson L-5 · Okuma, JASep 3, 1967 · N9881F · Substantial damageNTSB ANC68O0001Accident · No injuriesClosedGrumman G-21A · Prince Rupert, CanadaAug 30, 1967 · N74588 · Substantial damageNTSB OAK68D0229Accident · No injuriesClosedBeech A55 · Long Tien, LaosAug 29, 1967 · N1313Z · Substantial damageNTSB UNK67X0145Accident · Minor injuriesClosedRepublic RC-3 · Wanapitei Lke, CanadaAug 6, 1967 · N6443K · Substantial damageNTSB UNK67X0143Accident · No injuriesClosedPorter PC-6A · Tra Bong, VMJul 28, 1967 · N285L · Substantial damageNTSB SEA68O0001Accident · No injuriesClosedPiper PA-24 · Tsuniah Lake, CanadaJul 12, 1967 · N7422P · Substantial damageNTSB OAK68O0006Accident · No injuriesClosedBeech A55 · Luang, LaosJun 30, 1967 · N1313Z · Substantial damageNTSB LAX68O0299Accident · No injuriesClosedMooney M-21 · Montemorelos, MexicoJun 25, 1967 · N9316M · Substantial damageNTSB LAX68D0029Accident · No injuriesClosedCessna 310H · Corea, MexicoJun 23, 1967 · N1119Q · Substantial damageNTSB MIA68D0198Accident · No injuriesClosedPiper PA-28 · High Rock, Burkina FasoJun 12, 1967 · N7550W · Substantial damageNTSB FTW68D0034Accident · No injuriesClosedPiper PA-22 · Bahia De La, MexicoMay 27, 1967 · N1982A · Substantial damageNTSB FTW67D0676Accident · No injuriesClosedBellanca 14-19 · Santa Rosalia, MexicoMay 27, 1967 · N8837R · Substantial damageNTSB UNK67X0125Accident · No injuriesClosedChampion 7FC · Sembach, GeorgiaMay 16, 1967 · N9829Y · Substantial damageNTSB OAK68O0005Accident · No injuriesClosedBeech VTB-18 · Vo Cang, VMMay 11, 1967 · N9838Z · Substantial damageNTSB FTW67D0668Incident · No injuriesClosedBeech E35 · Mulege, MexicoApr 30, 1967 · N3328C · Minor damageNTSB OAK68O0004Accident · No injuriesClosedPiper PA-28 · Clark Ab, RPApr 27, 1967 · N6909W · Substantial damageNTSB MIA68D0282Accident · No injuriesClosedBeech C33A · S.Jose, SerbiaApr 6, 1967 · N3722Q · Substantial damageNTSB UNK67X0117Accident · Minor injuriesClosedCessna 310K · Mexico City, MexicoMar 9, 1967 · N3819X · DestroyedNTSB MIA67D0424Accident · Minor injuriesClosedPiper PA-32 · Mayaguana Is. Bwi, Burkina FasoMar 5, 1967 · N4101W · DestroyedNTSB UNK67X0115Accident · No injuriesClosedAero Comdr 680-FL · 6424n 4221w, GreenlandFeb 27, 1967 · N6313U · Substantial damageNTSB FTW67D0546Accident · Minor injuriesClosedCessna 182 · San Felipe, MexicoFeb 4, 1967 · N9068T · Substantial damageNTSB UNK67X0110Accident · No injuriesClosedPiper PA-24 · Mulege, MexicoJan 29, 1967 · N6160P · Substantial damageNTSB CAN F0435Accident · No injuriesClosedCessna 182 · Fort St.John, CanadaJan 15, 1967 · N4782D · Substantial damage