# NTSB investigations, 2017: Standing

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 ERA18LA053](https://openairdocs.org/ntsb/ERA18LA053.md): Sikorsky S76 · Islamorada, FL · Accident · No injuries · Class 3 · Limited · Final report · Dec 15, 2017 · N911FK · Substantial damage
  > The pilot's activation of the rotor brake while the No. 2 engine was still set to govern the power turbine speed, which resulted in continuous power being applied to the rotor while the rotor brake was engaged and led to excessive friction, heat, and a…
- [NTSB DCA18CA042](https://openairdocs.org/ntsb/DCA18CA042.md): Mcdonnell Douglas MD 88 · Detroit, MI · Accident · No injuries · Data collection · Final report · Dec 12, 2017 · N924DL · Substantial damage
  > failure of the flight crew to confirm the left engine throttle lever was at idle during engine start.
- [NTSB CEN18WA029](https://openairdocs.org/ntsb/CEN18WA029.md): Robinson R44 · Namur, Belgium · Accident · Minor injuries · Foreign investigation · Oct 8, 2017 · OO-FLY · Substantial damage
- [NTSB GAA18CA016](https://openairdocs.org/ntsb/GAA18CA016.md): Ultramagic T210 · Albuquerque, NM · Accident · Serious injuries · Data collection · Final report · Oct 6, 2017 · N123UT · 2 aircraft · Substantial damage
  > The pilot's failure to maintain adequate clearance from a balloon on the ground during landing.
- [NTSB GAA17CA560](https://openairdocs.org/ntsb/GAA17CA560.md): Piper J5A · Geneseo, NY · Accident · Minor injuries · Data collection · Final report · Sep 27, 2017 · N38633 · Substantial damage
  > The pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.
- [NTSB CEN17LA350](https://openairdocs.org/ntsb/CEN17LA350.md): Embraer EMB 120ER · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Sep 13, 2017 · N121CZ · Substantial damage
  > The bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.
- [NTSB GAA17CA520](https://openairdocs.org/ntsb/GAA17CA520.md): Cessna 680 · Wilmington, DE · Accident · Serious injuries · Data collection · Final report · Sep 3, 2017 · N378QS · No damage
  > The passenger’s inadvertent slip on the airplane's air stairs during deplaning, which resulted in a broken ankle.
- [NTSB ERA17CA295](https://openairdocs.org/ntsb/ERA17CA295.md): Piper PA 28-161 · Palatka, FL · Accident · No injuries · Data collection · Final report · Aug 25, 2017 · N84175 · Substantial damage
  > The student pilot's overpriming of the engine and the flight instructor's delayed remedial action, which resulted in an engine fire.
- [NTSB CEN17WA308](https://openairdocs.org/ntsb/CEN17WA308.md): American Champion 8GCBC · Dunaujvaros, Hungary · Accident · No injuries · Foreign investigation · Aug 4, 2017 · HA-KYL · Destroyed
  > The government of Hungary has notified the National Transportation Safety Board (NTSB) of an accident involving an American Champion 8GCBC airplane that occurred on August 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB ERA17LA243](https://openairdocs.org/ntsb/ERA17LA243.md): Balloon Works Firefly 8B 15 · Murfreesboro, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 2017 · N3282P · No damage
  > The passenger's failure to let go of the balloon's gondola when the balloon began to ascend. Contributing to the accident was the pilot's failure to maintain control of the balloon after landing, which resulted in an inadvertent takeoff.
- [NTSB GAA17CA398](https://openairdocs.org/ntsb/GAA17CA398.md): Robinson Helicopter R44 II · Pocahontas, IL · Accident · No injuries · Data collection · Final report · Jul 7, 2017 · N62FA · Substantial damage
  > The helicopter pilot’s miscommunication with the ground crewmember during reloading operations, which resulted in a takeoff with the filler hose attached to the helicopter and subsequent impact with a truck.
- [NTSB CEN17LA264](https://openairdocs.org/ntsb/CEN17LA264.md): Bell 47D1 · Big Lake, MN · Accident · No injuries · Limited investigation · Final report · Jul 6, 2017 · N153B · Substantial damage
  > The failure of the metal core assembly within a wooden main rotor blade due to undetected corrosion and fatigue, which caused the wooden blade to separate from the rotor mast.
- [NTSB CEN17LA223](https://openairdocs.org/ntsb/CEN17LA223.md): Head Balloons AX7 77B · Chatsworth, IL · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2017 · N30721 · Minor damage
  > The balloon’s encounter with unexpected wind gusts during inflation, which resulted in the balloon becoming prematurely airborne and subsequently the pilot being ejected from the basket and one passenger receiving serious injuries while attempting to egress…
- [NTSB GAA17CA344](https://openairdocs.org/ntsb/GAA17CA344.md): Eurocopter EC130 · Peach Springs, AZ · Accident · No injuries · Data collection · Final report · May 25, 2017 · N153GC · Substantial damage
  > The ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.
- [NTSB GAA17CA252](https://openairdocs.org/ntsb/GAA17CA252.md): Maule MX7 · Floydada, TX · Accident · No injuries · Data collection · Final report · Apr 30, 2017 · N3035M · Substantial damage
  > The pilot's decision to fly into and land at an area of known widespread high gusting wind, which resulted in a nose-over.
- [NTSB CEN17CA116](https://openairdocs.org/ntsb/CEN17CA116.md): Cessna 162 · Conway, AR · Accident · Serious injuries · Data collection · Final report · Mar 4, 2017 · N3028G · No damage
  > The pilot's failure to shut down the engine before exiting the airplane and his failure to focus his attention on the task at hand, which led to his walking into a rotating propeller.
- [NTSB GAA17CA135](https://openairdocs.org/ntsb/GAA17CA135.md): Hughes OH 6A · Price, UT · Accident · No injuries · Data collection · Final report · Feb 8, 2017 · N6640Z · Substantial damage
  > The fuel truck driver’s failure to stop before impacting the helicopter’s main rotor blades.
- [NTSB SUR17WA001](https://openairdocs.org/ntsb/SUR17WA001.md): Boeing 757-223 · Cancun, Mexico · Incident · No injuries · Foreign investigation · Jan 26, 2017 · N176AA · No damage

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

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

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