# NTSB investigations, 2015: 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 CEN16WA071](https://openairdocs.org/ntsb/CEN16WA071.md): Socata TB9 · Malaga, Spain · Accident · 2 fatal · Foreign investigation · Dec 24, 2015 · EC-LIQ · Destroyed
  > The Comisión De Investigación De Accidentes E Incidentes De Aviación Civil (CIAIAC) of Spain has notified the NTSB of a fatal accident involving a Socata TB-9 airplane, EC-LIQ, that occurred on December 24, 2015. The NTSB has appointed a U.S. Accredited…
- [NTSB CEN16WA044](https://openairdocs.org/ntsb/CEN16WA044.md): Bell 206 · San Carlos, Nicaragua · Accident · 3 fatal · Foreign investigation · Nov 17, 2015 · YN-ISA · Destroyed
  > On November 17, 2015, about 1140 coordinated universal time, a Bell 206L4 helicopter, Nicaraguan registered YN-ISA, impacted the San Juan River near San Carlos, Rio San Juan, Nicaragua. The pilot and three passengers were fatally injured and the helicopter…
- [NTSB ERA16WA038](https://openairdocs.org/ntsb/ERA16WA038.md): Air Tractor AT-502B · Balsas, Brazil · Accident · 1 fatal · Foreign investigation · Nov 9, 2015 · PR-RSA · Destroyed
  > On November 11, 2015, about 1930 universal coordinated time, an Air Tractor AT502B, Brazilian registration PR-RSA, was destroyed when it impacted terrain shortly after takeoff from Balsas Airport, Balsas Brazil. The pilot was fatally injured. The flight was…
- [NTSB ERA16WA050](https://openairdocs.org/ntsb/ERA16WA050.md): Cessna 150H · Rondonopolis Municipality, Brazil · Accident · 2 fatal · Foreign investigation · Oct 22, 2015 · PR-DMT · Destroyed
  > On October 22, 2015, about 1130 coordinated universal time, a Cessna 150H, Brazilian registration PR-DMT, was destroyed when it impacted terrain while on approach to land at Rondonopolis Airport, Rondonopolis, Mato Grosso, Brazil. The two occupants were…
- [NTSB ERA16WA013](https://openairdocs.org/ntsb/ERA16WA013.md): Cessna 208B · Yumbillo, Colombia · Accident · 3 fatal · Foreign investigation · Oct 14, 2015 · PR-MIC · Destroyed
  > On October 14, 2016, about 1645 coordinated universal time, a Cessna 208B, Brazilian registration PR-MIC, operated by Microsurvey Aerogeofisica E Consultoria Cientifica of Brazil, was destroyed when it impacted mountainous terrain during a survey flight near…
- [NTSB CEN16WA009](https://openairdocs.org/ntsb/CEN16WA009.md): Bell 430 · Xalapa, Mexico · Accident · 2 fatal · Foreign investigation · Oct 6, 2015 · XC-VER · Destroyed
  > On October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…
- [NTSB WPR15WA271](https://openairdocs.org/ntsb/WPR15WA271.md): Bell 407 · Chong Qing, China, China · Accident · 4 fatal · Foreign investigation · Sep 13, 2015 · B-7702 · Substantial damage
  > On September 13, 2015, at 0600 local time, a Bell 407 GX, B-7702, operated by Chong Qing General Aviation Corporation, collided with terrain during an aerial photo operation near Chong Qing, P. R. China. The helicopter was being operated under the pertinent…
- [NTSB ERA15WA355](https://openairdocs.org/ntsb/ERA15WA355.md): Smith AEROSTAR600 · Santa Fé de Antioquia, Colombia · Accident · 2 fatal · Foreign investigation · Sep 11, 2015 · N164HH · Destroyed
- [NTSB CEN15WA406](https://openairdocs.org/ntsb/CEN15WA406.md): Beech Beech C 24R · Könnern, Germany · Accident · 1 fatal · Foreign investigation · Sep 10, 2015 · D-EHZK · Substantial damage
  > On September 10, 2015 about 0830 UTC, a Beech C24R Sierra airplane, German registration D-EHZK, crashed into a field under unknown circumstances near Könnern, Germany. The pilot, who was the sole occupant, was fatally injured. The flight departed from the…
- [NTSB WPR15WA259](https://openairdocs.org/ntsb/WPR15WA259.md): Cessna 172 · Ballarat, Australia, Australia · Accident · 1 fatal · Foreign investigation · Sep 8, 2015 · VH-ZEW · Destroyed
  > On September 8, 2015, at 1542 local time, a Cessna 172S, VH-ZEW, collided with terrain near Ballarat, Australia. The airplane was being operated under the pertinent civil regulations of the Government of Australia. The airplane was destroyed and the pilot,…
- [NTSB CEN15WA380](https://openairdocs.org/ntsb/CEN15WA380.md): Dehavilland DHC-2 MK. I · Lac Long, Canada · Accident · 6 fatal · Foreign investigation · Aug 23, 2015 · C-FKRJ
  > On August 23, 2015, about 1530 coordinated universal time, a De Havilland DHC-2 MK. I airplane, collided with wooded mountainous terrain near Lac Long, Quebec, Canada. The pilot and 5 passengers were fatally injured. The accident investigation is under the…
- [NTSB CEN15WA349](https://openairdocs.org/ntsb/CEN15WA349.md): Cessna 172F · La Blanca, Guatemala · Accident · 1 fatal · Foreign investigation · Aug 4, 2015 · TG-ZAB · Destroyed
  > On August 4, 2015, at 1315 coordinated universal time, a Cessna 172F, Guatemalian registration TG-ZAB, operated by AFYCO S.A., was destroyed when it impacted the terrain near La Blanca, Guatemala, during an aerial application flight. The pilot was fatally…
- [NTSB CEN15WA283](https://openairdocs.org/ntsb/CEN15WA283.md): Lake LA4 - 200 · Split, Croatia · Accident · 2 fatal · Foreign investigation · Jun 25, 2015 · 9A-DLA · Destroyed
  > On June 25, 2015, at 1735 universal coordinated time (UTC), a Lake Aircraft LA4-200, Croatian Registration 9A-DLA, was destroyed when it contacted the sea near the Split Airport (LDSP), Resnik, Croatia. One pilot and the sole passenger were fatally injured.…
- [NTSB ANC15WA043](https://openairdocs.org/ntsb/ANC15WA043.md): Cessna 172 · Fort McMurray, Canada · Accident · 2 fatal · Foreign investigation · Jun 22, 2015 · C-GJSE · 2 aircraft · Substantial damage
- [NTSB WPR15WA188](https://openairdocs.org/ntsb/WPR15WA188.md): Robinson R44 - Undesignat · Timber Creek, Australia, Australia · Accident · 1 fatal · Foreign investigation · Jun 14, 2015 · VH-KJJ · Substantial damage
  > On June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…
- [NTSB GAA15CA161](https://openairdocs.org/ntsb/GAA15CA161.md): Cessna 172S · Galesburg, IL · Accident · No injuries · Data collection · Final report · Jun 10, 2015 · N740SP · Substantial damage
  > Firewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.
- [NTSB CEN15WA262](https://openairdocs.org/ntsb/CEN15WA262.md): Bell Helicopter 206B · Baldwin, United Kingdom · Accident · 1 fatal · Foreign investigation · Jun 6, 2015 · G-RAMY · Substantial damage
  > On June 6, 2015, about 0810 coordinated universal time, a Bell 206B helicopter, G-RAMY, impacted mountainous terrain near Baldwin, Isle of Man, United Kingdom. The pilot, the sole occupant, was fatally injured.The accident investigation is under the…
- [NTSB CEN15WA251](https://openairdocs.org/ntsb/CEN15WA251.md): M7 Aerospace SA226 - TC · Queretaro, Mexico · Accident · 5 fatal · Foreign investigation · Jun 2, 2015 · XA-UKP · Destroyed
  > On June 2, 2015, about 1425 central daylight time, an M7 Aerospace LLC SA226-TC airplane, XA-UKP, impacted terrain near Queretaro, Mexico. A postimpact ground fire occurred. The pilot, co-pilot, and three passengers were fatally injured and the airplane was…
- [NTSB ANC15FA032](https://openairdocs.org/ntsb/ANC15FA032.md): Cessna 207 · Bethel, AK · Accident · 1 fatal · Field investigation · Final report · May 30, 2015 · N1653U · Substantial damage
  > The pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…
- [NTSB ANC15WA029](https://openairdocs.org/ntsb/ANC15WA029.md): Air Tractor AT802-A · Cold Lake, Canada · Accident · 1 fatal · Foreign investigation · May 22, 2015 · C-FDHV · Substantial damage
  > On May 22, 2015, at 1630 mountain daylight time, a Canadian registered Air Tractor, AT-802A airplane, C-FDHV, operated by the Conair Group Inc., was destroyed when it collided with terrain under unknown circumstances during firefighting operations near Cold…
- [NTSB CEN15WA234](https://openairdocs.org/ntsb/CEN15WA234.md): Hughes 369 · Bocognano, Corse-du-Sud, France, France · Accident · Serious injuries · Foreign investigation · May 18, 2015 · OH-HNR · Destroyed
  > On May 18, 2015, about 0810 hours universal coordinated time, a Hughes model 369 helicopter, Finland registration OH-HNR, impacted terrain near Bocognano, Corse-du-Sud, France. The two crew members were seriously injured. The flight itinerary and purpose of…
- [NTSB WPR15FAMS1](https://openairdocs.org/ntsb/WPR15FAMS1.md): Cessna 172S · Davenport, CA · Accident · 1 fatal · Missing aircraft · Final report · May 8, 2015 · N191TG
  > Undetermined because the airplane was not located.
- [NTSB CEN15LA185](https://openairdocs.org/ntsb/CEN15LA185.md): Giackino Donald W Rotorway 162F · Marquette, MI · Accident · No injuries · Limited investigation · Final report · Mar 28, 2015 · N556DG · Substantial damage
  > The loss of helicopter control for reasons that could not be determined based on the available evidence.
- [NTSB GAA15CA018](https://openairdocs.org/ntsb/GAA15CA018.md): Cessna 172S · Camarillo, CA · Accident · No injuries · Data collection · Final report · Mar 23, 2015 · N2104H · Substantial damage
  > The pilot involved and the phase of flight when the damage occurred were not determined.
- [NTSB CEN15WA143](https://openairdocs.org/ntsb/CEN15WA143.md): Judr Zdenek Prazdny Rotorway · Bohušovice nad Ohrí, Czechia · Accident · 1 fatal · Foreign investigation · Feb 12, 2015 · N111ZP · Destroyed
- [NTSB CEN15WA145](https://openairdocs.org/ntsb/CEN15WA145.md): Pioneer 400 · Blackwood Forest, Hampshire, U.K., United Kingdom · Accident · 2 fatal · Foreign investigation · Jan 3, 2015 · G-CVGO · Destroyed
  > On January 3, 2015, about 1530 UTC, a Pioneer 400 airplane, G-CVGO (s/n LAA 364-15006) impacted terrain near Blackwood Forest, Hampshire. Two persons on board were fatally injured and one was seriously injured. The airplane was destroyed. This investigation…
- [NTSB CEN15WA455](https://openairdocs.org/ntsb/CEN15WA455.md): Rans S6 · Beja, Portugal · Accident · Serious injuries · Foreign investigation · Jan 1, 2015 · CS-UJF · Destroyed
  > On January 1, 2015, about 1700 local time, a Rans S-6 Coyote II, Portuguese registration CS-UJF, impacted terrain after departure from the Beja Civil Aerodrome (LPBE), Beja, Portugal. The pilot and passenger were seriously injured and the airplane was…

## 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") = 2015
  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?year=2015

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