# NTSB investigations, 2019: 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 DCA20WA016](https://openairdocs.org/ntsb/DCA20WA016.md): Boeing 747 · Leipzig, Germany · Incident · No injuries · Foreign investigation · Nov 14, 2019 · G-CLAE · Minor damage
  > The government of Germany has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…
- [NTSB WPR20FAMS1](https://openairdocs.org/ntsb/WPR20FAMS1.md): Piper PA28R · Shelter Cove, CA · Accident · 2 fatal · Class 3 · Missing aircraft · Final report · Oct 25, 2019 · N4958J · Destroyed
  > Undetermined due to lack of available evidence.
- [NTSB WPR20LA014](https://openairdocs.org/ntsb/WPR20LA014.md): Vans RV 6 · Spanaway, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 23, 2019 · N615RJ · Substantial damage
  > A total loss of engine power during the initial climb for reasons that could not be determined.
- [NTSB CEN20LA021](https://openairdocs.org/ntsb/CEN20LA021.md): Piper PA23 · (Gulf of Mexico) · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 17, 2019 · N778PA · Destroyed
  > The airplane’s descent into the ocean for reasons that could not be determined.
- [NTSB WPR20WA006](https://openairdocs.org/ntsb/WPR20WA006.md): Piper PA-28-140 · Huhudi, South Africa · Accident · 1 fatal · Foreign investigation · Oct 6, 2019 · ZS-EEZ
  > On October 6, 2019, about 1547 coordinated universal time, a Piper PA28-140, ZS-EEZ, crashed near, Vryburg Airport, Huhudi, South Africa. The pilot was fatally injured, and the passenger sustained serious injuries. The extent of the airplane's damage is…
- [NTSB CEN19WA296](https://openairdocs.org/ntsb/CEN19WA296.md): Robinson R44 · Veracruz, Mexico · Accident · Serious injuries · Foreign investigation · Aug 26, 2019 · XB-GIL
  > On August 26, 2019, about 1700 hours universal coordinated time, a Robinson R-44 II helicopter, Mexican registration XB-GIL, was substantially damaged during an emergency landing in a field near Veracruz, Mexico. Two occupants were seriously injured; one…
- [NTSB CEN19WA283](https://openairdocs.org/ntsb/CEN19WA283.md): Bell 206 · Inca, Mallorca, Spain · Accident · 7 fatal · Foreign investigation · Aug 25, 2019 · D-HOTT · 2 aircraft · Destroyed
  > On June 25, 2019, about 1335 local time, a Bell 206L-3 helicopter, D-HOTT, and an Aeroprakt A22L airplane collided in mid-air, near Inca, Mallorca, Spain. The pilot and four passengers aboard the helicopter and the two people on the airplane, received fatal…
- [NTSB CEN19WA286](https://openairdocs.org/ntsb/CEN19WA286.md): Pitts S2 · Stonor Oxforshire, United Kingdom · Accident · 2 fatal · Foreign investigation · Aug 24, 2019 · G-ODDS · Substantial damage
  > The government of United Kingdom has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…
- [NTSB CEN19WA289](https://openairdocs.org/ntsb/CEN19WA289.md): Capella XS · San Juan del Puerto, Spain · Accident · 1 fatal · Foreign investigation · Aug 23, 2019 · EC-YTA · Substantial damage
  > On August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…
- [NTSB CEN19WA284](https://openairdocs.org/ntsb/CEN19WA284.md): Reims F172 · Schneizlreuth, Germany · Accident · 1 fatal · Foreign investigation · Aug 22, 2019 · D-ECSC · Destroyed
  > The government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…
- [NTSB CEN19WA282](https://openairdocs.org/ntsb/CEN19WA282.md): Cessna 150 · Diepholz, Germany · Accident · 1 fatal · Foreign investigation · Aug 22, 2019 · D-EHLG · Destroyed
  > On August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on…
- [NTSB WPR19WA274](https://openairdocs.org/ntsb/WPR19WA274.md): Cessna 172 · Pretoria, South Africa · Accident · 2 fatal · Foreign investigation · Aug 16, 2019 · ZS-LMI · Substantial damage
  > On August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the…
- [NTSB CEN19FA248](https://openairdocs.org/ntsb/CEN19FA248.md): Cessna 310 · De Queen, AR · Accident · 1 fatal · Class 3 · Field · Final report · Aug 4, 2019 · N310QA · Substantial damage
  > A loss of control for reasons that could not be determined based on the available information.
- [NTSB CEN19WA301](https://openairdocs.org/ntsb/CEN19WA301.md): Cessna TU206 · Guachochi, Mexico · Accident · 2 fatal · Foreign investigation · Aug 2, 2019 · XB-FZN · Substantial damage
  > On August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the…
- [NTSB WPR19WA199](https://openairdocs.org/ntsb/WPR19WA199.md): Cessna 172 · Cangkring, Indonesia · Accident · 1 fatal · Foreign investigation · Jul 22, 2019 · PK-WUG · Substantial damage
  > On July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…
- [NTSB ERA19WA236](https://openairdocs.org/ntsb/ERA19WA236.md): Robinson R66 · Gorgona Island, Italy · Accident · 2 fatal · Foreign investigation · Jul 22, 2019 · RA07370 · Destroyed
  > The government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…
- [NTSB WPR19WA211](https://openairdocs.org/ntsb/WPR19WA211.md): Cessna 172 · Anji, China · Accident · 1 fatal · Foreign investigation · Jul 10, 2019 · B-10NH
  > On July 10, 2019, at an unknown time, a Cessna 172S, B-10NH, was substantially damaged when it collided with the ground near Anji, Zhejiang, China. One person on board was fatally injured, one sustained serious injury, and one is being assessed. The airplane…
- [NTSB CEN19WA208](https://openairdocs.org/ntsb/CEN19WA208.md): Piper PA-24-250 · Quetzaltenango, Guatemala · Accident · 1 fatal · Foreign investigation · Jul 5, 2019 · TG-DAN · Destroyed
  > The government of Guatemala has notified the NTSB of an accident involving a PIPER PA-24-250 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guatemala's investigation under the…
- [NTSB CEN19WA200](https://openairdocs.org/ntsb/CEN19WA200.md): Piper PA28 · Mandal, Norway · Accident · 1 fatal · Foreign investigation · Jun 22, 2019 · LN-MTJ · Substantial damage
  > On June 22, 2019, about 1255 local time, a Piper PA28-161, registration NL-MTJ, impacted the sea about 11 miles south of Mandal, Norway, following a loss of engine power. One person was fatally injured, and two passengers received minor injuries. The Accident…
- [NTSB GAA21WA067](https://openairdocs.org/ntsb/GAA21WA067.md): Cessna 172 · Keti Bandar, Pakistan · Accident · Class 5 · Foreign · May 31, 2019 · AP-BAJ · Substantial damage
- [NTSB ERA19WA176](https://openairdocs.org/ntsb/ERA19WA176.md): Bell 206 · La Vega, Dominican Republic · Accident · 2 fatal · Foreign investigation · May 21, 2019 · N9956K · Substantial damage
- [NTSB WPR19WA151](https://openairdocs.org/ntsb/WPR19WA151.md): Robinson R44 II · Tai Po, China · Accident · 1 fatal · Class 5 · Foreign · May 19, 2019 · B-KTK · Destroyed
- [NTSB GAA19CA282](https://openairdocs.org/ntsb/GAA19CA282.md): Cessna 172 · Edwards Air Force Base, CA · Accident · No injuries · Data collection · Final report · Apr 28, 2019 · N106ED · Substantial damage
  > An undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.
- [NTSB WPR19LA120](https://openairdocs.org/ntsb/WPR19LA120.md): Piper PA 18 225 DD · McCall, ID · Accident · No injuries · Class 3 · Limited · Final report · Apr 23, 2019 · N727WW · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA19WA108](https://openairdocs.org/ntsb/ERA19WA108.md): Cessna U206 · Eteringbang, Guyana · Accident · 1 fatal · Foreign investigation · Feb 21, 2019 · 8R-GHB · Substantial damage
  > The government of Guyana has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…
- [NTSB WPR19WA271](https://openairdocs.org/ntsb/WPR19WA271.md): Cessna U206G · Londiani, Kenya · Accident · 5 fatal · Foreign investigation · Feb 13, 2019 · 5Y-BSE · Substantial damage
  > On February 13, 2019, at 0729 universal coordinated time a Cessna U206G, 5Y-BSE, crashed into terrain, following a distress signal from the airplane near Londiani, Kericho County, Kenya. The pilot and four passengers were fatally injured. 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") = 2019
  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=2019

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