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

## Cases, newest first

- [NTSB BFO91FA031](https://openairdocs.org/ntsb/BFO91FA031.md): Cessna 182F · Princeton, WV · Accident · Serious injuries · Field investigation · Final report · Mar 14, 1991 · N3529Y · Destroyed
  > The pilot's inadequate inflight decision which resulted in airframe icing.
- [NTSB MIA91LA096](https://openairdocs.org/ntsb/MIA91LA096.md): Bartholomew Kolb Twinstar · Bronson, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 12, 1991 · N860RB · Destroyed
  > Pilot-in-command's decision to initiate a flight with known deficiencies in his equipment in that his airspeed indicator was inoperative. He then failed to maintain airspeed in a turn on final approach, stalled, and crashed.
- [NTSB LAX91LA130](https://openairdocs.org/ntsb/LAX91LA130.md): Cessna 152 · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Mar 12, 1991 · N757XE · Destroyed
  > The pilot's improper inflight planning which resulted in the flight's encounter with wake turbulence from a landing heavy transport.
- [NTSB CHI91LA106](https://openairdocs.org/ntsb/CHI91LA106.md): Beech A36 · Ogallala, NE · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1991 · N6687U · Destroyed
  > Improper planning/decision by the pilot and the lack of sufficient airspeed to maneuver (circle to land) in unfavorable wind conditions with structural ice on the aircraft. The adverse weather conditions and structural (wing) ice were related factors.
- [NTSB BFO91LA030](https://openairdocs.org/ntsb/BFO91LA030.md): Piper PA-24-250 · Hagerstown, MD · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 1991 · N6699P · Substantial damage
  > The failure of the throttle control cable. A factor ws the rough terrain.
- [NTSB FTW91LA046](https://openairdocs.org/ntsb/FTW91LA046.md): Piper PA-28-140 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 1991 · N7120R · Substantial damage
  > The pilot's failure to maintain airspeed and altitude on final approach.
- [NTSB ATL91LA063](https://openairdocs.org/ntsb/ATL91LA063.md): Cessna 152 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · Mar 5, 1991 · N4663B · Substantial damage
  > The inadvertent stall of the aircraft, encountered as a result of the student pilot's inability to maintain the proper compensation for wind and the lack of total experience of the student pilot.
- [NTSB DCA91MA023](https://openairdocs.org/ntsb/DCA91MA023.md): Boeing 737-291 · Colorado Spgs, CO · Accident · 25 fatal · Class 1 · Major · Final report · Mar 3, 1991 · N999UA · Destroyed
  > A loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…
- [NTSB SEA91LA055](https://openairdocs.org/ntsb/SEA91LA055.md): Cessna 180 · Glasgow, MT · Accident · No injuries · Limited investigation · Final report · Feb 25, 1991 · N7676A · Substantial damage
  > The loss of engine power due to carburetor icing. Factors relating to the accident were the strong winds, high obstructions in the area and tailwind conditions for landing at the only available area.
- [NTSB LAX91LA112](https://openairdocs.org/ntsb/LAX91LA112.md): Piper PA46-310P · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1991 · N9132X · Substantial damage
  > The poor preflight planning performed by the pilot-in-command in accurately determining the weight and fuel consumption of the airplane which resulted in loss of engine power due to fuel exhaustion.
- [NTSB NYC91LA077](https://openairdocs.org/ntsb/NYC91LA077.md): Cessna 182B · Wallkill, NY · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 1991 · N2445G · Substantial damage
  > Decision by the non-instrument rated pilot to attempt flight into instrument meteorological conditions, resulting in airframe icing, loss of control and collision with trees. A factor related to the accident was the failure of the pilot to receive a…
- [NTSB LAX91LA104](https://openairdocs.org/ntsb/LAX91LA104.md): Cessna 340A · Truckee, CA · Accident · No injuries · Limited investigation · Final report · Feb 17, 1991 · N5350J · Substantial damage
  > That the pilot failed to follow the correct emergency procedures when he began to experience engine problems and improperly used the fuel boost pumps contrary to the pilot's operating handbook. The initial cause of the engine surging could not be determined.
- [NTSB LAX91LA101](https://openairdocs.org/ntsb/LAX91LA101.md): Piper PA28-201T · So. Lake Tahoe, CA · Accident · No injuries · Limited investigation · Final report · Feb 16, 1991 · N47569 · Substantial damage
  > The pilot failed to properly compensate for the wind conditions, abruptly flared the airplane, and inadvertenly stalled the airplane. Contributing to this accident was windshear.
- [NTSB FTW91LA040](https://openairdocs.org/ntsb/FTW91LA040.md): Piper PA-28R-200 · Wichita Falls, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 1991 · N9490N · Substantial damage
  > The pilot's inadequate compensation for crosswind conditions encountered on final and his failure to maintain directional control during the attempted go around. A factor in the accident was the unfavorable gusting crosswind conditions.
- [NTSB DEN91LA045](https://openairdocs.org/ntsb/DEN91LA045.md): Piper PA-32-260 · Guymon, OK · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 1991 · N3549W · Destroyed
  > Fuel starvation for undetermined reasons, and the pilot's delay in flaring the airplane. A factor was: the pilot's total lack of experience.
- [NTSB FTW91FA038](https://openairdocs.org/ntsb/FTW91FA038.md): Piper PA-32-300 · Falfurrias, TX · Accident · 5 fatal · Field investigation · Final report · Feb 15, 1991 · N6961C · Destroyed
  > The pilot's improper compensation for wind conditions, the pilot not maintaining airspeed above vs during the go-around attempt and the pilot's impairment due to drugs. Factors were the gusting crosswind conditions and the pilot's lack of total aircraft…
- [NTSB DEN91FA043](https://openairdocs.org/ntsb/DEN91FA043.md): Learjet 35A · Aspen, CO · Accident · 3 fatal · Field investigation · Final report · Feb 14, 1991 · N535PC · Destroyed
  > The flight crew's failure to maintain airspeed and control of the airplane while maneuvering to land. Contributing factors were the flight crew's execution of an unstabilized approach and the surrounding snow-covered mountainous terrain.
- [NTSB ANC91IA028](https://openairdocs.org/ntsb/ANC91IA028.md): Boeing 737-200 · Unalaska, AK · Incident · No injuries · Incident investigation · Final report · Feb 13, 1991 · N672MA · Minor damage
  > The windshear encountered on short final. Contributing to the accident was the rising terrain within 150 feet of the runway, the variable nature of the wind due to the rising terrain, and the pilot's failure to maintain lateral control during the go around.
- [NTSB FTW91LA037](https://openairdocs.org/ntsb/FTW91LA037.md): Cessna 210L · Brownsville, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1991 · N210YB · Substantial damage
  > The pilot's failure to refuel the airplane prior to his departure on the last leg of the flight, which resulted in fuel exhaustion.
- [NTSB LAX91FA093](https://openairdocs.org/ntsb/LAX91FA093.md): Cessna TR182 · Petaluma, CA · Accident · 1 fatal · Field investigation · Final report · Feb 9, 1991 · N2415S · Destroyed
  > The pilot's inadvertent flight into IMC and his failure to maintain aircraft control of the airplane. Factors which contributed to the accident related to the pilot becoming disoriented in the dark, nighttime, instrument weather conditions, and to the pilot's…
- [NTSB CHI91LA093](https://openairdocs.org/ntsb/CHI91LA093.md): Piper PA-28-181 · Marshfield, WI · Accident · No injuries · Limited investigation · Final report · Feb 7, 1991 · N6205J · Substantial damage
  > Improper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.
- [NTSB CHI91FA091](https://openairdocs.org/ntsb/CHI91FA091.md): Piper PA-28R-200 · Dutchtown, MO · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1991 · N3966X · Destroyed
  > The pilot's failure to maintain control of the airplane in instrument meteorological conditions and the pilot exceeding the design stress limits of the airplane during the loss of control. Contributing factors were the existing weather conditions.
- [NTSB CHI91FA090](https://openairdocs.org/ntsb/CHI91FA090.md): Beech F.35 · Sidney, OH · Accident · 1 fatal · Field investigation · Final report · Feb 5, 1991 · N3822B · Destroyed
  > The pilot's intentional VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's disregard for directives and overconfidence in his ability.
- [NTSB SEA91FA046](https://openairdocs.org/ntsb/SEA91FA046.md): Cessna C-172 · Colstrip, MT · Accident · 2 fatal · Field investigation · Final report · Feb 3, 1991 · N8531B · Destroyed
  > The pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…
- [NTSB MIA91LA077](https://openairdocs.org/ntsb/MIA91LA077.md): Ryan Navion · Lake City, FL · Accident · No injuries · Limited investigation · Final report · Feb 3, 1991 · N4154K · Substantial damage
  > In-flight encounter with wind shear while on short final resulting in a hard landing.
- [NTSB LAX91LA089](https://openairdocs.org/ntsb/LAX91LA089.md): Ercoupe 415C · Pixley, CA · Accident · No injuries · Limited investigation · Final report · Feb 3, 1991 · N99483 · Substantial damage
  > The failure of the pilot to use carburetor heat in carburetor icing conditions. Contributing to the accident was the lack of experience in the accident airplane make and model.
- [NTSB CHI91FA088](https://openairdocs.org/ntsb/CHI91FA088.md): Piper PA-28-140 · Osceola, WI · Accident · 7 fatal · Field investigation · Final report · Feb 3, 1991 · N4676R · 2 aircraft · Destroyed
  > Failure of the pilots in both aircraft to seeing-and-avoid the other airplane.
- [NTSB BFO91LA026](https://openairdocs.org/ntsb/BFO91LA026.md): Cessna 150 · Harrisonburg, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1991 · N19240 · Destroyed
  > The pilot's failure to maintain directional control. Contributing to the accident was premature raising of the flaps, and inadequate airspeed.
- [NTSB ATL91LA048](https://openairdocs.org/ntsb/ATL91LA048.md): Piper PA-23-250 · Lumberton, NC · Accident · 1 fatal · Limited investigation · Final report · Feb 3, 1991 · N4749P · No damage
  > The pilot suffered a stroke and lost control of the airplane on final approach.
- [NTSB ATL91FA047](https://openairdocs.org/ntsb/ATL91FA047.md): Piper PA-24-260 · Cordele, GA · Accident · 3 fatal · Field investigation · Final report · Feb 3, 1991 · N9209P · Destroyed
  > Failure of the pilot to attain proper runway alignment and to maintain proper altitude. Related factors were: darkness and the pilot becoming lost/disoriented.
- [NTSB NYC91LA068](https://openairdocs.org/ntsb/NYC91LA068.md): Beech 200 · Johnstown, PA · Accident · No injuries · Limited investigation · Final report · Jan 30, 1991 · N30SE · Substantial damage
  > The pilot's failure to maintain proper directional control of the airplane during landing, resulting in a collision with a snow bank and runway marker. A factor relating to the accident was the low visibility during landing.
- [NTSB LAX91FA086](https://openairdocs.org/ntsb/LAX91FA086.md): Piper PA-24-180 · Dunsmuir, CA · Accident · 1 fatal · Field investigation · Final report · Jan 30, 1991 · N7194P · Destroyed
  > The pilot's delayed go-around attempt and improper use of carburetor heat. Contributing to the accident was a degradation of engine power due to fuel contamination from sand and rust.
- [NTSB MIA91FA075](https://openairdocs.org/ntsb/MIA91FA075.md): Cessna 210L · Orlando, FL · Accident · 1 fatal · Field investigation · Final report · Jan 28, 1991 · N210GC · Destroyed
  > The pilot's failure to maintain aircraft control in instrument conditions and his spatial disorientation. Factors were a failure of the vacuum pump and the pilot's lack of recent experience in partial panel instrument flying or training.
- [NTSB NYC91DFA02](https://openairdocs.org/ntsb/NYC91DFA02.md): Hayes Kolb/Twinstar · Round Lake, NY · Accident · 1 fatal · Final report · Jan 27, 1991 · N71817 · Substantial damage
  > In-flight structural failure of the outboard wing attachment fittings on both wings due to an undetermined reason.
- [NTSB LAX91FA081](https://openairdocs.org/ntsb/LAX91FA081.md): Cessna T210M · Sacramento, CA · Accident · 1 fatal · Field investigation · Final report · Jan 26, 1991 · N210TW · Destroyed
  > A loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the ensuing emergency landing.
- [NTSB MIA91LA071](https://openairdocs.org/ntsb/MIA91LA071.md): Piper PA-31-B-310 · Fernandina Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1991 · N31HL · Substantial damage
  > Delay by the pilot to perform a missed approach and failure to correct the descent before impact with terrain.
- [NTSB NYC91LA064](https://openairdocs.org/ntsb/NYC91LA064.md): Beech 58 · Batavia, NY · Accident · 1 fatal · Limited investigation · Final report · Jan 24, 1991 · N73JP · Destroyed
  > The failure of the pilot to ensure an adequate amount of fuel was on board for the planned flight which resulted in a double power loss due to the fuel exhaustion.
- [NTSB NYC91LA062](https://openairdocs.org/ntsb/NYC91LA062.md): Cessna P206 · Cleveland, OH · Accident · Minor injuries · Limited investigation · Final report · Jan 23, 1991 · N4626F · Substantial damage
  > Fatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).
- [NTSB CHI91LA074](https://openairdocs.org/ntsb/CHI91LA074.md): Piper PA-24 · Cabool, MO · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1991 · N5627P · Substantial damage
  > Failure of the pilot to maintain proper runway alignment during a go-around. Factors related to the accident were: darkness and the pilot's lack of understanding of the landing gear electrical system.
- [NTSB ATL91FA040](https://openairdocs.org/ntsb/ATL91FA040.md): Rockwell 114 · Bessemer, AL · Accident · 4 fatal · Field investigation · Final report · Jan 20, 1991 · N4827W · Destroyed
  > Failure of the pilot to follow instrument flight rules (IFR) and maintain the minimum descent altitude (mda) during the VOR approach. Factors related to the accident were: darkness and the adverse weather conditions.
- [NTSB MIA91FA069](https://openairdocs.org/ntsb/MIA91FA069.md): Beech 58P · Lantana, FL · Accident · 4 fatal · Field investigation · Final report · Jan 17, 1991 · N1802A · Destroyed
  > The pilot in commands failure to maintain airspeed while performing a go around resulting in the airplane stalling and colliding with the ground in an uncontrolled descent.
- [NTSB DEN91LA032](https://openairdocs.org/ntsb/DEN91LA032.md): Piper PA-28-140 · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 1991 · N32108 · Substantial damage
  > The flight instructor's delay in taking remedial action, his inadvertently allowing the airplane to stall, and exceeding the aircraft's climb performance. Factors were: the flight instructor's lack of experience in aircraft type, his lack of experience as a…
- [NTSB FTW91FA030](https://openairdocs.org/ntsb/FTW91FA030.md): Mooney 20J · Newcastle, OK · Accident · 4 fatal · Field investigation · Final report · Jan 15, 1991 · N7201E · Destroyed
  > The pilot's failure to maintain aircraft control. Factors were spatial disorientation, improper IFR procedures, and the dark night with low ceilings and rain.
- [NTSB CHI91DEP03](https://openairdocs.org/ntsb/CHI91DEP03.md): Air Command 503 · Tomahawk, WI · Accident · 1 fatal · Final report · Jan 15, 1991 · UNREG · Destroyed
  > The pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…
- [NTSB LAX91DUQ01](https://openairdocs.org/ntsb/LAX91DUQ01.md): Virgil D. Hawks Quickie · Camarillo, CA · Accident · No injuries · Final report · Jan 12, 1991 · N13VD · Substantial damage
  > The pilot's encounter with wake turbulence and his inflight loss of control by his failure to maintain a sufficient landing distance from a larger aircraft preceding his aircraft.
- [NTSB CHI91LA068](https://openairdocs.org/ntsb/CHI91LA068.md): Cessna 182A · Chadron, NE · Accident · No injuries · Limited investigation · Final report · Jan 12, 1991 · N6082B · Substantial damage
  > An engine power loss for undetermined reasons.
- [NTSB FTW91FA028](https://openairdocs.org/ntsb/FTW91FA028.md): Folland Gnat T-1 · Bossier City, LA · Accident · 2 fatal · Field investigation · Final report · Jan 10, 1991 · N3XR · Destroyed
  > Improper planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to lack of fuel. The adverse weather conditions and radio malfunction were related factors.
- [NTSB LAX91LA067](https://openairdocs.org/ntsb/LAX91LA067.md): Piper PA 34-200T · Red Bluff, CA · Accident · No injuries · Limited investigation · Final report · Jan 7, 1991 · N66SL · Substantial damage
  > The failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.
- [NTSB NYC91FA058](https://openairdocs.org/ntsb/NYC91FA058.md): Mooney M20K · Gallipolis, OH · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1991 · N231MC · Destroyed
  > The pilot allowed the speed of the airplane to get too slow, resulting in an inadvertant stall at too low an altitude to allow recovery. A factor relating to the accident was the pilot's trepidation about a successful landing because of the weather.
- [NTSB CHI91FA059](https://openairdocs.org/ntsb/CHI91FA059.md): Cessna 172P · Freeport, IL · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1991 · N65567 · Destroyed
  > The pilot-in-command's failure to maintain airspeed. Factors contributing were the pilot-in-command's misuse of flaps and his lack of total experience in this type of operation.

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

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

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