# 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 36 of 281 · 14,035 cases ## Cases, newest first - [NTSB WPR18LA020](https://openairdocs.org/ntsb/WPR18LA020.md): Cessna 140 · Port Townsend, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 30, 2017 · N72339 · Substantial damage > A total loss of engine power for undetermined reasons. - [NTSB ANC18WA076](https://openairdocs.org/ntsb/ANC18WA076.md): Piper PA34 · Calgary Springbank, Canada · Accident · 2 fatal · Foreign investigation · Oct 26, 2017 · C-GCCM · Substantial damage > On October 26, 2017, about 0952 mountain daylight time, a Piper PA-34-200T airplane, C-GCCM, departed controlled flight and impacted terrain shortly after takeoff from Calgary Springbank Airport (CYBW), Alberta, Canada. The flight instructor and pilot… - [NTSB WPR18WA017](https://openairdocs.org/ntsb/WPR18WA017.md): Cessna 210 · Albany, Australia · Accident · 1 fatal · Foreign investigation · Oct 24, 2017 · VH-DBU · Destroyed > On October 24, 2017, at 1115 local time, a Cessna 210B, VH-DBU, was destroyed when it impacted the ground following a collision with terrain near Albany, Western Australia. The airplane was operated under the pertinent regulations of the Australian… - [NTSB WPR18LA012](https://openairdocs.org/ntsb/WPR18LA012.md): Cirrus Design SR22T · San Carlos, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2017 · N3636E · Substantial damage > The pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which… - [NTSB CEN18LA015](https://openairdocs.org/ntsb/CEN18LA015.md): Cessna 150J · Willmar, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2017 · N50609 · Substantial damage > The pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing. - [NTSB WPR18WA025](https://openairdocs.org/ntsb/WPR18WA025.md): Quicksilver GT500 · Melaka, Malaysia · Accident · 1 fatal · Foreign investigation · Oct 14, 2017 · 9M-EAC · Destroyed > On October 14, 2017, about 1130 local time, a Quicksilver Aircraft GT-500, registration 9M-EAC, was destroyed after colliding with a river shortly after takeoff from Sungai Rambai Aerodrome, Melaka, Malaysia. The airplane was operated under the pertinent… - [NTSB GAA18CA014](https://openairdocs.org/ntsb/GAA18CA014.md): Himsl Vincent S Vans RV-8 · Othello, WA · Accident · No injuries · Data collection · Final report · Oct 14, 2017 · N8432 · Substantial damage > The pilot's failure to maintain directional control during the takeoff roll in crosswind conditions. - [NTSB ERA18WA015](https://openairdocs.org/ntsb/ERA18WA015.md): Cessna U206 · Itaituba, Brazil · Accident · 1 fatal · Foreign investigation · Oct 11, 2017 · PT-LSC · Destroyed > On October 11, 2017, about 1600 universal coordinated time, a Cessna U206G, Brazilian registration PT-LSC, was destroyed when it collided with a tree during takeoff near Itaituba, State of Para, Brazil. The pilot was fatally injured, and one passenger… - [NTSB CEN18LA012](https://openairdocs.org/ntsb/CEN18LA012.md): Globe GC 1A · Los Lunas, NM · Accident · 1 fatal · Limited investigation · Final report · Oct 9, 2017 · N90365 · Substantial damage > The loss of directional control during takeoff and impact with a steel culvert. - [NTSB CEN18WA007](https://openairdocs.org/ntsb/CEN18WA007.md): Robinson R44 · Gramzda, Latvia · Accident · 1 fatal · Foreign investigation · Oct 8, 2017 · YL-HBH > On October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously… - [NTSB GAA18CA006](https://openairdocs.org/ntsb/GAA18CA006.md): Maule M 7 · Manokatak, AK · Accident · No injuries · Data collection · Final report · Oct 7, 2017 · N81818 · Substantial damage > The pilot’s failure to maintain directional control during takeoff in gusting wind conditions. - [NTSB GAA18CA004](https://openairdocs.org/ntsb/GAA18CA004.md): Mooney M20 · Topping, VA · Accident · Minor injuries · Data collection · Final report · Oct 7, 2017 · N7884V · Substantial damage > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall. - [NTSB GAA18CA001](https://openairdocs.org/ntsb/GAA18CA001.md): Piper J3C · Yakima, WA · Accident · No injuries · Data collection · Final report · Oct 3, 2017 · N48694 · Substantial damage > The flight instructor's failure to maintain directional control during the takeoff roll. - [NTSB DCA17WA215](https://openairdocs.org/ntsb/DCA17WA215.md): Boeing 737 · Budapest, Hungary · Incident · No injuries · Foreign investigation · Sep 29, 2017 · EI-FRR · No damage > The Ministry of National Development Transport Safety Bureau of Hungary has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the… - [NTSB DCA17WA216](https://openairdocs.org/ntsb/DCA17WA216.md): Boeing 737 · Luga, Malta · Incident · No injuries · Foreign investigation · Sep 28, 2017 · G-FDZJ · No damage > The United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation… - [NTSB DCA17WA203](https://openairdocs.org/ntsb/DCA17WA203.md): Airbus A330 · Hong Kong, Hong Kong SAR China · Incident · No injuries · Foreign investigation · Sep 22, 2017 · B-LNS · 2 aircraft · No damage > The Civil Aviation Department of Hong Kong has notified the NTSB of an incident involving a BOEING 747-433 airplane that occurred on September 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Government of the… - [NTSB GAA17CA552](https://openairdocs.org/ntsb/GAA17CA552.md): Hencken William Pietenpol AIR Camper · Franklin, PA · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N40WH · Substantial damage > The failure of the weld that connects the left main landing gear and the axle during the takeoff roll. - [NTSB GAA17CA547](https://openairdocs.org/ntsb/GAA17CA547.md): Cessna 180 · Albuquerque, NM · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N180SA · Substantial damage > The pilot’s failure to maintain directional control during the takeoff roll in gusting crosswind conditions. - [NTSB GAA17CA546](https://openairdocs.org/ntsb/GAA17CA546.md): Cessna 150 · Siler City, NC · Accident · No injuries · Data collection · Final report · Sep 20, 2017 · N6250T · Substantial damage > The pilot's improper decision to take off with known electrical issues, which distracted him and led to a loss of directional control during the takeoff roll. - [NTSB DCA17WA200](https://openairdocs.org/ntsb/DCA17WA200.md): Boeing Boeing 737-8AS · London, United Kingdom · Incident · No injuries · Foreign investigation · Sep 15, 2017 · EI-DLV · Minor damage > The AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO… - [NTSB ERA17LA329](https://openairdocs.org/ntsb/ERA17LA329.md): Cessna 402 · Nantucket, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 2017 · N836GW · Substantial damage > The separation of the pushrod from the elevator trim tab actuator, which rendered controlled flight impossible. Contributing to the separation of the pushrod was the failure of maintenance personnel to properly secure it to the elevator trim tab actuator. - [NTSB GAA17CA532](https://openairdocs.org/ntsb/GAA17CA532.md): Cessna 177 · Harrisonville, MO · Accident · No injuries · Data collection · Final report · Sep 12, 2017 · N34413 · Substantial damage > A collision with a deer on the runway during the takeoff roll. - [NTSB GAA17CA549](https://openairdocs.org/ntsb/GAA17CA549.md): Cessna U206 · Chicken, AK · Accident · No injuries · Data collection · Final report · Sep 5, 2017 · N734GW · Substantial damage > The pilot’s failure to maintain clearance from a sign while taking off from a road. - [NTSB ENG17RA037](https://openairdocs.org/ntsb/ENG17RA037.md): Boeing 777 · Tokyo, Japan · Incident · No injuries · Foreign investigation · Sep 5, 2017 · JA743J > The Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B777-300ER that occurred September 5, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO… - [NTSB CEN17RA337](https://openairdocs.org/ntsb/CEN17RA337.md): Cessna U206 · San Jose, Costa Rica · Accident · 2 fatal · Foreign investigation · Sep 5, 2017 · TI-AGM · Destroyed > import - [NTSB ANC17LA053](https://openairdocs.org/ntsb/ANC17LA053.md): Cessna U206G · Kodiak, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 2017 · N16GP · Substantial damage > ***This probable cause was modified on November 27, 2018. Please see the docket for this accident to view the original probable cause.*** The pilot's improper decision to takeoff in an area of rough water and ocean swells, which resulted in a failure of the… - [NTSB ERA17LA311](https://openairdocs.org/ntsb/ERA17LA311.md): Piper PA32R · Merritt Island, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 2017 · N544DG · Substantial damage > The pilot's inadequate preflight planning and improper takeoff technique, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. - [NTSB GAA17CA545](https://openairdocs.org/ntsb/GAA17CA545.md): Dedeaux Gary G GN-1 · Elba, AL · Accident · No injuries · Data collection · Final report · Sep 2, 2017 · N168BD · Substantial damage > The pilot's incorrect pitch control during the initial climb, which resulted in his decision to abort the takeoff and a subsequent hard landing. - [NTSB ERA17LA312](https://openairdocs.org/ntsb/ERA17LA312.md): Piper PA28 · Lyndonville, VT · Accident · No injuries · Limited investigation · Final report · Sep 2, 2017 · N132AV · Substantial damage > The pilot's loss of airplane control during takeoff. - [NTSB GAA17CA576](https://openairdocs.org/ntsb/GAA17CA576.md): Hunter George RV 6 · Montgomery, NY · Accident · Minor injuries · Data collection · Final report · Aug 30, 2017 · N6GH · Substantial damage > The pilot’s loss of directional control during the takeoff roll, which resulted in impact with visual approach slope indicator lights. - [NTSB GAA17CA570](https://openairdocs.org/ntsb/GAA17CA570.md): Piper PA 31 · Saipan · Accident · No injuries · Data collection · Final report · Aug 30, 2017 · N4078J · Substantial damage > Impact with multiple birds while retracting the landing gear, which resulted in the subsequent failure of the right inboard main landing gear door actuator hose and prevented the pilot from being able to extend the landing gear. - [NTSB ERA17LA297](https://openairdocs.org/ntsb/ERA17LA297.md): Tukan Trike · Nicholasville, KY · Accident · 1 fatal · Limited investigation · Final report · Aug 27, 2017 · UNREG · Substantial damage > The noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during takeoff. - [NTSB WPR17LA194](https://openairdocs.org/ntsb/WPR17LA194.md): Paul Gaywood E CH 601 HD · Goldendale, WA · Accident · No injuries · Class 3 · Limited · Final report · Aug 26, 2017 · N9066F · Substantial damage > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB ENG17WA034](https://openairdocs.org/ntsb/ENG17WA034.md): Boeing 747 · Delhi, India · Accident · No injuries · Foreign investigation · Aug 26, 2017 · ER-BAT · Substantial damage > The India Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of an incident involving a Boeing 747-200 which occurred on August 26, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the… - [NTSB GAA17CA509](https://openairdocs.org/ntsb/GAA17CA509.md): Robinson Helicopter R22 · Bremerton, WA · Accident · No injuries · Data collection · Final report · Aug 24, 2017 · N7198J · Substantial damage > The student pilot’s improper bank control during takeoff, which resulted in a dynamic rollover. - [NTSB DCA17WA185](https://openairdocs.org/ntsb/DCA17WA185.md): Boeing 737 · Georgetown, Guyana · Incident · No injuries · Foreign investigation · Aug 23, 2017 · XA-UHZ · No damage > The Guyana Civil Aviation Authority (CAA) has notified the NTSB of an incident involving a Boeing 737-200, which occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions of ICAO… - [NTSB CEN17LA327](https://openairdocs.org/ntsb/CEN17LA327.md): Greene R/Greene S Rans S 17 · Erie, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 2017 · N117BE · Substantial damage > The pilot's failure to maintain control following a rejected takeoff for a perceived loss of engine power. Contributing to the accident was the pilot's lack of training and experience in the airplane. - [NTSB GAA17CA500](https://openairdocs.org/ntsb/GAA17CA500.md): Beech C23 · Rexburg, ID · Accident · No injuries · Data collection · Final report · Aug 21, 2017 · N6576R · Substantial damage > The pilot's delayed decision to land the airplane with insufficient runway remaining after realizing the airplane wasn't climbing. - [NTSB GAA17CA498](https://openairdocs.org/ntsb/GAA17CA498.md): Luscombe 8 · Perryville, MO · Accident · Minor injuries · Data collection · Final report · Aug 21, 2017 · N2861K · Substantial damage > The pilot’s failure to maintain directional control during takeoff. - [NTSB ERA17LA293](https://openairdocs.org/ntsb/ERA17LA293.md): Cessna 172 · Guntersville, AL · Accident · No injuries · Limited investigation · Final report · Aug 21, 2017 · N73929 · Substantial damage > The pilot's failure to maintain directional control on takeoff. - [NTSB ERA17LA286](https://openairdocs.org/ntsb/ERA17LA286.md): Air Tractor AT 402A · Shaw, MS · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 21, 2017 · N247LA · Substantial damage > The pilot’s decision to attempt takeoff at high gross weight, in high density altitude conditions, and with insufficient runway length. Contributing to the accident was the pilot’s inadequate preflight planning. - [NTSB ERA17LA288](https://openairdocs.org/ntsb/ERA17LA288.md): Smith AEROSTAR601 · Marietta, PA · Accident · No injuries · Limited investigation · Final report · Aug 19, 2017 · N7108 · Substantial damage > The pilot's failure to maintain directional control during takeoff with a quartering tailwind. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model. - [NTSB ERA17LA282](https://openairdocs.org/ntsb/ERA17LA282.md): Bellanca 7ACA · Fairhope, AL · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2017 · N9176L · Substantial damage > A total loss of engine power for reasons that could not be determined because postaccident examination and a test run of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation. - [NTSB GAA17CA494](https://openairdocs.org/ntsb/GAA17CA494.md): Aerotechnik L 13 SEH Vivat · Moses Lake, WA · Accident · No injuries · Data collection · Final report · Aug 17, 2017 · N8230S · Substantial damage > The pilot's improper takeoff configuration due to his failure to follow the pretakeoff checklist, which resulted in a loss of lift and collision with obstacles. - [NTSB GAA17CA492](https://openairdocs.org/ntsb/GAA17CA492.md): Cessna 182 · Quitman, MS · Accident · Minor injuries · Data collection · Final report · Aug 12, 2017 · N147DD · Substantial damage > The student pilot’s failure to maintain directional control during takeoff in gusting wind conditions after passing a large hill. - [NTSB ERA17LA324](https://openairdocs.org/ntsb/ERA17LA324.md): Cessna 195 · Newman, GA · Accident · No injuries · Limited investigation · Final report · Aug 10, 2017 · N2100C · Substantial damage > The improper rigging of the tailwheel assembly, which resulted in a loss of directional control during takeoff. Contributing to accident was the pilot’s decision to operate the airplane despite knowing it required excessive right rudder inputs for it to move… - [NTSB ERA17RA315](https://openairdocs.org/ntsb/ERA17RA315.md): Cessna U206 · Eteringbang, Guyana · Accident · Serious injuries · Foreign investigation · Aug 8, 2017 · 8R-GPR · Substantial damage > On August 8, 2017, about 1513 coordinated universal time (UTC), a Cessna U206G, 8R-GPR, was substantially damaged during a forced landing in trees shortly after takeoff from Eteringbang Airstrip (SYET), Eteringbang, Cuyuni-Mazaruni Region, Guyana. Visual… - [NTSB DCA17WA225](https://openairdocs.org/ntsb/DCA17WA225.md): Boeing 737 · Dubai, United Arab Emirates · Incident · No injuries · Foreign investigation · Aug 8, 2017 · A6-FDS · Minor damage > The GCAA of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO… - [NTSB CEN17LA304](https://openairdocs.org/ntsb/CEN17LA304.md): Roger M Allen RA2 · Hector, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 2017 · N952RA · Substantial damage > The pilot’s improper installation of the control stick hardware, which resulted in a loss of elevator control in flight. - [NTSB GAA17CA476](https://openairdocs.org/ntsb/GAA17CA476.md): Cessna 172 · Drexel, MO · Accident · No injuries · Data collection · Final report · Aug 5, 2017 · N8226U · Substantial damage > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=37 ## 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=36 --- 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.