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

## Cases, newest first

- [NTSB CEN17FA258](https://openairdocs.org/ntsb/CEN17FA258.md): Piper PA 28-181 · Waterford, OH · Accident · 2 fatal · Field investigation · Final report · Jul 8, 2017 · N793MA · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.
- [NTSB CEN17LA261](https://openairdocs.org/ntsb/CEN17LA261.md): Cessna 177 · Wauseon, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 2017 · N3225T · Substantial damage
  > The flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA17LA229](https://openairdocs.org/ntsb/ERA17LA229.md): Aviat A-1C-180 · Dillwyn, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 2017 · N272WY · Substantial damage
  > The pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.
- [NTSB ERA17FA226](https://openairdocs.org/ntsb/ERA17FA226.md): Luscombe 8 · Remsen, NY · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2017 · N45851 · Substantial damage
  > The pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.
- [NTSB GAA17CA421](https://openairdocs.org/ntsb/GAA17CA421.md): Aviat A 1 · Dixie, ID · Accident · No injuries · Data collection · Final report · Jul 3, 2017 · N368HY · Substantial damage
  > The pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.
- [NTSB GAA17CA379](https://openairdocs.org/ntsb/GAA17CA379.md): American General Acft AG5 · Rio Vista, CA · Accident · No injuries · Data collection · Final report · Jul 3, 2017 · N321MW · Substantial damage
  > The student pilot’s failure to maintain directional control during a go-around in gusting wind conditions.
- [NTSB CEN17LA250](https://openairdocs.org/ntsb/CEN17LA250.md): North American T-28A · Moorhead, MN · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 2017 · N9103F · Destroyed
  > Controlled descent into terrain due to engine issues, the reason for which could not be determined because examination of the engine revealed no evidence of malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17LA247](https://openairdocs.org/ntsb/CEN17LA247.md): Cessna P210N · Eagle, CO · Accident · No injuries · Limited investigation · Final report · Jun 30, 2017 · N210HG · Substantial damage
  > The loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17LA242](https://openairdocs.org/ntsb/CEN17LA242.md): Bellanca 17 30 · Grove, OK · Accident · No injuries · Limited investigation · Final report · Jun 25, 2017 · N14728 · Substantial damage
  > An unporting of fuel in the right wing while maneuvering in the airport traffic pattern, which resulted in a partial loss of engine power due to fuel starvation.
- [NTSB ERA17LA212](https://openairdocs.org/ntsb/ERA17LA212.md): Aero Commander 200D · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 2017 · N929DM · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to use the emergency checklist to restart the engine.
- [NTSB CEN17FA231](https://openairdocs.org/ntsb/CEN17FA231.md): Gefa-Flug AS-105-GD · Hartford, WI · Accident · Serious injuries · Field investigation · Final report · Jun 15, 2017 · G-SUNA · Destroyed
  > The overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.
- [NTSB ERA17LA205](https://openairdocs.org/ntsb/ERA17LA205.md): Cessna P206 · West Creek, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 2017 · N206TF · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation and the subsequent total loss of engine power.
- [NTSB ANC17WA031](https://openairdocs.org/ntsb/ANC17WA031.md): Bell 214 · Dongducheon, South Korea · Accident · Serious injuries · Foreign investigation · Jun 13, 2017 · HL9157 · Substantial damage
  > On June 13, 2017, about 1810 local time, a Republic of Korea registered Bell 214B helicopter, HL9157, operated by UB Air, impacted remote mountainous terrain about 3 miles northeast of Dongducheon, Republic of Korea, during the approach to a drop zone while…
- [NTSB GAA17CA337](https://openairdocs.org/ntsb/GAA17CA337.md): Cessna 172 · Ravenna, OH · Accident · No injuries · Data collection · Final report · Jun 11, 2017 · N33FM · Substantial damage
  > The flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…
- [NTSB ERA17LA201](https://openairdocs.org/ntsb/ERA17LA201.md): Cirrus Design SR22 · Gordonville, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 2017 · N592BC · Substantial damage
  > The pilot's failure to properly configure the mixture control for landing due to disorientation because he had the airport diagram upside down, which resulted in a total loss of engine power.
- [NTSB GAA17CA327](https://openairdocs.org/ntsb/GAA17CA327.md): Cessna 172 · Tooele, UT · Accident · No injuries · Data collection · Final report · Jun 6, 2017 · N741TW · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB GAA17CA318](https://openairdocs.org/ntsb/GAA17CA318.md): Cessna 172 · Payson, AZ · Accident · Minor injuries · Data collection · Final report · Jun 4, 2017 · N50526 · Destroyed
  > The pilot’s inadequate preflight planning that did not account for high-density altitude conditions and his subsequent attempted go-around in conditions that prevented the airplane from attaining a positive climb rate and resulted in its subsequent descent…
- [NTSB WPR17LA122](https://openairdocs.org/ntsb/WPR17LA122.md): Luscombe 8A · Rexberg, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 3, 2017 · N1627K · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information which resulted in a landing short of the runway.
- [NTSB GAA17CA317](https://openairdocs.org/ntsb/GAA17CA317.md): Cessna 177 · Guttenberg, IA · Accident · No injuries · Data collection · Final report · Jun 3, 2017 · N34462 · Substantial damage
  > The pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.
- [NTSB CEN17WA211](https://openairdocs.org/ntsb/CEN17WA211.md): Lake LA-4-200 · Muskoka, Ontario, Canada · Accident · 2 fatal · Foreign investigation · Jun 2, 2017 · C-GZSW · Destroyed
  > On June 2, 2017, at 2113 coordinated universal time, a Lake LA-4-200 Buccaneer, C-GZSW, was destroyed on impact with terrain after takeoff from Muskoka Airport (CYQA), Muskoka, Ontario, Canada. After takeoff, the pilot attempted to return to the airport, and…
- [NTSB CEN17WA240](https://openairdocs.org/ntsb/CEN17WA240.md): Reims F150 M · Charleroi, Belgium · Incident · No injuries · Foreign investigation · May 30, 2017 · OO-PRG · Minor damage
  > On May 30, 2017, about 1730 hours universal coordinated time, a Reims Aviation F150M, Belgium registration OO-PRG, sustained minor damage during a forced landing at Brussels South - Charleroi Airport (EBCI), Charleroi, Belgium. The flight instructor and…
- [NTSB WPR17LA112](https://openairdocs.org/ntsb/WPR17LA112.md): Cessna 175 · El Monte, CA · Accident · Minor injuries · Limited investigation · Final report · May 27, 2017 · N6832D · Substantial damage
  > The flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…
- [NTSB GAA17CA322](https://openairdocs.org/ntsb/GAA17CA322.md): Piper PA28 · Gilbert, SC · Accident · No injuries · Data collection · Final report · May 27, 2017 · N5544J · Substantial damage
  > The pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.
- [NTSB WPR17LA110](https://openairdocs.org/ntsb/WPR17LA110.md): Johnson Glastar · Concord, CA · Accident · Minor injuries · Limited investigation · Final report · May 26, 2017 · N4579J · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN17LA205](https://openairdocs.org/ntsb/CEN17LA205.md): Amstutz Curtis J BD-5B · Portland, IN · Accident · No injuries · Limited investigation · Final report · May 26, 2017 · N604KA · Substantial damage
  > A failure of the wiring between the engine control unit and the fuel injector, which resulted in a total loss of engine power.
- [NTSB ERA17FA190](https://openairdocs.org/ntsb/ERA17FA190.md): Eurocopter Deutschland EC 135 · New Castle, DE · Accident · 1 fatal · Field investigation · Final report · May 25, 2017 · N62UP · Destroyed
  > The pilot's loss of helicopter control during a missed approach in instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.
- [NTSB ERA17CA186](https://openairdocs.org/ntsb/ERA17CA186.md): Piper PA 28-181 · Bristow, VA · Accident · No injuries · Data collection · Final report · May 21, 2017 · N8304F · Substantial damage
  > The flight instructor’s and pilot’s mismanagement of the available fuel, which resulted in exhaustion of the fuel in the selected fuel tank and a subsequent total loss of engine power.
- [NTSB CEN17LA192](https://openairdocs.org/ntsb/CEN17LA192.md): Robinson Helicopter R66 · Canon City, CO · Accident · No injuries · Limited investigation · Final report · May 20, 2017 · N778TL · Substantial damage
  > The pilot’s loss of helicopter control on approach to land due to a vortex ring state (settling with power) condition, which resulted in a hard landing.
- [NTSB CEN17MA183](https://openairdocs.org/ntsb/CEN17MA183.md): Learjet 35A · Teterboro, NJ · Accident · 2 fatal · Class 1 · Major · Final report · May 15, 2017 · N452DA · Destroyed
  > The pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…
- [NTSB CEN17WA189](https://openairdocs.org/ntsb/CEN17WA189.md): Monocoupe 90AF · Plattsville, Canada · Accident · 1 fatal · Foreign investigation · May 13, 2017 · C-FJGA · Substantial damage
  > On May 13, 2017, a Monocoupe 90F-100 airplane, C-FJGA, impacted short of the threshold at Lubitz Flying Field (CLB2), Plattsville, Ontario. The pilot was fatally injured.This investigation is under the jurisdiction and control of the government of Canada. Any…
- [NTSB CEN17LA185](https://openairdocs.org/ntsb/CEN17LA185.md): Mooney M20TN · Grandby, CO · Accident · No injuries · Limited investigation · Final report · May 13, 2017 · N9306 · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB OPS17IA021](https://openairdocs.org/ntsb/OPS17IA021.md): Cessna 172S · New Orleans, LA · Incident · Class 3 · Incident · Final report · May 9, 2017 · N520ER · 2 aircraft · No damage
  > The air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.
- [NTSB GAA17CA282](https://openairdocs.org/ntsb/GAA17CA282.md): Piper PA23 · Fremont, OH · Accident · No injuries · Data collection · Final report · May 9, 2017 · N63944 · Substantial damage
  > The pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.
- [NTSB ERA17FA174](https://openairdocs.org/ntsb/ERA17FA174.md): Cirrus Design SR22 · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · May 5, 2017 · N271TS · Substantial damage
  > The pilot's decision to attempt to land while a line of rain showers with microburst activity was crossing the airport, which resulted in a loss of control during a subsequent attempted go-around.
- [NTSB WPR17LA126](https://openairdocs.org/ntsb/WPR17LA126.md): Hy-Tek Hurricane · Redcrest, CA · Accident · 1 fatal · Limited investigation · Final report · May 4, 2017 · UNREG · Substantial damage
  > The noncertificated pilot's impairment from methamphetamine and alcohol use, which precluded the pilot from maintaining control of the airplane after a loss of engine power for reasons that could not be determined based on available information.
- [NTSB GAA17CA255](https://openairdocs.org/ntsb/GAA17CA255.md): Schweizer SGS134 · Blairstown, NJ · Accident · No injuries · Data collection · Final report · Apr 28, 2017 · N2682H · Substantial damage
  > The pilot’s failure to attain a proper glidepath on approach for landing in gusting wind conditions, which resulted in an off-airport landing and impact with soccer goal posts.
- [NTSB CEN17FA170](https://openairdocs.org/ntsb/CEN17FA170.md): Air Tractor AT 602 · Hollis, OK · Accident · 1 fatal · Field investigation · Final report · Apr 28, 2017 · N604RH · Substantial damage
  > An impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.
- [NTSB CEN17FA164](https://openairdocs.org/ntsb/CEN17FA164.md): Bellanca 17 31ATC · Boonville, MO · Accident · 2 fatal · Field investigation · Final report · Apr 24, 2017 · N787TV · Substantial damage
  > The pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.
- [NTSB WPR17FA089](https://openairdocs.org/ntsb/WPR17FA089.md): Appleby Nieuport 28 · Paso Robles, CA · Accident · 1 fatal · Field investigation · Final report · Apr 23, 2017 · N6190 · Substantial damage
  > The failure of unknown personnel to properly safety an elevator control cable turnbuckle, which disconnected in flight resulting in loss of pitch control. Contributing to the accident was the inadequate design of the experimental airplane, which did not…
- [NTSB ERA17LA166](https://openairdocs.org/ntsb/ERA17LA166.md): Cessna 182A · Ovid, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 2017 · N9907B · Substantial damage
  > The mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…
- [NTSB ERA17LA165](https://openairdocs.org/ntsb/ERA17LA165.md): Ganjoo Amit Sonex · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2017 · N212AG · Substantial damage
  > The pilot's failure to use carburetor heat appropriately, which resulted in a total loss of engine power due to the formation of carburetor ice.
- [NTSB GAA17CA240](https://openairdocs.org/ntsb/GAA17CA240.md): Parlette Robert L Glastar · Wenatchee, WA · Accident · Minor injuries · Data collection · Final report · Apr 21, 2017 · N661RP · Substantial damage
  > The pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.
- [NTSB CEN17LA162](https://openairdocs.org/ntsb/CEN17LA162.md): Cessna 210 · Salida, CO · Accident · No injuries · Limited investigation · Final report · Apr 20, 2017 · N9589T · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN17LA157](https://openairdocs.org/ntsb/CEN17LA157.md): Cessna 210 · Minden, LA · Accident · No injuries · Limited investigation · Final report · Apr 15, 2017 · N7358E · Substantial damage
  > The pilot's inadequate fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR17WA123](https://openairdocs.org/ntsb/WPR17WA123.md): Cessna 208 · Anem Mountain, Oksibil, Indonesia · Accident · 1 fatal · Foreign investigation · Apr 12, 2017 · PK-FSO · Destroyed
  > On April 12, 2017, about 0340 universal coordinated time, a Cessna 208C, PK-FSO, operated by PT. Spirit Avia Sentosa as an unscheduled cargo flight under the pertinent civil regulations of the government of Indonesia, collided with mountainous terrain 7…
- [NTSB ERA17FA153](https://openairdocs.org/ntsb/ERA17FA153.md): Howard DGA 15P · Monongahela, PA · Accident · 1 fatal · Field investigation · Final report · Apr 12, 2017 · N4476N · Destroyed
  > The pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB CEN17LA153](https://openairdocs.org/ntsb/CEN17LA153.md): Cessna 152 · La Porte, TX · Accident · No injuries · Limited investigation · Final report · Apr 12, 2017 · N95551 · Substantial damage
  > A total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection that did not detect water contamination.
- [NTSB WPR17IA086](https://openairdocs.org/ntsb/WPR17IA086.md): Beech A36TC · Livermore, CA · Incident · No injuries · Class 3 · Incident · Final report · Apr 10, 2017 · N755R · Minor damage
  > A mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…
- [NTSB GAA17CA241](https://openairdocs.org/ntsb/GAA17CA241.md): American AA 1 · New Market, VA · Accident · Minor injuries · Data collection · Final report · Apr 9, 2017 · N5690L · Substantial damage
  > The pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.
- [NTSB CEN17LA154](https://openairdocs.org/ntsb/CEN17LA154.md): Piper PA-22-135 · Greensburg, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 2017 · N2389A · Substantial damage
  > The pilot's failure to maintain control during landing, which resulted in an impact with terrain.

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

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

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