# NTSB investigations, 2017: Prior to flight

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 WPR18LA058](https://openairdocs.org/ntsb/WPR18LA058.md): Cessna 210 · San Bernardino, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 2017 · N222AT · Substantial damage
  > The fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…
- [NTSB DCA18CA074](https://openairdocs.org/ntsb/DCA18CA074.md): Boeing 737 7H4 · Los Angeles, CA · Accident · Serious injuries · Data collection · Final report · Nov 19, 2017 · N740SW · No damage
  > The provisioning agent's lack of situational awareness while stepping from the airplane to the provisioning van. Contributing to the accident was the provisioning vans failed switch.
- [NTSB DCA18CA001](https://openairdocs.org/ntsb/DCA18CA001.md): Boeing 737 7H4 · Chicago, IL · Accident · No injuries · Data collection · Final report · Oct 2, 2017 · N930WN · Substantial damage
  > the mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.
- [NTSB ERA17LA333](https://openairdocs.org/ntsb/ERA17LA333.md): Buschmann/Vanzee Vari EZ · Ambler, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2017 · N830S · Substantial damage
  > Water contamination of the fuel that was not detected during a preflight inspection, which resulted in a total loss of engine power.
- [NTSB GAA17CA537](https://openairdocs.org/ntsb/GAA17CA537.md): Bellanca 8GCBC · Foley, AL · Accident · No injuries · Data collection · Final report · Aug 23, 2017 · N181TM · Substantial damage
  > The ground crew’s incorrect hook up of the banner, which resulted in a nose-over.
- [NTSB CEN17LA234](https://openairdocs.org/ntsb/CEN17LA234.md): Aeronca 65 CA · Mount Vernon, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 17, 2017 · N33778 · Minor damage
  > The pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.
- [NTSB GAA17CA347](https://openairdocs.org/ntsb/GAA17CA347.md): Aeronca 11AC · Watervliet, MI · Accident · Minor injuries · Data collection · Final report · Jun 16, 2017 · N9404E · Substantial damage
  > The flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.
- [NTSB DCA17WA127](https://openairdocs.org/ntsb/DCA17WA127.md): Boeing 747 · Glasgow, United Kingdom · Incident · No injuries · Foreign investigation · Mar 30, 2017 · LX-VCF · No damage
  > The United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on March 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as…
- [NTSB CEN17LA135](https://openairdocs.org/ntsb/CEN17LA135.md): Luscombe 8F · Vicksburg, MI · Accident · 1 fatal · Limited investigation · Final report · Mar 20, 2017 · N2007B · No damage
  > The pilot's inadvertent contact with the propeller while hand propping the engine, which resulted in a fatal injury.
- [NTSB WPR17LA064](https://openairdocs.org/ntsb/WPR17LA064.md): Beech A36TC · Stevensville, MT · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 2017 · N3803J · Substantial damage
  > The pilot's decision to conduct a takeoff with a tailwind on an upsloping runway in an overweight airplane, which resulted in the airplane having insufficient energy to climb out of ground effect.
- [NTSB WPR17LA075](https://openairdocs.org/ntsb/WPR17LA075.md): Hughes 369A · (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2017 · N805LA · Substantial damage
  > The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…
- [NTSB DCA17CA072](https://openairdocs.org/ntsb/DCA17CA072.md): Boeing 737 76N · Phoenix, AZ · Accident · Serious injuries · Data collection · Final report · Feb 12, 2017 · N7822A · No damage
  > the catering agent's lack of situational awareness when exiting the airplane that resulted in a serious injury.
- [NTSB GAA17CA119](https://openairdocs.org/ntsb/GAA17CA119.md): Cessna 175 · Lakeport, CA · Accident · No injuries · Data collection · Final report · Jan 6, 2017 · N8148T · Substantial damage
  > The pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.

## 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 = 100)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/100/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.