# NTSB investigations, 2018: 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 GAA19CA103](https://openairdocs.org/ntsb/GAA19CA103.md): Robinson R44 · Strykersville, NY · Accident · No injuries · Data collection · Final report · Dec 18, 2018 · N7535S · Substantial damage
  > The structural failure of the home-built landing platform during landing, which resulted in the helicopter rolling over.
- [NTSB GAA19CA091](https://openairdocs.org/ntsb/GAA19CA091.md): Zlin Z143 · Chester, CT · Accident · No injuries · Data collection · Final report · Dec 10, 2018 · N143GW · Substantial damage
  > The pilot's loss of airplane control during the engine start.
- [NTSB WPR19TA031](https://openairdocs.org/ntsb/WPR19TA031.md): Piper PA28 · Chandler, AZ · Accident · No injuries · Class 3 · Final report · Nov 5, 2018 · N9299B · 2 aircraft · Substantial damage
  > The student pilot’s failure to maintain a safe distance from the other airplane while taxiing, resulting in a ground collision.
- [NTSB ERA18LA269](https://openairdocs.org/ntsb/ERA18LA269.md): Robinson R44 · Westminster, MD · Accident · No injuries · Limited investigation · Final report · Sep 30, 2018 · N440SH · Substantial damage
  > The pilot's attempt to move the helicopter from a sloped surface after an overspeed event, which resulted in a loss of helicopter control and impact with a car. The overspeed event resulted from misrouted and damaged wiring in the magneto, which subsequently…
- [NTSB GAA18CA545](https://openairdocs.org/ntsb/GAA18CA545.md): Cirrus SR22 · Mason City, IA · Accident · Minor injuries · Data collection · Final report · Sep 8, 2018 · N669HT · Substantial damage
  > The pilot’s improper hand propping procedure, which resulted in a runaway airplane and subsequent impact with a hangar.
- [NTSB GAA18CA534](https://openairdocs.org/ntsb/GAA18CA534.md): Robinson R44 · Girdwood, AK · Accident · No injuries · Data collection · Final report · Aug 30, 2018 · N99645 · Substantial damage
  > The fisherman's fishing rod striking the helicopter’s rotating main rotor disk during loading.
- [NTSB ERA18LA199](https://openairdocs.org/ntsb/ERA18LA199.md): Cessna 182 · Cleveland, TN · Accident · 1 fatal · Limited investigation · Final report · Jul 26, 2018 · N1311S · No damage
  > The undetected wear of the ignition switch and key, which allowed removal of the key from an intermediate position and subsequently led to an unintended engine start-up. Contributing to the undetected wear of the 42-year-old ignition switch was the lack of…
- [NTSB CEN18LA245](https://openairdocs.org/ntsb/CEN18LA245.md): Kubicek BB30 · Ashland, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 2018 · N717FN · Minor damage
  > The pilot's failure to ensure that he was secure in the balloon's basket after landing, which resulted in him falling and striking his head on the burners when the wind caught the envelope and tipped the basket over. Contributing to the accident was the…
- [NTSB DCA18WA229](https://openairdocs.org/ntsb/DCA18WA229.md): Boeing 737 · Koln, Germany · Incident · No injuries · Foreign investigation · Jun 26, 2018 · D-ABKM · Minor damage
  > The government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…
- [NTSB CEN18CA294](https://openairdocs.org/ntsb/CEN18CA294.md): Robinson R22 · Sterling City, TX · Accident · No injuries · Data collection · Final report · Jun 17, 2018 · N410MM · Substantial damage
  > The pilot’s improper decision to exit the helicopter without shutting down the engine, which allowed the collective/throttle to increase and resulted in a loss of control of the unattended helicopter.
- [NTSB WPR18LA170](https://openairdocs.org/ntsb/WPR18LA170.md): Schweizer 269C · Las Vegas, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 13, 2018 · N557DC · Substantial damage
  > The pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.
- [NTSB GAA18CA295](https://openairdocs.org/ntsb/GAA18CA295.md): Luscombe 8 · Batavia, OH · Accident · Minor injuries · Data collection · Final report · May 24, 2018 · N77922 · Substantial damage
  > The student pilot’s use of an improper engine hand-propping procedure, which resulted in the airplane’s unexpected movement.
- [NTSB GAA18CA289](https://openairdocs.org/ntsb/GAA18CA289.md): Aerospatiale AS350 B2 Ecureuil · Yakutat, AK · Accident · No injuries · Data collection · Final report · May 18, 2018 · N288CH · Substantial damage
  > The helicopter’s movement during startup in gusting wind conditions, which resulted in the main rotor striking the tailboom.
- [NTSB DCA18CA165](https://openairdocs.org/ntsb/DCA18CA165.md): Bombardier CL600 2D24 · Queens, NY · Accident · No injuries · Data collection · Final report · May 1, 2018 · N606LR · 2 aircraft · Substantial damage
  > the failure of the captain of Delta 212 to ensure adequate clearance while taxiing behind Endeavor 3413.
- [NTSB ANC18LA020](https://openairdocs.org/ntsb/ANC18LA020.md): Eurocopter France SA330J Puma · Pacific Ocean, Japan · Accident · No injuries · Limited investigation · Final report · Jan 26, 2018 · N339EV · Substantial damage
  > The worn rear bearing of the freewheel unit. Contributing to the accident was the delay in analyzing an oil sample, which would have detected the increase in metal contaminants from the worn bearing.
- [NTSB DCA18WA075](https://openairdocs.org/ntsb/DCA18WA075.md): Boeing 737 · Toronto, Canada · Accident · No injuries · Foreign investigation · Jan 5, 2018 · C-FDMB · Substantial damage
  > The Transportation Safety Board (TSB) of Canada has notified the NTSB of an accident involving a Boeing 737, which occurred on January 5, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as 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") = 2018
  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=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.