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

## Cases, newest first

- [NTSB WPR16FA170](https://openairdocs.org/ntsb/WPR16FA170.md): Cessna 182 · Clinton, MT · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2016 · N9936T · Destroyed
  > The sudden right turn on approach to landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN16LA338](https://openairdocs.org/ntsb/CEN16LA338.md): Cessna 172 · New Orleans, LA · Accident · 2 fatal · Limited investigation · Final report · Aug 28, 2016 · N984RA · Substantial damage
  > The pilot's improper decision to continue a descent during a night visual approach a for landing which resulted in controlled flight into terrain. Contributing to the accident was the reduced visibility and pilot's disregard of the PAPI indications that the…
- [NTSB CEN16FA333](https://openairdocs.org/ntsb/CEN16FA333.md): Cessna 172N · Terre Haute, IN · Accident · 1 fatal · Field investigation · Final report · Aug 25, 2016 · N17SK · Substantial damage
  > The pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.
- [NTSB WPR16FA166](https://openairdocs.org/ntsb/WPR16FA166.md): Douglas TA-4K · Las Vegas, NV · Accident · Minor injuries · Field investigation · Final report · Aug 18, 2016 · N140EM · Destroyed
  > Foreign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…
- [NTSB ANC16CA056](https://openairdocs.org/ntsb/ANC16CA056.md): Brian Turner Northern Explorer · Chickaloon, AK · Accident · No injuries · Data collection · Final report · Aug 8, 2016 · N907BT · Substantial damage
  > A partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat.
- [NTSB ERA16LA281](https://openairdocs.org/ntsb/ERA16LA281.md): Vans RV4 · Shelbyville, KY · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2016 · N924WZ · Substantial damage
  > The partial loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to effectively use carburetor heat.
- [NTSB ERA16LA285](https://openairdocs.org/ntsb/ERA16LA285.md): Shaffer Donald Arion Lightning · Toughkenamon, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2016 · N270J · Substantial damage
  > A total loss of engine power for reasons that could not be determined because examination of the engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB GAA16CA413](https://openairdocs.org/ntsb/GAA16CA413.md): Cessna 172 · Cross Keys, NJ · Accident · Minor injuries · Data collection · Final report · Aug 3, 2016 · N84371 · Substantial damage
  > The pilot's failure to maintain lateral bank control during final approach, which resulted with an impact with a tree and substantial damage to the left and right wings.
- [NTSB DCA16WA218](https://openairdocs.org/ntsb/DCA16WA218.md): Robinson R44 · Lusikisuki, near Port John, Eastern Cape Province, South Africa · Accident · 4 fatal · Foreign investigation · Aug 3, 2016 · ZS-RXW · Destroyed
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on August 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB WPR16FA154](https://openairdocs.org/ntsb/WPR16FA154.md): Sperling Richard G Lancair 360 · The Dalles, OR · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2016 · N528HZ · Destroyed
  > The pilot's loss of control during an aborted landing. Contributing to the accident was the pilot's failure to extend the landing gear before touchdown.
- [NTSB ERA16WA306](https://openairdocs.org/ntsb/ERA16WA306.md): Embraer EMB820 · Londrina City, Brazil · Accident · 8 fatal · Foreign investigation · Jul 31, 2016 · PT-EFQ · Destroyed
  > On July 31, 2016, at 2357 universal coordinated time, an Embraer EMB820C (Piper PA-31-350), Brazilian registration PT-EFQ, was destroyed when it impacted a power line and terrain following a loss of power in the left engine, while on approach to Londrina…
- [NTSB DCA16WA213](https://openairdocs.org/ntsb/DCA16WA213.md): Boeing 737 · Makassar, Indonesia · Incident · No injuries · Foreign investigation · Jul 31, 2016 · PK-GMK · No damage
  > The National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 31, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation…
- [NTSB DCA16MA204](https://openairdocs.org/ntsb/DCA16MA204.md): Kubicek BB85 · Lockhart, TX · Accident · 16 fatal · Class 1 · Major · Final report · Jul 30, 2016 · N2469L · Destroyed
  > The pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…
- [NTSB CEN16LA294](https://openairdocs.org/ntsb/CEN16LA294.md): Bell 47G 2 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 2016 · N975BH · Substantial damage
  > The loosening and separation of the throttle linkage nut, which resulted in a loss of throttle control and subsequent hard landing after autorotation.
- [NTSB ERA16LA276](https://openairdocs.org/ntsb/ERA16LA276.md): Piper PA28R · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 29, 2016 · N94JR · Substantial damage
  > A total loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN16FA295](https://openairdocs.org/ntsb/CEN16FA295.md): Mooney M20J · Holmen, WI · Accident · 1 fatal · Field investigation · Final report · Jul 28, 2016 · N54PM · Destroyed
  > The pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.
- [NTSB ERA16LA274](https://openairdocs.org/ntsb/ERA16LA274.md): Alisport Silent 2 Targa · London, KY · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 2016 · N602SL · Substantial damage
  > The pilot's failure to properly secure the right side of the canopy before takeoff, and an in-flight collision with trees while maneuvering with an open canopy. Contributing to the pilot's failure to properly secure the canopy was the lack of a visual…
- [NTSB CEN16LA283](https://openairdocs.org/ntsb/CEN16LA283.md): Bristell E-LSA · Oshkosh, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2016 · N167BL · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack on short final approach, which resulted in an inadvertent aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot’s distraction with other traffic in the…
- [NTSB WPR16LA149](https://openairdocs.org/ntsb/WPR16LA149.md): Swartz Gene Titan T 51 Mustang · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Jul 23, 2016 · N5103 · Substantial damage
  > A total loss of engine power due to the separation of a flywheel magnet, which impacted the attachment bracket for the primary and secondary ignition and disrupted the timing of the ignition system, rendering it inoperative.
- [NTSB CEN16FA269](https://openairdocs.org/ntsb/CEN16FA269.md): Aeronca 11AC · Ishpeming, MI · Accident · 2 fatal · Field investigation · Final report · Jul 19, 2016 · N85893 · Substantial damage
  > The pilot's failure to maintain airspeed following a loss of engine power due to carburetor icing while turning from base to final at a low altitude, which resulted in the airplane's wing exceeding its critical angle of attack and a subsequent aerodynamic…
- [NTSB ERA16LA258](https://openairdocs.org/ntsb/ERA16LA258.md): Piper PA24 · Westwood, MA · Accident · 1 fatal · Limited investigation · Final report · Jul 16, 2016 · N11MT · Substantial damage
  > The pilot's improper fuel management, which resulted in exhaustion of the fuel in the selected fuel tank and a total loss of engine power due to fuel starvation.
- [NTSB CEN16WA279](https://openairdocs.org/ntsb/CEN16WA279.md): Rans S6 · Murcia, Spain · Accident · 1 fatal · Foreign investigation · Jul 15, 2016 · EC-YDQ · Substantial damage
  > On July 15, 2016, about 1910 coordinated universal time (UTC), a Rans S-6, EC-YDQ, sustained substantial damage when it impacted terrain after a loss of control while landing at the Los Garranchos Airport, Murcia, Spain. The pilot received fatal injuries. The…
- [NTSB ERA16LA252](https://openairdocs.org/ntsb/ERA16LA252.md): Cessna 310 · Bartow, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 2016 · N100CP · Substantial damage
  > The pilot's failure to move the fuel selectors to the “main” position in accordance with the Before Landing checklist, which resulted in fuel starvation and the total loss of power of both engines.
- [NTSB ERA16FA248](https://openairdocs.org/ntsb/ERA16FA248.md): Bell Helicopter Textron Canada 407 · Hickory, KY · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2016 · N427TV · Substantial damage
  > Company maintenance personnel's inappropriate removal without replacement of the safety wires on the collective lever pin screws during a recent maintenance inspection, which resulted in the screws backing out and led to a loss of collective control in flight.
- [NTSB ERA16LA247](https://openairdocs.org/ntsb/ERA16LA247.md): Mormile Francis W Aventura II · West Pittsfield, ME · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2016 · N932MC · Substantial damage
  > The pilot's failure to maintain airplane control after a total loss of engine power due to carburetor icing, which accumulated because the carburetor heat was not functioning.
- [NTSB WPR16LA135](https://openairdocs.org/ntsb/WPR16LA135.md): Bert N Norris RV-6 · St. Maries, ID · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N916BN · Substantial damage
  > A partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat.
- [NTSB GAA16CA357](https://openairdocs.org/ntsb/GAA16CA357.md): Beech 23 · Maryville, MO · Accident · Minor injuries · Data collection · Final report · Jul 2, 2016 · N8704M · Substantial damage
  > The pilot's failure to see and avoid power lines on approach during landing, resulting a power line strike, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's inadequate pre-flight planning.
- [NTSB CEN16LA252](https://openairdocs.org/ntsb/CEN16LA252.md): Piper PA-22-150 · Houghton Lake Heights, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 2016 · N5788D · Substantial damage
  > The pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.
- [NTSB ERA16CA303](https://openairdocs.org/ntsb/ERA16CA303.md): Cessna 152G · Augusta, ME · Accident · No injuries · Data collection · Final report · Jul 1, 2016 · N4916B · Substantial damage
  > The pilot's failure to compensate for the gusting wind conditions during a short-field landing and the designated pilot examiner's delayed remedial action, which resulted in the wing tip contacting the runway during the go-around.
- [NTSB DCA16CA197](https://openairdocs.org/ntsb/DCA16CA197.md): Facebook UK Aquila · Yuma, AZ · Accident · No injuries · Data collection · Final report · Jun 28, 2016 · N565AQ · Substantial damage
  > a structural failure of the wing as a result of exceeding the airspeed envelope due to wind gusts which were beyond the capabilities of the autopilot. Contributing to the accident was an insufficient amount of drag to track the glideslope in the presence of…
- [NTSB CEN16LA236](https://openairdocs.org/ntsb/CEN16LA236.md): Cessna 150L · Detroit, MI · Accident · 1 fatal · Limited investigation · Final report · Jun 28, 2016 · N6622G · Substantial damage
  > The pilot’s disregard of the banner-tow operator's policy regarding the maximum allowable flight duration, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB GAA16CA347](https://openairdocs.org/ntsb/GAA16CA347.md): Piper PA 12 · Burnet, TX · Accident · No injuries · Data collection · Final report · Jun 22, 2016 · N223CG · Substantial damage
  > The student pilot's failure to maintain adequate fuel levels, which resulted in fuel starvation, a loss of engine power, and a forced landing. Contributing to the accident was the flight instructor's failure to monitor the fuel levels.
- [NTSB CEN16LA225](https://openairdocs.org/ntsb/CEN16LA225.md): Piper PA 24 · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 2016 · N5661R · Substantial damage
  > The total loss of engine power due to fuel exhaustion.
- [NTSB CEN16LA230](https://openairdocs.org/ntsb/CEN16LA230.md): Glaeser Nieuport 11 · Gardner, KS · Accident · No injuries · Limited investigation · Final report · Jun 18, 2016 · N124TG · Substantial damage
  > The pilot's diverted attention during the approach for the precautionary landing, which resulted in low airspeed, an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall. Contributing to the accident was the control system…
- [NTSB DCA16WA189](https://openairdocs.org/ntsb/DCA16WA189.md): Boeing 737 · Launceston, Australia · Incident · No injuries · Foreign investigation · Jun 17, 2016 · VH-XMO · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…
- [NTSB ANC16RA037](https://openairdocs.org/ntsb/ANC16RA037.md): Cirrus SR20 · Muan, South Korea · Accident · 3 fatal · Foreign investigation · Jun 17, 2016 · HL1210 · Destroyed
  > On June 17, 2016, about 1515 local time, a Cirrus SR20 airplane, Republic of Korea registration number HL1210, operated by the pilot, was destroyed following a loss of control while on approach to Muan International Airport, Republic of Korea. The flight…
- [NTSB ERA16FA215](https://openairdocs.org/ntsb/ERA16FA215.md): Piper PA31 · State College, PA · Accident · 2 fatal · Field investigation · Final report · Jun 16, 2016 · N3591P · Destroyed
  > The pilot's decision to continue an unstabilized instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ANC16WA033](https://openairdocs.org/ntsb/ANC16WA033.md): Piper PA28R · Green Lake, Canada · Accident · 1 fatal · Foreign investigation · Jun 16, 2016 · C-FYGG · Substantial damage
  > On June 16, 2016, about 1900 Coordinated Universal Time, a Piper PA28R-180 airplane, C-FYGG, struck trees and impacted terrain while attempting a go-around near Green Lake, British Columbia, Canada. The pilot sustained serious injuries and the passenger…
- [NTSB ERA16FA208](https://openairdocs.org/ntsb/ERA16FA208.md): Mooney M20E · Collegedale, TN · Accident · 3 fatal · Field investigation · Final report · Jun 11, 2016 · N7830V · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering after a go-around, which resulted in an aerodynamic stall.
- [NTSB ERA16CA211](https://openairdocs.org/ntsb/ERA16CA211.md): Piper PA-28 · Williamsburg, VA · Accident · Serious injuries · Data collection · Final report · Jun 10, 2016 · N9297J · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a go-around which led to the airplane exceeding its critical angle-of-attack and experiencing aerodynamic stall.
- [NTSB CEN16FA211](https://openairdocs.org/ntsb/CEN16FA211.md): Cirrus Design SR20 · Houston, TX · Accident · 3 fatal · Field investigation · Final report · Jun 9, 2016 · N4252G · Substantial damage
  > The pilot's improper go-around procedure that did not ensure that the airplane was at a safe airspeed before raising the flaps, which resulted in exceedance of the critical angle of attack and resulted in an accelerated aerodynamic stall and spin into…
- [NTSB ERA16WA273](https://openairdocs.org/ntsb/ERA16WA273.md): BAE BAE125 · Yakutia, Russia · Accident · No injuries · Foreign investigation · Jun 5, 2016 · RA-02773 · Substantial damage
  > On June 5, 2016, about 1425 coordinated universal time (2325 local time), a British Aerospace (BAE) Hawker 125-800, Russian registration RA-02773, was substantially damaged when it impacted terrain while on approach to Neryungri Airport, Yakutia, Russia, and…
- [NTSB ERA16CA203](https://openairdocs.org/ntsb/ERA16CA203.md): Beech F33A · Fairfield, NJ · Accident · No injuries · Data collection · Final report · Jun 5, 2016 · N444VT · Substantial damage
  > The pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power.
- [NTSB DCA16CA182](https://openairdocs.org/ntsb/DCA16CA182.md): Boeing 737-932ER · Las Vegas, NV · Accident · Serious injuries · Data collection · Final report · Jun 5, 2016 · N801DZ · No damage
  > An encounter with wake turbulence that resulted in a flight attendant injury.
- [NTSB WPR16LA127](https://openairdocs.org/ntsb/WPR16LA127.md): Piper PA46 · Seattle, WA · Accident · No injuries · Class 3 · Limited · Final report · Jun 2, 2016 · N301DM · Substantial damage
  > The pilot’s failure to use the emergency procedures checklist for generator failures or for gear extension following a loss of electrical power due to the separated flag terminal of a diode in overstress, which resulted in a gear-up landing.
- [NTSB ERA16LA200](https://openairdocs.org/ntsb/ERA16LA200.md): Aeronca 7AC · Toughkenamon, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2016 · N83547 · Substantial damage
  > The student pilot’s inadvertent actuation of the fuel shutoff valve, which led to a total loss of engine power, forced landing, and impact with a hangar. Contributing to the outcome was maintenance personnel’s inadequate inspection of the fuel shutoff system…
- [NTSB CEN16LA201](https://openairdocs.org/ntsb/CEN16LA201.md): Cessna 402B · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · May 27, 2016 · N76MD · Substantial damage
  > The failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.
- [NTSB WPR16LA122](https://openairdocs.org/ntsb/WPR16LA122.md): Rans S 5 · Lodi, CA · Accident · Minor injuries · Limited investigation · Final report · May 23, 2016 · N481TJ · Substantial damage
  > A total loss of engine power due to fuel starvation as the result of a pinched fuel line. Contributing to the accident was the pilot’s maneuvering just before landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an…
- [NTSB CEN16LA190](https://openairdocs.org/ntsb/CEN16LA190.md): Beech C24R · Marine City, MI · Accident · No injuries · Limited investigation · Final report · May 22, 2016 · N20135 · Substantial damage
  > The misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…
- [NTSB WPR16FA111](https://openairdocs.org/ntsb/WPR16FA111.md): Cessna R182 · Altadena, CA · Accident · 1 fatal · Field investigation · Final report · May 15, 2016 · N133BW · Destroyed
  > The pilot's failure to maintain clearance from rising mountainous terrain while flying in instrument meteorological conditions. Contributing to the accident was the loss of radio communications for a reason that could not be determined because of the…

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

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

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