# NTSB investigations: 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 37 of 281 · 14,035 cases

## Cases, newest first

- [NTSB CEN17LA303](https://openairdocs.org/ntsb/CEN17LA303.md): Cessna A188B · Marshall, MO · Accident · No injuries · Limited investigation · Final report · Aug 4, 2017 · N3047J · Substantial damage
  > The pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…
- [NTSB CEN17LA312](https://openairdocs.org/ntsb/CEN17LA312.md): Ralph Marine Devil DOG · Danville, AR · Accident · No injuries · Limited investigation · Final report · Aug 3, 2017 · N165AB · Substantial damage
  > A separation of the left tire from its wheel because of the use of an improper substance and wheel size, which resulted in a loss of directional control during landing.
- [NTSB ERA17LA263](https://openairdocs.org/ntsb/ERA17LA263.md): Sikorsky S-97A · Jupiter, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 2017 · N971SK · Substantial damage
  > A design change in the helicopter's fly-by-wire control system that resulted in an increase in the sensitivity of the cyclic stick while transitioning from ground to flight mode, magnifying the pilot's control inputs, which resulted in unintentional over…
- [NTSB CEN17RA377](https://openairdocs.org/ntsb/CEN17RA377.md): Mcdonnell Douglas MD900 · Heiligenblut, Austria · Accident · Minor injuries · Foreign investigation · Aug 1, 2017 · OE-XWF · Substantial damage
  > On August 1, 2017, at 1815 UTC, a McDonnell Douglas MD 900 Helicopter, Austrian registration OE-XWF, impacted mountainous terrain about 8 miles west-northwest of Heiligenblut, Austria. One medical crewmember sustained minor injuries. The pilot, the other…
- [NTSB GAA17CA450](https://openairdocs.org/ntsb/GAA17CA450.md): Robinson Helicopter R44 · Dunlap, IL · Accident · Minor injuries · Data collection · Final report · Jul 31, 2017 · N344MM · Substantial damage
  > The pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.
- [NTSB CEN17LA293](https://openairdocs.org/ntsb/CEN17LA293.md): Chapman T-BIRD II · Potosi, MO · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 2017 · N204BC · Substantial damage
  > The pilot's loss of airplane control during a departure turn for reasons that could not be determined.
- [NTSB GAA17CA480](https://openairdocs.org/ntsb/GAA17CA480.md): Thomas J Hankamp VAN'S Aircraft RV4 · Poughkeepsie, NY · Accident · No injuries · Data collection · Final report · Jul 28, 2017 · N9214 · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB CEN17FA287](https://openairdocs.org/ntsb/CEN17FA287.md): Aerofab Lake LA 4 250 · Oshkosh, WI · Accident · 2 fatal · Field investigation · Final report · Jul 28, 2017 · N1400P · Substantial damage
  > The pilot's failure to properly configure the airplane for takeoff and his decision to takeoff with a tailwind in unfavorable water conditions, which resulted in the airplane entering an aerodynamic stall and the pilot losing control.
- [NTSB WPR17LA167](https://openairdocs.org/ntsb/WPR17LA167.md): Robinson Helicopter R44 II · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Jul 27, 2017 · N7535G · Substantial damage
  > The pilot's failure to maintain helicopter control while maneuvering during takeoff.
- [NTSB CEN17WA291](https://openairdocs.org/ntsb/CEN17WA291.md): Cessna 402 · British Virgin Islands, British Virgin Islands · Incident · No injuries · Foreign investigation · Jul 27, 2017 · N618CA · No damage
  > On July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…
- [NTSB WPR17LA164](https://openairdocs.org/ntsb/WPR17LA164.md): Piper PA 28R-180 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Jul 23, 2017 · N4594J · Substantial damage
  > Maintenance personnel's incorrect installation of the aileron control cables and subsequent failure to verify proper aileron functionality following the maintenance, which resulted in roll control that was opposite of that commanded by the pilot, and the…
- [NTSB GAA17CA440](https://openairdocs.org/ntsb/GAA17CA440.md): Mitchell Derryle V Rans S 7 Courier · Cordova, AK · Accident · No injuries · Data collection · Final report · Jul 23, 2017 · N6333Y · Substantial damage
  > The pilot’s improper decision to take off from a lake in gusting wind conditions, which resulted in a loss of airplane control.
- [NTSB GAA17CA429](https://openairdocs.org/ntsb/GAA17CA429.md): Cirrus Design SR22 · Edgartown, MA · Accident · No injuries · Data collection · Final report · Jul 23, 2017 · N831SR · Substantial damage
  > The airplane’s collision with geese during the takeoff roll.
- [NTSB WPR17LA160](https://openairdocs.org/ntsb/WPR17LA160.md): Cessna 182L · Arbuckle, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 2017 · N42143 · Substantial damage
  > The pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.
- [NTSB GAA17CA439](https://openairdocs.org/ntsb/GAA17CA439.md): Cessna A185 · Arctic Village, AK · Accident · No injuries · Data collection · Final report · Jul 22, 2017 · N5227R · Substantial damage
  > The pilot’s failure to maintain directional control after an aborted takeoff.
- [NTSB GAA17CA435](https://openairdocs.org/ntsb/GAA17CA435.md): Gilbert Thomas Jeffrey Lancair 235 · Denison, TX · Accident · No injuries · Data collection · Final report · Jul 22, 2017 · N91JG · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB GAA17CA433](https://openairdocs.org/ntsb/GAA17CA433.md): Stinson SR9 · Bode, IA · Accident · No injuries · Data collection · Final report · Jul 22, 2017 · N83K · Substantial damage
  > The pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.
- [NTSB GAA17CA574](https://openairdocs.org/ntsb/GAA17CA574.md): Cessna 208 · New York, NY · Accident · No injuries · Data collection · Final report · Jul 21, 2017 · N802TW · Substantial damage
  > The airplane’s encounter with boat wake and multiple swells during a water takeoff.
- [NTSB DCA17WA157](https://openairdocs.org/ntsb/DCA17WA157.md): Boeing 737-86J · Belfast, United Kingdom · Incident · No injuries · Foreign investigation · Jul 21, 2017 · C-FWGH
  > The United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 737-86J airplane that occurred on July 21, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO…
- [NTSB ANC17CA038](https://openairdocs.org/ntsb/ANC17CA038.md): Dehavilland DHC 2 · Dilllingham, AK · Accident · No injuries · Data collection · Final report · Jul 21, 2017 · N364RA · Substantial damage
  > The pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.
- [NTSB GAA17CA424](https://openairdocs.org/ntsb/GAA17CA424.md): Salerno Kenneth G JR Kitfox Series 7 · Owyhee, OR · Accident · Minor injuries · Data collection · Final report · Jul 18, 2017 · N702KF · Substantial damage
  > The pilot's failure to maintain directional control during takeoff from a rough, dirt airstrip.
- [NTSB CEN17LA275](https://openairdocs.org/ntsb/CEN17LA275.md): Golden Circle Air T-BIRD II · Dunn Center, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 2017 · UNREG · Substantial damage
  > The pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.
- [NTSB DCA17WA166](https://openairdocs.org/ntsb/DCA17WA166.md): Boeing 747-87UF · Narita, Japan · Incident · No injuries · Foreign investigation · Jul 15, 2017 · N852GT · Minor damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 747-87UF airplane that occurred on July 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…
- [NTSB CEN17LA274](https://openairdocs.org/ntsb/CEN17LA274.md): Endler Glasair/Glasair 1-Td SH2 · Colorado Springs, CO · Accident · No injuries · Limited investigation · Final report · Jul 15, 2017 · N181AL · Destroyed
  > The pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…
- [NTSB GAA17CA407](https://openairdocs.org/ntsb/GAA17CA407.md): Gerald Donovan Rans S-16 · Los Lunas, NM · Accident · No injuries · Data collection · Final report · Jul 12, 2017 · N116GD · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB GAA17CA403](https://openairdocs.org/ntsb/GAA17CA403.md): Luscombe 8 · Grand Island, NE · Accident · No injuries · Data collection · Final report · Jul 6, 2017 · N45609 · Substantial damage
  > The student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action.
- [NTSB ERA17WA228](https://openairdocs.org/ntsb/ERA17WA228.md): Bell 206 · Republic of Buryatia, Russia · Accident · 1 fatal · Foreign investigation · Jul 5, 2017 · RA-01625 · Substantial damage
  > The government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…
- [NTSB CEN17LA257](https://openairdocs.org/ntsb/CEN17LA257.md): Cessna 182T · Jackson, MI · Accident · No injuries · Limited investigation · Final report · Jul 5, 2017 · CGBFY · Substantial damage
  > The pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.
- [NTSB GAA17CA383](https://openairdocs.org/ntsb/GAA17CA383.md): Robinson Helicopter R44 · Easton, PA · Accident · No injuries · Data collection · Final report · Jul 4, 2017 · N3025J · Substantial damage
  > The pilot’s distraction during liftoff due to the tail rotor chip warning light illuminating, which resulted in the helicopter drifting right, the skid touching down, and a dynamic roll-over.
- [NTSB ERA17WA238](https://openairdocs.org/ntsb/ERA17WA238.md): Cessna 210M · Cantá Municipality, State, Brazil · Accident · 4 fatal · Foreign investigation · Jul 3, 2017 · PR-MFR · Substantial damage
  > On July 3, 2017, about 1500 universal time coordinated, a Cessna 210M, Brazilian registration PR-MFR, was destroyed when it impacted terrain near Canta Municipality, State of Roraima, Brazil. The pilot and three passengers were fatally injured and one…
- [NTSB ERA17LA225](https://openairdocs.org/ntsb/ERA17LA225.md): Piper PA 15 · Farmville, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 3, 2017 · N4195H · Destroyed
  > The pilot’s improper decision to depart from an unsuitable off-airport surface which resulted in his subsequent exceedance of the airplane's critical angle of attack, an aerodynamic stall and loss of control.
- [NTSB CEN17LA251](https://openairdocs.org/ntsb/CEN17LA251.md): Cody Hawkins JA30 Superstol · Ponca City, OK · Accident · No injuries · Limited investigation · Final report · Jul 2, 2017 · N2463H · Substantial damage
  > Contamination of the fuel system, resulting in a partial loss of engine power and subsequent off-airport landing.
- [NTSB CEN17WA262](https://openairdocs.org/ntsb/CEN17WA262.md): Embraer ERJ190 · Mérida, Yucatán, Mexico · Incident · No injuries · Foreign investigation · Jun 30, 2017 · XA-GAH · Minor damage
  > On June 30, 2017, at 2133 universal coordinated time, an Embraer ERJ190 airplane, XA-GAH, experienced an engine problem and returned to the Manuel Crescencio Rejón International Airport (MMMD), Mérida, Yucatán. The aircrew performed a precautionary landing…
- [NTSB GAA17CA370](https://openairdocs.org/ntsb/GAA17CA370.md): Aero-Ace CE 1 · Cottonwood, AZ · Accident · Minor injuries · Data collection · Final report · Jun 26, 2017 · N473CQ · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.
- [NTSB ERA17LA217](https://openairdocs.org/ntsb/ERA17LA217.md): Barnes Richard B/Howe Michael Vans RV 10 · Blairsville, GA · Accident · No injuries · Limited investigation · Final report · Jun 26, 2017 · N865HB · Substantial damage
  > The pilot’s loss of directional control upon landing.
- [NTSB CEN17LA238](https://openairdocs.org/ntsb/CEN17LA238.md): Aeronca 7BCM · Mahnomen, MN · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 2017 · N2558E · Substantial damage
  > The pilot’s failure to abort the takeoff after recognizing a partial loss of engine power during the takeoff roll and his subsequent inability to maintain adequate airspeed during a turn to avoid power lines, which resulted in an aerodynamic stall. The…
- [NTSB GAA17CA358](https://openairdocs.org/ntsb/GAA17CA358.md): Vans RV-12 · Eugene, OR · Accident · No injuries · Data collection · Final report · Jun 20, 2017 · N234VA · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff.
- [NTSB GAA17CA350](https://openairdocs.org/ntsb/GAA17CA350.md): Ward Christopher Barry RAI 6 · Williston, FL · Accident · No injuries · Data collection · Final report · Jun 18, 2017 · N251CW · Substantial damage
  > The pilot’s failure to maintain the airplane’s pitch control during rotation and his subsequent loss of directional control.
- [NTSB ANC17LA032](https://openairdocs.org/ntsb/ANC17LA032.md): Dehavilland DHC-2 · Ketchikan, AK · Accident · Minor injuries · Class 2 · Limited · Final report · Jun 18, 2017 · N930TG · Substantial damage
  > The pilot's misjudgment of the takeoff distance needed to depart the lake, and his subsequent failure to maintain clearance from the water during a turn to avoid terrain, which resulted in impact with water.
- [NTSB GAA17CA359](https://openairdocs.org/ntsb/GAA17CA359.md): Cessna A188 · Salem, OR · Accident · No injuries · Data collection · Final report · Jun 14, 2017 · N4877Q · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.
- [NTSB GAA17CA341](https://openairdocs.org/ntsb/GAA17CA341.md): Cessna 172 · Galena, ID · Accident · No injuries · Data collection · Final report · Jun 14, 2017 · N9912Q · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.
- [NTSB ENG17IA028](https://openairdocs.org/ntsb/ENG17IA028.md): Bombardier CL 600 2C10 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 10, 2017 · N715SK · Minor damage
  > A Bombardier CRJ700 No. 1 engine failure caused by buckling of the combustion outer liner due to fatigue cracks. The liner buckling resulted in airflow disruption and reduced engine performance. The engine fuel control unit attempted to compensate for the…
- [NTSB CEN17LA229](https://openairdocs.org/ntsb/CEN17LA229.md): Hughes 269C · Tallulah, LA · Accident · No injuries · Limited investigation · Final report · Jun 10, 2017 · N7482F · Substantial damage
  > The pilot's failure to reset the cyclic trim before takeoff, which resulted in ground resonance.
- [NTSB GAA17CA336](https://openairdocs.org/ntsb/GAA17CA336.md): Piper PA 28 · Auburn, IN · Accident · No injuries · Data collection · Final report · Jun 8, 2017 · N4543R · Substantial damage
  > The pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.
- [NTSB CEN17LA224](https://openairdocs.org/ntsb/CEN17LA224.md): Mckenna SD-1A · Juneau, WI · Accident · No injuries · Limited investigation · Final report · Jun 7, 2017 · N31313 · Substantial damage
  > The pilot’s difficulty controlling the airplane due to his incorrect reinstallation of the wings, which led to a bounced precautionary landing. Contributing to the accident was the failure of the pilot and the mechanic to verify the wings’ angle of incidence.
- [NTSB GAA17CA323](https://openairdocs.org/ntsb/GAA17CA323.md): Air Tractor AT 802 · Prosser, WA · Accident · No injuries · Data collection · Final report · Jun 5, 2017 · N802NB · Substantial damage
  > The pilot’s abrupt maneuver to avoid hay bales during the takeoff roll, which resulted in a loss of directional control.
- [NTSB GAA17CA326](https://openairdocs.org/ntsb/GAA17CA326.md): Cessna 150 · Newburyport, MA · Accident · No injuries · Data collection · Final report · Jun 4, 2017 · N6511S · Substantial damage
  > The student pilot's decision to attempt to close the cockpit window during takeoff and his subsequent failure to maintain directional control.
- [NTSB DCA17WA138](https://openairdocs.org/ntsb/DCA17WA138.md): Boeing 737 · Lima, Peru · Incident · No injuries · Foreign investigation · Jun 3, 2017 · OB-2138-P · No damage
  > The Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…
- [NTSB CEN17LA206](https://openairdocs.org/ntsb/CEN17LA206.md): Kenneth B Hines Nieuport 28 · Boonville, MO · Accident · No injuries · Limited investigation · Final report · Jun 1, 2017 · N6165 · Substantial damage
  > A partial loss of engine power due to a compromised induction system.
- [NTSB ERA17WA193](https://openairdocs.org/ntsb/ERA17WA193.md): Cessna 172 · Chernihiv, Ukraine · Accident · 1 fatal · Foreign investigation · May 26, 2017 · UR-WTA · Substantial damage
  > On May 26, 2017, about 1200 coordinated universal time, a Cessna 172M, Ukrainian registration UR-WTA, was substantially damaged when it impacted a one-story building after takeoff from the Pivtsi Airport, Chernihiv, Ukraine. The pilot was fatally injured. The…

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=38

## 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 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?page=37

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