# NTSB investigations, Outside the U.S.: Uncontrolled descent

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 GAA25WA176](https://openairdocs.org/ntsb/GAA25WA176.md): Socata TB 20 · Vaduleni, Moldova · Accident · 1 fatal · Class 5 · Foreign · Oct 27, 2024 · D-EMRT · Destroyed
- [NTSB GAA24WA250](https://openairdocs.org/ntsb/GAA24WA250.md): Beech 95A55 · Birigui, Brazil · Accident · 3 fatal · Class 5 · Foreign · Aug 3, 2024 · PS-RCM · Destroyed
- [NTSB ENG15WA040](https://openairdocs.org/ntsb/ENG15WA040.md): Bell 407 · Morobe Province, Papua New Guinea · Incident · No injuries · Foreign investigation · May 2, 2015 · P2-HSL · No damage
  > On May 2, 2015, a Bell Helicopters 407 powered by a Roll-Royce M250-C47B turboshaft experienced an unexpected uncommanded high rate of descent while on approach to the helipad with an external load of two diesel fuel drums. The pilot jettisoned his load and…
- [NTSB CEN15WA152](https://openairdocs.org/ntsb/CEN15WA152.md): Avions Robin Robin DR 400/140 B · Yverdon LSGY, Switzerland · Accident · 2 fatal · Foreign investigation · Feb 23, 2015 · HB-KDD · Destroyed
- [NTSB ERA10WA116](https://openairdocs.org/ntsb/ERA10WA116.md): Piper PA-32-300 · Bimini, Bahamas, Bahamas · Accident · 3 fatal · Foreign investigation · Jan 17, 2010 · N4219R · Destroyed
  > On January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…
- [NTSB ERA09WA166](https://openairdocs.org/ntsb/ERA09WA166.md): Embraer EMB110 · Coari, Brazil · Accident · 24 fatal · Foreign investigation · Feb 7, 2009 · PR-SAE · Destroyed
  > On February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…
- [NTSB MIA77FA069](https://openairdocs.org/ntsb/MIA77FA069.md): Piper PA-32 · Andros Is, Burkina Faso · Accident · 2 fatal · Closed · Jul 16, 1977 · N4434F · Destroyed
- [NTSB MIA77RA039](https://openairdocs.org/ntsb/MIA77RA039.md): Cessna 402 · Stirrup, Burkina Faso · Accident · 4 fatal · Closed · Mar 5, 1977 · N69378 · Destroyed
- [NTSB LAX74OL033](https://openairdocs.org/ntsb/LAX74OL033.md): Sikorsky S-62A · Requena, Peru · Accident · 9 fatal · Closed · Oct 11, 1973 · N316Y · Substantial damage
- [NTSB OAK72FJY14](https://openairdocs.org/ntsb/OAK72FJY14.md): Beech 23 · Castillejos, RP · Accident · 2 fatal · Closed · Mar 10, 1972 · N3786 · Destroyed
- [NTSB MIA72AM040](https://openairdocs.org/ntsb/MIA72AM040.md): Lockheed 1049H · Gt.Inagua, Burkina Faso · Accident · 4 fatal · Closed · Oct 20, 1971 · N564E · Destroyed
- [NTSB MIA71OM015](https://openairdocs.org/ntsb/MIA71OM015.md): Mooney M20C · C.Engano, DR · Accident · 2 fatal · Closed · Aug 12, 1970 · N7102U · Destroyed
- [NTSB UNK69X0102](https://openairdocs.org/ntsb/UNK69X0102.md): Dornier DO-28D · Sonderborg, DA · Accident · 1 fatal · Closed · Dec 6, 1968 · N7154 · Destroyed
- [NTSB UNK67X0134](https://openairdocs.org/ntsb/UNK67X0134.md): Bell 47G-4 · Ecuador, Ecuador · Accident · Minor injuries · Closed · Jul 2, 1967 · N6753D · Substantial damage
- [NTSB UNK66X0156](https://openairdocs.org/ntsb/UNK66X0156.md): Bell 47G-5 · Episkopi, Greece · Accident · No injuries · Closed · Jul 12, 1966 · N8574F · Destroyed
- [NTSB UNK65X1537](https://openairdocs.org/ntsb/UNK65X1537.md): Beechcraft C-45H · Bao Trai, VM · Accident · 3 fatal · Closed · Sep 27, 1965 · N9574Z · Destroyed
- [NTSB UNK65X1474](https://openairdocs.org/ntsb/UNK65X1474.md): Douglas DC-3 · Waterville, Canada · Accident · 2 fatal · Closed · Mar 18, 1965 · N4997E · Destroyed

## 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 c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 650)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.