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

## Cases, newest first

- [NTSB ERA18FA005](https://openairdocs.org/ntsb/ERA18FA005.md): Bryant C Crosby BC Ultra PUP · Bardstown, KY · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2017 · N484HC · Substantial damage
  > The pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…
- [NTSB ERA18LA002](https://openairdocs.org/ntsb/ERA18LA002.md): Cessna 182 · San Juan, PR · Accident · 1 fatal · Limited investigation · Final report · Oct 2, 2017 · N9021X · Substantial damage
  > The pilot's failure to maintain adequate distance from helicopters during the approach for landing, resulting in an encounter with wake turbulence and subsequent loss of control.
- [NTSB ERA17LA341](https://openairdocs.org/ntsb/ERA17LA341.md): Cessna 162 · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Sep 28, 2017 · N552ES · Substantial damage
  > The flight instructor’s failure to use carburetor heat, which resulted in the total loss of engine power due to carburetor icing.
- [NTSB GAA17CA559](https://openairdocs.org/ntsb/GAA17CA559.md): Cessna 182 · San Diego, CA · Accident · No injuries · Data collection · Final report · Sep 27, 2017 · N9346G · Substantial damage
  > The airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.
- [NTSB CEN17LA376](https://openairdocs.org/ntsb/CEN17LA376.md): Cessna 182M · Piqua, OH · Accident · No injuries · Limited investigation · Final report · Sep 27, 2017 · N70634 · Substantial damage
  > The accumulation of carburetor ice while operating at a reduced engine power setting, which resulted in a total loss of engine power on approach and a subsequent forced landing on unsuitable terrain.
- [NTSB GAA17CA557](https://openairdocs.org/ntsb/GAA17CA557.md): Bellet James J Vans RV 8 · Orange, MA · Accident · Minor injuries · Data collection · Final report · Sep 26, 2017 · N184SJ · Substantial damage
  > The pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.
- [NTSB GAA17CA573](https://openairdocs.org/ntsb/GAA17CA573.md): Cessna 172 · Chino, CA · Accident · No injuries · Data collection · Final report · Sep 22, 2017 · N520KS · Substantial damage
  > An in-flight collision with a bird while on downwind.
- [NTSB CEN17WA370](https://openairdocs.org/ntsb/CEN17WA370.md): Cessna 150J · Goderich, Canada · Accident · 2 fatal · Foreign investigation · Sep 21, 2017 · C-FHPU · Substantial damage
  > On September 20, 2017, about 2036 eastern daylight time, a Cessna 150J single-engine airplane, Canadian registration C-FHPU, serial number 15070602, crashed in Lake Huron about 1.1 nautical miles west of Goderich Municipal Airport (CYGD), Goderich, Ontario,…
- [NTSB CEN17WA360](https://openairdocs.org/ntsb/CEN17WA360.md): Vans RV4 · Stafsberg, Norway · Accident · 2 fatal · Foreign investigation · Sep 19, 2017 · LN-ABF · Destroyed
  > On September 19, 2017, at 1450 UTC, a Vans Aircraft RV-4, experimental, amateur-built airplane, Norwegian registration LN-ABF, impacted terrain near the Hamar Airport (ENHA), Stafsberg, Norway. The pilot and passenger on board were fatally injured and the…
- [NTSB WPR17LA208](https://openairdocs.org/ntsb/WPR17LA208.md): Piper PA 28-161 · El Cajon, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 2017 · N2587X · Substantial damage
  > A partial loss of engine power due to the formation of carburetor ice during descent for landing. Contributing to the accident was the pilot’s failure to apply carburetor heat.
- [NTSB CEN17LA365](https://openairdocs.org/ntsb/CEN17LA365.md): Gaddis Michael Exec 162 F · Plymouth, IN · Accident · No injuries · Limited investigation · Final report · Sep 16, 2017 · N123XZ · Substantial damage
  > A failure of the drive belt for reasons that could not be determined based on the available information.
- [NTSB CEN17LA357](https://openairdocs.org/ntsb/CEN17LA357.md): Beech A36 · McAlester, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 2017 · N18403 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA17LA325](https://openairdocs.org/ntsb/ERA17LA325.md): Beech C23 · Machias, ME · Accident · No injuries · Limited investigation · Final report · Sep 14, 2017 · N2120W · Substantial damage
  > The pilot's delay in applying carburetor heat, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB CEN17LA348](https://openairdocs.org/ntsb/CEN17LA348.md): Beech N35 · South Bend, IN · Accident · No injuries · Limited investigation · Final report · Sep 12, 2017 · N9368Y · Substantial damage
  > The improperly seated fuel cap, which resulted in an in-flight fuel leak and subsequent total loss of engine power due to fuel starvation.
- [NTSB GAA17CA530](https://openairdocs.org/ntsb/GAA17CA530.md): Cessna 172 · Plainville, CT · Accident · Minor injuries · Data collection · Final report · Sep 11, 2017 · N54463 · Substantial damage
  > The pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.
- [NTSB ERA17WA321](https://openairdocs.org/ntsb/ERA17WA321.md): Piper Piper PA-34-200T · Cerrione, Italy · Accident · 1 fatal · Foreign investigation · Sep 9, 2017 · G-STZA · Destroyed
- [NTSB DCA17CA194](https://openairdocs.org/ntsb/DCA17CA194.md): Mcdonnell Douglas MD 90-30 · El Paso, TX · Accident · Serious injuries · Data collection · Final report · Sep 4, 2017 · N938DN · No damage
  > an inadvertent encounter with turbulence.
- [NTSB GAA17CA518](https://openairdocs.org/ntsb/GAA17CA518.md): Croft Robert C Kitfox Super Sport · Afton, WY · Accident · No injuries · Data collection · Final report · Sep 2, 2017 · N429NC · Substantial damage
  > The pilot’s failure to maintain bank control during an attempted go-around.
- [NTSB GAA17CA542](https://openairdocs.org/ntsb/GAA17CA542.md): Cessna 150 · Wasilla, AK · Accident · No injuries · Data collection · Final report · Aug 31, 2017 · N2996S · Substantial damage
  > The student pilot’s inadequate in-flight fuel planning, which resulted in fuel exhaustion, the subsequent total loss of engine power, and a forced off-airport landing.
- [NTSB GAA17CA513](https://openairdocs.org/ntsb/GAA17CA513.md): Cessna 172 · Belle Fourche, SD · Accident · Minor injuries · Data collection · Final report · Aug 30, 2017 · N2982U · Substantial damage
  > The flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.
- [NTSB ERA17FA299](https://openairdocs.org/ntsb/ERA17FA299.md): Grumman AA1 · Portland, TN · Accident · 2 fatal · Field investigation · Final report · Aug 30, 2017 · N8866L · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR17LA190](https://openairdocs.org/ntsb/WPR17LA190.md): Beech M35 · Lake Havasu City, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 2017 · N339Z · Substantial damage
  > The pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…
- [NTSB GAA17CA519](https://openairdocs.org/ntsb/GAA17CA519.md): Piper J5A · Springfield, VT · Accident · No injuries · Data collection · Final report · Aug 27, 2017 · N30897 · Substantial damage
  > The pilot's unstabilized approach, which resulted in landing long and fast, and his subsequent failure to maintain clearance from trees during a go-around.
- [NTSB ERA17WA351](https://openairdocs.org/ntsb/ERA17WA351.md): Cessna 207 · Recanati, Italy · Incident · No injuries · Foreign investigation · Aug 27, 2017 · D-EPJR · Minor damage
  > The government of Italy has notified the NTSB of an accident involving a CESSNA 207 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…
- [NTSB CEN17LA329](https://openairdocs.org/ntsb/CEN17LA329.md): James M Raulerson CH 750 · Manila, AR · Accident · No injuries · Limited investigation · Final report · Aug 24, 2017 · N61LR · Substantial damage
  > A loss of engine power for reasons that could not be determined because the airplane was not available for examination.
- [NTSB ERA17LA281](https://openairdocs.org/ntsb/ERA17LA281.md): Piper J3C · Green Creek, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2017 · N46286 · Substantial damage
  > The pilot's exhaustion of the fuel supply in the selected tank.
- [NTSB WPR17FA185](https://openairdocs.org/ntsb/WPR17FA185.md): Rich Wheeler Express CT · Madras, OR · Accident · 1 fatal · Field investigation · Final report · Aug 19, 2017 · N246TM · Destroyed
  > The pilot's failure to maintain adequate airspeed while maneuvering in the airport traffic pattern for landing, which resulted in an exceedance of the airplane's critical angle of attack, a subsequent aerodynamic stall at an altitude too low to recover.
- [NTSB ERA17LA287](https://openairdocs.org/ntsb/ERA17LA287.md): Cessna R182 · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Aug 19, 2017 · N9155C · Substantial damage
  > The improper maintenance of the landing gear system and subsequent failure of the hydraulic landing gear down return line, which resulted in a loss of hydraulic fluid and the pilot’s inability to extend and lock the main landing gear.
- [NTSB ANC17LA043](https://openairdocs.org/ntsb/ANC17LA043.md): Cessna T207 · Juneau, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 14, 2017 · N745KP · Substantial damage
  > The total loss of engine power due to fuel starvation.
- [NTSB GAA17CA489](https://openairdocs.org/ntsb/GAA17CA489.md): Cessna 170 · Axtell, KS · Accident · No injuries · Data collection · Final report · Aug 11, 2017 · N4189V · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.
- [NTSB CEN17LA359](https://openairdocs.org/ntsb/CEN17LA359.md): Cirrus Design SR22T · Raton, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2017 · N702N · Substantial damage
  > The pilot's failure to maintain a proper descent rate, which resulted in a bounced landing, and his subsequent failure to attain a proper airspeed during an attempted go-around in shifting wind conditions, which resulted in an aerodynamic stall.
- [NTSB CEN17LA307](https://openairdocs.org/ntsb/CEN17LA307.md): Pegasus Quantum · Fort Atkinson, WI · Accident · 2 fatal · Limited investigation · Final report · Aug 9, 2017 · N56092 · Substantial damage
  > The student pilot's failure to maintain aircraft control during a go-around, which resulted in impact with water. Contributing to the accident was the non-instructor sport pilot's decision to allow the student pilot to fly the aircraft.
- [NTSB ERA17LA267](https://openairdocs.org/ntsb/ERA17LA267.md): Piper PA28 · Pittstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 2017 · N56884 · Substantial damage
  > The student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…
- [NTSB ERA17LA270](https://openairdocs.org/ntsb/ERA17LA270.md): Pipistrel Doo Ajdovscina Virus SW · Immokalee, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2017 · N811AW · Substantial damage
  > The pilot's failure to attain adequate airspeed during an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB GAA17CA472](https://openairdocs.org/ntsb/GAA17CA472.md): Mooney M20 · Skiatook, OK · Accident · No injuries · Data collection · Final report · Aug 2, 2017 · N95442 · Substantial damage
  > The pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…
- [NTSB DCA17WA168](https://openairdocs.org/ntsb/DCA17WA168.md): Boeing 737 · Tijuana, Mexico · Incident · No injuries · Foreign investigation · Aug 1, 2017 · N368AR · No damage
  > The Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation…
- [NTSB CEN17FA297](https://openairdocs.org/ntsb/CEN17FA297.md): Piper PA30 · Topeka, KS · Accident · 2 fatal · Field investigation · Final report · Aug 1, 2017 · N22HW · Destroyed
  > The failure of the pilot and flight instructor to maintain aircraft control while maneuvering in the traffic pattern.
- [NTSB GAA17CA477](https://openairdocs.org/ntsb/GAA17CA477.md): Let L 23 Super Blanik · Homestead, FL · Accident · No injuries · Data collection · Final report · Jul 30, 2017 · N304MG · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in the pilot landing short of the intended runway.
- [NTSB ERA17RA260](https://openairdocs.org/ntsb/ERA17RA260.md): Britten Norman BN2A · Eteringbang, Guyana · Accident · 1 fatal · Foreign investigation · Jul 25, 2017 · 8R-GRA · Substantial damage
  > On July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…
- [NTSB CEN17LA285](https://openairdocs.org/ntsb/CEN17LA285.md): Hillard Charlie R Hawker FB60 · Breckenridge, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 2017 · N254SF · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.
- [NTSB WPR17LA158](https://openairdocs.org/ntsb/WPR17LA158.md): Enstrom F 28C · Ontario, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2017 · N5697B · Substantial damage
  > The student pilot's mismanagement of the main rotor rpm, which resulted in low rotor rpm, a high descent rate, and a subsequent hard landing.
- [NTSB WPR17FA155](https://openairdocs.org/ntsb/WPR17FA155.md): Evolution 19 Lancair Evolution · Mesa, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 17, 2017 · N571JM · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…
- [NTSB ERA17LA247](https://openairdocs.org/ntsb/ERA17LA247.md): Aeroprakt A 20 Vista Cruiser · Shirley, NY · Accident · No injuries · Limited investigation · Final report · Jul 17, 2017 · N55US · Substantial damage
  > The pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.
- [NTSB GAA17CA417](https://openairdocs.org/ntsb/GAA17CA417.md): Perner/Pitts S1S · Brenham, TX · Accident · No injuries · Data collection · Final report · Jul 16, 2017 · N714H · Substantial damage
  > The pilot's failure to maintain lateral/bank and yaw control during a go-around.
- [NTSB WPR17LA157](https://openairdocs.org/ntsb/WPR17LA157.md): Cirrus Design SR22 · Ogden, UT · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2017 · N754AP · Substantial damage
  > The failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.
- [NTSB GAA17CA412](https://openairdocs.org/ntsb/GAA17CA412.md): Mooney M20C · Washington Island, WI · Accident · No injuries · Data collection · Final report · Jul 15, 2017 · N9303V · Substantial damage
  > The pilot's failure to maintain a proper approach path, which resulted in impact with trees.
- [NTSB ERA17LA246](https://openairdocs.org/ntsb/ERA17LA246.md): Costruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MD · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2017 · N561TU · Substantial damage
  > The fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.
- [NTSB ANC17LA034](https://openairdocs.org/ntsb/ANC17LA034.md): Cessna 180 · Anchorage, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 9, 2017 · N2429C · Substantial damage
  > A total loss of engine power due to fuel starvation for undetermined reasons.
- [NTSB GAA17CA474](https://openairdocs.org/ntsb/GAA17CA474.md): Cessna 210 · Bettles, AK · Accident · No injuries · Data collection · Final report · Jul 8, 2017 · N9664X · Destroyed
  > The pilot's failure to maintain an appropriate glidepath during the approach to the runway over glassy water and in glaring sun conditions.
- [NTSB DCA17IA148](https://openairdocs.org/ntsb/DCA17IA148.md): Airbus A320-211 · San Francisco, CA · Incident · No injuries · Class 1 · Incident · Final report · Jul 8, 2017 · C-FKCK · No damage
  > The flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…

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

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

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