# NTSB investigations, 2019: 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 1 of 10 · 463 cases

## Latest cases

- [NTSB WPR20LA054](https://openairdocs.org/ntsb/WPR20LA054.md): Mitsubishi MU2B · Big Piney, WY · Accident · No injuries · Class 3 · Limited · Final report · Dec 30, 2019 · N43866 · Substantial damage
  > The failure of the right propeller position to correspond to the throttle change when moved to the beta position for reasons that could not be determined based on available evidence.
- [NTSB CEN20WA061](https://openairdocs.org/ntsb/CEN20WA061.md): Robinson R44 · Wijnendaele, Belgium · Accident · No injuries · Foreign investigation · Dec 29, 2019 · OO-RFF · Substantial damage
  > The government of Belgium has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on December 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the…
- [NTSB ERA20CA078](https://openairdocs.org/ntsb/ERA20CA078.md): Cessna 172 · Ormond Beach, FL · Accident · No injuries · Data collection · Final report · Dec 26, 2019 · N882TC · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a hard landing.
- [NTSB ERA20LA070](https://openairdocs.org/ntsb/ERA20LA070.md): Cessna 210 · Concord, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 24, 2019 · N30259 · Substantial damage
  > A malfunction of the left main landing gear brake during landing for undetermined reasons. Contributing was the pilot’s failure to attain a proper touchdown point and maintain an appropriate approach speed while landing on the wet turf runway.
- [NTSB DCA20WA044](https://openairdocs.org/ntsb/DCA20WA044.md): Boeing 737 · Manchester, United Kingdom · Incident · No injuries · Foreign investigation · Dec 24, 2019 · G-TAWG · Minor damage
  > The AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…
- [NTSB DCA20LA047](https://openairdocs.org/ntsb/DCA20LA047.md): Boeing 737-824 · Denver, CO · Accident · No injuries · Class 3 · Limited · Final report · Dec 23, 2019 · N87513 · Substantial damage
  > Maintenance personnel’s excessive grinding of the left main landing gear’s aft trunnion pin during its initial overhaul, which caused heat damage to the base metal and led to the fatigue crack that caused the pin to fail during the accident flight.…
- [NTSB CEN20CA059](https://openairdocs.org/ntsb/CEN20CA059.md): Zenith CH 750 · Xenia, OH · Accident · No injuries · Data collection · Final report · Dec 23, 2019 · N227L · Substantial damage
  > The pilot’s failure to maintain airplane control during landing, which resulted in the right tire contacting the runway first followed by the left wing.
- [NTSB CEN20CA040](https://openairdocs.org/ntsb/CEN20CA040.md): Cessna 172 · Pineville, LA · Accident · Minor injuries · Data collection · Final report · Dec 23, 2019 · N739SB · Substantial damage
  > The pilot's failure to attain an adequate climb rate during an aborted landing with a left quartering, gusting headwind, which resulted in impact with a tree.
- [NTSB WPR20CA048](https://openairdocs.org/ntsb/WPR20CA048.md): Piper PA22 · Caldwell, ID · Accident · No injuries · Data collection · Final report · Dec 18, 2019 · N1107C · Substantial damage
  > The student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.
- [NTSB WPR20CA043](https://openairdocs.org/ntsb/WPR20CA043.md): John Sample Bearhawk · Nampa, ID · Accident · No injuries · Data collection · Final report · Dec 16, 2019 · N719JS · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which resulted in impact with a knoll and a subsequent ground-loop.
- [NTSB ERA20CA138](https://openairdocs.org/ntsb/ERA20CA138.md): Lindstrand 180A · Davenport, FL · Accident · Serious injuries · Data collection · Final report · Dec 16, 2019 · N3013T · No damage
  > The pilot’s failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injury to a passenger.
- [NTSB ERA20LA055](https://openairdocs.org/ntsb/ERA20LA055.md): Piper PA18 · New Market, VA · Accident · No injuries · Class 3 · Limited · Final report · Dec 15, 2019 · N1984A · Substantial damage
  > The pilot's improper touchdown, which resulted in a hard landing and an overload failure of the right main landing gear leg and its associated shock/dampener.
- [NTSB WPR20TA039](https://openairdocs.org/ntsb/WPR20TA039.md): Enstrom F28 · Riverton, UT · Accident · Minor injuries · Class 3 · Final report · Dec 11, 2019 · N65RS · Substantial damage
  > The noncertificated pilot’s decision to operate a deregistered helicopter, which resulted in a component failure and subsequent loss of control and hard landing. Contributing to the accident was the lack of recent maintenance on the helicopter.
- [NTSB ERA20LA053](https://openairdocs.org/ntsb/ERA20LA053.md): Piper PA28 · Louisville, KY · Accident · No injuries · Class 3 · Limited · Final report · Dec 10, 2019 · N9097W · Substantial damage
  > The pilot’s improper flare to land, which resulted in a hard landing and the nose landing gear collapsing.
- [NTSB CEN20TA030](https://openairdocs.org/ntsb/CEN20TA030.md): Rotary RAF 2000 · Omaha, NE · Accident · Serious injuries · Class 3 · Final report · Dec 7, 2019 · N47EB · Substantial damage
  > The pilot's loss of directional control while landing in gusting wind conditions.
- [NTSB WPR20CA041](https://openairdocs.org/ntsb/WPR20CA041.md): Cessna 182 · Camas, WA · Accident · No injuries · Data collection · Final report · Dec 5, 2019 · N52458 · Substantial damage
  > The student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.
- [NTSB WPR20CA036](https://openairdocs.org/ntsb/WPR20CA036.md): Javron PA-18 Replica · Nephi, UT · Accident · No injuries · Data collection · Final report · Dec 3, 2019 · N864SC · Substantial damage
  > The passenger’s inadvertent application of the brakes during landing, which resulted in a nose-over.
- [NTSB CEN20LA028](https://openairdocs.org/ntsb/CEN20LA028.md): BAE BAE125 · Detroit, MI · Accident · No injuries · Class 3 · Limited · Final report · Dec 3, 2019 · N469RJ · Substantial damage
  > The pilots’ failure to increase approach speed as recommended for flight in icing conditions, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the failure of the stall warning system to advise the…
- [NTSB GAA20WA099](https://openairdocs.org/ntsb/GAA20WA099.md): Piper PA23 · Shannon, Ireland · Accident · No injuries · Foreign investigation · Dec 2, 2019 · EI-WMN · Substantial damage
  > The government of Ireland has notified the NTSB of an accident involving a PIPER PA23 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…
- [NTSB ERA20CA048](https://openairdocs.org/ntsb/ERA20CA048.md): Cirrus SR22 · Union City, TN · Accident · No injuries · Data collection · Final report · Dec 1, 2019 · N991WS · Substantial damage
  > The pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a runway excursion and the left wing impacting grass.
- [NTSB DCA20WA031](https://openairdocs.org/ntsb/DCA20WA031.md): Boeing 747 · Sydney, Australia · Incident · No injuries · Foreign investigation · Nov 28, 2019 · 9V-SFO · Minor damage
  > The government of Australia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on November 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…
- [NTSB WPR20CA058](https://openairdocs.org/ntsb/WPR20CA058.md): Aeronca 11AC · San Diego, CA · Accident · No injuries · Data collection · Final report · Nov 25, 2019 · N9510E · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.
- [NTSB DCA20CA028](https://openairdocs.org/ntsb/DCA20CA028.md): General Atomics MQ-9 · Palmdale, CA · Accident · No injuries · Data collection · Final report · Nov 25, 2019 · N341HK · Substantial damage
  > Incorrect control inputs by the student pilot during a crosswind landing, resulting in control saturation and a runway excursion.
- [NTSB CEN20TA025](https://openairdocs.org/ntsb/CEN20TA025.md): Piper PA34 · Mount Pleasant, TX · Accident · No injuries · Class 3 · Final report · Nov 25, 2019 · N15412 · Substantial damage
  > The pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.
- [NTSB GAA20CA094](https://openairdocs.org/ntsb/GAA20CA094.md): Piper PA28 · Simsbury, CT · Accident · Minor injuries · Data collection · Final report · Nov 23, 2019 · N5776W · Substantial damage
  > The automobile driver's incursion onto an active runway, which resulted in a collision with a landing airplane.
- [NTSB DCA20WA018](https://openairdocs.org/ntsb/DCA20WA018.md): Boeing 737 · Bogota, Colombia · Accident · No injuries · Foreign investigation · Nov 23, 2019 · YV3012 · Substantial damage
  > The government of Colombia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB CEN20CA033](https://openairdocs.org/ntsb/CEN20CA033.md): Piper PA18 · Kerrville, TX · Accident · No injuries · Data collection · Final report · Nov 23, 2019 · N530AK · Substantial damage
  > The pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.
- [NTSB DCA20WA030](https://openairdocs.org/ntsb/DCA20WA030.md): Boeing 737 · Odesa, Ukraine · Incident · No injuries · Foreign investigation · Nov 21, 2019 · TC-JGZ · Minor damage
  > The government of Ukraine has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the provisions…
- [NTSB ERA20LA038](https://openairdocs.org/ntsb/ERA20LA038.md): Mooney M20M · College Park, MD · Accident · No injuries · Class 3 · Limited · Final report · Nov 18, 2019 · N1031M · Substantial damage
  > The pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.
- [NTSB GAA20CA089](https://openairdocs.org/ntsb/GAA20CA089.md): Cessna 172 · DuBois, PA · Accident · No injuries · Data collection · Final report · Nov 17, 2019 · N683SP · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…
- [NTSB GAA20CA081](https://openairdocs.org/ntsb/GAA20CA081.md): Stinson SR9 · West Jefferson, OH · Accident · No injuries · Data collection · Final report · Nov 17, 2019 · N18416 · Substantial damage
  > The pilot's use of excessive braking during landing, which resulted in a nose-over.
- [NTSB WPR20LA025](https://openairdocs.org/ntsb/WPR20LA025.md): North American SNJ-4 · Heber City, UT · Accident · No injuries · Class 3 · Limited · Final report · Nov 16, 2019 · N694US · Substantial damage
  > The pilot’s loss of directional control during landing as a result of the separated tailwheel-to-rudder link rod
- [NTSB GAA20CA086](https://openairdocs.org/ntsb/GAA20CA086.md): Cessna 152 · Sherman/Dennison, TX · Accident · No injuries · Data collection · Final report · Nov 16, 2019 · N4705Q · Substantial damage
  > The pilot's improper landing flare, which resulted in a bounced landing.
- [NTSB ERA20LA034](https://openairdocs.org/ntsb/ERA20LA034.md): Cessna 172 · Toms River, NJ · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 13, 2019 · N3958S · 2 aircraft · Substantial damage
  > The failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…
- [NTSB GAA20CA074](https://openairdocs.org/ntsb/GAA20CA074.md): Cessna 172 · FallBrook, CA · Accident · No injuries · Data collection · Final report · Nov 12, 2019 · N3803S · Substantial damage
  > The student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.
- [NTSB GAA20CA071](https://openairdocs.org/ntsb/GAA20CA071.md): Cessna 182 · San Luis, CO · Accident · No injuries · Data collection · Final report · Nov 12, 2019 · N91846 · Substantial damage
  > The pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.
- [NTSB GAA20CA067](https://openairdocs.org/ntsb/GAA20CA067.md): Cessna 172 · Pembroke Pines, FL · Accident · No injuries · Data collection · Final report · Nov 12, 2019 · N739UA · Substantial damage
  > The student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.
- [NTSB GAA20CA070](https://openairdocs.org/ntsb/GAA20CA070.md): Cessna 195 · Kalispell, MT · Accident · No injuries · Data collection · Final report · Nov 11, 2019 · N195BG · Substantial damage
  > The pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the left main landing gear collapsing.
- [NTSB DCA20LA013](https://openairdocs.org/ntsb/DCA20LA013.md): Embraer EMB145 · Chicago, IL · Accident · No injuries · Class 3 · Limited · Final report · Nov 11, 2019 · N619AE · Substantial damage
  > The flight crew’s inability to maintain the airplane on the runway centerline after touchdown due to the reduced braking action resulting from the deteriorating weather conditions, which caused the airplane’s departure from the runway surface. Contributing to…
- [NTSB GAA20CA085](https://openairdocs.org/ntsb/GAA20CA085.md): Piper PA60 · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Nov 9, 2019 · N914MB · Substantial damage
  > The pilot's failure to follow the taxiway centerline guide and his distraction due to adjusting the radio, which resulted in his failure to maintain clearance from a taxiway light after landing and while taxiing to a ramp.
- [NTSB GAA20CA084](https://openairdocs.org/ntsb/GAA20CA084.md): Beech 55 · Broomfield, CO · Accident · No injuries · Data collection · Final report · Nov 9, 2019 · N6206V · Substantial damage
  > The pilot's unintentional retraction of the landing gear during the landing roll.
- [NTSB GAA20CA062](https://openairdocs.org/ntsb/GAA20CA062.md): Bell 47G · Groveland, FL · Accident · No injuries · Data collection · Final report · Nov 7, 2019 · N6746D · Substantial damage
  > The student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.
- [NTSB GAA20CA075](https://openairdocs.org/ntsb/GAA20CA075.md): Cessna 182 · Broomfield, CO · Accident · No injuries · Data collection · Final report · Nov 6, 2019 · N97596 · Substantial damage
  > The pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.
- [NTSB GAA20CA073](https://openairdocs.org/ntsb/GAA20CA073.md): Schleicher ASW15 · Waynesville, OH · Accident · Minor injuries · Data collection · Final report · Nov 6, 2019 · N16TD · Substantial damage
  > The glider pilot's improper approach during landing, which resulted in collision with trees.
- [NTSB CEN20WA065](https://openairdocs.org/ntsb/CEN20WA065.md): Learjet 35 · Cabo San Lucas, Mexico · Accident · No injuries · Foreign investigation · Nov 5, 2019 · XA-VBD
  > On November 5, 2019, at 1942 Mexican pacific standard time, a Learjet 35A airplane, Mexican registration XA-VBD, experienced a runway excursion after landing at Cabo San Lucas International Airport, Cabo San Lucas, Mexico. The four occupants sustained no…
- [NTSB WPR20LA032](https://openairdocs.org/ntsb/WPR20LA032.md): Beech 36 · Hurricane, UT · Accident · No injuries · Class 3 · Limited · Final report · Nov 4, 2019 · N936TC · Substantial damage
  > The pilot’s failure to ensure that the landing gear was in the fully extended and locked position before landing. Contributing to the accident was the overload of the landing gear circuit for reasons that could not be determined.
- [NTSB GAA20CA059](https://openairdocs.org/ntsb/GAA20CA059.md): Ercoupe 415 · Greer, SC · Accident · No injuries · Data collection · Final report · Nov 3, 2019 · N87173 · Substantial damage
  > The pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.
- [NTSB GAA20CA056](https://openairdocs.org/ntsb/GAA20CA056.md): Pitts S1 · Monument Valley, UT · Accident · No injuries · Data collection · Final report · Nov 3, 2019 · C-GMEE · Substantial damage
  > The pilot's failure to maintain directional control during landing after a wing struck vegetation, which resulted in a runway excursion and subsequent ground-loop.
- [NTSB GAA20CA068](https://openairdocs.org/ntsb/GAA20CA068.md): Icon A5 · Chester, CT · Accident · No injuries · Data collection · Final report · Nov 2, 2019 · N59WE · Substantial damage
  > The pilot's failure to maintain a proper approach angle in dark night conditions, which resulted in a collision with treetops and a subsequent hard landing.
- [NTSB ERA20LA037](https://openairdocs.org/ntsb/ERA20LA037.md): Mosquito XE · Seffner, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 2, 2019 · UNREG · Substantial damage
  > The pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.

Next page: https://openairdocs.org/ntsb-phases/550/cases.md?year=2019&page=2

## 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 year(c."eventDate") = 2019
  AND 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?year=2019

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