# NTSB investigations: Enroute

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 8 of 718 · 35,883 cases

## Cases, newest first

- [NTSB ERA25LA346](https://openairdocs.org/ntsb/ERA25LA346.md): Piper PA-24-180 · Ashland City, TN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 5, 2025 · N5759P · Substantial damage
  > On September 5, 2025, at 1645 central daylight time, N5759P, a Piper Cherokee PA-24-180, sustained substantial damage when it was involved in an accident near Ashland City, Tennessee. The private pilot sustained minor injuries. The flight was conducted as a…
- [NTSB ERA25FA332](https://openairdocs.org/ntsb/ERA25FA332.md): Czech Sport Sportcruiser · Fryeburg, ME · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 4, 2025 · N336SC · Substantial damage
  > On September 4, 2025, about 1418 eastern daylight time, a Czech Sport Aircraft Sportcruiser, N336SC, was substantially damaged when it was involved in an accident near Fryeburg, Maine. The private pilot was fatally injured. The airplane was operated as a…
- [NTSB GAA25WA259](https://openairdocs.org/ntsb/GAA25WA259.md): Cessna U206 · Alto Alegre, Brazil · Accident · No injuries · Class 5 · Foreign · Sep 3, 2025 · PS-SLM · Substantial damage
- [NTSB ERA25LA327](https://openairdocs.org/ntsb/ERA25LA327.md): Mark Strout Zenair Zodiac 601HDS · Connerton, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 1, 2025 · N680LM · Substantial damage
  > On September 01, 2025 about 1605 eastern standard time, an experimental amateur-built Zenith Zodiac 601 HDS, N680LM, was substantially damaged when it was involved in an accident near Connerton, Florida. The pilot and the passenger received minor injuries.…
- [NTSB DCA25WA325](https://openairdocs.org/ntsb/DCA25WA325.md): Airbus A320 · Chennai, India · Incident · Class 5 · Foreign · Sep 1, 2025 · VT-ATF · No damage
- [NTSB ANC25FA098](https://openairdocs.org/ntsb/ANC25FA098.md): Piper PA-28-180 · Wolf, WY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 1, 2025 · N8307W · Substantial damage
  > On September 1, 2025 about 1612 mountain daylight time, a Piper PA-28-180 airplane, N8307W, was substantially damaged when it was involved in an accident near Wolf, Wyoming. The pilot and one passenger were seriously injured; one passenger was fatally…
- [NTSB WPR25FA269](https://openairdocs.org/ntsb/WPR25FA269.md): Piper PA-28R-200 · Alta, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 31, 2025 · N1147X · Substantial damage
  > On August 31, 2025, about 1720, mountain daylight time a Piper PA28-200R, N1147X, was substantially damaged when it was involved in an accident near Alta, Utah. The pilot was seriously injured, and the passenger sustained fatal injuries. The airplane was…
- [NTSB DCA25LA307](https://openairdocs.org/ntsb/DCA25LA307.md): Embraer S A ERJ 170-200 LL · Peaster, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 29, 2025 · N110SY · No damage
  > The airplane’s encounter with convective turbulence that resulted in serious injuries to a passenger who was out of their seat when the seatbelt sign was illuminated.
- [NTSB DCA25LA306](https://openairdocs.org/ntsb/DCA25LA306.md): Airbus Industrie A320-212 · Chase City, VA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 28, 2025 · N373NW · No damage
  > The abrupt maneuver required to comply with a traffic alert and collision avoidance system resolution advisory during descent.
- [NTSB CEN25LA357](https://openairdocs.org/ntsb/CEN25LA357.md): Piper PA-24-250 · Gregory, MI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 28, 2025 · N7412P · Substantial damage
  > On August 28, 2025, at about 1550 eastern daylight time, a Piper PA-24-250 airplane, N7412P, was substantially damaged when it was involved in an accident near Gregory, Michigan. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…
- [NTSB ENG25WA051](https://openairdocs.org/ntsb/ENG25WA051.md): Boeing 727 · Caracas, Venezuela · Incident · Class 5 · Foreign · Aug 26, 2025 · YV665T · No damage
- [NTSB CEN25LA347](https://openairdocs.org/ntsb/CEN25LA347.md): Beech C35 · Lakeview, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 26, 2025 · N655D · Substantial damage
  > The pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.
- [NTSB WPR25LA265](https://openairdocs.org/ntsb/WPR25LA265.md): Cessna 120 · Taylor, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N3151N · Substantial damage
  > On August 24, 2025, about 0711 mountain daylight time, a Cessna 120, N3151N, was substantially damaged when it was involved in an accident near Taylor, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB GAA25WA243](https://openairdocs.org/ntsb/GAA25WA243.md): Cessna TU206 · Mitu, Colombia · Accident · 4 fatal · Class 3 · Foreign · Aug 24, 2025 · HK1833 · Destroyed
- [NTSB CEN25LA342](https://openairdocs.org/ntsb/CEN25LA342.md): Cirrus Design SR22 · Granbury, TX · Accident · No injuries · Class 4 · Limited · Final report · Aug 24, 2025 · N376CD · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB DCA25LA312](https://openairdocs.org/ntsb/DCA25LA312.md): Mcdonnell Douglas MD 83 · Miami, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 23, 2025 · N805WA · No damage
  > An encounter with convective turbulence during descent that resulted in a serious injury to a flight attendant.
- [NTSB ANC25LA091](https://openairdocs.org/ntsb/ANC25LA091.md): Vu Holdings LLC/DBA Vanilla UN VA 001 · Ninilchik, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 20, 2025 · N246VU · Substantial damage
  > On August 20, 2025, at about 0632 Alaska daylight time, a Platform Aerospace VA 001 Unmanned Aerial System (UAS), N246VU, was substantially damaged when it was involved in an accident on a beachside cliff near Ninilchik, Alaska. The aircraft was unmanned. The…
- [NTSB CEN25LA327](https://openairdocs.org/ntsb/CEN25LA327.md): Marshall Allen L RV6A · Centerview, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 19, 2025 · N692AC · Substantial damage
  > On August 19, 2025, at 1640 central daylight time, a Vans RV-6A airplane, N692AC, was substantially damaged when it was involved in an accident near Centerview, Missouri. The commercial pilot sustained minor injuries and the passenger was uninjured. The…
- [NTSB CEN25FA321](https://openairdocs.org/ntsb/CEN25FA321.md): Lancair NLA-275-FR-C · Bradley, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 19, 2025 · N345LA · Destroyed
  > On August 18, 2025, about 2133 central daylight time, a Lancair NLA-275-FR-C airplane, N345LA, was destroyed when it was involved in an accident near Bradley, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA267](https://openairdocs.org/ntsb/WPR25LA267.md): David Ullman Jabirwatt · Albany, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 18, 2025 · N824DW · Substantial damage
  > On August 18, 2025, about 1300 Pacific daylight time, an experimental amateur-built Jabirwatt, N824DW, was substantially damaged when it was involved in an accident near Albany, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code…
- [NTSB GAA25WA245](https://openairdocs.org/ntsb/GAA25WA245.md): Embraer EMB721 · Cano Negro, Bolivia · Accident · No injuries · Class 5 · Foreign · Aug 18, 2025 · CP-2003 · Substantial damage
- [NTSB WPR25LA261](https://openairdocs.org/ntsb/WPR25LA261.md): Piper PA-28-181 · San Diego, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 17, 2025 · N8150J · Substantial damage
  > On August 16, 2025, about 1737 Pacific daylight time, a Piper PA-28-181, N8150J, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…
- [NTSB GAA25WA260](https://openairdocs.org/ntsb/GAA25WA260.md): Aerospool WT9 Dynamic LSA · Orbe, Switzerland · Accident · 1 fatal · Class 4 · Foreign · Aug 16, 2025 · HB-WZN · Substantial damage
- [NTSB CEN25LA326](https://openairdocs.org/ntsb/CEN25LA326.md): Robinson Helicopter R44 II · Cape Girardeau, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 16, 2025 · N24DF · Substantial damage
  > On August 16, 2025, at 1150 central daylight time, a Robinson R44 II helicopter, N24DF was substantially damaged when it was involved in an accident near Cape Girardeau, Missouri. The pilot and three passengers were not injured. The helicopter was operated as…
- [NTSB WPR25FA256](https://openairdocs.org/ntsb/WPR25FA256.md): Beech M35 · Des Moines, NM · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 14, 2025 · N951T · Destroyed
  > On August 13, 2025, about 2300 mountain daylight time, a Beech M35, N951T, was destroyed when it was involved in an accident near Des Moines, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25WA295](https://openairdocs.org/ntsb/DCA25WA295.md): Boeing 787 · Banksmeadow, Australia · Incident · Class 5 · Foreign · Aug 14, 2025 · ZK-NZR · No damage
- [NTSB CEN25FA320](https://openairdocs.org/ntsb/CEN25FA320.md): Cessna 172L · Walters, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 14, 2025 · N2860Q · Destroyed
  > On August 14, 2025, about 0934 central daylight time, a Cessna 172L, N2860Q, was destroyed when it was involved in an accident near Walters, Oklahoma. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code of Federal Regulations as…
- [NTSB ERA25LA299](https://openairdocs.org/ntsb/ERA25LA299.md): Cessna 150 · Fordsville, KY · Accident · No injuries · Class 4 · Limited · Final report · Aug 13, 2025 · N9400U · Substantial damage
  > The pilot’s improper fuel planning, which resulted in fuel exhaustion and a subsequent forced landing.
- [NTSB DCA25WA298](https://openairdocs.org/ntsb/DCA25WA298.md): Boeing 737 · Comboyne, Australia · Incident · No injuries · Class 5 · Foreign · Aug 13, 2025 · VH-IJU · No damage
- [NTSB DCA25WA294](https://openairdocs.org/ntsb/DCA25WA294.md): Boeing 737 · Madrid, Spain · Incident · Class 5 · Foreign · Aug 13, 2025 · 9H-VVL · Minor damage
- [NTSB CEN25LA317](https://openairdocs.org/ntsb/CEN25LA317.md): Cessna P210 · Zapata, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 13, 2025 · N92MS · Substantial damage
  > On August 13, 2025, about 1835 central daylight time, a Cessna P210N airplane, N92MS, was substantially damaged when it was involved in an accident near Zapata, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25LA297](https://openairdocs.org/ntsb/ERA25LA297.md): Piper PA-12 · Ponce Inlet, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 11, 2025 · N2504M · Substantial damage
  > On August 11, 2024, about 1359 easter daylight time, a Piper PA-12, N2504M, was substantially damaged when it was involved in an accident near Ponce Inlet, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA25LA307](https://openairdocs.org/ntsb/ERA25LA307.md): Beech A36 · Wirt County, WV · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 8, 2025 · N60357 · Substantial damage
  > On August 8, 2025, about 1757 eastern daylight time, a Beech A36, N60357, was substantially damaged when it was involved in an accident in Wirt County, West Virginia. The commercial pilot and three passengers were not injured. The airplane was operated as a…
- [NTSB CEN25LA310](https://openairdocs.org/ntsb/CEN25LA310.md): Cirrus Design SR22 · Jaroso, CO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 7, 2025 · N412DJ · Substantial damage
  > On August 7, 2025 at 0935 mountain daylight time, a Cirrus SR22 airplane, N412DJ, was substantially damaged when it was involved in an accident near Jaroso, Colorado. The pilot receiving instruction and a passenger were seriously injured, and the flight…
- [NTSB CEN25LA309](https://openairdocs.org/ntsb/CEN25LA309.md): Vans RV4 · Elgin, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 7, 2025 · N595BS · Substantial damage
  > On August 6, 2025, about 1925 central daylight time, a Vans RV4 airplane, N595BS, was substantially damaged when it was involved in an accident near Elgin, Illinois. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25LA306](https://openairdocs.org/ntsb/CEN25LA306.md): Air Tractor AT-301 · Davenport, ND · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 7, 2025 · N23069 · Substantial damage
  > On August 6, 2025, at 2035 central daylight time, an Air Tractor Inc AT-301 airplane, N23069, was substantially damaged when it was involved in an accident near Davenport, North Dakota. The commercial pilot sustained serious injuries. The airplane was…
- [NTSB CEN25FA308](https://openairdocs.org/ntsb/CEN25FA308.md): Cessna T182T · Augusta, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 7, 2025 · N35370 · Substantial damage
  > On August 7, 2025, at 1037 central daylight time, a Cessna T182T airplane, N35370, was substantially damaged when it was involved in an accident near Augusta, Arkansas. The pilot was fatally injured and the passenger received minor injuries. The airplane was…
- [NTSB GAA25WA238](https://openairdocs.org/ntsb/GAA25WA238.md): Lancair ES · Puerto Suarez, Bolivia · Accident · Minor injuries · Class 5 · Foreign · Aug 6, 2025 · CA-AD05 · Substantial damage
- [NTSB CEN25LA305](https://openairdocs.org/ntsb/CEN25LA305.md): Stolp Starduster SA300 · Marshall, AR · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 6, 2025 · N983AM · Substantial damage
  > On August 6, 2025 about 1552 central daylight time, a Stolp Starduster SA 300 airplane was substantially damaged when it was involved in an accident near Marshall, Arkansas. The pilot was not injured. The airplane was operated under the provisions of Title 14…
- [NTSB WPR25LA236](https://openairdocs.org/ntsb/WPR25LA236.md): Piper PA-28-180 · Silver Springs, NV · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 3, 2025 · N8359W · Substantial damage
  > On August 3, 2025, at about 0730 Pacific daylight time, a Piper PA28-180, N8359W, was substantially damaged when it was involved in an accident near Stagecoach, Nevada. The student pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25WA283](https://openairdocs.org/ntsb/DCA25WA283.md): Airbus A321 · Madrid, Spain · Incident · No injuries · Class 5 · Foreign · Aug 3, 2025 · EC-OOJ
- [NTSB ERA25LA289](https://openairdocs.org/ntsb/ERA25LA289.md): Jabiru Aircraft PTY J230-D · Oak Island, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 2, 2025 · N784J · Substantial damage
  > On August 2, 2025, about 1925 eastern daylight time, a Jabiru Aircraft Pty Ltd J-230-D, N784J, was substantially damaged when it was involved in an accident near Oak Island, North Carolina. The private pilot received minor injuries. The airplane was operated…
- [NTSB DCA25WA287](https://openairdocs.org/ntsb/DCA25WA287.md): Boeing 737 · Gauteng, South Africa · Incident · Class 5 · Foreign · Aug 2, 2025 · ZS-ZWO · No damage
- [NTSB WPR25FA232](https://openairdocs.org/ntsb/WPR25FA232.md): Schleicher ASW27-18 · Morgan, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N929JK · Destroyed
  > On August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…
- [NTSB ERA25FA283](https://openairdocs.org/ntsb/ERA25FA283.md): Piper J5C · Rochester, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N28151 · Substantial damage
  > On August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…
- [NTSB GAA25WA228](https://openairdocs.org/ntsb/GAA25WA228.md): Piper PA32 · Marsh Harbor, Bahamas · Accident · No injuries · Class 3 · Foreign · Jul 31, 2025 · N68BT · Substantial damage
- [NTSB GAA25WA221](https://openairdocs.org/ntsb/GAA25WA221.md): Grumman AA5 · Ottawa, Ontario, Canada · Accident · 1 fatal · Class 5 · Foreign · Jul 31, 2025 · C-GUXN · Substantial damage
- [NTSB ERA25LA281](https://openairdocs.org/ntsb/ERA25LA281.md): Cessna 172S · Kissimmee, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 30, 2025 · N121CW · Substantial damage
  > On July 30, 2025, at 11:28 eastern daylight time, a Cessna 172S, N121CW, was substantially damaged when it was involved in an accident near Kissimmee, Florida. The private pilot and flight instructor were uninjured. The airplane was operated as a Title 14…
- [NTSB DCA25LA276](https://openairdocs.org/ntsb/DCA25LA276.md): Airbus A330 · Creston, WY · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 30, 2025 · N422DZ · Minor damage
  > On July 30, 2025, at 1723 mountain daylight time, Delta Air Lines flight 56, an Airbus A330-941, encountered severe turbulence while in cruise flight at an altitude of 37,000 ft near Creston, Wyoming. After determining that injuries had occurred, the flight…
- [NTSB DCA25WA304](https://openairdocs.org/ntsb/DCA25WA304.md): Boeing 737 · Near MAR holding fix within Algiers TMA, Algeria · Incident · Class 5 · Foreign · Jul 29, 2025 · 7T-VCE · 2 aircraft · No damage

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=9

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=8

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