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

## Cases, newest first

- [NTSB DCA19WA181](https://openairdocs.org/ntsb/DCA19WA181.md): Boeing 777 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jul 3, 2019 · GY-MMU · No damage
  > The AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…
- [NTSB GAA19CA439](https://openairdocs.org/ntsb/GAA19CA439.md): Cessna 172 · Manteo, NC · Accident · Minor injuries · Data collection · Final report · Jun 30, 2019 · N78658 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB CEN19MA190](https://openairdocs.org/ntsb/CEN19MA190.md): Textron B-300 · Addison, TX · Accident · 10 fatal · Class 2 · Major · Final report · Jun 30, 2019 · N534FF · Destroyed
  > The pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…
- [NTSB ENG19WA028](https://openairdocs.org/ntsb/ENG19WA028.md): Airbus A320 · Delhi, India · Incident · No injuries · Foreign investigation · Jun 29, 2019 · VT-ITP · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on June 26, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced issues with the No. 1 (left)…
- [NTSB CEN19LA202](https://openairdocs.org/ntsb/CEN19LA202.md): Aeronca L16A · Zelienople, PA · Accident · No injuries · Class 3 · Limited · Final report · Jun 29, 2019 · N9325H · Substantial damage
  > A total loss of engine power due to obstruction of the carburetor air intake by a piece of the air filter gasket that had become detached.
- [NTSB GAA19CA429](https://openairdocs.org/ntsb/GAA19CA429.md): Flightstar Sportplanes Flightstar II · Coward, SC · Accident · Minor injuries · Data collection · Final report · Jun 28, 2019 · UNREG · Substantial damage
  > The noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.
- [NTSB ERA19LA217](https://openairdocs.org/ntsb/ERA19LA217.md): Beech 77 · Leesburg, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 28, 2019 · N1802Y · Substantial damage
  > A partial loss of engine power due to carburetor icing, which resulted from the flight instructor's decision not to use carburetor heat.
- [NTSB GAA19CA377](https://openairdocs.org/ntsb/GAA19CA377.md): Cessna 177 · Pleasanton, KS · Accident · No injuries · Data collection · Final report · Jun 27, 2019 · N30257 · Substantial damage
  > The pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.
- [NTSB ERA19FA200](https://openairdocs.org/ntsb/ERA19FA200.md): Rans S6 · Fletcher, NC · Accident · 2 fatal · Class 2 · Field · Final report · Jun 26, 2019 · N661PF · Destroyed
  > The exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.
- [NTSB GAA19CA426](https://openairdocs.org/ntsb/GAA19CA426.md): North American T28 · Hollister, CA · Accident · Minor injuries · Data collection · Final report · Jun 20, 2019 · N28CU · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB CEN19WA201](https://openairdocs.org/ntsb/CEN19WA201.md): Piper PA28R · Pointe-A-Pitre, Guadeloupe · Accident · Serious injuries · Foreign investigation · Jun 19, 2019 · F-ODSM · Destroyed
- [NTSB CEN19LA174](https://openairdocs.org/ntsb/CEN19LA174.md): Robinson R44 · Key West, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 17, 2019 · N1241W · Substantial damage
  > The failure of maintenance personnel to properly secure the right-side tail boom mounting bolts which resulted in the failure of the bolts and an inflight separation of the tail rotor.
- [NTSB GAA19WA356](https://openairdocs.org/ntsb/GAA19WA356.md): Pitts S2 · Saint-Jean-Port-Joli, Canada · Accident · 1 fatal · Foreign investigation · Jun 16, 2019 · C-CONV · Destroyed
- [NTSB WPR19LA174](https://openairdocs.org/ntsb/WPR19LA174.md): Cessna 182M · Upland, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 15, 2019 · N777RK · Substantial damage
  > The total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.
- [NTSB CEN19LA172](https://openairdocs.org/ntsb/CEN19LA172.md): Karns SKY Ranger · Hedgesville, WV · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 14, 2019 · N106RK · Substantial damage
  > A partial loss of engine power during takeoff due to the formation of carburetor ice while on the ground, which resulted in an impact with terrain.
- [NTSB CEN19LA173](https://openairdocs.org/ntsb/CEN19LA173.md): Just Highlander · Quinlan, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 13, 2019 · N324SB · Substantial damage
  > The pilot's decision to depart with minimal runway available and his improper soft-field takeoff procedure, which resulted in impact with trees due to a slow airspeed and settling effect during climb out.
- [NTSB ERA19FA193](https://openairdocs.org/ntsb/ERA19FA193.md): Cessna 182 · Maitland, FL · Accident · 2 fatal · Field investigation · Final report · Jun 12, 2019 · N3051Y · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR19LA167](https://openairdocs.org/ntsb/WPR19LA167.md): Mooney M20V · Phoenix, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 11, 2019 · N576CM · Substantial damage
  > The partial loss of engine power during cruise flight for reasons that could not be determined with the available evidence.
- [NTSB WPR19TA162](https://openairdocs.org/ntsb/WPR19TA162.md): Beech 35 · Medford, OR · Accident · Minor injuries · Class 3 · Final report · Jun 8, 2019 · N602BH · Substantial damage
  > The pilot’s mismanagement of fuel onboard, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA19WA357](https://openairdocs.org/ntsb/GAA19WA357.md): S.A.N. Jodel D-11 · La Cote, Switzerland, Switzerland · Accident · 1 fatal · Foreign investigation · May 30, 2019 · HB-SFR · Substantial damage
  > The government of Switzerland has notified the NTSB of an accident involving a S.A.N. Jodel D-11 airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…
- [NTSB ANC19WA020](https://openairdocs.org/ntsb/ANC19WA020.md): Cessna 170 · Whitehorse, Canada · Accident · 2 fatal · Foreign investigation · May 28, 2019 · N4512C · Destroyed
- [NTSB WPR19LA155](https://openairdocs.org/ntsb/WPR19LA155.md): Cessna 150 · Garberville, CA · Accident · Serious injuries · Class 3 · Limited · Final report · May 26, 2019 · N8746S · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN19FA148](https://openairdocs.org/ntsb/CEN19FA148.md): Cessna S550 · Greenfield, IN · Accident · 2 fatal · Class 2 · Field · Final report · May 22, 2019 · N311G · Destroyed
  > The pilot's failure to fully advance the power levers during the takeoff and initial climb, which led to his failure to maintain sufficient airspeed and resulted in the exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB WPR19FA150](https://openairdocs.org/ntsb/WPR19FA150.md): Beech 35 · Melba, ID · Accident · 1 fatal · Class 3 · Field · Final report · May 19, 2019 · N1888D · Substantial damage
  > The pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.
- [NTSB WPR19LA165](https://openairdocs.org/ntsb/WPR19LA165.md): Cessna T210 · Medford, OR · Accident · Minor injuries · Class 3 · Limited · Final report · May 15, 2019 · N732DK · Substantial damage
  > A total loss of engine power due to fuel starvation.
- [NTSB GAA19WA275](https://openairdocs.org/ntsb/GAA19WA275.md): Beech F33 · Campo Grande County, Brazil · Accident · 2 fatal · Foreign investigation · May 15, 2019 · PR-BHF · Destroyed
- [NTSB GAA19WA291](https://openairdocs.org/ntsb/GAA19WA291.md): Cessna T210 · Mahahual, Mexico, Mexico · Accident · 2 fatal · Foreign investigation · May 12, 2019 · XB-OYJ · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB CEN19WA254](https://openairdocs.org/ntsb/CEN19WA254.md): Cirrus SR22 · Abergavenny, United Kingdom · Accident · Minor injuries · Foreign investigation · May 12, 2019 · 2-RORO · Destroyed
  > On May 12, 2019, about 0930 coordinated universal time (UTC), a Cirrus Aircraft SR22T airplane, Guernsey registration 2-RORO, serial number 701, was destroyed during a forced landing and postimpact fire following a loss of engine power shortly after takeoff…
- [NTSB GAA19CA258](https://openairdocs.org/ntsb/GAA19CA258.md): Cessna 172 · Dexter, MI · Accident · Serious injuries · Data collection · Final report · May 11, 2019 · N21794 · Substantial damage
  > The airplane's failure to maintain a climb for reasons that could not be determined based on the available evidence.
- [NTSB GAA19CA257](https://openairdocs.org/ntsb/GAA19CA257.md): Cessna 182 · Glades Park, CO · Accident · Minor injuries · Data collection · Final report · May 11, 2019 · N6314B · Substantial damage
  > The pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.
- [NTSB CEN19FA139](https://openairdocs.org/ntsb/CEN19FA139.md): Mooney M20J · Moose Lake, MN · Accident · 1 fatal · Class 3 · Field · Final report · May 8, 2019 · N111JP · Substantial damage
  > The pilot’s failure to maintain control of the airplane after departing into a snowstorm.
- [NTSB WPR19FA133](https://openairdocs.org/ntsb/WPR19FA133.md): Just JA30 Superstol · Chelan, WA · Accident · 1 fatal · Class 2 · Field · Final report · May 6, 2019 · N825PW · Destroyed
  > The pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.
- [NTSB ERA19FA164](https://openairdocs.org/ntsb/ERA19FA164.md): Piper PA28 · Foley, AL · Accident · 1 fatal · Field investigation · Final report · May 6, 2019 · N5542U · Destroyed
  > A partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.
- [NTSB DCA19WA148](https://openairdocs.org/ntsb/DCA19WA148.md): Sukhoi RRJ95 · Moscow, Russia · Accident · 41 fatal · Foreign investigation · May 5, 2019 · RA89098 · Destroyed
  > The MAK of Russia has notified the NTSB of an accident involving a Sukhoi RRJ95 airplane that occurred on May 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the MAK's investigation under the provisions of ICAO Annex 13 as State of…
- [NTSB CEN19FA135](https://openairdocs.org/ntsb/CEN19FA135.md): Piper PA34 · Anderson, IN · Accident · Serious injuries · Class 2 · Field · Final report · May 5, 2019 · N999CR · Substantial damage
  > The loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.
- [NTSB WPR19LA171](https://openairdocs.org/ntsb/WPR19LA171.md): Beech 35 · Deer Park, WA · Accident · No injuries · Class 3 · Limited · Final report · May 3, 2019 · N2839V · Substantial damage
  > An empennage flutter event for reasons that could not be determined based on the available information.
- [NTSB GAA19WA249](https://openairdocs.org/ntsb/GAA19WA249.md): Grumman AA1 · Grena, Denmark, Denmark · Accident · Minor injuries · Foreign investigation · May 3, 2019 · OY-CLH · Destroyed
  > The government of Denmark has notified the NTSB of an accident involving a GRUMMAN AA1 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions of…
- [NTSB WPR19LA129](https://openairdocs.org/ntsb/WPR19LA129.md): Storch FL-156C · Upland, CA · Accident · Serious injuries · Class 3 · Limited · Final report · May 1, 2019 · N156LZ · Substantial damage
  > The pilot’s improper installation of the No. 3 cylinder valve cover, which resulted in an oil leak, oil starvation, and a subsequent total loss of engine power.
- [NTSB WPR19LA128](https://openairdocs.org/ntsb/WPR19LA128.md): Beech 35 · Sedona, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 1, 2019 · N6864Q · Substantial damage
  > The partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.
- [NTSB ENG19WA024](https://openairdocs.org/ntsb/ENG19WA024.md): Boeing 767 · London, United Kingdom · Incident · No injuries · Foreign investigation · Apr 29, 2019 · N657UA · Minor damage
  > The United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 767-322, which occurred on April 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…
- [NTSB ENG19WA023](https://openairdocs.org/ntsb/ENG19WA023.md): Boeing 767 · Johannesburg, South Africa · Incident · No injuries · Foreign investigation · Apr 28, 2019 · Z-WPF · No damage
  > The Government of South Africa has notified the NTSB of an incident involving an Air Zimbabwe Boeing 767-2NOER with Pratt & Whitney PW4056 engines on April 28, 2019. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO…
- [NTSB WPR19FA121](https://openairdocs.org/ntsb/WPR19FA121.md): TL Ultralight Sro Stingsport · Madera, CA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 25, 2019 · N797N · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.
- [NTSB CEN19FA122](https://openairdocs.org/ntsb/CEN19FA122.md): Rans S7 · Kingsland, TX · Accident · 2 fatal · Class 3 · Field · Final report · Apr 21, 2019 · N25TX · Destroyed
  > The exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.
- [NTSB WPR19FA115](https://openairdocs.org/ntsb/WPR19FA115.md): Beech 60 · Fullerton, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 19, 2019 · N65MY · Destroyed
  > The pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…
- [NTSB GAA19CA268](https://openairdocs.org/ntsb/GAA19CA268.md): Piper PA32 · Saipan · Accident · No injuries · Data collection · Final report · Apr 19, 2019 · N4599X · Substantial damage
  > The airplane’s collision with a bird during the initial climb, which resulted in the engine cowling separating and impacting the empennage.
- [NTSB CEN19LA121](https://openairdocs.org/ntsb/CEN19LA121.md): Bell OH 58A · Omaha, NE · Accident · No injuries · Class 3 · Limited · Final report · Apr 16, 2019 · N109PD · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ENG19RA019](https://openairdocs.org/ntsb/ENG19RA019.md): Avro 146 · Tambo International Airport, South Africa · Incident · No injuries · Foreign investigation · Apr 12, 2019 · ZS-SSJ · No damage
  > The South Africa Accident and Incident Investigation Division (AIID) has notified the United States, as the State of Design and Manufacture for the Engines, of an engine in-flight shut down incident involving a BAE Aero 146 RJ85A, ZS-SSJ, that occurred near…
- [NTSB WPR19FA106](https://openairdocs.org/ntsb/WPR19FA106.md): Tecnam P2002 · Santa Fe, NM · Accident · 2 fatal · Class 3 · Field · Final report · Apr 8, 2019 · N118LS · Destroyed
  > The flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.
- [NTSB ERA19LA144](https://openairdocs.org/ntsb/ERA19LA144.md): Robinson R22 · Clover, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 7, 2019 · N4047H · Destroyed
  > The pilot's inadequate visual lookout, which resulted in a collision with trees. Contributing to the accident was the pilot’s decision to takeoff at night without adequate runway lighting.
- [NTSB ENG19WA017](https://openairdocs.org/ntsb/ENG19WA017.md): Airbus A320 · Pune, India · Incident · No injuries · Foreign investigation · Apr 2, 2019 · VT-ITG · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 2, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…

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

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

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