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

## Cases, newest first

- [NTSB ERA15LA115](https://openairdocs.org/ntsb/ERA15LA115.md): Piper PA-28R-200 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 28, 2015 · N54380 · 2 aircraft · Minor damage
  > The failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…
- [NTSB ERA15LA114](https://openairdocs.org/ntsb/ERA15LA114.md): Cessna 150 · Fernandina Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 25, 2015 · N10616 · Substantial damage
  > The pilot’s physical impairment due to intense pain, which resulted in his failure to maintain airplane control.
- [NTSB CEN15LA111](https://openairdocs.org/ntsb/CEN15LA111.md): Cessna 172F · Lowell, MI · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 2015 · N7854U · Substantial damage
  > The student pilot’s loss of airplane control during a go-around after not applying sufficient engine power.
- [NTSB ERA15FA103](https://openairdocs.org/ntsb/ERA15FA103.md): Luscombe 8 · Fort Valley, GA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2015 · N1745K · Substantial damage
  > The flight instructor’s failure to maintain airspeed during an approach with a simulated engine failure, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.
- [NTSB ERA15CA101](https://openairdocs.org/ntsb/ERA15CA101.md): Cessna 150L · Stow, MA · Accident · No injuries · Data collection · Final report · Jan 15, 2015 · N5443Q · Substantial damage
  > The flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.
- [NTSB ERA15FA099](https://openairdocs.org/ntsb/ERA15FA099.md): Cessna 152 · New Smyrna Beach, FL · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2015 · N757ZM · Substantial damage
  > The pilot's failure to maintain control of the airplane while operating under visual flight rules (VFR) in night, instrument meteorological conditions, likely due to spatial disorientation. Contributing to the outcome was the radar controller's failure to…
- [NTSB ERA15FA096](https://openairdocs.org/ntsb/ERA15FA096.md): Robinson Helicopter R22 Beta · Catano, PR · Accident · 1 fatal · Field investigation · Final report · Jan 10, 2015 · N348VH · Destroyed
  > The student pilot’s failure to maintain rotor rpm while maneuvering in the airport traffic pattern, which resulted in the helicopter’s uncontrolled descent to the water. Contributing to the accident was the student’s distraction with other aircraft operating…
- [NTSB ERA15LA090](https://openairdocs.org/ntsb/ERA15LA090.md): Cessna P206 · Key West, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 3, 2015 · N2534X · Substantial damage
  > A total loss of engine power for reasons that could not be determined during postaccident examinations and testing.
- [NTSB WPR15IA080](https://openairdocs.org/ntsb/WPR15IA080.md): Robinson Helicopter R22 Beta II · Phoenix, AZ · Incident · No injuries · Incident investigation · Final report · Dec 30, 2014 · N7041X · No damage
  > The failure of the fanshaft due to fatigue.
- [NTSB ERA15LA087](https://openairdocs.org/ntsb/ERA15LA087.md): MDS Fying Zenith Zodiac CH 650 · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Dec 30, 2014 · N419PE · Substantial damage
  > The inadequate modification of the airplane’s canopy latching mechanism, which resulted in the inadvertent opening of the canopy while on final approach to land and a subsequent loss of pitch control.
- [NTSB DCA15WA212](https://openairdocs.org/ntsb/DCA15WA212.md): Boeing 737 · Lahore, Pakistan · Incident · No injuries · Foreign investigation · Dec 30, 2014 · AP-BJN · Minor damage
  > The Pakistan Civil Aviation Authority (PCAA) has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on December 30, 2014. The NTSB has appointed a U.S. Accredited Representative to assist PCAA's investigation under the provisions…
- [NTSB CEN15LA091](https://openairdocs.org/ntsb/CEN15LA091.md): Cessna 208B · Roswell, NM · Accident · No injuries · Limited investigation · Final report · Dec 30, 2014 · N950FE · Substantial damage
  > The pilot's failure to maintain adequate airspeed to compensate for icing on the airplane's wings and control surfaces during a circling approach, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA15FA085](https://openairdocs.org/ntsb/ERA15FA085.md): Robinson Helicopter R22 Beta · Lake Worth, FL · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2014 · N771MM · Substantial damage
  > A main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.
- [NTSB ERA15LA084](https://openairdocs.org/ntsb/ERA15LA084.md): Aerotek Pitts Special S-1S · Westminster, MD · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2014 · N49294 · 2 aircraft · Substantial damage
  > The pilot’s failure to see and avoid the other airplane, which resulted in a midair collision while both airplanes were on final approach to land.
- [NTSB CEN15FA087](https://openairdocs.org/ntsb/CEN15FA087.md): Piper PA-34-200T · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2014 · N38884 · Destroyed
  > The pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.
- [NTSB CEN15FA081](https://openairdocs.org/ntsb/CEN15FA081.md): Beech V35A · Seagoville, TX · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2014 · N555SF · Destroyed
  > The pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.
- [NTSB CEN15WA113](https://openairdocs.org/ntsb/CEN15WA113.md): Saab-Scania Saab 2000 · Sumburgh, United Kingdom · Incident · No injuries · Foreign investigation · Dec 15, 2014 · G-LGNO
  > On December 15, 2014, about 1955 coordinated universal time, a SAAB-Scania SAAB 2000 airplane, G-LGNO, lost elevator control following a lightning strike on approach to Sumburgh Airport, Sumburgh, United Kingdom. The damage to the airplane is unknown. The…
- [NTSB DCA15CA037](https://openairdocs.org/ntsb/DCA15CA037.md): Boeing 737 · Baltimore, MD · Accident · No injuries · Data collection · Final report · Dec 13, 2014 · N7710A · Substantial damage
  > an inadvertent encounter with birds during approach to land that resulted in substantial damage.
- [NTSB CEN15IA085](https://openairdocs.org/ntsb/CEN15IA085.md): Dassault/Sud FAN JET Falcon · Shreveport, LA · Incident · No injuries · Incident investigation · Final report · Dec 12, 2014 · N827AA · No damage
  > A short in the trim system’s wires and connector, which resulted in the elevator trim being in a full nose-down position.
- [NTSB DCA15WA031](https://openairdocs.org/ntsb/DCA15WA031.md): Beech F33 - A · Krugersdorp, South Africa · Accident · No injuries · Foreign investigation · Dec 8, 2014 · ZS-KHE · Destroyed
- [NTSB DCA15MA029](https://openairdocs.org/ntsb/DCA15MA029.md): Embraer EMB-500 · Gaithersburg, MD · Accident · 6 fatal · Class 1 · Major · Final report · Dec 8, 2014 · N100EQ · Destroyed
  > the pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…
- [NTSB WPR15LA055](https://openairdocs.org/ntsb/WPR15LA055.md): Fouga CM 170R Magister · Lake Havasu City, AZ · Accident · No injuries · Limited investigation · Final report · Dec 6, 2014 · N300FM · Substantial damage
  > A total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.
- [NTSB CEN15LA069](https://openairdocs.org/ntsb/CEN15LA069.md): Cirrus Design SR20 · Fort Collins, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 2014 · N407ND · Substantial damage
  > The student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…
- [NTSB ERA15WA070](https://openairdocs.org/ntsb/ERA15WA070.md): Piper PA-31-350 · Mariquita, Colombia · Accident · 10 fatal · Foreign investigation · Dec 3, 2014 · HK4464 · Destroyed
- [NTSB ERA15CA064](https://openairdocs.org/ntsb/ERA15CA064.md): Piper PA 28-180 · Athens, AL · Accident · Serious injuries · Data collection · Final report · Nov 30, 2014 · N7422W · Substantial damage
  > The pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.
- [NTSB ENG15RA003](https://openairdocs.org/ntsb/ENG15RA003.md): ATR ATR72 - 212A · Visby, Sweden · Incident · No injuries · Foreign investigation · Nov 30, 2014 · SE-MDB · No damage
  > On November 30, 2014, an ATR72-212A airplane, SE-MDB, experienced excessive vibration during approach to Visby Airport(ESSV), Gotland, Sweden. The right engine was shut down and a single-engine landing was performed. Post-incident inspection found damage to…
- [NTSB CEN15FA060](https://openairdocs.org/ntsb/CEN15FA060.md): Bellanca 17-30A · Boonville, MO · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2014 · N6629V · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…
- [NTSB DCA15WA030](https://openairdocs.org/ntsb/DCA15WA030.md): Robinson R44 - II · Dar es Salaam, Tanzania · Accident · 4 fatal · Foreign investigation · Nov 29, 2014 · 5H-TWA · Destroyed
- [NTSB CEN15LA068](https://openairdocs.org/ntsb/CEN15LA068.md): Rans S-14 · Kewanee, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 2014 · UNREG · Substantial damage
  > The pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.
- [NTSB CEN15LA064](https://openairdocs.org/ntsb/CEN15LA064.md): Piper PA 24-250 · Berrien Springs, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2014 · N5897P · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15LA066](https://openairdocs.org/ntsb/CEN15LA066.md): MD Helicopter MD 900 · Highlandville, MO · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2014 · N902LC · Substantial damage
  > The pilot's inability to identify the power line during the initial approach in night visual meteorological conditions and his subsequent failure to avoid the power line once he identified it on final approach.
- [NTSB ANC15LA005](https://openairdocs.org/ntsb/ANC15LA005.md): Piper PA 18-150 · Nikiski, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 2014 · N9720P · Substantial damage
  > The total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat while operating at low-power settings in an area conducive to carburetor icing.
- [NTSB ERA15CA065](https://openairdocs.org/ntsb/ERA15CA065.md): Socata TB 20 Trinidad · Hilton Head Island, SC · Accident · No injuries · Data collection · Final report · Nov 26, 2014 · N85AV · Substantial damage
  > The pilot's inadvertent selection of an incorrect frequency, which resulted in his inability to activate the airport lighting, and his subsequent decision to continue the approach in dark night conditions despite having not positively identified the runway…
- [NTSB WPR15FA045](https://openairdocs.org/ntsb/WPR15FA045.md): Piper PA 24-250 · Garberville, CA · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2014 · N7428P · Substantial damage
  > A loss of engine power for reasons that could not be determined due to extensive damage sustained during the collision and postaccident water immersion.
- [NTSB CEN15FA048](https://openairdocs.org/ntsb/CEN15FA048.md): Aero Commander 500 B · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2014 · N30MB · Substantial damage
  > The pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.
- [NTSB CEN15FA051](https://openairdocs.org/ntsb/CEN15FA051.md): Mooney M20C · Pagosa Springs, CO · Accident · 2 fatal · Field investigation · Final report · Nov 15, 2014 · N6466U · Destroyed
  > The noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.
- [NTSB WPR15CA040](https://openairdocs.org/ntsb/WPR15CA040.md): Aerospatiale AS350BA · Panguitch, UT · Accident · Minor injuries · Data collection · Final report · Nov 13, 2014 · N425U · Substantial damage
  > The flight instructor's delayed reaction in taking control of the helicopter during a student pilot's loss of control while landing.
- [NTSB ERA15RA047](https://openairdocs.org/ntsb/ERA15RA047.md): Gates Learjet 35A · Freeport, Bahamas · Accident · 9 fatal · Foreign investigation · Nov 9, 2014 · N17UF · Destroyed
- [NTSB WPR15LA036](https://openairdocs.org/ntsb/WPR15LA036.md): Champion 7AC · Darby, MT · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 2014 · N84462 · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering in gusting wind conditions, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB WPR15LA034](https://openairdocs.org/ntsb/WPR15LA034.md): Extra Flugzeugproduktions-Und EA 300 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Nov 5, 2014 · N369XT · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR15GA030](https://openairdocs.org/ntsb/WPR15GA030.md): Hawker Hawker Hunter MK.58 · Oxnard, CA · Accident · 1 fatal · Final report · Oct 30, 2014 · N332AX · Destroyed
  > The pilot's failure to maintain adequate airspeed during the approach for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at an altitude too low for recovery.
- [NTSB ERA15CA031](https://openairdocs.org/ntsb/ERA15CA031.md): Solo Wings Aquilla · Eustis, FL · Accident · Minor injuries · Data collection · Final report · Oct 26, 2014 · N55446 · Substantial damage
  > The pilot's failure to maintain aircraft control during the final approach in turbulent conditions, which resulted in a collision with water.
- [NTSB CEN15LA031](https://openairdocs.org/ntsb/CEN15LA031.md): Cessna T210M · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Oct 26, 2014 · XBNCZ · Substantial damage
  > A loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight fuel planning.
- [NTSB ERA15WA026](https://openairdocs.org/ntsb/ERA15WA026.md): Cessna 310R · Governors Harbor, Bahamas · Accident · 1 fatal · Foreign investigation · Oct 24, 2014 · N310WL · Substantial damage
- [NTSB ERA15FA025](https://openairdocs.org/ntsb/ERA15FA025.md): Cirrus Design SR22 · Frederick, MD · Accident · 3 fatal · Field investigation · Final report · Oct 23, 2014 · N122ES · 2 aircraft · Substantial damage
  > The failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…
- [NTSB CEN15FA022](https://openairdocs.org/ntsb/CEN15FA022.md): CGS Hawk Arrow II Slsa · Lonoke, AR · Accident · 1 fatal · Field investigation · Final report · Oct 20, 2014 · N916H · Substantial damage
  > The pilot's loss of airplane control while turning onto the base leg of the traffic pattern due to his failure to maintain sufficient speed and/or overbanking, which resulted in the airplane impacting trees. Contributing to the pilot's fatal injuries was his…
- [NTSB CEN15LA012](https://openairdocs.org/ntsb/CEN15LA012.md): Cessna 182B · Orange, TX · Accident · No injuries · Limited investigation · Final report · Oct 15, 2014 · N2437G · Substantial damage
  > The pilot’s failure to maintain airplane control during a go-around to avoid another airplane that was making a nonstandard approach to the opposing runway. Contributing to the accident was the other pilot’s use of a nonstandard approach while landing on the…
- [NTSB ERA15CA036](https://openairdocs.org/ntsb/ERA15CA036.md): Six Chuter SR7 XL · Fairview, NC · Accident · Serious injuries · Data collection · Final report · Oct 14, 2014 · UNREG · Substantial damage
  > The non-certificated pilot's delayed go-around procedure, which resulted in collision with trees. Contributing to the accident was the pilot's lack of total flying experience.
- [NTSB CEN15FA008](https://openairdocs.org/ntsb/CEN15FA008.md): Piper PA46 · Dubuque, IA · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2014 · N9126V · Destroyed
  > The pilot's loss of airplane control while attempting to fly a missed approach procedure in instrument meteorological conditions.
- [NTSB CEN15LA020](https://openairdocs.org/ntsb/CEN15LA020.md): Kovars Gary D Zenith Zodiak 601XL · Richland Center, WI · Accident · No injuries · Limited investigation · Final report · Oct 9, 2014 · N601GK · Substantial damage
  > The loss of engine power due to carburetor icing.

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

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

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