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

## Cases, newest first

- [NTSB CEN26LA235](https://openairdocs.org/ntsb/CEN26LA235.md): Beech V35B · Greeley, CO · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 17, 2026 · N4275S · No damage
- [NTSB CEN26FA224](https://openairdocs.org/ntsb/CEN26FA224.md): Pacific Aerospace 750XL · Butler, MO · Accident · 12 fatal · Class 2 · Field · Preliminary report · Jun 14, 2026 · N221BN · Destroyed
  > On June 14, 2026, about 1125 central daylight time, a Pacific Aerospace Limited 750XL airplane, N221BN, was destroyed when it was involved in an accident near Butler, Missouri. The pilot and 11 passengers sustained fatal injuries. The airplane was operated as…
- [NTSB ANC26LA049](https://openairdocs.org/ntsb/ANC26LA049.md): William F Schoen RV-7 · Alpine, CO · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jun 10, 2026 · N727BN · Substantial damage
- [NTSB CEN26LA220](https://openairdocs.org/ntsb/CEN26LA220.md): Aero Commander 112 · Fabens, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 6, 2026 · N27007 · Substantial damage
  > On June 6, 2026, at 0900 central daylight time, an Aero Commander, N27007, sustained substantial damage when it was involved in an accident in Fabens, Texas. The private pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA240](https://openairdocs.org/ntsb/ERA26LA240.md): Piper PA-22-108 · Westminster, MD · Accident · No injuries · Class 4 · Limited · Final report · Jun 5, 2026 · N5081Z · Substantial damage
  > The pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.
- [NTSB ENG26LA026](https://openairdocs.org/ntsb/ENG26LA026.md): Cirrus SF50 · Athens, GA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jun 2, 2026 · N129KA · Minor damage
  > On June 2, 2026, at 0945 eastern daylight time, a Cirrus SF50, N129KA, powered by a Williams International FJ33-5A turbofan engine, experienced an uncontained engine failure during climb from Greene County Regional Airport (KCPP), Greensboro, Georgia. There…
- [NTSB ERA26LA223](https://openairdocs.org/ntsb/ERA26LA223.md): Cessna T210 · Loíza, PR · Accident · No injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N210PL · Substantial damage
  > On May 30, 2026, about 0744 Atlantic standard time, a Cessna T210, N210PL, was substantially damaged when it was involved in an accident near Loiza, Puerto Rico. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA221](https://openairdocs.org/ntsb/ERA26LA221.md): Cessna 172P · Pembroke Pines, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 29, 2026 · N96100 · Substantial damage
  > On May 29, 2026, at 1138 eastern daylight time, a Cessna 172P, N96100, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor sustained serious injuries. The student pilot sustained minor injuries.…
- [NTSB ERA26LA219](https://openairdocs.org/ntsb/ERA26LA219.md): Rainbow Cheetah XLS · Knightdale, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 27, 2026 · N146RC · Substantial damage
  > On May 27, 2026, about 1420 eastern daylight time, a special light sport Rainbow Cheetah XLS airplane, N146RC, was substantially damaged when it was involved in an accident near Knightdale, North Carolina. The flight instructor and student pilot were…
- [NTSB ERA26FA214](https://openairdocs.org/ntsb/ERA26FA214.md): Piper PA-25-235 · Saratoga Springs, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 26, 2026 · N8656L · 2 aircraft · Substantial damage
  > On May 26, 2026, about 1347 eastern daylight time, a Piper PA-25-235 airplane, N8656L, was substantially damaged when it was involved in an accident near Saratoga Springs, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB DCA26WA222](https://openairdocs.org/ntsb/DCA26WA222.md): Boeing 737 · Marrakech, Morocco · Occurrence · Class 5 · Foreign · May 22, 2026 · PH-HSB · No damage
- [NTSB CEN26LA202](https://openairdocs.org/ntsb/CEN26LA202.md): Piper PA-32R-300 · Comanche, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N4556Q · Substantial damage
  > On May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA211](https://openairdocs.org/ntsb/ERA26LA211.md): Patsch Thorp T-18 · Hendersonville, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · May 15, 2026 · N2KP · Substantial damage
  > On May 15, 2026, about 1853 eastern daylight time, an experimental amateur-built Thorp T-18, N2KP, was substantially damaged when it was involved in an accident near Hendersonville, North Carolina. The commercial pilot was not injured. The airplane was…
- [NTSB DCA26WA199](https://openairdocs.org/ntsb/DCA26WA199.md): Boeing 747 · Karachi, Pakistan · Incident · No injuries · Class 5 · Foreign · May 12, 2026 · EX-47004
- [NTSB ERA26LA201](https://openairdocs.org/ntsb/ERA26LA201.md): Sky Ranger SKY Ranger 1 · Front Royal, VA · Accident · No injuries · Class 4 · Limited · Final report · May 9, 2026 · N8092S · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in him taking off with the fuel selector in the OFF position, and the subsequent total loss of engine power due to fuel starvation.
- [NTSB DCA26WA207](https://openairdocs.org/ntsb/DCA26WA207.md): Boeing 737 · Lahore, Pakistan · Occurrence · No injuries · Class 5 · Foreign · May 6, 2026 · 9M-LRL
- [NTSB ERA26LA196](https://openairdocs.org/ntsb/ERA26LA196.md): Beech C23 · Bangor, ME · Accident · No injuries · Class 3 · Limited · Preliminary report · May 1, 2026 · N18516 · Substantial damage
  > On May 01, 2026, at 1604 eastern daylight time, a Beechcraft C23 airplane, N18516, was substantially damaged when it was involved in an accident near Bangor, Maine. The private pilot and flight instructor were uninjured. The airplane was operated as a Title…
- [NTSB WPR26LA170](https://openairdocs.org/ntsb/WPR26LA170.md): Balony Kubicek Spol Sro BB100Z · Elk Grove, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 27, 2026 · N355WC · Substantial damage
  > The pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…
- [NTSB CEN26LA180](https://openairdocs.org/ntsb/CEN26LA180.md): Just JA-30 · Hartville, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 26, 2026 · N422T · Destroyed
  > The pilot’s failure to maintain clearance from a power line after takeoff.
- [NTSB CEN26FA172](https://openairdocs.org/ntsb/CEN26FA172.md): Beechcraft F33A · Minneapolis, MN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 25, 2026 · N8032X · Destroyed
  > On April 25, 2026, about 1151 central daylight time, a Beechcraft F33A airplane, N8032X was destroyed when it was involved in an accident near Minneapolis, Minnesota. The pilot and passenger were fatally injured. The airplane was operated under Title 14 Code…
- [NTSB ERA26FA179](https://openairdocs.org/ntsb/ERA26FA179.md): Cessna 401B · Land O' Lakes, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 19, 2026 · N122AT · Destroyed
  > On April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA173](https://openairdocs.org/ntsb/WPR26LA173.md): Pipistrel Alpha Trainer · Salinas, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 18, 2026 · N143AW · Substantial damage
  > The flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB GAA26WA167](https://openairdocs.org/ntsb/GAA26WA167.md): Socata TB9 · Zborowo, Poland · Accident · No injuries · Class 5 · Foreign · Apr 18, 2026 · D-EUGA · Substantial damage
- [NTSB WPR26LA162](https://openairdocs.org/ntsb/WPR26LA162.md): Cirrus Design SR22 · La Cienega, NM · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 17, 2026 · N654MC · Substantial damage
  > On April 17, 2026, at about 0954 mountain standard time, a Cirrus Design Corp SR22, N654MC, sustained substantial damage when it was involved in an accident near La Cienega, New Mexico. The pilot receiving instruction and the flight instructor were not…
- [NTSB WPR26FA160](https://openairdocs.org/ntsb/WPR26FA160.md): Mooney M20J · Union, SC · Accident · 4 fatal · Class 3 · Field · Preliminary report · Apr 17, 2026 · N1151H · Substantial damage
  > On April 17, 2026, about 1750 eastern daylight time, a Mooney M20J, N1151H, was destroyed when it was involved in an accident near Union, South Carolina. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA178](https://openairdocs.org/ntsb/ERA26FA178.md): Mooney M20J · Ironton, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 17, 2026 · N205MK · Substantial damage
  > On April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB WPR26LA158](https://openairdocs.org/ntsb/WPR26LA158.md): Alexander Schleicher ASH 31 MI · Williams, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 13, 2026 · N77UK · Substantial damage
  > On April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The…
- [NTSB ENG26WA027](https://openairdocs.org/ntsb/ENG26WA027.md): ATR ATR72 · Marseille-Provence, France · Occurrence · No injuries · Class 5 · Foreign · Apr 5, 2026 · EC-JXF · No damage
- [NTSB CEN26LA163](https://openairdocs.org/ntsb/CEN26LA163.md): Textron T206H · Wichita, KS · Accident · No injuries · Class 4 · Limited · Final report · Apr 3, 2026 · N411CV · Substantial damage
  > The flight crew’s failure to ensure that the rear cargo door was properly latched before flight.
- [NTSB ANC26LA029](https://openairdocs.org/ntsb/ANC26LA029.md): Maule M-7-235 · Wasilla, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 3, 2026 · N93ML · Substantial damage
  > On April 3, 2026, at 1300 Alaska daylight time, a Maule M 7 235 airplane, N93ML, was substantially damaged during an accident near Wasilla, Alaska. The pilot and one passenger were not injured. The airplane was operated as a personal flight under the…
- [NTSB GAA26WA184](https://openairdocs.org/ntsb/GAA26WA184.md): Robinson R44 · Yorke Island, Australia · Accident · Serious injuries · Class 5 · Foreign · Mar 31, 2026 · VH-HYR · Substantial damage
- [NTSB DCA26WA172](https://openairdocs.org/ntsb/DCA26WA172.md): Mcdonnell Douglas MD80 · La Guaira, Venezuela · Incident · No injuries · Class 5 · Foreign · Mar 31, 2026 · YV3499 · No damage
- [NTSB ENG26WA025](https://openairdocs.org/ntsb/ENG26WA025.md): Airbus A330-323 · Sao Paulo, Brazil · Incident · No injuries · Class 3 · Foreign · Mar 30, 2026 · N813NW · Substantial damage
- [NTSB CEN26LA149](https://openairdocs.org/ntsb/CEN26LA149.md): Piper PA28 · Atlanta, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 26, 2026 · N1653J · Substantial damage
  > On March 26, 2026, about 0720 central daylight time, a Piper PA28-140 airplane, N1653J, was substantially damaged when it was involved in an accident near Atlanta, Texas. The pilot was not injured. The flight was operated under the provisions of Title 14 Code…
- [NTSB GAA26WA134](https://openairdocs.org/ntsb/GAA26WA134.md): Air Tractor AT502B · Cruz Alta, Brazil · Incident · 1 fatal · Class 5 · Foreign · Mar 16, 2026 · PT-SEF · Destroyed
- [NTSB DCA26WA157](https://openairdocs.org/ntsb/DCA26WA157.md): Embraer ERJ190 · Minatitlan, Mexico · Incident · No injuries · Class 5 · Foreign · Mar 9, 2026 · XA-ACE · Minor damage
- [NTSB ERA26LA144](https://openairdocs.org/ntsb/ERA26LA144.md): Piper PA-28-140 · Indian Trail, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N98360 · Substantial damage
  > On March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a…
- [NTSB ERA26LA149](https://openairdocs.org/ntsb/ERA26LA149.md): Piper PA-28-181 · Sanford, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 6, 2026 · N697LH · Substantial damage
  > An in-flight collision with a bird during initial climb.
- [NTSB WPR26FA119](https://openairdocs.org/ntsb/WPR26FA119.md): Piper PA-28-140 · Phoenix, AZ · Accident · Serious injuries · Class 3 · Field · Preliminary report · Mar 4, 2026 · N7744T · Substantial damage
  > On March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the…
- [NTSB DCA26WA147](https://openairdocs.org/ntsb/DCA26WA147.md): Boeing 737-823 · San Salvador, El Salvador · Incident · No injuries · Class 5 · Foreign · Mar 1, 2026 · N907NN · Minor damage
- [NTSB GAA26WA116](https://openairdocs.org/ntsb/GAA26WA116.md): Beech C90 · Gangnani, India · Accident · Class 5 · Foreign · Feb 23, 2026 · VT-AJV · Destroyed
- [NTSB ANC26LA016](https://openairdocs.org/ntsb/ANC26LA016.md): Cessna 177B · Rocky Junction, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 22, 2026 · N12984 · Substantial damage
  > On February 21, 2026, 1746 Mountain standard time, a Cessna 177B airplane, N12984, was substantially damaged when it was involved in an accident near Rocky Junction, Arizona. The pilot and passenger sustain minor injuries. The airplane was operated as a Title…
- [NTSB CEN26LA110](https://openairdocs.org/ntsb/CEN26LA110.md): Glasair GlaStar · Beaumont, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 7, 2026 · N789BM · Substantial damage
  > On February 6, 2026, about 1810 central standard time, an experimental Glasair GlaStar airplane, N789BM, was substantially damaged when it was involved in an accident near Beaumont, Texas. The pilot was not injured. The airplane was operated as a Title 14…
- [NTSB WPR26FA101](https://openairdocs.org/ntsb/WPR26FA101.md): Sonex Onex · Caldwell, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N362DZ · Destroyed
  > On February 6, 2026, about 0945 mountain standard time, a Sonex Onex airplane, N362DZ, was destroyed when it was involved in an accident near Caldwell, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB DCA26WA114](https://openairdocs.org/ntsb/DCA26WA114.md): Saab 340B · Canberra, Australia · Incident · No injuries · Class 5 · Foreign · Jan 29, 2026 · VH-VEZ · Minor damage
- [NTSB DCA26LA106](https://openairdocs.org/ntsb/DCA26LA106.md): Airbus A330-343 · Hebron, KY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 28, 2026 · N5827K · Substantial damage
  > On January 28, 2026, at 1505 eastern standard time, Alaska Airlines flight 2616, an Airbus 330-343, N5827K, powered by two Rolls Royce RB211 engines, struck birds during initial climb after takeoff from Cincinnati/Northern Kentucky International Airport…
- [NTSB ENG26WA013](https://openairdocs.org/ntsb/ENG26WA013.md): Airbus A350 · Las Vegas, NV · Incident · No injuries · Class 5 · Foreign · Jan 27, 2026 · G-XWBN · Minor damage
- [NTSB GAA26WA077](https://openairdocs.org/ntsb/GAA26WA077.md): Cessna T-206H · Saltillo, Coahuila, Mexico · Accident · Serious injuries · Class 5 · Foreign · Jan 17, 2026 · XB-HUS · Substantial damage
- [NTSB WPR26LA086](https://openairdocs.org/ntsb/WPR26LA086.md): Bell 206L-3 · Logsden, OR · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 15, 2026 · N868H · Substantial damage
  > The inadvertent entanglement of a long line with the skid, which resulted in a loss of flight control. Contributing to the accident was the use of nylon lines instead of steel cables to secure the bucket.
- [NTSB ERA26LA091](https://openairdocs.org/ntsb/ERA26LA091.md): Piper PA-28-180 · Port St. Lucie, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jan 11, 2026 · N6516J · Substantial damage
  > On January 10, 2026, about 1925 eastern standard time, a Piper PA-28-180, N6516J was substantially damaged when it was involved in an accident near Port St. Lucie, Florida. The pilot and passenger sustained serious injuries. The airplane was operated as a…

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

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

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