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

## Cases, newest first

- [NTSB CEN19LA220](https://openairdocs.org/ntsb/CEN19LA220.md): Icon A5 · Wheeling, IL · Accident · No injuries · Class 3 · Limited · Final report · Jul 12, 2019 · N83BA · Substantial damage
  > The pilot’s decision to operate the engine above its maximum continuous speed for most of the flight, which led to fuel exhaustion and a subsequent total loss of engine power.
- [NTSB GAA19CA401](https://openairdocs.org/ntsb/GAA19CA401.md): Cessna 172 · Vineyard Haven, MA · Accident · No injuries · Data collection · Final report · Jul 11, 2019 · N677DM · Substantial damage
  > The pilot's failure to maintain lateral position in relation to the instrument approach course at night in instrument meteorological conditions, which resulted in collision with a tree.
- [NTSB DCA19WA183](https://openairdocs.org/ntsb/DCA19WA183.md): Boeing 747 · Harare, Zimbabwe · Incident · No injuries · Foreign investigation · Jul 9, 2019 · PH-CKA · Minor damage
  > The CAA of Zimbabwe has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAAZ's investigation under the provisions of ICAO Annex 13 as State…
- [NTSB ANC19LA031](https://openairdocs.org/ntsb/ANC19LA031.md): Cessna 208 · Bethel, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 8, 2019 · N9448B · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall at low altitude. Contributing to the accident, was the…
- [NTSB CEN19FA212](https://openairdocs.org/ntsb/CEN19FA212.md): Cessna 172 · Oxford, MS · Accident · 1 fatal · Class 2 · Field · Final report · Jul 6, 2019 · N994CP · Destroyed
  > The student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.
- [NTSB CEN19TA205](https://openairdocs.org/ntsb/CEN19TA205.md): Beech 23 · Vaiden, MS · Accident · Serious injuries · Class 3 · Final report · Jul 4, 2019 · N7618R · Substantial damage
  > The pilot's unstable approach and failure to properly configure the flaps during the attempted go-around, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN19LA186](https://openairdocs.org/ntsb/CEN19LA186.md): Cessna 150 · Omaha, NE · Accident · No injuries · Class 3 · Limited · Final report · Jun 28, 2019 · N5256Q · Substantial damage
  > The loss of engine power due to fuel starvation.
- [NTSB CEN19FA189](https://openairdocs.org/ntsb/CEN19FA189.md): Beechcraft 58 · Hiawatha, KS · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2019 · N4614S · Destroyed
  > The pilot's loss of control for undetermined reasons.
- [NTSB CEN19FA185](https://openairdocs.org/ntsb/CEN19FA185.md): Agusta A109 · Brainerd, MN · Accident · 2 fatal · Class 2 · Field · Final report · Jun 28, 2019 · N11NM · Substantial damage
  > The pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.
- [NTSB WPR19LA179](https://openairdocs.org/ntsb/WPR19LA179.md): Stinson 108 · Caldwell, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 27, 2019 · N6116M · Substantial damage
  > A total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.
- [NTSB ERA19FA201](https://openairdocs.org/ntsb/ERA19FA201.md): Beech E55 · Hope Mills, NC · Accident · 2 fatal · Class 2 · Field · Final report · Jun 27, 2019 · N664AR · Destroyed
  > The pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.
- [NTSB GAA19CA427](https://openairdocs.org/ntsb/GAA19CA427.md): Beech 35 · Caldwell, NJ · Accident · No injuries · Data collection · Final report · Jun 26, 2019 · N1361Z · Substantial damage
  > The pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.
- [NTSB CEN19LA184](https://openairdocs.org/ntsb/CEN19LA184.md): Piper J3C · Vine Grove, KY · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 23, 2019 · N70803 · Substantial damage
  > The pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.
- [NTSB CEN19WA288](https://openairdocs.org/ntsb/CEN19WA288.md): Zenair CH601 · Pont-A-Celles, Belgium · Accident · 2 fatal · Foreign investigation · Jun 22, 2019 · F-JDNG · Substantial damage
  > The government of Belgium has notified the National Transportation Safety Board (NTSB) of an accident involving a Zenair CH 601XL airplane that occurred on June 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of…
- [NTSB CEN19LA213](https://openairdocs.org/ntsb/CEN19LA213.md): Ercoupe 415 · Smithfield, RI · Accident · No injuries · Class 3 · Limited · Final report · Jun 22, 2019 · N415WP · Substantial damage
  > The pilot’s failure to use carburetor heat on approach in weather conditions conducive to carburetor icing, which resulted in a forced landing to a pond.
- [NTSB ERA19LA202](https://openairdocs.org/ntsb/ERA19LA202.md): Aeronca S7EC · Jasper, AL · Accident · No injuries · Class 3 · Limited · Final report · Jun 21, 2019 · N4349C · Substantial damage
  > A total loss of engine power due to fuel contamination.
- [NTSB CEN19LA179](https://openairdocs.org/ntsb/CEN19LA179.md): Piper PA28 · Cottrellville Township, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 21, 2019 · N2360R · Substantial damage
  > The partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…
- [NTSB GAA19CA363](https://openairdocs.org/ntsb/GAA19CA363.md): Cessna 150 · Elkader, IA · Accident · No injuries · Data collection · Final report · Jun 20, 2019 · N6471F · Substantial damage
  > The pilot's delayed decision to go around, which resulted in a collision with trees and terrain.
- [NTSB ERA19LA197](https://openairdocs.org/ntsb/ERA19LA197.md): Piper PA32 · Crisfield, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 15, 2019 · N2750Q · Substantial damage
  > The pilot's sudden incapacitation from an undiagnosed cardiac arrhythmia while on final approach, which resulted in descent and collision with trees and terrain.
- [NTSB CEN19LA167](https://openairdocs.org/ntsb/CEN19LA167.md): Ercoupe 415 · Hawkins, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 13, 2019 · N87294 · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB GAA19CA336](https://openairdocs.org/ntsb/GAA19CA336.md): Cessna 180 · Ontario, OR · Accident · Minor injuries · Data collection · Final report · Jun 10, 2019 · N3242D · Substantial damage
  > The pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB GAA19WA391](https://openairdocs.org/ntsb/GAA19WA391.md): Piper PA23 · Mulakot, Iceland · Accident · 3 fatal · Foreign investigation · Jun 9, 2019 · N3294P · Destroyed
- [NTSB ERA19LA186](https://openairdocs.org/ntsb/ERA19LA186.md): Alisport Silent 2 · Danbury, CT · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 4, 2019 · N66911 · Substantial damage
  > The pilot’s inadequate inflight management of the motor glider’s available battery power, which resulted in the inability of the electric motor to provide sufficient thrust to sustain flight in an environment where no atmospheric lift was available.
- [NTSB DCA19WA160](https://openairdocs.org/ntsb/DCA19WA160.md): Boeing 737 · Brussels, Belgium · Incident · No injuries · Foreign investigation · Jun 4, 2019 · G-JMCR · No damage
  > The Air Accident Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on June 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…
- [NTSB CEN19LA157](https://openairdocs.org/ntsb/CEN19LA157.md): Piper PA18 · Palm City, FL · Accident · Minor injuries · Class 3 · Limited · Final report · May 27, 2019 · N70699 · Substantial damage
  > A total loss of engine power due to fuel starvation.
- [NTSB ERA19FA179](https://openairdocs.org/ntsb/ERA19FA179.md): Cessna TR182 · St. Simons Island, GA · Accident · 1 fatal · Field investigation · Final report · May 25, 2019 · N6123T · Destroyed
  > The pilot's loss of airplane control during approach for undetermined reasons.
- [NTSB CEN19LA149](https://openairdocs.org/ntsb/CEN19LA149.md): Chistov Challenger · Raymond, MS · Accident · No injuries · Class 3 · Limited · Final report · May 22, 2019 · N638DC · Destroyed
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA19WA198](https://openairdocs.org/ntsb/ERA19WA198.md): Diamond DA 62 · Dubai, United Arab Emirates · Accident · 4 fatal · Foreign investigation · May 16, 2019 · G-MDME · Destroyed
  > The government of United Arab Emirates has notified the NTSB of an accident involving a Diamond DA 62 airplane that occurred on May 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab Emirates's…
- [NTSB CEN19FA143](https://openairdocs.org/ntsb/CEN19FA143.md): Beech 60 · Loveland, CO · Accident · 1 fatal · Field investigation · Final report · May 15, 2019 · N60RK · Destroyed
  > A loss of control due to an inflight right engine fire due to the loose fuel hose between the engine-driven fuel pump and the flow transducer.
- [NTSB ERA19FA170](https://openairdocs.org/ntsb/ERA19FA170.md): Piper PA 30 · Naples, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 11, 2019 · N7650Y · Destroyed
  > Incapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.
- [NTSB WPR19WA158](https://openairdocs.org/ntsb/WPR19WA158.md): JM Kemp RT13B · Mookgopong, South Africa · Accident · 2 fatal · Foreign investigation · May 10, 2019 · ZU-FUO · Destroyed
  > On May 10, 2019, about 1105 Coordinated Universal time, a JM Kemp RT13B, South African registry ZU-FUO, was destroyed when it impacted a ridge north of the Mountain View Lodge Airport, near the town of Mookgopong, Limpopo Province, South Africa. The pilot and…
- [NTSB WPR19LA141](https://openairdocs.org/ntsb/WPR19LA141.md): Flight Design Ctls · Boulder City, NV · Accident · Serious injuries · Class 3 · Limited · Final report · May 7, 2019 · N423EB · Substantial damage
  > The pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.
- [NTSB GAA19CA246](https://openairdocs.org/ntsb/GAA19CA246.md): Cessna 182 · Marion, IN · Accident · Minor injuries · Data collection · Final report · May 5, 2019 · N96974 · Destroyed
  > The pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.
- [NTSB WPR19LA136](https://openairdocs.org/ntsb/WPR19LA136.md): Piper PA28R · Winter Haven, FL · Accident · No injuries · Class 3 · Limited · Final report · May 4, 2019 · N2134T · Substantial damage
  > A partial loss of engine power due to worn fuel valve O-rings, which allowed air into the fuel system and resulted in a forced landing to unsuitable terrain.
- [NTSB CEN19LA133](https://openairdocs.org/ntsb/CEN19LA133.md): Cirrus SR20 · Mineral Wells, TX · Accident · No injuries · Class 3 · Limited · Final report · May 2, 2019 · N8160C · Substantial damage
  > The in-flight separation of the right aileron when the inboard hinge bolt disengaged from its nut plate due to excessively twisted safety wire, which resulted in a torsional overstress fracture that caused the inboard hinge bolt to become unsecured.
- [NTSB ERA19WA167](https://openairdocs.org/ntsb/ERA19WA167.md): Bell 206 · Sabanalarga, Colombia · Accident · No injuries · Foreign investigation · Apr 30, 2019 · HK3321 · Substantial damage
  > The government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…
- [NTSB WPR19FA124](https://openairdocs.org/ntsb/WPR19FA124.md): Vans RV 6 · Ridgefield, WA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 29, 2019 · N90LK · Substantial damage
  > The pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.
- [NTSB ERA19FA155](https://openairdocs.org/ntsb/ERA19FA155.md): Bellanca 1730 · Henderson, KY · Accident · 2 fatal · Class 2 · Field · Final report · Apr 23, 2019 · N9693E · Substantial damage
  > The student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…
- [NTSB ERA19LA157](https://openairdocs.org/ntsb/ERA19LA157.md): Barrows Bearhawk LSA · Holly Springs, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 22, 2019 · N289EH · Substantial damage
  > The pilot's failure to maintain clearance from powerlines during the visual approach.
- [NTSB CEN19FA124](https://openairdocs.org/ntsb/CEN19FA124.md): Beech 58 · Kerrville, TX · Accident · 6 fatal · Class 2 · Field · Final report · Apr 22, 2019 · N501CE · Substantial damage
  > The pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…
- [NTSB ERA19WA203](https://openairdocs.org/ntsb/ERA19WA203.md): Canadair CL600 1A11 · Rio de Janeiro, Brazil · Incident · No injuries · Foreign investigation · Apr 18, 2019 · N100QR · No damage
  > The government of Brazil has notified the NTSB of an incident involving a Canadair CL600 1A11 airplane that occurred on April 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB ERA19LA150](https://openairdocs.org/ntsb/ERA19LA150.md): Cessna 172 · New York, NY · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 14, 2019 · N5296H · Substantial damage
  > The pilot's decision to initiate a flight into low instrument flight rules conditions, which resulted in six missed approaches at two airports and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the external pressure the…
- [NTSB ERA19LA151](https://openairdocs.org/ntsb/ERA19LA151.md): Cessna 150 · Fulton, NY · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 11, 2019 · N3795J · Substantial damage
  > A total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.
- [NTSB ERA19LA149](https://openairdocs.org/ntsb/ERA19LA149.md): Piper PA28R · Meriden, CT · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 11, 2019 · N38658 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN19LA116](https://openairdocs.org/ntsb/CEN19LA116.md): Berkey S-6ES · Lafe, AR · Accident · No injuries · Class 3 · Limited · Final report · Apr 2, 2019 · N265GB · Substantial damage
  > The non-certificated pilot's failure to maintain an appropriate glidepath while landing toward the sun, which resulted in impact with vegetation and a subsequent loss of control.
- [NTSB GAA19WA188](https://openairdocs.org/ntsb/GAA19WA188.md): Piper J3C · Snowshoe Lake, Ontario, Canada · Accident · 1 fatal · Foreign investigation · Mar 30, 2019 · C-FLDQ · Substantial damage
- [NTSB ENG19WA016](https://openairdocs.org/ntsb/ENG19WA016.md): Boeing 787 · Osaka, Japan · Incident · No injuries · Foreign investigation · Mar 29, 2019 · VH-VKJ · No damage
  > On March 29, 2019, a Boeing 787, powered by two General Electric GEnx 1B64P2 turbofan engines and operated by Jetstar Airways, experienced a dual engine event while descending to land at the Kansai International Airport (RJBB), Osaka, Japan. During descent,…
- [NTSB GAA19CA185](https://openairdocs.org/ntsb/GAA19CA185.md): Rockwell S 2R · Hermiston, OR · Accident · Minor injuries · Data collection · Final report · Mar 28, 2019 · N4250X · Substantial damage
  > The pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.
- [NTSB ERA19CA289](https://openairdocs.org/ntsb/ERA19CA289.md): Piper PA28 · Winder, GA · Accident · No injuries · Data collection · Final report · Mar 28, 2019 · N6412W · Substantial damage
  > The student pilot’s loss of airplane control, the flight instructor's delayed remedial action, and the student's delay in relinquishing the flight controls, which resulted in the airplane striking a runway sign during a go-around.
- [NTSB DCA19CA130](https://openairdocs.org/ntsb/DCA19CA130.md): Boeing 737 · Nashville, TN · Accident · No injuries · Data collection · Final report · Mar 28, 2019 · N249WN · Substantial damage
  > a collision with a bird.

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

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

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