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

## Cases, newest first

- [NTSB ANC14WA020](https://openairdocs.org/ntsb/ANC14WA020.md): Cessna TU206 - G · Akita City, Japan · Incident · No injuries · Foreign investigation · Nov 16, 2013 · JA4000 · Minor damage
  > On November 16, 2013, at 0246 coordinated universal time, a Japanese registered Cessna 206 airplane, JA4000, operated by Honda Airways, experienced a total loss of engine power near Arayamachi, Akita City, Japan. The pilot made a successful emergency landing,…
- [NTSB CEN14FA047](https://openairdocs.org/ntsb/CEN14FA047.md): Beechcraft B36TC · Amarillo, TX · Accident · 3 fatal · Field investigation · Final report · Nov 11, 2013 · N4245D · Destroyed
  > The noninstrument-rated pilot’s improper decision to fly a night instrument approach in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane during an attempted missed approach.
- [NTSB DCA14RA009](https://openairdocs.org/ntsb/DCA14RA009.md): Swearingen SA227 - AC · Red Lake, Canada · Accident · 5 fatal · Foreign investigation · Nov 10, 2013 · C-FFZN · Destroyed
  > The Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Swearingen SA227 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions…
- [NTSB CEN14FA042](https://openairdocs.org/ntsb/CEN14FA042.md): Piper PA-32R-301 · Kirksville, MO · Accident · 2 fatal · Field investigation · Final report · Nov 6, 2013 · N408DM · Destroyed
  > A loss of control due to spatial disorientation. Contributing to the accident were the private pilot's impairment due to a sedating antihistamine and both pilots' fatigue.
- [NTSB WPR14LA042](https://openairdocs.org/ntsb/WPR14LA042.md): Cessna 180 · St. Johns, AZ · Accident · No injuries · Limited investigation · Final report · Nov 3, 2013 · N3148C · Substantial damage
  > A total loss of engine power while on final approach due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning.
- [NTSB DCA14WA007](https://openairdocs.org/ntsb/DCA14WA007.md): Swearingen SA227 · Riberalta, Bolivia · Accident · 10 fatal · Foreign investigation · Nov 3, 2013 · CP-2754 · Destroyed
  > The government of Bolivia has notified the NTSB of an accident involving a SWEARINGEN SA227 airplane that occurred on November 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the…
- [NTSB CEN14WA038](https://openairdocs.org/ntsb/CEN14WA038.md): Piper PA-34 · Coburg, Germany · Accident · 3 fatal · Class 5 · Foreign · Nov 2, 2013 · D-GRCP · Destroyed
  > On November 11, 2013, at 1020 coordinated universal time, a Piper PA-34, German registration D-GRCP, impacted trees while on approach to land at the Coburg/Brandensteinsebene Airport (EDQC), Coburg, Germany. The pilot and two passengers were fatally injured.…
- [NTSB CEN14LA033](https://openairdocs.org/ntsb/CEN14LA033.md): Clevenger Jimmie B Pitts S 1S · Wellington, KS · Accident · No injuries · Limited investigation · Final report · Oct 31, 2013 · N67JC · Substantial damage
  > The loss of engine power due to a malfunctioning fuel pump.
- [NTSB WPR14LA038](https://openairdocs.org/ntsb/WPR14LA038.md): Eurocopter France AS 350 · Kailua Kona, HI · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 2013 · N985EW · Substantial damage
  > The pilot receiving instruction’s failure to maintain main rotor rpm while practicing manual throttle control and the flight instructor’s delayed remedial action, which resulted in a hard landing.
- [NTSB ERA14FA027](https://openairdocs.org/ntsb/ERA14FA027.md): Cessna 172R · Nashville, TN · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2013 · C-GRJH · Destroyed
  > The noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…
- [NTSB ERA14LA024](https://openairdocs.org/ntsb/ERA14LA024.md): Piper PA 28R-201T · Everglades City, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 2013 · N2702M · Substantial damage
  > The pilot’s failure to maintain airplane control and airspeed during a go-around, which resulted in a stall and impact with terrain. Contributing to the accident were the pilot’s inadvertent use of an outdated GPS navigation database, which provided an…
- [NTSB CEN14TA020](https://openairdocs.org/ntsb/CEN14TA020.md): Bell OH-58A · Jefferson City, MO · Accident · Minor injuries · Final report · Oct 26, 2013 · N283MP · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examinations of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN14CA027](https://openairdocs.org/ntsb/CEN14CA027.md): Cessna 172M · Raymondville, TX · Accident · Serious injuries · Data collection · Final report · Oct 25, 2013 · N20587 · Substantial damage
  > The operation of an airplane by a non-certificated pilot. Contributing to the accident was his failure to maintain airspeed following a total loss of engine power at low altitude, which resulted in an aerodynamic stall. Also contributing was the pilot's…
- [NTSB ERA14LA004](https://openairdocs.org/ntsb/ERA14LA004.md): Mcdonald Howard Brian Zenair 701 · Zephyrhills, FL · Accident · No injuries · Limited investigation · Final report · Oct 19, 2013 · N538HB · Substantial damage
  > The failure of the propeller speed reduction unit drive belts due to inadequate belt tension being applied during installation, which resulted in a complete loss of thrust.
- [NTSB ERA14LA018](https://openairdocs.org/ntsb/ERA14LA018.md): Fuller Van L Sonex · Palatine, NY · Accident · No injuries · Limited investigation · Final report · Oct 16, 2013 · N68VF · Substantial damage
  > A total loss of engine power for reasons that could not be determined because a test run and partial teardown of the engine did not reveal any anomalies.
- [NTSB ERA14WA026](https://openairdocs.org/ntsb/ERA14WA026.md): Luscombe 8 - E · Buenos Aires, Argentina · Accident · 2 fatal · Foreign investigation · Oct 14, 2013 · LV-RTS · Substantial damage
  > On October 14, 2013, about 1134 coordinated universal time, a Luscombe 8E, Argentina registration LV-RTS, was substantially damaged, during descent in thick fog, when it impacted terrain in an industrial park. The flight had departed Zarate Airport (SATE),…
- [NTSB ERA14CA037](https://openairdocs.org/ntsb/ERA14CA037.md): Piper PA 28-150 · Newport, NH · Accident · No injuries · Data collection · Final report · Oct 14, 2013 · N5873W · Substantial damage
  > The pilot's incorrect glide path, which resulted in a landing area overshoot and a runway excursion.
- [NTSB CEN14WA115](https://openairdocs.org/ntsb/CEN14WA115.md): Gulfstream 550 · London, United Kingdom · Accident · No injuries · Foreign investigation · Oct 12, 2013 · HZ-A6 · Substantial damage
  > On October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…
- [NTSB CEN14LA045](https://openairdocs.org/ntsb/CEN14LA045.md): Sutphin Rans S-12 · French Lick, IN · Accident · No injuries · Limited investigation · Final report · Oct 11, 2013 · N8028W · Substantial damage
  > The pilot's failure to maintain adequate airspeed while in a steep turn, which resulted in an aerodynamic stall/mush at a low altitude.
- [NTSB ERA14LA006](https://openairdocs.org/ntsb/ERA14LA006.md): Cessna 340A · Hampton Roads, VA · Accident · 4 fatal · Limited investigation · Final report · Oct 10, 2013 · N4TK · Destroyed
  > The pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.
- [NTSB CEN14LA007](https://openairdocs.org/ntsb/CEN14LA007.md): Cameron Balloons US V 77 · Rio Rancho, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 2013 · N9528A · Substantial damage
  > The pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.
- [NTSB ERA14LA050](https://openairdocs.org/ntsb/ERA14LA050.md): Cessna 170 · Ridgely, MD · Accident · No injuries · Limited investigation · Final report · Oct 8, 2013 · N4216V · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN14LA002](https://openairdocs.org/ntsb/CEN14LA002.md): Beech S35 · Brownwood, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 2013 · N6861Q · Substantial damage
  > A loss of engine power due to fuel starvation, which resulted from a foreign material in the fuel system blocking the fuel flow to the engine.
- [NTSB CEN13LA570](https://openairdocs.org/ntsb/CEN13LA570.md): Piper PA 28-181 · Algona, IA · Accident · No injuries · Limited investigation · Final report · Sep 30, 2013 · N31688 · Substantial damage
  > Fuel exhaustion as a result of the pilot's failure to ensure he had sufficient fuel on board to complete the planned flight. Contributing to the accident was the incomplete information provided by the airport's AWOS.
- [NTSB WPR13LA431](https://openairdocs.org/ntsb/WPR13LA431.md): Bombardier DHC-8-402 · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2013 · N449QX · No damage
  > The airplane’s encounter with known moderate-to-severe turbulence, which resulted in a serious injury to a flight attendant.
- [NTSB ERA13LA437](https://openairdocs.org/ntsb/ERA13LA437.md): Innovator Technologies Mosquito XEL · Felda, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2013 · UNREG · Destroyed
  > The pilot’s loss of helicopter control while hovering for reasons that could not be determined during postaccident examination of the helicopter, which was limited due to postcrash fire damage.
- [NTSB CEN13LA571](https://openairdocs.org/ntsb/CEN13LA571.md): Cessna 182J · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Sep 29, 2013 · N3078F · Substantial damage
  > A loss of engine power for reasons that could not be determined because no anomalies were found during the postaccident engine examination.
- [NTSB WPR13CA428](https://openairdocs.org/ntsb/WPR13CA428.md): Cessna 182Q · Big Bear, CA · Accident · Minor injuries · Data collection · Final report · Sep 28, 2013 · N759UP · Substantial damage
  > The pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.
- [NTSB CEN13FA558](https://openairdocs.org/ntsb/CEN13FA558.md): Cirrus Design SR20 · Bolingbrook, IL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2013 · N406DC · Destroyed
  > The pilot’s failure to maintain control of the airplane during a go-around.
- [NTSB CEN13CA556](https://openairdocs.org/ntsb/CEN13CA556.md): Cessna 152 · Wadsworth, OH · Accident · Serious injuries · Data collection · Final report · Sep 24, 2013 · N24800 · Substantial damage
  > The pilot's failure to adequately maintain airspeed during a go-around.
- [NTSB CEN13CA559](https://openairdocs.org/ntsb/CEN13CA559.md): Cessna 182Q · Goodhue, MN · Accident · No injuries · Data collection · Final report · Sep 22, 2013 · N94303 · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during landing.
- [NTSB WPR13LA416](https://openairdocs.org/ntsb/WPR13LA416.md): Beech C90 - A · Idaho Falls, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2013 · N191TP · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.
- [NTSB ENG13RA041](https://openairdocs.org/ntsb/ENG13RA041.md): ATR 72-500 · Makassar, Indonesia, Indonesia · Incident · No injuries · Foreign investigation · Sep 18, 2013 · PK-WFV · Minor damage
- [NTSB WPR13LA408](https://openairdocs.org/ntsb/WPR13LA408.md): Cessna 182A · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Sep 14, 2013 · N6324B · Substantial damage
  > A loss of engine power during final approach for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR13FA405](https://openairdocs.org/ntsb/WPR13FA405.md): Kamtz RV-7A · Jackson Hole, WY · Accident · 2 fatal · Field investigation · Final report · Sep 11, 2013 · N820RV · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Also causal was the pilot’s failure to adequately compensate for the…
- [NTSB ERA13WA411](https://openairdocs.org/ntsb/ERA13WA411.md): Dornier 228 · Valparaiso, Chile · Accident · 2 fatal · Foreign investigation · Sep 9, 2013 · CC-CNW · Destroyed
  > On September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…
- [NTSB ANC13CA096](https://openairdocs.org/ntsb/ANC13CA096.md): Piper PA 18-150 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Sep 8, 2013 · N4483Z · Substantial damage
  > The pilot's delayed decision to go-around, which resulted in a collision with water.
- [NTSB ENG13WA044](https://openairdocs.org/ntsb/ENG13WA044.md): Bombardier CL600 2B19 · Moscow, Russia · Incident · No injuries · Foreign investigation · Sep 7, 2013 · TC-EJA
  > On September 7, 2013 a MNG Jet charter flight, a Bombardier Canadair CL-600-2B19-7763, registration TC-EJA, landed at Vnukovo International Airport, Moscow, Russian Federation, with the nose landing gear extended and both main gear retracted. The…
- [NTSB ERA13FA402](https://openairdocs.org/ntsb/ERA13FA402.md): Cessna T-50 · Lenox Twp., PA · Accident · 2 fatal · Field investigation · Final report · Sep 3, 2013 · N41759 · Destroyed
  > The pilot's intentional visual flight into night instrument meteorological conditions and thunderstorms and his improper decision to takeoff without getting updated weather information after a briefer cautioned him during a previous flight that visual flight…
- [NTSB CEN13CA573](https://openairdocs.org/ntsb/CEN13CA573.md): Schweizer SGS 2 33A · Hampshire, IL · Accident · No injuries · Data collection · Final report · Sep 2, 2013 · N2668H · Substantial damage
  > The student pilot's inadequate compensation for landing area conditions during an off-airport landing which resulted in a collision with an obstruction.
- [NTSB WPR13CA395](https://openairdocs.org/ntsb/WPR13CA395.md): Beech C-50 · Homedale, ID · Accident · No injuries · Data collection · Final report · Sep 1, 2013 · N212G · Substantial damage
  > The pilot's delayed action to arrest a loss of altitude on short final, which resulted in a loss of aircraft control and collision with a fence post.
- [NTSB CEN13LA525](https://openairdocs.org/ntsb/CEN13LA525.md): Cessna 182 · Boulder, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2013 · N6460A · Substantial damage
  > The pilot's failure to adequately clear carburetor icing, resulting in a loss of engine power on final approach following a descent at idle power.
- [NTSB WPR13FA393](https://openairdocs.org/ntsb/WPR13FA393.md): Stuart Vortex · Scappoose, OR · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2013 · N43259 · Destroyed
  > The student pilot's unintentional takeoff followed by his failure to maintain control of the gyroplane during the landing approach. Contributing to the accident was the student pilot’s lack of both flight training and flight experience and his lack of a solo…
- [NTSB ERA13LA390](https://openairdocs.org/ntsb/ERA13LA390.md): Continental Copters 47G · Sandy Hook, KY · Accident · No injuries · Limited investigation · Final report · Aug 31, 2013 · N6356X · Substantial damage
  > The in-flight disengagement of the tail rotor extension shaft from the tail rotor gearbox, resulting in a loss of tail rotor control.
- [NTSB CEN13LA524](https://openairdocs.org/ntsb/CEN13LA524.md): Stemme S10-VT · Mackinaw City, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 2013 · N389BD · Substantial damage
  > The mechanic’s failure to inspect the tightness of the bolts that connected the flexible disk to the driveshaft, which resulted in the failure of these components.
- [NTSB ERA13WA401](https://openairdocs.org/ntsb/ERA13WA401.md): Piper PA-32-300 · Macas, Ecuador · Accident · Serious injuries · Foreign investigation · Aug 30, 2013 · HC-BOD · Substantial damage
  > On August 30, 2013, about 1630 coordinated universal time (1130 local time), a Piper PA-32-300, Ecuadorian registration HC-BOD, was substantially damaged during a forced landing while approaching Edmundo Carvajal Airport (SEMC), Macas, Ecuador. The Ecuadorian…
- [NTSB ERA13CA392](https://openairdocs.org/ntsb/ERA13CA392.md): Cessna 172L · McComb, MS · Accident · Minor injuries · Data collection · Final report · Aug 30, 2013 · N7892G · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during approach to landing, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB ERA13FA385](https://openairdocs.org/ntsb/ERA13FA385.md): Piper PA-28-161 · Danville, VA · Accident · 1 fatal · Field investigation · Final report · Aug 29, 2013 · N9089N · Destroyed
  > The student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…
- [NTSB ERA13CA375](https://openairdocs.org/ntsb/ERA13CA375.md): Mark C Pauls RV-7A · Cortland, NY · Accident · Minor injuries · Data collection · Final report · Aug 25, 2013 · N411AK · Substantial damage
  > A partial loss of engine power during go-around due to incorrect maintenance of the fuel system by the pilot/builder.
- [NTSB CEN13LA506](https://openairdocs.org/ntsb/CEN13LA506.md): Buckeye Breeze · Franklin, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 2013 · N5164G · 2 aircraft · Substantial damage
  > The failure of both pilots, one of whom was noncertificated, to maintain adequate visual lookout while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the pilots’ inadequate communication about their intended…

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

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

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