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

## Cases, newest first

- [NTSB CEN25LA163](https://openairdocs.org/ntsb/CEN25LA163.md): Messerschmitt-Bolkow-Blohm BK 117 · Hartford, IL · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 25, 2025 · N880SL · Substantial damage
  > The pilot’s failure to maintain directional control during the initial climb at night from a confined area landing zone, that resulted in an impact with a tree, a loss of control, and a subsequent impact with terrain.
- [NTSB ERA25LA188](https://openairdocs.org/ntsb/ERA25LA188.md): Cessna 172RG · Louisburg, NC · Accident · No injuries · Class 3 · Limited · Final report · Apr 23, 2025 · N6386V · Substantial damage
  > Maintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.
- [NTSB CEN25LA162](https://openairdocs.org/ntsb/CEN25LA162.md): Cessna T210N · Fayetteville, AR · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 22, 2025 · N4795C · Substantial damage
  > On April 22, 2025, about 13:25 central daylight time a Cessna T210N, N4795C was involved in an accident near Fayetteville, Arkansas. The pilot and two passengers were not injured. The flight was operated under the provisions of Title 14 Code of Federal…
- [NTSB ERA25LA177](https://openairdocs.org/ntsb/ERA25LA177.md): Beech A24 · Greenville, SC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 17, 2025 · N8060R · Substantial damage
  > On April 17, 2025, about 1540 eastern daylight time, a Beech A24 airplane, N8060R, was substantially damaged when it was involved in an accident at the Greenville Downtown Airport (GMU), Greenville, South Carolina. The pilot sustained minor injuries. The…
- [NTSB DCA25WA205](https://openairdocs.org/ntsb/DCA25WA205.md): Boeing 737-800 · Uberlândia, Brazil · Incident · Class 5 · Foreign · Apr 11, 2025 · PR-GUI
- [NTSB ERA25LA164](https://openairdocs.org/ntsb/ERA25LA164.md): Cessna 172N · Hickory, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 1, 2025 · N79514 · Substantial damage
  > The student pilot’s failure to maintain airplane control during an attempted go-around, which resulted in an aerodynamic stall/spin and collision with terrain.
- [NTSB ERA25FA158](https://openairdocs.org/ntsb/ERA25FA158.md): Cirrus Design SR22 · Franklin Township, NJ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 30, 2025 · N319TM · Substantial damage
  > On March 30, 2025, about 1034 eastern daylight time, a Cirrus SR22, N319TM, was substantially damaged when it was involved in an accident near Franklin Township, New Jersey. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB ERA25LA207](https://openairdocs.org/ntsb/ERA25LA207.md): Piper PA-18-150 · Winter Haven, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2025 · N38BS · Substantial damage
  > The pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.
- [NTSB OPS25LA032](https://openairdocs.org/ntsb/OPS25LA032.md): Airbus A319-114 · Arlington, VA · Incident · Class 3 · Limited · Preliminary report · Mar 28, 2025 · N342NB · 2 aircraft · No damage
  > On March 28, 2025, about 1516 eastern daylight time (EDT), DRAGO61, a flight of four US Air Force Northrop T38s, enroute to conduct an aerial flyby at Arlington National Cemetery, and Delta (DAL) Air Lines flight 2983 (DAL2983), an Airbus 319-114, N342NB,…
- [NTSB GAA25WA127](https://openairdocs.org/ntsb/GAA25WA127.md): Cessna 152 · Antanhol, Portugal · Accident · Class 5 · Foreign · Mar 28, 2025 · CS-EBF · Destroyed
- [NTSB DCA25LA174](https://openairdocs.org/ntsb/DCA25LA174.md): Pyka Pelican · Dixon, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 28, 2025 · N939NP · Substantial damage
  > The flight control system’s unanticipated transition to takeoff abort mode due to a software error in the autonomous flight control system, which resulted in a premature throttle reduction and hard landing.
- [NTSB ERA25LA155](https://openairdocs.org/ntsb/ERA25LA155.md): Cirrus Design SF50 · Kissimmee, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 24, 2025 · N56GY · Substantial damage
  > On March 24, 2025 about 0804 eastern daylight time, a Cirrus Design Corporation SF50, N56GY, was substantially damaged when it was involved in an accident at Kissimmee Gateway Airport (ISM), Orlando, Florida. The commercial pilot was not injured. The airplane…
- [NTSB DCA25WA164](https://openairdocs.org/ntsb/DCA25WA164.md): Boeing 767 · Managua, Nicaragua · Incident · No injuries · Class 5 · Foreign · Mar 23, 2025 · N373CM
- [NTSB ERA25LA149](https://openairdocs.org/ntsb/ERA25LA149.md): Cessna 162 · Miami, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 19, 2025 · N62PT · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during a go-around, which resulted in an aerodynamic stall.
- [NTSB GAA25WA115](https://openairdocs.org/ntsb/GAA25WA115.md): JetstreaM 32 · Coxen Hole, Honduras · Accident · Class 5 · Foreign · Mar 18, 2025 · HR-AYW · Substantial damage
- [NTSB ERA25LA147](https://openairdocs.org/ntsb/ERA25LA147.md): Champion 7AC · Palmetto, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 18, 2025 · N1369E · Substantial damage
  > The flight instructor’s inability to overpower control inputs made by the student pilot during initial climb, which resulted in the airplane impacting powerlines and the ground.
- [NTSB ANC25LA025](https://openairdocs.org/ntsb/ANC25LA025.md): Cessna 172A · Fairbanks, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 16, 2025 · N7274T · Substantial damage
  > The pilot’s decision to initiate the flight despite identifying a malfunction in the carburetor heat system during the pre-takeoff engine run-up, which led to a partial loss of engine power during climb out. Contributing to the accident was maintenance…
- [NTSB CEN25FA124](https://openairdocs.org/ntsb/CEN25FA124.md): Robinson Helicopter R44 · Danville, VA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 15, 2025 · N331ES · Destroyed
  > On March 15, 2025, about 1500 eastern daylight time, a Robinson R44 helicopter, N331ES, was destroyed when it was involved in an accident near Danville, Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB ERA25LA145](https://openairdocs.org/ntsb/ERA25LA145.md): Wild Sky Goat · Chester, CT · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Mar 14, 2025 · N372WS · Substantial damage
  > On March 14, 2025, about 1515 eastern daylight time, an experimental amateur-built Wild Sky Goat light-sport aircraft, N372WS, was substantially damaged when it was involved in an accident near Chester, Connecticut. The commercial pilot sustained fatal…
- [NTSB ERA25FA143](https://openairdocs.org/ntsb/ERA25FA143.md): Raytheon A36 · Greenville, NC · Accident · 2 fatal · Class 3 · Field · Final report · Mar 14, 2025 · N566C · Destroyed
  > The pilot’s loss of airplane control shortly after climbing into instrument meteorological conditions due to spatial disorientation (somatogyral illusion).
- [NTSB ENG25WA034](https://openairdocs.org/ntsb/ENG25WA034.md): Airbus A321 · Ciudad de México, Mexico · Occurrence · Class 5 · Foreign · Mar 13, 2025 · XA-VXP · No damage
- [NTSB ERA25LA141](https://openairdocs.org/ntsb/ERA25LA141.md): Piper PA-28-181 · Hollywood, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 12, 2025 · N3055B · Substantial damage
  > A total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…
- [NTSB CEN25LA117](https://openairdocs.org/ntsb/CEN25LA117.md): Vans RV-7A · Plainview, TX · Accident · No injuries · Class 3 · Limited · Final report · Mar 10, 2025 · N923ZA · Substantial damage
  > The improper machining of the propeller blade bearing seat, which resulted in an inflight propeller blade fatigue failure. Contributing to the accident was the improper machining of the propeller hub and propeller blade root and machining surface quality…
- [NTSB CEN25LA114](https://openairdocs.org/ntsb/CEN25LA114.md): Beech A23-19 · Rochester, MN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 10, 2025 · N4784J · Substantial damage
  > On March 9, 2025, about 2215 central daylight time, a Beech A23-19, N4784J, was substantially damaged when it was involved in an accident near Rochester, Minnesota. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25WA154](https://openairdocs.org/ntsb/DCA25WA154.md): Boeing 737-400 · Bogotá, Colombia · Incident · No injuries · Class 5 · Foreign · Mar 3, 2025 · YV622T
- [NTSB DCA25FA148](https://openairdocs.org/ntsb/DCA25FA148.md): Boeing 767 · Newark, NJ · Incident · No injuries · Class 3 · Field · Preliminary report · Mar 1, 2025 · N178FE · Minor damage
  > On March 1, 2025, at 0800 eastern standard time, FedEx flight 3609, a Boeing 767-300F, powered by two General Electric CF6-80C2 turbofan engines, registration number N178FE, struck birds during initial climb after takeoff from Newark Liberty International…
- [NTSB WPR25LA103](https://openairdocs.org/ntsb/WPR25LA103.md): Amazon.Com Services MK30 · Pendleton, OR · Accident · No injuries · Class 4 · Limited · Final report · Feb 21, 2025 · N265PA · Substantial damage
  > The unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.
- [NTSB ERA25LA123](https://openairdocs.org/ntsb/ERA25LA123.md): Cessna 172C · Argyle, NY · Accident · No injuries · Class 4 · Limited · Final report · Feb 20, 2025 · N1609Y · Substantial damage
  > The mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…
- [NTSB ANC25LA020](https://openairdocs.org/ntsb/ANC25LA020.md): Cessna 172M · Kapolei, HI · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 20, 2025 · N19867 · Substantial damage
  > The flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.
- [NTSB CEN25LA096](https://openairdocs.org/ntsb/CEN25LA096.md): Grumman American Avn. AA-5A · Gladewater, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 18, 2025 · N26071 · Substantial damage
  > On February 17, 2025, about 2215 central standard time, a Grumman AA-5A airplane, N26071, was substantially damaged when it was involved in an accident near Gladewater, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25LA099](https://openairdocs.org/ntsb/CEN25LA099.md): Cessna 172N · Pearland, TX · Accident · No injuries · Class 4 · Limited · Final report · Feb 17, 2025 · N2913E · Substantial damage
  > The pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA25LA122](https://openairdocs.org/ntsb/ERA25LA122.md): Allyn Kaste Rans S-19 (KIT) · Doylestown, PA · Accident · No injuries · Class 4 · Limited · Final report · Feb 10, 2025 · N258DK · Substantial damage
  > The pilot’s inadequate maintenance and preflight inspection.
- [NTSB ENG25WA024](https://openairdocs.org/ntsb/ENG25WA024.md): Airbus A380 · Dubai, United Arab Emirates · Incident · No injuries · Class 5 · Foreign · Feb 6, 2025 · A6-E0L · Minor damage
- [NTSB GAA25WA073](https://openairdocs.org/ntsb/GAA25WA073.md): Cessna 550 · Baruta, Venezuela · Accident · 3 fatal · Class 3 · Foreign · Jan 29, 2025 · YV3561 · Destroyed
- [NTSB ENG25WA015](https://openairdocs.org/ntsb/ENG25WA015.md): Bombardier BD100 1A10 · Nassau, Bahamas · Incident · Class 5 · Foreign · Jan 20, 2025 · CS-CHJ · No damage
- [NTSB CEN25LA080](https://openairdocs.org/ntsb/CEN25LA080.md): Luscombe 8 · Omaha, NE · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 16, 2025 · N71586 · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN25LA079](https://openairdocs.org/ntsb/CEN25LA079.md): Piper PA-24-250 · Tyler, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 15, 2025 · N8051P · Substantial damage
  > An electrical system surge for a reason that could not be determined that resulted in an overvoltage event, internal damage to electronics equipment, smoke in the cockpit, and a gear up landing.
- [NTSB CEN25LA077](https://openairdocs.org/ntsb/CEN25LA077.md): Piper PA-28-181 · Addison, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 15, 2025 · N504AF · Substantial damage
  > A partial loss of engine power during takeoff due to the partial blockage of the fuel diaphragm metering stem and the No. 1 cylinder fuel injector nozzle. Contributing to the accident was maintenance that allowed the introduction of debris that resulted in…
- [NTSB GAA25WA068](https://openairdocs.org/ntsb/GAA25WA068.md): Thrush S2R · Uberaba, state of Minas Gerais, MG, Brazil · Accident · No injuries · Class 5 · Foreign · Jan 11, 2025 · PR-FIM · Substantial damage
- [NTSB WPR25LA073](https://openairdocs.org/ntsb/WPR25LA073.md): Cessna 150D · Temple City, CA · Accident · Class 4 · Limited · Final report · Jan 6, 2025 · N5943T · Substantial damage
  > The flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.
- [NTSB GAA25WA049](https://openairdocs.org/ntsb/GAA25WA049.md): Rockwell International 112TCA · Fife, United Kingdom · Accident · 1 fatal · Class 5 · Foreign · Dec 23, 2024 · N4698W · Substantial damage
- [NTSB ERA25FA082](https://openairdocs.org/ntsb/ERA25FA082.md): Cessna 172 · Cintrona, PR · Accident · 1 fatal · Class 3 · Field · Final report · Dec 20, 2024 · N22088 · Destroyed
  > Maintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.
- [NTSB DCA25WA089](https://openairdocs.org/ntsb/DCA25WA089.md): Boeing 737-832 · Belize City, Belize · Incident · No injuries · Class 5 · Foreign · Dec 19, 2024 · N3772H · 2 aircraft · No damage
- [NTSB ANC25FA010](https://openairdocs.org/ntsb/ANC25FA010.md): Cessna 208B · Honolulu, HI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Dec 18, 2024 · N689KA · Destroyed
  > On December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…
- [NTSB ERA25FA071](https://openairdocs.org/ntsb/ERA25FA071.md): Magni Builder M-16 · Foley, AL · Accident · 1 fatal · Class 3 · Field · Final report · Dec 9, 2024 · N271BP · Substantial damage
  > The sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.
- [NTSB CEN25FA056](https://openairdocs.org/ntsb/CEN25FA056.md): Zenith Zodiac CH601 · Columbia, IL · Accident · Serious injuries · Class 3 · Field · Final report · Dec 8, 2024 · N9853M · Destroyed
  > The pilot’s failure to secure the engine oil filter following maintenance, which resulted in oil starvation, a total loss of engine power, and impact with terrain.
- [NTSB CEN25LA054](https://openairdocs.org/ntsb/CEN25LA054.md): American AA-1B · Brenham, TX · Accident · No injuries · Class 3 · Limited · Final report · Dec 1, 2024 · N6242L · Substantial damage
  > A partial loss of engine power due to an obstructed induction system from a mud dauber nest.
- [NTSB ERA25LA062](https://openairdocs.org/ntsb/ERA25LA062.md): Alexander S Rolinski BOT Journey · Ocean Isle Beach, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 27, 2024 · N814B · Substantial damage
  > Maintenance personnel’s failure to identify and remediate a buildup of oxides in one of the engine’s carburetors, which resulted in the seizure of the carburetor’s piston slide and a subsequent total loss of engine power during initial climb.
- [NTSB WPR25LA048](https://openairdocs.org/ntsb/WPR25LA048.md): Mooney M20F · Fullerton, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 25, 2024 · N9245V · Substantial damage
  > The loss of engine power during departure for reasons that could not be determined.
- [NTSB ERA25LA052](https://openairdocs.org/ntsb/ERA25LA052.md): Cessna 172S · Chattanooga, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 19, 2024 · N951JA · Substantial damage
  > A partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…

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

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

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