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

## Cases, newest first

- [NTSB LAX00LA086](https://openairdocs.org/ntsb/LAX00LA086.md): Robinson R44 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Feb 2, 2000 · N999EV · Substantial damage
  > The pilot's failure to use carburetor heat, resulting in a loss of engine power, and, his misjudged autorotation approach that resulted in a collision with the ground during the landing flare. Contributing to the accident was the conditions conducive to…
- [NTSB LAX00LA085](https://openairdocs.org/ntsb/LAX00LA085.md): Siai-Marchetti SF260 · Napa, CA · Accident · No injuries · Limited investigation · Final report · Jan 30, 2000 · N65FD · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.
- [NTSB FTW00LA084](https://openairdocs.org/ntsb/FTW00LA084.md): Mitsubishi MU-300 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Jan 27, 2000 · N900WJ · Substantial damage
  > The diminished effectiveness of the anti-skid brake system due to the slush contaminated runway. Factors were the freezing rain encountered during the approach, coupled with a failure of the horizontal stabilizer heat.
- [NTSB SEA00FA038](https://openairdocs.org/ntsb/SEA00FA038.md): Hughes 269C · Sherwood, OR · Accident · No injuries · Field investigation · Final report · Jan 18, 2000 · N9297F · Substantial damage
  > The pilots failure to arrest the helicopter's descent rate during a planned approach to a hover. Factors include uneven terrain.
- [NTSB NYC00FA067](https://openairdocs.org/ntsb/NYC00FA067.md): Beech C-90 · Somerset, KY · Accident · 4 fatal · Field investigation · Final report · Jan 18, 2000 · N74CC · Destroyed
  > the failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…
- [NTSB FTW00LA066](https://openairdocs.org/ntsb/FTW00LA066.md): Cessna 340A · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Jan 17, 2000 · XBBJU · Substantial damage
  > The hard landing of the aircraft resulting from the pilot's excessive rate of descent on the VFR approach. A factor was the loss of right engine power for an undetermined reason.
- [NTSB CHI00LA058](https://openairdocs.org/ntsb/CHI00LA058.md): Cessna 172M · Liberal, KS · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 2000 · N12654 · Substantial damage
  > the pilot not maintaining proper glidepath on the ILS approach, the pilot's improper decision to continue the approach below the glidepath, and the pilot's failure to perform a missed approach. Factors relating to the accident were the low ceiling and…
- [NTSB NYC00FA064](https://openairdocs.org/ntsb/NYC00FA064.md): Aerostar 601P · Coatesville, PA · Accident · 2 fatal · Field investigation · Final report · Jan 10, 2000 · N905DK · Destroyed
  > The pilot's failure to follow the published instrument approach procedure, and his failure to establish a climb after passing the missed approach point.
- [NTSB LAX00LA070](https://openairdocs.org/ntsb/LAX00LA070.md): Hawker Siddeley Hunter F MK 4 · Chino, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 8, 2000 · N72602 · Substantial damage
  > A loss of engine power for undetermined reasons. A factor was the particulate contamination in the fuel.
- [NTSB NYC00FA063](https://openairdocs.org/ntsb/NYC00FA063.md): Cessna 310N · Old Forge, PA · Accident · 2 fatal · Field investigation · Final report · Jan 6, 2000 · N70CM · Substantial damage
  > Both pilots' failure to adequately manage the fuel supply, which resulted in fuel starvation.
- [NTSB CHI00FA057](https://openairdocs.org/ntsb/CHI00FA057.md): Beech D-95A Travelair · Dunbar, WI · Accident · 1 fatal · Field investigation · Final report · Jan 6, 2000 · N5918S · Destroyed
  > the pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.
- [NTSB LAX00LA071](https://openairdocs.org/ntsb/LAX00LA071.md): Rotorway Exec 90 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Jan 4, 2000 · N89678 · Substantial damage
  > the fatigue fracture and separation of the secondary drive shaft, which resulted from the manufacturer's inadequate quality control process.
- [NTSB ATL00FA021](https://openairdocs.org/ntsb/ATL00FA021.md): Piper PA-24-180 · Cordesville, SC · Accident · 2 fatal · Field investigation · Final report · Jan 4, 2000 · N5703P · Substantial damage
  > The pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB LAX00LA065](https://openairdocs.org/ntsb/LAX00LA065.md): Piper PA-32-300 · Fallbrook, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1999 · N1412T · Substantial damage
  > the pilot's misjudged altitude and distance during a night landing approach, which resulted in an undershoot.
- [NTSB LAX00LA058](https://openairdocs.org/ntsb/LAX00LA058.md): O'Hara Bob Bakeng Duce · Carson City, NV · Accident · No injuries · Limited investigation · Final report · Dec 26, 1999 · N8523X · Substantial damage
  > The pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.
- [NTSB NYC00FA058](https://openairdocs.org/ntsb/NYC00FA058.md): Cessna 172P · Leominster, MA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1999 · N96273 · 2 aircraft · Destroyed
  > The student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…
- [NTSB ATL00FA017](https://openairdocs.org/ntsb/ATL00FA017.md): Cessna 551 · Cordele, GA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1999 · N1218S · Destroyed
  > The pilot's failure to follow the published missed approach procedures, and to maintain proper altitude. Factors contributing to the severity of the accident were the low ceilings and trees.
- [NTSB FTW00LA051](https://openairdocs.org/ntsb/FTW00LA051.md): Cessna 210 · Bulverde, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1999 · N6561X · Substantial damage
  > The total loss of engine power for an undetermined reason.
- [NTSB MIA00GA057](https://openairdocs.org/ntsb/MIA00GA057.md): Hughes OH-6A · Fort Myers, FL · Accident · Serious injuries · Final report · Dec 20, 1999 · N72LC · Substantial damage
  > improper maintenance inspection of the helicopter by unknown maintenance personnel, resulting in a worn control rod bearing being continued in service, and subsequent separation, resulting in an in-flight loss of control and a crash.
- [NTSB MIA00LA055](https://openairdocs.org/ntsb/MIA00LA055.md): Piper PA-24-400 · Naples, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 1999 · N8469P · Substantial damage
  > The pilot's improper fuel management and selection of an empty fuel tank (auxiliary) on approach for landing. This resulted in a total loss of engine power due to fuel starvation, forced landing, and subsequent in-flight collision with terrain.
- [NTSB MIA00LA053](https://openairdocs.org/ntsb/MIA00LA053.md): Swertfeger Velocity 173 Elite · Murfreesboro, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 18, 1999 · N627KB · Substantial damage
  > The failure of an unknown maintenance person to comply with an Airworthiness Directive (replace center body bellows seal assembly and tube bushings) and Service Bulletin (replace fuel diaphragm) resulting in an in-flight power loss due to an over rich…
- [NTSB DEN00LA029](https://openairdocs.org/ntsb/DEN00LA029.md): Beech N-35 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Dec 16, 1999 · N9468Y · Substantial damage
  > A forced landing on unsuitable terrain due a complete loss of power. A factor was the pilot inadvertently placing the fuel selector to the off position while executing the approach for landing checklist.
- [NTSB CHI00LA041](https://openairdocs.org/ntsb/CHI00LA041.md): Piper PA-28-180 · Mankato, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 1999 · N41910 · Substantial damage
  > the pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.
- [NTSB CHI00LA036](https://openairdocs.org/ntsb/CHI00LA036.md): Cessna 172M · Ava, MO · Accident · No injuries · Limited investigation · Final report · Dec 9, 1999 · N69LM · Substantial damage
  > the improper in-flight decision made by the pilot. Factors to the accident were the charts/other manuals depicting the incorrect frequency, the dirt bank, and the rocks.
- [NTSB CHI00FA040](https://openairdocs.org/ntsb/CHI00FA040.md): Cessna 525 · Branson, MO · Accident · 6 fatal · Field investigation · Final report · Dec 9, 1999 · N525KL · Destroyed
  > the pilot descended below the minimum altitude for the segment of the GPS approach. Factors relating to the accident were low ceilings, rain, and pilot fatigue.
- [NTSB MIA00LA040](https://openairdocs.org/ntsb/MIA00LA040.md): Piper PA-28-140 · Pelzer, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1999 · N3848K · Substantial damage
  > The student pilot's failure to recognize and compensate for changing wind conditions while on final approach and landing and his failure to initiate a timely go-around, resulting in collision with trees and a utility pole.
- [NTSB MIA00FA041](https://openairdocs.org/ntsb/MIA00FA041.md): Piper PA-44-180 · Deland, FL · Accident · 4 fatal · Field investigation · Final report · Dec 3, 1999 · N3038N · 2 aircraft · Destroyed
  > The inadequate visual lookout by the pilot-in-command (PIC)/certified flight instructor (CFI) of both aircraft. Contributing factors in the accident were: 1) the frequency congestion of the CTAF 2) the poor in-flight planning decision by the PIC/CFI of the…
- [NTSB MIA00LA036](https://openairdocs.org/ntsb/MIA00LA036.md): Cessna 152 · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Dec 1, 1999 · N46946 · Substantial damage
  > The inadequate supervision of the student pilot by the pilot-in-command (CFI) for his failure to take the controls from the student and initiate a go-around earlier following the airplane drifting off the runway centerline.
- [NTSB MIA00LA035](https://openairdocs.org/ntsb/MIA00LA035.md): Howard DGA-15P · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 1, 1999 · N35RH · Substantial damage
  > The pilot's failure to maintain directional control during an attempted go-around, and the subsequent wing tip strike of the ground and collision with a tree. A factor in the loss of control was the crosswind conditions present during the landing attempt.
- [NTSB MIA00LA031](https://openairdocs.org/ntsb/MIA00LA031.md): Cessna 175-235 · Mint Hill, NC · Accident · No injuries · Limited investigation · Final report · Nov 29, 1999 · N7145M · Substantial damage
  > The PIC's improper preflight fuel planning and preparation and the PIC's improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.
- [NTSB LAX00LA045](https://openairdocs.org/ntsb/LAX00LA045.md): Lewis Stewart S-51 · Aguila, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1999 · N151L · Substantial damage
  > The jamming of a main landing gear in its wheel well for undetermined reasons.
- [NTSB FTW00LA037](https://openairdocs.org/ntsb/FTW00LA037.md): Mooney M20C · Hillsboro, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1999 · N6766U · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during the go-around. A factor was the gust of wind.
- [NTSB SEA00LA025](https://openairdocs.org/ntsb/SEA00LA025.md): Dassault DA-20 · Boise, ID · Accident · No injuries · Limited investigation · Final report · Nov 27, 1999 · N216SA · Substantial damage
  > Failure of the forward gear door lock pin. An inoperative landing gear door and inadequate maintenance inspection of the aircraft were factors.
- [NTSB LAX00TA051](https://openairdocs.org/ntsb/LAX00TA051.md): de Havilland DHC-7 · Kwajalein, Marshall Islands · Accident · No injuries · Final report · Nov 27, 1999 · N273EP · Substantial damage
  > The failure of the flight crew to properly execute the emergency landing gear extension procedure in response to a landing gear unsafe cockpit indication.
- [NTSB NYC00IA036](https://openairdocs.org/ntsb/NYC00IA036.md): Boeing 767-200 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Nov 21, 1999 · N610UA · No damage
  > Total failure of the stabilizer control system for undetermined reasons.
- [NTSB FTW00FA035](https://openairdocs.org/ntsb/FTW00FA035.md): Piper PA-24-260 · New Orleans, LA · Accident · 4 fatal · Field investigation · Final report · Nov 20, 1999 · N8825P · Destroyed
  > the pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.
- [NTSB NYC00LA037](https://openairdocs.org/ntsb/NYC00LA037.md): Beech C23 · Fincastle, VA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1999 · N5203M · Substantial damage
  > The restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.
- [NTSB FTW00LA034](https://openairdocs.org/ntsb/FTW00LA034.md): Cessna 150M · Carrolton, TX · Accident · No injuries · Limited investigation · Final report · Nov 19, 1999 · N63077 · Substantial damage
  > The pilot's failure to refuel, which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX00LA035](https://openairdocs.org/ntsb/LAX00LA035.md): American General AG5B · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Nov 13, 1999 · N1195L · Substantial damage
  > The pilot's encounter with unknown and unanticipated wake turbulence from a heavy transport aircraft, which was landing at another airport. A factor in the accident was the tower controller's failure to repeat a previously broadcast wake turbulence cautionary…
- [NTSB CHI00LA033](https://openairdocs.org/ntsb/CHI00LA033.md): Schweizer SGS-1-34 · East Lynne, MO · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1999 · N7646 · Substantial damage
  > inadequate airspeed and a subsequent stall. Factors associated with the accident were the tailwind, the pilot's misjudgment of the wind condition, and poor inflight planning.
- [NTSB SEA00LA017](https://openairdocs.org/ntsb/SEA00LA017.md): Cessna A185F · Astoria, OR · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 1999 · N6245E · Substantial damage
  > The pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.
- [NTSB FTW00LA026](https://openairdocs.org/ntsb/FTW00LA026.md): Waco KNF · Midway, AR · Accident · No injuries · Limited investigation · Final report · Nov 5, 1999 · N698N · Substantial damage
  > The inability of the pilot to maintain control of the airplane as a result of a downdraft.
- [NTSB FTW00LA025](https://openairdocs.org/ntsb/FTW00LA025.md): Streifthau Baby Great Lakes · Iowa Park, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 1999 · N415 · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel the airplane.
- [NTSB NYC00FA020](https://openairdocs.org/ntsb/NYC00FA020.md): Cessna 210L · Medina, OH · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1999 · N76N · Destroyed
  > The pilot's failure to maintain proper altitude during the final approach segment of the visual approach. A factor was the diminishing light conditions of a deepening dusk.
- [NTSB LAX00GA025](https://openairdocs.org/ntsb/LAX00GA025.md): McDonnell Douglas 500N · San Jose, CA · Accident · 2 fatal · Final report · Oct 25, 1999 · N904PD · Destroyed
  > The pilot's in-flight loss of control due to the failure and separation of the forward thruster control cable telescoping sleeve ball swivel fitting, which resulted in a stuck thruster and the entry into an uncontrollable yaw/spin. Also causal was the…
- [NTSB CHI00LA015](https://openairdocs.org/ntsb/CHI00LA015.md): Welch Murphy Rebel · Saint Johns, MI · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 1999 · N8160X · Substantial damage
  > the pilot not maintaining altitude and clearance. Factors were the trees, the flap control not fully engaged, and the pilot's lack of total experience in the kind of airplane flown.
- [NTSB ATL00LA007](https://openairdocs.org/ntsb/ATL00LA007.md): Cessna 150F · Arecibo, PR · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 1999 · N8865G · Substantial damage
  > The pilot's failure to maintain altitude clearance during final approach to landing. A factor was the hay bundles.
- [NTSB SEA00IA007](https://openairdocs.org/ntsb/SEA00IA007.md): Cessna 172P · Wenatchee, WA · Incident · No injuries · Incident investigation · Final report · Oct 23, 1999 · N54844 · 2 aircraft · Minor damage
  > The failure of the pilots in both aircraft to maintain an adequate visual lookout. Haze was a factor.
- [NTSB FTW00LA019](https://openairdocs.org/ntsb/FTW00LA019.md): Cessna TU206A · Jeanerette, LA · Accident · No injuries · Limited investigation · Final report · Oct 23, 1999 · N4807F · Substantial damage
  > The total loss of power for undetermined reasons and the pilot's failure to maintain airspeed, while clearing a ditch during a forced landing, resulting in an inadvertent stall. A factor was the ditch.
- [NTSB LAX00LA023](https://openairdocs.org/ntsb/LAX00LA023.md): Luhnau BD-5B · Boulder City, NV · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 1999 · N62765 · Substantial damage
  > The pilot's failure to secure an electrical wire terminal in the propeller pitch control circuit following a maintenance adjustment, which resulted in the propeller malfunctioning and going to a flat pitch. The flat pitch of the propeller produced a high drag…

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

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

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