# 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 72 of 412 · 20,559 cases

## Cases, newest first

- [NTSB LAX04FA330](https://openairdocs.org/ntsb/LAX04FA330.md): Bushmaster 2000 · Fullerton, CA · Accident · Serious injuries · Field investigation · Final report · Sep 25, 2004 · N750RW · Destroyed
  > the inadequate preflight inspection by the pilot-in-command, where the pilot failed to remove the makeshift gust lock attached to the rudder and left elevator of the airplane. As a result, the airplane veered off the runway surface during the takeoff roll,…
- [NTSB ANC04LA120](https://openairdocs.org/ntsb/ANC04LA120.md): Piper PA-12 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Sep 25, 2004 · N4409M · Substantial damage
  > The loss of engine power during takeoff-initial climb for an undetermined reason, which resulted in an emergency descent and hard landing.
- [NTSB NYC04LA219](https://openairdocs.org/ntsb/NYC04LA219.md): de Havilland DHC-22A · Richmond, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2004 · N665WB · Substantial damage
  > The pilot's inadequate preflight inspection which resulted in fuel contamination and a subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while attempting a forced landing which resulted in an inadvertent…
- [NTSB ANC04LA113](https://openairdocs.org/ntsb/ANC04LA113.md): Britten-Norman BN-2A · Kodiak, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2004 · N6522T · Substantial damage
  > The pilot's inadequate compensation for wind conditions, and his intentional flight into adverse weather conditions, which resulted in a loss of control and collision with terrain during takeoff-initial climb. Factors contributing to the accident were high…
- [NTSB IAD04LA048](https://openairdocs.org/ntsb/IAD04LA048.md): Boeing A75N (PT17) · Bayport, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2004 · N57003 · Substantial damage
  > The failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.
- [NTSB DEN04LA147](https://openairdocs.org/ntsb/DEN04LA147.md): Cessna 172 · Provo, UT · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2004 · N5338H · Substantial damage
  > the pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.
- [NTSB CHI04LA265](https://openairdocs.org/ntsb/CHI04LA265.md): Kenny Mariner-MF Boat · Eagle River, WI · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 2004 · N744PK · Substantial damage
  > The pilot's inability to maintain control of the aircraft during flight for undetermined reasons.
- [NTSB LAX04LA322](https://openairdocs.org/ntsb/LAX04LA322.md): Wolf Glassair IIS · Mesa, AZ · Accident · 2 fatal · Limited investigation · Final report · Sep 18, 2004 · N110UX · Destroyed
  > a partial loss of power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and a collision with terrain.
- [NTSB LAX04LA320](https://openairdocs.org/ntsb/LAX04LA320.md): Hebb Avid Magnum · Bridgeport, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2004 · N970JH · Destroyed
  > the pilot's failure to adequately compensate for the crosswind condition and his failure to maintain an adequate airspeed while using crossed controls, which led to a stall.
- [NTSB ATL04LA187](https://openairdocs.org/ntsb/ATL04LA187.md): Piper PA-22-108 · Inverness, FL · Accident · No injuries · Limited investigation · Final report · Sep 16, 2004 · N4647Z · Substantial damage
  > The improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.
- [NTSB ANC04LA109](https://openairdocs.org/ntsb/ANC04LA109.md): Cessna 140 · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 2004 · N1629V · Substantial damage
  > The pilot's failure to use carburetor heat during takeoff/initial climb, which resulted in a total loss of engine power, and an in-flight collision with trees.
- [NTSB SEA04LA187](https://openairdocs.org/ntsb/SEA04LA187.md): WSK PZL Warzawa-Okecie PZL-104 Wilga 80 · The Dalles, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 2004 · N10RN · Substantial damage
  > Aircraft control was not maintained by the tow plane pilot and the glider pilot did not maintain a proper climb rate during the initial climb. A direct crosswind and wind gusts were factors.
- [NTSB FTW04LA236](https://openairdocs.org/ntsb/FTW04LA236.md): Lancair 360 · Orange, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 10, 2004 · N163DS · Destroyed
  > The pilot's failure to maintain adequate airspeed during takeoff resulting in an inadvertent stall and loss of aircraft control.
- [NTSB CHI04LA253](https://openairdocs.org/ntsb/CHI04LA253.md): Williams Glastar GS-1 · Hayward, WI · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2004 · N501YR · Substantial damage
  > The pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.
- [NTSB ATL04LA175](https://openairdocs.org/ntsb/ATL04LA175.md): Piper PA-32-260 · Kennesaw, GA · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 2004 · N45100 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB LAX04LA333](https://openairdocs.org/ntsb/LAX04LA333.md): McDonnell Douglas MD 900 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Sep 8, 2004 · N9016W · Substantial damage
  > fracture of a Tension-Torsion strap in the anti-torque fan due to progressive fiber failure of the composite strap material from compression and/or transverse shear stresses that occurred with repeated manipulation of the cockpit anti-torque control pedals…
- [NTSB ANC04LA112](https://openairdocs.org/ntsb/ANC04LA112.md): Cessna 170 · Teller, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 2004 · N3492C · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…
- [NTSB MIA04LA131](https://openairdocs.org/ntsb/MIA04LA131.md): Robinson R22 Beta · St. Thomas · Accident · No injuries · Limited investigation · Final report · Sep 4, 2004 · N176FM · Substantial damage
  > The failure of the pilot-in-command to comply with performance data related to the recommended takeoff profile and his failure to perform remedial action following reduced tailrotor effectiveness, resulting in subsequent initiation of an autorotation and…
- [NTSB FTW04FA232](https://openairdocs.org/ntsb/FTW04FA232.md): Fairchild M-62A-3 · Corsicana, TX · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2004 · N79307 · Substantial damage
  > The loss of engine power due to a faulty carburetor and the pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing after takeoff.
- [NTSB FTW04LA231](https://openairdocs.org/ntsb/FTW04LA231.md): Piper PA-22 · Mountain Home, TX · Accident · No injuries · Limited investigation · Final report · Sep 3, 2004 · N2972P · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in a stall.
- [NTSB FTW04LA229](https://openairdocs.org/ntsb/FTW04LA229.md): Cessna 175 · De Ridder, LA · Accident · No injuries · Limited investigation · Final report · Sep 2, 2004 · N6517E · Substantial damage
  > The partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX04LA308](https://openairdocs.org/ntsb/LAX04LA308.md): Rockwell 112TCA · San Rafael, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2004 · N44MH · Substantial damage
  > A total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.
- [NTSB SEA04IA175](https://openairdocs.org/ntsb/SEA04IA175.md): Boeing 757-200 · Richmond, BC, Canada · Incident · No injuries · Incident investigation · Final report · Aug 27, 2004 · N526UA · Minor damage
  > The slat was impacted by birds after takeoff and subsequently the slat delaminated due to flight loads.
- [NTSB FTW04LA220](https://openairdocs.org/ntsb/FTW04LA220.md): Bell 212 · Umpire, AR · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2004 · N181W · Substantial damage
  > The pilot's encounter with settling with power resulting in a loss of control. A contributing factor was the high density altitude.
- [NTSB ANC04LA093](https://openairdocs.org/ntsb/ANC04LA093.md): Hudson Hiperbipe SNS-7 · Palmer, AK · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2004 · N898DH · Destroyed
  > The pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and subsequent in-flight collision with trees. A factor associated with the accident was a low altitude maneuver preformed by the pilot just after takeoff.
- [NTSB SEA04FA165](https://openairdocs.org/ntsb/SEA04FA165.md): Cessna T210L · Tulsa, OK · Accident · 3 fatal · Field investigation · Final report · Aug 17, 2004 · N2452S · Destroyed
  > The pilot's inadequate preflight inspection by his failure to secure the oil cap, which resulted in oil leakage on the windscreen, obstructing his vision, and his failure to maintain adequate airspeed.
- [NTSB MIA04LA120](https://openairdocs.org/ntsb/MIA04LA120.md): Beech 65-A90 · Pensacola, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2004 · N45TT · Destroyed
  > The pilot's inadequate planning/decision and his failure to maintain airspeed which resulted in fuel exhaustion and an inadvertent stall.
- [NTSB IAD04LA039](https://openairdocs.org/ntsb/IAD04LA039.md): Ercoupe 415-C · Pemberton, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2004 · N3771H · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CHI04LA231](https://openairdocs.org/ntsb/CHI04LA231.md): Stephen T-Bird TBT06 · Gobles, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2004 · N655DM · Substantial damage
  > The pilot's inadvertent flight into adverse weather conditions which resulted in an encounter with a downdraft that exceeded the climb capabilities of the airplane. The downdraft and the trees were factors.
- [NTSB LAX04FA291](https://openairdocs.org/ntsb/LAX04FA291.md): Cessna 172M · Yuba City, CA · Accident · 1 fatal · Field investigation · Final report · Aug 15, 2004 · C-GTKX · Destroyed
  > the pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall.
- [NTSB NYC04LA192](https://openairdocs.org/ntsb/NYC04LA192.md): Waco QCF · Rhinebeck, NY · Accident · No injuries · Limited investigation · Final report · Aug 14, 2004 · N11478 · Substantial damage
  > A partial loss of engine power due to a magneto failure.
- [NTSB IAD04LA037](https://openairdocs.org/ntsb/IAD04LA037.md): Aero Commander 112 · Jackson, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2004 · N1222J · Substantial damage
  > the loss of engine power for undetermined reasons over unsuitable terrain.
- [NTSB CHI04CA229](https://openairdocs.org/ntsb/CHI04CA229.md): Bell 47G2 · Muncie, IN · Accident · No injuries · Data collection · Final report · Aug 14, 2004 · N96MB · Destroyed
  > The engine failure for an undetermined reason, and the pilot's inability to properly level-off for landing due to the low rotor speed, which resulted in the hard landing. The low altitude where the engine failure occurred was a factor.
- [NTSB CHI04CA224](https://openairdocs.org/ntsb/CHI04CA224.md): Air Tractor AT-301 · Cambridge, KS · Accident · Minor injuries · Data collection · Final report · Aug 12, 2004 · N2353W · Substantial damage
  > The pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.
- [NTSB SEA04LA156](https://openairdocs.org/ntsb/SEA04LA156.md): Taylorcraft DC-65 · Wamic, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2004 · N61021 · Substantial damage
  > The pilot's inadequate compensation for wind conditions and his failure to maintain airspeed, resulting in a stall. The pilot's failure to use all of the available runway, and the high-gusty winds were factors.
- [NTSB NYC04LA186](https://openairdocs.org/ntsb/NYC04LA186.md): Cessna 150E · Marlboro, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2004 · N6159T · Substantial damage
  > The loss of engine power due to a stuck cylinder exhaust valve. Factors were the tailwind and a jammed engine cylinder exhaust valve.
- [NTSB ANC04CA089](https://openairdocs.org/ntsb/ANC04CA089.md): Aeronca 15AC · Big lake, AK · Accident · No injuries · Data collection · Final report · Aug 7, 2004 · N4433N · Substantial damage
  > The pilot's inadequate evaluation of the weather conditions and subsequent collision with high vegetation during the initial climb after takeoff, which resulted in a collision with the ground. Factors contributing to the accident were the presence of a…
- [NTSB NYC04LA187](https://openairdocs.org/ntsb/NYC04LA187.md): Piper PA-24-180 · Phillipsburg, PA · Accident · No injuries · Limited investigation · Final report · Aug 3, 2004 · N6311P · Substantial damage
  > A loss of partial engine power for undetermined reasons.
- [NTSB FTW04FA204](https://openairdocs.org/ntsb/FTW04FA204.md): Piper PA-60-601P · Lakeway, TX · Accident · 6 fatal · Field investigation · Final report · Aug 3, 2004 · N601BV · Destroyed
  > The pilot's failure to successfully perform a short-field takeoff and his subsequent failure to maintain adequate airspeed during climbout, which resulted in an aerodynamic stall.
- [NTSB SEA04LA152](https://openairdocs.org/ntsb/SEA04LA152.md): Paulick Wittman W-10 · Langley, WA · Accident · 1 fatal · Limited investigation · Final report · Aug 1, 2004 · N70P · Destroyed
  > The pilot's inadequate preflight preparation to assure adequate takeoff performance to clear obstacles, and his failure to maintain obstacle clearance.
- [NTSB SEA04LA134](https://openairdocs.org/ntsb/SEA04LA134.md): Cessna 150C · Mazama, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2004 · N7815Z · Substantial damage
  > The pilot's inadequate compensation for the weather conditions and his failure to maintain the initial takeoff climb, which resulted in a collision with trees during an emergency landing. Contributing factors were the unfavorable wind and high density…
- [NTSB DEN04LA118](https://openairdocs.org/ntsb/DEN04LA118.md): Beech V35A · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Aug 1, 2004 · N222S · Substantial damage
  > the pilot's improper planning and decision making resulting in the loss of engine power due to fuel starvation. Contributing factors include the insufficient time to completely extend the landing gear, and the lack of suitable terrain for a forced landing.
- [NTSB CHI04CA210](https://openairdocs.org/ntsb/CHI04CA210.md): Piper PA-28RT-201T · Plymouth, MI · Accident · Minor injuries · Data collection · Final report · Jul 31, 2004 · N77782 · Destroyed
  > The loss of engine power at a low altitude due to a fuel flow restriction caused by vapor lock. Factors to the accident included the high atmospheric temperature and the road sign that the airplane impacted during the forced landing.
- [NTSB DEN04LA110](https://openairdocs.org/ntsb/DEN04LA110.md): American AA-1 · Guernsey, WY · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 2004 · N5667L · Destroyed
  > the pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…
- [NTSB NYC04LA176](https://openairdocs.org/ntsb/NYC04LA176.md): Piper PA-28-140 · Somerville, NJ · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2004 · N6139J · Substantial damage
  > The flight instructor's inadequate preflight inspection, which resulted in an attempted takeoff with contaminated fuel, and a subsequent forced landing.
- [NTSB LAX04CA278](https://openairdocs.org/ntsb/LAX04CA278.md): Cessna A185F · Gridley, CA · Accident · No injuries · Data collection · Final report · Jul 24, 2004 · N93DM · Destroyed
  > The pilot's improper use of the rudder to correct for torque and P-factor effects and failure to maintain obstacle clearance.
- [NTSB LAX04LA275](https://openairdocs.org/ntsb/LAX04LA275.md): Air Tractor AT-502B · Mendota, CA · Accident · No injuries · Limited investigation · Final report · Jul 23, 2004 · N5010E · Substantial damage
  > The pilot's inadequate preflight/pretakeoff procedure by not lowering the wing flaps, which resulted in an inadvertent stall as the pilot attempted to climb out of ground effect to clear a corn crop at the end of the runway. A factor in the accident was the…
- [NTSB FTW04LA196](https://openairdocs.org/ntsb/FTW04LA196.md): Everett Vidrine Dragonfly · Covington, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 2004 · N89VE · Substantial damage
  > the pilot's inadequate preflight planning which failed to assure adequate takeoff performance for the airplane to clear obstacles. A contributing factor was the pilot's failure to abort the takeoff.
- [NTSB ANC04CA082](https://openairdocs.org/ntsb/ANC04CA082.md): Piper J3C · Palmer, AK · Accident · Minor injuries · Data collection · Final report · Jul 22, 2004 · N3458N · Substantial damage
  > The pilot's inadequate evaluation of the wind conditions which resulted in an encounter with a downdraft during the takeoff/initial climb, and subsequent collision with trees and terrain. Factors contributing to the accident were the presence of a downdraft,…
- [NTSB SEA04LA137](https://openairdocs.org/ntsb/SEA04LA137.md): Root RV-4 · Buckley, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2004 · N901ER · Substantial damage
  > The pilot's inadequate preflight planning/preparation which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff. The pilot's failure to select the proper fuel tank before takeoff and to maintain airspeed during the…

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

## 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=72

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