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

## Cases, newest first

- [NTSB WPR18FA229](https://openairdocs.org/ntsb/WPR18FA229.md): James E Causey Acroduster II · Phoenix, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2018 · N787WM · Substantial damage
  > An exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.
- [NTSB DCA18WA278](https://openairdocs.org/ntsb/DCA18WA278.md): Airbus A321-271N · Tapachula, Mexico · Incident · No injuries · Foreign investigation · Aug 20, 2018 · N535VL · Minor damage
  > The government of Mexico has notified the NTSB of an accident involving a AIRBUS A321-271N airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…
- [NTSB ERA18FA221](https://openairdocs.org/ntsb/ERA18FA221.md): Quicksilver MXL II Sport · Westminster, MD · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2018 · N105SE · Substantial damage
  > The in-flight fracture of a stainless steel bolt that was used to secure the upper and lower wing cables to the outer attach point at the leading edge spar of the right wing due to stress corrosion cracking, which caused the right wing to fail and precluded…
- [NTSB GAA18CA490](https://openairdocs.org/ntsb/GAA18CA490.md): Cessna 172 · DePere, WI · Accident · Serious injuries · Data collection · Final report · Aug 14, 2018 · N1085U · Substantial damage
  > The pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.
- [NTSB WPR18FA219](https://openairdocs.org/ntsb/WPR18FA219.md): Beech A36TC · Sylmar, CA · Accident · 1 fatal · Field investigation · Final report · Aug 12, 2018 · N136RM · Substantial damage
  > The pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR18FA218](https://openairdocs.org/ntsb/WPR18FA218.md): Mooney M20K · Baker City, OR · Accident · 2 fatal · Field investigation · Final report · Aug 11, 2018 · N231EC · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…
- [NTSB DCA18IA265](https://openairdocs.org/ntsb/DCA18IA265.md): Gulfstream G IV · Philadelphia, PA · Incident · No injuries · Class 3 · Incident · Final report · Aug 11, 2018 · N619A · No damage
  > The flight crew’s misalignment of the airplane with a taxiway instead of the assigned runway, resulting in a low-altitude go-around late in the final approach and reduced separation with the airplanes on the taxiway.
- [NTSB WPR18LA215](https://openairdocs.org/ntsb/WPR18LA215.md): Cessna T337 · Lewiston, ID · Accident · No injuries · Limited investigation · Final report · Aug 9, 2018 · N255 · Substantial damage
  > The liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…
- [NTSB CEN18CA323](https://openairdocs.org/ntsb/CEN18CA323.md): Cessna 172 · Greeley, CO · Accident · No injuries · Data collection · Final report · Aug 9, 2018 · N20JA · Substantial damage
  > The pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…
- [NTSB GAA18CA470](https://openairdocs.org/ntsb/GAA18CA470.md): Walter C Smythe Tango XR · Mansfield, OH · Accident · Minor injuries · Data collection · Final report · Aug 6, 2018 · N454WS · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall.
- [NTSB WPR18TA212](https://openairdocs.org/ntsb/WPR18TA212.md): ICP Savannah · Fairfield, UT · Accident · Minor injuries · Final report · Aug 5, 2018 · N951RA · Substantial damage
  > The pilot's failure to maintain airplane control after encountering a downdraft on approach to the runway.
- [NTSB CEN18LA319](https://openairdocs.org/ntsb/CEN18LA319.md): Beech 35 · Knox, IN · Accident · No injuries · Limited investigation · Final report · Aug 4, 2018 · N533JW · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR18FA210](https://openairdocs.org/ntsb/WPR18FA210.md): Mooney M20J · Lopez Island, WA · Accident · 2 fatal · Field investigation · Final report · Aug 3, 2018 · N56039 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…
- [NTSB CEN18WA394](https://openairdocs.org/ntsb/CEN18WA394.md): Piper PA28 · Décines, France · Accident · No injuries · Foreign investigation · Aug 2, 2018 · F-GKEC · Substantial damage
  > On August 2, 2018, about 1930 UTC, a Piper PA-28-181 airplane, French registration F-GKEC, sustained a loss of engine power while on approach to the Lyon-Bron Airport (LFLY), near Décines, France. The two occupants onboard sustained no injury. The airplane…
- [NTSB CEN18LA306](https://openairdocs.org/ntsb/CEN18LA306.md): Bell 47G 3B · Custer, SD · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 2, 2018 · N347BH · Substantial damage
  > The pilot’s mismanagement of rotor RPM and subsequent forced landing on uneven terrain which led to a dynamic rollover.
- [NTSB CEN18LA302](https://openairdocs.org/ntsb/CEN18LA302.md): Beech A36 · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Jul 30, 2018 · N1856W · Substantial damage
  > Total loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.
- [NTSB ERA18WA209](https://openairdocs.org/ntsb/ERA18WA209.md): Beech 90 · Sao Paulo, Brazil · Accident · 1 fatal · Foreign investigation · Jul 29, 2018 · PP-SZN · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Beech C90 that occurred on July 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO Annex…
- [NTSB WPR18LA207](https://openairdocs.org/ntsb/WPR18LA207.md): Cessna 172 · Mount Vernon, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2018 · N785SP · Destroyed
  > An in-flight fuel-fed fire from an unknown source for reasons that could not be determined due to the extensive fire damage to the airplane.
- [NTSB GAA18CA466](https://openairdocs.org/ntsb/GAA18CA466.md): Vans RV9 · Holland, MI · Accident · No injuries · Data collection · Final report · Jul 28, 2018 · N899RV · Substantial damage
  > The pilot’s failure to maintain yaw control during a go-around.
- [NTSB CEN18CA291](https://openairdocs.org/ntsb/CEN18CA291.md): Quad City Challenger · Oshkosh, WI · Accident · No injuries · Data collection · Final report · Jul 23, 2018 · N1666R · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB GAA18CA519](https://openairdocs.org/ntsb/GAA18CA519.md): Cessna 150 · Everett, WA · Accident · No injuries · Data collection · Final report · Jul 22, 2018 · N45586 · Substantial damage
  > A total loss of engine power due to carburetor icing during final approach, which resulted in a hard landing short of the runway and the nose landing gear collapsing.
- [NTSB CEN18LA278](https://openairdocs.org/ntsb/CEN18LA278.md): Aero Commander S2R · Vinton, IA · Accident · No injuries · Class 3 · Limited · Final report · Jul 17, 2018 · N5553X · Substantial damage
  > Loss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.
- [NTSB CEN18FA267](https://openairdocs.org/ntsb/CEN18FA267.md): Kolb Twinstar · La Porte, TX · Accident · 2 fatal · Field investigation · Final report · Jul 15, 2018 · N3135J · Substantial damage
  > The pilot's failure to maintain airspeed during a visual approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall at an altitude too low for recovery.
- [NTSB ERA18TA193](https://openairdocs.org/ntsb/ERA18TA193.md): Quicksilver MXL II · Arecibo, PR · Accident · Serious injuries · Final report · Jul 14, 2018 · N594TC · Substantial damage
  > The noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA18LA192](https://openairdocs.org/ntsb/ERA18LA192.md): Schweizer 269D · Stewartstown, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 14, 2018 · N411HU · Substantial damage
  > The pilot's inability to maintain yaw control while transitioning to an out of ground effect hover due to a loss of tail rotor effectiveness.
- [NTSB WPR18LA193](https://openairdocs.org/ntsb/WPR18LA193.md): Cessna 150 · Ontario, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 12, 2018 · N6908G · Destroyed
  > A total loss of engine power during final approach for reasons that could not be determined based on the available information.
- [NTSB ERA18FA189](https://openairdocs.org/ntsb/ERA18FA189.md): Rutan Defiant · Plainville, CT · Accident · 1 fatal · Field investigation · Final report · Jul 12, 2018 · N17DR · Substantial damage
  > The pilot's loss of airplane control during climb for reasons that could not be determined based on the available information.
- [NTSB CEN18WA264](https://openairdocs.org/ntsb/CEN18WA264.md): Cessna 152 · Ponte de Sor, Portugal · Accident · 1 fatal · Foreign investigation · Jul 10, 2018 · CS-DGU · Destroyed
  > The government of Portugal has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…
- [NTSB GAA18CA395](https://openairdocs.org/ntsb/GAA18CA395.md): Costruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CA · Accident · No injuries · Data collection · Final report · Jul 5, 2018 · N75SY · Substantial damage
  > The pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.
- [NTSB GAA18CA394](https://openairdocs.org/ntsb/GAA18CA394.md): Evektor Aerotechnik Sportstar · Louisburg, NC · Accident · No injuries · Data collection · Final report · Jul 5, 2018 · N902HB · Substantial damage
  > The student pilot's distraction due to a previous runway excursion and navigational issues during the accident flight and his failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the downwind leg, which…
- [NTSB CEN18LA257](https://openairdocs.org/ntsb/CEN18LA257.md): Piper PA46 · Springhill, LA · Accident · No injuries · Class 3 · Limited · Final report · Jul 3, 2018 · N689KC · Substantial damage
  > The pilot’s exceedance of the airplane's critical angle of attack during an improper go-around procedure which resulted in an aerodynamic stall.
- [NTSB ENG18WA039](https://openairdocs.org/ntsb/ENG18WA039.md): Mcdonnell Douglas MD80 · Songshan, Taipei, China, Taiwan · Incident · No injuries · Foreign investigation · Jul 2, 2018 · B28035 · No damage
  > On July 2, 2018, Far Eastern Air Transport, flight FE8026, an MD82 aircraft, registration number B-28035, took off from Penghu Airport for Songsang Airport. The aircraft declared PAN PAN at 7 miles from the runway of Songshan Airport at an altitude of 2,800…
- [NTSB CEN18LA251](https://openairdocs.org/ntsb/CEN18LA251.md): Robinson R22 · Georgetown, TX · Accident · No injuries · Limited investigation · Final report · Jul 2, 2018 · N830J · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information, which resulted in an impact with terrain during the subsequent forced landing.
- [NTSB CEN18LA246](https://openairdocs.org/ntsb/CEN18LA246.md): Cessna 337 · Baldwin City, KS · Accident · No injuries · Limited investigation · Final report · Jun 30, 2018 · N107BL · Substantial damage
  > The loss of hydraulic accumulator pressure for reasons that could not be determined, which prevented the propeller from unfeathering, and the pilot's improper decision to attempt a go-around, which resulted in an off-airport landing and the airplane impacting…
- [NTSB CEN18LA239](https://openairdocs.org/ntsb/CEN18LA239.md): Sibila MH-1 · Beach City, OH · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 2018 · N32KS · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN18FA236](https://openairdocs.org/ntsb/CEN18FA236.md): Cessna P210N · Detroit, MI · Accident · 2 fatal · Field investigation · Final report · Jun 24, 2018 · N3896P · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…
- [NTSB CEN18LA237](https://openairdocs.org/ntsb/CEN18LA237.md): Zenith Stol CH701 · Maple Lake, MN · Accident · No injuries · Limited investigation · Final report · Jun 22, 2018 · N736MM · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN18TA233](https://openairdocs.org/ntsb/CEN18TA233.md): Cessna 150F · Ferdinand, IN · Accident · Serious injuries · Final report · Jun 19, 2018 · N3002X · Substantial damage
  > The pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.
- [NTSB CEN18LA230](https://openairdocs.org/ntsb/CEN18LA230.md): Cessna TR182 · Beloit, KS · Accident · No injuries · Limited investigation · Final report · Jun 18, 2018 · N756SW · Substantial damage
  > The mechanic’s failure to properly torque one of the left brake caliper’s back plate attachment bolts while re-installing it during the annual inspection, which resulted in the left main landing gear not extending before landing.
- [NTSB DCA18CA201](https://openairdocs.org/ntsb/DCA18CA201.md): Boeing 777 223 · Decatur, TX · Accident · Serious injuries · Data collection · Final report · Jun 10, 2018 · N750AN · No damage
  > the passengers failure to comply with the fasten seatbelt sign when the airplane encountered convective turbulence.
- [NTSB CEN18FA216](https://openairdocs.org/ntsb/CEN18FA216.md): Cessna T182T · Monroe, WI · Accident · 4 fatal · Field investigation · Final report · Jun 10, 2018 · N1880B · Destroyed
  > Spatial disorientation resulting in a loss of control during the missed approach conducted in instrument meteorological conditions. Contributing to the accident was the pilot's decision to execute an instrument approach in weather conditions that were below…
- [NTSB ERA18LA164](https://openairdocs.org/ntsb/ERA18LA164.md): Piper PA 44 · Daytona Beach, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 9, 2018 · N21161 · Substantial damage
  > The pilots’ improper in-flight weather evaluation and decision to continue the approach, which resulted in an encounter with a thunderstorm, a loss of airplane control, and collision with terrain. Contributing to the accident was the flight instructor’s…
- [NTSB WPR18WA187](https://openairdocs.org/ntsb/WPR18WA187.md): Cessna 172 · Moorabbin, Australia · Accident · 1 fatal · Foreign investigation · Jun 8, 2018 · VH-EWE · Substantial damage
- [NTSB CEN18LA218](https://openairdocs.org/ntsb/CEN18LA218.md): Aerovodochody L 29 Delfin · Moriarty, NM · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 2018 · N4323N · Substantial damage
  > The pilot’s failure to maintain a proper glidepath during a visual approach and the flight instructor’s delayed remedial action, which resulted in ground impact before the runway.
- [NTSB CEN18LA197](https://openairdocs.org/ntsb/CEN18LA197.md): Fairchild M 62C(PT-23A) · Wichita, KS · Accident · Minor injuries · Limited investigation · Final report · May 28, 2018 · N64176 · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.
- [NTSB CEN18LA205](https://openairdocs.org/ntsb/CEN18LA205.md): Cessna 150L · Union, IL · Accident · Serious injuries · Limited investigation · Final report · May 27, 2018 · N19366 · Substantial damage
  > The pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.
- [NTSB WPR18LA148](https://openairdocs.org/ntsb/WPR18LA148.md): Cessna 152 · Hillsboro, OR · Accident · No injuries · Class 3 · Limited · Final report · May 26, 2018 · N152GB · Substantial damage
  > The partial loss of engine power during a go-around due to the loose copper electrode finger inside the left magneto.
- [NTSB ANC18LA038](https://openairdocs.org/ntsb/ANC18LA038.md): James Wiebe Belite Pipper · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · May 24, 2018 · N3748 · Substantial damage
  > An inadequate fuel supply to the engine, which resulted in a total loss of engine power and subsequent impact with terrain.
- [NTSB WPR18CA146](https://openairdocs.org/ntsb/WPR18CA146.md): Ayres S2R G10 · Marysville, CA · Accident · No injuries · Data collection · Final report · May 22, 2018 · N32064 · Substantial damage
  > The pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.
- [NTSB GAA18CA291](https://openairdocs.org/ntsb/GAA18CA291.md): Piper PA28 · Farmingdale, NY · Accident · Minor injuries · Data collection · Final report · May 21, 2018 · N5560W · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.

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

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

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