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

## Cases, newest first

- [NTSB ANC06LA130](https://openairdocs.org/ntsb/ANC06LA130.md): McNabb Bushmaster · Delta Junction, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2006 · N5090F · Substantial damage
  > An electrical short that disabled the electronic ignition system of the airplane's engine during the final approach phase for landing, which resulted in a forced landing and collision with high vegetation. A factor contributing to the accident was the failure…
- [NTSB SEA06CA174](https://openairdocs.org/ntsb/SEA06CA174.md): Cessna 180 · Arock, OR · Accident · No injuries · Data collection · Final report · Sep 3, 2006 · N9026C · Substantial damage
  > The pilot's failure to maintain directional control during a go-around, resulting in an in-flight collision with trees and substantial damage to the airplane. Factors included the pilot's failure to attain the proper touchdown point, the delayed go-around,…
- [NTSB MIA06CA134](https://openairdocs.org/ntsb/MIA06CA134.md): Cessna 172N · Pensacola, FL · Accident · Minor injuries · Data collection · Final report · Sep 3, 2006 · N1210F · Substantial damage
  > The student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.
- [NTSB LAX06CA281](https://openairdocs.org/ntsb/LAX06CA281.md): Cessna 172P · Spanish Springs, NV · Accident · No injuries · Data collection · Final report · Sep 1, 2006 · N97306 · Substantial damage
  > the pilot's failure to initiate a timely go-around and to attain an adequate climb rate. Factors in the accident were the high density altitude and the likely quartering tail wind that may have affected the aircraft's climb gradient.
- [NTSB SEA06CA173](https://openairdocs.org/ntsb/SEA06CA173.md): Cessna 182RG · Fairfield, UT · Accident · No injuries · Data collection · Final report · Aug 30, 2006 · N5464N · Substantial damage
  > The failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…
- [NTSB ATL06CA124](https://openairdocs.org/ntsb/ATL06CA124.md): Cessna 172R · Winder, GA · Accident · No injuries · Data collection · Final report · Aug 29, 2006 · N856CP · Substantial damage
  > The student pilot's failure to maintain control of the airplane during an attempted go-around.
- [NTSB NYC06FA209](https://openairdocs.org/ntsb/NYC06FA209.md): Cessna 401A · Whick, KY · Accident · 7 fatal · Field investigation · Final report · Aug 28, 2006 · N408JC · Destroyed
  > The non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.
- [NTSB CHI06CA246](https://openairdocs.org/ntsb/CHI06CA246.md): Aviat A-1B · Minocqua, WI · Accident · No injuries · Data collection · Final report · Aug 26, 2006 · N314MA · Substantial damage
  > The inadvertent collision with power lines. A factor associated with the accident was the water which blended in with the power lines resulting in the pilot's inability to see them prior to contact.
- [NTSB SEA06CA165](https://openairdocs.org/ntsb/SEA06CA165.md): Bell 407 · Havre, MT · Accident · No injuries · Data collection · Final report · Aug 19, 2006 · N407SH · Substantial damage
  > The pilot inadvertently allowing the helicopter to enter into a vortex ring state (settling with power) condition while he was lowering a long-line load to the ground, resulting in the helicopter settling to the ground and its tail rotor impacting part of the…
- [NTSB ATL06FA122](https://openairdocs.org/ntsb/ATL06FA122.md): Piper PA-32RT-300 · Hartsville, SC · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2006 · N31911 · Substantial damage
  > The pilot's loss of control of the airplane due to spatial disorientation.
- [NTSB CHI06LA244](https://openairdocs.org/ntsb/CHI06LA244.md): Fairchild SA227-AC · Grain Valley, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2006 · N620PA · Substantial damage
  > the pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.
- [NTSB CHI06CA234](https://openairdocs.org/ntsb/CHI06CA234.md): Beech 19A · Yankton, SD · Accident · No injuries · Data collection · Final report · Aug 16, 2006 · N6544T · Substantial damage
  > The dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.
- [NTSB CHI06FA232](https://openairdocs.org/ntsb/CHI06FA232.md): Piper PA-23-250 · Sault Ste Marie, MI · Accident · 4 fatal · Field investigation · Final report · Aug 14, 2006 · N133BH · Destroyed
  > The pilot's failure to maintain aircraft control during the circling approach and his failure to perform a missed approach when the airplane was no longer in a position to land using normal flight maneuvers. Contributing to the accident was the pilot's…
- [NTSB NYC06CA201](https://openairdocs.org/ntsb/NYC06CA201.md): Beech B100 · Pawtucket, RI · Accident · No injuries · Data collection · Final report · Aug 13, 2006 · N75AP · Substantial damage
  > The pilot's misjudged distance and speed during final approach, which resulted in an undershoot and subsequent gear collapse.
- [NTSB CHI06LA230](https://openairdocs.org/ntsb/CHI06LA230.md): Dix Acro Sport II · Coldwater, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 12, 2006 · N208BY · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.
- [NTSB SEA06CA160](https://openairdocs.org/ntsb/SEA06CA160.md): Robinson R-22B · Boise, ID · Accident · No injuries · Data collection · Final report · Aug 11, 2006 · N228SH · Substantial damage
  > The instructor pilot's inadvertent excessive descent rate, and his delay of remedial action during the demonstration of a 180 degree autorotation.
- [NTSB ANC06LA107](https://openairdocs.org/ntsb/ANC06LA107.md): Piper PA-22-150 · Deadhorse, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 2006 · N3546P · Substantial damage
  > The pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an uncontrolled descent and collision with terrain. A factor contributing to the accident was an inadvertent stall.
- [NTSB NYC06CA194](https://openairdocs.org/ntsb/NYC06CA194.md): Champion 7FC · Harmonsburg, PA · Accident · Serious injuries · Data collection · Final report · Aug 5, 2006 · N9866B · Substantial damage
  > The pilot's failure to maintain the proper altitude/clearance on final approach, which resulted in an in-flight collision with trees.
- [NTSB CHI06FA218](https://openairdocs.org/ntsb/CHI06FA218.md): Cirrus Design SR22 · Boyceville, WI · Accident · Serious injuries · Field investigation · Final report · Aug 5, 2006 · N658CD · Substantial damage
  > The pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…
- [NTSB SEA06LA154](https://openairdocs.org/ntsb/SEA06LA154.md): Piper PA-23-150 · Ontario, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2006 · N1221P · Substantial damage
  > The pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.
- [NTSB NYC06MA192](https://openairdocs.org/ntsb/NYC06MA192.md): Embraer 110P1 · Pownal, VT · Accident · 1 fatal · Major investigation · Final report · Aug 4, 2006 · N59BA · Destroyed
  > The pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…
- [NTSB LAX06CA253](https://openairdocs.org/ntsb/LAX06CA253.md): Cessna 172M · Gasquet, CA · Accident · Serious injuries · Data collection · Final report · Aug 4, 2006 · N5262R · Substantial damage
  > the pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…
- [NTSB ANC06LA103](https://openairdocs.org/ntsb/ANC06LA103.md): de Havilland DHC-3 · Juneau, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 2006 · N93356 · Substantial damage
  > The pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting the surface of the water. Factors associated with the accident were the flat-light and glassy water conditions, which affected the pilot's ability to…
- [NTSB DFW06CA192](https://openairdocs.org/ntsb/DFW06CA192.md): Beech BE23 · Bowie, TX · Accident · No injuries · Data collection · Final report · Jul 23, 2006 · N2326Z · Substantial damage
  > The student pilot's failure to maintain clearance from trees. Contributing factors were the prevailing crosswind and improper supervision of the flight by the flight instructor.
- [NTSB CHI06FA196](https://openairdocs.org/ntsb/CHI06FA196.md): Shaw Europa XS · Oshkosh, WI · Accident · 2 fatal · Field investigation · Final report · Jul 23, 2006 · N229WC · Substantial damage
  > The pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.
- [NTSB LAX06CA248](https://openairdocs.org/ntsb/LAX06CA248.md): Cessna T210N · Truckee, CA · Accident · No injuries · Data collection · Final report · Jul 22, 2006 · N6686N · Substantial damage
  > the pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.
- [NTSB DFW06CA190](https://openairdocs.org/ntsb/DFW06CA190.md): Piper PA-28-140 · Woodworth, LA · Accident · No injuries · Data collection · Final report · Jul 22, 2006 · N9952W · Substantial damage
  > The pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.
- [NTSB CHI06CA198](https://openairdocs.org/ntsb/CHI06CA198.md): Sargent Bushby Mustang II · Troy, MI · Accident · Minor injuries · Data collection · Final report · Jul 22, 2006 · N6186C · Destroyed
  > The pilot's delayed decision to go-around leading to the impact with the fence during the go-around. A factor was the fence.
- [NTSB ANC06LA092](https://openairdocs.org/ntsb/ANC06LA092.md): Piper PA-34-200 · Deland, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2006 · N717PE · Substantial damage
  > The flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…
- [NTSB NYC06IA176](https://openairdocs.org/ntsb/NYC06IA176.md): Eurocopter AS-350 BA · Philadelphia, PA · Incident · No injuries · Incident investigation · Final report · Jul 17, 2006 · N606TV · No damage
  > A loss of hydraulic boost for undetermined reasons.
- [NTSB MIA06LA123](https://openairdocs.org/ntsb/MIA06LA123.md): Bell 206B · Pompano Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 2006 · N515AA · Substantial damage
  > The pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.
- [NTSB LAX06FA233](https://openairdocs.org/ntsb/LAX06FA233.md): Bellanca 14-19 · Arcata, CA · Accident · 1 fatal · Field investigation · Final report · Jul 17, 2006 · N522A · Destroyed
  > The pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…
- [NTSB NYC06CA177](https://openairdocs.org/ntsb/NYC06CA177.md): Beech A36 · Somerville, NJ · Accident · No injuries · Data collection · Final report · Jul 16, 2006 · N5363P · Substantial damage
  > The pilot's continued flight into known adverse weather.
- [NTSB NYC06CA119](https://openairdocs.org/ntsb/NYC06CA119.md): Cessna 182A · Plattsburgh, NY · Accident · Serious injuries · Data collection · Final report · Jul 15, 2006 · N2186G · Substantial damage
  > The pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.
- [NTSB LAX06FA238](https://openairdocs.org/ntsb/LAX06FA238.md): Learjet 55 · Van Nuys, CA · Accident · No injuries · Field investigation · Final report · Jul 15, 2006 · N554CL · Substantial damage
  > An in-flight fire of undetermined origins.
- [NTSB LAX06LA235](https://openairdocs.org/ntsb/LAX06LA235.md): Alfred Long-EZ · Hesperia, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 2006 · N1014A · Substantial damage
  > The pilot's failure to maintain the proper glide path on final approach as a result of the visual illusions created by a narrow, upsloping runway.
- [NTSB DFW06FA180](https://openairdocs.org/ntsb/DFW06FA180.md): Beech C24R · Virginia Beach, VA · Accident · 2 fatal · Field investigation · Final report · Jul 11, 2006 · N78MB · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while maneuvering at a low altitude. Contributing was the pilot's diverted attention to an open door.
- [NTSB CHI06FA186](https://openairdocs.org/ntsb/CHI06FA186.md): Cirrus Design SR-22 · Edgewater, MD · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2006 · N8163Q · Destroyed
  > The pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.
- [NTSB DFW06CA179](https://openairdocs.org/ntsb/DFW06CA179.md): Piper PA-28-161 · Georgetown, TX · Accident · Minor injuries · Data collection · Final report · Jul 10, 2006 · N8164J · Substantial damage
  > The flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…
- [NTSB ATL06LA103](https://openairdocs.org/ntsb/ATL06LA103.md): Taylorcraft BC12-D · Gold Hill, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2006 · N96758 · Substantial damage
  > The pilot's failure to maintain airspeed while doing a go around, which resulted in an inadvertent stall, loss of control and in-flight collision with the ground. A factor was the pilot's lack of recent experience in the airplane.
- [NTSB ATL06FA102](https://openairdocs.org/ntsb/ATL06FA102.md): Piper PA-32-260 · Suches, GA · Accident · 5 fatal · Field investigation · Final report · Jul 8, 2006 · N3380W · Destroyed
  > The pilot's failure to retract the wing flaps and his decision to make a turn while performing a go-around.
- [NTSB DFW06CA176](https://openairdocs.org/ntsb/DFW06CA176.md): Cessna 210A · Denver City, TX · Accident · No injuries · Data collection · Final report · Jul 7, 2006 · N9419X · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA177](https://openairdocs.org/ntsb/CHI06CA177.md): Cessna T210G · Pontiac, IL · Accident · Minor injuries · Data collection · Final report · Jul 6, 2006 · N6900R · Substantial damage
  > A loss of engine power due to the pilot's improper in-flight planning which led to fuel exhaustion and his failure to maintain an adequate airspeed during the landing approach which resulted in an inadvertent stall. The road embankment was a factor.
- [NTSB CHI06CA176](https://openairdocs.org/ntsb/CHI06CA176.md): Cessna 182A · Jackson, MI · Accident · Minor injuries · Data collection · Final report · Jul 6, 2006 · N4780D · Substantial damage
  > The pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.
- [NTSB LAX06CA223](https://openairdocs.org/ntsb/LAX06CA223.md): Piper PA28-181 · Dorris, CA · Accident · No injuries · Data collection · Final report · Jul 3, 2006 · N6413C · Substantial damage
  > the pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.
- [NTSB DEN06FA091](https://openairdocs.org/ntsb/DEN06FA091.md): Beech A36TC · Montrose, CO · Accident · 2 fatal · Field investigation · Final report · Jul 3, 2006 · N1800Z · Destroyed
  > the pilot's inadequate preflight planning/decision by not having the airplane refueled prior to takeoff, and allowing the engine to be starved of fuel because he failed to switch the fuel selector valve. A contributing factor was the flight instructor's…
- [NTSB ATL06CA100](https://openairdocs.org/ntsb/ATL06CA100.md): Nickel Acro II · Hertford, NC · Accident · Serious injuries · Data collection · Final report · Jul 2, 2006 · N6N · Substantial damage
  > The certified flight instructor and commercial pilot receiving instruction failure to maintain a visual look out, resulting in a wire strike on final approach, and collapse of the main landing gear on touchdown.
- [NTSB DFW06CA174](https://openairdocs.org/ntsb/DFW06CA174.md): Cessna 172L · Burnett, TX · Accident · Minor injuries · Data collection · Final report · Jul 1, 2006 · N7943G · Substantial damage
  > The flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.
- [NTSB NYC06LA160](https://openairdocs.org/ntsb/NYC06LA160.md): Aerial Productions Intl. Acrojet Special · Ocean City, MD · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 2006 · N23AP · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall mush and subsequent impact with trees. A factor in the accident was windshear, and the high weight of the airplane.
- [NTSB LAX06CA217](https://openairdocs.org/ntsb/LAX06CA217.md): Beech 76 · El Cajon, CA · Accident · No injuries · Data collection · Final report · Jun 27, 2006 · N6720T · Substantial damage
  > the failure of the "A" frame tube, which caused the left main landing gear to collapse.

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

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

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