# NTSB investigations, 2005: Approach

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 1 of 5 · 229 cases

## Latest cases

- [NTSB DEN06CA029](https://openairdocs.org/ntsb/DEN06CA029.md): Cessna 182A · Hobbs, NM · Accident · Serious injuries · Data collection · Final report · Dec 31, 2005 · N4755D · Substantial damage
  > the loss of engine power due to fuel exhaustion and the pilot's failure to visually verify the fuel quantity in the fuel tanks prior to departure. Contributing factors include the pilot's inadequate preflight, and the transmission wires.
- [NTSB LAX06FA071](https://openairdocs.org/ntsb/LAX06FA071.md): Learjet 35A · Truckee, CA · Accident · 2 fatal · Field investigation · Final report · Dec 28, 2005 · N781RS · Destroyed
  > The pilot's inadequate compensation for the gusty crosswind condition and failure to maintain an adequate airspeed while maneuvering in a steep turn close to the ground.
- [NTSB LAX06CA070](https://openairdocs.org/ntsb/LAX06CA070.md): Socata TBM 700 · Lancaster, CA · Accident · Minor injuries · Data collection · Final report · Dec 27, 2005 · N198X · Substantial damage
  > The student's failure to maintain adequate airspeed, and the instructor's inadequate supervision and delayed remedial action, which resulted in a stall/mush.
- [NTSB CHI06LA051](https://openairdocs.org/ntsb/CHI06LA051.md): Piper PA-31-350 · Marshall, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 2005 · N711HG · Substantial damage
  > A loss of engine power in both engines while on approach due to fuel exhaustion and the pilot's inaccurate fuel consumption calculations leading to him refueling the outboard tanks only.
- [NTSB LAX06FA066](https://openairdocs.org/ntsb/LAX06FA066.md): Beech 36 · Livermore, CA · Accident · 2 fatal · Field investigation · Final report · Dec 23, 2005 · N5942S · Substantial damage
  > The pilot's failure to maintain the appropriate glidepath alignment during an instrument landing system approach, resulting in collision with terrain. A contributing factor to the accident was the failure of the air traffic controllers to issue a minimum safe…
- [NTSB LAX06LA065](https://openairdocs.org/ntsb/LAX06LA065.md): Beech F33A · La Verne, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 2005 · N3084N · 2 aircraft · No damage
  > the failure of the pilot of the other aircraft to comply with his air traffic control clearance and line up for the proper runway, and his failure to maintain an adequate visual lookout, which resulted in his in-flight collision with the Cessna airplane.
- [NTSB NYC06LA045](https://openairdocs.org/ntsb/NYC06LA045.md): Beech 23 · Chaplin, CT · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 2005 · N7631R · Substantial damage
  > A complete loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the emergency landing.
- [NTSB DEN06LA024](https://openairdocs.org/ntsb/DEN06LA024.md): Piper PA-28-235 · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Dec 21, 2005 · N9318W · Substantial damage
  > the pilot's delay in applying carburetor heat that resulted in the partial loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA050](https://openairdocs.org/ntsb/CHI06CA050.md): Elliott Quad City Ultralight Challenger II · California, MO · Accident · Minor injuries · Data collection · Final report · Dec 21, 2005 · N115BT · Substantial damage
  > The pilot's failure to maintain aircraft control due to his failure to comply with procedures/directives, and the inadvertent stall/spin he encountered on his turn to base.
- [NTSB MIA06CA031](https://openairdocs.org/ntsb/MIA06CA031.md): Cessna 210 · Stuart, FL · Accident · Minor injuries · Data collection · Final report · Dec 16, 2005 · N41805 · Substantial damage
  > The pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent collision with terrain.
- [NTSB MIA06CA029](https://openairdocs.org/ntsb/MIA06CA029.md): Piper PA-34-200 · Daytona Beach, FL · Accident · No injuries · Data collection · Final report · Dec 12, 2005 · N56825 · Substantial damage
  > The flight instructor's inadequate supervision, and the student pilot's improper go-around procedures, which resulted in the airplane's left wing striking the runway.
- [NTSB SEA06LA026](https://openairdocs.org/ntsb/SEA06LA026.md): Hitchens EDI 90FT · Chehalis, WA · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 2005 · N900EH · Substantial damage
  > The pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.
- [NTSB ATL06LA022](https://openairdocs.org/ntsb/ATL06LA022.md): Embraer EMB-110P1 · Orangeburg, SC · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 2005 · N790RA · Substantial damage
  > The pilot's inadequate preflight inspection and her failure to refuel the airplane which resulted in total loss of engine power due to fuel exhaustion, and subsequent in-flight collision with trees.
- [NTSB SEA06CA024](https://openairdocs.org/ntsb/SEA06CA024.md): Cessna 210-5 · Lopez Island, WA · Accident · No injuries · Data collection · Final report · Dec 1, 2005 · N1876Z · Substantial damage
  > The pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.
- [NTSB NYC06FA040](https://openairdocs.org/ntsb/NYC06FA040.md): Beech B-55 · Nantucket, MA · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2005 · N64PW · Destroyed
  > The pilot's failure to maintain the proper glidepath during the instrument approach, which resulted in controlled flight into water. Factors were the failure of the air traffic controllers to issue minimum safe altitude warnings, night lighting conditions,…
- [NTSB SEA06FA022](https://openairdocs.org/ntsb/SEA06FA022.md): Cessna 425 · Belgrade, MT · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2005 · N701QR · Destroyed
  > The pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.
- [NTSB LAX06LA048](https://openairdocs.org/ntsb/LAX06LA048.md): Cessna 182A · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 2005 · N3936D · Substantial damage
  > The failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.
- [NTSB NYC06IA036](https://openairdocs.org/ntsb/NYC06IA036.md): Mooney M20F · Cadiz, KY · Incident · No injuries · Incident investigation · Final report · Nov 24, 2005 · N52DB · Minor damage
  > Fuel starvation, which resulted in a loss of engine power.
- [NTSB NYC06FA034](https://openairdocs.org/ntsb/NYC06FA034.md): Piper PA-23-250 · Burlington, VT · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2005 · N26399 · Substantial damage
  > The pilot's failure to follow the published instrument flight procedure, which resulted in an in-flight collision with terrain. Factors in the accident were the local air traffic controller's inadequate monitoring of the MSAW system, and his delayed…
- [NTSB MIA06FA022](https://openairdocs.org/ntsb/MIA06FA022.md): Aerospatiale AS350B · Homestead, FL · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2005 · N264BH · 2 aircraft · Substantial damage
  > The failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…
- [NTSB NYC06LA033](https://openairdocs.org/ntsb/NYC06LA033.md): Boeing 737-800 · State College, PA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2005 · N734MA · Substantial damage
  > The pilot's improper touchdown and recovery from a bounced landing. Factors to the accident were the operator's failure to provide sufficient information on the use of autothrottles and bounced landing recovery techniques, along with the Federal Aviation…
- [NTSB CHI06LA034](https://openairdocs.org/ntsb/CHI06LA034.md): Piper PA-28-180 · Batavia, OH · Accident · No injuries · Limited investigation · Final report · Nov 20, 2005 · N3425R · Substantial damage
  > The loss of engine power due to fuel starvation and improper fuel management by the pilot while on approach. Contributing factors were the low altitude and unsuitable terrain encountered during an emergency landing.
- [NTSB LAX06CA038](https://openairdocs.org/ntsb/LAX06CA038.md): Piper PA-28RT-201 · Bakersfield, CA · Accident · No injuries · Data collection · Final report · Nov 17, 2005 · N2863X · Substantial damage
  > the pilot's failure to maintain adequate airspeed, which resulted in an accelerated stall and hard landing.
- [NTSB SEA06CA017](https://openairdocs.org/ntsb/SEA06CA017.md): Cessna T210M · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Nov 16, 2005 · N6029N · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.
- [NTSB LAX06CA037](https://openairdocs.org/ntsb/LAX06CA037.md): Hopkins Rutan VariViggen · Aguila, AZ · Accident · Serious injuries · Data collection · Final report · Nov 16, 2005 · N389VV · Substantial damage
  > the pilot's failure to maintain an adequate airspeed during landing approach, which resulted in an inadvertent stall. A contributing factor was the pilot's lack of experience in the accident airplane.
- [NTSB CHI06FA032](https://openairdocs.org/ntsb/CHI06FA032.md): Aero Commander 500B · Gaylord, MI · Accident · 1 fatal · Field investigation · Final report · Nov 16, 2005 · N1153C · Destroyed
  > The clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.
- [NTSB ATL06CA016](https://openairdocs.org/ntsb/ATL06CA016.md): Cessna 177 · New Bern, NC · Accident · Minor injuries · Data collection · Final report · Nov 16, 2005 · N821KF · Substantial damage
  > The pilot's failure to activate the carburetor heat during approach resulting in a total loss of engine power due to carburetor ice.
- [NTSB DFW06LA028](https://openairdocs.org/ntsb/DFW06LA028.md): Rehler Gyrocopter · New Braunfels, TX · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2005 · N100KR · Substantial damage
  > The pilot's failure to maintain control while landing. A contributing factor was the high winds.
- [NTSB DFW06CA031](https://openairdocs.org/ntsb/DFW06CA031.md): Air Tractor AT-502B · Osceola, AR · Accident · No injuries · Data collection · Final report · Nov 10, 2005 · N5075P · Substantial damage
  > The pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.
- [NTSB DFW06CA030](https://openairdocs.org/ntsb/DFW06CA030.md): Cessna 172N · Arlington, TX · Accident · No injuries · Data collection · Final report · Nov 9, 2005 · N5437J · Substantial damage
  > The students improper recovery from a bounced landing. A contributing factor was the pilots excessive airspeed on final approach.
- [NTSB ATL06CA013](https://openairdocs.org/ntsb/ATL06CA013.md): Beech BE-76 · Greer, SC · Accident · Minor injuries · Data collection · Final report · Nov 7, 2005 · N3873X · Substantial damage
  > The pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.
- [NTSB DFW06FA021](https://openairdocs.org/ntsb/DFW06FA021.md): Piper PA-34-220T · Tomball, TX · Accident · 2 fatal · Field investigation · Final report · Nov 6, 2005 · N4171Z · Destroyed
  > The pilot's failure to maintain control of the aircraft while attempting to execute a missed approach procedure in weather that was below landing minimums. Contributing factors were the low ceiling, and the below approach landing minimums.
- [NTSB DFW06CA020](https://openairdocs.org/ntsb/DFW06CA020.md): Deussen Alexander II Rotorway Exec · Gibson, LA · Accident · Minor injuries · Data collection · Final report · Nov 5, 2005 · N5436X · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA029](https://openairdocs.org/ntsb/CHI06CA029.md): Hughes 269A · Omaha, NE · Accident · No injuries · Data collection · Final report · Nov 5, 2005 · N1020Q · Substantial damage
  > The loss of engine power for an undetermined reason and the pilot's improper execution of the emergency procedure which resulted in an excessive descent rate and subsequent hard landing.
- [NTSB LAX06CA027](https://openairdocs.org/ntsb/LAX06CA027.md): Lee Kolb Mark III Classic · Tucson, AZ · Accident · No injuries · Data collection · Final report · Nov 4, 2005 · N515AB · Substantial damage
  > the fatigue failure of the attachment that secured the horizontal stabilizer to the fuselage.
- [NTSB CHI06CA022](https://openairdocs.org/ntsb/CHI06CA022.md): Cessna 180 · Manitowish Wate, WI · Accident · No injuries · Data collection · Final report · Oct 27, 2005 · N20KK · Substantial damage
  > The pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.
- [NTSB DEN06LA011](https://openairdocs.org/ntsb/DEN06LA011.md): Piper PA-18-150 · Cortez, CO · Accident · No injuries · Limited investigation · Final report · Oct 26, 2005 · N4055Z · Substantial damage
  > the pilot's failure to maintain directional control of the airplane, resulting in a ground loop. Contributing factors were the excessive descent rate, the obstacle (horse), the high density altitude, and the tailwind.
- [NTSB LAX06LA016](https://openairdocs.org/ntsb/LAX06LA016.md): Nord 3202 · Casa Grande, AZ · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 2005 · N22532 · Substantial damage
  > the pilot's failure to maintain airspeed during a low-altitude evasive maneuver away from another airplane, which resulted in a stall and uncontrolled descent.
- [NTSB DFW06CA011](https://openairdocs.org/ntsb/DFW06CA011.md): Bell B206 L-3 · Marble Falls, TX · Accident · No injuries · Data collection · Final report · Oct 22, 2005 · N941SL · Substantial damage
  > A hard landing as result of a loss of engine power for undetermined reasons.
- [NTSB DEN06LA005](https://openairdocs.org/ntsb/DEN06LA005.md): Aviat A-1 · Kaycee, WY · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2005 · N6QR · Substantial damage
  > the pilot's improper decision to attempt a go-around and the pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was the hard landing.
- [NTSB DFW06CA017](https://openairdocs.org/ntsb/DFW06CA017.md): Hawker Siddeley 125-700 · Houston, TX · Accident · No injuries · Data collection · Final report · Oct 19, 2005 · N564BR · Substantial damage
  > The pilot-in-command's failure to attain proper runway alignment.
- [NTSB CHI06CA014](https://openairdocs.org/ntsb/CHI06CA014.md): Cessna 210C · Kankakee, IL · Accident · No injuries · Data collection · Final report · Oct 19, 2005 · N3610Y · Substantial damage
  > A hydraulic line leak causing a loss of hydraulic fluid and subsequent failure of the hydraulic system. An additional cause was the inoperative landing gear extension system, both normal and emergency, due to a complete loss of the hydraulic system.
- [NTSB CHI06CA013](https://openairdocs.org/ntsb/CHI06CA013.md): Cessna 152 · Peoria, IL · Accident · Minor injuries · Data collection · Final report · Oct 16, 2005 · N152SG · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.
- [NTSB ATL06LA008](https://openairdocs.org/ntsb/ATL06LA008.md): Elan/Glaser Dirks DG-300 · Brownsboro, AL · Accident · 1 fatal · Limited investigation · Final report · Oct 16, 2005 · N300HX · Substantial damage
  > The pilot's misjudgment of distance/altitude on final approach which resulted in an undershoot of the runway, and an in-flight collision with a embankment. A factor was the dirt bank/rising terrain.
- [NTSB SEA06LA005](https://openairdocs.org/ntsb/SEA06LA005.md): Piper PA-38-112 · Newberg, OR · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 2005 · N23887 · Substantial damage
  > The flight instructor's failure to maintain airspeed while on approach for landing resulting in an inadvertent stall. Wind gusts, trees and an undetermined loss of engine power were factors.
- [NTSB CHI06LA012](https://openairdocs.org/ntsb/CHI06LA012.md): Bellanca 7GCBC · Williams, MN · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 2005 · N2698Z · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in the airplane stalling. Factors associated with the accident were the low level at which the airplane was maneuvering and the pilot's failure to perform weight and balance calculations prior to the…
- [NTSB SEA06CA008](https://openairdocs.org/ntsb/SEA06CA008.md): Williams Challenger II · Spokane, WA · Accident · No injuries · Data collection · Final report · Oct 8, 2005 · N8069J · Substantial damage
  > The loss of all engine power while on downwind for undetermined reasons.
- [NTSB NYC06MA005](https://openairdocs.org/ntsb/NYC06MA005.md): Augusta 109E · Smethport, PA · Accident · 1 fatal · Major investigation · Final report · Oct 8, 2005 · N7YL · Destroyed
  > The pilot's failure to maintain aircraft control. Factors in the accident were, night instrument meteorological conditions, pilot workload, and improper air traffic control procedures by the approach controller.
- [NTSB NYC06FA004](https://openairdocs.org/ntsb/NYC06FA004.md): Beech A36 · Pikeville, KY · Accident · 3 fatal · Field investigation · Final report · Oct 7, 2005 · N97CM · Destroyed
  > The pilot's failure to follow the published instrument approach which resulted in controlled flight into terrain. A factor was the low ceiling.
- [NTSB NYC06CA006](https://openairdocs.org/ntsb/NYC06CA006.md): Mooney M20K · Ithaca, NY · Accident · Minor injuries · Data collection · Final report · Oct 7, 2005 · N1163A · Substantial damage
  > The pilot's failure to comply with the published instrument approach procedure, which resulted in an in-flight collision with trees.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2005&page=2

## 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 year(c."eventDate") = 2005
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?year=2005

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