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

## Cases, newest first

- [NTSB CHI90LA045](https://openairdocs.org/ntsb/CHI90LA045.md): Beech 58P · Harrison, OH · Accident · No injuries · Limited investigation · Final report · Dec 18, 1989 · N6036S · Substantial damage
  > The pilot misjudged his distance, speed, and altitude on final approach and failed to attain the proper touchdown. Factors related to the accident were: uneven (rising) terrain near the runway threshold and the runway light.
- [NTSB DEN90FA033](https://openairdocs.org/ntsb/DEN90FA033.md): Beech B35-A33 · Castle Rock, CO · Accident · 2 fatal · Field investigation · Final report · Dec 16, 1989 · N477T · Destroyed
  > The pilot's loss of control as a result of spatial disorientation. Factors related to the accident were: the adverse weather conditions.
- [NTSB SEA90LA029](https://openairdocs.org/ntsb/SEA90LA029.md): Aero Commander 600 S-2D · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1989 · N1767S · Destroyed
  > An engine loss of power for undetermined reasons. Contributing to the accident was the embankment.
- [NTSB LAX90DJA02](https://openairdocs.org/ntsb/LAX90DJA02.md): Bryce Duster BJ-1B · Haleiwa, Oahu, HI · Accident · Minor injuries · Final report · Dec 11, 1989 · N25601 · Substantial damage
  > The separation in flight of the vertical wood fin from the main structure. It was not determined if the separation was due to overload forces or fatigue.
- [NTSB ATL90FA038](https://openairdocs.org/ntsb/ATL90FA038.md): Cessna T210N · Spindale, NC · Accident · 3 fatal · Field investigation · Final report · Dec 10, 1989 · N5417C · Destroyed
  > The pilot-in-command's improper IFR procedure which resulted in descent below the minimum descent altitude. Contributingfactor(s) was: the fog and low ceiling.
- [NTSB NYC90LA037](https://openairdocs.org/ntsb/NYC90LA037.md): Cessna 172G · Uxbridge, MA · Accident · Serious injuries · Limited investigation · Final report · Dec 9, 1989 · N4289L · Destroyed
  > Ice in the fuel strainer, which restricted fuel flow & resulted in fuel starvation, and the pilot inadvertently stalled the airplane, when he abruptly maneuvered it to avoid a transmission wire during a forced landing.
- [NTSB MIA90IA038](https://openairdocs.org/ntsb/MIA90IA038.md): Mcdonnell Douglas DC-9-51 · Tallahassee, FL · Incident · No injuries · Incident investigation · Final report · Dec 8, 1989 · N404EA · Minor damage
  > Failure of the first officer to properly align the aircraft for landing, and the captain's delay in taking remedial action.
- [NTSB CHI90LA036](https://openairdocs.org/ntsb/CHI90LA036.md): Schweizer SGS-2-33A · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Dec 3, 1989 · N2610H · Substantial damage
  > The dual student did not maintain proper glidepath and his misjudgment for compensation for wind conditions resulted in a collision with utility wires. The cfi's inadequate supervision during the duel flight operation contributed to the accident.
- [NTSB LAX90LA048](https://openairdocs.org/ntsb/LAX90LA048.md): Aerostar RX-7 · Chandler, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1989 · N64997 · Substantial damage
  > Improper planning/decision by the pilot. Factors related to the accident were: variable and high wind conditions.
- [NTSB DEN90FA030](https://openairdocs.org/ntsb/DEN90FA030.md): Beech F-90 · Lincoln, NM · Accident · 2 fatal · Field investigation · Final report · Dec 2, 1989 · N9PU · Destroyed
  > Loss of control due to pilot disorientation while conducting a non precision instrument approach. Contributing to the accident was the pilot's lack of instrument and multiengine experience, and the existing adverse weather.
- [NTSB CHI90DEE02](https://openairdocs.org/ntsb/CHI90DEE02.md): Edward Avid Flyer C · Lansing Arpt, IL · Accident · Serious injuries · Final report · Dec 1, 1989 · N533T · Destroyed
  > Pilot's failure to attain proper runway alignment prior to touchdown. A factor in the accident was the builder's improper modification of the carburetors.
- [NTSB CHI90LA035](https://openairdocs.org/ntsb/CHI90LA035.md): Piper PA-22 · Barron, WI · Accident · No injuries · Limited investigation · Final report · Nov 30, 1989 · N8749D · Substantial damage
  > Improper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.
- [NTSB BFO90LA014](https://openairdocs.org/ntsb/BFO90LA014.md): Cessna 421B · Chesapeake, VA · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1989 · N3359Q · Destroyed
  > The pilot misjudged distance and altitude to the runway, while on final approach to land. The light condition at dusk was a related factor.
- [NTSB FTW90LA036](https://openairdocs.org/ntsb/FTW90LA036.md): Cessna 150 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Nov 27, 1989 · N714AE · Substantial damage
  > Fuel exhaustion due to the inadequate in-flight planning/decision by the plt. A factor in this was the improper initial training by the flight instructor.
- [NTSB LAX90DUG02](https://openairdocs.org/ntsb/LAX90DUG02.md): Wittman Tailwind W-8 · Chino, CA · Accident · Serious injuries · Final report · Nov 26, 1989 · N77DR · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB LAX90LA041](https://openairdocs.org/ntsb/LAX90LA041.md): Barnes AX-7 · Sun City, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 1989 · N4058F · Substantial damage
  > Inadequate visual lookout by the student pilot (his failure to see & avoid). The transmission line and the student's lack of familiarity with the area were related factors.
- [NTSB ATL90LA030](https://openairdocs.org/ntsb/ATL90LA030.md): Bell 47G-3B1 · Ewell, AL · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 1989 · N1358X · Substantial damage
  > The loss of engine power, for undetermined reasons, at low altitude during a practice autorotation. Contributing to the accident was the instructor's failure to properly plan the demonstrated autorotation so as to preclude an accident, in the event that power…
- [NTSB MKC90LA034](https://openairdocs.org/ntsb/MKC90LA034.md): Cessna 150 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Nov 24, 1989 · N8912S · Substantial damage
  > Fuel exhaustion due to poor planning and the pilot's failure to refuel the aircraft.
- [NTSB SEA90FA021](https://openairdocs.org/ntsb/SEA90FA021.md): Beech B35 · Bremerton, WA · Accident · 2 fatal · Field investigation · Final report · Nov 23, 1989 · N8918A · Destroyed
  > The pilot's improper IFR procedure, his failure to maintain proper alignment on the ILS approach, and his failure to initiate a missed approached after reaching the lateral limits of the ILS system or decision height. Darkness and deteriorating weather were…
- [NTSB NYC90LA032](https://openairdocs.org/ntsb/NYC90LA032.md): Piper PA-32R-300 · Johnstown, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 1989 · N1028Q · Substantial damage
  > Failure of the pilot to maintain proper airspeed and altitude on an ILS final approach, which allowed the aircraft to descend below the glide path and collide with approach lighting. Factors related to the accident were: darkness, adverse weather conditions,…
- [NTSB FTW90IA030](https://openairdocs.org/ntsb/FTW90IA030.md): Saab-Fairchild 340A · Beaumont, TX · Incident · No injuries · Incident investigation · Final report · Nov 22, 1989 · N363MA · Minor damage
  > The pilot failed to maintain adjusted vref and proper descent rates during the approach. The pilot delayed decision to execute a go-around and the copilot failed to monitor the poorly flown approach. Contributing to the accident was the rain and wind shear…
- [NTSB MIA90LA030](https://openairdocs.org/ntsb/MIA90LA030.md): Cessna 177RG · Mims, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 1989 · N7628V · Substantial damage
  > A worn throttle control assembly that had failed.
- [NTSB LAX90LA038](https://openairdocs.org/ntsb/LAX90LA038.md): Piper PA-28-161 · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1989 · N4359C · Substantial damage
  > Inadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Collision with a vehicle in the emergency landing area contributed to the damage and injuries.
- [NTSB CHI90LA030](https://openairdocs.org/ntsb/CHI90LA030.md): Cessna 150M · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Nov 19, 1989 · N66714 · Substantial damage
  > Inadequate preflight planning/preparation which resulted in fuel exhaustion due to an inadequate supply of fuel.
- [NTSB MKC90LA031](https://openairdocs.org/ntsb/MKC90LA031.md): Cessna 172 · Osage City, KS · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 1989 · N20428 · Substantial damage
  > The pilot misjudged distance and altitude to the runway while on final approach to land. Factors related to the accident were: dark night and static wires.
- [NTSB LAX90LA035](https://openairdocs.org/ntsb/LAX90LA035.md): Cessna 177RG · Van Nuys, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1989 · N2069Q · Substantial damage
  > The incorrect installation of the engine cowl and baffle seals during the installation of the engine following an overhaul.
- [NTSB NYC90FA030](https://openairdocs.org/ntsb/NYC90FA030.md): Piper PA-28R-200 · New Castle, NY · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1989 · N55399 · Destroyed
  > The pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.
- [NTSB NYC90FA029](https://openairdocs.org/ntsb/NYC90FA029.md): Hughes 369HS · North Adams, MA · Accident · 2 fatal · Field investigation · Final report · Nov 15, 1989 · N9208F · Destroyed
  > Failure of the pilot-in-command (PIC) to assure proper rotor RPM and proper operation of the flight controls during an approach in gusty wind conditions. A factor related to the accident was: the pic's lack of experience in the type of operation.
- [NTSB FTW90LA027](https://openairdocs.org/ntsb/FTW90LA027.md): Cessna 150M · Norman, OK · Accident · No injuries · Limited investigation · Final report · Nov 15, 1989 · N9258U · Destroyed
  > The pilot inadvertently became lost and disoriented and delayed in obtaining help from the flight service station, which resulted in fuel exhaustion.
- [NTSB CHI90FA028](https://openairdocs.org/ntsb/CHI90FA028.md): Beech A36 · Shell Lake, WI · Accident · 3 fatal · Field investigation · Final report · Nov 14, 1989 · N1607W · Destroyed
  > The pilot-in-command's failure to perform a missed approach, his descending below the minimum descent altitude, and his failure to maintain proper altitude to avoid impact with the terrain. Contributing to the accident was the pilot-in-command's lack of total…
- [NTSB ATL90LA027](https://openairdocs.org/ntsb/ATL90LA027.md): Piper PA-32R-300 · Morrisville, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 1989 · N4945F · Destroyed
  > Loss of engine power for an unknown reason. The dark night and instrument conditions contributed to the accident.
- [NTSB LAX90LA030](https://openairdocs.org/ntsb/LAX90LA030.md): Cessna 210 · North Hollywood, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1989 · N46JW · Destroyed
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications, lack of a suitable area for a forced landing, and obstructions (utility pole &…
- [NTSB LAX90FA031](https://openairdocs.org/ntsb/LAX90FA031.md): Piper PA-28R-200 · Camarillo, CA · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1989 · N2723R · Destroyed
  > Improper IFR procedure by the pilot, and his failure to maintain the minimum descent altitude (mda) for that segment of the VOR approach. Factors related to the accident were: darkness, low ceiling, fog, haze, the pilot's lack of recent instrument experience,…
- [NTSB NYC90LA027](https://openairdocs.org/ntsb/NYC90LA027.md): Piper PA-28 · Coatesville, PA · Accident · No injuries · Limited investigation · Final report · Nov 11, 1989 · N4948T · Substantial damage
  > Improper planning/decision by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel.
- [NTSB LAX90LA029](https://openairdocs.org/ntsb/LAX90LA029.md): Bell-Kitz Kopters 47D1 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1989 · N6324X · Substantial damage
  > A fatigue failure of both the main rotor stabilizer bar tube and the tie rod. In addition, the tie rod nut was loose and did not conform to engineering drawing specifications. Company personnel failed to detect the fatigue cracks during daily inspections.
- [NTSB LAX90FA027](https://openairdocs.org/ntsb/LAX90FA027.md): Cessna R182 · San Diego, CA · Accident · 2 fatal · Field investigation · Final report · Nov 9, 1989 · N2257T · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…
- [NTSB DEN90LA020](https://openairdocs.org/ntsb/DEN90LA020.md): Beech V35B · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 1989 · N8193R · Substantial damage
  > Loss of engine power for an unknown reason.
- [NTSB CHI90LA024](https://openairdocs.org/ntsb/CHI90LA024.md): Beech A36 · Angola, IN · Accident · No injuries · Limited investigation · Final report · Nov 9, 1989 · N951V · Substantial damage
  > Failure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness and adverse weather conditions.
- [NTSB CHI90LA023](https://openairdocs.org/ntsb/CHI90LA023.md): Piper 601P · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Nov 8, 1989 · N601LC · Substantial damage
  > The pilot failed to maintain adequate airspeed while maneuvering to circle and land, which resulted in an inadvertent stall. Factors related to the accident were: the excessive maneuver (steep turn) and terrain conditions (road and curb) short of the runway.
- [NTSB MKC90LA022](https://openairdocs.org/ntsb/MKC90LA022.md): Cessna 152 · Toledo, IA · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1989 · N6449M · Substantial damage
  > The pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.
- [NTSB LAX90LA024](https://openairdocs.org/ntsb/LAX90LA024.md): Cessna 320 · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1989 · N3018T · Substantial damage
  > Failure of the pilot to attain the proper touchdown point and his improper flare for landing. Factors related to the accident were: the pilot's lack of experience in the make and model of aircraft, and company induced pressure.
- [NTSB SEA90LA011](https://openairdocs.org/ntsb/SEA90LA011.md): I.C.A. Brasov IS-28B2 · Chilcoot, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 1989 · N72598 · Destroyed
  > The pilot's improper inflight planning. Contributing to the accident was a down draft and the pilot's lack of recent expereince in this aircraft type.
- [NTSB MKC90LA021](https://openairdocs.org/ntsb/MKC90LA021.md): Bell 206L-3 · Saint Paul, MN · Accident · No injuries · Limited investigation · Final report · Nov 2, 1989 · N3174S · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Darkness was a related factor.
- [NTSB MIA90FA021](https://openairdocs.org/ntsb/MIA90FA021.md): Smith, Ted Aerostar Aerostar 600 · Apopka, FL · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1989 · N7526S · Destroyed
  > Failure of the pilot to maintain altitude/clearance above the water, while proceeding over a lake and approaching the vicinity of the airport.
- [NTSB ATL90FA022](https://openairdocs.org/ntsb/ATL90FA022.md): Cessna 182P · Darlington, SC · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1989 · N58735 · Destroyed
  > The pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.
- [NTSB MIA90FA022](https://openairdocs.org/ntsb/MIA90FA022.md): Piper 601P · Fort Myers, FL · Accident · 1 fatal · Field investigation · Final report · Nov 1, 1989 · N50TR · Destroyed
  > Failure of the pilot to properly follow the IFR procedure and to identify the decision height. Factors related to the accident were: the adverse weather conditions, darkness, the pilot's lack of visual perception without the approach lights, and tree(s) in…
- [NTSB LAX90LA020](https://openairdocs.org/ntsb/LAX90LA020.md): Piper PA-18-150 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Oct 29, 1989 · N9292Z · Substantial damage
  > The flight instructor improperly supervised the flight and the dual student pilot failed to properly set the fuel selector valve in the proper position. Both pilots failed to use the emergency checklist.
- [NTSB ATL90FA016](https://openairdocs.org/ntsb/ATL90FA016.md): Cessna T210M · Peachtree City, GA · Accident · Minor injuries · Field investigation · Final report · Oct 28, 1989 · N8444M · Substantial damage
  > The improper calibration of the fuel quantity gauges by maintenance personnel, which resulted in erroneous fuel quantity indications and led to fuel starvation. Contributing to the accident were the unsuitable terrain conditions that existed at the…
- [NTSB ATL90LA014](https://openairdocs.org/ntsb/ATL90LA014.md): Cessna 150K · Vine Grove, KY · Accident · No injuries · Limited investigation · Final report · Oct 25, 1989 · N2662Q · Substantial damage
  > Inadequate preflight planning/preparation by the student pilot, which led to fuel exhaustion due to an inadequate supply of fuel. The pilot's failure to attain the proper touchdown point during the landing and the parked airplane were contributing factors.
- [NTSB ATL90LA012](https://openairdocs.org/ntsb/ATL90LA012.md): Cessna 172N · Knightdale, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 1989 · N737QG · Substantial damage
  > The pilot's failure to maintain the proper glide path to the runway resulting in the airplane colliding with trees while making an approach to landing with no electrical power.

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

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

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