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

## Cases, newest first

- [NTSB GAA16CA404](https://openairdocs.org/ntsb/GAA16CA404.md): Cessna 177 · Wickenburg, AZ · Accident · No injuries · Data collection · Final report · Jul 29, 2016 · N34867 · Substantial damage
  > The pilot's incorrect balked landing procedure, which resulted in an uncontrolled descent, hard landing, a runway excursion, and nose gear collapse.
- [NTSB GAA16CA388](https://openairdocs.org/ntsb/GAA16CA388.md): Canadian Light Acft Sales &Svc Bushcaddy Explorer · Island Pond, VT · Accident · No injuries · Data collection · Final report · Jul 29, 2016 · N335BE · Substantial damage
  > The pilot's exceedance of the airplane's critical angle-of-attack during approach, resulting in an inadvertent stall and hard landing.
- [NTSB GAA16CA402](https://openairdocs.org/ntsb/GAA16CA402.md): Cirrus Design SR · Henderson, NV · Accident · No injuries · Data collection · Final report · Jul 28, 2016 · N341CP · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a landing gear collapse.
- [NTSB GAA16CA397](https://openairdocs.org/ntsb/GAA16CA397.md): Olmsted Charles A RV · Dwight, IL · Accident · No injuries · Data collection · Final report · Jul 28, 2016 · N54CV · Substantial damage
  > The pilot's delayed action to perform an aborted landing, which resulted in a nose over and substantial damage to the firewall, fuselage, and empennage.
- [NTSB GAA16CA398](https://openairdocs.org/ntsb/GAA16CA398.md): Cessna 152 · Denton, TX · Accident · No injuries · Data collection · Final report · Jul 27, 2016 · N4702P · Substantial damage
  > The student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.
- [NTSB GAA16CA396](https://openairdocs.org/ntsb/GAA16CA396.md): Cessna 150 · Williamsburg, VA · Accident · Minor injuries · Data collection · Final report · Jul 27, 2016 · N18228 · Substantial damage
  > An evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.
- [NTSB GAA16CA410](https://openairdocs.org/ntsb/GAA16CA410.md): Aeronca 11AC · Gig Harbor, WA · Accident · No injuries · Data collection · Final report · Jul 26, 2016 · N9791E · Substantial damage
  > The pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.
- [NTSB CEN16FA286](https://openairdocs.org/ntsb/CEN16FA286.md): Embraer EMB-505 · Sugar Land, TX · Accident · Minor injuries · Class 3 · Field · Final report · Jul 26, 2016 · N362FX · Substantial damage
  > The airplane’s hydroplaning during the landing roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s continuation of an unstabilized approach, his decision to land in heavy rain conditions, and his improper use of the main…
- [NTSB ERA16FA269](https://openairdocs.org/ntsb/ERA16FA269.md): Yakovlev YAK11 · West Mifflin, PA · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2016 · N5940 · Substantial damage
  > A malfunction of the electrical system, which resulted in an electrical fire in the right wing root of the airplane, which compromised the fuel system and resulted in ignition of fuel. Contributing to the accident was the routing of the electrical wiring near…
- [NTSB GAA16CA426](https://openairdocs.org/ntsb/GAA16CA426.md): American Champion 8KCAB · Cordova, SC · Accident · No injuries · Data collection · Final report · Jul 24, 2016 · N68JK · Substantial damage
  > The pilot's failure to maintain the runway heading, which resulted in the airplane not being aligned with the runway and a subsequent runway excursion.
- [NTSB GAA16CA389](https://openairdocs.org/ntsb/GAA16CA389.md): Cirrus Design SR22 · Hyannis, MA · Accident · Minor injuries · Data collection · Final report · Jul 24, 2016 · N799MR · Substantial damage
  > The pilot's failure to maintain an appropriate descent rate during landing, which resulted in a hard landing, followed by a loss of directional control, runway excursion, and an impact with a security fence and vehicles during the subsequent attempt to abort…
- [NTSB ERA16LA271](https://openairdocs.org/ntsb/ERA16LA271.md): Cessna 310L · Linden, NJ · Accident · No injuries · Limited investigation · Final report · Jul 23, 2016 · N3261X · Substantial damage
  > The overtravel of the main landing gear (MLG) actuator, which resulted in the MLG partially collapsing upon landing. The reasons for the overtravel of the MLG actuator could not be determined due to the unavailability of the wreckage.
- [NTSB CEN16LA288](https://openairdocs.org/ntsb/CEN16LA288.md): Cessna 208B · Baldwin, WI · Accident · No injuries · Limited investigation · Final report · Jul 21, 2016 · N7581F · Substantial damage
  > The pilot's decision to land the fully loaded parachutist drop airplane on a wet grass runway that had insufficient length for the landing in high temperature conditions, which resulted in a runway overrun, when a more suitable longer runway was available at…
- [NTSB GAA16CA391](https://openairdocs.org/ntsb/GAA16CA391.md): Diamond Aircraft Ind HK 36 · Blanchester, OH · Accident · No injuries · Data collection · Final report · Jul 20, 2016 · N526TC · Substantial damage
  > The pilot's failure to maintain directional control of the powered glider during the landing roll.
- [NTSB ERA16CA302](https://openairdocs.org/ntsb/ERA16CA302.md): Beech B200 · Burnsville, NC · Accident · No injuries · Data collection · Final report · Jul 20, 2016 · N46CE · Substantial damage
  > A collision with a bush during landing.
- [NTSB ANC16CA049](https://openairdocs.org/ntsb/ANC16CA049.md): Cessna U206 · Cordova, AK · Accident · No injuries · Data collection · Final report · Jul 20, 2016 · N1222V · Substantial damage
  > The pilot's improper landing flare, which resulted in a hard landing and subsequent landing gear separation and collapse.
- [NTSB CEN16LA274](https://openairdocs.org/ntsb/CEN16LA274.md): Chance Vought F4U 5 · East Troy, WI · Accident · No injuries · Limited investigation · Final report · Jul 19, 2016 · N179PT · Substantial damage
  > A failure of the O-ring in the left brake master cylinder for reasons that could not be determined, which resulted in a loss of directional control during landing.
- [NTSB ANC16LA046](https://openairdocs.org/ntsb/ANC16LA046.md): Cessna A185 · Illiamna, AK · Accident · No injuries · Limited investigation · Final report · Jul 19, 2016 · N85CF · Substantial damage
  > The overstress fracture of the left main landing (MLG) gear axle attachment bolts and the subsequent separation of the left MLG wheel, which resulted in the pilot’s inability to control the airplane.
- [NTSB ANC16CA055](https://openairdocs.org/ntsb/ANC16CA055.md): Kirbybilt Xcalibur · Valdez, AK · Accident · No injuries · Data collection · Final report · Jul 19, 2016 · N505XC · Substantial damage
  > The pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.
- [NTSB GAA16CA386](https://openairdocs.org/ntsb/GAA16CA386.md): Cessna 172 · Chesterfield, MO · Accident · No injuries · Data collection · Final report · Jul 18, 2016 · N128RM · Substantial damage
  > The student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.
- [NTSB CEN16LA271](https://openairdocs.org/ntsb/CEN16LA271.md): Gerald Nelson Nelson Woody · Hope, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 2016 · N525AG · Substantial damage
  > The loss of control upon landing for reasons that could not be determined.
- [NTSB ANC16LA048](https://openairdocs.org/ntsb/ANC16LA048.md): Stinson 108 · Haines, AK · Accident · No injuries · Limited investigation · Final report · Jul 18, 2016 · N343C · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind, which resulted in a ground loop and overstress failure of the left main landing gear wheel axle.
- [NTSB WPR16LA142](https://openairdocs.org/ntsb/WPR16LA142.md): Bell UH 1H · Mt. Adams, WA · Accident · No injuries · Limited investigation · Final report · Jul 17, 2016 · N790RJ · Substantial damage
  > The pilot’s failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in the loss of helicopter control due to the loss of tail rotor effectiveness.
- [NTSB GAA16CA382](https://openairdocs.org/ntsb/GAA16CA382.md): Gonzalez Manuel A RV 7 · Langley, WA · Accident · Minor injuries · Data collection · Final report · Jul 16, 2016 · N228MG · Substantial damage
  > The pilot's decision to land with a tailwind, which resulted in, landing long, a runway overrun, and impact with a berm and nose over.
- [NTSB GAA16CA379](https://openairdocs.org/ntsb/GAA16CA379.md): Jesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KS · Accident · Minor injuries · Data collection · Final report · Jul 16, 2016 · N801G · Substantial damage
  > The pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.
- [NTSB CEN16LA299](https://openairdocs.org/ntsb/CEN16LA299.md): Engineering & Research 415 C · Mt Morris, IL · Accident · No injuries · Limited investigation · Final report · Jul 16, 2016 · N99307 · Substantial damage
  > The pilot's loss of airplane control during a forced landing in gusting crosswind conditions and the airplane’s subsequent bounce on the runway following a loss of engine power. Contributing to the accident was the loss of engine power due to carburetor icing.
- [NTSB ERA16LA260](https://openairdocs.org/ntsb/ERA16LA260.md): Sorensen Danny Pitts S1 S · Somerville, TN · Accident · No injuries · Limited investigation · Final report · Jul 15, 2016 · N4714H · Substantial damage
  > The failure of the left landing gear leg due to fatigue, which resulted in a ground loop during landing. Contributing to the accident was the airplane builder's installation of a custom-built landing gear rather than the landing gear included with the…
- [NTSB GAA16CA378](https://openairdocs.org/ntsb/GAA16CA378.md): Piper PA46R · Denver, CO · Accident · No injuries · Data collection · Final report · Jul 14, 2016 · N465BP · Substantial damage
  > The pilot's improper nose down pitch attitude during touchdown resulting in a propeller strike, hard bounced landing, and nose landing gear collapse.
- [NTSB ENG16WA035](https://openairdocs.org/ntsb/ENG16WA035.md): Boeing 737 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Jul 12, 2016 · XA-UNY · Substantial damage
  > The DIRECCIÓN GENERAL DE AERONAUTICA CIVIL (DGCA) of Mexico has notified the NTSB of an incident involving a Magnicharter Boeing 737, which occurred on July 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA investigation…
- [NTSB GAA16CA374](https://openairdocs.org/ntsb/GAA16CA374.md): Cessna 150 · Cleveland, GA · Accident · Minor injuries · Data collection · Final report · Jul 11, 2016 · N23483 · Substantial damage
  > Failure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.
- [NTSB GAA16CA373](https://openairdocs.org/ntsb/GAA16CA373.md): Canadian Car & Foundry Harvard · Somerset, KY · Accident · No injuries · Data collection · Final report · Jul 11, 2016 · N99CV · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with an airport sign.
- [NTSB ERA16LA251](https://openairdocs.org/ntsb/ERA16LA251.md): Tumbling Goose 12S · Zellwood, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 2016 · N867TG · Destroyed
  > A total loss of engine power during descent for reasons that could not be determined because impact damage precluded a complete examination of the fuel servo.
- [NTSB GAA16CA472](https://openairdocs.org/ntsb/GAA16CA472.md): Cessna 172 · Kahului, HI · Accident · No injuries · Data collection · Final report · Jul 10, 2016 · N335SP · Substantial damage
  > The pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.
- [NTSB GAA16CA366](https://openairdocs.org/ntsb/GAA16CA366.md): Helio H 295 · Grants Pass, OR · Accident · No injuries · Data collection · Final report · Jul 10, 2016 · N9185Z · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a ground loop.
- [NTSB CEN16LA263](https://openairdocs.org/ntsb/CEN16LA263.md): Evolution Trikes Revo · Newark, IL · Accident · 1 fatal · Limited investigation · Final report · Jul 9, 2016 · N9912S · Substantial damage
  > The student pilot's failure to maintain directional control on landing. Contributing to the accident was the pilot's lack of flight experience.
- [NTSB WPR16LA139](https://openairdocs.org/ntsb/WPR16LA139.md): Cessna 140 · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Jul 8, 2016 · N89965 · Substantial damage
  > The fatigue failure of a bulkhead-skin joint that supported the main landing gear leg, which resulted in the collapse of the left main landing gear. Contributing to the failure were the non-original structural configuration of the 60-year-old airplane and the…
- [NTSB DCA16IA200](https://openairdocs.org/ntsb/DCA16IA200.md): Airbus Industrie A320 211 · Rapid City, SD · Incident · No injuries · Incident investigation · Final report · Jul 8, 2016 · N333NW · No damage
  > The flight crew's misidentification of the desired landing runway due to excess altitude requiring an extended downwind, and failure to use all available navigation information.
- [NTSB CEN16LA259](https://openairdocs.org/ntsb/CEN16LA259.md): Cessna 152 · Bridgeport, TX · Accident · No injuries · Limited investigation · Final report · Jul 8, 2016 · N5331B · Substantial damage
  > The pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…
- [NTSB GAA16CA367](https://openairdocs.org/ntsb/GAA16CA367.md): Cessna 182 · Searcy, AR · Accident · No injuries · Data collection · Final report · Jul 7, 2016 · N9046T · Substantial damage
  > The pilot landed long and failed to stop before the end of the runway, which resulted in a runway overrun and impact with trees. Contributing to the accident was the pilot's failure to maintain a stabilized approach.
- [NTSB GAA16CA370](https://openairdocs.org/ntsb/GAA16CA370.md): Cessna 180 · New Durham, NH · Accident · No injuries · Data collection · Final report · Jul 6, 2016 · N767MH · Substantial damage
  > The pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.
- [NTSB CEN16CA258](https://openairdocs.org/ntsb/CEN16CA258.md): Boyd Kenneth C Rans S-19 · Ephraim, WI · Accident · No injuries · Data collection · Final report · Jul 6, 2016 · N39KB · Substantial damage
  > The pilot's decision to continue the landing from an unstabilized approach which resulted in a loss of control and subsequent hard landing.
- [NTSB GAA16CA368](https://openairdocs.org/ntsb/GAA16CA368.md): Avions Mudry ET Cie CAP · Spring Branch, TX · Accident · No injuries · Data collection · Final report · Jul 5, 2016 · N42415 · Substantial damage
  > The flight instructor's inability to maintain directional control during the landing roll as a result of the malfunctioning brake master cylinder.
- [NTSB CEN16WA257](https://openairdocs.org/ntsb/CEN16WA257.md): Cirrus SR22 · Madrid, Spain, Spain · Accident · 2 fatal · Foreign investigation · Jul 5, 2016 · EC-KJO · Destroyed
  > On July 5, 2016, about 1940 coordinated universal time, a Cirrus SR22 single engine airplane, serial number 2558, registry EC-KJO, was destroyed after impacting terrain and obstructions while landing at Cuatro Vientos Airport at Madrid, Spain. The two…
- [NTSB CEN16LA246](https://openairdocs.org/ntsb/CEN16LA246.md): Cessna 172 · Wonder Lake, IL · Accident · No injuries · Limited investigation · Final report · Jul 5, 2016 · N6576H · Substantial damage
  > The flight instructor's inadequate supervision and lack of remedial action due to his diverted attention to a radio call, which resulted in the airplane landing short of the runway.
- [NTSB GAA16CA355](https://openairdocs.org/ntsb/GAA16CA355.md): Rainbow Sky Reach Bushcat · Cairo, NE · Accident · No injuries · Data collection · Final report · Jul 4, 2016 · N321WL · Substantial damage
  > The pilot's decision to fly into deteriorating weather conditions, leading to a precautionary off airport soft field landing which resulted in a nose gear collapse and the airplane to nose over.
- [NTSB ANC16LA038](https://openairdocs.org/ntsb/ANC16LA038.md): Cessna 206 · Halibut Cove, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N6251K · Substantial damage
  > The pilot's failure to maintain clearance from trees during an attempted go-around.
- [NTSB ANC16CA040](https://openairdocs.org/ntsb/ANC16CA040.md): Cessna 180 · Nome, AK · Accident · No injuries · Data collection · Final report · Jul 4, 2016 · N9203T · Substantial damage
  > The pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and impacting a barricade. Contributing to the accident was the airport manager's improper placement and marking of a metal…
- [NTSB ERA16CA241](https://openairdocs.org/ntsb/ERA16CA241.md): Cessna 305 · Shirley, NY · Accident · No injuries · Data collection · Final report · Jul 3, 2016 · N12633 · Substantial damage
  > The pilot's failure to maintain directional control while landing. Contributing to the accident was the pilot's decision to accept an advised runway rather than determine actual airport winds, which resulted in the airplane landing with a quartering tailwind.
- [NTSB GAA16CA360](https://openairdocs.org/ntsb/GAA16CA360.md): Cessna 172 · Pembroke Pines, FL · Accident · No injuries · Data collection · Final report · Jul 2, 2016 · N65645 · Substantial damage
  > The student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.
- [NTSB GAA16CA353](https://openairdocs.org/ntsb/GAA16CA353.md): Cessna 182 · Hungry Horse, MT · Accident · Minor injuries · Data collection · Final report · Jul 2, 2016 · N42469 · Substantial damage
  > The pilot's decision to land on unsuitable wet terrain, and his failure to stop prior to the end of the runway, which resulted in a runway overrun and impact with tree(s).

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

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

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