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

## Cases, newest first

- [NTSB GAA19CA054](https://openairdocs.org/ntsb/GAA19CA054.md): Cessna 206 · Boise, ID · Accident · No injuries · Data collection · Final report · Nov 10, 2018 · N16HT · Substantial damage
  > The airplane’s impact with a bird during the approach.
- [NTSB ERA19WA040](https://openairdocs.org/ntsb/ERA19WA040.md): Piper PA23 · Nassau, Bahamas · Accident · 1 fatal · Foreign investigation · Nov 8, 2018 · N8383C · Substantial damage
  > The government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…
- [NTSB CEN19FA022](https://openairdocs.org/ntsb/CEN19FA022.md): Mustang II · Broomfield, CO · Accident · 2 fatal · Field investigation · Final report · Nov 2, 2018 · N287BM · Substantial damage
  > The pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.
- [NTSB GAA19CA048](https://openairdocs.org/ntsb/GAA19CA048.md): Cessna 172 · Cleburne, TX · Accident · Minor injuries · Data collection · Final report · Nov 1, 2018 · N3984L · Substantial damage
  > The pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB WPR19LA017](https://openairdocs.org/ntsb/WPR19LA017.md): Cessna 180 · Cottonwood, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 30, 2018 · N6414X · Substantial damage
  > A partial loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat during a reduced-power approach descent.
- [NTSB CEN19CA017](https://openairdocs.org/ntsb/CEN19CA017.md): Piper PA28R · Hobbs, NM · Accident · No injuries · Data collection · Final report · Oct 28, 2018 · N6899C · Substantial damage
  > The pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.
- [NTSB ERA19WA046](https://openairdocs.org/ntsb/ERA19WA046.md): Garlick UH1D · Valparaiso, Chile · Accident · Serious injuries · Foreign investigation · Oct 24, 2018 · CC-CPU · Destroyed
  > The government of Chile has notified the NTSB of an accident involving a GARLICK UH1D helicopter that occurred on October 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions…
- [NTSB ERA19LA024](https://openairdocs.org/ntsb/ERA19LA024.md): Beech 35 · State College, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 2018 · N8319D · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR19FA007](https://openairdocs.org/ntsb/WPR19FA007.md): Cessna T240 · Payson, AZ · Accident · 2 fatal · Class 2 · Field · Final report · Oct 14, 2018 · N433CS · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.
- [NTSB CEN19LA006](https://openairdocs.org/ntsb/CEN19LA006.md): Cessna 120 · Hudson, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2018 · N1881N · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA19CA034](https://openairdocs.org/ntsb/GAA19CA034.md): Just Just Aircraft (Highl · Monroe, WA · Accident · No injuries · Data collection · Final report · Oct 12, 2018 · N488VG · Substantial damage
  > The pilot's improper engine modification and operation, which resulted in a total loss of engine power due to fuel starvation, and the pilot's failure to maintain an adequate approach path, which resulted in the airplane landing short of the runway.
- [NTSB ERA19LA016](https://openairdocs.org/ntsb/ERA19LA016.md): Sa300 Starduster · Byhalia, MS · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 2018 · N503CM · Substantial damage
  > The pilot's failure to maintain a proper approach path, which resulted a collision with trees short of the runway.
- [NTSB CEN19LA007](https://openairdocs.org/ntsb/CEN19LA007.md): Grumman AA5 · Refugio, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 12, 2018 · N81383 · Substantial damage
  > The pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and the pilot’s failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and an…
- [NTSB DCA19WA008](https://openairdocs.org/ntsb/DCA19WA008.md): Boeing 787 · Perth, Australia · Incident · No injuries · Foreign investigation · Oct 11, 2018 · 9V-OJE · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on October 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB ANC19CA003](https://openairdocs.org/ntsb/ANC19CA003.md): Cessna 207 · Anchorage, AK · Accident · No injuries · Data collection · Final report · Oct 11, 2018 · N6492H · Substantial damage
  > The pilot's inadequate in-flight fuel management, which resulted in fuel starvation and the subsequent loss of engine power, and her subsequent failure to maintain clearance from trees during the approach to land at a nearby airstrip.
- [NTSB WPR19TA005](https://openairdocs.org/ntsb/WPR19TA005.md): Balloon Works Firefly 7 · Placitas, NM · Accident · Serious injuries · Final report · Oct 10, 2018 · N7252H · No damage
  > The pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.
- [NTSB GAA19CA021](https://openairdocs.org/ntsb/GAA19CA021.md): Aviat S · Hampton, GA · Accident · No injuries · Data collection · Final report · Oct 9, 2018 · N126BB · Substantial damage
  > The pilot’s failure to see and avoid power wires during approach.
- [NTSB DCA19WA011](https://openairdocs.org/ntsb/DCA19WA011.md): Boeing 737 · Brisbane, Australia · Incident · No injuries · Foreign investigation · Oct 9, 2018 · VH-YFW · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on October 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…
- [NTSB WPR19WA004](https://openairdocs.org/ntsb/WPR19WA004.md): Cessna 172 · Midrand, South Africa · Accident · 2 fatal · Foreign investigation · Oct 8, 2018 · ZS-PZT · Substantial damage
  > On October 8, 2018, at 0920 coordinated universal time, a Cessna 172L airplane, registration ZS-PZT, sustained substantial damage after colliding with the ground during the landing approach at Grand Central Airport, Midrand, South Africa. The pilot and one…
- [NTSB ERA19WA038](https://openairdocs.org/ntsb/ERA19WA038.md): Siai Marchetti SF260 · Caorle, Italy · Accident · 2 fatal · Foreign investigation · Oct 3, 2018 · I-ISAE · Destroyed
  > The government of Italy has notified the NTSB of an accident involving a Siai Marchetti SF260 airplane that occurred on October 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…
- [NTSB WPR19FA001](https://openairdocs.org/ntsb/WPR19FA001.md): Beech V35 · La Verne, CA · Accident · 1 fatal · Class 2 · Field · Final report · Oct 1, 2018 · N7997M · Destroyed
  > The pilot's failure to maintain clearance from trees during a visual approach for landing. Contributing to the accident was the pilot's distraction during the approach.
- [NTSB GAA18CA575](https://openairdocs.org/ntsb/GAA18CA575.md): Piper PA28 · Spokane, WA · Accident · Serious injuries · Data collection · Final report · Sep 29, 2018 · N40825 · Substantial damage
  > The pilot’s improper retraction of the flaps during a go-around, which resulted in the airplane’s failure to climb and its subsequent collision with trees.
- [NTSB DCA18RA292](https://openairdocs.org/ntsb/DCA18RA292.md): Boeing 737 · Chuuk, Micronesia · Accident · 1 fatal · Foreign investigation · Sep 28, 2018 · P2-PXE · Substantial damage
  > The government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…
- [NTSB CEN18FA387](https://openairdocs.org/ntsb/CEN18FA387.md): Beech 200 · Oscoda, MI · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2018 · N241CK · Destroyed
  > The pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.
- [NTSB CEN18FA384](https://openairdocs.org/ntsb/CEN18FA384.md): Cessna 150 · Festus, MO · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2018 · N7152S · Substantial damage
  > A total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…
- [NTSB WPR18LA271](https://openairdocs.org/ntsb/WPR18LA271.md): Cessna TU206 · Brenham, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 20, 2018 · N756NN · Substantial damage
  > The pilot's improper fuel management during the landing approach, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was his failure to follow the published emergency procedures after the loss of engine power.
- [NTSB ERA18TA255](https://openairdocs.org/ntsb/ERA18TA255.md): Calvin Nate H Velocity STD RG E · Kingsport, TN · Accident · Serious injuries · Final report · Sep 20, 2018 · N67WR · Substantial damage
  > The pilot's failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a partial loss of power and an aerodynamic stall.
- [NTSB CEN18LA382](https://openairdocs.org/ntsb/CEN18LA382.md): Cessna 206 · Sugar Land, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 2018 · N247F · Substantial damage
  > Fatigue failure of the No. 1 cylinder intake valve, which resulted in the loss of engine power.
- [NTSB WPR18LA268](https://openairdocs.org/ntsb/WPR18LA268.md): Piper PA24 · Upland, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2018 · N7472P · Substantial damage
  > Loss of engine power due to fuel contamination.
- [NTSB WPR18FA266](https://openairdocs.org/ntsb/WPR18FA266.md): Beech 33 · Cottonwood, AZ · Accident · 1 fatal · Class 2 · Field · Final report · Sep 17, 2018 · N2031D · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA18CA560](https://openairdocs.org/ntsb/GAA18CA560.md): Piper PA22 · Hillsdale, MI · Accident · Minor injuries · Data collection · Final report · Sep 17, 2018 · N3544A · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.
- [NTSB DCA18WA288](https://openairdocs.org/ntsb/DCA18WA288.md): Boeing 747 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Sep 16, 2018 · TC-ACM · Minor damage
  > The BFU of Germany has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on September 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the BFU of Germany's investigation under the provisions of ICAO…
- [NTSB ERA18FA251](https://openairdocs.org/ntsb/ERA18FA251.md): Columbia Aircraft Mfg LC41 · Woburn, MA · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2018 · N2536T · Destroyed
  > The pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.
- [NTSB GAA18CA549](https://openairdocs.org/ntsb/GAA18CA549.md): Aviat A1 · Bentonville, AR · Accident · Minor injuries · Data collection · Final report · Sep 12, 2018 · N868X · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during an attempted go-around after the airplane bounced, which resulted in an aerodynamic stall.
- [NTSB DCA18CA289](https://openairdocs.org/ntsb/DCA18CA289.md): Boeing 737 · Phoenix, AZ · Accident · Serious injuries · Data collection · Final report · Sep 11, 2018 · N950NN · No damage
  > an inadvertent encounter with wake turbulence.
- [NTSB ERA18FA244](https://openairdocs.org/ntsb/ERA18FA244.md): Cessna 335 · Lake Worth, FL · Accident · 2 fatal · Field investigation · Final report · Sep 9, 2018 · N2707J · Destroyed
  > The pilot's loss of control during approach for landing following a total loss of left engine power for undetermined reasons.
- [NTSB ANC18TA070](https://openairdocs.org/ntsb/ANC18TA070.md): Cessna U206 · Willow, AK · Accident · Serious injuries · Final report · Sep 9, 2018 · N8070Z · Substantial damage
  > The pilot receiving instruction's failure to maintain control during a night landing pattern crosswind turn due to spatial disorientation and the flight instructor's inadequate supervision and delayed remedial action, which resulted in impact with terrain.
- [NTSB WPR18FA253](https://openairdocs.org/ntsb/WPR18FA253.md): Commander 114 · Jean, NV · Accident · 1 fatal · Class 2 · Field · Final report · Sep 6, 2018 · N6064C · Destroyed
  > The pilot failed to maintain adequate speed while maneuvering at a low attitude during night and entered an aerodynamic stall and subsequent spin.
- [NTSB CEN18FA371](https://openairdocs.org/ntsb/CEN18FA371.md): Cessna 340A · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2018 · C-GLKX · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…
- [NTSB GAA18CA537](https://openairdocs.org/ntsb/GAA18CA537.md): Cessna 180 · Richmond, VA · Accident · No injuries · Data collection · Final report · Sep 5, 2018 · C-GODA · Substantial damage
  > The pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the total loss of engine power.
- [NTSB WPR18WA254](https://openairdocs.org/ntsb/WPR18WA254.md): Cessna 182M · Leshiba Wilderness, South Africa · Accident · Serious injuries · Foreign investigation · Sep 1, 2018 · ZS-IAM · Substantial damage
  > On September 1, 2018, at 1247 universal coordinated time, a Cessna 182M, ZS-IAM, collided with trees while on final approach to land at Leshiba Wilderness, South Africa. The pilot and passenger were seriously injured. The airplane was substantially damaged.…
- [NTSB ERA18LA241](https://openairdocs.org/ntsb/ERA18LA241.md): Diamond DA40 · Mount Pleasant, TN · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2018 · N388MA · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR18FA245](https://openairdocs.org/ntsb/WPR18FA245.md): Cessna P210 · Prescott, AZ · Accident · 1 fatal · Class 2 · Field · Final report · Aug 30, 2018 · N6500W · Destroyed
  > The pilot's misjudgment of distance and altitude from the runway and his subsequent failure to maintain an approach path that provided clearance from the terrain due to a visual illusion in dark night conditions.
- [NTSB CEN18FA358](https://openairdocs.org/ntsb/CEN18FA358.md): Beech B60 · Fort Walton Beach, FL · Accident · 4 fatal · Field investigation · Final report · Aug 30, 2018 · N1876L · Destroyed
  > The pilot's controlled flight into terrain after misidentifying the destination airport during a period of restricted visibility due to weather.
- [NTSB ERA18LA233](https://openairdocs.org/ntsb/ERA18LA233.md): Cessna 172 · New Kent, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 26, 2018 · N1537U · Substantial damage
  > The student pilot’s loss of airplane control during a go-around.
- [NTSB WPR18LA242](https://openairdocs.org/ntsb/WPR18LA242.md): Bell 212 · Dardanelle, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 25, 2018 · N512TA · Substantial damage
  > An in-flight failure of the trunnion bearing and subsequent failure of the drive link and swashplate support, which resulted in the loss of helicopter control.
- [NTSB ERA18FA232](https://openairdocs.org/ntsb/ERA18FA232.md): Piper PA22 · Island Pond, VT · Accident · 1 fatal · Field investigation · Final report · Aug 25, 2018 · N6936B · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.
- [NTSB GAA18CA507](https://openairdocs.org/ntsb/GAA18CA507.md): Vans RV10 · Spring Branch, TX · Accident · Minor injuries · Data collection · Final report · Aug 23, 2018 · N110DV · Substantial damage
  > The pilot's failure to maintain the proper glidepath and his subsequent abrupt maneuver to avoid trees, which led to the exceedance of the airplane's critical angle of attack and resulted in an aerodynamic stall during landing and a subsequent loss of…
- [NTSB GAA18CA503](https://openairdocs.org/ntsb/GAA18CA503.md): Champion 8GCBC · Elberta, AL · Accident · Minor injuries · Data collection · Final report · Aug 22, 2018 · N88287 · Substantial damage
  > The pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.
- [NTSB ANC18LA066](https://openairdocs.org/ntsb/ANC18LA066.md): Cessna A185F · Kaktovik, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 22, 2018 · N8041R · Substantial damage
  > A loss of engine power due to fuel starvation during a steep turn with a low fuel state.

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

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

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