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

## Cases, newest first

- [NTSB ATL92LA051](https://openairdocs.org/ntsb/ATL92LA051.md): Cessna 172I · Bainbridge, GA · Accident · No injuries · Limited investigation · Final report · Mar 1, 1992 · N35637 · Substantial damage
  > The pilot's failure to maintain airspeed on the initial climbout, and the inadvertent stall/mush which resulted. Factors in this accident were: the high obstructions (trees) near the airstrip.
- [NTSB LAX92FA130](https://openairdocs.org/ntsb/LAX92FA130.md): Cessna 150M · San Ysidro, CA · Accident · 2 fatal · Field investigation · Final report · Feb 29, 1992 · N45165 · Destroyed
  > The certified flight instructor's improper supervision of the flight to correct the student pilot's improper use of the flight controls resulting in an excessive angle of attack and failure to maintain the proper airspeed. Contributing to this accident was…
- [NTSB ANC92LA042](https://openairdocs.org/ntsb/ANC92LA042.md): Piper PA-18A-135 · Paxson, AK · Accident · No injuries · Limited investigation · Final report · Feb 29, 1992 · N3372B · Substantial damage
  > The pilot failed to attain & maintain takeoff airspeed. Factors to the accident were: takeoff was performed with a tailwind, and inadequate remedial action.
- [NTSB LAX92LA126](https://openairdocs.org/ntsb/LAX92LA126.md): Grumman G-164B · Dixon, CA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1992 · N3633C · Substantial damage
  > The pilot's premature lift-off. Contributing to the accident was the inadvertent stall/mush and the soft dirt airstrip.
- [NTSB NYC92LA065](https://openairdocs.org/ntsb/NYC92LA065.md): Cessna 305A · Plymouth, MA · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 1992 · N234BD · Substantial damage
  > The failure of the pilot to use carburetor heat which resulted in the formation of carburetor ice and a subsequent loss of engine power and forced landing in trees.
- [NTSB LAX92LA124](https://openairdocs.org/ntsb/LAX92LA124.md): Cessna 150 · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 1992 · N126NK · Destroyed
  > That the certified flight instructor's (CFI) misjudged approach which resulted in a long landing, the cfi's in-flight decision to a go-around with partial power, and the failure of the CFI to maintain aircraft control in the initial climb segment of the…
- [NTSB FTW92LA072](https://openairdocs.org/ntsb/FTW92LA072.md): Ryan Navion A · Oklahoma City, OK · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 1992 · N39JH · Substantial damage
  > The propeller hydraulic control pitch setting being incorrect for undetermined reasons. A factor in the accident was the pilot's failure to identify and correct the pitch setting as the propeller went to a higher setting.
- [NTSB DEN92LA037](https://openairdocs.org/ntsb/DEN92LA037.md): Cessna 177RG · Durango, CO · Accident · No injuries · Limited investigation · Final report · Feb 23, 1992 · N2550V · Substantial damage
  > A total loss of power due to a mechanical failure of the engine. Factors were: rough and uneven snow covered terrain.
- [NTSB ANC92LA039](https://openairdocs.org/ntsb/ANC92LA039.md): Cessna 185F · Pelican, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1992 · N4948Q · Substantial damage
  > The pilot's inadequate visual lookout during takeoff. Contributing to the accident was the glare from the sun.
- [NTSB MIA92LA088](https://openairdocs.org/ntsb/MIA92LA088.md): Beech E-55 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Feb 16, 1992 · N3011W · Substantial damage
  > Failure of the pilot to attain the proper airspeed (vhc) before rotation which resulted in failure to maintain directional control following total loss of engine power from the right engine. Contributing to the accident was failure of the right engine, engine…
- [NTSB SEA92LA047](https://openairdocs.org/ntsb/SEA92LA047.md): Kna,Ken,Dac,Wel Tern Sailplane · Cottage Grove, OR · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 1992 · N8000Z · Destroyed
  > The pilot's inadequate preflight of the sailplane. Factors contributing to the accident were improper tow equipment and lack of total glider experience.
- [NTSB NYC92LA060](https://openairdocs.org/ntsb/NYC92LA060.md): Piper PA-22-20 · Isle Au Haut, ME · Accident · Serious injuries · Limited investigation · Final report · Feb 15, 1992 · N36142 · Substantial damage
  > Fuel system icing and contamination which resulted in a loss of engine power and subsequent stall and loss of control during a forced landing.
- [NTSB LAX92LA117](https://openairdocs.org/ntsb/LAX92LA117.md): Cessna 152 · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Feb 14, 1992 · N48360 · Destroyed
  > The total loss of engine power due to undetermined reason(s). A factor in this accident was the soft soil the airplane encountered during landing roll which caused the airplane to nose over.
- [NTSB MIA92IA081](https://openairdocs.org/ntsb/MIA92IA081.md): Boeing 727-214A · San Juan, PR · Incident · No injuries · Incident investigation · Final report · Feb 9, 1992 · N752US · Minor damage
  > The flight engineer's lack of training in emergency procedures and his failure to follow published emergency procedures, resulting in his not being able to manually extend the right main landing gear, following the loss of the 'a' hydraulic system.…
- [NTSB LAX92LA113](https://openairdocs.org/ntsb/LAX92LA113.md): Cessna 150M · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Feb 9, 1992 · N9312U · Substantial damage
  > Fuel exhaustion due to the instructor pilot's failure to refuel the aircraft.
- [NTSB LAX92LA107](https://openairdocs.org/ntsb/LAX92LA107.md): Cessna 150D · Carson City, NV · Accident · No injuries · Limited investigation · Final report · Feb 3, 1992 · N6002T · Substantial damage
  > The pilot's premature liftoff which resulted in a stall mush.
- [NTSB DEN92LA029](https://openairdocs.org/ntsb/DEN92LA029.md): Warfield BD-4 · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 1992 · N689W · Destroyed
  > Improper vr speed used, causing an inadvertent stall/mush. A factor was: the pilot's lack of total experience in aircraft make and model.
- [NTSB CHI92FA084](https://openairdocs.org/ntsb/CHI92FA084.md): Piper PA-31T · Swanton, OH · Accident · 3 fatal · Field investigation · Final report · Jan 31, 1992 · N6038A · Destroyed
  > Loss of aircraft control for an undetermined reason.
- [NTSB BFO92LA028](https://openairdocs.org/ntsb/BFO92LA028.md): Piper PA-46 · Baltimore, MD · Accident · No injuries · Limited investigation · Final report · Jan 30, 1992 · N9103Q · Substantial damage
  > The failure of the fuel line, for undetermined reasons, resulting in a fuel leak causing an engine fire and total power loss.
- [NTSB FTW92FA061](https://openairdocs.org/ntsb/FTW92FA061.md): Bellanca 17-30 · Oklahoma City, OK · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1992 · N4869V · Substantial damage
  > The second pilot's (left seat) failure to attain a positive rate-of-climb during an instrument takeoff, and inadequate supervision by the pilot-in-command. Factors were: the weather, and the copilot's lack of instrument flight time and training.
- [NTSB DEN92LA027](https://openairdocs.org/ntsb/DEN92LA027.md): Cessna 172P · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jan 27, 1992 · N52872 · Substantial damage
  > A loss of control due to the pilot's failure to follow proper soft field takeoff procedures by flying out of ground effect at an inadequate airspeed. A factor was the pilot's improper use of flaps.
- [NTSB BFO92FA025](https://openairdocs.org/ntsb/BFO92FA025.md): Beech V35B · Manassas, VA · Accident · 1 fatal · Field investigation · Final report · Jan 26, 1992 · N3738A · Destroyed
  > The pilot's failure to remove ice from the wings during the preflight inspection which resulted in a stall during takeoff due to ice on the wings.
- [NTSB LAX92LA100](https://openairdocs.org/ntsb/LAX92LA100.md): James Houston KR2 · Chandler, AZ · Accident · Serious injuries · Limited investigation · Final report · Jan 24, 1992 · N87JJ · Destroyed
  > The pilot's improper emergency procedures, misjudging the airplane's altitude, failure to attain the proper touchdown point and excessive airspeed. Contributing to this accident was an undetermined loss of power and the pilot's lack of familiarity with the…
- [NTSB FTW92LA059](https://openairdocs.org/ntsb/FTW92LA059.md): Piper PA-28-140 · Denton, TX · Accident · No injuries · Limited investigation · Final report · Jan 22, 1992 · N107EH · Substantial damage
  > Fouled spark plugs, loose spark plug ignition lead, exhaust leak, and cylinder leak. Factors were an inadequate annual inspection, poor maintenance, and operation by the pilot with known mechanical deficiencies.
- [NTSB LAX92LA097](https://openairdocs.org/ntsb/LAX92LA097.md): Cessna 120 · Sonoma, CA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1992 · N3010N · Substantial damage
  > Engine failure due to a binding mixture control shaft. The binding mixture control shaft was the result of inadequate maintenance which allowed the accumulation of moisture and water in the carburetor to remain for an extended period of time causing rust and…
- [NTSB LAX92FA094](https://openairdocs.org/ntsb/LAX92FA094.md): Mooney M-20-C · Santa Monica, CA · Accident · 2 fatal · Field investigation · Final report · Jan 19, 1992 · N6481U · Destroyed
  > Fuel contamination by water due to the; 1) failure of the fuel caps to properly seal against water ingestion, 2) the pilots failure to adequately perform a preflight inspection of the aircraft sufficient to detect the presence of water in the fuel tanks.…
- [NTSB CHI93LA381](https://openairdocs.org/ntsb/CHI93LA381.md): Cessna 172 · Union Center, SD · Accident · No injuries · Limited investigation · Final report · Jan 19, 1992 · N8529U · Substantial damage
  > Improper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.
- [NTSB CHI92LA073](https://openairdocs.org/ntsb/CHI92LA073.md): Cessna 177RG · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jan 18, 1992 · N8013G · Substantial damage
  > Engine loss of power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.
- [NTSB ATL92FA040](https://openairdocs.org/ntsb/ATL92FA040.md): Cessna 140 · Columbia, SC · Accident · 2 fatal · Field investigation · Final report · Jan 16, 1992 · N1976N · Substantial damage
  > The pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…
- [NTSB BFO92LA019](https://openairdocs.org/ntsb/BFO92LA019.md): Piper PA-46-350P · Bowling Green, KY · Accident · No injuries · Limited investigation · Final report · Jan 13, 1992 · N9161K · Substantial damage
  > The pilot's premature flare, stalling the airplane which resulted in a hard landing. Factors related to the accident were the dual fuel flow gauge failures and deteriorating weather conditions.
- [NTSB BFO92IA017](https://openairdocs.org/ntsb/BFO92IA017.md): de Havilland DHC-8-102 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Jan 12, 1992 · N923HA · Minor damage
  > Improper installation of the low fuel pressure warning switch snubber on the #1 engine, resulting in fatigue failure of the snubber, a fuel leak (spray), and subsequent explosion/fire damage. A factor related to the incident was: inadequate design of the…
- [NTSB ATL92LA036](https://openairdocs.org/ntsb/ATL92LA036.md): Mosley HS GN-1 · Cullman, AL · Accident · Serious injuries · Limited investigation · Final report · Jan 11, 1992 · N3202F · Substantial damage
  > The pilot's failure to maintain a safe flying speed.
- [NTSB FTW92IA055](https://openairdocs.org/ntsb/FTW92IA055.md): Boeing 737-232 · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Jan 7, 1992 · N322DL · Minor damage
  > The failure of the aft cone bolt as result of preexisting fatigue cracking due to improper maintenance, and the failure of the secondary support structure as a result of loads that exceeded the capacity of the attaching hardware and the crushable honeycomb…
- [NTSB BFO92LA021](https://openairdocs.org/ntsb/BFO92LA021.md): Piper PA-32R-300 · Edgartown, MA · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 1992 · N38781 · Destroyed
  > Failure of the pilot to attain adequate airspeed, which resulted in a stall. Factors related to the accident were the crosswind, the pilot's inadequate compensation for the wind and failure to maintain proper alignment with the runway, and high obstructions.
- [NTSB LAX92LA080](https://openairdocs.org/ntsb/LAX92LA080.md): Cessna 150L · Fresno, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 4, 1992 · N10828 · Substantial damage
  > The improper major repair of the carburetor heat control by unidentified persons that resulted the failure of the air intake distribution system and the loss of engine power.
- [NTSB LAX92FA078](https://openairdocs.org/ntsb/LAX92FA078.md): Cessna 182R · Flagstaff, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 3, 1992 · N5485N · Destroyed
  > The pilot became spatially disoriented and lost control of the airplane as he turned away from ground lights toward unlighted terrain. The clouds, fog, and dark night condition were factors.
- [NTSB FTW92LA053](https://openairdocs.org/ntsb/FTW92LA053.md): Beech B19 · Bonham, TX · Accident · No injuries · Limited investigation · Final report · Jan 3, 1992 · N2226L · Substantial damage
  > Inadvertent stall during the forced landing approach. A factor was the partial loss of power for undetermined reasons.
- [NTSB ANC92LA060](https://openairdocs.org/ntsb/ANC92LA060.md): De Havilland DHC-2 · Port Walter, AK · Accident · No injuries · Limited investigation · Final report · Jan 2, 1992 · N64396 · Substantial damage
  > The design stress limits of the airplane were exceeded. A factor to the accident was: rough water.
- [NTSB FTW92LA050](https://openairdocs.org/ntsb/FTW92LA050.md): Beech 95-C55 · Tyler, TX · Accident · No injuries · Limited investigation · Final report · Dec 29, 1991 · N111RV · Substantial damage
  > The pilot's failure to feather the propeller and maintain directional control. Factors were the lose of power on one engine for undetermined reasons and the soft terrain.
- [NTSB NYC92LA051](https://openairdocs.org/ntsb/NYC92LA051.md): Piper PA-24-260C · Stratford, CT · Accident · Serious injuries · Limited investigation · Final report · Dec 26, 1991 · N9423P · Destroyed
  > Water/ice in the fuel system, which resulted in fuel starvation and a loss of engine power. Factors related to the accident were: freezing temperatures and inadequate pre-flight preparation by the pilot.
- [NTSB DEN92FA020](https://openairdocs.org/ntsb/DEN92FA020.md): Grumman American AA-5A · Monte Vista, CO · Accident · 3 fatal · Field investigation · Final report · Dec 25, 1991 · N9991U · Destroyed
  > An inadvertent stall by the pilot in command at an altitude insufficient to effect recovery. Factors were: aircraft gross weight above maximum; physical impairment of the pilot; lack of total experience; lack of recent experience; and lack of experience in…
- [NTSB MIA92LA050](https://openairdocs.org/ntsb/MIA92LA050.md): Mooney M-20C · Plant City, FL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1991 · N7866V · Substantial damage
  > Total loss of engine power (nonmechanical) for undetermined reasons. This resulted in a forced landing to an unsuitable landing area and collision with terrain.
- [NTSB DEN92LA017](https://openairdocs.org/ntsb/DEN92LA017.md): Stinson 108-1 · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1991 · N97962 · Destroyed
  > A loss of engine power due to fouled spark plugs. The inadequate maintenance of the engine was a factor in the accident.
- [NTSB ANC92LA021](https://openairdocs.org/ntsb/ANC92LA021.md): Piper PA-18 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Dec 20, 1991 · N8678D · Substantial damage
  > Engine failure due to fuel contamination. Contributing to the accident was unsuitable terrain.
- [NTSB ANC92LA019](https://openairdocs.org/ntsb/ANC92LA019.md): Cessna 185 · Ketchikan, AK · Accident · 1 fatal · Limited investigation · Final report · Dec 14, 1991 · N2212T · Substantial damage
  > An inadvertent stall while maneuvering for a precautionary landing. Factors include a partial loss of engine power for undetermined reasons, and inadequate altitude for the maneuver.
- [NTSB MIA92LA047](https://openairdocs.org/ntsb/MIA92LA047.md): Cessna 150M · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Dec 13, 1991 · N3767V · Substantial damage
  > Total loss of engine power during the initial climb due to fuel starvation as a result of the pilot's failure to perform an adequate preflight to determine the quantity of fuel on board.
- [NTSB NYC92LA041](https://openairdocs.org/ntsb/NYC92LA041.md): Cessna 150 · Gansevoort, NY · Accident · No injuries · Limited investigation · Final report · Dec 12, 1991 · N1404Q · Substantial damage
  > The pilot's improperly planned approach, resulting in a landing on an icy runway at excessive speed; and unable to stop on the available runway and subsequent collision with trees. Factors related to the accident were the pilot's failure to obtain a weather…
- [NTSB LAX92LA062](https://openairdocs.org/ntsb/LAX92LA062.md): Cessna 210M · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1991 · N761VB · Substantial damage
  > An engine power loss due to a partial blockage of the fuel selector valve with debris.
- [NTSB CHI92LA052](https://openairdocs.org/ntsb/CHI92LA052.md): Cessna 172 · Carlyle, IL · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 1991 · N8316X · Substantial damage
  > Fuel contamination and blockage of the carburetor, which restuled in fuel starvation. The high obstructions (trees) were a related factor.
- [NTSB CHI92LA048](https://openairdocs.org/ntsb/CHI92LA048.md): Beech A36 · Rensselaer, IN · Accident · 1 fatal · Limited investigation · Final report · Dec 10, 1991 · N61054 · Destroyed
  > The pilot's improper aircraft handling which resulted in an inadvertent stall and descent. Factors related to the accident were the obscuration & icing conditions.

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

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

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