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

## Cases, newest first

- [NTSB CEN14FA377](https://openairdocs.org/ntsb/CEN14FA377.md): Oden Weldon Pat Kitfox IV Speedster · Blackwell, TX · Accident · 1 fatal · Field investigation · Final report · Jul 20, 2014 · N622P · Substantial damage
  > The pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN14LA385](https://openairdocs.org/ntsb/CEN14LA385.md): Evektor-Aerotechnik Sportstar · Wichita Falls, TX · Accident · No injuries · Limited investigation · Final report · Jul 19, 2014 · N636EV · Substantial damage
  > A partial loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined during postaccident examination.
- [NTSB WPR14LA298](https://openairdocs.org/ntsb/WPR14LA298.md): Piper PA 30 · Othello, WA · Accident · No injuries · Limited investigation · Final report · Jul 17, 2014 · N7981Y · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA14FA337](https://openairdocs.org/ntsb/ERA14FA337.md): Culver LFA · Limington, ME · Accident · 1 fatal · Field investigation · Final report · Jul 12, 2014 · N41716 · Substantial damage
  > The pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB ENG14IA019](https://openairdocs.org/ntsb/ENG14IA019.md): Boeing 767 332 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Jul 11, 2014 · N139DL · Minor damage
  > The combination of fuel leaking from the integrated drive generator (IDG) fuel/oil heat exchanger and the coincident arcing of the IDG power feeder cables that ignited the leaking fuel. Contributing to the ignition of the fuel was the misrouting of the IDG…
- [NTSB ERA14CA349](https://openairdocs.org/ntsb/ERA14CA349.md): Pekola James W Ridge Runner III · Andrews, NC · Accident · No injuries · Data collection · Final report · Jul 10, 2014 · N39ZT · Substantial damage
  > The pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR14FA286](https://openairdocs.org/ntsb/WPR14FA286.md): Cessna 182 · Fall City, WA · Accident · 1 fatal · Field investigation · Final report · Jul 8, 2014 · N5816B · Substantial damage
  > The pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB CEN14LA357](https://openairdocs.org/ntsb/CEN14LA357.md): Cessna TR182 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Jul 7, 2014 · N4602S · Substantial damage
  > Maintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.
- [NTSB ERA14LA338](https://openairdocs.org/ntsb/ERA14LA338.md): Lawson Ronald S Explorer · East Bend, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 2014 · N6663K · Substantial damage
  > A total loss of engine power likely due to a failure of a rotary valve shaft seal and the pilot’s failure to detect and diagnose the impending failure during the preflight inspection.
- [NTSB ERA14LA329](https://openairdocs.org/ntsb/ERA14LA329.md): Flight Design CT-SW 2006 · Gasport, NY · Accident · 1 fatal · Limited investigation · Final report · Jul 5, 2014 · N508CT · Substantial damage
  > The pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB CEN14RA340](https://openairdocs.org/ntsb/CEN14RA340.md): Piper PA 31P · Czestochowska, Poland · Accident · 11 fatal · Foreign investigation · Jul 5, 2014 · N11WB · Destroyed
- [NTSB WPR14WA318](https://openairdocs.org/ntsb/WPR14WA318.md): Cessna T210N · Inverell, Australia, Australia · Accident · 1 fatal · Foreign investigation · Jul 4, 2014 · VH-ZFW · Destroyed
  > On July 4, 2014, at 1325 local time, a Cessna T210N, VH-ZFW, collided with terrain shortly after takeoff from Inverell, Australia. The airplane was operated by the pilot under the pertinent civil regulations of the government of Australia. The airplane was…
- [NTSB CEN14FA339](https://openairdocs.org/ntsb/CEN14FA339.md): North American/Aero Classics P 51D · Durango, CO · Accident · 2 fatal · Field investigation · Final report · Jul 4, 2014 · N1451D · Substantial damage
  > The pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…
- [NTSB DCA14WA138](https://openairdocs.org/ntsb/DCA14WA138.md): Fokker F27 - 50 · Nairobi, Kenya · Accident · 4 fatal · Foreign investigation · Jul 2, 2014 · 5Y-CET · Destroyed
- [NTSB CEN14FA337](https://openairdocs.org/ntsb/CEN14FA337.md): Piper PA30 · Harrison, AR · Accident · Serious injuries · Field investigation · Final report · Jul 2, 2014 · N7762Y · Substantial damage
  > The pilot's loss of control of the airplane during initial climb because he failed to correctly compensate for the loss of power in the left engine. Contributing to the accident was water contamination in the fuel and the lack of an adequate preflight…
- [NTSB CEN14LA333](https://openairdocs.org/ntsb/CEN14LA333.md): Cessna 172R · Joplin, MO · Accident · No injuries · Limited investigation · Final report · Jul 1, 2014 · N468CM · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA14LA316](https://openairdocs.org/ntsb/ERA14LA316.md): Czech Sport Piper Sport · Peachtree City, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2014 · N957MD · Substantial damage
  > The pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…
- [NTSB CEN14LA305](https://openairdocs.org/ntsb/CEN14LA305.md): Bollinger Robert L BD 4 · Fairfield, IA · Accident · 1 fatal · Limited investigation · Final report · Jun 22, 2014 · N108BC · Destroyed
  > The pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.
- [NTSB WPR14LA257](https://openairdocs.org/ntsb/WPR14LA257.md): Cessna 152 · Agua Dulce, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 2014 · N4606L · Substantial damage
  > The pilot's decision to continue the takeoff from the upsloping runway with full-flap deflection in high density altitude conditions, which led to a decreased climb rate and impact with terrain.
- [NTSB WPR14CA254](https://openairdocs.org/ntsb/WPR14CA254.md): Maule MX 7-235 · Port Orchard, WA · Accident · No injuries · Data collection · Final report · Jun 20, 2014 · N5665A · Substantial damage
  > The pilot's delayed remedial action and failure to maintain directional control.
- [NTSB ERA14LA309](https://openairdocs.org/ntsb/ERA14LA309.md): Simmons William E Aventura 2 · Rockledge, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 2014 · N700WS · Substantial damage
  > The pilot’s failure to maintain airspeed during a forced landing following a loss of engine power, which resulted in a hard landing. Contributing to the accident was the pilot’s inadequate inspection of the engine, which resulted in a loose ground wire lug on…
- [NTSB ERA14LA308](https://openairdocs.org/ntsb/ERA14LA308.md): Taylor J-2 · Lock Haven, PA · Accident · No injuries · Limited investigation · Final report · Jun 20, 2014 · N16667 · Substantial damage
  > The airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.
- [NTSB ERA14LA321](https://openairdocs.org/ntsb/ERA14LA321.md): Grumman Acft ENG Cor-Schweizer G 164B · Farmington, DE · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2014 · N891JC · Substantial damage
  > The pilot's inadequate preflight planning for a takeoff in high-density altitude conditions and his decision to reduce power during the initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB ERA14LA294](https://openairdocs.org/ntsb/ERA14LA294.md): Cub Crafters CC18-180 · Pennsboro, WV · Accident · No injuries · Limited investigation · Final report · Jun 17, 2014 · N696RP · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA14LA302](https://openairdocs.org/ntsb/ERA14LA302.md): Bailey Robert Moyes Dragonfly · Melfa, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2014 · N286A · Substantial damage
  > The pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.
- [NTSB WPR14LA249](https://openairdocs.org/ntsb/WPR14LA249.md): Piper PA 28-180 · Quincy, CA · Accident · No injuries · Limited investigation · Final report · Jun 15, 2014 · N4931L · Substantial damage
  > The partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow to the engine. Contributing to the accident was maintenance personnel’s inadequate inspection of the exhaust system…
- [NTSB ERA14FA289](https://openairdocs.org/ntsb/ERA14FA289.md): Meyer Clair O 2/3 P 51B/C Mustang · Marion, SC · Accident · 1 fatal · Field investigation · Final report · Jun 13, 2014 · N51BM · Substantial damage
  > The airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.
- [NTSB ERA14FA288](https://openairdocs.org/ntsb/ERA14FA288.md): Piper PA-46-500TP · White Plains, NY · Accident · 1 fatal · Field investigation · Final report · Jun 13, 2014 · N5335R · Destroyed
  > The pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…
- [NTSB WPR14LA242](https://openairdocs.org/ntsb/WPR14LA242.md): Adams Dragonfly · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jun 12, 2014 · N85TL · Substantial damage
  > A partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.
- [NTSB ERA14FA283](https://openairdocs.org/ntsb/ERA14FA283.md): Cessna 172S · Daytona Beach, FL · Accident · 2 fatal · Field investigation · Final report · Jun 10, 2014 · N5524L · Destroyed
  > A partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…
- [NTSB ERA14LA281](https://openairdocs.org/ntsb/ERA14LA281.md): Belew Marshall D II Steen Skybolt · Chapmansboro, TN · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2014 · N863SB · Destroyed
  > The pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…
- [NTSB WPR14LA233](https://openairdocs.org/ntsb/WPR14LA233.md): North Wing Apache Sport · Polson, MT · Accident · 1 fatal · Limited investigation · Final report · Jun 7, 2014 · N2804P · Destroyed
  > The pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.
- [NTSB WPR14FA234](https://openairdocs.org/ntsb/WPR14FA234.md): Piper J3C · Paso Robles, CA · Accident · 2 fatal · Field investigation · Final report · Jun 7, 2014 · N24918 · Substantial damage
  > The pilot's steep right turn shortly after takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB ERA14LA285](https://openairdocs.org/ntsb/ERA14LA285.md): Piper PA-28-140 · Newport, VT · Accident · No injuries · Limited investigation · Final report · Jun 7, 2014 · N5169T · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.
- [NTSB WPR14LA232](https://openairdocs.org/ntsb/WPR14LA232.md): Cessna 150F · Ronan, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 2014 · N3376B · Substantial damage
  > A loss of engine power for reasons that could not be determined due to insufficient evidence.
- [NTSB CEN14LA279](https://openairdocs.org/ntsb/CEN14LA279.md): Cessna 177A · Sauk Centre, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 2014 · N30537 · 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 failure to retract the flaps after beginning the go-around.
- [NTSB WPR14LA220](https://openairdocs.org/ntsb/WPR14LA220.md): Aero Commander Callair A 9B · Gardiner, MT · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 2014 · N7292V · Substantial damage
  > The pilot’s inadequate preflight planning and his subsequent takeoff with the airplane over its allowable gross weight in high density altitude conditions, which degraded the airplane’s climb performance and led to a subsequent forced landing.
- [NTSB CEN14LA267](https://openairdocs.org/ntsb/CEN14LA267.md): Diamond Aircraft Ind DA20-C1 · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Jun 1, 2014 · N206ND · Substantial damage
  > A loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.
- [NTSB ERA14FA255](https://openairdocs.org/ntsb/ERA14FA255.md): Piper PA-28-140 · Fountain, FL · Accident · 3 fatal · Field investigation · Final report · May 25, 2014 · N43113 · Substantial damage
  > The pilot's decision to depart from a soft runway with a tailwind and toward obstructions, and his failure to follow the manufacturer's recommended procedures for the takeoff. Contributing to the accident were the degradation of airplane and engine…
- [NTSB CEN14LA259](https://openairdocs.org/ntsb/CEN14LA259.md): Sibley Glasair · Midlothian, TX · Accident · Serious injuries · Limited investigation · Final report · May 24, 2014 · N4VX · Destroyed
  > The pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.
- [NTSB WPR14CA197](https://openairdocs.org/ntsb/WPR14CA197.md): Cessna 140 · Vacaville, CA · Accident · Minor injuries · Data collection · Final report · May 21, 2014 · N2256N · Substantial damage
  > The pilot's use of excessive brakes during landing, which resulted in a nose over. Contributing to the accident was a partial loss of engine power during takeoff initial climb, likely due to carburetor ice.
- [NTSB ERA14LA248](https://openairdocs.org/ntsb/ERA14LA248.md): Bell Helicopter Textron Canada 206 L4 · Beverly, MA · Accident · No injuries · Limited investigation · Final report · May 21, 2014 · N55SL · Substantial damage
  > Maintenance personnel’s inadequate inspection of the engine’s outer combustion case, which resulted in the failure of the case due to fatigue cracks that initiated on the inside surface of the case and the subsequent total loss of engine power.
- [NTSB WPR14FA194](https://openairdocs.org/ntsb/WPR14FA194.md): Aero Commander 500 S · Fort Huachuca, AZ · Accident · 1 fatal · Field investigation · Final report · May 17, 2014 · N40TC · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…
- [NTSB ERA14LA222](https://openairdocs.org/ntsb/ERA14LA222.md): Champion 7GCAA · Bardwell, KY · Accident · Minor injuries · Limited investigation · Final report · May 4, 2014 · N9588S · Substantial damage
  > The failure of the pilot to maintain airspeed while maneuvering shortly after takeoff, resulting in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, uncontrolled descent, and impact with the ground.
- [NTSB ANC14CA027](https://openairdocs.org/ntsb/ANC14CA027.md): Taylorcraft BC12 D · Wasilla, AK · Accident · No injuries · Data collection · Final report · May 4, 2014 · N64518 · Substantial damage
  > The pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.
- [NTSB WPR14FA181](https://openairdocs.org/ntsb/WPR14FA181.md): Aero Tek Zuni · Aguila, AZ · Accident · 1 fatal · Field investigation · Final report · May 3, 2014 · N22DA · Substantial damage
  > The pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.
- [NTSB ENG14RA014](https://openairdocs.org/ntsb/ENG14RA014.md): BAE AVRO146RJ - 100 · Perth, Australia, Australia · Incident · No injuries · Foreign investigation · Apr 29, 2014 · VH-NJI · Minor damage
  > On April 29, 2014, a British Aerospace BAE AVRO 146-RJ100, registration VH-NJI, experienced a No. 2 engine (left inboard) fire from the Honeywell LF507-1F turbofan engine during climb from Perth, Australia. The airplane was returned to Perth where an…
- [NTSB ERA14LA208](https://openairdocs.org/ntsb/ERA14LA208.md): Alon A2 · Apex, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2014 · N6364V · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined during postaccident examination and testing.
- [NTSB CEN14LA205](https://openairdocs.org/ntsb/CEN14LA205.md): Quicksilver GT400 · Hillsboro, KS · Accident · 1 fatal · Limited investigation · Final report · Apr 18, 2014 · UNREG · Substantial damage
  > The pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.
- [NTSB ERA14FA464](https://openairdocs.org/ntsb/ERA14FA464.md): Fortuna Dave Sonex · Dunnellon, FL · Accident · 1 fatal · Field investigation · Final report · Apr 5, 2014 · N229P · Substantial damage
  > The in-flight collision with a tree in a heavily wooded area during controlled flight while the pilot was attempting a forced landing for reasons that could not be determined based on the available evidence. Contributing to the delay in locating the wreckage…

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

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

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