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

## Cases, newest first

- [NTSB CEN20CA277](https://openairdocs.org/ntsb/CEN20CA277.md): Kitfox Kitfox Sport · Rand, CO · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 12, 2020 · N702KS · Substantial damage
  > The encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.
- [NTSB WPR20CA232](https://openairdocs.org/ntsb/WPR20CA232.md): Cessna U206 · Nenana, AK · Accident · No injuries · Class 4 · Data collection · Final report · Jul 11, 2020 · N756DJ · Substantial damage
  > The pilot's failure to maintain directional control during a soft field takeoff on a dirt airstrip, which resulted in an impact with a vehicle.
- [NTSB WPR20CA221](https://openairdocs.org/ntsb/WPR20CA221.md): Quickie Q2 · Preston, ID · Accident · No injuries · Class 4 · Data collection · Final report · Jul 11, 2020 · N85BJ · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff in high density altitude conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot's failure to accomplish performance calculations for the atmospheric…
- [NTSB ERA20CA244](https://openairdocs.org/ntsb/ERA20CA244.md): New Kolb Kolb Flyer SS · Lutz, FL · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 11, 2020 · N38KF · Substantial damage
  > The flight instructor’s failure to maintain control of the airplane following an unannounced transfer of flight control during takeoff.
- [NTSB CEN20LA271](https://openairdocs.org/ntsb/CEN20LA271.md): Cessna T188 · Dustin, OK · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 10, 2020 · N2690J · Substantial damage
  > The pilot’s continued takeoff without ensuring obstacles could be avoided due to his use of a sedating medication, which likely diminished his reaction time and flying performance.
- [NTSB WPR20CA236](https://openairdocs.org/ntsb/WPR20CA236.md): Stinson 108 · Farewell Lakes, AK · Accident · No injuries · Class 4 · Data collection · Final report · Jul 8, 2020 · N134C · Substantial damage
  > The pilot's delayed decision to abort the takeoff roll, which resulted in a runway overrun and airplane nose over.
- [NTSB CEN20LA268](https://openairdocs.org/ntsb/CEN20LA268.md): Mooney M20TN · Buena Vista, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 7, 2020 · C-GTVS · Substantial damage
  > The pilot's distraction during takeoff, which resulted in collision with terrain.
- [NTSB ERA20CA240](https://openairdocs.org/ntsb/ERA20CA240.md): Piper PA28R · Bardstown, KY · Accident · No injuries · Class 4 · Data collection · Final report · Jul 6, 2020 · N3725T · Substantial damage
  > The commercial pilot's exceedance of the airplane's critical angle of attack and subsequent loss of lateral bank control during a soft field takeoff.
- [NTSB CEN20LA267](https://openairdocs.org/ntsb/CEN20LA267.md): Titan Tornado · Mankato, KS · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 6, 2020 · N900WH · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on available information.
- [NTSB WPR20WA210](https://openairdocs.org/ntsb/WPR20WA210.md): Robinson R44 · Broome Aerodrome, Australia · Accident · 2 fatal · Foreign investigation · Jul 4, 2020 · VH-NBY · Substantial damage
  > The government of Australia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…
- [NTSB ERA20CA239](https://openairdocs.org/ntsb/ERA20CA239.md): Beech 76 · Crystal River, FL · Accident · No injuries · Class 4 · Data collection · Final report · Jul 2, 2020 · N20131 · Substantial damage
  > The flight instructor's delayed remedial action during a simulated engine failure on takeoff, which resulted in a loss of directional control.
- [NTSB ANC20CA063](https://openairdocs.org/ntsb/ANC20CA063.md): Stinson 108 · Nikolai, AK · Accident · No injuries · Class 4 · Data collection · Final report · Jul 2, 2020 · N6252M · Substantial damage
  > The pilot's improper decision to depart from an unsuitable off-airport surface which resulted in a departure area excursion and impact with trees.
- [NTSB WPR20LA201](https://openairdocs.org/ntsb/WPR20LA201.md): Avia Stroitel AC-5M · Bend, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 30, 2020 · N263R · Destroyed
  > A loss of control just after takeoff for reasons that could not be determined based on the available information.
- [NTSB ERA20CA232](https://openairdocs.org/ntsb/ERA20CA232.md): Ayres S2R · Perry, GA · Accident · No injuries · Class 4 · Data collection · Final report · Jun 27, 2020 · N4032L · Substantial damage
  > The reported malfunction of the aileron flight control system during takeoff for reasons that could not be determined.
- [NTSB CEN20CA253](https://openairdocs.org/ntsb/CEN20CA253.md): Beech 23 · Davenport, IA · Accident · Minor injuries · Class 4 · Data collection · Final report · Jun 27, 2020 · N18873 · Substantial damage
  > The pilot's failure to properly configure the airplane for takeoff, which resulted in the exceedance of the airplane's critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.
- [NTSB WPR20CA195](https://openairdocs.org/ntsb/WPR20CA195.md): Capella XLS · Liberty, UT · Accident · Minor injuries · Class 4 · Data collection · Final report · Jun 24, 2020 · N18XX · Substantial damage
  > The pilot's failure to maintain clearance from a fence post during the initial climb.
- [NTSB GAA20WA117](https://openairdocs.org/ntsb/GAA20WA117.md): American Champion 8KCAB · Lommis, WZ · Accident · No injuries · Foreign investigation · Jun 24, 2020 · HB-KHN · Substantial damage
  > The government of Swaziland has notified the NTSB of an accident involving a AMERICAN Champion 8KCAB airplane that occurred on June 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Swaziland's investigation under…
- [NTSB WPR20CA231](https://openairdocs.org/ntsb/WPR20CA231.md): Chad Lewis Kitfox Super Sport · St Anthony, ID · Accident · No injuries · Class 4 · Data collection · Final report · Jun 23, 2020 · N338RW · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion, contact with the airport perimeter fence, and subsequent nose over.
- [NTSB ERA20LA219](https://openairdocs.org/ntsb/ERA20LA219.md): Cessna 152 · McAlpin, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 17, 2020 · N25449 · Substantial damage
  > The pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…
- [NTSB ENG20WA041](https://openairdocs.org/ntsb/ENG20WA041.md): Airbus A321 · Doncaster, United Kingdom · Incident · No injuries · Foreign investigation · Jun 16, 2020 · G-WUKJ · No damage
  > The United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident which occurred on June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO Annex 13…
- [NTSB ERA20CA214](https://openairdocs.org/ntsb/ERA20CA214.md): Waco YMF F5C · Ghent, NY · Accident · No injuries · Class 4 · Data collection · Final report · Jun 13, 2020 · N323TX · Substantial damage
  > A loss of directional control on takeoff, which resulted in a runway excursion and collision with trees.
- [NTSB CEN20LA227](https://openairdocs.org/ntsb/CEN20LA227.md): Vans RV8 · Mandan, ND · Accident · 1 fatal · Class 2 · Limited · Final report · Jun 13, 2020 · N836JC · Destroyed
  > The pilot's failure to remove the seat belt used as a flight control lock from the aft cockpit control stick before takeoff, which resulted in a loss of control during takeoff and collision with terrain.
- [NTSB WPR20WA182](https://openairdocs.org/ntsb/WPR20WA182.md): Cessna 152 · Bhubaneswar, India · Accident · 2 fatal · Foreign investigation · Jun 8, 2020 · VT-ENF · Substantial damage
  > The government of India has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of ICAO…
- [NTSB CEN20LA219](https://openairdocs.org/ntsb/CEN20LA219.md): Flight Design Ctls · Beecher, IL · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 8, 2020 · N257V · Destroyed
  > The pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…
- [NTSB CEN20CA221](https://openairdocs.org/ntsb/CEN20CA221.md): Air Tractor AT502 · Hiawatha, KS · Accident · No injuries · Class 4 · Data collection · Final report · Jun 8, 2020 · N5092J · Substantial damage
  > The pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.
- [NTSB CEN20LA215](https://openairdocs.org/ntsb/CEN20LA215.md): Mitsubishi MU2B · Sioux Falls, SD · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 7, 2020 · N44MX · Destroyed
  > The pilot’s failure to maintain control of the airplane during takeoff for reasons that could not be determined.
- [NTSB WPR20LA175](https://openairdocs.org/ntsb/WPR20LA175.md): Grumman G164 · Lincoln, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 4, 2020 · N8486K · Substantial damage
  > The pilot’s loss of directional control on takeoff for undetermined reasons.
- [NTSB CEN20CA213](https://openairdocs.org/ntsb/CEN20CA213.md): Piper PA18 · Cadillac, MI · Accident · Minor injuries · Class 4 · Data collection · Final report · Jun 4, 2020 · N68EE · Substantial damage
  > The pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.
- [NTSB WPR20CA167](https://openairdocs.org/ntsb/WPR20CA167.md): Cessna 172 · Las Vegas, NV · Accident · No injuries · Class 4 · Data collection · Final report · Jun 3, 2020 · N478ER · Substantial damage
  > The student pilot's failure to maintain directional control of the airplane during a soft-field takeoff and the flight instructor's delayed remedial action.
- [NTSB WPR20CA164](https://openairdocs.org/ntsb/WPR20CA164.md): Cessna 182 · Sandia, TX · Accident · Serious injuries · Class 4 · Data collection · Final report · Jun 3, 2020 · N3107R · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.
- [NTSB CEN20LA207](https://openairdocs.org/ntsb/CEN20LA207.md): Icon A5 · Duluth, MN · Accident · No injuries · Class 3 · Limited · Final report · Jun 3, 2020 · N838BA · Substantial damage
  > The pilot’s failure to remove an object from the airplane’s exterior, which impacted the propeller blades when he applied full power, causing them to fracture and damage the airplane.
- [NTSB ERA20LA202](https://openairdocs.org/ntsb/ERA20LA202.md): Piper PA23 · San Juan, PR · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 2, 2020 · N14181 · Substantial damage
  > The pilot’s intentional operation of the airplane with known deficiencies of the left engine and subsequent in-flight loss of control after takeoff. Contributing to the loss of engine power was internal contamination of the left servo fuel injector.…
- [NTSB CEN20WA398](https://openairdocs.org/ntsb/CEN20WA398.md): Cessna U206 · Tallard, France · Accident · No injuries · Foreign investigation · Jun 2, 2020 · F-HIDZ · Substantial damage
  > The government of France has notified the NTSB of an accident involving a Cessna U206 airplane that occurred on June 2, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…
- [NTSB ANC20CA052](https://openairdocs.org/ntsb/ANC20CA052.md): Air Tractor AT802 · Unalakleet, AK · Accident · No injuries · Class 4 · Data collection · Final report · Jun 1, 2020 · N779DA · Substantial damage
  > The pilot's failure to maintain terrain clearance during the departure, which resulted in a collision with terrain..
- [NTSB CEN20LA199](https://openairdocs.org/ntsb/CEN20LA199.md): Piper PA28 · Pineville, LA · Accident · 2 fatal · Class 3 · Limited · Final report · May 31, 2020 · N6461J · Substantial damage
  > The airplane’s inability to gain sufficient airspeed after takeoff due to it being at or over its maximum gross weight, which resulted in a loss of control. Contributing to the accident was the pilot’s decision to operate the airplane at or over its maximum…
- [NTSB CEN20CA205](https://openairdocs.org/ntsb/CEN20CA205.md): Cessna 172 · Lakeview, AR · Accident · No injuries · Class 4 · Data collection · Final report · May 31, 2020 · N52794 · Substantial damage
  > The pilot’s failure to maintain control of the airplane during the takeoff.
- [NTSB ANC20LA053](https://openairdocs.org/ntsb/ANC20LA053.md): Zenith Stol CH701 · Ambler, AK · Accident · No injuries · Class 3 · Limited · Final report · May 31, 2020 · N324WS · Substantial damage
  > The pilot’s improper decision to take off from unsuitable terrain, which resulted in impact with uneven terrain, the subsequent failure of the nosewheel fork, and a nose over.
- [NTSB WPR20CA162](https://openairdocs.org/ntsb/WPR20CA162.md): Bell 206 · Elko, NV · Accident · No injuries · Class 4 · Data collection · Final report · May 30, 2020 · N401HP · Substantial damage
  > The pilot's failure to maintain helicopter control in gusting wind that resulted in a loss in altitude and subsequent collision with a fence.
- [NTSB WPR20CA159](https://openairdocs.org/ntsb/WPR20CA159.md): Grumman G164 · Maxwell, CA · Accident · No injuries · Class 4 · Data collection · Final report · May 29, 2020 · N9716 · Substantial damage
  > The pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the runway and collided with terrain. Contributing to the accident was the pilot's inadequate preflight…
- [NTSB ANC20CA051](https://openairdocs.org/ntsb/ANC20CA051.md): Piper PA18 · Sterling, AK · Accident · Minor injuries · Class 4 · Data collection · Final report · May 28, 2020 · N7164B · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and collision with trees.
- [NTSB WPR20CA154](https://openairdocs.org/ntsb/WPR20CA154.md): Champion 7GCBC · Spotted Horse, WY · Accident · No injuries · Class 4 · Data collection · Final report · May 25, 2020 · N771CT · Substantial damage
  > The pilot's loss of directional control during an aborted takeoff with a tailwind, which resulted in a noseover.
- [NTSB ERA20WA196](https://openairdocs.org/ntsb/ERA20WA196.md): Diamond DA20 · Rome, Italy · Accident · 1 fatal · Foreign investigation · May 25, 2020 · I-DADL · Substantial damage
  > The government of Italy has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on May 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…
- [NTSB WPR20CA153](https://openairdocs.org/ntsb/WPR20CA153.md): Ayres S 2R · Artois, CA · Accident · Minor injuries · Class 4 · Data collection · Final report · May 23, 2020 · N5573X · Substantial damage
  > The pilot's failure to maintain clearance from power lines during a go-around.
- [NTSB CEN20CA190](https://openairdocs.org/ntsb/CEN20CA190.md): Air Tractor AT502 · Bunkie, LA · Accident · Minor injuries · Class 4 · Data collection · Final report · May 23, 2020 · N571LA · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB CEN20CA188](https://openairdocs.org/ntsb/CEN20CA188.md): Cessna R172 · Lino Lakes, MN · Accident · No injuries · Class 4 · Data collection · Final report · May 20, 2020 · N612R · Substantial damage
  > The pilot's loss of directional control during takeoff with a crosswind.
- [NTSB CEN20CA184](https://openairdocs.org/ntsb/CEN20CA184.md): Rhoads, Larry E Sopwith Baby · Lee's Summit, MO · Accident · No injuries · Class 4 · Data collection · Final report · May 19, 2020 · N41LR · Substantial damage
  > The airplane builder's improper installation of the lower right wing which resulted in an uncommanded left roll and the subsequent loss of control.
- [NTSB ANC20CA047](https://openairdocs.org/ntsb/ANC20CA047.md): Piper PA 18 · McGrath, AK · Accident · No injuries · Class 4 · Data collection · Final report · May 16, 2020 · N5478H · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a collision with trees and impacted with the ground.
- [NTSB WPR20LA148](https://openairdocs.org/ntsb/WPR20LA148.md): American AA-1A · Blythe, CA · Accident · Serious injuries · Class 3 · Limited · Final report · May 15, 2020 · N12YT · Substantial damage
  > The excessive wear of one magneto’s wiring harness, which resulted in a loss of engine power during takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following the loss of engine power, which resulted in exceedance of the…
- [NTSB WPR20WA143](https://openairdocs.org/ntsb/WPR20WA143.md): Daher Kodiak · Papua, Indonesia · Accident · 1 fatal · Foreign investigation · May 12, 2020 · PK-MEC · Substantial damage
  > The government of Indonesia has notified the NTSB of an accident involving a Daher Kodiak airplane that occurred on May 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…
- [NTSB ERA20LA179](https://openairdocs.org/ntsb/ERA20LA179.md): Beech F33 · Land O Lakes, FL · Accident · 1 fatal · Class 3 · Limited · Final report · May 12, 2020 · N711JA · Destroyed
  > The partial loss of engine power due to a contaminated fuel system and the pilot’s improper decision to attempt a takeoff with a known deficiency in engine power.

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

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

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