# Final 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 1 of 400 · 19,996 cases

## Latest cases

- [NTSB WPR26LA263](https://openairdocs.org/ntsb/WPR26LA263.md): Schleicher ASW-27 · Montague, CA · Accident · No injuries · Class 4 · Limited · Final report · Jul 15, 2026 · N920KB · Substantial damage
  > The pilot’s inability to see and avoid a piece of loose wire in a field during an off-airport landing in a glider, which resulted in a ground loop. Contributing to the accident was the pilot’s inability to maintain a safe position behind the tow airplane…
- [NTSB CEN26LA246](https://openairdocs.org/ntsb/CEN26LA246.md): Rotec Engineering Rally 3 · Hooker, OK · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 7, 2026 · UNREG · Substantial damage
  > The total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.
- [NTSB CEN26LA244](https://openairdocs.org/ntsb/CEN26LA244.md): Cassutt Iiim · Odessa, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 5, 2026 · N45889 · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…
- [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 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 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 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 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 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 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 ERA26LA092](https://openairdocs.org/ntsb/ERA26LA092.md): Cessna 172P · Flemington, GA · Accident · No injuries · Class 4 · Limited · Final report · Jan 9, 2026 · N96493 · Substantial damage
  > The pilot’s inadvertent manipulation of the mixture control, which resulted in a total loss of engine power during initial climb and a subsequent forced lading.
- [NTSB CEN26LA077](https://openairdocs.org/ntsb/CEN26LA077.md): Beech B35 · La Casa, TX · Accident · No injuries · Class 4 · Limited · Final report · Jan 2, 2026 · N5174C · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during initial climb after takeoff, leading to an aerodynamic stall and impact with trees.
- [NTSB ERA26LA062](https://openairdocs.org/ntsb/ERA26LA062.md): Cessna 172 · Pensacola, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 7, 2025 · N6542H · Substantial damage
  > The pilot’s exceedance of the critical angle of attack during initial climb which resulted in an aerodynamic stall.
- [NTSB ANC26LA007](https://openairdocs.org/ntsb/ANC26LA007.md): Danchini Aero Danchini Cub · Wasilla, AK · Accident · No injuries · Class 4 · Limited · Final report · Nov 24, 2025 · N794AK · Substantial damage
  > The pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.
- [NTSB ERA26LA047](https://openairdocs.org/ntsb/ERA26LA047.md): Torres Ruben Aventura II · Culebrita Beach, PR · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 15, 2025 · N258RS · Substantial damage
  > The pilot's failure to maintain directional control during the initial climb, which resulted in abnormal contact with the water and a subsequent collision with vegetation.
- [NTSB ERA26LA022](https://openairdocs.org/ntsb/ERA26LA022.md): Rans Employee Flying Club Rans S-6ES Coyote II · Williston, SC · Accident · No injuries · Class 4 · Limited · Final report · Oct 24, 2025 · N43822 · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during the initial climb in gusting crosswind conditions.
- [NTSB ERA26LA023](https://openairdocs.org/ntsb/ERA26LA023.md): Cessna 152 · St. Augustine, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 23, 2025 · N95005 · Substantial damage
  > The student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.
- [NTSB ERA26LA008](https://openairdocs.org/ntsb/ERA26LA008.md): Champion 7ECA · East Rockingham, NC · Accident · No injuries · Class 4 · Limited · Final report · Oct 7, 2025 · N63BC · Substantial damage
  > The pilot’s failure to maintain control of the airplane during initial climb, resulting in an aerodynamic stall and impact with terrain.
- [NTSB WPR25LA283](https://openairdocs.org/ntsb/WPR25LA283.md): Cessna 150F · Rigby, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 17, 2025 · N8047F · Substantial damage
  > The flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.
- [NTSB WPR25LA308](https://openairdocs.org/ntsb/WPR25LA308.md): Thomas Graham Teenie Two · Chehalis, WA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 11, 2025 · N311TS · Substantial damage
  > The pilot's improper decision to take off with the airplane over its maximum allowable gross weight, which degraded its climb performance and led to a subsequent off airport landing.
- [NTSB CEN25LA382](https://openairdocs.org/ntsb/CEN25LA382.md): Beech C23 · South Bend, IN · Accident · No injuries · Class 4 · Limited · Final report · Sep 10, 2025 · N997V · Substantial damage
  > The pilot’s failure to maintain control of the airplane during a go around which resulted in an aerodynamic stall. Contributing to the accident was the loss of directional control during the landing roll.
- [NTSB ERA25LA342](https://openairdocs.org/ntsb/ERA25LA342.md): Schweizer G-164B · Dover, DE · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 9, 2025 · N8483K · Substantial damage
  > The pilot’s exceedance of the critical angle of attack which resulted in an aerodynamic stall at an altitude too low to recover.
- [NTSB ERA25LA324](https://openairdocs.org/ntsb/ERA25LA324.md): Cessna 172 · New Smyrna Beach, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 29, 2025 · N1607F · Substantial damage
  > Maintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.
- [NTSB CEN25LA355](https://openairdocs.org/ntsb/CEN25LA355.md): Cessna 172M · Lubbock, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 27, 2025 · N92356 · Substantial damage
  > The pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.
- [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 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 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 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 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 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 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 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.
- [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 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 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 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 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 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 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 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 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…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?status=final&page=2

## 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."completionStatus" = 'Completed'
  AND 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?status=final

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