# NTSB investigations, 2014, Outside the U.S.: Initial climb

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 ERA15WA098](https://openairdocs.org/ntsb/ERA15WA098.md): Aerospatiale AS350B · Bertioga, Brazil · Accident · 5 fatal · Foreign investigation · Dec 27, 2014 · PT-HNC · Destroyed
  > On December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…
- [NTSB DCA15RA018](https://openairdocs.org/ntsb/DCA15RA018.md): Short Bros Shorts SD3 60 · Sint Maartin -Juliana, NT · Accident · 2 fatal · Foreign investigation · Oct 29, 2014 · N380MQ · Destroyed
  > import
- [NTSB ENG15IA037](https://openairdocs.org/ntsb/ENG15IA037.md): Boeing 787-8 · London, United Kingdom · Incident · No injuries · Incident investigation · Final report · Oct 10, 2014 · N26906 · Minor damage
  > A shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…
- [NTSB WPR14LA309](https://openairdocs.org/ntsb/WPR14LA309.md): Beech A36 · Pago Pago, Antarctica · Accident · 2 fatal · Limited investigation · Final report · Jul 22, 2014 · N20TC · Destroyed
  > A loss of airplane control during the initial climb in gusting wind conditions for reasons that could not be determined because the wreckage was not recovered from the ocean.
- [NTSB CEN14RA340](https://openairdocs.org/ntsb/CEN14RA340.md): Piper PA 31P · Czestochowska, Poland · Accident · 11 fatal · Foreign investigation · Jul 5, 2014 · N11WB · Destroyed
- [NTSB WPR14WA318](https://openairdocs.org/ntsb/WPR14WA318.md): Cessna T210N · Inverell, Australia, Australia · Accident · 1 fatal · Foreign investigation · Jul 4, 2014 · VH-ZFW · Destroyed
  > On July 4, 2014, at 1325 local time, a Cessna T210N, VH-ZFW, collided with terrain shortly after takeoff from Inverell, Australia. The airplane was operated by the pilot under the pertinent civil regulations of the government of Australia. The airplane was…
- [NTSB DCA14WA138](https://openairdocs.org/ntsb/DCA14WA138.md): Fokker F27 - 50 · Nairobi, Kenya · Accident · 4 fatal · Foreign investigation · Jul 2, 2014 · 5Y-CET · Destroyed
- [NTSB ENG14RA014](https://openairdocs.org/ntsb/ENG14RA014.md): BAE AVRO146RJ - 100 · Perth, Australia, Australia · Incident · No injuries · Foreign investigation · Apr 29, 2014 · VH-NJI · Minor damage
  > On April 29, 2014, a British Aerospace BAE AVRO 146-RJ100, registration VH-NJI, experienced a No. 2 engine (left inboard) fire from the Honeywell LF507-1F turbofan engine during climb from Perth, Australia. The airplane was returned to Perth where an…
- [NTSB DCA14WA086](https://openairdocs.org/ntsb/DCA14WA086.md): Embraer ERJ 190 100 IGW · Kingston, Jamaica · Incident · No injuries · Foreign investigation · Mar 31, 2014 · N267JB · No damage
- [NTSB ERA14WA186](https://openairdocs.org/ntsb/ERA14WA186.md): Boeing B75 · Lujan, Argentina · Accident · 1 fatal · Foreign investigation · Mar 29, 2014 · LV-HAF · Substantial damage
  > On March 29, 2014, about 1900 coordinated universal time, a Boeing B75 Stearman, Argentine registration LV-HAF, was substantially damaged when it impacted the ground during the initial climb after takeoff from the Lujan Airport, Lujan, Argentina. The pilot…
- [NTSB WPR14WA128](https://openairdocs.org/ntsb/WPR14WA128.md): Hughes 369D · Moonlight Creek, New Zealand, New Zealand · Accident · No injuries · Foreign investigation · Feb 25, 2014 · ZK-IQQ · Substantial damage
  > On February 25, 2014, at 2055 universal coordinated time, a Hughes 369D, ZK-IQQ, was substantially damaged when the main rotor blades contacted and severed the tailboom at the conclusion of an autorotation and landing near Moonlight Creek, New Zealand. The…
- [NTSB ERA14WA135](https://openairdocs.org/ntsb/ERA14WA135.md): Cessna T210L · Araguaina, Brazil · Accident · 1 fatal · Foreign investigation · Feb 19, 2014 · PR-VPI · Substantial damage
  > On February 19, 2014, about 1920 universal coordinated time, a Cessna T210L, Brazilian registration PR-VPI, operated by Talla Taxi Aereo Ltda., was substantially damaged during a forced landing, after it experienced a loss of engine power during takeoff from…
- [NTSB ERA14WA116](https://openairdocs.org/ntsb/ERA14WA116.md): Helio HT-295 · Macas, Ecuador · Accident · Serious injuries · Foreign investigation · Jan 15, 2014 · HC-BTC · Substantial damage
  > On January 15, 2014, about 2030 coordinated universal time (1530 local time), a Helio Courier HT-295, Ecuadorian registration HC-BTC, was substantially damaged during a forced landing after takeoff from Edmundo Carvajal Airport (SEMC), Macas, Ecuador. The…

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

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

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