# 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 27 of 281 · 14,038 cases ## Cases, newest first - [NTSB WPR20LA148](https://openairdocs.org/ntsb/WPR20LA148.md): American AA-1A · Blythe, CA · Accident · Serious injuries · Class 3 · Limited · Final report · May 15, 2020 · N12YT · Substantial damage > The excessive wear of one magneto’s wiring harness, which resulted in a loss of engine power during takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following the loss of engine power, which resulted in exceedance of the… - [NTSB WPR20WA143](https://openairdocs.org/ntsb/WPR20WA143.md): Daher Kodiak · Papua, Indonesia · Accident · 1 fatal · Foreign investigation · May 12, 2020 · PK-MEC · Substantial damage > The government of Indonesia has notified the NTSB of an accident involving a Daher Kodiak airplane that occurred on May 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the… - [NTSB ERA20LA179](https://openairdocs.org/ntsb/ERA20LA179.md): Beech F33 · Land O Lakes, FL · Accident · 1 fatal · Class 3 · Limited · Final report · May 12, 2020 · N711JA · Destroyed > The partial loss of engine power due to a contaminated fuel system and the pilot’s improper decision to attempt a takeoff with a known deficiency in engine power. - [NTSB ERA20CA191](https://openairdocs.org/ntsb/ERA20CA191.md): Bell UH 1N · Baghdad, Iraq · Accident · Minor injuries · Class 4 · Data collection · Final report · May 10, 2020 · N12328 · Substantial damage > The flight crew's inadequate situational awareness and failure to maintain adequate clearance from a security barrier during a night takeoff. - [NTSB WPR20LA141](https://openairdocs.org/ntsb/WPR20LA141.md): Bellanca 8GCBC · Byron, CA · Accident · 1 fatal · Class 3 · Limited · Final report · May 9, 2020 · N4116Y · Destroyed > The tow airplane pilot’s loss of control resulting from the glider pilot’s failure to maintain a proper altitude behind the tow airplane, which caused the tail of the tow airplane to be lifted upward and the tow airplane to pitch nose down while at a low… - [NTSB WPR20CA139](https://openairdocs.org/ntsb/WPR20CA139.md): Cessna 180 · Hanksville, UT · Accident · No injuries · Class 4 · Data collection · Final report · May 6, 2020 · N89SJ · Substantial damage > The pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop. - [NTSB CEN20CA177](https://openairdocs.org/ntsb/CEN20CA177.md): M-Squared Sport 1000 · Little Falls, MN · Accident · Minor injuries · Class 4 · Data collection · Final report · May 5, 2020 · N7013W · Substantial damage > The uncertificated pilot's failure to maintain aircraft control during takeoff, which resulted in an impact with terrain. - [NTSB GAA20WA140](https://openairdocs.org/ntsb/GAA20WA140.md): Mudry CAP10 · BAN Lanveoc-Poulmic, France · Accident · No injuries · Foreign investigation · May 4, 2020 · F-YSDB · Substantial damage > The government of France has notified the NTSB of an accident involving a MUDRY CAP10 airplane that occurred on May 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of… - [NTSB WPR20LA136](https://openairdocs.org/ntsb/WPR20LA136.md): Cessna 172 · Fresno, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 2, 2020 · N734NW · Substantial damage > The partial loss of engine power for reasons that could not be determined based on available evidence. - [NTSB ERA20CA168](https://openairdocs.org/ntsb/ERA20CA168.md): Dayton-Wright DH-4 · Bowling Green, KY · Accident · No injuries · Class 4 · Data collection · Final report · May 2, 2020 · N32517 · Substantial damage > A primary control (aileron) system anomaly that progressively worsened during a test flight that resulted in a loss of control. The reason for the anomaly was not determined due to impact damage. - [NTSB ERA20LA162](https://openairdocs.org/ntsb/ERA20LA162.md): Iai 1125 · Fort Lauderdale, FL · Accident · No injuries · Class 3 · Limited · Final report · Apr 24, 2020 · YV3427 · Substantial damage > The pilot’s inadequate preflight planning, resulting in an attempted takeoff in excess of the airplane’s maximum allowable weight given it’s configuration and the temperature. - [NTSB CEN20CA155](https://openairdocs.org/ntsb/CEN20CA155.md): Vans RV 3 · Independence, IA · Accident · No injuries · Data collection · Final report · Apr 23, 2020 · N24DE · Substantial damage > The pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain. - [NTSB WPR20LA145](https://openairdocs.org/ntsb/WPR20LA145.md): Czech Sport Sport Cruiser · Logan, UT · Accident · No injuries · Class 3 · Limited · Final report · Apr 22, 2020 · N802PS · Substantial damage > A partial loss of engine power during takeoff due to vapor lock. - [NTSB CEN20CA153](https://openairdocs.org/ntsb/CEN20CA153.md): Air Tractor AT 602 · Mamou, LA · Accident · No injuries · Data collection · Final report · Apr 21, 2020 · N653LA · Substantial damage > The airplane's encounter with a sunken area during takeoff from a turf runway, which resulted in the airplane becoming prematurely airborne and impacting a tree and then terrain. - [NTSB ERA20WA154](https://openairdocs.org/ntsb/ERA20WA154.md): Garlick UH1H · del Curepto, Chile · Accident · 1 fatal · Foreign investigation · Apr 20, 2020 · CC-CBB · Substantial damage > The government of Chile has notified the NTSB of an accident involving a GARLICK UH1H helicopter that occurred on April 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of… - [NTSB CEN20LA150](https://openairdocs.org/ntsb/CEN20LA150.md): Piper PA 18 · Bowie, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 19, 2020 · N3670P · Substantial damage > The pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions, which resulted in an uncontrolled turn and descent into terrain. - [NTSB CEN20LA149](https://openairdocs.org/ntsb/CEN20LA149.md): Cessna 402 · Kirksville, MO · Accident · No injuries · Class 3 · Limited · Final report · Apr 14, 2020 · N98649 · Substantial damage > A loss of engine power after takeoff for undetermined reasons. - [NTSB WPR20LA119](https://openairdocs.org/ntsb/WPR20LA119.md): Robinson R44 · Hillsboro, OR · Accident · No injuries · Class 3 · Limited · Final report · Apr 6, 2020 · N725GT · Substantial damage > The total loss of engine power during takeoff due to the delamination of the fuel servo induction air inlet duct tube. - [NTSB CEN20WA183](https://openairdocs.org/ntsb/CEN20WA183.md): Socata TB9 · Nyköping, Sweden · Accident · No injuries · Foreign investigation · Apr 6, 2020 · SE-MKV · Substantial damage > The government of Sweden has notified the NTSB of an accident involving a SOCATA TB9 airplane that occurred on April 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of… - [NTSB ERA20CA144](https://openairdocs.org/ntsb/ERA20CA144.md): Lake LA4 · Hickory, NC · Accident · No injuries · Class 4 · Data collection · Final report · Apr 4, 2020 · N84PF · Substantial damage > The pilot's inadequate preflight planning and attempted takeoff with obstacles in the direction of departure, and his failure to maintain control of the airplane during the rejected takeoff. - [NTSB WPR20WA114](https://openairdocs.org/ntsb/WPR20WA114.md): Israel Aircraft Industries 1124A · Manilla, Philippines · Accident · 8 fatal · Foreign investigation · Mar 29, 2020 · RP-C5880 · Destroyed > The government of the Philippines has notified the NTSB of an accident involving an Israel Aircraft Industries 1124A airplane that occurred on March 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the… - [NTSB ANC20CA039](https://openairdocs.org/ntsb/ANC20CA039.md): Wag-Aero Sportsman 2+2 · Wasilla, AK · Accident · No injuries · Data collection · Final report · Mar 27, 2020 · N5045X · Substantial damage > The pilot's loss of directional control during takeoff from an icy ski strip in gusting wind conditions, which resulted in the left wing impacting a tree. - [NTSB CEN20LA132](https://openairdocs.org/ntsb/CEN20LA132.md): Cessna T210 · Waxahachie, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 25, 2020 · N5553C · Substantial damage > The partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which… - [NTSB WPR20LA111](https://openairdocs.org/ntsb/WPR20LA111.md): Piper PA 30 · Eagle Creek, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 19, 2020 · N7155Y · Destroyed > The pilot's loss of airplane control during takeoff due to his left shoe’s interference with the rudder pedal. - [NTSB ENG20WA021](https://openairdocs.org/ntsb/ENG20WA021.md): Airbus A321 · Tan Son Nhat Int’L Airport, Vietnam · Incident · No injuries · Foreign investigation · Mar 18, 2020 · VN-A392 · Minor damage > The government of Vietnam has notified the NTSB of an incident involving an Airbus A321 airplane that occurred on March 18, 2020. A Vietnam Airbus A321-231 powered by two International Aero Engines V2533-A5 turbofan engines experienced a No. 2 (right) engine… - [NTSB CEN20CA128](https://openairdocs.org/ntsb/CEN20CA128.md): Cessna 172 · Denver, CO · Accident · No injuries · Data collection · Final report · Mar 18, 2020 · N1132W · Substantial damage > The pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign. - [NTSB ERA20CA130](https://openairdocs.org/ntsb/ERA20CA130.md): Cessna 172 · West Palm Beach, FL · Accident · No injuries · Data collection · Final report · Mar 17, 2020 · N66046 · Substantial damage > The failure of the nosewheel steerage linkage during takeoff, which resulted in a loss of directional control and impact with an obstacle during an attempted aborted landing. - [NTSB ERA20LA126](https://openairdocs.org/ntsb/ERA20LA126.md): Piper PA28 · Beverly, MA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 12, 2020 · N656ST · Substantial damage > A loss of engine power due to carburetor icing, and the student pilot’s failure to utilize carburetor heat in conditions conducive to carburetor icing. - [NTSB ANC20CA032](https://openairdocs.org/ntsb/ANC20CA032.md): Cessna 172 · Big Lake, AK · Accident · No injuries · Data collection · Final report · Mar 10, 2020 · N52168 · Substantial damage > The pilot's improper decision to initiate the takeoff roll from a snow-covered taxiway, which resulted in a loss of directional control, runway excursion, and impact with a snow berm. - [NTSB WPR20CA100](https://openairdocs.org/ntsb/WPR20CA100.md): Piper PA28R · Twin Falls, ID · Accident · No injuries · Data collection · Final report · Mar 6, 2020 · N41429 · Substantial damage > The pilot's loss of directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and impact with a runway approach light. - [NTSB ERA20LA121](https://openairdocs.org/ntsb/ERA20LA121.md): Piper PA28 · Mount Pleasant, TN · Accident · No injuries · Class 3 · Limited · Final report · Feb 28, 2020 · N79HA · Substantial damage > A partial loss of engine power during initial climb due to carburetor icing that formed while idling on the ground for an extended amount of time. Contributing was the flight instructor's failure to perform the recommended ground checks before takeoff. - [NTSB DCA20WA099](https://openairdocs.org/ntsb/DCA20WA099.md): Boeing 737 · Crawley, United Kingdom · Incident · No injuries · Foreign investigation · Feb 28, 2020 · CN-RGJ > United Kingdom Air Accidents Investigation Branch (AAIB) notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's… - [NTSB DCA20WA085](https://openairdocs.org/ntsb/DCA20WA085.md): Boeing 737 · Papua, Indonesia · Accident · No injuries · Foreign investigation · Feb 25, 2020 · PK-YSG · Substantial damage > The government of Indonesia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the… - [NTSB CEN20CA090](https://openairdocs.org/ntsb/CEN20CA090.md): Robinson R22 · Cotulla, TX · Accident · No injuries · Data collection · Final report · Feb 18, 2020 · N10786 · Substantial damage > The pilot's failure to remove the right skid trailer tie-down before attempting to take off, which resulted in a dynamic roll-over. - [NTSB CEN20TA088](https://openairdocs.org/ntsb/CEN20TA088.md): Cessna 170 · Valley Center, KS · Accident · Minor injuries · Class 3 · Final report · Feb 16, 2020 · N170RH · Substantial damage > The pilot's delayed decision to abort the takeoff when the airplane passed the point where he had anticipated the liftoff would occur. - [NTSB DCA20WA078](https://openairdocs.org/ntsb/DCA20WA078.md): Boeing 737 · East Midlands, United Kingdom · Incident · No injuries · Foreign investigation · Feb 9, 2020 · G-DTRN · Minor damage > The government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under… - [NTSB DCA20WA076](https://openairdocs.org/ntsb/DCA20WA076.md): Boeing 787 · London, United Kingdom · Incident · No injuries · Foreign investigation · Feb 9, 2020 · VH-ZND · Minor damage > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 787-900, which occurred on February 9, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation… - [NTSB ANC20LA020](https://openairdocs.org/ntsb/ANC20LA020.md): Cessna 208 · Hooper Bay, AK · Accident · No injuries · Class 3 · Limited · Final report · Feb 5, 2020 · N454SF · Substantial damage > The pilot’s decision to depart from a contaminated runway, and his failure to make a timely decision to abort the takeoff when the airplane was not accelerating as expected. Contributing to the accident was the pilot’s decision to depart in limited visibility… - [NTSB WPR20CA088](https://openairdocs.org/ntsb/WPR20CA088.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Data collection · Final report · Feb 4, 2020 · N4400F · Substantial damage > The student pilot's failure to maintain directional control and the flight instructor's inadequate remediation during a short-field takeoff, which resulted in impact with a parked airplane. - [NTSB DCA20WA068](https://openairdocs.org/ntsb/DCA20WA068.md): Boeing 737 · Madrid, Spain · Incident · No injuries · Foreign investigation · Feb 3, 2020 · C-GHOZ · Minor damage > The Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737-300, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist… - [NTSB DCA20CA077](https://openairdocs.org/ntsb/DCA20CA077.md): Boeing 747 412 · Los Angeles, CA · Accident · No injuries · Class 4 · Data collection · Final report · Feb 3, 2020 · N703CK · Substantial damage > An unavoidable collision with a garbage dumpster that had blown into the path of the airplane during the takeoff roll. - [NTSB ERA20CA093](https://openairdocs.org/ntsb/ERA20CA093.md): Cessna 172 · Crystal River, FL · Accident · No injuries · Data collection · Final report · Jan 31, 2020 · N739XT · Substantial damage > The student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over. - [NTSB DCA20WA062](https://openairdocs.org/ntsb/DCA20WA062.md): Boeing 747 · Dammam, Saudi Arabia · Incident · No injuries · Foreign investigation · Jan 31, 2020 · TC-MCT · Minor damage > The government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on January 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the… - [NTSB ERA20LA089](https://openairdocs.org/ntsb/ERA20LA089.md): Beech A36 · Summerland Key, FL · Accident · No injuries · Class 3 · Limited · Final report · Jan 25, 2020 · N41VK · Substantial damage > The pilot's failure to remove the flight control gust lock before takeoff, which resulted in an inability to rotate, aborted takeoff, and subsequent runway overrun. Contributing to the accident was a missing piece of the flight control gust lock, which did… - [NTSB WPR20FA072](https://openairdocs.org/ntsb/WPR20FA072.md): Beech B36TC · Corona, CA · Accident · 4 fatal · Class 3 · Field · Final report · Jan 22, 2020 · N36TT · Destroyed > The pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting. - [NTSB DCA20WA060](https://openairdocs.org/ntsb/DCA20WA060.md): Boeing 777 · Sydney, Australia · Incident · No injuries · Foreign investigation · Jan 22, 2020 · N2333U · No damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of a serious incident involving a Boeing 777 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's… - [NTSB WPR20CA070](https://openairdocs.org/ntsb/WPR20CA070.md): Powrachute Airwolf · Gold Canyon, AZ · Accident · Serious injuries · Data collection · Final report · Jan 18, 2020 · N260AZ · Substantial damage > The pilot's failure to maintain directional control during an aborted takeoff, which resulted in collision with a barricade. - [NTSB ERA20CA091](https://openairdocs.org/ntsb/ERA20CA091.md): Cessna 185 · Laytonsville, MD · Accident · No injuries · Data collection · Final report · Jan 17, 2020 · N1557F · Substantial damage > The failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing. - [NTSB ANC20LA015](https://openairdocs.org/ntsb/ANC20LA015.md): Beech 200 · Unalaska, AK · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 16, 2020 · N547LM · Substantial damage > The pilot’s improper decision to takeoff downwind and to load the airplane beyond its allowable gross weight and center of gravity limits, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the inadequacy of the… - [NTSB ERA20LA076](https://openairdocs.org/ntsb/ERA20LA076.md): Magni M-24 Plus · Nashua, NH · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 15, 2020 · N327JD · Substantial damage > The pilot's incapacitation during the takeoff roll due to a stroke. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=28 ## 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=27 --- 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.