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

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 ERA11WA031](https://openairdocs.org/ntsb/ERA11WA031.md): Cessna TU206G · Medellin, Colombia · Accident · 5 fatal · Foreign investigation · Oct 20, 2010 · HK2933 · Destroyed
  > On October 20, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna TU206G, Columbian registration HK2933, was destroyed by fire after crashing in Path Shipyards, Medellin, Columbia. The flight was en route from Medellin, (SKMD), to Fort Vigia,…
- [NTSB WPR11WA020](https://openairdocs.org/ntsb/WPR11WA020.md): Cessna 172 · Durham Downs, Australia, Australia · Accident · 2 fatal · Foreign investigation · Oct 18, 2010 · VH-VSK · Substantial damage
  > On October 18, 2010, at 1230 universal coordinated time, a Cessna 172S, VH-VSK, collided with the terrain near Durham Downs, Australia. The airplane was operated by S. Kidman & Co LTD. The pilot and passenger were killed and the airplane was substantially…
- [NTSB ERA11WA041](https://openairdocs.org/ntsb/ERA11WA041.md): Piper PA38 · Buenos Aires, Argentina · Accident · 2 fatal · Foreign investigation · Oct 3, 2010 · LV-MNO · Substantial damage
  > On October 3, 2010, about 1920 Universal Coordinated Time (UTC), a Piper PA-A-38-112, Argentinean registration LV-MNO, crashed into terrain during an instructional flight near Marcos Paz, Argentina. The local training flight originated from San Fernando…
- [NTSB CEN12WA547](https://openairdocs.org/ntsb/CEN12WA547.md): Beech D55 · Cabo San Lucas, Mexico · Accident · 2 fatal · Foreign investigation · Sep 25, 2010 · N91HV · Substantial damage
- [NTSB ANC10WA073](https://openairdocs.org/ntsb/ANC10WA073.md): Beech B36TC · Peace River, Canada · Accident · 1 fatal · Foreign investigation · Jul 24, 2010 · N64631 · Substantial damage
- [NTSB WPR10WA321](https://openairdocs.org/ntsb/WPR10WA321.md): Erickson S64E · Borneo Island, Indonesia · Accident · 1 fatal · Foreign investigation · Jun 25, 2010 · N229AC · Substantial damage
- [NTSB ERA10WA327](https://openairdocs.org/ntsb/ERA10WA327.md): Cessna · Pavacachi, Ecuador · Accident · Serious injuries · Foreign investigation · Jun 22, 2010 · HC-BYA · Substantial damage
  > On June 22, 2010, about 1345 universal time, a Cessna TU-206F, HC-BYA, registered to and operated by Servicio Aero Quichua De Pasta, as a cargo flight, initiated a descent in the vicinity of Pavacachi, Ecuador. Visual meteorological conditions prevailed and a…
- [NTSB WPR10WA309](https://openairdocs.org/ntsb/WPR10WA309.md): Cessna 172N · Broken Hill, Australia · Accident · 1 fatal · Class 5 · Foreign · Jun 21, 2010 · VH-UFN · Substantial damage
  > On June 21, 2010, about 0145 coordinated universal time, a Cessna 172N, VH-UFN, registered to a private owner, collided with water during an unknown flight phase near Broken Hill, New South Wales (NSW), Australia. The airplane was reported missing and was…
- [NTSB ERA10WA171](https://openairdocs.org/ntsb/ERA10WA171.md): Robinson R44 · Karelia, Russia · Accident · 2 fatal · Foreign investigation · Mar 10, 2010 · RA-04163 · Substantial damage
  > On March 10, 2010, about 0900 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Russian registration RA-04163, operated by a private individual, was involved in an accident under unknown circumstances near Karelia, Russia. The helicopter departed…
- [NTSB ERA10WA160](https://openairdocs.org/ntsb/ERA10WA160.md): Cessna 310R · Nova Lima, Brazil · Accident · 2 fatal · Foreign investigation · Feb 26, 2010 · PT-OID · Destroyed
  > On Feburary 26, 2010, about 1119 UTC, a Cessna 310R, Brazilian registration PT-OID, was destroyed when it collided with mountainous terrain near Nova Lima, Brazil. The pilot and one passenger were killed. The flight originated from Leopoldina, Brazil (SNDN)…
- [NTSB ERA10WA153](https://openairdocs.org/ntsb/ERA10WA153.md): Cessna U206F · Nazca, Peru · Accident · 7 fatal · Foreign investigation · Feb 25, 2010 · OB-1117 · Destroyed
  > On February 25, 2010, about 1630 universal coordinated time (1130 local time), a Cessna U206F, Peruvian registration OB-1117, operated by Nazca Airlines, was destroyed when it impacted terrain near Nazca, Ica Province, Peru. The Peruvian commercial pilot and…
- [NTSB ERA10WA157](https://openairdocs.org/ntsb/ERA10WA157.md): Bell 206 · Carayaca, Venezuela · Accident · 4 fatal · Foreign investigation · Feb 19, 2010 · YV2191 · Substantial damage
  > On February 19, 2010, about 1950 Universal Coordinated Time, a Bell 206B helicopter, Venezuelan registration YV2191, operated by Aeromedic 2005, was lost from contact with Maiquetia approach control. The helicopter departed from Generalisimo Francisco de…
- [NTSB ERA10WA130](https://openairdocs.org/ntsb/ERA10WA130.md): Piper PA-34 · Ipero, Brazil · Accident · 2 fatal · Foreign investigation · Jan 27, 2010 · PR-UGO · Substantial damage
  > On January 27, 2010, at 0918 EST, a Piper PA-34, PR-UGO, of Brazilian registration, registered to and operated by an individual, crashed 10 minutes after takeoff. The pilot and passenger were killed and the airplane was substantially damaged. The weather at…

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/990/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.
