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

## Cases, newest first

- [NTSB ERA14LA180](https://openairdocs.org/ntsb/ERA14LA180.md): Helpling Helen C Tango 2 · Ocala, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2014 · N599WT · Destroyed
  > The pilot's failure to maintain airplane control after the left cockpit canopy opened during takeoff for reasons that could not be determined due to fire damage.
- [NTSB DCA14WA086](https://openairdocs.org/ntsb/DCA14WA086.md): Embraer ERJ 190 100 IGW · Kingston, Jamaica · Incident · No injuries · Foreign investigation · Mar 31, 2014 · N267JB · No damage
- [NTSB ERA14LA178](https://openairdocs.org/ntsb/ERA14LA178.md): Bellanca 8KCAB · Bay St Louis, MS · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 2014 · N11FS · Substantial damage
  > A sudden fuel leak, which resulted in a postlanding fire; the origin of the leak could not be determined due to fire damage.
- [NTSB ERA14WA186](https://openairdocs.org/ntsb/ERA14WA186.md): Boeing B75 · Lujan, Argentina · Accident · 1 fatal · Foreign investigation · Mar 29, 2014 · LV-HAF · Substantial damage
  > On March 29, 2014, about 1900 coordinated universal time, a Boeing B75 Stearman, Argentine registration LV-HAF, was substantially damaged when it impacted the ground during the initial climb after takeoff from the Lujan Airport, Lujan, Argentina. The pilot…
- [NTSB ERA14LA167](https://openairdocs.org/ntsb/ERA14LA167.md): Cessna O1 - A · St. Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Mar 23, 2014 · N211PP · Substantial damage
  > The pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank and a subsequent loss of engine power due to fuel starvation.
- [NTSB ERA14LA164](https://openairdocs.org/ntsb/ERA14LA164.md): Farace Thomas Scott Kitfox II · Vicksburg, MS · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 2014 · N438TT · Substantial damage
  > The airplane’s low-level encounter with a downdraft that maximum engine power could not overcome.
- [NTSB WPR14CA136](https://openairdocs.org/ntsb/WPR14CA136.md): Norman Quad City Challenger · Monroe, WA · Accident · No injuries · Data collection · Final report · Mar 13, 2014 · N345MN · Substantial damage
  > The pilot's inadequate construction of the propeller bracket, which resulted in its failure during the initial climb and the propeller subsequently departing the airplane.
- [NTSB ENG14IA011](https://openairdocs.org/ntsb/ENG14IA011.md): Raytheon 400A · Rochester, NY · Incident · No injuries · Incident investigation · Final report · Mar 13, 2014 · N193BJ · Minor damage
  > The probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a herring gull birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural frequency (resonance)…
- [NTSB ERA14LA141](https://openairdocs.org/ntsb/ERA14LA141.md): Piper PA-28-161 · Atlantic City, NJ · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 2014 · N1449H · Substantial damage
  > A partial loss of engine power at takeoff for reasons that could not be determined during a postaccident examination or engine test run.
- [NTSB WPR14FA124](https://openairdocs.org/ntsb/WPR14FA124.md): Piper PA31 · Lanai City, HI · Accident · 3 fatal · Field investigation · Final report · Feb 27, 2014 · N483VA · Substantial damage
  > The pilot’s spatial disorientation while turning during flight in dark night conditions and terrain-induced turbulence, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment from a sedating antihistamine.
- [NTSB WPR14WA128](https://openairdocs.org/ntsb/WPR14WA128.md): Hughes 369D · Moonlight Creek, New Zealand, New Zealand · Accident · No injuries · Foreign investigation · Feb 25, 2014 · ZK-IQQ · Substantial damage
  > On February 25, 2014, at 2055 universal coordinated time, a Hughes 369D, ZK-IQQ, was substantially damaged when the main rotor blades contacted and severed the tailboom at the conclusion of an autorotation and landing near Moonlight Creek, New Zealand. The…
- [NTSB WPR14LA118](https://openairdocs.org/ntsb/WPR14LA118.md): Cessna P210N · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Feb 23, 2014 · N18DP · Substantial damage
  > Fuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.
- [NTSB WPR14LA117](https://openairdocs.org/ntsb/WPR14LA117.md): Beech A45 · Hollister, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2014 · N666 · Substantial damage
  > The total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.
- [NTSB ERA14WA135](https://openairdocs.org/ntsb/ERA14WA135.md): Cessna T210L · Araguaina, Brazil · Accident · 1 fatal · Foreign investigation · Feb 19, 2014 · PR-VPI · Substantial damage
  > On February 19, 2014, about 1920 universal coordinated time, a Cessna T210L, Brazilian registration PR-VPI, operated by Talla Taxi Aereo Ltda., was substantially damaged during a forced landing, after it experienced a loss of engine power during takeoff from…
- [NTSB CEN14FA143](https://openairdocs.org/ntsb/CEN14FA143.md): Hawker SEA Fury ISS 25 · Breckenridge, TX · Accident · 1 fatal · Field investigation · Final report · Feb 18, 2014 · N13HP · Destroyed
  > The pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.
- [NTSB ERA14FA123](https://openairdocs.org/ntsb/ERA14FA123.md): Williams Christopher T Sonex · Wellington, FL · Accident · 1 fatal · Field investigation · Final report · Feb 17, 2014 · N732SX · Destroyed
  > The pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the…
- [NTSB CEN14LA144](https://openairdocs.org/ntsb/CEN14LA144.md): Cessna 150 - G · Galion, OH · Accident · No injuries · Limited investigation · Final report · Feb 13, 2014 · N3882J · Substantial damage
  > A total loss of engine power on climbout 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 WPR14FA111](https://openairdocs.org/ntsb/WPR14FA111.md): Piper PA 28-181 · Phoenix, AZ · Accident · Serious injuries · Field investigation · Final report · Feb 4, 2014 · N312PA · Substantial damage
  > The student pilot’s inadvertent positioning of the fuel selector in an intermediate position, which resulted in a loss of engine power due to fuel starvation.
- [NTSB CEN14TA126](https://openairdocs.org/ntsb/CEN14TA126.md): Diamond Aircraft Ind DA20-C1 · Fort Carson, CO · Accident · Minor injuries · Final report · Jan 29, 2014 · N959DA · Substantial damage
  > The flight instructor's loss of control after takeoff following a wake turbulence encounter from a preceding helicopter. Contributing to the accident were the flight instructor's misidentification of the helicopter type and a lack of Federal Aviation…
- [NTSB ERA14TA096](https://openairdocs.org/ntsb/ERA14TA096.md): Eurocopter AS350B3 · Houlton, ME · Accident · No injuries · Final report · Jan 18, 2014 · N578AE · Substantial damage
  > An engine compartment explosion during takeoff; the origin of the explosion could not be determined during postaccident examination due to extensive fire damage.
- [NTSB ERA14WA116](https://openairdocs.org/ntsb/ERA14WA116.md): Helio HT-295 · Macas, Ecuador · Accident · Serious injuries · Foreign investigation · Jan 15, 2014 · HC-BTC · Substantial damage
  > On January 15, 2014, about 2030 coordinated universal time (1530 local time), a Helio Courier HT-295, Ecuadorian registration HC-BTC, was substantially damaged during a forced landing after takeoff from Edmundo Carvajal Airport (SEMC), Macas, Ecuador. The…
- [NTSB WPR14LA071](https://openairdocs.org/ntsb/WPR14LA071.md): Piper PA 32-301 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Dec 18, 2013 · N8169C · Substantial damage
  > The total loss of engine power during takeoff due to fuel starvation, which resulted from the pilot’s failure to adequately manage the fuel supply.
- [NTSB CEN14CA088](https://openairdocs.org/ntsb/CEN14CA088.md): Piper PA 28R-200 · Bowling Green, OH · Accident · No injuries · Data collection · Final report · Dec 13, 2013 · N66CS · Substantial damage
  > A bird strike during takeoff.
- [NTSB WPR14CA066](https://openairdocs.org/ntsb/WPR14CA066.md): Mcdonnell Douglas Helicopter 369E · Monticello, UT · Accident · No injuries · Data collection · Final report · Dec 6, 2013 · N2066W · Substantial damage
  > The passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.
- [NTSB CEN14LA079](https://openairdocs.org/ntsb/CEN14LA079.md): Thompson William A Sparrow II · Jeromesville, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 4, 2013 · N5955Y · Substantial damage
  > The student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.
- [NTSB CEN14FA071](https://openairdocs.org/ntsb/CEN14FA071.md): Cessna 182E · Delta, CO · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2013 · N3087Y · Destroyed
  > The student pilot’s decision to attempt flight into instrument meteorological conditions, which resulted in a loss of control and ground impact.
- [NTSB ENG14RA004](https://openairdocs.org/ntsb/ENG14RA004.md): Saab Saab 2000 · Lugano, Switzerland · Incident · No injuries · Foreign investigation · Nov 28, 2013 · HB-IZW
  > On November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…
- [NTSB ERA14FA049](https://openairdocs.org/ntsb/ERA14FA049.md): Piper PA-23-160 · Graniteville, SC · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2013 · N4016P · Substantial damage
  > The pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…
- [NTSB ERA14FA045](https://openairdocs.org/ntsb/ERA14FA045.md): Learjet 35 · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Nov 20, 2013 · XA-USD · Destroyed
  > The pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…
- [NTSB CEN14FA057](https://openairdocs.org/ntsb/CEN14FA057.md): Cessna 152 · Spring, TX · Accident · 2 fatal · Field investigation · Final report · Nov 18, 2013 · N555UF · Substantial damage
  > The flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.
- [NTSB ERA14LA043](https://openairdocs.org/ntsb/ERA14LA043.md): Maule M-5-180C · Marshfield, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2013 · N76RD · Destroyed
  > A partial loss of engine power for reasons that could not be determined in postaccident examinations because fire damage precluded testing of the fuel and several engine accessories.
- [NTSB CEN14LA054](https://openairdocs.org/ntsb/CEN14LA054.md): Quicksilver Mxii Sport · Erie, CO · Accident · No injuries · Limited investigation · Final report · Nov 14, 2013 · N2910P · Substantial damage
  > A loss of engine power due to a crankshaft failure, which resulted in a forced landing.
- [NTSB ERA14WA041](https://openairdocs.org/ntsb/ERA14WA041.md): Cirrus Design SR22 · Freeport, Bahamas · Accident · 4 fatal · Foreign investigation · Nov 10, 2013 · N432BC · Destroyed
- [NTSB ERA14LA011](https://openairdocs.org/ntsb/ERA14LA011.md): Boeing B75N1 · Tampa, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 19, 2013 · N65355 · No damage
  > The parachutist’s low altitude departure from the right wing before the planned altitude and his delayed opening of his parachute canopy, which resulted in impact with a tree and then the ground before the parachute fully opened.
- [NTSB WPR14CA019](https://openairdocs.org/ntsb/WPR14CA019.md): Robinson R44 - II · Sedro Woolley, WA · Accident · No injuries · Data collection · Final report · Oct 18, 2013 · N414CC · Substantial damage
  > The non-instrument rated pilot's inadvertent encounter with instrument meteorological conditions during initial climb and his improper decision to continue flight, which resulted in an in-flight impact with a tree and an emergency descent that resulted in a…
- [NTSB ANC14FA002](https://openairdocs.org/ntsb/ANC14FA002.md): Cessna 172C · Fairbanks, AK · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2013 · N1512Y · Substantial damage
  > The pilot’s failure to ensure that adequate fuel was on board the airplane, which resulted in fuel exhaustion and a subsequent collision with terrain.
- [NTSB WPR14CA009](https://openairdocs.org/ntsb/WPR14CA009.md): Beech A36 · Tilden, TX · Accident · Serious injuries · Data collection · Final report · Oct 6, 2013 · N2051N · Substantial damage
  > The pilot's decision to continue the takeoff from a wet and soft airstrip which resulted in his failure to maintain adequate airspeed and aircraft control during the takeoff initial climb.
- [NTSB WPR14WA098](https://openairdocs.org/ntsb/WPR14WA098.md): Amateur Built KR-2 · Tumut, New South Wales, Australia · Accident · 1 fatal · Foreign investigation · Oct 5, 2013 · VH-CTE · Destroyed
  > On October 5, 2013, at 0900 local time, an amateur built aircraft, KR-2, VH-CTE, collided with the terrain shortly after takeoff from a private airstrip near Tumut, New South Wales. The flight was operated by the pilot under the pertinent civil regulations of…
- [NTSB ERA14LA035](https://openairdocs.org/ntsb/ERA14LA035.md): Airborne Edge Executive · Eustis, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2013 · N927H · Substantial damage
  > The pilot's inadvertent stalling of the wing following a total loss of engine power for reasons that could not be determined during postaccident examinations, which resulted in a hard landing.
- [NTSB DCA14WA177](https://openairdocs.org/ntsb/DCA14WA177.md): Embraer EMB120 · Lagos, Nigeria · Accident · No injuries · Foreign investigation · Oct 3, 2013 · 5N-BJY · Destroyed
  > The Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving an Embraer120 airplane that occurred on October 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…
- [NTSB ERA13WA430](https://openairdocs.org/ntsb/ERA13WA430.md): Cessna R172K · Morona Santiago, Ecuador · Accident · 3 fatal · Foreign investigation · Sep 21, 2013 · HC-BGT · Destroyed
- [NTSB ERA13CA417](https://openairdocs.org/ntsb/ERA13CA417.md): Miller/Culpepper Christen Eagle II · Blythe, GA · Accident · Serious injuries · Data collection · Final report · Sep 14, 2013 · N887AS · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.
- [NTSB WPR13LA402](https://openairdocs.org/ntsb/WPR13LA402.md): Cessna 172N · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 2013 · N42EP · Substantial damage
  > The total loss of engine power during initial climb due to debris within the carburetor mixture metering sleeve.
- [NTSB CEN13CA543](https://openairdocs.org/ntsb/CEN13CA543.md): Taylorcraft BL 65 · Chippewa Falls, WI · Accident · Serious injuries · Data collection · Final report · Sep 8, 2013 · N23683 · Substantial damage
  > The loss of engine power after takeoff due to carburetor icing.
- [NTSB ERA13LA406](https://openairdocs.org/ntsb/ERA13LA406.md): Engineering & Research 415-D · Beaver Falls, PA · Accident · No injuries · Limited investigation · Final report · Sep 6, 2013 · N3940H · Substantial damage
  > The owner/pilot’s failure to follow engine manufacturer recommendations for engine oil changes and spark plug cleaning and rotating when operating the airplane with 100 low lead fuel, which resulted in carbon buildup in the engine and the total loss of engine…
- [NTSB CEN13LA539](https://openairdocs.org/ntsb/CEN13LA539.md): Cessna T207 · Colorado Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2013 · N211AS · Substantial damage
  > The pilot’s failure to establish the proper pitch attitude and airspeed during takeoff with the engine at maximum power, which resulted in the exceedance of the airplane’s climb performance capability.
- [NTSB ERA13LA397](https://openairdocs.org/ntsb/ERA13LA397.md): Aeronca 65CA · Hardwick, VT · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2013 · N31915 · Substantial damage
  > The improper maintenance of the carburetor, which resulted in a total loss of engine power due to carburetor flooding.
- [NTSB ERA13CA400](https://openairdocs.org/ntsb/ERA13CA400.md): Maxair Drifter Drifter II · Lafayette, TN · Accident · Minor injuries · Data collection · Final report · Sep 1, 2013 · N42548 · Substantial damage
  > The pilot's failure to maintain aircraft control during the initial climb after takeoff in gusty wind conditions, which resulted in a hard off-airport landing.
- [NTSB CEN13CA521](https://openairdocs.org/ntsb/CEN13CA521.md): Evektor-Aerotechnik Sportstar · Osage Beach, MO · Accident · No injuries · Data collection · Final report · Sep 1, 2013 · N407EV · Substantial damage
  > The pilot’s failure to maintain aircraft control during initial climb in gusty wind conditions.
- [NTSB ERA13LA382](https://openairdocs.org/ntsb/ERA13LA382.md): Consolidated Aeronautics Lake Model 250 · Middle Grove, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 2013 · N522WB · Substantial damage
  > Maintenance personnel’s application of insufficient torque to the No. 6 cylinder connecting rod bolts during overhaul, which resulted in the fatigue fracture of the connecting rod and a subsequent total loss of engine power.

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

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

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