# 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 123 of 420 · 20,996 cases

## Cases, newest first

- [NTSB MIA96LA172](https://openairdocs.org/ntsb/MIA96LA172.md): Charles Raymond Glasair 2SFT · Apalachicola, FL · Accident · No injuries · Limited investigation · Final report · Jun 30, 1996 · N16CD · Substantial damage
  > Inadequate application of throttle input and up elevator input by the pilot-in-command. Contributing to the accident was the in-flight encounter with a downdraft and inadequate design of the airplane by the kit manufacturer.
- [NTSB LAX96LA255](https://openairdocs.org/ntsb/LAX96LA255.md): Cessna 172 · Frazier Park, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1996 · N6819H · Substantial damage
  > the failure of the pilot to maintain terrain clearance after a misjudged approach and landing that necessitated a go-around and subsequent collision with some wires. Factors were high density altitude and an inadequate evaluation by the pilot-in-command of…
- [NTSB LAX96LA254](https://openairdocs.org/ntsb/LAX96LA254.md): Gray Berkut · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1996 · N260DG · Destroyed
  > Loss of engine power during final approach for undetermined reasons. A factor in the accident was the nature of the terrain for the forced landing.
- [NTSB LAX96LA252](https://openairdocs.org/ntsb/LAX96LA252.md): Cessna 402A · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Jun 29, 1996 · N13GM · Substantial damage
  > Failure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.
- [NTSB ATL96LA097](https://openairdocs.org/ntsb/ATL96LA097.md): Cessna 140 · Jacksboro, TN · Accident · No injuries · Limited investigation · Final report · Jun 29, 1996 · N72438 · Substantial damage
  > loss of engine power for undetermined reason(s), which resutled in a forced landing and subsequent in-flight collision with trees and the terrain.
- [NTSB MIA96FA165](https://openairdocs.org/ntsb/MIA96FA165.md): Beech P35 · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Jun 24, 1996 · N1527S · Destroyed
  > the pilot's improper procedure by not placing the fuel selector on the tank with the most fuel.
- [NTSB SEA96LA160](https://openairdocs.org/ntsb/SEA96LA160.md): Cessna 182A · Toledo, WA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1996 · N9975B · Substantial damage
  > loss of engine power for undetermined reason(s). Factors relating to the accident were: the pilot's need to maneuvering to avoid obstructions near the approach end of the runway, and a ditch in the emergency landing area.
- [NTSB FTW96FA268](https://openairdocs.org/ntsb/FTW96FA268.md): Jones Peckerwood 1A1 · La Porte, TX · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1996 · N92506 · Destroyed
  > improper installation and subsequent failure of the elevator control cable clamps which led to the pilot's restricted pitch control and resultant stall/spin.
- [NTSB IAD96FA100](https://openairdocs.org/ntsb/IAD96FA100.md): Piper PA-31-325 · Springboro, OH · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1996 · N62852 · Destroyed
  > the pilot's impairment of judgment and performance due to drugs which led to spatial disorientation and a loss of aircraft control. The weather was a factor.
- [NTSB SEA96LA124](https://openairdocs.org/ntsb/SEA96LA124.md): Cessna 177B · Gardiner, WA · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1996 · N1159C · Substantial damage
  > the pilot's inadequate compensation for wind conditions and failure to maintain the proper altitude/clearance from obstruction(s), while on final approach. Factors relating to the accident were: the downdraft, and the obstruction (tree).
- [NTSB SEA96LA123](https://openairdocs.org/ntsb/SEA96LA123.md): Cessna 182 · Roche Harbor, WA · Accident · No injuries · Limited investigation · Final report · Jun 16, 1996 · N5686B · Destroyed
  > the pilot's inadequate compensation for wind conditions and failure to attain a proper touchdown point for landing. Factors relating to the accident were: downdraft conditions and soft/uneven terrain short of the runway.
- [NTSB SEA96LA125](https://openairdocs.org/ntsb/SEA96LA125.md): Piper PA-24-250 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N6554P · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point for landing. A factor relating to the accident was: upsloping terrain short of the threshold.
- [NTSB FTW96LA249](https://openairdocs.org/ntsb/FTW96LA249.md): American General AG-5B · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N115JE · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Darkness was a related factor.
- [NTSB LAX96LA231](https://openairdocs.org/ntsb/LAX96LA231.md): Vans RV6 · Inyokern, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1996 · N43BL · Destroyed
  > the pilot's failure to maintain control of his airplane and stalled while intentionally performing a low altitude maneuver on base leg in a high density altitude environment.
- [NTSB CHI96LA202](https://openairdocs.org/ntsb/CHI96LA202.md): Piper PA-44 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Jun 14, 1996 · N853ND · Substantial damage
  > the instructor pilot used an improper procedure when he demonstrated a rejected takeoff and he misjudged the flare.
- [NTSB ATL96LA091](https://openairdocs.org/ntsb/ATL96LA091.md): Grumman American AA-1C · Gulfport, MS · Accident · No injuries · Limited investigation · Final report · Jun 12, 1996 · N39018 · Substantial damage
  > improper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.
- [NTSB CHI96LA193](https://openairdocs.org/ntsb/CHI96LA193.md): Cessna 172 · Lowell, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 1996 · N1106F · Substantial damage
  > was inadequate initial training of the pilot and inadequate flight test procedures by the FAA Designated Pilot Examiner when he reportedly had the pilot demonstrate 12 pilot operations from the FAA's practical flight test standards in 35 minutes during the…
- [NTSB DCA96IA061](https://openairdocs.org/ntsb/DCA96IA061.md): Boeing B-737-201 · Richmond, VA · Incident · No injuries · Incident investigation · Final report · Jun 10, 1996 · N221US · No damage
  > The yaw/roll upset of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…
- [NTSB SEA96LA117](https://openairdocs.org/ntsb/SEA96LA117.md): Head Pitts S-1C · Everett, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1996 · N7BH · Substantial damage
  > the pilot's inadequate fuel management, which resulted in fuel starvation. The aircraft's lack of a fuel quantity gauge and trees in the forced landing area were related factors.
- [NTSB FTW96LA242](https://openairdocs.org/ntsb/FTW96LA242.md): Aerostar S-60A · San Angelo, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 1996 · N63286 · Minor damage
  > failure of the pilot to maintain altitude or clearance from a tree, during an approach to land in a field.
- [NTSB SEA96LA116](https://openairdocs.org/ntsb/SEA96LA116.md): Cessna 172L · Sisters, OR · Accident · No injuries · Limited investigation · Final report · Jun 8, 1996 · N7849G · Substantial damage
  > the pilot's inadequate compensation for wind conditions during a go-around, which resulted in his failure to maintain proper runway alignment. Factors relating to the accident were: the variable/gusty crosswind condition, and the proximity of the hanger and…
- [NTSB LAX96LA224](https://openairdocs.org/ntsb/LAX96LA224.md): Robinson R22 Beta · Santa Clarita, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1996 · N40009 · Substantial damage
  > the pilot's failure to abandon the pinnacle approach after encountering an excessive rate of descent.
- [NTSB LAX96FA226](https://openairdocs.org/ntsb/LAX96FA226.md): Piper PA-32R-300 · Goleta, CA · Accident · 2 fatal · Field investigation · Final report · Jun 7, 1996 · N4303X · Destroyed
  > failure of the flying pilot to maintain control of the airplane, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the water. Factors relating to the accident were: the lack of recent instrument experience by the…
- [NTSB SEA96LA111](https://openairdocs.org/ntsb/SEA96LA111.md): Grumman American AA-1B · Coquille, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1996 · N9875L · Substantial damage
  > the pilot's inadequate evaluation of wind conditions, and his subsequent failure to initiate a go-around in a timely manner, which resulted in his inability to maintain clearance with trees during the go-around. Factors relating to the accident included a…
- [NTSB IAD96LA091](https://openairdocs.org/ntsb/IAD96LA091.md): Piper PA-24-180 · New Carlisle, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1996 · N5984P · Substantial damage
  > inadequate maintenance and inspection, and the pilot overshooting the approach to land.
- [NTSB FTW96IA237](https://openairdocs.org/ntsb/FTW96IA237.md): McDonnell Douglas DC-9-82 (MD-82) · Albuquerque, NM · Incident · Minor injuries · Incident investigation · Final report · Jun 5, 1996 · N224AA · Minor damage
  > the flightcrew's inadvertent encounter with windshear at low altitude. Factors were: variable winds, high density altitude, and the FAA's inadequate location/height of the LLWAS sensor.
- [NTSB LAX96LA217](https://openairdocs.org/ntsb/LAX96LA217.md): Hughes 269B · Georgetown, CA · Accident · No injuries · Limited investigation · Final report · Jun 1, 1996 · N9332F · Substantial damage
  > loss of engine power for undetermined reason(s), while practicing an autorotation, which resulted in a forced landing; and the flight instructor's misjudged landing flare during the emergency autorotation/landing.
- [NTSB FTW96FA234](https://openairdocs.org/ntsb/FTW96FA234.md): Fairchild KR-31 · Bartlesville, OK · Accident · 4 fatal · Field investigation · Final report · Jun 1, 1996 · N7780 · 2 aircraft · Destroyed
  > The failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…
- [NTSB SEA96LA105](https://openairdocs.org/ntsb/SEA96LA105.md): Cessna 140 · Puyallup, WA · Accident · Minor injuries · Limited investigation · Final report · May 31, 1996 · N72344 · Substantial damage
  > the pilot's improper recovery from a bounced landing, and failure to maintain runway alignment during a go-around. The pilot's improper flare for landing was a related factor.
- [NTSB MIA96LA147](https://openairdocs.org/ntsb/MIA96LA147.md): Piper PA-28-140 · Barbour Island, GA · Accident · No injuries · Limited investigation · Final report · May 31, 1996 · N6351W · Substantial damage
  > the pilot's failure to adequately compensate for gusty wind conditions.
- [NTSB ATL96LA089](https://openairdocs.org/ntsb/ATL96LA089.md): Schweizer SGS233A · Franklinton, NC · Accident · No injuries · Limited investigation · Final report · May 30, 1996 · N1197S · Substantial damage
  > the failure of the instructor pilot to maintain control of the aircraft.
- [NTSB LAX96LA205](https://openairdocs.org/ntsb/LAX96LA205.md): Cessna 150M · Los Banos, CA · Accident · Minor injuries · Limited investigation · Final report · May 26, 1996 · N66392 · Substantial damage
  > fuel exhaustion due to the pilot's improper in-flight decision to utilize a high engine power setting which reduced the airplane's endurance, and the pilot's inadequate fuel consumption calculations.
- [NTSB FTW96LA229](https://openairdocs.org/ntsb/FTW96LA229.md): Bell 47J · Lakeway, TX · Accident · No injuries · Limited investigation · Final report · May 26, 1996 · N8412E · Substantial damage
  > The pilot's failure to maintain a proper descent rate prior to landing.
- [NTSB CHI96FA172](https://openairdocs.org/ntsb/CHI96FA172.md): Cessna 152 · Mount Pleasant, MI · Accident · 2 fatal · Field investigation · Final report · May 26, 1996 · N68610 · Destroyed
  > loss of aircraft control by the pilot, due to cardiac arrest (heart attack).
- [NTSB CHI96LA176](https://openairdocs.org/ntsb/CHI96LA176.md): Merlin GT · Charlotte, MI · Accident · No injuries · Limited investigation · Final report · May 25, 1996 · N68EV · Substantial damage
  > the pilot's failure to maintain airspeed. A factor was the pilot's lack of experience in the airplane.
- [NTSB MIA96LA143](https://openairdocs.org/ntsb/MIA96LA143.md): Cessna 172D · Vilarica, GA · Accident · Minor injuries · Limited investigation · Final report · May 20, 1996 · N2814U · Substantial damage
  > The student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's improper use of flaps.
- [NTSB FTW96LA218](https://openairdocs.org/ntsb/FTW96LA218.md): Maule MX-7-160 · Belcher, LA · Accident · Minor injuries · Limited investigation · Final report · May 18, 1996 · N35TX · Substantial damage
  > The pilot's failure to maintain aircraft control in flight. A factor was the gusty wind.
- [NTSB ANC96FA072](https://openairdocs.org/ntsb/ANC96FA072.md): McDonnell Douglas MD-11-F · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · May 16, 1996 · N614FE · Substantial damage
  > the pilot's improper in-flight planning/decision, which allowed the airplane (MD-11) to encounter wake turbulence from a larger/heavy jet airplane (Boeing 747), while on a short final approach for landing on a close-by/parallel runway with a staggered…
- [NTSB CHI96LA156](https://openairdocs.org/ntsb/CHI96LA156.md): Cessna 172N · Crystal Lake, IL · Accident · Minor injuries · Limited investigation · Final report · May 13, 1996 · N738CS · Substantial damage
  > the pilot not flying a proper glidepath for the displaced runway threshold.
- [NTSB CHI96LA158](https://openairdocs.org/ntsb/CHI96LA158.md): Bellanca 17-30 · Springfield, MO · Accident · Serious injuries · Limited investigation · Final report · May 12, 1996 · N6668V · Substantial damage
  > a total loss of power due to the pilot's inadequate preflight planning and preparation and subsequent fuel exhaustion. A factor was the pilot's lack of experience in the airplane.
- [NTSB NYC96LA104](https://openairdocs.org/ntsb/NYC96LA104.md): Schweizer SGS-2-33A · Readington, NJ · Accident · Serious injuries · Limited investigation · Final report · May 11, 1996 · N17957 · Substantial damage
  > the pilot's inadequate evaluation of the weather, and his misjudgment of altitude and distance from the runway. Contributing factors were the pilot's lack of recent experience and the weather.
- [NTSB SEA96LA091](https://openairdocs.org/ntsb/SEA96LA091.md): Limes Challenger II · Redmond, OR · Accident · No injuries · Limited investigation · Final report · May 10, 1996 · N52898 · Substantial damage
  > the pilot's misjudgment of distance and altitude on final approach, and his failure to maintain proper clearance from an object (fence) in his approach path. The fence was a related factor.
- [NTSB NYC96LA102](https://openairdocs.org/ntsb/NYC96LA102.md): Beech A36 · Olean, NY · Accident · Minor injuries · Limited investigation · Final report · May 9, 1996 · N65792 · Substantial damage
  > the pilot's improper IFR procedure by not maintaining the minimum descent altitude (MDA) during the ILS localizer approach. Factors relating to the accident were: low ceiling, fog, and weather below minimums for landing.
- [NTSB CHI96FA152](https://openairdocs.org/ntsb/CHI96FA152.md): Cessna 340A · Waukegan, IL · Accident · Serious injuries · Field investigation · Final report · May 8, 1996 · N225BA · Substantial damage
  > the pilot's inability to maintain visual contact with the runway environment due to 'flash blindness' when he turned on the airplane's landing light, and his subsequent inability to regain control of the airplane after turning off the landing light due to his…
- [NTSB LAX96LA192](https://openairdocs.org/ntsb/LAX96LA192.md): Cessna 172P · Reno, NV · Accident · No injuries · Limited investigation · Final report · May 7, 1996 · N5394K · Substantial damage
  > the pilot's failure to obtain and maintain flying speed and a proper glide path, which resulted in an inadvertent stall during a visual approach. An increased altitude illusion created by rising terrain under the final approach course was a factor.
- [NTSB NYC96LA100](https://openairdocs.org/ntsb/NYC96LA100.md): Cessna P206D · Harrison, NY · Accident · No injuries · Limited investigation · Final report · May 5, 1996 · N8744Z · Substantial damage
  > separation of the number one connecting rod bolt, which resulted in a total loss of engine power.
- [NTSB NYC96LA098](https://openairdocs.org/ntsb/NYC96LA098.md): Piper PA-28-180 · Bath, PA · Accident · Serious injuries · Limited investigation · Final report · May 4, 1996 · N9549J · Substantial damage
  > the pilot's improper in-flight decision and planning, and his mismanagement of the fuel supply, which resulted in fuel exhaustion and the loss of engine power. Darkness and low clouds in the emergency landing area were related factors.
- [NTSB LAX96FA189](https://openairdocs.org/ntsb/LAX96FA189.md): Cessna 310D · Los Angeles, CA · Accident · 4 fatal · Field investigation · Final report · May 4, 1996 · N6780T · Destroyed
  > failure of the pilot to maintain aircraft control due to spatial disorientation. Factors were clouds and dark night light conditions, and the pilot's diverted attention due to a landing gear problem.
- [NTSB CHI96LA149](https://openairdocs.org/ntsb/CHI96LA149.md): Deweese Bushby Mustang M-II · Lancaster, WI · Accident · 1 fatal · Limited investigation · Final report · May 4, 1996 · N16JD · Substantial damage
  > failure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin and collison with the terrain. The pilot's use of abrupt maneuvers was a related factor.
- [NTSB NYC96LA097](https://openairdocs.org/ntsb/NYC96LA097.md): Piper PA-22-150 · Chester, NH · Accident · Serious injuries · Limited investigation · Final report · May 3, 1996 · N2946P · Substantial damage
  > The pilot's misjudged distance and altitude during final approach.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.