# NTSB investigations: Maneuvering 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 46 of 377 · 18,849 cases ## Cases, newest first - [NTSB CEN14WA254](https://openairdocs.org/ntsb/CEN14WA254.md): Air Tractor AT802 · Seron, Spain · Accident · 1 fatal · Foreign investigation · May 26, 2014 · EC-LCA · Destroyed > On May 26, 2014, about 1400 UTC, an Air Tractor AT-802 airplane, EC-LCA, (s/n 802-0326), impacted terrain during a firefighting operation near Seron, Spain. A post-impact fire occurred and the airplane was subsequently destroyed. The pilot sustained fatal… - [NTSB ERA14CA262](https://openairdocs.org/ntsb/ERA14CA262.md): Evolution Trikes Revo · Williamsburg, VA · Accident · Minor injuries · Data collection · Final report · May 25, 2014 · N9912S · Substantial damage > The pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with water. - [NTSB WPR14FA203](https://openairdocs.org/ntsb/WPR14FA203.md): Robinson Helicopter R22 Beta · Santa Paula, CA · Accident · 1 fatal · Field investigation · Final report · May 23, 2014 · N4081H · Substantial damage > The pilot's failure to maintain clearance from power lines while flying at a low altitude. - [NTSB WPR14CA196](https://openairdocs.org/ntsb/WPR14CA196.md): Bell 47G · Bakersfield, CA · Accident · No injuries · Data collection · Final report · May 18, 2014 · N16414 · Substantial damage > The pilot's failure to maintain aircraft control after the helicopter's skid catching on the side of a trailer during takeoff, which resulted in a dynamic rollover. - [NTSB ERA14CA239](https://openairdocs.org/ntsb/ERA14CA239.md): Taylorcraft BC 65 · Summerville, GA · Accident · Serious injuries · Data collection · Final report · May 13, 2014 · N29611 · Substantial damage > The pilot's selection of an inadequate altitude during low level maneuvering, which resulted in an in-flight collision with trees. - [NTSB ERA14CA234](https://openairdocs.org/ntsb/ERA14CA234.md): Sam R Peachey Just Aircraft Highla · Roxbury, PA · Accident · Minor injuries · Data collection · Final report · May 11, 2014 · N209SP · Substantial damage > The pilot's failure to maintain adequate airspeed during low altitude maneuvering. - [NTSB ERA14WA247](https://openairdocs.org/ntsb/ERA14WA247.md): Cessna 140A · Cachoeira do Sul, Brazil · Accident · 2 fatal · Foreign investigation · May 10, 2014 · PT-AGS · Substantial damage > On May 10, 2014, at 2025 coordinated universal time, a Cessna 140A, Brazilian registration PT-AGS, experienced a loss of control and subsequently impacted terrain near Cachoeira do Su, Brazil. The two pilots onboard were fatally injured. The instructional… - [NTSB CEN14LA243](https://openairdocs.org/ntsb/CEN14LA243.md): Hoffius Stowe Challenger II · Attica, IN · Accident · 1 fatal · Limited investigation · Final report · May 10, 2014 · N824SH · Substantial damage > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an… - [NTSB CEN14LA235](https://openairdocs.org/ntsb/CEN14LA235.md): Pazmany PL 4 · Yates City, IL · Accident · Minor injuries · Limited investigation · Final report · May 10, 2014 · N44PL · Substantial damage > A loss of propeller thrust due to a failure of the reduction drive unit resulting from the improper installation of the unit. Contributing to the accident was a lack of documentation for the reduction drive unit installation. - [NTSB WPR14FA183](https://openairdocs.org/ntsb/WPR14FA183.md): Cessna 150 - F · Santa Clara, UT · Accident · 2 fatal · Field investigation · Final report · May 7, 2014 · N8236F · Substantial damage > The flight instructor’s failure to arrest the airplane’s descent and maintain clearance from mountainous terrain while maneuvering at a low altitude. - [NTSB CEN14LA229](https://openairdocs.org/ntsb/CEN14LA229.md): Air Tractor AT 301 · Hessmer, LA · Accident · No injuries · Limited investigation · Final report · May 5, 2014 · N7309Z · Substantial damage > A partial loss of engine power for reasons that could not be determined because a full examination of the engine could not be performed. - [NTSB CEN14FA230](https://openairdocs.org/ntsb/CEN14FA230.md): Piper PA 25-235 · Northglenn, CO · Accident · No injuries · Field investigation · Final report · May 5, 2014 · N4519Y · Destroyed > The pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s… - [NTSB WPR14FA182](https://openairdocs.org/ntsb/WPR14FA182.md): Boeing E75 · Fairfield, CA · Accident · 1 fatal · Field investigation · Final report · May 4, 2014 · N68828 · Destroyed > The pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,… - [NTSB ERA14CA220](https://openairdocs.org/ntsb/ERA14CA220.md): Schleicher ASW 20 · Monroe, GA · Accident · Serious injuries · Data collection · Final report · May 4, 2014 · N777LR · Substantial damage > The pilot's improper selection of an off-airport landing site and his subsequent failure to maintain clearance from trees during an off airport landing. - [NTSB ERA14WA221](https://openairdocs.org/ntsb/ERA14WA221.md): Piper PA-31 · Santander, Colombia · Accident · 2 fatal · Foreign investigation · May 3, 2014 · C-GSVM · Substantial damage > On May 3, 2014, about 1500 coordinated universal time, a Piper PA-31, Canadian registration C-GSVM, was substantially damaged when it impacted terrain near Santander, Colombia. The pilot and passenger were fatally injured. The local survey flight departed… - [NTSB CEN14FA232](https://openairdocs.org/ntsb/CEN14FA232.md): Bell 407 · Telluride, CO · Accident · No injuries · Field investigation · Final report · May 3, 2014 · N407MH · Substantial damage > The failure of the power turbine thrust (No. 5) bearing due to overheating as a result of oil starvation, which led to the engine failure. Also causal to the accident was an undocumented repair to the gearbox cover oil delivery tube port during which an… - [NTSB ERA14CA217](https://openairdocs.org/ntsb/ERA14CA217.md): Robinson Helicopter R22 Beta · Frederick, MD · Accident · Minor injuries · Data collection · Final report · May 1, 2014 · N802CP · Substantial damage > The student pilot's failure to maintain directional control during the hover, and the flight instructors lack of remedial action, resulting in a dynamic rollover and structural damage to the helicopter. - [NTSB CEN14WA535](https://openairdocs.org/ntsb/CEN14WA535.md): Alpi Pioneer · Evora, Portugal · Accident · 2 fatal · Foreign investigation · Apr 30, 2014 · CS-UOV · Destroyed > On April 30, 2014, at 1851 coordinated universal time, an Alpi Aviation Pioneer 300J airplane, Portuguese registered CS-UOV, impacted terrain after a low pass near the Evora Airport (LPEV), Evora, Portugal. The two pilots were fatally injured and the airplane… - [NTSB ANC14CA025](https://openairdocs.org/ntsb/ANC14CA025.md): Cessna 182J · Cooper Landing, AK · Accident · No injuries · Data collection · Final report · Apr 30, 2014 · N3024F · Substantial damage > The pilot's failure to correctly use carburetor heat, resulting in a loss of engine power and collision with terrain. - [NTSB WPR14GA176](https://openairdocs.org/ntsb/WPR14GA176.md): Hughes OH 6 · Bullfrog, UT · Accident · Serious injuries · Final report · Apr 29, 2014 · N37929 · Substantial damage > A loss of engine power while the helicopter was hovering for reasons that could not be determined because postaccident examination of the engine and rotor drive system revealed no evidence of a mechanical malfunction or failure that would have precluded… - [NTSB WPR14FA174](https://openairdocs.org/ntsb/WPR14FA174.md): Cessna 210E · Richmond, CA · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2014 · N4962U · 2 aircraft · Destroyed > Both pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot. - [NTSB ERA14CA229](https://openairdocs.org/ntsb/ERA14CA229.md): Gingras Michel Aventura II · Punta Gorda, FL · Accident · No injuries · Data collection · Final report · Apr 27, 2014 · N543MG · Substantial damage > The pilot's failure to maintain clearance from the water while operating at a low altitude. - [NTSB CEN14LA222](https://openairdocs.org/ntsb/CEN14LA222.md): Hughes 269A · Cleburne, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 2014 · N90636 · Substantial damage > The student pilot's failure to maintain tail rotor clearance from terrain while transitioning to a hover taxi and the instructor pilot's inadequate remedial action to prevent the impending tail rotor contact. - [NTSB CEN14WA214](https://openairdocs.org/ntsb/CEN14WA214.md): Cessna 172 - M · Gracias, Honduras · Accident · 4 fatal · Foreign investigation · Apr 23, 2014 · HR-AVN · Destroyed > On April 23, 2014, at 1900 universal coordinated time, a Cessna 172M airplane, bearing Honduran registration HR-AVH, was destroyed upon impact with trees and terrain under unknown circumstances, near Gracias, Department of Lempira, in the Republic of… - [NTSB CEN14LA211](https://openairdocs.org/ntsb/CEN14LA211.md): Air Tractor AT 502B · Garfield, KS · Accident · 1 fatal · Limited investigation · Final report · Apr 22, 2014 · N51990 · Substantial damage > The pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground. - [NTSB CEN14WA206](https://openairdocs.org/ntsb/CEN14WA206.md): Sui RY, Laurinen Janne, KääRiä Comp AIR 8 · Jamijarvi, Finland · Accident · 7 fatal · Foreign investigation · Apr 20, 2014 · OH-XDZ · Destroyed > On April 20, 2014, at 1240 UTC, a Comp Air 8, Finnish registration OH-XDZ, was destroyed when it departed controlled flight and subsequently impacted in a forest near Jamijarvi Airfield (EFJM), Jamijarvi, Finland. A post-impact fire ensued. Eight of the 10… - [NTSB WPR14LA161](https://openairdocs.org/ntsb/WPR14LA161.md): Northwing Apache Sport · Brigham City, UT · Accident · 1 fatal · Limited investigation · Final report · Apr 8, 2014 · N58AS · Substantial damage > The pilot’s failure to maintain aircraft control while maneuvering near power lines. - [NTSB ANC14FA022](https://openairdocs.org/ntsb/ANC14FA022.md): Cessna 208B · Kwethluk, AK · Accident · 2 fatal · Field investigation · Final report · Apr 8, 2014 · N126AR · Destroyed > The check airman's delayed remedial action and initiation of a recovery procedure after a simulated pitch trim excursion, which resulted in a loss of airplane control. - [NTSB WPR14FA158](https://openairdocs.org/ntsb/WPR14FA158.md): Robinson Helicopter R22 Beta · Green River, UT · Accident · 2 fatal · Field investigation · Final report · Apr 6, 2014 · N13HG · Substantial damage > A loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination. - [NTSB ERA14FA182](https://openairdocs.org/ntsb/ERA14FA182.md): Monroe Dennis RV-7 · Summerfield, FL · Accident · 2 fatal · Field investigation · Final report · Apr 6, 2014 · N57DC · Substantial damage > The pilot's failure to maintain airplane control while maneuvering at a low airspeed, which resulted in an aerodynamic stall, and his decision to maneuver at an altitude that did not allow an adequate margin to recover from a stall. - [NTSB WPR14LA160](https://openairdocs.org/ntsb/WPR14LA160.md): Agustawestland AW109SP · Astoria, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 2014 · N361CR · No damage > The decision by the ship pilot and the helicopter crew to lower the ship pilot to a location on the ship that did not provide the helicopter pilot with an adequate view of the ship. Contributing to the accident was the inadequate pre-mission coordination… - [NTSB CEN14WA184](https://openairdocs.org/ntsb/CEN14WA184.md): Cessna T210L · San Marcos, Guatemala · Accident · 2 fatal · Foreign investigation · Apr 1, 2014 · N732JY · Destroyed > On April 1, 2014, about 1340 local time, a Cessna T210L, single engine airplane, N732JY, was destroyed after impacting mountainous terrain near San Marcos, Guatemala. The pilot and passenger were fatally injured. About 1318 the airplane departed from… - [NTSB CEN14LA174](https://openairdocs.org/ntsb/CEN14LA174.md): Bell 47G 3B · Oglesby, TX · Accident · No injuries · Limited investigation · Final report · Mar 30, 2014 · N147WT · Substantial damage > Maintenance personnel’s failure to safety wire the throttle control adapter per maintenance instructions when the carburetor was replaced and to detect that the adapter was not safety wired during the annual inspection, which resulted in the throttle control… - [NTSB WPR14WA311](https://openairdocs.org/ntsb/WPR14WA311.md): Robinson Helicopter R22 Beta · Borroloola, Australia, Australia · Accident · Serious injuries · Foreign investigation · Mar 27, 2014 · VH-HRX · Substantial damage > On March 27, 2014, at 0900 universal coordinated time, a Robinson R22 Beta, VH-HRX, collided with terrain near Borroloola, Australia during an aerial mustering flight. The helicopter was operated by the pilot under the pertinent civil regulations of the… - [NTSB WPR14LA147](https://openairdocs.org/ntsb/WPR14LA147.md): Cessna 172P · Inarajan · Accident · No injuries · Limited investigation · Final report · Mar 26, 2014 · N9551L · Substantial damage > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. - [NTSB WPR14WA148](https://openairdocs.org/ntsb/WPR14WA148.md): MD Helicopter 500N · Gisborne, New Zealand, New Zealand · Accident · 1 fatal · Foreign investigation · Mar 19, 2014 · ZK-HQP · Substantial damage > On March 19, 2014, at 2030 universal coordinated time, a MD Helicopters 500N, ZK-HQP, was preparing for a fire lighting operation when it crashed in Hawkes Bay near Gisborne, New Zealand. The helicopter was operated by Gisborne Helicopters Limited under the… - [NTSB CEN14FA163](https://openairdocs.org/ntsb/CEN14FA163.md): Smith Aerostar 601P · Aurora, CO · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2014 · N90464 · Destroyed > The pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control. - [NTSB CEN14CA164](https://openairdocs.org/ntsb/CEN14CA164.md): Piper PA 28R-201 · Ruidoso, NM · Accident · No injuries · Data collection · Final report · Mar 19, 2014 · N3398M · Substantial damage > The pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance. - [NTSB CEN14LA161](https://openairdocs.org/ntsb/CEN14LA161.md): Cessna 150M · Greenwood, IN · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2014 · N9432U · Substantial damage > The flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.… - [NTSB WPR14CA138](https://openairdocs.org/ntsb/WPR14CA138.md): DG Flugzeugbau DG 1000S · Wrightwood, CA · Accident · Minor injuries · Data collection · Final report · Mar 15, 2014 · N624RM · Substantial damage > The pilot's inadequate in-flight planning/decision to maneuver the glider where the lift was not sufficient to maintain flight, resulting in an off airport landing. - [NTSB CEN14CA160](https://openairdocs.org/ntsb/CEN14CA160.md): Piper PA 28-235 · De Beque, CO · Accident · Minor injuries · Data collection · Final report · Mar 14, 2014 · N9172W · Substantial damage > The pilot's failure to maintain control of the airplane while maneuvering at low altitude. - [NTSB ERA14WA245](https://openairdocs.org/ntsb/ERA14WA245.md): Cessna T188C · Canton Naranjal, Ecuador · Accident · Minor injuries · Foreign investigation · Mar 13, 2014 · HC-BTA · Substantial damage > On March 13, 2014, a Cessna T188C, Ecuadorian registration HC-BTA, was substantially damaged when it lost engine power and impacted terrain near Canton Naranjal, Ecuador. A postaccident fire ensued. The foreign certificated pilot received minor injuries. The… - [NTSB WPR14FA135](https://openairdocs.org/ntsb/WPR14FA135.md): Evolution Trikes Revo · Kekaha, HI · Accident · 2 fatal · Field investigation · Final report · Mar 11, 2014 · N98EV · Substantial damage > The pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control. - [NTSB ERA14FA144](https://openairdocs.org/ntsb/ERA14FA144.md): Rogers George T Lancair IVP · Hartsville, SC · Accident · 3 fatal · Field investigation · Final report · Mar 8, 2014 · N724HP · Substantial damage > Failure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the… - [NTSB ERA14WA148](https://openairdocs.org/ntsb/ERA14WA148.md): Zivko Aeronautics Edge 540T · Al Khor, Qatar · Accident · 1 fatal · Foreign investigation · Mar 7, 2014 · N149WA · Substantial damage > On March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The… - [NTSB CEN14LA149](https://openairdocs.org/ntsb/CEN14LA149.md): Robinson Helicopter R44 II · Presidio, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 2014 · N360AH · Substantial damage > The pilot’s failure to maintain sufficient rotor rpm when transitioning the helicopter from a hover to forward flight, which resulted in a loss of helicopter control. - [NTSB ERA14LA137](https://openairdocs.org/ntsb/ERA14LA137.md): Piper J3C-65 · Macon, GA · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 2014 · N9026N · Substantial damage > The pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow… - [NTSB CEN14LA147](https://openairdocs.org/ntsb/CEN14LA147.md): Air Tractor AT 602 · Church Point, LA · Accident · No injuries · Limited investigation · Final report · Feb 19, 2014 · N5035R · Substantial damage > The pilot’s improper preflight inspection and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB WPR14CA115](https://openairdocs.org/ntsb/WPR14CA115.md): Bell 47G 5A · Greenfield, CA · Accident · No injuries · Data collection · Final report · Feb 18, 2014 · N715BH · Substantial damage > The pilot's failure to maintain clearance from a power pole during low-altitude maneuvering flight. - [NTSB ERA14WA132](https://openairdocs.org/ntsb/ERA14WA132.md): Robinson R22 - Beta · Rio de Janeiro, Brazil · Accident · 2 fatal · Foreign investigation · Feb 18, 2014 · PT-YFV · Destroyed > On February 18, 2014, about 1315 universal coordinated time, a Robinson R22 - BETA, Brazilian registration PT-YFV, was destroyed when it impacted water, near Rio de Janeiro, Brazil. The flight instructor and student pilot were fatally injured. The local… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=47 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=46 --- 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.