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

## Cases, newest first

- [NTSB FTW02FA162](https://openairdocs.org/ntsb/FTW02FA162.md): Cirrus Design SR-20 · Angel Fire, NM · Accident · 1 fatal · Field investigation · Final report · May 28, 2002 · N901CD · Destroyed
  > The pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,
- [NTSB NYC02LA103](https://openairdocs.org/ntsb/NYC02LA103.md): Taylorcraft BC-12D · Roxbury, NY · Accident · No injuries · Limited investigation · Final report · May 27, 2002 · N36322 · Substantial damage
  > The airplane encountering an unanticipated downdraft that exceeded the climb performance of the airplane.
- [NTSB SEA02LA087](https://openairdocs.org/ntsb/SEA02LA087.md): Hanson Rans S6ES · Spanaway, WA · Accident · Serious injuries · Limited investigation · Final report · May 26, 2002 · N654RH · Substantial damage
  > The loss of engine power for undetermined reasons during the climb-out after takeoff. Factors include no suitable terrain upon which to attempt a forced landing, and trees and cars alongside of the residential street that the pilot attempted to land on.
- [NTSB FTW02LA160](https://openairdocs.org/ntsb/FTW02LA160.md): Ercoupe 415-C · Hinton, OK · Accident · Minor injuries · Limited investigation · Final report · May 26, 2002 · N99044 · Substantial damage
  > Fuel exhaustion due to a fuel cap leak. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL02FA107](https://openairdocs.org/ntsb/ATL02FA107.md): Bell 47G-4A · Yauco, PR · Accident · 1 fatal · Field investigation · Final report · May 25, 2002 · N6SR · Destroyed
  > The pilot's failure to apply carburetor heat that resulted in a partial loss of engine power and the subsequent collision with an object during the forced landing. A factor was weather conditions favorable for the formation of carburetor ice.
- [NTSB MIA02FA100](https://openairdocs.org/ntsb/MIA02FA100.md): Bell 206L-1 · Fort Lauderdale, FL · Accident · No injuries · Field investigation · Final report · May 24, 2002 · N80PH · Substantial damage
  > The excessive rate of descent by the pilot-in-command during the autorotative landing resulting in a hard landing, following a total loss of engine power caused by failure of the No. 4 bearing.
- [NTSB LAX02LA174](https://openairdocs.org/ntsb/LAX02LA174.md): Cessna 175 · Anaheim, CA · Accident · No injuries · Limited investigation · Final report · May 24, 2002 · N6713E · Substantial damage
  > the pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.
- [NTSB LAX02LA172](https://openairdocs.org/ntsb/LAX02LA172.md): Cessna 172K · Lake Thomas A., CA · Accident · Serious injuries · Limited investigation · Final report · May 24, 2002 · N79944 · Substantial damage
  > a partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…
- [NTSB ANC02LA040](https://openairdocs.org/ntsb/ANC02LA040.md): Piper PA-32R-300 · Noorvik, AK · Accident · No injuries · Limited investigation · Final report · May 24, 2002 · N9243K · Substantial damage
  > The partial loss of engine power during the climb to cruise for an undetermined reason, which resulted in a forced landing in soft terrain. A factor associated in the accident was the lack of suitable terrain for the forced landing.
- [NTSB SEA02FA085](https://openairdocs.org/ntsb/SEA02FA085.md): Robinson R-22 Mariner · Merlin, OR · Accident · 2 fatal · Field investigation · Final report · May 23, 2002 · N2322Y · Substantial damage
  > Clearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.
- [NTSB ATL02LA103](https://openairdocs.org/ntsb/ATL02LA103.md): Mooney M20J · Charleston, SC · Accident · Minor injuries · Limited investigation · Final report · May 23, 2002 · N4560H · Substantial damage
  > Total loss of engine power due to oil system starvation. A factor was the transmission wire encountered during emergency descent.
- [NTSB NYC02IA100](https://openairdocs.org/ntsb/NYC02IA100.md): Dornier 328-300 · Albany, NY · Incident · No injuries · Incident investigation · Final report · May 22, 2002 · N421FJ · No damage
  > Rudder oscillations of an undetermined origin.
- [NTSB LAX02FA173](https://openairdocs.org/ntsb/LAX02FA173.md): Robinson R22 Beta · Mammoth Lakes, CA · Accident · 2 fatal · Field investigation · Final report · May 22, 2002 · N7194J · Destroyed
  > The pilot's poor decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were rising mountainous terrain, the high density altitude, and the exceeded weight and…
- [NTSB FTW02LA159](https://openairdocs.org/ntsb/FTW02LA159.md): Cessna 172N · Glen Rose, TX · Accident · No injuries · Limited investigation · Final report · May 22, 2002 · N734KG · Substantial damage
  > The pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.
- [NTSB SEA02IA096](https://openairdocs.org/ntsb/SEA02IA096.md): Kaman K-600 (HH-43B) · Cocolalla, ID · Incident · No injuries · Incident investigation · Final report · May 21, 2002 · N286M · No damage
  > The reverse installation of the RPM compensator assembly control box bolts resulting in the threaded end of the bolt impinging on a clevis and jamming the collective during climb. A contributing factor was the lack of adequate documentation provided by the…
- [NTSB CHI02LA137](https://openairdocs.org/ntsb/CHI02LA137.md): Piper PA-28-236 · Angola, IN · Accident · Minor injuries · Limited investigation · Final report · May 19, 2002 · N8442A · Substantial damage
  > The loss of engine power for undetermined reasons. A factor to the accident was the soft terrain condition.
- [NTSB ANC02LA041](https://openairdocs.org/ntsb/ANC02LA041.md): Cessna 180 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · May 18, 2002 · N9024M · Substantial damage
  > A total engine failure during cruise flight due to the disentegration of the number five cylinder piston. A contributing factor in the accident was the lack of suitable terrain for a forced landing.
- [NTSB LAX02FA166](https://openairdocs.org/ntsb/LAX02FA166.md): Socata TB-21 · New River, AZ · Accident · 2 fatal · Field investigation · Final report · May 17, 2002 · N328CG · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition, and the…
- [NTSB FTW02LA153](https://openairdocs.org/ntsb/FTW02LA153.md): Cessna 150M · Godley, TX · Accident · No injuries · Limited investigation · Final report · May 17, 2002 · N50XP · Substantial damage
  > the loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.
- [NTSB ATL02FA101](https://openairdocs.org/ntsb/ATL02FA101.md): Luscombe LL-8-E · Olar, SC · Accident · 2 fatal · Field investigation · Final report · May 17, 2002 · N71344 · Destroyed
  > The in-flight separation of the elevator push-pull control tube that resulted in a loss of flight control and subsequent collision with the ground.
- [NTSB IAD02LA051](https://openairdocs.org/ntsb/IAD02LA051.md): Piper PA-28-151 · Port Columbus, OH · Accident · No injuries · Limited investigation · Final report · May 16, 2002 · N75303 · Substantial damage
  > The pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.
- [NTSB FTW02LA151](https://openairdocs.org/ntsb/FTW02LA151.md): Nolan RV-4 · Jonesboro, AR · Accident · 1 fatal · Limited investigation · Final report · May 15, 2002 · N437BN · Substantial damage
  > The loss of engine power for an undetermined reason.
- [NTSB LAX02FA163](https://openairdocs.org/ntsb/LAX02FA163.md): Cessna T210M · Groveland, CA · Accident · 2 fatal · Field investigation · Final report · May 13, 2002 · N761LX · Destroyed
  > a catastrophic engine failure due to the fatigue fracture and failure of the crankshaft. A factor contributing to the accident was the unsuitable nature of the mountainous terrain for a successful forced landing. The precipitating cause of the fatigue…
- [NTSB LAX02FA162](https://openairdocs.org/ntsb/LAX02FA162.md): Cessna 152 · Livermore, CA · Accident · Minor injuries · Field investigation · Final report · May 13, 2002 · N48512 · Substantial damage
  > A loss of engine power due to the failure of the CFI to apply carburetor heat which resulted in carburetor icing. The unsuitable landing area in mountainous terrain, and carburetor icing conditions were factors.
- [NTSB CHI02LA129](https://openairdocs.org/ntsb/CHI02LA129.md): Cessna 210M · Watertown, MN · Accident · Minor injuries · Limited investigation · Final report · May 11, 2002 · N357TC · Substantial damage
  > The improper fuel management by the pilot which resulted in fuel starvation and subsequent loss of engine power. Contributing to the accident was the soft terrain in which the forced landing was completed.
- [NTSB ATL02LA095](https://openairdocs.org/ntsb/ATL02LA095.md): McDonnell Douglas MD-600N · Deland, FL · Accident · No injuries · Limited investigation · Final report · May 10, 2002 · N810LA · Substantial damage
  > The pilot's failure to follow the FADEC malfunction checklist that resulted in the loss of rotor RPM, and the pilot's improper use of the flight controls during the precautionary landing that resulted in a hard landing. A factor was the malfunction of the…
- [NTSB NYC02IA097](https://openairdocs.org/ntsb/NYC02IA097.md): Bombardier CL600-2B19 · Covington, KY · Incident · No injuries · Incident investigation · Final report · May 8, 2002 · N709CA · No damage
  > The manufacturer's failure to provide inspection criteria for the BPSU compartment aileron control pulleys, which resulted in eventual pulley corrosion, and subsequent control stiffness when seized pulleys and water-soaked aileron cables froze together at…
- [NTSB MIA02IA094](https://openairdocs.org/ntsb/MIA02IA094.md): Boeing B737-448 · Miami, FL · Incident · No injuries · Incident investigation · Final report · May 8, 2002 · EI-BXI · Minor damage
  > Inadequate maintenance by company maintenance personnel and failure to comply with manufacturer recommended maintence procedures (SB 737-55A1070R1), which resulted in an inflight inseparation of a section of the airplane's right hand elevator control tab. A…
- [NTSB NYC02LA092](https://openairdocs.org/ntsb/NYC02LA092.md): Blanik L-13 · Saratoga Spring, NY · Accident · No injuries · Limited investigation · Final report · May 5, 2002 · N711KR · Substantial damage
  > The glider encountering an unanticipated downdraft, which resulted in insufficient altitude to reach a suitable landing area.
- [NTSB IAD02IA046](https://openairdocs.org/ntsb/IAD02IA046.md): Fairchild Dornier DO-328-300 · Atlantic City, NJ · Incident · No injuries · Incident investigation · Final report · May 2, 2002 · N429FJ · No damage
  > The partial loss of flight display information for undetermined reasons.
- [NTSB FTW02LA137](https://openairdocs.org/ntsb/FTW02LA137.md): Cessna 182G · Tuckerman, AR · Accident · Serious injuries · Limited investigation · Final report · May 2, 2002 · N3146S · Substantial damage
  > The pilot's operation of the airplane with a known equipment deficiency, which resulted in fuel leakage and a loss of engine power due to fuel exhaustion. A contributing factors was the lack of suitable terrain for the forced landing.
- [NTSB LAX02LA146](https://openairdocs.org/ntsb/LAX02LA146.md): Boeing 747-422 · Pacific Ocean (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · May 1, 2002 · N182UA · No damage
  > An in-flight encounter with clear air turbulence and wind shear, which resulted in a serious injury to a flight attendant.
- [NTSB MIA02LA092](https://openairdocs.org/ntsb/MIA02LA092.md): Lake LA-4-200 · Headland, AL · Accident · No injuries · Limited investigation · Final report · Apr 30, 2002 · N3121P · Substantial damage
  > a loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.
- [NTSB LAX02FA148](https://openairdocs.org/ntsb/LAX02FA148.md): Beech C23 · Oak Shores, CA · Accident · 3 fatal · Field investigation · Final report · Apr 28, 2002 · N9180S · Destroyed
  > the number 1 cylinder exhaust valve fractured and separated resulting in a loss of engine power and an off airport forced landing. A finding in the accident was the owner's failure to maintain the engine in accordance with the manufacturer's recommendations.
- [NTSB DEN02LA040](https://openairdocs.org/ntsb/DEN02LA040.md): Cessna TR182 · Kersey, CO · Accident · No injuries · Limited investigation · Final report · Apr 28, 2002 · N787PC · Substantial damage
  > The pilot's inadequate planning decision which led to fuel exhaustion and subsequent loss of engine power.
- [NTSB LAX02FA144](https://openairdocs.org/ntsb/LAX02FA144.md): Cessna 177B · Fullerton, CA · Accident · Minor injuries · Field investigation · Final report · Apr 26, 2002 · N177DP · Destroyed
  > The total loss of engine power during cruise flight resulting from oil exhaustion. The oil exhaustion resulted from deterioration and total failure of the oil filter converter plate gasket, which had not been replaced due to maintenance personnel's failure to…
- [NTSB SEA02LA073](https://openairdocs.org/ntsb/SEA02LA073.md): Hiller UH-12E · Goshen, OR · Accident · No injuries · Limited investigation · Final report · Apr 22, 2002 · N3004T · Substantial damage
  > The failure of company maintenance personnel to identify and replace/repair the degraded exhaust stack. Contributing factors were the mis-rigged carburetor heat control and the pilot's failure to maintain appropriate rotor RPM. Additional contributing factors…
- [NTSB NYC02LA088](https://openairdocs.org/ntsb/NYC02LA088.md): Boeing 767-224 · Atlantic Ocean · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 2002 · N68160 · No damage
  > The airplane's inadvertent encounter which clear air turbulence during cruise flight.
- [NTSB CHI02IA116](https://openairdocs.org/ntsb/CHI02IA116.md): Beech 200 · Hillsdale, WI · Incident · No injuries · Incident investigation · Final report · Apr 22, 2002 · N26SJ · Minor damage
  > The fatigue failure of the passenger/crew door latch pin during cruise flight.
- [NTSB SEA02LA069](https://openairdocs.org/ntsb/SEA02LA069.md): Woodley Zodiac 601HD · Beaver, OR · Accident · No injuries · Limited investigation · Final report · Apr 18, 2002 · N9240W · Substantial damage
  > A partial failure of the electrical (ignition) system and a short to the master electrical switch during cruise flight resulting in a loss of engine power. A collision with an embankment during the landing roll was a factor.
- [NTSB MIA02LA085](https://openairdocs.org/ntsb/MIA02LA085.md): Grote Cruiser TR-4 · Pembroke Pines, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 18, 2002 · N98WG · Destroyed
  > the pilot-in-command delayed initiating a go-around and failed to obtain sufficient altitude to clear obstacles at the departure end of the airport which resulted in an in-flight collision with power lines.
- [NTSB FTW02LA125](https://openairdocs.org/ntsb/FTW02LA125.md): Howard Harder Skybolt · Claremore, OK · Accident · 1 fatal · Limited investigation · Final report · Apr 18, 2002 · N16HH · Destroyed
  > The failure of the pilot to maintain clearance with terrain for undetermined reasons while conducting aerobatic maneuvers. A factor contributing to the accident was the physical impairment of the pilot.
- [NTSB CHI02LA111](https://openairdocs.org/ntsb/CHI02LA111.md): Boeing 757-200 · Springfield, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 2002 · N516AT · No damage
  > The flightcrew's failure to follow weather avoidance prcedures and their delay in activating the seat belt sign. Factors were the turbulent thunderstorm weather conditions, and the failure of the National Weather Service to issue an applicable in-flight…
- [NTSB CHI02LA108](https://openairdocs.org/ntsb/CHI02LA108.md): Long FEW TF-51 · Summersville, MO · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2002 · N51HL · Substantial damage
  > The unsuitable terrain encountered during the power off landing. The loss of engine power for unknown reasons was a contributing factor.
- [NTSB LAX02LA136](https://openairdocs.org/ntsb/LAX02LA136.md): Cessna 172 · Lake Los Angele, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2002 · N211CA · Substantial damage
  > a reconditioned engine cylinder barrel failure due to previous rust damage and improper maintenance practices.
- [NTSB CHI02LA104](https://openairdocs.org/ntsb/CHI02LA104.md): Hoagland Varieze · Gary, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 2002 · N97JW · Substantial damage
  > The pilot was unable to maintain directional control of the airplane during the forced landing due to a locked brake. Factors associated with the accident were the pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion and the…
- [NTSB ATL02LA084](https://openairdocs.org/ntsb/ATL02LA084.md): Cessna 150D · Chatsworth, GA · Accident · No injuries · Limited investigation · Final report · Apr 14, 2002 · N4449U · Substantial damage
  > The pilot's failure to apply carburetor heat that resulted in the loss of engine power. Factors were conditions favorable for the formation of carburetor icing and the selection of unsuitable terrain for a forced landing.
- [NTSB ANC02LA030](https://openairdocs.org/ntsb/ANC02LA030.md): Aeronca 15AC · Sitka, AK · Accident · No injuries · Limited investigation · Final report · Apr 14, 2002 · N1272H · Substantial damage
  > A loss of engine power during cruise flight for an undertermined reason. A factor in the accident was rough/uneven beach terrain at the site of the forced landing.
- [NTSB FTW02LA119](https://openairdocs.org/ntsb/FTW02LA119.md): Cessna TR182 · Cypress, TX · Accident · No injuries · Limited investigation · Final report · Apr 11, 2002 · N9321R · Substantial damage
  > the total loss of engine power as a result of oil starvation due to a missing oil filler cap, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW02LA117](https://openairdocs.org/ntsb/FTW02LA117.md): Bell 206B · Walnut Hill, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2002 · N513FD · Substantial damage
  > The loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…

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

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

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