# NTSB investigations, 2017: Initial climb

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.

Page 1 of 3 · 149 cases

## Latest cases

- [NTSB WPR18WA060](https://openairdocs.org/ntsb/WPR18WA060.md): De Havilland DHC2 · Cottage Point, Australia · Accident · 6 fatal · Foreign investigation · Dec 31, 2017 · VH-NOO · Destroyed
  > On December 31, 2017, at 1515 local time, a De Havilland DHC-2, VH-NOO, collided with water during takeoff initial climb near Cottage Point, Australia. The airplane was destroyed and the pilot and five passengers were fatally injured. The flight was operated…
- [NTSB DCA18CA056](https://openairdocs.org/ntsb/DCA18CA056.md): Mcdonnell Douglas DC 9 33F · Bethel, AK · Accident · No injuries · Data collection · Final report · Dec 23, 2017 · N935CE · Substantial damage
  > failure of a cargo tie-down fastener, resulting in unsecured cargo striking the pressure bulkhead.
- [NTSB WPR18WA054](https://openairdocs.org/ntsb/WPR18WA054.md): Bell UH1H · Bredasdorp, South Africa · Accident · Serious injuries · Foreign investigation · Dec 21, 2017 · ZS-HLI · Substantial damage
  > On December 21, 2017, about 1105 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLI, was substantially damaged when it impacted terrain shortly after liftoff from Bredasdorp fire station, Western Cape Province, South Africa. The helicopter was…
- [NTSB WPR18LA049](https://openairdocs.org/ntsb/WPR18LA049.md): North American Navion · El Cajon, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 2017 · N8884H · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA18LA062](https://openairdocs.org/ntsb/ERA18LA062.md): Piper PA32 · Oakland Park, FL · Accident · No injuries · Limited investigation · Final report · Dec 13, 2017 · C6RVT · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN18LA051](https://openairdocs.org/ntsb/CEN18LA051.md): Cessna 172C · Algona, IA · Accident · No injuries · Limited investigation · Final report · Dec 9, 2017 · N8856B · Substantial damage
  > The No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.
- [NTSB GAA18CA071](https://openairdocs.org/ntsb/GAA18CA071.md): Cessna 402 · Hyannis, MA · Accident · No injuries · Data collection · Final report · Dec 4, 2017 · N2748Y · Substantial damage
  > Encounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.
- [NTSB ANC18LA013](https://openairdocs.org/ntsb/ANC18LA013.md): Cessna 172R · Huntingdon, TN · Accident · No injuries · Limited investigation · Final report · Dec 2, 2017 · N9730F · Substantial damage
  > A total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA18CA035](https://openairdocs.org/ntsb/ERA18CA035.md): Driggers Quillan E Titan Tornado · Mechanicsville, VA · Accident · No injuries · Data collection · Final report · Nov 29, 2017 · N50F · Substantial damage
  > The pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.
- [NTSB DCA18WA028](https://openairdocs.org/ntsb/DCA18WA028.md): Boeing 737 · Latvia, Latvia · Incident · No injuries · Foreign investigation · Nov 23, 2017 · LNN-II · No damage
  > The Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 23, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…
- [NTSB ERA18LA033](https://openairdocs.org/ntsb/ERA18LA033.md): Cessna 421 · Presque Isle, ME · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 2017 · N421RX · Substantial damage
  > The in-flight leakage of fuel from the fuel injection system's mixture shaft onto the hot turbocharger, which resulted in an in-flight fire, and the pilot's inability to see the runway due to reduced visibility conditions and conduct a successful landing.
- [NTSB WPR18LA034](https://openairdocs.org/ntsb/WPR18LA034.md): Cessna 172P · San Jose, CA · Accident · Serious injuries · Class 2 · Limited · Final report · Nov 19, 2017 · N52492 · Substantial damage
  > The pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the…
- [NTSB ERA18LA027](https://openairdocs.org/ntsb/ERA18LA027.md): Homer Autogyro Cavalon · Oak Island, NC · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2017 · N470CH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18LA027](https://openairdocs.org/ntsb/CEN18LA027.md): Riggs Kenneth W T Bird II · St Mary's, KS · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2017 · N618ER · Substantial damage
  > The loss of engine power due to a propeller failure when the passenger’s hat exited the cockpit and impacted the three-bladed pusher propeller, separating one of the propeller blades.
- [NTSB CEN18FA024](https://openairdocs.org/ntsb/CEN18FA024.md): Cessna 172N · Hatch, NM · Accident · 4 fatal · Field investigation · Final report · Nov 4, 2017 · N251CH · Substantial damage
  > The pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.
- [NTSB WPR18FA026](https://openairdocs.org/ntsb/WPR18FA026.md): Piper PA 18-150 · Murphy, ID · Accident · 1 fatal · Class 2 · Field · Final report · Nov 3, 2017 · N4393Z · Substantial damage
  > Failure of the left aileron control cable that resulted in a loss of aircraft control during takeoff. Contributing to the accident was inadequate maintenance inspections to the aileron cable connections.
- [NTSB GAA18CA035](https://openairdocs.org/ntsb/GAA18CA035.md): Smith Aerostar 600A · Tallahassee, FL · Accident · No injuries · Data collection · Final report · Oct 27, 2017 · N211W · Substantial damage
  > The pilot's incorrect pitch control and premature landing gear retraction during the initial climb.
- [NTSB ERA18LA010](https://openairdocs.org/ntsb/ERA18LA010.md): Beech A24 · Manteo, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 18, 2017 · N400LE · Substantial damage
  > The failure of maintenance personnel to properly secure wiring during an electrical component installation, which resulted in arcing and smoke in the cockpit. Contributing to the outcome was the flight instructor's failure to attain a proper descent rate…
- [NTSB ANC18LA004](https://openairdocs.org/ntsb/ANC18LA004.md): Cirrus Design SR22T · Tuskegee, AL · Accident · No injuries · Limited investigation · Final report · Oct 15, 2017 · N289CM · Substantial damage
  > An improperly adjusted slope controller and fuel pump that resulted in an excessively high fuel flow, an extremely rich mixture, a rough-running engine, and a subsequent partial loss of engine power.
- [NTSB ERA18FA006](https://openairdocs.org/ntsb/ERA18FA006.md): Piper PA 25-235 · Front Royal, VA · Accident · 1 fatal · Field investigation · Final report · Oct 7, 2017 · N90866 · Destroyed
  > The tow plane pilot's loss of airplane control for reasons that could not be determined based on the available evidence. Contributing to the accident was the glider instructor's diversion of attention away from the tow airplane which resulted in his delay in…
- [NTSB ERA18LA007](https://openairdocs.org/ntsb/ERA18LA007.md): Ercoupe 415 · Centre Hall, PA · Accident · No injuries · Limited investigation · Final report · Oct 6, 2017 · N3538H · Substantial damage
  > The partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.
- [NTSB CEN18LA008](https://openairdocs.org/ntsb/CEN18LA008.md): Piper PA 34-220T · Sugar Grove, IL · Accident · No injuries · Limited investigation · Final report · Oct 6, 2017 · N4136D · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR18LA007](https://openairdocs.org/ntsb/WPR18LA007.md): Thomas Stephen Glasair Super II RG · Santa Ynez, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 5, 2017 · N248ST · Substantial damage
  > A partial loss of engine power for reasons that were not determined.
- [NTSB CEN18FA003](https://openairdocs.org/ntsb/CEN18FA003.md): Schaffer Fisher Horizon 2 · Eden Prairie, MN · Accident · 1 fatal · Field investigation · Final report · Oct 4, 2017 · N428AP · Destroyed
  > An inflight loss of control and collision with terrain for undetermined reasons after a thorough examination of the airplane's flight controls was unable to confirm control continuity. Contributing to the accident was the pilot's lack of experience in the…
- [NTSB ERA18LA003](https://openairdocs.org/ntsb/ERA18LA003.md): Freeman Heritage Collection SE5A · Virginia Beach, VA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 3, 2017 · N685SE · Substantial damage
  > A partial loss of engine power due to an interruption of the normal fuel/air mixture to the engine.
- [NTSB ERA17LA336](https://openairdocs.org/ntsb/ERA17LA336.md): Cessna 152 · Winder, GA · Accident · No injuries · Limited investigation · Final report · Sep 27, 2017 · N53393 · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.
- [NTSB CEN17WA369](https://openairdocs.org/ntsb/CEN17WA369.md): MD Helicopter 369 · Norrbotten, Sweden, Sweden · Accident · 1 fatal · Foreign investigation · Sep 26, 2017 · SE-JVI · Destroyed
  > On September 26, 2017, about 1154 hours universal coordinated time, an MD Helicopters 369D, Swedish registration SE-JVI, impacted terrain about one-third mile from the Alvsbyn Airport (ESUV), Norrbotten, Sweden. One pilot was fatally injured and the second…
- [NTSB CEN17LA368](https://openairdocs.org/ntsb/CEN17LA368.md): Eris E. Ervin Quicksilver · Cleburne, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 25, 2017 · N5112S · Destroyed
  > An engine loss of power due to fuel starvation from a broken fuel line between the fuel tank and the engine; the loss of engine power prevented the pilot from reaching a suitable landing area. Contributing to the accident was the inadequate maintenance of the…
- [NTSB ERA17LA334](https://openairdocs.org/ntsb/ERA17LA334.md): Mcmillan Joel L Avid SW 65 · Darlington, SC · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2017 · N65SW · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a clogged fuel filter.
- [NTSB CEN17LA366](https://openairdocs.org/ntsb/CEN17LA366.md): Emerson Kitfox · Waller, TX · Accident · No injuries · Limited investigation · Final report · Sep 24, 2017 · N91904 · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN17FA364](https://openairdocs.org/ntsb/CEN17FA364.md): Beech C35 · Camden, AR · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2017 · N5958C · Destroyed
  > The pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…
- [NTSB CEN17FA362](https://openairdocs.org/ntsb/CEN17FA362.md): Mitsubishi MU 2B-40 · Ainsworth, NE · Accident · 1 fatal · Field investigation · Final report · Sep 23, 2017 · N73MA · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation.
- [NTSB CEN17FA361](https://openairdocs.org/ntsb/CEN17FA361.md): Cessna TR182 · Thief River Falls, MN · Accident · 3 fatal · Field investigation · Final report · Sep 23, 2017 · N4777T · Destroyed
  > The noninstrument-rated pilot's decision to depart into instrument meteorological conditions, and his subsequent loss of control due to spatial disorientation.
- [NTSB ERA17FA330](https://openairdocs.org/ntsb/ERA17FA330.md): Cessna 150G · Rhine, GA · Accident · 1 fatal · Field investigation · Final report · Sep 20, 2017 · N3875J · Substantial damage
  > The student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.
- [NTSB DCA17WA222](https://openairdocs.org/ntsb/DCA17WA222.md): Boeing 737 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · Sep 19, 2017 · HS-LUJ · No damage
  > The AAIB of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of Thailand's investigation under the provisions of ICAO…
- [NTSB DCA17WA199](https://openairdocs.org/ntsb/DCA17WA199.md): Boeing 737 · Caracas, Venezuela · Incident · No injuries · Foreign investigation · Sep 13, 2017 · YV-268T
  > The DGAC of Venezuela has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB WPR17LA202](https://openairdocs.org/ntsb/WPR17LA202.md): Beech A24R · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 2017 · N9798L · Substantial damage
  > The airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.
- [NTSB GAA17CA526](https://openairdocs.org/ntsb/GAA17CA526.md): Cessna 172 · Coolin, ID · Accident · Serious injuries · Data collection · Final report · Sep 10, 2017 · N5703A · Substantial damage
  > The pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.
- [NTSB WPR17FA200](https://openairdocs.org/ntsb/WPR17FA200.md): Raytheon G36 · Benicia, CA · Accident · 2 fatal · Field investigation · Final report · Sep 9, 2017 · N7215J · Substantial damage
  > The pilot's failure to maintain adequate airspeed which caused the airplane to exceed its critical angle of attack and led to an aerodynamic stall.
- [NTSB GAA17CA567](https://openairdocs.org/ntsb/GAA17CA567.md): Chancey Gerry M RV-12 · Dunkirk, NY · Accident · No injuries · Data collection · Final report · Sep 6, 2017 · N1214J · Substantial damage
  > The pilot's failure to maintain lateral/bank control during takeoff in crosswind conditions.
- [NTSB ENG17IA036](https://openairdocs.org/ntsb/ENG17IA036.md): Boeing 757 232 · Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Sep 6, 2017 · N686DA · No damage
  > A No. 1 (left) engine undercowl fire caused by a fuel nozzle installation error during engine overhaul at Delta TechOps. A fuel nozzle b-nut was cross threaded, which allowed fuel to leak on hot engine case surfaces and subsequently ignite.
- [NTSB WPR17LA201](https://openairdocs.org/ntsb/WPR17LA201.md): Cobalt Aircraft Industries Co50 Valkyrie · Atwater, CA · Accident · No injuries · Limited investigation · Final report · Sep 5, 2017 · N523CA · Substantial damage
  > A loss of aileron effectiveness due to the airplane's design configuration, which resulted in the pilot's inability to control the roll axis and led to a hard landing.
- [NTSB ERA17LA314](https://openairdocs.org/ntsb/ERA17LA314.md): Rudder Dwight K Kitfox IV 1200 Spdst · Raymond, MS · Accident · No injuries · Class 3 · Limited · Final report · Sep 5, 2017 · N16KR · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB ERA17WA320](https://openairdocs.org/ntsb/ERA17WA320.md): Cessna 182 · Pontinia, Italy · Accident · 2 fatal · Foreign investigation · Sep 3, 2017 · I-SCAP · Substantial damage
  > On September 3, 2017 about 1030 universal coordinated time, a Cessna 182P, I-SCAP, impacted terrain during initial climb after takeoff, from Pegaso Club 2000 Airfield, Pontinia, Italy. The airplane was destroyed by impact forces and a post crash fire. Five…
- [NTSB DCA17WA190](https://openairdocs.org/ntsb/DCA17WA190.md): Embraer EMB145 · Medellin, Colombia · Incident · No injuries · Foreign investigation · Aug 31, 2017 · HK4535 · No damage
  > The government of Colombia has notified the NTSB of an incident involving a EMBRAER EMB145 airplane that occurred on August 31, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB CEN17FA334](https://openairdocs.org/ntsb/CEN17FA334.md): Vans RV-12 · Fishers, IN · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2017 · N212ZF · Destroyed
  > The pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.
- [NTSB CEN17WA384](https://openairdocs.org/ntsb/CEN17WA384.md): Diamond DA20 · Sankt Veit, Austria · Accident · No injuries · Foreign investigation · Aug 29, 2017 · D-EJFT · Substantial damage
  > The government of Austria has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on August 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions…
- [NTSB WPR17LA191](https://openairdocs.org/ntsb/WPR17LA191.md): North American Navion A · Fortuna, CA · Accident · No injuries · Limited investigation · Final report · Aug 27, 2017 · N8695H · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have that would have precluded normal operation.
- [NTSB WPR17LA187](https://openairdocs.org/ntsb/WPR17LA187.md): Cessna 310I · Salt Lake City, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 24, 2017 · N8170M · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA17LA292](https://openairdocs.org/ntsb/ERA17LA292.md): Hostein K/Hostein S Pietenpol · Albion, NY · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 23, 2017 · N888MG · Substantial damage
  > Loss of directional control due to a restriction of rudder movement.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?year=2017&page=2

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

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