# NTSB investigations, 2010, Outside the U.S.: Approach

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 ERA11WA098](https://openairdocs.org/ntsb/ERA11WA098.md): Bell 206 · Aracuju, Brazil · Accident · 1 fatal · Foreign investigation · Dec 21, 2010 · PR-HQB · Substantial damage
  > On December 21, 2010, about 1300 universal coordinated time, a Bell 206B, Brazilian registration PR-HQB, during an approach for landing; encountered a strong wind gust, impacted the terrain, and was substantially damaged in Aracaju, Segripe, Brazil. The pilot…
- [NTSB ERA11WA090](https://openairdocs.org/ntsb/ERA11WA090.md): Hawker Beechcraft TC-45J · Nassau, Bahamas · Accident · 2 fatal · Foreign investigation · Dec 14, 2010 · N38L · Destroyed
  > On December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…
- [NTSB DCA11WA003](https://openairdocs.org/ntsb/DCA11WA003.md): Lockheed L-100 · Kabul, Afghanistan · Accident · 8 fatal · Foreign investigation · Oct 12, 2010 · 5X-TUC · Destroyed
  > On October 12, 2010, about 1505 UTC, a Trans Afrique Airlines (under contract to National Air Cargo) Lockheed L-100, registration 5X-TUC, impacted terrain while maneuvering to land at Kabul International Airport (OAKB), Kabul Afghanistan. The two flight crew…
- [NTSB ERA10WA498](https://openairdocs.org/ntsb/ERA10WA498.md): Aero Commander 500 · Santo Domingo, Dominican Republic · Accident · Minor injuries · Foreign investigation · Sep 23, 2010 · N100PV · Substantial damage
- [NTSB ERA10WA443](https://openairdocs.org/ntsb/ERA10WA443.md): Embraer EMB145 LU · Bahia, Brazil · Accident · No injuries · Foreign investigation · Aug 25, 2010 · PR-PSJ · Substantial damage
  > On August 25, 2010, about 1741 Universal Coordinated Time (UTC), an Embraer EMB-145 LU, Brazilian registration PR-PSJ, operated by Passaredo Transportes Aereos LTDA, on a commercial flight, was substantially damaged, when it landed short of the runway during…
- [NTSB ENG10RA025](https://openairdocs.org/ntsb/ENG10RA025.md): Tupolev TU154 · Smolensk, Russia · Accident · 89 fatal · Foreign investigation · Apr 10, 2010 · N101 · Destroyed
  > On April 10, 2010, about 0656 Coordinated Universal Time (UTC), a Tupolev Tu-154M, Tail Number 101, operated by the Polish Air Force as flight PLF101, crashed during approach to the Military Aerodrom Smolensk "Severnyi", Russia. All 89 passengers and 7…
- [NTSB CEN10RA133](https://openairdocs.org/ntsb/CEN10RA133.md): Cessna 206 · San Pedro, Belize · Accident · 5 fatal · Foreign investigation · Feb 26, 2010 · V3-HDR · 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") = 2010
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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