# 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 29 of 281 · 14,038 cases ## Cases, newest first - [NTSB GAA19CA560](https://openairdocs.org/ntsb/GAA19CA560.md): Thomas Lee Nieuport 11 · Rose Hill, KS · Accident · No injuries · Data collection · Final report · Sep 23, 2019 · N1398 · Substantial damage > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and an impact with runway lights. - [NTSB GAA19CA563](https://openairdocs.org/ntsb/GAA19CA563.md): De Havilland Beaver DHC 2 · Mountain Village, AK · Accident · No injuries · Data collection · Final report · Sep 22, 2019 · N77KZ · Substantial damage > The pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff… - [NTSB CEN19FA325](https://openairdocs.org/ntsb/CEN19FA325.md): Cessna A185 · Conroe, TX · Accident · 2 fatal · Class 3 · Field · Final report · Sep 21, 2019 · C-GOZJ · Destroyed > A partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall. - [NTSB GAA19CA562](https://openairdocs.org/ntsb/GAA19CA562.md): De Havilland Beaver DHC 2 MK.1 · Kotzebue, AK · Accident · No injuries · Data collection · Final report · Sep 20, 2019 · N67112 · Substantial damage > The pilot's delayed decision to abort the takeoff from water after the airplane impacted a submerged object, which resulted in insufficient airspeed for liftoff and led to the pilot steering the airplane toward a mud embankment to avoid rocks. - [NTSB GAA19CA550](https://openairdocs.org/ntsb/GAA19CA550.md): Pzl Okecie PZL104 · Reno, NV · Accident · No injuries · Data collection · Final report · Sep 16, 2019 · N123T · Substantial damage > The pilot's failure to maintain bank control during takeoff in gusting crosswind conditions, resulting in a loss of control in flight and subsequent impact with terrain. - [NTSB GAA19CA551](https://openairdocs.org/ntsb/GAA19CA551.md): Piper PA 12 · Healy, AK · Accident · No injuries · Data collection · Final report · Sep 15, 2019 · N4315M · Substantial damage > The pilot's exceedance of the airplane's critical angle of attack while taking off from water in shifting wind conditions. - [NTSB ERA19WA271](https://openairdocs.org/ntsb/ERA19WA271.md): Piper PA31 · Popayan, Colombia · Accident · 7 fatal · Foreign investigation · Sep 15, 2019 · HK-5229 · Destroyed > The government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the… - [NTSB ERA19LA272](https://openairdocs.org/ntsb/ERA19LA272.md): Diamond DA40 · Norfolk, VA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 15, 2019 · N292RA · Substantial damage > A partial loss of engine power due to the mechanic's failure to properly tighten the two clamps securing the flexible coupling from the intercooler to the induction inlet. - [NTSB GAA19CA546](https://openairdocs.org/ntsb/GAA19CA546.md): Mooney M20M · Chandler, AZ · Accident · No injuries · Data collection · Final report · Sep 14, 2019 · N1085W · Substantial damage > The pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action. - [NTSB GAA19CA542](https://openairdocs.org/ntsb/GAA19CA542.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Sep 12, 2019 · N796WW · Substantial damage > The student pilot's failure to maintain directional control during an aborted takeoff, which resulted in a runway excursion and impact with runway signs while attempting to maneuver back onto the runway. - [NTSB ERA19LA269](https://openairdocs.org/ntsb/ERA19LA269.md): Mooney M20J · Bowie, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 12, 2019 · N202JB · Substantial damage > A blockage of the pitot static system that preclude the airspeed indicator from displaying speeds greater than 40 mph, which led the pilot to abort the landing and overrun the runway. - [NTSB DCA19WA220](https://openairdocs.org/ntsb/DCA19WA220.md): Boeing 737 · Malaga, Spain · Incident · No injuries · Foreign investigation · Sep 11, 2019 · EI-ENH · 2 aircraft · No damage > The government of Spain has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of… - [NTSB WPR19LA253](https://openairdocs.org/ntsb/WPR19LA253.md): Ercoupe 415 · Maricopa, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 10, 2019 · N3816H · Substantial damage > The flight instructor’s failure to prevent the student pilot from exceeding the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Contributing to the accident was the student pilot’s failure to make a positive… - [NTSB GAA19CA529](https://openairdocs.org/ntsb/GAA19CA529.md): Cessna 172 · Mekoryuk, AK · Accident · No injuries · Data collection · Final report · Sep 8, 2019 · N737NJ · Substantial damage > The pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting wind conditions. - [NTSB DCA19WA218](https://openairdocs.org/ntsb/DCA19WA218.md): Boeing 767 · Jeddah, Saudi Arabia · Incident · No injuries · Foreign investigation · Sep 8, 2019 · ET-ALO · Minor damage > The AIB of Saudi Arabia has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on September 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AIB's investigation under the provisions of ICAO Annex 13… - [NTSB GAA19CA528](https://openairdocs.org/ntsb/GAA19CA528.md): Siai-Marchetti SM 1019 · Lakeport, CA · Accident · Minor injuries · Data collection · Final report · Sep 7, 2019 · N16XC · Substantial damage > The pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting, variable wind conditions, which resulted in a loss of airplane control and subsequent impact with water. - [NTSB WPR19FA251](https://openairdocs.org/ntsb/WPR19FA251.md): Piper PA18 · Hood River, OR · Accident · 2 fatal · Class 3 · Field · Final report · Sep 6, 2019 · N14365 · Substantial damage > The total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time… - [NTSB CEN19LA304](https://openairdocs.org/ntsb/CEN19LA304.md): Piper PA-28D-180 · Midlothian, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 6, 2019 · N6595J · Substantial damage > Misalignment of the fuel selector valve when the right fuel tank was selected, which restricted fuel flow and resulted in a total loss of engine power due to fuel starvation. - [NTSB GAA19CA521](https://openairdocs.org/ntsb/GAA19CA521.md): Piper PA18 · Beluga, AK · Accident · No injuries · Data collection · Final report · Sep 2, 2019 · N655HE · Substantial damage > The pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent. - [NTSB CEN19CA336](https://openairdocs.org/ntsb/CEN19CA336.md): Piper PA38 · Taylor, TX · Accident · No injuries · Data collection · Final report · Sep 2, 2019 · N6400A · Substantial damage > The flight instructor's inadequate supervision of the student's soft-field takeoff, which resulted in an excessive pitch attitude, settling effect, and impact with a ditch off the end of the runway. - [NTSB WPR19LA249](https://openairdocs.org/ntsb/WPR19LA249.md): Hughes 369 · Asotin, WA · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2019 · N54528 · Substantial damage > A loss of control for undetermined reasons. - [NTSB GAA19CA522](https://openairdocs.org/ntsb/GAA19CA522.md): Stinson 108 · Bandera, WA · Accident · No injuries · Data collection · Final report · Sep 1, 2019 · N97699 · Substantial damage > The pilot's selection of unsuitable terrain for a simulated rejected takeoff, which resulted in a runway overrun and noseover. - [NTSB WPR19LA247](https://openairdocs.org/ntsb/WPR19LA247.md): Cessna 510 · El Monte, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 31, 2019 · N551WH · Substantial damage > The pilot's failure to disengage the parking brake before takeoff, which resulted in decreased acceleration and a subsequent runway overrun following an aborted takeoff. - [NTSB WPR19FA244](https://openairdocs.org/ntsb/WPR19FA244.md): Cessna 172 · McKenzie Bridge, OR · Accident · 2 fatal · Class 3 · Field · Final report · Aug 28, 2019 · N4108F · Destroyed > The pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was… - [NTSB GAA19CA511](https://openairdocs.org/ntsb/GAA19CA511.md): Piper PA28 · Cottonwood, AZ · Accident · No injuries · Data collection · Final report · Aug 25, 2019 · N8619W · Substantial damage > The student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor. - [NTSB CEN19LA300](https://openairdocs.org/ntsb/CEN19LA300.md): Cessna 425 · Bethany, OK · Accident · No injuries · Class 3 · Limited · Final report · Aug 25, 2019 · N300GD · Substantial damage > A loss of control during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion. - [NTSB GAA19CA513](https://openairdocs.org/ntsb/GAA19CA513.md): Cessna A185 · Rangeley Lake, ME · Accident · Minor injuries · Data collection · Final report · Aug 22, 2019 · N1920Q · Substantial damage > The pilot's inadequate preflight inspection of the floats, which led to his subsequent attempt to depart from a lake with damaged floats and led to a loss of roll control and the right wing impacting the water. - [NTSB WPR19LA233](https://openairdocs.org/ntsb/WPR19LA233.md): Cessna 120 · Livermore, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 21, 2019 · N4237N · Substantial damage > A partial loss of engine power due to fouled spark plugs in the No. 4 cylinder. Contributing to the accident was the pilot’s exceedance of the airplane’s critical angle of attack and a subsequent loss of control during the initial climb. - [NTSB WPR19FA230](https://openairdocs.org/ntsb/WPR19FA230.md): Cessna 560XL · Oroville, CA · Accident · No injuries · Class 3 · Field · Final report · Aug 21, 2019 · N91GY · Destroyed > The pilot’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane nose down pitching moment. Also causal was the flight crew’s delayed decision to abort the takeoff, which… - [NTSB WPR19LA237](https://openairdocs.org/ntsb/WPR19LA237.md): Cessna T210 · Eugene, OR · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2019 · N501SF · Substantial damage > The failure of the landing gear electric motor to shut off after landing gear retraction, which resulted in the motor overheating, burning out, and producing smoke in the cockpit. The pilot’s decision to land with the landing gear retracted resulted in… - [NTSB GAA19CA517](https://openairdocs.org/ntsb/GAA19CA517.md): Cessna 180 · Arlington, WA · Accident · Minor injuries · Data collection · Final report · Aug 20, 2019 · N180TB · Substantial damage > The pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm. - [NTSB CEN19FA279](https://openairdocs.org/ntsb/CEN19FA279.md): Aero Commander 200 · Howell, MI · Accident · 2 fatal · Class 3 · Field · Final report · Aug 20, 2019 · N200HS · Substantial damage > The improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed… - [NTSB GAA19CA496](https://openairdocs.org/ntsb/GAA19CA496.md): Cessna TU206 · Regina, NM · Accident · No injuries · Data collection · Final report · Aug 19, 2019 · N6588X · Substantial damage > The pilot's improper preflight performance planning for a high-density altitude takeoff from a short, dirt airstrip, which resulted in impact with terrain. - [NTSB ENG19WA044](https://openairdocs.org/ntsb/ENG19WA044.md): Airbus A320 · Guwahati, India · Incident · No injuries · Foreign investigation · Aug 19, 2019 · VT-IVO · No damage > The government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 19, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)… - [NTSB WPR19LA223](https://openairdocs.org/ntsb/WPR19LA223.md): Beech 35 · Ruidoso, NM · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 17, 2019 · N5410D · Substantial damage > The airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance as a result of high-density altitude conditions at the time of takeoff. Contributing to the accident were the pilot’s inadequate… - [NTSB ERA19FA249](https://openairdocs.org/ntsb/ERA19FA249.md): Cessna T303 · Lagrangeville, NY · Accident · 2 fatal · Class 3 · Field · Final report · Aug 17, 2019 · N303TL · Destroyed > A partial loss of engine power in both engines during initial climb for reasons that could not be determined based on the available information. - [NTSB WPR19LA221](https://openairdocs.org/ntsb/WPR19LA221.md): AutoGyro Cavalon · Shelton, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 15, 2019 · N477AG · Substantial damage > The pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground. - [NTSB DCA19WA202](https://openairdocs.org/ntsb/DCA19WA202.md): Boeing 767 · Shannon, Ireland · Incident · Minor injuries · Foreign investigation · Aug 15, 2019 · N378AX · Minor damage > The AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO… - [NTSB ANC19TA044](https://openairdocs.org/ntsb/ANC19TA044.md): Cessna 180 · Anchorage, AK · Accident · Minor injuries · Class 3 · Final report · Aug 12, 2019 · N91402 · Substantial damage > The pilot’s failure to maintain takeoff heading due to sun glare, which resulted in his inability to see an island adjacent to the water lane and subequent impact with the island. - [NTSB CEN19LA263](https://openairdocs.org/ntsb/CEN19LA263.md): Cessna 172 · New Carlisle, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 11, 2019 · N8928B · Substantial damage > The pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff. - [NTSB GAA19CA491](https://openairdocs.org/ntsb/GAA19CA491.md): Consolidated Vultee BT13 · Franklin, PA · Accident · No injuries · Data collection · Final report · Aug 10, 2019 · N62644 · Substantial damage > The pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and the left main landing gear collapsing. - [NTSB DCA19WA197](https://openairdocs.org/ntsb/DCA19WA197.md): Boeing 787 · Rome, Italy · Incident · No injuries · Foreign investigation · Aug 10, 2019 · LN-LND · Minor damage > The government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of… - [NTSB CEN19WA274](https://openairdocs.org/ntsb/CEN19WA274.md): Bell 206 · Vuoggatjålme, Sweden · Accident · No injuries · Foreign investigation · Aug 10, 2019 · SE-JOA · Substantial damage > On August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,… - [NTSB ENG19RA038](https://openairdocs.org/ntsb/ENG19RA038.md): Raytheon 390 · Hamburg, Germany · Incident · No injuries · Foreign investigation · Aug 7, 2019 · OK-EJH · Minor damage > On August 7, 2019, about 1408 coordinated universal time (UTC), a Raytheon 390 Premier 1A airplane, Czech Republic registration OK-EJH, experienced smoke/fire in the cockpit from the windshield heat system during takeoff from Hamburg Airport, Hamburg,… - [NTSB CEN19LA252](https://openairdocs.org/ntsb/CEN19LA252.md): Piper PA28 · Miami, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 5, 2019 · N5915U · Substantial damage > The flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing. - [NTSB WPR19WA206](https://openairdocs.org/ntsb/WPR19WA206.md): Bell 47G · Limpopo Province, South Africa · Accident · 1 fatal · Foreign investigation · Jul 30, 2019 · ZS-HGY · Substantial damage > On July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously… - [NTSB WPR19LA204](https://openairdocs.org/ntsb/WPR19LA204.md): Cessna 162 · Vernal, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 29, 2019 · N30321 · Substantial damage > The flight instructor's abrupt maneuver at an altitude too low for recovery, which resulted in impact with the runway. - [NTSB GAA19CA472](https://openairdocs.org/ntsb/GAA19CA472.md): Cessna 172 · Mt. Sterling, KY · Accident · No injuries · Data collection · Final report · Jul 28, 2019 · N9548W · Substantial damage > The pilot's loss of directional control during the takeoff roll due to distraction by the passenger window being unsecured, which resulted in a runway excursion and impact with a runway distance marker. Contributing to the accident was pilot’s failure to… - [NTSB GAA19CA456](https://openairdocs.org/ntsb/GAA19CA456.md): Piper PA46 · Sparta, TN · Accident · No injuries · Data collection · Final report · Jul 27, 2019 · N12KW · Substantial damage > The pilot's failure to maintain the runway heading during an aborted takeoff, which resulted in a runway excursion and collision with a sign and terrain. Contributing to the need to abort the takeoff was the pilot's improper decision to take off with the… - [NTSB GAA19CA469](https://openairdocs.org/ntsb/GAA19CA469.md): Schempp Hirth Ventus 2A · Wurtsboro, NY · Accident · No injuries · Data collection · Final report · Jul 26, 2019 · N57LK · Substantial damage > The pilot's failure to properly secure the glider’s canopy before flight, which resulted in it opening in flight and the pilot's inability to maintain an appropriate final approach path and altitude, which resulted in impact with a shipping container. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=30 ## 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=29 --- 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.