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

## Cases, newest first

- [NTSB FTW97FA299](https://openairdocs.org/ntsb/FTW97FA299.md): Beech 58P · Colorado Spring, CO · Accident · 2 fatal · Field investigation · Final report · Aug 5, 1997 · N258W · Destroyed
  > failure of the pilot to follow IFR procedures; and his failure to maintain proper altitude, while executing a missed approach from an attempted ILS approach. Related factors included: low ceiling, rain, fog, the pilot's overconfidence in his personal ability,…
- [NTSB NYC97LA160](https://openairdocs.org/ntsb/NYC97LA160.md): Piper PA-28R-200 · Ashland, OH · Accident · No injuries · Limited investigation · Final report · Aug 4, 1997 · N33341 · Substantial damage
  > The pilot's improper fuel management which resulted in fuel exhaustion and loss of engine power.
- [NTSB CHI97FA252](https://openairdocs.org/ntsb/CHI97FA252.md): Beech 76 · New Richmond, WI · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1997 · N18960 · Destroyed
  > The certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.
- [NTSB SEA97FA181](https://openairdocs.org/ntsb/SEA97FA181.md): Avian Magnum IX · Donald, OR · Accident · 1 fatal · Field investigation · Final report · Aug 3, 1997 · N20146 · Substantial damage
  > The pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.
- [NTSB FTW97LA301](https://openairdocs.org/ntsb/FTW97LA301.md): Beech C23 · Terlingua, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1997 · N2146W · Substantial damage
  > The inadvertent stall by the pilot-in-command. A factor was the sudden wind shift.
- [NTSB LAX97LA269](https://openairdocs.org/ntsb/LAX97LA269.md): Mitteer Mini 500 · Agua Dulce, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 1997 · N501GM · Substantial damage
  > failure of the owner/builder to obtain and comply with service literature from the kit manufacturer, which resulted in improper setting of the carburetor fuel mixture and led to loss of engine power. An additional cause was the pilot's failure to successfully…
- [NTSB CHI97LA230](https://openairdocs.org/ntsb/CHI97LA230.md): Jenkins RV-6 · Middleton, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1997 · N126JM · Substantial damage
  > the pilot was too low on final approach and hit the high vegetation.
- [NTSB CHI97LA227](https://openairdocs.org/ntsb/CHI97LA227.md): Kearns RV-6 · Harrisburg, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1997 · N35K · Substantial damage
  > The pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.
- [NTSB ANC97LA109](https://openairdocs.org/ntsb/ANC97LA109.md): Cessna 208 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Jul 22, 1997 · N9481F · Substantial damage
  > The pilots decision to continue the landing into adverse weather conditions and failure to maintain runway alignmet. A factor was the rain shower which resulted in reduced forward visibility.
- [NTSB CHI97LA215](https://openairdocs.org/ntsb/CHI97LA215.md): Cessna 182 · Chippewa Falls, WI · Accident · No injuries · Limited investigation · Final report · Jul 20, 1997 · N5820B · Substantial damage
  > the pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.
- [NTSB FTW97LA272](https://openairdocs.org/ntsb/FTW97LA272.md): Beech C35 · Chickasha, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1997 · N1878D · Substantial damage
  > the pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.
- [NTSB SEA97LA162](https://openairdocs.org/ntsb/SEA97LA162.md): Cessna 320E · W. Yellowstone, MT · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1997 · N3425Q · Substantial damage
  > The pilot's failure to maintain directional control during landing when asymmetric power was applied. A factor was the crosswind conditions.
- [NTSB LAX97FA253](https://openairdocs.org/ntsb/LAX97FA253.md): Mooney M20J · Placerville, CA · Accident · 2 fatal · Field investigation · Final report · Jul 18, 1997 · N405LA · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB LAX97IA243](https://openairdocs.org/ntsb/LAX97IA243.md): Boeing 737-522 · Ontario, CA · Incident · No injuries · Incident investigation · Final report · Jul 15, 1997 · N956UA · No damage
  > a laser light source of undetermined origin directed toward the cockpit window of an aircraft in-flight by a person or persons unknown.
- [NTSB LAX97FA241](https://openairdocs.org/ntsb/LAX97FA241.md): Cessna TR182 · Panamint Spring, CA · Accident · 3 fatal · Field investigation · Final report · Jul 15, 1997 · N757CF · Destroyed
  > failure of the pilot to attain a proper touchdown point for landing, and his delay in initiating a go-around. Factors relating to the accident were: the pilot's attempt to land at the wrong airport, uphill slope of the runway, high density altitude, and…
- [NTSB SEA97LA168](https://openairdocs.org/ntsb/SEA97LA168.md): Bell 47G-3B · Idaho Falls, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1997 · N8494E · Substantial damage
  > The pilot mismanaged his fuel supply which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the lack of adequate altitude and airspeed to successfully execute an autorotation.
- [NTSB ATL97LA103](https://openairdocs.org/ntsb/ATL97LA103.md): Hughes 269C · Johnston, SC · Accident · No injuries · Limited investigation · Final report · Jul 13, 1997 · N7413F · Substantial damage
  > failure of the pilot to maintain the proper rotor RPM during the approach and flare for landing.
- [NTSB CHI97IA212](https://openairdocs.org/ntsb/CHI97IA212.md): McDonnell Douglas DC-9-15 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Jul 12, 1997 · N9348 · No damage
  > the spoiler cable was misrouted by unknown maintenance personnel.
- [NTSB SEA97LA165](https://openairdocs.org/ntsb/SEA97LA165.md): Young Turbo Cruiser · Milford, UT · Accident · No injuries · Limited investigation · Final report · Jul 9, 1997 · N6626W · Substantial damage
  > Loss of engine power due to fuel starvation. Factors include the pilot's fuel consumption calculations based upon insufficient or erroneous information provided by the amateur-built airplane's builder and previous owner, and terrain conditions not suitable…
- [NTSB NYC97LA136](https://openairdocs.org/ntsb/NYC97LA136.md): Cessna 172P · Wildwood, NJ · Accident · No injuries · Limited investigation · Final report · Jul 6, 1997 · N97011 · Substantial damage
  > The pilot's inadequate use of carburetor heat, which resulted in carburetor icing.
- [NTSB NYC97LA135](https://openairdocs.org/ntsb/NYC97LA135.md): Cessna 182B · Medford, NJ · Accident · No injuries · Limited investigation · Final report · Jul 6, 1997 · N166KM · Destroyed
  > An inflight engine fire of undetermined origin.
- [NTSB CHI97TA198](https://openairdocs.org/ntsb/CHI97TA198.md): Cessna 182R · Peoria, IL · Accident · Minor injuries · Final report · Jul 6, 1997 · N661SP · Substantial damage
  > the pilot's improper use of carburetor heat and the carburetor icing conditions which existed at the time of the accident. Factors were the ditch and poles which the airplane contacted.
- [NTSB MIA97LA205](https://openairdocs.org/ntsb/MIA97LA205.md): Bellanca 7ECA · Mooresville, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1997 · N7636S · Substantial damage
  > The pilot's failure to obtain the proper touchdown point on landing resulting in a go-around, and a subsequent in-flight collision with trees and terrain.
- [NTSB IAD97LA096](https://openairdocs.org/ntsb/IAD97LA096.md): Piper PA-23-160 · Hampton, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1997 · N4022P · Substantial damage
  > The pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.
- [NTSB FTW97FA249](https://openairdocs.org/ntsb/FTW97FA249.md): Schempp-Hirth VENTUS-2B · Hobbs, NM · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1997 · N80077 · Destroyed
  > The pilot's failure to select an off-field landing site with sufficient time/altitude to perform the landing which led to his failure to maintain airspeed. A factor was the unfavorable wind.
- [NTSB NYC97LA134](https://openairdocs.org/ntsb/NYC97LA134.md): Martin Velocity RG · Montauk, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1997 · N280DM · Substantial damage
  > The pilot's failure to maintain directional control and his inadequate compensation for wind conditions.
- [NTSB LAX97LA238](https://openairdocs.org/ntsb/LAX97LA238.md): Bellanca 17-30 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jul 4, 1997 · N70EC · Substantial damage
  > The pilot's improper placement of the unmarked fuel selector valve to off which resulted in fuel starvation. A factor in the accident was the pilot's lack of total experience in this model aircraft.
- [NTSB CHI97LA201](https://openairdocs.org/ntsb/CHI97LA201.md): Weber RV-4 · Hermann, MO · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1997 · N1142J · Substantial damage
  > the pilot's inadequate in-flight planning/decision and encounter with a stall. Related factors were the chafed throttle cable, which became jammed; and failure of the pilot to perform an engine shut down in order to land on the runway.
- [NTSB ANC97FA097](https://openairdocs.org/ntsb/ANC97FA097.md): Piper PA-32 · Skagway, AK · Accident · 4 fatal · Field investigation · Final report · Jul 4, 1997 · N15199 · Destroyed
  > jamming/failure of the left magneto impulse coupling, which stopped rotation of the magneto gear, and resulted in subsequent shearing of the accessory intermediate idler gear. Factors relating to the accident were: the lack of suitable terrain for a forced…
- [NTSB MIA97LA203](https://openairdocs.org/ntsb/MIA97LA203.md): Cessna A185F · Bay St. Louis, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1997 · N5054R · Substantial damage
  > The pilot's improper short field landing procedure and use of full flaps prior to being assured of reaching the proper touchdown point, resulting in an in-flight collision with an embankment, and subsequent nose over. Contributing to the accident was a total…
- [NTSB MIA97LA200](https://openairdocs.org/ntsb/MIA97LA200.md): Cessna 150F · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Jul 2, 1997 · N8083S · Substantial damage
  > the student pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in an on-ground loss of control and subsequent collision with trees and a ditch. The crosswind, trees, and ditch were related factors.
- [NTSB NYC97LA133](https://openairdocs.org/ntsb/NYC97LA133.md): Beech C24R · Old Bridge, NJ · Accident · No injuries · Limited investigation · Final report · Jul 1, 1997 · N5156M · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB ATL97LA094](https://openairdocs.org/ntsb/ATL97LA094.md): Maule MX-7-180C · Dyersburg, TN · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1997 · N71VF · Substantial damage
  > the pilot's improper planning/decision and failure to insure the that airplane would remain clear of trees during the go-around. Factors relating to the accident included: the high temperature, high density altitude, and the proximity of trees.
- [NTSB LAX97LA226](https://openairdocs.org/ntsb/LAX97LA226.md): Cessna 182C · Rimrock, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 1997 · N5158U · Substantial damage
  > Fuel starvation due to the pilot's failure to monitor the fuel level in the right tank, and to select a tank containing fuel during the approach and landing in accordance with the checklist.
- [NTSB ATL97FA090](https://openairdocs.org/ntsb/ATL97FA090.md): Beech 35-C33A · Lugoff, SC · Accident · 1 fatal · Field investigation · Final report · Jun 28, 1997 · N4863J · Substantial damage
  > improper fuel management by the pilot by not positioning the fuel selector to the fullest tank for landing, which resulted in fuel starvation, loss of engine power, and a forced landing. Trees in the emergency landing area were a factor.
- [NTSB ANC97TA095](https://openairdocs.org/ntsb/ANC97TA095.md): Piper PA-18-180 · Tok, AK · Accident · No injuries · Final report · Jun 27, 1997 · N3685Z · Substantial damage
  > The second pilot/dual student's failure to maintain a proper glidepath, and the pilot-in-command/flight instructor's inadequate supervision. A factor associated with the accident was a downdraft.
- [NTSB CHI97FA188](https://openairdocs.org/ntsb/CHI97FA188.md): Cessna 172N · Canton, MI · Accident · Serious injuries · Field investigation · Final report · Jun 26, 1997 · N7031Q · Substantial damage
  > A loss of engine power due to fuel starvation from a binding throttle/power lever cable. Also causal was the improper maintenance, installation of the throttle arm. Contributing to the accident were the dark night and unsuitable terrain for the forced landing.
- [NTSB CHI97LA175](https://openairdocs.org/ntsb/CHI97LA175.md): Beech C23 · Wamego, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1997 · N6535R · Substantial damage
  > inaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.
- [NTSB SEA97LA145](https://openairdocs.org/ntsb/SEA97LA145.md): Ross/Stonecipher Vans RV-6 · Woods Cross, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1997 · N345JE · Substantial damage
  > a bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.
- [NTSB LAX97LA218](https://openairdocs.org/ntsb/LAX97LA218.md): Hughes 369HS · Pacific Ocean (Pacific Ocean) · Accident · 1 fatal · Limited investigation · Final report · Jun 20, 1997 · N4250N · Destroyed
  > The unapproved field modification of the cyclic trim switch, including the use of non-standard parts, which resulted in a hard-over lateral trim failure, and the pilot's subsequent failure to maintain control of the helicopter during a landing approach. A…
- [NTSB NYC97IA123](https://openairdocs.org/ntsb/NYC97IA123.md): Beech 1900D · Clarksburg, WV · Incident · No injuries · Incident investigation · Final report · Jun 19, 1997 · N165YV · Minor damage
  > The right outboard flap detaching from the flap aft roller bearings, at the flap track, which was a result of the manufacturer's inadequate inspection program.
- [NTSB CHI97LA172](https://openairdocs.org/ntsb/CHI97LA172.md): Cessna 150K · Ypsilanti, MI · Accident · No injuries · Limited investigation · Final report · Jun 19, 1997 · N5738G · Substantial damage
  > the pilot's failure to use carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Factors relating to this accident were: the icing (weather) condition and sign(s) in the emergency landing area.
- [NTSB CHI97LA171](https://openairdocs.org/ntsb/CHI97LA171.md): Roe-Wayne Mustang II · Portage, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 1997 · N11WJ · Destroyed
  > inadequate fuel system design by the owner/builder, which led to fuel starvation as the airplane was on a 'flat' approach to land. The pilot's inadequate flight planning was a factor, in that he did not fly the traffic pattern of this first test flight, in a…
- [NTSB LAX97LA215](https://openairdocs.org/ntsb/LAX97LA215.md): Schempp-Hirth Nimbus 3/24.5 · Macdoel, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1997 · N4427M · Substantial damage
  > the pilot's failure to see and avoid a set of power lines while making an off-airport landing due to a lack of lift.
- [NTSB LAX97LA214](https://openairdocs.org/ntsb/LAX97LA214.md): Cessna 150 · Jean, NV · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1997 · N22406 · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's failure to retract the flaps during the go-around.
- [NTSB MIA97LA184](https://openairdocs.org/ntsb/MIA97LA184.md): Cessna 150G · Greer, SC · Accident · No injuries · Limited investigation · Final report · Jun 15, 1997 · N2276J · Substantial damage
  > the student pilot's improper management of fuel, which resulted in fuel exhaustion, loss of engine power, and subsequent collision with trees and terrain.
- [NTSB LAX97LA211](https://openairdocs.org/ntsb/LAX97LA211.md): Maule M-4-220C · Gualala, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1997 · N40654 · Destroyed
  > continued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from tall trees. The weather conditions (low ceiling and fog) were related factors.
- [NTSB NYC97LA119](https://openairdocs.org/ntsb/NYC97LA119.md): Enstrom F-280C · Sharon, VT · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1997 · N5700J · Substantial damage
  > The pilot's improper decision to descend and fly at 100 feet over a river and his failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with wires.
- [NTSB FTW97LA224](https://openairdocs.org/ntsb/FTW97LA224.md): Aero Commander 200D · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Jun 13, 1997 · N898LF · Substantial damage
  > a loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.
- [NTSB SEA97FA130](https://openairdocs.org/ntsb/SEA97FA130.md): Lockheed P-38L · Tillamook, OR · Accident · 1 fatal · Field investigation · Final report · Jun 7, 1997 · N7973 · Destroyed
  > failure of the pilot to maintain minimum control speed (VMC), after loss of power in one engine, which resulted in a loss of aircraft control and collision with terrain. Related factors were: the pilot's improper fuel management and failure to change the fuel…

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

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

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