# NTSB investigations: Approach

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 40 of 420 · 20,992 cases

## Cases, newest first

- [NTSB GAA15CA128](https://openairdocs.org/ntsb/GAA15CA128.md): Beech C23 · Long Beach, CA · Accident · No injuries · Data collection · Final report · Jun 19, 2015 · N24022 · Substantial damage
  > The pilot failed to maintain clearance from trees while maneuvering to land at night, which resulted in a collision with terrain/objects. A factor contributing to the accident was the lack of oversight by ATC; failing to insure that the fully operational VASI…
- [NTSB ERA15CA243](https://openairdocs.org/ntsb/ERA15CA243.md): Diamond Aircraft Ind DA 20 C1 · Moreland, GA · Accident · No injuries · Data collection · Final report · Jun 17, 2015 · N353DC · Substantial damage
  > The flight instructor's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA15WA210](https://openairdocs.org/ntsb/DCA15WA210.md): Boeing 737 · Nauru, Nauru · Incident · No injuries · Foreign investigation · Jun 12, 2015 · VH-NLK · No damage
  > The Australian Transport Safety Board (ATSB) has notified the NTSB of an accident involving a BOEING 737 that occurred on June 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…
- [NTSB CEN15WA273](https://openairdocs.org/ntsb/CEN15WA273.md): Piper PA-23-250 · Kangirsuk, Canada · Accident · 3 fatal · Foreign investigation · Jun 12, 2015 · C-FXPS · Substantial damage
  > On June 11, 2015, about 2340 eastern daylight time, a Canadian registered PA-23-250, C-FXPS, impacted terrain about 1.2 nautical miles from the Kangirsuk Airport, Kangirsuk, Quebec, Canada. The pilot and two passengers were fatally injured. The investigation…
- [NTSB CEN15LA280](https://openairdocs.org/ntsb/CEN15LA280.md): Beech G58 · Taylorville, IL · Accident · No injuries · Limited investigation · Final report · Jun 12, 2015 · N669CS · Substantial damage
  > The flight instructor’s failure to verify that the left engine was operational, which resulted in insufficient engine power being available during an attempted go-around and his subsequent loss of airplane control. Contributing to the accident was the…
- [NTSB CEN15LA266](https://openairdocs.org/ntsb/CEN15LA266.md): Hunziker Eros 1650R · Quitman, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 2015 · N104JX · Substantial damage
  > The pilot's failure to maintain adequate airspeed for the approach to landing.
- [NTSB WPR15LA180](https://openairdocs.org/ntsb/WPR15LA180.md): Mooney M20C · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 8, 2015 · N7887V · Destroyed
  > The in-flight separation of the exhaust tube at a weld joint due to erosion and corrosion, which resulted in a subsequent in-flight fire.
- [NTSB ENG15IA024](https://openairdocs.org/ntsb/ENG15IA024.md): Bombardier DHC 8 · Windsor Locks, CT · Incident · No injuries · Incident investigation · Final report · Jun 5, 2015 · N363PH · Minor damage
  > The arcing failure of the windshield heat power wire on the right windshield due to unknown reasons. Contributing to the severity of the fire was the lack of training or guidance provided to the crew for selecting the windshield heat to off that would cut…
- [NTSB ERA15LA231](https://openairdocs.org/ntsb/ERA15LA231.md): Beech A36 · Siler City, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2015 · N985K · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.
- [NTSB ANC15LA033](https://openairdocs.org/ntsb/ANC15LA033.md): Cessna 185 · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 2015 · N1694M · 2 aircraft · Substantial damage
  > The other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.
- [NTSB ERA15LA228](https://openairdocs.org/ntsb/ERA15LA228.md): Luscombe 8A · Churchville, MD · Accident · Minor injuries · Limited investigation · Final report · May 29, 2015 · N2009B · Substantial damage
  > The pilot's improper reduction of the fuel mixture while the airplane was descending on the final leg of the traffic pattern, which resulted in a total loss of engine power and subsequent aerodynamic stall.
- [NTSB GAA15CA099](https://openairdocs.org/ntsb/GAA15CA099.md): Cessna 172 - R · State College, PA · Accident · No injuries · Data collection · Final report · May 28, 2015 · N2254U · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.
- [NTSB CEN15LA237](https://openairdocs.org/ntsb/CEN15LA237.md): Piper PA-22 · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · May 19, 2015 · N118U · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ANC15CA026](https://openairdocs.org/ntsb/ANC15CA026.md): Piper PA 22-150 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · May 16, 2015 · N7347D · Substantial damage
  > The private pilot's failure to maintain clearance from a spruce tree during final approach, which resulted in a loss of control and hard landing. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.
- [NTSB WPR15LA156](https://openairdocs.org/ntsb/WPR15LA156.md): Buhl LA 1 · Cottage Grove, OR · Accident · Minor injuries · Limited investigation · Final report · May 3, 2015 · N352Y · Substantial damage
  > A loss of engine power on downwind for landing due to carburetor icing, which resulted in a forced landing.
- [NTSB CEN15WA221](https://openairdocs.org/ntsb/CEN15WA221.md): Beech Beech 95-B55 · Dundee, United Kingdom · Accident · 2 fatal · Foreign investigation · May 3, 2015 · G-RICK
  > On May 3, 2015, at 1113 coordinated universal time, a Beech 95-B55 airplane, G-RICK, impacted terrain while on approach to the Dundee Airport (EGPN), Dundee, Scotland. The pilot and one passenger were fatally injured and the airplane was destroyed. Instrument…
- [NTSB CEN15LA252](https://openairdocs.org/ntsb/CEN15LA252.md): Michael Wilson Murphy Spirit · Livingston, TX · Accident · No injuries · Limited investigation · Final report · Apr 26, 2015 · N193MW · Substantial damage
  > The pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…
- [NTSB ERA15FA191](https://openairdocs.org/ntsb/ERA15FA191.md): Mooney M20TN · Lakeland, FL · Accident · Serious injuries · Field investigation · Final report · Apr 20, 2015 · N608MR · Substantial damage
  > The total loss of engine power for reasons that could not be determined due to thermal damage and because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB CEN15LA205](https://openairdocs.org/ntsb/CEN15LA205.md): Pitts Model 12 · Burneyville, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 2015 · N12DR · Substantial damage
  > The partial loss of engine power due to contamination of the fuel system.
- [NTSB OPS15IA017](https://openairdocs.org/ntsb/OPS15IA017.md): Boeing 767 34AF · Miami, FL · Incident · No injuries · Incident investigation · Final report · Apr 12, 2015 · N342UP · 2 aircraft · No damage
  > The controller's issuance of a landing clearance to an arriving aircraft while another aircraft was in position on the same runway. Contributing to the incident was the controller's non-compliance with traffic advisory procedures, and insufficient…
- [NTSB ERA15FA181](https://openairdocs.org/ntsb/ERA15FA181.md): Piper PA-31T1 · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Apr 12, 2015 · N119RL · Destroyed
  > A rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.
- [NTSB CEN15LA195](https://openairdocs.org/ntsb/CEN15LA195.md): Quad City Challenger - II · Chippewa Falls, WI · Accident · 1 fatal · Limited investigation · Final report · Apr 11, 2015 · N30796 · Substantial damage
  > The pilot’s incapacitation due to a cardiovascular event, which resulted in a loss of control and subsequent impact with terrain.
- [NTSB CEN15FA190](https://openairdocs.org/ntsb/CEN15FA190.md): Cessna 414A · Bloomington, IL · Accident · 7 fatal · Field investigation · Final report · Apr 7, 2015 · N789UP · Substantial damage
  > The pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…
- [NTSB ERA15CA176](https://openairdocs.org/ntsb/ERA15CA176.md): Beech V35B · Wetumpka, AL · Accident · Serious injuries · Data collection · Final report · Apr 4, 2015 · N9172Q · Substantial damage
  > The pilot's use of an incorrect radio frequency when attempting to turn on the runway lights, resulting is an attempt to land the airplane while aligned with airport hangar lights.
- [NTSB ERA15FA175](https://openairdocs.org/ntsb/ERA15FA175.md): Bedecorp BD-22 · Fort Pierce, FL · Accident · 1 fatal · Field investigation · Final report · Apr 1, 2015 · N224BD · Destroyed
  > The pilot's excessive pitch control inputs to the airplane’s sidestick control, which resulted in an overstress of the airframe and its subsequent in-flight breakup. Contributing to the accident was the pilot's decision to operate the airplane contrary to the…
- [NTSB ERA15LA174](https://openairdocs.org/ntsb/ERA15LA174.md): G-Dawg Just Acft Highlander · Walhalla, SC · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2015 · N376CG · Substantial damage
  > The pilot's failure to maintain airplane control during a go-around in gusting tailwind conditions, which resulted in a collision with trees.
- [NTSB ENG15WA026](https://openairdocs.org/ntsb/ENG15WA026.md): Airbus A320 - 211 · Halifax, Canada · Accident · Minor injuries · Foreign investigation · Mar 29, 2015 · C-FTJP · Substantial damage
  > On 29 March 2015, an Air Canada Airbus A320-200 aircraft (registration C-FTJP) clipped a power line and approach lights short of Runway 05 at the Halifax Stanfield International Airport. The Transportation Safety Board (TSB) of Canada is investigating the…
- [NTSB GAA15LA027](https://openairdocs.org/ntsb/GAA15LA027.md): Cub Crafters CC18 180 · Westfield Township, OH · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 2015 · N550BS · Substantial damage
  > The pilot’s failure to maintain clearance from trees during a base-to-final turn while landing toward the sun.
- [NTSB ENG15WA021](https://openairdocs.org/ntsb/ENG15WA021.md): Boeing 737 - 683 · Oslo, Norway · Incident · No injuries · Foreign investigation · Mar 25, 2015 · LN-RPA · No damage
  > On March 25, 2015, at approximately 0730 Coordinated Universal Time (UTC), a Boeing 737-683, Norwegian registration LN-RPA, operated by Scandinavian Airlines System (SAS), experienced a pitch control problem while landing on Runway 01R at Oslo Airport,…
- [NTSB DCA15WA103](https://openairdocs.org/ntsb/DCA15WA103.md): Boeing 737 · Tarapoto, Peru · Incident · No injuries · Foreign investigation · Mar 25, 2015 · OB-1851 · No damage
  > The CIAA of Peru has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB ERA15LA168](https://openairdocs.org/ntsb/ERA15LA168.md): Trick Trikes 582 Cyclone Storm · Live Oak, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 2015 · N993RA · Substantial damage
  > The student pilot applicant’s failure to clear the engine during a prolonged descent of a simulated engine failure and his subsequent rapid throttle input at the completion of the maneuver, which resulted in the engine’s failure to respond. Contributing to…
- [NTSB WPR15LA131](https://openairdocs.org/ntsb/WPR15LA131.md): Mccurry Charles P F 1 Rocket · Sedona, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 2015 · N747MC · Substantial damage
  > The partial loss of engine power during final approach for reasons that could not be determined during postaccident examination of the engine.
- [NTSB DCA15CA108](https://openairdocs.org/ntsb/DCA15CA108.md): Embraer EMB 145LR · Springfield, MO · Accident · No injuries · Data collection · Final report · Mar 20, 2015 · N625AE · Substantial damage
  > an in-flight collision with a bird.
- [NTSB GAA15CA017](https://openairdocs.org/ntsb/GAA15CA017.md): American Champion 7GCAA · Greensboro, NC · Accident · No injuries · Data collection · Final report · Mar 18, 2015 · N43MT · Substantial damage
  > The pilot's failure to maintain directional/pitch control during final approach, resulting in a collision with terrain.
- [NTSB ERA15LA155](https://openairdocs.org/ntsb/ERA15LA155.md): Richard Fuist Rotorway Talon · Indian Lake Estates, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 2015 · N220AF · Substantial damage
  > A loss of helicopter control following an uncommanded increased left cyclic pressure during landing for reasons that could not be determined because postaccident examination of the helicopter revealed no evidence of any mechanical malfunctions or anomalies.
- [NTSB DCA15IA089](https://openairdocs.org/ntsb/DCA15IA089.md): Bombardier CL 600 2C10 · Chicago, IL · Incident · No injuries · Class 3 · Incident · Final report · Mar 14, 2015 · N157GJ · Minor damage
  > The nose landing gear’s failure to fully extend due to missing and damaged fastening hardware on the drive arm assembly.
- [NTSB CEN15WA173](https://openairdocs.org/ntsb/CEN15WA173.md): Eipper Quicksilver - GT500 · Illes Balears, Spain · Accident · 1 fatal · Foreign investigation · Mar 14, 2015 · EC-DK6 · Substantial damage
  > This is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On March 14, 2015, about 1145 UTC, an Eipper Quicksilver GT-500 airplane, EC-DK6, (s/n 0085) impacted terrain after an…
- [NTSB GAA15CA005](https://openairdocs.org/ntsb/GAA15CA005.md): Cessna 208B · Muskegon, MI · Accident · No injuries · Data collection · Final report · Mar 10, 2015 · N12155 · Substantial damage
  > The pilot's improper decision to continue the landing when the airplane was not in a safe position to land, resulting in the collision with ground-based approach lighting.
- [NTSB ERA15LA149](https://openairdocs.org/ntsb/ERA15LA149.md): Piper PA-24-250 · Fort Myers, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 9, 2015 · N6514P · Substantial damage
  > The pilot's inadvertent placement of both fuel selectors to the "off" position, which resulted in fuel starvation and a total loss of engine power.
- [NTSB WPR15LA127](https://openairdocs.org/ntsb/WPR15LA127.md): Jimenez Vans RV 7A · Dayton, NV · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 2015 · N51MJ · Substantial damage
  > A loss of engine power during descent for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB CEN15LA177](https://openairdocs.org/ntsb/CEN15LA177.md): Ercoupe 415 C · St Jacob, IL · Accident · No injuries · Limited investigation · Final report · Mar 7, 2015 · N87EV · Substantial damage
  > The loss of engine power during the go-around due to fuel contamination.
- [NTSB CEN15LA169](https://openairdocs.org/ntsb/CEN15LA169.md): Hoke Bobby F Rans S 12 · Rusk, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 2015 · N154BH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's failure to maintain control while maneuvering for a forced landing, which resulted in the airplane…
- [NTSB CEN15FA164](https://openairdocs.org/ntsb/CEN15FA164.md): Airbus Helicopters (Eurocopte EC-130-B4 · St Louis, MO · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2015 · N356AM · Destroyed
  > The pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…
- [NTSB ERA15FA144](https://openairdocs.org/ntsb/ERA15FA144.md): Mooney M20F · Norfolk, VA · Accident · 3 fatal · Field investigation · Final report · Mar 4, 2015 · N66BB · Substantial damage
  > The pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…
- [NTSB CEN15CA160](https://openairdocs.org/ntsb/CEN15CA160.md): Zenith Acft Stol CH 701 · Marion, SD · Accident · Serious injuries · Data collection · Final report · Feb 27, 2015 · N511QC · Substantial damage
  > The pilot failed to maintain control of the airplane while maneuvering to land resulting in contact with a power line and the ground. Contributing to the accident was the pilot's lack of familiarity with the airplane.
- [NTSB CEN15LA137](https://openairdocs.org/ntsb/CEN15LA137.md): Beech A36 · Andrews, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2015 · N29AC · Substantial damage
  > The pilot's failure to note that icing conditions existed in the airport area despite having received that information in a preflight briefing, which resulted in his flight into an area of icing and the subsequent loss of airplane control due to ice…
- [NTSB CEN15FA136](https://openairdocs.org/ntsb/CEN15FA136.md): Cessna 441 · Argyle, TX · Accident · 1 fatal · Field investigation · Final report · Feb 5, 2015 · N441TG · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin at a low altitude.
- [NTSB CEN15FA135](https://openairdocs.org/ntsb/CEN15FA135.md): Piper PA46 500TP · Lubbock, TX · Accident · 1 fatal · Field investigation · Final report · Feb 5, 2015 · N301D · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation and light ice accumulation while operating in night, instrument meteorological conditions with gusting wind.
- [NTSB ANC15LA010](https://openairdocs.org/ntsb/ANC15LA010.md): Piper PA 12 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Feb 1, 2015 · N2370M · Substantial damage
  > The student pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s inadvertent switching of the fuel selector to the “off” position during the attempted engine restart.
- [NTSB ERA15CA122](https://openairdocs.org/ntsb/ERA15CA122.md): Evolution Revo · Bushnell, FL · Accident · Minor injuries · Data collection · Final report · Jan 31, 2015 · N40EV · Substantial damage
  > The pilot's failure to maintain airspeed during approach in variable wind, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=41

## 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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=40

---
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.