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

## Cases, newest first

- [NTSB ERA15LA354](https://openairdocs.org/ntsb/ERA15LA354.md): Cessna 177 · Moneta, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 2015 · N2835X · Substantial damage
  > The pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…
- [NTSB WPR15FA258](https://openairdocs.org/ntsb/WPR15FA258.md): Silvaire Luscombe 8A · Creswell, OR · Accident · 2 fatal · Field investigation · Final report · Sep 7, 2015 · N4948E · Destroyed
  > The pilot's decision to return to the runway shortly after takeoff, and his failure to maintain adequate airspeed during the turn, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin.
- [NTSB ERA15LA344](https://openairdocs.org/ntsb/ERA15LA344.md): Easterwood Mark W RV 6A · Rome, GA · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 2015 · N555TN · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA15FA340](https://openairdocs.org/ntsb/ERA15FA340.md): Beech A36 · Kernersville, NC · Accident · 3 fatal · Field investigation · Final report · Sep 7, 2015 · N36HT · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…
- [NTSB ERA15LA343](https://openairdocs.org/ntsb/ERA15LA343.md): Dehavilland DHC-6 · Louisburg, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2015 · N181CS · Substantial damage
  > The propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.
- [NTSB ERA15LA342](https://openairdocs.org/ntsb/ERA15LA342.md): Cessna 152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Sep 5, 2015 · N6141Q · Substantial damage
  > The pilot's improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA15LA341](https://openairdocs.org/ntsb/ERA15LA341.md): Piper PA 28RT-201 · Russell Springs, KY · Accident · Minor injuries · Class 2 · Limited · Final report · Sep 4, 2015 · N8162S · Substantial damage
  > Maintenance personnel’s inadequate fuel injection servo maintenance due to an out-of-date AD list, which resulted in the fuel injection servo plug backing out of the threaded plug hole on the regulator cover of the fuel injection servo and subsequent total…
- [NTSB ERA15FA330](https://openairdocs.org/ntsb/ERA15FA330.md): Cirrus Design SR22 · Alabaster, AL · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2015 · N1116C · Substantial damage
  > An in-flight loss of airplane control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR15FA250](https://openairdocs.org/ntsb/WPR15FA250.md): Piper PA 25 · Llano, CA · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2015 · N4369Y · Substantial damage
  > The pilot's loss of airplane control during the landing approach due to an incapacitating medical event.
- [NTSB ERA15FA326](https://openairdocs.org/ntsb/ERA15FA326.md): Piper PA44 · Houlton, ME · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2015 · N553MD · Destroyed
  > The pilot's descent below the published minimum descent altitude in night instrument meteorological conditions without visual contact with the runway environment, which resulted in a collision with trees and terrain short of the runway. Contributing to the…
- [NTSB ERA15FA325](https://openairdocs.org/ntsb/ERA15FA325.md): Cessna 310R · Titusville, FL · Accident · 1 fatal · Field investigation · Final report · Aug 26, 2015 · N90PS · Destroyed
  > The pilot's continued flight into known convective weather conditions, which resulted in the airplane's encounter with thunderstorms and the pilot's subsequent loss of airplane control during a missed approach. Contributing to the accident was the failure of…
- [NTSB WPR15LA249](https://openairdocs.org/ntsb/WPR15LA249.md): Schweizer 269C - Undesignat · Mesa, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 2015 · N315TV · Substantial damage
  > The disbondment of a main rotor damper, which resulted in the degradation of its damping action and led to excessive main rotor vibrations and oscillations that caused substantial damage to the helicopter in flight and led to a hard landing.
- [NTSB CEN15FA374](https://openairdocs.org/ntsb/CEN15FA374.md): Beech 35 B33 · El Dorado, AR · Accident · 1 fatal · Field investigation · Final report · Aug 23, 2015 · N9704Y · Destroyed
  > The loss of engine power for reasons that could not be determined during postaccident examination of the accident site or based on the available information and the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical…
- [NTSB DCA15WA187](https://openairdocs.org/ntsb/DCA15WA187.md): Cessna 441 · Cape Town, South Africa · Accident · 7 fatal · Foreign investigation · Aug 17, 2015 · V5-NRS · Destroyed
  > The government of South Africa has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on August 17, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…
- [NTSB CEN15WA394](https://openairdocs.org/ntsb/CEN15WA394.md): Piper PA-34-220T · Newquay, United Kingdom, United Kingdom · Accident · 1 fatal · Foreign investigation · Aug 17, 2015 · OK-OKD · Substantial damage
  > On August 17, 2015, about 1833 universal time (UTC), a Czech Republic registered Piper PA-34-220T, OK-OKD, sustained substantial damage during a go-around at the Newquay Cornwall Airport, Newquay, United Kingdom. The pilot was fatally injured. The…
- [NTSB WPR15MA243](https://openairdocs.org/ntsb/WPR15MA243.md): Cessna 172M · San Diego, CA · Accident · 5 fatal · Major investigation · Final report · Aug 16, 2015 · N1285U · 2 aircraft · Destroyed
  > The local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…
- [NTSB ERA15LA315](https://openairdocs.org/ntsb/ERA15LA315.md): Piper PA 28-161 · Bristow, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 2015 · N82587 · Substantial damage
  > The student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.
- [NTSB DCA15LA173](https://openairdocs.org/ntsb/DCA15LA173.md): Airbus A321 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Aug 15, 2015 · N564UW · Substantial damage
  > an encounter with a small microburst on short final at low altitude that resulted in a loss of lift and a tail strike during the go-around. Contributing to the accident was the captain's decision to continue the approach without applying appropriate windshear…
- [NTSB ERA15CA317](https://openairdocs.org/ntsb/ERA15CA317.md): Ercoupe 415 C · Fairmont, WV · Accident · Minor injuries · Data collection · Final report · Aug 14, 2015 · N93606 · Substantial damage
  > The pilot's failure to maintain airspeed and his exceedance of the wing's critical angle of attack, which resulted in an aerodynamic stall and subsequent collision with terrain.
- [NTSB CEN15CA356](https://openairdocs.org/ntsb/CEN15CA356.md): Taylorcraft BC12-D · Pearland, TX · Accident · Minor injuries · Data collection · Final report · Aug 12, 2015 · N95592 · Substantial damage
  > The student pilot inadvertently shut off the fuel valve while on the downwind leg, which resulted in a total loss of engine power due to fuel starvation and a forced landing short of the runway.
- [NTSB CEN15LA361](https://openairdocs.org/ntsb/CEN15LA361.md): Cessna 150 · Brookfield, MO · Accident · No injuries · Limited investigation · Final report · Aug 11, 2015 · N8896U · Substantial damage
  > The pilot's failure to visually check the quantity of fuel in the fuel tanks in accordance with the Preflight checklist, which resulted in a loss of engine power due to fuel exhaustion and the subsequent forced landing.
- [NTSB CEN15FA342](https://openairdocs.org/ntsb/CEN15FA342.md): Piper PA 32R-300 · Harbor Springs, MI · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2015 · N43829 · Substantial damage
  > The pilot's failure to maintain clearance from the trees during the approach in dark, night conditions, which resulted in controlled flight into trees and terrain.
- [NTSB ERA15LA301](https://openairdocs.org/ntsb/ERA15LA301.md): Cessna 172 · Kissimmee, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2015 · N8370X · Substantial damage
  > The student pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to fuel contamination.
- [NTSB CEN15LA354](https://openairdocs.org/ntsb/CEN15LA354.md): Cessna C421B · Clovis, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2015 · N726JB · Substantial damage
  > The pilot's improper management of fuel to the left engine during approach for landing, which resulted in a total loss of left engine power due to fuel starvation, and his subsequent failure to maintain control during the final landing approach, which…
- [NTSB ERA15FA298](https://openairdocs.org/ntsb/ERA15FA298.md): Mchugh Tony Kitfox Model 1 · Montrose, PA · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2015 · N428YT · Substantial damage
  > The pilot's failure to maintain control of the airplane during final approach, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.
- [NTSB ERA15LA296](https://openairdocs.org/ntsb/ERA15LA296.md): Bell 47G 3B 1 · Camden, AL · Accident · No injuries · Limited investigation · Final report · Aug 3, 2015 · N4002G · Substantial damage
  > A failure of the helicopter's hydraulic flight control systems for reasons that could not be determined due to the fire damage, and the pilot's inability to turn off the hydraulic system to relieve control pressure.
- [NTSB CEN15LA333](https://openairdocs.org/ntsb/CEN15LA333.md): Cessna 182 · Watertown, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2015 · N1685R · Substantial damage
  > The total loss of engine power due to carburetor icing.
- [NTSB DCA15WA163](https://openairdocs.org/ntsb/DCA15WA163.md): Boeing 737 - 4Q8 · St Georges sur Meuse, Belgium · Incident · No injuries · Foreign investigation · Jul 31, 2015 · TC-TLE · Minor damage
  > The Air Accidents Investigation Unit (AAIU) of Belgium has notified the NTSB of an incident involving a Boeing 737-4Q8, which occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…
- [NTSB CEN15LA326](https://openairdocs.org/ntsb/CEN15LA326.md): Eagle Eagle DW 1 · Hector, MN · Accident · No injuries · Limited investigation · Final report · Jul 29, 2015 · N8806B · Substantial damage
  > The intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…
- [NTSB WPR15LA223](https://openairdocs.org/ntsb/WPR15LA223.md): Stinson 108 - 3 · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jul 25, 2015 · N6152M · Substantial damage
  > The partial loss of engine power due to a degraded cylinder exhaust valve seal, which resulted in low cylinder compression.
- [NTSB CEN15FA325](https://openairdocs.org/ntsb/CEN15FA325.md): Piper PA-28-151 · Truth or Consequences, NM · Accident · 2 fatal · Field investigation · Final report · Jul 24, 2015 · N32401 · Substantial damage
  > The student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.
- [NTSB ERA15FA277](https://openairdocs.org/ntsb/ERA15FA277.md): Cirrus Design SR20 · Lake Wales, FL · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2015 · N610DA · Destroyed
  > A partial loss of engine power due to oil starvation. Contributing was the flight instructor's failure to maintain control of the airplane during an aborted emergency landing, and his delayed decision to deploy the airplane's parachute system.
- [NTSB CEN15FA311](https://openairdocs.org/ntsb/CEN15FA311.md): Piper PA-46-310P · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Jul 22, 2015 · N4BP · Substantial damage
  > The pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…
- [NTSB ERA15WA290](https://openairdocs.org/ntsb/ERA15WA290.md): Cessna 210D · Rio Verde, Brazil · Accident · 1 fatal · Foreign investigation · Jul 19, 2015 · PR-ITO · Destroyed
- [NTSB ERA15LA276](https://openairdocs.org/ntsb/ERA15LA276.md): Grumman American Avn. AA1B · Lititz, PA · Accident · No injuries · Limited investigation · Final report · Jul 19, 2015 · N8969L · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA15CA272](https://openairdocs.org/ntsb/ERA15CA272.md): Smith Steen Skybolt · Junction City, KY · Accident · Minor injuries · Data collection · Final report · Jul 18, 2015 · N31CS · Substantial damage
  > The pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15WA440](https://openairdocs.org/ntsb/CEN15WA440.md): Maule MX7 · Munster, Switzerland · Accident · Serious injuries · Foreign investigation · Jul 18, 2015 · HB-KDF · Substantial damage
  > On July 18, 2015 about 0857 UTC, a Maule MX7-235 airplane, Swiss registration HB-KDF, impacted terrain during a go around near the Munster Airport (LSPU), near Munster, Switzerland. The pilot and two passengers sustained minor injuries and one passenger…
- [NTSB GAA15CA227](https://openairdocs.org/ntsb/GAA15CA227.md): Robinson Helicopter R44 · Sandusky, MI · Accident · No injuries · Data collection · Final report · Jul 15, 2015 · N8337Z · Substantial damage
  > The pilot's failure to monitor the landing environment while operating in a confined off-airport site resulting in a wire strike and substantial damage to the helicopter.
- [NTSB GAA15CA188](https://openairdocs.org/ntsb/GAA15CA188.md): Champion 7GCAA · Kingsland, TX · Accident · No injuries · Data collection · Final report · Jul 15, 2015 · N8305V · Substantial damage
  > The pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.
- [NTSB CEN15LA357](https://openairdocs.org/ntsb/CEN15LA357.md): Piper PA 30 · Clifton, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 2015 · N7768Y · Destroyed
  > The pilot's failure to maintain control during a precautionary landing following a total loss of power to one engine. The reason for the loss of engine power could not be determined based on available information.
- [NTSB ERA15CA264](https://openairdocs.org/ntsb/ERA15CA264.md): Haphey Bruce Frederic Mustang II · Palatka, FL · Accident · Minor injuries · Data collection · Final report · Jul 11, 2015 · N59PB · Substantial damage
  > The pilot's failure to maintain airplane control during a balked landing and attempted go-around in dark night conditions and without a landing light, which resulted in collision with terrain.
- [NTSB GAA15CA172](https://openairdocs.org/ntsb/GAA15CA172.md): Schweizer SGS 1 26B · Silver Springs, NV · Accident · No injuries · Data collection · Final report · Jul 8, 2015 · N5839V · Substantial damage
  > The pilot's improper decision making in adverse weather conditions, which resulted in an encounter with weather and impact with terrain.
- [NTSB GAA15CA178](https://openairdocs.org/ntsb/GAA15CA178.md): Piper PA 24-250 · Newton, KS · Accident · No injuries · Data collection · Final report · Jul 4, 2015 · N7985P · Substantial damage
  > The failure of the right main landing gear down-lock micro switch, which resulted in a landing gear collapse during landing, and the pilot/owner's unfamiliarity with the emergency landing gear extension procedure. Contributing to the accident was the flight…
- [NTSB WPR15FA205](https://openairdocs.org/ntsb/WPR15FA205.md): Schweizer 269C · Newberg, OR · Accident · 2 fatal · Field investigation · Final report · Jul 2, 2015 · N2096W · Destroyed
  > The loss of translation/rotational power between the engine and the transmission due to the severe wear of the forward spline portion of the lower coupling drive shaft. The reason for the severe wear of the forward spline could not be definitively determined…
- [NTSB ERA15LA257](https://openairdocs.org/ntsb/ERA15LA257.md): Piper PA28 · Galax Hillsville, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 2015 · N43503 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while turning onto the final approach leg of the traffic pattern, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB WPR15LA201](https://openairdocs.org/ntsb/WPR15LA201.md): Cessna 182D · Oak Harbor, WA · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2015 · N9980T · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA15CA256](https://openairdocs.org/ntsb/ERA15CA256.md): Cessna 170 · Raymond, MS · Accident · No injuries · Data collection · Final report · Jun 30, 2015 · N4027V · Substantial damage
  > The flight instructor's inadequate preflight inspection of the fuel system resulting in a total loss of engine power due to fuel contamination.
- [NTSB GAA15CA138](https://openairdocs.org/ntsb/GAA15CA138.md): Quicksilver MXL II Sport · Ute, IA · Accident · Serious injuries · Data collection · Final report · Jun 25, 2015 · UNREG · Substantial damage
  > The pilot's failure to maintain sufficient airspeed to prevent an inadvertent aerodynamic stall, and impact with terrain.
- [NTSB GAA15CA133](https://openairdocs.org/ntsb/GAA15CA133.md): Schempp-Hirth Ventus 2C · Hobbs, NM · Accident · No injuries · Data collection · Final report · Jun 23, 2015 · N172VC · Substantial damage
  > The pilot's improper compensation for gusty wind conditions which resulted in impact with terrain short of the runway.
- [NTSB WPR15LA191](https://openairdocs.org/ntsb/WPR15LA191.md): Cessna 180A · Polson, MT · Accident · No injuries · Limited investigation · Final report · Jun 19, 2015 · N9699B · Substantial damage
  > A total loss of engine power during approach for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.

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

## 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=39

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