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

## Cases, newest first

- [NTSB GAA17CA109](https://openairdocs.org/ntsb/GAA17CA109.md): Piper PA28R · Kewanee, IL · Accident · No injuries · Data collection · Final report · Dec 16, 2016 · N55484 · Substantial damage
  > The pilot’s failure to extend the landing gear during the approach to land.
- [NTSB GAA17CA095](https://openairdocs.org/ntsb/GAA17CA095.md): Robinson Helicopter R44 · Separ, NM · Accident · No injuries · Data collection · Final report · Dec 15, 2016 · N835AK · Substantial damage
  > The pilot’s abrupt maneuver to avoid electrical wires during the approach, which resulted in a hard landing.
- [NTSB ERA17CA068](https://openairdocs.org/ntsb/ERA17CA068.md): Beech A36 · New Smyrna Beach, FL · Accident · Minor injuries · Data collection · Final report · Dec 12, 2016 · N776WM · Substantial damage
  > The pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the…
- [NTSB CEN17WA051](https://openairdocs.org/ntsb/CEN17WA051.md): Piper PA-34-200T · Alsace, France · Accident · 1 fatal · Foreign investigation · Dec 7, 2016 · HB-LSD · Destroyed
  > On December 7, 2016, at 1644 coordinated universal time, a Piper PA-34-200T airplane, Switzerland registration HB-LSD, was destroyed when it collided with the terrain near Alsace, France. The pilot was fatally injured. The airplane departed the Nurnberg…
- [NTSB WPR17FA033](https://openairdocs.org/ntsb/WPR17FA033.md): Airborne Windsports PTY Edge XT-912-L · Santa Barbara, CA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2016 · N188M · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering in the traffic pattern.
- [NTSB WPR17LA032](https://openairdocs.org/ntsb/WPR17LA032.md): Hoskins Lonnie F Velocity XL RG · Petaluma, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2016 · N84KJ · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on…
- [NTSB GAA17CA087](https://openairdocs.org/ntsb/GAA17CA087.md): Jack Fehling Celebrity · North Hampton, NH · Accident · No injuries · Data collection · Final report · Dec 4, 2016 · N28JF · Substantial damage
  > The pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.
- [NTSB ERA17WA081](https://openairdocs.org/ntsb/ERA17WA081.md): Robinson Helicopter R44 II · Sao Lourenco da Serra, Brazil · Accident · 4 fatal · Foreign investigation · Dec 4, 2016 · PR-TUN · Destroyed
  > On December 4, 2016, about 1800 universal coordinated time, a Robinson R44-II, Brazilian registration PR-TUN, was substantially damaged when it impacted terrain while maneuvering near Sao Lourenco, Sao Paulo, Brazil. The pilot and three passengers were…
- [NTSB GAA17CA089](https://openairdocs.org/ntsb/GAA17CA089.md): Piper PA 28 · Thomson, GA · Accident · No injuries · Data collection · Final report · Dec 2, 2016 · N2367R · Substantial damage
  > The pilot’s improper preflight planning, which resulted in fuel exhaustion and the total loss of engine power.
- [NTSB CEN17FA045](https://openairdocs.org/ntsb/CEN17FA045.md): Cessna 340 · Fargo, ND · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2016 · N123KK · Destroyed
  > The loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.
- [NTSB DCA17RA031](https://openairdocs.org/ntsb/DCA17RA031.md): BAE AVRO146RJ · Medellin, Colombia · Accident · No injuries · Foreign investigation · Nov 28, 2016 · CP-2933 · Destroyed
  > The El Grupo de Investigacon de Accidentes (GRIAA) of Colombia has notified the NTSB of an accident involving a BAE AVRO146RJ that occurred on November 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA investigation under…
- [NTSB WPR17FA029](https://openairdocs.org/ntsb/WPR17FA029.md): Bellanca 7GCAA · Glamis, CA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2016 · N88373 · Substantial damage
  > The pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…
- [NTSB ERA17WA059](https://openairdocs.org/ntsb/ERA17WA059.md): Embraer EMB710 · Novo Progresso, Brazil · Accident · 4 fatal · Foreign investigation · Nov 24, 2016 · PT-NCJ · Substantial damage
  > On November 24, 2016, about 2040 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NCJ, was substantially damaged when it impacted terrain on approach to an unregistered landing strip in a quarry near Novo Progresso, State of Para,…
- [NTSB ERA17WA061](https://openairdocs.org/ntsb/ERA17WA061.md): Cessna TU206 · Villavicencio, Colombia · Accident · 1 fatal · Foreign investigation · Nov 23, 2016 · HK-2659 · Substantial damage
  > On November 23, 2016, about 2000 coordinated universal time, a Cessna TU206G, Colombian registration HK2659, was substantially damaged during a forced landing near Vanguardia Airport (SKVV), Colombia. The Colombian certificated pilot and two of the passengers…
- [NTSB CEN17LA043](https://openairdocs.org/ntsb/CEN17LA043.md): Beech 200 · Moorhead, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 2016 · N80RT · Substantial damage
  > The pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.
- [NTSB WPR17FA023](https://openairdocs.org/ntsb/WPR17FA023.md): Cessna 172N · Moss Beach, CA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2016 · N6610D · Substantial damage
  > The pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in…
- [NTSB ERA17LA048](https://openairdocs.org/ntsb/ERA17LA048.md): Schweizer SGS126 · Moscow, TN · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2016 · N65968 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin.
- [NTSB ENG17WA025](https://openairdocs.org/ntsb/ENG17WA025.md): Bombardier BD700 1A11 · Hong Kong, Hong Kong SAR China · Incident · No injuries · Foreign investigation · Nov 15, 2016 · VP-CKM · No damage
  > The United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Bombardier Global Express BD700, which occurred on November 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…
- [NTSB GAA17CA061](https://openairdocs.org/ntsb/GAA17CA061.md): Beech 95B55 · Plattsburgh, NY · Accident · No injuries · Data collection · Final report · Nov 14, 2016 · N180GA · Substantial damage
  > The pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle-of-attack during a single-engine approach, which resulted in an aerodynamic stall at an altitude too low for the flight instructor to recover.
- [NTSB GAA17CA072](https://openairdocs.org/ntsb/GAA17CA072.md): Piper PA 28R · Payallup, WA · Accident · No injuries · Data collection · Final report · Nov 11, 2016 · N9466K · Substantial damage
  > The airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.
- [NTSB ERA17CA039](https://openairdocs.org/ntsb/ERA17CA039.md): Piper PA 24-250 · Houlton, ME · Accident · No injuries · Data collection · Final report · Nov 8, 2016 · N7682P · Substantial damage
  > A total loss of engine power due to fuel starvation, which resulted from the pilot’s mismanagement of the available fuel.
- [NTSB CEN17LA037](https://openairdocs.org/ntsb/CEN17LA037.md): Johnson Kenneth R Stol CH 801 · Royalton, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2016 · N801KJ · Destroyed
  > The loss of control during approach for reasons that could not be determined due to postimpact fire damage.
- [NTSB GAA17LA090](https://openairdocs.org/ntsb/GAA17LA090.md): Piper PA28R · Watertown, WI · Accident · No injuries · Limited investigation · Final report · Nov 5, 2016 · N300KR · Substantial damage
  > The pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…
- [NTSB ERA17LA034](https://openairdocs.org/ntsb/ERA17LA034.md): Piper PA32 · Bartow, FL · Accident · No injuries · Limited investigation · Final report · Oct 31, 2016 · N3941X · Substantial damage
  > A total loss of engine power during approach for reasons that could not be determined because engine examinations did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17FA028](https://openairdocs.org/ntsb/CEN17FA028.md): Aviat A-1C-180 · Clarksville, TX · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2016 · N377MA · Destroyed
  > The pilot's failure to maintain sufficient airspeed during the landing approach, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.
- [NTSB CEN17WA086](https://openairdocs.org/ntsb/CEN17WA086.md): Mooney M20K · Saarbrucken, Germany · Accident · 1 fatal · Foreign investigation · Oct 27, 2016 · N400MW · Substantial damage
  > On October 27, 2016, about 0946 UTC, a Mooney M20T, N400MW, owned and operated by a private individual, impacted on the runway at the Saarbrucken-Ensheim Airport (EDDR), Saarbrucken, Germany. The pilot on board was fatally injured and the airplane was…
- [NTSB DCA17WA224](https://openairdocs.org/ntsb/DCA17WA224.md): Boeing 757 · Keflavik, Iceland · Incident · No injuries · Foreign investigation · Oct 19, 2016 · TF-ISR · No damage
  > The Icelandic Transportation Safety Board has notified the NTSB of a serious incident involving a BOEING 757 airplane that occurred on October 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iceland's…
- [NTSB ERA17WA090](https://openairdocs.org/ntsb/ERA17WA090.md): Aerofab Lake LA 250 · Puerto Plata, Dominican Republic · Accident · 3 fatal · Foreign investigation · Oct 17, 2016 · N724ST · Substantial damage
  > On October 17, 2016, about 2200 coordinated universal time, an AeroFab, Inc. Lake-250, N724ST, was substantially damaged when it impacted the ocean while on approach to Gregorio Luperón International Airport (POP), Puerto Plata, Dominican Republic. The pilot…
- [NTSB WPR17IA007](https://openairdocs.org/ntsb/WPR17IA007.md): Short Bros SD3 60 Sherpa · Missoula, MT · Incident · No injuries · Incident investigation · Final report · Oct 13, 2016 · N148Z · Minor damage
  > The failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…
- [NTSB CEN17LA015](https://openairdocs.org/ntsb/CEN17LA015.md): Milholland Kelly D · Livingston, TX · Accident · No injuries · Limited investigation · Final report · Oct 7, 2016 · N522LM · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA17CA004](https://openairdocs.org/ntsb/GAA17CA004.md): Airborne Windsports PTY Edge XT 912 L · Fort Valley, GA · Accident · Serious injuries · Data collection · Final report · Oct 2, 2016 · N53AW · Substantial damage
  > The failure of the aircraft’s right overcenter washout strut split ring, which resulted in the pilot’s inability to maintain lateral control of the aircraft and subsequent ground impact.
- [NTSB CEN17WA008](https://openairdocs.org/ntsb/CEN17WA008.md): North American P-51D · East Anglia, United Kingdom · Accident · 1 fatal · Foreign investigation · Oct 2, 2016 · G-MSTG · Substantial damage
  > This is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On October 2, 2016, at 1438 Coordinated Universal Time (UTC), a North American P-51D, British registration G-MSTG, impacted…
- [NTSB ERA17LA005](https://openairdocs.org/ntsb/ERA17LA005.md): Piper PA28 · Laurel, MS · Accident · No injuries · Limited investigation · Final report · Oct 1, 2016 · N499TG · Substantial damage
  > A total loss of engine power due to a stuck carburetor float. The reason the carburetor float became stuck could not be determined because postaccident examination of the float and needle/seat revealed no anomalies.
- [NTSB CEN17LA003](https://openairdocs.org/ntsb/CEN17LA003.md): Beech C23 · Taylor, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2016 · N9704L · Destroyed
  > A total loss of engine power due to fuel starvation as a result of debris obstructing the fuel strainer screen and corrosion of the fuel strainer bowl.
- [NTSB DCA16CA226](https://openairdocs.org/ntsb/DCA16CA226.md): Bombardier DHC 8 202 · Dulles, VA · Accident · No injuries · Data collection · Final report · Sep 24, 2016 · N366PH · Substantial damage
  > incorrect installation of the frangible towing fuse that prevented the nose landing gear from extending.
- [NTSB ERA16LA322](https://openairdocs.org/ntsb/ERA16LA322.md): Aero Vodochody L 39 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Sep 23, 2016 · N139AJ · Substantial damage
  > An uncommanded flap retraction for reasons that could not be determined, as a postaccident examination of the flap system did not reveal evidence of any preaccident anomalies.
- [NTSB CEN16LA380](https://openairdocs.org/ntsb/CEN16LA380.md): Piper PA 30 · Mineral Wells, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2016 · N7663Y · Substantial damage
  > The pilot's fuel mismanagement, which resulted in fuel starvation to both engines and their subsequent loss of engine power.
- [NTSB GAA16CA501](https://openairdocs.org/ntsb/GAA16CA501.md): Piper PA28R · Ottumwa, IA · Accident · No injuries · Data collection · Final report · Sep 21, 2016 · N3803T · Substantial damage
  > The pilot receiving instruction's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a simulated engine failure and landing, which resulted in an aerodynamic stall. Contributing to the accident was the…
- [NTSB CEN16FA373](https://openairdocs.org/ntsb/CEN16FA373.md): Cessna 182 · Ephraim, WI · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2016 · N2012F · Destroyed
  > The pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain.
- [NTSB CEN16FA372](https://openairdocs.org/ntsb/CEN16FA372.md): Agusta A109 · Alexandria, MN · Accident · Serious injuries · Field investigation · Final report · Sep 17, 2016 · N91NM · Destroyed
  > The pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.
- [NTSB ANC16LA068](https://openairdocs.org/ntsb/ANC16LA068.md): Jeffery D Tuttle BDK Carbon Concepts · Wasilla, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 2016 · N8008Z · Substantial damage
  > The structural failure of both wings’ leading-edge slats, which resulted in a loss of airplane control.
- [NTSB GAA16CA490](https://openairdocs.org/ntsb/GAA16CA490.md): Piper PA 28 · Parkersburg, WV · Accident · No injuries · Data collection · Final report · Sep 15, 2016 · N5673U · Substantial damage
  > The flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…
- [NTSB CEN16LA374](https://openairdocs.org/ntsb/CEN16LA374.md): Piper PA-28R-201 · Bowling Green, OH · Accident · No injuries · Limited investigation · Final report · Sep 13, 2016 · N786BG · Substantial damage
  > The pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…
- [NTSB OPS16WA017](https://openairdocs.org/ntsb/OPS16WA017.md): Airbus A330 · Gold Coast, Australia · Incident · No injuries · Foreign investigation · Sep 11, 2016 · 9M-XXI · No damage
  > The Australian Transport Safety Bureau (ATSB) of Australia has notified the NTSB of an incident involving an Airbus A330-343, which occurred on September 11, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under…
- [NTSB ERA16FA312](https://openairdocs.org/ntsb/ERA16FA312.md): Beech F33 · Carrollton, GA · Accident · 3 fatal · Field investigation · Final report · Sep 7, 2016 · N6027K · 2 aircraft · Substantial damage
  > The failure of the Beech pilot to see and avoid the Diamond that was in front of and below his airplane on final approach and his use of an incorrect radio communication frequency for the airport.
- [NTSB CEN16LA352](https://openairdocs.org/ntsb/CEN16LA352.md): Cameron Z90 · Morrill, NE · Accident · No injuries · Limited investigation · Final report · Sep 4, 2016 · N982ZS · Substantial damage
  > The pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.
- [NTSB CEN16LA347](https://openairdocs.org/ntsb/CEN16LA347.md): Haggenmacher Bensen · Bryant, AR · Accident · 1 fatal · Limited investigation · Final report · Sep 3, 2016 · UNREG · Destroyed
  > The pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…
- [NTSB ANC16WA063](https://openairdocs.org/ntsb/ANC16WA063.md): Bell 206B · Williams Lake, Canada · Accident · Serious injuries · Foreign investigation · Sep 3, 2016 · C-FWHF · Substantial damage
  > On September 3, 2016, about 1530 Pacific daylight time, a Bell 206B helicopter, Canadian registration C-FWHF, impacted terrain following a loss of engine power during a visual approach to landing about 58 miles east of Williams Lake, British Colombia, Canada.…
- [NTSB WPR16FA172](https://openairdocs.org/ntsb/WPR16FA172.md): Beech A36 · Sparks, NV · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2016 · N985CA · Destroyed
  > The pilot's selection of a landing runway which, given the wind and traffic conditions, was susceptible to high crosswinds and the translation of wake turbulence across its approach path, and the controller's and pilot's failure to ensure separation from the…
- [NTSB CEN16CA364](https://openairdocs.org/ntsb/CEN16CA364.md): Beech V35B · Sioux Falls, SD · Accident · No injuries · Data collection · Final report · Aug 30, 2016 · N23583 · Substantial damage
  > The pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate preflight by the pilot and flight instructor, and the flight instructor's…

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

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

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