# NTSB investigations, 1973, Outside the U.S.: Enroute

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB OAK74DJY09](https://openairdocs.org/ntsb/OAK74DJY09.md): Cessna 150 · Tagaytay City, RP · Accident · 2 fatal · Closed · Dec 22, 1973 · N21963 · Destroyed
- [NTSB MIA74AM054](https://openairdocs.org/ntsb/MIA74AM054.md): Lake L4-200 · Bimini, Burkina Faso · Accident · 3 fatal · Closed · Dec 20, 1973 · N39385 · Destroyed
- [NTSB MIA740KT47](https://openairdocs.org/ntsb/MIA740KT47.md): Cessna 402 · San Vicente, Mexico · Accident · No injuries · Closed · Nov 29, 1973 · N111RN · Destroyed
- [NTSB FTW74DRG40](https://openairdocs.org/ntsb/FTW74DRG40.md): Piper PA-28 · Mexico City, Mexico · Accident · Serious injuries · Closed · Nov 29, 1973 · N5872U · Destroyed
- [NTSB MIA74DKT22](https://openairdocs.org/ntsb/MIA74DKT22.md): Aero Comdr 500S · Andros Isl, Burkina Faso · Accident · No injuries · Closed · Sep 26, 1973 · N69NP · Destroyed
- [NTSB OAK74DJY03](https://openairdocs.org/ntsb/OAK74DJY03.md): Beech C-45H · Phan Rang, VM · Accident · No injuries · Closed · Sep 20, 1973 · N9157Z · Substantial damage
- [NTSB MIA74AM041](https://openairdocs.org/ntsb/MIA74AM041.md): Lockheed L-1011 · Grnd Turk Is, Burkina Faso · Accident · Serious injuries · Closed · Aug 25, 1973 · N318EA · No damage
- [NTSB MIA74OKT63](https://openairdocs.org/ntsb/MIA74OKT63.md): Norman BN-2A · Don Don, HA · Accident · 10 fatal · Closed · Aug 15, 1973 · N38JA · Destroyed
- [NTSB UNK73X0120](https://openairdocs.org/ntsb/UNK73X0120.md): Cessna 182 · Malaga, SP · Accident · Serious injuries · Closed · Aug 9, 1973 · N3957D · Substantial damage
- [NTSB UNK73X0116](https://openairdocs.org/ntsb/UNK73X0116.md): Piper PA-24 · Riske Crk, Canada · Accident · No injuries · Closed · Jun 30, 1973 · N6330P · Substantial damage
- [NTSB FTW73DQG43](https://openairdocs.org/ntsb/FTW73DQG43.md): Mitsubishi MU-2B · Cedillos C, Mexico · Accident · 2 fatal · Closed · Jun 13, 1973 · N882Q · Destroyed
- [NTSB MIA73RM100](https://openairdocs.org/ntsb/MIA73RM100.md): Lockheed L18 · Chub Cay, Burkina Faso · Accident · 2 fatal · Closed · May 6, 1973 · N620S · Destroyed
- [NTSB LAX730L013](https://openairdocs.org/ntsb/LAX730L013.md): Cessna 182 · San Louis, Mexico · Accident · No injuries · Closed · Mar 31, 1973 · N9382G · Substantial damage
- [NTSB UNK73X0108](https://openairdocs.org/ntsb/UNK73X0108.md): Douglas DC-8 · Lands End, United Kingdom · Incident · Minor injuries · Closed · Mar 12, 1973 · N801WA · No damage
- [NTSB OAK73FJZ03](https://openairdocs.org/ntsb/OAK73FJZ03.md): Cessna 150 · Kashima Isl, JA · Accident · Serious injuries · Closed · Jan 29, 1973 · N6772G · Substantial damage
- [NTSB OAK73DVD46](https://openairdocs.org/ntsb/OAK73DVD46.md): Piper PA-23 · Canada Honda, Mexico · Accident · No injuries · Closed · Jan 6, 1973 · N2093P · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 1973
  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
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?state=OF&year=1973

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
