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

## Cases, newest first

- [NTSB CHI97FA290](https://openairdocs.org/ntsb/CHI97FA290.md): Beech 76 · West Lafayette, IN · Accident · 3 fatal · Field investigation · Final report · Sep 12, 1997 · N18562 · Destroyed
  > the inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.
- [NTSB FTW97LA344](https://openairdocs.org/ntsb/FTW97LA344.md): Stinson 108-3 · Horseshoe Bend, AR · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1997 · N800C · Substantial damage
  > Fuel starvation due to partially blocked fuel vents. Factors were: the pilot's inadequate preflight inspection of the airplane; the pilot's improper decision to continue operation of the airplane with known deficiencies; and the lack of suitable terrain for…
- [NTSB ANC97LA134](https://openairdocs.org/ntsb/ANC97LA134.md): Cessna 207A · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N7318U · Substantial damage
  > The pilot's inadequate evaluation of the weather conditions. Factors in the accident were a downdraft, crosswind conditions, and rough/uneven terrain.
- [NTSB IAD97FA117](https://openairdocs.org/ntsb/IAD97FA117.md): Cessna 182E · Smithfield, RI · Accident · 5 fatal · Field investigation · Final report · Sep 6, 1997 · N3286Y · Destroyed
  > A loss of engine power for undetermined reason, and the pilot's failure to maintain control of the airplane.
- [NTSB FTW97LA341](https://openairdocs.org/ntsb/FTW97LA341.md): Burgess Skyhopper · Jonesboro, AR · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1997 · N4186C · Substantial damage
  > The pilot's failure to obtain/maintain the aircraft's airspeed. Factors were the high density altitude and the lack of suitable terrain for the forced landing.
- [NTSB CHI97LA286](https://openairdocs.org/ntsb/CHI97LA286.md): Piper PA-22 · Shields, KS · Accident · No injuries · Limited investigation · Final report · Sep 6, 1997 · N9228D · Substantial damage
  > a loss of engine power from undetermined reasons.
- [NTSB ANC97LA141](https://openairdocs.org/ntsb/ANC97LA141.md): Cessna 150H · Yakutat, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1997 · N467SR · Substantial damage
  > A partial blockage of the main fuel supply line to the engine, caused by improper manufacture of the fuel line by unknown maintenance personnel.
- [NTSB ANC97LA139](https://openairdocs.org/ntsb/ANC97LA139.md): Cessna 170B · Paxson, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1997 · N4520C · Substantial damage
  > The pilot's improper use of carburetor heat during a takeoff in carburetor icing conditions. Factors associated with the accident were the pilot's decision to operate the airplane with known deficiencies (a disabled stall warning horn), an inadvertent stall,…
- [NTSB SEA97LA199](https://openairdocs.org/ntsb/SEA97LA199.md): Comeaux Kitfox 1 · Bend, OR · Accident · No injuries · Limited investigation · Final report · Aug 30, 1997 · N594KF · Substantial damage
  > The private pilot-in-command's failure to ensure that directional control was maintained. A related factor was the private pilot's lack of total flight experience.
- [NTSB NYC97GA177](https://openairdocs.org/ntsb/NYC97GA177.md): Navion G · Brooklyn, NY · Accident · No injuries · Final report · Aug 30, 1997 · N2362T · Substantial damage
  > the pilot's inadequate preflight by failing to ensure the fuel selector was properly positioned for takeoff, which resulted in fuel starvation, loss of engine power, and a forced landing after takeoff.
- [NTSB CHI97LA281](https://openairdocs.org/ntsb/CHI97LA281.md): Cessna 150M · Benton, KS · Accident · No injuries · Limited investigation · Final report · Aug 28, 1997 · N704TL · Substantial damage
  > the flight instructor's (CFI') improper in-flight planning/decision, which led to fuel exhaustion and loss of engine power before the airplane was safely landed.
- [NTSB NYC97LA171](https://openairdocs.org/ntsb/NYC97LA171.md): Lorello Genesis · Columbia Statn, OH · Accident · 1 fatal · Limited investigation · Final report · Aug 27, 1997 · N9091B · Destroyed
  > The pilot's failure to maintain airspeed.
- [NTSB CHI97LA282](https://openairdocs.org/ntsb/CHI97LA282.md): Cessna 172M · Portage, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1997 · N9026H · Substantial damage
  > the pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.
- [NTSB ATL97LA123](https://openairdocs.org/ntsb/ATL97LA123.md): Jurka P51D Mustang · Fort Pierce, FL · Accident · 1 fatal · Limited investigation · Final report · Aug 24, 1997 · N151MS · Destroyed
  > loss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while starting to maneuver for an emergency landing, which resulted in loss of aircraft control (stall) and collision with terrain.
- [NTSB FTW97LA325](https://openairdocs.org/ntsb/FTW97LA325.md): Piper PA-24-180 · Marietta, OK · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N177MM · Substantial damage
  > The pilot's failure to follow procedures/directives for takeoff. Factors were the runway's rough/uneven condition and the hilly terrain on the departure end of the runway.
- [NTSB NYC97LA167](https://openairdocs.org/ntsb/NYC97LA167.md): Piper PA-28-181 · Brickerville, PA · Accident · No injuries · Limited investigation · Final report · Aug 19, 1997 · N8262K · Substantial damage
  > Fuel starvation as a result of the pilot performing a takeoff with the fuel selector in the 'OFF' position.
- [NTSB FTW97FA313](https://openairdocs.org/ntsb/FTW97FA313.md): Beech B24R · Albany, TX · Accident · 2 fatal · Field investigation · Final report · Aug 19, 1997 · N2521W · Destroyed
  > The flight instructor's failure to maintain aircraft control during the takeoff/initial climb. A factor was the flight instructor's lack of experience in the make and model of aircraft.
- [NTSB LAX97FA292](https://openairdocs.org/ntsb/LAX97FA292.md): Piper PA-34-200T · Kernville, CA · Accident · Serious injuries · Field investigation · Final report · Aug 18, 1997 · N6654A · Destroyed
  > The partial loss of engine power due to the operator's inadequate engine maintenance relating to excessively rich mixtures (high fuel flow rates) and spark plug/magneto deficiencies. Contributing factors were degraded climb performance resulting from the high…
- [NTSB ANC97LA124](https://openairdocs.org/ntsb/ANC97LA124.md): Cessna 180H · Arctic Village, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1997 · N91412 · Destroyed
  > The pilot's inadequate compensation for gusty wind conditions. Factors were the gusty wind conditions, and the pilot's misjudging the wind information.
- [NTSB SEA97LA192](https://openairdocs.org/ntsb/SEA97LA192.md): Cessna 175 · Lynnwood, WA · Accident · No injuries · Limited investigation · Final report · Aug 17, 1997 · N7533M · Substantial damage
  > The pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.
- [NTSB CHI97LA262](https://openairdocs.org/ntsb/CHI97LA262.md): Piper PA-32R-301 · Jefferson City, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1997 · N8147B · Substantial damage
  > the pilot's incomplete preflight of the airplane's stabilizer and rudder trim settings for takeoff, his failure to correct for the high pitch during the initial climb, his failure to recover from the bounced landing, and the inadvertent stall. Factors…
- [NTSB IAD97LA111](https://openairdocs.org/ntsb/IAD97LA111.md): Cessna 150L · Westfield, MA · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 1997 · N16040 · Substantial damage
  > The pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.
- [NTSB CHI97LA261](https://openairdocs.org/ntsb/CHI97LA261.md): Piper PA-25-235 · Hinckley, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1997 · N9781P · Destroyed
  > the failure of the glider pilot to properly handle his airplane during the initial takeoff climb which resulted in the tow pilot's inability to maintain control of his airplane.
- [NTSB SEA97LA189](https://openairdocs.org/ntsb/SEA97LA189.md): Rotz RAF 2000 GTX SE · Olympia, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1997 · N9155H · Substantial damage
  > The pilot's failure to attain adequate rotor rpm prior to takeoff.
- [NTSB LAX97TA289](https://openairdocs.org/ntsb/LAX97TA289.md): Bell UH-1H · Tahoe City, CA · Accident · Minor injuries · Final report · Aug 15, 1997 · N205DF · Substantial damage
  > The pilot's decision to attempt a takeoff in environmental conditions which exceeded the helicopter's performance capability, and his improper use of the collective, which caused a decay of the main rotor rpm, the collision with the lake, and the subsequent…
- [NTSB CHI97LA257](https://openairdocs.org/ntsb/CHI97LA257.md): Cessna A188B · Elwood, NE · Accident · No injuries · Limited investigation · Final report · Aug 14, 1997 · N731GE · Substantial damage
  > the pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…
- [NTSB LAX97LA287](https://openairdocs.org/ntsb/LAX97LA287.md): Aerostar S-55A · Marana, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 1997 · N3607B · Destroyed
  > The pilot's in-flight planning/decision to continue his flight after striking a fence, and his inability to attain the proper climb rate, which subsequently led to the in-flight collision with the transmission power line.
- [NTSB MIA97LA229](https://openairdocs.org/ntsb/MIA97LA229.md): Beech 77 · Pink Hill, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 1997 · N6043T · Substantial damage
  > Failure of the dual student to maintain airspeed resulting in an inadvertent stall and uncontrolled descent until ground impact. Contributing to the accident was improper supervision of the dual student by the pilot-in-command flight instructor.
- [NTSB ANC97FA121](https://openairdocs.org/ntsb/ANC97FA121.md): Cessna U206G · Halibut Cove, AK · Accident · 3 fatal · Field investigation · Final report · Aug 12, 1997 · N756AD · Destroyed
  > The pilot's improper evaluation of the weather conditions which led the pilot to maneuver within the confines of the lake to avoid surrounding terrain and a subsequent inadvertent stall. Factors were the terrain-induced turbulence and gusts.
- [NTSB ATL97FA118](https://openairdocs.org/ntsb/ATL97FA118.md): Piper PA-24-250 · Palm Bch Garden, FL · Accident · 3 fatal · Field investigation · Final report · Aug 11, 1997 · N8213P · Destroyed
  > loss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.
- [NTSB NYC97LA163](https://openairdocs.org/ntsb/NYC97LA163.md): Elliot Monnett Moni · Hollis, NH · Accident · 1 fatal · Limited investigation · Final report · Aug 9, 1997 · N2400M · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall spin and collision with terrain.
- [NTSB LAX97LA279](https://openairdocs.org/ntsb/LAX97LA279.md): Piper PA-24-250 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Aug 9, 1997 · N711EW · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB FTW97LA307](https://openairdocs.org/ntsb/FTW97LA307.md): Cessna T210 · Eagle, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 1997 · N1119W · Destroyed
  > water contamination of the fuel, which led to a total loss of engine power and a forced landing. Factors relating to the accident were: the delay in refueling the aircraft by the FBO, which allowed condensation to form in the fuel tanks, and inadequate…
- [NTSB LAX97LA282](https://openairdocs.org/ntsb/LAX97LA282.md): Mooney M20K · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Aug 8, 1997 · N321RM · Substantial damage
  > the pilot's inadequate preflight by failing to ensure that the fuel selector was positioned to a tank containing fuel, which resulted in fuel starvation, and a forced landing shortly after takeoff.
- [NTSB NYC97LA161](https://openairdocs.org/ntsb/NYC97LA161.md): Cessna A150L · Waynesburg, PA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1997 · N23JR · Substantial damage
  > the pilot's inadequate preflight by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion during takeoff.
- [NTSB SEA97LA182](https://openairdocs.org/ntsb/SEA97LA182.md): Cessna 140 · Vancouver, WA · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 1997 · N2076N · Substantial damage
  > Aircraft control was not maintained. Continued operation with known deficiencies in equipment and movement restrictions to an exhaust valve were factors.
- [NTSB NYC97FA159](https://openairdocs.org/ntsb/NYC97FA159.md): Piper J3C-65 · Danbury, CT · Accident · 1 fatal · Field investigation · Final report · Aug 4, 1997 · N24565 · Destroyed
  > The pilot's failure to takeoff with the fuel selector in the full on position, which resulted in fuel starvation. Also causal was the pilot's improper in-flight decision to attempt a 180 degree turn back to the runway, which resulted in the inadvertent…
- [NTSB MIA97LA225](https://openairdocs.org/ntsb/MIA97LA225.md): Cessna 150 · Columbia, SC · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1997 · N3517J · Substantial damage
  > The improper rebuild/remanufacture of the fuel line (obstructed at both ends) that runs between the carburetor and sediment bowl by an unknown person. This resulted in a loss of engine power due to fuel starvation, forced landing to non-suitable terrain, and…
- [NTSB FTW97LA296](https://openairdocs.org/ntsb/FTW97LA296.md): Ercoupe Ercoupe 415-C · Harrison, AR · Accident · No injuries · Limited investigation · Final report · Aug 2, 1997 · N2899H · Substantial damage
  > The total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI97LA236](https://openairdocs.org/ntsb/CHI97LA236.md): Cessna 150M · Lee'S Summit, MO · Accident · No injuries · Limited investigation · Final report · Aug 2, 1997 · N66116 · Destroyed
  > the pilot's inadequate preflight planning/preparation, and his failure to ensure that the airplane remained clear of obstrictions (trees). Factors associated with the accident were: the short runway/takeoff area, and the proximity of trees.
- [NTSB ANC97LA114](https://openairdocs.org/ntsb/ANC97LA114.md): Cessna 170B · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Aug 2, 1997 · N3491C · Substantial damage
  > The pilot's selection of an unsuitable off-airport site for takeoff, and his premature lift-off.
- [NTSB FTW97LA293](https://openairdocs.org/ntsb/FTW97LA293.md): Bauer Vans RV-4 · Seminole, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1997 · N37RV · Substantial damage
  > loss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel tank selector.
- [NTSB FTW97LA290](https://openairdocs.org/ntsb/FTW97LA290.md): Cessna A150K · Elgin, OK · Accident · No injuries · Limited investigation · Final report · Jul 30, 1997 · N8332M · Substantial damage
  > fuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.
- [NTSB CHI97LA233](https://openairdocs.org/ntsb/CHI97LA233.md): Albrecht SEA REY · Brighton, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 30, 1997 · N7475Q · Destroyed
  > Loss of engine power due to a failed exhaust valve oil seal, and fouled spark plugs.
- [NTSB CHI97LA231](https://openairdocs.org/ntsb/CHI97LA231.md): Stratton Challenger II · Bellaire, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 1997 · N44LS · Destroyed
  > failure of the pilot to maintain control of the airplane during takeoff. The gusty wind condition was a related factor.
- [NTSB IAD97LA104](https://openairdocs.org/ntsb/IAD97LA104.md): Bell 47G-3B-1 · Mt. Vernon, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1997 · N35134 · Substantial damage
  > The pilot's failure to maintain rotor RPM.
- [NTSB MIA97FA219](https://openairdocs.org/ntsb/MIA97FA219.md): Piper PA-32R-301T · Gainesville, GA · Accident · 2 fatal · Field investigation · Final report · Jul 25, 1997 · N8473P · Destroyed
  > loss of engine power for undetermined reason(s). Factors relating to the accident were: the lack of suitable terrain for a forced landing, and obstructions (trees and building) that were encountered during the emergency landing.
- [NTSB MIA97FA217](https://openairdocs.org/ntsb/MIA97FA217.md): Gulfstream American AA-5B · Naples, FL · Accident · 1 fatal · Field investigation · Final report · Jul 25, 1997 · N28246 · Substantial damage
  > leaking fuel cap(s), due to inadequate maintenance/repair, which resulted in water contamination of the fuel; inadequate preflight by the flight crew; and improper planning/decision by the flight crew. Factors relating to the accident were: high obstructions…
- [NTSB FTW97FA280](https://openairdocs.org/ntsb/FTW97FA280.md): Cessna 150D · Fort Collins, CO · Accident · Serious injuries · Field investigation · Final report · Jul 25, 1997 · N4228U · Substantial damage
  > Inadequate preflight planning by loading the aircraft over the maximum certificated gross weight, failure to follow procedures and directives by using flaps for takeoff and failing to properly lean the engine for optimum power, and stalling the aircraft.…
- [NTSB CHI97LA224](https://openairdocs.org/ntsb/CHI97LA224.md): Beech B-23 · Watertown, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 1997 · N9120T · Destroyed
  > a loss of engine power due to undetermined reason(s).

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.