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

## Cases, newest first

- [NTSB ATL04LA105](https://openairdocs.org/ntsb/ATL04LA105.md): Cessna 182A · Elberta, AL · Accident · Minor injuries · Limited investigation · Final report · May 1, 2004 · N5099D · Substantial damage
  > The loss of engine power due to a foreign substance blockage of the fuel line which resulted in fuel starvation, and the pilot's failure to maintain terrain clearance during an aborted landing.
- [NTSB ATL04CA108](https://openairdocs.org/ntsb/ATL04CA108.md): Sawyer Skybolt · Philadelphia, MS · Accident · No injuries · Data collection · Final report · May 1, 2004 · N32DS · Substantial damage
  > The pilot's failure to see and avoid a guy wire which resulted in an in-flight collision.
- [NTSB FTW04LA119](https://openairdocs.org/ntsb/FTW04LA119.md): Holmes RV-6A · San Antonio, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 2004 · N65RV · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC04LA111](https://openairdocs.org/ntsb/NYC04LA111.md): Black Kitfox · Mount Sterling, KY · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2004 · N917JB · Substantial damage
  > The loss of engine power due to blockage of the fuel filters resulting in fuel starvation. A factor in the accident was the inadequate maintenance inspection.
- [NTSB DEN04LA075](https://openairdocs.org/ntsb/DEN04LA075.md): Beech 95-C55 · Rifle, CO · Accident · No injuries · Limited investigation · Final report · Apr 28, 2004 · N282JL · Substantial damage
  > the pilot's failure to verify the manual extension of the landing gear resulting in an inadvertent wheels up landing. Contributing factors include the electrical systems failure for undetermined reasons, the pilot's diverted attention and the pilot's improper…
- [NTSB DEN04CA067](https://openairdocs.org/ntsb/DEN04CA067.md): Cessna 172N · Lyons, CO · Accident · No injuries · Data collection · Final report · Apr 24, 2004 · N5048E · Substantial damage
  > a loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.
- [NTSB ATL04CA091](https://openairdocs.org/ntsb/ATL04CA091.md): Piper PA-28R-200 · Delco, NC · Accident · Minor injuries · Data collection · Final report · Apr 24, 2004 · N32891 · Substantial damage
  > The flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation. A factor was the flight instructor's failure to use the checklist.
- [NTSB ATL04LA097](https://openairdocs.org/ntsb/ATL04LA097.md): Durr Lancair Legacy · Oakland, TN · Accident · 1 fatal · Limited investigation · Final report · Apr 23, 2004 · N511WD · Destroyed
  > The pilot loss control of the airplane when he continued flight into known thunderstorm and convective activity. A factor is insufficient information provided by ATC personnel.
- [NTSB ANC04LA045](https://openairdocs.org/ntsb/ANC04LA045.md): Arctic S-1B2 · Big Lake, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 2004 · N55AD · Substantial damage
  > The flight instructor's failure to insure that the carburetor heat was activated by the dual student following a simulated loss of engine power, which resulted in carburetor ice and the actual loss of engine power during a descent. A factor associated with…
- [NTSB CHI04FA107](https://openairdocs.org/ntsb/CHI04FA107.md): Bell 206L-1 · Boonville, IN · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2004 · N137AE · Substantial damage
  > The pilot's inadequate planning/decision which resulted in his failure to maintain terrain clearance. Contributing factors were the pilot's inadequate preflight planning, his diverted attention, and the dark night conditions.
- [NTSB ANC04IA046](https://openairdocs.org/ntsb/ANC04IA046.md): Cessna 208 · Kalaupapa, HI · Incident · Minor injuries · Incident investigation · Final report · Apr 21, 2004 · N302PW · No damage
  > An in-flight encounter with turbulence during cruise flight, which resulted in a minor injury to a passenger. On February 7, 2006, this occurrence was reclassified from an accident to an incident and this narrative was modified.
- [NTSB FTW04LA113](https://openairdocs.org/ntsb/FTW04LA113.md): Piper PA-23-250 · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · Apr 20, 2004 · N6257H · Substantial damage
  > The propeller overspeed for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX04FA190](https://openairdocs.org/ntsb/LAX04FA190.md): Piper PA 28-161 · Holoaloa, HI · Accident · Serious injuries · Field investigation · Final report · Apr 19, 2004 · N8198A · Destroyed
  > The pilot's continued flight into adverse weather conditions that resulted in an in-flight collision with mountainous terrain. Factors in the accident were rising terrain, low clouds and rain, and the pilot's lack of familiarity with the geographic area.
- [NTSB SEA04LA071](https://openairdocs.org/ntsb/SEA04LA071.md): Keller Prospector FK1 · Gibbonsville, ID · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 2004 · N5XK · Substantial damage
  > The pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing, trees and mountainous terrain.
- [NTSB FTW04LA110](https://openairdocs.org/ntsb/FTW04LA110.md): Cessna 175B · Locust Grove, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2004 · N8172T · Substantial damage
  > The improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.
- [NTSB CHI04CA106](https://openairdocs.org/ntsb/CHI04CA106.md): Piper PA-28-180 · Columbia, MO · Accident · No injuries · Data collection · Final report · Apr 15, 2004 · N40RT · Substantial damage
  > The pilot inadvertently became lost and over flew his destination in cruise flight and selected an unsuitable landing area for his precautionary landing. Factors were the rough/uneven terrain, the barbed wire fence, and the fence post encountered during the…
- [NTSB NYC04LA107](https://openairdocs.org/ntsb/NYC04LA107.md): Boeing 737-700 · Beach Haven, NJ · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 2004 · N448WN · No damage
  > An encounter with turbulence during cruise flight.
- [NTSB FTW04LA116](https://openairdocs.org/ntsb/FTW04LA116.md): Cessna 150 · Magnolia, AR · Accident · No injuries · Limited investigation · Final report · Apr 14, 2004 · N5628E · Substantial damage
  > The pilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC04LA105](https://openairdocs.org/ntsb/NYC04LA105.md): Piper PA-46-310P · Taylor, PA · Accident · No injuries · Limited investigation · Final report · Apr 13, 2004 · N861DD · Substantial damage
  > The failure of the number 2 connecting rod, after a main bearing shift, which resulted in a catastrophic engine failure.
- [NTSB NYC04TA103](https://openairdocs.org/ntsb/NYC04TA103.md): McDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Final report · Apr 11, 2004 · N14075 · Substantial damage
  > The failure of the number two upper forward right engine cowling attachment, which resulted in substantial damage to the right inboard elevator. A factor was the inadequate procedures in the airliner maintenance manual.
- [NTSB MIA04LA070](https://openairdocs.org/ntsb/MIA04LA070.md): Cirrus Design SR22 · N. Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Apr 10, 2004 · N916LJ · Substantial damage
  > The erratic operation of the pitot-static system associated flight instruments due to water contamination, and the pilot's failure to take the appropriate corrective actions.
- [NTSB MIA04LA067](https://openairdocs.org/ntsb/MIA04LA067.md): Cessna 206 · Clewiston, FL · Accident · No injuries · Limited investigation · Final report · Apr 10, 2004 · N5019U · Substantial damage
  > The failure of the No. 2 cylinder connecting rod for undetermined reasons, and the failure of one of the connecting rod bolts due to tension overload resulting in the total loss of engine power and subsequent collision with a ditch during the forced landing.
- [NTSB IAD04LA016](https://openairdocs.org/ntsb/IAD04LA016.md): Pilatus P3-05 · Edgewater, FL · Accident · 2 fatal · Limited investigation · Final report · Apr 10, 2004 · N860MK · Destroyed
  > The delamination of the no. 2 connecting rod bearing for undetermined reasons, resulting in a total loss of engine power. A factor in the accident was the pilot's inability to complete a successful forced landing due to oil on the windscreen, and smoke and…
- [NTSB CHI04LA126](https://openairdocs.org/ntsb/CHI04LA126.md): Boeing 737-300 · St. Louis, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 2004 · N662SW · No damage
  > The inadvertent encounter with turbulence which resulted in the injury to the flight attendant.
- [NTSB CHI04LA104](https://openairdocs.org/ntsb/CHI04LA104.md): Cessna 172M · New Munster, WI · Accident · No injuries · Limited investigation · Final report · Apr 10, 2004 · N73213 · 2 aircraft · Substantial damage
  > Visual lookout not maintained by the pilots of both airplanes.
- [NTSB NYC04LA106](https://openairdocs.org/ntsb/NYC04LA106.md): Cessna 182S · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Apr 9, 2004 · N518CR · Substantial damage
  > The failure of the elevator servo which resulted in restricted elevator movement and the pilot's inability to initiate a landing flare.
- [NTSB DEN04IA059](https://openairdocs.org/ntsb/DEN04IA059.md): Beech 1900D · Denver, CO · Incident · No injuries · Incident investigation · Final report · Apr 9, 2004 · N210GL · No damage
  > arcing of the windshield deicing system. Factors contributing to the incident were the improper inspection of the windshield's exterior seal, deterioration of the windshield seal, and water penetration through the deteriorated seal.
- [NTSB LAX04CA181](https://openairdocs.org/ntsb/LAX04CA181.md): Piper PA-38-112 · McKinleyville, CA · Accident · No injuries · Data collection · Final report · Apr 8, 2004 · N2609F · Substantial damage
  > a loss of engine power due fuel exhaustion, which was caused by the pilot's inadequate in-flight planning/decision, inadequate in-flight fuel consumption calculations, and failure to divert to an alternate airport before the fuel situation became critical.…
- [NTSB IAD04CA014](https://openairdocs.org/ntsb/IAD04CA014.md): Cessna 152 · Hamilton, OH · Accident · Minor injuries · Data collection · Final report · Apr 7, 2004 · N4713B · Substantial damage
  > The pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power. The student pilot becoming lost/disoriented is a contributing factor.
- [NTSB DEN04FA057](https://openairdocs.org/ntsb/DEN04FA057.md): Cessna 182F · Burlington, CO · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2004 · N3524Y · Destroyed
  > loss of aircraft control due to structural icing. Factors contributing to the accident were the pilot's inadvertent flight into adverse weather conditions, the icing conditions, and ice fog.
- [NTSB CHI04LA101](https://openairdocs.org/ntsb/CHI04LA101.md): Piper PA-24-250 · Overland Park, KS · Accident · No injuries · Limited investigation · Final report · Apr 6, 2004 · N5844P · Substantial damage
  > The pilot's inadequate fuel calculations and the pilot's improper in-flight decision which resulted in fuel exhaustion. Contributing factors were the trees and the night conditions.
- [NTSB SEA04LA064](https://openairdocs.org/ntsb/SEA04LA064.md): Grumman G-44 · Belliigham, WA · Accident · No injuries · Limited investigation · Final report · Apr 2, 2004 · N65914 · Substantial damage
  > The failure of the pilot to select the proper touchdown point while conducting a forced landing. Factors included the #1 engine malfunction, the right propeller oil control valve leak, and the shallow subsurface terrain condition.
- [NTSB DEN04LA056](https://openairdocs.org/ntsb/DEN04LA056.md): Cessna 150M · Orem, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 2004 · N66758 · Substantial damage
  > the pilot's improper in-flight planning and decision making, resulting in fuel exhaustion and the loss of engine power. Contributing factors include the dark night light conditions, and the trees.
- [NTSB CHI04CA091](https://openairdocs.org/ntsb/CHI04CA091.md): Cessna C-180 · Aberdeen, SD · Accident · No injuries · Data collection · Final report · Mar 28, 2004 · N2916C · Substantial damage
  > The pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…
- [NTSB NYC04FA093](https://openairdocs.org/ntsb/NYC04FA093.md): Mitsubishi MU-2B-36 · Pittsfield, MA · Accident · 1 fatal · Field investigation · Final report · Mar 25, 2004 · N201UV · Substantial damage
  > The pilot's loss of aircraft control for undetermined reasons, which resulted in an inadvertent stall/spin and subsequent impact with the ground.
- [NTSB DEN04LA055](https://openairdocs.org/ntsb/DEN04LA055.md): Mikoyan MiG Mig-17 · Truth or Conseq, NM · Accident · 1 fatal · Limited investigation · Final report · Mar 25, 2004 · N508M · Destroyed
  > the loss of aircraft control for undetermined reasons resulting in impact with desert terrain.
- [NTSB DCA04MA030](https://openairdocs.org/ntsb/DCA04MA030.md): Sikorsky S76A++ · Gulf of Mexico · Accident · 10 fatal · Class 1 · Major · Final report · Mar 23, 2004 · N579EH · Destroyed
  > the flight crew's failure to identify and arrest the helicopter's descent for undetermined reasons, which resulted in controlled flight into terrain.
- [NTSB NYC04FA092](https://openairdocs.org/ntsb/NYC04FA092.md): Piper PA-32R-301 · Harlan, KY · Accident · 6 fatal · Field investigation · Final report · Mar 22, 2004 · N8173U · Destroyed
  > The pilot's improper decision to continue VFR flight into IMC conditions and his failure to maintain terrain clearance, which resulted in controlled flight into terrain. Factors were night, snow and a low ceiling.
- [NTSB SEA04CA054](https://openairdocs.org/ntsb/SEA04CA054.md): Menefee RAF Vari-Eze · Bremerton, WA · Accident · Minor injuries · Data collection · Final report · Mar 21, 2004 · N200TZ · Substantial damage
  > Failure to maintain airspeed while on final approach resulting in a stall. Factors include a rough running engine for undetermined reasons and rough/uneven terrain.
- [NTSB NYC04LA090](https://openairdocs.org/ntsb/NYC04LA090.md): Cessna 152 · Greenville, KY · Accident · No injuries · Limited investigation · Final report · Mar 21, 2004 · N4468V · Substantial damage
  > The total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.
- [NTSB LAX04LA169](https://openairdocs.org/ntsb/LAX04LA169.md): Stanley Glasair SH-2 · San Luis Obispo, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 2004 · N309TS · Substantial damage
  > The loss of engine power due to the failure of the #3 cylinder piston and connecting rod for undetermined reasons.
- [NTSB FTW04FA097](https://openairdocs.org/ntsb/FTW04FA097.md): Bell 407 · Pyote, TX · Accident · 4 fatal · Field investigation · Final report · Mar 21, 2004 · N502MT · Destroyed
  > The pilot's inadvertent encounter with adverse weather, which resulted in the pilot failing to maintain terrain clearance. Contributing factors were the dark night conditions, the pilot's inadequate preflight preparation and planning, and the pressure to…
- [NTSB ANC04LA043](https://openairdocs.org/ntsb/ANC04LA043.md): Piper PA-24-250 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 20, 2004 · N6583R · Substantial damage
  > The incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…
- [NTSB SEA04LA051](https://openairdocs.org/ntsb/SEA04LA051.md): Piper PA-18 · Sisters, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 2004 · N2553S · Substantial damage
  > The loss of engine power for undetermined reasons. Factors include no suitable place for a forced landing, and trees in the area where the pilot found it necessary to attempt the forced landing.
- [NTSB MIA04FA060](https://openairdocs.org/ntsb/MIA04FA060.md): Cessna 182P · Spring Hill, FL · Accident · 1 fatal · Field investigation · Final report · Mar 16, 2004 · N8148G · Substantial damage
  > The non instrument rated pilot's decision to attempt VFR flight into IMC conditions resulting in an in-flight loss of control.
- [NTSB LAX04LA158](https://openairdocs.org/ntsb/LAX04LA158.md): Quinn E L Tom Cat MK-5A · Galt, CA · Accident · No injuries · Limited investigation · Final report · Mar 15, 2004 · N8429 · Substantial damage
  > a loss of engine power due to water contamination of the fuel system.
- [NTSB FTW04LA092](https://openairdocs.org/ntsb/FTW04LA092.md): Beech A36 · Conroe, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 15, 2004 · N789SA · Substantial damage
  > The loss of engine power due to the improper fuel type. Contributing factors were the improper aircraft servicing, lack of training by the fixed base operator, and the low cloud ceiling.
- [NTSB LAX04CA147](https://openairdocs.org/ntsb/LAX04CA147.md): Cessna 182E · Sonora, CA · Accident · No injuries · Data collection · Final report · Mar 6, 2004 · N2819Y · Substantial damage
  > the pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.
- [NTSB FTW04LA087](https://openairdocs.org/ntsb/FTW04LA087.md): Piper PA-38-112 · Sugar Land, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 2004 · N2588A · Substantial damage
  > The pilot's improper weather evaluation, and his encounter with adverse weather conditions. A contributing factor was the lack of suitable terrain for the precautionary landing.
- [NTSB CHI04LA084](https://openairdocs.org/ntsb/CHI04LA084.md): Boeing 757-200 · Janesville, WI · Accident · Serious injuries · Limited investigation · Final report · Mar 1, 2004 · N516UA · No damage
  > The unexpected encounter with convective turbulence.

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

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

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