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

## Cases, newest first

- [NTSB ERA13FA062](https://openairdocs.org/ntsb/ERA13FA062.md): Cessna 172K · Savannah, GA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2012 · N78304 · Substantial damage
  > The pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.
- [NTSB ERA13LA060](https://openairdocs.org/ntsb/ERA13LA060.md): Beech 35B33 · White Plains, NY · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 2012 · N8519M · Substantial damage
  > The pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.
- [NTSB ERA13LA058](https://openairdocs.org/ntsb/ERA13LA058.md): Cessna 172RG · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Nov 15, 2012 · N9985B · Substantial damage
  > The rupture of the landing gear’s hydraulic pressure hose, which resulted in the depletion of all of the hydraulic fluid, and the inability of the landing gear to raise or lower. Contributing to the accident was the installation of an unapproved hydraulic…
- [NTSB ERA13LA053](https://openairdocs.org/ntsb/ERA13LA053.md): Cessna 210 · Jasper, GA · Accident · No injuries · Limited investigation · Final report · Nov 11, 2012 · N9633T · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…
- [NTSB ERA13LA054](https://openairdocs.org/ntsb/ERA13LA054.md): Vans RV-12 · Williamson, GA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2012 · N678AD · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.
- [NTSB ERA13WA074](https://openairdocs.org/ntsb/ERA13WA074.md): Piper PA-31T · Curitiba, Brazil · Accident · 4 fatal · Foreign investigation · Nov 6, 2012 · PT-MFW · Destroyed
  > On November 6, 2012, at 2030 Coordinated Universal Time (UTC), a Piper PA-31T, Brazilian registration PT-MFW, was destroyed when it impacted terrain while approaching Bacacheri Airport (SBBI), Curitiba, Brazil. The flight was operated by Taxi Aereo Hercules,…
- [NTSB CEN13FA045](https://openairdocs.org/ntsb/CEN13FA045.md): Cessna 150F · Gothenburg, NE · Accident · 1 fatal · Field investigation · Final report · Nov 4, 2012 · N8375G · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.
- [NTSB CEN13LA041](https://openairdocs.org/ntsb/CEN13LA041.md): Cessna 172S · Roanoke, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2012 · N985GE · Substantial damage
  > The student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…
- [NTSB CEN13FA030](https://openairdocs.org/ntsb/CEN13FA030.md): Piper PA-28-140 · Maryland Heights, MO · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2012 · N55620 · Substantial damage
  > The pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.
- [NTSB CEN13LA029](https://openairdocs.org/ntsb/CEN13LA029.md): Quad City Challenger · Castroville, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 23, 2012 · UNREG · Substantial damage
  > The pilot’s steep 180-degree turn to final approach for landing, which resulted in an inadvertent stall and spin at an altitude from which he could not recover.
- [NTSB CEN13LA016](https://openairdocs.org/ntsb/CEN13LA016.md): Beech A36 · Wausau, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2012 · N121VP · Substantial damage
  > The pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.
- [NTSB WPR13LA009](https://openairdocs.org/ntsb/WPR13LA009.md): Piper PA-38-112 · Corona, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2012 · N4309E · Substantial damage
  > Total loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.
- [NTSB ERA13LA018](https://openairdocs.org/ntsb/ERA13LA018.md): Sikorsky S-55B · Yorktown, NY · Accident · No injuries · Limited investigation · Final report · Oct 12, 2012 · N443FD · Substantial damage
  > The pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.
- [NTSB ERA13WA108](https://openairdocs.org/ntsb/ERA13WA108.md): Sikorsky S61 · Carauari, Brazil · Incident · No injuries · Foreign investigation · Oct 10, 2012 · PR-HRU · No damage
  > On October 10, 2012, at 1630 Coordinated Universal Time (UTC), a Sikorsky S-61, Brazilian registration PR-HRU, experienced a loss of power in the number one engine and performed a single-engine landing to Carauari Airport, Carauari Municipality, Brazil. The…
- [NTSB ANC13CA002](https://openairdocs.org/ntsb/ANC13CA002.md): Cessna U206F · Buckland, AK · Accident · No injuries · Data collection · Final report · Oct 9, 2012 · N9575G · Substantial damage
  > The pilot's loss of airplane control during final approach in gusty wind conditions.
- [NTSB WPR13LA005](https://openairdocs.org/ntsb/WPR13LA005.md): Cessna 180H · St Maries, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 2012 · N2780X · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13LA012](https://openairdocs.org/ntsb/ERA13LA012.md): Cirrus Design SR22 · Birmingham, AL · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2012 · N80KW · Substantial damage
  > The pilot's failure to maintain airplane control during a missed approach in instrument meteorological conditions. Contributing to the accident was the pilot's overreliance on the autopilot system and his inability to hand-fly the airplane once the autopilot…
- [NTSB WPR13LA002](https://openairdocs.org/ntsb/WPR13LA002.md): Wood Mustang II FB · San Manuel, AZ · Accident · 1 fatal · Limited investigation · Final report · Oct 4, 2012 · N112MW · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.
- [NTSB WPR13FA001](https://openairdocs.org/ntsb/WPR13FA001.md): Piper PA-28-180 · Beatty, NV · Accident · Serious injuries · Field investigation · Final report · Oct 3, 2012 · N7895W · Substantial damage
  > The pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.
- [NTSB CEN13FA002](https://openairdocs.org/ntsb/CEN13FA002.md): Cirrus Design SR22 · Gary, IN · Accident · 2 fatal · Field investigation · Final report · Oct 3, 2012 · N308PJ · Substantial damage
  > The pilot's loss of control during an instrument approach due to spatial disorientation. Contributing to the accident were deficient approach control services and the pilot's loss of positional awareness.
- [NTSB WPR12LA441](https://openairdocs.org/ntsb/WPR12LA441.md): Team MINI-MAX · Chula Vista, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 2012 · N1532W · Substantial damage
  > A complete loss of engine power as a result of fuel starvation due to an unsecured fuel filter, which moved in flight and kinked the flexible fuel line, severely restricting the fuel flow to the carburetor. Contributing to the accident was the inadequate…
- [NTSB CEN12LA675](https://openairdocs.org/ntsb/CEN12LA675.md): Beech E33 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Sep 26, 2012 · N7133N · Substantial damage
  > The loss of engine power for reasons that could not be determined during postaccident examinations and testing.
- [NTSB CEN12CA658](https://openairdocs.org/ntsb/CEN12CA658.md): Cessna 175A · Spearfish, SD · Accident · No injuries · Data collection · Final report · Sep 25, 2012 · N6979E · Substantial damage
  > The pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.
- [NTSB ERA12LA575](https://openairdocs.org/ntsb/ERA12LA575.md): Cessna 182Q · Fort Thomas, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2012 · N735FJ · Substantial damage
  > The pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.
- [NTSB WPR12FA432](https://openairdocs.org/ntsb/WPR12FA432.md): Kundel Vans RV 7A · Laramie, WY · Accident · 1 fatal · Field investigation · Final report · Sep 21, 2012 · N423RA · Destroyed
  > The pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.
- [NTSB CEN12LA645](https://openairdocs.org/ntsb/CEN12LA645.md): Cessna 177B · Branson, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 2012 · N34722 · Substantial damage
  > The pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.
- [NTSB CEN12FA638](https://openairdocs.org/ntsb/CEN12FA638.md): Mchenry George B JR KR2S · Pueblo, CO · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2012 · N966G · Substantial damage
  > The pilot’s loss of airplane control while maneuvering to land, which resulted in a stall and uncontrolled descent.
- [NTSB ERA12LA562](https://openairdocs.org/ntsb/ERA12LA562.md): Republic RC-3 · Cedar Bluff, AL · Accident · 1 fatal · Limited investigation · Final report · Sep 15, 2012 · N6072K · Substantial damage
  > The pilot's failure to see and avoid power lines during final approach to landing.
- [NTSB CEN12FA633](https://openairdocs.org/ntsb/CEN12FA633.md): Cirrus Design SR22 · Willard, MO · Accident · 5 fatal · Field investigation · Final report · Sep 15, 2012 · N436KS · Substantial damage
  > The pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.
- [NTSB WPR12CA419](https://openairdocs.org/ntsb/WPR12CA419.md): Piper PA-28-180 · French Valley, CA · Accident · Minor injuries · Data collection · Final report · Sep 14, 2012 · N7971W · Substantial damage
  > The pilot’s loss of directional control during a go-around following a sudden change in wind direction.
- [NTSB CEN12CA656](https://openairdocs.org/ntsb/CEN12CA656.md): Fairchild PT-19A · Cape Girardeau, MO · Accident · Minor injuries · Data collection · Final report · Sep 13, 2012 · N19GP · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed during a low approach, which resulted in an aerodynamic stall.
- [NTSB ANC12LA106](https://openairdocs.org/ntsb/ANC12LA106.md): Cessna A185F · Denali Park, AK · Accident · No injuries · Limited investigation · Final report · Sep 13, 2012 · N4786Q · Substantial damage
  > The pilot’s failure to maintain clearance from an electric transmission line during the approach to land because he was distracted by the airplane’s broken and deflected landing ski. Contributing to the accident was the in-flight failure of the right ski…
- [NTSB CEN12CA625](https://openairdocs.org/ntsb/CEN12CA625.md): Beech 35 · Geary, OK · Accident · No injuries · Data collection · Final report · Sep 9, 2012 · N3014V · Substantial damage
  > The student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…
- [NTSB ANC12LA103](https://openairdocs.org/ntsb/ANC12LA103.md): Piper PA-18-150 · Homer, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 2012 · N3214D · Substantial damage
  > The total loss of engine power for reasons that could not be determined because the engine could not be examined because of the extent of time in salt water.
- [NTSB ERA12LA549](https://openairdocs.org/ntsb/ERA12LA549.md): Beech 76 · Manville, NJ · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2012 · N6716L · Substantial damage
  > The pilot’s failure to maintain directional control during the landing and attempted go-around.
- [NTSB CEN12FA611](https://openairdocs.org/ntsb/CEN12FA611.md): Fairley Gooch Lancair IV · Winnsboro, LA · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2012 · N1126V · Substantial damage
  > The pilot’s failure to maintain control of the airplane after a loss of engine power during a go-around. Contributing to the accident was the difficult-to-operate fuel selector valve and the pilot’s continued operation of the airplane with a known mechanical…
- [NTSB CEN12TA604](https://openairdocs.org/ntsb/CEN12TA604.md): Cessna 182P · Newberry, MI · Accident · Serious injuries · Final report · Sep 2, 2012 · N5981J · Substantial damage
  > The pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…
- [NTSB WPR12FA385](https://openairdocs.org/ntsb/WPR12FA385.md): Easton Searey · Friday Harbor, WA · Accident · Serious injuries · Field investigation · Final report · Aug 31, 2012 · N346PE · Substantial damage
  > The pilot’s inadequate glidepath and failure to maintain clearance from the transmission wire during a landing approach.
- [NTSB WPR12FA378](https://openairdocs.org/ntsb/WPR12FA378.md): Aircraft Mfg & Development CH 2000 · Nephi, UT · Accident · 2 fatal · Field investigation · Final report · Aug 30, 2012 · N651AM · Substantial damage
  > The pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.
- [NTSB WPR12CA376](https://openairdocs.org/ntsb/WPR12CA376.md): Champion 7FC · Terrebonne, OR · Accident · Serious injuries · Data collection · Final report · Aug 30, 2012 · N4849E · Substantial damage
  > The pilot's physical impairment, which adversely affected his ability to properly operate the airplane.
- [NTSB WPR12LA373](https://openairdocs.org/ntsb/WPR12LA373.md): Cessna P210 · Alturas, CA · Accident · No injuries · Limited investigation · Final report · Aug 27, 2012 · C-GFCK · Substantial damage
  > A loss of engine power due to fuel vaporization. Contributing to the accident was the pilot’s failure to use the auxiliary fuel pump when he noticed a degradation in the airplane’s climb performance.
- [NTSB WPR12CA370](https://openairdocs.org/ntsb/WPR12CA370.md): Cessna 150G · Madera, CA · Accident · Minor injuries · Data collection · Final report · Aug 26, 2012 · N6346S · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion.
- [NTSB WPR12LA367](https://openairdocs.org/ntsb/WPR12LA367.md): Aeronca 11AC · Pacoima, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 2012 · N9409E · Substantial damage
  > A total loss of engine power on approach for landing due to a combination of the low fuel level and fuel contamination.
- [NTSB CEN12LA580](https://openairdocs.org/ntsb/CEN12LA580.md): Cessna 140 · Spearfish, SD · Accident · No injuries · Limited investigation · Final report · Aug 25, 2012 · N140XX · Substantial damage
  > The partial loss of engine power due to debris lodged beneath the throttle body of the carburetor venturi.
- [NTSB ANC12CA092](https://openairdocs.org/ntsb/ANC12CA092.md): Dehavilland Beaver U-6 · Kenai, AK · Accident · Minor injuries · Data collection · Final report · Aug 25, 2012 · N314HA · Substantial damage
  > The pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.
- [NTSB ERA12WA554](https://openairdocs.org/ntsb/ERA12WA554.md): Bell 212 · Malvinas, Peru · Accident · Serious injuries · Foreign investigation · Aug 23, 2012 · OB-1912-P · Substantial damage
  > On August 23, 2012, about 2020 universal coordinated time (1520 local time), a Bell 212, Peruvian registration OB-1912-P, operated by Los Andes S.A.C., was substantially damaged when it impacted terrain while approaching a jungle landing site about 19…
- [NTSB ERA12CA521](https://openairdocs.org/ntsb/ERA12CA521.md): Cessna 152 · Deland, FL · Accident · Minor injuries · Data collection · Final report · Aug 21, 2012 · N49054 · Substantial damage
  > The pilot’s failure to maintain airplane control on final approach in gusting wind conditions. Contributing to the accident was the pilot’s decision to operate in an environment of thunderstorms and rapidly deteriorating weather.
- [NTSB ERA12FA513](https://openairdocs.org/ntsb/ERA12FA513.md): Mcleod Alan FW-190 1/2 Scale · Columbus, GA · Accident · 1 fatal · Field investigation · Final report · Aug 18, 2012 · N149AM · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.
- [NTSB DCA12WA127](https://openairdocs.org/ntsb/DCA12WA127.md): Boeing 747-400 · London, United Kingdom · Incident · No injuries · Foreign investigation · Aug 17, 2012 · 9M-MPL · No damage
  > The United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 747-400 that occurred on August 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…
- [NTSB CEN12CA599](https://openairdocs.org/ntsb/CEN12CA599.md): Cessna 152 · Rockford, IL · Accident · No injuries · Data collection · Final report · Aug 17, 2012 · N152BA · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.

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

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

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