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

## Cases, newest first

- [NTSB DEN05CA073](https://openairdocs.org/ntsb/DEN05CA073.md): Champion 7ECA · Fort Collins, CO · Accident · Minor injuries · Data collection · Final report · May 10, 2005 · N11065 · Destroyed
  > the pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.
- [NTSB IAD05LA061](https://openairdocs.org/ntsb/IAD05LA061.md): Schneidhorst Slingshot · Lima, OH · Accident · Serious injuries · Limited investigation · Final report · May 8, 2005 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall. A factor to the accident was the overheating of the powerplant which resulted in a partial loss of engine power.
- [NTSB LAX05LA160](https://openairdocs.org/ntsb/LAX05LA160.md): Cessna 172RG · Grand Canyon, AZ · Accident · Minor injuries · Limited investigation · Final report · May 7, 2005 · N4970V · Substantial damage
  > the pilot-in-command's failure to properly lean the mixture, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush condition while departing during high density…
- [NTSB LAX05LA159](https://openairdocs.org/ntsb/LAX05LA159.md): Beech 23 · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · May 7, 2005 · N2388Q · Substantial damage
  > a loss of engine power due to the fatigue fracture and separation of the mixture control cable. The fatigue crack resulted from inadequate installation techniques by unknown maintenance personnel.
- [NTSB ANC05FA070](https://openairdocs.org/ntsb/ANC05FA070.md): Taylorcraft F-19 · Fairbanks, AK · Accident · 1 fatal · Field investigation · Final report · May 1, 2005 · N3691T · Substantial damage
  > The pilot's failure to maintain a minimum airspeed during a low-altitude turn to return to the airport, and his improper in-flight decision to initiate a steep, low altitude turn, which resulted in an inadvertent stall/spin, and an in-flight collision with…
- [NTSB NYC05LA087](https://openairdocs.org/ntsb/NYC05LA087.md): Kolb Mark III · Clay Center, OH · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 2005 · UNREG · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB LAX05LA152](https://openairdocs.org/ntsb/LAX05LA152.md): Grumman G-164A · Yuba City, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 2005 · N5304 · Substantial damage
  > a partial loss of engine power due to multiple cracks in the number 7 cylinder. The reasons for the cracks were not determined
- [NTSB SEA05LA087](https://openairdocs.org/ntsb/SEA05LA087.md): Ercoupe 415-C · Roseburg, OR · Accident · No injuries · Limited investigation · Final report · Apr 22, 2005 · N2256H · Substantial damage
  > Loss of engine power for undetermined reasons. High vegetation was a factor.
- [NTSB SEA05LA076](https://openairdocs.org/ntsb/SEA05LA076.md): Beech A36 · Plant City, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 2005 · N33CF · Substantial damage
  > An engine power interruption during takeoff for undetermined reasons.
- [NTSB LAX05LA134](https://openairdocs.org/ntsb/LAX05LA134.md): Newell Thomas RV6-A · Hayward, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 2005 · N16TN · Substantial damage
  > A loss of engine power due to fuel system contamination. A factor in the accident was the fuel system not being flushed out after it was involved in a previous accident where the fuel tanks were damaged.
- [NTSB LAX05LA133](https://openairdocs.org/ntsb/LAX05LA133.md): Clark Aerosport Scamp · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2005 · N234HC · Substantial damage
  > a loss of engine power due to the pilot/builder's excessive adjustment (lean) of the mixture setting at the carburetor. The pilot/builder's failure to perform a more comprehensive ground test prior to flight was a factor.
- [NTSB SEA05LA071](https://openairdocs.org/ntsb/SEA05LA071.md): Park Kitfox IV · Eagle Point, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 2005 · N70265 · Substantial damage
  > Loss of partial engine power during initial climb for undetermined reasons. Soft terrain was a factor
- [NTSB SEA05CA069](https://openairdocs.org/ntsb/SEA05CA069.md): Cessna A188B · Palouse, WA · Accident · No injuries · Data collection · Final report · Apr 4, 2005 · N4784Q · Substantial damage
  > The pilot's failure to maintain terrain clearance during the initial climb after takeoff. A tailwind, hilly terrain and inadequate airspeed were factors.
- [NTSB LAX05CA129](https://openairdocs.org/ntsb/LAX05CA129.md): Beech D50C · Montague, CA · Accident · Minor injuries · Data collection · Final report · Apr 2, 2005 · N50G · Substantial damage
  > The pilot's inadequate aircraft preflight and failure to verify that an adequate fuel supply was in the right main tank prior to flight, resulting in a fuel starvation induced loss of engine power in the right engine. Also causal was the pilot's failure to…
- [NTSB MIA05FA085](https://openairdocs.org/ntsb/MIA05FA085.md): Commander 114-B · Venice, FL · Accident · 2 fatal · Field investigation · Final report · Mar 31, 2005 · N60204 · Destroyed
  > The pilot's in-flight loss of control during takeoff/initial climb over the water at night due to spatial disorientation. A related factor was the night conditions.
- [NTSB DEN05LA065](https://openairdocs.org/ntsb/DEN05LA065.md): Beech A36 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Mar 30, 2005 · N1830V · Substantial damage
  > the pilot's improper soft-field takeoff procedures and failure to maintain control of the aircraft. A contributing factor was the attempted aborted takeoff.
- [NTSB CHI05FA081](https://openairdocs.org/ntsb/CHI05FA081.md): Piper PA-28R-200 · West Lafayette, IN · Accident · 2 fatal · Field investigation · Final report · Mar 26, 2005 · N999SK · Destroyed
  > The pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…
- [NTSB DFW05LA092](https://openairdocs.org/ntsb/DFW05LA092.md): Cessna 150F · Tontitown, AR · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 2005 · N6828F · Substantial damage
  > The pilot's falure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.
- [NTSB ATL05LA065](https://openairdocs.org/ntsb/ATL05LA065.md): Embraer EMB-135LR · Raleigh, NC · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 2005 · N733KR · No damage
  > An oily smell in the airplane shortly after takeoff for undetermined reasons that resulted in a return to the airport and a passenger injury during the emergency evacuation.
- [NTSB ANC05CA050](https://openairdocs.org/ntsb/ANC05CA050.md): Piper PA-18 · False Pass, AK · Accident · Minor injuries · Data collection · Final report · Mar 19, 2005 · N3996Z · Substantial damage
  > The pilot's inadequate compensation for the wind conditions during the initial climb after takeoff, which resulted in a collision with the ground and subsequent nose over. Factors contributing to the accident were a downdraft, and the pilot's inadequate…
- [NTSB DEN05CA062](https://openairdocs.org/ntsb/DEN05CA062.md): Beech A36 · Farmington, NM · Accident · No injuries · Data collection · Final report · Mar 15, 2005 · N435P · Substantial damage
  > the student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.
- [NTSB LAX05FA114](https://openairdocs.org/ntsb/LAX05FA114.md): Piper PA-28-140 · Big Bear City, CA · Accident · Serious injuries · Field investigation · Final report · Mar 13, 2005 · N9956W · Substantial damage
  > The pilot's failure to maintain adequate airspeed that resulted in an inadvertent stall/mush during initial climb. Contributing factors were the pilot's inadequate preflight preparations and the high density altitude.
- [NTSB SEA05FA061](https://openairdocs.org/ntsb/SEA05FA061.md): Navion Navion H · Hubbard, OR · Accident · Serious injuries · Field investigation · Final report · Mar 12, 2005 · N2512T · Substantial damage
  > The total loss of engine power immediately after takeoff for undetermined reason.
- [NTSB MIA05LA079](https://openairdocs.org/ntsb/MIA05LA079.md): Rockwell Aero Commander 500 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Mar 12, 2005 · N8498C · Substantial damage
  > The failure of the pilot to follow the emergency checklist and his inadvertent operation of the airplane with known discrepancies resulting in landing overrun and on-ground collision with a ditch during the landing roll.
- [NTSB MIA05LA071](https://openairdocs.org/ntsb/MIA05LA071.md): Piper PA-24-260 · Merritt Island, FL · Accident · No injuries · Limited investigation · Final report · Mar 7, 2005 · N9446P · Substantial damage
  > The owner/pilot/mechanics inadequate installation of a fuel line resulting in a fuel leak, partial loss of engine power, and force landing in swampy terrain.
- [NTSB SEA05CA055](https://openairdocs.org/ntsb/SEA05CA055.md): Cessna 172H · Waldport, OR · Accident · Minor injuries · Data collection · Final report · Mar 6, 2005 · N8100L · Substantial damage
  > The pilot's failure to attain sufficient altitude/clearance during the takeoff initial climb, which resulted in an inflight collision with trees. A factor was the tall grass on the turf runway, which slowed the airplane's acceleration during the takeoff roll.
- [NTSB ATL05CA058](https://openairdocs.org/ntsb/ATL05CA058.md): Piper PA-28-140 · Suches, GA · Accident · No injuries · Data collection · Final report · Mar 6, 2005 · N7209J · Substantial damage
  > The pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.
- [NTSB ANC05FA038](https://openairdocs.org/ntsb/ANC05FA038.md): Aero Commander 500-S · San Juan, PR · Accident · Serious injuries · Field investigation · Final report · Feb 28, 2005 · N97VB · Destroyed
  > The fuel truck operator's improper refueling of a gasoline engine powered airplane with jet (turbine) fuel, and the pilot's inadequate preflight, which resulted in a loss of power in both engines and subsequent collision with trees. Factors associated with…
- [NTSB IAD05FA040](https://openairdocs.org/ntsb/IAD05FA040.md): Cessna 182P · West Milford, NJ · Accident · 2 fatal · Field investigation · Final report · Feb 27, 2005 · N6685M · Destroyed
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.
- [NTSB CHI05CA074](https://openairdocs.org/ntsb/CHI05CA074.md): Cessna 177RG · Fargo, ND · Accident · Serious injuries · Data collection · Final report · Feb 26, 2005 · N1623H · Substantial damage
  > The mechanic's improper installation of the oil filter canister base gasket, which resulted in an oil leak and the separation of the connecting rod due to oil starvation. Factors to the accident were the unsuitable terrain encountered during the forced…
- [NTSB ATL05CA053](https://openairdocs.org/ntsb/ATL05CA053.md): Bennett Ra Oliver Zodiac CH 601 HDS · Mt. Olive, NC · Accident · Serious injuries · Data collection · Final report · Feb 26, 2005 · N2521B · Substantial damage
  > Rupture of the engine's cooling system radiator, which allowed steam to fill the cockpit.
- [NTSB LAX05LA100](https://openairdocs.org/ntsb/LAX05LA100.md): Ayres S2R · Firebaugh, CA · Accident · 1 fatal · Limited investigation · Final report · Feb 18, 2005 · N4009M · Substantial damage
  > the loss of engine power during takeoff climb resulting from the fatigue failure of one of the compressor turbine blades; the cause of the fatigue failure could not be definitively determined.
- [NTSB DEN05LA057](https://openairdocs.org/ntsb/DEN05LA057.md): Cessna P210N · Lander, WY · Accident · No injuries · Limited investigation · Final report · Feb 17, 2005 · N4912K · Substantial damage
  > the loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA05LA058](https://openairdocs.org/ntsb/MIA05LA058.md): Interplane Sro Skyboy · Zephyrhills, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 2005 · N942WW · Substantial damage
  > The instructors in-flight loss of control due to the flight controls being jammed for undetermined reasons.
- [NTSB ANC05LA035](https://openairdocs.org/ntsb/ANC05LA035.md): Bellanca 8GCBC · Koyukuk, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 2005 · N86911 · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted in an in flight collision with the snow during takeoff initial climb. A factor contributing to the accident was soft snow conditions.
- [NTSB ANC05FA034](https://openairdocs.org/ntsb/ANC05FA034.md): Beech 35-C33 · Clearwater, FL · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2005 · N3NM · Destroyed
  > The loss of engine power during initial climb due to fuel exhaustion, the pilot's failure to refuel the airplane, and the pilot's failure to maintain minimum airspeed, which resulted in an inadvertent stall and uncontrolled descent into a residence.
- [NTSB LAX05FA090](https://openairdocs.org/ntsb/LAX05FA090.md): American AA1B · Petaluma, CA · Accident · 1 fatal · Field investigation · Final report · Feb 10, 2005 · N5704L · Destroyed
  > The pilot's failure to maintain an adequate airspeed above the stall speed (Vso) while maneuvering to a landing area that resulted in a stall-spin. Factors in the accident were the fuel starvation induced loss of engine power due to the pilot's fuel system…
- [NTSB MIA05FA055](https://openairdocs.org/ntsb/MIA05FA055.md): Bell 206B · Bonifay, FL · Accident · 1 fatal · Field investigation · Final report · Feb 5, 2005 · N35BA · Substantial damage
  > The pilot's failure to maintain a climb after takeoff and his continued descent which resulted in an in-flight collision with the ground. A factor in the accident was the dark night.
- [NTSB IAD05LA035](https://openairdocs.org/ntsb/IAD05LA035.md): Aeronca S7CCM · Ulster, NY · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2005 · N3069E · Substantial damage
  > A loss of engine power due to carburetor ice. Contributing to the accident was conditions conducive to carburetor icing.
- [NTSB LAX05LA075](https://openairdocs.org/ntsb/LAX05LA075.md): Piper PA-25-235 · Llano, CA · Accident · No injuries · Limited investigation · Final report · Jan 23, 2005 · N6745Z · Substantial damage
  > the pilot's inadequate preflight planning and failure to verify the amount of fuel onboard the airplane prior to departure, which resulted in loss of engine power due to fuel exhaustion.
- [NTSB MIA05FA050](https://openairdocs.org/ntsb/MIA05FA050.md): Cessna T337G · Lakeland, FL · Accident · 2 fatal · Field investigation · Final report · Jan 14, 2005 · N42WA · Destroyed
  > The pilot's operation of the airplane with known deficiencies in equipment related to pitch, an abrupt pitch-up during the initial climb after takeoff for undetermined reasons and the failure of the pilot to maintain airspeed (Vs) resulting in inadvertent…
- [NTSB DFW05FA055](https://openairdocs.org/ntsb/DFW05FA055.md): Beech 95-B55 · Patterson, LA · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2005 · N7912R · Substantial damage
  > The pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…
- [NTSB ATL05FA044](https://openairdocs.org/ntsb/ATL05FA044.md): Cessna T206H · Huntsville, AL · Accident · 2 fatal · Field investigation · Final report · Jan 12, 2005 · N2467X · Substantial damage
  > The pilot's decision to attempt flight into known adverse weather, which resulted in an in-flight encounter with a thunderstorm.
- [NTSB ATL05FA043](https://openairdocs.org/ntsb/ATL05FA043.md): Piper PA-30 · Charleston, SC · Accident · 1 fatal · Field investigation · Final report · Jan 11, 2005 · N7654Y · Substantial damage
  > The pilot's inadequate preflight and mismanagement of the fuel supply, which resulted in fuel exhaustion.
- [NTSB DFW05LA053](https://openairdocs.org/ntsb/DFW05LA053.md): Myers Kit Fox Series VI · Cleveland, OK · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 2005 · N982KF · Destroyed
  > The pilot's failure to maintain control and sufficient airspeed while performing an abrupt pull-up manuever after takeoff, which resulted in an inadvertent stall/spin.
- [NTSB IAD05LA029](https://openairdocs.org/ntsb/IAD05LA029.md): Cessna 172L · Poughkeepsie, NY · Accident · No injuries · Limited investigation · Final report · Jan 1, 2005 · N7180Q · Substantial damage
  > The pilot's inadequate preflight, which resulted in a loss of engine power due to fuel contamination.
- [NTSB SEA05LA032](https://openairdocs.org/ntsb/SEA05LA032.md): Aerostar 601 · Hamilton, MT · Accident · No injuries · Limited investigation · Final report · Dec 30, 2004 · N601DF · Destroyed
  > A partial loss of engine power due to the lack of lubrication and subsequent failure of the left engine's right turbocharger for undetermined reasons, and subsequent forced landing after takeoff. A factor was the unsuitable terrain for the forced landing.
- [NTSB IAD05CA027](https://openairdocs.org/ntsb/IAD05CA027.md): Enstrom 280C · Pedricktown, NJ · Accident · Minor injuries · Data collection · Final report · Dec 30, 2004 · N175BM · Substantial damage
  > The pilot's failure to maintain control of the helicopter during the takeoff and his failure to flare during the autorotation.
- [NTSB ANC05IA020](https://openairdocs.org/ntsb/ANC05IA020.md): Boeing 747-123 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Dec 29, 2004 · N858FT · Minor damage
  > The failure of a high-pressure fuel line fitting, which resulted in an engine fire during takeoff/initial climb.
- [NTSB DEN05LA039](https://openairdocs.org/ntsb/DEN05LA039.md): Raytheon C90A · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Dec 19, 2004 · N55EP · Substantial damage
  > the pilot's failure to obtain/maintain a proper climb rate and the pilot's premature initiation of the turn (low altitude flight maneuver). Contributing factors include the pilot's improper in-flight planning and decision making, the low altitude, the fog,…

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

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

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