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

## Cases, newest first

- [NTSB ERA20CA211](https://openairdocs.org/ntsb/ERA20CA211.md): Piper PA22 · Olean, NY · Accident · No injuries · Class 4 · Data collection · Final report · Jun 5, 2020 · N5044Z · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ERA20CA204](https://openairdocs.org/ntsb/ERA20CA204.md): Sonex Sonex · New Smyrna Beach, FL · Accident · Minor injuries · Class 4 · Data collection · Final report · Jun 3, 2020 · N187PB · Substantial damage
  > The pilot failed to maintain an adequate airspeed while on final approach and impacted terrain.
- [NTSB ANC20CA056](https://openairdocs.org/ntsb/ANC20CA056.md): Piper PA18 · Nikiski, AK · Accident · No injuries · Class 4 · Data collection · Final report · Jun 2, 2020 · N8987Y · Substantial damage
  > The pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a ground loop.
- [NTSB WPR20CA158](https://openairdocs.org/ntsb/WPR20CA158.md): Cessna P210 · Heber City, UT · Accident · No injuries · Class 4 · Data collection · Final report · May 31, 2020 · N5404W · Substantial damage
  > The pilots failure to switch the fuel pump to the 'OFF' position during landing, resulting in a loss of engine power and subsequent collision with a fence during landing. Contributing to the accident was a modified before landing checklist which omitted the…
- [NTSB ERA20LA195](https://openairdocs.org/ntsb/ERA20LA195.md): Piper PA24 · South Boston, VA · Accident · No injuries · Class 3 · Limited · Final report · May 26, 2020 · N5948P · Substantial damage
  > The powerplant mechanic’s failure to properly affix the engine crankshaft gear lockplate during overhaul, resulting in a total loss of engine power.
- [NTSB ANC20CA054](https://openairdocs.org/ntsb/ANC20CA054.md): Cessna 120 · Gulkana, AK · Accident · No injuries · Class 4 · Data collection · Final report · May 24, 2020 · N72536 · Substantial damage
  > The pilot's failure to maintain proper airspeed during final approach to landing, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.
- [NTSB DCA20WA108](https://openairdocs.org/ntsb/DCA20WA108.md): Airbus A320 · Karachi, Pakistan · Accident · 97 fatal · Foreign investigation · May 22, 2020 · AP-BLD · Destroyed
  > The government of Pakistan has notified the NTSB of an accident involving an AIRBUS A320 with CFM56 engines that occurred on May 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…
- [NTSB WPR20LA152](https://openairdocs.org/ntsb/WPR20LA152.md): Cirrus SR20 · Santa Maria, CA · Accident · 1 fatal · Class 3 · Limited · Final report · May 20, 2020 · N883PJ · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during a steep and descending turn to final approach, which resulted in an aerodynamic stall and loss of control.
- [NTSB CEN20LA186](https://openairdocs.org/ntsb/CEN20LA186.md): Cessna T206 · Center, TX · Accident · 2 fatal · Class 3 · Limited · Final report · May 20, 2020 · N51610 · Substantial damage
  > The non-instrument rated pilot’s intentional flight into instrument meteorological conditions (clouds) which resulted in spatial disorientation and an inflight loss of control.
- [NTSB WPR21WA018](https://openairdocs.org/ntsb/WPR21WA018.md): Osprey 2 Amphibian · Maitland Aerodrome, Australia · Accident · 1 fatal · Class 5 · Foreign · May 17, 2020 · VH-WID · Destroyed
- [NTSB WPR20LA161](https://openairdocs.org/ntsb/WPR20LA161.md): Beech 35 · Cascade Locks, OR · Accident · Minor injuries · Class 3 · Limited · Final report · May 17, 2020 · N8359D · Substantial damage
  > The pilot’s improper fuel tank selection which resulted in fuel starvation to the engine and a loss of engine power.
- [NTSB ERA20LA188](https://openairdocs.org/ntsb/ERA20LA188.md): Vaughn Challenger · Clarksville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · May 16, 2020 · N97KV · Substantial damage
  > The loss of engine power due to carburetor ice.
- [NTSB ERA20LA183](https://openairdocs.org/ntsb/ERA20LA183.md): Ercoupe 415 · Rogersville, TN · Accident · 1 fatal · Class 3 · Limited · Final report · May 15, 2020 · N3956H · Destroyed
  > The pilot's failure to maintain a proper glidepath on approach, which resulted in an inflight collision with trees and terrain. Contributing to the accident was the pilot’s use of an impairing medication.
- [NTSB CEN20LA179](https://openairdocs.org/ntsb/CEN20LA179.md): Cessna P210 · Burlington, WI · Accident · 1 fatal · Class 3 · Limited · Final report · May 15, 2020 · N1JA · Substantial damage
  > The pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.
- [NTSB ERA20WA170](https://openairdocs.org/ntsb/ERA20WA170.md): Learjet 35 · Esquel, Argentina · Accident · 1 fatal · Foreign investigation · May 6, 2020 · LV-BXU · Substantial damage
  > The government of Argentina has notified the NTSB of an accident involving a LEARJET 35 airplane that occurred on May 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…
- [NTSB ENG20LA031](https://openairdocs.org/ntsb/ENG20LA031.md): Airbus Helicopters AS350 · Clewiston, FL · Incident · No injuries · Class 3 · Limited · Final report · May 3, 2020 · N1WT · No damage
  > Seizure of the hydraulic pump pulley bearing due to its improper installation by the manufacturer, leading to a failure of the hydraulic pump belt and the resultant partial loss of hydraulic assistance to the pedals.
- [NTSB CEN20LA169](https://openairdocs.org/ntsb/CEN20LA169.md): Rans S-12 · Delta, CO · Accident · 1 fatal · Class 3 · Limited · Final report · May 3, 2020 · N427LB · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during a test flight which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA20LA164](https://openairdocs.org/ntsb/ERA20LA164.md): Piper PA32RT · Meridianville, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 27, 2020 · N772SG · Substantial damage
  > The pilot's slip maneuver with a less than full fuel tank selected, which resulted in unporting of the fuel supply, and a total loss of engine power due to fuel starvation.
- [NTSB ERA20LA163](https://openairdocs.org/ntsb/ERA20LA163.md): Piper PA28 · East Hampton, NY · Accident · No injuries · Class 3 · Limited · Final report · Apr 25, 2020 · N33005 · Substantial damage
  > The partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.
- [NTSB CEN20CA154](https://openairdocs.org/ntsb/CEN20CA154.md): Cessna 172 · Ft Worth, TX · Accident · No injuries · Data collection · Final report · Apr 22, 2020 · N13005 · Substantial damage
  > The student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.
- [NTSB ERA20CA155](https://openairdocs.org/ntsb/ERA20CA155.md): Grumman AA5 · Bloomingdale, GA · Accident · Serious injuries · Data collection · Final report · Apr 21, 2020 · N314JG · Substantial damage
  > The pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.
- [NTSB WPR20LA126](https://openairdocs.org/ntsb/WPR20LA126.md): Cessna 152 · Corona, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 19, 2020 · N6306P · Substantial damage
  > The pilot's failure to use carburetor heat while operating in conditions conducive to serious carburetor icing, which resulted in a total loss of engine power.
- [NTSB ANC20CA041](https://openairdocs.org/ntsb/ANC20CA041.md): Piper PA 18A · Chickaloon, AK · Accident · No injuries · Data collection · Final report · Apr 7, 2020 · N2791P · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which necessitated a go-around, and her subsequent failure to maintain clearance from rising mountainous terrain.
- [NTSB ERA20CA146](https://openairdocs.org/ntsb/ERA20CA146.md): Cessna 172 · Hollywood, FL · Accident · No injuries · Data collection · Final report · Apr 1, 2020 · N734HF · Substantial damage
  > The pilot’s failure to apply full engine power during the initiation of a go-around in gusting wind conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at low altitude, and the flight instructor's…
- [NTSB ERA20CA143](https://openairdocs.org/ntsb/ERA20CA143.md): Diamond DA42 · Palm Coast, FL · Accident · No injuries · Data collection · Final report · Apr 1, 2020 · N311ER · Substantial damage
  > The pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.
- [NTSB CEN20LA134](https://openairdocs.org/ntsb/CEN20LA134.md): Muse P51D · Mesquite, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 29, 2020 · N151JD · Destroyed
  > The pilot’s inadvertent exceedance of the airplane’s critical angle of attack for undetermined reasons, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.
- [NTSB ENG20WA029](https://openairdocs.org/ntsb/ENG20WA029.md): Airbus A300 · Brussles, Belgium · Incident · No injuries · Foreign investigation · Mar 27, 2020 · D-AZMK · Minor damage
  > On March 27, 2020, the Danish Aviation Accident Investigation Board (AAIB) informed the NTSB of an Airbus A300-622RF cargo airplane, powered by two Pratt & Whitney PW4158 turbofan engines, that experienced a right (No. 2) engine failure during approach to…
- [NTSB CEN20LA131](https://openairdocs.org/ntsb/CEN20LA131.md): Bower Challenger II · Lettsworth, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 22, 2020 · N6138Z · Substantial damage
  > The owner/pilot's inability to maintain control of the airplane due to his lack of training and experience, resulting in a collision with a tree.
- [NTSB ERA20CA135](https://openairdocs.org/ntsb/ERA20CA135.md): AugustaWestland AW119MKII · Philadelphia, PA · Accident · No injuries · Data collection · Final report · Mar 21, 2020 · N982SS · Substantial damage
  > The in-flight failure of the lower left side of the engine cowling due to the mechanic’s improper installation of the fasteners, which resulted in the cowling impacting all four main rotor blades.
- [NTSB CEN20LA127](https://openairdocs.org/ntsb/CEN20LA127.md): Piper PA28R · Pleasant Plain, OH · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 19, 2020 · N3943T · Destroyed
  > The pilot’s encounter with convective turbulence and low-level wind shear in dark night instrument meteorological conditions that resulted in spatial disorientation and the loss of airplane control.
- [NTSB ERA20LA129](https://openairdocs.org/ntsb/ERA20LA129.md): Cirrus SR22 · Conway, SC · Accident · No injuries · Class 3 · Limited · Final report · Mar 17, 2020 · N150X · Substantial damage
  > The pilot’s incorrect use of the autopilot while approaching the initial approach fix and his subsequent improper primary pitch control input while a pitch mode of the autopilot was engaged, which resulted in pitch excursions and subsequent departure from…
- [NTSB WPR20LA110](https://openairdocs.org/ntsb/WPR20LA110.md): Piper PA22 · Pinedale, WY · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 16, 2020 · N4837Z · Substantial damage
  > A loss of airplane control during approach for reasons that could not be determined based on available evidence.
- [NTSB WPR20FA108](https://openairdocs.org/ntsb/WPR20FA108.md): Mooney M20K · Sylmar, CA · Accident · 2 fatal · Class 3 · Field · Final report · Mar 13, 2020 · N777WP · Substantial damage
  > The pilot’s spatial disorientation during an instrument approach in instrument meteorological conditions, which resulted in loss of control of the airplane.
- [NTSB CEN20LA118](https://openairdocs.org/ntsb/CEN20LA118.md): Piper PA32R · Rensselaer, IN · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 11, 2020 · N599ST · Destroyed
  > The non-instrument rated pilot’s failure to establish a climb while initiating a missed approach after conducting an instrument approach below weather minimums.
- [NTSB ERA20LA122](https://openairdocs.org/ntsb/ERA20LA122.md): Beech V35 · Destin, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 8, 2020 · N581U · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA20CA116](https://openairdocs.org/ntsb/ERA20CA116.md): Let L 23 Super Blanik · Huntsville, AL · Accident · Serious injuries · Data collection · Final report · Mar 1, 2020 · N296BA · Substantial damage
  > The pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.
- [NTSB ERA20CA120](https://openairdocs.org/ntsb/ERA20CA120.md): Learjet 35 · Altoona, PA · Accident · No injuries · Data collection · Final report · Feb 29, 2020 · N721EC · Substantial damage
  > The pilot flying's improper lateral bank control during a go-around in gusting wind conditions, which resulted in the left-wing tip tank striking the runway.
- [NTSB CEN20FA108](https://openairdocs.org/ntsb/CEN20FA108.md): Cessna 150 · Port Isabel, TX · Accident · 1 fatal · Class 3 · Field · Final report · Feb 29, 2020 · N407WJ · Destroyed
  > The pilot’s loss of control during the initial takeoff climb for reasons that could not be determined based on available evidence.
- [NTSB WPR20LA104](https://openairdocs.org/ntsb/WPR20LA104.md): Piper PA46 · San Jose, CA · Accident · No injuries · Class 3 · Limited · Final report · Feb 28, 2020 · N304LA · Substantial damage
  > The failure to properly service the hydraulic power pack prevented a normal landing gear extension. Contributing to the accident was the failure of the landing gear emergency release valve to function properly for reasons that could not be determined based on…
- [NTSB CEN20CA104](https://openairdocs.org/ntsb/CEN20CA104.md): Champion 7ECA · Athens, TX · Accident · Minor injuries · Data collection · Final report · Feb 27, 2020 · N2987Z · Substantial damage
  > The rear seat pilot and the student pilot's failure to see and avoid trees during initial climb following an aborted landing.
- [NTSB CEN20WA097](https://openairdocs.org/ntsb/CEN20WA097.md): Piper PA60 · Pamplona, Spain · Accident · 1 fatal · Foreign investigation · Feb 20, 2020 · EC-HRJ · Destroyed
  > The National Transportation Safety Board was notified of an accident involving a Piper PA-60-602P, EC-HRJ, in Pamplona, Spain. This investigation is under the jurisdiction of the Comisión de Investigación de Accidentes e Incidentes de Aviación Civil in Spain.
- [NTSB GAA20WA135](https://openairdocs.org/ntsb/GAA20WA135.md): Piper PA32 · Fort-de-France, Martinique · Accident · No injuries · Foreign investigation · Feb 16, 2020 · F-OKGO · Destroyed
- [NTSB ERA20CA102](https://openairdocs.org/ntsb/ERA20CA102.md): Cessna 172 · Rochester, NY · Accident · No injuries · Data collection · Final report · Feb 16, 2020 · N1126U · Substantial damage
  > The pilot's failure to maintain airplane control during a go-around. Contributing to the accident was the pilot’s decision to take off after perceiving a rudder issue during taxi operations.
- [NTSB ENG20LA016](https://openairdocs.org/ntsb/ENG20LA016.md): Airbus A319 · Sacramento, CA · Incident · No injuries · Class 3 · Limited · Final report · Feb 15, 2020 · N521NK · No damage
  > A worn component within each engine integrated drive generator (IDG) resulted in the loss of electrical power supplied to several flight deck displays and systems while on approach to landing. The component, a fixed cylinder block, had significant wearing of…
- [NTSB CEN20LA092](https://openairdocs.org/ntsb/CEN20LA092.md): Cessna 150 · Wadsworth, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 15, 2020 · N714ER · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN20CA086](https://openairdocs.org/ntsb/CEN20CA086.md): Cessna 182 · Huron, SD · Accident · No injuries · Data collection · Final report · Feb 15, 2020 · N2019A · Substantial damage
  > The pilot's failure to maintain adequate airspeed during final approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.
- [NTSB WPR20CA102](https://openairdocs.org/ntsb/WPR20CA102.md): Mooney M20K · Minden, NV · Accident · No injuries · Data collection · Final report · Feb 14, 2020 · N231VM · Substantial damage
  > The pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA20FA101](https://openairdocs.org/ntsb/ERA20FA101.md): Mooney M20J · Bartow, FL · Accident · 2 fatal · Class 3 · Field · Final report · Feb 13, 2020 · N1149T · Substantial damage
  > The pilot’s exceedance of the airplane's critical angle of attack and subsequent aerodynamic stall and spin at low altitude due to a possible distraction in the cockpit for which the reason was undetermined.
- [NTSB ERA20FA097](https://openairdocs.org/ntsb/ERA20FA097.md): Aviastroitel AC 4C · Front Royal, VA · Accident · 1 fatal · Class 3 · Field · Final report · Feb 9, 2020 · N912ES · Substantial damage
  > The pilot's exceedance of the glider’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB CEN20FA076](https://openairdocs.org/ntsb/CEN20FA076.md): Beech 33 · Granbury, TX · Accident · 1 fatal · Class 3 · Field · Final report · Feb 8, 2020 · N6665U · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.

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

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

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