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

## Latest cases

- [NTSB ANC07LA011](https://openairdocs.org/ntsb/ANC07LA011.md): Cessna T210N · Albany, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2006 · N5093A · Substantial damage
  > The loss of engine power during cruise flight due to a fractured crankshaft, resulting in an off-airport forced landing in a muddy field.
- [NTSB ANC07CA010](https://openairdocs.org/ntsb/ANC07CA010.md): Beech BE-23 · Asheville, NC · Accident · Minor injuries · Data collection · Final report · Dec 30, 2006 · N2319L · Substantial damage
  > The pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in a forced landing and collision with trees. Factors associated with the accident were fog and low ceilings.
- [NTSB SEA07LA039](https://openairdocs.org/ntsb/SEA07LA039.md): Averyt Vans RV-4 · Grants Pass, OR · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 2006 · N234RV · Substantial damage
  > The pilot's failure to maintain adequate airspeed during performance of a go-around, resulting in an inadvertent stall and subsequent in flight collision with the ground. A contributing factor was the in-flight loss of a portion of one propeller blade.
- [NTSB CHI07LA056](https://openairdocs.org/ntsb/CHI07LA056.md): Piper PA-24-260B · Belleville, IL · Accident · No injuries · Limited investigation · Final report · Dec 28, 2006 · N9284P · Substantial damage
  > The failure of the torque link bolt which resulted in the right main landing gear strut scissors separating and becoming jammed in the wheel well. Contributing to the accident was the seized torque link bolt due to surface corrosion.
- [NTSB LAX07LA065](https://openairdocs.org/ntsb/LAX07LA065.md): Beech A36 · Lake Hughes, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2006 · N4598S · Substantial damage
  > The pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.
- [NTSB DFW07CA044](https://openairdocs.org/ntsb/DFW07CA044.md): Cessna 150M · Eastland, TX · Accident · No injuries · Data collection · Final report · Dec 27, 2006 · N9364U · Substantial damage
  > The partial loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and an overrun. A factor associated with the accident was the pilot's misjudged distance/speed while landing.
- [NTSB CHI07CA047](https://openairdocs.org/ntsb/CHI07CA047.md): Cessna T210L · North St. Louis, MO · Accident · Minor injuries · Data collection · Final report · Dec 27, 2006 · N6864C · Substantial damage
  > Fuel starvation due to an inadequate fuel supply. A factor associated with the accident was the soft terrain encountered during the landing.
- [NTSB DEN07CA039](https://openairdocs.org/ntsb/DEN07CA039.md): Cessna T210M · Broomfield, CO · Accident · No injuries · Data collection · Final report · Dec 25, 2006 · N6051N · Substantial damage
  > the failure of the mechanic to comply with the required replacement schedule resulting in the failure of the hydraulic line and the resulting gear up landing.
- [NTSB MIA07FA029](https://openairdocs.org/ntsb/MIA07FA029.md): Cessna 421B · Greenhead, FL · Accident · 5 fatal · Field investigation · Final report · Dec 22, 2006 · N70BC · Destroyed
  > The pilot-in-command's improper planning/decision and continued flight into known adverse weather which resulted in an encounter with a level 5 thunderstorm.
- [NTSB LAX07FA061](https://openairdocs.org/ntsb/LAX07FA061.md): Piper PA-28-140 · Bridgeport, CA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2006 · N8001H · Destroyed
  > The pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.
- [NTSB LAX07LA058](https://openairdocs.org/ntsb/LAX07LA058.md): Cessna 152 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Dec 21, 2006 · N5295B · Substantial damage
  > a loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.
- [NTSB CHI07CA044](https://openairdocs.org/ntsb/CHI07CA044.md): Piper PA-22-150 · Cheyboygan, MI · Accident · No injuries · Data collection · Final report · Dec 20, 2006 · N5811D · Substantial damage
  > A loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.
- [NTSB LAX07FA062](https://openairdocs.org/ntsb/LAX07FA062.md): Cirrus Design SR22 · Young, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N457S · Destroyed
  > The pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…
- [NTSB CHI07FA041](https://openairdocs.org/ntsb/CHI07FA041.md): Piper PA-24-260 · Bucyrus, OH · Accident · 4 fatal · Field investigation · Final report · Dec 18, 2006 · N9073P · Destroyed
  > The inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…
- [NTSB MIA07LA028](https://openairdocs.org/ntsb/MIA07LA028.md): Cessna 150K · Cape Coral, FL · Accident · No injuries · Limited investigation · Final report · Dec 17, 2006 · N6069G · Substantial damage
  > The pilot's in-flight encounter with carburetor ice and inadequate remedial action which resulted in the engine ceasing to operate and a forced landing and damage to the airplane during the landing.
- [NTSB DFW07FA039](https://openairdocs.org/ntsb/DFW07FA039.md): Bellanca 17-30A · Jay, OK · Accident · 3 fatal · Field investigation · Final report · Dec 17, 2006 · N39858 · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's improper decision to extend the landing gear for the water landing. Contributing factors were the prevailing night conditions and the lack of suitable terrain for the forced landing.
- [NTSB ATL07LA028](https://openairdocs.org/ntsb/ATL07LA028.md): Scharnhorst RV-4 · Hoschton, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 2006 · N360WS · Substantial damage
  > The failure of the manufacturer to safety wire the purge valve stop screw during maintenance resulting in a total loss of engine power in cruise flight due to fuel starvation. This resulted in a forced landing, on-ground collision with a berm/terrace, and…
- [NTSB DEN07IA037](https://openairdocs.org/ntsb/DEN07IA037.md): Boeing 737-824 · Colorado Spring, CO · Incident · Minor injuries · Incident investigation · Final report · Dec 16, 2006 · N24202 · Minor damage
  > A short circuit in the primary (non-rechargeable) battery, most likely due to it being recharged. This internal short led to thermal runaway, battery failure, and an explosion.
- [NTSB CHI07LA038](https://openairdocs.org/ntsb/CHI07LA038.md): Beech B36TC · Peoria, IL · Accident · No injuries · Limited investigation · Final report · Dec 14, 2006 · N30799 · Destroyed
  > The loss of engine power due to a fatigue fracture of the exhaust valve as a result of maintenance not performed by the aircraft owner, and the unsuitable terrain encountered during the forced landing.
- [NTSB ANC07FA007](https://openairdocs.org/ntsb/ANC07FA007.md): Piper PA-32-301 · Port Heiden, AK · Accident · 2 fatal · Field investigation · Final report · Dec 14, 2006 · N8361Q · Destroyed
  > The pilot's failure to maintain control of the airplane during cruise flight, which resulted in an uncontrolled descent, and an in-flight collision with snow-covered terrain. Contributing to the accident were the pilot's spatial disorientation, and dark night…
- [NTSB ATL07CA027](https://openairdocs.org/ntsb/ATL07CA027.md): Piper J-2 · Williamson, GA · Accident · Serious injuries · Data collection · Final report · Dec 13, 2006 · N16651 · Substantial damage
  > The pilot's inadequate preflight inspection which resulted in fuel exhaustion a subsequent total loss of engine power.
- [NTSB CHI07IA042](https://openairdocs.org/ntsb/CHI07IA042.md): Bell 407 · Raytown, MO · Incident · No injuries · Incident investigation · Final report · Dec 12, 2006 · N302LE · Minor damage
  > The loss of engine power during cruise flight due to third stage turbine wheel blade fatigue and subsequent separation, which resulted in an emergency landing.
- [NTSB LAX07FA056](https://openairdocs.org/ntsb/LAX07FA056.md): Bell 412SP · Hesperia, CA · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2006 · N410MA · Destroyed
  > The pilot's inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain terrain clearance. Contributing to the accident were the dark night conditions, fog, and mountainous terrain.
- [NTSB ATL07LA026](https://openairdocs.org/ntsb/ATL07LA026.md): Ridgway Bensen B8M · Johns Island, SC · Accident · No injuries · Limited investigation · Final report · Dec 10, 2006 · N7030T · Substantial damage
  > The pilots improper preflight planning and decision resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB SEA07LA028](https://openairdocs.org/ntsb/SEA07LA028.md): Robinson R-22 · Bountiful, UT · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2006 · N611SC · Substantial damage
  > The pilot's improper decision to fly up a mountain canyon at low level without knowledge of the wind conditions. Factors associated with the accident are gusty winds, downdrafts, and rough/uneven terrain.
- [NTSB SEA07CA027](https://openairdocs.org/ntsb/SEA07CA027.md): Piper PA-12 · Antelope Island, UT · Accident · No injuries · Data collection · Final report · Dec 9, 2006 · N3222M · Substantial damage
  > The pilot's excessive braking during a precautionary landing at an off-airport landing area. A contributing factor was the pilot's non-standard modification of the oil cooler, which resulted in high engine oil temperature.
- [NTSB CHI07LA039](https://openairdocs.org/ntsb/CHI07LA039.md): Cessna 140 · Vienna, MO · Accident · No injuries · Limited investigation · Final report · Dec 9, 2006 · N76379 · Substantial damage
  > The loss of engine power during cruise flight due to fatigued crankshaft cluster gear bolts and the inadequate major overhaul of the engine that was last performed by other maintenance personnel. An additional cause was a subsequent major engine overhaul not…
- [NTSB NYC07FA041](https://openairdocs.org/ntsb/NYC07FA041.md): Mooney M20R · Summersville, WV · Accident · 1 fatal · Field investigation · Final report · Dec 7, 2006 · N9165T · Destroyed
  > The airplane's encounter with in-flight icing, which resulted in a loss of engine power. Contributing to the accident were the pilot's improper weather evaluation, the in-flight icing conditions, the reduced visibility from a snow squall during the forced…
- [NTSB LAX07LA052](https://openairdocs.org/ntsb/LAX07LA052.md): Cessna 150G · Eureka, CA · Accident · No injuries · Limited investigation · Final report · Dec 6, 2006 · N3394J · Substantial damage
  > a loss of engine power due to carburetor icing and the pilot's inadequate preflight planning and decision to operate the airplane in carburetor icing conditions with an inoperative carburetor heat system.
- [NTSB ATL07LA024](https://openairdocs.org/ntsb/ATL07LA024.md): Piper PA-15 · Conyers, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2006 · N4540H · Substantial damage
  > Loss of engine oil for undetermined reasons resulting in oil starvation, failure of the No. 1 connecting rod resulting in the total loss of engine power.
- [NTSB DFW07CA034](https://openairdocs.org/ntsb/DFW07CA034.md): Piper PA-24-250 · Jacksboro, TX · Accident · No injuries · Data collection · Final report · Dec 3, 2006 · N5697P · Substantial damage
  > The pilot's improper fuel calculations, which resulted in a loss of engine power due to fuel exhaustion. A factor was the unsuitable terrain encountered during the emergency landing.
- [NTSB CHI07LA035](https://openairdocs.org/ntsb/CHI07LA035.md): Piper PA 46-350P · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Dec 3, 2006 · N46PT · Substantial damage
  > The exceedance of airplane design stress limits when the pilot did not maintain aircraft control after his attention was diverted to the right side attitude indicator during cruise flight. An additional cause was the aural detection for the autopilot…
- [NTSB DFW07LA027](https://openairdocs.org/ntsb/DFW07LA027.md): Bell BH 206L-3 · Brownwood, TX · Accident · No injuries · Limited investigation · Final report · Nov 26, 2006 · N805SB · Substantial damage
  > The fracture of the turbine-to-compressor coupling and subsequent overspeed failure of the first stage turbine wheel as result of the improper re-assembly of the engine by maintenance personnel. A contributing factor was the lack of suitable terrain for the…
- [NTSB LAX07CA046](https://openairdocs.org/ntsb/LAX07CA046.md): Cessna T210M · Las Vegas, NV · Accident · No injuries · Data collection · Final report · Nov 24, 2006 · N977SA · Substantial damage
  > fuel exhaustion due to the pilot's inadequate fuel consumption calculations and his failure to refuel the airplane during the cross-country flight,.
- [NTSB DFW07LA029](https://openairdocs.org/ntsb/DFW07LA029.md): Beech V35 · Mountain View, AR · Accident · No injuries · Limited investigation · Final report · Nov 22, 2006 · N205DB · Substantial damage
  > The loss of engine power due to oil starvation as a result of a broken oil pressure line. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC07LA033](https://openairdocs.org/ntsb/NYC07LA033.md): Piper PA-32RT-300 · Bardstown, KY · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 2006 · N3887M · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB LAX07LA040](https://openairdocs.org/ntsb/LAX07LA040.md): Stinson 108-1 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2006 · N97949 · Substantial damage
  > Partial loss of engine power due to a seized exhaust valve during cruise flight. Rough terrain at the forced landing site was a contributing factor.
- [NTSB LAX07LA039](https://openairdocs.org/ntsb/LAX07LA039.md): Cessna 172RG · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2006 · N28RJ · Substantial damage
  > An undetermined total electrical failure. The pilot's failure to extend the landing gear to the down and locked position was a factor.
- [NTSB CHI07FA026](https://openairdocs.org/ntsb/CHI07FA026.md): Piper PA-28-235 · Wellington, IL · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2006 · N8990W · Destroyed
  > Spatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…
- [NTSB CHI07FA022](https://openairdocs.org/ntsb/CHI07FA022.md): Cessna T303 · Mill Creek, IN · Accident · 5 fatal · Field investigation · Final report · Nov 14, 2006 · N611BB · Destroyed
  > The pilot became spatially disoriented and as a result failed to maintain control of the airplane. Factors associated with the accident were the instrument meteorological conditions aloft and the pilot being fatigued.
- [NTSB DEN07LA024](https://openairdocs.org/ntsb/DEN07LA024.md): Bell UH-1H · Melrose, NM · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2006 · N24CF · Substantial damage
  > the in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.
- [NTSB DFW07LA024](https://openairdocs.org/ntsb/DFW07LA024.md): Beech A36 · Pocasset, OK · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 2006 · N711A · Substantial damage
  > The "abnormally high" oil temperature indication and smoke in the cabin for undetermined reasons. A contributing factor was the lack of suitable terrain for the precautionary landing.
- [NTSB NYC07LA026](https://openairdocs.org/ntsb/NYC07LA026.md): Vogel Glastar 41 · Snow Shoe, PA · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2006 · N441AV · Substantial damage
  > The builder's improper installation of an additional alternator. Contributing to the accident were the night lighting conditions.
- [NTSB MIA07LA013](https://openairdocs.org/ntsb/MIA07LA013.md): Winter J.T/Johnson Kitfox III · Southwest Ranch, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2006 · N727PD · Substantial damage
  > The owner/builder's improper maintenance/installation of the propeller which resulted in a propeller blade coming loose and separating from the hub.
- [NTSB ATL07CA018](https://openairdocs.org/ntsb/ATL07CA018.md): Grumman G-164B · Pine Hill, AL · Accident · No injuries · Data collection · Final report · Nov 9, 2006 · N962QC · Substantial damage
  > The pilot's improper fuel management resulting in a total loss of engine power in cruise flight due to fuel exhaustion, subsequent forced landing to non suitable terrain, and an on-ground collision with tree stumps on the landing roll out.
- [NTSB ATL07LA014](https://openairdocs.org/ntsb/ATL07LA014.md): Carlson Lancair Propjet · Dalton, GA · Accident · 1 fatal · Limited investigation · Final report · Nov 6, 2006 · N750LC · Substantial damage
  > The pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. Contributing to the accident was the pilot's mismanagement of the fuel supply, which resulted in loss of engine due to fuel starvation.
- [NTSB DFW07FA020](https://openairdocs.org/ntsb/DFW07FA020.md): Piper PA-32-300 · Danville, AR · Accident · 3 fatal · Field investigation · Final report · Nov 5, 2006 · N15852 · Destroyed
  > Failure of the number 5 cylinder which resulted in oil starvation and the subsequent loss of engine power, and the pilot's inability to see the transmission line during the forced landing. Factors Contributing to the accident were the dark night and the…
- [NTSB DFW07FA019](https://openairdocs.org/ntsb/DFW07FA019.md): Cessna 172S · Hominy, OK · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2006 · N53443 · Destroyed
  > The pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.
- [NTSB DEN07CA019](https://openairdocs.org/ntsb/DEN07CA019.md): Luscombe 8F · Wellsville, KS · Accident · No injuries · Data collection · Final report · Nov 5, 2006 · N26324 · Substantial damage
  > A loss of engine power due to the ingestion of the number 2 intake valve into its cylinder. Contributing factors included the pilot allowing the airspeed and altitude to drop, making a safe landing not possible.
- [NTSB ANC07FA006](https://openairdocs.org/ntsb/ANC07FA006.md): Cessna 180E · Cordova, AK · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2006 · N4141J · Substantial damage
  > A loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and collision with an embankment.

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.