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

## Cases, newest first

- [NTSB GAA16CA244](https://openairdocs.org/ntsb/GAA16CA244.md): Schleicher ASW 19 · Frankton, IN · Accident · Minor injuries · Data collection · Final report · May 15, 2016 · N19VT · Substantial damage
  > The pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.
- [NTSB DCA16CA153](https://openairdocs.org/ntsb/DCA16CA153.md): Airbus Industrie A320 214 · Philadelphia, PA · Accident · Serious injuries · Data collection · Final report · May 14, 2016 · N103US · No damage
  > an inadvertent encounter with clear air turbulence that resulted in a serious injury to a flight attendant.
- [NTSB WPR16LA110](https://openairdocs.org/ntsb/WPR16LA110.md): Seguin Quickie · Mojave, CA · Accident · Minor injuries · Limited investigation · Final report · May 13, 2016 · N68TQ · Destroyed
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA16LA179](https://openairdocs.org/ntsb/ERA16LA179.md): Taylorcraft BC12 D · Critz, VA · Accident · Serious injuries · Limited investigation · Final report · May 7, 2016 · N43363 · Substantial damage
  > The pilot’s failure to maintain airspeed while on final approach, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.
- [NTSB ANC16LA022](https://openairdocs.org/ntsb/ANC16LA022.md): Airbus AS350 · Juneau, AK · Accident · Serious injuries · Limited investigation · Final report · May 5, 2016 · N194EH · Substantial damage
  > The pilot's failure to maintain terrain clearance while on approach to land in flat light conditions. Contributing to the severity of the pilot's injuries was the inadequately restrained internal cargo, which shifted forward during the impact and struck the…
- [NTSB GAA16CA212](https://openairdocs.org/ntsb/GAA16CA212.md): Cessna 140 · Poplar Grove, IL · Accident · No injuries · Data collection · Final report · Apr 30, 2016 · N4242H · Substantial damage
  > The pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.
- [NTSB CEN16LA170](https://openairdocs.org/ntsb/CEN16LA170.md): Buckeye Industries Dream Machine 582 · Fortville, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 29, 2016 · N9447T · Substantial damage
  > The collapse of the powered parachute's canopy for a reason that could not be determined, because postaccident examination revealed no anomalies with the parachute.
- [NTSB DCA16WA143](https://openairdocs.org/ntsb/DCA16WA143.md): Robinson R44 · Pretoria, South Africa · Accident · No injuries · Foreign investigation · Apr 27, 2016 · ZS-RXD · 2 aircraft · Substantial damage
  > The South African CAA has notified the NTSB of an accident involving a Robinson R44 helicopter and Aeroprakt A-22 Foxbat ultralight that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…
- [NTSB WPR16LA096](https://openairdocs.org/ntsb/WPR16LA096.md): DG Flugzeugbau DG 800B · Clements, CA · Accident · No injuries · Limited investigation · Final report · Apr 25, 2016 · N800YG · Substantial damage
  > The motorglider pilot's decision to perform an in-flight engine start with insufficient altitude, which resulted in an off-airport landing and collision with trees after the engine did not start. Contributing to the accident was the pilot's distraction by the…
- [NTSB ERA16FA168](https://openairdocs.org/ntsb/ERA16FA168.md): Ryskamp Bruce A Acroduster · Belton, SC · Accident · 1 fatal · Field investigation · Final report · Apr 24, 2016 · N380JA · Destroyed
  > A loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.
- [NTSB GAA16CA201](https://openairdocs.org/ntsb/GAA16CA201.md): Helicycle/Morrisey RR RM-1 · Denver, CO · Accident · Minor injuries · Data collection · Final report · Apr 22, 2016 · N867TV · Substantial damage
  > The pilot's failure to maintain control of the helicopter yaw while operating in conditions conducive to loss of tail rotor effectiveness, resulting in an uncommanded rapid right yaw and ground impact.
- [NTSB CEN16LA163](https://openairdocs.org/ntsb/CEN16LA163.md): Cessna 162 · Zionsville, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 2016 · N5217S · Substantial damage
  > The flight instructor’s improper decision to depart on a local instructional flight in rapidly deteriorating weather conditions, including thunderstorms and hail, which resulted in subsequent impact with terrain during a go-around.
- [NTSB CEN16FA158](https://openairdocs.org/ntsb/CEN16FA158.md): Beech 65 A90 1 · Slidell, LA · Accident · 2 fatal · Field investigation · Final report · Apr 20, 2016 · N7MC · Destroyed
  > The unstable approach in black-hole conditions, resulting in the airplane overshooting the runway extended centerline and descending well below a safe glidepath for the runway. Contributing to the accident was the lack of monitoring by the copilot allowing…
- [NTSB ERA16FA165](https://openairdocs.org/ntsb/ERA16FA165.md): Vans RV12 · Stevensville, MD · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2016 · N276VA · Substantial damage
  > The pilot's failure to maintain airplane control during approach for landing in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB WPR16LA093](https://openairdocs.org/ntsb/WPR16LA093.md): Cessna 172 · Avalon, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 2016 · N7133G · Destroyed
  > The pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…
- [NTSB DCA16WA131](https://openairdocs.org/ntsb/DCA16WA131.md): Britten Norman BN2 · Kiunga, Papua New Guinea · Accident · 12 fatal · Foreign investigation · Apr 13, 2016 · P2-SBC · Destroyed
  > The government of Papua New Guinea has notified the NTSB of an accident involving a BRITTEN NORMAN BN2 airplane that occurred on April 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Papua New Guinea's…
- [NTSB ERA16LA148](https://openairdocs.org/ntsb/ERA16LA148.md): Flight Design Ctsw · Hilton Head Island, SC · Accident · No injuries · Limited investigation · Final report · Apr 6, 2016 · N466CT · Substantial damage
  > The pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.
- [NTSB CEN16RA136](https://openairdocs.org/ntsb/CEN16RA136.md): Mitsubishi MU 2B · Iles-de-la-Madeleine, Canada · Accident · 7 fatal · Foreign investigation · Mar 29, 2016 · N246W · Substantial damage
  > import
- [NTSB CEN16LA137](https://openairdocs.org/ntsb/CEN16LA137.md): Matthews H Thomas Jodel F11 A · Marathon, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 2016 · N3068M · Substantial damage
  > The pilot's failure to conduct a go-around in a timely manner, which resulted in impact with trees and a powerline.
- [NTSB CEN16LA132](https://openairdocs.org/ntsb/CEN16LA132.md): Piper PA24 · Kentland, IN · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 2016 · N8154P · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…
- [NTSB ANC16WA016](https://openairdocs.org/ntsb/ANC16WA016.md): Mooney M20C · Yao, Japan · Accident · 4 fatal · Foreign investigation · Mar 26, 2016 · JA3788 · Destroyed
  > On March 26, 2016, about 1618 Local Time, a Mooney M20C airplane, Japan registration number JA3788, operated by the pilot, was destroyed by post crash fire following a loss of control while attempting a go-around at the Yao Airport, Osaka Prefecture. The…
- [NTSB DCA16WA235](https://openairdocs.org/ntsb/DCA16WA235.md): Cessna T210H · Hoedspruit, Limpopo Province, South Africa · Accident · No injuries · Foreign investigation · Mar 25, 2016 · ZS-DOM · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna T210H airplane that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…
- [NTSB DCA16WA110](https://openairdocs.org/ntsb/DCA16WA110.md): Embraer ERJ 190 100 IGW · Nassau, Bahamas · Incident · No injuries · Foreign investigation · Mar 25, 2016 · N273JB · Minor damage
  > The Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB CEN16LA143](https://openairdocs.org/ntsb/CEN16LA143.md): Cirrus Design SR22 · Alexandria, LA · Accident · No injuries · Limited investigation · Final report · Mar 23, 2016 · N927DS · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA16CA157](https://openairdocs.org/ntsb/GAA16CA157.md): Cessna 172 · Nashville, TN · Accident · No injuries · Data collection · Final report · Mar 20, 2016 · N118ET · Substantial damage
  > The pilot's excessive pitch up and incorrect action of selecting flaps to zero degrees, which resulted in a tail strike during a go-around in crosswind conditions.
- [NTSB ERA16WA206](https://openairdocs.org/ntsb/ERA16WA206.md): Cessna 150 · Daule, Ecuador · Accident · No injuries · Foreign investigation · Mar 20, 2016 · HC-CJS · Substantial damage
  > On March 20, 2016, at 1730 Universal Coordinated Time (UTC), a Cessna 150L, Ecuadorian registration HC-CJS, operated by Sky Ecuador, received substantial damage following a loss of engine power and forced landing in a rice field near Daule, Ecuador. The…
- [NTSB DCA16RA108](https://openairdocs.org/ntsb/DCA16RA108.md): Boeing 737 · Rostov-on-Don, Russia · Accident · 62 fatal · Foreign investigation · Mar 19, 2016 · A6-FDN · Destroyed
  > The Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a BOEING 737 that occurred on March 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO…
- [NTSB CEN16LA129](https://openairdocs.org/ntsb/CEN16LA129.md): Mooney M20C · Wichita, KS · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2016 · N9262M · Substantial damage
  > The total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.
- [NTSB ENG16RA011](https://openairdocs.org/ntsb/ENG16RA011.md): Airbus A320 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Mar 13, 2016 · XA-VLD · No damage
  > The Dirección General de Aviación Civil of Mexico has notified the NTSB of an accident involving a AIRBUS A320-233 that occurred on March 13, 2016. The NTSB has designated a U.S. Accredited Representative to assist the DGAC investigation under the provisions…
- [NTSB CEN16FA122](https://openairdocs.org/ntsb/CEN16FA122.md): Remos Acft Gmbh Flugzeugbau Remos GX · Española, NM · Accident · 2 fatal · Field investigation · Final report · Mar 11, 2016 · N28GX · Destroyed
  > The pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.
- [NTSB ERA16LA137](https://openairdocs.org/ntsb/ERA16LA137.md): Beech 99 · Rockland, ME · Accident · No injuries · Limited investigation · Final report · Mar 2, 2016 · N198WA · Substantial damage
  > The airplane’s encounter with isolated severe turbulence, which resulted in substantial airframe damage.
- [NTSB CEN16FA111](https://openairdocs.org/ntsb/CEN16FA111.md): Cirrus Design SR20 · Navasota, TX · Accident · 4 fatal · Field investigation · Final report · Feb 28, 2016 · N477TC · Substantial damage
  > The flight instructor's delayed remedial action to prevent a stall at an altitude that was too low to recover. Contributing to the accident was the owner/non-certificated pilot's failure to maintain control of the airplane, which resulted in an accelerated…
- [NTSB ERA16LA111](https://openairdocs.org/ntsb/ERA16LA111.md): Cessna 152 · Pembroke Pines, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 2016 · N6449P · Substantial damage
  > The loss of engine power while on approach for reasons that could not be determined based on the available evidence.
- [NTSB GAA16LA135](https://openairdocs.org/ntsb/GAA16LA135.md): Pinkston Randy T RV-7 · Tavernier, FL · Accident · No injuries · Limited investigation · Final report · Feb 18, 2016 · N705RP · Substantial damage
  > The pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.
- [NTSB ANC16WA070](https://openairdocs.org/ntsb/ANC16WA070.md): Piper PA-28-140 · St Andrews, Canada · Accident · No injuries · Foreign investigation · Feb 13, 2016 · C-GQPN · No damage
  > On February 13, 2016, about 2039 Coordinated Universal Time (UTC), a Piper PA-28-140 airplane, (Canadian Registration C-GQPN) was on approach to St. Andrews, MB (CYAV) with an instructor and a student on board. Prior to touch down at approximately 50 feet…
- [NTSB GAA16LA128](https://openairdocs.org/ntsb/GAA16LA128.md): Piper PA24 · Sturgis, SD · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 2016 · N6691P · Substantial damage
  > The pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.
- [NTSB CEN16LA105](https://openairdocs.org/ntsb/CEN16LA105.md): Enstrom TH-180 · Menominee, MI · Accident · No injuries · Limited investigation · Final report · Feb 12, 2016 · N180TH · Substantial damage
  > The failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.
- [NTSB GAA16CA126](https://openairdocs.org/ntsb/GAA16CA126.md): Piper PA31 · Newport, RI · Accident · No injuries · Data collection · Final report · Feb 5, 2016 · N102WM · Substantial damage
  > An inadvertent collision with birds during final approach at night.
- [NTSB ERA16FA100](https://openairdocs.org/ntsb/ERA16FA100.md): Cessna 182 · Mobile, AL · Accident · 2 fatal · Field investigation · Final report · Feb 2, 2016 · N784CP · Destroyed
  > The pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…
- [NTSB WPR16FA059](https://openairdocs.org/ntsb/WPR16FA059.md): Piper PA 24-260 · Santa Rosa, CA · Accident · 2 fatal · Field investigation · Final report · Jan 29, 2016 · N9362P · Substantial damage
  > The pilot’s failure to maintain airplane control during an instrument approach in night instrument meteorological conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent experience in night…
- [NTSB DCA16WA080](https://openairdocs.org/ntsb/DCA16WA080.md): Cessna 425 · Windhoek, Namibia · Accident · 3 fatal · Foreign investigation · Jan 29, 2016 · V5-MJW · Destroyed
  > The Namibia Directorate of Aircraft Accident and Incident Investigation (DAAII) has notified the NTSB of an accident involving a Cessna 425 airplane that occurred on January 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB CEN16FA095](https://openairdocs.org/ntsb/CEN16FA095.md): Cirrus Design SR22T · Xenia, OH · Accident · 1 fatal · Field investigation · Final report · Jan 26, 2016 · N1703 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while turning from the base leg to final, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall.
- [NTSB GAA16CA106](https://openairdocs.org/ntsb/GAA16CA106.md): Piper PA 28RT-201 · Terrell, TX · Accident · No injuries · Data collection · Final report · Jan 19, 2016 · N2119N · Substantial damage
  > The private pilot's exceedance of the airplane's critical angle-of-attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall and a collision with terrain short of the runway.
- [NTSB CEN16LA093](https://openairdocs.org/ntsb/CEN16LA093.md): Socata TBM700 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Jan 19, 2016 · N602MA · Substantial damage
  > The pilot’s failure to maintain the minimum-recommended approach airspeed in icing conditions, which resulted in a loss of airplane control.
- [NTSB ERA16LA090](https://openairdocs.org/ntsb/ERA16LA090.md): Beech A23 · Kingston, TN · Accident · No injuries · Limited investigation · Final report · Jan 16, 2016 · N3680Q · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning and his improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN16FA083](https://openairdocs.org/ntsb/CEN16FA083.md): Cessna 172N · Gilmer, TX · Accident · 1 fatal · Field investigation · Final report · Jan 13, 2016 · N737EZ · Substantial damage
  > The pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…
- [NTSB ERA16LA085](https://openairdocs.org/ntsb/ERA16LA085.md): Cirrus SR22 · Concord, NC · Accident · No injuries · Class 3 · Limited · Final report · Jan 8, 2016 · C-GXXJ · Substantial damage
  > The pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.
- [NTSB WPR16LA048](https://openairdocs.org/ntsb/WPR16LA048.md): Beech 35 C33 · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Jan 5, 2016 · N20XY · Substantial damage
  > A partial loss of engine power during final approach for reasons that could not be determined based on available information.
- [NTSB ERA16WA083](https://openairdocs.org/ntsb/ERA16WA083.md): Beech C90 · Parati, Brazil · Accident · 2 fatal · Foreign investigation · Jan 3, 2016 · PP-LMM · Destroyed
  > On January 3, 2016, about 1730 Coordinated Universal Time (UTC), a Beech C90GTi, PP-LMM, registered to Bradesco Leasing S.A., operated by Supermercado Shibata Ltda, experienced controlled flight into mountainous terrain near Parati Airport (SDTK), Parati,…
- [NTSB WPR16LA049](https://openairdocs.org/ntsb/WPR16LA049.md): Kai Engstad RV-8A · Salem, OR · Accident · No injuries · Limited investigation · Final report · Jan 2, 2016 · N958RV · Substantial damage
  > A total loss of engine power for undetermined reasons, because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation.

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

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

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