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

## Cases, newest first

- [NTSB ERA16LA267](https://openairdocs.org/ntsb/ERA16LA267.md): Temple Benjamin Freedom Master FM-2 · East Haddam, CT · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2016 · N282XT · Substantial damage
  > The pilot’s loss of airplane control during the initial climb.
- [NTSB ERA16LA266](https://openairdocs.org/ntsb/ERA16LA266.md): Republic RC 3 · Winter Haven, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 22, 2016 · N87570 · Substantial damage
  > Improper installation of a fuel line by unknown personnel, which resulted in a total loss of engine power during initial climb due to fuel starvation.
- [NTSB CEN16LA270](https://openairdocs.org/ntsb/CEN16LA270.md): Cessna 182J · Weatherford, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2016 · N2644F · Substantial damage
  > An electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…
- [NTSB ERA16FA257](https://openairdocs.org/ntsb/ERA16FA257.md): Piper PA 28R-201 · Esperance, NY · Accident · 3 fatal · Field investigation · Final report · Jul 16, 2016 · N2241Q · Destroyed
  > The pilot's inadequate preflight weight and balance and performance planning, which resulted in the airplane being over gross weight. Also causal were the pilot's decision not to use the entire runway for takeoff, his premature liftoff, and his failure to…
- [NTSB ENG16IA027](https://openairdocs.org/ntsb/ENG16IA027.md): Boeing 757 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Jul 7, 2016 · N706TW · Minor damage
  > Maintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.
- [NTSB CEN16LA256](https://openairdocs.org/ntsb/CEN16LA256.md): Gulfstream American AA 5 · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jul 7, 2016 · N26908 · Substantial damage
  > The airplane’s encounter with low-level wind shear during takeoff, which resulted in an off-airport landing.
- [NTSB WPR16LA138](https://openairdocs.org/ntsb/WPR16LA138.md): Cessna 172 · Brookings, OR · Accident · 3 fatal · Limited investigation · Final report · Jul 5, 2016 · N7870U · Destroyed
  > The pilot's spatial disorientation and loss of situational awareness during the departure turn in dark night conditions, which resulted in an in-flight collision with water.
- [NTSB ANC16WA039](https://openairdocs.org/ntsb/ANC16WA039.md): Piper PA28 · Winnipeg, Canada · Accident · 2 fatal · Foreign investigation · Jul 1, 2016 · C-GNUC · Substantial damage
  > On July 1, 2016, at approximately 1445 Coordinated Universal Time, a Canadian registered Piper PA-28-140 airplane, C-GNUC, owned and operated by a private pilot, was destroyed when it collided with terrain shortly after takeoff from Winnipeg Lyncrest Airport…
- [NTSB GAA16CA359](https://openairdocs.org/ntsb/GAA16CA359.md): Piper PA28 · Amarillo, TX · Accident · No injuries · Data collection · Final report · Jun 30, 2016 · N5724F · Substantial damage
  > The pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.
- [NTSB CEN16LA243](https://openairdocs.org/ntsb/CEN16LA243.md): Challenger II CW · Marysville, OH · Accident · No injuries · Limited investigation · Final report · Jun 30, 2016 · N788RH · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR16LA137](https://openairdocs.org/ntsb/WPR16LA137.md): Rockwell International S 2R · Brawley, CA · Accident · No injuries · Limited investigation · Final report · Jun 29, 2016 · N4952X · Substantial damage
  > The airplane’s inability to climb and subsequent impact with terrain for reasons that could not be determined based on the available information.
- [NTSB ERA16LA235](https://openairdocs.org/ntsb/ERA16LA235.md): Cessna 150 · Peachtree City, GA · Accident · No injuries · Limited investigation · Final report · Jun 29, 2016 · N1567Q · Substantial damage
  > The fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a total loss of engine power at low altitude after takeoff.
- [NTSB CEN16LA239](https://openairdocs.org/ntsb/CEN16LA239.md): Piper J3F 65 · Strasburg, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 2016 · N29042 · Substantial damage
  > A partial loss of engine power due to carburetor ice accumulation.
- [NTSB GAA16CA335](https://openairdocs.org/ntsb/GAA16CA335.md): Rans Employee Flying Club Rans S 6S · Richwood, OH · Accident · Minor injuries · Data collection · Final report · Jun 26, 2016 · N95669 · Substantial damage
  > The pilot's exceedance of the critical angle of attack during an initial climb of an aborted landing, which resulted in an inadvertent aerodynamic stall and impact with terrain.
- [NTSB ERA16LA231](https://openairdocs.org/ntsb/ERA16LA231.md): Cessna 172 · Hollywood, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 26, 2016 · N734UF · Substantial damage
  > A partial loss of engine power during the initial climb for undetermined reasons.
- [NTSB CEN16LA235](https://openairdocs.org/ntsb/CEN16LA235.md): Cessna 182 · Kankakee, IL · Accident · No injuries · Limited investigation · Final report · Jun 26, 2016 · N5792B · Substantial damage
  > Aa total loss of engine power due to fuel starvation, which resulted from the low level of fuel unporting during a rapid spiraling descent.
- [NTSB GAA16CA336](https://openairdocs.org/ntsb/GAA16CA336.md): Cessna 152 · Delta, CO · Accident · No injuries · Data collection · Final report · Jun 25, 2016 · N152L · Substantial damage
  > The pilot exceeded the critical angle of attack during the initial climb in tailwind conditions, which resulted in an aerodynamic stall.
- [NTSB ERA16WA232](https://openairdocs.org/ntsb/ERA16WA232.md): Cessna U206 · Fresh Creek, Bahamas · Accident · No injuries · Foreign investigation · Jun 25, 2016 · N9662G · Substantial damage
  > On June 25, 2016, about 2106 Universal Coordinated Time (UTC), a Cessna U206F, N9662G, operated by Chrimat Inc., was substantially damaged following a loss of engine power and forced landing at Fresh Creek, Bahamas. The pilot was not injured. The airplane…
- [NTSB ERA16LA230](https://openairdocs.org/ntsb/ERA16LA230.md): Piper PA28 · Hollywood, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 2016 · N9836W · Substantial damage
  > The pilot’s inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.
- [NTSB GAA16CA320](https://openairdocs.org/ntsb/GAA16CA320.md): Beech 77 · Santa Fe, NM · Accident · No injuries · Data collection · Final report · Jun 16, 2016 · N60189 · Substantial damage
  > The pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…
- [NTSB ERA16LA220](https://openairdocs.org/ntsb/ERA16LA220.md): Champion 7AC · Gorham, NH · Accident · No injuries · Class 3 · Limited · Final report · Jun 16, 2016 · N83578 · Substantial damage
  > The partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to abort the takeoff after the airplane’s initial failure to climb.
- [NTSB CEN16FA220](https://openairdocs.org/ntsb/CEN16FA220.md): Piper PA-38-112 · Madison, IN · Accident · 1 fatal · Field investigation · Final report · Jun 16, 2016 · N2412D · Substantial damage
  > The pilot’s failure to maintain a proper climb rate after takeoff and the subsequent collision with transmission line structures.
- [NTSB CEN16LA221](https://openairdocs.org/ntsb/CEN16LA221.md): Flight Design Ctsw HXB · Sealy, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 2016 · N302CT · Destroyed
  > Failure of maintenance personnel to comply with the engine manufacturer’s mandatory service bulletin, which resulted in failure of the mechanical fuel pump diaphragm and a subsequent total loss of engine power.
- [NTSB CEN16FA216](https://openairdocs.org/ntsb/CEN16FA216.md): Cessna 150F · Rockville, IN · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2016 · N102DK · Destroyed
  > The pilot's use of an improper soft-field takeoff procedure, which resulted in the airplane having insufficient airspeed to climb out of ground effect and its subsequent impact with trees near the departure end of the runway.
- [NTSB GAA16CA298](https://openairdocs.org/ntsb/GAA16CA298.md): Cessna 182 · Stanley, ID · Accident · No injuries · Data collection · Final report · Jun 9, 2016 · N1403S · Substantial damage
  > The pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.
- [NTSB CEN16FA212](https://openairdocs.org/ntsb/CEN16FA212.md): Piper PA 28-140 · Wishek, ND · Accident · 3 fatal · Field investigation · Final report · Jun 9, 2016 · N6223W · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…
- [NTSB GAA16LA329](https://openairdocs.org/ntsb/GAA16LA329.md): Mini Max 1200 · Batesville, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2016 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to depart without obtaining flight training in the…
- [NTSB ERA16LA204](https://openairdocs.org/ntsb/ERA16LA204.md): Bobbi Boucher DUO Deuce · Stafford, VA · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 2016 · N808DD · Substantial damage
  > The pilot's failure to attain adequate airspeed during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ERA16LA202](https://openairdocs.org/ntsb/ERA16LA202.md): Bell 407 · Mountain City, TN · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 2016 · N4999 · Substantial damage
  > An incorrect and unapproved repair of the engine compressor diffuser performed by a machinist at a repair facility, which resulted in failure of the compressor diffuser aft plate and a partial loss of engine power.
- [NTSB CEN16WA237](https://openairdocs.org/ntsb/CEN16WA237.md): Vans RV6 · St-Mathieu-De-Beloeil, Canada · Accident · 1 fatal · Foreign investigation · Jun 2, 2016 · C-FTUO · Destroyed
  > On June 28, 2016, about 1350 Universal Coordinated Time (UTC), a Vans RV6, C-TFUO, impacted terrain at St-Mathieu-De-Beloeil (CSB3), Quebec, Canada. The pilot, the sole occupant on board, was fatally injured. The airplane was substantially destroyed. The…
- [NTSB ERA16LA199](https://openairdocs.org/ntsb/ERA16LA199.md): American Legend AL3 · Elberta, AL · Accident · No injuries · Limited investigation · Final report · May 31, 2016 · N156WB · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the engine ran normally during a postaccident engine test run with no anomalies noted.
- [NTSB DCA16WA167](https://openairdocs.org/ntsb/DCA16WA167.md): Boeing 737 · tokyo, Japan · Incident · Minor injuries · Foreign investigation · May 27, 2016 · JA85AN · No damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of serious incident involving a BOEING 737 airplane that occurred on May 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…
- [NTSB GAA16CA234](https://openairdocs.org/ntsb/GAA16CA234.md): Cirrus Design SR22 · Pahokee, FL · Accident · No injuries · Data collection · Final report · May 15, 2016 · N463C · Substantial damage
  > The pilot's failure to maintain directional control and lateral bank control during the aborted landing, which resulted in collision with terrain.
- [NTSB CEN16LA186](https://openairdocs.org/ntsb/CEN16LA186.md): Piper PA 32R · Alpine, TX · Accident · No injuries · Limited investigation · Final report · May 15, 2016 · N185DX · Substantial damage
  > The engine’s decreased performance due to high-density altitude conditions and a partially obstructed fuel injector nozzle. Contributing to the pilot's decision to perform an off-field landing was the anomalous high exhaust gas temperature reading.
- [NTSB ERA16LA184](https://openairdocs.org/ntsb/ERA16LA184.md): Globe GC 1B · Hedgesville, WV · Accident · Serious injuries · Limited investigation · Final report · May 14, 2016 · N78193 · Substantial damage
  > The pilot's failure to maintain airplane control when it encountered a wind gust during climbout.
- [NTSB ERA16LA183](https://openairdocs.org/ntsb/ERA16LA183.md): Piper PA 22 · Gallatin, TN · Accident · No injuries · Limited investigation · Final report · May 13, 2016 · N5823Z · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in an inflight fire due to the presence of a bird nest in the engine compartment.
- [NTSB WPR16LA106](https://openairdocs.org/ntsb/WPR16LA106.md): Boeing B75N1 · Winslow, AZ · Accident · No injuries · Limited investigation · Final report · May 12, 2016 · N56200 · Substantial damage
  > The partial loss of engine power during takeoff initial climb in high-density altitude conditions for reasons that could not be determined because a postaccident examination of the airplane and engine revealed no anomalies.
- [NTSB DCA16WA159](https://openairdocs.org/ntsb/DCA16WA159.md): Boeing 737 · Lahore, Pakistan · Incident · No injuries · Foreign investigation · May 9, 2016 · AP-BKE · No damage
  > The government of Pakistan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…
- [NTSB CEN16WA176](https://openairdocs.org/ntsb/CEN16WA176.md): Rans S12 · Wiener Neustadt, Austria, Austria · Accident · 2 fatal · Foreign investigation · May 6, 2016 · D-MOHA · Destroyed
  > On May 6, 2016, about 1625 coordinated universal time (UTC), a Rans S-12, D-MOHA, was destroyed when it impacted terrain after a loss of control during the initial climb from Loan Airport, Wiener Neustadt, Austria. The pilot and passenger were killed. The…
- [NTSB CEN16LA175](https://openairdocs.org/ntsb/CEN16LA175.md): Airborne Windsports PTY Edge X Classic · Rush City, MN · Accident · 1 fatal · Limited investigation · Final report · May 5, 2016 · N701FP · Destroyed
  > The student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…
- [NTSB CEN16FA172](https://openairdocs.org/ntsb/CEN16FA172.md): Cessna 310F · North Little Rock, AR · Accident · 1 fatal · Field investigation · Final report · May 5, 2016 · N6770X · Destroyed
  > The pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…
- [NTSB WPR16IA100](https://openairdocs.org/ntsb/WPR16IA100.md): Piper PA28 · San Carlos, CA · Incident · No injuries · Incident investigation · Final report · Apr 29, 2016 · N200KR · No damage
  > The failure of maintenance personnel to properly install and secure the input swivel boot on the swivel joint, which resulted in excessive vibration that led to fatigue cracks and failure of the throttle cable.
- [NTSB CEN16LA177](https://openairdocs.org/ntsb/CEN16LA177.md): Boeing A75N1 (PT17) · Osage City, KS · Accident · No injuries · Limited investigation · Final report · Apr 28, 2016 · N17PY · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA16FA170](https://openairdocs.org/ntsb/ERA16FA170.md): Beech 76 · Pompano Beach, FL · Accident · Serious injuries · Field investigation · Final report · Apr 25, 2016 · N6709Y · Destroyed
  > The flight instructor's failure to maintain airplane control while demonstrating a simulated engine failure. Contributing to the accident was the pilot's improper response to the simulated engine failure.
- [NTSB ERA16FA169](https://openairdocs.org/ntsb/ERA16FA169.md): Piper PA32 · Boone, NC · Accident · 1 fatal · Field investigation · Final report · Apr 25, 2016 · N43576 · Destroyed
  > The pilot's delayed decision to conduct a go-around following an unstabilized landing approach and his subsequent failure to maintain clearance from trees near the end of the runway.
- [NTSB CEN16LA164](https://openairdocs.org/ntsb/CEN16LA164.md): Mooney M20C · Sand Springs, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 2016 · N6870N · Substantial damage
  > A total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate preflight inspection.
- [NTSB ERA16LA156](https://openairdocs.org/ntsb/ERA16LA156.md): Atkinson Eaglet · Deland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 2016 · N5AQ · Substantial damage
  > A total loss of engine power during initial climb due to a separation of the ignition plug.
- [NTSB ERA16LA152](https://openairdocs.org/ntsb/ERA16LA152.md): Piper PA 28-140 · Bayport, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 2016 · N95118 · Substantial damage
  > Maintenance personnel’s improper installation and maintenance of the fuel selector valve, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ENG16RA021](https://openairdocs.org/ntsb/ENG16RA021.md): ATR ATR72 · Trapani, Italy · Incident · No injuries · Foreign investigation · Apr 9, 2016 · OY-YAB · No damage
  > The Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred April 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of ICAO…
- [NTSB ERA16WA155](https://openairdocs.org/ntsb/ERA16WA155.md): Douglas DC3 · Puerto Gaitan, Colombia · Accident · Minor injuries · Foreign investigation · Apr 7, 2016 · HK2663 · Substantial damage
  > On April 7, 2016, about 1200 coordinated universal time, a Douglas DC3-C, Colombian registration HK2663, was destroyed during a postimpact fire, following a forced landing to a field due to a loss of power on the left engine during initial climb from Puerto…

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

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

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