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

## Cases, newest first

- [NTSB MIA97LA123](https://openairdocs.org/ntsb/MIA97LA123.md): Cumberland Skybolt · Smithfield, NC · Accident · No injuries · Limited investigation · Final report · Apr 8, 1997 · N4TZ · Substantial damage
  > Installation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…
- [NTSB FTW97LA157](https://openairdocs.org/ntsb/FTW97LA157.md): Beech BE-95 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Apr 7, 1997 · N2702Y · Substantial damage
  > The failure of the right main gear due to improper repair by the company maintenance personnel.
- [NTSB NYC97FA069](https://openairdocs.org/ntsb/NYC97FA069.md): Piper PA-28-180 · Farmingville, NY · Accident · Serious injuries · Field investigation · Final report · Apr 6, 1997 · N4400T · Substantial damage
  > the pilot's improper inflight planning/decision, which subsequently resulted in fuel exhaustion and loss of engine power. Related factors were: excessive fuel consumption rate, and obstructions (trees and house) in the emergency landing area.
- [NTSB MIA97LA122](https://openairdocs.org/ntsb/MIA97LA122.md): Kunc KR-1 · Deland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N7KR · Substantial damage
  > the pilot's improper planning/decision, by failing to ensure there was sufficient fuel to safety complete the flight, which resulted in fuel exhaustion, loss of engine power, a forced landing, and subsequent collision with tree(s).
- [NTSB NYC97LA068](https://openairdocs.org/ntsb/NYC97LA068.md): Cessna 650 · Buffalo, NY · Accident · No injuries · Limited investigation · Final report · Apr 4, 1997 · N553AC · Substantial damage
  > A combination hydraulic fluid and fuel-fed fire which originated from electrical arcing, due to the lack of an adequate production standard from Cessna for the separation of flammable fluid lines and electrical lines. A factor was the lack of oversight from…
- [NTSB LAX97LA141](https://openairdocs.org/ntsb/LAX97LA141.md): Cessna 172N · Avalon, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 1997 · N733CN · Destroyed
  > The pilot's misjudging the airplane's altitude and distance to the runway and an excessive descent rate, which led to an undershoot, and the pilot's failure to maintain an adequate airspeed during the approach. Contributing factors were the pilot's delay in…
- [NTSB SEA97LA082](https://openairdocs.org/ntsb/SEA97LA082.md): Cessna 172L · Manzanita, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 3, 1997 · CGICR · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions, and his failure to maintain directional control of the airplane during the go-around attempt. Factors contributing to the accident are gusty crosswinds.
- [NTSB FTW97LA149](https://openairdocs.org/ntsb/FTW97LA149.md): Beech D35 · Bartlesville, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1997 · N940MD · Substantial damage
  > the pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.
- [NTSB ANC97LA047](https://openairdocs.org/ntsb/ANC97LA047.md): Cessna 207 · Teller, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1997 · N6299H · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and failure to maintain directional control during the landing. Factors related to the accident were: a crosswind, a downdraft, the pilot's delayed go-around, improper raising of the flaps, and…
- [NTSB ANC97LA044](https://openairdocs.org/ntsb/ANC97LA044.md): Cessna 175 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Apr 1, 1997 · N9261B · Substantial damage
  > The pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…
- [NTSB MIA97LA104](https://openairdocs.org/ntsb/MIA97LA104.md): Piper PA-28-181 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1997 · N109LD · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB FTW97IA144](https://openairdocs.org/ntsb/FTW97IA144.md): Boeing 767-232 · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Mar 27, 1997 · N105DA · Minor damage
  > The manufacturer's improper installation of the flap, which resulted in fatigue cracking of the flap attach bolts and separation of the flap.
- [NTSB ANC97LA041](https://openairdocs.org/ntsb/ANC97LA041.md): Piper PA-31-350 · Nome, AK · Accident · No injuries · Limited investigation · Final report · Mar 27, 1997 · N4105D · Substantial damage
  > a fuel leak from an engine driven fuel pump which initiated an engine fire, and the fuel pump manufacturer's inadequate quality control of the fuel pump.
- [NTSB NYC97LA063](https://openairdocs.org/ntsb/NYC97LA063.md): Piper PA-32-260 · Lincoln Park, NJ · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1997 · N3604W · Destroyed
  > The pilot's failure to maintain adequate obstacle clearance due to his diverted attention in attempting to re-illuminate the runway lights, which resulted in an inflight collision with a tree.
- [NTSB ATL97LA052](https://openairdocs.org/ntsb/ATL97LA052.md): Burkhart Grob G-103-TWIN II · Lancaster, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1997 · N54553 · Substantial damage
  > the pilot's improper use of the spoilers, while approaching to land, which allowed the glider to get low on final approach and strike trees. The pilot's lack of recent flying experience and lack of experience in the make and model of glider were related…
- [NTSB LAX97LA120](https://openairdocs.org/ntsb/LAX97LA120.md): McDonnell Douglas MD 369HS · Pacific Ocean (Pacific Ocean) · Accident · No injuries · Limited investigation · Final report · Mar 11, 1997 · N95MS · Destroyed
  > A loss of engine power due to a deteriorated compressor air seal, which resulted from inadequate maintenance inspection of the helicopter to detect corrosion in the compressor case while being operated in a marine environment.
- [NTSB IAD97LA053](https://openairdocs.org/ntsb/IAD97LA053.md): Cessna 175 · Weirs Cave, VA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1997 · N9485B · Substantial damage
  > the pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.
- [NTSB IAD97LA062](https://openairdocs.org/ntsb/IAD97LA062.md): Schweizer SGS-233A · Woodbine, MD · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1997 · N2559H · Substantial damage
  > The pilot misjudged his altitude during approach.
- [NTSB SEA97FA067](https://openairdocs.org/ntsb/SEA97FA067.md): Beech 200 · Salt Lake City, UT · Accident · 1 fatal · Field investigation · Final report · Mar 3, 1997 · N117WM · Substantial damage
  > The pilot's failure to maintain adequate airspeed on the ILS approach, resulting in a stall. Factors included: low visibility; the pilot's selection of the improper DME for the approach; his resulting failure to attain the proper descent profile for the…
- [NTSB LAX97LA110](https://openairdocs.org/ntsb/LAX97LA110.md): Bell 206B · Mountain Spring, NV · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 1997 · N42SS · Destroyed
  > the pilot's poor weather evaluation and the decision to continue to attempt to land during forecast adverse weather conditions.
- [NTSB FTW97LA108](https://openairdocs.org/ntsb/FTW97LA108.md): Cessna R172K · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Feb 24, 1997 · N98DE · Substantial damage
  > the pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ANC97LA078](https://openairdocs.org/ntsb/ANC97LA078.md): Cessna 185F · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Feb 23, 1997 · N4471R · Substantial damage
  > the pilot allowed an excessive rate of descent to develope during an approach to land, and delayed in initiating a go-around.
- [NTSB ANC97LA027](https://openairdocs.org/ntsb/ANC97LA027.md): Cessna 207 · Chevak, AK · Accident · No injuries · Limited investigation · Final report · Feb 22, 1997 · N7389U · Substantial damage
  > the pilot's continued VFR flight into instrument meteorological conditions, his misjudgment of distance and altitude during the approach to land, and his failure to attain a proper touchdown point during the landing. A factor relating to the accident was: the…
- [NTSB SEA97LA064](https://openairdocs.org/ntsb/SEA97LA064.md): Cessna 150J · Price, UT · Accident · No injuries · Limited investigation · Final report · Feb 15, 1997 · N5514G · Substantial damage
  > The flight instructor's failure to ensure that the dual student maintained adequate airspeed.
- [NTSB NYC97LA054](https://openairdocs.org/ntsb/NYC97LA054.md): Cessna 208B · Covington, KY · Accident · No injuries · Limited investigation · Final report · Feb 14, 1997 · N922FE · Substantial damage
  > The pilot's failure to maintain the airplane on the ILS glide slope, which resulted in a descent below the glide path, and the inadvertent in-flight collision with a utility pole. Contributing factors were sleet/snow, dark night conditions, and the pole.
- [NTSB FTW97LA102](https://openairdocs.org/ntsb/FTW97LA102.md): Cessna 210-5 · Hobbs, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1997 · N1866Z · Substantial damage
  > The loss of engine power due to fuel starvation for undetermined reasons. A factor was the pilot's continued flight after a fuel consumption anomaly was encountered.
- [NTSB ATL97LA040](https://openairdocs.org/ntsb/ATL97LA040.md): Cessna 150F · Winter Haven, FL · Accident · No injuries · Limited investigation · Final report · Feb 9, 1997 · N6679F · Substantial damage
  > the student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.
- [NTSB LAX97LA097](https://openairdocs.org/ntsb/LAX97LA097.md): Cessna 310Q · Los Angeles, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1997 · N10ML · Substantial damage
  > Fuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.
- [NTSB SEA97LA058](https://openairdocs.org/ntsb/SEA97LA058.md): Cessna 421C · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · Feb 6, 1997 · N45MV · Substantial damage
  > water contamination in the hydraulic system, which froze in the (right) main gear hydraulic actuator, and restricted movement of the (right) main gear retraction and extension system.
- [NTSB IAD97LA046](https://openairdocs.org/ntsb/IAD97LA046.md): Cessna 172P · Chesapeake, OH · Accident · No injuries · Limited investigation · Final report · Feb 4, 1997 · N62332 · Substantial damage
  > the pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.
- [NTSB NYC97LA050](https://openairdocs.org/ntsb/NYC97LA050.md): Berry Vans RV-4 · York, PA · Accident · No injuries · Limited investigation · Final report · Feb 2, 1997 · N42BN · Substantial damage
  > the pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.
- [NTSB LAX97LA096](https://openairdocs.org/ntsb/LAX97LA096.md): Beech N35 · Payson, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 2, 1997 · N61DE · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB MIA97LA077](https://openairdocs.org/ntsb/MIA97LA077.md): Beech 95-B55 · Monroe, NC · Accident · 1 fatal · Limited investigation · Final report · Feb 1, 1997 · N70F · Substantial damage
  > pilot incapacitation as result of Ischemic heart disease.
- [NTSB CHI97LA062](https://openairdocs.org/ntsb/CHI97LA062.md): Cessna 172N · Fort Wayne, IN · Accident · No injuries · Limited investigation · Final report · Feb 1, 1997 · N4696G · Substantial damage
  > the pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.
- [NTSB LAX97LA098](https://openairdocs.org/ntsb/LAX97LA098.md): Bellanca 17-30A · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 1997 · N6638V · Substantial damage
  > fuel exhaustion due to the pilot's improper fuel management.
- [NTSB NYC97LA049](https://openairdocs.org/ntsb/NYC97LA049.md): Cessna 152 · North Andover, MA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1997 · N67898 · Destroyed
  > Fuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.
- [NTSB FTW97LA090](https://openairdocs.org/ntsb/FTW97LA090.md): Piper PA-28-151 · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Jan 27, 1997 · N8478F · Substantial damage
  > the pilot's failure to refuel the airplane which led to fuel exhaustion and subsequent loss of engine power. Factors were the pilot's lack of preflight planning and the lack of suitable terrain for the forced landing.
- [NTSB FTW97LA089](https://openairdocs.org/ntsb/FTW97LA089.md): Piper PA-38-112 · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Jan 26, 1997 · N2422N · Substantial damage
  > The pilot's delayed go-around and subsequent inadvertent stall. A factor was the gusty winds.
- [NTSB MIA97LA074](https://openairdocs.org/ntsb/MIA97LA074.md): Schweizer SGS-2-33A · Clermont, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1997 · N233HH · Substantial damage
  > the pilot's improper planning/decision by electing to be towed aloft with a cold front nearby, which resulted in an in-flight encounter with wind gusts from the nearby cold front and subsequent in-flight collision with trees.
- [NTSB FTW97LA091](https://openairdocs.org/ntsb/FTW97LA091.md): Cessna 182A · Midland, TX · Accident · No injuries · Limited investigation · Final report · Jan 25, 1997 · N4723D · Substantial damage
  > The pilot's failure to periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the lack of suitable terrain for the forced landing.
- [NTSB SEA97IA051](https://openairdocs.org/ntsb/SEA97IA051.md): Beech 1900D · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jan 21, 1997 · N75ZV · Minor damage
  > an axial shift of the aft flap track bearing's outer roller, resulting in erosion and failure of the flap track bracket/bearing assembly. A factor relating to the incident was: inadequate inspection of the flap roller bearing/bracket assemblies.
- [NTSB CHI97FA058](https://openairdocs.org/ntsb/CHI97FA058.md): Mooney M20J · Cottage Grove, MN · Accident · 2 fatal · Field investigation · Final report · Jan 21, 1997 · N1160G · Destroyed
  > failure of the pilot to maintain control of the airplane during an ILS approach. Factors relating to the accident were: the IFR weather conditions, the pilot's lack of recent instrument experience, and the pilot's lack of familiarity in flying the accident…
- [NTSB NYC97LA044](https://openairdocs.org/ntsb/NYC97LA044.md): Mooney 20F · Jaffrey, NH · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1997 · N7112V · Destroyed
  > The pilot's failure to maintain aircraft control during a go around attempt, which resulted in a loss of control and collision with trees.
- [NTSB ANC97LA023](https://openairdocs.org/ntsb/ANC97LA023.md): Maule M-5 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Jan 18, 1997 · N5654N · Substantial damage
  > The pilot's failure to attain the proper touchdown point during landing. The snow-covered runway was a factor.
- [NTSB CHI97LA055](https://openairdocs.org/ntsb/CHI97LA055.md): Beech D95A · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jan 17, 1997 · N44BP · Substantial damage
  > the pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.
- [NTSB MIA97LA064](https://openairdocs.org/ntsb/MIA97LA064.md): Cessna 152 · Boca Raton, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 1997 · N69219 · Substantial damage
  > Inadequate inspection of the fuel caps by company maintenance personnel resulting in a cap with a deteriorated seal being allowed to continue in service. This allowed water to leak into the fuel tank which resulted in loss of engine power due to water…
- [NTSB MIA97LA061](https://openairdocs.org/ntsb/MIA97LA061.md): Beech C23 · Lincolnton, NC · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 1997 · N2236L · Substantial damage
  > The student pilot's improper use of flaps and failure to maintain airspeed during a go-around.
- [NTSB ANC97LA019](https://openairdocs.org/ntsb/ANC97LA019.md): Piper PA-34 · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Jan 13, 1997 · N2491U · Substantial damage
  > the pilot's failure to maintain sufficient altitude or clearance from terrain during a go-around. A factor related to the accident was: the dark, night condition.
- [NTSB DCA97MA017](https://openairdocs.org/ntsb/DCA97MA017.md): Embraer EMB-120RT · Monroe, MI · Accident · 29 fatal · Class 1 · Major · Final report · Jan 9, 1997 · N265CA · Destroyed
  > The Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…
- [NTSB MIA97FA057](https://openairdocs.org/ntsb/MIA97FA057.md): Cessna 208B · Edenton, NC · Accident · 2 fatal · Field investigation · Final report · Jan 2, 1997 · N802TH · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions. Factors in this accident were: fog, the low ceiling, and the dark night.

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

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

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