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

## Cases, newest first

- [NTSB IAD97LA010](https://openairdocs.org/ntsb/IAD97LA010.md): Bellanca BL28 · Ledbetter, KY · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1996 · N5029G · Substantial damage
  > the pilot's delay in executing a go-around, and his failure to obtain/maintain adequate airspeed, which resulted in a stall and collision with the ground.
- [NTSB NYC97MA005](https://openairdocs.org/ntsb/NYC97MA005.md): McDonnell Douglas MD-88 · Flushing, NY · Accident · Minor injuries · Class 1 · Major · Final report · Oct 19, 1996 · N914DL · Substantial damage
  > The Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…
- [NTSB NYC97LA007](https://openairdocs.org/ntsb/NYC97LA007.md): Cessna 310Q · Pasadena, MD · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1996 · N8226 · Destroyed
  > the pilot's inadequate preflight planning/preparation and inadequate management of the airplane's fuel supply, which resulted in fuel exhaustion and a forced landing at night. Factors related to the accident were: an inaccurate fuel quantity indicating…
- [NTSB SEA97LA017](https://openairdocs.org/ntsb/SEA97LA017.md): Cessna 182Q · Pocatello, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1996 · N5117N · Substantial damage
  > inadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Soft terrain at the emergency landing site was a related factor.
- [NTSB LAX97LA020](https://openairdocs.org/ntsb/LAX97LA020.md): Beech S35 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1996 · N5642K · Substantial damage
  > fuel starvation, due to the pilot's improper positioning of the fuel tank selector to an empty tank. Swampy terrain in the emergency landing area was a related factor.
- [NTSB ATL97LA005](https://openairdocs.org/ntsb/ATL97LA005.md): Mooney M-20F · Griffin, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1996 · N6434Q · Substantial damage
  > Fuel system contamination that resulted in fuel starvation and subsequent loss of engine power. A factor was rough terrain at the emergency landing site.
- [NTSB FTW97LA018](https://openairdocs.org/ntsb/FTW97LA018.md): Aeronca 11BC · Oil City, LA · Accident · No injuries · Limited investigation · Final report · Oct 13, 1996 · N3818E · 2 aircraft · Substantial damage
  > the failure of the pilots of both aircraft to maintain an adequate visual lookout. Factors were: different traffic pattern altitudes flown by the two pilots, and the sunglare encountered by the pilot of the ultralight.
- [NTSB CHI97LA007](https://openairdocs.org/ntsb/CHI97LA007.md): Cessna 182 · Hillsdale, MI · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 1996 · N5720B · Destroyed
  > the pilot's improper in-flight planning/decision and failure to refuel which led to fuel exhaustion.
- [NTSB ATL97LA006](https://openairdocs.org/ntsb/ATL97LA006.md): Cessna 337G · Fayetteville, NC · Accident · No injuries · Limited investigation · Final report · Oct 13, 1996 · N20EC · Substantial damage
  > The unapproved maintenance modification of the landing gear electrical system by maintenance personnel that prevented the extension of the landing gear.
- [NTSB SEA97LA009](https://openairdocs.org/ntsb/SEA97LA009.md): Globe GC-1B · Caldwell, ID · Accident · 1 fatal · Limited investigation · Final report · Oct 10, 1996 · N3228K · Substantial damage
  > the pilot's misjudgment of distance and altitude to the runway, while on final approach to land. The sunglare was a related factor.
- [NTSB LAX97LA012](https://openairdocs.org/ntsb/LAX97LA012.md): Cessna 310Q · Truckee, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1996 · N7833Q · Substantial damage
  > the pilot's inadequate preflight planning/preparation and fuel consumption calculations resulting in fuel exhaustion. The pilot's failure to switch the fuel tanks to the auxiliary position and feather both propellers were factors.
- [NTSB SEA97LA007](https://openairdocs.org/ntsb/SEA97LA007.md): Cessna 182Q · Manzanita, OR · Accident · No injuries · Limited investigation · Final report · Oct 8, 1996 · N759RE · Substantial damage
  > failure of pilot to adequately compensate for wind conditions on final approach and attain a proper touchdown point for landing. A factor relating to the accident was: the unfavorable wind condition.
- [NTSB SEA97FA005](https://openairdocs.org/ntsb/SEA97FA005.md): Cessna T210M · Everett, WA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1996 · N761TQ · Destroyed
  > The pilot's impairment of judgment and performance due to the recent excessive use of potent prescription drugs, the pilot's descent below the published decision height, and the pilot's failure to execute a missed approach. Factors contributing to the…
- [NTSB CHI97LA005](https://openairdocs.org/ntsb/CHI97LA005.md): Beech 23 · Neenah, WI · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1996 · N2398Z · Destroyed
  > the local terrain conditions around the airport. A factor was the inadequate runway safety area.
- [NTSB MIA97LA003](https://openairdocs.org/ntsb/MIA97LA003.md): Socata TB-20 · Mobile, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1996 · N59TB · Substantial damage
  > the pilot's improper management of fuel, which resulted in fuel exhaustion and loss of engine power during a go-around, and subsequent collision with trees and terrain during a forced landing.
- [NTSB MIA97LA002](https://openairdocs.org/ntsb/MIA97LA002.md): Cessna 152 · Hartsville, SC · Accident · No injuries · Limited investigation · Final report · Oct 4, 1996 · N94526 · Substantial damage
  > The student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an inadvertent stall, and subsequent in-flight collision with terrain and nose over.
- [NTSB FTW97LA004](https://openairdocs.org/ntsb/FTW97LA004.md): PZL-Bielsko SZD-59 · Sterling, CO · Accident · 1 fatal · Limited investigation · Final report · Oct 4, 1996 · N597R · Substantial damage
  > Loss of control when the pilot exceeded the velocity of stall while in a turn.
- [NTSB IAD97FA001](https://openairdocs.org/ntsb/IAD97FA001.md): Piper PA-32-300 · Brandywine, MD · Accident · 3 fatal · Field investigation · Final report · Oct 2, 1996 · N2881W · Destroyed
  > The pilots failure to maintain his assigned altitude in IFR conditions. A related factor was the failure of the radar controller to prevent the descent of N2881W to an altitude below the minimum vectoring altitude. Additionally, the controller's failure to…
- [NTSB MIA96FA233](https://openairdocs.org/ntsb/MIA96FA233.md): Piper PA-28-180 · Birmingham, AL · Accident · 1 fatal · Field investigation · Final report · Sep 27, 1996 · N8803J · Substantial damage
  > The pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…
- [NTSB CHI96LA343](https://openairdocs.org/ntsb/CHI96LA343.md): Beech BE-35 · Minot, ND · Accident · No injuries · Limited investigation · Final report · Sep 23, 1996 · N1368Z · Substantial damage
  > fuel management was not performed and starvation of the fuel system. A factor involved was inadequate in-flight planning/decision.
- [NTSB CHI96LA349](https://openairdocs.org/ntsb/CHI96LA349.md): Avian Balloon Magnum IX · Stilwell, KS · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1996 · N2006W · No damage
  > the pilot's not maintaining adequate clearance from a tree, and his allowing an abrupt touchdown. Factors relating to the accident were: dusk and the proximity of tree(s).
- [NTSB LAX96LA341](https://openairdocs.org/ntsb/LAX96LA341.md): Beech V35A-TC · Santa Ynez, CA · Accident · No injuries · Limited investigation · Final report · Sep 21, 1996 · N7956M · Substantial damage
  > failure of a maintenance technician to properly torque the fuel injector lines to three cylinders.
- [NTSB FTW96LA395](https://openairdocs.org/ntsb/FTW96LA395.md): Bell 407 · Kerrville, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 1996 · N1114S · Substantial damage
  > The loss of power due to the pilot's failure to comply with established procedures. Factors were a short in the FADEC wiring harness due to a manufacturing defect, and the lack of suitable terrain for the forced landing.
- [NTSB ANC96LA159](https://openairdocs.org/ntsb/ANC96LA159.md): Pzl-Mielec 104-80 · Aniak, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1996 · N6630M · Substantial damage
  > The pilot's improper glide path on final approach, and his inadequate compensation for the gusty wind conditions. Factors associated with the accident are the gusty winds and a downdraft.
- [NTSB ANC96FA161](https://openairdocs.org/ntsb/ANC96FA161.md): Piper PA-18 · Minto, AK · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1996 · N241WH · Substantial damage
  > the pilot's inadequate compensation for wind conditions, while maneuvering to land, which resulted in inadequate airspeed for conditions, an inadvertent stall, and collision with terrain (water).
- [NTSB LAX96LA345](https://openairdocs.org/ntsb/LAX96LA345.md): Cessna 172F · Ehrenberg, AZ · Accident · No injuries · Limited investigation · Final report · Sep 19, 1996 · N5536T · Substantial damage
  > The pilot's attempt to perform a low altitude evasive maneuver with inadequate airspeed resulting in a stall/mush.
- [NTSB FTW96FA390](https://openairdocs.org/ntsb/FTW96FA390.md): Cessna 320C · Waco, TX · Accident · 1 fatal · Field investigation · Final report · Sep 19, 1996 · N3020T · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident were: inadequate preflight by the pilot, his failure to obtain a weather…
- [NTSB IAD96LA148](https://openairdocs.org/ntsb/IAD96LA148.md): Bellanca BL-26 · Bowling Green, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1996 · N66PG · Substantial damage
  > the pilot's improper fuel consumption calculations and fuel exhaustion, which resulted in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB IAD96FA147](https://openairdocs.org/ntsb/IAD96FA147.md): Short Brothers SC7 · Findlay Twnshp, PA · Accident · No injuries · Field investigation · Final report · Sep 17, 1996 · N10DA · Destroyed
  > The pilot's improper in-flight decision to continue to his destination when known en route delays were encountered which resulted in fuel exhaustion.
- [NTSB NYC96LA184](https://openairdocs.org/ntsb/NYC96LA184.md): Cessna 172N · Shirley, NY · Accident · No injuries · Limited investigation · Final report · Sep 16, 1996 · N737GJ · Substantial damage
  > the pilot's prematurely retraction of flaps during the go-around, which resulted in settling (mushing) of the airplane and a collision with the ground.
- [NTSB ATL96LA127](https://openairdocs.org/ntsb/ATL96LA127.md): Beech 33 · West Palm Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1996 · N108VW · Substantial damage
  > The maintenance personnel failure to properly inspect the fuel system during the last annual inspection.
- [NTSB CHI96LA336](https://openairdocs.org/ntsb/CHI96LA336.md): Kenoyer Horizon ONE · Owosso, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 1996 · N1153X · Destroyed
  > the pilot's failure to maintain aircraft control and airspeed. A factor was the pilot's lack of experience in type of aircraft.
- [NTSB LAX96LA330](https://openairdocs.org/ntsb/LAX96LA330.md): Burkhart Grob G102 · Warner Springs, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1996 · N3950B · Substantial damage
  > improper planning/decision by the pilot concerning a low altitude release to return to the airport after takeoff. Factors relating to the accident were: the pilot's inadequate preflight by failing to ensure that the yaw indicator string movement was free,…
- [NTSB LAX96LA331](https://openairdocs.org/ntsb/LAX96LA331.md): Piper PA-28R-200 · Oxnard, CA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1996 · N41331 · Substantial damage
  > the instructor's inadequate supervision of the flight, and his delay in taking the controls and initiating a go-around. The student pilot's failure to maintain runway alignment and the proximity of the runway remaining marker were related factors.
- [NTSB IAD96LA142](https://openairdocs.org/ntsb/IAD96LA142.md): Schweizer SGS-1-26E · Elmira, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1996 · N1142S · Substantial damage
  > the pilot's failure to maintain adequate altitude and airspeed during the landing approach, resulting in a stall/spin and subsequent encounter with an embankment.
- [NTSB LAX96LA323](https://openairdocs.org/ntsb/LAX96LA323.md): Cessna T210L · Globe, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1996 · N2059S · Substantial damage
  > fuel starvation due to the pilot's inadequate preflight inspection and improper fuel tank selection.
- [NTSB SEA96FA201](https://openairdocs.org/ntsb/SEA96FA201.md): Beech D50 · Seattle, WA · Accident · 1 fatal · Field investigation · Final report · Aug 24, 1996 · N567SF · Substantial damage
  > failure of the pilot to follow proper emergency procedures (properly configure the airplane and feather the appropriate propeller) after loosing power in one engine, which resulted in his inability to maintain altitude until reaching an airport. Factors…
- [NTSB NYC96LA172](https://openairdocs.org/ntsb/NYC96LA172.md): Pzl-Bielsko SZD-59 · Franconia, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1996 · N591SZ · Substantial damage
  > The pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.
- [NTSB FTW96LA402](https://openairdocs.org/ntsb/FTW96LA402.md): Cessna TR182 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Aug 24, 1996 · N757QT · Substantial damage
  > failure of the generator control unit (GCU), which resulted in a total electrical failure and failure of the main landing gear to lock in place.
- [NTSB ANC96LA128](https://openairdocs.org/ntsb/ANC96LA128.md): Champion 7GCBC · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1996 · N5267X · Substantial damage
  > the pilot's delayed in initiating a go-around, and his failure to maintain clearance from trees. The high/fast approach for landing was a related factor.
- [NTSB NYC96IA169](https://openairdocs.org/ntsb/NYC96IA169.md): Boeing 727-232 · Howard Beach, NY · Incident · No injuries · Incident investigation · Final report · Aug 16, 1996 · N24343 · Minor damage
  > fatigue failure of the fore flap attachment fitting, due to grinding marks on the fitting.
- [NTSB ANC96LA125](https://openairdocs.org/ntsb/ANC96LA125.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Aug 16, 1996 · N9272D · Substantial damage
  > the pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.
- [NTSB NYC96FA163](https://openairdocs.org/ntsb/NYC96FA163.md): Beech A36 · Roanoke, VA · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1996 · N1795W · Destroyed
  > the pilot's failure to follow the published instrument approach procedures, and his delayed missed approach, which resulted in an inflight collision with mountainous terrain.
- [NTSB FTW96FA339](https://openairdocs.org/ntsb/FTW96FA339.md): Beech 23 · Wimberley, TX · Accident · 1 fatal · Field investigation · Final report · Aug 11, 1996 · N2382Z · Destroyed
  > The pilot's failure to maintain airspeed. Factors were the high density altitude, the tail wind, and the pilot's failure to adhere to the limitations prescribed by his flight instructor.
- [NTSB CHI96LA285](https://openairdocs.org/ntsb/CHI96LA285.md): Ramesbotham CH701 · N. Sioux City, SD · Accident · No injuries · Limited investigation · Final report · Aug 11, 1996 · N4053G · Substantial damage
  > the pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.
- [NTSB FTW96LA340](https://openairdocs.org/ntsb/FTW96LA340.md): Maule M-4-210C · Hudson, CO · Accident · No injuries · Limited investigation · Final report · Aug 10, 1996 · N9862M · Destroyed
  > the pilot's delay in initiating a go-around and failure to attain sufficient airspeed to clear obstructions at the departure end of the runway, which resulted in an inadvertent stall and collision with the ground. Factors relating to the accident were: the…
- [NTSB CHI96LA289](https://openairdocs.org/ntsb/CHI96LA289.md): Mrotek Minicab GY20 · Albion, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1996 · N263AM · Substantial damage
  > the pilot's misjudgment of distance and altitude during the approach to land, and his failure to attain the proper touchdown point. Factors relating to the accident were: the uneven and uphill terrain conditions at the approach end of the airstrip.
- [NTSB LAX96LA302](https://openairdocs.org/ntsb/LAX96LA302.md): Beech B23 · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Aug 9, 1996 · N6087N · Destroyed
  > fuel starvation due to the pilot's inadequate fuel management and failure to reposition the fuel selector to a tank containing adequate fuel. The power lines were a factor.
- [NTSB ANC96LA121](https://openairdocs.org/ntsb/ANC96LA121.md): Piper PA-18 · Arctic Village, AK · Accident · No injuries · Limited investigation · Final report · Aug 8, 1996 · N9730P · Substantial damage
  > The airplane's low airspeed during final approach, and the pilot's delayed remedial action in correcting the low airspeed condition.
- [NTSB CHI96LA276](https://openairdocs.org/ntsb/CHI96LA276.md): Piper PA-22 · Flushing, MI · Accident · No injuries · Limited investigation · Final report · Aug 7, 1996 · N7245D · Substantial damage
  > fuel exhaustion caused by the failure of the pilot to select a fuel tank with fuel remaining.

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

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

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