# NTSB investigations, 2016: Takeoff

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 4 · 191 cases

## Latest cases

- [NTSB ERA17WA076](https://openairdocs.org/ntsb/ERA17WA076.md): Air Tractor AT802 · Santa Juana, Chile · Accident · 1 fatal · Foreign investigation · Dec 28, 2016 · CC-CCJ · Destroyed
- [NTSB DCA17WA047](https://openairdocs.org/ntsb/DCA17WA047.md): Boeing 737 · Dabolim, Goa, India · Accident · Minor injuries · Foreign investigation · Dec 27, 2016 · VT-JBG · Substantial damage
  > The India Air Accident Investigation Bureau (AAIB) has notified the NTSB of an accident involving a Boeing 737-800 airplane that occurred on December 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…
- [NTSB CEN17LA061](https://openairdocs.org/ntsb/CEN17LA061.md): Mead RV 8A · Farmington, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 2016 · N918KS · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff in crosswind conditions.
- [NTSB DCA17WA044](https://openairdocs.org/ntsb/DCA17WA044.md): Boeing 727 · Puerto Carreno, Colombia · Accident · 3 fatal · Foreign investigation · Dec 20, 2016 · HK4544 · Destroyed
  > The Accident Investigation Group (AIG) of Colombia has notified the NTSB of an accident involving a Boeing 727 airplane that occurred on December 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Colombia's investigation…
- [NTSB CEN17LA057](https://openairdocs.org/ntsb/CEN17LA057.md): Stinson 108-3 · Ionia, MI · Accident · No injuries · Limited investigation · Final report · Dec 16, 2016 · N812C · Substantial damage
  > A failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.
- [NTSB GAA17CA101](https://openairdocs.org/ntsb/GAA17CA101.md): Maule MX 7 · Willow, AK · Accident · No injuries · Data collection · Final report · Dec 15, 2016 · N56681 · Substantial damage
  > The pilot’s failure to ensure that the runway was clear of any obstacles before departure, which resulted in the airplane impacting a snowdrift.
- [NTSB ERA17WA080](https://openairdocs.org/ntsb/ERA17WA080.md): Neiva EMB-721D · Manaus, Brazil · Accident · 6 fatal · Foreign investigation · Dec 7, 2016 · PT-REI · Destroyed
  > On December 7, 2016, about 1150 UTC, an Industria Aeronautica Neiva S/A EMB 721D, Brazilian registration PT-REI, registered to and operated by a foreign individual, collided with trees then terrain shortly after takeoff. Visual meteorological conditions…
- [NTSB ERA17LA063](https://openairdocs.org/ntsb/ERA17LA063.md): Cirrus Design SR22 · Bluefield, WV · Accident · No injuries · Limited investigation · Final report · Nov 22, 2016 · N217CE · Substantial damage
  > The pilot's failure to maintain directional control during the aborted takeoff.
- [NTSB CEN17LA042](https://openairdocs.org/ntsb/CEN17LA042.md): Northwing Navajo · Daingerfield, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2016 · N360XL · Substantial damage
  > The noncertificated pilot’s unfamiliarity with the aircraft, which resulted in a loss of control during an unintentional takeoff.
- [NTSB GAA17CA081](https://openairdocs.org/ntsb/GAA17CA081.md): Cessna 172 · Destin, FL · Accident · No injuries · Data collection · Final report · Nov 17, 2016 · N9358L · Substantial damage
  > The student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.
- [NTSB GAA17CA070](https://openairdocs.org/ntsb/GAA17CA070.md): Robinson Helicopter R44 · Stone Lake, WI · Accident · Minor injuries · Data collection · Final report · Nov 12, 2016 · N744JS · Substantial damage
  > The pilot’s failure to maintain lateral control while in a hover and the helicopter’s subsequent impact with a tree.
- [NTSB WPR17LA019](https://openairdocs.org/ntsb/WPR17LA019.md): Bell 206B · Yuma, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 2016 · N914HH · Substantial damage
  > The pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.
- [NTSB GAA17CA073](https://openairdocs.org/ntsb/GAA17CA073.md): Carter Richard L Buddy Baby Lakes · Hurricane, UT · Accident · No injuries · Data collection · Final report · Nov 10, 2016 · N1028Q · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB GAA17CA076](https://openairdocs.org/ntsb/GAA17CA076.md): Cessna 172 · Salmon, ID · Accident · No injuries · Data collection · Final report · Nov 8, 2016 · N737MY · Substantial damage
  > The airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.
- [NTSB GAA17CA057](https://openairdocs.org/ntsb/GAA17CA057.md): Piper PA18 · Mouth of The Big Susitna River, AK · Accident · No injuries · Data collection · Final report · Nov 7, 2016 · N62744 · Substantial damage
  > The pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.
- [NTSB GAA17CA056](https://openairdocs.org/ntsb/GAA17CA056.md): Beech 76 · Davis, CA · Accident · No injuries · Data collection · Final report · Nov 5, 2016 · N6703L · Substantial damage
  > The pilot's failure to maintain directional control during a simulated left engine failure during takeoff. Also causal to the accident was the flight instructor's delayed remedial action to maintain directional control and reduce the right engine mixture…
- [NTSB CEN17FA035](https://openairdocs.org/ntsb/CEN17FA035.md): Stamper RV-10 · Dubois, WY · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2016 · N924WY · Destroyed
  > The pilot's failure to maintain adequate airspeed after becoming distracted by the opening of the gull-wing cabin door during takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low…
- [NTSB CEN17LA029](https://openairdocs.org/ntsb/CEN17LA029.md): Beech 100 · Jeffersonville, IN · Accident · No injuries · Limited investigation · Final report · Oct 30, 2016 · N411HA · Substantial damage
  > The pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…
- [NTSB DCA17FA021](https://openairdocs.org/ntsb/DCA17FA021.md): Boeing 767 · Chicago, IL · Accident · Serious injuries · Class 1 · Field · Final report · Oct 28, 2016 · N345AN · Substantial damage
  > The failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…
- [NTSB CEN17LA031](https://openairdocs.org/ntsb/CEN17LA031.md): Piper PA 28-236 · Lexington, MO · Accident · No injuries · Limited investigation · Final report · Oct 27, 2016 · N4376V · Substantial damage
  > A total loss of engine power during takeoff for reasons that could not be determined based on available information.
- [NTSB CEN17FA026](https://openairdocs.org/ntsb/CEN17FA026.md): Roe Cleo Wittman Tailwind W10 · Pearland, TX · Accident · 1 fatal · Field investigation · Final report · Oct 26, 2016 · N557CL · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…
- [NTSB CEN17LA032](https://openairdocs.org/ntsb/CEN17LA032.md): Boeing A75N1 (PT17) · Ingleside, TX · Accident · No injuries · Limited investigation · Final report · Oct 25, 2016 · N48182 · Substantial damage
  > The pilot's failure to maintain proper yaw and roll control during takeoff, which resulted in excessive adverse yaw upon liftoff.
- [NTSB CEN17LA025](https://openairdocs.org/ntsb/CEN17LA025.md): Cessna 182Q · Buffalo, WY · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 2016 · N97878 · Substantial damage
  > The pilot’s failure to set the proper flap position before the short field takeoff, which resulted in a runway excursion and impact with terrain.
- [NTSB WPR17LA009](https://openairdocs.org/ntsb/WPR17LA009.md): Gray Jim Robert Exec 90 · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Oct 19, 2016 · N716JB · Substantial damage
  > The pilot's failure to properly tighten the tension bolts during the installation of the alternator belt, which resulted in inadequate voltage to sustain ignition and the subsequent partial loss of engine power.
- [NTSB GAA17CA033](https://openairdocs.org/ntsb/GAA17CA033.md): Stinson 108 3 · Boulder City, NV · Accident · Minor injuries · Data collection · Final report · Oct 19, 2016 · N818C · Substantial damage
  > The pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.
- [NTSB GAA17CA042](https://openairdocs.org/ntsb/GAA17CA042.md): Cessna 152 · Miami, FL · Accident · No injuries · Data collection · Final report · Oct 17, 2016 · N46953 · Substantial damage
  > The student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.
- [NTSB ERA17LA020](https://openairdocs.org/ntsb/ERA17LA020.md): Taylorcraft BC12 D · Vaughn, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2016 · N94919 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17WA017](https://openairdocs.org/ntsb/CEN17WA017.md): Cessna F150 · Cambridge, United Kingdom · Accident · 1 fatal · Foreign investigation · Oct 17, 2016 · G-BDZC · Substantial damage
  > On October 17, 2016, at 1021 coordinated universal time, a Reims Cessna F150M airplane, G-BDZC, crashed after takeoff at the Bourn Airfield (EGSN), Cambridge, United Kingdom. The pilot was fatally injured.The accident investigation is under the jurisdiction…
- [NTSB GAA17CA051](https://openairdocs.org/ntsb/GAA17CA051.md): Cessna 152 · Chickaloon, AK · Accident · No injuries · Data collection · Final report · Oct 14, 2016 · N488E · Substantial damage
  > The flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.
- [NTSB GAA17CA020](https://openairdocs.org/ntsb/GAA17CA020.md): Remos Remos GX · Lowell, AR · Accident · No injuries · Data collection · Final report · Oct 11, 2016 · N27GX · Substantial damage
  > The pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.
- [NTSB DCA17WA006](https://openairdocs.org/ntsb/DCA17WA006.md): Boeing 777 · Melbourne, Australia · Incident · No injuries · Foreign investigation · Oct 9, 2016 · 9V-SYG · Minor damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on October 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB GAA17CA014](https://openairdocs.org/ntsb/GAA17CA014.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Oct 6, 2016 · N602ND · Substantial damage
  > The flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.
- [NTSB GAA17CA011](https://openairdocs.org/ntsb/GAA17CA011.md): Fuller Neil H Glasair SH 2 · Bellingham, WA · Accident · No injuries · Data collection · Final report · Oct 5, 2016 · N724NF · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.
- [NTSB WPR17CA001](https://openairdocs.org/ntsb/WPR17CA001.md): Cessna R172K · Rosamond, CA · Accident · No injuries · Data collection · Final report · Oct 2, 2016 · N736LZ · Substantial damage
  > The pilot's improper use of the control lock, combined with his incomplete execution of two pre-departure procedures, which resulted in a takeoff with the control lock installed.
- [NTSB CEN17LA001](https://openairdocs.org/ntsb/CEN17LA001.md): Drake Kitfox Speedster · Jennings, LA · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2016 · N157D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.
- [NTSB DCA16WA227](https://openairdocs.org/ntsb/DCA16WA227.md): Boeing 777 · Abu Dhabi, United Arab Emirates · Incident · No injuries · Foreign investigation · Sep 27, 2016 · A6-ETL · Minor damage
  > The General Civil Aviation Authority (GCAA) of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on September 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation…
- [NTSB ANC16LA071](https://openairdocs.org/ntsb/ANC16LA071.md): Helio H-295 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Sep 26, 2016 · N68857 · Substantial damage
  > The pilot’s decision to take off from a wet, snowy airstrip and his delayed decision to abort the takeoff, which resulted in a runway excursion.
- [NTSB GAA16CA526](https://openairdocs.org/ntsb/GAA16CA526.md): Six Chuter Legend XL · Arcadia, FL · Accident · No injuries · Data collection · Final report · Sep 24, 2016 · N149SC · Substantial damage
  > The pilot’s decision to take off in high-density altitude conditions, which resulted in the powered parachute being unable to maintain a sufficient climb rate and its subsequent impact with power lines.
- [NTSB GAA16CA503](https://openairdocs.org/ntsb/GAA16CA503.md): Cessna 185 · Fairbanks, AK · Accident · Minor injuries · Data collection · Final report · Sep 22, 2016 · N5892T · Substantial damage
  > The pilot’s failure to recognize he was taking off with a tailwind and his inadequate compensation for taking off with a tailwind, which led to the airplane’s failure to attain a climb and a subsequent forced landing.
- [NTSB CEN16FA378](https://openairdocs.org/ntsb/CEN16FA378.md): Piper PA 28-235 · Lee's Summit, MO · Accident · 2 fatal · Field investigation · Final report · Sep 20, 2016 · N8983W · Substantial damage
  > The pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.
- [NTSB ENG16IA037](https://openairdocs.org/ntsb/ENG16IA037.md): Airbus A320 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Sep 19, 2016 · P4-AAA · Minor damage
  > the incorrect latching of the #2 Engine Fan Cowl following a routine maintenance check that resulted in separation of the cowl during takeoff.
- [NTSB CEN16LA375](https://openairdocs.org/ntsb/CEN16LA375.md): Piper PA 32R-300 · Grants, NM · Accident · No injuries · Limited investigation · Final report · Sep 19, 2016 · N4477F · Destroyed
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR16LA185](https://openairdocs.org/ntsb/WPR16LA185.md): Hoover David Arnold AR 6 · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 2016 · N616DH · 2 aircraft · Substantial damage
  > The pilot of Race 11’s failure to maintain clearance from Race 1 during takeoff, and the insufficient abort procedures specified within the race rules. Contributing to the accident was the pilot of Race 1’s decision to shut down the engine on the runway and…
- [NTSB GAA16CA499](https://openairdocs.org/ntsb/GAA16CA499.md): Alex Michael Bantum/Tercel USA TERCEL-GYROPLANE · Blairstown, NJ · Accident · No injuries · Data collection · Final report · Sep 17, 2016 · N528WM · Substantial damage
  > The student pilot’s incorrect takeoff procedure, which resulted in a loss of main rotor rpm and the subsequent loss of directional control and runway excursion.
- [NTSB GAA16CA498](https://openairdocs.org/ntsb/GAA16CA498.md): Airtime Cygnet · Venice, FL · Accident · No injuries · Data collection · Final report · Sep 16, 2016 · N145AT · Substantial damage
  > The student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action, which resulted in a runway excursion.
- [NTSB ANC16LA067](https://openairdocs.org/ntsb/ANC16LA067.md): Helio H 295 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 2016 · N6464V · Substantial damage
  > Excessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.
- [NTSB WPR16FA176](https://openairdocs.org/ntsb/WPR16FA176.md): Cessna 310N · Wickenburg, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 9, 2016 · N126P · Substantial damage
  > Total loss of power to the right engine during takeoff due to a fuel contaminant, which blocked the fuel flow transducer and resulted in fuel starvation to the engine.
- [NTSB GAA16CA477](https://openairdocs.org/ntsb/GAA16CA477.md): Pacific Aerospace 750XL · Warrenton, VA · Accident · No injuries · Data collection · Final report · Sep 9, 2016 · N750SS · Substantial damage
  > The pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.
- [NTSB GAA16CA478](https://openairdocs.org/ntsb/GAA16CA478.md): Cessna 180 · Clemson, SC · Accident · No injuries · Data collection · Final report · Sep 5, 2016 · N451SW · Substantial damage
  > The pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.
- [NTSB GAA16CA486](https://openairdocs.org/ntsb/GAA16CA486.md): Champion 7GC · Palmer, AK · Accident · No injuries · Data collection · Final report · Sep 4, 2016 · N4831E · Substantial damage
  > The pilot’s inadequate preflight inspection and failure to assess the airplane’s fuel quantity before departure, which resulted in fuel exhaustion.

Next page: https://openairdocs.org/ntsb-phases/300/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 = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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