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

## Cases, newest first

- [NTSB ANC96LA020](https://openairdocs.org/ntsb/ANC96LA020.md): Beech G18S · Nome, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1995 · N340K · Substantial damage
  > The pilot exceeding the weight and balance limitations of the airplane and improperly utilizing the airplane's elevator trim by selecting full nose up trim.
- [NTSB CHI96LA056](https://openairdocs.org/ntsb/CHI96LA056.md): Maule M-4 · Hot Springs, SD · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1995 · N12010 · Substantial damage
  > an unauthorized modification of the air induction system by the pilot.
- [NTSB FTW96FA072](https://openairdocs.org/ntsb/FTW96FA072.md): Beech 35 · Kremmling, CO · Accident · 2 fatal · Field investigation · Final report · Dec 16, 1995 · N1969D · Destroyed
  > a loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…
- [NTSB CHI96LA054](https://openairdocs.org/ntsb/CHI96LA054.md): Bitonti Wittman WT-8 · Plymouth, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 16, 1995 · N88TK · Destroyed
  > a stuck exhaust valve resulting in an overtemperature condition of the cylinder, the pilot's continued operation without corrective maintenance, and his failure to maintain aircraft control.
- [NTSB LAX96LA071](https://openairdocs.org/ntsb/LAX96LA071.md): Cessna 172M · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Dec 13, 1995 · N73601 · Substantial damage
  > the pilot's inadequate bounced landing recovery technique, which resulted in porpoising during a downwind emergency landing. The loss of engine power for undetermined reasons was a factor.
- [NTSB SEA96LA028](https://openairdocs.org/ntsb/SEA96LA028.md): Cessna 152 · Chimacum, WA · Accident · No injuries · Limited investigation · Final report · Dec 12, 1995 · N5366M · Substantial damage
  > the pilot-in-command's delayed application of carburetor heat which resulted in a power loss due to carburetor ice. Carburetor icing conditions, a short takeoff area, and a ditch at the end of the airstrip were factors.
- [NTSB FTW96LA065](https://openairdocs.org/ntsb/FTW96LA065.md): Cessna 182E · Erie, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 1995 · N9376X · Destroyed
  > inadequate preflight by the pilot, by failing to properly remove water and other contamination from the fuel system before the flight. Factors relating to the accident were: deteriorated seals at the fuel filler neck/caps, and the annual inspection was…
- [NTSB FTW96IA066](https://openairdocs.org/ntsb/FTW96IA066.md): McDonnell Douglas DC-9-32 · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Dec 12, 1995 · N930VV · No damage
  > fatigue failure of a first stage, high pressure, turbine blade.
- [NTSB ANC96LA022](https://openairdocs.org/ntsb/ANC96LA022.md): Piper PA-11 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Dec 12, 1995 · N4589M · Substantial damage
  > The pilot's inadequate preflight preparation/planning, and his improper in flight decision making. Factors associated with the accident are the gusty crosswinds and associated turbulence.
- [NTSB NYC96IA036](https://openairdocs.org/ntsb/NYC96IA036.md): Boeing 747-240 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Dec 7, 1995 · APBAK · Minor damage
  > failure of the number two engine fan mid shaft, due a fatigue fracture caused by a previous bearing failure, and failure of the operator's maintenance personnel to detect the cracks during subsequent inspections.
- [NTSB ATL96FA017](https://openairdocs.org/ntsb/ATL96FA017.md): Cessna 402A · Avon Park, FL · Accident · 2 fatal · Field investigation · Final report · Dec 5, 1995 · N402RL · Destroyed
  > The failure of the pilot to maintain the proper climb rate and direction of flight following takeoff, resulting in a collision with obstacles. The reason for the loss of control and subsequent unusual attitude ground impact was not determined.
- [NTSB CHI96LA044](https://openairdocs.org/ntsb/CHI96LA044.md): Herring Sport FAN · Newton, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1995 · N95SF · Substantial damage
  > a loss of engine power for undetermined reasons. A factor related to the accident was the presence of traffic requiring the pilot to perform an evasive maneuver.
- [NTSB FTW96LA056](https://openairdocs.org/ntsb/FTW96LA056.md): Cessna 150M · Santa Fe, NM · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1995 · N8130V · Substantial damage
  > Loss of engine power for undetermined reasons. A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB FTW96LA054](https://openairdocs.org/ntsb/FTW96LA054.md): Hughes 369HS · Leakey, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 1995 · N8312F · Substantial damage
  > improper planning/decision by the pilot, by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion and a subsequent roll-over during a forced landing on hilly terrain. A factor relating to the accident was: downsloping terrain…
- [NTSB CHI96LA040](https://openairdocs.org/ntsb/CHI96LA040.md): Cessna 172G · Nora Springs, IA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1995 · N6094R · Substantial damage
  > the pilot's inadequate preflight planning/preparation, which resulted in loss of airspeed and a stall/mush as he was maneuvering to avoid obstructions off the end of the runway. Factors relating to the accident were: the unfavorable wind condition, high…
- [NTSB SEA96LA023](https://openairdocs.org/ntsb/SEA96LA023.md): Hardesty/Hays Quickie Q2 · Puyallup, WA · Accident · 1 fatal · Limited investigation · Final report · Nov 24, 1995 · N4416Q · Destroyed
  > a loss of engine power for undetermined reasons, the pilot's failure to maintain adequate airspeed, and his improper decision to attempt a 180-degree turn back toward the runway during the forced landing.
- [NTSB LAX96FA052](https://openairdocs.org/ntsb/LAX96FA052.md): Cessna 210L · Grand Canyon, AZ · Accident · 2 fatal · Field investigation · Final report · Nov 23, 1995 · N5138Q · Destroyed
  > the pilot's loss of aircraft control as a result of spatial disorientation. Factors were: the pilot's lack of experience in instrument and night flight conditions, inadequate transition/upgrade training, and the dark night light condition.
- [NTSB CHI96LA037](https://openairdocs.org/ntsb/CHI96LA037.md): Krugler Sonerai II · Belleville, MI · Accident · 1 fatal · Limited investigation · Final report · Nov 22, 1995 · N36AL · Destroyed
  > a loss of aircraft control due to the owner/builder's improper loading of the aircraft.
- [NTSB ATL96LA014](https://openairdocs.org/ntsb/ATL96LA014.md): Piper PA-22 · Durham, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 1995 · N5057Z · Substantial damage
  > The aircraft mechanic's failure to follow engine overhaul procedures which resulted in the failure of the camshaft drive gear.
- [NTSB ATL96LA012](https://openairdocs.org/ntsb/ATL96LA012.md): Waco ASO · Ridgeland, SC · Accident · No injuries · Limited investigation · Final report · Nov 18, 1995 · N950E · Substantial damage
  > Failure of the ignition system after takeoff, which resulted the loss of engine power.
- [NTSB MIA96LA024](https://openairdocs.org/ntsb/MIA96LA024.md): Rans S-12 · Plant City, FL · Accident · 2 fatal · Limited investigation · Final report · Nov 13, 1995 · UNREG · Substantial damage
  > failure of the non-certificated pilot (unqualified person) to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the terrain.
- [NTSB FTW96LA043](https://openairdocs.org/ntsb/FTW96LA043.md): Beech F35 · Berryville, AR · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1995 · N3299C · Substantial damage
  > The pilot's failure to conduct an adequate preflight and remove the control locks.
- [NTSB BFO96LA021](https://openairdocs.org/ntsb/BFO96LA021.md): Beech E55 · Manassas, VA · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1995 · N36SV · Destroyed
  > failure of the pilot to maintain control of the airplane, when the left engine lost power shortly after liftoff. Related factors were the pilot's failure to follow the checklist procedure, and his failure to ensure that the fuel selector was in the proper…
- [NTSB MIA96LA021](https://openairdocs.org/ntsb/MIA96LA021.md): Lynch Starduster SA-300 · Ormond Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1995 · N39339 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and control of the airplane resulting in an inadvertent stall and collision with the ground.
- [NTSB LAX96LA041](https://openairdocs.org/ntsb/LAX96LA041.md): Cooke KR-2 · Watsonville, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 1995 · N57CC · Destroyed
  > partial loss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, while maneuvering for an emergency landing, which resulted in an inadvertent stall and collision with the terrain.
- [NTSB SEA96LA014](https://openairdocs.org/ntsb/SEA96LA014.md): Cessna 180J · Stanley, ID · Accident · No injuries · Limited investigation · Final report · Nov 6, 1995 · N52095 · Substantial damage
  > the pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.
- [NTSB FTW96LA040](https://openairdocs.org/ntsb/FTW96LA040.md): Piper PA-28-180 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Nov 4, 1995 · N9504J · Substantial damage
  > Inadequate preflight by the pilot, and improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power during takeoff. Darkness was a related factor.
- [NTSB CHI96LA027](https://openairdocs.org/ntsb/CHI96LA027.md): Beech 33 · Lone Rock, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1995 · N9559Y · Substantial damage
  > a partial loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during his attempt to land the airplane back on the runway. A factor in the accident was the pilot's decision not to land in the suitable fields…
- [NTSB BFO96LA020](https://openairdocs.org/ntsb/BFO96LA020.md): Cessna 150F · New Carlisle, OH · Accident · No injuries · Limited investigation · Final report · Nov 3, 1995 · N7089F · Destroyed
  > inadequate preflight planning/preparation by the flight instructor (CFI), which resulted in a loss of engine power during initial climb, due to an inadequate supply of fuel and fuel starvation. The soft terrain encountered during the forced landing was a…
- [NTSB ANC96LA012](https://openairdocs.org/ntsb/ANC96LA012.md): Cessna 207 · Toksook Bay, AK · Accident · No injuries · Limited investigation · Final report · Nov 3, 1995 · N88BC · Substantial damage
  > The pilot's inadequate planning/decision, improper use of the flaps, and inadequate removal of snow/frost from the wings of the airplane. An upsloping runway and snow conditions were factors in the accident.
- [NTSB NYC96IA022](https://openairdocs.org/ntsb/NYC96IA022.md): Boeing 737-3B7 · Portland, ME · Incident · No injuries · Incident investigation · Final report · Nov 2, 1995 · N373US · Minor damage
  > a bird strike during takeoff, which resulted in failure of several fan blades in the right engine and a partial loss of engine power.
- [NTSB LAX96LA036](https://openairdocs.org/ntsb/LAX96LA036.md): Agusta F.260D · Grand Canyon, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 2, 1995 · N404FD · Destroyed
  > the pilot inadvertently allowed the ferry tank fuel selector to be in (or to be moved to) a partially open position before or during takeoff, which allowed air to enter the fuel system lines and result in fuel starvation. The location of the valve in the…
- [NTSB FTW96LA035](https://openairdocs.org/ntsb/FTW96LA035.md): Helio HT-295 · Llano, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 1995 · N68889 · Destroyed
  > The pilot's encounter with a downdraft and his inability to outclimb rising terrain. Factors were the rising terrain and high winds.
- [NTSB NYC96LA021](https://openairdocs.org/ntsb/NYC96LA021.md): Bischoff VAN RV-6 · Monticello, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 1995 · N9234B · Destroyed
  > the pilot's improper inflight decision to continue flight without sufficient fuel, which resulted in a loss of power due to fuel exhaustion.
- [NTSB ATL96FA010](https://openairdocs.org/ntsb/ATL96FA010.md): Piper PA-23-250 · Isbela Segunda, PR · Accident · 4 fatal · Field investigation · Final report · Oct 31, 1995 · N250HP · Substantial damage
  > the pilot's failure to maintain control of the aircraft resulting in a stall. A factor was the mechanic's failure to properly maintain the forward baggage door locking mechanism.
- [NTSB FTW96LA038](https://openairdocs.org/ntsb/FTW96LA038.md): Cessna 170B · Reklaw, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1995 · N3152A · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96LA022](https://openairdocs.org/ntsb/CHI96LA022.md): Piper J-3C · Rochester, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 1995 · N88037 · Destroyed
  > failure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall. A factor relating to the accident was: the gusty wind condition.
- [NTSB CHI96LA016](https://openairdocs.org/ntsb/CHI96LA016.md): Cessna 170B · Oconomowoc, WI · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1995 · N4555C · Substantial damage
  > a loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.
- [NTSB MIA96LA010](https://openairdocs.org/ntsb/MIA96LA010.md): Rockwell 112A · Meridianville, AL · Accident · No injuries · Limited investigation · Final report · Oct 18, 1995 · N1455J · Substantial damage
  > Loss of engine power due to inadequate maintenance during the 100-hour annual. Contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB NYC96LA009](https://openairdocs.org/ntsb/NYC96LA009.md): Cessna 172G · Wilkes-Barre, PA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1995 · N3773L · Substantial damage
  > the instructor's inadequate supervision of the flight. Contributing factors were the instructor's inexperience and the student pilot's failure to maintain aircraft control.
- [NTSB SEA96LA008](https://openairdocs.org/ntsb/SEA96LA008.md): Nord Stampe SV4C · Cottage Grove, OR · Accident · No injuries · Limited investigation · Final report · Oct 15, 1995 · N51SV · Substantial damage
  > A propeller blade separation due to inadequate material. The lack of a suitable area for the forced landing was a factor.
- [NTSB ATL96FA006](https://openairdocs.org/ntsb/ATL96FA006.md): Luscombe 8E · Picayune, MS · Accident · 2 fatal · Field investigation · Final report · Oct 15, 1995 · N71590 · Substantial damage
  > a worn left magneto distributor gear, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.
- [NTSB LAX96LA010](https://openairdocs.org/ntsb/LAX96LA010.md): Cessna 140 · Dixon, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1995 · N1782V · Substantial damage
  > fuel starvation due to debris blocking the carburetor main jet.
- [NTSB LAX96LA009](https://openairdocs.org/ntsb/LAX96LA009.md): Hughes 369HS · Hana, HI · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1995 · N9205F · Substantial damage
  > the loss of engine power due to inadequate maintenance inspection of the fuel system which permitted air to enter the engine fuel supply. A factor in the accident was the pilot's improper execution of the autorotation landing.
- [NTSB NYC96LA005](https://openairdocs.org/ntsb/NYC96LA005.md): Kelosky Pulsar XP · Zelienople, PA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1995 · N95RK · Substantial damage
  > The pilot inadvertently allowed the airplane to lift-off during a high speed taxi check, while operating the airplane with a known deficiency that consisted of a partially blocked quick disconnect fitting, which resulted in fuel starvation and the loss of…
- [NTSB LAX96LA005](https://openairdocs.org/ntsb/LAX96LA005.md): Piper J3C-65 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Oct 9, 1995 · N59931 · Substantial damage
  > fuel starvation due to swelling of the carburetor needle valve tip, which restricted the fuel flow to the carburetor inlet. A factor in the accident was the use of automotive gasoline.
- [NTSB CHI96LA003](https://openairdocs.org/ntsb/CHI96LA003.md): Piper PA-28-236 · Thorp, WI · Accident · No injuries · Limited investigation · Final report · Oct 9, 1995 · N9090X · Substantial damage
  > the pilot's failure to abort the takeoff and the premature liftoff which resulted in an inadvertent stall. Factors relating to this accident are improper planning and decision by the pilot, and the tall, wet grass.
- [NTSB BFO96LA006](https://openairdocs.org/ntsb/BFO96LA006.md): Madsen/Rans Rans S12 Airaile · Cobbs Creek, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1995 · N43364 · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB MIA96LA003](https://openairdocs.org/ntsb/MIA96LA003.md): Piper PA-23 · Spring Hill, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1995 · N183JD · Substantial damage
  > The pilot's failure to maintain airspeed (VMC) on initial takeoff climb resulting in an in-flight loss of control, and subsequent in-flight collision with the ground and a building. Contributing to the accident was a partial loss of engine power on the left…
- [NTSB ANC96LA001](https://openairdocs.org/ntsb/ANC96LA001.md): Cessna 150 · Hoonah, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1995 · N4024J · Substantial damage
  > the pilot's inadequate preflight planning/preparation. Factors relating to the accident were: improper weight and balance configuration, and unsuitable terrain in the emergency landing area.

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

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

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