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

## Cases, newest first

- [NTSB SEA00LA005](https://openairdocs.org/ntsb/SEA00LA005.md): Beech S35 · Melstone, MT · Accident · No injuries · Limited investigation · Final report · Oct 21, 1999 · N8811M · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB SEA00LA006](https://openairdocs.org/ntsb/SEA00LA006.md): Piper PA-24-250 · Bozeman, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1999 · N8078P · Substantial damage
  > The pilot-in-command's (CFI) failure to take remedial action. Factors include the private pilot letting the airspeed get too low.
- [NTSB SEA00LA004](https://openairdocs.org/ntsb/SEA00LA004.md): Thomson Vans RV-6 · Emmett, ID · Accident · No injuries · Limited investigation · Final report · Oct 20, 1999 · N541JT · Substantial damage
  > The pilot's improper fuel management, resulting in fuel starvation. A factor was the aircraft's low altitude at the time engine power was lost.
- [NTSB LAX00LA013](https://openairdocs.org/ntsb/LAX00LA013.md): Bell 206B · Los Angeles, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 14, 1999 · N16889 · Substantial damage
  > **This report was modified on 2/23/2016. Please refer to the public docket for this accident for additional information.** The pilot-in-command's excessive rate of descent and improper use of the collective control, which resulted in a low rotor rpm condition.
- [NTSB CHI00LA008](https://openairdocs.org/ntsb/CHI00LA008.md): Cessna 150F · East Troy, WI · Accident · No injuries · Limited investigation · Final report · Oct 13, 1999 · N7941F · Substantial damage
  > the pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.
- [NTSB LAX00LA007](https://openairdocs.org/ntsb/LAX00LA007.md): Pitts S2B · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Oct 11, 1999 · N50AL · Substantial damage
  > The pilot's inadequate compensation for the effects of torque and P-factor during a go-around from a bounced landing, which led to a loss of control and the inadvertent dragging of a wing.
- [NTSB NYC00LA024](https://openairdocs.org/ntsb/NYC00LA024.md): Cessna 177 · Frankfort, KY · Accident · No injuries · Limited investigation · Final report · Oct 7, 1999 · N29362 · Substantial damage
  > A total loss of engine power for undetermined reasons
- [NTSB LAX00LA005](https://openairdocs.org/ntsb/LAX00LA005.md): Cessna 210B · Tonopah, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1999 · N9609X · Substantial damage
  > The pilot's failure to monitor his altitude and maintain an adequate terrain clearance during the approach. The dark night lighting conditions and the visual illusion created by the lack of ground reference lights were factors in the accident.
- [NTSB NYC00FA004](https://openairdocs.org/ntsb/NYC00FA004.md): Cessna 182R · Killingworth, CT · Accident · 1 fatal · Field investigation · Final report · Oct 4, 1999 · N121BG · Destroyed
  > The pilot's failure follow the published instrument approach procedure. A factor in the accident was the low cloud ceiling.
- [NTSB MIA00LA001](https://openairdocs.org/ntsb/MIA00LA001.md): Cessna 152 · Pensacola, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1999 · N49508 · Substantial damage
  > The failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.
- [NTSB LAX00LA002](https://openairdocs.org/ntsb/LAX00LA002.md): Zdybel Glasair FT · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1999 · N711FZ · Substantial damage
  > Fuel starvation due to the owner/builder's improper installation of the fuel selector valve, and, his failure to placard the operating positions of the valve handle.
- [NTSB FTW00FA001](https://openairdocs.org/ntsb/FTW00FA001.md): Cessna P210N · Spicewood, TX · Accident · 2 fatal · Field investigation · Final report · Oct 2, 1999 · N7542K · Destroyed
  > The pilot's delayed application of full throttle during a go-around, which resulted in a slow airspeed and inadvertent stall/spin. A factor was the pilot's habit of only applying partial power during takeoff.
- [NTSB DEN00LA002](https://openairdocs.org/ntsb/DEN00LA002.md): Piper PA-24-250 · La Junta, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1999 · N6406P · Substantial damage
  > The pilot-in-command's failure to maintain a proper altitude during final approach to landing, and his misjudgment of altitude clearances. Factors were the sudden windshift, downdraft and turbulent weather conditions, the dark night, and the pilot's lack of…
- [NTSB DEN00LA001](https://openairdocs.org/ntsb/DEN00LA001.md): Gray Rotorway Exec · Gallup, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 1999 · N716JB · Substantial damage
  > The pilot inadvertently allowing main rotor rpm to decay while avoiding obstacles during an emergency autorotation following a loss of power for reasons undetermined. Factors were houses and powerlines.
- [NTSB DEN99LA173](https://openairdocs.org/ntsb/DEN99LA173.md): Enstrom 280C · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Sep 30, 1999 · N84DH · Substantial damage
  > An inaccurate touchdown during a full autorotation, which resulted in main rotor flex which cut off the tail boom. Factors were the pilot's lack of total experience in helicopters and high density altitude.
- [NTSB IAD99FA070](https://openairdocs.org/ntsb/IAD99FA070.md): Cessna 310Q · Salisbury, MD · Accident · Serious injuries · Field investigation · Final report · Sep 28, 1999 · N69945 · Substantial damage
  > The improper installation of the #2 cylinder that resulted in a fractured crankshaft and a total loss of engine power. Factors in the accident were the premature deployment of the landing gear and flaps by the pilot.
- [NTSB MIA99FA269](https://openairdocs.org/ntsb/MIA99FA269.md): Piper PA-31P · Louisville, MS · Accident · 1 fatal · Field investigation · Final report · Sep 27, 1999 · N100EE · Destroyed
  > The pilot's disregard for the published minimum descent altitude resulting in tree contact and separation of 51 inches of the left wing. Findings in the investigation were the pilot's two failures of the ATP checkride in a multiengine airplane.
- [NTSB CHI99LA349](https://openairdocs.org/ntsb/CHI99LA349.md): Cessna 150 · Detroit, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 1999 · N40LM · Destroyed
  > the pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.
- [NTSB LAX99FA310](https://openairdocs.org/ntsb/LAX99FA310.md): Cessna 421C · Santa Monica, CA · Accident · Minor injuries · Field investigation · Final report · Sep 23, 1999 · N26585 · Substantial damage
  > The failure of the pilot to establish and maintain a stabilized approach, which resulted in a hard landing and on-ground collision with the airport VASI display.
- [NTSB SEA99LA173](https://openairdocs.org/ntsb/SEA99LA173.md): Cessna 150M · Camas, WA · Accident · No injuries · Limited investigation · Final report · Sep 22, 1999 · N704XA · Substantial damage
  > A misjudged approach and inadequate airspeed. Sunglare, a delayed decision to go-around, and not maintaining clearance from a fence were factors.
- [NTSB MIA99FA263](https://openairdocs.org/ntsb/MIA99FA263.md): Piper PA-31-350 · Moreland, GA · Accident · 2 fatal · Field investigation · Final report · Sep 21, 1999 · N27343 · Destroyed
  > The pilot's failure to maintain the minimum descent altitude while executing a localizer approach. Contributing factors were low ceilings and dark night conditions as well as the trees.
- [NTSB DEN99LA166](https://openairdocs.org/ntsb/DEN99LA166.md): Cessna 172G · Delta, CO · Accident · No injuries · Limited investigation · Final report · Sep 19, 1999 · N4262L · Substantial damage
  > A forced landing due to fuel exhaustion. Factors were inadequate preflight planing, inadequate in-flight planing and rough uneven, unsuitable terrain for a forced landing.
- [NTSB ATL99LA133](https://openairdocs.org/ntsb/ATL99LA133.md): Grumman-Schweizer G-164B · Enterprise, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1999 · N6736Q · Destroyed
  > The loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.
- [NTSB LAX99LA313](https://openairdocs.org/ntsb/LAX99LA313.md): Cessna 172N · Merced, CA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1999 · N2339E · Substantial damage
  > The pilot's premature retraction of the flaps during an attempted go-around with insufficient airspeed, which led to an inadvertent stall/mush condition.
- [NTSB LAX99LA307](https://openairdocs.org/ntsb/LAX99LA307.md): Robinson R-22 · Azusa, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1999 · N8328Q · Substantial damage
  > the pilot's delay in recognizing the settling with power condition while performing a pinnacle approach, thus delaying his attempted go-around.
- [NTSB NYC99LA224](https://openairdocs.org/ntsb/NYC99LA224.md): North American T6-G · Falmouth, KY · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 1999 · N7767C · Substantial damage
  > The pilot's misjudgment of altitude/clearance on approach which resulted in an in-flight collision with trees.
- [NTSB NYC99LA223](https://openairdocs.org/ntsb/NYC99LA223.md): Beech A23 · Carlisle, PA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1999 · N3508R · Substantial damage
  > The pilot's improper fuel management, resulting in fuel starvation.
- [NTSB LAX99LA304](https://openairdocs.org/ntsb/LAX99LA304.md): Glover Teenie TWO · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 1999 · N925SG · Destroyed
  > The in-flight separation and loss of the carburetor fuel jet resulting from the pilot's improper installation of the component. Also causal was the pilot's failure to maintain an adequate airspeed margin following the loss of power, which resulted in an…
- [NTSB MIA99LA251](https://openairdocs.org/ntsb/MIA99LA251.md): Bellanca BL-17-30 · Athens, GA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1999 · N6676V · Substantial damage
  > The pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.
- [NTSB ATL99LA131](https://openairdocs.org/ntsb/ATL99LA131.md): Hiller UH-12A · Satartia, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1999 · N212W · Substantial damage
  > The pilot's failure to maintain control of the helicopter while on approach which resulted in the uncontrolled collision with the ground. A factor was the pilot's physiological condition.
- [NTSB MIA99FA250](https://openairdocs.org/ntsb/MIA99FA250.md): Mbb BO105CBS · Kenansville, FL · Accident · Serious injuries · Field investigation · Final report · Sep 10, 1999 · N911HR · Substantial damage
  > The pilots failure to recognize entry into settling with power during approach to land and his failure to take remedial action to escape from settling with power resulting in the helicopter descending and colliding with trees and swampy terrain.
- [NTSB CHI99LA337](https://openairdocs.org/ntsb/CHI99LA337.md): Reichert MJ-77 · Owosso, MI · Accident · 1 fatal · Limited investigation · Final report · Sep 10, 1999 · N51MJ · Substantial damage
  > the pilot's improper preflight which resulted in a takeoff with the oil cap not secured and the subsequent loss of engine power.
- [NTSB ATL99LA128](https://openairdocs.org/ntsb/ATL99LA128.md): Cessna 182P · Collegedale, TN · Accident · No injuries · Limited investigation · Final report · Sep 9, 1999 · N78092 · Substantial damage
  > The pilot's failure to secure the fuel cap which resulted in fuel exhaustion and the loss of engine power. A factor was the collision with a fence post.
- [NTSB ATL99TA126](https://openairdocs.org/ntsb/ATL99TA126.md): Hughes OH-6A · Hernando, MS · Accident · No injuries · Final report · Sep 7, 1999 · N584SD · Substantial damage
  > The in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.
- [NTSB CHI99LA331](https://openairdocs.org/ntsb/CHI99LA331.md): Champion 7ECA · Forest Lake, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1999 · N9549S · Substantial damage
  > the pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.
- [NTSB LAX99LA296](https://openairdocs.org/ntsb/LAX99LA296.md): Beech 35-A33 · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Sep 5, 1999 · N849B · Substantial damage
  > The pilot's failure to follow the manufacturer's procedures to fully enrich the mixture, which induced an overly lean condition during full power application on the go-around and a resulting loss of power. The high density altitude weather condition was a…
- [NTSB SEA99LA153](https://openairdocs.org/ntsb/SEA99LA153.md): Cessna 210B · Dixie, ID · Accident · No injuries · Limited investigation · Final report · Sep 4, 1999 · N9740X · Substantial damage
  > Inadequate airspeed and clearance was not maintained. Mountainous conditions, trees, and an inadequately planned approach were factors.
- [NTSB MIA99FA245](https://openairdocs.org/ntsb/MIA99FA245.md): Beech B-90 · West Palm Beach, FL · Accident · 8 fatal · Field investigation · Final report · Sep 3, 1999 · N338AS · Destroyed
  > a total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.
- [NTSB CHI99LA354](https://openairdocs.org/ntsb/CHI99LA354.md): Cessna 150L · Midland, MI · Accident · No injuries · Limited investigation · Final report · Sep 2, 1999 · N1316Q · Substantial damage
  > the student pilot's failure to maintain control of the airplane during an attempted go-around.
- [NTSB FTW99LA243](https://openairdocs.org/ntsb/FTW99LA243.md): Let Blanik L-13 · Jonesboro, AR · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1999 · N3255Y · Substantial damage
  > The pilot's misjudgment of distance/altitude during the final approach to landing, resulting in an undershoot, and collision with a power line pole.
- [NTSB LAX99LA289](https://openairdocs.org/ntsb/LAX99LA289.md): Cessna P210N · North Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1999 · N40RP · Substantial damage
  > The pilot's improper procedure in that he failed to follow the flight manual, resulting in a loss of engine power and subsequent collision with the ground.
- [NTSB FTW99LA238](https://openairdocs.org/ntsb/FTW99LA238.md): Burkhart Grob 103C · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1999 · N103MS · Substantial damage
  > The pilot's failure to attain proper runway alignment of the glider resulting in failure to maintain obstacle clearance. A factor was the high density altitude.
- [NTSB DEN99LA155](https://openairdocs.org/ntsb/DEN99LA155.md): North American SNJ-4 (AT-6) · Mack, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1999 · N7011C · Substantial damage
  > The pilot misjudging his distance and altitude from the runway. A factor was the tall crops.
- [NTSB LAX99LA282](https://openairdocs.org/ntsb/LAX99LA282.md): Aerospatiale AS350BA · Kahului, HI · Accident · No injuries · Limited investigation · Final report · Aug 24, 1999 · N6094S · Substantial damage
  > The pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.
- [NTSB SEA99FA146](https://openairdocs.org/ntsb/SEA99FA146.md): Republic RC-3 · Chimacum, WA · Accident · 2 fatal · Field investigation · Final report · Aug 23, 1999 · N6070K · Destroyed
  > The inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…
- [NTSB FTW99FA235](https://openairdocs.org/ntsb/FTW99FA235.md): Beech D-35 · Seminole, OK · Accident · 1 fatal · Field investigation · Final report · Aug 23, 1999 · N2934B · Destroyed
  > The loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.
- [NTSB MIA99FA232](https://openairdocs.org/ntsb/MIA99FA232.md): Beech C24R · Pickens, SC · Accident · 1 fatal · Field investigation · Final report · Aug 22, 1999 · N67198 · Substantial damage
  > The pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.
- [NTSB FTW99LA231](https://openairdocs.org/ntsb/FTW99LA231.md): Alon A-2A · Cabot, AR · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 1999 · N5465F · Substantial damage
  > The missing engine oil filler cap which resulted in the loss of engine power as a result of oil starvation. Factors were the pilot's improper aircraft preflight inspection and the lack of suitable terrain for the forced landing.
- [NTSB LAX99FA275](https://openairdocs.org/ntsb/LAX99FA275.md): Mooney M20E · Las Vegas, NV · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1999 · N2654W · Substantial damage
  > The pilot's steep turn at low altitude that resulted in an accelerated stall while in the landing configuration, leading to a loss of control and subsequent ground impact.
- [NTSB NYC99LA203](https://openairdocs.org/ntsb/NYC99LA203.md): Piper PA-28R-200 · Berlin, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1999 · N2721R · Substantial damage
  > A loss of engine power for undetermined reason(s).

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

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

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