# 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 129 of 378 · 18,851 cases

## Cases, newest first

- [NTSB ATL97LA011](https://openairdocs.org/ntsb/ATL97LA011.md): Grumman G-164B · Abbeyville, AL · Accident · No injuries · Limited investigation · Final report · Oct 31, 1996 · N6756K · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB SEA97LA022](https://openairdocs.org/ntsb/SEA97LA022.md): Collier Q200 · Estacada, OR · Accident · 1 fatal · Limited investigation · Final report · Oct 29, 1996 · N200CQ · Substantial damage
  > inadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…
- [NTSB CHI97LA016](https://openairdocs.org/ntsb/CHI97LA016.md): Hughes 369 · Vestaburg, MI · Accident · 1 fatal · Limited investigation · Final report · Oct 28, 1996 · N9251F · Substantial damage
  > failure of the pilot to maintain clearance with the wires.
- [NTSB NYC97FA011](https://openairdocs.org/ntsb/NYC97FA011.md): Yakovlev YAK-18T · Berlin, NJ · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1996 · N9418 · Destroyed
  > an inadequate preflight by unknown person(s), sometime before the flight, by failing to avoid a hydraulic lock (from oil seepage) in the #5 cylinder, which resulted in a bent connecting rod, subsequent failure of the #5 piston, and loss of engine power. Also…
- [NTSB MIA97LA012](https://openairdocs.org/ntsb/MIA97LA012.md): Air Tractor 400 · Sylvester, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1996 · N73080 · Substantial damage
  > Was the pilots intentional disregard for operating the engine contrary to the flight manuals for intentionally exceeding the maximum engine temperature, resulting in creep failure of one of the compressor turbine blades.
- [NTSB FTW97LA019](https://openairdocs.org/ntsb/FTW97LA019.md): Air Tractor AT-502 · Throckmorton, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1996 · N4549Z · Destroyed
  > failure of the pilot to maintain clearance of a transmission wire during pullup from a swath run. The proximity of the transmission wire was a related factor. The installation of wire cutter equipment on the landing gear might have prevented or reduced the…
- [NTSB LAX97LA014](https://openairdocs.org/ntsb/LAX97LA014.md): Cunningham Rotorway Exec · Mather, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 13, 1996 · N18WC · Destroyed
  > excessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.
- [NTSB IAD97LA006](https://openairdocs.org/ntsb/IAD97LA006.md): Piper J3C-65 · Springfield, OH · Accident · 1 fatal · Limited investigation · Final report · Oct 13, 1996 · N42719 · Substantial damage
  > failure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.
- [NTSB ATL97LA002](https://openairdocs.org/ntsb/ATL97LA002.md): Bell UH-IB · Bennettsville, SC · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1996 · N846MC · Destroyed
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of usable fuel. A factor relating to the accident was: an inoperative left boost pump, which increased the amount of unusable fuel…
- [NTSB SEA97LA011](https://openairdocs.org/ntsb/SEA97LA011.md): Aero Vodochody Aero. Works L-29 · Tillamook, OR · Accident · 2 fatal · Limited investigation · Final report · Oct 11, 1996 · N7150A · Destroyed
  > failure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.
- [NTSB SEA97GA008](https://openairdocs.org/ntsb/SEA97GA008.md): Piper PA-18-150 · Holden, UT · Accident · 2 fatal · Final report · Oct 10, 1996 · N91017 · Destroyed
  > The first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…
- [NTSB CHI97LA004](https://openairdocs.org/ntsb/CHI97LA004.md): Bell 47G-5 · Nunda, SD · Accident · No injuries · Limited investigation · Final report · Oct 6, 1996 · N7925J · Substantial damage
  > failure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.
- [NTSB CHI97LA003](https://openairdocs.org/ntsb/CHI97LA003.md): Piper PA-16 · Silver Lake, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 1996 · N5749H · Destroyed
  > fuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.
- [NTSB NYC97LA001](https://openairdocs.org/ntsb/NYC97LA001.md): Cessna 172 · Coudersport, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1996 · N5154E · Destroyed
  > the pilot's improper in-flight planning/decision, and his failure to ensure that adequate airspeed would be maintained, while maneuvering at low altitude to photograph a residence. The rising terrain and lack of altitude were related factors.
- [NTSB FTW97LA009](https://openairdocs.org/ntsb/FTW97LA009.md): Young Cozy MK IV · Pueblo, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1996 · N96PJ · Substantial damage
  > the pilot/builder's improper design change which resulted in a loss of control following an intentional stall. A factor was an erroneous weight-and-balance calculation.
- [NTSB FTW97FA002](https://openairdocs.org/ntsb/FTW97FA002.md): Bell EAA Biplane P · Manzanola, CO · Accident · 1 fatal · Field investigation · Final report · Oct 2, 1996 · N145DB · Destroyed
  > failure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.
- [NTSB MIA96TA236](https://openairdocs.org/ntsb/MIA96TA236.md): Bell 206B III · Flamingo, FL · Accident · No injuries · Final report · Sep 30, 1996 · N2113Z · Substantial damage
  > the wire strike protection guide became entangled in a mangrove branch which resulted in helicopter control not being maintained.
- [NTSB MIA96LA235](https://openairdocs.org/ntsb/MIA96LA235.md): Bell 47G-3B-1 · Borinquen, PR · Accident · No injuries · Limited investigation · Final report · Sep 29, 1996 · N1397X · Substantial damage
  > the pilot failed to maintain control of the aircraft while hover taxing. Factors in this accident were wind gusts and a tailwind.
- [NTSB MIA96LA234](https://openairdocs.org/ntsb/MIA96LA234.md): Piper PA-31-310 · Wassau Island, GA · Accident · No injuries · Limited investigation · Final report · Sep 27, 1996 · N151JP · Substantial damage
  > the pilot's inadequate preflight and planning which resulted in fuel exhaustion.
- [NTSB SEA96LA220](https://openairdocs.org/ntsb/SEA96LA220.md): Ralph Taylor Royal T · Kent, WA · Accident · No injuries · Limited investigation · Final report · Sep 25, 1996 · N2554 · Substantial damage
  > in-flight collision with an unknown object.
- [NTSB MIA96LA232](https://openairdocs.org/ntsb/MIA96LA232.md): Air Tractor 402 · Slocomb, AL · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 1996 · N9130M · Destroyed
  > The pilot's failure to maintain airspeed.
- [NTSB FTW96TA400](https://openairdocs.org/ntsb/FTW96TA400.md): Cessna T188C · Snyder, TX · Accident · No injuries · Final report · Sep 24, 1996 · N9537J · Substantial damage
  > The pilot's failure to maintain clearance with a pole resulting in the separation of the left aileron and a loss of aircraft control. A factor was the haze.
- [NTSB IAD96LA151](https://openairdocs.org/ntsb/IAD96LA151.md): Cessna 150C · Liberty, KY · Accident · 1 fatal · Limited investigation · Final report · Sep 23, 1996 · N1947Z · Destroyed
  > the pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.
- [NTSB CHI96LA344](https://openairdocs.org/ntsb/CHI96LA344.md): Rozendaal Smith Innovation · Hampton, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1996 · N2982 · Substantial damage
  > the pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.
- [NTSB LAX96LA342](https://openairdocs.org/ntsb/LAX96LA342.md): Bell 206B · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Sep 21, 1996 · N909CM · Substantial damage
  > the pilot's improper in-flight planning/decision to turn right instead of left.
- [NTSB LAX96FA340](https://openairdocs.org/ntsb/LAX96FA340.md): Piper PA-28-181 · Caliente, CA · Accident · 3 fatal · Field investigation · Final report · Sep 21, 1996 · N2393W · Destroyed
  > improper in-flight planning/decision by the flight instructor (CFI) by allowing the airplane to flying into a box canyon area, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with wooded terrain. The CFI's…
- [NTSB ATL96LA130](https://openairdocs.org/ntsb/ATL96LA130.md): Air Tractor 402 · Mayersville, MS · Accident · 1 fatal · Limited investigation · Final report · Sep 21, 1996 · N1517G · Substantial damage
  > the pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…
- [NTSB SEA96LA216](https://openairdocs.org/ntsb/SEA96LA216.md): Piper PA-18 · Gillette, WY · Accident · 1 fatal · Limited investigation · Final report · Sep 19, 1996 · N8789C · Substantial damage
  > failure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.
- [NTSB ATL96LA129](https://openairdocs.org/ntsb/ATL96LA129.md): Bell 47G-4A (Soloy) · Belmont, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1996 · N23PH · Substantial damage
  > failure of the aft universal joint of the tail rotor drive shaft, due to inadequate lubrication by company maintenance personnel. A factor relating to the accident was the pilot's delay in discontinuing the flight after noting a progressively worse tail rotor…
- [NTSB SEA96FA214](https://openairdocs.org/ntsb/SEA96FA214.md): Mudry CAP 10B · Fairchild Afb, WA · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1996 · N25AK · Destroyed
  > loss of control due to a jammed aileron pushpull tube, due to improper installation/routing of electrical wire bundles through the right aileron bellcrank mechanism by unknown person(s).
- [NTSB SEA96TA213](https://openairdocs.org/ntsb/SEA96TA213.md): Bell 206B-3 · St Regis, MT · Accident · No injuries · Final report · Sep 13, 1996 · N47MA · Substantial damage
  > failure of the pilot to maintain clearance from electrical transmission lines. The proximity of transmission lines was a related factor.
- [NTSB ANC96FA158](https://openairdocs.org/ntsb/ANC96FA158.md): Champion 7EC · May Creek, AK · Accident · 2 fatal · Field investigation · Final report · Sep 13, 1996 · N9061B · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering and/or flying at low altitude, which resulted in a stall and collision with the terrain. A factor relating to the accident was: the pilot allowed the weight and balance (aft…
- [NTSB FTW96TA383](https://openairdocs.org/ntsb/FTW96TA383.md): Bell 47G-3B-1 · Rangely, CO · Accident · No injuries · Final report · Sep 10, 1996 · N1335X · Substantial damage
  > the pilot's excessive cyclic control input during a low altitude operation, and his failure to maintain altitude/clearance from high vegetation (sage brush). The proximity of high vegetation was a related factor.
- [NTSB FTW97LA029](https://openairdocs.org/ntsb/FTW97LA029.md): Piper PA-36-300 · Stanton, TX · Accident · No injuries · Limited investigation · Final report · Sep 8, 1996 · N57871 · Substantial damage
  > Pilot's failure to maintain clearance with a wire resulting in the separation of the rudder and a loss of aircraft control.
- [NTSB CHI96FA332](https://openairdocs.org/ntsb/CHI96FA332.md): Taylorcraft BC-12D · Bellaire, MI · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1996 · N43687 · Substantial damage
  > the pilot's improper remedial action, while recovering from an intentional stall, which resulted in an inadvertent spin and collision with the terrain. The lack of altitude for recovery was a related factor.
- [NTSB ANC96FA149](https://openairdocs.org/ntsb/ANC96FA149.md): Champion 7GCBC · Glennallen, AK · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1996 · N88359 · Substantial damage
  > failure of the pilot to maintain adequate airspeed, while maneuvering a low altitude, which resulted in an inadvertent stall and an uncontrolled collision with the terrain. A factor related to the accident was: the pilot's use of a medication with sedative…
- [NTSB SEA96LA211](https://openairdocs.org/ntsb/SEA96LA211.md): Cessna 172M · Pacific City, OR · Accident · No injuries · Limited investigation · Final report · Sep 7, 1996 · N12382 · Substantial damage
  > the pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.
- [NTSB MIA96LA226](https://openairdocs.org/ntsb/MIA96LA226.md): Air Tractor 301 · St Clair, AL · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 1996 · N8563S · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to ground.
- [NTSB SEA96TA207](https://openairdocs.org/ntsb/SEA96TA207.md): Bell 206L-3 · Sheridan, WY · Accident · Minor injuries · Final report · Sep 4, 1996 · N253EV · Substantial damage
  > the pilot's improper in-flight planning/decision, concerning maneuvers to position the helicopter for aerial application; and inadvertent loss of tail rotor effectiveness, which resulted in loss of directional control and subsequent collision with the…
- [NTSB ANC96LA145](https://openairdocs.org/ntsb/ANC96LA145.md): Taylorcraft F21B · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1996 · N4417P · Substantial damage
  > the pilot's improper fuel managment, which resulted in loss of engine power due to fuel exhaustion.
- [NTSB FTW96LA371](https://openairdocs.org/ntsb/FTW96LA371.md): Air Tractor AT-301 · Meadow, TX · Accident · No injuries · Limited investigation · Final report · Sep 3, 1996 · N3166H · Substantial damage
  > The pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.
- [NTSB ANC96FA141](https://openairdocs.org/ntsb/ANC96FA141.md): Cessna 172 · Eagle River, AK · Accident · 3 fatal · Field investigation · Final report · Sep 3, 1996 · N8739B · Destroyed
  > The first pilot's failure to maintain sufficient distance/altitude from terrain. A box canyon and mountainous terrain are factors in the accident.
- [NTSB NYC96LA179](https://openairdocs.org/ntsb/NYC96LA179.md): Piper J-3 · Wildwood, NJ · Accident · No injuries · Limited investigation · Final report · Sep 2, 1996 · N92085 · Substantial damage
  > The pilot's failure to maintain sufficient altitude during a low altitude maneuver.
- [NTSB CHI96LA325](https://openairdocs.org/ntsb/CHI96LA325.md): Karr Titan Tornado · Union Pier, MI · Accident · 1 fatal · Limited investigation · Final report · Sep 1, 1996 · N238PW · Destroyed
  > the pilot not obtaining/maintaining altitude/clearance. Factors were the pilot not maintaining aircraft control and intentional aerobatics.
- [NTSB FTW96GA365](https://openairdocs.org/ntsb/FTW96GA365.md): Piper PA-23-250 · Jennings, LA · Accident · 2 fatal · Final report · Aug 31, 1996 · N14196 · Destroyed
  > The pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.
- [NTSB FTW96LA372](https://openairdocs.org/ntsb/FTW96LA372.md): Hardie KIT FOX XL · Monticello, AR · Accident · No injuries · Limited investigation · Final report · Aug 30, 1996 · N42JH · Substantial damage
  > the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA370](https://openairdocs.org/ntsb/FTW96LA370.md): Air Tractor AT-401 · Plains, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1996 · N1558N · Substantial damage
  > failure of the pilot to maintain control of the airplane, while maneuvering after a swath run, which subsequently resulted in a collision with the terrain. A factor relating to the accident was: the adverse wind condition (gusty wind and possible windshear).
- [NTSB MIA96LA219](https://openairdocs.org/ntsb/MIA96LA219.md): Flightstar 2SL · Kiln, MS · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1996 · UNREG · Substantial damage
  > failure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.
- [NTSB FTW96LA363](https://openairdocs.org/ntsb/FTW96LA363.md): Cessna 150M · Oklahoma City, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1996 · N9253U · Substantial damage
  > the student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…
- [NTSB CHI96LA319](https://openairdocs.org/ntsb/CHI96LA319.md): Piper PA-28-161 · Pittsburg, KS · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1996 · N47558 · Substantial damage
  > the pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.

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

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

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