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

## Cases, newest first

- [NTSB DEN99LA035](https://openairdocs.org/ntsb/DEN99LA035.md): Mooney M20E · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jan 31, 1999 · N5658Q · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff.
- [NTSB MIA99LA071](https://openairdocs.org/ntsb/MIA99LA071.md): Piper PA-28-210T · Washington, NC · Accident · Serious injuries · Limited investigation · Final report · Jan 30, 1999 · N28235 · Destroyed
  > Loss of engine power for undetermined reasons on initial takeoff climb resulting in a forced landing and in-flight collision with trees and terrain.
- [NTSB LAX99LA084](https://openairdocs.org/ntsb/LAX99LA084.md): Maule M-4-220C · Jean, NV · Accident · No injuries · Limited investigation · Final report · Jan 30, 1999 · N474W · Substantial damage
  > Fuel starvation due to the pilot's failure to ensure that a tank containing an adequate fuel supply was selected for takeoff. A factor in the accident was the contamination in the engine driven fuel pump, which likely was not capable of providing full system…
- [NTSB CHI99LA069](https://openairdocs.org/ntsb/CHI99LA069.md): Cessna 150C · Middleton, WI · Accident · No injuries · Limited investigation · Final report · Jan 20, 1999 · N1956Z · Substantial damage
  > inadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.
- [NTSB LAX99LA076](https://openairdocs.org/ntsb/LAX99LA076.md): Cessna 140 · Burson, CA · Accident · No injuries · Limited investigation · Final report · Jan 17, 1999 · N89513 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering to avoid an obstacle immediately after takeoff. A factor in the accident was the pilot's inadequate examination of the off-airport takeoff area in order to identify potential hazards.
- [NTSB MIA99LA065](https://openairdocs.org/ntsb/MIA99LA065.md): Piper PA-22-108 · Perry, GA · Accident · No injuries · Limited investigation · Final report · Jan 6, 1999 · N4542Z · Substantial damage
  > The maintenance personnel incorrect adjustment of the intake and exhaust valves resulting in the induction system fire and subsequent loss of engine power.
- [NTSB NYC99LA045](https://openairdocs.org/ntsb/NYC99LA045.md): Piper PA-28-161 · Methuen, MA · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 1999 · N9683C · Substantial damage
  > The pilot's failure to ensure the engine primer was in and locked prior to takeoff which resulted in a loss of engine power. A factor in this accident was the pilot's lack of experience in airplanes equipped with reciprocating engines.
- [NTSB MIA99LA063](https://openairdocs.org/ntsb/MIA99LA063.md): Piper PA-28-161 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Jan 5, 1999 · N9225N · Substantial damage
  > The pilot-in command's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command.
- [NTSB LAX99IA072](https://openairdocs.org/ntsb/LAX99IA072.md): Boeing 727-225A · Phoenix, AZ · Incident · No injuries · Incident investigation · Final report · Jan 5, 1999 · N804MA · Minor damage
  > The failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…
- [NTSB LAX99LA067](https://openairdocs.org/ntsb/LAX99LA067.md): Cessna 140 · Santa Barbara, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1999 · N3585V · Substantial damage
  > A loss of engine power due to an internal left magneto coil primary circuit short. Factors were insufficient altitude and inadequate terrain to make an emergency landing.
- [NTSB IAD99FA025](https://openairdocs.org/ntsb/IAD99FA025.md): Lake LA-4-250 · Laconia, NH · Accident · 1 fatal · Field investigation · Final report · Jan 4, 1999 · N14001 · Destroyed
  > A loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.
- [NTSB NYC99LA044](https://openairdocs.org/ntsb/NYC99LA044.md): Beech C-24R · Farmingdale, NY · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 1999 · N1857G · Substantial damage
  > The pilot's inadequate preflight examination of the airplane, which resulted in a power loss due to fuel contamination.
- [NTSB FTW99LA064](https://openairdocs.org/ntsb/FTW99LA064.md): Cessna 152 · Bowie, TX · Accident · No injuries · Limited investigation · Final report · Dec 31, 1998 · N46285 · Substantial damage
  > The hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.
- [NTSB MIA99LA060](https://openairdocs.org/ntsb/MIA99LA060.md): Cessna 177 · Immokalee, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1998 · N3293T · Substantial damage
  > The certified flight instructor's inadequate supervision and his inadequate management of the fuel, which resulted in fuel exhaustion.
- [NTSB MIA99LA059](https://openairdocs.org/ntsb/MIA99LA059.md): Piper PA-28-161 · Conyers, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1998 · N8253E · Substantial damage
  > The pilot's decision to attempt a touch-and-go landing with insufficient runway remaining, and his failure to maintain adequate clearance from an object (tree).
- [NTSB DEN99LA028](https://openairdocs.org/ntsb/DEN99LA028.md): Burkhart Grob G103 Twin Astir · Canon City, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1998 · N173SS · Substantial damage
  > The glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.
- [NTSB MIA99LA054](https://openairdocs.org/ntsb/MIA99LA054.md): Dean Kolb Firestar 1 · Davenport, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 1998 · N643FS · Substantial damage
  > The pilot's failure to perform weight and balance calculations, resulting in a loss of directional control on initial takeoff climb due to an aft center of gravity flight condition, in flight collision with trees and terrain. Contributing to the accident was…
- [NTSB MIA99LA052](https://openairdocs.org/ntsb/MIA99LA052.md): Piper PA-24-250 · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 1998 · N5836P · Substantial damage
  > The delay by the pilot-in-command (CFI) to take control of the airplane and inadvertent stall/mush resulting in the uncontrolled descent and impact with the runway.
- [NTSB ANC99LA018](https://openairdocs.org/ntsb/ANC99LA018.md): Piper PA-23-160 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 1998 · N4185P · Substantial damage
  > A loss of engine power due to fuel contamination. A factor associated with the accident was the pilot's failure to maintain directional control.
- [NTSB LAX99FA052](https://openairdocs.org/ntsb/LAX99FA052.md): Parkman VARI-EZE · Tucson, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1998 · N81EZ · Destroyed
  > The pilot's failure to attain and maintain an adequate flying airspeed during the aircraft's maiden flight, which resulted in a stall/mush condition. Also causal was the pilot/builder's decision to modify the engine and the fuel system control microchip,…
- [NTSB LAX99LA056](https://openairdocs.org/ntsb/LAX99LA056.md): Weber CA-65 · Red Bluff, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 1998 · N5656 · Substantial damage
  > The failure of the pilot to remove the right seat belt from around the right control stick, which resulted in a loss of aircraft control. An additional cause is the pilot's failure to use a checklist.
- [NTSB ATL99LA029](https://openairdocs.org/ntsb/ATL99LA029.md): Cessna 150B · Adjuntas, PR · Accident · No injuries · Limited investigation · Final report · Dec 5, 1998 · N5957T · Substantial damage
  > The loss of engine power due to the restricted movement of the intake and exhaust valves on number 3 cylinder.
- [NTSB ATL99LA028](https://openairdocs.org/ntsb/ATL99LA028.md): Sid Champion Jurca MJ-5 · Madison, MS · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1998 · N9772N · Substantial damage
  > A loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.
- [NTSB CHI99LA045](https://openairdocs.org/ntsb/CHI99LA045.md): Beech 58 · Ankeny, IA · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1998 · N7278R · Substantial damage
  > the elevator control system jammed for undetermined reasons.
- [NTSB DEN99LA022](https://openairdocs.org/ntsb/DEN99LA022.md): Ryan Navion A · Carrizozo, NM · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 1998 · N2PE · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB FTW99LA039](https://openairdocs.org/ntsb/FTW99LA039.md): Cessna 150H · Braithwaite, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1998 · N567G · Substantial damage
  > The pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.
- [NTSB FTW99LA036](https://openairdocs.org/ntsb/FTW99LA036.md): Piper PA-28-160 · Greenville, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 1998 · N5087W · Minor damage
  > The partial loss of engine power due to a blocked muffler exhaust pipe/manifold as a result of a loose internal baffle. Factors were the improper maintenance by other maintenance personnel and the lack of suitable terrain for the forced landing.
- [NTSB LAX99LA035](https://openairdocs.org/ntsb/LAX99LA035.md): Mooney M20F · Upland, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 1998 · N3500X · Destroyed
  > Loss of engine power due to water contaminated fuel and the pilot's inadequate preflight inspection of the airplane. A factor was the failure of the owner/pilot to properly maintain the airplane.
- [NTSB IAD99LA019](https://openairdocs.org/ntsb/IAD99LA019.md): Piper PA-28-161 · Melfa, VA · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1998 · N1685H · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB FTW99LA029](https://openairdocs.org/ntsb/FTW99LA029.md): Cessna 414 · Monroe, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 1998 · N30ML · Substantial damage
  > The pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.
- [NTSB SEA99LA011](https://openairdocs.org/ntsb/SEA99LA011.md): Cessna 152 · Auburn, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1998 · N6312P · Substantial damage
  > A partial loss of engine power due to carburetor ice formation. Factors included insufficient altitude/time available for remedial action, a tail wind during the forced landing attempt, and a fence at the end of the runway.
- [NTSB MIA99LA030](https://openairdocs.org/ntsb/MIA99LA030.md): Cessna 172N · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Nov 7, 1998 · N1901S · Substantial damage
  > The failure of the pilot-in-command to note that the flaps did not retract while the pilot-rated student performed a touch-and-go landing on a 6,001 foot-long runway. Factors in the accident were the total failure of the flap system for undetermined reasons…
- [NTSB LAX99LA023](https://openairdocs.org/ntsb/LAX99LA023.md): Piper PA-46-350P · Mammoth, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 1998 · N50JG · Substantial damage
  > The pilot's failure to ensure that the autopilot was off prior to takeoff, and, his failure to maintain pitch control during the resultant pitch trim excursion during the takeoff ground roll.
- [NTSB CHI99LA021](https://openairdocs.org/ntsb/CHI99LA021.md): Jordan Acey Deucy P70 · Ava, MO · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 1998 · N597HJ · Substantial damage
  > the pilot's attempted operation of the airplane with known deficiencies, and his not obtaining control of the airplane in flight. A factor was asymmetrical ailerons.
- [NTSB ANC99LA009](https://openairdocs.org/ntsb/ANC99LA009.md): Cessna 207A · Aniak, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 1998 · N73533 · Substantial damage
  > A loss of engine power due to fuel contamination. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB FTW99LA012](https://openairdocs.org/ntsb/FTW99LA012.md): Cessna 421C · Eagle Pass, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1998 · N19MH · Destroyed
  > A downdraft, which exceeded the aircraft's climb performance. A factor was the thunderstorms in the vicinity of the airport.
- [NTSB ANC99LA007](https://openairdocs.org/ntsb/ANC99LA007.md): de Havilland DHC-2 · Chitina, AK · Accident · No injuries · Limited investigation · Final report · Oct 18, 1998 · N94DC · Substantial damage
  > The pilot's inadequate preflight which failed to detect water contamination in the fuel system. A factor was the unsuitable terrain in the emergency landing area.
- [NTSB FTW99LA009](https://openairdocs.org/ntsb/FTW99LA009.md): Cessna 172H · Conroe, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1998 · N2513L · Substantial damage
  > The pilot's failure to maintain clearance with trees. Factors were the fogged front windshield and side windows.
- [NTSB NYC99LA011](https://openairdocs.org/ntsb/NYC99LA011.md): Zeidler Sonerai II · Kenton, OH · Accident · No injuries · Limited investigation · Final report · Oct 15, 1998 · N5DZ · Substantial damage
  > The pilot's premature rotation and failure to obtain/maintain airspeed during the takeoff, which resulted in a stall and impact with the ground. Factors in this accident were the pilot's lack of total experience in tail-wheeled aircraft, and the nose high…
- [NTSB FTW99LA008](https://openairdocs.org/ntsb/FTW99LA008.md): Cessna 152 · Bridgeport, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1998 · N757XC · Substantial damage
  > The partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI99LA004](https://openairdocs.org/ntsb/CHI99LA004.md): Cessna 182N · Genesee, MI · Accident · No injuries · Limited investigation · Final report · Oct 9, 1998 · N92322 · Substantial damage
  > the pilot's failure to maintain directional control and the subsequent failure to attain clearance with the trees during takeoff. Factors associated with the accident were the trees, dark night conditions, and fog which resulted in the lack of visual…
- [NTSB FTW99LA011](https://openairdocs.org/ntsb/FTW99LA011.md): Wilson Teenie TWO · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Oct 7, 1998 · N5576 · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB IAD99FA004](https://openairdocs.org/ntsb/IAD99FA004.md): Cessna 305A · Warren, VT · Accident · 1 fatal · Field investigation · Final report · Oct 5, 1998 · N5213G · 2 aircraft · Destroyed
  > The glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.
- [NTSB ANC99LA001](https://openairdocs.org/ntsb/ANC99LA001.md): Cessna 172 · Russian Mission, AK · Accident · No injuries · Limited investigation · Final report · Oct 4, 1998 · N6867X · Substantial damage
  > The pilot's inadequate compensation for wind conditions. Factors associated with the accident are rising terrain, and a downdraft.
- [NTSB NYC99LA002](https://openairdocs.org/ntsb/NYC99LA002.md): Foreit Super CAT · Middlebury, CT · Accident · 1 fatal · Limited investigation · Final report · Oct 3, 1998 · N132TF · Destroyed
  > The pilot's failure to utilize his seat belt and shoulder harness.
- [NTSB MIA99LA003](https://openairdocs.org/ntsb/MIA99LA003.md): Piper PA-28R-200 · Punta Gorda, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1998 · N53EN · Substantial damage
  > The failure of maintenance personnel to refill the engine oil following the draining of the oil and changing of the oil filter. Also, inadequate preflight of the airplane by the pilot for his failure to noted the absence of engine oil.
- [NTSB NYC99LA003](https://openairdocs.org/ntsb/NYC99LA003.md): Piper PA-38-112 · Toughkenamon, PA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1998 · N2535A · Substantial damage
  > The pilot's inadequate preflight inspections which failed to detect an open fuel strainer valve, which resulted in a loss of engine power.
- [NTSB IAD99LA001](https://openairdocs.org/ntsb/IAD99LA001.md): Cessna 172K · Middlefield, OH · Accident · No injuries · Limited investigation · Final report · Oct 2, 1998 · N78624 · Substantial damage
  > The pilot's inadequate preflight inspection which resulted in fuel exhaustion.
- [NTSB ATL99LA003](https://openairdocs.org/ntsb/ATL99LA003.md): Auxier Herschel A Jr. SEA REY Amphibian · Keystone Height, FL · Accident · No injuries · Limited investigation · Final report · Oct 2, 1998 · N54114 · Substantial damage
  > The pilots failure to attain adequate airspeed, which resulted in a stall, and loss of control.
- [NTSB FTW99LA062](https://openairdocs.org/ntsb/FTW99LA062.md): Diamond Aircraft Industries DA 20-A1 · Tomball, TX · Accident · No injuries · Limited investigation · Final report · Oct 1, 1998 · N527SS · Substantial damage
  > The pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.

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

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

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