# 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 33 of 281 · 14,035 cases ## Cases, newest first - [NTSB GAA18CA481](https://openairdocs.org/ntsb/GAA18CA481.md): Helio H 295 · Great Falls, MT · Accident · No injuries · Data collection · Final report · Aug 11, 2018 · N77TR · Substantial damage > The pilot’s failure to maintain lateral control of the airplane during takeoff in a quartering tailwind. - [NTSB GAA18CA484](https://openairdocs.org/ntsb/GAA18CA484.md): Airgyro Tercel · Spanish Fork, UT · Accident · Minor injuries · Data collection · Final report · Aug 9, 2018 · N557AT · Substantial damage > The student pilot’s failure to maintain pitch and yaw control during takeoff. - [NTSB DCA18WA284](https://openairdocs.org/ntsb/DCA18WA284.md): Boeing 777 · Lahore, Pakistan · Incident · No injuries · Foreign investigation · Aug 8, 2018 · AP-BID > The Safety Investigation Board (SIB) Pakistan has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on August 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation… - [NTSB GAA18CA521](https://openairdocs.org/ntsb/GAA18CA521.md): Cub Crafters CC18 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Aug 1, 2018 · N437CC · Substantial damage > The pilot’s premature liftoff and subsequent settling of the airplane to the gravel airstrip. - [NTSB DCA18RA253](https://openairdocs.org/ntsb/DCA18RA253.md): Embraer ERJ190 · Durango, Mexico · Accident · Serious injuries · Foreign investigation · Jul 31, 2018 · XA-GAL · Destroyed > The Director General of Civil Aviation (DGAC) of Mexico has notified the NTSB of an accident involving an Embraer E-190, which occurred on July 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the… - [NTSB ANC18WA075](https://openairdocs.org/ntsb/ANC18WA075.md): Piper PA28 · Black Diamond, Canada · Accident · 1 fatal · Foreign investigation · Jul 30, 2018 · C-GVZJ · Substantial damage > On July 30, 2018, about 0133 Coordinated Universal Time, a Piper PA-28-161 airplane, C-GVZJ, was departing a cut hay field and collided with hay bales near Black Diamond, Alberta, Canada, under unknown circumstances. Of the two occupants onboard, 1 sustained… - [NTSB GAA18CA460](https://openairdocs.org/ntsb/GAA18CA460.md): Cessna 172 · Grand Prairie, TX · Accident · No injuries · Data collection · Final report · Jul 29, 2018 · N24144 · Substantial damage > The student pilot’s failure to maintain the runway centerline during takeoff with a crosswind. - [NTSB DCA18WA263](https://openairdocs.org/ntsb/DCA18WA263.md): Boeing 737 · Birmingham, United Kingdom · Incident · No injuries · Foreign investigation · Jul 28, 2018 · YR-BMF · Minor damage > The government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the… - [NTSB CEN18LA299](https://openairdocs.org/ntsb/CEN18LA299.md): Piper PA28 · Columbia, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2018 · N624FL · Substantial damage > The airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight. - [NTSB ERA18WA198](https://openairdocs.org/ntsb/ERA18WA198.md): Beech 58 · Ayolas, Paraguay · Accident · 4 fatal · Foreign investigation · Jul 25, 2018 · ZP-BEU · Destroyed > The government of Paraguay has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Paraguay's investigation under the provisions of… - [NTSB ANC18CA056](https://openairdocs.org/ntsb/ANC18CA056.md): Eurocopter AS 350 B3 · Kobuk, AK · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 25, 2018 · N354LA · Substantial damage > The pilot's inadvertent dynamic rollover during takeoff. - [NTSB CEN18CA293](https://openairdocs.org/ntsb/CEN18CA293.md): Just JA30 Superstol · Oshkosh, WI · Accident · Minor injuries · Data collection · Final report · Jul 24, 2018 · N45FT · Substantial damage > The pilot's failure to maintain adequate airspeed during the initial climb and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. - [NTSB CEN18WA324](https://openairdocs.org/ntsb/CEN18WA324.md): Cessna 750 · Cork, Ireland · Accident · No injuries · Foreign investigation · Jul 23, 2018 · N752TX · Substantial damage > On July 23, 2018, about 1741 hours universal coordinated time, a Cessna 750, United States registration N752TX, was substantially damaged during takeoff at the Cork International Airport (EICK), Cork, Ireland. The two pilots and six passengers were not… - [NTSB CEN18LA288](https://openairdocs.org/ntsb/CEN18LA288.md): Air Tractor AT 301 · Milford, IA · Accident · No injuries · Limited investigation · Final report · Jul 22, 2018 · N3169H · Substantial damage > The pilot's loss of airplane control during takeoff for reasons that could not be determined because no anomalies consistent with a flight control system malfunction were observed. - [NTSB WPR18FA201](https://openairdocs.org/ntsb/WPR18FA201.md): Douglas DC3 · Burnet, TX · Accident · Serious injuries · Class 2 · Field · Final report · Jul 21, 2018 · N47HL · Destroyed > The copilot's failure to maintain directional control during the initial takeoff roll and the pilot's failure to adequately monitor the copilot during the takeoff and his delayed remedial action, which resulted in the airplane briefly becoming airborne and… - [NTSB CEN18LA290](https://openairdocs.org/ntsb/CEN18LA290.md): Bell 206 · Todd Mission, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 2018 · N352CT · Substantial damage > The passenger’s inadvertent interference with the tail rotor pedals, which resulted in a loss of helicopter control during takeoff and the subsequent impact with terrain. - [NTSB CEN18LA285](https://openairdocs.org/ntsb/CEN18LA285.md): Smith AEROSTAR601 · Baton Rouge, LA · Accident · No injuries · Limited investigation · Final report · Jul 20, 2018 · N327BK · Substantial damage > The loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight. - [NTSB GAA18CA429](https://openairdocs.org/ntsb/GAA18CA429.md): Cessna 170 · Spearfish, SD · Accident · No injuries · Data collection · Final report · Jul 19, 2018 · N432W · Substantial damage > The pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining. - [NTSB GAA18CA424](https://openairdocs.org/ntsb/GAA18CA424.md): Bell 206 · New Castle, IN · Accident · No injuries · Data collection · Final report · Jul 16, 2018 · N39LR · Substantial damage > The pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate… - [NTSB GAA18CA422](https://openairdocs.org/ntsb/GAA18CA422.md): Piper PA18S · Palmer, AK · Accident · No injuries · Data collection · Final report · Jul 16, 2018 · N3982Z · Substantial damage > The pilot's failure to maintain pitch control during the landing roll. - [NTSB DCA18WA270](https://openairdocs.org/ntsb/DCA18WA270.md): Boeing 737 · Iguazu Province of Misiones, Argentina · Accident · No injuries · Foreign investigation · Jul 16, 2018 · LV-HQY · Substantial damage > The Junta de Investigacion de Accidentes de Aviacion Civil (JIAAC) of Argentina has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the… - [NTSB WPR18CA213](https://openairdocs.org/ntsb/WPR18CA213.md): Cessna E162 · Burlington, WA · Accident · No injuries · Data collection · Final report · Jul 14, 2018 · N5202B · Substantial damage > The student pilot’s failure to maintain pitch control during an aborted takeoff. - [NTSB ERA18WA196](https://openairdocs.org/ntsb/ERA18WA196.md): Piper PA28R · Santiago, Chile · Accident · 2 fatal · Foreign investigation · Jul 14, 2018 · CC-PVR · Substantial damage > The government of Chile has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on July 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of… - [NTSB ERA18LA191](https://openairdocs.org/ntsb/ERA18LA191.md): Cessna 182 · Geneseo, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 2018 · N291CP · Substantial damage > The pilot's failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane's critical angle of attack during takeoff and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s failure to follow… - [NTSB GAA18WA586](https://openairdocs.org/ntsb/GAA18WA586.md): Beagle B121 · Bembridge, Isle of Wight, United Kingdom · Accident · Serious injuries · Foreign investigation · Jul 12, 2018 · G-TSKY · Substantial damage > The government of United Kingdom has notified the NTSB of an accident involving a BEAGLE B121 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the… - [NTSB CEN18WA320](https://openairdocs.org/ntsb/CEN18WA320.md): Champion 8KCAB · Toronto, Canada · Accident · 1 fatal · Foreign investigation · Jul 12, 2018 · C-GDLP · Destroyed > On July 12, 2018, at 2359 universal coordinated time, a Bellanca 8KCAB, Canadian registration C-GDLP, declared an emergency and impacted terrain shortly after takeoff from the Toronto/Buttonville Airport (CYKZ), Ontario, Canada. The pilot was fatally injured.… - [NTSB CEN18LA274](https://openairdocs.org/ntsb/CEN18LA274.md): Cessna 150 · Lakeview, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 2018 · N50183 · Substantial damage > The student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and… - [NTSB CEN18FA265](https://openairdocs.org/ntsb/CEN18FA265.md): Rose Parrakeet A-1 · Rhome, TX · Accident · 1 fatal · Field investigation · Final report · Jul 12, 2018 · N14842 · Destroyed > The pilot's exceedance of the airplane's critical angle of attack after takeoff, which resulted in an aerodynamic stall. - [NTSB GAA18CA408](https://openairdocs.org/ntsb/GAA18CA408.md): Robinson R44 · Rulo, NE · Accident · No injuries · Data collection · Final report · Jul 10, 2018 · N144DJ · Substantial damage > The pilot's improper collective application, which resulted in low rotor rpm during the takeoff climb and a subsequent ground collision. Contributing to the accident was the pilot’s self-induced pressure to complete the operation. - [NTSB GAA18CA430](https://openairdocs.org/ntsb/GAA18CA430.md): Robinson R44 · Okawville, IL · Accident · No injuries · Data collection · Final report · Jul 9, 2018 · N944DC · Substantial damage > The pilot's improper preflight weight and balance calculation, which resulted in his operating the helicopter over its maximum gross takeoff weight and in its subsequent failure to climb. - [NTSB CEN18LA280](https://openairdocs.org/ntsb/CEN18LA280.md): Best Off Skyranger · Houghton Lake, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 8, 2018 · N4329R · Substantial damage > A partial loss of engine power during takeoff for undetermined reasons. - [NTSB WPR18LA190](https://openairdocs.org/ntsb/WPR18LA190.md): Autogyro Calidus · Tacoma, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2018 · N623AG · Substantial damage > The pilot's failure to properly configure the gyrocopter for takeoff, which resulted in it developing high speed and led to a subsequent loss of control. - [NTSB GAA18CA403](https://openairdocs.org/ntsb/GAA18CA403.md): Rockwell 114 · Corsicana, TX · Accident · No injuries · Data collection · Final report · Jul 7, 2018 · N314CT · Substantial damage > The pilot’s failure to maintain the runway heading during a soft-field takeoff with a tailwind, which resulted in a rejected takeoff. - [NTSB GAA18CA400](https://openairdocs.org/ntsb/GAA18CA400.md): Champion 8GCBC · Waunakee, WI · Accident · No injuries · Data collection · Final report · Jul 6, 2018 · N114JM · Substantial damage > The pilot’s failure to maintain clearance from tall corn along the edge of the airstrip during takeoff. - [NTSB GAA18CA401](https://openairdocs.org/ntsb/GAA18CA401.md): Grumman G164 · Rochelle, IL · Accident · No injuries · Data collection · Final report · Jul 5, 2018 · N6795Q · Substantial damage > The pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall. - [NTSB GAA18CA393](https://openairdocs.org/ntsb/GAA18CA393.md): Zenair Zenith Stol CH 701 · San Saba, TX · Accident · No injuries · Data collection · Final report · Jul 4, 2018 · N127VV · Substantial damage > The pilot’s improper landing flare during the aborted takeoff, which resulted in a hard landing and a nose-over. - [NTSB CEN18WA256](https://openairdocs.org/ntsb/CEN18WA256.md): Cessna 172 · Bad Voslau, Austria · Accident · 2 fatal · Foreign investigation · Jul 4, 2018 · F-HFPL · Destroyed > On June 4, 2018, about 0815 coordinated universal time, a Cessna 172S airplane, F-HFPL, impacted terrain at Bad Voslau Airport, Bad Voslau, Austria. The pilot in command and passenger were fatally injured, and the airplane was destroyed. The flight was… - [NTSB GAA18CA407](https://openairdocs.org/ntsb/GAA18CA407.md): Beech 58 · Mackinac Island, MI · Accident · No injuries · Data collection · Final report · Jul 1, 2018 · N66568 · Substantial damage > The pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane. - [NTSB ERA18LA182](https://openairdocs.org/ntsb/ERA18LA182.md): Piper PA 25 · Flat Rock, AL · Accident · No injuries · Class 3 · Limited · Final report · Jun 30, 2018 · N6307Z · Substantial damage > The failure of the right landing gear during takeoff due to a fatigue failure, which resulted in a runway excursion. - [NTSB GAA18CA402](https://openairdocs.org/ntsb/GAA18CA402.md): Piper PA28 · Rolla, MO · Accident · No injuries · Data collection · Final report · Jun 28, 2018 · N7104F · Substantial damage > A collision with a deer on the runway during the takeoff roll at night. - [NTSB CEN18LA249](https://openairdocs.org/ntsb/CEN18LA249.md): Air Tractor AT502 · Tappen, ND · Accident · No injuries · Limited investigation · Final report · Jun 28, 2018 · N502S · Substantial damage > The partial loss of engine power for reasons that could not be determined based on the available evidence. - [NTSB OPS18IA014](https://openairdocs.org/ntsb/OPS18IA014.md): Embraer EMB145 · Springfield, MO · Incident · Class 3 · Incident · Final report · Jun 27, 2018 · N655AE · No damage > The local controller failing to follow established facility directives and issuing a clearance for takeoff from a runway not under his control. - [NTSB WPR18LA179](https://openairdocs.org/ntsb/WPR18LA179.md): Cessna 340A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jun 25, 2018 · N60E · Substantial damage > The pilot's delayed decision to discontinue the takeoff when confronted with abnormal acceleration and airspeed indication; the reason for the abnormal acceleration could not be determined based on the available information. - [NTSB ERA18LA170](https://openairdocs.org/ntsb/ERA18LA170.md): Bell OH 58A · Raleigh, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 2018 · N303HP · Substantial damage > The pilot's inadequate preflight inspection, during which he failed to detach ground handling equipment from the helicopter before initiating the takeoff, which resulted in the subsequent dynamic rollover. - [NTSB GAA18CA358](https://openairdocs.org/ntsb/GAA18CA358.md): Diamond Aircraft Ind DA 20 · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Jun 16, 2018 · N992CT · Substantial damage > The pilot receiving instruction’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall. - [NTSB WPR18LA166](https://openairdocs.org/ntsb/WPR18LA166.md): Cessna 421C · Plant City, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 11, 2018 · N13RF · Substantial damage > The pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the… - [NTSB GAA18CA379](https://openairdocs.org/ntsb/GAA18CA379.md): Dan Jelinek Backcountry Supercub · Douglas, WY · Accident · No injuries · Data collection · Final report · Jun 11, 2018 · N7455 · Substantial damage > The pilot’s overcorrection with rudder during takeoff, which resulted in a loss of directional control. - [NTSB GAA18CA336](https://openairdocs.org/ntsb/GAA18CA336.md): Aviat A 1 · Renton, WA · Accident · No injuries · Data collection · Final report · Jun 10, 2018 · N352AM · Substantial damage > The pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface. - [NTSB DCA21WA027](https://openairdocs.org/ntsb/DCA21WA027.md): Boeing 737 · Amsterdam, Netherlands · Incident · Class 5 · Foreign · Jun 10, 2018 · PH-BXG · No damage - [NTSB GAA18CA329](https://openairdocs.org/ntsb/GAA18CA329.md): Dobbs George Coot · Malone, WI · Accident · No injuries · Data collection · Final report · Jun 7, 2018 · N100TN · Substantial damage > The pilot’s improper decision to take off with a known structural issue, which resulted in hull damage. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=34 ## 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=33 --- 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.