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

## Cases, newest first

- [NTSB ANC97FA002](https://openairdocs.org/ntsb/ANC97FA002.md): Piper PA-18 · Palmer, AK · Accident · 1 fatal · Field investigation · Final report · Oct 2, 1996 · N64RS · Destroyed
  > the pilot's inadequate compensation for wind conditions and failure to maintain adequate airspeed, which resulted in an inadvertent stall. The unfavorable wind condition was a related factor.
- [NTSB IAD96LA155](https://openairdocs.org/ntsb/IAD96LA155.md): Merritt Acro Sport II · Cumberland, MD · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 1996 · N30803 · Substantial damage
  > The pilot's failure to select the electric fuel boost pump during take off which resulted in loss of engine power due to fuel starvation and the subsequent forced landing. A factor to this accident was the owner/builder alteration of the fuel system by…
- [NTSB FTW96LA404](https://openairdocs.org/ntsb/FTW96LA404.md): Republic RC-3 · Santa Fe, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 1996 · N6103K · Substantial damage
  > The pilot's failure to obtain/maintain airspeed resulting in an inadvertent stall/mush. Factors were the high density altitude and the lack of suitable terrain for the landing.
- [NTSB NYC96LA188](https://openairdocs.org/ntsb/NYC96LA188.md): Mitsubishi MU-2B-30 · Chillicothe, OH · Accident · No injuries · Limited investigation · Final report · Sep 28, 1996 · N618BB · Substantial damage
  > failure of the pilot to follow the published emergency procedures after loss of power in the left engine. Factors relating to the accident were: fatigue failure of the left torque sensor and gear assembly, which resulted in the loss of engine power, failure…
- [NTSB FTW96LA403](https://openairdocs.org/ntsb/FTW96LA403.md): Piper PA-30 · Watkins, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1996 · N37P · Substantial damage
  > the pilot-in-command's failure to use proper procedures and engage the turbochargers for takeoff from a high altitude airport. A factor was the high density altitude.
- [NTSB NYC97LA084](https://openairdocs.org/ntsb/NYC97LA084.md): Schempp-Hirth CIRRUS-S · Wadsworth, OH · Accident · No injuries · Limited investigation · Final report · Sep 25, 1996 · N9775 · Substantial damage
  > The pilot's inadvertent activation of the speed brakes while being towed for takeoff. Subsequently, the glider pilot lost sight of the tow airplane due to excessive altitude, released the tow rope, and performed an off airport landing during which the glider…
- [NTSB ANC96TA163](https://openairdocs.org/ntsb/ANC96TA163.md): de Havilland U-6A · King Salmon, AK · Accident · Serious injuries · Final report · Sep 24, 1996 · N67207 · Substantial damage
  > failure of the pilot to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain (water). Turbulence was a related factor.
- [NTSB ANC96FA162](https://openairdocs.org/ntsb/ANC96FA162.md): Cessna 206G · Anchorage, AK · Accident · 3 fatal · Field investigation · Final report · Sep 24, 1996 · N7312C · Destroyed
  > improper installation of a connecting bolt in the throttle linkage, which resulted in a worn/disconnected throttle arm, partial loss of engine power, and a forced landing after takeoff.
- [NTSB NYC96LA186](https://openairdocs.org/ntsb/NYC96LA186.md): Mooney M20K · Islip, NY · Accident · No injuries · Limited investigation · Final report · Sep 21, 1996 · N3375X · Substantial damage
  > loss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.
- [NTSB FTW96LA393](https://openairdocs.org/ntsb/FTW96LA393.md): Cessna 177RG · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Sep 21, 1996 · N7568V · Substantial damage
  > Failure of the flight instructor to maintain airspeed above stall speed during initial climb and loss of control on the ground after aborting the takeoff. Factors were inadequate preflight planning and preparation, inaccurate weather evaluation, and high…
- [NTSB NYC96LA187](https://openairdocs.org/ntsb/NYC96LA187.md): Cessna 180K · Derry, NH · Accident · No injuries · Limited investigation · Final report · Sep 20, 1996 · N2738K · Substantial damage
  > the pilot's inadequate preflight inspection, which failed to detect water contaminated fuel, and resulted in a loss of engine power. A factor relating to the accident was: the pilot's operation of the aircraft with a known deficiency that consisted of a fuel…
- [NTSB FTW96LA392](https://openairdocs.org/ntsb/FTW96LA392.md): Beech H35 · Boulder, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1996 · N5428D · Substantial damage
  > a loss of engine power due to a plugged fuel tank vent which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA388](https://openairdocs.org/ntsb/FTW96LA388.md): Schweizer G-164B · Ferriday, LA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1996 · N8498K · Substantial damage
  > The partial loss of engine power due to a cracked cylinder head. Factors were the oil leak which restricted the pilot's visual lookout and the lack of suitable terrain for the forced landing.
- [NTSB MIA96LA231](https://openairdocs.org/ntsb/MIA96LA231.md): Piper PA-22-108 · Pensacola, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1996 · N984WB · Substantial damage
  > loss of engine power during the initial climb due to contamination in the carburetor. Trees in the emergency landing area were a related factor.
- [NTSB ANC96LA155](https://openairdocs.org/ntsb/ANC96LA155.md): Champion 7GCBC · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1996 · N9033L · Substantial damage
  > the pilot's improper planning/decision. Related factors were: the terrain condition, unfavorable (lee-side) wind, and trees.
- [NTSB MIA96FA229](https://openairdocs.org/ntsb/MIA96FA229.md): Aero Commander 680E · Lakeland, FL · Accident · 1 fatal · Field investigation · Final report · Sep 10, 1996 · N262X · Destroyed
  > failure of the pilot to maintain minimum control speed, while returning to the airport for a precautionary landing, following a reported loss of power in one engine, which resulted in a loss of aircraft control and an uncontrolled collision with the terrain.…
- [NTSB ANC96LA151](https://openairdocs.org/ntsb/ANC96LA151.md): Cessna 150 · Willow, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1996 · N7909Z · Substantial damage
  > The loss of engine power for an undetermined reason. Factors associated with the accident are the soft terrain and brush in the airstrip overrun area.
- [NTSB LAX96LA329](https://openairdocs.org/ntsb/LAX96LA329.md): Stinson 108 · Quincy, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 1996 · N97337 · Substantial damage
  > the pilot's over leaning of the fuel mixture, which resulted in the initial loss of engine power; and continued fuel starvation, resulting from the pilot's inadvertent mispositioning of the fuel selector valve during an attempted restart of the engine.
- [NTSB FTW96LA379](https://openairdocs.org/ntsb/FTW96LA379.md): Piper PA-18 · Palestine, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1996 · N7467D · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff.
- [NTSB FTW96LA382](https://openairdocs.org/ntsb/FTW96LA382.md): Champion 7GCBC · Edgewood, NM · Accident · No injuries · Limited investigation · Final report · Sep 7, 1996 · N9071L · Substantial damage
  > The pilot's failure to maintain aircraft control. A factor was a whirlwind.
- [NTSB CHI96LA328](https://openairdocs.org/ntsb/CHI96LA328.md): Cessna 182P · Cahokia, IL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1996 · N6590M · Substantial damage
  > the pilot misjudged his planned approach during the precautionary landing and the failed to obtain a proper touchdown point. Factors relating to the accident were: the loose oil filler cap, the uneven terrain on which the landing was made, the runway lights…
- [NTSB CHI96FA327](https://openairdocs.org/ntsb/CHI96FA327.md): Beech 23 · Tomahawk, WI · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1996 · N2338Z · Destroyed
  > the student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.
- [NTSB ANC96LA146](https://openairdocs.org/ntsb/ANC96LA146.md): Bellanca 8GCBC · Iliamna, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1996 · N8648V · Destroyed
  > the pilot's inadequate weather evaluation and inadequate compensation for wind conditions. The adverse weather condition was a related factor.
- [NTSB CHI96FA330](https://openairdocs.org/ntsb/CHI96FA330.md): Green Castle Avid Flyer Aerobat · Oxford, IA · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1996 · N95GC · Destroyed
  > failure of the private pilot to maintain sufficient airspeed after takeoff, during the initial climb and turn to the crosswind leg; and a delay by the flight instructor (CFI) in taking remedial action to avoid a stall.
- [NTSB ANC96LA142](https://openairdocs.org/ntsb/ANC96LA142.md): Cessna 206 · Port Alsworth, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 3, 1996 · N1801Q · Substantial damage
  > The pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the unfavorable wind.
- [NTSB CHI96FA324](https://openairdocs.org/ntsb/CHI96FA324.md): Piper PA-28-180 · Grosse Ile, MI · Accident · 2 fatal · Field investigation · Final report · Sep 2, 1996 · N7082W · Substantial damage
  > the pilot exceeding the critical angle of bank required to maintain altitude.
- [NTSB SEA96LA206](https://openairdocs.org/ntsb/SEA96LA206.md): Piper PA-22-108 · Ashland, OR · Accident · No injuries · Limited investigation · Final report · Aug 30, 1996 · N4992Z · Destroyed
  > inadequate inspection of the airplane by maintenance personnel,and a worn exhaust clamp, which resulted in a disconnected exhaust pipe, exhaust leak, burning and shorting of electrical wiring associated with the voltage regulator, and a cabin fire.
- [NTSB IAD96LA140](https://openairdocs.org/ntsb/IAD96LA140.md): Aeronca 7AC · Frederick, MD · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1996 · N81543 · Substantial damage
  > the pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain.
- [NTSB IAD96LA139](https://openairdocs.org/ntsb/IAD96LA139.md): American AA-5 · Annapolis, MD · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1996 · N9525L · Substantial damage
  > failure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall and subsequent collision with water.
- [NTSB SEA96LA199](https://openairdocs.org/ntsb/SEA96LA199.md): Piper PA-38-112 · Sisters, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 1996 · N2465K · Substantial damage
  > inadequate preflight planning/preparation by the flight instructor (CFI), and his failure to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall. Excessive gross weight, high density altitude, and improper use of flaps were…
- [NTSB SEA96LA196](https://openairdocs.org/ntsb/SEA96LA196.md): Westcott Glasair I-FT · Puyallup, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1996 · N289W · Substantial damage
  > failure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.
- [NTSB IAD96FA138](https://openairdocs.org/ntsb/IAD96FA138.md): Piper PA-24-180 · Whitefield, NH · Accident · 4 fatal · Field investigation · Final report · Aug 20, 1996 · N7635P · Destroyed
  > the pilot's failure to adequately preflight the aircraft which led to the loss of engine power due to fuel exhaustion, and the pilot's attempt to return to the airport by executing a steep left turn which led to a stall and subsequent loss of control of the…
- [NTSB FTW96LA353](https://openairdocs.org/ntsb/FTW96LA353.md): Piper PA-36-300 · Hale Center, TX · Accident · No injuries · Limited investigation · Final report · Aug 20, 1996 · N57831 · Substantial damage
  > the pilot's inadequate preflight planning/preparation and failure to obtain and/or maintain adequate airspeed after takeoff, which resulted in an inadvertent stall/mush. The overweight condition of the airplane and high density altitude were related factors.
- [NTSB CHI96LA308](https://openairdocs.org/ntsb/CHI96LA308.md): Piper J3C-65 · Grosse Ile, MI · Accident · No injuries · Limited investigation · Final report · Aug 20, 1996 · N3607N · Substantial damage
  > improper attachment of the flight control cables to the ailerons by the mechanic who performed the last annual inspection. A factor relating to this accident was the pilot's failure to perform an adequate check of the flight controls before takeoff.
- [NTSB FTW96LA351](https://openairdocs.org/ntsb/FTW96LA351.md): Cessna A185F · Midland, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 1996 · N61609 · Substantial damage
  > failure of the pilot to obtain or maintain adequate airspeed, by allowing the airplane to enter an excessive nose high attitude and an excessive rate of climb after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain. A…
- [NTSB SEA96LA194](https://openairdocs.org/ntsb/SEA96LA194.md): Piper PA-20 · Mulino, OR · Accident · No injuries · Limited investigation · Final report · Aug 18, 1996 · N150KS · Substantial damage
  > loss of engine power for undetermined reason(s).
- [NTSB IAD96LA137](https://openairdocs.org/ntsb/IAD96LA137.md): Bellanca 8KCAB · Waterford, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1996 · N88428 · Substantial damage
  > the pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.
- [NTSB MIA96LA214](https://openairdocs.org/ntsb/MIA96LA214.md): Cessna 150F · Plant City, FL · Accident · No injuries · Limited investigation · Final report · Aug 16, 1996 · N7053F · Substantial damage
  > a loss of engine power due to fuel contamination, resulting in a forced landing, and subsequent nose over. A factor in this accident was an inadequate aircraft pre-flight
- [NTSB ANC96LA129](https://openairdocs.org/ntsb/ANC96LA129.md): Piper PA-18 · Slana, AK · Accident · No injuries · Limited investigation · Final report · Aug 16, 1996 · N6760B · Substantial damage
  > The pilot's failure to maintain directional control during takeoff. A factor associated with the accident was the rough and uneven terrain.
- [NTSB CHI96LA298](https://openairdocs.org/ntsb/CHI96LA298.md): Piper PA-38 · Fairbury, NE · Accident · No injuries · Limited investigation · Final report · Aug 15, 1996 · N2538N · Substantial damage
  > inadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.
- [NTSB CHI96LA295](https://openairdocs.org/ntsb/CHI96LA295.md): Beech V35 · Custer, SD · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1996 · N2055V · Destroyed
  > loss of engine power for undetermined reason(s). The terrain condition beyond the end of the runway was a related factor.
- [NTSB LAX96LA306](https://openairdocs.org/ntsb/LAX96LA306.md): Cessna 172Q · Kayenta, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1996 · N65963 · Substantial damage
  > the pilot's failure to adhere to the manufacturer's performance data by not maintaining the recommended best rate of climb speed, resulting in an inadvertent stall/mush event. The high density altitude was a related factor.
- [NTSB ANC96LA124](https://openairdocs.org/ntsb/ANC96LA124.md): Piper PA-18 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Aug 14, 1996 · N7797B · Substantial damage
  > An engine failure due to an eroded engine piston. Factors in the accident were unsuitable terrain for a forced landing and improperly timed magnetos.
- [NTSB CHI96LA286](https://openairdocs.org/ntsb/CHI96LA286.md): Schuler T Bird II · Fond Du Lac, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 1996 · N31774 · Substantial damage
  > loss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.
- [NTSB IAD96FA132](https://openairdocs.org/ntsb/IAD96FA132.md): Cessna 172P · Summersville, WV · Accident · 3 fatal · Field investigation · Final report · Aug 11, 1996 · N65632 · Destroyed
  > The pilot's improper flare, his delay in aborting a landing, and his failure to maintain adequate airspeed, which resulted in a bounced landing and a stall during climb out in an attempt to avoid collision with trees.
- [NTSB CHI96LA288](https://openairdocs.org/ntsb/CHI96LA288.md): Beech 23 · Wilmot, WI · Accident · No injuries · Limited investigation · Final report · Aug 10, 1996 · N1823Q · Destroyed
  > improper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.
- [NTSB FTW96LA343](https://openairdocs.org/ntsb/FTW96LA343.md): Piper PA-28-180 · Midlothian, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1996 · N2559R · Substantial damage
  > maintenance personnel's improper engine overhaul procedures resulting in the installation of the rocker arms in reversed positions, which led to improper lubrication and binding of the exhaust valves. A related factor was the lack of suitable terrain for the…
- [NTSB LAX96LA299](https://openairdocs.org/ntsb/LAX96LA299.md): Grumman-Schweizer G-164A · Caruthers, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1996 · N8598H · Substantial damage
  > the loss of engine power due to the failure of a cylinder. The road's soft surface was a factor.
- [NTSB SEA96LA178](https://openairdocs.org/ntsb/SEA96LA178.md): Piper PA-12 · Astoria, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1996 · N2564M · Substantial damage
  > failure of the carburetor heat box flapper valve, and the resultant air flow restriction to the carburetor. A factor relating to the accident was: high vegetation in the area where the forced landing was executed.
- [NTSB ANC96LA119](https://openairdocs.org/ntsb/ANC96LA119.md): Aviat A-1 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Aug 5, 1996 · N54JK · Substantial damage
  > The pilot's inadequate weather evaluation, inadequate compensation for the existing wind conditions, and failure to maintain directional control. A factor associated with the accident was the gusty wind.

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

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

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