# NTSB investigations, 2006: 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 · 225 cases

## Latest cases

- [NTSB NYC07FA052](https://openairdocs.org/ntsb/NYC07FA052.md): Cessna TR182 · Charlotte, NC · Accident · 4 fatal · Field investigation · Final report · Dec 31, 2006 · N7090S · Destroyed
  > The pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.
- [NTSB CHI07LA051](https://openairdocs.org/ntsb/CHI07LA051.md): Piper PA-32-300 · Romeo, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 2006 · N888PR · Substantial damage
  > The pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.
- [NTSB CHI07LA050](https://openairdocs.org/ntsb/CHI07LA050.md): Beech B-99 · Rapid City, SD · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 2006 · N99TH · Substantial damage
  > The pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.
- [NTSB LAX07CA066](https://openairdocs.org/ntsb/LAX07CA066.md): Burkhart Grob G-103A · Minden, NV · Accident · Minor injuries · Data collection · Final report · Dec 27, 2006 · N794G · Substantial damage
  > The flight's encounter with a low ceiling while on approach that necessatiated an off-airport precautionary landing on unsuitable terrain. Obstructions were a factor.
- [NTSB ATL07FA030](https://openairdocs.org/ntsb/ATL07FA030.md): Cessna 414A · Lawrenceville, GA · Accident · 3 fatal · Field investigation · Final report · Dec 26, 2006 · N62950 · Substantial damage
  > The pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.
- [NTSB ANC07LA009](https://openairdocs.org/ntsb/ANC07LA009.md): Gates Learjet 35A · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Dec 26, 2006 · N136WE · Substantial damage
  > The pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…
- [NTSB CHI07FA045](https://openairdocs.org/ntsb/CHI07FA045.md): Beech A36 · Chattanooga, TN · Accident · 4 fatal · Field investigation · Final report · Dec 23, 2006 · N3704B · Destroyed
  > The pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.
- [NTSB ATL07FA029](https://openairdocs.org/ntsb/ATL07FA029.md): Cessna 340A · Charleston, SC · Accident · 4 fatal · Field investigation · Final report · Dec 22, 2006 · N808RA · Substantial damage
  > The pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.
- [NTSB LAX07FA059](https://openairdocs.org/ntsb/LAX07FA059.md): Piper PA-46-350P · Concord, CA · Accident · 4 fatal · Field investigation · Final report · Dec 21, 2006 · N1AM · Destroyed
  > Failure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.
- [NTSB DFW07FA042](https://openairdocs.org/ntsb/DFW07FA042.md): Cessna T210N · Austin, TX · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N5434C · Destroyed
  > The pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.
- [NTSB DFW07FA041](https://openairdocs.org/ntsb/DFW07FA041.md): Beech A36 · Fayetteville, AR · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N1100J · Destroyed
  > The pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.
- [NTSB CHI07LA043](https://openairdocs.org/ntsb/CHI07LA043.md): Cessna 560 · North Canton, OH · Accident · No injuries · Limited investigation · Final report · Dec 18, 2006 · N49NS · Substantial damage
  > The rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…
- [NTSB DFW07CA038](https://openairdocs.org/ntsb/DFW07CA038.md): Cessna 421 · Brackettville, TX · Accident · No injuries · Data collection · Final report · Dec 16, 2006 · N642CB · Destroyed
  > The pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.
- [NTSB NYC07CA049](https://openairdocs.org/ntsb/NYC07CA049.md): Cessna 172C · Middletown, NY · Accident · Minor injuries · Data collection · Final report · Dec 14, 2006 · N8260X · Substantial damage
  > The pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.
- [NTSB CHI07CA040](https://openairdocs.org/ntsb/CHI07CA040.md): Schleicher AS-K13 · Gregory, MI · Accident · No injuries · Data collection · Final report · Dec 14, 2006 · N545TT · Substantial damage
  > The pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.
- [NTSB SEA07FA031](https://openairdocs.org/ntsb/SEA07FA031.md): Piper PA-28-140 · Bandon, OR · Accident · 1 fatal · Field investigation · Final report · Dec 12, 2006 · N5618U · Substantial damage
  > The loss of aircraft control in the traffic pattern for undetermined reasons.
- [NTSB DFW07FA036](https://openairdocs.org/ntsb/DFW07FA036.md): Cessna 310Q · Waco, TX · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2006 · N69677 · Destroyed
  > The pilot's failure to maintain sufficient airspeed to avoid a stall during the instrument landing approach, which resulted in an inadvertent stall and collision with terrain. Also causal was the pilot's impairment due to prohibited drugs. Factors associated…
- [NTSB NYC07FA043](https://openairdocs.org/ntsb/NYC07FA043.md): Piper PA-32R-300 · Charlottesville, VA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2006 · N8349C · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB NYC07FA042](https://openairdocs.org/ntsb/NYC07FA042.md): Cessna 210K · Edgewater, MD · Accident · 2 fatal · Field investigation · Final report · Dec 9, 2006 · N9449M · Substantial damage
  > The pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…
- [NTSB DEN07CA035](https://openairdocs.org/ntsb/DEN07CA035.md): Piper PA-28-180 · Falcon, CO · Accident · Minor injuries · Data collection · Final report · Dec 8, 2006 · N6487J · Substantial damage
  > loss of power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing, unsuitable terrain available on which to make a forced landing and the tree.
- [NTSB NYC07FA038](https://openairdocs.org/ntsb/NYC07FA038.md): Smith, Ted Aerostar 601P · West Dover, VT · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2006 · N9797Q · Destroyed
  > A loss of control during approach for undetermined reasons, which resulted in a collision with trees.
- [NTSB DFW07LA032](https://openairdocs.org/ntsb/DFW07LA032.md): Noble Vans RV-7A · Norman, OK · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2006 · N216RV · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.
- [NTSB NYC07FA037](https://openairdocs.org/ntsb/NYC07FA037.md): Cirrus SR22 · Huntersville, NC · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2006 · N665CD · Destroyed
  > The pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.
- [NTSB LAX07FA049](https://openairdocs.org/ntsb/LAX07FA049.md): Beech B36TC · Buena Park, CA · Accident · Serious injuries · Field investigation · Final report · Nov 27, 2006 · N3144D · Substantial damage
  > a fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.
- [NTSB LAX07LA048](https://openairdocs.org/ntsb/LAX07LA048.md): Cessna 414A · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2006 · N414AY · Substantial damage
  > A loss of power in the right engine due to fuel starvation. The fuel starvation was the result of the pilot's improper fuel selector position setting.
- [NTSB NYC07LA036](https://openairdocs.org/ntsb/NYC07LA036.md): Cessna T210N · Caldwell, NJ · Accident · No injuries · Limited investigation · Final report · Nov 21, 2006 · N210MP · Substantial damage
  > The private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.
- [NTSB NYC07CA034](https://openairdocs.org/ntsb/NYC07CA034.md): Taylorcraft BC12-D · Benton, KY · Accident · Serious injuries · Data collection · Final report · Nov 21, 2006 · N148HW · Substantial damage
  > The pilot's improper decision to fly between the trees during his approach to the runway.
- [NTSB MIA07CA020](https://openairdocs.org/ntsb/MIA07CA020.md): Liberty Aerospace XL-2 · Melbourne, FL · Accident · No injuries · Data collection · Final report · Nov 21, 2006 · N508XL · Substantial damage
  > The pilot's (Dual Student) failure to relinquish control of the airplane when instructed by the certified flight instructor resulting in airspeed not being maintained and an inadvertent stall.
- [NTSB ATL07CA023](https://openairdocs.org/ntsb/ATL07CA023.md): Hudspeth Shawn D Challenger II · Bessemer, AL · Accident · No injuries · Data collection · Final report · Nov 21, 2006 · N44594 · Substantial damage
  > The pilot's failure to maintain control of the airplane during an approach for landing. A factor in the accident was gusting winds.
- [NTSB MIA07CA018](https://openairdocs.org/ntsb/MIA07CA018.md): Sargent Jonathan Varieze · Punta Gorda, FL · Accident · Serious injuries · Data collection · Final report · Nov 18, 2006 · N75EZ · Substantial damage
  > The pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight, which did not ensure the security of the canopy before flight.
- [NTSB LAX07LA037](https://openairdocs.org/ntsb/LAX07LA037.md): Beechcraft J35 · Flagstaff, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 2006 · N8246D · Substantial damage
  > The pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.
- [NTSB SEA07IA019](https://openairdocs.org/ntsb/SEA07IA019.md): Cessna 172 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Nov 16, 2006 · N9522S · No damage
  > The instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…
- [NTSB SEA07LA017](https://openairdocs.org/ntsb/SEA07LA017.md): Piper PA-28-140 · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Nov 14, 2006 · N2390T · Substantial damage
  > The pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.
- [NTSB CHI07CA023](https://openairdocs.org/ntsb/CHI07CA023.md): Mooney M20J · Akron, OH · Accident · Minor injuries · Data collection · Final report · Nov 14, 2006 · N202WB · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during final approach resulting in an inadvertent stall. Contributing factors were the airplane's low altitude at the time of the stall and the asymmetric flap configuration.
- [NTSB MIA07CA015](https://openairdocs.org/ntsb/MIA07CA015.md): Bellanca BL-17-30 · Lantana, FL · Accident · Minor injuries · Data collection · Final report · Nov 13, 2006 · N6663V · Substantial damage
  > The pilot's improper preflight planning/decision which resulted in total loss of engine power due to fuel exhaustion.
- [NTSB MIA07LA014](https://openairdocs.org/ntsb/MIA07LA014.md): Cessna 150J · DeFuniak Springs, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 2006 · N50977 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB DFW07FA023](https://openairdocs.org/ntsb/DFW07FA023.md): McCutchan Glasair · Mineral Wells, TX · Accident · 2 fatal · Field investigation · Final report · Nov 11, 2006 · N606MC · Destroyed
  > The pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. A factor was the loss of engine power due to fuel exhaustion.
- [NTSB ATL07CA017](https://openairdocs.org/ntsb/ATL07CA017.md): Diamond Aircraft Industries DA 20-C1 · Raleigh, NC · Accident · No injuries · Data collection · Final report · Nov 10, 2006 · N190WA · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in a inadvertent stall.
- [NTSB SEA07FA016](https://openairdocs.org/ntsb/SEA07FA016.md): Beech D35 · Shelton, WA · Accident · 1 fatal · Field investigation · Final report · Nov 9, 2006 · N2843V · Substantial damage
  > The pilot's failure to refuel the airplane, which resulted in fuel exhaustion, and his failure to maintain sufficient airspeed to avoid a stall during the subsequent forced landing. A factor associated with the accident is the inadvertent stall.
- [NTSB DFW07LA022](https://openairdocs.org/ntsb/DFW07LA022.md): Cessna 152 · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Nov 7, 2006 · N94684 · 2 aircraft · Substantial damage
  > The failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.
- [NTSB MIA07FA011](https://openairdocs.org/ntsb/MIA07FA011.md): Beech BE-76 · Port Orange, FL · Accident · 2 fatal · Field investigation · Final report · Nov 1, 2006 · N6017U · Destroyed
  > The flight instructor's inadequate preflight planning which resulted in fuel exhaustion.
- [NTSB NYC07CA016](https://openairdocs.org/ntsb/NYC07CA016.md): Jahns RV-7 · Farmingdale, NJ · Accident · No injuries · Data collection · Final report · Oct 31, 2006 · N916R · Substantial damage
  > A loss of engine power due to a disconnected throttle/power lever linkage. A contributingfactor was the owner/builder's improper installation of the throttle linkage.
- [NTSB NYC07CA014](https://openairdocs.org/ntsb/NYC07CA014.md): Cessna 172N · Morgantown, WV · Accident · No injuries · Data collection · Final report · Oct 29, 2006 · N952AC · Substantial damage
  > The student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.
- [NTSB CHI07FA009](https://openairdocs.org/ntsb/CHI07FA009.md): Beech 95-B55 · Lawrenceville, IL · Accident · 1 fatal · Field investigation · Final report · Oct 27, 2006 · N1832N · Substantial damage
  > The improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…
- [NTSB SEA07CA010](https://openairdocs.org/ntsb/SEA07CA010.md): Alexander Lancair 320 · Scappoose, OR · Accident · No injuries · Data collection · Final report · Oct 22, 2006 · N1382Y · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around.
- [NTSB NYC07LA011](https://openairdocs.org/ntsb/NYC07LA011.md): Bishop Bakeng Duce · South Boston, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 2006 · N91BK · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…
- [NTSB CHI07LA011](https://openairdocs.org/ntsb/CHI07LA011.md): Cessna R182 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Oct 22, 2006 · N5274S · Substantial damage
  > The fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.
- [NTSB MIA07CA007](https://openairdocs.org/ntsb/MIA07CA007.md): Cessna 150L · Umatilla, FL · Accident · Minor injuries · Data collection · Final report · Oct 20, 2006 · N10772 · Substantial damage
  > The flight instructor's delayed remedial action during a go-around, which resulted in a failure to maintain sufficient airspeed to avoid a stall/mush, and an in-flight collision with terrain.
- [NTSB NYC07FA009](https://openairdocs.org/ntsb/NYC07FA009.md): Piper PA-46-310P · Odenton, MD · Accident · 2 fatal · Field investigation · Final report · Oct 19, 2006 · N9130N · Destroyed
  > The pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…
- [NTSB NYC07CA010](https://openairdocs.org/ntsb/NYC07CA010.md): Cirrus SR-22 · Lumberton, NJ · Accident · No injuries · Data collection · Final report · Oct 19, 2006 · N246MT · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around, which resulted in an in-flight collision with a tree.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2006&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") = 2006
  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=2006

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