# NTSB investigations: Maneuvering

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 45 of 377 · 18,849 cases

## Cases, newest first

- [NTSB CEN14LA358](https://openairdocs.org/ntsb/CEN14LA358.md): Grumman Acft ENG Cor-Schweizer G-164B · Garrison, ND · Accident · No injuries · Limited investigation · Final report · Jul 9, 2014 · N6648Q · Substantial damage
  > Excessive wear between the power turbine shaft and quill shaft spline, which led to the disconnection of the power turbine wheel, an overspeed of the power turbine, and the subsequent loss of engine power. Contributing to the accident was maintenance…
- [NTSB WPR14LA285](https://openairdocs.org/ntsb/WPR14LA285.md): Bailey-Moyes Microlights Dragonfly B Model · Buckley, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2014 · N7008Z · Substantial damage
  > The pilot’s inability to maintain airplane control due to a loss of flight control effectiveness for reasons that could not be determined during postaccident examinations.
- [NTSB WPR14FA282](https://openairdocs.org/ntsb/WPR14FA282.md): Piper PA 28R-180 · Lake Elsinore, CA · Accident · 3 fatal · Field investigation · Final report · Jul 6, 2014 · N3723T · Destroyed
  > The pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.
- [NTSB ERA14LA330](https://openairdocs.org/ntsb/ERA14LA330.md): Zubair S Khan Raven · Mattituck, NY · Accident · 1 fatal · Limited investigation · Final report · Jul 6, 2014 · N79ZR · Substantial damage
  > The pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.
- [NTSB ERA14CA335](https://openairdocs.org/ntsb/ERA14CA335.md): Alexander Schleicher K 7 · Mocksville, NC · Accident · No injuries · Data collection · Final report · Jul 6, 2014 · N9156 · Substantial damage
  > The pilot's decision to install an additional cushion to elevate his passenger and his failure to insure the cushion would not interfere with the control stick movement resulting in limited movement of the elevator in flight and collision with a fence during…
- [NTSB WPR14GA281](https://openairdocs.org/ntsb/WPR14GA281.md): American Eurocopter AS350B3 · Fallon, NV · Accident · Minor injuries · Final report · Jul 4, 2014 · N832PA · Substantial damage
  > A loss of tail rotor effectiveness, which resulted in an uncontrolled rotation and descent into terrain. Contributing to the accident was a sudden shift in wind conditions and the helicopter's high power demand condition due to its load weight and operating…
- [NTSB CEN14LA342](https://openairdocs.org/ntsb/CEN14LA342.md): Slaughter Mike CH601-HDS · Frankston, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 2014 · N4263 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's decision to make a…
- [NTSB WPR14CA280](https://openairdocs.org/ntsb/WPR14CA280.md): Bell 47G · Gaston, OR · Accident · No injuries · Data collection · Final report · Jul 3, 2014 · N684PC · Substantial damage
  > The pilot's inability to maintain control of the helicopter as a result of a hydraulic hose becoming entangled around the right skid.
- [NTSB ERA14TA326](https://openairdocs.org/ntsb/ERA14TA326.md): Cessna 336 · Mobile, AL · Accident · Serious injuries · Final report · Jul 3, 2014 · N3804U · Substantial damage
  > The pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.
- [NTSB CEN14CA344](https://openairdocs.org/ntsb/CEN14CA344.md): Piper PA 25-235 · Rhinelander, WI · Accident · Minor injuries · Data collection · Final report · Jul 3, 2014 · N8730L · Substantial damage
  > A loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.
- [NTSB ERA14FA322](https://openairdocs.org/ntsb/ERA14FA322.md): Air Tractor AT-602 · Clarksdale, MS · Accident · 1 fatal · Field investigation · Final report · Jul 1, 2014 · N91331 · Destroyed
  > The pilot's failure to maintain adequate airspeed during a low-level, high angle-of-bank turn, which resulted in an exceedance of the critical angle of attack and a subsequent accelerated stall.
- [NTSB CEN14LA379](https://openairdocs.org/ntsb/CEN14LA379.md): Kolb Mark III · Jonesville, LA · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 2014 · UNREG · Substantial damage
  > The noncertificated pilot's failure to maintain clearance from trees.
- [NTSB ERA14LA319](https://openairdocs.org/ntsb/ERA14LA319.md): Waco UPF 7 · Warrenton, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2014 · N32162 · Substantial damage
  > A total loss of engine power during a low pass for reasons that could not be determined during postaccident examination of the engine.
- [NTSB WPR14LA273](https://openairdocs.org/ntsb/WPR14LA273.md): Skyraider Skyraider · Lewiston, ID · Accident · 1 fatal · Limited investigation · Final report · Jun 28, 2014 · UNREG · Substantial damage
  > The pilot's failure to maintain an adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall at too low an altitude to recover.
- [NTSB CEN14FA325](https://openairdocs.org/ntsb/CEN14FA325.md): Doyle James E Skybolt · Midlothian, TX · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2014 · N619PD · Substantial damage
  > The pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in an inverted spin and subsequent collision with terrain.
- [NTSB WPR14CA270](https://openairdocs.org/ntsb/WPR14CA270.md): Robinson Helicopter R44 II · Quincy, WA · Accident · No injuries · Data collection · Final report · Jun 27, 2014 · N560LH · Substantial damage
  > The pilot's failure to maintain clearance from a wind generator tower while drying cherries, which resulted in a loss of aircraft control and subsequent hard landing.
- [NTSB CEN14LA331](https://openairdocs.org/ntsb/CEN14LA331.md): Cessna A188 · Arlington, TX · Accident · No injuries · Limited investigation · Final report · Jun 27, 2014 · N8157V · Substantial damage
  > The total loss of engine power due to a loose oil filter adapter, which resulted in oil starvation. Contributing to the accident was maintenance personnel’s failure to comply with a Federal Aviation Administration airworthiness directive.
- [NTSB CEN14CA341](https://openairdocs.org/ntsb/CEN14CA341.md): Air Tractor AT 402B · Sudan, TX · Accident · Minor injuries · Data collection · Final report · Jun 26, 2014 · N5197U · Substantial damage
  > The pilot's lapse in monitoring the airplane's speed during a low level aerial application maneuver and its subsequent stall during the maneuver.
- [NTSB ANC14LA046](https://openairdocs.org/ntsb/ANC14LA046.md): Dehavilland DHC 2 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 2014 · N115CX · Minor damage
  > The pilot’s improper decision to operate the airplane at low altitude and deliberately in close proximity to the boat operators, which resulted in a collision with a boat operator.
- [NTSB CEN14LA316](https://openairdocs.org/ntsb/CEN14LA316.md): Grazhopper Trike · Ottawa, IL · Accident · 1 fatal · Limited investigation · Final report · Jun 24, 2014 · UNREG · Substantial damage
  > The noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…
- [NTSB WPR14LA267](https://openairdocs.org/ntsb/WPR14LA267.md): Air Tractor AT 502B · Sacramento, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 2014 · N61150 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because the airplane was not available for postaccident examination.
- [NTSB CEN14WA321](https://openairdocs.org/ntsb/CEN14WA321.md): Learjet 35 - A · Olsberg, Germany · Accident · 2 fatal · Foreign investigation · Jun 23, 2014 · D-CGFI · Destroyed
  > The accident investigation is under the jurisdiction and control of the German government. This report is for information purposes only and contains only information released by or obtained from the German government or German Federal Bureau of Aircraft…
- [NTSB WPR14FA258](https://openairdocs.org/ntsb/WPR14FA258.md): Parker Loehle Mustang T5151 · Livermore, CA · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2014 · N518BC · Destroyed
  > An in-flight fire of unknown origin for reasons that could not be determined because of impact damage and postimpact fire damage.
- [NTSB CEN14CA314](https://openairdocs.org/ntsb/CEN14CA314.md): Air Tractor AT 402B · Newport, AR · Accident · Minor injuries · Data collection · Final report · Jun 21, 2014 · N428JJ · Substantial damage
  > The pilot misjudged his altitude which resulted in the airplane contacting a wire during the low altitude aerial application maneuver.
- [NTSB WPR14FA262](https://openairdocs.org/ntsb/WPR14FA262.md): Mooney M20B · Page, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 20, 2014 · N74584 · Substantial damage
  > The pilot’s failure to maintain adequate clearance from terrain while maneuvering in a canyon in high-density altitude conditions.
- [NTSB WPR14CA256](https://openairdocs.org/ntsb/WPR14CA256.md): Robinson Helicopter R22 Beta · Long Beach, CA · Accident · No injuries · Data collection · Final report · Jun 20, 2014 · N681SH · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering for landing.
- [NTSB CEN14LA319](https://openairdocs.org/ntsb/CEN14LA319.md): Grumman G 164 · Anadarko, OK · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 2014 · N455Y · Substantial damage
  > The total loss of engine power while climbing after takeoff for reasons that could not be determined based on the available information.
- [NTSB CEN14CA317](https://openairdocs.org/ntsb/CEN14CA317.md): Quicksilver Enterprises MXL II Sport · Watertown, SD · Accident · Serious injuries · Data collection · Final report · Jun 19, 2014 · N4474P · Substantial damage
  > The uncertificated pilot's loss of control while maneuvering at low altitude.
- [NTSB ANC14CA042](https://openairdocs.org/ntsb/ANC14CA042.md): Robinson Helicopter R44 II · Coldfoot, AK · Accident · No injuries · Data collection · Final report · Jun 18, 2014 · N74713 · Substantial damage
  > The pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in an emergency landing on uneven terrain.
- [NTSB WPR14FA231](https://openairdocs.org/ntsb/WPR14FA231.md): Grumman G 21A · Sula, MT · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2014 · N888GG · Destroyed
  > The pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.
- [NTSB ERA14FA292](https://openairdocs.org/ntsb/ERA14FA292.md): Columbia Aircraft Mfg LC41 550FG · East Patchogue, NY · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2014 · N610MH · Destroyed
  > The noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CEN14CA318](https://openairdocs.org/ntsb/CEN14CA318.md): Meyer Geoffrey A Goat · Wolcott, CO · Accident · No injuries · Data collection · Final report · Jun 16, 2014 · N987SL · Substantial damage
  > The failure of an oil line leading to the oil pressure transducer which resulted in oil starvation and subsequent loss of engine power.
- [NTSB WPR14FA244](https://openairdocs.org/ntsb/WPR14FA244.md): Grumman American Avn. AA 5B · Florence, OR · Accident · 2 fatal · Field investigation · Final report · Jun 15, 2014 · N28718 · Destroyed
  > The noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.
- [NTSB CEN14CA289](https://openairdocs.org/ntsb/CEN14CA289.md): Cessna 182A · Valmeyer, IL · Accident · No injuries · Data collection · Final report · Jun 14, 2014 · N5172D · Substantial damage
  > The inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.
- [NTSB CEN14LA287](https://openairdocs.org/ntsb/CEN14LA287.md): Air Tractor AT 301 · Pearsall, TX · Accident · No injuries · Limited investigation · Final report · Jun 12, 2014 · N8593S · Substantial damage
  > The failure of the No. 1 cylinder rod at the link pin. Contributing to the accident was oil starvation to the rod bearing due to the improper flushing of the oil cooler, which allowed metal and other debris in the oil to clog the drain and the led to the…
- [NTSB ERA14FA282](https://openairdocs.org/ntsb/ERA14FA282.md): Liberty Aerospace XL-2 · Merritt Island, FL · Accident · 2 fatal · Field investigation · Final report · Jun 10, 2014 · N516XL · Destroyed
  > The failure of the pilots to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the loss of engine power for a reason that could…
- [NTSB WPR14FA239](https://openairdocs.org/ntsb/WPR14FA239.md): American AA-1A · El Mirage, CA · Accident · 2 fatal · Field investigation · Final report · Jun 9, 2014 · N9454L · Destroyed
  > The pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.
- [NTSB CEN14FA288](https://openairdocs.org/ntsb/CEN14FA288.md): Schrieber Robert L P 70 · Great Bend, KS · Accident · 2 fatal · Field investigation · Final report · Jun 8, 2014 · N567CM · Substantial damage
  > The pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.
- [NTSB CEN14LA298](https://openairdocs.org/ntsb/CEN14LA298.md): Air Tractor AT-802A · Oneida, AR · Accident · No injuries · Limited investigation · Final report · Jun 7, 2014 · N802PR · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power at low altitude due to fuel exhaustion and a forced landing in a muddy field and subsequent nose-over.
- [NTSB WPR14LA230](https://openairdocs.org/ntsb/WPR14LA230.md): Cessna 172M · Laytonville, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 6, 2014 · N1186U · Substantial damage
  > The pilot’s impairment due to alcohol ingestion, which resulted in his failure to maintain clearance from trees during a low-altitude flyby.
- [NTSB CEN14LA281](https://openairdocs.org/ntsb/CEN14LA281.md): Offchiss Edward R Avid Flyer · Lamoni, IA · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 2014 · N111ED · Substantial damage
  > The student pilot’s failure to maintain control of the airplane while landing.
- [NTSB WPR14FA226](https://openairdocs.org/ntsb/WPR14FA226.md): North American AT 6C · Buckley, WA · Accident · 2 fatal · Field investigation · Final report · Jun 4, 2014 · N13372 · Substantial damage
  > The loss of engine power during takeoff initial climb for reasons that could not be determined during a postaccident examination of the airplane.
- [NTSB CEN14FA266](https://openairdocs.org/ntsb/CEN14FA266.md): Yakovlev YAK-55M · Stevens Point, WI · Accident · 1 fatal · Field investigation · Final report · Jun 1, 2014 · N176FD · Substantial damage
  > The pilot's failure to maintain airplane control during the aerobatic flight, which resulted in the airplane exceeding its critical angle of attack and entering an accelerated stall at a low altitude.
- [NTSB WPR14CA216](https://openairdocs.org/ntsb/WPR14CA216.md): Robinson Helicopter R22 Beta · San Manuel, AZ · Accident · No injuries · Data collection · Final report · May 31, 2014 · N7122E · Substantial damage
  > The pilot's failure to maintain an adequate obstacle clearance altitude from phone wires while performing low-level operations.
- [NTSB CEN14FA265](https://openairdocs.org/ntsb/CEN14FA265.md): Cessna 150 · Watkins, CO · Accident · 2 fatal · Field investigation · Final report · May 31, 2014 · N6275G · Substantial damage
  > The pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.
- [NTSB CEN14LA418](https://openairdocs.org/ntsb/CEN14LA418.md): Texas Helicopter OH 13H/M74A · Little Falls, MN · Accident · 1 fatal · Limited investigation · Final report · May 28, 2014 · N51853 · Substantial damage
  > The pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.
- [NTSB ANC14FA030](https://openairdocs.org/ntsb/ANC14FA030.md): Robinson Helicopter R44 II · Chugiak, AK · Accident · 1 fatal · Field investigation · Final report · May 28, 2014 · N392GP · Destroyed
  > The pilot's loss of control of the helicopter due to impairment or incapacitation from a sudden, acute cardiac event.
- [NTSB CEN14LA255](https://openairdocs.org/ntsb/CEN14LA255.md): Air Tractor AT 602 · Gueydan, LA · Accident · 1 fatal · Limited investigation · Final report · May 27, 2014 · N602RR · Substantial damage
  > The pilot's failure to maintain airplane control, which resulted in a stall and subsequent collision with power lines.
- [NTSB ERA14LA261](https://openairdocs.org/ntsb/ERA14LA261.md): Piper PA-11 · Cooperstown, NY · Accident · No injuries · Limited investigation · Final report · May 26, 2014 · N4550M · Substantial damage
  > The pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.
- [NTSB ERA14FA256](https://openairdocs.org/ntsb/ERA14FA256.md): Stolp Starduster SA-300 · Newton, NC · Accident · 1 fatal · Field investigation · Final report · May 26, 2014 · N4493 · Substantial damage
  > The pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=46

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

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

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