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

## Cases, newest first

- [NTSB SEA00LA072](https://openairdocs.org/ntsb/SEA00LA072.md): Cessna A185F · Wallowa, OR · Accident · No injuries · Limited investigation · Final report · Apr 4, 2000 · N78DE · Substantial damage
  > The pilot's failure to maintain proper runway alignment upon encountering a wind gust, and his subsequent failure or inability to maintain clearance with a tree during a go-around attempt. Factors included a short and narrow airstrip, gusty wind conditions,…
- [NTSB MIA00IA128](https://openairdocs.org/ntsb/MIA00IA128.md): Dassault DA-20 · Opa Locka, FL · Incident · No injuries · Incident investigation · Final report · Apr 4, 2000 · N175GA · Minor damage
  > The failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…
- [NTSB IAD00LA031](https://openairdocs.org/ntsb/IAD00LA031.md): Beech 23 · Selinsgrove, PA · Accident · No injuries · Limited investigation · Final report · Apr 3, 2000 · N1923L · Substantial damage
  > The student pilot's inadequate correction for torque, which resulted in a loss of directional control of the airplane.
- [NTSB LAX00LA145](https://openairdocs.org/ntsb/LAX00LA145.md): Owens/Richburg Vans RV6-A · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Apr 2, 2000 · N4419Q · Substantial damage
  > Failure to maintain sufficient altitude while on the base to final turn for landing subsequently striking the wing tip on the runway.
- [NTSB ANC00LA040](https://openairdocs.org/ntsb/ANC00LA040.md): Cessna 150M · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Apr 2, 2000 · N704GK · Substantial damage
  > The pilot's selection of an unsuitable landing area. Factors associated with the accident were the pilot's disorientation, landing at the wrong airport, flat lighting conditions, and his delay in initiating a go-around.
- [NTSB MIA00LA125](https://openairdocs.org/ntsb/MIA00LA125.md): Beech 58 · Rocky Mount, NC · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2000 · N8230V · Substantial damage
  > The pilot's inadvertent VFR flight into IMC conditions and the failure of the pilot to maintain altitude/clearance resulting in the in-flight collision with trees and unmarked power lines during a visual approach to the runway.
- [NTSB LAX00LA140](https://openairdocs.org/ntsb/LAX00LA140.md): Stuart RAF 2000 GTX SE · Overton, NV · Accident · 1 fatal · Limited investigation · Final report · Mar 27, 2000 · N60739 · Destroyed
  > Failure of the pilot to obtain/maintain aircraft control. A factor in the accident was the pilot's inexperience in rotorcraft.
- [NTSB MIA00LA120](https://openairdocs.org/ntsb/MIA00LA120.md): Cessna 152 · Edgewater, FL · Accident · No injuries · Limited investigation · Final report · Mar 26, 2000 · N757JE · Substantial damage
  > The partial loss of engine power due to undetermined reasons.
- [NTSB MIA00LA119](https://openairdocs.org/ntsb/MIA00LA119.md): Bair Helicopters Searey · Kill Devil Hill, NC · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 2000 · N246DB · Substantial damage
  > The inadvertent stall by the pilot-in-command while on final approach resulting in the uncontrolled descent and in-flight collision with water.
- [NTSB FTW00FA103](https://openairdocs.org/ntsb/FTW00FA103.md): Cessna 525 · Buda, TX · Accident · 1 fatal · Field investigation · Final report · Mar 26, 2000 · N130MR · Destroyed
  > the pilot's inadequate in-flight decision to continue a visual approach in instrument meteorological conditions which resulted in his failure to maintain terrain clearance. Contributing factors were the fog, drizzle, and low ceilings.
- [NTSB DEN00LA065](https://openairdocs.org/ntsb/DEN00LA065.md): Cessna 182K · Hanksville, UT · Accident · Serious injuries · Limited investigation · Final report · Mar 25, 2000 · N2722Q · Destroyed
  > The pilot inadvertently allowing the airplane to porpoise after landing hard, and inadvertently stalling the airplane after aborting the landing attempt. Factors were wind gusts, and the pilot failing to reconfigure the airplane (resetting the elevator trim…
- [NTSB LAX00FA134](https://openairdocs.org/ntsb/LAX00FA134.md): Robinson R22 Beta · Rialto, CA · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2000 · N8328Q · Destroyed
  > The pilot's in-flight loss of control for undetermined reasons.
- [NTSB DEN00LA064](https://openairdocs.org/ntsb/DEN00LA064.md): Johnson Zodiac CH 601 HDS · West Jordan, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 2000 · N984J · Destroyed
  > Total failure of an oil line fitting, resulting in oil exhaustion and subsequent engine seizure. Factors were the poor fitting installation by the pilot, and unsuitable terrain on which to make a forced landing.
- [NTSB MIA00FA117](https://openairdocs.org/ntsb/MIA00FA117.md): Cessna 177RG · Columbia, SC · Accident · 1 fatal · Field investigation · Final report · Mar 22, 2000 · N1556H · Destroyed
  > The PIC's inadequate planning and preparation resulting in refueling not being performed and the subsequent fuel exhaustion and forced landing into trees. A factor in the accident was the erratic operation of the right fuel tank quantity indicating system.
- [NTSB NYC00LA095](https://openairdocs.org/ntsb/NYC00LA095.md): Cessna 172 · New Brighton, PA · Accident · No injuries · Limited investigation · Final report · Mar 19, 2000 · N6261E · Substantial damage
  > The pilot's inadequate compensation for the gusty wind conditions. A factor was the windshear encountered on final approach.
- [NTSB ANC00LA036](https://openairdocs.org/ntsb/ANC00LA036.md): Cessna 152 · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Mar 19, 2000 · N96082 · Substantial damage
  > The pilot's inadvertent stall during an attempted go-around. A factor associated with the accident was the pilot's failure to maintain proper runway alignment.
- [NTSB IAD00LA027](https://openairdocs.org/ntsb/IAD00LA027.md): Bellanca 8KCAB · Erwinna, PA · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2000 · N2520Z · 2 aircraft · Substantial damage
  > the improper entry into the traffic pattern by the pilot of the Piper airplane and the inadequate lookout by the pilots in both airplanes. A factor in the accident was that radio communication was not possible because the Piper was not so equipped, and the…
- [NTSB MIA00FA107](https://openairdocs.org/ntsb/MIA00FA107.md): Cessna 310D · Stuart, FL · Accident · No injuries · Field investigation · Final report · Mar 14, 2000 · N6744T · 2 aircraft · Minor damage
  > the failure of both pilots to maintain an adequate visual lookout, resulting in both airplanes colliding in flight. Contributing to the accident were: 1) inadequate approach/departure control service by ATC approach/departure personnel, and the failure of the…
- [NTSB FTW00LA094](https://openairdocs.org/ntsb/FTW00LA094.md): Cessna 152 · Lake Charles, LA · Accident · No injuries · Limited investigation · Final report · Mar 10, 2000 · N68333 · Substantial damage
  > The failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.
- [NTSB CHI00LA089](https://openairdocs.org/ntsb/CHI00LA089.md): Beech A36 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Mar 10, 2000 · N311JR · Substantial damage
  > the pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…
- [NTSB ATL00LA036](https://openairdocs.org/ntsb/ATL00LA036.md): Trike Unknown · Dalton, GA · Accident · 2 fatal · Limited investigation · Final report · Mar 7, 2000 · NONE · Destroyed
  > The pilot's failure to maintain appropriate clearance with objects during final approach to landing. A factor was the tree.
- [NTSB LAX00LA117](https://openairdocs.org/ntsb/LAX00LA117.md): Piper PA-46-310 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Mar 5, 2000 · N43412 · Substantial damage
  > The pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.
- [NTSB NYC00LA087](https://openairdocs.org/ntsb/NYC00LA087.md): Ercoupe 415-C · Rome, NY · Accident · No injuries · Limited investigation · Final report · Mar 4, 2000 · N3719H · Substantial damage
  > The pilot inadvertently selecting the mixture control to off, resulting in a total loss of engine power.
- [NTSB IAD00LA025](https://openairdocs.org/ntsb/IAD00LA025.md): I.C.A. Brasov IS-28B2 · Blairstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 2000 · N97VT · Destroyed
  > the encountering of wind conditions in flight that inhibited the pilot from maintaining altitude.
- [NTSB ATL00LA031](https://openairdocs.org/ntsb/ATL00LA031.md): unknown unknown · Manatee, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 3, 2000 · UNREG · Destroyed
  > The pilot's impairment due to the use of unapproved medication which led to loss of control in flight.
- [NTSB MIA00LA099](https://openairdocs.org/ntsb/MIA00LA099.md): Cessna 150L · Brooksville, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 2000 · N717NC · Substantial damage
  > Total loss of engine power for undetermined reasons on appr oach for landing resulting in an in-flight collision with a dirt bank, separation of the main landing gear, and subsequent nose over. Contributing to the accident was carburetor icing conditions.
- [NTSB ATL00LA029](https://openairdocs.org/ntsb/ATL00LA029.md): Piper PA-23-160 · Titusville, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 2000 · N441WA · Substantial damage
  > The pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.
- [NTSB DEN00LA054](https://openairdocs.org/ntsb/DEN00LA054.md): Mooney M-20C · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Feb 26, 2000 · N90MR · Substantial damage
  > The pilot not following procedures in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing, weather conditions conducive to carburetor ice, and lack of suitable terrain for landing.
- [NTSB CHI00LA082](https://openairdocs.org/ntsb/CHI00LA082.md): Ellis Q2 · Shelbyville, IN · Accident · 1 fatal · Limited investigation · Final report · Feb 25, 2000 · N84DG · Destroyed
  > aircraft control not being maintained by the pilot during the attempted go-around. Factors to the accident were the inadequate preflight by the pilot, which resulted in fuel exhaustion. An additional factor to the accident was the inadvertent stall/mush.
- [NTSB CHI00FA080](https://openairdocs.org/ntsb/CHI00FA080.md): Beech 95-B55 · Moorhead, MN · Accident · 3 fatal · Field investigation · Final report · Feb 24, 2000 · N7736R · Destroyed
  > the pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…
- [NTSB IAD00FA023](https://openairdocs.org/ntsb/IAD00FA023.md): Aerotechnik L-13 SEH Vivat · Plymouth, MA · Accident · 1 fatal · Field investigation · Final report · Feb 23, 2000 · N64RG · Destroyed
  > the flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.
- [NTSB ANC00LA029](https://openairdocs.org/ntsb/ANC00LA029.md): Piper PA-31-T3 · Kotzebue, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 2000 · N219CS · Substantial damage
  > The pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.
- [NTSB MIA00LA093](https://openairdocs.org/ntsb/MIA00LA093.md): Schweizer SGS2-33A · Miami, FL · Accident · No injuries · Limited investigation · Final report · Feb 19, 2000 · N65819 · Substantial damage
  > the pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.
- [NTSB ATL00LA027](https://openairdocs.org/ntsb/ATL00LA027.md): Cessna 152 · Leesburg, FL · Accident · No injuries · Limited investigation · Final report · Feb 19, 2000 · N68197 · Substantial damage
  > The pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB DEN00IA052](https://openairdocs.org/ntsb/DEN00IA052.md): Cessna TR182 · Fort Carson, CO · Incident · No injuries · Incident investigation · Final report · Feb 17, 2000 · N155HC · No damage
  > The pilot electing to fly the aircraft with known deficiencies which resulted in a catastrophic engine failure. Factors were a connecting rod failure, and low engine oil level.
- [NTSB LAX00FA101](https://openairdocs.org/ntsb/LAX00FA101.md): Cessna 172N · Palm Springs, CA · Accident · Minor injuries · Field investigation · Final report · Feb 16, 2000 · N6479D · 2 aircraft · Substantial damage
  > the failure of both flight crews to see and avoid the other airplane while operating in the traffic pattern, which resulted in a mid-air collision. A contributing factor was the failure of the arriving aircraft to comply with air traffic control requests by…
- [NTSB FTW00LA082](https://openairdocs.org/ntsb/FTW00LA082.md): Beech BE-35K · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 2000 · N6089E · Substantial damage
  > The pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.
- [NTSB FTW00LA081](https://openairdocs.org/ntsb/FTW00LA081.md): Piper PA-24-250 · College Station, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 13, 2000 · N7878P · Substantial damage
  > The loss of engine power due to fuel system contamination. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI00LA069](https://openairdocs.org/ntsb/CHI00LA069.md): Beech A36 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Feb 12, 2000 · N711VS · Substantial damage
  > the pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.
- [NTSB CHI00FA070](https://openairdocs.org/ntsb/CHI00FA070.md): Mitsubishi MU-2B-60 · Lewiston, ID · Accident · 1 fatal · Field investigation · Final report · Feb 11, 2000 · N152BK · Destroyed
  > the pilot failed to follow the flight manual procedures and did not engage the Continuous Ignition system resulting in both engines flaming out when the air induction system was blocked with ice. Additional factors to the accident included the hilly terrain,…
- [NTSB CHI00LA067](https://openairdocs.org/ntsb/CHI00LA067.md): Beech V35 · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Feb 10, 2000 · N9582Q · Destroyed
  > inadequate aircraft preflight by the pilot and fuel consumption calculations not being preformed by the pilot. Factors to the accident were fuel exhaustion, the rocks/boulders, and the high vegetation.
- [NTSB ATL00FA024](https://openairdocs.org/ntsb/ATL00FA024.md): Mooney M20J · Odessa, FL · Accident · 2 fatal · Field investigation · Final report · Feb 10, 2000 · N201RC · Substantial damage
  > The pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.
- [NTSB ANC00LA027](https://openairdocs.org/ntsb/ANC00LA027.md): Piper PA-31-T3 · Wales, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 2000 · N110JK · Substantial damage
  > The pilot's inadequate evaluation of the weather conditions, and his inadvertent flight into adverse weather conditions. Factors in the accident were terrain induced turbulence and a tailwind.
- [NTSB CHI00MA066](https://openairdocs.org/ntsb/CHI00MA066.md): Moravan Z242L · Zion, IL · Accident · 3 fatal · Major investigation · Final report · Feb 8, 2000 · N5ZA · 2 aircraft · Destroyed
  > Clearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.
- [NTSB LAX00LA253](https://openairdocs.org/ntsb/LAX00LA253.md): Cessna 310L · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Feb 7, 2000 · N867MF · Substantial damage
  > the fracture across the eyelet of the nose gear retraction rod, which prevented the extension of the nose gear.
- [NTSB MIA00LA081](https://openairdocs.org/ntsb/MIA00LA081.md): Piper PA-28R-200 · Fayette, AL · Accident · No injuries · Limited investigation · Final report · Feb 4, 2000 · N8924T · Substantial damage
  > The pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.
- [NTSB LAX00LA086](https://openairdocs.org/ntsb/LAX00LA086.md): Robinson R44 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Feb 2, 2000 · N999EV · Substantial damage
  > The pilot's failure to use carburetor heat, resulting in a loss of engine power, and, his misjudged autorotation approach that resulted in a collision with the ground during the landing flare. Contributing to the accident was the conditions conducive to…
- [NTSB LAX00LA085](https://openairdocs.org/ntsb/LAX00LA085.md): Siai-Marchetti SF260 · Napa, CA · Accident · No injuries · Limited investigation · Final report · Jan 30, 2000 · N65FD · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.
- [NTSB FTW00LA084](https://openairdocs.org/ntsb/FTW00LA084.md): Mitsubishi MU-300 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Jan 27, 2000 · N900WJ · Substantial damage
  > The diminished effectiveness of the anti-skid brake system due to the slush contaminated runway. Factors were the freezing rain encountered during the approach, coupled with a failure of the horizontal stabilizer heat.
- [NTSB SEA00FA038](https://openairdocs.org/ntsb/SEA00FA038.md): Hughes 269C · Sherwood, OR · Accident · No injuries · Field investigation · Final report · Jan 18, 2000 · N9297F · Substantial damage
  > The pilots failure to arrest the helicopter's descent rate during a planned approach to a hover. Factors include uneven terrain.

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

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

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