# NTSB investigations: Landing

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 97 of 1,075 · 53,702 cases

## Cases, newest first

- [NTSB GAA16CA445](https://openairdocs.org/ntsb/GAA16CA445.md): Cessna T207 · Nanwalek, AK · Accident · No injuries · Data collection · Final report · Aug 23, 2016 · N91025 · Substantial damage
  > The pilot’s unstabilized approach and a subsequent runway overrun while landing on a short runway in variable wind conditions.
- [NTSB GAA16CA448](https://openairdocs.org/ntsb/GAA16CA448.md): Cessna 152 · Miami, FL · Accident · No injuries · Data collection · Final report · Aug 21, 2016 · N94939 · Substantial damage
  > The pilot's improper pitch control during landing, which resulted in a bounced landing, and a nose landing gear collapse.
- [NTSB GAA16CA446](https://openairdocs.org/ntsb/GAA16CA446.md): Cessna A185 · Caldwell, ID · Accident · No injuries · Data collection · Final report · Aug 21, 2016 · N4477R · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.
- [NTSB GAA16CA444](https://openairdocs.org/ntsb/GAA16CA444.md): P Z L -Warszawa-Cnpsl PZL 104 Wilga · Austin, NV · Accident · Minor injuries · Data collection · Final report · Aug 21, 2016 · N65ZA · Substantial damage
  > The pilot's failure to maintain an appropriate descent rate during the base to final turn, which resulted in a forced landing, and an intentional aerodynamic stall. Contributing to the accident was the pilot's excessive braking, which resulted in a nose over…
- [NTSB GAA16CA438](https://openairdocs.org/ntsb/GAA16CA438.md): Cessna A185 · Fayetteville, TN · Accident · No injuries · Data collection · Final report · Aug 21, 2016 · N185DK · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and a ground loop.
- [NTSB ERA16LA296](https://openairdocs.org/ntsb/ERA16LA296.md): Mantell Allan T Kitfox 4 1200 · Canandaigua, NY · Accident · No injuries · Limited investigation · Final report · Aug 20, 2016 · N51TM · Substantial damage
  > The failure of the right rudder pedal torque tube due to fatigue, which resulted in a loss of directional control during landing. Also causal to the accident was the airplane owner/builder's failure to install a rudder torque tube reinforcement or replacement…
- [NTSB GAA16CA443](https://openairdocs.org/ntsb/GAA16CA443.md): Cessna A185 · Klamath Falls, OR · Accident · No injuries · Data collection · Final report · Aug 19, 2016 · N185SC · Substantial damage
  > The pilot's improper landing flare, which resulted in the airplane porpoising and the subsequent loss of directional control.
- [NTSB GAA16CA440](https://openairdocs.org/ntsb/GAA16CA440.md): Piper PA 18-150 · Palmer, AK · Accident · No injuries · Data collection · Final report · Aug 19, 2016 · N5408Y · Substantial damage
  > The pilot's excessive brake application during the landing roll resulting in a nose over.
- [NTSB GAA16CA439](https://openairdocs.org/ntsb/GAA16CA439.md): Bell 206 L4 · Broussard, LA · Accident · No injuries · Data collection · Final report · Aug 18, 2016 · N7898X · Substantial damage
  > The pilot's failure to attain a proper touchdown point, which resulted in the helicopter sliding off the aft end of the transport dolly.
- [NTSB GAA16CA455](https://openairdocs.org/ntsb/GAA16CA455.md): Cessna U206 · Sleetmute, AK · Accident · No injuries · Data collection · Final report · Aug 17, 2016 · N8076Z · Substantial damage
  > The pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall and a hard landing.
- [NTSB GAA16CA441](https://openairdocs.org/ntsb/GAA16CA441.md): Valloric Carl Stephen Valloric Sport Trnr · Cadiz, OH · Accident · No injuries · Data collection · Final report · Aug 17, 2016 · N772CV · Substantial damage
  > The pilot's failure to maintain directional control during landing and the unintentional right brake application, which resulted in a runway excursion and a nose over.
- [NTSB GAA16CA434](https://openairdocs.org/ntsb/GAA16CA434.md): Cessna 182 · Anchorage, AK · Accident · No injuries · Data collection · Final report · Aug 17, 2016 · N2704Q · Substantial damage
  > The pilot's failure to maintain a controlled landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's inattention and distraction.
- [NTSB ERA16CA294](https://openairdocs.org/ntsb/ERA16CA294.md): Cessna 152 · Newnan, GA · Accident · No injuries · Data collection · Final report · Aug 17, 2016 · N5250B · Substantial damage
  > The student pilot's improper decision to land long and maintain excessive speed during the landing roll. Contributing to the accident was the student pilot's decision to maintain full flaps and aft yoke inputs at a higher speed, reducing his ability to stop…
- [NTSB GAA16CA436](https://openairdocs.org/ntsb/GAA16CA436.md): Piper PA18 · Anchor Point, AK · Accident · No injuries · Data collection · Final report · Aug 16, 2016 · N8097N · Substantial damage
  > The pilot's failure to maintain clearance from obstacles while landing on a coastal beach.
- [NTSB DCA16WA240](https://openairdocs.org/ntsb/DCA16WA240.md): Cessna 401 · Antalaha, Madagascar · Accident · No injuries · Foreign investigation · Aug 16, 2016 · 5R-MEK · Substantial damage
- [NTSB GAA16CA473](https://openairdocs.org/ntsb/GAA16CA473.md): Cessna 172 · Fulton, MO · Accident · No injuries · Data collection · Final report · Aug 14, 2016 · N78242 · Substantial damage
  > The pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.
- [NTSB ERA16WA292](https://openairdocs.org/ntsb/ERA16WA292.md): Eurocopter AS355 · Santo Domingo, Dominican Republic · Accident · Serious injuries · Foreign investigation · Aug 14, 2016 · HI-861 · Substantial damage
  > On August 14, 2016, about 2040 coordinated universal time, a Eurocopter AS355 F2, Dominican registration HI-861, was substantially damaged during a hard landing at the La Isabela International Airport (MDJB), Santo Domingo, Dominican Republic. The pilot was…
- [NTSB GAA16CA429](https://openairdocs.org/ntsb/GAA16CA429.md): Consolidated Vultee BT13 · Joseph, OR · Accident · No injuries · Data collection · Final report · Aug 13, 2016 · N53331 · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and damage to the left aileron and elevator.
- [NTSB ANC16LA059](https://openairdocs.org/ntsb/ANC16LA059.md): Wight Carbon CUB CCK-1865 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Aug 13, 2016 · N625EX · Substantial damage
  > The failure of the tailwheel suspension assembly during landing due to preexisting fatigue fractures in the suspension system, which resulted in a loss of directional control.
- [NTSB GAA16CA431](https://openairdocs.org/ntsb/GAA16CA431.md): Cessna 152 · Hillsboro, OR · Accident · No injuries · Data collection · Final report · Aug 12, 2016 · N48440 · Substantial damage
  > The student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.
- [NTSB ERA16CA290](https://openairdocs.org/ntsb/ERA16CA290.md): Kessinger Roger L Rans Coyote · London, KY · Accident · Serious injuries · Data collection · Final report · Aug 12, 2016 · N910RK · Substantial damage
  > The student pilot's improper recovery from a bounced landing and his subsequent failure to maintain clearance from trees during an attempted go-around.
- [NTSB GAA16CA433](https://openairdocs.org/ntsb/GAA16CA433.md): Maule MXT7 · Quitman, AR · Accident · No injuries · Data collection · Final report · Aug 11, 2016 · N1665B · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's limited forward visibility due to sun glare.
- [NTSB GAA16CA427](https://openairdocs.org/ntsb/GAA16CA427.md): Piper PA28 · Hamburg, NY · Accident · No injuries · Data collection · Final report · Aug 11, 2016 · N2259Q · Substantial damage
  > The pilot's failure to perform a go-around, which resulted in a landing area overshoot, a runway overrun, a landing gear collapse, and a collision with a guard rail.
- [NTSB GAA16CA425](https://openairdocs.org/ntsb/GAA16CA425.md): American Legend AL3 · San Diego, CA · Accident · No injuries · Data collection · Final report · Aug 10, 2016 · N35451 · Substantial damage
  > The pilot's failure to maintain directional control during landing with a crosswind.
- [NTSB CEN16LA322](https://openairdocs.org/ntsb/CEN16LA322.md): Piper J5C · Sandusky, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2016 · N30313 · Substantial damage
  > The pilot's improper landing flare, which resulted in a bounced landing, and a subsequent loss of control followed by a runway excursion.
- [NTSB CEN16LA316](https://openairdocs.org/ntsb/CEN16LA316.md): Schabacker Konrad J Acro Sport II · Winterset, IA · Accident · No injuries · Limited investigation · Final report · Aug 9, 2016 · N6214C · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in an on-ground collision with two parked airplanes.
- [NTSB CEN16CA319](https://openairdocs.org/ntsb/CEN16CA319.md): Cessna 172S · Arlington, TX · Accident · No injuries · Data collection · Final report · Aug 9, 2016 · N544SP · Substantial damage
  > The student pilot's improper recovery from a bounced landing.
- [NTSB CEN16CA317](https://openairdocs.org/ntsb/CEN16CA317.md): Ercoupe 415 · Eminence, IN · Accident · No injuries · Data collection · Final report · Aug 9, 2016 · N3884H · Substantial damage
  > The pilot's failure to maintain a proper glide path during the landing approach and his failure to use available engine power to arrest the descent, resulting in an undershoot and collision with terrain.
- [NTSB WPR16LA163](https://openairdocs.org/ntsb/WPR16LA163.md): Cessna TR182 · Torrance, CA · Accident · No injuries · Limited investigation · Final report · Aug 8, 2016 · N756FZ · Substantial damage
  > The failure of the right main landing gear to fully extend for reasons that could not be determined because postaccident examination and testing did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal…
- [NTSB GAA16CA420](https://openairdocs.org/ntsb/GAA16CA420.md): Cubcrafters CC11 · Hailey, ID · Accident · No injuries · Data collection · Final report · Aug 8, 2016 · N76CC · Substantial damage
  > The flight instructor's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground loop.
- [NTSB ERA16LA282](https://openairdocs.org/ntsb/ERA16LA282.md): Diamond DA20 · St. Croix · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2016 · N828BB · Destroyed
  > The flight instructor's improper recovery from a bounced landing, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.
- [NTSB GAA16CA471](https://openairdocs.org/ntsb/GAA16CA471.md): Piper PA24 · Hillsboro, OH · Accident · No injuries · Data collection · Final report · Aug 6, 2016 · N7292P · Substantial damage
  > The pilot's descent below the intended glidepath during the approach, which resulted in an impact with a ditch prior to the runway.
- [NTSB GAA16CA422](https://openairdocs.org/ntsb/GAA16CA422.md): Cessna 195 · Hillsborough, OR · Accident · No injuries · Data collection · Final report · Aug 6, 2016 · N4026A · Substantial damage
  > The pilot's failure to attain a proper touchdown point and loss of directional control and her subsequent excessive brake application, which resulted in a nose-over.
- [NTSB ERA16LA284](https://openairdocs.org/ntsb/ERA16LA284.md): Balloon Works FIREFLY8 · Northwood, NH · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 2016 · N317W · No damage
  > The balloon pilot’s inadequate weather planning and improper decision to depart in reported increasing variable winds with nearby thunderstorms, which resulted in a subsequent hard landing and a serious passenger injury.
- [NTSB CEN16LA311](https://openairdocs.org/ntsb/CEN16LA311.md): Cessna 180 · Cardington, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2016 · N2601Y · Destroyed
  > The partial loss of engine power due to carburetor icing during an attempted go-around.
- [NTSB GAA16CA424](https://openairdocs.org/ntsb/GAA16CA424.md): Stinson 108 · Sunriver, OR · Accident · No injuries · Data collection · Final report · Aug 5, 2016 · N9250K · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in runway excursion and nose-over.
- [NTSB DCA16WA219](https://openairdocs.org/ntsb/DCA16WA219.md): Robinson R66 · Drakensburg Mountain, South Africa · Accident · No injuries · Foreign investigation · Aug 5, 2016 · ZS-HBS · Destroyed
  > The government of South Africa has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on August 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…
- [NTSB DCA16WA210](https://openairdocs.org/ntsb/DCA16WA210.md): Boeing 737 · Bergamo, Italy · Accident · No injuries · Foreign investigation · Aug 5, 2016 · HA-FAX · Substantial damage
  > The Agenzia Nazionale per la sicurezza del volo (ANSV) of Italy has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the…
- [NTSB CEN16LA356](https://openairdocs.org/ntsb/CEN16LA356.md): Cessna P210N · Waco, TX · Accident · No injuries · Limited investigation · Final report · Aug 5, 2016 · N323DC · Substantial damage
  > The failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.
- [NTSB ANC16FA052](https://openairdocs.org/ntsb/ANC16FA052.md): Cessna 210-5 · Wasilla, AK · Accident · Minor injuries · Field investigation · Final report · Aug 5, 2016 · N1839Z · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other while landing at a non-tower-controlled airport, which resulted in a midair collision. Contributing to the accident was the absence of radio calls from the Cessna during the traffic pattern preceding the…
- [NTSB GAA16CA423](https://openairdocs.org/ntsb/GAA16CA423.md): Beech F33 · Bivalve, MD · Accident · No injuries · Data collection · Final report · Aug 4, 2016 · N90HF · Substantial damage
  > The pilot's excessive airspeed during landing, which resulted in a runway overrun, and impact with a ditch.
- [NTSB GAA16CA416](https://openairdocs.org/ntsb/GAA16CA416.md): Cessna 172 · Palm Springs, CA · Accident · No injuries · Data collection · Final report · Aug 3, 2016 · N5203H · Substantial damage
  > The student pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a nose over in rough terrain.
- [NTSB GAA16CA412](https://openairdocs.org/ntsb/GAA16CA412.md): Cessna 120 · Belen, NM · Accident · No injuries · Data collection · Final report · Aug 3, 2016 · N72580 · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a ground loop.
- [NTSB DCA16RA206](https://openairdocs.org/ntsb/DCA16RA206.md): Boeing 777 · Dubai, United Arab Emirates · Accident · 1 fatal · Foreign investigation · Aug 3, 2016 · A6-EMW · Destroyed
  > The United Arab Emirates General Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a BOEING 777 that occurred on August 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the…
- [NTSB ANC16CA050](https://openairdocs.org/ntsb/ANC16CA050.md): Holley Carol L Antares · North Pole, AK · Accident · No injuries · Data collection · Final report · Aug 3, 2016 · N8512Q · Substantial damage
  > The pilot's failure to maintain directional control of the weight-shift control airplane during the landing in a crosswind condition, which resulted in a runway excursion, a tip over of the wing, and a collision with terrain.
- [NTSB GAA16CA421](https://openairdocs.org/ntsb/GAA16CA421.md): Cessna 172 · Oak Island, NC · Accident · No injuries · Data collection · Final report · Aug 2, 2016 · N24447 · Substantial damage
  > The pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing and substantial damage to the firewall.
- [NTSB GAA16CA414](https://openairdocs.org/ntsb/GAA16CA414.md): Cessna 150 · New Albany, MS · Accident · No injuries · Data collection · Final report · Aug 2, 2016 · N50945 · Substantial damage
  > The pilot's failure to maintain an appropriate pitch attitude during landing, which resulted in an initial nose wheel contact, followed by a nose gear collapse, and the airplane came to rest in a nose down position.
- [NTSB DCA16WA216](https://openairdocs.org/ntsb/DCA16WA216.md): Boeing 737 · Mbuji Mayi, Congo - Kinshasa · Incident · No injuries · Foreign investigation · Aug 2, 2016 · 9Q-DBJ · Minor damage
  > The government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on August 02, 2016. The NTSB has appointed a U.S. Accredited Representative to DRC under the provisions of ICAO Annex 13 as…
- [NTSB GAA16CA407](https://openairdocs.org/ntsb/GAA16CA407.md): Cessna 152 · Scappoose, OR · Accident · No injuries · Data collection · Final report · Aug 1, 2016 · N49276 · Substantial damage
  > The student pilot's failure to maintain pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard landing/abnormal runway contact, a partial nose wheel collapse and substantial damage to the firewall.
- [NTSB GAA16CA401](https://openairdocs.org/ntsb/GAA16CA401.md): S C Aerostar S.A. Festival R40S · Frankfort, MI · Accident · Minor injuries · Data collection · Final report · Jul 30, 2016 · N291AF · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion, a nose gear collapse, and impact with terrain.

Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=98

## 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 = 550)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=97

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