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

## Cases, newest first

- [NTSB SEA07CA144](https://openairdocs.org/ntsb/SEA07CA144.md): Billings/Humbyrd Thorpe T-18 · Corona, CA · Accident · No injuries · Data collection · Final report · Jun 4, 2007 · N45BH · Substantial damage
  > A loss of engine power during the initial climb due to a fuel system malfunction. The pilot's incorrect maintenance modification to the fuel system and continued operation with known deficiencies were factors.
- [NTSB DFW07LA124](https://openairdocs.org/ntsb/DFW07LA124.md): Adams RV-6A · Boerne, TX · Accident · 1 fatal · Limited investigation · Final report · May 30, 2007 · N39AJ · Destroyed
  > The pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.
- [NTSB CHI07LA157](https://openairdocs.org/ntsb/CHI07LA157.md): Purvis Rans S6S · Newark, IL · Accident · 1 fatal · Limited investigation · Final report · May 28, 2007 · N743RP · Substantial damage
  > The pilot's failure to maintain control of the airplane which resulted in inadequate airspeed and a subsequent stall. Contributing to the accident were the pilot's improper installation of the altimeter and airspeed indicator which rendered them inoperative…
- [NTSB LAX07CA176](https://openairdocs.org/ntsb/LAX07CA176.md): I.C.A.-Brasov IS-28B2 · Mokuleia, HI · Accident · No injuries · Data collection · Final report · May 27, 2007 · N1052Y · Substantial damage
  > the pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.
- [NTSB CHI07CA155](https://openairdocs.org/ntsb/CHI07CA155.md): Champion 7EC · Sioux Falls, SD · Accident · No injuries · Data collection · Final report · May 25, 2007 · N9904Y · Substantial damage
  > The pilot's inadequate compensation for the wind conditions and the excessive pull-up during the initial takeoff climb which resulted in the stall. A factor associated with the accident was the crosswind condition.
- [NTSB CHI07LA154](https://openairdocs.org/ntsb/CHI07LA154.md): Cessna 421 · Chesterfield, MO · Accident · Serious injuries · Limited investigation · Final report · May 23, 2007 · N4082L · Substantial damage
  > Maintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…
- [NTSB LAX07CA172](https://openairdocs.org/ntsb/LAX07CA172.md): Schweizer SGS2-33A · Los Alamitos, CA · Accident · No injuries · Data collection · Final report · May 22, 2007 · N65844 · Substantial damage
  > failure of the towrope during the initial climb out.
- [NTSB CHI07CA152](https://openairdocs.org/ntsb/CHI07CA152.md): Cessna 421C · Kokomo, IN · Accident · No injuries · Data collection · Final report · May 22, 2007 · N85SC · Substantial damage
  > The pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…
- [NTSB CHI07CA148](https://openairdocs.org/ntsb/CHI07CA148.md): Cessna A188 · Scotland, SD · Accident · No injuries · Data collection · Final report · May 19, 2007 · N926LT · Substantial damage
  > The pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.
- [NTSB SEA07LA126](https://openairdocs.org/ntsb/SEA07LA126.md): Cessna 150G · Pahrump, NV · Accident · 1 fatal · Limited investigation · Final report · May 18, 2007 · N3121J · Substantial damage
  > The loss of engine power due to fuel contamination followed by the pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's inadequate preflight and an inadequate 100-hour maintenance inspection by other maintenance…
- [NTSB SEA07CA130](https://openairdocs.org/ntsb/SEA07CA130.md): Aircraft Mfg & Dev. CH 2000 · Merced, CA · Accident · No injuries · Data collection · Final report · May 15, 2007 · N363AM · Substantial damage
  > The student pilot's inadvertent stall/mush during a simulated power loss after takeoff and the flight instructor's delayed remedial action, which resulted in a hard landing. A contributing factor was the flight instructor's lack of familiarity with the…
- [NTSB CHI07CA139](https://openairdocs.org/ntsb/CHI07CA139.md): Cessna 150 · English, IN · Accident · No injuries · Data collection · Final report · May 15, 2007 · N7772E · Substantial damage
  > The pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.
- [NTSB LAX07LA167](https://openairdocs.org/ntsb/LAX07LA167.md): Sheely Rans S-12XL · Pinetop, AZ · Accident · 1 fatal · Limited investigation · Final report · May 13, 2007 · N6641K · Substantial damage
  > the pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with terrain.
- [NTSB LAX07CA165](https://openairdocs.org/ntsb/LAX07CA165.md): Piper PA-28-140 · Moab, UT · Accident · Minor injuries · Data collection · Final report · May 12, 2007 · N8598N · Substantial damage
  > The pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.
- [NTSB ANC07CA033](https://openairdocs.org/ntsb/ANC07CA033.md): Cessna 185 · Cantwell, AK · Accident · No injuries · Data collection · Final report · May 10, 2007 · N9832X · Substantial damage
  > The pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in a descent into high vegetation, and a nose over. Factors contributing to the accident were the pilot's inadequate weather evaluation and a downdraft.
- [NTSB MIA07LA091](https://openairdocs.org/ntsb/MIA07LA091.md): Lee Stevens Sorrell SNS-2 Guppy · Stewartstown, PA · Accident · 1 fatal · Limited investigation · Final report · May 5, 2007 · UNREG · Substantial damage
  > The pilot's failure to maintain airspeed resulting in inadvertent stall. Contributing to the accident was the pilot's lack of experience in the airplane.
- [NTSB DFW07LA105](https://openairdocs.org/ntsb/DFW07LA105.md): Aviat A-1A · Farmingdale, NY · Accident · Serious injuries · Limited investigation · Final report · May 5, 2007 · N16HY · Substantial damage
  > The pilot's failure to maintain control of the airplane during a short-field takeoff, which resulted in an inadvertent stall.
- [NTSB SEA07CA122](https://openairdocs.org/ntsb/SEA07CA122.md): Piper PA-22 · Chiloquin, OR · Accident · Serious injuries · Data collection · Final report · May 4, 2007 · N1394C · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.
- [NTSB ANC07FA037](https://openairdocs.org/ntsb/ANC07FA037.md): Cessna 170 · Wasilla, AK · Accident · 1 fatal · Field investigation · Final report · May 4, 2007 · N4217V · Substantial damage
  > A total loss of engine power during takeoff initial climb due to fuel contamination, and the pilot's inadequate preflight inspection.
- [NTSB DFW07LA103](https://openairdocs.org/ntsb/DFW07LA103.md): Livpt Lancair IV-P · McAllen, TX · Accident · 2 fatal · Limited investigation · Final report · May 2, 2007 · N119TC · Destroyed
  > A loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI07LA126](https://openairdocs.org/ntsb/CHI07LA126.md): Luscombe 8A · Fruitport, MI · Accident · Serious injuries · Limited investigation · Final report · May 1, 2007 · N1120B · Substantial damage
  > The flight instructor failed to use carburetor heat during takeoff in icing conditions. A factor was the power line pole.
- [NTSB SEA07LA114](https://openairdocs.org/ntsb/SEA07LA114.md): Britten-Norman BN-2A-20 · Hamilton, MT · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 2007 · N634MA · Substantial damage
  > The loss of power in one engine, for undetermined reasons, soon after establishing the takeoff departure climb. Factors include rough/uneven terrain.
- [NTSB DFW07CA098](https://openairdocs.org/ntsb/DFW07CA098.md): Flagg Kitfox IV · Centerville, TX · Accident · No injuries · Data collection · Final report · Apr 28, 2007 · N674F · Substantial damage
  > The loss of engine power due to the failure of the air induction ducting. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX07CA135](https://openairdocs.org/ntsb/LAX07CA135.md): Cessna 150L · Watsonville, CA · Accident · Minor injuries · Data collection · Final report · Apr 26, 2007 · N1557Q · Substantial damage
  > a partial loss of engine power for undertermined reasons during takeoff.
- [NTSB LAX07LA134](https://openairdocs.org/ntsb/LAX07LA134.md): Piper PA-28-161 · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 2007 · N8171V · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB SEA07LA110](https://openairdocs.org/ntsb/SEA07LA110.md): Eurocopter EC 130 B4 · Makawao, HI · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 2007 · N130WS · Substantial damage
  > The pilot's improper decision to takeoff downwind in a confined landing zone, which resulted in a failure to attain translational lift and a loss of control.
- [NTSB NYC07CA101](https://openairdocs.org/ntsb/NYC07CA101.md): Stinson 108-3 · Pompton Plains, NJ · Accident · Minor injuries · Data collection · Final report · Apr 20, 2007 · N6513M · Destroyed
  > A loss of engine power during the initial climb for undetermined reasons.
- [NTSB MIA07LA081](https://openairdocs.org/ntsb/MIA07LA081.md): Cessna U206G · Welaka, FL · Accident · 2 fatal · Limited investigation · Final report · Apr 19, 2007 · N2874B · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.
- [NTSB NYC07FA096](https://openairdocs.org/ntsb/NYC07FA096.md): Beech 95-B55 · Saranac Lake, NY · Accident · 1 fatal · Field investigation · Final report · Apr 18, 2007 · N868ST · Destroyed
  > The pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.
- [NTSB ANC07LA029](https://openairdocs.org/ntsb/ANC07LA029.md): de Havilland DHC-2 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Apr 18, 2007 · N93V · Substantial damage
  > The improper installation/reversal of the aileron flight control system by other maintenance personnel, and the pilot's inadequate preflight inspection, which resulted in a loss of control during takeoff initial climb.
- [NTSB SEA07CA102](https://openairdocs.org/ntsb/SEA07CA102.md): North American Aviation Div. T-28C · Red Lodge, MT · Accident · Minor injuries · Data collection · Final report · Apr 17, 2007 · N464SB · Destroyed
  > The lack of suitable terrain for a forced landing. Contributing factors were the loss of engine power during takeoff for undetermined reasons, and rough/uneven condition of the terrain.
- [NTSB CHI07LA121](https://openairdocs.org/ntsb/CHI07LA121.md): Mooney M20C · Sidney, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2007 · N3529H · Substantial damage
  > The total loss of engine power during initial climb due to oil starvation as a result of improper maintenance. The fixed base operator's failure to advise the pilot that the engine had been operated without oil in the engine and soft terrain were factors.
- [NTSB NYC07LA094](https://openairdocs.org/ntsb/NYC07LA094.md): Romeo Lancair Legacy RG · Fulton, NY · Accident · 2 fatal · Limited investigation · Final report · Apr 14, 2007 · N45FR · Substantial damage
  > A loss of engine power during the initial climb after takeoff for undetermined reasons.
- [NTSB MIA07LA074](https://openairdocs.org/ntsb/MIA07LA074.md): Consolidated Aeronautics Lake LA-4-200 · Sarasota, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2007 · N8543W · Substantial damage
  > The total loss of engine power for undetermined reasons during initial climb after takeoff, resulting in a forced landing, and an in-flight collision with transmission wires and terrain.
- [NTSB DEN07LA083](https://openairdocs.org/ntsb/DEN07LA083.md): Beech 35 · Topeka, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 2007 · N460B · Substantial damage
  > The use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…
- [NTSB SEA07LA095](https://openairdocs.org/ntsb/SEA07LA095.md): Diemert/Rotorway Exec 162 F · Roseburg, OR · Accident · No injuries · Limited investigation · Final report · Apr 8, 2007 · N173ST · Substantial damage
  > a total loss of engine power due to the failure of the primary and secondary electronic control units (ECU's) within the engine's Fully Automated Digital Electronic Control.
- [NTSB SEA07LA092](https://openairdocs.org/ntsb/SEA07LA092.md): Piper PA-32R-301T · Lincoln, CA · Accident · No injuries · Limited investigation · Final report · Apr 6, 2007 · N4379A · Substantial damage
  > An in-flight fire occurred during the initial climb as a result of the aviation maintenance technician's failure to sufficiently tighten the b-nut that was found disconnected post-accident. A contributing factor was the engine manufacturer's failure to…
- [NTSB LAX07CA120](https://openairdocs.org/ntsb/LAX07CA120.md): Carpenter Lancair 320 · Los Angeles, CA · Accident · No injuries · Data collection · Final report · Apr 3, 2007 · N320 · Substantial damage
  > contamination of the number 2 fuel injector nozzle that lead to a partial loss of engine power.
- [NTSB ATL07LA063](https://openairdocs.org/ntsb/ATL07LA063.md): Randy Stanley Rotoway Exc 162F · Foley, AL · Accident · No injuries · Limited investigation · Final report · Mar 29, 2007 · N494D · Substantial damage
  > Loss of engine power due to failure of the No. 4 engine exhaust valve.
- [NTSB DFW07LA087](https://openairdocs.org/ntsb/DFW07LA087.md): PZL 101A · Spicewood, TX · Accident · No injuries · Limited investigation · Final report · Mar 25, 2007 · N69NV · Substantial damage
  > The loss of engine power due to water contamination in the fuel system. A contributing factor was the lack of suitable terrain available for the forced landing.
- [NTSB MIA07CA061](https://openairdocs.org/ntsb/MIA07CA061.md): Bruce E. Hotz Wind Wagon · Leesburg, FL · Accident · Minor injuries · Data collection · Final report · Mar 19, 2007 · N9017M · Substantial damage
  > The failure of the pilot to abort the takeoff after recognizing that the engine rpm was 760 less than desired after becoming airborne, and the inability of the airplane to maintain a positive rate of climb resulting in a controlled descent, and in-flight…
- [NTSB MIA07LA063](https://openairdocs.org/ntsb/MIA07LA063.md): Jimenez Reymundo Challenger II Specia · Arecibo, PR · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2007 · N7023D · Substantial damage
  > The uncertificated pilot's failure to remove the aft seat belt from around the aft control stick prior to flight.
- [NTSB CHI07LA093](https://openairdocs.org/ntsb/CHI07LA093.md): Boeing 767-300 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Mar 16, 2007 · N662UA · Substantial damage
  > The contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.
- [NTSB MIA07FA056](https://openairdocs.org/ntsb/MIA07FA056.md): Beech 95-C55 · Port Orange, FL · Accident · 1 fatal · Field investigation · Final report · Mar 4, 2007 · N100FG · Substantial damage
  > The pilot's failure to maintain airspeed during initial climb resulting in inadvertent stall. Contributing to the accident was the pilot's improper positioning of the left fuel selector which resulted in fuel starvation to the left engine.
- [NTSB SEA07LA066](https://openairdocs.org/ntsb/SEA07LA066.md): Scherer Europa · Upland, CA · Accident · No injuries · Limited investigation · Final report · Feb 25, 2007 · N81EU · Substantial damage
  > The pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.
- [NTSB ATL07LA045](https://openairdocs.org/ntsb/ATL07LA045.md): Hiller UH-12A · Bethlehem, GA · Accident · 2 fatal · Limited investigation · Final report · Feb 24, 2007 · N8180H · Substantial damage
  > The pilot's failure to maintain adequate rotor rpm, which resulted in an attempted autorotation and in-flight collision with trees. Contributing to the severity of the accident was the pilot exceeding the helicopters takeoff capability.
- [NTSB NYC07LA068](https://openairdocs.org/ntsb/NYC07LA068.md): Piper PA-28-140 · Saluda, VA · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2007 · N32285 · Substantial damage
  > The improper repair of the carburetor heat control linkage by person(s) unknown. Contributing to the accident was the pilot's improper decision to takeoff, with the engine developing partial power.
- [NTSB SEA07LA059](https://openairdocs.org/ntsb/SEA07LA059.md): Barnhart RV-6 · Auburn, WA · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 2007 · N601DB · Substantial damage
  > A loss of engine power due to the obstruction of the engine's air inlet by a fabricated neoprene seal, and inadequate maintenance by unknown maintenance personnel. A contributing factor was the lack of suitable terrain for a forced landing.
- [NTSB DEN07IA069](https://openairdocs.org/ntsb/DEN07IA069.md): Airbus Industrie A319-111 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Feb 16, 2007 · N927FR · Minor damage
  > Fracturing of the aircraft windscreens due to impact with foreign object debris. Contributing to the event was the high, gusty surface winds.
- [NTSB MIA07LA049](https://openairdocs.org/ntsb/MIA07LA049.md): McDonnell Douglas 369FF · Placida, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 2007 · N819BP · Substantial damage
  > The in-flight separation of the tail rotor pitch change control rod and bellcrank during takeoff-initial climb.

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

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

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