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

## Cases, newest first

- [NTSB DEN00LA056](https://openairdocs.org/ntsb/DEN00LA056.md): Piper PA-18-150 · Belen, NM · Accident · No injuries · Limited investigation · Final report · Mar 12, 2000 · N4069Z · Substantial damage
  > A loss of engine power due to low cylinder compression from an open exhaust valve, and the pilot's failure to lean the fuel mixture.
- [NTSB LAX00LA129](https://openairdocs.org/ntsb/LAX00LA129.md): Robinson R22B · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 2000 · N7078B · Substantial damage
  > The pilot's selection of an inadequate takeoff area which precluded his ability to remain in ground effect until entering translational lift and resulted in his failure to maintain main rotor rpm.
- [NTSB LAX00FA126](https://openairdocs.org/ntsb/LAX00FA126.md): Cessna 182Q · Fallbrook, CA · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2000 · N95996 · Substantial damage
  > the loss of engine power resulting from fuel starvation due to the pilot's inadequate pre-flight inspection, inadequate performance of the pre-takeoff checklist, and failure to ensure that the fuel selector was properly positioned prior to takeoff. Also…
- [NTSB LAX00LA118](https://openairdocs.org/ntsb/LAX00LA118.md): Arrow OH-58A · Calipatria, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 8, 2000 · N39FA · Substantial damage
  > The pilot's inadequate checklist procedure prior to departure, which did not verify the fuel selector was in the proper position for flight, and the pilot's failure to maintain adequate main rotor speed for an autorotative landing.
- [NTSB CHI00LA086](https://openairdocs.org/ntsb/CHI00LA086.md): Alon Ercoupe · Osceola, IA · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 2000 · N6560Q · Substantial damage
  > fuel starvation due to an undetermined blockage in the fuel line from the header tank to the gascolator. Factors relating to this accident were the blocked fuel line and the rough terrain.
- [NTSB LAX00LA104](https://openairdocs.org/ntsb/LAX00LA104.md): Cohen VAN'S RV-6 · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Feb 21, 2000 · N264JC · Substantial damage
  > Failure of the pilot to maintain control of the aircraft during a crosswind takeoff, which resulted in a collision with the terrain and a runway light.
- [NTSB LAX00LA109](https://openairdocs.org/ntsb/LAX00LA109.md): Hughes 500C · Pohnpei (Pacific Ocean) · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 2000 · N437DS · Destroyed
  > The pilot reported that he and the observer were planning to conduct tuna spotting operations. This was to be the first flight of the day. After takeoff, about 100 to 150 feet above sea level, the helicopter began an uncommanded right turn, followed by an…
- [NTSB DCA00MA026](https://openairdocs.org/ntsb/DCA00MA026.md): Douglas DC-8-71F · Rancho Cordova, CA · Accident · 3 fatal · Class 1 · Major · Final report · Feb 17, 2000 · N8079U · Destroyed
  > A loss of pitch control resulting from the disconnection of the right elevator control tab. The disconnection was caused by the failure to properly secure and inspect the attachment bolt.
- [NTSB LAX00LA088](https://openairdocs.org/ntsb/LAX00LA088.md): Piper PA-32-300 · Ukiah, CA · Accident · No injuries · Limited investigation · Final report · Feb 16, 2000 · N1452T · Substantial damage
  > failure of the pilot to comply with the checklists in the Owner's Handbook, resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB ATL00FA026](https://openairdocs.org/ntsb/ATL00FA026.md): Piper PA-28-161 · Chamblee, GA · Accident · 1 fatal · Field investigation · Final report · Feb 15, 2000 · N8447Y · Substantial damage
  > The S76 helicopter pilot's failure to follow ATC landing sequence clearance, which resulted in the PA-28's encounter with the helicopters wake turbulence. A factor was the air traffic controllers clearance procedure.
- [NTSB NYC00LA072](https://openairdocs.org/ntsb/NYC00LA072.md): Piper PA-24 · Alton Bay, NH · Accident · No injuries · Limited investigation · Final report · Feb 5, 2000 · N6577P · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff which resulted in an inadvertent stall. A factor in the accident was the pilot's inadequate compensation for the wind conditions.
- [NTSB DEN00LA048](https://openairdocs.org/ntsb/DEN00LA048.md): Beech M35 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2000 · N639V · Destroyed
  > The pilot inadvertently allowing the airplane to stall. Factors were the missing alternator belt and the resultant total electrical system failure, and the pilot's attention being diverted.
- [NTSB MIA00LA076](https://openairdocs.org/ntsb/MIA00LA076.md): Cessna 150L · Statesboro, GA · Accident · No injuries · Limited investigation · Final report · Jan 27, 2000 · N11567 · Substantial damage
  > The partial loss of engine power due to undetermined reasons and unsuitable terrain encountered by the pilot-in-command (CFI), during the forced landing.
- [NTSB MIA00LA074](https://openairdocs.org/ntsb/MIA00LA074.md): Cessna 172N · Lincolnton, GA · Accident · No injuries · Limited investigation · Final report · Jan 25, 2000 · N2469E · Substantial damage
  > The pilot's failure to remove ice from the wings prior to takeoff resulting in the aircraft not climbing after takeoff and colliding with a tree.
- [NTSB FTW00LA074](https://openairdocs.org/ntsb/FTW00LA074.md): Air Tractor AT-401 · Rayville, LA · Accident · No injuries · Limited investigation · Final report · Jan 25, 2000 · N91968 · Substantial damage
  > The loss of engine power due to a crack in the #6 cylinder. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA00FA039](https://openairdocs.org/ntsb/SEA00FA039.md): Mooney M20K · Pendleton, OR · Accident · 2 fatal · Field investigation · Final report · Jan 24, 2000 · N251BD · Destroyed
  > The pilot's failure to adequately remove ice and snow from the airplane. A contributing factor was the pilot's inability to maintain control during climb due to degradation of the airplane's aerodynamic performance.
- [NTSB LAX00LA078](https://openairdocs.org/ntsb/LAX00LA078.md): Myers Q-2 · Compton, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 2000 · N813S · Substantial damage
  > Failure of the pilot to maintain directional control of the airplane during the takeoff roll.
- [NTSB CHI00LA059](https://openairdocs.org/ntsb/CHI00LA059.md): Cessna 208B · Warsaw, IN · Accident · No injuries · Limited investigation · Final report · Jan 20, 2000 · N9457B · Substantial damage
  > the misjudged unsafe/hazardous condition by the pilot. Factors to the accident were the precautionary landing being performed by the pilot and the snow covered runway. Additional factors were the dark night, the snowing weather condition, the airport…
- [NTSB DEN00LA046](https://openairdocs.org/ntsb/DEN00LA046.md): Cessna 172 · Tooele, UT · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 2000 · N6445B · Substantial damage
  > The pilot's failure to correct the descent, and his failure to maintain a visual lookout. Factors were the pilot's improper weather evaluation, his lack of recent experience in type of operation, his inadvertent encounter with instrument meteorological…
- [NTSB DEN00LA043](https://openairdocs.org/ntsb/DEN00LA043.md): Beech K35 · Fillmore, UT · Accident · No injuries · Limited investigation · Final report · Jan 13, 2000 · N9500R · Substantial damage
  > The pilot's improper use of elevator trim, resulting in his failure to obtain sufficient takeoff airspeed and subsequent inadvertent stall/mush. A Factor was his failure to follow the preflight checklist.
- [NTSB NYC00LA066](https://openairdocs.org/ntsb/NYC00LA066.md): Piper PA-46-310P · Bradford, PA · Accident · No injuries · Limited investigation · Final report · Jan 11, 2000 · N9103N · Substantial damage
  > The pilot's inadequate ice/frost removal from the aircraft.
- [NTSB FTW00LA061](https://openairdocs.org/ntsb/FTW00LA061.md): Taylorcraft DCO-65 · Sherman, TX · Accident · No injuries · Limited investigation · Final report · Jan 10, 2000 · N48634 · Substantial damage
  > A jammed carburetor needle which resulted in fuel starvation and the subsequent hard forced landing after takeoff. Contributing factors were the fence, trees, and pilot's maneuver to avoid these objects.
- [NTSB NYC00LA065](https://openairdocs.org/ntsb/NYC00LA065.md): Piper PA-32R-301T · Harpswell, ME · Accident · No injuries · Limited investigation · Final report · Jan 9, 2000 · N8463X · Substantial damage
  > was the improper decision of the pilot to depart at night, from an unlighted runway with no visual references to obstructions on the sides of the runway. Factors were the dark night conditions, and the lack of runway side lights.
- [NTSB DEN00LA035](https://openairdocs.org/ntsb/DEN00LA035.md): Piper PA-22-160 · Brighton, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 1999 · N9225D · Substantial damage
  > The pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.
- [NTSB DEN00LA034](https://openairdocs.org/ntsb/DEN00LA034.md): Price Glasair 1-RG · Ruidoso, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 1999 · N1190D · Substantial damage
  > The failure of the pilot to perform an adequate preflight, and the subsequent partial power loss as a result of water contamination in the fuel. A factor was the lack of suitable terrain for a forced landing.
- [NTSB FTW00LA054](https://openairdocs.org/ntsb/FTW00LA054.md): Cessna 150H · Sinton, TX · Accident · No injuries · Limited investigation · Final report · Dec 27, 1999 · N7290S · Substantial damage
  > The pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX00LA057](https://openairdocs.org/ntsb/LAX00LA057.md): Luscombe 8A · Gualala, CA · Accident · No injuries · Limited investigation · Final report · Dec 26, 1999 · N45886 · Substantial damage
  > The student pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall/mush and a collision with the ground.
- [NTSB ANC00LA021](https://openairdocs.org/ntsb/ANC00LA021.md): Cessna T207A · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1999 · N1864 · Substantial damage
  > The pilot's failure to remove frost from the airplane prior to flight, and an inadvertent stall/mush.
- [NTSB SEA00FA033](https://openairdocs.org/ntsb/SEA00FA033.md): Beech 95-B55 · Hermiston, OR · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1999 · N8129R · Destroyed
  > The pilot's failure to maintain clearance with terrain. Factors include a dark night, low ceilings and mist.
- [NTSB NYC00LA056](https://openairdocs.org/ntsb/NYC00LA056.md): Cessna 182P · Port Clinton, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1999 · N1545M · Substantial damage
  > Loss of engine power caused by ice crystal blockage of the fuel system.
- [NTSB MIA00FA058](https://openairdocs.org/ntsb/MIA00FA058.md): Aero Commander 500 · Georgetown, SC · Accident · 2 fatal · Field investigation · Final report · Dec 22, 1999 · N6261B · Destroyed
  > The noninstrument-rated pilot's improper decision to attempt VFR flight into known instrument flight conditions, willful disregard of FAA Automated Flight Service Station weather forecast/weather observations, failure to maintain airspeed (VSO) while…
- [NTSB ATL00FA016](https://openairdocs.org/ntsb/ATL00FA016.md): Piper PA-32RT-300 · Geneva, AL · Accident · 2 fatal · Field investigation · Final report · Dec 17, 1999 · N2215U · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.
- [NTSB DEN00LA030](https://openairdocs.org/ntsb/DEN00LA030.md): Piper PA-31T1 · Santa Fe, NM · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 1999 · N919RD · Substantial damage
  > The pilot initiating lift off at an airspeed insufficient to maintain flight and retracting the landing gear prematurely resulting in a stall mush. A factor was the pilot incorrectly setting the elevator trim.
- [NTSB NYC00LA052](https://openairdocs.org/ntsb/NYC00LA052.md): Cessna P210N · Greenwood, DE · Accident · No injuries · Limited investigation · Final report · Dec 15, 1999 · N450M · Substantial damage
  > the failure of the pilot to use full power for takeoff, which resulted in not obtaining a positive rate of climb and the inadvertent collision with trees. A factor was the fog.
- [NTSB NYC00LA051](https://openairdocs.org/ntsb/NYC00LA051.md): Piper PA-22-108 · Wales, ME · Accident · No injuries · Limited investigation · Final report · Dec 12, 1999 · N5279Z · Substantial damage
  > Fuel exhaustion due to a blocked fuel feed line.
- [NTSB IAD00LA013](https://openairdocs.org/ntsb/IAD00LA013.md): Rogers RAF 2000 · Franklin, NY · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 1999 · N78ME · Substantial damage
  > was the pilot's failure to abort the takeoff due to inadequate rotor rpm.
- [NTSB NYC00LA050](https://openairdocs.org/ntsb/NYC00LA050.md): Mooney M20-C · Reading, PA · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1999 · N6715U · Substantial damage
  > The failure of the number two connecting rod after an improper overhaul by maintenance personnel.
- [NTSB CHI00FA039](https://openairdocs.org/ntsb/CHI00FA039.md): Cessna 310N · Danville, IL · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1999 · N5038Q · Destroyed
  > Aircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…
- [NTSB MIA00LA044](https://openairdocs.org/ntsb/MIA00LA044.md): American AA-5 · St. Elmo, AL · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 1999 · N5864L · Substantial damage
  > The failure of the pilot to maintain airspeed resulting in the in-flight loss of control while maneuvering for a forced landing in a field after the loss of engine power. Contributing factors were the loss of engine power due to water-contaminated fuel.
- [NTSB DEN00IA023](https://openairdocs.org/ntsb/DEN00IA023.md): Boeing 767-232 · Salt Lake City, UT · Incident · No injuries · Incident investigation · Final report · Dec 6, 1999 · N111DN · Minor damage
  > Total failure of the main landing gear retract actuator due to stress corrosion caused by the use of a faulty sealant by company maintenance personnel that allowed moisture to enter the joint. A factor was the use of an improper fillet seal.
- [NTSB ANC00LA017](https://openairdocs.org/ntsb/ANC00LA017.md): Cessna 208B · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Dec 6, 1999 · N5187B · Substantial damage
  > The pilot's inadequate preflight and his failure to remove snow and airframe ice from the airplane.
- [NTSB ANC00LA016](https://openairdocs.org/ntsb/ANC00LA016.md): Taylorcraft F-19 · Skwentna, AK · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 1999 · N3719T · Substantial damage
  > The pilot's selection of an unsuitable landing/takeoff area. Factors associated with the accident were snow-covered terrain, and a tree.
- [NTSB LAX00LA044](https://openairdocs.org/ntsb/LAX00LA044.md): Cessna 152 · Surprise, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 1999 · N48WT · Substantial damage
  > The pilot's failure to attain and maintain an adequate airspeed during takeoff from a short and unimproved dirt road, which resulted in an inadvertent stall/mush condition and impact with the ground.
- [NTSB DEN00FA021](https://openairdocs.org/ntsb/DEN00FA021.md): Piper PA-18-125 · Afton, WY · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1999 · N1132A · Destroyed
  > Failure of the pilot to remove frost from the wings prior to takeoff, causing an inadvertent stall/spin on initial climbout. Factors included exceeding the aircraft's certificated gross weight, and fog conditions.
- [NTSB ANC00LA014](https://openairdocs.org/ntsb/ANC00LA014.md): Cessna 150K · Juneau, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 1999 · N5730G · Substantial damage
  > An inadvertent stall. Factors in the accident were the instructor pilot's excessive angle of climb, and gusty wind conditions.
- [NTSB LAX00LA034](https://openairdocs.org/ntsb/LAX00LA034.md): Hawker Siddeley Hunter T MK 7 · Mesa, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1999 · N576NL · Substantial damage
  > The fatigue failure and separation the stage 3 compressor blades due to corrosion pitting of the blade retention lug bores. A factor in the accident was the failure of the various post military surplus operators of this engine to incorporate the…
- [NTSB ANC00LA015](https://openairdocs.org/ntsb/ANC00LA015.md): Cessna 207A · Dillingham, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1999 · N9933M · Substantial damage
  > Failure of the pilot to remove frost from the wings prior to flight, and the resulting inadvertent stall/mush.
- [NTSB ANC00LA013](https://openairdocs.org/ntsb/ANC00LA013.md): Maule M7-235C · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Nov 15, 1999 · N5657A · Substantial damage
  > The pilot's intentional takeoff into known adverse weather. Factors associated with this accident are crosswinds, gusts, and downdrafts.
- [NTSB ATL00LA014](https://openairdocs.org/ntsb/ATL00LA014.md): Champion 7ECA · Ridgeland, SC · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1999 · N2570F · Substantial damage
  > The pilot's failure to obtain/maintain adequate airspeed during the takeoff/initial climb which resulted in an inadvertent stall and subsequent collision with terrain.
- [NTSB IAD00LA005](https://openairdocs.org/ntsb/IAD00LA005.md): Ankenbruck SEA Hawk · Somerset, PA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1999 · N101WR · Substantial damage
  > The pilot's improper preflight which resulted in a loss of power due to contaminated fuel, and the pilot's failure to maintain aircraft control after the loss of power. A factor in the accident was fuel contamination.

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

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

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