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

## Cases, newest first

- [NTSB ERA25LA294](https://openairdocs.org/ntsb/ERA25LA294.md): Piper PA-28-151 · Chamblee, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 9, 2025 · N1080H · Substantial damage
  > On August 9, 2025, about 0033 eastern daylight time, a Piper PA-28-151, N1080H, was substantially damaged when it was involved in an accident near DeKalb-Peachtree Airport (PDK), Chamblee, Georgia. The flight instructor and student pilot were seriously…
- [NTSB GAA25WA240](https://openairdocs.org/ntsb/GAA25WA240.md): Cessna TR182 · Vereda la Patera, Ubate, Colombia · Accident · Serious injuries · Class 5 · Foreign · Aug 1, 2025 · HK2434G · Substantial damage
- [NTSB CEN25LA300](https://openairdocs.org/ntsb/CEN25LA300.md): Cessna 172P · Gainesville, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 1, 2025 · N62296 · Substantial damage
  > On August 1, 2025, about 0802 central daylight time, a Cessna 172P airplane, N62296, was substantially damaged during an accident near Gainesville, Texas. The flight instructor and pilot-receiving-instruction were not injured. The airplane was operated as a…
- [NTSB CEN25FA296](https://openairdocs.org/ntsb/CEN25FA296.md): Helms Richard Lancair IVP · Greenwood, IN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 30, 2025 · N49BX · Destroyed
  > On July 30, 2025, at 1046 eastern daylight time, a Lancair IVP airplane, N49BX, was destroyed when it was involved in an accident near Greenwood, Indiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB GAA25WA220](https://openairdocs.org/ntsb/GAA25WA220.md): Cessna 210L · Turks and Caicos Islands, United Kingdom · Accident · Class 5 · Foreign · Jul 29, 2025 · N1110S · Substantial damage
- [NTSB ERA25LA278](https://openairdocs.org/ntsb/ERA25LA278.md): Orlican S R O M-8 Eagle · Lake Worth Beach, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 28, 2025 · N974FL · Substantial damage
  > On July 28, 2025, about 16:24 eastern daylight time, an Orlican M-8, N974FL, was substantially damaged when it was involved in an accident near Lake Worth Beach, Florida. The flight instructor sustained minor injuries, the private pilot sustained no injuries,…
- [NTSB DCA25WA277](https://openairdocs.org/ntsb/DCA25WA277.md): Boeing 737 · Mexico City, Mexico · Incident · No injuries · Class 5 · Foreign · Jul 28, 2025 · XA-PPP · No damage
- [NTSB WPR25FA225](https://openairdocs.org/ntsb/WPR25FA225.md): Mooney M20J · Nampa, ID · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 27, 2025 · N5764H · Substantial damage
  > On August 27, 2025, about 1741 mountain daylight time, a Mooney M20J, N5764H, was destroyed when it was involved in an accident near Nampa, Idaho. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB GAA25WA219](https://openairdocs.org/ntsb/GAA25WA219.md): Piper PA31 · Deer Lake, Canada · Accident · 2 fatal · Class 5 · Foreign · Jul 26, 2025 · C-GYYP · Substantial damage
- [NTSB CEN25LA288](https://openairdocs.org/ntsb/CEN25LA288.md): Piper PA-28RT-201T · Brookings, SD · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 26, 2025 · N8423H · Substantial damage
  > On July 26, 2025, at 1840 central daylight time, a Piper PA-28RT-201T airplane, N8423H, was substantially damaged when it was involved in an accident near Brookings, South Dakota. The airline transport pilot and passenger were uninjured. The airplane was…
- [NTSB ANC25FA079](https://openairdocs.org/ntsb/ANC25FA079.md): Piper J3C-65 · Dillingham, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 25, 2025 · N5050R · Substantial damage
  > On July 25, 2025, about 0916 Alaska daylight time, a Piper J3C-65 airplane, N5050R, was substantially damaged when it was involved in an accident near Dillingham, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA25FA272](https://openairdocs.org/ntsb/ERA25FA272.md): Piper PA46-500TP · Lititz, PA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 20, 2025 · N819MA · Substantial damage
  > On July 20, 2025, about 0800 eastern daylight time, a Piper PA-46-500TP Meridian airplane, N819MA, was substantially damaged when it was involved in an accident in Lititz, Pennsylvania. The pilot was the sole person on board and was fatally injured. The…
- [NTSB WPR25LA211](https://openairdocs.org/ntsb/WPR25LA211.md): Cessna 172S · Sisters, OR · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N787LF · Destroyed
  > On July 13, 2025, about 1106 Pacific daylight time, a Cessna 172S, N787LF, was substantially damaged when it was involved in an accident near Sisters, Oregon. The flight instructor was seriously injured, and the student pilot and pilot rated passenger…
- [NTSB DCA25WA262](https://openairdocs.org/ntsb/DCA25WA262.md): Airbus A320-232 · Nassau, Bahamas · Incident · Class 5 · Foreign · Jul 13, 2025 · N793JB · No damage
- [NTSB CEN25LA252](https://openairdocs.org/ntsb/CEN25LA252.md): Beech 35 · Cedarcreek, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 13, 2025 · N3181V · Substantial damage
  > The student pilot’s failure to attain a proper airspeed and climb attitude during takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were the student pilot’s lack of…
- [NTSB CEN25LA251](https://openairdocs.org/ntsb/CEN25LA251.md): Scott Vincin Just Acft Highlander · Mancos, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 13, 2025 · N970SV · Substantial damage
  > The airplane’s reduced climb performance during takeoff in mountainous terrain, which resulted in the airplane’s inability to climb and impact with terrain.
- [NTSB CEN25FA248](https://openairdocs.org/ntsb/CEN25FA248.md): Piper PA-25 · Hot Springs, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N8186K · Substantial damage
  > On July 12, 2025, about 1322 mountain daylight time, a Piper PA-25, N8186K, was substantially damaged when it was involved in an accident near Hot Springs, South Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25WA254](https://openairdocs.org/ntsb/DCA25WA254.md): Douglas DC9 · El Vigía, Venezuela · Incident · No injuries · Class 5 · Foreign · Jul 7, 2025 · YV3145 · Minor damage
- [NTSB GAA25WA210](https://openairdocs.org/ntsb/GAA25WA210.md): Jodel DR1050 · Châteauroux-Villers, France · Accident · 1 fatal · Class 5 · Foreign · Jul 5, 2025 · F-BJOZ · Destroyed
- [NTSB ERA25LA256](https://openairdocs.org/ntsb/ERA25LA256.md): Kyle Koncak Aventura II · DeLand, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 3, 2025 · N508K · Substantial damage
  > The uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.
- [NTSB CEN25LA232](https://openairdocs.org/ntsb/CEN25LA232.md): Bell 206B · Edgerton, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N16726 · Substantial damage
  > On July 1, 2025, at 0845 central daylight time, a Bell 206B, N17626, was substantially damaged when it was involved in an accident near Edgerton, Missouri. The commercial pilot was uninjured. The helicopter was operated under Title 14 Code of Federal…
- [NTSB GAA25WA196](https://openairdocs.org/ntsb/GAA25WA196.md): Cirrus Design SR22 · Remomeix, France · Accident · Class 5 · Foreign · Jun 28, 2025 · N675SR · Destroyed
- [NTSB GAA25WA195](https://openairdocs.org/ntsb/GAA25WA195.md): Cessna 172 · Chartres, France · Accident · Class 5 · Foreign · Jun 27, 2025 · F-GYDS · Destroyed
- [NTSB ENG25WA040](https://openairdocs.org/ntsb/ENG25WA040.md): Boeing 777 · Karachi, Pakistan · Incident · Class 5 · Foreign · Jun 27, 2025 · HZ-AK17 · No damage
- [NTSB ERA25LA243](https://openairdocs.org/ntsb/ERA25LA243.md): Cessna T188C · Mount Gilead, OH · Accident · No injuries · Class 4 · Limited · Final report · Jun 26, 2025 · N3619J · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while in a turn during initial climb and the exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.
- [NTSB ERA25LA238](https://openairdocs.org/ntsb/ERA25LA238.md): Cessna 310 · Fayetteville, TN · Accident · No injuries · Class 3 · Limited · Final report · Jun 24, 2025 · N5045Q · Substantial damage
  > The pilot’s decision to operate the airplane with known discrepancies.
- [NTSB ERA25LA235](https://openairdocs.org/ntsb/ERA25LA235.md): Cessna R182 · Milton, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 23, 2025 · N262AL · Substantial damage
  > Separation of the throttle cable sleeve during takeoff, which resulted an uncommanded engine power reduction and the pilot’s inability to control the engine throttle, and resulted in a forced landing.
- [NTSB CEN25FA216](https://openairdocs.org/ntsb/CEN25FA216.md): Murphy Aircraft Manufacturing Moose · Montrose, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 23, 2025 · N250MK · Destroyed
  > On June 23, 2025, about 1021 mountain daylight time, a Murphy Aircraft Manufacturing Limited Moose airplane, N250MK, was destroyed when it was involved in an accident near Montrose, Colorado. The pilot and the pilot-rated passenger sustained fatal injuries.…
- [NTSB GAA25WA193](https://openairdocs.org/ntsb/GAA25WA193.md): Messerschmitt-Bölkow-Blohm BK117 · Havre St-Pierre, Canada · Accident · Class 5 · Foreign · Jun 21, 2025 · C-GDPD
- [NTSB DCA25WA237](https://openairdocs.org/ntsb/DCA25WA237.md): Boeing 737 · Dubai, United Arab Emirates · Incident · No injuries · Class 5 · Foreign · Jun 16, 2025 · A6-FMU · No damage
- [NTSB DCA25LA234](https://openairdocs.org/ntsb/DCA25LA234.md): Boeing 737-7H4 · Ebro, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 14, 2025 · N969WN · No damage
  > The airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…
- [NTSB DCA25LA233](https://openairdocs.org/ntsb/DCA25LA233.md): Boeing 747-47UF · Guayaquil, Ecuador · Incident · No injuries · Class 4 · Limited · Investigation open · Jun 12, 2025 · N476MC · Minor damage
- [NTSB WPR25FA169](https://openairdocs.org/ntsb/WPR25FA169.md): Cessna 414 · San Diego, CA · Accident · 6 fatal · Class 3 · Field · Preliminary report · Jun 8, 2025 · N414BA · Substantial damage
  > On June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25LA199](https://openairdocs.org/ntsb/CEN25LA199.md): Cessna 182P · Mineral Wells, TX · Accident · No injuries · Class 4 · Limited · Final report · Jun 8, 2025 · N7376N · Substantial damage
  > The pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.
- [NTSB WPR25LA171](https://openairdocs.org/ntsb/WPR25LA171.md): Yakovlev YAK-50 · Hayward, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 7, 2025 · N150YK · Substantial damage
  > On June 7, 2025, about 1252 Pacific daylight time, a Yakovlev YAK-50, N150YK, was substantially damaged when it was involved in an accident near Hayward, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA170](https://openairdocs.org/ntsb/WPR25LA170.md): Cessna 150M · Phoenix, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 6, 2025 · N45659 · Substantial damage
  > On June 6, 2025, about 0530 mountain standard time, a Cessna 150M, N45659, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane was operated as a…
- [NTSB ERA25LA225](https://openairdocs.org/ntsb/ERA25LA225.md): Cessna 150J · Elberta, AL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 1, 2025 · N150FJ · Substantial damage
  > On June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…
- [NTSB ENG25WA037](https://openairdocs.org/ntsb/ENG25WA037.md): Boeing 737 · Muscat, Oman · Incident · No injuries · Class 5 · Foreign · May 31, 2025 · A4O-ML · Minor damage
- [NTSB ERA25FA211](https://openairdocs.org/ntsb/ERA25FA211.md): Zenith Stol CH701 · Geneva, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 25, 2025 · N514JG · Substantial damage
  > On May 25, 2025, about 1007 eastern daylight time, an experimental, amateur-built Zenith STOL CH701, N514JG, was substantially damaged when it was involved in an accident near Geneva, Ohio. The pilot was fatally injured and the pilot-rated passenger sustained…
- [NTSB CEN25LA186](https://openairdocs.org/ntsb/CEN25LA186.md): Aeronca 7AC · Westphalia, MI · Accident · No injuries · Class 3 · Limited · Preliminary report · May 24, 2025 · N2659E · Substantial damage
  > On May 24, 2025, at 1300 eastern daylight time, an Aeronca 7AC, N2659E, was substantially damaged when it was involved in an accident near Westphalia, Michigan. The commercial pilot was not injured. The airplane was operated under Title 14 Code of Federal…
- [NTSB WPR25LA159](https://openairdocs.org/ntsb/WPR25LA159.md): North American T-28B · Olivehurst, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 17, 2025 · N28DE · Substantial damage
  > On May 17, 2025, at 1022 Pacific daylight time, a North American T-28B, N28DE, was substantially damaged when it was involved in an accident near Marysville, California. The pilot and passenger were seriously injured. The airplane was operated as a Title 14…
- [NTSB ERA25LA203](https://openairdocs.org/ntsb/ERA25LA203.md): Seamax Aircraft Ltda Seamax M-22 · Dahlgren Center, VA · Accident · Serious injuries · Class 3 · Limited · Final report · May 17, 2025 · N154RL · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a known…
- [NTSB DCA25WA217](https://openairdocs.org/ntsb/DCA25WA217.md): Boeing 777 · Schiphol, Netherlands · Incident · Class 5 · Foreign · May 17, 2025 · PH-BVW · No damage
- [NTSB ERA25FA202](https://openairdocs.org/ntsb/ERA25FA202.md): Harteveld Drew J Chinook Plus 2 · Pittstown, NJ · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 16, 2025 · N3300K · Destroyed
  > On May 16, 2025, about 1642 eastern daylight time, an experimental, amateur-built Chinook Plus 2, N3300K, was destroyed when it was involved in an accident near Pittstown, NJ. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB CEN25LA182](https://openairdocs.org/ntsb/CEN25LA182.md): Beech F33A · Houston, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 16, 2025 · N6376S · Destroyed
  > On May 16, 2025, about 1459 central daylight time, a Beech F33A airplane, N6376S, was destroyed when it was involved in an accident near Houston, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB WPR25LA155](https://openairdocs.org/ntsb/WPR25LA155.md): Piper PA-18-150 · Enumclaw, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 10, 2025 · N333TM · Substantial damage
  > On May 10, 2025, about 1412 Pacific daylight time, a Piper PA-18-150, N333TM, was substantially damaged when it was involved in an accident near Enumclaw, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA25FA201](https://openairdocs.org/ntsb/ERA25FA201.md): Piper PA32RT · Yulee, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 10, 2025 · N30689 · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…
- [NTSB WPR25LA154](https://openairdocs.org/ntsb/WPR25LA154.md): Lee JA30 Superstol · Evanston, WY · Accident · No injuries · Class 3 · Limited · Preliminary report · May 9, 2025 · N128EL · Substantial damage
  > On May 9, 2025, about 1020 mountain daylight time, an experimental amateur-built Just Aircraft Superstol, N128EL, was substantially damaged when it was involved in an accident near Evanston, Wyoming. The pilot and passenger were not injured. The airplane was…
- [NTSB ERA25LA198](https://openairdocs.org/ntsb/ERA25LA198.md): Diamond Aircraft Ind DA 40 NG · Sanford, NC · Accident · Serious injuries · Class 3 · Limited · Final report · May 7, 2025 · N499BW · Substantial damage
  > The mechanic’s re-use of worm drive clamps, which resulted in a separation of the turbocharger air discharge duct and a partial loss of engine power during initial climb.
- [NTSB ERA25LA194](https://openairdocs.org/ntsb/ERA25LA194.md): Cessna 172 · Hastings, FL · Accident · Minor injuries · Class 4 · Limited · Final report · May 3, 2025 · N127EP · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.

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

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

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