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

## Cases, newest first

- [NTSB LAX97LA080](https://openairdocs.org/ntsb/LAX97LA080.md): Cessna 182P · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1996 · N9003M · Substantial damage
  > Fuel system water contamination due to the failure of both pilots to purge all water from the fuel system prior to departure. Contributing factors were: failure of the mechanic conducting the recent annual inspection to identify and replace a deteriorated…
- [NTSB NYC97LA039](https://openairdocs.org/ntsb/NYC97LA039.md): Cessna 150D · Catawba Valley, VA · Accident · No injuries · Limited investigation · Final report · Dec 28, 1996 · N4523U · Substantial damage
  > the pilot's improper planning/decision, and his failure to attain adequate airspeed, which resulted in a stall after takeoff and collision with ground. Factors relating to the accident were: the pilot's use of inadequate terrain for takeoff, high vegetation…
- [NTSB NYC97LA033](https://openairdocs.org/ntsb/NYC97LA033.md): Piper PA-28-140 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Dec 22, 1996 · N55228 · Substantial damage
  > ice ingestion into the engine from the carburetor air box, which resulted in a loss of engine power and a subsequent forced landing, off airport, on unprepared terrain.
- [NTSB IAD97LA034](https://openairdocs.org/ntsb/IAD97LA034.md): Piper PA-28-140 · Beverly, MA · Accident · 1 fatal · Limited investigation · Final report · Dec 21, 1996 · N7246F · Substantial damage
  > loss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and subsequent in-flight collision with terrain.
- [NTSB MIA97FA040](https://openairdocs.org/ntsb/MIA97FA040.md): Piper PA-34-200T · Birmingham, AL · Accident · 3 fatal · Field investigation · Final report · Dec 16, 1996 · N872SD · Destroyed
  > failure of the pilot to follow emergency procedures and feather the malfunctioning engine, which led to a forced landing and subsequent collision with a chimney (residence) and the terrain. His lack of recent experience in make/model of aircraft was a related…
- [NTSB NYC97LA031](https://openairdocs.org/ntsb/NYC97LA031.md): Cessna 152 · Baltimore, MD · Accident · No injuries · Limited investigation · Final report · Dec 15, 1996 · N714YW · Substantial damage
  > the student pilot's premature rotation and inadequate supervision by the flight instructor (CFI), which resulted in failure of the flight crew to obtain adequate airspeed during takeoff for a proper rate of climb. Trees at the departure end of the runway were…
- [NTSB MIA97LA039](https://openairdocs.org/ntsb/MIA97LA039.md): Wiedemann KIT FOX · Montgomery, AL · Accident · No injuries · Limited investigation · Final report · Dec 15, 1996 · N19VX · Substantial damage
  > improper installation of a throttle cable clamp by an unknown person, resulting in a loose throttle cable housing and an inability to control the throttle position; and failure of the pilot to maintain adequate airspeed during an approach for an emergency…
- [NTSB ANC97LA014](https://openairdocs.org/ntsb/ANC97LA014.md): de Havilland DHC-2 · Ketchikan, AK · Accident · 1 fatal · Limited investigation · Final report · Dec 12, 1996 · N67694 · Destroyed
  > the pilot's inadequate compensation for wind conditions, and failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with terrain (water). A factor associated with the accident was the gusty wind condition.
- [NTSB FTW97LA062](https://openairdocs.org/ntsb/FTW97LA062.md): Luscombe 8E · Ardmore, OK · Accident · No injuries · Limited investigation · Final report · Dec 11, 1996 · N77974 · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.
- [NTSB SEA97FA034](https://openairdocs.org/ntsb/SEA97FA034.md): Douglas DC-3C · Boise, ID · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1996 · N75142 · Destroyed
  > A fire within the right engine compartment of undetermined cause and the pilot-in-command's failure to maintain airspeed above the aircraft's minimum control speed. A factor contributing to the accident was the dark night environmental conditions.
- [NTSB CHI97LA038](https://openairdocs.org/ntsb/CHI97LA038.md): Piper PA-28-180 · New Hudson, MI · Accident · No injuries · Limited investigation · Final report · Dec 4, 1996 · N142AV · Substantial damage
  > loss of engine power for undetermined reason(s). Darkness was a related factor.
- [NTSB IAD97LA026](https://openairdocs.org/ntsb/IAD97LA026.md): Cessna 205 · Columbia, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 1996 · N1892Z · Destroyed
  > The pilot's failure to obtain/maintain airspeed, which resulted in an inadvertent stall, and collision with trees during the initial climb. A factor in the accident was a tailwind condition.
- [NTSB IAD97FA024](https://openairdocs.org/ntsb/IAD97FA024.md): Cessna 182P · Fort Washington, MD · Accident · Serious injuries · Field investigation · Final report · Nov 29, 1996 · N52773 · Destroyed
  > Loss of engine power for undetermined reason(s).
- [NTSB ANC97FA008](https://openairdocs.org/ntsb/ANC97FA008.md): Cessna 208B · Bethel, AK · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1996 · N4704B · Destroyed
  > failure of the pilot to maintain control of the airplane, while maneuvering to reverse direction after takeoff, after encountering an undetermined anomaly. The undetermined anomaly was a related factor.
- [NTSB MIA97LA026](https://openairdocs.org/ntsb/MIA97LA026.md): Cessna 150 · Gulf Shores, AL · Accident · No injuries · Limited investigation · Final report · Nov 20, 1996 · N2428J · Substantial damage
  > Inadequate maintenance/inspection of the aircraft engine, which allowed continued use of a deteriorated ignition harness and subsequent loss of engine power.
- [NTSB FTW97FA042](https://openairdocs.org/ntsb/FTW97FA042.md): Piper Aerostar 601P · Eagle, CO · Accident · 5 fatal · Field investigation · Final report · Nov 17, 1996 · N251B · Destroyed
  > The pilot initiating flight into known adverse weather conditions without proper certification. Factors were the meteorological conditions that existed --- low ceiling, low visibility, and falling snow --- and his use of contraindicated drugs.
- [NTSB LAX97LA037](https://openairdocs.org/ntsb/LAX97LA037.md): Cessna 152 · Williams, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1996 · N714VX · Destroyed
  > a foreign object in the oil system, which resulted in failure of the oil pump, oil starvation, loss of engine power, and a subsequent forced landing. Rough/uneven terrain in the emergency landing area was a related factor.
- [NTSB LAX97LA038](https://openairdocs.org/ntsb/LAX97LA038.md): Cessna 210L · Elk Grove, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1996 · N30115 · Substantial damage
  > loss of engine power for undetermined reason(s) after takeoff. The lack of maintenance/annual inspection was a related factor.
- [NTSB IAD97LA017](https://openairdocs.org/ntsb/IAD97LA017.md): Vanatta KR-2 · Blackstone, VA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 1996 · N85JV · Substantial damage
  > loss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, which resulted in a loss of control (stall) and collision with the ground.
- [NTSB IAD97LA016](https://openairdocs.org/ntsb/IAD97LA016.md): Grumman American AA-1B · Gaithersburg, MD · Accident · Minor injuries · Limited investigation · Final report · Nov 5, 1996 · N9926L · Substantial damage
  > the pilot's inadequate preflight, and his failure to detect an insufficent fuel supply, which resulted in fuel exhaustion and a forced landing after takeoff. Uneven terrain (drop-off in the emergency landing area) was a related factor.
- [NTSB LAX97LA035](https://openairdocs.org/ntsb/LAX97LA035.md): Aerostar YAK 52 · Fullerton, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1996 · N207YK · Substantial damage
  > loss of engine power due to an undetermined internal carburetor malfunction. A factor relating to the accident was: the directions that were use for reassembly of the aircraft were written only in Russian.
- [NTSB MIA97IA016](https://openairdocs.org/ntsb/MIA97IA016.md): Piper PA-31-350 · Mccomb, MS · Incident · No injuries · Incident investigation · Final report · Oct 31, 1996 · N120JD · Minor damage
  > the lineman's fueling of the aircraft with the wrong type fuel, the pilot's failure to verify the type of fuel added to the aircraft before flight, and failure of the refueling facility to be equipped with the proper fuel nozzle.
- [NTSB LAX97LA029](https://openairdocs.org/ntsb/LAX97LA029.md): Cessna 310H · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Oct 31, 1996 · N1039Q · Destroyed
  > water/ice contamination in the fuel system and/or fuel filters due to failure of the maintenance facility that performed the annual inspection to identify and replace four cracked and deteriorated fuel filler cap O-rings. A factor in this accident was the…
- [NTSB FTW97LA030](https://openairdocs.org/ntsb/FTW97LA030.md): Bell 206B-3 · Creole, LA · Accident · No injuries · Limited investigation · Final report · Oct 31, 1996 · N2043B · Substantial damage
  > the pilot's inadequate preflight by failing to remove the 100 foot long line and the external cargo basket from the helicopter before takeoff, and/or his failure to ensure that clearance/altitude was maintained from the fence.
- [NTSB LAX97LA028](https://openairdocs.org/ntsb/LAX97LA028.md): Leibert BD-5B · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Oct 30, 1996 · N169DS · Substantial damage
  > loss of engine power during the takeoff initial climb, due to an undetermined cooling system malfunction. A related factor was: soft terrain in the forced landing area.
- [NTSB SEA97TA023](https://openairdocs.org/ntsb/SEA97TA023.md): Bell 47G-3B-1 · Fillmore, UT · Accident · 1 fatal · Final report · Oct 29, 1996 · N3098G · Substantial damage
  > inadequate procedure and inadequate monitoring by the pilot, the operator, and/or other personnel, which allowed one of three external cables to the seed bucket to become entangled with the right skid of the helicopter, resulting in an imbalance and loss of…
- [NTSB MIA97FA014](https://openairdocs.org/ntsb/MIA97FA014.md): Bellanca 14-13-2 · Smithville, TN · Accident · 1 fatal · Field investigation · Final report · Oct 27, 1996 · N74306 · Destroyed
  > loss of engine power for undetermined reason(s), shortly after takeoff; and failure of the pilot to maintain adequate airspeed, while turning in an attempt to maneuver back to the airport, which resulted in an inadvertent stall and uncontrolled descent into…
- [NTSB MIA97FA013](https://openairdocs.org/ntsb/MIA97FA013.md): Cessna 172P · St. Croix · Accident · 3 fatal · Field investigation · Final report · Oct 26, 1996 · N9818L · Destroyed
  > the pilot's failure to maintain airspeed.
- [NTSB LAX97LA025](https://openairdocs.org/ntsb/LAX97LA025.md): Luscombe 8A · El Cajon, CA · Accident · No injuries · Limited investigation · Final report · Oct 26, 1996 · N71643 · Substantial damage
  > unfavorable weather condition(s), which caused the aircraft to descend at a rate that exceeded its climb capability.
- [NTSB IAD97LA012](https://openairdocs.org/ntsb/IAD97LA012.md): Bellanca 8KCAB · Sheffield, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 1996 · N2571Z · Destroyed
  > The pilot's abrupt control of the airplane, which resulted in an inadvertent stall, uncontrolled descent, and subsequent in-flight collision with water.
- [NTSB MIA97FA010](https://openairdocs.org/ntsb/MIA97FA010.md): Cessna 172F · Venice, FL · Accident · Minor injuries · Field investigation · Final report · Oct 22, 1996 · N5130F · Substantial damage
  > inadequate maintenance servicing of the airplane during an oil change by the owner/pilot for his failure to secure the oil temperature probe securing nut. Also, inadequate maintenance of the airplane by the owner/pilot for his failure to operate the engine…
- [NTSB IAD97LA009](https://openairdocs.org/ntsb/IAD97LA009.md): Cessna 172A · Lebanon, OH · Accident · 1 fatal · Limited investigation · Final report · Oct 20, 1996 · N9890T · Destroyed
  > improper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.
- [NTSB MIA97LA007](https://openairdocs.org/ntsb/MIA97LA007.md): Cessna 172N · Fruitland Park, FL · Accident · No injuries · Limited investigation · Final report · Oct 19, 1996 · N5155E · Substantial damage
  > The pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during takeoff. The unfavorable wind condition was a related factor.
- [NTSB MIA97LA006](https://openairdocs.org/ntsb/MIA97LA006.md): Cessna 150F · Lexington, TN · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1996 · N7102F · Substantial damage
  > failure of the pilot to abort the takeoff after encountering excessive ground roll, and failure (or inability) of the pilot to obtain/maintain adequate airspeed, which resulted in an inadvertent stall. Factors relating to the accident were: restricted…
- [NTSB CHI97LA011](https://openairdocs.org/ntsb/CHI97LA011.md): Aero Commander 685 · Eden, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1996 · N58RG · Destroyed
  > a partial loss of engine power due to improper adjustment of the fuel pump by an unqualified person (pilot-in-command) and the pilot's inadequate preflight planning which resulted in his selection of unsuitable terrain for the attempted takeoff. The pilot's…
- [NTSB FTW97LA020](https://openairdocs.org/ntsb/FTW97LA020.md): Cessna 320A · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Oct 18, 1996 · N430N · Substantial damage
  > The partial failure of the fuel control servo, causing an excessive flow/output of fuel to, and flooding of, the right engine.
- [NTSB ANC97LA004](https://openairdocs.org/ntsb/ANC97LA004.md): Burns Burn Experimental · Sitka, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1996 · N239AH · Substantial damage
  > the pilot's failure to follow the checklist and secure the cockpit door/canopy.
- [NTSB FTW97LA016](https://openairdocs.org/ntsb/FTW97LA016.md): Bell 206L-3 · Venice, LA · Accident · No injuries · Limited investigation · Final report · Oct 14, 1996 · N21497 · Substantial damage
  > a loss of engine power due to frogs being ingested into the engine as a result of the pilots failure to perform a thorough preflight, and the pilot's improper touchdown technique.
- [NTSB CHI97LA010](https://openairdocs.org/ntsb/CHI97LA010.md): Dellicker Starduster TOO SA300 · Eaton Rapids, MI · Accident · 2 fatal · Limited investigation · Final report · Oct 13, 1996 · N7691 · Destroyed
  > the pilot's failure to maintain adequate airspeed and subsequent inadvertent stall of the airplane. A factor was the ostentatious display.
- [NTSB ATL97LA003](https://openairdocs.org/ntsb/ATL97LA003.md): Harper W-8 Tailwind · Macclenny, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 1996 · N91323 · Substantial damage
  > the pilot's inadequate preflight inspection, which resulted in loss of engine power due to fuel contamination.
- [NTSB SEA97LA013](https://openairdocs.org/ntsb/SEA97LA013.md): Keith Vans RV-6A · Hurricane, UT · Accident · 2 fatal · Limited investigation · Final report · Oct 12, 1996 · N16DK · Destroyed
  > the pilot's impairment of judgment and performance due to drugs (diphenhydramine) which led to spatial disorientation and loss of aircraft control. Contributing to the accident were: dark night lighting conditions; inoperative airport runway lights; the…
- [NTSB LAX97LA016](https://openairdocs.org/ntsb/LAX97LA016.md): Waco QCF · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1996 · N11481 · Substantial damage
  > the pilot's improper response to a perceived in-flight emergency by abruptly retarding the throttle and failing to properly flare the airplane during the aborted takeoff. The pilot's improper perception of the source of smoke was a related factor.
- [NTSB MIA97LA004](https://openairdocs.org/ntsb/MIA97LA004.md): Cessna 177 · Ringgold, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1996 · N2286Y · Substantial damage
  > The pilot's failure to see and avoid obstructions during takeoff.
- [NTSB LAX97LA010](https://openairdocs.org/ntsb/LAX97LA010.md): Texas Helicopter OH-13E · Santa Rita, CA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1996 · N51582 · Substantial damage
  > The pilot's inadequate preflight inspection of the helicopter.
- [NTSB LAX97LA009](https://openairdocs.org/ntsb/LAX97LA009.md): Bellanca 17-30A · Jackpot, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1996 · N28172 · Destroyed
  > the pilot's inadvertent disorientation in dark night time conditions and failure to maintain a proper climbing attitude.
- [NTSB LAX97LA004](https://openairdocs.org/ntsb/LAX97LA004.md): Piper PA-28-180 · Ely, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1996 · N6614J · Destroyed
  > a partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed to preclude stalling, while turning toward an emergency landing area. A factor related to the accident was: the high density altitude condition.
- [NTSB IAD97LA004](https://openairdocs.org/ntsb/IAD97LA004.md): Wsk Pzl Krosno KR-03A · Kutztown, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1996 · N288S · Substantial damage
  > the glider pilot's improper decision to takeoff despite the presence of a glider winch cable lying on the runway area, which led to the glider snagging the winch cable during the takeoff roll and a subsequent forced landing. A related factor was: the airport…
- [NTSB LAX97FA003](https://openairdocs.org/ntsb/LAX97FA003.md): Cessna 172RG · Grand Canyon, AZ · Accident · 4 fatal · Field investigation · Final report · Oct 5, 1996 · N6267R · Destroyed
  > the pilot's inadequate preflight planning and preparation, which resulted in an inability to outclimb rising/wooded terrain after takeoff. Factors relating to the accident were: failure of the pilot to ensure that the aircraft's gross weight was not exceed…
- [NTSB ANC97LA003](https://openairdocs.org/ntsb/ANC97LA003.md): Piper PA-22 · Port Ashton, AK · Accident · No injuries · Limited investigation · Final report · Oct 3, 1996 · N2821P · Substantial damage
  > The pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the crosswind and wind gusts.
- [NTSB MIA97LA001](https://openairdocs.org/ntsb/MIA97LA001.md): Beech 58 · Jackson, MS · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1996 · N4178S · Substantial damage
  > the pilot's failure to maintain control of the airplane resulting in an in flight collision with the runway. A factor in this accident was the pilot diverted his attention away from flying the airplane to fix his shoe lace.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.