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

## Cases, newest first

- [NTSB ERA14CA175](https://openairdocs.org/ntsb/ERA14CA175.md): Beech S35 · Marathon, FL · Accident · Minor injuries · Data collection · Final report · Mar 30, 2014 · N8985M · Substantial damage
  > The pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.
- [NTSB ERA14LA174](https://openairdocs.org/ntsb/ERA14LA174.md): N/A N/A · Patillas, PR · Accident · 1 fatal · Limited investigation · Final report · Mar 26, 2014 · UNREG · Substantial damage
  > The pilot’s failure to maintain airplane control during approach for landing, which resulted in a stall/spin.
- [NTSB ERA14CA171](https://openairdocs.org/ntsb/ERA14CA171.md): Cessna 172 · Carlisle, PA · Accident · Serious injuries · Data collection · Final report · Mar 24, 2014 · N4214F · Substantial damage
  > The pilot's decision to depart with a known mechanical malfunction and his improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an off-airport landing.
- [NTSB ERA14CA165](https://openairdocs.org/ntsb/ERA14CA165.md): Fantasy Air Sro Allegro 2000 · Kill Devil Hills, NC · Accident · Serious injuries · Data collection · Final report · Mar 23, 2014 · N90650 · Substantial damage
  > The pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.
- [NTSB ERA14FA162](https://openairdocs.org/ntsb/ERA14FA162.md): Piper PA-28-181 · Safety Harbor, FL · Accident · 2 fatal · Field investigation · Final report · Mar 22, 2014 · N8309L · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to cocaine use.
- [NTSB CEN14FA167](https://openairdocs.org/ntsb/CEN14FA167.md): Socata TBM 700 · Ridgway, CO · Accident · 5 fatal · Field investigation · Final report · Mar 22, 2014 · N702H · Substantial damage
  > The pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.
- [NTSB ERA14LA161](https://openairdocs.org/ntsb/ERA14LA161.md): Cessna LC41-550FG · Palatka, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 21, 2014 · N717RR · Substantial damage
  > The pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…
- [NTSB CEN14CA170](https://openairdocs.org/ntsb/CEN14CA170.md): Donald G Stokes Challenger II · Crockett, TX · Accident · No injuries · Data collection · Final report · Mar 21, 2014 · N284DS · Substantial damage
  > The pilot's failure to maintain control of the airplane, resulting in a hard landing.
- [NTSB CEN14LA165](https://openairdocs.org/ntsb/CEN14LA165.md): Beech P35 · Wichita Falls, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2014 · N9532Y · Substantial damage
  > The loss of engine power due to the misrigging of the fuel mixture control.
- [NTSB ERA14LA156](https://openairdocs.org/ntsb/ERA14LA156.md): Cessna 402B · Stuart, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 2014 · N419AR · Substantial damage
  > The pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.
- [NTSB ERA14FA153](https://openairdocs.org/ntsb/ERA14FA153.md): Waters Peter T Avid Bandit · Washington, PA · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2014 · N62PT · Destroyed
  > The pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.
- [NTSB ERA14LA147](https://openairdocs.org/ntsb/ERA14LA147.md): Cessna 172D · Fairhope, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 8, 2014 · N2755U · Destroyed
  > The pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.
- [NTSB ERA14LA146](https://openairdocs.org/ntsb/ERA14LA146.md): Cessna 170B · Mulberry, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 2014 · N211R · Substantial damage
  > The failure of the pilot and the parachutist to see and avoid each other, which resulted in the airplane’s wing colliding with the parachute’s suspension lines.
- [NTSB WPR14LA153](https://openairdocs.org/ntsb/WPR14LA153.md): Zenair CH2T · Woodland, CA · Accident · No injuries · Limited investigation · Final report · Mar 6, 2014 · N285AM · Substantial damage
  > A total loss of engine power during approach due to carburetor icing, which resulted in an off-airport landing into trees.
- [NTSB WPR14FA127](https://openairdocs.org/ntsb/WPR14FA127.md): Piper PA 46 350P · Truckee, CA · Accident · 1 fatal · Field investigation · Final report · Mar 3, 2014 · N9281F · Substantial damage
  > The pilot’s failure to properly execute the missed approach in instrument conditions. Contributing to the accident were the pilot’s lack of instrument proficiency, as demonstrated by his failure to execute the required procedure turn to align with the final…
- [NTSB WPR14CA129](https://openairdocs.org/ntsb/WPR14CA129.md): Partenavia P 68 Observer · Molokai, HI · Accident · No injuries · Data collection · Final report · Feb 28, 2014 · N947MZ · Substantial damage
  > The pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.
- [NTSB WPR14LA123](https://openairdocs.org/ntsb/WPR14LA123.md): Lake LA 4 200 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Feb 25, 2014 · N1040L · Substantial damage
  > The loss of engine power during initial climb for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR14LA119](https://openairdocs.org/ntsb/WPR14LA119.md): Sabrena Dragonfly · Maricopa, AZ · Accident · 1 fatal · Limited investigation · Final report · Feb 24, 2014 · N7745C · Substantial damage
  > The pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.
- [NTSB ERA14FA128](https://openairdocs.org/ntsb/ERA14FA128.md): Beech 95-B55 · LaGrange, GA · Accident · 3 fatal · Field investigation · Final report · Feb 22, 2014 · N36638 · Destroyed
  > The pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…
- [NTSB CEN14FA145](https://openairdocs.org/ntsb/CEN14FA145.md): Beech B100 · Pearland, TX · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2014 · N811BL · Destroyed
  > The noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.
- [NTSB ERA14FA120](https://openairdocs.org/ntsb/ERA14FA120.md): Cessna 210L · Clay, AL · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2014 · N732EJ · Destroyed
  > The pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…
- [NTSB ERA14CA124](https://openairdocs.org/ntsb/ERA14CA124.md): Cessna 172S · Mansfield, MA · Accident · No injuries · Data collection · Final report · Feb 15, 2014 · N2143X · Substantial damage
  > The student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.
- [NTSB ERA14WA125](https://openairdocs.org/ntsb/ERA14WA125.md): Cessna 210N · Palmas, Brazil · Accident · 3 fatal · Foreign investigation · Feb 9, 2014 · PT-OMX · Substantial damage
  > On February 9, 2014, about 1330 universal coordinated time, a Cessna 210N, Brazilian registration PT-OMX, operated by a private individual, was substantially damaged after it experienced a loss of engine power and impacted terrain while on approach to the…
- [NTSB CEN14LA133](https://openairdocs.org/ntsb/CEN14LA133.md): Cessna 182A · Lexington, TX · Accident · No injuries · Limited investigation · Final report · Feb 9, 2014 · N6061B · Substantial damage
  > The pilot’s improper use of the carburetor heat, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB CEN14LA129](https://openairdocs.org/ntsb/CEN14LA129.md): Cessna 525 · Elk City, OK · Accident · No injuries · Limited investigation · Final report · Feb 4, 2014 · N61YP · Substantial damage
  > The pilot’s descent below the published minimum descent altitude for the instrument approach procedure, which resulted in impact with a utility pole.
- [NTSB ERA14FA112](https://openairdocs.org/ntsb/ERA14FA112.md): Gulfstream AM Corp Comm Div 690 · Bellevue, TN · Accident · 4 fatal · Field investigation · Final report · Feb 3, 2014 · N840V · Destroyed
  > The pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…
- [NTSB DCA14WA179](https://openairdocs.org/ntsb/DCA14WA179.md): Beech C90 · Lanseria, South Africa · Accident · 3 fatal · Foreign investigation · Feb 3, 2014 · ZS-CLT · Destroyed
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Beech C90-GTI airplane that occurred on February 03, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation under the…
- [NTSB WPR14CA110](https://openairdocs.org/ntsb/WPR14CA110.md): Beech V35A · Globe, AZ · Accident · Minor injuries · Data collection · Final report · Feb 1, 2014 · N31TC · Substantial damage
  > The pilot's inadequate glide path and failure to maintain adequate airspeed during final approach, which resulted in an aerodynamic stall.
- [NTSB ERA14WA114](https://openairdocs.org/ntsb/ERA14WA114.md): Cessna 140 · Cachoeira do Sul, Brazil · Accident · 2 fatal · Foreign investigation · Jan 29, 2014 · PP-DFW · Substantial damage
  > On January 29, 2014, about 1340 universal coordinated time, a Cessna 140, Brazilian registration PP-DFW, was substantially damaged during impact with terrain, following a loss of control on approach to Cachoeira do Sul Airport (SSKS), Cachoeira do Sul, Rio…
- [NTSB CEN14LA134](https://openairdocs.org/ntsb/CEN14LA134.md): Cessna 172K · Milan, IL · Accident · No injuries · Limited investigation · Final report · Jan 26, 2014 · N4VN · Substantial damage
  > The pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during a short final approach.
- [NTSB CEN14CA123](https://openairdocs.org/ntsb/CEN14CA123.md): Cessna 172N · Boulder, CO · Accident · Minor injuries · Data collection · Final report · Jan 25, 2014 · N738LQ · Substantial damage
  > The pilot's failure to maintain airplane control during final approach with known turbulence present.
- [NTSB ERA14LA099](https://openairdocs.org/ntsb/ERA14LA099.md): Bell 47D1 · Pell City, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 2014 · N93067 · Substantial damage
  > The pilot’s use of an improper clutch engagement procedure, which resulted in clutch glazing, slippage, and, ultimately, the in-flight disengagement of the clutch and a loss of rotor rpm. Contributing to the accident were the installation of a light-weight…
- [NTSB DCA14WA042](https://openairdocs.org/ntsb/DCA14WA042.md): Boeing 767 332 · Buenos Aires, Argentina · Incident · No injuries · Foreign investigation · Jan 21, 2014 · N191DN · Minor damage
  > The Direccion Nacional de Aviacion Civil e Infraestructura Aeronautica (DINACIA) has notified the NTSB of an incident involving Boeing 767-300, which occurred on January 21, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DINACIA…
- [NTSB WPR14WA108](https://openairdocs.org/ntsb/WPR14WA108.md): Piper PA31 - 350 · Maluku, Indonesia, Indonesia · Accident · 4 fatal · Foreign investigation · Jan 19, 2014 · PK-IWT · Destroyed
  > On January 19, 2014, at 1220 local time, a Piper PA-31-350, PK-IWT, collided with terrain under unknown circumstances while on approach to Dumatubun Airport, Maluku, Indonesia. The pilot and three passengers were fatally injured and the airplane was…
- [NTSB CEN14FA110](https://openairdocs.org/ntsb/CEN14FA110.md): Cessna 310R · Waterford, MI · Accident · 1 fatal · Field investigation · Final report · Jan 11, 2014 · N3829G · Destroyed
  > The pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…
- [NTSB ERA14LA086](https://openairdocs.org/ntsb/ERA14LA086.md): Cirrus Design SR22 · Buckhannon, WV · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 2014 · N450TX · Substantial damage
  > The pilot’s improper in-flight fuel mixture management and failure to use the appropriate checklist or manuals during approach to landing, which resulted in a loss of engine power.
- [NTSB CEN14LA094](https://openairdocs.org/ntsb/CEN14LA094.md): Cessna 150L · Gladewater, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 2013 · N6905G · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB ERA14LA076](https://openairdocs.org/ntsb/ERA14LA076.md): Cessna 210N · Tampa, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 20, 2013 · N5307A · Substantial damage
  > A total loss of engine power due to the fatigue failure of the No. 4 connecting rod. Contributing to the accident was a likely loss of lubrication for reasons that could not be determined during a postaccident engine examination.
- [NTSB ERA14FA075](https://openairdocs.org/ntsb/ERA14FA075.md): Beech A36TC · Chatlottesville, VA · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2013 · N3705Z · Substantial damage
  > The pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…
- [NTSB ERA14FA073](https://openairdocs.org/ntsb/ERA14FA073.md): Raytheon 390 · Atlanta, GA · Accident · 2 fatal · Field investigation · Final report · Dec 18, 2013 · N50PM · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering the airplane in the traffic pattern at night. Contributing to the accident was the pilot's impairment from the use of illicit drugs.
- [NTSB ERA14FA068](https://openairdocs.org/ntsb/ERA14FA068.md): Cessna 310R · Jacksonville, FL · Accident · 3 fatal · Field investigation · Final report · Dec 8, 2013 · N98BT · Destroyed
  > The pilot’s failure to maintain airplane control during a missed approach in night instrument meteorological conditions due to spatial disorientation and a lack of instrument proficiency.
- [NTSB CEN14WA180](https://openairdocs.org/ntsb/CEN14WA180.md): Christen Industries Pitts S-2B · Meaux-Esbly, France · Accident · No injuries · Foreign investigation · Dec 8, 2013 · F-GEAL · Substantial damage
  > On December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…
- [NTSB ERA14LA059](https://openairdocs.org/ntsb/ERA14LA059.md): Moffitt Oscar/ Kit Prostar A/C PT2 · Trenton, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2013 · N355PT · Substantial damage
  > The airplane owner/pilot ‘s failure to follow the gascolator manufacturer’s recommendations for installing and safety wiring the gascolator strainer bowl, which resulted in the bowl separating and a total loss of engine power due to fuel starvation.
- [NTSB ANC14MA008](https://openairdocs.org/ntsb/ANC14MA008.md): Cessna 208B · Saint Marys, AK · Accident · 5 fatal · Major investigation · Final report · Nov 30, 2013 · N12373 · Substantial damage
  > The pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…
- [NTSB WPR14LA059](https://openairdocs.org/ntsb/WPR14LA059.md): Cessna 210 · Florence, OR · Accident · No injuries · Limited investigation · Final report · Nov 29, 2013 · N6575X · Substantial damage
  > The failure of the hydraulic power pack, which prevented the extension of the landing gear and resulted in a partial gear-up landing.
- [NTSB ERA14LA052](https://openairdocs.org/ntsb/ERA14LA052.md): Beech V35 · Trussville, AL · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 2013 · N5655D · Substantial damage
  > The failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.
- [NTSB ANC14LA007](https://openairdocs.org/ntsb/ANC14LA007.md): Beech 1900C · Deadhorse, AK · Accident · No injuries · Limited investigation · Final report · Nov 22, 2013 · N575X · Substantial damage
  > The captain’s decision to initiate a visual flight rules approach and attempted landing into an area of instrument meteorological conditions, which resulted in the airplane touching down short of the runway. Contributing to the accident was the operator’s…
- [NTSB ERA14WA047](https://openairdocs.org/ntsb/ERA14WA047.md): Robinson R66 · Rio de Janeiro, Brazil · Accident · 1 fatal · Foreign investigation · Nov 20, 2013 · PR-MXM · Substantial damage
- [NTSB ERA14FA044](https://openairdocs.org/ntsb/ERA14FA044.md): Focke-Wulf FWP 149D · Kenansville, NC · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2013 · N132FW · Destroyed
  > The pilot’s loss of control in instrument meteorological conditions for reasons that could not be determined because examination of the airframe and engine revealed no anomalies that would have precluded normal operation. Contributing to the accident was the…
- [NTSB DCA14RA012](https://openairdocs.org/ntsb/DCA14RA012.md): Boeing 737 - 500 · Kazan, Russia · Accident · 50 fatal · Foreign investigation · Nov 17, 2013 · VQ-BBN · Destroyed
  > The Russian Interstate Aviation Committee, Accident Investigation Commission (IAC) has notified the NTSB of an accident involving a Boeing 737-500 that occurred on November 17, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the IAC…

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

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

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