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

## Cases, newest first

- [NTSB WPR12CA284](https://openairdocs.org/ntsb/WPR12CA284.md): Cessna 210-5 · West Glacier, MT · Accident · Minor injuries · Data collection · Final report · Jul 2, 2012 · N8450Z · Substantial damage
  > The pilot elected to abort the takeoff without sufficient runway available to land and stop the airplane. Contributing to the accident was the illusion created by the rising terrain, which influenced the pilot's decision to abort the takeoff.
- [NTSB ERA12CA443](https://openairdocs.org/ntsb/ERA12CA443.md): Evektor-Aerotechnik Sportstar Plus · Lancaster, PA · Accident · No injuries · Data collection · Final report · Jul 2, 2012 · N182EV · Substantial damage
  > The pilot's attempt to secure an open canopy during takeoff, which resulted in a loss of control and subsequent hard landing.
- [NTSB WPR12LA281](https://openairdocs.org/ntsb/WPR12LA281.md): Tecnam P2002 Sierra · Watsonville, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 2012 · N308TA · Substantial damage
  > A partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.
- [NTSB ERA12FA423](https://openairdocs.org/ntsb/ERA12FA423.md): Piper PA-31P · Dalton, GA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 2012 · N33CG · Substantial damage
  > The pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…
- [NTSB ERA12LA425](https://openairdocs.org/ntsb/ERA12LA425.md): Piper PA-28-140 · Lakewood, NJ · Accident · No injuries · Limited investigation · Final report · Jun 29, 2012 · N449FL · Substantial damage
  > The loss of engine power during climb for reasons that could not be determined during postaccident examination of the engine and engine systems or during postaccident operational testing of the engine.
- [NTSB CEN12LA407](https://openairdocs.org/ntsb/CEN12LA407.md): Fields Mike Hawk SSC · Evansville, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2012 · N163F · Substantial damage
  > The operation of an airplane by a non-certificated pilot, and the pilot's loss of control during takeoff, which resulted in an inadvertent stall and spin.
- [NTSB WPR12FA280](https://openairdocs.org/ntsb/WPR12FA280.md): Aviat A-1C-180 · Kooskia, ID · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2012 · N63WY · Substantial damage
  > The pilot's decision to attempt a takeoff with a gusty tailwind, which resulted in his loss of airplane control during the initial climb and an aerodynamic stall/spin.
- [NTSB WPR12LA277](https://openairdocs.org/ntsb/WPR12LA277.md): Rehn Kitfox IV · Vancouver, WA · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 2012 · N645GR · Substantial damage
  > The pilot's failure to maintain airspeed during an attempt to return to the runway immediately after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was foreign debris in the right-hand carburetor bowl, which precipitated a loss…
- [NTSB ERA12FA412](https://openairdocs.org/ntsb/ERA12FA412.md): Socata TB21 · Gold Hill, NC · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2012 · N2528N · Substantial damage
  > An inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.
- [NTSB CEN12LA404](https://openairdocs.org/ntsb/CEN12LA404.md): Destiny 2000 · Shelbyville, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 2012 · UNREG · Substantial damage
  > The operation of the aircraft by a non-certificated pilot and his failure to plan for the high density altitude and to maintain control of the aircraft.
- [NTSB WPR12FA274](https://openairdocs.org/ntsb/WPR12FA274.md): Cessna 172 · Veneta, OR · Accident · 4 fatal · Field investigation · Final report · Jun 23, 2012 · N5781A · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.
- [NTSB DCA12IA096](https://openairdocs.org/ntsb/DCA12IA096.md): Airbus A320 · Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Jun 17, 2012 · N552JB · No damage
  > the failure of the right main landing gear door retraction flexible hydraulic line in the Green hydraulic system, which led to prolonged operation of the power transfer unit and subsequent overheating and loss of pressure in the Yellow hydraulic system,…
- [NTSB ERA12LA397](https://openairdocs.org/ntsb/ERA12LA397.md): Cessna 170 · Biddeford, ME · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 2012 · N3812V · Substantial damage
  > A total loss of engine power due to water contamination of the fuel. Contributing to the accident was the pilot/owner’s inadequate preflight inspection.
- [NTSB CEN12CA370](https://openairdocs.org/ntsb/CEN12CA370.md): Evektor-Aerotechnik Sportstar Plus · Erie, CO · Accident · Minor injuries · Data collection · Final report · Jun 14, 2012 · N617EV · Substantial damage
  > The student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.
- [NTSB CEN12LA368](https://openairdocs.org/ntsb/CEN12LA368.md): Mooney M20F · Hooker, OK · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 2012 · N6455Q · Substantial damage
  > The pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…
- [NTSB CEN12LA359](https://openairdocs.org/ntsb/CEN12LA359.md): Robinson Helicopter R44 II · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Jun 10, 2012 · N744JS · Substantial damage
  > The sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…
- [NTSB WPR12CA254](https://openairdocs.org/ntsb/WPR12CA254.md): Cessna 162 · Santa Ana, CA · Accident · No injuries · Data collection · Final report · Jun 9, 2012 · N5211Y · Substantial damage
  > The pilot’s failure to compensate for the gusting wind and failure to maintain airplane control during the approach to land.
- [NTSB CEN12LA348](https://openairdocs.org/ntsb/CEN12LA348.md): Piper PA-22-135 · Bangor, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 2012 · N3431A · Substantial damage
  > The pilot’s failure to properly service the fuel system, and subsequent decision to conduct the flight with known fuel system deficiencies, which led to the total loss of engine power.
- [NTSB WPR12LA241](https://openairdocs.org/ntsb/WPR12LA241.md): Westcott Prowler Jaguar · Salinas, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 1, 2012 · N125CW · Destroyed
  > The pilot's inability to maintain airplane control during takeoff due to an incapacitating cardiac event.
- [NTSB WPR12LA264](https://openairdocs.org/ntsb/WPR12LA264.md): Luscombe 8 · Twentynine Palms, CA · Accident · No injuries · Limited investigation · Final report · May 29, 2012 · N2435K · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12LA246](https://openairdocs.org/ntsb/WPR12LA246.md): Beech B36TC · Santa Ynez, CA · Accident · No injuries · Limited investigation · Final report · May 27, 2012 · N8234M · Substantial damage
  > A loss of engine power during initial climb due to fuel starvation. Contributing to the accident were the pilot’s inadequate preflight inspection, his failure to properly diagnose the loss of engine power, and his failure to follow the appropriate emergency…
- [NTSB WPR12FA230](https://openairdocs.org/ntsb/WPR12FA230.md): Cessna 172S · St. George, UT · Accident · 4 fatal · Field investigation · Final report · May 26, 2012 · N953SP · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…
- [NTSB CEN12LA357](https://openairdocs.org/ntsb/CEN12LA357.md): Rockwell International S-2R · Howard, SD · Accident · No injuries · Limited investigation · Final report · May 23, 2012 · N8421V · Substantial damage
  > A fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.
- [NTSB ERA12CA371](https://openairdocs.org/ntsb/ERA12CA371.md): Aero Works Aero Lite 103 · Lincolnton, NC · Accident · No injuries · Data collection · Final report · May 21, 2012 · N2355L · Substantial damage
  > The loss of engine power due to fuel flow interruption, which resulted from a stuck carburetor bowl needle.
- [NTSB CEN12LA308](https://openairdocs.org/ntsb/CEN12LA308.md): Piper PA-28-180 · Frankenmuth, MI · Accident · Minor injuries · Limited investigation · Final report · May 20, 2012 · N4595T · Substantial damage
  > A partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.
- [NTSB WPR12LA217](https://openairdocs.org/ntsb/WPR12LA217.md): Jackson TOP DOG · Apple Valley, CA · Accident · Serious injuries · Limited investigation · Final report · May 19, 2012 · N214AB · Substantial damage
  > A loss of engine power during the initial climb for reasons that could not be determined because the anomalies revealed during the postaccident examination would not have necessarily precluded normal operation. Contributing to the accident was the inadequate…
- [NTSB ERA12LA346](https://openairdocs.org/ntsb/ERA12LA346.md): Robinson Helicopter R44 · Destin, FL · Accident · No injuries · Limited investigation · Final report · May 19, 2012 · N444WT · Substantial damage
  > The partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.
- [NTSB DCA12WA085](https://openairdocs.org/ntsb/DCA12WA085.md): Boeing 737 · Riga, Latvia · Incident · No injuries · Foreign investigation · May 19, 2012 · YL-BBN · No damage
  > On May 19, 2012, at approximately 0819 locat time, a Boeing 737-500 operated by AirBaltic was climbing after departure from Riga International Airport, and was cleared by ATC to climb to FL230. At the same time, an Airbus 320, operated by Aeroflot perfromed a…
- [NTSB CEN12LA309](https://openairdocs.org/ntsb/CEN12LA309.md): Quicksilver Sprint II · Lebanon, IL · Accident · Minor injuries · Limited investigation · Final report · May 19, 2012 · N3521A · Substantial damage
  > The total loss of engine power due to a fatigue failure of the crankshaft, attributed to the relative movement between the crankshaft and flywheel assembly.
- [NTSB CEN12LA307](https://openairdocs.org/ntsb/CEN12LA307.md): Dial David L Titan Tornado II · Checotah, OK · Accident · 1 fatal · Limited investigation · Final report · May 19, 2012 · N158TX · Substantial damage
  > The noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.
- [NTSB ERA12CA341](https://openairdocs.org/ntsb/ERA12CA341.md): Czech Sport Aircraft A S Sportcruiser · Shirley, NY · Accident · Minor injuries · Data collection · Final report · May 17, 2012 · N297SC · Substantial damage
  > The pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.
- [NTSB WPR12LA212](https://openairdocs.org/ntsb/WPR12LA212.md): Schweizer 269C-1 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · May 13, 2012 · N61482 · Substantial damage
  > The flight instructor's improper decision to take off from a hover with low rotor rpm.
- [NTSB ANC12CA047](https://openairdocs.org/ntsb/ANC12CA047.md): Maule M-4-220C · Sterling, AK · Accident · No injuries · Data collection · Final report · May 13, 2012 · N615SD · Substantial damage
  > The pilot's failure to use a preflight checklist and subsequent failure to turn on the airplane's fuel supply, which resulted in a loss of engine power due to fuel starvation.
- [NTSB WPR12LA201](https://openairdocs.org/ntsb/WPR12LA201.md): Beech 3NM · Pope Valley, CA · Accident · Minor injuries · Limited investigation · Final report · May 12, 2012 · N9540 · Substantial damage
  > A loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.
- [NTSB ERA12FA327](https://openairdocs.org/ntsb/ERA12FA327.md): Mooney M20J · Sterling, PA · Accident · 2 fatal · Field investigation · Final report · May 10, 2012 · N9154K · Substantial damage
  > The pilot’s decision to take off on an uphill slope without utilizing the entire available runway, and his failure to abort the takeoff when he realized he wasn’t going to liftoff in time to clear the trees at the end of the runway.
- [NTSB ERA12FA326](https://openairdocs.org/ntsb/ERA12FA326.md): Gutierrez Pablino Hummel Bird · DeFuniak Springs, FL · Accident · 1 fatal · Field investigation · Final report · May 9, 2012 · N9001N · Substantial damage
  > The pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…
- [NTSB ERA12LA340](https://openairdocs.org/ntsb/ERA12LA340.md): Piper PA-28R-201T · Williston, FL · Accident · No injuries · Limited investigation · Final report · May 5, 2012 · N442G · Substantial damage
  > Loss of engine power for reasons that could not be determined during postaccident examination and testing, which included a successful postaccident engine run.
- [NTSB ERA12FA319](https://openairdocs.org/ntsb/ERA12FA319.md): Cessna 177B · Honesdale, PA · Accident · 1 fatal · Field investigation · Final report · May 5, 2012 · N34539 · Substantial damage
  > The pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…
- [NTSB ERA12LA312](https://openairdocs.org/ntsb/ERA12LA312.md): Shoup Ronald R RV-6A · Milton, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 2012 · N819RS · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ANC12CA034](https://openairdocs.org/ntsb/ANC12CA034.md): Piper PA-18-150 · Palmer, AK · Accident · Minor injuries · Data collection · Final report · Apr 30, 2012 · N8976D · Substantial damage
  > The student pilot did not maintain sufficient airspeed during a steep turn after takeoff, which resulted in an aerodynamic stall.
- [NTSB CEN12WA268](https://openairdocs.org/ntsb/CEN12WA268.md): Robinson · Wuppertal-Langerfeld, Germany · Accident · Minor injuries · Foreign investigation · Apr 28, 2012 · D-HARV · Substantial damage
  > On April 28, 2012, at 1650 coordinated universal time, a Robinson R44 helicopter, D-HARV, impacted terrain near Wuppertal-Langerfeld, Germany. The pilot and 3 passengers sustained minor injuries. Visual meteorological conditions prevailed for the flight. The…
- [NTSB WPR12LA185](https://openairdocs.org/ntsb/WPR12LA185.md): Bellanca 17-30A · Cloverdale, CA · Accident · No injuries · Limited investigation · Final report · Apr 27, 2012 · N80SV · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power during climb due to fuel starvation.
- [NTSB OPS12IA535](https://openairdocs.org/ntsb/OPS12IA535.md): Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Apr 27, 2012 · No damage
  > Federal Aviation Administration procedures that do not ensure separation in the event of a go-around during simultaneous independent runway operations on runways that do not physically intersect but whose flight paths intersect.
- [NTSB ERA12LA305](https://openairdocs.org/ntsb/ERA12LA305.md): Aviat A-1B · Sylacauga, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 2012 · N388AS · Substantial damage
  > The pilot's attempt to take off with the carburetor heat in the hot position, which limited the airplane’s performance, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.
- [NTSB CEN12LA261](https://openairdocs.org/ntsb/CEN12LA261.md): Beech A36 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Apr 26, 2012 · N4830M · Substantial damage
  > The partial loss of engine power due to an intake valve that was stuck in the open position.
- [NTSB WPR12LA181](https://openairdocs.org/ntsb/WPR12LA181.md): Cub Crafters CC11-100 · Monmouth, OR · Accident · No injuries · Limited investigation · Final report · Apr 22, 2012 · N499CC · Substantial damage
  > A partial loss of engine power during takeoff for undetermined reasons.
- [NTSB CEN12LA253](https://openairdocs.org/ntsb/CEN12LA253.md): Bumford-Royer Christen Eagle II · Pearland, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 2012 · N80BH · Substantial damage
  > A loose B nut on the fuel inlet line due to maintenance personnel’s application of insufficient torque on the nut at an unknown time, which resulted in a fuel leak and a subsequent total loss of engine power during initial climb.
- [NTSB ANC12LA031](https://openairdocs.org/ntsb/ANC12LA031.md): Cessna 150F · Fairbanks, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 2012 · N7911F · Substantial damage
  > The student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.
- [NTSB WPR12CA166](https://openairdocs.org/ntsb/WPR12CA166.md): Mooney M20B · Rosamond, CA · Accident · Minor injuries · Data collection · Final report · Apr 15, 2012 · N74518 · Substantial damage
  > A loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.
- [NTSB ERA12LA285](https://openairdocs.org/ntsb/ERA12LA285.md): Willoughby Pete A Streak Shadow · Salem, WV · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 2012 · N2828W · Substantial damage
  > A total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of…

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

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

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