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

## Cases, newest first

- [NTSB ANC26LA050](https://openairdocs.org/ntsb/ANC26LA050.md): Cessna A185F · Steele Creek, AK · Accident · No injuries · Class 4 · Limited · Investigation open · May 31, 2026 · N2821Q · Substantial damage
- [NTSB CEN26LA210](https://openairdocs.org/ntsb/CEN26LA210.md): Cessna 172S · Colorado Springs, CO · Accident · No injuries · Class 4 · Limited · Final report · May 29, 2026 · N386SP · Substantial damage
  > The student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.
- [NTSB CEN26LA204](https://openairdocs.org/ntsb/CEN26LA204.md): Mustang Aeronautics Mustang II · Richmond, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 28, 2026 · N160MT · Substantial damage
  > On May 28, 2026, about 1440 central daylight time, a Mustang Aeronautics Mustang II airplane, N160MT, sustained substantial damage when it was involved in an accident near Richmond, Texas. The pilot sustained minor injuries. The airplane was operated as a…
- [NTSB WPR26LA213](https://openairdocs.org/ntsb/WPR26LA213.md): Moose SR 2500 · Sonoma, CA · Accident · Serious injuries · Class 4 · Limited · Final report · May 27, 2026 · N135DS · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB CEN26LA201](https://openairdocs.org/ntsb/CEN26LA201.md): Cessna 172H · Berryville, AR · Accident · Serious injuries · Class 4 · Limited · Final report · May 25, 2026 · N2632L · Substantial damage
  > The pilot in command’s decision to continue the takeoff when the airplane was not airborne at midfield, and the student pilot’s likely improper technique that resulted in a lack of sufficient climb performance and subsequent loss of control.
- [NTSB WPR26LA199](https://openairdocs.org/ntsb/WPR26LA199.md): Bell 206-L4 · Cedar City, UT · Accident · Minor injuries · Class 4 · Limited · Final report · May 23, 2026 · N917SU · Substantial damage
  > The flight instructor's failure to maintain helicopter control while manipulating the engine governor reference rpm adjustment during hover operations, which resulted in a loss of control and impact with the ground.
- [NTSB ERA26LA216](https://openairdocs.org/ntsb/ERA26LA216.md): Cessna A188B · Doerun, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 23, 2026 · N8288G · Substantial damage
  > On May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN26LA198](https://openairdocs.org/ntsb/CEN26LA198.md): Commander 114TC · Woodruff, WI · Accident · No injuries · Class 4 · Limited · Final report · May 23, 2026 · N114DP · Substantial damage
  > The pilot’s failure to maintain airplane control during the go-around.
- [NTSB ANC26LA043](https://openairdocs.org/ntsb/ANC26LA043.md): Piper PA-18A 150 · Tyonek, AK · Accident · No injuries · Class 4 · Limited · Investigation open · May 19, 2026 · N9250D · Substantial damage
- [NTSB ERA26LA209](https://openairdocs.org/ntsb/ERA26LA209.md): Cessna 172S · Harrison, NY · Accident · Minor injuries · Class 4 · Limited · Final report · May 18, 2026 · N5114Z · Substantial damage
  > The student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.
- [NTSB DCA26WA209](https://openairdocs.org/ntsb/DCA26WA209.md): Airbus 220 · Split, Croatia · Incident · No injuries · Class 5 · Foreign · May 16, 2026 · 9A-CAN · Minor damage
- [NTSB CEN26LA191](https://openairdocs.org/ntsb/CEN26LA191.md): Vertical Hummingbird · Lee's Summit, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 16, 2026 · N284ST · Substantial damage
  > On May 16, 2026, about 0950 central daylight time, a Vertical Aviation Technologies 300L Hummingbird helicopter, N284ST, was substantially damaged when it was involved in an accident near Lee’s Summit, Missouri. One passenger sustained minor injuries. The…
- [NTSB ERA26LA210](https://openairdocs.org/ntsb/ERA26LA210.md): John Bradley Vans RV-7 · Athens, GA · Accident · No injuries · Class 4 · Limited · Final report · May 15, 2026 · N519JS · Substantial damage
  > Contamination of the left wheel brake system with debris, which resulted in a loss of directional control during takeoff.
- [NTSB DCA26WA212](https://openairdocs.org/ntsb/DCA26WA212.md): Boeing 737 · Muscat, Oman · Accident · Class 3 · Foreign · May 15, 2026 · VT---AXR
- [NTSB WPR26LA197](https://openairdocs.org/ntsb/WPR26LA197.md): Mooney M20J · Lake Havasu City, AZ · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 14, 2026 · N4665H · Substantial damage
  > On May 14, 2026, at 1523, a Mooney M20J, N4665H, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The pilot and two passengers sustained serious injuries. The airplane was operated under Title 14 Code of Federal…
- [NTSB CEN26LA187](https://openairdocs.org/ntsb/CEN26LA187.md): Cessna 172S · Denton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 13, 2026 · N2134M · Substantial damage
  > On May 13, 2026, about 1815 central daylight time, a Cessna 172S, N2134M, sustained substantial damage when it was involved in an accident near Denton, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN26LA186](https://openairdocs.org/ntsb/CEN26LA186.md): Piper PA-28R-201 · West Chicago, IL · Accident · No injuries · Class 4 · Limited · Final report · May 13, 2026 · N31401 · Substantial damage
  > The pilot’s improper decision to attempt an intersection takeoff and delay to abort the takeoff which resulted in a subsequent runway excursion.
- [NTSB WPR26LA179](https://openairdocs.org/ntsb/WPR26LA179.md): Cessna A150L · Superior, AZ · Accident · No injuries · Class 4 · Limited · Final report · May 10, 2026 · N6067J · Substantial damage
  > The pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.
- [NTSB CEN26LA177](https://openairdocs.org/ntsb/CEN26LA177.md): Air Tractor AT-602 · El Campo, TX · Accident · No injuries · Class 4 · Limited · Final report · May 5, 2026 · N422TW · Destroyed
  > The pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.
- [NTSB ENG26WA028](https://openairdocs.org/ntsb/ENG26WA028.md): Airbus A321 · Ciudad de México, Mexico · Incident · Class 5 · Foreign · May 4, 2026 · XA-VXK · No damage
- [NTSB ANC26LA035](https://openairdocs.org/ntsb/ANC26LA035.md): Champion 7EC · Hollis, OK · Accident · No injuries · Class 4 · Limited · Investigation open · Apr 30, 2026 · N7436B · Substantial damage
- [NTSB GAA26WA180](https://openairdocs.org/ntsb/GAA26WA180.md): Costruzioni Aeronautiche Tecna P92 Eaglet · Dajabon, Dominican Republic · Incident · Minor injuries · Class 5 · Foreign · Apr 29, 2026 · N577TU · Destroyed
- [NTSB ERA26LA187](https://openairdocs.org/ntsb/ERA26LA187.md): Cessna 172 · Quakertown, PA · Accident · No injuries · Class 4 · Limited · Final report · Apr 24, 2026 · N99467 · Substantial damage
  > The pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.
- [NTSB GAA26WA182](https://openairdocs.org/ntsb/GAA26WA182.md): Piper PA60 · Villavicencio, Colombia · Incident · Class 5 · Foreign · Apr 23, 2026 · HK3641G · Minor damage
- [NTSB ANC26LA031](https://openairdocs.org/ntsb/ANC26LA031.md): Piper PA-28-151 · Lapeer, MI · Accident · No injuries · Class 4 · Limited · Final report · Apr 23, 2026 · N44690 · Substantial damage
  > The flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…
- [NTSB ERA26LA186](https://openairdocs.org/ntsb/ERA26LA186.md): Cessna 172M · Crystal River, FL · Accident · No injuries · Class 4 · Limited · Investigation open · Apr 22, 2026 · N868SA · Substantial damage
- [NTSB CEN26LA169](https://openairdocs.org/ntsb/CEN26LA169.md): Luscombe 8E · Meeker, CO · Accident · No injuries · Class 4 · Limited · Final report · Apr 19, 2026 · N1398K · Substantial damage
  > The pilot’s inability to maintain climb performance and clearance from terrain due to the airplane’s encounter with windshear during takeoff.
- [NTSB ERA26LA183](https://openairdocs.org/ntsb/ERA26LA183.md): Cessna 421 · Richmond, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 18, 2026 · C-GTGR · Substantial damage
  > On April 18, 2026, about 1410 eastern daylight time, a Cessna 421C, C-GTGR, was substantially damaged when it was involved in an accident near Richmond, Virginia. The pilot and four passengers were uninjured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26LA159](https://openairdocs.org/ntsb/WPR26LA159.md): Cirrus Design SR22T · Fullerton, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 13, 2026 · N285AH · Substantial damage
  > The pilot’s loss of control during takeoff, due to the seat sliding aft.
- [NTSB ERA26LA172](https://openairdocs.org/ntsb/ERA26LA172.md): Dehavilland DHC-3 · Dry Tortugas, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 11, 2026 · N708KA · Substantial damage
  > On April 11, 2026, about 0845 eastern daylight time, an amphibious DeHavilland DHC-3, N708KA, was substantially damaged when it was involved in an accident near Dry Tortugas, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA169](https://openairdocs.org/ntsb/ERA26LA169.md): Eric Vargosko SW-51 · Iron Station, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N551EV · Minor damage
  > On April 10, 2026, about 1732 eastern daylight time, an experimental amateur built SW-51 airplane, N551EV, sustained minor damage when it was involved in an accident near Iron Station, North Carolina. The front seat pilot sustained minor injuries, and the…
- [NTSB WPR26LA149](https://openairdocs.org/ntsb/WPR26LA149.md): Cessna T-41B · Fort Mohave, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 7, 2026 · N39ND · Substantial damage
  > On April 7, 2026, about 1300 mountain standard time, a Cessna T-41B, N39ND, was substantially damaged when it was involved in an accident near Fort Mohave, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code…
- [NTSB ERA26LA159](https://openairdocs.org/ntsb/ERA26LA159.md): Cessna 172M · Lakeland, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 5, 2026 · N61972 · Substantial damage
  > On April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The…
- [NTSB WPR26LA146](https://openairdocs.org/ntsb/WPR26LA146.md): Bell Helicopter Textron 206L-1 · Chimney Rock, MT · Accident · No injuries · Class 4 · Limited · Final report · Apr 4, 2026 · N5017G · Substantial damage
  > The pilot’s failure to maintain adequate clearance from the terrain while performing a low altitude circling takeoff maneuver, which resulted in a dynamic rollover.
- [NTSB GAA26WA144](https://openairdocs.org/ntsb/GAA26WA144.md): Cessna 182 · Pucallpa, Peru · Accident · No injuries · Class 5 · Foreign · Mar 31, 2026 · N2406R · Substantial damage
- [NTSB ERA26LA157](https://openairdocs.org/ntsb/ERA26LA157.md): Cirrus Design SR22T · Mount Pleasant, SC · Accident · No injuries · Class 4 · Limited · Final report · Mar 31, 2026 · N778WT · Substantial damage
  > The airplane’s encounter with uneven terrain during takeoff, which resulted in a runway excursion and impact with water.
- [NTSB CEN26LA152](https://openairdocs.org/ntsb/CEN26LA152.md): Ela ELA10 · Boulder, CO · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2026 · N510EA · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.
- [NTSB DCA26WA220](https://openairdocs.org/ntsb/DCA26WA220.md): Boeing 737-832 · San Miguel de Cozumel, Mexico · Occurrence · No injuries · Class 5 · Foreign · Mar 25, 2026 · N3734B · 2 aircraft · No damage
- [NTSB ERA26LA227](https://openairdocs.org/ntsb/ERA26LA227.md): Cessna 172R · Maiden, NC · Accident · No injuries · Class 4 · Limited · Final report · Mar 22, 2026 · N870CP · Substantial damage
  > The flight instructor’s inadequate preflight planning, which resulted in a rejected takeoff from a tailwind departure and subsequent runway excursion.
- [NTSB WPR26LA131](https://openairdocs.org/ntsb/WPR26LA131.md): Aerospatiale SA341G Gazelle · Winslow, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N71FR · Substantial damage
  > On March 21, 2026, about 1406 mountain daylight time, a Aerospatiale SA341G Gazelle, N71FR, sustained substantial damage when it was involved in an accident near Winslow, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as…
- [NTSB ERA26LA153](https://openairdocs.org/ntsb/ERA26LA153.md): Textron T206H · Fort Myers, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N2469H · Substantial damage
  > On March 21, 2026, about 0905 eastern daylight time, a Cessna T206H, N2469H, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The pilot and four passengers sustained minor injuries. The airplane was operated as a Title…
- [NTSB CEN26LA146](https://openairdocs.org/ntsb/CEN26LA146.md): Piper PA-24-250 · Madison, IN · Accident · No injuries · Class 4 · Limited · Final report · Mar 21, 2026 · N7548P · Substantial damage
  > The pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN26LA143](https://openairdocs.org/ntsb/CEN26LA143.md): Cessna 172P · Denton, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 20, 2026 · N65614 · Substantial damage
  > On March 20, 2026, about 1415 central daylight time, a Cessna 172P airplane, N65614, was substantially damaged when it was involved in an accident near Denton, Texas. The pilot sustained minor injuries, and the pilot-rated sensor operator sustained serious…
- [NTSB WPR26LA133](https://openairdocs.org/ntsb/WPR26LA133.md): Piper PA-12 · West Linn, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 19, 2026 · N7632H · Substantial damage
  > On March 18, 2026, about 1700 Pacific daylight time, a Piper PA-12, N7632H, was substantially damaged when it was involved in an accident near West Linn, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN26FA140](https://openairdocs.org/ntsb/CEN26FA140.md): Aero Commander 500-B · Chesterfield, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 17, 2026 · N444CA · Destroyed
  > On March 17, 2026, about 0024 central daylight time, an Aero Commander 500-B airplane, N444CA, was destroyed when it was involved in an accident near Chesterfield, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB DCA26WA162](https://openairdocs.org/ntsb/DCA26WA162.md): Boeing 737 · Misawa, Japan · Accident · No injuries · Class 5 · Foreign · Mar 13, 2026 · JA301J · Substantial damage
- [NTSB ERA26LA147](https://openairdocs.org/ntsb/ERA26LA147.md): Piper PA24-180 · Leonardtown, MD · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 11, 2026 · N7573P · Substantial damage
  > The pilot’s failure to maintain control during a crosswind takeoff, which resulted in a runway excursion and impact with a drainage ditch.
- [NTSB ANC26LA018](https://openairdocs.org/ntsb/ANC26LA018.md): Bell Textron Canada 505 · Fort Worth, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N911FW · Substantial damage
  > On March 7, 2026, at 2210 Central daylight time, a Bell Textron 505 helicopter, N911FW, was substantially damaged when it was involved in an accident near Fort Worth, Texas. The pilot and crew member were not injured. The helicopter was operated as a Title 14…
- [NTSB CEN26LA137](https://openairdocs.org/ntsb/CEN26LA137.md): Piper PA-12 · Lockhart, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 7, 2026 · N2511M · Substantial damage
  > On March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26LA134](https://openairdocs.org/ntsb/CEN26LA134.md): Piper PA-18-150 · Sonora, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 4, 2026 · N3695Z · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing.

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

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

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