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

## Cases, newest first

- [NTSB LAX97LA146](https://openairdocs.org/ntsb/LAX97LA146.md): Cessna 170B · Furnace Creek, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1997 · N2294D · Substantial damage
  > Fuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.
- [NTSB IAD97LA061](https://openairdocs.org/ntsb/IAD97LA061.md): Theis Quickie · Fostoria, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1997 · N53ET · Substantial damage
  > a disconnect of electrical wires to the engine ignition, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: the lack of suitable terrain for a forced landing, and the wheat (crop) that was encountered during…
- [NTSB LAX97LA139](https://openairdocs.org/ntsb/LAX97LA139.md): Cessna 182F · Mokuleia, HI · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1997 · N3652U · Destroyed
  > An unintentional stall for undetermined reasons.
- [NTSB MIA97LA112](https://openairdocs.org/ntsb/MIA97LA112.md): Charles J. Keuthan Zephyr II · Bunnell, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1997 · N52958 · Substantial damage
  > Inadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.
- [NTSB MIA97LA105](https://openairdocs.org/ntsb/MIA97LA105.md): Cessna 172N · St Matthews, SC · Accident · No injuries · Limited investigation · Final report · Mar 31, 1997 · N738NC · Substantial damage
  > the pilot's improper decision to take off downwind with gusty wind conditions.
- [NTSB IAD97LA059](https://openairdocs.org/ntsb/IAD97LA059.md): Cessna 172M · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Mar 31, 1997 · N73455 · Substantial damage
  > the pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.
- [NTSB FTW97LA147](https://openairdocs.org/ntsb/FTW97LA147.md): Beech M35 · Iowa Park, TX · Accident · No injuries · Limited investigation · Final report · Mar 30, 1997 · N223C · Substantial damage
  > The pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX97LA133](https://openairdocs.org/ntsb/LAX97LA133.md): Enstrom F-28C · Sacaton, AZ · Accident · No injuries · Limited investigation · Final report · Mar 27, 1997 · N294SB · Substantial damage
  > the pilot's improper use of the collective by not maintaining rotor rpm during takeoff from a confined area.
- [NTSB CHI97FA093](https://openairdocs.org/ntsb/CHI97FA093.md): Stinson 108 · Greenfield, IN · Accident · 1 fatal · Field investigation · Final report · Mar 27, 1997 · N97120 · Destroyed
  > a loss of engine power due to restricted movement in the exhaust valve and rotted/weathered ignition harness, and the pilot's failure to maintain airspeed which resulted in an inadvertant stall.
- [NTSB ANC97LA042](https://openairdocs.org/ntsb/ANC97LA042.md): Cessna 207 · Grayling, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1997 · N1747U · Substantial damage
  > The partial loss of engine power due to a fractured connecting rod bolt, which was precipitated by fatigue. A factor associated with the accident was the snow covered terrain in the emergency landing site.
- [NTSB CHI97LA091](https://openairdocs.org/ntsb/CHI97LA091.md): Cessna 152 · Ft. Leavenworth, KS · Accident · No injuries · Limited investigation · Final report · Mar 26, 1997 · N6359M · Substantial damage
  > fatigue failure and separation of the number 2 cylinder. A factor was the rough terrain.
- [NTSB ANC97LA036](https://openairdocs.org/ntsb/ANC97LA036.md): Williams Kitfox · Wasilla, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1997 · N9KF · Substantial damage
  > a broken electrical wire, which resulted in an inoperative electrical fuel pump, an overly lean mixture, fuel starvation, and loss of engine power.
- [NTSB LAX97FA126](https://openairdocs.org/ntsb/LAX97FA126.md): Piper PA-22-160 · Bagdad, AZ · Accident · 4 fatal · Field investigation · Final report · Mar 19, 1997 · N3629Z · Destroyed
  > failure of the pilot to obtain and/or maintain adequate airspeed during takeoff/initial climb, which resulted in an inadvertent stall and collision with the terrain. High density altitude was a related factor.
- [NTSB FTW97LA132](https://openairdocs.org/ntsb/FTW97LA132.md): Piper PA-28-161 · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1997 · N2572Y · Substantial damage
  > the student pilot's improper use of the fuel tank selector which led to fuel starvation and loss of engine power. Factors were the pilot's inadequate fuel management and the lack of suitable terrain for the forced landing.
- [NTSB FTW97IA128](https://openairdocs.org/ntsb/FTW97IA128.md): McDonnell Douglas DC-9-32 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Mar 18, 1997 · N12508 · Minor damage
  > The failure of company maintenance personnel to perform a proper inspection of the combustion chamber outer case, thus allowing a detectable crack to grow to a length at which the case ruptured.
- [NTSB LAX97FA123](https://openairdocs.org/ntsb/LAX97FA123.md): Ercoupe 415-D · Pacoima, CA · Accident · 2 fatal · Field investigation · Final report · Mar 15, 1997 · N3030H · Destroyed
  > improper maintenance/installation of electrical wiring, the lack of circuit protection, and subsequent in-flight electrical fire.
- [NTSB FTW97LA124](https://openairdocs.org/ntsb/FTW97LA124.md): Piper PA-28-180 · Fort Collins, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 1997 · N4860T · Destroyed
  > The pilot's failure to remove completely ice/frost from the wing, impeding the airplane's aerodynamic performance. Factors were wing contamination by frost and ice.
- [NTSB NYC97LA060](https://openairdocs.org/ntsb/NYC97LA060.md): Piper PA-28-161 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Mar 14, 1997 · N2914A · Substantial damage
  > the pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…
- [NTSB FTW97LA116](https://openairdocs.org/ntsb/FTW97LA116.md): Cessna 172P · Cleveland, OK · Accident · No injuries · Limited investigation · Final report · Mar 10, 1997 · N65753 · Substantial damage
  > The pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.
- [NTSB LAX97LA115](https://openairdocs.org/ntsb/LAX97LA115.md): Ryan Navion · Marina, CA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1997 · N4969K · Substantial damage
  > Fuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.
- [NTSB ANC97LA033](https://openairdocs.org/ntsb/ANC97LA033.md): Cessna 337T · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Mar 9, 1997 · N922EJ · Substantial damage
  > a leaking landing gear actuator seal, which resulted in an inability of the landing gear to lock in the down position. Failure of the emergency gear extension handle was a related factor.
- [NTSB FTW97LA118](https://openairdocs.org/ntsb/FTW97LA118.md): Ryan Navion A · Hudson, CO · Accident · No injuries · Limited investigation · Final report · Mar 6, 1997 · N800PS · Substantial damage
  > A total power loss due to fuel starvation as a result of the pilot's inadequate preflight inspection of the airplane and its fuel system. Factors include: the pilot's failure to refuel the airplane, the improper fuel tank selector position that would not…
- [NTSB LAX97LA114](https://openairdocs.org/ntsb/LAX97LA114.md): Hoac Austria DV-20 · Galt, CA · Accident · No injuries · Limited investigation · Final report · Feb 26, 1997 · N194DV · Substantial damage
  > a disconnect of a fuel line fitting, due to the manufacturer's inadequate design and/or lack of adequate installation procedure for replacement of the fuel filter; which resulted in fuel starvation, loss of engine power, and a forced landing. Soft terrain in…
- [NTSB SEA97LA062](https://openairdocs.org/ntsb/SEA97LA062.md): Hall Kitfox · Billings, MT · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1997 · N87TJ · Substantial damage
  > The pilot-in-command's failure to maintain flying airspeed while executing a downwind turn at low altitude immediately following takeoff.
- [NTSB LAX97FA108](https://openairdocs.org/ntsb/LAX97FA108.md): Beech H18 · Honolulu, HI · Accident · Minor injuries · Field investigation · Final report · Feb 22, 1997 · N7969K · Destroyed
  > loss of aircraft control for undetermined reason(s).
- [NTSB ATL97LA043](https://openairdocs.org/ntsb/ATL97LA043.md): Cessna 172M · Brooksville, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1997 · N9987V · Substantial damage
  > inadequate supervision by the flight instructor (CFI), and his failure to ensure that adequate airspeed was obtained/maintained, which resulted in a stall and collision with the ground. The crosswind was a related factor.
- [NTSB NYC97LA053](https://openairdocs.org/ntsb/NYC97LA053.md): Piper PA-38-112 · Nanjemoy, MD · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1997 · N2558 · Substantial damage
  > the pilot's inadequate compensate for the wind conditions and failure to maintain adequate obstacle clearance during the initial climb after takeoff. The unfavorable wind condition and proximity of trees were related factors.
- [NTSB IAD97LA050](https://openairdocs.org/ntsb/IAD97LA050.md): Cessna 150 · Turner, ME · Accident · No injuries · Limited investigation · Final report · Feb 19, 1997 · N7811E · Substantial damage
  > Loss of engine power for undetermined reasons. A related factor was the snowbank.
- [NTSB IAD97GA049](https://openairdocs.org/ntsb/IAD97GA049.md): Enstrom 280C · Lucasville, OH · Accident · Serious injuries · Final report · Feb 19, 1997 · N51662 · Substantial damage
  > The pilot in command failure to maintain rotor rpm.
- [NTSB FTW97FA103](https://openairdocs.org/ntsb/FTW97FA103.md): Piper PA-24-250 · Farmington, NM · Accident · 5 fatal · Field investigation · Final report · Feb 15, 1997 · N6433P · Destroyed
  > loss of aircraft control for undetermined reason(s).
- [NTSB CHI97LA068](https://openairdocs.org/ntsb/CHI97LA068.md): Cessna 172 · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · Feb 8, 1997 · N13611 · Substantial damage
  > The loss of power for undetermined reasons.
- [NTSB CHI97FA067](https://openairdocs.org/ntsb/CHI97FA067.md): Cessna 150 · Larchwood, IA · Accident · 1 fatal · Field investigation · Final report · Feb 7, 1997 · N714EE · Destroyed
  > the noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.
- [NTSB ANC97FA026](https://openairdocs.org/ntsb/ANC97FA026.md): Piper PA-18 · Circle, AK · Accident · 1 fatal · Field investigation · Final report · Feb 7, 1997 · N121BB · Destroyed
  > inadequate preflight by the pilot; and his subsequent loss of aircraft control, during the initial climb after takeoff. Factors relating to the accident were: the pilot failed to ensure that the cargo was properly secured, and he allowed the aircraft's weight…
- [NTSB FTW97FA099](https://openairdocs.org/ntsb/FTW97FA099.md): Aeronca 65-TC · Moriarty, NM · Accident · 2 fatal · Field investigation · Final report · Feb 3, 1997 · N31794 · Substantial damage
  > The pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.
- [NTSB FTW97LA098](https://openairdocs.org/ntsb/FTW97LA098.md): Cessna 172E · Waxahachie, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 1997 · N5598T · Destroyed
  > The loss of engine power for undetermined reasons. A factors was the lack of suitable terrain for the forced landing.
- [NTSB FTW97LA094](https://openairdocs.org/ntsb/FTW97LA094.md): Enstrom F-28C · Lake Jackson, TX · Accident · No injuries · Limited investigation · Final report · Jan 30, 1997 · N51774 · Destroyed
  > The failure of the #2 cylinder for an undetermined reason which resulted in an exhaust leak that melted an oil line.
- [NTSB MIA97LA076](https://openairdocs.org/ntsb/MIA97LA076.md): Cessna U206D · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Jan 27, 1997 · N72074 · Substantial damage
  > Inadequate torque of the cylinder base nuts and through bolt nuts by company maintenance personnel which allowed movement of the crankcase halves. As a result the No. 2 main bearing failed which allowed excessive movement of the crankshaft resulting in…
- [NTSB SEA97LA052](https://openairdocs.org/ntsb/SEA97LA052.md): Piper PA-28RT-201 · Chehalis, WA · Accident · Serious injuries · Limited investigation · Final report · Jan 26, 1997 · N344LC · Destroyed
  > The failure of the first pilot to conduct an adequate preflight inspection, and his failure to properly manage the aircraft fuel supply. This led to fuel starvation and a subsequent loss of engine power. Factors contributing to the accident are the false…
- [NTSB LAX97LA092](https://openairdocs.org/ntsb/LAX97LA092.md): Crane Thorp T-18 · San Diego, CA · Accident · 2 fatal · Limited investigation · Final report · Jan 25, 1997 · N40918 · Destroyed
  > Installation by the pilot/owner of an unairworthy check valve in the fuel system of the amateur built aircraft, which resulted in inadequate fuel flow to the engine and subsequent engine failure. A factor in the accident was the owner's operation of the…
- [NTSB MIA97LA072](https://openairdocs.org/ntsb/MIA97LA072.md): Navion G · Indiantown, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 24, 1997 · N2417T · Substantial damage
  > Total loss of engine power due to undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing. Findings of the follow-up investigation were 1) The airplane had not been operated and no annual inspections…
- [NTSB FTW97LA087](https://openairdocs.org/ntsb/FTW97LA087.md): Piper PA-28-140 · Sulphur, OK · Accident · No injuries · Limited investigation · Final report · Jan 23, 1997 · N15754 · Substantial damage
  > The loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.
- [NTSB CHI97IA075](https://openairdocs.org/ntsb/CHI97IA075.md): de Havilland DHC-8-102 · Charleston, WV · Incident · No injuries · Incident investigation · Final report · Jan 22, 1997 · N852MA · No damage
  > a fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…
- [NTSB CHI97FA059](https://openairdocs.org/ntsb/CHI97FA059.md): Cessna 401 · Crystal, MN · Accident · Minor injuries · Field investigation · Final report · Jan 22, 1997 · N5AS · Substantial damage
  > failure of the pilot-in-command to ensure adequate removal of airframe ice from the aircraft during preflight.
- [NTSB SEA97LA050](https://openairdocs.org/ntsb/SEA97LA050.md): Cessna 180J · Lopez, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1997 · N42376 · Substantial damage
  > The pilot's improper decision to initiate flight into marginal VFR conditions at night which led to inadvertent flight into instrument meteorological conditions, and his failure to maintain adequate clearance from terrain. Factors contributing to the accident…
- [NTSB FTW97LA086](https://openairdocs.org/ntsb/FTW97LA086.md): Mahan Starduster II · Atlanta, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1997 · N45227 · Substantial damage
  > improper maintenance by unknown person(s), which resulted in the failure of the throttle cable and a substantial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for the forced landing.
- [NTSB IAD97LA044](https://openairdocs.org/ntsb/IAD97LA044.md): Aerospatiale TB-20 · University Park, PA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1997 · N2803A · Substantial damage
  > the pilot's inability to control the airplane due to a damaged/bent elevator control lever and resultant lack of elevator authority.
- [NTSB NYC97FA043](https://openairdocs.org/ntsb/NYC97FA043.md): Cessna 150L · Collegeville, PA · Accident · 2 fatal · Field investigation · Final report · Jan 12, 1997 · N10809 · Destroyed
  > The loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.
- [NTSB LAX97LA088](https://openairdocs.org/ntsb/LAX97LA088.md): McDonnell Douglas 369D · Kamuela, HI · Accident · No injuries · Limited investigation · Final report · Jan 12, 1997 · N7012G · Substantial damage
  > fuel system contamination resulting in a partial loss of power, and the failure of the pilot to maintain adequate rotor rpm to cushion the autorotative landing and prevent main rotor blade contact with the tailboom. Factors were the inadequacy of…
- [NTSB NYC97FA045](https://openairdocs.org/ntsb/NYC97FA045.md): Beech 1900D · Bangor, ME · Accident · Minor injuries · Field investigation · Final report · Jan 10, 1997 · N139ZV · Substantial damage
  > The inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…
- [NTSB ANC97LA017](https://openairdocs.org/ntsb/ANC97LA017.md): Cessna 185F · Nome, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 1997 · N23CB · Substantial damage
  > the pilot's failure to properly verify the position of a fractured fuel selector handle, which resulted in fuel starvation and subsequent loss of engine power. A factor related to the accident was: the fractured handle that allowed the fuel selector to be…

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

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

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