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

## Cases, newest first

- [NTSB FTW98LA292](https://openairdocs.org/ntsb/FTW98LA292.md): Grumman-Schweizer G-164A · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Jul 2, 1998 · N8866H · Substantial damage
  > The loss of engine power due to the collapsed of the engine induction air ducting. Factors were the inadequate maintenance inspection and the lack of suitable terrain for the pilot to execute the forced landing.
- [NTSB CHI98LA233](https://openairdocs.org/ntsb/CHI98LA233.md): Wicks FLY Baby · Blissfield, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1998 · N40349 · Substantial damage
  > the pilot's misjudging of the fuel supply and his inadequate aircraft preflight. A factor was fuel exhaustion,
- [NTSB FTW98FA291](https://openairdocs.org/ntsb/FTW98FA291.md): Cessna 140A · Edgewood, TX · Accident · 1 fatal · Field investigation · Final report · Jul 1, 1998 · N9689A · Substantial damage
  > The pilot's failure to maintain minimum required airspeed for flight. Factors were the worn fuel line, which separated, and the failure of the maintenance personnel to locate the worn fuel line during the annual inspection.
- [NTSB LAX98FA208](https://openairdocs.org/ntsb/LAX98FA208.md): Frandsen Midget Mustang MM-1 · Tracy, CA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 1998 · N76JF · Destroyed
  > inadequate maintenance/inspection by the owner/pilot that resulted in an obstructed fuel vent system and a subsequent loss of engine power during takeoff.
- [NTSB FTW98LA285](https://openairdocs.org/ntsb/FTW98LA285.md): Cessna 150G · Uvalde, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 1998 · N8445J · Substantial damage
  > The pilot's improper use of the flaps which resulted in an inadvertent stall during the initial takeoff climb. Factors were his lack of recent experience in the make and model of airplane and the high density altitude.
- [NTSB CHI98LA227](https://openairdocs.org/ntsb/CHI98LA227.md): Commonwealth 185 · Oregon, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1998 · N92997 · Substantial damage
  > the improper adjustment of the carburetor by an unqualified person. Factors to the accident were the annual inspection not being complied with and the lack of recent experience of the pilot.
- [NTSB CHI98LA226](https://openairdocs.org/ntsb/CHI98LA226.md): Cessna 150H · Osceola, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1998 · N50433 · Substantial damage
  > the student pilot's incomplete preflight, and the instructor pilot's inadequate supervision of the student's preflight. Factors were the fuel contaminated with water, and the roadway encountered during the forced landing rollout.
- [NTSB SEA98LA111](https://openairdocs.org/ntsb/SEA98LA111.md): Koster Murphy Rebel · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1998 · N265KK · Substantial damage
  > The pilot/builder's attachment inadequate installation of the aileron control pushrods to the control stick assembly, resulting in the ailerons deflecting in a direction opposite of the input applied by the pilot. Also causal was the pilot's inadequate…
- [NTSB SEA98LA106](https://openairdocs.org/ntsb/SEA98LA106.md): Schweizer G-164B · Oakdale, WA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1998 · N7502C · Substantial damage
  > A fatigue failure of the number three cylinder exhaust rocker box assembly, compromising the ability of the exhaust valve to operate. Factors include a ditch at the end of the runway.
- [NTSB MIA98LA190](https://openairdocs.org/ntsb/MIA98LA190.md): Aviat A-1A · Daytona Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1998 · N32HU · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in a stall. A contributing factor was the pilot's delay in initiating remedial action.
- [NTSB LAX98LA214](https://openairdocs.org/ntsb/LAX98LA214.md): Cessna 172 · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Jun 27, 1998 · N7188A · Substantial damage
  > Oil system contamination with an unidentified metal substance that traveled through the oil system and blocked the number 4 main bearing and number 6 connecting rod bearing oil ports, resulting in oil starvation and failure of the engine. The source of the…
- [NTSB CHI98LA224](https://openairdocs.org/ntsb/CHI98LA224.md): Piper PA-28-235 · Liberal, KS · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 1998 · N8903W · Destroyed
  > the inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.
- [NTSB LAX98LA212](https://openairdocs.org/ntsb/LAX98LA212.md): North American Navion · San Andreas, CA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1998 · N1400Z · Substantial damage
  > The pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.
- [NTSB CHI98LA223](https://openairdocs.org/ntsb/CHI98LA223.md): Rockwell S2-R · Williams, MN · Accident · No injuries · Limited investigation · Final report · Jun 26, 1998 · N5682X · Substantial damage
  > the pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.
- [NTSB CHI98LA217](https://openairdocs.org/ntsb/CHI98LA217.md): Air Tractor AT-301 · Ipswich, SD · Accident · No injuries · Limited investigation · Final report · Jun 25, 1998 · N31677 · Substantial damage
  > the pilot's inadequate evaluation of the weather conditions and his failure to maintain aircraft control which resulted in a stall/mush. Factors associated with the accident were the tailwind condition and the soft terrain.
- [NTSB CHI98LA218](https://openairdocs.org/ntsb/CHI98LA218.md): Hiller UH-12E · Park Rapids, MN · Accident · No injuries · Limited investigation · Final report · Jun 24, 1998 · N86663 · Substantial damage
  > the pilot's failure to maintain control of aircraft. Factors were the congested helipad conditions and wind gusts.
- [NTSB CHI98LA212](https://openairdocs.org/ntsb/CHI98LA212.md): Cessna 150G · Rush City, MN · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 1998 · N8450J · Destroyed
  > the pilot inadvertently stalled the airplane during the initial takeoff climb. Factors associated with the accident were the pilot's inattentiveness at lowering excessive flaps for takeoff.
- [NTSB CHI98LA211](https://openairdocs.org/ntsb/CHI98LA211.md): Hartzler Nieuport 11 · Gardner, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1998 · N921DH · Substantial damage
  > the pilot's inadequate weather evaluation and the aircraft stall. A factor to the accident was the gusting wind.
- [NTSB CHI98LA213](https://openairdocs.org/ntsb/CHI98LA213.md): Cessna 310N · Janesville, WI · Accident · No injuries · Limited investigation · Final report · Jun 20, 1998 · N5030Q · Substantial damage
  > other maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.
- [NTSB FTW98LA270](https://openairdocs.org/ntsb/FTW98LA270.md): Piper PA-25-260 · Douglas, WY · Accident · No injuries · Limited investigation · Final report · Jun 17, 1998 · N8531L · Substantial damage
  > The pilot's inadequate judgement in attempting to takeoff from unsuitable rough terrain.
- [NTSB LAX98LA200](https://openairdocs.org/ntsb/LAX98LA200.md): Hughes 369HS · Pacific Ocean (Pacific Ocean) · Accident · 2 fatal · Limited investigation · Final report · Jun 16, 1998 · N95MS · Destroyed
  > The improper shimmying of the tail rotor driveshaft by maintenance personnel which induced fatigue in the tail rotor driveshaft coupling causing it to fail, which resulted in a loss of tail rotor control. A factor is the failure of the pilot to recognize the…
- [NTSB SEA98LA097](https://openairdocs.org/ntsb/SEA98LA097.md): Piper PA-25-235 · Blackfoot, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 1998 · N8553L · Destroyed
  > A loss of power for undetermined reasons.
- [NTSB ANC98LA073](https://openairdocs.org/ntsb/ANC98LA073.md): Lake LA-4 · Saint Mary'S, AK · Accident · No injuries · Limited investigation · Final report · Jun 15, 1998 · N19AK · Substantial damage
  > The pilot's diverted attention during takeoff, and his failure to maintain a proper climb rate. A factor associated with the accident was the presence of birds.
- [NTSB SEA98LA096](https://openairdocs.org/ntsb/SEA98LA096.md): Cessna 172R · Independence, OR · Accident · No injuries · Limited investigation · Final report · Jun 14, 1998 · N9514P · Substantial damage
  > A loss of power due to fatigue failure and cracking of an engine cylinder barrel.
- [NTSB FTW98LA266](https://openairdocs.org/ntsb/FTW98LA266.md): Cessna A188B · Mcgehee, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1998 · N4911R · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ANC98LA081](https://openairdocs.org/ntsb/ANC98LA081.md): Aeronca 15AC · Homer, AK · Accident · No injuries · Limited investigation · Final report · Jun 12, 1998 · N1023H · Substantial damage
  > The loss of engine power due to fuel starvation, and an improper fuel selector valve. Factors in the accident were turbulent wind conditions, the improper replacement of the fuel selector valve by an airplane mechanic, and the failure of an FAA inspector to…
- [NTSB NYC98FA127](https://openairdocs.org/ntsb/NYC98FA127.md): Piper 601P · Martinsburg, PA · Accident · 3 fatal · Field investigation · Final report · Jun 10, 1998 · N60721 · Destroyed
  > The pilot's failure to maintain airspeed due to spatial disorientation, which resulted in an inadvertent stall and subsequent collision with terrain. A factor in the accident was the low ceiling.
- [NTSB FTW98LA261](https://openairdocs.org/ntsb/FTW98LA261.md): Gisclair Murphy Renegade SP · Galliano, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 1998 · N96VG · Destroyed
  > A loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB LAX98LA186](https://openairdocs.org/ntsb/LAX98LA186.md): Piper PA-28-181 · El Cajon, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1998 · N84451 · Substantial damage
  > The certified flight instructor's inadequate preflight which led to fuel exhaustion and subsequent loss of engine power. A related factor was the unsuitable terrain.
- [NTSB CHI98LA205](https://openairdocs.org/ntsb/CHI98LA205.md): Piper PA-28-140 · Harrison, NE · Accident · No injuries · Limited investigation · Final report · Jun 6, 1998 · N4541R · Substantial damage
  > the pilot's improper positioning of the magneto switch and his improper use of the mixture control.
- [NTSB MIA98LA192](https://openairdocs.org/ntsb/MIA98LA192.md): Cessna 310K · Opa-Locka, FL · Accident · No injuries · Limited investigation · Final report · Jun 5, 1998 · N366J · Substantial damage
  > The fuel leak due to improper installation of the left auxiliary fuel tank by maintenance personnel. Also, inadequate annual inspection of the airplane by maintenance personnel for failure to identify the missing screw from the adel clamp resulting in chafing…
- [NTSB CHI98LA186](https://openairdocs.org/ntsb/CHI98LA186.md): Sheets Kitfox II · Greenfield, IA · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1998 · N487JS · Destroyed
  > the initial climb airspeed not obtained/maintained after liftoff by the pilot in command. A factor was the improper compensation for wind conditions by the pilot in command.
- [NTSB CHI98LA188](https://openairdocs.org/ntsb/CHI98LA188.md): Cessna 175A · Norfolk, NE · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1998 · N6847E · Destroyed
  > the pilot's misjudged wind conditions and his not obtaining/maintaining compensation for wind conditions. A factor was a sudden wind shift.
- [NTSB LAX98LA178](https://openairdocs.org/ntsb/LAX98LA178.md): Fields Baby Belle · Inyokern, CA · Accident · Serious injuries · Limited investigation · Final report · May 31, 1998 · N656VK · Destroyed
  > The failure of the pilot to recover from a low rotor rpm condition, which resulted in a loss of aircraft control.
- [NTSB FTW98LA250](https://openairdocs.org/ntsb/FTW98LA250.md): Piper PA-22 · Balko, OK · Accident · Minor injuries · Limited investigation · Final report · May 31, 1998 · N200HA · Substantial damage
  > The pilot's inadequate preflight planning which failed to assure adequate climb performance to clear an obstacle (fence) during takeoff climb.
- [NTSB CHI98LA183](https://openairdocs.org/ntsb/CHI98LA183.md): Luscombe 8E · Montague, MI · Accident · Minor injuries · Limited investigation · Final report · May 30, 1998 · N1968K · Substantial damage
  > the pilot's improper use of carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Factors to the accident were the carburetor icing conditions and the trees.
- [NTSB FTW98LA242](https://openairdocs.org/ntsb/FTW98LA242.md): Grumman American AA-1C · Roanoke, TX · Accident · Minor injuries · Limited investigation · Final report · May 29, 1998 · N9606U · Substantial damage
  > The loss of engine power resulting from an excessively rich mixture for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI98LA179](https://openairdocs.org/ntsb/CHI98LA179.md): Cessna 177RG · Tocsin, IN · Accident · No injuries · Limited investigation · Final report · May 28, 1998 · N1849Q · Substantial damage
  > the pilot's failure to obtain adequate airspeed during the takeoff climb and the resulting inadvertant stall. A factor in the accident was the pilot's premature raising of the flaps.
- [NTSB CHI98LA178](https://openairdocs.org/ntsb/CHI98LA178.md): Cessna 414 · North Platte, NE · Accident · Minor injuries · Limited investigation · Final report · May 28, 1998 · N888AA · Destroyed
  > the slipped number two bearing in the airplane's right engine, which blocked the bearing's oil feed line, causing the bearing and the crankshaft to overheat and fracture. A factor contributing to this accident was the trees.
- [NTSB FTW98FA239](https://openairdocs.org/ntsb/FTW98FA239.md): Bell 206L-3 · Springdale, AR · Accident · Serious injuries · Field investigation · Final report · May 24, 1998 · N27AE · Substantial damage
  > The failure of maintenance personnel to properly assemble the engine's accessory gearbox, which resulted in a total loss of engine power due to partial blockage of the main oil passage by an o-ring. The blockage reduced oil flow to the turbine shafting, which…
- [NTSB CHI98LA173](https://openairdocs.org/ntsb/CHI98LA173.md): Cessna 310R · Augusta, KS · Accident · Serious injuries · Limited investigation · Final report · May 24, 1998 · N5247J · Substantial damage
  > the pilot's inadequate evaluation of the current local weather conditions and his failure to maintain a climb after takeoff. Factors related to the accident were the fog, the powerlines, and spatial disorientation.
- [NTSB CHI98LA170](https://openairdocs.org/ntsb/CHI98LA170.md): Kreatz Genesis · Maple Lake, MN · Accident · 2 fatal · Limited investigation · Final report · May 21, 1998 · N68474 · Destroyed
  > the pilot inadvertently stalled the airplane. A factor was the failed reduction drive belts.
- [NTSB CHI98LA158](https://openairdocs.org/ntsb/CHI98LA158.md): Cessna 150 · Griffith, IN · Accident · No injuries · Limited investigation · Final report · May 21, 1998 · N2916J · Substantial damage
  > The aircraft's speed not maintained by the pilot, which resulted in the aircraft stalling in close proximity to the ground.
- [NTSB CHI98LA160](https://openairdocs.org/ntsb/CHI98LA160.md): Pitts S-2A · Benton, KS · Accident · Serious injuries · Limited investigation · Final report · May 18, 1998 · N31517 · Substantial damage
  > the pilot did not flare the airplane properly during the forced landing. A factor was the engine failure for undetermined reasons.
- [NTSB NYC98LA110](https://openairdocs.org/ntsb/NYC98LA110.md): Cessna 337B · Montgomery, NY · Accident · 1 fatal · Limited investigation · Final report · May 17, 1998 · N5471S · Substantial damage
  > the pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).
- [NTSB LAX98LA162](https://openairdocs.org/ntsb/LAX98LA162.md): Schweizer G164D · Richvale, CA · Accident · No injuries · Limited investigation · Final report · May 17, 1998 · N8177K · Destroyed
  > The separation of four compressor/turbine blades resulting in a sudden loss of engine power with a subsequent forced landing into unsuitable terrain.
- [NTSB IAD98FA059](https://openairdocs.org/ntsb/IAD98FA059.md): Piper PA-28-140 · Fort Washington, MD · Accident · 1 fatal · Field investigation · Final report · May 17, 1998 · N4537R · Destroyed
  > The pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.
- [NTSB FTW98LA225](https://openairdocs.org/ntsb/FTW98LA225.md): Air Tractor AT-502B · Parkin, AR · Accident · No injuries · Limited investigation · Final report · May 17, 1998 · N502JF · Destroyed
  > the pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees at the departure end of the airstrip. Related factors were: high density altitude and trees at the departure end of the airstrip.
- [NTSB CHI98LA161](https://openairdocs.org/ntsb/CHI98LA161.md): Grumman American AA-1C · Manhattan, KS · Accident · No injuries · Limited investigation · Final report · May 17, 1998 · N954OU · Substantial damage
  > the pilot did not attain proper flying speed. Factors included the high density altitude and crosswind condition.
- [NTSB CHI98FA165](https://openairdocs.org/ntsb/CHI98FA165.md): Cessna 172 · S. Sioux City, NE · Accident · 2 fatal · Field investigation · Final report · May 17, 1998 · N8919B · Destroyed
  > The pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.

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

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

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