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

## Cases, newest first

- [NTSB WPR12LA122](https://openairdocs.org/ntsb/WPR12LA122.md): Bowers Fly Baby 1-A · Fallbrook, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 2012 · N41017 · Substantial damage
  > The pilot did not maintain directional control of the airplane during the takeoff roll.
- [NTSB ERA12CA220](https://openairdocs.org/ntsb/ERA12CA220.md): American Champion 8KCAB · Beverly, MA · Accident · No injuries · Data collection · Final report · Mar 4, 2012 · N7DF · Substantial damage
  > The pilot's loss of airplane control during takeoff, which resulted in a runway excursion.
- [NTSB WPR12WA335](https://openairdocs.org/ntsb/WPR12WA335.md): Hawker Beechcraft G58 · Auckland, New Zealand · Accident · No injuries · Foreign investigation · Feb 28, 2012 · N298WA · Substantial damage
- [NTSB WPR12LA116](https://openairdocs.org/ntsb/WPR12LA116.md): Beech S35 · Dixie Valley, NV · Accident · No injuries · Limited investigation · Final report · Feb 25, 2012 · N272D · Substantial damage
  > The airplane’s encounter with forecast low-level windshear conditions during takeoff, which resulted in a loss of lift.
- [NTSB ERA12CA213](https://openairdocs.org/ntsb/ERA12CA213.md): Zenair CH 2000 · Warrenton, VA · Accident · No injuries · Data collection · Final report · Feb 13, 2012 · N200ZA · Substantial damage
  > The student pilot's failure to follow instruction and to relinquish control of the airplane to the flight instructor in a timely manner, which resulted in a runway excursion.
- [NTSB ENG12IA012](https://openairdocs.org/ntsb/ENG12IA012.md): Mcdonnell Douglas MD-10-30F · Portland, OR · Incident · No injuries · Incident investigation · Final report · Feb 13, 2012 · N304FE · Minor damage
  > The fracture of the fan mid shaft due to a stress corrosion cracking initiated by local regions of corrosion pitting, which resulted from oil migration within the shaft and its subsequent degradation.
- [NTSB CEN12LA153](https://openairdocs.org/ntsb/CEN12LA153.md): Socata TBM 700 · Madison, WI · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 2012 · N850LM · Substantial damage
  > The pilot’s failure to ensure that ice and snow were removed from the airplane’s surfaces during the preflight inspection, which resulted in an inadvertent aerodynamic stall after takeoff and loss of control of the airplane.
- [NTSB DCA12WA063](https://openairdocs.org/ntsb/DCA12WA063.md): Mcdonnell Douglas MD80 - 80 · Copenhagen, Denmark · Incident · No injuries · Foreign investigation · Feb 5, 2012 · SE-DIL · Minor damage
  > The Danish Accident Investigation Board (AIB) has notified the NTSB of an incident involving a McDonnell Douglas MD-82 that occurred on February 5, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under the…
- [NTSB CEN12FA151](https://openairdocs.org/ntsb/CEN12FA151.md): Gates Lear Jet 35 · Pueblo, CO · Accident · No injuries · Field investigation · Final report · Feb 3, 2012 · N31WS · Substantial damage
  > The captain's failure to maintain airplane control during an attempted crosswind takeoff on a contaminated runway.
- [NTSB WPR12CA083](https://openairdocs.org/ntsb/WPR12CA083.md): Piper PA-28-181 · Santa Barbara, CA · Accident · No injuries · Data collection · Final report · Jan 26, 2012 · N4297S · Substantial damage
  > The pilot did not maintain directional control during takeoff.
- [NTSB WPR12LA096](https://openairdocs.org/ntsb/WPR12LA096.md): Arrow Falcon Exporters OH-58A · Brawley, CA · Accident · No injuries · Limited investigation · Final report · Jan 21, 2012 · N902SF · Substantial damage
  > The failure of the main rotor mast due to fatigue cracks that originated from corrosion pits. Contributing to the accident was the operator’s failure to adhere to the manufacturer’s recommended overhaul interval for the main rotor mast.
- [NTSB CEN12CA140](https://openairdocs.org/ntsb/CEN12CA140.md): Piper PA-32RT-300 · Angle Fire, NM · Accident · No injuries · Data collection · Final report · Jan 15, 2012 · N513CW · Substantial damage
  > The pilot did not maintain control of the airplane during the takeoff in gusting crosswind conditions.
- [NTSB CEN12CA131](https://openairdocs.org/ntsb/CEN12CA131.md): Infinity Power Parachutes Classic 2002 · Alanson, MI · Accident · Serious injuries · Data collection · Final report · Jan 11, 2012 · N3902V · Substantial damage
  > The powered parachute’s encounter with a downdraft/windshear during takeoff, which resulted in a loss of lift.
- [NTSB CEN12LA126](https://openairdocs.org/ntsb/CEN12LA126.md): Aviat A1 · Somerset, CO · Accident · No injuries · Limited investigation · Final report · Jan 6, 2012 · N127AK · Substantial damage
  > The pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.
- [NTSB CEN12CA121](https://openairdocs.org/ntsb/CEN12CA121.md): Butler John R SX 300 · Truth or Consequences, NM · Accident · No injuries · Data collection · Final report · Jan 3, 2012 · N120J · Substantial damage
  > The pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.
- [NTSB WPR12LA070](https://openairdocs.org/ntsb/WPR12LA070.md): Ryan Navion · Concord, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2011 · N4398K · Substantial damage
  > The pilot's inadequate preflight inspection of the airplane and the subsequent total loss of engine power as a result of debris and water contamination in the fuel system.
- [NTSB CEN12LA114](https://openairdocs.org/ntsb/CEN12LA114.md): Southern Powered Parachute Condor · Rogersville, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 2011 · UNREG · Substantial damage
  > The pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.
- [NTSB ERA12CA118](https://openairdocs.org/ntsb/ERA12CA118.md): Cessna 120 · Montague, MA · Accident · No injuries · Data collection · Final report · Dec 17, 2011 · N89809 · Substantial damage
  > The pilot's delay in performing a rejected takeoff after experiencing an intermittent loss of engine power, which resulted in a runway excursion.
- [NTSB ERA12FA107](https://openairdocs.org/ntsb/ERA12FA107.md): Shaw Douglas Wayne Rans S 7 · Somerville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 11, 2011 · N347DS · Substantial damage
  > The pilot's incapacitation due to a ruptured berry aneurysm during takeoff.
- [NTSB DCA13WA052](https://openairdocs.org/ntsb/DCA13WA052.md): Beech 1900 · Goose Bay, Canada · Incident · No injuries · Foreign investigation · Dec 10, 2011 · C-GLHO · No damage
  > On 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…
- [NTSB DCA12WA018](https://openairdocs.org/ntsb/DCA12WA018.md): Boeing 737 · Seoul, South Korea · Incident · No injuries · Foreign investigation · Dec 4, 2011 · HL-7796 · Minor damage
  > The Korean Aviationand Railway Accident Investigation Board (ARAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 4, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under…
- [NTSB ERA12CA094](https://openairdocs.org/ntsb/ERA12CA094.md): Nuse George F1H Rocket · Caroleen, NC · Accident · No injuries · Data collection · Final report · Dec 2, 2011 · N295JS · Substantial damage
  > The pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.
- [NTSB OPS12IA167](https://openairdocs.org/ntsb/OPS12IA167.md): Learjet 45 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Dec 1, 2011 · N570AM · 2 aircraft · No damage
  > The tower local controller did not ensure that the runway was clear of conflict before directing the B737 to cross the runway, and other air traffic control personnel did not effectively intervene when the separation between the two airplanes became…
- [NTSB DCA12WA019](https://openairdocs.org/ntsb/DCA12WA019.md): Gulfstream American G 1159 · Huambo, Angola · Accident · No injuries · Foreign investigation · Nov 26, 2011 · N811DE · Substantial damage
  > On November 26, 2011, about 1300 UTC, N811DE, a Grumman G-1159 Gulfstream G-II, a private flight operated by Wings Over Africa, was involved in a runway excursion following a rejected takeoff. None of the 10 persons aboard were injured. The aircraft was…
- [NTSB CEN12FA073](https://openairdocs.org/ntsb/CEN12FA073.md): Skykits Savannah VGW · Plato Center, IL · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2011 · N61XT · Substantial damage
  > The noncertificated pilot’s decision to fly the airplane without receiving any flight instruction in the airplane, which resulted in his failure to maintain sufficient airspeed during takeoff and the subsequent aerodynamic stall.
- [NTSB ERA12LA077](https://openairdocs.org/ntsb/ERA12LA077.md): Ercoupe 415-C · Mulberry, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2011 · N99168 · Substantial damage
  > The pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…
- [NTSB CEN12LA071](https://openairdocs.org/ntsb/CEN12LA071.md): Juve Richard G Zodiac CH601 HDS · Clinton, AR · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2011 · N274 · Substantial damage
  > The inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.
- [NTSB WPR12CA038](https://openairdocs.org/ntsb/WPR12CA038.md): Cessna 172S · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Nov 12, 2011 · N24350 · Substantial damage
  > The student pilot's inadequate directional control during takeoff.
- [NTSB ERA12WA092](https://openairdocs.org/ntsb/ERA12WA092.md): Piper PA-25 · Meteropolitana, Chile · Accident · No injuries · Foreign investigation · Nov 11, 2011 · CC-ABM · Substantial damage
  > On November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…
- [NTSB CEN12LA059](https://openairdocs.org/ntsb/CEN12LA059.md): Cessna 172M · Sturgis, SD · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2011 · N13584 · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.
- [NTSB CEN12WA223](https://openairdocs.org/ntsb/CEN12WA223.md): Piper PA-31 · Cottens, Switzerland · Accident · 1 fatal · Foreign investigation · Nov 10, 2011 · HB-LOT · Destroyed
  > The accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…
- [NTSB WPR12CA033](https://openairdocs.org/ntsb/WPR12CA033.md): Casler Scott CX-4 · San Carlos, AZ · Accident · No injuries · Data collection · Final report · Nov 9, 2011 · N5089Q · Substantial damage
  > The pilot's inadequate directional control during takeoff.
- [NTSB ERA12WA067](https://openairdocs.org/ntsb/ERA12WA067.md): Cessna 402 · Quibdo, Colombia · Incident · No injuries · Foreign investigation · Nov 4, 2011 · HK4417 · Minor damage
  > On November 4, 2011, about 1640 UTC, a Cessna 402C, Colombian registration HK4417, registered to and operated by AeroEjecutivos De Antioquia S.A. experienced collapse of the left main landing gear during the takeoff roll from El Carano Airport (SKUI), Quibdo,…
- [NTSB CEN12LA056](https://openairdocs.org/ntsb/CEN12LA056.md): Cessna 182K · Branson West, MO · Accident · No injuries · Limited investigation · Final report · Oct 30, 2011 · N2893R · Substantial damage
  > The pilot's failure to ensure that his seat was in a locked position before takeoff, which resulted in the seat sliding rearward and the subsequent loss of directional control.
- [NTSB DCA12WA007](https://openairdocs.org/ntsb/DCA12WA007.md): Boeing 737 - 800 · Faro, Portugal · Accident · No injuries · Foreign investigation · Oct 24, 2011 · EI-DPA · Substantial damage
  > TheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…
- [NTSB ERA12CA040](https://openairdocs.org/ntsb/ERA12CA040.md): Engineering & Research 415-C · Mebane, NC · Accident · No injuries · Data collection · Final report · Oct 16, 2011 · N3760H · Substantial damage
  > The pilot's delay in aborting the takeoff.
- [NTSB OPS12IA041](https://openairdocs.org/ntsb/OPS12IA041.md): Cessna 172S · Daytona Beach, FL · Incident · No injuries · Incident investigation · Final report · Oct 15, 2011 · N488ER · 2 aircraft · No damage
  > The departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…
- [NTSB CEN12CA029](https://openairdocs.org/ntsb/CEN12CA029.md): Hunt Sparrowhawk · Blair, NE · Accident · Minor injuries · Data collection · Final report · Oct 15, 2011 · N29HT · Substantial damage
  > The pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.
- [NTSB WPR12FA010](https://openairdocs.org/ntsb/WPR12FA010.md): DG Flugzeugbau DG 1000S · Cle Elum, WA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 2011 · N7760A · Substantial damage
  > The pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.
- [NTSB ENG12IA001](https://openairdocs.org/ntsb/ENG12IA001.md): Boeing 757-251 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Oct 10, 2011 · N553NW · Minor damage
  > the return to service of overhauled airplane engine parts with undetected fatigue cracks, resulting in complete loss of engine power and uncontained engine failure. A contributing factor was the inadequate diffuser and HPT case inspection procedure.
- [NTSB ERA12CA022](https://openairdocs.org/ntsb/ERA12CA022.md): Aeronca 0-58A · Westmoreland, TN · Accident · No injuries · Data collection · Final report · Oct 9, 2011 · N46513 · Substantial damage
  > The pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.
- [NTSB ERA12LA016](https://openairdocs.org/ntsb/ERA12LA016.md): Cessna 180J · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Oct 5, 2011 · N180RN · Substantial damage
  > The pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.
- [NTSB ERA12CA013](https://openairdocs.org/ntsb/ERA12CA013.md): Loehle Loehle P-40 · Tullahoma, TN · Accident · Minor injuries · Data collection · Final report · Oct 3, 2011 · N414L · Substantial damage
  > The pilot's delayed decision to abort the takeoff.
- [NTSB CEN12CA003](https://openairdocs.org/ntsb/CEN12CA003.md): Sadler Terry Rans S-7 Courier · Riley, KS · Accident · Serious injuries · Data collection · Final report · Oct 1, 2011 · N2417T · Substantial damage
  > A total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.
- [NTSB ERA11CA505](https://openairdocs.org/ntsb/ERA11CA505.md): Robinson Helicopter R44 · Clearwater, FL · Accident · Minor injuries · Data collection · Final report · Sep 27, 2011 · N982DH · Substantial damage
  > The certified flight instructor's delayed remedial action, which resulted in a loss of control and subsequent rollover.
- [NTSB ANC11CA112](https://openairdocs.org/ntsb/ANC11CA112.md): Cessna 180 · Haines, AK · Accident · No injuries · Data collection · Final report · Sep 27, 2011 · N3126D · Substantial damage
  > The pilot's loss of directional control during takeoff in a float-equipped airplane for an undetermined reason, which resulted in the airplane colliding with trees and the shore.
- [NTSB ANC11CA113](https://openairdocs.org/ntsb/ANC11CA113.md): Piper PA-12 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Sep 26, 2011 · N2945M · Substantial damage
  > The pilot’s decision to take off from an off-airport site in variable wind.
- [NTSB ERA11FA504](https://openairdocs.org/ntsb/ERA11FA504.md): Hutchinson Kenneth A Velocity RG · Sanford, NC · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2011 · N360TV · Substantial damage
  > The pilot/owner's intentional flight of his airplane with known mechanical discrepancies (frozen turbocharger waste gate), which resulted in a partial loss of engine power and subsequent collision with trees and terrain shortly after takeoff. Contributing to…
- [NTSB ANC11CA106](https://openairdocs.org/ntsb/ANC11CA106.md): Piper PA-12 · Beluga, AK · Accident · No injuries · Data collection · Final report · Sep 23, 2011 · N78564 · Substantial damage
  > The pilot's decision to take off uphill into rising terrain.
- [NTSB ANC11CA096](https://openairdocs.org/ntsb/ANC11CA096.md): Cessna 170B · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Sep 20, 2011 · N2810C · Substantial damage
  > The pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.

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

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

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