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

## Cases, newest first

- [NTSB FTW97LA245](https://openairdocs.org/ntsb/FTW97LA245.md): Air Tractor AT-400A · Church Point, LA · Accident · No injuries · Limited investigation · Final report · Jun 11, 1997 · N36538 · Substantial damage
  > The pilot's improperly performed short field takeoff procedures.
- [NTSB CHI97LA157](https://openairdocs.org/ntsb/CHI97LA157.md): Cessna A188B · La Moure, ND · Accident · No injuries · Limited investigation · Final report · Jun 5, 1997 · N8293G · Substantial damage
  > a loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.
- [NTSB CHI97LA156](https://openairdocs.org/ntsb/CHI97LA156.md): Champion 7ECA · Gregory, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 4, 1997 · N5253X · Substantial damage
  > The pilot's improper planning/decision. The tailwind and location of trees were related factors.
- [NTSB SEA97LA125](https://openairdocs.org/ntsb/SEA97LA125.md): Cessna 402C · Rawlins, WY · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 1997 · N1233P · Substantial damage
  > The pilot's failure to maintain clearance from the terrain during the initial climb after a night takeoff. Factors include a dark night and rising terrain off the departure end of the runway.
- [NTSB CHI97LA153](https://openairdocs.org/ntsb/CHI97LA153.md): Piper PA-22-108 · Alanson, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 1997 · N5739Z · Destroyed
  > inadequate preflight by the pilot, which resulted in fuel starvation, due to an improper fuel tank selector position. A factor relating to the accident was: the pilot's improper inflight planning/decision, which resulted in his delay or inability to flare the…
- [NTSB CHI97LA155](https://openairdocs.org/ntsb/CHI97LA155.md): Cessna 150 · Woodbine, IA · Accident · No injuries · Limited investigation · Final report · May 31, 1997 · N60971 · Substantial damage
  > The pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.
- [NTSB NYC97LA100](https://openairdocs.org/ntsb/NYC97LA100.md): Piper PA-28-140 · Baltimore, MD · Accident · No injuries · Limited investigation · Final report · May 27, 1997 · N6927W · Substantial damage
  > the pilot's inadequate preflight of the airplane which failed to detect water in the fuel, and resulted in a power loss after departure due to fuel contamination.
- [NTSB LAX97LA196](https://openairdocs.org/ntsb/LAX97LA196.md): Piper PA-32-300 · Tinian, Sark · Accident · No injuries · Limited investigation · Final report · May 27, 1997 · N4510X · Substantial damage
  > the pilot's improper takeoff abort. Contributing to the accident was the pilot's improper preflight planning and preparation.
- [NTSB NYC97FA099](https://openairdocs.org/ntsb/NYC97FA099.md): Cessna 180 · Freedom, PA · Accident · Serious injuries · Field investigation · Final report · May 26, 1997 · N1802C · Destroyed
  > the pilot's premature lift off, and his failure to maintain proper runway alignment, which resulted in an inadvertent stall, while attempting to avoid an obstruction (telephone pole). Factors relating to the accident were: the pilot allowed the airplane's…
- [NTSB IAD97LA076](https://openairdocs.org/ntsb/IAD97LA076.md): Dresbach RV-4 · Bainbridge, OH · Accident · 1 fatal · Limited investigation · Final report · May 26, 1997 · N61CD · Destroyed
  > failure of the pilot to maintain control of the airplane during the initial climb after takeoff. The pilot's physiological conditions was a possible factor.
- [NTSB CHI97LA144](https://openairdocs.org/ntsb/CHI97LA144.md): Piper PA-28-140 · Arcadia, IN · Accident · Serious injuries · Limited investigation · Final report · May 24, 1997 · N5892W · Destroyed
  > improper planning/decision by the pilot. Factors related to the accident were: the pilot's selection of the wrong runway for takeoff, and the resultant tailwind.
- [NTSB FTW97LA196](https://openairdocs.org/ntsb/FTW97LA196.md): Ayres S2R-T34 · Welsh, LA · Accident · Minor injuries · Limited investigation · Final report · May 22, 1997 · N30982 · Substantial damage
  > The pilot's failure to maintain clearance with a moving vehicle. Factors were: the lack of runway signs and a runway safety area, and the difficulty for the pilot and driver of the vehicle to visually detect each other due to high vegetation at the edge of…
- [NTSB CHI97LA143](https://openairdocs.org/ntsb/CHI97LA143.md): Cessna 140 · Fulton, MO · Accident · No injuries · Limited investigation · Final report · May 22, 1997 · N76122 · Substantial damage
  > a malfunction of the engine's carburetor that was associated with a spalled carburetor float fulcrum pin which resulted in fuel starvation.
- [NTSB SEA97LA118](https://openairdocs.org/ntsb/SEA97LA118.md): Hughes 369D · Moclips, WA · Accident · No injuries · Limited investigation · Final report · May 21, 1997 · N8306F · Substantial damage
  > Inadequate installation of the fuel control by company maintenance personnel and a loose nut on a line. A disconnected Pc line was a factor.
- [NTSB LAX97FA189](https://openairdocs.org/ntsb/LAX97FA189.md): Embraer EMB-120 · San Diego, CA · Accident · No injuries · Field investigation · Final report · May 21, 1997 · N198SW · Substantial damage
  > The failure of maintenance personnel to allow adequate time for the engine oil to drain back into the engine oil reservoir prior to adding additional oil, thereby overfilling the reservoir, which resulted in an engine fire and subsequent damage to hydraulic…
- [NTSB FTW97FA193](https://openairdocs.org/ntsb/FTW97FA193.md): Pezetel M-18A · Wilmot, AR · Accident · 1 fatal · Field investigation · Final report · May 19, 1997 · N8089Z · Destroyed
  > failure of the pilot to remove the elevator control lock before the first flight of the day, which resulted in his inability to control the airplane, due to the locked elevator control. Related factors were: the prevailing high winds and the lack of a visible…
- [NTSB NYC97LA096](https://openairdocs.org/ntsb/NYC97LA096.md): Cessna 172M · Galion, OH · Accident · No injuries · Limited investigation · Final report · May 18, 1997 · N4430R · Substantial damage
  > The inadvertent encounter with the helicopter main rotor downwash during the initial takeoff climb. Subsequently, the airplane descended and impacted the ground.
- [NTSB CHI97FA133](https://openairdocs.org/ntsb/CHI97FA133.md): Piper PA-38-112 · Savoy, IL · Accident · 1 fatal · Field investigation · Final report · May 18, 1997 · N383AV · Destroyed
  > the pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.
- [NTSB MIA97LA166](https://openairdocs.org/ntsb/MIA97LA166.md): Travis C. Elmore B2B/582 · Haines City, FL · Accident · Serious injuries · Limited investigation · Final report · May 16, 1997 · N43CT · Substantial damage
  > The pilots inadvertent activation of the rear carburetor choke lever during routine engine maintenance the day before the accident. Contributing to the accident was the unsuitable terrain encountered during the forced landing and also failure of the engine…
- [NTSB LAX97LA179](https://openairdocs.org/ntsb/LAX97LA179.md): Hiller UH-12E · Truckee, CA · Accident · Serious injuries · Limited investigation · Final report · May 14, 1997 · N7082D · Substantial damage
  > A loss of engine power for undetermined reasons. A factor in the accident was the unsuccessful attempt to release the long line from the belly hook after it became entangled in a tree.
- [NTSB IAD97LA075](https://openairdocs.org/ntsb/IAD97LA075.md): Cessna 180J · Lebanon, NH · Accident · No injuries · Limited investigation · Final report · May 14, 1997 · N4992V · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB FTW97LA191](https://openairdocs.org/ntsb/FTW97LA191.md): Piper PA-28-160 · Weatherford, TX · Accident · No injuries · Limited investigation · Final report · May 14, 1997 · N5140W · Substantial damage
  > loss of engine power for undetermined reason(s). Uneven terrain beyond the end of the runway was a related factor.
- [NTSB LAX97IA180](https://openairdocs.org/ntsb/LAX97IA180.md): Saab-Scania 340B · San Luis Obispo, CA · Incident · No injuries · Incident investigation · Final report · May 13, 1997 · N313AE · No damage
  > Compressor stalls of both engines due to in-service compressor contamination. Factors in the compressor stall of the right engine were an atmospheric temperature inversion and a transient fuel flow condition produced when the constant thrust on takeoff (CTOT)…
- [NTSB MIA97IA160](https://openairdocs.org/ntsb/MIA97IA160.md): Short Brothers SD3-60 · Miami, FL · Incident · No injuries · Incident investigation · Final report · May 9, 1997 · N263GA · No damage
  > fatigue failure of a segment of the elevator trim cable system. A factor relating to the incident was: inadequate procedure for inspection of the cable system by the airplane manufacturer.
- [NTSB CHI97LA126](https://openairdocs.org/ntsb/CHI97LA126.md): Grumman G-164A · Prairie View, KS · Accident · No injuries · Limited investigation · Final report · May 9, 1997 · N7859 · Substantial damage
  > an undetermined event, which resulted in loss of engine power. Factors relating to the accident were: an automobile, which prevented the pilot from landing on a road; and a dirt bank (terrace) in the emergency landing area.
- [NTSB FTW97IA362](https://openairdocs.org/ntsb/FTW97IA362.md): Ayres S2R-G10 · Munday, TX · Incident · No injuries · Incident investigation · Final report · May 8, 1997 · N3298Y · Minor damage
  > blockage of both fuel lines from the left wing tank to the header tank by silicone rubber contaminants (foreign material), which resulted in fuel starvation. A related factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC97LA087](https://openairdocs.org/ntsb/NYC97LA087.md): Pitts S1C · Salem, OH · Accident · Minor injuries · Limited investigation · Final report · May 7, 1997 · N12073 · Substantial damage
  > the pilot's failure to maintain aircraft control during the initial takeoff climb. Factors relating to the accident were the pilot's lack of experience in the make and model of airplane, and the gusty crosswind conditions.
- [NTSB FTW97LA179](https://openairdocs.org/ntsb/FTW97LA179.md): Callair A2A · Grants, NM · Accident · Serious injuries · Limited investigation · Final report · May 6, 1997 · N2915V · Substantial damage
  > Inadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.
- [NTSB ANC97LA068](https://openairdocs.org/ntsb/ANC97LA068.md): Hammer Avid Flyer · Chitina, AK · Accident · No injuries · Limited investigation · Final report · May 4, 1997 · N525BB · Substantial damage
  > improper overhaul of the engine, which resulted in a seized piston and resultant loss of engine power. Rough terrain in the emergency landing area was a related factor.
- [NTSB MIA97LA155](https://openairdocs.org/ntsb/MIA97LA155.md): Piper PA31-350 · St Thomas · Accident · No injuries · Limited investigation · Final report · May 3, 1997 · N4088G · Substantial damage
  > failure of the pilot to follow emergency procedures for loss of power in the right engine, by failing to shutdown the right engine and feather the right propeller. This resulted in the aircraft being unable to maintain altitude and a subsequent ditching in…
- [NTSB FTW97FA173](https://openairdocs.org/ntsb/FTW97FA173.md): Gowan LONG-EZ · Roanoke, TX · Accident · Minor injuries · Field investigation · Final report · May 3, 1997 · N86RG · Substantial damage
  > The pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.
- [NTSB LAX97LA171](https://openairdocs.org/ntsb/LAX97LA171.md): Cessna 140 · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 1997 · N2031N · Destroyed
  > the pilot's failure to obtain and/or maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the degraded climb performance due to an…
- [NTSB LAX97IA170](https://openairdocs.org/ntsb/LAX97IA170.md): McDonnell Douglas MD-82 · Tucson, AZ · Incident · No injuries · Incident investigation · Final report · Apr 28, 1997 · N470AA · Minor damage
  > an undetermined failure in the #1 (left) engine turbine assembly, which resulted in a fracture of the first stage nozzle guide vane (NGV) and subsequent damage to the turbine blades.
- [NTSB FTW97LA168](https://openairdocs.org/ntsb/FTW97LA168.md): Globe GC-1B · Gatesville, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1997 · N80737 · Substantial damage
  > Inadvertent stall. A factor was the pilot's lack of total experience in the make and model of aircraft.
- [NTSB SEA97LA093](https://openairdocs.org/ntsb/SEA97LA093.md): Piper PA-28-140 · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Apr 26, 1997 · N6121J · Substantial damage
  > The pilot's inadequate preflight planning. Factors include high density altitude, downdrafts, and rough/uneven terrain in the area where the pilot attempted the emergency landing.
- [NTSB ATL97LA062](https://openairdocs.org/ntsb/ATL97LA062.md): Cessna 140 · Clearwater, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1997 · N2351V · Substantial damage
  > The pilot's failure to select the fuller tank for takeoff that resulted in fuel starvation to the engine, and the subsequent total loss of engine power.
- [NTSB MIA97LA141](https://openairdocs.org/ntsb/MIA97LA141.md): Young Merlin GT · Fort Myers, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 19, 1997 · N2100S · Destroyed
  > the pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/spin and subsequent collision with the terrain. Factors relating to the accident were: the pilot's failure to use all available runway, and…
- [NTSB LAX97LA163](https://openairdocs.org/ntsb/LAX97LA163.md): Piper PA-28R-201T · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 18, 1997 · N2847F · Substantial damage
  > The partial blockage of the No. 2 cylinder injection line/nozzle by a transient contaminant, which induced an excessively lean mixture in that cylinder, and the subsequent overheating of the cylinder and intake valve. The engine power loss was due to the open…
- [NTSB CHI97LA106](https://openairdocs.org/ntsb/CHI97LA106.md): Air Tractor AT-401 · Highmore, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1997 · N1008P · Substantial damage
  > a premature lift-off of the airplane by the pilot in command.
- [NTSB NYC97FA076](https://openairdocs.org/ntsb/NYC97FA076.md): Eurocopter MBB-BK117-B2 · New York, NY · Accident · 1 fatal · Field investigation · Final report · Apr 15, 1997 · N909CP · Destroyed
  > Fatigue failure of the vertical fin, accelerated by the installation of blind rivets in lieu of solid rivets in the replacement of the yaw SAS mount support, which resulted in the loss of helicopter directional control and collision with the terrain (water).…
- [NTSB MIA97LA130](https://openairdocs.org/ntsb/MIA97LA130.md): Boeing B75N1 · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 1997 · N65467 · Destroyed
  > The partial loss of engine power for undetermined reasons.
- [NTSB MIA97LA120](https://openairdocs.org/ntsb/MIA97LA120.md): Basinski Kolb MK3 · Winter Haven, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 8, 1997 · N128BB · Substantial damage
  > failure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.
- [NTSB MIA97GA119](https://openairdocs.org/ntsb/MIA97GA119.md): Aerospatiale AS 350B · West Palm Beach, FL · Accident · Serious injuries · Final report · Apr 8, 1997 · N370WM · Substantial damage
  > Failure of the pilot-in-command to recognize that the main rotor rpm was decreasing and his failure to maintain the main rotor rpm during the autorotative landing resulting in a hard landing. Contributing to the accident was the partial loss of engine power…
- [NTSB FTW97LA156](https://openairdocs.org/ntsb/FTW97LA156.md): Rockwell 114 · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Apr 7, 1997 · N4861W · Destroyed
  > The exhaust manifold cracking due to the pilot's inadequate maintenance modification of the exhaust system which resulted in a fire. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA97LA085](https://openairdocs.org/ntsb/SEA97LA085.md): Beech 1900D · Portland, OR · Accident · No injuries · Limited investigation · Final report · Apr 6, 1997 · N75ZV · Substantial damage
  > the flightcrew's inadequate preflight, and the ramp agent's inadequate dispatch of the aircraft. The unsecured cargo door was a factor.
- [NTSB SEA97LA084](https://openairdocs.org/ntsb/SEA97LA084.md): Hutton Rand Robinson KR-2 · Grants Pass, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N4GJ · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions, his failure to maintain directional control on takeoff, and his failure to abort the takeoff. Factors contributing to the accident are gusty crosswinds.
- [NTSB SEA97LA083](https://openairdocs.org/ntsb/SEA97LA083.md): Cessna 150D · Arlington, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N4100U · 2 aircraft · Destroyed
  > The failure of the commercial pilot to perform an adequate visual lookout while on final approach for landing on the runway, and the failure of the student pilot of the other airplane to perform an adequate visual lookout prior to taking off from the same…
- [NTSB FTW97LA153](https://openairdocs.org/ntsb/FTW97LA153.md): Mooney M20F · Marietta, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N6492Q · Substantial damage
  > The pilot's inadequate short field takeoff. A factor was the pilot's lack of recent experience in short field takeoffs from a grass/turf runway.
- [NTSB NYC97LA070](https://openairdocs.org/ntsb/NYC97LA070.md): Cessna 150E · Wolfeboro, NH · Accident · No injuries · Limited investigation · Final report · Apr 5, 1997 · N6106T · Substantial damage
  > The pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.
- [NTSB LAX97LA147](https://openairdocs.org/ntsb/LAX97LA147.md): Cessna 182D · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 5, 1997 · N9000X · Substantial damage
  > Fuel exhaustion due to the inadequate preflight inspections performed by both pilots. A factor in the accident was the crosswind experienced during landing rollout.

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

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

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