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

## Cases, newest first

- [NTSB CHI03LA020](https://openairdocs.org/ntsb/CHI03LA020.md): Cessna 182N · Wheatfield, IN · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2002 · N253R · Substantial damage
  > The pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.
- [NTSB ANC03LA014](https://openairdocs.org/ntsb/ANC03LA014.md): Cessna 172 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2002 · N80948 · Substantial damage
  > The pilot's failure to adequately remove frost/ice from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb.
- [NTSB ANC03LA009](https://openairdocs.org/ntsb/ANC03LA009.md): Arima Kolb Fire Star II · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Nov 1, 2002 · N8199 · Substantial damage
  > The pilot's inadequate preflight inspection which failed to remove contaminated fuel from the airplane's fuel system, resulting in a loss of engine power during takeoff.
- [NTSB FTW03LA040](https://openairdocs.org/ntsb/FTW03LA040.md): Cessna 172N · Porter, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 2002 · N1317E · Substantial damage
  > The loss of engine power for an undetermined reason.
- [NTSB FTW03FA024](https://openairdocs.org/ntsb/FTW03FA024.md): Piper PA-31T · Hobbs, NM · Accident · 1 fatal · Field investigation · Final report · Oct 30, 2002 · N3998Y · Destroyed
  > The pilot's loss of control while in instrument meteorological conditions during initial takeoff climb. Contributing factors were the prevailing clouds and fog.
- [NTSB LAX03LA016](https://openairdocs.org/ntsb/LAX03LA016.md): Hubbard StddHmltn GlasairIIS · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 2002 · N98TR · Substantial damage
  > Fuel starvation for undetermined reasons.
- [NTSB CHI03LA016](https://openairdocs.org/ntsb/CHI03LA016.md): LaFerriere Vans RV-4 · Lake Geneva, WI · Accident · No injuries · Limited investigation · Final report · Oct 27, 2002 · N994RV · Substantial damage
  > The loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.
- [NTSB MIA03FA005](https://openairdocs.org/ntsb/MIA03FA005.md): Cessna 310 · Merritt Island, FL · Accident · 1 fatal · Field investigation · Final report · Oct 22, 2002 · N5247A · Substantial damage
  > The pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.
- [NTSB IAD03LA008](https://openairdocs.org/ntsb/IAD03LA008.md): Piper PA-30 · Middlesboro, KY · Accident · Serious injuries · Limited investigation · Final report · Oct 22, 2002 · N8770Y · Substantial damage
  > The pilot's operation of the airplane with a known deficiency. Factors related to the accident were the loss of engine power of the left engine due to a failure of the left engine-driven and electric fuel pumps, and inadequate maintenance.
- [NTSB LAX03FA013](https://openairdocs.org/ntsb/LAX03FA013.md): Piper Aerostar 601 · Agua Dulce, CA · Accident · 3 fatal · Field investigation · Final report · Oct 20, 2002 · N700US · Destroyed
  > the pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush. The pilot's selection of the wrong runway for departure, considering the uphill gradient, the wind direction, and a takeoff path into rising terrain are…
- [NTSB LAX03LA012](https://openairdocs.org/ntsb/LAX03LA012.md): Piper PA-28-235 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Oct 19, 2002 · N9483W · Substantial damage
  > fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.
- [NTSB IAD03IA007](https://openairdocs.org/ntsb/IAD03IA007.md): Boeing 767-222 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Oct 19, 2002 · N607UA · Minor damage
  > An inadvertant collision with birds during the initial climb out.
- [NTSB DEN03LA010](https://openairdocs.org/ntsb/DEN03LA010.md): Hildebrandt Rutan/Defiant · Watkins, CO · Accident · No injuries · Limited investigation · Final report · Oct 19, 2002 · N219DF · Substantial damage
  > the pilot's failure to use the checklist, resulting in his forgetting to lower the nose landing gear. Contributing factors included the pilot's attention being diverted by the loss of oil pressure on the rear engine due to a broken oil pressure sensor line,…
- [NTSB NYC03FA008](https://openairdocs.org/ntsb/NYC03FA008.md): Pilatus PC-12/45 · Trenton, NJ · Accident · Minor injuries · Field investigation · Final report · Oct 16, 2002 · N96WF · Substantial damage
  > A power loss, due to failure of the No. 1 bearing, which was a result of previous electrical discharge damage (EDD). Factors were the low ceiling and a wet runway.
- [NTSB ATL03LA003](https://openairdocs.org/ntsb/ATL03LA003.md): Cessna 172N · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 13, 2002 · N6542J · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB IAD03TA003](https://openairdocs.org/ntsb/IAD03TA003.md): Beech A200 · Cleveland, OH · Accident · Minor injuries · Final report · Oct 9, 2002 · N200NG · Substantial damage
  > Inadequate operating clearance between the ring gear and pinion gear during the manufacturing process resulting in the failure of the landing gear actuator gear ring.
- [NTSB DEN03LA004](https://openairdocs.org/ntsb/DEN03LA004.md): Beech C24R · Newcastle, UT · Accident · No injuries · Limited investigation · Final report · Oct 9, 2002 · N18917 · Substantial damage
  > the pilot's failure to maintain clearance from the tree during takeoff. A factor was the reduced light conditions.
- [NTSB IAD03LA002](https://openairdocs.org/ntsb/IAD03LA002.md): Taylorcraft 15A · Somerset, PA · Accident · No injuries · Limited investigation · Final report · Oct 7, 2002 · N6652N · Substantial damage
  > The mechanic's failure to discover several mechanical deficiencies during a pre-buy inspection, which either independently or collectively resulted in a subsequent engine failure. A factor was the power lines in the forced landing area.
- [NTSB FTW03LA006](https://openairdocs.org/ntsb/FTW03LA006.md): SIAI-Marchetti L1019 · Midland, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2002 · N2069W · Substantial damage
  > The loss of engine power resulting from a loose "B" nut on the line going from the bleed air filter to the fuel control unit. Also causal was the inadequate maintenence of the fuel control unit and filters during the last conditional inspection.
- [NTSB LAX03LA009](https://openairdocs.org/ntsb/LAX03LA009.md): Quicksilver Challenger II · Porterville, CA · Accident · No injuries · Limited investigation · Final report · Oct 5, 2002 · UNREG · Substantial damage
  > The loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.
- [NTSB LAX03GA001](https://openairdocs.org/ntsb/LAX03GA001.md): McDonnell Douglas 600N · Rialto, CA · Accident · Serious injuries · Final report · Oct 4, 2002 · N625SB · Substantial damage
  > an engine deceleration event due to a loose HMU fuel line fitting, which was a result of inadequate maintenance procedures in the 100/300-hour inspection. Also causal was the flying pilot's and pilot-in-command's delayed recognition of the power loss, as well…
- [NTSB NYC03FA001](https://openairdocs.org/ntsb/NYC03FA001.md): Beagle B.206 Basset · West Carrollton, OH · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2002 · N72KB · Destroyed
  > The pilots inadequate preflight inspection, his operation of the airplane with an overdue annual inspection, and his failure to maintain airspeed after the failure of an engine which resulted in an inadvertent stall/spin. A factor related to the accident was…
- [NTSB CHI03LA002](https://openairdocs.org/ntsb/CHI03LA002.md): Tanner Kitfox · Coldwater, MI · Accident · No injuries · Limited investigation · Final report · Oct 2, 2002 · N633KF · Substantial damage
  > The low altitude at which an undetermined loss of engine power occurred following takeoff.
- [NTSB NYC02FA200](https://openairdocs.org/ntsb/NYC02FA200.md): Mooney M20E · West Creek, NJ · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2002 · N5556Q · Destroyed
  > The pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.
- [NTSB MIA02LA175](https://openairdocs.org/ntsb/MIA02LA175.md): Piper PA-28R-200 · Irvington, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 2002 · N2963R · Substantial damage
  > The loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…
- [NTSB LAX02LA297](https://openairdocs.org/ntsb/LAX02LA297.md): Paige Kolb MK III · Fresno, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 2002 · N6124U · Substantial damage
  > the student pilot's excessive rotation and failure to obtain/maintain adequate airspeed during takeoff, resulting in a stall.
- [NTSB FTW02LA265](https://openairdocs.org/ntsb/FTW02LA265.md): Cessna 320 · Gatesville, TX · Accident · No injuries · Limited investigation · Final report · Sep 26, 2002 · N382MR · Substantial damage
  > The loss of engine power to the left engine for undetermined reasons. A contributing factor was the rough and uneven terrain.
- [NTSB CHI02FA292](https://openairdocs.org/ntsb/CHI02FA292.md): Piper PA-24-260 · Ankeny, IA · Accident · 1 fatal · Field investigation · Final report · Sep 24, 2002 · N8782P · Destroyed
  > The pilot applied an excessive angle of bank and failed to maintain terrain clearance. An additonal factor was the pilot's attention being diverted.
- [NTSB FTW02LA261](https://openairdocs.org/ntsb/FTW02LA261.md): Beech V35 · Del Rio, TX · Accident · No injuries · Limited investigation · Final report · Sep 21, 2002 · N9486S · Substantial damage
  > The loss of engine power due to the low-pressure pump separating internally. Contributing factors were the deterioration of the fuel pump and the lack of suitable terrain for the forced landing.
- [NTSB ANC02LA123](https://openairdocs.org/ntsb/ANC02LA123.md): de Havilland DHC-2 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Sep 20, 2002 · N144Q · Substantial damage
  > The instructor pilot's inadequate preflight by his failure to remove all frost from the wings prior to takeoff, which resulted in an inadvertent stall and in-flight collision with terrain.
- [NTSB NYC02LA188](https://openairdocs.org/ntsb/NYC02LA188.md): Mooney M20J · Canadaigua, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 2002 · N201ZC · Substantial damage
  > The pilot's inadequate preflight inspection of the airplane, which resulted in a loss of engine power due to fuel contamination.
- [NTSB MIA02LA169](https://openairdocs.org/ntsb/MIA02LA169.md): Charles Maxted RV6 · Bay Minette, AL · Accident · No injuries · Limited investigation · Final report · Sep 16, 2002 · N440CM · Substantial damage
  > The intentional operation of the airplane with known deficiencies with the right magneto resulting in the partial loss of engine power during the initial climb.
- [NTSB NYC02LA192](https://openairdocs.org/ntsb/NYC02LA192.md): Hughes 369A · Burtonsville, MD · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 2002 · N336SP · Substantial damage
  > The failure of the tailrotor gearbox for undetermined reasons.
- [NTSB CHI02LA290](https://openairdocs.org/ntsb/CHI02LA290.md): Christen Industries A-1 · Chetek, WI · Accident · No injuries · Limited investigation · Final report · Sep 15, 2002 · N9598C · Substantial damage
  > The pilot's failure to maintain directional control of the airplane, and his failure to maintain clearance from the utility pole. A factor was the utility pole.
- [NTSB ANC02LA121](https://openairdocs.org/ntsb/ANC02LA121.md): Gardner Kitfox · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 2002 · N996DG · Substantial damage
  > A partial loss of engine power due to an engine bearing failure during the takeoff initial climb. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB CHI02LA283](https://openairdocs.org/ntsb/CHI02LA283.md): Terning Sky Scout · Sedan, KS · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 2002 · N174BT · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.
- [NTSB ANC02LA119](https://openairdocs.org/ntsb/ANC02LA119.md): Cessna 185 · Mc Grath, AK · Accident · No injuries · Limited investigation · Final report · Sep 11, 2002 · N1987U · Substantial damage
  > The pilot's inadequate compensation for wind conditions during takeoff, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind condition.
- [NTSB ATL02LA168](https://openairdocs.org/ntsb/ATL02LA168.md): Cessna 172P · Mocksville, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2002 · N62602 · Substantial damage
  > The pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.
- [NTSB SEA02FA171](https://openairdocs.org/ntsb/SEA02FA171.md): Cessna 175B · Arlington, WA · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2002 · N8195T · Substantial damage
  > A partial loss of engine power for undetermined reasons during the initial climb, followed by the pilot's failure to maintain airspeed while maneuvering. Impairing drugs found in the pilot's system at the time of the accident were a factor.
- [NTSB LAX02LA279](https://openairdocs.org/ntsb/LAX02LA279.md): Lockamy Sonex · Oxnard, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 2002 · N164JL · Substantial damage
  > the loosening of the tapered spacer, which resulted in the propeller hub separating from the crankshaft. A factor in the accident was the unsuitable terrain for landing.
- [NTSB ANC02LA118](https://openairdocs.org/ntsb/ANC02LA118.md): Cessna 180 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 2002 · N4563B · Substantial damage
  > The pilot's inadequate compensation for wind conditions during initial climb, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind.
- [NTSB CHI02LA277](https://openairdocs.org/ntsb/CHI02LA277.md): Grumman-Schweizer G-164B · Martin, MI · Accident · No injuries · Limited investigation · Final report · Sep 6, 2002 · N48417 · Substantial damage
  > The pilot's inadequate aircraft preflight and his inability to abort the takeoff due to the obscured windshield. Contributing to the accident was the bent hopper latch and the pilot's failure to maintain directional control.
- [NTSB CHI02LA274](https://openairdocs.org/ntsb/CHI02LA274.md): Brooks Sonerai 2L · Canton, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 2002 · N356RB · Substantial damage
  > The partial failure of the ignition system, the induction air leak at the carburetor mounting plate, and the pilot's inadvertant stall during the forced landing. Contributing factors were the crack in the electronic ignition coil, and the improper…
- [NTSB CHI02LA268](https://openairdocs.org/ntsb/CHI02LA268.md): Rebholz Rans S-10 · Cottage Grove, WI · Accident · 1 fatal · Limited investigation · Final report · Sep 4, 2002 · N92PD · Substantial damage
  > The pilot's decision to turn back to the airport following the loss of engine power during initial climb, the pilot not maintaining airspeed and aircraft control, which resulted in the stall at a low altitude. An additional cause was the seizure of the engine…
- [NTSB ANC02LA117](https://openairdocs.org/ntsb/ANC02LA117.md): Piper PA-32R · Manley Hot Spgs, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 2002 · N40449 · Substantial damage
  > A bird strike during takeoff, which resulted in substantial damage to the right wing.
- [NTSB ANC02LA114](https://openairdocs.org/ntsb/ANC02LA114.md): Cessna 185 · Pilot Point, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 2002 · N9563H · Substantial damage
  > The pilot's inadequate compensation for P-factor, and his failure to abort the takeoff which resulted in a collision with trees during the takeoff initial climb.
- [NTSB NYC02FA178](https://openairdocs.org/ntsb/NYC02FA178.md): Beechcraft 58P · Swanzey, NH · Accident · 7 fatal · Field investigation · Final report · Sep 2, 2002 · N6688D · Destroyed
  > **This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** the pilot's improper preflight planning and his decision to depart with known landing gear system mechanical deficiencies, which resulted in a…
- [NTSB FTW02LA248](https://openairdocs.org/ntsb/FTW02LA248.md): Cessna 150F · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2002 · N8351G · Substantial damage
  > The loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.
- [NTSB MIA02FA162](https://openairdocs.org/ntsb/MIA02FA162.md): Gulfstream American AA-5A · Greeneville, TN · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2002 · N9807U · Substantial damage
  > A loss of engine power for undetermined reasons and the pilot's decision to continue flight with a known equipment deficiency. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.
- [NTSB MIA02FA161](https://openairdocs.org/ntsb/MIA02FA161.md): Sikorsky S76A+ · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Aug 31, 2002 · N15460 · Substantial damage
  > The flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…

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

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

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