# NTSB investigations: Enroute

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 173 of 718 · 35,885 cases

## Cases, newest first

- [NTSB IAD00LA057](https://openairdocs.org/ntsb/IAD00LA057.md): Cessna 172G · North Elba, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2000 · N4198L · Substantial damage
  > the pilot's inaccurate fuel consumption calculations and exhaustion of his fuel supply.
- [NTSB FTW00LA204](https://openairdocs.org/ntsb/FTW00LA204.md): Cessna 402A · Del City, TX · Accident · No injuries · Limited investigation · Final report · Jul 8, 2000 · N402NA · Substantial damage
  > the total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…
- [NTSB CHI00FA185](https://openairdocs.org/ntsb/CHI00FA185.md): Piper PA-30 · Duluth, MN · Accident · 3 fatal · Field investigation · Final report · Jul 8, 2000 · N7213Y · Destroyed
  > loss of control in flight for undetermined reason(s).
- [NTSB LAX00LA258](https://openairdocs.org/ntsb/LAX00LA258.md): Cessna 205 · Tacna, AZ · Accident · No injuries · Limited investigation · Final report · Jul 5, 2000 · N8154Z · Substantial damage
  > The piston and rings in cylinder No. 1 failed resulting in a total loss of engine power. The pilot made a forced landing on a road and the airplane's wing collided with a road sign.
- [NTSB LAX00LA250](https://openairdocs.org/ntsb/LAX00LA250.md): Thorp T211 · Grass Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 2000 · N91313 · Substantial damage
  > the pilot encountered a mountain wave at an altitude too low to maintain clearance from trees.
- [NTSB CHI00LA188](https://openairdocs.org/ntsb/CHI00LA188.md): Schleicher ASW-20L · Gregory, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 2000 · N4804W · Substantial damage
  > the control stick movement being restricted by the pilot's seat-type parachute and the excessive descent rate and airspeed during landing. A factor to the accident was the pilot's lack of familiarity with the aircraft.
- [NTSB ANC00FA082](https://openairdocs.org/ntsb/ANC00FA082.md): Cessna 172S · Whittier, AK · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2000 · N862SP · Destroyed
  > Suicide.
- [NTSB MIA00LA196](https://openairdocs.org/ntsb/MIA00LA196.md): Gulfstream American AA5A · Selma, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2000 · N26937 · Substantial damage
  > The improper installation of the engine front crankshaft seal by maintenance personnel resulting in the seal separating, total loss of engine oil, failure of the engine due to oil starvation, and a collision with trees while making a forced landing on…
- [NTSB SEA00LA121](https://openairdocs.org/ntsb/SEA00LA121.md): Fairchild Hiller FH-1100 · West Linn, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 2000 · N2784D · Substantial damage
  > Improper maintenance (excessive/improper sealant application) by an unknown person, and subsequent fracture of the spur adapter gearshaft resulting in a total loss of engine power. Factors included foreign material/substance in the engine oil, a blocked oil…
- [NTSB MIA00TA200](https://openairdocs.org/ntsb/MIA00TA200.md): Hughes 369D · Destin, FL · Accident · No injuries · Final report · Jul 2, 2000 · N88MP · Substantial damage
  > improper maintenance inspection of the tail rotor by maintenance personnel and improper preflight inspection of the tail rotor by the pilot, which resulted in worn elastomeric bearings being continued in service, resulting in failure of the tail rotor…
- [NTSB CHI00FA180](https://openairdocs.org/ntsb/CHI00FA180.md): Cessna 152 · Brownton, MN · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2000 · N757SL · Destroyed
  > In flight collision with the terrain for undetermined reason.
- [NTSB MIA00LA204](https://openairdocs.org/ntsb/MIA00LA204.md): Spurgeon Avid Bandit · Columbus, MS · Accident · No injuries · Limited investigation · Final report · Jul 1, 2000 · N60698 · Substantial damage
  > the owner/builder's improper installation that resulted in the fuel line being snagged, resulting in fuel starvation and an inflight loss of engine power and subsequent damage to the airplane during the forced landing.
- [NTSB DEN00IA133](https://openairdocs.org/ntsb/DEN00IA133.md): Diamond Aircraft Industries 20C-1 · Spanish Fork, UT · Incident · No injuries · Incident investigation · Final report · Jul 1, 2000 · N991CT · Minor damage
  > The company maintenance personnel's inadequate torquing procedures of the propeller attachment bolts which resulted in the fatigue failure of the propeller attachment bolts and the in-flight separation of the propeller.
- [NTSB CHI00LA179](https://openairdocs.org/ntsb/CHI00LA179.md): Norton Volksplane VP-1 · Waconia, MN · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 2000 · N256DN · Destroyed
  > the inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.
- [NTSB SEA00LA119](https://openairdocs.org/ntsb/SEA00LA119.md): Piper PA-28-140 · Kennewick, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2000 · N6887W · Substantial damage
  > A failure in the engine's number 1 piston, resulting in a total loss of engine power. Factors included the aircraft windshield being covered with oil (restricting forward visibility), a road sign, and a ditch beside the road on which the forced landing was…
- [NTSB MIA00LA199](https://openairdocs.org/ntsb/MIA00LA199.md): Bellanca 17-30A · Albany, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2000 · N8787V · Substantial damage
  > The dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…
- [NTSB MIA00LA195](https://openairdocs.org/ntsb/MIA00LA195.md): Cessna 402C · Naples, FL · Accident · No injuries · Limited investigation · Final report · Jun 30, 2000 · N7037E · Substantial damage
  > an inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.
- [NTSB CHI00LA211](https://openairdocs.org/ntsb/CHI00LA211.md): Piper PA-36-285 · Saint Vincent, MN · Accident · No injuries · Limited investigation · Final report · Jun 30, 2000 · N11A · Substantial damage
  > the failure of the engine reduction gear assembly. Factors were the low altitude when the failure occurred and the crops.
- [NTSB LAX00LA245](https://openairdocs.org/ntsb/LAX00LA245.md): Garlick HH-1K · Live Oak, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 29, 2000 · N896RP · Destroyed
  > The inadequate lubrication of the tail rotor drive shaft coupling by unknown maintenance personnel that resulted in the in-flight failure and separation of the helicopter's tail boom.
- [NTSB LAX00LA244](https://openairdocs.org/ntsb/LAX00LA244.md): Cessna 182K · Mayer, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2000 · N3094Q · Substantial damage
  > the total loss of engine power resulting from the mechanic's failure to properly torque the connecting rod bolt nuts during engine overhaul.
- [NTSB CHI00LA176](https://openairdocs.org/ntsb/CHI00LA176.md): Beech B200 · Joliet, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2000 · N780CA · Substantial damage
  > the failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.
- [NTSB DEN00FA119](https://openairdocs.org/ntsb/DEN00FA119.md): Cessna 172H · Angel Fire, NM · Accident · 2 fatal · Field investigation · Final report · Jun 26, 2000 · N2526L · Destroyed
  > The pilot's improper inflight decision to prematurely attempt a climb towards rising terrain before sufficient altitude had been attained that would assure adequate obstacle clearance. Factors were high density altitude and trees.
- [NTSB CHI00FA171](https://openairdocs.org/ntsb/CHI00FA171.md): Cessna 210J · Sumner, IA · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2000 · N3396S · Destroyed
  > failure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.
- [NTSB ATL00LA073](https://openairdocs.org/ntsb/ATL00LA073.md): Piper PA-30 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Jun 24, 2000 · N8629Y · Substantial damage
  > A landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.
- [NTSB ATL00LA066](https://openairdocs.org/ntsb/ATL00LA066.md): Cessna 172N · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Jun 24, 2000 · N738WD · Substantial damage
  > Loss of engine power for undetermined reasons. A factor was the pilot failed to use carburetor heat during the descent.
- [NTSB NYC00LA174](https://openairdocs.org/ntsb/NYC00LA174.md): Enstrom 280 FX · Springdale, OH · Accident · No injuries · Limited investigation · Final report · Jun 23, 2000 · N383MA · Substantial damage
  > The pilot's inadequate preflight of the helicopter, and his subsequent failure to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain.
- [NTSB MIA00FA190](https://openairdocs.org/ntsb/MIA00FA190.md): Learjet 55 · Boca Raton, FL · Accident · 4 fatal · Field investigation · Final report · Jun 23, 2000 · N220JC · 2 aircraft · Destroyed
  > The failure of the pilot's of both airplanes to maintain a visual lookout (while climbing and maneuvering) resulting in an in-flight collision and subsequent collision with residences and terrain.
- [NTSB LAX00LA260](https://openairdocs.org/ntsb/LAX00LA260.md): Cessna 172N · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 2000 · N7598D · Substantial damage
  > The loss of engine power during the initial takeoff climb, at too low an altitude to afford remedial action, because of an ingested valve, and the airplane's subsequent collision with the ground adjacent to the runway.
- [NTSB LAX00LA238](https://openairdocs.org/ntsb/LAX00LA238.md): Ward Sidewinder · Madera, CA · Accident · No injuries · Limited investigation · Final report · Jun 21, 2000 · N4119Q · Substantial damage
  > The pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.
- [NTSB LAX00LA237](https://openairdocs.org/ntsb/LAX00LA237.md): Cessna 150M · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Jun 21, 2000 · N704QJ · Substantial damage
  > The inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…
- [NTSB ANC00LA073](https://openairdocs.org/ntsb/ANC00LA073.md): Blanc Glastar · Northway, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 2000 · N2623B · Destroyed
  > The pilot's continued flight into known adverse weather. A factor associated with the accident were low clouds.
- [NTSB LAX00LA235](https://openairdocs.org/ntsb/LAX00LA235.md): Piper PA-28-180 · Selma, CA · Accident · No injuries · Limited investigation · Final report · Jun 20, 2000 · N32322 · Substantial damage
  > The pilot's inadequate preflight planning that resulted in fuel exhaustion and subsequent collision with grapevines during an off airport forced landing.
- [NTSB ANC00GA071](https://openairdocs.org/ntsb/ANC00GA071.md): Cessna 185E · Talkeetna, AK · Accident · 4 fatal · Final report · Jun 20, 2000 · N1589F · Destroyed
  > The pilot's continued flight into known adverse weather conditions and subsequent in-flight break-up. Factors in the accident were weather conditions consisting of low ceilings, turbulence, and an occluded front with convective activity, and inadequate…
- [NTSB FTW00LA182](https://openairdocs.org/ntsb/FTW00LA182.md): Cessna 152 · Mcallen, TX · Accident · No injuries · Limited investigation · Final report · Jun 19, 2000 · N94290 · Substantial damage
  > Loss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA00IA108](https://openairdocs.org/ntsb/SEA00IA108.md): Douglas DC-8-73 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jun 17, 2000 · N831AL · No damage
  > Auxiliary hydraulic pump leak resulting in a failure of the hydraulic system.
- [NTSB DEN00LA113](https://openairdocs.org/ntsb/DEN00LA113.md): Enstrom 280CB · Ruidoso, NM · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 2000 · N440RB · Substantial damage
  > the loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight planning. A contributing factor was the pilot's lack of experience in the model of helicopter.
- [NTSB NYC00LA164](https://openairdocs.org/ntsb/NYC00LA164.md): Cessna 210 · Louisville, KY · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2000 · N485CA · Substantial damage
  > The pilot's improper operation of the fuel selector.
- [NTSB IAD00LA052](https://openairdocs.org/ntsb/IAD00LA052.md): Hughes 269A · Mansfield, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2000 · N9014N · Substantial damage
  > The pilot's failure to comply with published emergency procedures. A factor in the accident was the pilot's inadequate preflight planning which resulted in a take-off with the inadequate amount of fuel for the flight.
- [NTSB LAX00LA225](https://openairdocs.org/ntsb/LAX00LA225.md): Cessna 152 · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Jun 14, 2000 · N67608 · Substantial damage
  > The pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.
- [NTSB FTW00LA179](https://openairdocs.org/ntsb/FTW00LA179.md): Ayres S2R-T34 · Helena, AR · Accident · 1 fatal · Limited investigation · Final report · Jun 13, 2000 · N3096Z · Destroyed
  > The pilot's failure to maintain clearance with the power lines.
- [NTSB CHI00LA159](https://openairdocs.org/ntsb/CHI00LA159.md): Cessna 150M · Bethalto, IL · Accident · No injuries · Limited investigation · Final report · Jun 11, 2000 · N66081 · Destroyed
  > the improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.
- [NTSB SEA00LA102](https://openairdocs.org/ntsb/SEA00LA102.md): Cessna 182H · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2000 · N8321S · Substantial damage
  > The pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…
- [NTSB NYC00IA159](https://openairdocs.org/ntsb/NYC00IA159.md): British Aerospace BAE Jetstream 3201 · Lexington, KY · Incident · No injuries · Incident investigation · Final report · Jun 9, 2000 · N914AE · Minor damage
  > A misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.
- [NTSB CHI00LA156](https://openairdocs.org/ntsb/CHI00LA156.md): Piper PA-28-181 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jun 9, 2000 · N4142F · Substantial damage
  > The improper in-flight decision of the pilot not to land at the nearest airport at the first loss of engine power. Factors to the accident were fuel exhaustion, the excessive fuel flow, and the airport perimeter fence.
- [NTSB ATL00LA062](https://openairdocs.org/ntsb/ATL00LA062.md): Daniel J. Zoerb Kitfox · Spruce Pine, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 2000 · N715DZ · Substantial damage
  > A total loss of engine power due to carburetor icing conditions. A factor was the mountainous, unsuitable terrain on which to make a forced landing.
- [NTSB ANC00LA066](https://openairdocs.org/ntsb/ANC00LA066.md): Piper PA-18-150 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Jun 9, 2000 · N9739P · Substantial damage
  > The pilot's improper positioning of the fuel tank selector, and fuel starvation. A factor in the accident was the improper service of the airplane's hydraulic brake system.
- [NTSB LAX00LA222](https://openairdocs.org/ntsb/LAX00LA222.md): Mooney M20D · Baker, CA · Accident · No injuries · Limited investigation · Final report · Jun 8, 2000 · N31M · Substantial damage
  > The fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…
- [NTSB FTW00LA202](https://openairdocs.org/ntsb/FTW00LA202.md): Piper PA-28-235 · Sugar Land, TX · Accident · No injuries · Limited investigation · Final report · Jun 8, 2000 · N9407W · Substantial damage
  > The pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN00LA105](https://openairdocs.org/ntsb/DEN00LA105.md): Froelich Lancair IV · Bountiful, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 2000 · N493K · Substantial damage
  > The loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.
- [NTSB FTW00LA176](https://openairdocs.org/ntsb/FTW00LA176.md): Bellanca 17-31ATC · Del Rio, TX · Accident · No injuries · Limited investigation · Final report · Jun 7, 2000 · N39827 · Substantial damage
  > The separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=174

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

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

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