# NTSB investigations, 2016: Enroute

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 7 · 324 cases

## Latest cases

- [NTSB CEN17LA066](https://openairdocs.org/ntsb/CEN17LA066.md): Gosselin Charles Glastar · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2016 · N120CG · Substantial damage
  > Partial failure of the electric system due to a battery short, which resulted in a total loss of engine power.
- [NTSB CEN17FA064](https://openairdocs.org/ntsb/CEN17FA064.md): Piper PA 28R-200 · Vienna, IL · Accident · 4 fatal · Field investigation · Final report · Dec 31, 2016 · N2806R · Destroyed
  > The non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.
- [NTSB WPR17FA044](https://openairdocs.org/ntsb/WPR17FA044.md): Cessna 182 · Dabob, WA · Accident · 4 fatal · Field investigation · Final report · Dec 30, 2016 · N52388 · Substantial damage
  > The non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…
- [NTSB WPR17LA050](https://openairdocs.org/ntsb/WPR17LA050.md): Diamond Aircraft Ind DA 40 NG · Kingman, AZ · Accident · No injuries · Class 3 · Limited · Final report · Dec 29, 2016 · N605SJ · Substantial damage
  > The loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…
- [NTSB DCA17WA086](https://openairdocs.org/ntsb/DCA17WA086.md): Boeing 737 · Bucharest, Romania · Incident · No injuries · Foreign investigation · Dec 29, 2016 · YR-BAR · No damage
  > The Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a Boeing 737, which occurred on December 29, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…
- [NTSB ERA17FA073](https://openairdocs.org/ntsb/ERA17FA073.md): Cessna 182 · Gatlinburg, TN · Accident · 3 fatal · Field investigation · Final report · Dec 26, 2016 · N1839X · Destroyed
  > The non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.
- [NTSB GAA17CA098](https://openairdocs.org/ntsb/GAA17CA098.md): Cessna 182 · Apple Valley, CA · Accident · Serious injuries · Data collection · Final report · Dec 19, 2016 · N5954B · Substantial damage
  > The pilot’s mismanagement of the available fuel, which resulted in a loss of engine power and a subsequent hard, off-airport landing and nose-over.
- [NTSB ERA17LA071](https://openairdocs.org/ntsb/ERA17LA071.md): Cessna 150 · Palm Bay, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 2016 · N150EC · Substantial damage
  > Unknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.
- [NTSB CEN17LA058](https://openairdocs.org/ntsb/CEN17LA058.md): Bellanca 17 30A · Blaine, MN · Accident · No injuries · Limited investigation · Final report · Dec 18, 2016 · N4204B · Substantial damage
  > A total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.
- [NTSB OPS17IA010](https://openairdocs.org/ntsb/OPS17IA010.md): Boeing 777 · Mt. Wilson, CA · Incident · No injuries · Incident investigation · Final report · Dec 16, 2016 · B-16726 · No damage
  > The incident was caused by the air traffic controller assigning the pilots a left turn instead of the required right turn after departure which placed the aircraft in an unsafe proximity with terrain and obstructions. Contributing to the incident was the air…
- [NTSB ANC17FA012](https://openairdocs.org/ntsb/ANC17FA012.md): Piper PA 11 · Aniak, AK · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2016 · N5028H · Substantial damage
  > The pilot's intentional flight of the airplane into terrain in an act of suicide.
- [NTSB DCA17CA042](https://openairdocs.org/ntsb/DCA17CA042.md): Boeing 737 824 · Denver, CO · Accident · Serious injuries · Data collection · Final report · Dec 14, 2016 · N24202 · No damage
  > An inadvertent encounter with mountain wave turbulence.
- [NTSB WPR17LA036](https://openairdocs.org/ntsb/WPR17LA036.md): Cessna T210M · Mecca, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 12, 2016 · N761SZ · Substantial damage
  > The total loss of engine power due to fuel starvation during approach, which necessitated a gear-up landing on unsuitable terrain.
- [NTSB ERA17LA069](https://openairdocs.org/ntsb/ERA17LA069.md): Beech A36 · Shoreham, NY · Accident · No injuries · Limited investigation · Final report · Dec 11, 2016 · N69286 · Substantial damage
  > A fatigue crack of the crankshaft at the No. 4 main bearing journal.
- [NTSB CEN17WA222](https://openairdocs.org/ntsb/CEN17WA222.md): Piper PA38 · Ingenio La Cabana, El Salvador · Accident · 2 fatal · Foreign investigation · Dec 11, 2016 · YS-332-PE · Substantial damage
  > On December 11, 2016, a Piper PA-38, YS-332-PE, crashed near Ingenio La Cabana, El Salvador, a 0715 local time and was destroyed. The flight instructor and student pilot were fatally injured. The accident investigation is under the jurisdiction and control of…
- [NTSB CEN17FA053](https://openairdocs.org/ntsb/CEN17FA053.md): Aircraft Mfg & Design CH601XL Slsa · Marengo, IL · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2016 · N4218 · Destroyed
  > A loss of control in flight for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were identified during the investigation.
- [NTSB ENG17RA010](https://openairdocs.org/ntsb/ENG17RA010.md): ATR ATR42 · Havelian, Pakistan · Accident · No injuries · Foreign investigation · Dec 7, 2016 · AP-BHO · Destroyed
  > Pakistan has notified the NTSB of an accident involving an ATR 42-500 that occurred on December 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Pakistan Safety Investigation Board investigation under the provisions of ICAO Annex…
- [NTSB ANC17FA010](https://openairdocs.org/ntsb/ANC17FA010.md): Piper PA 28-180 · Port Alsworth, AK · Accident · 4 fatal · Field investigation · Final report · Dec 7, 2016 · N8648N · Substantial damage
  > Undetermined due to a lack of physical evidence.
- [NTSB WPR17LA031](https://openairdocs.org/ntsb/WPR17LA031.md): Piper PA 31T · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Dec 5, 2016 · N909PW · Substantial damage
  > Failure of the left windshield due to moisture ingression into the windshield laminate, which deteriorated the strength of the windshield.
- [NTSB CEN17LA136](https://openairdocs.org/ntsb/CEN17LA136.md): Cessna 550 · Port Aransas, TX · Accident · No injuries · Limited investigation · Final report · Dec 5, 2016 · N75WL · Substantial damage
  > An in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.
- [NTSB DCA17WA035](https://openairdocs.org/ntsb/DCA17WA035.md): Boeing 777 · Lajes Terceira Island, Portugal · Accident · Serious injuries · Foreign investigation · Dec 4, 2016 · A7-BAN · No damage
  > The government of Portugal has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on December 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…
- [NTSB CEN17WA049](https://openairdocs.org/ntsb/CEN17WA049.md): Beech E 90 · Toledo, Spain · Accident · 4 fatal · Foreign investigation · Dec 4, 2016 · N79CT · Destroyed
- [NTSB CEN17LA048](https://openairdocs.org/ntsb/CEN17LA048.md): Arion Lightning LS-1 · Goshen, IN · Accident · No injuries · Limited investigation · Final report · Dec 3, 2016 · N218D · Substantial damage
  > A partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.
- [NTSB GAA17CA088](https://openairdocs.org/ntsb/GAA17CA088.md): Diamond Aircraft Ind DA-20 · Payson, UT · Accident · No injuries · Data collection · Final report · Dec 2, 2016 · N992CT · Substantial damage
  > The student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.
- [NTSB DCA17WA219](https://openairdocs.org/ntsb/DCA17WA219.md): Boeing 737 · Nagpur, India · Incident · No injuries · Foreign investigation · Dec 2, 2016 · VT-JFP · 2 aircraft · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a ATR-72 airplane that occurred on December 02, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…
- [NTSB CEN17FA046](https://openairdocs.org/ntsb/CEN17FA046.md): Gordon Pegazair P 100 · Mt Vernon, IN · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2016 · N129LZ · Destroyed
  > The pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.
- [NTSB ENG17IA006](https://openairdocs.org/ntsb/ENG17IA006.md): Bombardier CL 600 2C10 · Kansas, IL · Incident · No injuries · Incident investigation · Final report · Nov 29, 2016 · N367CA · No damage
  > The probable cause of the uncontained No. 1 (left) engine failure was a separated high pressure turbine 2nd stage blade that failed due to a fatigue crack that originated below the blade platform from an area of corrosion.
- [NTSB ANC17LA008](https://openairdocs.org/ntsb/ANC17LA008.md): Airborne Extreme SQ-12 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Nov 25, 2016 · N37PX · Substantial damage
  > The fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…
- [NTSB WPR17LA038](https://openairdocs.org/ntsb/WPR17LA038.md): Cessna 182A · Safford, AZ · Accident · No injuries · Limited investigation · Final report · Nov 24, 2016 · N6077B · Substantial damage
  > The total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.
- [NTSB ERA17WA055](https://openairdocs.org/ntsb/ERA17WA055.md): Ayres S2R · Valparaiso, Chile · Accident · 1 fatal · Foreign investigation · Nov 23, 2016 · N5532G · Substantial damage
  > On November 23, 2016, about 1410 universal coordinated time, an Ayres S2-R, United States registration N5532G, was destroyed when it impacted mountainous terrain near Paso Internacional Los Libertadores, Chile. The pilot was fatally injured. The flight…
- [NTSB WPR17FA025](https://openairdocs.org/ntsb/WPR17FA025.md): Piper PA 28-181 · Upland, CA · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2016 · N6912C · Substantial damage
  > The pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.
- [NTSB DCA17CA096](https://openairdocs.org/ntsb/DCA17CA096.md): Boeing 717 200 · Hopewell, VA · Accident · Serious injuries · Data collection · Final report · Nov 21, 2016 · N930AT · No damage
  > the flight attendant's inadvertent bump into a retractable galley tray.
- [NTSB ANC17LA014](https://openairdocs.org/ntsb/ANC17LA014.md): Piper PA 32R-300 · McGrath, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 2016 · N4352F · Minor damage
  > The failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…
- [NTSB ERA17FA052](https://openairdocs.org/ntsb/ERA17FA052.md): Ryan Navion · New Gretna, NJ · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2016 · N4976K · Substantial damage
  > The pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.
- [NTSB ERA17WA060](https://openairdocs.org/ntsb/ERA17WA060.md): Agusta A109A II · Varese, Italy · Accident · 1 fatal · Foreign investigation · Nov 19, 2016 · N109W · Destroyed
  > On November 19, 2016, at 1316 universal coordinated time, an Augusta A109 A II, N109W, was destroyed when it impacted terrain while navigating near Varese, Italy. An Italian passenger was fatally injured and the Italian certificated pilot and Swiss passenger…
- [NTSB WPR17WA027](https://openairdocs.org/ntsb/WPR17WA027.md): Robinson R44 · Mount Windsor, Australia · Accident · 1 fatal · Foreign investigation · Nov 18, 2016 · VH-ZNZ · Destroyed
  > On November 18, 2016, at 1244 local time, a Robinson R44 II, Australian registration VH-ZNZ, collided with terrain near Mount Windsor, Australia. The helicopter was destroyed by a post impact fire. The pilot sustained serious injuries and the passenger was…
- [NTSB GAA17CA086](https://openairdocs.org/ntsb/GAA17CA086.md): Beech A36 · Ft. Myers, FL · Accident · Minor injuries · Data collection · Final report · Nov 18, 2016 · N64793 · Substantial damage
  > An in-flight collision with a flock of birds.
- [NTSB ERA17LA044](https://openairdocs.org/ntsb/ERA17LA044.md): Cessna 152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 13, 2016 · N94292 · Substantial damage
  > The loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.
- [NTSB CEN17LA039](https://openairdocs.org/ntsb/CEN17LA039.md): Cessna P210N · Pleasanton, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2016 · N44C · Substantial damage
  > Maintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight.
- [NTSB WPR17LA018](https://openairdocs.org/ntsb/WPR17LA018.md): Grumman American Avn. AA 1C · Hemet, CA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2016 · N9556U · Substantial damage
  > The pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA17LA045](https://openairdocs.org/ntsb/ERA17LA045.md): Cessna 150 · Snow Hill, NC · Accident · No injuries · Limited investigation · Final report · Nov 10, 2016 · N23473 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA17LA041](https://openairdocs.org/ntsb/ERA17LA041.md): Beech 36 · Ormond Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 2016 · N3089A · Destroyed
  > A loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation.
- [NTSB ERA17WA178](https://openairdocs.org/ntsb/ERA17WA178.md): Cessna 210 · Metropolitana, Chile · Accident · Minor injuries · Foreign investigation · Nov 8, 2016 · CC-LLH
  > On August 11, 2016, at 1312 coordinated universal time, a Cessna 210N, Chilean registration CC-LLH, was substantially damaged when it impacted terrain during a forced landing near Metropolitana, Chile. The pilot and one passenger sustained minor injuries.…
- [NTSB ERA17LA040](https://openairdocs.org/ntsb/ERA17LA040.md): Cessna 177 · Hopkinton, RI · Accident · No injuries · Limited investigation · Final report · Nov 8, 2016 · N30703 · Substantial damage
  > The pilot's failure to accurately determine the airplane's fuel quantity before the flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB GAA17CA060](https://openairdocs.org/ntsb/GAA17CA060.md): Cessna 172 · Englewood, CO · Accident · No injuries · Data collection · Final report · Nov 7, 2016 · N6026Z · Substantial damage
  > An in-flight collision with multiple birds.
- [NTSB GAA17CA058](https://openairdocs.org/ntsb/GAA17CA058.md): Beech 58TC · Valdosta, GA · Accident · No injuries · Data collection · Final report · Nov 5, 2016 · N2CH · Substantial damage
  > The pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power.
- [NTSB ERA17LA037](https://openairdocs.org/ntsb/ERA17LA037.md): Aviat A 1B · Geneva, FL · Accident · No injuries · Limited investigation · Final report · Nov 2, 2016 · N54HY · Substantial damage
  > A partial loss of engine power due to debris in the No. 1 cylinder that damaged the spark plugs.
- [NTSB GAA17WA584](https://openairdocs.org/ntsb/GAA17WA584.md): DHC 4 · Perkumpulan, Indonesia · Accident · No injuries · Class 5 · Foreign · Oct 31, 2016 · PK-SWW · Substantial damage
- [NTSB ANC17FA004](https://openairdocs.org/ntsb/ANC17FA004.md): Fairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AK · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2016 · N5308F · Substantial damage
  > The airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions…
- [NTSB CEN17LA030](https://openairdocs.org/ntsb/CEN17LA030.md): Cirrus Design SR22 · Bloomfield, NM · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N234PJ · Substantial damage
  > Maintenance personnel’s failure to fully torque the fuel port cap, which allowed the cap to back off in flight and interrupted fuel flow to the engine, which resulted in a total loss of engine power.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2016&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") = 2016
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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