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

## Cases, newest first

- [NTSB DCA13WA092](https://openairdocs.org/ntsb/DCA13WA092.md): Boeing 767 · Madrid, Spain · Accident · No injuries · Foreign investigation · Apr 16, 2013 · XA-TOJ · Substantial damage
  > On April 16,2013, about 1235 UTC, an Aero Mexico B767-200, registration XA-TOJ, operated as flight 071 from Madrid-Barajas International Airport, Madrid, Spain, to Benito Juarez International Airport, Mexico City, Mexico, experienced a tail strike while…
- [NTSB CEN13LA231](https://openairdocs.org/ntsb/CEN13LA231.md): Needham Stoddard-Hamilton TD · Bloomington, IN · Accident · No injuries · Limited investigation · Final report · Apr 14, 2013 · N95RL · Substantial damage
  > The improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.
- [NTSB CEN13LA227](https://openairdocs.org/ntsb/CEN13LA227.md): Quad City Ultralight Acft Challenger I · Winnie, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 2013 · N171DP · Substantial damage
  > The noncertificated pilot’s failure to maintain airplane control during takeoff due to his fixation on the instrument panel.
- [NTSB CEN13CA222](https://openairdocs.org/ntsb/CEN13CA222.md): Cessna 172 · Manvel, TX · Accident · Minor injuries · Data collection · Final report · Apr 8, 2013 · N7825T · Substantial damage
  > The pilot’s failure to maintain airplane control while taking off in gusting wind conditions.
- [NTSB WPR13CA199](https://openairdocs.org/ntsb/WPR13CA199.md): Cessna A185E · Cottonwood, ID · Accident · No injuries · Data collection · Final report · Apr 7, 2013 · N2303Y · Substantial damage
  > The pilot’s failure to see and avoid an object on the grass airstrip during the takeoff.
- [NTSB ERA13LA194](https://openairdocs.org/ntsb/ERA13LA194.md): Cessna 172M · New Castle, VA · Accident · No injuries · Limited investigation · Final report · Apr 7, 2013 · N92804 · Substantial damage
  > The pilot's failure to abort the takeoff after recognizing that the airplane was not accelerating properly, which led to an aerodynamic stall. The reason for the lack of acceleration could not be determined because postaccident examinations did not reveal any…
- [NTSB DCA13WA072](https://openairdocs.org/ntsb/DCA13WA072.md): Boeing B737 · Guatemala City, Guatemala · Incident · No injuries · Foreign investigation · Apr 5, 2013 · N279AD · Minor damage
  > On 5 April 2013, at approximately 1029 local time, a Boeing 737-4Q8, registration N279AD, ingested a turkey vulture in the right engine during takeoff from La Aurora Airport, Guatemala City, Guatemala. Inspection of the airplane revealed damage to the first…
- [NTSB WPR13LA180](https://openairdocs.org/ntsb/WPR13LA180.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Apr 4, 2013 · N2166K · Substantial damage
  > The student pilot's excessive directional control inputs during the takeoff roll and the flight instructor's delayed and ineffective corrective actions, which resulted in the loss of airplane control.
- [NTSB WPR13CA179](https://openairdocs.org/ntsb/WPR13CA179.md): Aeronca 7CCM · Caldwell, ID · Accident · No injuries · Data collection · Final report · Apr 3, 2013 · N4687E · Substantial damage
  > The pilot's loss of directional control after an encounter with a wind gust during takeoff.
- [NTSB ERA13CA185](https://openairdocs.org/ntsb/ERA13CA185.md): Cessna 172N · Bally, PA · Accident · No injuries · Data collection · Final report · Mar 30, 2013 · N4601D · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll.
- [NTSB WPR13CA164](https://openairdocs.org/ntsb/WPR13CA164.md): Piper PA-30 · Fullerton, CA · Accident · No injuries · Data collection · Final report · Mar 23, 2013 · N7497Y · Substantial damage
  > The pilot receiving instruction’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action.
- [NTSB CEN13CA203](https://openairdocs.org/ntsb/CEN13CA203.md): Aviat A-1B · Dumas, TX · Accident · No injuries · Data collection · Final report · Mar 21, 2013 · N132AA · Substantial damage
  > The pilot’s failure to maintain control of the airplane while taking off in gusty crosswind conditions. Contributing to the accident was the pilot’s decision to takeoff instead of waiting to ensure that the wind velocity had decreased.
- [NTSB WPR13LA154](https://openairdocs.org/ntsb/WPR13LA154.md): Piper PA-23-250 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Mar 18, 2013 · N318CA · Substantial damage
  > A runway overrun due to an insufficient stopping distance due to the downsloping runway during a rejected takeoff. Contributing to the accident was a cabin door that inadvertently opened during the takeoff roll.
- [NTSB CEN13LA193](https://openairdocs.org/ntsb/CEN13LA193.md): Piper J3C-65 · Seguin, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 2013 · N88313 · Substantial damage
  > The partial loss of engine power for reasons that could not be undetermined because an examination of the engine did not reveal any malfunctions or failures that would preclude normal operation.
- [NTSB CEN13CA189](https://openairdocs.org/ntsb/CEN13CA189.md): Cessna 140 · El Reno, OK · Accident · No injuries · Data collection · Final report · Mar 11, 2013 · N90047 · Substantial damage
  > The pilot's failure to maintain control during takeoff. Contributing to the accident was the check pilot's delayed remedial action.
- [NTSB CEN13LA191](https://openairdocs.org/ntsb/CEN13LA191.md): Grumman Acft ENG Cor-Schweizer G-164B · Beech Grove, AR · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 2013 · N6902K · Substantial damage
  > The pilot’s failure to maintain control of the airplane during the takeoff roll.
- [NTSB CEN13LA188](https://openairdocs.org/ntsb/CEN13LA188.md): Piper PA 46-350P · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Mar 7, 2013 · N715BB · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB DCA13WA064](https://openairdocs.org/ntsb/DCA13WA064.md): Boeing 737 · Keflavik, Iceland · Incident · No injuries · Foreign investigation · Mar 6, 2013 · OY-PSE · Minor damage
  > The AAIB of Iceland has notified the NTSB of an accident involving a Boeing 737 that occurred on March 06, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB Iceland's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB DCA13WA062](https://openairdocs.org/ntsb/DCA13WA062.md): Airbus · Chicago, IL · Incident · No injuries · Foreign investigation · Mar 6, 2013 · D-AIKJ · Minor damage
  > The BFU-DE of Germany has notified the NTSB of an accident involving an Airbus 330 that occurred on March 06, 2013 in Chicago, Illinois. The NTSB delegated the investigation to Germany and has appointed a U.S. Accredited Representative to assist the BFU-DE's…
- [NTSB WPR13CA140](https://openairdocs.org/ntsb/WPR13CA140.md): Weston SEA-ERA · Bellevue, WA · Accident · Minor injuries · Data collection · Final report · Mar 4, 2013 · N226SE · Substantial damage
  > The pilot’s failure to maintain control during takeoff on choppy water conditions.
- [NTSB CEN13FA183](https://openairdocs.org/ntsb/CEN13FA183.md): Mooney M20E · Angel Fire, NM · Accident · 4 fatal · Field investigation · Final report · Mar 3, 2013 · N3484X · Substantial damage
  > The pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…
- [NTSB WPR13LA135](https://openairdocs.org/ntsb/WPR13LA135.md): Summit II · Quartzsite, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 2013 · N8028X · Substantial damage
  > The noncertificated pilot’s failure to maintain aircraft control after encountering shifting wind, which resulted in collision with a windsock.
- [NTSB ERA13CA137](https://openairdocs.org/ntsb/ERA13CA137.md): Cessna 172N · Okeechobee, FL · Accident · Minor injuries · Data collection · Final report · Feb 18, 2013 · N6249D · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB WPR13LA132](https://openairdocs.org/ntsb/WPR13LA132.md): Cessna T310R · Casper, WY · Accident · No injuries · Limited investigation · Final report · Feb 17, 2013 · N4941J · Substantial damage
  > The separation of the right main gear bracket assembly from its wing attachment fitting due to lack of lubrication of the torque tube bearing.
- [NTSB WPR13CA124](https://openairdocs.org/ntsb/WPR13CA124.md): Beech B19 · Ephrata, WA · Accident · No injuries · Data collection · Final report · Feb 13, 2013 · N2059L · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff ground roll in crosswind conditions, and the flight instructor's delayed remedial action.
- [NTSB WPR13CA117](https://openairdocs.org/ntsb/WPR13CA117.md): Cessna 170B · Sunburst, MT · Accident · No injuries · Data collection · Final report · Feb 6, 2013 · N2619D · Substantial damage
  > The pilot's failure to compensate for the strong, gusting wind conditions, which resulted in a loss of airplane control during takeoff.
- [NTSB WPR13LA109](https://openairdocs.org/ntsb/WPR13LA109.md): Piper PA-28-235 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Feb 1, 2013 · N8554W · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13CA151](https://openairdocs.org/ntsb/CEN13CA151.md): Cessna 172 · Murphysboro, IL · Accident · No injuries · Data collection · Final report · Feb 1, 2013 · N546A · Substantial damage
  > The pilot’s failure to maintain control of the airplane during the takeoff roll.
- [NTSB ENG13WA014](https://openairdocs.org/ntsb/ENG13WA014.md): Mcdonnell Douglas MD-82 · Copenhagen, Denmark, Denmark · Incident · No injuries · Foreign investigation · Jan 30, 2013 · SE-DIK · No damage
  > On January 30, 2013 an MD-82, registration number SE-DIK, sustained a serious engine failure during the takeoff roll. The engine has been removed from the airplane and will undergo a teardown examination. The Danish Accident Investigation Board is…
- [NTSB CEN13CA142](https://openairdocs.org/ntsb/CEN13CA142.md): Cessna 172S · Peoria, IL · Accident · No injuries · Data collection · Final report · Jan 24, 2013 · N5113J · Substantial damage
  > The pilot’s inadvertent activation of the electric trim to the nose-down position, which resulted in the airplane being improperly configured for takeoff, and the flight instructor’s incorrect remedial action that allowed the airplane to porpoise.
- [NTSB CEN13CA138](https://openairdocs.org/ntsb/CEN13CA138.md): Cessna 170B · Erie, CO · Accident · Minor injuries · Data collection · Final report · Jan 20, 2013 · N2323D · Substantial damage
  > The pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.
- [NTSB WPR13LA078](https://openairdocs.org/ntsb/WPR13LA078.md): Cessna 210A · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Dec 31, 2012 · N9507X · Substantial damage
  > A loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN13CA114](https://openairdocs.org/ntsb/CEN13CA114.md): Bell 407 · McAllen, TX · Accident · No injuries · Data collection · Final report · Dec 25, 2012 · N489AE · Substantial damage
  > The pilot’s failure to maintain clearance with a parked helicopter during takeoff.
- [NTSB CEN13IA107](https://openairdocs.org/ntsb/CEN13IA107.md): Swearingen SA227-AC · Williston, ND · Incident · No injuries · Incident investigation · Final report · Dec 14, 2012 · N3108B · No damage
  > The snowplow driver’s failure to ensure that the runway was clear before driving onto it, which resulted in a runway incursion with a departing airplane.
- [NTSB ERA13CA086](https://openairdocs.org/ntsb/ERA13CA086.md): Cessna 172P · Murfreesboro, TN · Accident · Serious injuries · Data collection · Final report · Dec 13, 2012 · N54500 · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB CEN13CA108](https://openairdocs.org/ntsb/CEN13CA108.md): Piper PA-18-150 · Okaton, SD · Accident · No injuries · Data collection · Final report · Dec 11, 2012 · N3471Z · Substantial damage
  > The pilot's failure to perform an adequate preflight inspection of the airplane and obstruction of the aileron control system by snow and ice, which led to a loss of control during flight.
- [NTSB CEN13LA076](https://openairdocs.org/ntsb/CEN13LA076.md): Cessna 177RG · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Nov 28, 2012 · N1912Q · Substantial damage
  > A loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.
- [NTSB CEN13LA068](https://openairdocs.org/ntsb/CEN13LA068.md): Boeing A75L3 · San Antonio, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2012 · N56226 · Substantial damage
  > A partial loss of engine power during takeoff, likely due to the accumulation of carburetor ice.
- [NTSB ENG13WA038](https://openairdocs.org/ntsb/ENG13WA038.md): Airbus A310 - 308 · Karachi, Pakistan · Incident · No injuries · Foreign investigation · Nov 18, 2012 · AP-BEB · No damage
  > The Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Airbus A-310-308, registration number AP-BEB, powered by General Electric CF6-80C2A8…
- [NTSB ERA13FA059](https://openairdocs.org/ntsb/ERA13FA059.md): Cessna 172N · Owls Head, ME · Accident · 3 fatal · Field investigation · Final report · Nov 16, 2012 · N6142F · Substantial damage
  > The vehicle driver's failure to verify that the runway was not occupied by an airplane before crossing the runway, which resulted in the vehicle being struck by a departing airplane, and the pilot's continued takeoff with flight control damage, which…
- [NTSB DCA13WA020](https://openairdocs.org/ntsb/DCA13WA020.md): Boeing MD-82 · Johannesburg, South Africa · Incident · No injuries · Foreign investigation · Nov 13, 2012 · ZS-TOG · Minor damage
  > On November 13, 2012, a McDonnell Douglas MD-80, registration ZS-TOG, experienced a wheel failure on the left hand main gear during takeoff from O.R.Tambo International Airport (FAJS),, South Africa. The chartered flight was enroute to Kamuzu International…
- [NTSB CEN13WA173](https://openairdocs.org/ntsb/CEN13WA173.md): Swearingen SA226 · Murcia, Spain · Accident · No injuries · Foreign investigation · Nov 13, 2012 · EC-JYC · Minor damage
  > On November 13, 2012, at 1205 coordinated universal time, a Swearingen Fairchild SA-226-TC, Spanish registered EC-JYC, operated by Zorex.org, sustained minor damage during the takeoff roll from the Murcia-San Javier Airport (LELC), Murcia, Spain. Visual…
- [NTSB WPR13CA039](https://openairdocs.org/ntsb/WPR13CA039.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Carlsbad, CA · Accident · No injuries · Data collection · Final report · Nov 11, 2012 · N153TB · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with parked aircraft. Contributing to the accident was the pilot's lack of experience in the airplane make/model.
- [NTSB DCA13WA019](https://openairdocs.org/ntsb/DCA13WA019.md): Boeing 757 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Nov 11, 2012 · D-ABOE · No damage
  > On November 11, 2013, a Boeing B757-300, registration D-ABOE, operated by Condor Flugdienst, experienced a smell in cockpit and cabin during take off roll and climb. The airplane returned to Frankfurt and landed uneventfully. There was no damage to the…
- [NTSB CEN13CA053](https://openairdocs.org/ntsb/CEN13CA053.md): Robinson Helicopter R44 II · Bryan, TX · Accident · No injuries · Data collection · Final report · Nov 6, 2012 · N131AA · Substantial damage
  > The pilot’s over-correction in an attempt to stabilize the helicopter during liftoff.
- [NTSB CEN13CA042](https://openairdocs.org/ntsb/CEN13CA042.md): Luscombe 8E · West Bend, WI · Accident · Minor injuries · Data collection · Final report · Nov 3, 2012 · N2368K · Substantial damage
  > The pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.
- [NTSB CEN13CA031](https://openairdocs.org/ntsb/CEN13CA031.md): Cessna 150 · Carrollton, OH · Accident · No injuries · Data collection · Final report · Oct 24, 2012 · N5978E · Substantial damage
  > The airplane’s collision with two deer during the takeoff roll.
- [NTSB CEN13CA022](https://openairdocs.org/ntsb/CEN13CA022.md): Robinson Helicopter R44 · Loop, TX · Accident · Minor injuries · Data collection · Final report · Oct 21, 2012 · N7507K · Substantial damage
  > The pilot’s inadequate performance calculations, which resulted in an overweight takeoff for the conditions and the subsequent hard impact with terrain.
- [NTSB ERA13CA035](https://openairdocs.org/ntsb/ERA13CA035.md): AB Sportine Aviacija Genesis 2 · Roseland, VA · Accident · Minor injuries · Data collection · Final report · Oct 20, 2012 · N4KN · Substantial damage
  > The pilot’s failure to maintain glider control during takeoff.
- [NTSB CEN13CA017](https://openairdocs.org/ntsb/CEN13CA017.md): Hunthrop Autogyro MTO Sport · Bourland, TX · Accident · Serious injuries · Data collection · Final report · Oct 20, 2012 · N589DH · Substantial damage
  > The pilot's decision to fly the gyroplane in gusty wind conditions that exceeded his limitations and his resultant loss of control during takeoff.

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

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

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