NTSB investigations, 1966, Outside the U.S.

40 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1966, 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\") = 1966
    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 MIA67D0367Accident · No injuriesClosedCessna 172 · Duncan Town, Burkina FasoDec 29, 1966 · N1352Y · Substantial damageNTSB MIA67D0371Accident · No injuriesClosedBeech C-18S · Tortola Br., U.S. Virgin IslandsNov 24, 1966 · N6402C · DestroyedNTSB FTW67D0350Accident · Minor injuriesClosedMooney M20E · Chihuahua, MexicoNov 20, 1966 · N2746W · Substantial damageNTSB FTW67D0283Accident · No injuriesClosedCessna 310 · San Pedro, MexicoOct 27, 1966 · N158B · Substantial damageNTSB UNK67X0103Accident · No injuriesClosedCessna 185 · Spout Lake, CanadaOct 14, 1966 · N1537F · Substantial damageNTSB OAK67D0097Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoOct 1, 1966 · N9283J · Substantial damageNTSB MIA67D0234Accident · No injuriesClosedPiper PA-24 · Bimini, Burkina FasoSep 28, 1966 · N5136P · Substantial damageNTSB UNK66X0174Accident · No injuriesClosedBeech S35 · Cananea, MexicoSep 16, 1966 · N5803K · Substantial damageNTSB UNK66X0167Accident · No injuriesClosedCessna 182 · Williams Lak, CanadaAug 28, 1966 · N6446A · Substantial damageNTSB FTW67D0206Accident · No injuriesClosedCessna 210B · Tamaulipas, MexicoAug 24, 1966 · N9594X · Substantial damageNTSB DCA67S0001Accident · No injuriesClosedLockheed 749A · Tachikawa, JAAug 15, 1966 · N65 · Substantial damageNTSB LAX67D0131Accident · No injuriesClosedCessna 120 · Guaymas, MexicoAug 8, 1966 · N76231 · Substantial damageNTSB UNK66X0162Accident · No injuriesClosedCessna 172 · Suffolk, United KingdomAug 6, 1966 · N9188B · Substantial damageNTSB UNK66X0160Accident · No injuriesClosedCessna 180 · Simunjan Sarawak, MalaysiaAug 3, 1966 · N3685C · Substantial damageNTSB FTW67D0165Accident · No injuriesClosedCessna 210 · Zacatecas, MexicoJul 13, 1966 · N7316E · Substantial damageNTSB CAN F0406Accident · No injuriesClosedEssna 182 · Tsuniah Lake, CanadaJul 9, 1966 · N6253A · Substantial damageNTSB UNK66X0155Accident · No injuriesClosedCessna 310 · Eagle River, CanadaJul 6, 1966 · N5251A · Substantial damageNTSB UNK66X0154Accident · No injuriesClosedCessna 185A · Benghazi, LibyaJul 5, 1966 · N4053Y · Substantial damageNTSB FTW67D0102Accident · No injuriesClosedBeech D35 · Muleje, MexicoJul 5, 1966 · N2993B · Substantial damageNTSB FTW67D0082Accident · No injuriesClosedPiper PA-23 · Baboragama, MexicoJul 1, 1966 · N5268Y · Substantial damageNTSB UNK66X0152Accident · No injuriesClosedBellanca 14-132 · Scum Lake, CanadaJun 25, 1966 · N74414 · Substantial damageNTSB UNK66X0151Accident · No injuriesClosedCessna 172 · Parrsboro, CanadaJun 25, 1966 · N2474Y · Substantial damageNTSB UNK66X0144Accident · No injuriesClosedBeech V35 · Tsuniah Lodge, CanadaMay 26, 1966 · N5620S · Substantial damageNTSB UNK66X0143Accident · No injuriesClosedPiper PA-28 · Clark Air Base, RPMay 24, 1966 · N6809N · Substantial damageNTSB CAN F0393Accident · No injuriesClosedCessna 120 · Yukon Territy, CanadaMay 16, 1966 · N2041V · Substantial damageNTSB FTW67D0003Accident · No injuriesClosedCessna 182 · El Pilar, MexicoMay 6, 1966 · N8797T · Substantial damageNTSB UNK66X0140Accident · Minor injuriesClosedBeech M35 · Chlkoot Ps, CanadaMay 3, 1966 · N9341Y · Substantial damageNTSB UNK66X0138Accident · No injuriesClosedCessna 182 · Mulege Baja Calif, MexicoApr 19, 1966 · N2464R · Substantial damageNTSB FTW67D0420Accident · Minor injuriesClosedCessna 206 · Merida, MexicoApr 17, 1966 · N2196F · DestroyedNTSB MIA67D0360Accident · No injuriesClosedCessna 310C · Nassau, Burkina FasoApr 12, 1966 · N1884H · Substantial damageNTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoApr 8, 1966 · N8305U · Substantial damageNTSB UNK66X0135Accident · No injuriesClosedBeech 35 · Baja Calif, MexicoApr 7, 1966 · N2725Y · Substantial damageNTSB UNK66X0134Accident · No injuriesClosedCessna 182 · Tiburon Is., MexicoApr 2, 1966 · N3510U · Substantial damageNTSB UNK66X0127Accident · No injuriesClosedCessna 180 · El Socorro, MexicoMar 4, 1966 · N1584C · Substantial damageNTSB MIA66D0497Accident · No injuriesClosedBeech D-18S · St Maarten Na, NTFeb 25, 1966 · N6787C · Substantial damageNTSB UNK66X0123Accident · No injuriesClosedCessna 337 · Monterrey, MexicoFeb 24, 1966 · N2113X · Substantial damageNTSB DEN66D0262Accident · No injuriesClosedCessna 180 · Llano, MexicoFeb 23, 1966 · N7720A · Substantial damageNTSB NYC66I0090Incident · No injuriesClosedBoeing B-720B · Merida, MexicoFeb 18, 1966 · N784PA · Minor damageNTSB UNK66X0121Accident · No injuriesClosedPiper PA-28 · San Felipe, MexicoFeb 5, 1966 · N8866J · Substantial damageNTSB UNK66X0120Accident · No injuriesClosedCessna 182 · Mulege, MexicoJan 22, 1966 · N3141U · Substantial damage