# NTSB investigations, 2017: 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 · 195 cases

## Latest cases

- [NTSB ERA18WA061](https://openairdocs.org/ntsb/ERA18WA061.md): Cessna A188 · Dom Pedrito, Brazil · Accident · 1 fatal · Foreign investigation · Dec 30, 2017 · PR-MLY · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB CEN18LA052](https://openairdocs.org/ntsb/CEN18LA052.md): Piper PA 28R-200 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Dec 25, 2017 · N550D · Substantial damage
  > The pilot's loss of directional control during the rejected takeoff. Contributing to the accident were the pilot's lack of familiarity with the airport runway configuration, which led to his premature attempt to take off, and the airplane’s inoperative…
- [NTSB ERA18WA057](https://openairdocs.org/ntsb/ERA18WA057.md): Cessna 172 · Providenciales, Turks & Caicos Islands · Accident · 2 fatal · Foreign investigation · Dec 24, 2017 · PR-RTS · Destroyed
  > The government of the United Kingdom has notified the NTSB of an accident involving a Cessna 172S airplane that occurred on December 24, 2017, in Turks and Caicos Islands. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accidents…
- [NTSB CEN18FA061](https://openairdocs.org/ntsb/CEN18FA061.md): Cessna 340 · Bartow, FL · Accident · 5 fatal · Field investigation · Final report · Dec 24, 2017 · N247AT · Destroyed
  > The pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.
- [NTSB WPR18FA053](https://openairdocs.org/ntsb/WPR18FA053.md): Browning Gregory S Zodiac 601XL · Thompson's Station, TN · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2017 · N929GB · Substantial damage
  > The sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA18LA054](https://openairdocs.org/ntsb/ERA18LA054.md): Cessna 177 · Ridgeland, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 2017 · N3179T · Substantial damage
  > The student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.
- [NTSB ENG18WA024](https://openairdocs.org/ntsb/ENG18WA024.md): Antonov TVS-2MS · Naryan-Mar, Russia · Accident · No injuries · Foreign investigation · Dec 19, 2017 · RA-01460 · Destroyed
  > A TVS-2MS airplane powered by a Honeywell TPE331-12UHR-702H and equipped with skids impacted unpaved runway after an aborted takeoff. The airplane was completed destroyed. The Russian Interstate Aviation Committee (MAK) is investigating.
- [NTSB CEN18LA065](https://openairdocs.org/ntsb/CEN18LA065.md): Piper PA-28-201T · Versailles, MO · Accident · No injuries · Limited investigation · Final report · Dec 19, 2017 · N555WM · Substantial damage
  > The total loss of engine power due to fuel starvation when the cap fitting came off the inlet tee fitting on the throttle body/fuel metering unit.
- [NTSB GAA18CA105](https://openairdocs.org/ntsb/GAA18CA105.md): Golden Circle Air T Bird II · Wiscassett, ME · Accident · No injuries · Data collection · Final report · Dec 17, 2017 · N5619Z · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB ERA18LA048](https://openairdocs.org/ntsb/ERA18LA048.md): Cessna 150 · Castalia, NC · Accident · 1 fatal · Limited investigation · Final report · Dec 16, 2017 · N7929Z · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while performing a turning takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's decision to attempt the takeoff, which he believed…
- [NTSB ENG18WA016](https://openairdocs.org/ntsb/ENG18WA016.md): Aerospatiale ATR 42-320 · Fond-du-Lac, Canada · Accident · No injuries · Foreign investigation · Dec 14, 2017 · C-GWEA · Destroyed
  > The Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale ATR 42-320, which occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…
- [NTSB GAA18CA089](https://openairdocs.org/ntsb/GAA18CA089.md): Robinson Helicopter R44 · Newark, OH · Accident · Minor injuries · Data collection · Final report · Dec 13, 2017 · N441ML · Substantial damage
  > The pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in dynamic rollover.
- [NTSB GAA18CA083](https://openairdocs.org/ntsb/GAA18CA083.md): Michael Adamczyk Zenith CH750 · Franklin, PA · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N750AD · Substantial damage
  > The pilot’s excessive application of aft stick during takeoff, which resulted in an aerodynamic stall. Contributing to this accident was the pilot’s inexperience in the airplane.
- [NTSB GAA18CA077](https://openairdocs.org/ntsb/GAA18CA077.md): Czech Sport Aircraft a.s. Sport Cruiser · Sacramento, CA · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N227US · Destroyed
  > The pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.
- [NTSB GAA18CA078](https://openairdocs.org/ntsb/GAA18CA078.md): Cessna 172 · Everett, WA · Accident · No injuries · Data collection · Final report · Dec 8, 2017 · N4801D · Substantial damage
  > The pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.
- [NTSB GAA18CA079](https://openairdocs.org/ntsb/GAA18CA079.md): Boeing A75N1(PT17) · Chino, CA · Accident · No injuries · Data collection · Final report · Dec 3, 2017 · N1431C · Substantial damage
  > The pilot’s failure to maintain directional control during a touch-and-go landing.
- [NTSB GAA18CA067](https://openairdocs.org/ntsb/GAA18CA067.md): Todd Foley Zenith 701 · Mount Airy, NC · Accident · No injuries · Data collection · Final report · Dec 1, 2017 · N701TF · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.
- [NTSB GAA18CA076](https://openairdocs.org/ntsb/GAA18CA076.md): Cessna 152 · Fullerton, CA · Accident · No injuries · Data collection · Final report · Nov 30, 2017 · N417CB · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff.
- [NTSB GAA18CA059](https://openairdocs.org/ntsb/GAA18CA059.md): Mooney M20 · Tucson, AZ · Accident · No injuries · Data collection · Final report · Nov 26, 2017 · N6002Q · Substantial damage
  > The pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.
- [NTSB WPR18LA036](https://openairdocs.org/ntsb/WPR18LA036.md): Doshier Wilbert A GT-500 · Willows, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 25, 2017 · N599RA · Substantial damage
  > A loss of engine power during takeoff due a coolant leak and the subsequent overheating of the engine, and the student pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall…
- [NTSB ERA18LA031](https://openairdocs.org/ntsb/ERA18LA031.md): Piper PA46 · Clearwater, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2017 · N863RB · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18LA041](https://openairdocs.org/ntsb/CEN18LA041.md): Cessna 182S · Bolingbrook, IL · Accident · No injuries · Limited investigation · Final report · Nov 22, 2017 · N7111W · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB CEN18LA039](https://openairdocs.org/ntsb/CEN18LA039.md): Piper PA 12 · Dickinson, ND · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 2017 · N4040M · Substantial damage
  > The pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB ERA18LA038](https://openairdocs.org/ntsb/ERA18LA038.md): Beech B 55 · Statesville, NC · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2017 · N592SS · Substantial damage
  > A total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.
- [NTSB DCA18WA025](https://openairdocs.org/ntsb/DCA18WA025.md): Boeing 737 · Singapore, Singapore · Incident · No injuries · Foreign investigation · Nov 16, 2017 · VP-CAM · Minor damage
  > The TSIB of Singapore has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB's investigation under the provisions of ICAO Annex 13 as…
- [NTSB WPR18LA031](https://openairdocs.org/ntsb/WPR18LA031.md): Robinson Helicopter R44 · Page, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2017 · N744BS · Substantial damage
  > The pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.
- [NTSB DCA18WA030](https://openairdocs.org/ntsb/DCA18WA030.md): Boeing 747 · Maastricht, Netherlands · Incident · No injuries · Foreign investigation · Nov 11, 2017 · TC-ACR · No damage
  > The Dutch Safety Board has notified the NTSB of an incident involving a Boeing 747, which occurred on November 11, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of Manufacture and…
- [NTSB ERA18WA025](https://openairdocs.org/ntsb/ERA18WA025.md): Quest Kodiac 100 · Goias, Brazil · Accident · Serious injuries · Foreign investigation · Nov 10, 2017 · N154KQ · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a QUEST AIRCRAFT COMPANY LLC KODIAC 100 airplane that occurred on November 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's…
- [NTSB GAA18CA047](https://openairdocs.org/ntsb/GAA18CA047.md): Cessna 140 · Macon, GA · Accident · No injuries · Data collection · Final report · Nov 8, 2017 · N76238 · Substantial damage
  > The pilot's incorrect pitch control during takeoff, which resulted in a nose-over.
- [NTSB ERA18LA023](https://openairdocs.org/ntsb/ERA18LA023.md): Great Lakes 2T1A · Montague, MA · Accident · No injuries · Limited investigation · Final report · Nov 2, 2017 · N3512L · Substantial damage
  > The pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.
- [NTSB WPR18LA020](https://openairdocs.org/ntsb/WPR18LA020.md): Cessna 140 · Port Townsend, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 30, 2017 · N72339 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ANC18WA076](https://openairdocs.org/ntsb/ANC18WA076.md): Piper PA34 · Calgary Springbank, Canada · Accident · 2 fatal · Foreign investigation · Oct 26, 2017 · C-GCCM · Substantial damage
  > On October 26, 2017, about 0952 mountain daylight time, a Piper PA-34-200T airplane, C-GCCM, departed controlled flight and impacted terrain shortly after takeoff from Calgary Springbank Airport (CYBW), Alberta, Canada. The flight instructor and pilot…
- [NTSB WPR18WA017](https://openairdocs.org/ntsb/WPR18WA017.md): Cessna 210 · Albany, Australia · Accident · 1 fatal · Foreign investigation · Oct 24, 2017 · VH-DBU · Destroyed
  > On October 24, 2017, at 1115 local time, a Cessna 210B, VH-DBU, was destroyed when it impacted the ground following a collision with terrain near Albany, Western Australia. The airplane was operated under the pertinent regulations of the Australian…
- [NTSB WPR18LA012](https://openairdocs.org/ntsb/WPR18LA012.md): Cirrus Design SR22T · San Carlos, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2017 · N3636E · Substantial damage
  > The pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…
- [NTSB CEN18LA015](https://openairdocs.org/ntsb/CEN18LA015.md): Cessna 150J · Willmar, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2017 · N50609 · Substantial damage
  > The pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.
- [NTSB WPR18WA025](https://openairdocs.org/ntsb/WPR18WA025.md): Quicksilver GT500 · Melaka, Malaysia · Accident · 1 fatal · Foreign investigation · Oct 14, 2017 · 9M-EAC · Destroyed
  > On October 14, 2017, about 1130 local time, a Quicksilver Aircraft GT-500, registration 9M-EAC, was destroyed after colliding with a river shortly after takeoff from Sungai Rambai Aerodrome, Melaka, Malaysia. The airplane was operated under the pertinent…
- [NTSB GAA18CA014](https://openairdocs.org/ntsb/GAA18CA014.md): Himsl Vincent S Vans RV-8 · Othello, WA · Accident · No injuries · Data collection · Final report · Oct 14, 2017 · N8432 · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll in crosswind conditions.
- [NTSB ERA18WA015](https://openairdocs.org/ntsb/ERA18WA015.md): Cessna U206 · Itaituba, Brazil · Accident · 1 fatal · Foreign investigation · Oct 11, 2017 · PT-LSC · Destroyed
  > On October 11, 2017, about 1600 universal coordinated time, a Cessna U206G, Brazilian registration PT-LSC, was destroyed when it collided with a tree during takeoff near Itaituba, State of Para, Brazil. The pilot was fatally injured, and one passenger…
- [NTSB CEN18LA012](https://openairdocs.org/ntsb/CEN18LA012.md): Globe GC 1A · Los Lunas, NM · Accident · 1 fatal · Limited investigation · Final report · Oct 9, 2017 · N90365 · Substantial damage
  > The loss of directional control during takeoff and impact with a steel culvert.
- [NTSB CEN18WA007](https://openairdocs.org/ntsb/CEN18WA007.md): Robinson R44 · Gramzda, Latvia · Accident · 1 fatal · Foreign investigation · Oct 8, 2017 · YL-HBH
  > On October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously…
- [NTSB GAA18CA006](https://openairdocs.org/ntsb/GAA18CA006.md): Maule M 7 · Manokatak, AK · Accident · No injuries · Data collection · Final report · Oct 7, 2017 · N81818 · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff in gusting wind conditions.
- [NTSB GAA18CA004](https://openairdocs.org/ntsb/GAA18CA004.md): Mooney M20 · Topping, VA · Accident · Minor injuries · Data collection · Final report · Oct 7, 2017 · N7884V · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall.
- [NTSB GAA18CA001](https://openairdocs.org/ntsb/GAA18CA001.md): Piper J3C · Yakima, WA · Accident · No injuries · Data collection · Final report · Oct 3, 2017 · N48694 · Substantial damage
  > The flight instructor's failure to maintain directional control during the takeoff roll.
- [NTSB DCA17WA215](https://openairdocs.org/ntsb/DCA17WA215.md): Boeing 737 · Budapest, Hungary · Incident · No injuries · Foreign investigation · Sep 29, 2017 · EI-FRR · No damage
  > The Ministry of National Development Transport Safety Bureau of Hungary has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB DCA17WA216](https://openairdocs.org/ntsb/DCA17WA216.md): Boeing 737 · Luga, Malta · Incident · No injuries · Foreign investigation · Sep 28, 2017 · G-FDZJ · No damage
  > The United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…
- [NTSB DCA17WA203](https://openairdocs.org/ntsb/DCA17WA203.md): Airbus A330 · Hong Kong, Hong Kong SAR China · Incident · No injuries · Foreign investigation · Sep 22, 2017 · B-LNS · 2 aircraft · No damage
  > The Civil Aviation Department of Hong Kong has notified the NTSB of an incident involving a BOEING 747-433 airplane that occurred on September 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Government of the…
- [NTSB GAA17CA552](https://openairdocs.org/ntsb/GAA17CA552.md): Hencken William Pietenpol AIR Camper · Franklin, PA · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N40WH · Substantial damage
  > The failure of the weld that connects the left main landing gear and the axle during the takeoff roll.
- [NTSB GAA17CA547](https://openairdocs.org/ntsb/GAA17CA547.md): Cessna 180 · Albuquerque, NM · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N180SA · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll in gusting crosswind conditions.
- [NTSB GAA17CA546](https://openairdocs.org/ntsb/GAA17CA546.md): Cessna 150 · Siler City, NC · Accident · No injuries · Data collection · Final report · Sep 20, 2017 · N6250T · Substantial damage
  > The pilot's improper decision to take off with known electrical issues, which distracted him and led to a loss of directional control during the takeoff roll.
- [NTSB DCA17WA200](https://openairdocs.org/ntsb/DCA17WA200.md): Boeing Boeing 737-8AS · London, United Kingdom · Incident · No injuries · Foreign investigation · Sep 15, 2017 · EI-DLV · Minor damage
  > The AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…

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

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