# 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 102 of 1,075 · 53,703 cases

## Cases, newest first

- [NTSB GAA16CA251](https://openairdocs.org/ntsb/GAA16CA251.md): Cirrus SR22 · Church Hill, MD · Accident · No injuries · Data collection · Final report · Apr 21, 2016 · N27ML · Substantial damage
  > The pilot's decision to land on an unlighted grass airstrip at night, resulting in landing long, a loss of directional control, and collapsed landing gear producing substantial damage to the landing gear attachment point and left wing.
- [NTSB CEN16LA162](https://openairdocs.org/ntsb/CEN16LA162.md): Cessna 150J · Bixby, OK · Accident · No injuries · Limited investigation · Final report · Apr 21, 2016 · N51242 · Substantial damage
  > A total loss of engine power for reasons that could not be determined, as the fuel state of the airplane at the time of the accident could not be verified, and postaccident examination of the engine did not provide adequate information.
- [NTSB GAA16CA202](https://openairdocs.org/ntsb/GAA16CA202.md): Cessna 172 · Camarillo, CA · Accident · No injuries · Data collection · Final report · Apr 20, 2016 · N6616D · Substantial damage
  > The student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.
- [NTSB ENG16WA022](https://openairdocs.org/ntsb/ENG16WA022.md): Beech 1900 · Gander, Canada · Accident · Minor injuries · Foreign investigation · Apr 20, 2016 · C-FEVA
  > The Transportation Safety Board of Canada has notified the NTSB of an accident involving a Beechcraft 1900D, which occurred on April 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Transportation Safety Board of Canada…
- [NTSB GAA16CA204](https://openairdocs.org/ntsb/GAA16CA204.md): Piper PA 18 · Palmer, AK · Accident · No injuries · Data collection · Final report · Apr 19, 2016 · N2518A · Substantial damage
  > The pilot's decision to land on unsuitable terrain and incorrect brake application during the landing roll, which resulted in a nose over.
- [NTSB GAA16CA193](https://openairdocs.org/ntsb/GAA16CA193.md): Silvaire Luscombe 8A · Burlington, WA · Accident · No injuries · Data collection · Final report · Apr 19, 2016 · N28437 · Substantial damage
  > The pilot's excessive application of the brakes during the landing roll, resulting in a loss of directional control, runway excursion, and ground loop.
- [NTSB GAA16CA195](https://openairdocs.org/ntsb/GAA16CA195.md): Gary A Jamieson JA30 Superstol · Palmer, AK · Accident · Minor injuries · Data collection · Final report · Apr 18, 2016 · N826AK · Substantial damage
  > The pilot's failure to maintain pitch control of the airplane during the landing touchdown, which resulted in a nose over.
- [NTSB GAA16CA194](https://openairdocs.org/ntsb/GAA16CA194.md): Cessna 172 · Stillwater, OK · Accident · No injuries · Data collection · Final report · Apr 15, 2016 · N2663X · Substantial damage
  > The student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.
- [NTSB ERA16LA159](https://openairdocs.org/ntsb/ERA16LA159.md): Eurocopter France AS350 · Jasper, GA · Accident · No injuries · Limited investigation · Final report · Apr 15, 2016 · N561AM · Substantial damage
  > The pilot's loss of helicopter control due to vortex ring state, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to conduct the landing approach with a tailwind.
- [NTSB CEN16LA157](https://openairdocs.org/ntsb/CEN16LA157.md): Czech Sport Piper Sport · Mansfield, OH · Accident · No injuries · Limited investigation · Final report · Apr 14, 2016 · N197PS · Substantial damage
  > The pilot's failure to inspect the nose landing gear (NLG), which resulted in a crack going undetected and the subsequent separation of the NLG at the weld area during landing.
- [NTSB WPR16LA092](https://openairdocs.org/ntsb/WPR16LA092.md): Cessna 421C · Death Valley, CA · Accident · No injuries · Limited investigation · Final report · Apr 13, 2016 · N21SG · Substantial damage
  > A runway overrun for reasons that could not be determined based on the available information.
- [NTSB GAA16CA192](https://openairdocs.org/ntsb/GAA16CA192.md): Cessna E162 · Lee's Summit, MO · Accident · No injuries · Data collection · Final report · Apr 12, 2016 · N7027F · Substantial damage
  > The flight instructor's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and collision with a taxiway sign.
- [NTSB GAA16CA190](https://openairdocs.org/ntsb/GAA16CA190.md): Monocoupe 110 · Chandler, AZ · Accident · No injuries · Data collection · Final report · Apr 12, 2016 · N501W · Substantial damage
  > The pilot's incorrect installation of the tailwheel steering bungee, which resulted in a runway excursion and airplane nose over.
- [NTSB CEN16WA152](https://openairdocs.org/ntsb/CEN16WA152.md): Piper PA32R · Hampshire, United Kingdom · Accident · Minor injuries · Foreign investigation · Apr 12, 2016 · G-MAIE · Substantial damage
  > On April 12, 2016, at 1300 coordinated universal time, a Piper PA-32R-301T airplane, G-MAIE, experienced a hard landing at the Daedalus Airfield (EGHF), Hampshire, United Kingdom. The pilot was not seriously injured, and the airplane sustained damage to the…
- [NTSB GAA16CA217](https://openairdocs.org/ntsb/GAA16CA217.md): Cessna A185 · Chesterfield, MO · Accident · No injuries · Data collection · Final report · Apr 9, 2016 · N4095A · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and a wing strike.
- [NTSB GAA16CA184](https://openairdocs.org/ntsb/GAA16CA184.md): Dehavilland DHC 6 Twin Otter · Fentress, TX · Accident · No injuries · Data collection · Final report · Apr 9, 2016 · N122PM · Substantial damage
  > The pilot's failure to maintain directional control during the aborted landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with a tree.
- [NTSB GAA16CA189](https://openairdocs.org/ntsb/GAA16CA189.md): TL Ultralight Sro TL-3000 Sirius · South St. Paul, MN · Accident · No injuries · Data collection · Final report · Apr 8, 2016 · N726T · Substantial damage
  > The pilot's failure to maintain a proper landing flare in gusty wind conditions, which resulted in a hard landing and substantial damage to the firewall.
- [NTSB GAA16CA188](https://openairdocs.org/ntsb/GAA16CA188.md): Cessna 172 · Payson, AZ · Accident · No injuries · Data collection · Final report · Apr 6, 2016 · N5275S · Substantial damage
  > The student pilot's failure to maintain pitch control during the landing flare, resulting in the subsequent porpoise during landing and substantial damage to the firewall.
- [NTSB GAA16CA179](https://openairdocs.org/ntsb/GAA16CA179.md): Bell 206 · Supai, AZ · Accident · Minor injuries · Data collection · Final report · Apr 6, 2016 · N73AW · Substantial damage
  > The pilot's decision to fly a normal approach and forgetting that the long line remained attached to the helicopter, which resulted in the line snagging on a ridgeline, a loss of lateral control, and a rollover.
- [NTSB GAA16CA206](https://openairdocs.org/ntsb/GAA16CA206.md): Boeing A75N1(PT17) · Spring, TX · Accident · No injuries · Data collection · Final report · Apr 3, 2016 · N501TT · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and substantial damage to the lower left wing spar.
- [NTSB GAA16CA175](https://openairdocs.org/ntsb/GAA16CA175.md): Champion 7ECA · Kinder, LA · Accident · No injuries · Data collection · Final report · Apr 3, 2016 · N9611S · Substantial damage
  > The pilot's selection of an unsuitable landing area, resulting in a loss of directional control during landing, an airstrip excursion, impact with a fence and the subsequent airplane fire.
- [NTSB GAA16CA176](https://openairdocs.org/ntsb/GAA16CA176.md): North American AT6 · Yukon, OK · Accident · No injuries · Data collection · Final report · Apr 2, 2016 · N107FG · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in runway excursion and impact with terrain.
- [NTSB CEN16LA153](https://openairdocs.org/ntsb/CEN16LA153.md): Gill Craig Lancair IV P Propjet · Addison, TX · Accident · No injuries · Limited investigation · Final report · Apr 1, 2016 · N992BC · Substantial damage
  > Collapse of the nose landing gear during landing for reasons that could not be determined, because postaccident examination did not detect any anomalies consistent with a preimpact failure or malfunction.
- [NTSB CEN16LA138](https://openairdocs.org/ntsb/CEN16LA138.md): Cessna 180D · Shiprock, NM · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2016 · N180XV · Substantial damage
  > The pilot's failure to maintain directional control after encountering a sudden change in wind direction during the landing roll.
- [NTSB GAA16CA170](https://openairdocs.org/ntsb/GAA16CA170.md): Waco CTO · Ridgeland, SC · Accident · No injuries · Data collection · Final report · Mar 29, 2016 · N744H · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.
- [NTSB DCA16WA118](https://openairdocs.org/ntsb/DCA16WA118.md): Airbus A320 · Bilbao, Spain · Incident · No injuries · Foreign investigation · Mar 28, 2016 · EC-MGE · No damage
  > The government of Spain has notified the NTSB of an accident involving a AIRBUS A320 airplane that occurred on March 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB GAA16CA171](https://openairdocs.org/ntsb/GAA16CA171.md): Rockwell International 114 · Addison, TX · Accident · No injuries · Data collection · Final report · Mar 26, 2016 · N114P · Substantial damage
  > The private pilot's failure to maintain directional control during the landing roll and the flight instructor's delayed remedial action, which resulted in a runway excursion, collision with an airport sign, and a nose gear collapse.
- [NTSB GAA16CA164](https://openairdocs.org/ntsb/GAA16CA164.md): Pphu Ekolot KR-030 Topaz · Lake Dallas, TX · Accident · No injuries · Data collection · Final report · Mar 26, 2016 · N717SP · Substantial damage
  > The pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.
- [NTSB GAA16CA163](https://openairdocs.org/ntsb/GAA16CA163.md): Enstrom F280 · Sodus, NY · Accident · No injuries · Data collection · Final report · Mar 26, 2016 · N5698Y · Substantial damage
  > The pilot's improper collective application at touchdown during a practice run-on landing, which resulted in the main rotor system impacting the tailboom and the forward portion of the fuselage impacting terrain during remedial action by the flight…
- [NTSB GAA16CA169](https://openairdocs.org/ntsb/GAA16CA169.md): American Legend AL3 · Monticello, GA · Accident · Minor injuries · Data collection · Final report · Mar 24, 2016 · N127LC · Substantial damage
  > The pilot's decision to land with a quartering tail wind, and failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with a tree.
- [NTSB GAA16CA159](https://openairdocs.org/ntsb/GAA16CA159.md): Cessna 152 · Valparaiso, IN · Accident · No injuries · Data collection · Final report · Mar 23, 2016 · N918U · Substantial damage
  > The student pilot's failure to maintain pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.
- [NTSB GAA16CA158](https://openairdocs.org/ntsb/GAA16CA158.md): Cessna 172 · Frederick, MD · Accident · No injuries · Data collection · Final report · Mar 23, 2016 · N65329 · Substantial damage
  > The student pilot's improper pitch control during the landing flare, which resulted in a hard bounced landing.
- [NTSB GAA16CA154](https://openairdocs.org/ntsb/GAA16CA154.md): Nicholson David F RV 9 · Allison, IA · Accident · No injuries · Data collection · Final report · Mar 22, 2016 · N347N · Substantial damage
  > The pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.
- [NTSB DCA16WA140](https://openairdocs.org/ntsb/DCA16WA140.md): Fairchild SA227 · Tierra del Fuego, Argentina · Accident · No injuries · Foreign investigation · Mar 22, 2016 · LV-ZEB · Substantial damage
  > The Argentina Junta de Investigacion de Acidentes de Aviacion Civil (JIAAC) has notified the NTSB of an accident involving a Fairchild SA-226 that occurred on March 22, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC…
- [NTSB ANC16WA026](https://openairdocs.org/ntsb/ANC16WA026.md): Cirrus SR22 · Kagoshima, Japan · Incident · No injuries · Foreign investigation · Mar 21, 2016 · JA01YK · Minor damage
  > On March 21, 2016, about 1320 Local Time, a Cirrus SR22 airplane, Japan registration number JA01YK, operated by the pilot, sustained minor damage following a fracture of the nose landing gear strut during landing at the Kagoshima Airport, Japan. The pilot…
- [NTSB GAA16CA155](https://openairdocs.org/ntsb/GAA16CA155.md): Piper PA 46 · Pflugerville, TX · Accident · No injuries · Data collection · Final report · Mar 20, 2016 · N975MA · Substantial damage
  > The pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.
- [NTSB DCA16WA115](https://openairdocs.org/ntsb/DCA16WA115.md): Boeing 737 · Cusco, Peru · Incident · No injuries · Foreign investigation · Mar 20, 2016 · OB-2041P · Minor damage
  > The government of Peru has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…
- [NTSB GAA16CA161](https://openairdocs.org/ntsb/GAA16CA161.md): Beech 58 · Huntsville, AL · Accident · No injuries · Data collection · Final report · Mar 18, 2016 · N358CB · Substantial damage
  > The pilot's failure to extend the landing gear prior to touchdown resulting in a landing with the landing gear retracted and consequent substantial damage.
- [NTSB GAA16CA151](https://openairdocs.org/ntsb/GAA16CA151.md): Robinson Helicopter R22 · Riverside, CA · Accident · No injuries · Data collection · Final report · Mar 17, 2016 · N9076U · Substantial damage
  > The student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.
- [NTSB ERA16LA131](https://openairdocs.org/ntsb/ERA16LA131.md): Raytheon 400A · Rome, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 14, 2016 · N465FL · Substantial damage
  > The pilots’ failure to use available sources of wind information before landing and recognize cues indicating the presence of the tailwind and conduct a go-around, which resulted in their landing with a significant tailwind and a subsequent runway overrun.
- [NTSB GAA16CA152](https://openairdocs.org/ntsb/GAA16CA152.md): Cessna 140 · Chandler, AZ · Accident · No injuries · Data collection · Final report · Mar 13, 2016 · N89939 · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.
- [NTSB GAA16LA172](https://openairdocs.org/ntsb/GAA16LA172.md): Balloon Works FIREFLY8B · Rock Hill, SC · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 2016 · N3180S · No damage
  > The pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.
- [NTSB GAA16CA147](https://openairdocs.org/ntsb/GAA16CA147.md): Piper PA 28 · Pearland, TX · Accident · No injuries · Data collection · Final report · Mar 12, 2016 · N9309J · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.
- [NTSB GAA16CA148](https://openairdocs.org/ntsb/GAA16CA148.md): Remos G 3/600 · Chesapeake, OH · Accident · No injuries · Data collection · Final report · Mar 9, 2016 · N201RQ · Substantial damage
  > The pilot's unstable approach, which resulted in excessive airspeed during the touchdown, subsequent bounced landing, collapsed nose landing gear, and a runway excursion.
- [NTSB GAA16CA187](https://openairdocs.org/ntsb/GAA16CA187.md): Cessna 172 · Scottsdale, AZ · Accident · No injuries · Data collection · Final report · Mar 6, 2016 · N6023V · Substantial damage
  > The failure of the student pilot to maintain pitch control while landing, which resulted in a hard landing, loss of directional control, and runway excursion.
- [NTSB ERA16CA125](https://openairdocs.org/ntsb/ERA16CA125.md): Piper PA 22-108 · Lincolnton, NC · Accident · No injuries · Data collection · Final report · Mar 6, 2016 · N5488Z · Substantial damage
  > The non-certificated pilot's loss of directional control while landing.
- [NTSB GAA16CA145](https://openairdocs.org/ntsb/GAA16CA145.md): Aeropro CZ A220 · Canton, TX · Accident · No injuries · Data collection · Final report · Mar 5, 2016 · N841S · Substantial damage
  > The pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a collision with trees.
- [NTSB DCA16CA113](https://openairdocs.org/ntsb/DCA16CA113.md): Boeing 767 34AF · Albuquerque, NM · Accident · No injuries · Data collection · Final report · Mar 5, 2016 · N305UP · Substantial damage
  > the pilot flying's failure to maintain airspeed and correct pitch attitude. Contributing to the accident was the pilot's failure to maintain appropriate thrust after disconnecting the autothrottles. Also contributing was the first officer's failure to monitor…
- [NTSB ENG16RA017](https://openairdocs.org/ntsb/ENG16RA017.md): Boeing 737 · Mumbai, India · Accident · No injuries · Foreign investigation · Mar 3, 2016 · VT-JGD · Substantial damage
  > The Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Jet Airways Boeing 737, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation…
- [NTSB GAA16CA144](https://openairdocs.org/ntsb/GAA16CA144.md): Cessna 195 · Clinton, AR · Accident · No injuries · Data collection · Final report · Mar 2, 2016 · N3869V · Substantial damage
  > The pilot's failure to maintain direction control during the landing roll, which resulted in runway excursion, and collision with a fence.

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

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

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