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

## Cases, newest first

- [NTSB SEA03LA047](https://openairdocs.org/ntsb/SEA03LA047.md): Cessna 172M · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Mar 17, 2003 · N64427 · Substantial damage
  > The student pilot's failure to maintain proper runway alignment (centerline tracking) during a go around maneuver resulting in the aircraft impacting a runway light. Contributing factors were the gusty/crosswind conditions and the light fixture.
- [NTSB LAX03LA113](https://openairdocs.org/ntsb/LAX03LA113.md): Piper PA24 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Mar 15, 2003 · N842PS · Substantial damage
  > The flight instructor's delayed remedial action during a go-around, which resulted in an inadvertent touchdown and hard landing. Factors associated with the accident are a momentary loss of engine power, and the inadvertent touchdown.
- [NTSB LAX03FA111](https://openairdocs.org/ntsb/LAX03FA111.md): Beech 3NM · Anza, CA · Accident · 3 fatal · Field investigation · Final report · Mar 11, 2003 · N14437 · Destroyed
  > the failure of the pilot to maintain an adequate airspeed resulting in a stall and loss of control.
- [NTSB MIA03CA074](https://openairdocs.org/ntsb/MIA03CA074.md): Schempp-Hirth DISCUS-2B · Clermont, FL · Accident · No injuries · Data collection · Final report · Mar 10, 2003 · N828JN · Substantial damage
  > An in-flight encounter with wind gusts while making an approach to land in a field resulting in the aircraft landing early and colliding with a berm.
- [NTSB FTW03LA107](https://openairdocs.org/ntsb/FTW03LA107.md): Cessna 150K · Sherman, TX · Accident · No injuries · Limited investigation · Final report · Mar 9, 2003 · N6066G · Substantial damage
  > The flight instructor's failure to refuel the airplane which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN03FA045](https://openairdocs.org/ntsb/DEN03FA045.md): Piper PA-46-500TP · Albuquerque, NM · Accident · 3 fatal · Field investigation · Final report · Mar 8, 2003 · N522RF · Destroyed
  > The pilot's unstabilized approach and his failure to maintain obstacle clearance. Contributing factors were the dark night light condition, and the static wires.
- [NTSB ATL03FA055](https://openairdocs.org/ntsb/ATL03FA055.md): Beech A-36 · Milledgeville, GA · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2003 · N333RB · Destroyed
  > The pilot's improper IFR procedure by which he failed to maintain the minimum descent altitude, and his failure to maintain obstacle clearance. A factor was low the ceiling.
- [NTSB SEA03FA042](https://openairdocs.org/ntsb/SEA03FA042.md): Piper PA-34-220T · Rexburg, ID · Accident · 4 fatal · Field investigation · Final report · Mar 5, 2003 · N9257X · Destroyed
  > The pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.
- [NTSB ANC03LA029](https://openairdocs.org/ntsb/ANC03LA029.md): Cessna 208 · Kotzebue, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 2003 · N205BA · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain altitude/clearance above the ground, resulting in a collision with snow and ice covered terrain during the final approach phase of a VFR landing. Factors…
- [NTSB NYC03LA060](https://openairdocs.org/ntsb/NYC03LA060.md): Piper PA-28-235 · Westerly, RI · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2003 · N8547N · Substantial damage
  > The pilot-in-command's delayed remedial action when the airplane flew below the glidepath, and a total loss of engine power for undetermined reasons.
- [NTSB IAD03FA035](https://openairdocs.org/ntsb/IAD03FA035.md): Socata TBM 700 · Leesburg, VA · Accident · 3 fatal · Field investigation · Final report · Mar 1, 2003 · N700PP · Substantial damage
  > The pilot's failure to fly a stabilized, published instrument approach procedure, and his failure to maintain adequate airspeed which led to an aerodynamic stall.
- [NTSB CHI03LA076](https://openairdocs.org/ntsb/CHI03LA076.md): Cessna T210L · New Hudson, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2003 · N123JL · Substantial damage
  > The pilot's failure to maintain aircraft control which resulted in the airplane stalling while on final approach.
- [NTSB NYC03LA059](https://openairdocs.org/ntsb/NYC03LA059.md): Cessna 152 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Feb 28, 2003 · N170SU · Substantial damage
  > The student pilot's misjudgment of distance/altitude and the instructor's delayed remedial action,
- [NTSB SEA03FA041](https://openairdocs.org/ntsb/SEA03FA041.md): Grubert KIS TRI-R TR-1 · Puyallup, WA · Accident · 2 fatal · Field investigation · Final report · Feb 24, 2003 · N23KS · Destroyed
  > The pilot-in-command's failure to maintain adequate flying airspeed during the turn from crosswind to downwind resulting in an inadvertent stall/spin and subsequent collision with terrain (ground).
- [NTSB LAX03LA095](https://openairdocs.org/ntsb/LAX03LA095.md): Aerostar RX-7 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Feb 22, 2003 · N6413N · Substantial damage
  > A sudden wind shift that forced the balloon to drift towards an obstruction, and the pilot's inability to perform an evasive maneuver in sufficient time to prevent a collision.
- [NTSB FTW03LA100](https://openairdocs.org/ntsb/FTW03LA100.md): Cessna 172K · Jacksonville, TX · Accident · No injuries · Limited investigation · Final report · Feb 18, 2003 · N678BC · Substantial damage
  > The pilot's inadequate preflight planning and preparation for the flight which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI03LA072](https://openairdocs.org/ntsb/CHI03LA072.md): Beech V35 · Sparta, MI · Accident · No injuries · Limited investigation · Final report · Feb 18, 2003 · N9439S · Substantial damage
  > The pilots improper decision to fly into known adverse weather, and his failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was airframe icing.
- [NTSB ATL03LA047](https://openairdocs.org/ntsb/ATL03LA047.md): Beech C23 · Valdosta, GA · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 2003 · N2190W · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.
- [NTSB ATL03LA046](https://openairdocs.org/ntsb/ATL03LA046.md): Beech A36 · Morristown, TN · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 2003 · N100DA · Substantial damage
  > The pilot's inadequate preflight planning/decision to initiate flight into known adverse weather conditions, resulting in the in-flight encounter with weather and subsequent in-flight collision with terrain. A factor was airplane performance deteriorated due…
- [NTSB IAD03FA032](https://openairdocs.org/ntsb/IAD03FA032.md): Cessna 421 · Ferguson, KY · Accident · 3 fatal · Field investigation · Final report · Feb 17, 2003 · N421TJ · Destroyed
  > The pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.
- [NTSB NYC03LA055](https://openairdocs.org/ntsb/NYC03LA055.md): Cessna 140 · Fryeburg, ME · Accident · No injuries · Limited investigation · Final report · Feb 16, 2003 · N76897 · Substantial damage
  > An in-flight encounter with carburetor ice, which resulted in a total loss of engine power during a simulated engine failure.
- [NTSB NYC03LA051](https://openairdocs.org/ntsb/NYC03LA051.md): Piper PA-31-350 · Taylor Mill, KY · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 2003 · N130CM · Substantial damage
  > The pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision not to land and refuel.
- [NTSB ATL03LA044](https://openairdocs.org/ntsb/ATL03LA044.md): Cessna 172 · Hendersonville, NC · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 2003 · N80355 · Substantial damage
  > The pilot's failure to maintain directional control and clearence from power lines during a go-around, resulting in an in-flight collision with a powerline.
- [NTSB SEA03LA037](https://openairdocs.org/ntsb/SEA03LA037.md): Cessna 172S · Everett, WA · Accident · No injuries · Limited investigation · Final report · Feb 9, 2003 · N912LB · Substantial damage
  > The pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision of the flight. Contributing factors were the rime icing conditions, and the soft terrain encountered on the off runway rollout.
- [NTSB LAX03LA084](https://openairdocs.org/ntsb/LAX03LA084.md): Cobb International Rotorway Exec 90 · Casa Grande, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 2003 · N9876D · Substantial damage
  > the flight instructor's failure to maintain directional control of the helicopter during the flare and landing. Factors in the accident were the failure of the secondary drive shaft and inadequate tail rotor failure procedures specified by the manufacturer.
- [NTSB IAD03LA030](https://openairdocs.org/ntsb/IAD03LA030.md): Young Challenger II · Huntington, WV · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2003 · N851MY · Substantial damage
  > The pilot's improper decision to switch off the ignition on approach and not attaining the proper touchdown point.
- [NTSB LAX03LA079](https://openairdocs.org/ntsb/LAX03LA079.md): Piper PA-28-140 · Tehachapi, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 2003 · N6087W · Substantial damage
  > The pilot's failure to maintain adequate clearance above the surrounding terrain, and his evasive maneuver to avoid a perceived object. A factor in the accident was the dark night.
- [NTSB LAX03FA078](https://openairdocs.org/ntsb/LAX03FA078.md): Beech D95A · Lancaster, CA · Accident · 2 fatal · Field investigation · Final report · Jan 31, 2003 · N5639S · Destroyed
  > a loss of aircraft control due to the instructor pilot's incapacitation by seizure activity as a result of his undiagnosed cancer, and his use of a medication that can increase seizure risk.
- [NTSB FTW03LA096](https://openairdocs.org/ntsb/FTW03LA096.md): Cessna 182F · Wildorado, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 2003 · N3535Y · Substantial damage
  > The airplane collided with an animal that wandered onto the runway. A contributing factor was sun glare impairing the pilot's view on final approach.
- [NTSB DEN03FA040](https://openairdocs.org/ntsb/DEN03FA040.md): Beech V35B · Rock Springs, WY · Accident · 1 fatal · Field investigation · Final report · Jan 30, 2003 · N935V · Destroyed
  > the pilot's failure to maintain adequate airspeed, resulting in a stall. Factors contributing to the accident were the icing conditions, low altitude, and the high gusting winds.
- [NTSB DEN03LA039](https://openairdocs.org/ntsb/DEN03LA039.md): Cessna 172M · Logan, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 2003 · N64312 · Substantial damage
  > the pilot's improper in-flight planning/decision, his failure to accomplish appropriate checklist items during the go-around, and his failure to maintain clearance from the trees and the lamp post. Factors contributing to the accident were the low altitude,…
- [NTSB MIA03LA045](https://openairdocs.org/ntsb/MIA03LA045.md): Bornhofen Twinjet 1500 · Melbourne, FL · Accident · 1 fatal · Limited investigation · Final report · Jan 24, 2003 · N750TJ · Destroyed
  > the pilot-in-command failed to obtain sufficient altitude to clear obstacles at the approach end of the airport which resulted in an in-flight collision with trees.
- [NTSB LAX03FA073](https://openairdocs.org/ntsb/LAX03FA073.md): Cessna 402C · Mather, CA · Accident · Serious injuries · Field investigation · Final report · Jan 24, 2003 · N6814A · Destroyed
  > loss of engine power in the left engine for undetermined reasons. Also causal was the pilot's failure to correctly configure the airplane for a single engine missed approach, which resulted in a negative climb performance. A factor was the pilot's decision to…
- [NTSB LAX03FA072](https://openairdocs.org/ntsb/LAX03FA072.md): Cirrus Design SR 20 · San Jose, CA · Accident · 1 fatal · Field investigation · Final report · Jan 24, 2003 · N893MK · Destroyed
  > The pilot's failure to maintain the course for the published approach procedure due to his diverted attention. The distraction responsible for the pilot's diverted attention was the erroneous frequency assignment provided by ATC and the resultant task…
- [NTSB NYC03LA041](https://openairdocs.org/ntsb/NYC03LA041.md): Piper PA-28-180 · Poughkeepsie, NY · Accident · No injuries · Limited investigation · Final report · Jan 18, 2003 · N5136L · Substantial damage
  > The pilot's failure to maintain an adequate amount of engine power while maneuvering to land, which produced delayed engine response times. A facture in the accident was the cold day.
- [NTSB CHI03FA056](https://openairdocs.org/ntsb/CHI03FA056.md): Bell 206L-1 · B.S. 53, LA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2003 · N3194P · Destroyed
  > The improper approach by the pilot and the settling with power encountered by the pilot.
- [NTSB LAX03FA067](https://openairdocs.org/ntsb/LAX03FA067.md): Cessna 414 · Palm Springs, CA · Accident · Serious injuries · Field investigation · Final report · Jan 14, 2003 · N127WW · Substantial damage
  > The flight instructor's improper selection of the high boost position for the operating right engine while on base leg to land, which resulted in a loss of engine power of the right engine. Factors associated with the accident are the left engine's loss of…
- [NTSB CHI03LA051](https://openairdocs.org/ntsb/CHI03LA051.md): Piper PA-38-112 · Mansfield, MO · Accident · No injuries · Limited investigation · Final report · Jan 13, 2003 · N2400K · Substantial damage
  > The pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the loss of engine power.
- [NTSB SEA03FA024](https://openairdocs.org/ntsb/SEA03FA024.md): Bombardier DHC-8-401 · Medford, OR · Accident · Serious injuries · Field investigation · Final report · Jan 9, 2003 · N409QX · Substantial damage
  > The fracture and spalling of the inner-most pane of the aircraft's port side windshield while on a downwind for a night visual approach due to an imposed load beyond that required for windshield certification (multiple bird strikes). Factors include a dark…
- [NTSB DEN03LA031](https://openairdocs.org/ntsb/DEN03LA031.md): Piper PA-34-200 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jan 9, 2003 · N16453 · Substantial damage
  > the pilot's failure to maintain clearance from the power lines and his improper in flight planning and decision to maneuver on a go around without noting where the power lines were. Factors contributing to the accident were the pilot's inability to see the…
- [NTSB CHI03LA046](https://openairdocs.org/ntsb/CHI03LA046.md): Cessna 310R · Ada, MN · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 2003 · N37221 · Destroyed
  > The pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.
- [NTSB ATL03LA028](https://openairdocs.org/ntsb/ATL03LA028.md): Cessna 172F · Stuart, FL · Accident · No injuries · Limited investigation · Final report · Dec 31, 2002 · N5338R · Substantial damage
  > The pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.
- [NTSB MIA03FA034](https://openairdocs.org/ntsb/MIA03FA034.md): Cessna 208B · Manteo, NC · Accident · 1 fatal · Field investigation · Final report · Dec 25, 2002 · N1122Y · Substantial damage
  > The pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…
- [NTSB SEA03LA020](https://openairdocs.org/ntsb/SEA03LA020.md): Grumman American AA-1 · Chehalis, WA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2002 · N5985L · Substantial damage
  > The total loss of engine power, for undetermined reasons, while the aircraft was on a VFR final approach. No suitable terrain for landing and water were factors.
- [NTSB FTW03LA065](https://openairdocs.org/ntsb/FTW03LA065.md): Beech BE-35 · Denver City, TX · Accident · No injuries · Limited investigation · Final report · Dec 21, 2002 · N9096Q · Substantial damage
  > The pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.
- [NTSB NYC03LA031](https://openairdocs.org/ntsb/NYC03LA031.md): Bell 206B · Odenton, MD · Accident · No injuries · Limited investigation · Final report · Dec 18, 2002 · N651GA · Substantial damage
  > The pilot's failure to monitor his fuel supply which resulted in a power loss due to fuel exhaustion, and the pilot's misjudged flare, which resulted in a hard landing.
- [NTSB CHI03FA041](https://openairdocs.org/ntsb/CHI03FA041.md): Cessna 208B · Rockford, IL · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2002 · N277PM · Destroyed
  > The pilot's failure to maintain control of the airplane during the ILS approach. Factors associated with the accident were the low ceilings, high winds, crosswind, and wind shear conditions that existed.
- [NTSB OPS03IA001](https://openairdocs.org/ntsb/OPS03IA001.md): Airbus Industrie 330-301 · Agana · Incident · No injuries · Incident investigation · Final report · Dec 17, 2002 · F-OHZO · Minor damage
  > The pilot's initiation of a premature descent that was both below the nominal glideslope and steeper than normal. Contributing to the incident was the air traffic controller's failure to respond to the MSAW warning and issue a safety alert as required by FAA…
- [NTSB LAX03FA051](https://openairdocs.org/ntsb/LAX03FA051.md): Piper PA-24-250 · Anaheim Hills, CA · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2002 · N6268P · Destroyed
  > the pilot's encounter with forecast severe turbulence during an inadvertent penetration of an intense weather cell, which resulted in the pilot exceeding the design structural limits of the airplane. A factor in the accident was the pilot's inadequate…
- [NTSB FTW03FA059](https://openairdocs.org/ntsb/FTW03FA059.md): Beech 1900C · Eagleton, AR · Accident · 3 fatal · Field investigation · Final report · Dec 9, 2002 · N127YV · Destroyed
  > In-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.

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

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

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