# NTSB investigations, 2018: Emergency descent

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 WPR19LA019](https://openairdocs.org/ntsb/WPR19LA019.md): Bell 47G · Wichita Falls, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 2, 2018 · N1159W · Destroyed
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA19WA288](https://openairdocs.org/ntsb/ERA19WA288.md): Embraer EMB-202 · Miranda, Brazil · Accident · No injuries · Foreign investigation · Oct 30, 2018 · PT-UJI · No damage
  > The government of Brazil has notified the NTSB of an accident involving a Embraer EMB-202 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB WPR18LA252](https://openairdocs.org/ntsb/WPR18LA252.md): Guimbal Cabri · Santa Ana, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 3, 2018 · N401SH · Substantial damage
  > The flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.
- [NTSB WPR18LA226](https://openairdocs.org/ntsb/WPR18LA226.md): Hughes 369 · Riverside, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 17, 2018 · N105JL · Substantial damage
  > The instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.
- [NTSB ANC18LA057](https://openairdocs.org/ntsb/ANC18LA057.md): Aeros Venture 2000 · Bad Axe, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 23, 2018 · N43865 · Substantial damage
  > The pilot's loss of aircraft control for reasons that could not be determined based on the available information.
- [NTSB WPR18LA183](https://openairdocs.org/ntsb/WPR18LA183.md): Cessna 182 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jun 23, 2018 · N5682B · Substantial damage
  > A total loss of engine power for reasons that could not be determined due to insufficient evidence.
- [NTSB WPR18LA127](https://openairdocs.org/ntsb/WPR18LA127.md): Yakovlev YAK 52 · Hillsboro, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 26, 2018 · N2YK · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was…
- [NTSB DCA18WA106](https://openairdocs.org/ntsb/DCA18WA106.md): Canadair CL600 2B16 · Shahr-e Kurd, Iran · Accident · 11 fatal · Foreign investigation · Mar 11, 2018 · TC-TRB · Destroyed
  > The Transportation Safety Board of Canada has informed the NTSB of an accident involving a Challenger 604, which occurred on March 11, 2018, in the Islamic Republic of Iran. All investigative information will be released by the government of Iran.
- [NTSB GAA18CA159](https://openairdocs.org/ntsb/GAA18CA159.md): Hughes 269 · Jacksonville, FL · Accident · No injuries · Data collection · Final report · Mar 10, 2018 · N9020M · Substantial damage
  > The pilot’s failure to maintain rotor rpm during a practice autorotation, which resulted in ground contact and a dynamic rollover.
- [NTSB ERA18WA090](https://openairdocs.org/ntsb/ERA18WA090.md): Neiva EMB-720D · Manaus City, Brazil · Accident · 4 fatal · Foreign investigation · Feb 22, 2018 · PT-VKR · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a NEIVA EMB-720D airplane that occurred on February 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB ERA18LA075](https://openairdocs.org/ntsb/ERA18LA075.md): Bell OH 58C · Zebulon, GA · Accident · No injuries · Limited investigation · Final report · Jan 29, 2018 · N942SC · Substantial damage
  > The pilot's failure to fully open the throttle before initiating the power recovery in response to a simulated engine failure.

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

This list as a web page: https://openairdocs.org/ntsb-phases/600/cases?year=2018

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