# NTSB investigations: Initial climb

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 87 of 412 · 20,559 cases

## Cases, newest first

- [NTSB FTW01LA109](https://openairdocs.org/ntsb/FTW01LA109.md): Hughes 269B · Nacogdoches, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2001 · N9508F · Substantial damage
  > the pilot's failure to maintain clearance with the wires during takeoff. Contributory factors were the sunglare and the unmarked wires.
- [NTSB DEN01LA093](https://openairdocs.org/ntsb/DEN01LA093.md): Piper PA-31-350 · St. George, UT · Accident · No injuries · Limited investigation · Final report · Apr 27, 2001 · N27367 · Substantial damage
  > the pilot's failure to sump all the fuel drains during preflight and the subsequent loss of power in the right engine during takeoff, the pilot feathering the wrong engine's propeller during the forced landing, the pilot improperly raising the landing gear…
- [NTSB DEN01FA090](https://openairdocs.org/ntsb/DEN01FA090.md): Piper PA-39 · Fort Collins, CO · Accident · Serious injuries · Field investigation · Final report · Apr 26, 2001 · N8984Y · Substantial damage
  > the loss of right engine power on take-off as a result of the separation of the right engine's alternate air door, which lodged in the fuel servo air inlet. A factor was the lack of suitable terrain for a forced landing.
- [NTSB LAX01LA154](https://openairdocs.org/ntsb/LAX01LA154.md): Piper PA-22-135 · Oxnard, CA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2001 · N75343 · Substantial damage
  > The fracture and separation of the number 3 cylinder exhaust valve head resulting in a loss of engine power and a forced landing. A factor in the accident was the soft field where the forced landing occurred.
- [NTSB SEA01LA076](https://openairdocs.org/ntsb/SEA01LA076.md): Cessna 172 N · Sultan, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 2001 · N8402E · Substantial damage
  > The pilot's failure to maintain adequate clearance from trees and terrain during the airplane's initial climb.
- [NTSB DEN01FA088](https://openairdocs.org/ntsb/DEN01FA088.md): Beech 35 · Glenwood Sprgs, CO · Accident · 1 fatal · Field investigation · Final report · Apr 17, 2001 · N2PZ · Destroyed
  > the pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush to the ground. Contributing factors were the pilot's lack of experience in make/model airplane, the high density altitude weather condition, and the pilot's attempted…
- [NTSB LAX01FA144](https://openairdocs.org/ntsb/LAX01FA144.md): Schleicher ASW-20 · Williams, CA · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2001 · N47TR · Substantial damage
  > The failure of the pilot to attach the elevator control rod to the elevator, resulting in a loss of pitch control and subsequent ground impact. Additional factors were the failure to complete a positive control check and the lack of clear guidance in the…
- [NTSB FTW01FA100](https://openairdocs.org/ntsb/FTW01FA100.md): Fairchild PT-19A · Midland, TX · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2001 · N58123 · Destroyed
  > the pilot's failure to maintain airspeed which resulted in an inadvertant stall during initial takeoff climb. A contributing factor was wind gusts.
- [NTSB FTW01LA099](https://openairdocs.org/ntsb/FTW01LA099.md): Cessna 150L · Iowa Park, TX · Accident · No injuries · Limited investigation · Final report · Apr 12, 2001 · N19045 · Substantial damage
  > fuel exhaustion during takeoff due to the pilot's failure to refuel.
- [NTSB DEN01LA085](https://openairdocs.org/ntsb/DEN01LA085.md): Boyd Young Kolb Mark III · Brigham City, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2001 · N1225Y · Substantial damage
  > the pilot's misjudged landing flare, which resulted in a hard landing. A factor was the propeller tip separation due to foreign object damage.
- [NTSB MIA01FA119](https://openairdocs.org/ntsb/MIA01FA119.md): Beech A-45/T-34A · Claxton, GA · Accident · 1 fatal · Field investigation · Final report · Apr 10, 2001 · N340JB · Destroyed
  > The pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.
- [NTSB MIA01FA117](https://openairdocs.org/ntsb/MIA01FA117.md): Piper PA-46-500TP · Vero Beach, FL · Accident · 2 fatal · Field investigation · Final report · Apr 9, 2001 · N262MM · Destroyed
  > The pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.
- [NTSB DEN01LA083](https://openairdocs.org/ntsb/DEN01LA083.md): Piper PA-24-250 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Apr 8, 2001 · N7736P · Substantial damage
  > the pilot's failure to maintain control of the airplane during initial climb. Factors include the gusty wind and high density altitude conditions.
- [NTSB MIA01LA114](https://openairdocs.org/ntsb/MIA01LA114.md): Arnet Pereyra Aventura II · Rockledge, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 2001 · N407EC · Substantial damage
  > the pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with the ground. Contributing to the accident was the pilot's distraction with the landing gear system.
- [NTSB LAX01LA139](https://openairdocs.org/ntsb/LAX01LA139.md): Beech F-33A · Mobile, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 2001 · N5544P · Substantial damage
  > The certified flight instructor's inadequate supervision of the dual student who failed to recognize the extent of the crosswind and lost directional control. A factor in the accident was the variable wind condition.
- [NTSB LAX01LA138](https://openairdocs.org/ntsb/LAX01LA138.md): Cessna 180 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 3, 2001 · N21394 · Substantial damage
  > the pilot's failure to attain and maintain a sufficient airspeed, which resulted in an inadvertent stall/mush.
- [NTSB CHI01LA112](https://openairdocs.org/ntsb/CHI01LA112.md): Meyers 200A · Tecumseh, MI · Accident · No injuries · Limited investigation · Final report · Apr 2, 2001 · N495C · Substantial damage
  > The fuel starvation. Factors were the loose line at the distribution valve, the inadequate annual inspection the owner/pilot mechanic performed, the unsuitable terrain the pilot encountered during the emergency landing after takeoff, and the trees.
- [NTSB CHI01FA111](https://openairdocs.org/ntsb/CHI01FA111.md): Cessna 501 · Ashwaubenon, WI · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2001 · N405PC · Destroyed
  > The pilot not maintaining aircraft control while maneuvering after takeoff and the pilot's inadequate preflight planning and preparation. Factors relating to the accident were the pilot's diverted attention while maneuvering after takeoff, the pilot's…
- [NTSB ATL01LA046](https://openairdocs.org/ntsb/ATL01LA046.md): Jacques J. Mistrot Skybolt · Smithfield, NC · Accident · 1 fatal · Limited investigation · Final report · Apr 2, 2001 · N58JM · Substantial damage
  > The pilot's failure to maintain control of the airplane during climb out that resulted in the in-flight collision with the ground. A factor was the physical impairment.
- [NTSB ATL01LA045](https://openairdocs.org/ntsb/ATL01LA045.md): Cessna 182 P · Kennesaw, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2001 · N21306 · Substantial damage
  > The loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.
- [NTSB FTW01LA091](https://openairdocs.org/ntsb/FTW01LA091.md): de Havilland DHC-3 · Decatur, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2001 · N120BA · Substantial damage
  > the pilot's failure to maintain aircraft control during the takeoff/initial climb. Contributing factors were the pilot's exceeding aircraft weight and balance limits and the dust devil.
- [NTSB DEN01FA075](https://openairdocs.org/ntsb/DEN01FA075.md): Socata TBM 700 · Englewood, CO · Accident · 1 fatal · Field investigation · Final report · Mar 26, 2001 · N300WC · Destroyed
  > the pilot's spatial disorientation, which led to his failure to maintain aircraft control. A contributing factor was the pilot's decision to intentionally fly into known adverse weather that consisted of low ceilings, obscuration, and ice fog.
- [NTSB LAX01LA120](https://openairdocs.org/ntsb/LAX01LA120.md): Enstrom F-28C · Hollister, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2001 · N637H · Destroyed
  > the pilot's inadequate use of the antitorque controls and subsequent failure to maintain directional control of the helicopter during the takeoff initial climb.
- [NTSB FTW01LA078](https://openairdocs.org/ntsb/FTW01LA078.md): Cessna 152 · Oklahoma City, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 2001 · N757GP · Destroyed
  > the loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.
- [NTSB MIA01LA099](https://openairdocs.org/ntsb/MIA01LA099.md): Grumman G-164A · Poplarville, MS · Accident · No injuries · Limited investigation · Final report · Mar 13, 2001 · N5076 · Substantial damage
  > a loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.
- [NTSB ATL01LA037](https://openairdocs.org/ntsb/ATL01LA037.md): Cessna 182J · Durham, NC · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 2001 · N2968F · Substantial damage
  > The loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.
- [NTSB MIA01LA095](https://openairdocs.org/ntsb/MIA01LA095.md): Cessna 172R · Cartersville, GA · Accident · No injuries · Limited investigation · Final report · Mar 8, 2001 · N651MA · Substantial damage
  > the pilot's failure to maintain control of the airplane which resulted in the airplane veering off course and subsequent impact with trees.
- [NTSB ANC01LA041](https://openairdocs.org/ntsb/ANC01LA041.md): Cessna 180 · Ophir, AK · Accident · No injuries · Limited investigation · Final report · Mar 7, 2001 · N9383C · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his inadequate preflight planning/preparation resulting in a collision with trees during the initial climb. Factors in the accident were soft, snow-covered terrain, and trees in the area of…
- [NTSB IAD01IA034](https://openairdocs.org/ntsb/IAD01IA034.md): McDonnell Douglas DC-10 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Mar 6, 2001 · N375FE · Minor damage
  > The inadequate de-ice and preflight inspection procedure of the #2 engine inlet and bellmouth area by company maintenance personnel that resulted in ice ingestion and foreign object damage of the #2 engine.
- [NTSB SEA01LA058](https://openairdocs.org/ntsb/SEA01LA058.md): Avia Stroitel AC-5m · Bozeman, MT · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 2001 · N1635M · Substantial damage
  > the pilot's improper remedial action upon experiencing the unexpected opening of the aircraft's canopy during the initial part of the takeoff climb. Factors include his attention being diverted to the open canopy, his failure to use a checklist to ensure he…
- [NTSB CHI01LA098](https://openairdocs.org/ntsb/CHI01LA098.md): Cessna 170B · South Haven, MN · Accident · No injuries · Limited investigation · Final report · Mar 4, 2001 · N2577D · Substantial damage
  > The pilot's failure to maintain altitude/clearance from the terrain during the maneuver to avoid the tree line. Factors to the accident were the diminished aircraft handling, the pilot's maneuver to avoid the tree line, the unsuitable terrain for takeoff…
- [NTSB NYC01LA081](https://openairdocs.org/ntsb/NYC01LA081.md): Piper PA-38-112 · Lincoln, RI · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 2001 · N2542A · Substantial damage
  > The loose fuel line, which resulted in fuel starvation to the engine.
- [NTSB FTW01LA072](https://openairdocs.org/ntsb/FTW01LA072.md): Piper PA-28R-200 · Brenham, TX · Accident · No injuries · Limited investigation · Final report · Feb 27, 2001 · N1488T · Substantial damage
  > the in-flight separation of the throttle linkage, which resulted in the loss of engine power.
- [NTSB LAX01FA103](https://openairdocs.org/ntsb/LAX01FA103.md): Piper PA-46-350P · Paso Robles, CA · Accident · 1 fatal · Field investigation · Final report · Feb 21, 2001 · N9176Z · Destroyed
  > The pilot/owner/operator's failure to maintain control of the airplane during the takeoff initial climb resulting in an in-flight collision with terrain. Contributing to the accident was the dark night light condition.
- [NTSB NYC01LA086](https://openairdocs.org/ntsb/NYC01LA086.md): Robinson R-22B · Keene, NH · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 2001 · N910SM · Substantial damage
  > inadequate visual lookout by the flight instructor on the helicopter's proximity to the snowbank, and subsequent lift off, which resulted in a dynamic rollover.
- [NTSB LAX01LA099](https://openairdocs.org/ntsb/LAX01LA099.md): Beech 77 · Auburn, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 15, 2001 · N18152 · Substantial damage
  > A partial loss of engine power during initial takeoff climb due to the formation of carburetor ice. A contributing factor was the pilot's improper pretakeoff actions. A finding was that the improper rigging of the mixture control cable may have precluded…
- [NTSB MIA01FA077](https://openairdocs.org/ntsb/MIA01FA077.md): Cessna 182J · Stuart, FL · Accident · 2 fatal · Field investigation · Final report · Feb 13, 2001 · N979ND · Destroyed
  > The loss of engine power due to undetermined reasons resulting in the forced landing. A factor in the accident was the unsuitable terrain encountered during the forced landing.
- [NTSB LAX01LA098](https://openairdocs.org/ntsb/LAX01LA098.md): Bell 47-G3B1 · Winterhaven, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 2001 · N3084G · Substantial damage
  > A failure of the transmission free wheeling unit due to improper maintenance. A factor was the dark night visual condition.
- [NTSB ATL01LA034](https://openairdocs.org/ntsb/ATL01LA034.md): Jack McDaniel Rans S-12 · Homestead, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 10, 2001 · N823S · Substantial damage
  > The pilots failure to maintain flying speed during a soft field takeoff, that resulted in the loss of control and a stall/ spin.
- [NTSB MIA01FA072](https://openairdocs.org/ntsb/MIA01FA072.md): Piper PA-30 · Ponce, PR · Accident · 1 fatal · Field investigation · Final report · Feb 8, 2001 · N181MM · Destroyed
  > The pilot's decision to attempt flight with known deficiencies in the airplanes right engine, his failure to feather the right propeller after the engine failed, his failure to retract the landing gear following the engine failure, and his failure to…
- [NTSB LAX01LA093](https://openairdocs.org/ntsb/LAX01LA093.md): Bell 47G-5 · Pixley, CA · Accident · No injuries · Limited investigation · Final report · Feb 7, 2001 · N6260C · Substantial damage
  > A loss of control during takeoff due to the helicopter's heavy gross weight condition that exceeded its lifting capability.
- [NTSB DEN01LA048](https://openairdocs.org/ntsb/DEN01LA048.md): Cessna 182L · Canon City, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2001 · N42696 · Substantial damage
  > The loss of engine power during takeoff initial climb resulting from an excessively rich fuel/air mixture, which fouled the spark plugs. A factor was rough, unsuitable terrain for a forced landing.
- [NTSB LAX01LA086](https://openairdocs.org/ntsb/LAX01LA086.md): Storey MK 7 · Marana, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 2001 · N1296 · Substantial damage
  > The pilot's inadequate preflight preparation with regards to runway choice, terrain, and performance capabilities of the airplane.
- [NTSB CHI01LA074](https://openairdocs.org/ntsb/CHI01LA074.md): Cessna 150H · Burlington, WI · Accident · No injuries · Limited investigation · Final report · Jan 28, 2001 · N22026 · Substantial damage
  > Aircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.
- [NTSB DEN01FA044](https://openairdocs.org/ntsb/DEN01FA044.md): Aero Vodochody Aero. Works L-39CT · Watkins, CO · Accident · 2 fatal · Field investigation · Final report · Jan 24, 2001 · N602MC · Destroyed
  > The pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush. Factors were the pilot's diverted attention due to the failure of the rear canopy's acrylic transparency and the loss of communication with his back seat passenger,…
- [NTSB ATL01FA027](https://openairdocs.org/ntsb/ATL01FA027.md): Beech F90-42 · Nashville, TN · Accident · 4 fatal · Field investigation · Final report · Jan 24, 2001 · N17AE · Destroyed
  > The pilot's failure to follow loss of engine power emergency procedures by not feathering the propeller following the loss of engine power for undetermined reasons, resulting in a descent and collision with trees and the ground.
- [NTSB ATL01LA020](https://openairdocs.org/ntsb/ATL01LA020.md): Piper PA-18-A-150 · Sun City, FL · Accident · No injuries · Limited investigation · Final report · Jan 15, 2001 · N6971D · Substantial damage
  > The loss of engine power for undetermined reasons, a factor was weather conditions favorable for carburetor icing
- [NTSB SEA01LA037](https://openairdocs.org/ntsb/SEA01LA037.md): Grumman American AA-1B · Cottage Grove, OR · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 2001 · N9988L · Destroyed
  > The flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…
- [NTSB CHI01TA063](https://openairdocs.org/ntsb/CHI01TA063.md): Piper PA-23 · Griffith, IN · Accident · Serious injuries · Final report · Jan 10, 2001 · N200WH · Substantial damage
  > The unsuitable terrain for landing encountered by the pilot. Factors included the loss of power for undetermined reasons and the rough terrain.
- [NTSB FTW01LA047](https://openairdocs.org/ntsb/FTW01LA047.md): Nord 1101 · McKinney, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 2001 · N208BF · Substantial damage
  > the loss of engine power during takeoff resulting from the inadequate engagement of the throttle torque tube rod end into the support bushing by unknown maintenance personnel.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=88

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

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=87

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