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

## Cases, newest first

- [NTSB CEN10IA157](https://openairdocs.org/ntsb/CEN10IA157.md): Embraer EMB-145LR · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 13, 2010 · N16561 · Minor damage
  > An in-flight encounter with lightning. Contributing to the incident was the damaged and displaced tailcone bulkhead frame that inhibited the full travel of the elevator during approach.
- [NTSB ERA10LA162](https://openairdocs.org/ntsb/ERA10LA162.md): Piper PA-34-200T · Vero Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 2010 · N103GK · Substantial damage
  > The certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.
- [NTSB ERA10FA154](https://openairdocs.org/ntsb/ERA10FA154.md): Beech P35 · Edgewater, MD · Accident · 1 fatal · Field investigation · Final report · Feb 27, 2010 · N1521S · Substantial damage
  > The pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.
- [NTSB CEN10CA154](https://openairdocs.org/ntsb/CEN10CA154.md): Grumman American AA-5 · Maple Lake, MN · Accident · No injuries · Data collection · Final report · Feb 27, 2010 · N5418L · Substantial damage
  > The pilot's failure to maintain a proper glide path during a simulated forced landing and the flight instructor's delayed remedial action to execute a go-around.
- [NTSB CEN10RA133](https://openairdocs.org/ntsb/CEN10RA133.md): Cessna 206 · San Pedro, Belize · Accident · 5 fatal · Foreign investigation · Feb 26, 2010 · V3-HDR · Substantial damage
- [NTSB WPR10CA146](https://openairdocs.org/ntsb/WPR10CA146.md): Diamond Aircraft Ind DA 20-C1 · Delta, UT · Accident · No injuries · Data collection · Final report · Feb 23, 2010 · N894CT · Substantial damage
  > The student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…
- [NTSB ERA10FA148](https://openairdocs.org/ntsb/ERA10FA148.md): Piper PA-28-180 · Springfield, KY · Accident · 1 fatal · Field investigation · Final report · Feb 23, 2010 · N7778W · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…
- [NTSB CEN10FA125](https://openairdocs.org/ntsb/CEN10FA125.md): Piper PA 46-350P · Belleville, IL · Accident · 2 fatal · Field investigation · Final report · Feb 22, 2010 · N350WF · Destroyed
  > The pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.
- [NTSB WPR10LA141](https://openairdocs.org/ntsb/WPR10LA141.md): Cessna 208B · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 2010 · N892FE · Substantial damage
  > An in-flight collision with a bird while on final approach.
- [NTSB CEN10LA136](https://openairdocs.org/ntsb/CEN10LA136.md): Maule M-5-235C · La Porte, TX · Accident · No injuries · Limited investigation · Final report · Feb 14, 2010 · N56347 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB WPR10LA134](https://openairdocs.org/ntsb/WPR10LA134.md): Boeing 737-7H4 · Santa Clarita, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 13, 2010 · N221WN · No damage
  > The pilot’s abrupt airplane pitch change maneuver. Contributing to the accident was the flight crew’s failure to maintain the heading specified by the air traffic controller, which would have avoided the near collision course with an unidentified airplane…
- [NTSB CEN10CA120](https://openairdocs.org/ntsb/CEN10CA120.md): Aviat A1 · Austin, TX · Accident · No injuries · Data collection · Final report · Feb 13, 2010 · N741MA · Substantial damage
  > The pilot's failure to maintain directional control during landing and his failure to properly execute a go-around.
- [NTSB CEN10FA119](https://openairdocs.org/ntsb/CEN10FA119.md): Piper PA-31T · Forest City, IA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 2010 · N250TT · Substantial damage
  > The pilot's failure to maintain airplane control during final approach.
- [NTSB CEN10FA114](https://openairdocs.org/ntsb/CEN10FA114.md): Beech A36 · Winslow, AR · Accident · 4 fatal · Field investigation · Final report · Feb 6, 2010 · N1085D · Substantial damage
  > The instrument-rated pilot's spatial disorientation and subsequent loss of airplane control during flight in instrument meteorological and conditions favorable for structural icing.
- [NTSB CEN10FA113](https://openairdocs.org/ntsb/CEN10FA113.md): Aerospatiale AS350 · El Paso, TX · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2010 · N157BC · Substantial damage
  > The pilot's loss of situational awareness resulting in controlled flight into terrain. Contributing to the accident was the pilot's unfamiliarity with the hazards of a low-contrast area while using night vision goggles.
- [NTSB WPR10LA127](https://openairdocs.org/ntsb/WPR10LA127.md): Hiller UH-12E · Los Banos, CA · Accident · No injuries · Limited investigation · Final report · Feb 2, 2010 · N36MV · Substantial damage
  > A partial loss of engine power due to a failure of the throttle interconnect hardware, which resulted in a hard landing.
- [NTSB ERA10LA128](https://openairdocs.org/ntsb/ERA10LA128.md): Cessna 402C · Watertown, NY · Accident · No injuries · Limited investigation · Final report · Feb 1, 2010 · N121PB · Substantial damage
  > The pilot's decision to continue the approach with a known anomaly with the left airspeed indicator. Contributing to the accident was an undetermined malfunction of the left airspeed indicator and the condition of the runway, resulting in decreased braking…
- [NTSB ANC10CA016](https://openairdocs.org/ntsb/ANC10CA016.md): Piper PA-17 · Skwentna, AK · Accident · Minor injuries · Data collection · Final report · Jan 31, 2010 · N4568H · Substantial damage
  > The pilot's decision to make a low-altitude approach to land over trees in gusting winds, which resulted in an in-flight collision with a tree and a loss of control.
- [NTSB ERA10CA117](https://openairdocs.org/ntsb/ERA10CA117.md): Luscombe 8 · Springfield, TN · Accident · Serious injuries · Data collection · Final report · Jan 18, 2010 · N2111K · Substantial damage
  > The student pilot's failure to maintain control of the airplane during a go-around after a bounced landing.
- [NTSB CEN10FA097](https://openairdocs.org/ntsb/CEN10FA097.md): Mitsubishi MU-2B-60 · Elyria, OH · Accident · 4 fatal · Field investigation · Final report · Jan 18, 2010 · N80HH · Destroyed
  > The pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN10CA100](https://openairdocs.org/ntsb/CEN10CA100.md): Cessna P172D · Cedar Rapids, IA · Accident · Minor injuries · Data collection · Final report · Jan 18, 2010 · N8584X · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions and his failure to maintain a proper glidepath during the approach. Contributing to the accident was the pilot's lack of instrument proficiency.
- [NTSB CEN10LA103](https://openairdocs.org/ntsb/CEN10LA103.md): Cessna 177RG · Cedar Rapids, IA · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2010 · N53120 · Substantial damage
  > The pilot's failure to maintain aircraft control while flying an instrument approach. Contributing to the accident was the pilot's lack of experience in actual instrument conditions.
- [NTSB ERA10LA119](https://openairdocs.org/ntsb/ERA10LA119.md): Quad City Challenger · Palmetto, FL · Accident · 1 fatal · Limited investigation · Final report · Jan 14, 2010 · UNREG · Substantial damage
  > The non-certificated pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with the ground. Contributing to the accident was his impairment due to the prescription narcotic medication he was taking.
- [NTSB ERA10LA113](https://openairdocs.org/ntsb/ERA10LA113.md): Foster John Glasair III · Oxford, CT · Accident · 1 fatal · Limited investigation · Final report · Jan 13, 2010 · N540WF · Substantial damage
  > The pilot's failure to maintain a proper approach path during visual conditions at dusk, which resulted in an in-flight collision with power lines.
- [NTSB WPR10FA107](https://openairdocs.org/ntsb/WPR10FA107.md): Piper PA-32-300 · Honolulu, HI · Accident · 2 fatal · Field investigation · Final report · Jan 10, 2010 · N8934N · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance. Contributing to the accident was the air traffic controller's failure to issue a safety alert after observing the…
- [NTSB CEN10MA088](https://openairdocs.org/ntsb/CEN10MA088.md): Gates Learjet 35A · Prospect Heights, IL · Accident · 2 fatal · Major investigation · Final report · Jan 5, 2010 · N720RA · Substantial damage
  > A loss of control for undetermined reasons.
- [NTSB ERA10WA106](https://openairdocs.org/ntsb/ERA10WA106.md): Hughes 369 · Pitalito, Colombia · Accident · 1 fatal · Foreign investigation · Dec 29, 2009 · HK4177 · Substantial damage
  > On December 29, 2009, about 1655 universal coordinated time (1155 local time), a Hughes 369D, Colombian registration HK4177, operated by Sociedad Aerea de Ibague, was substantially damaged during a forced landing in Pitalito, Huila, Colombia. The Colombian…
- [NTSB WPR10LA087](https://openairdocs.org/ntsb/WPR10LA087.md): Cessna 172F · Corona, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 2009 · N8520U · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB WPR10LA082](https://openairdocs.org/ntsb/WPR10LA082.md): EADS Socata TBM 700 · Truckee, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 2009 · N850MT · Substantial damage
  > The pilot’s failure to maintain an adequate airspeed and clearance from terrain during an attempted go-around. Contributing to the accident was the pilot's decision to land on a partially obscured runway.
- [NTSB CEN10FA071](https://openairdocs.org/ntsb/CEN10FA071.md): Cessna 310R · Alva, OK · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2009 · N310CR · Substantial damage
  > The pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was the…
- [NTSB ERA10WA096](https://openairdocs.org/ntsb/ERA10WA096.md): Huber Hartmut Express · Berry Island, Bahamas · Accident · 1 fatal · Foreign investigation · Dec 12, 2009 · N93HE · Substantial damage
  > On December 12, 2009, at 1300 UTC, an experimental, amateur-built Harmut Huber Express, N93HE, operated by a private individual, crashed into the water on short final approach to Chub Cay Airport (MYBC), Berry Island, Bahamas. The pilot was killed and the…
- [NTSB CEN10FA070](https://openairdocs.org/ntsb/CEN10FA070.md): Piper PA-30 · Port Mansfield, TX · Accident · 2 fatal · Field investigation · Final report · Dec 11, 2009 · N7781Y · Destroyed
  > The pilot’s failure to maintain clearance with the water while on approach (VFR) to land.
- [NTSB CEN10CA075](https://openairdocs.org/ntsb/CEN10CA075.md): Cessna 172 · Pearland, TX · Accident · No injuries · Data collection · Final report · Dec 11, 2009 · N172BJ · Substantial damage
  > The student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.
- [NTSB ERA10IA095](https://openairdocs.org/ntsb/ERA10IA095.md): Beech 58 · Lexington, KY · Incident · No injuries · Incident investigation · Final report · Dec 10, 2009 · N391MC · Minor damage
  > The overstress failure of the nose landing gear aft drag brace.
- [NTSB CEN10WA073](https://openairdocs.org/ntsb/CEN10WA073.md): Cirrus SR20 · Oberbarnim, Germany · Accident · 1 fatal · Class 5 · Foreign · Dec 10, 2009 · D-EYAT · Destroyed
  > On December 10, 2009, at 1625 coordinated universal time, a Cirrus SR20, German registered D-EYAT, was destroyed when it impacted forested terrain near Oberbarnim, Germany. Instrument meteorological conditions prevailed at the time of the accident. The pilot…
- [NTSB CEN10FA069](https://openairdocs.org/ntsb/CEN10FA069.md): Beech A36 · Eagle Pass, TX · Accident · 1 fatal · Field investigation · Final report · Dec 9, 2009 · N1105N · Destroyed
  > The pilot's decision to continue the approach below minimums without visual references, and subsequent collision with the perimeter fence/terrain.
- [NTSB CEN10FA065](https://openairdocs.org/ntsb/CEN10FA065.md): New Piper PA-46-500TP · Mendoza, TX · Accident · 2 fatal · Field investigation · Final report · Dec 7, 2009 · N600YE · Substantial damage
  > ***This report was modified on May 22, 2014. Please see the docket for this accident to view the original report.*** The pilot's spatial disorientation, which resulted in his loss of airplane control. Contributing to the pilot's spatial disorientation was the…
- [NTSB ERA10LA082](https://openairdocs.org/ntsb/ERA10LA082.md): Piper PA-32RT-300 · Memphis, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 29, 2009 · N9243C · Substantial damage
  > The pilot's failure to execute a timely missed approach and subsequent failure to maintain aircraft control, after he was unable to establish the airplane on the instrument approach. Contributing to the accident was the pilot's possible impairment due to his…
- [NTSB WPR10FA068](https://openairdocs.org/ntsb/WPR10FA068.md): Schleicher ASW-27 · Middletown, CA · Accident · 2 fatal · Field investigation · Final report · Nov 28, 2009 · N127AL · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.
- [NTSB WPR10CA066](https://openairdocs.org/ntsb/WPR10CA066.md): Nephew Alan H Kitfox · Agua Caliente Springs, CA · Accident · Minor injuries · Data collection · Final report · Nov 27, 2009 · N7824L · Substantial damage
  > The pilot's failure to maintain an adequate glide path that ensured obstacle clearance during final approach to land.
- [NTSB ERA10CA071](https://openairdocs.org/ntsb/ERA10CA071.md): Cirrus SR-22 · Everglades City, FL · Accident · No injuries · Data collection · Final report · Nov 21, 2009 · N609SR · Substantial damage
  > The pilot's failure to maintain directional control during the attempted go-around.
- [NTSB ERA10CA087](https://openairdocs.org/ntsb/ERA10CA087.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Ashland, VA · Accident · Minor injuries · Data collection · Final report · Nov 20, 2009 · N319UA · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees during the landing approach.
- [NTSB CEN10LA054](https://openairdocs.org/ntsb/CEN10LA054.md): Piper PA-28-181 · Mineola, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2009 · N3148Q · Substantial damage
  > A loss of engine power due to fuel exhaustion and the pilot's inadequate preflight planning.
- [NTSB WPR10LA053](https://openairdocs.org/ntsb/WPR10LA053.md): Beech 35-B33 · Chico, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2009 · N9617Y · Substantial damage
  > A loss of engine power during final approach for undetermined reasons.
- [NTSB ERA10LA056](https://openairdocs.org/ntsb/ERA10LA056.md): Hawker Beechcraft B200 · Greer, SC · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 2009 · N337MT · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot’s failure to visually verify that sufficient fuel was onboard prior to flight.
- [NTSB DCA10RA031](https://openairdocs.org/ntsb/DCA10RA031.md): Beech 1900 - D · Nairobi, Kenya · Accident · No injuries · Foreign investigation · Nov 9, 2009 · 5Y-VVQ · Destroyed
  > On November 9, 2009 about 0517 UTC, Kenyan registry 5Y-VVQ, a Beech 1900D, a chartered cargo flight, had a loss of control and collided with the ground during a visual approach for landing at Wilson Airport, Nairobi, Kenya. The airplane had turned back to…
- [NTSB ERA10LA059](https://openairdocs.org/ntsb/ERA10LA059.md): Cessna A188B · Ripley, MS · Accident · No injuries · Limited investigation · Final report · Nov 8, 2009 · N9368G · Substantial damage
  > The pilot’s failure to maintain adequate airspeed on final approach, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to water in the fuel.
- [NTSB CEN10LA049](https://openairdocs.org/ntsb/CEN10LA049.md): Lockwood AIR-CAM · Mount Victory, OH · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2009 · N32786 · Substantial damage
  > The pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.
- [NTSB CEN10IA173](https://openairdocs.org/ntsb/CEN10IA173.md): Univar 415-C/D · Xenia, OH · Incident · No injuries · Incident investigation · Final report · Nov 6, 2009 · N93415 · Minor damage
  > The pilot's failure to maintain the proper glide slope during final approach, which resulted in an in-flight collision with a tree.
- [NTSB WPR10LA046](https://openairdocs.org/ntsb/WPR10LA046.md): Eurocopter AS350BA · Globe, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2009 · N617LH · Substantial damage
  > The pilot receiving instruction’s failure to maintain adequate airspeed or control of the helicopter during a simulated hydraulic failure maneuver, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial…

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

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

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