# NTSB investigations: Takeoff

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 6 of 281 · 14,035 cases

## Cases, newest first

- [NTSB WPR25LA259](https://openairdocs.org/ntsb/WPR25LA259.md): Czech Aircraft Group Sro Sportcruiser · Puyallup, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 25, 2025 · N538SF · Substantial damage
  > On August 25, 2025, about 1456 Pacific daylight time, a Czech Aircraft Group SRO Sportcruiser, N538SF was substantially damaged when it was involved in an accident near Puyallup, Washington. The pilot sustained serious injuries, and the passenger was not…
- [NTSB CEN25LA340](https://openairdocs.org/ntsb/CEN25LA340.md): Burkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, IL · Accident · No injuries · Class 4 · Limited · Final report · Aug 24, 2025 · N424BG · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff which resulted in a collision with a parked vehicle.
- [NTSB ANC25LA092](https://openairdocs.org/ntsb/ANC25LA092.md): Eurocopter AS 350 B2 · Juneau, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 22, 2025 · N149TH · Substantial damage
  > The pilot’s failure to maintain adequate obstacle clearance during takeoff from uneven, snow-covered terrain in flat light conditions.
- [NTSB ANC25LA095](https://openairdocs.org/ntsb/ANC25LA095.md): Helio H-395 · Pilot Point, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 21, 2025 · N44344 · Substantial damage
  > The pilot's inadequate takeoff performance planning, which resulted in a runway excursion and collision with terrain.
- [NTSB ERA25LA322](https://openairdocs.org/ntsb/ERA25LA322.md): Cessna 182 · Edgartown, MA · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 19, 2025 · N691DM · Substantial damage
  > The accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.
- [NTSB ANC25LA088](https://openairdocs.org/ntsb/ANC25LA088.md): Cessna 180G · Delta Junction, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 19, 2025 · N4721U · Substantial damage
  > The pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.
- [NTSB ANC25LA090](https://openairdocs.org/ntsb/ANC25LA090.md): Piper PA-18-150 · Willow, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 18, 2025 · N4387Z · Substantial damage
  > The pilot’s loss of control after a rejected takeoff, which resulted in a noseover.
- [NTSB GAA25WA275](https://openairdocs.org/ntsb/GAA25WA275.md): Cessna 172 · Islamabad, Pakistan · Accident · Class 5 · Foreign · Aug 16, 2025 · AP-BLO · Destroyed
- [NTSB ERA25LA303](https://openairdocs.org/ntsb/ERA25LA303.md): Centrair 101A · Springfield, VT · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 16, 2025 · N99KG · Substantial damage
  > The pilot’s failure to assemble the glider’s elevator control before takeoff.
- [NTSB DCA25WA309](https://openairdocs.org/ntsb/DCA25WA309.md): Airbus A320-214 · Villahermosa, Mexico · Incident · Class 5 · Foreign · Aug 16, 2025 · N837VA · 2 aircraft · No damage
- [NTSB ERA25LA302](https://openairdocs.org/ntsb/ERA25LA302.md): Cessna 172 · Titusville, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 15, 2025 · N7205Q · Substantial damage
  > On August 15, 2025, about 1415 eastern daylight time, a Cessna 172, N7205Q, was substantially damaged when it was involved in an accident near Titusville, Florida. The pilot was seriously injured and the flight instructor received minor injuries. The airplane…
- [NTSB ERA25LA300](https://openairdocs.org/ntsb/ERA25LA300.md): Piper PA-12 · Inverness, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 14, 2025 · N4014M · Substantial damage
  > On August 14, 2025, about 1915 easter daylight time, a Piper-PA12, N4014M, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The private pilot sustained serious injuries, and the passenger received a minor injury. The…
- [NTSB CEN25LA316](https://openairdocs.org/ntsb/CEN25LA316.md): Xag P100 PRO · Depew, IA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 12, 2025 · N467GE · Substantial damage
  > The pilot’s failure to maintain clearance from the unmanned aircraft system during takeoff.
- [NTSB WPR25LA247](https://openairdocs.org/ntsb/WPR25LA247.md): Aviat A1 · Etna, WY · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 10, 2025 · N801RA · Substantial damage
  > The pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…
- [NTSB CEN25LA313](https://openairdocs.org/ntsb/CEN25LA313.md): Air Tractor AT-502 · Lawrenceville, IL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 10, 2025 · N9193V · Substantial damage
  > On August 10, 2025, about 1321 central daylight time, an Air Tractor AT-502, was substantially damaged when it was involved in an accident near Lawrenceville, Illinois. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25LA244](https://openairdocs.org/ntsb/WPR25LA244.md): North American T-28C · West Wendover, NV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 7, 2025 · N9748Y · Substantial damage
  > On August 07, 2025, at 1532 Pacific daylight time, a North American T-28C, N9748Y, was substantially damaged when it was involved in an accident near West Wendover, Utah. The pilot and the passenger were seriously injured. The airplane was operated as a Title…
- [NTSB GAA25WA237](https://openairdocs.org/ntsb/GAA25WA237.md): Cessna 210 · San Lorenzo, Bolivia · Accident · No injuries · Class 5 · Foreign · Aug 7, 2025 · CP-3139 · Substantial damage
- [NTSB ERA25LA291](https://openairdocs.org/ntsb/ERA25LA291.md): Beech 35-C33 · Kingston, TN · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 6, 2025 · N500HT · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.
- [NTSB ANC25LA084](https://openairdocs.org/ntsb/ANC25LA084.md): Aeronca 7AC · Willow, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 6, 2025 · N84726 · Substantial damage
  > On August 5, 2025, about 1600 Alaska daylight time, an Aeronca 7AC airplane, N84726, was substantially damaged when it was involved in an accident at the Willow Airport (UUO) in Willow, Alaska. The student pilot sustained serious injuries. The airplane was…
- [NTSB ERA25LA290](https://openairdocs.org/ntsb/ERA25LA290.md): Gary W Lewinski Sonex · Tellico Plains, TN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 5, 2025 · N67BG · Substantial damage
  > On August 5, 2025, about 1131 eastern daylight time, a Lewinski Sonex, N67BG, was substantially damaged when it was involved in an accident near Tellico Plains, Tennessee. The private pilot was seriously injured. The airplane was operated as a Title 14?Code…
- [NTSB CEN25LA303](https://openairdocs.org/ntsb/CEN25LA303.md): Air Tractor AT-400A · Lamoni, IA · Accident · No injuries · Class 4 · Limited · Final report · Aug 3, 2025 · N3157B · Substantial damage
  > The pilot’s failure to maintain airplane control during an aborted takeoff.
- [NTSB WPR25LA238](https://openairdocs.org/ntsb/WPR25LA238.md): Cessna A185E · Warren, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 2, 2025 · N2252T · Substantial damage
  > The pilot’s failure to adequately compensate for a wind gust during the departure roll, which resulted in a loss of directional control and a runway excursion.
- [NTSB WPR25LA235](https://openairdocs.org/ntsb/WPR25LA235.md): Cessna 180J · Kamiah, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 1, 2025 · N52175 · Substantial damage
  > The pilot’s loss of airplane control following an encounter with a microburst during takeoff.
- [NTSB ANC25LA080](https://openairdocs.org/ntsb/ANC25LA080.md): Cessna 150J · Soldotna, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 31, 2025 · N60509 · Substantial damage
  > On July 31, 2025, about 1300 Alaska daylight time, a Cessna 150J airplane, N60509, was substantially damaged when it was involved in an accident near Soldotna, Alaska. The instructor pilot sustained minor injuries and the pilot receiving instruction was…
- [NTSB WPR25LA226](https://openairdocs.org/ntsb/WPR25LA226.md): Cessna 182L · Tucson Estates, AZ · Accident · No injuries · Class 4 · Limited · Final report · Jul 27, 2025 · N42725 · Destroyed
  > The pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.
- [NTSB WPR25FA223](https://openairdocs.org/ntsb/WPR25FA223.md): Grumman American Avn. AA-5 · West Glacier, MT · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 26, 2025 · N1342R · Substantial damage
  > On July 26, 2025, about 0942 mountain daylight time, a Grumman AA-5, N1342R, was destroyed when it was involved in an accident near West Glacier, Montana. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25LA275](https://openairdocs.org/ntsb/DCA25LA275.md): Boeing 737-8 · Denver, CO · Accident · No injuries · Class 4 · Limited · Final report · Jul 26, 2025 · N306SW · Substantial damage
  > The failure of the airplane’s left main landing gear tires and wheels during the takeoff roll due to the thermal relief plugs melting and releasing tire pressure, which resulted in abnormal airplane handling characteristics and led the flight crew to reject…
- [NTSB ERA25LA279](https://openairdocs.org/ntsb/ERA25LA279.md): Beech A23-24 · Windham, CT · Accident · No injuries · Class 4 · Limited · Final report · Jul 25, 2025 · N469JS · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in a rejected takeoff and subsequent runway excursion.
- [NTSB ANC25LA077](https://openairdocs.org/ntsb/ANC25LA077.md): Cessna 210-5 · Yakutat, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 24, 2025 · N8457Z · Substantial damage
  > On July 23, 2025, about 1700 Alaska daylight time, a Cessna 210-5 (205) airplane, N8457Z, was substantially damaged when it was involved in an accident on a remote beach about 50 miles southeast of Yakutat, Alaska. The pilot was uninjured. The airplane was…
- [NTSB WPR25LA227](https://openairdocs.org/ntsb/WPR25LA227.md): Hartline J Bon Hartline Kitfox III · Logan, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 22, 2025 · N422K · Substantial damage
  > The pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.
- [NTSB ERA25LA275](https://openairdocs.org/ntsb/ERA25LA275.md): Piper PA28 · San Juan, PR · Accident · No injuries · Class 4 · Limited · Final report · Jul 21, 2025 · N4187U · Substantial damage
  > The student pilot’s excessing pitch attitude during takeoff, which resulted in a loss of aircraft control and aerodynamic stall.
- [NTSB DCA25WA292](https://openairdocs.org/ntsb/DCA25WA292.md): Boeing 737-832 · Ciudad de México, Mexico · Incident · No injuries · Class 5 · Foreign · Jul 21, 2025 · N3766 · No damage
- [NTSB ENG25WA047](https://openairdocs.org/ntsb/ENG25WA047.md): Viking DHC-2 MK. I (Beaver) · Lac du Poisson Blanc, Canada · Accident · No injuries · Class 5 · Foreign · Jul 19, 2025 · C-FJAC · Substantial damage
- [NTSB OPS25LA054](https://openairdocs.org/ntsb/OPS25LA054.md): Bombardier CL-600-2D24 · Freeland, MI · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 16, 2025 · N833SK · No damage
  > On July 16, 2025, about 1542 eastern daylight time (EDT), SkyWest Airlines (SKW) flight 3751, a Bombardier CL-600-2D24, N833SK, departed from a closed runway at MBS International Airport (MBS), Freeland, Michigan. The flight continued without further incident…
- [NTSB CEN25LA256](https://openairdocs.org/ntsb/CEN25LA256.md): Farrington Twinstar · Greencastle, IN · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 16, 2025 · N45CL · Substantial damage
  > The pilot’s failure to maintain pitch control during takeoff. Contributing to the accident was the pilot’s inexperience in the accident gyroplane.
- [NTSB WPR25LA215](https://openairdocs.org/ntsb/WPR25LA215.md): Beech 95-B55 (T42A) · North Las Vegas, NV · Accident · No injuries · Class 4 · Limited · Final report · Jul 15, 2025 · N945B · Substantial damage
  > The failure of the pilot to set the flaps to the proper configuration for takeoff.
- [NTSB CEN25LA267](https://openairdocs.org/ntsb/CEN25LA267.md): Air Tractor AT-402B · Wyoming, IL · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 15, 2025 · N647RA · Substantial damage
  > The pilot’s failure to attain a positive climb rate due to airplane’s improper takeoff configuration.
- [NTSB CEN25LA254](https://openairdocs.org/ntsb/CEN25LA254.md): Schweizer G-164B · Russellville, IN · Accident · No injuries · Class 4 · Limited · Final report · Jul 15, 2025 · N7501A · Substantial damage
  > The pilot’s failure to establish and maintain the airstrip centerline during takeoff, which resulted in the airplane’s right wingtips contacting the corn that bordered the airstrip.
- [NTSB WPR25LA222](https://openairdocs.org/ntsb/WPR25LA222.md): Rotorsport UK Rotorsport UK Cavalon · Hurricane, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 14, 2025 · N630JM · Substantial damage
  > The pilot’s failure to maintain pitch control during takeoff, which resulted in an unintended liftoff from the runway and a subsequent loss of control.
- [NTSB GAA25WA208](https://openairdocs.org/ntsb/GAA25WA208.md): Beech B200 · Southend-on-Sea, United Kingdom · Accident · 4 fatal · Class 5 · Foreign · Jul 13, 2025 · PH-ZAZ · Destroyed
- [NTSB ANC25LA072](https://openairdocs.org/ntsb/ANC25LA072.md): Piper PA-18-150 · Dillingham, AK · Accident · No injuries · Class 4 · Limited · Final report · Jul 12, 2025 · N82109 · Substantial damage
  > The pilot’s failure to maintain direction control during takeoff roll which resulted in a ground loop, and subsequent runway excursion.
- [NTSB WPR25LA204](https://openairdocs.org/ntsb/WPR25LA204.md): Beech A36 · Coolin, ID · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 9, 2025 · N41VH · Substantial damage
  > On July 8, 2025, about 1840 Pacific daylight time, a Beech A36, N41VH, was substantially damaged when it was involved in an accident near Coolin, Idaho. The pilot and passenger sustained minor injuries. The airplane was operated under Title 14 Code of Federal…
- [NTSB CEN25LA241](https://openairdocs.org/ntsb/CEN25LA241.md): Cessna 177 · Jenison, MI · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 8, 2025 · N29342 · Substantial damage
  > The pilot’s failure to maintain airplane control and clearance from trees during takeoff.
- [NTSB GAA25WA215](https://openairdocs.org/ntsb/GAA25WA215.md): Cessna 650 · Mallorca, Spain · Incident · No injuries · Class 5 · Foreign · Jul 6, 2025 · CN-SRA · Minor damage
- [NTSB ERA25LA257](https://openairdocs.org/ntsb/ERA25LA257.md): Yates Tom W Kitfox III · Greenville, KY · Accident · No injuries · Class 4 · Limited · Final report · Jul 4, 2025 · N11TY · Substantial damage
  > The pilot’s loss of control during takeoff.
- [NTSB ANC25LA067](https://openairdocs.org/ntsb/ANC25LA067.md): Rockwell International 690B · Fairbanks, AK · Accident · No injuries · Class 4 · Limited · Final report · Jul 3, 2025 · N690AX · Substantial damage
  > The pilot’s failure to maintain control during takeoff resulting in a gear-up landing on the runway. Contributing to the accident was the pilot’s momentary distraction from within the airplane.
- [NTSB WPR25FA197](https://openairdocs.org/ntsb/WPR25FA197.md): Evolution Revolt · Mount Vernon, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 2, 2025 · N774RS · Substantial damage
  > On July 2, 2025, about 1313 Pacific daylight time, an Evolution Aircraft REVOLT weight shift control aircraft (commonly called a trike), N774RS, was substantially damaged when it was involved in an accident near Mount Vernon, Washington. The pilot was fatally…
- [NTSB ENG25WA054](https://openairdocs.org/ntsb/ENG25WA054.md): Pilatus PC12 · Kitakyushu, Japan · Incident · Class 5 · Foreign · Jul 2, 2025 · T7-12DW · No damage
- [NTSB GAA25WA207](https://openairdocs.org/ntsb/GAA25WA207.md): Air Tractor AT502 · Porto Dos GaúChos, Brazil · Accident · 1 fatal · Class 5 · Foreign · Jul 1, 2025 · PP-LTO · No damage
- [NTSB CEN25LA233](https://openairdocs.org/ntsb/CEN25LA233.md): ICP Savannah S · Slaughter, LA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N5000S · Substantial damage
  > On June 30, 2025, about 1932 central daylight time an I.C.P. Srl Savannah S light sport airplane, N5000S was substantially damaged when it was involved in an accident near Slaughter, LA. The pilot and passenger were not injured. The flight was operated under…

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=7

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

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

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