# NTSB investigations, 2005: 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 8 · 390 cases

## Latest cases

- [NTSB DFW06CA048](https://openairdocs.org/ntsb/DFW06CA048.md): Bell 206L-4 · Washington, LA · Accident · Minor injuries · Data collection · Final report · Dec 30, 2005 · N1811 · Substantial damage
  > The in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.
- [NTSB ATL06FA029](https://openairdocs.org/ntsb/ATL06FA029.md): Cirrus Design SR22 · Sylva, NC · Accident · 2 fatal · Field investigation · Final report · Dec 29, 2005 · N799TM · Destroyed
  > The pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.
- [NTSB SEA06LA033](https://openairdocs.org/ntsb/SEA06LA033.md): McDonnell Douglas MD-83 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Dec 27, 2005 · N979AS · Substantial damage
  > The ground personnel baggage handler failed to maintain clearance from the aircraft with cargo handling equipment during ground operations and inadvertently damaged the airplane's pressure bulkhead which subsequently decompressed during climb to cruise.
- [NTSB ATL06LA028](https://openairdocs.org/ntsb/ATL06LA028.md): Cessna 177-RG · Locust Grove, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2005 · N53257 · Substantial damage
  > The total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.
- [NTSB ATL06LA027](https://openairdocs.org/ntsb/ATL06LA027.md): Piper PA32-300 · Maiden, NC · Accident · No injuries · Limited investigation · Final report · Dec 27, 2005 · N2887M · Substantial damage
  > The total loss of engine power due to the failure of the No. 5 main bearing due to overheating for undetermined reasons.
- [NTSB DFW06LA041](https://openairdocs.org/ntsb/DFW06LA041.md): Boeing A75N1 (PT17) · Fort Worth, TX · Accident · 1 fatal · Limited investigation · Final report · Dec 26, 2005 · N67195 · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. Contributing factors were the reported loss of engine power for undetermined reasons and the low altitude maneuver.
- [NTSB SEA06CA032](https://openairdocs.org/ntsb/SEA06CA032.md): Piper PA-28-151 · Emmett, ID · Accident · No injuries · Data collection · Final report · Dec 25, 2005 · N5695V · Destroyed
  > The pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.
- [NTSB LAX06LA068](https://openairdocs.org/ntsb/LAX06LA068.md): Piper PA-28-180 · Hopland, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 25, 2005 · N3953R · Destroyed
  > The non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.
- [NTSB MIA06CA040](https://openairdocs.org/ntsb/MIA06CA040.md): Beech BE23 · Palatka, FL · Accident · No injuries · Data collection · Final report · Dec 24, 2005 · N7657R · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB MIA06CA034](https://openairdocs.org/ntsb/MIA06CA034.md): Cessna 182 · Haines City, FL · Accident · No injuries · Data collection · Final report · Dec 24, 2005 · N8304S · Substantial damage
  > The pilot's improper preflight planning/preparation, and operation of equipment with known deficiencies, a right wing fuel cap leak, which resulted in fuel exhaustion and the loss of engine power.
- [NTSB LAX06LA067](https://openairdocs.org/ntsb/LAX06LA067.md): Forrest Haynes Lancair 320 · Ramona, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 2005 · N320WH · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB LAX06LA064](https://openairdocs.org/ntsb/LAX06LA064.md): Cessna 172 · Gilroy, CA · Accident · 4 fatal · Limited investigation · Final report · Dec 22, 2005 · N7383A · Destroyed
  > The non-instrument rated pilot's poor judgment to fly in dark night instrument conditions, which resulted in his spatial disorientation and loss of aircraft control while maneuvering. Contributing factors were the dark night light condition and the low…
- [NTSB ATL06CA026](https://openairdocs.org/ntsb/ATL06CA026.md): Eurocopter France AS-350-B2 · Jasper, AL · Accident · Serious injuries · Data collection · Final report · Dec 22, 2005 · N350ET · Substantial damage
  > The pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.
- [NTSB DCA06MA010](https://openairdocs.org/ntsb/DCA06MA010.md): Grumman G-73T · Miami, FL · Accident · 20 fatal · Class 1 · Major · Final report · Dec 19, 2005 · N2969 · Destroyed
  > The in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…
- [NTSB MIA06LA041](https://openairdocs.org/ntsb/MIA06LA041.md): Cessna 195 · St. Augustine, FL · Accident · 3 fatal · Limited investigation · Final report · Dec 18, 2005 · N22L · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.
- [NTSB DFW06LA040](https://openairdocs.org/ntsb/DFW06LA040.md): Bellanca 17-30A · Columbus, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 2005 · N78SV · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX06LA058](https://openairdocs.org/ntsb/LAX06LA058.md): Cessna 177RG · Dixon, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 15, 2005 · N8040G · Substantial damage
  > the pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.
- [NTSB DEN06FA023](https://openairdocs.org/ntsb/DEN06FA023.md): Cessna 172S · Pinon, NM · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2005 · N1257Z · Destroyed
  > the pilot's failure to maintain control of the airplane for undetermined reasons.
- [NTSB LAX06FA055](https://openairdocs.org/ntsb/LAX06FA055.md): Beech A23 · Mammoth Lakes, CA · Accident · 2 fatal · Field investigation · Final report · Dec 12, 2005 · N3590R · Destroyed
  > a loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.
- [NTSB CHI06FA043](https://openairdocs.org/ntsb/CHI06FA043.md): Cirrus Design SR22 · Arco, MN · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2005 · N621PH · Destroyed
  > The pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…
- [NTSB LAX06FA054](https://openairdocs.org/ntsb/LAX06FA054.md): Piper PA-32RT-300 · Kingsburg, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2005 · N3039B · Destroyed
  > The pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.
- [NTSB MIA06LA026](https://openairdocs.org/ntsb/MIA06LA026.md): Cessna 152 · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Dec 8, 2005 · N49815 · Substantial damage
  > A loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.
- [NTSB LAX06CA081](https://openairdocs.org/ntsb/LAX06CA081.md): Burkhart Grob G 103 Twin II · Llano, CA · Accident · No injuries · Data collection · Final report · Dec 3, 2005 · N4601M · Substantial damage
  > The flight's encounter with downdrafts. A contributing factor was the unsuitable vegetation-covered mountainous terrain.
- [NTSB LAX06CA050](https://openairdocs.org/ntsb/LAX06CA050.md): Mooney M20A · China Lake, CA · Accident · Minor injuries · Data collection · Final report · Dec 2, 2005 · N6004X · Substantial damage
  > fuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.
- [NTSB DCA06IA007](https://openairdocs.org/ntsb/DCA06IA007.md): Raytheon Corporate Jets Beechjet 400 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Nov 28, 2005 · N691TA · Minor damage
  > The dual-engine flameout due to high-altitude ice crystals that had accreted onto the JT15D-5 engines' compressor vanes and were ingested into the engine when the pilots retarded the power levers, resulting in compressor surges and rapid reduction in fuel…
- [NTSB CHI06FA037](https://openairdocs.org/ntsb/CHI06FA037.md): Piper PA-28-140 · Atlanta, NE · Accident · 3 fatal · Field investigation · Final report · Nov 27, 2005 · N5596F · Destroyed
  > The non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.
- [NTSB NYC06LA038](https://openairdocs.org/ntsb/NYC06LA038.md): Piper PA-24-180 · Lincoln Park, NJ · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2005 · N6858P · Substantial damage
  > The improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.
- [NTSB MIA06FA024](https://openairdocs.org/ntsb/MIA06FA024.md): Piper PA-32-300 · Mims, FL · Accident · 2 fatal · Field investigation · Final report · Nov 23, 2005 · N666DE · Substantial damage
  > The loss of engine power due to improper installation of the #2 cylinder by maintenance personnel, which resulted in the separation of the cylinder as a result of fatigue cracking of the cylinder to crankcase fasteners. A contributing factor was the lack of…
- [NTSB DFW06CA033](https://openairdocs.org/ntsb/DFW06CA033.md): Piper PA-23-250 · Bixby, OK · Accident · No injuries · Data collection · Final report · Nov 23, 2005 · N859DA · Substantial damage
  > The loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA040](https://openairdocs.org/ntsb/CHI06CA040.md): Piper PA-28-180 · Marshall, MO · Accident · Minor injuries · Data collection · Final report · Nov 23, 2005 · N3619R · Substantial damage
  > An in-flight loss of engine power in descent due to fuel exhaustion, and the pilot's inaccurate preflight planning. Contributing to the accident was the unsuitable terrain the pilot encountered and the night conditions.
- [NTSB LAX06LA044](https://openairdocs.org/ntsb/LAX06LA044.md): Piper PA-24-250 · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 2005 · N7466P · Substantial damage
  > the separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.
- [NTSB LAX06FA043](https://openairdocs.org/ntsb/LAX06FA043.md): Cessna T210N · Dana Point, CA · Accident · 4 fatal · Field investigation · Final report · Nov 19, 2005 · N546BC · Destroyed
  > The pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.
- [NTSB CHI06TA033](https://openairdocs.org/ntsb/CHI06TA033.md): Schweizer 269C · Manhattan, KS · Accident · No injuries · Final report · Nov 18, 2005 · N400PD · Substantial damage
  > The binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…
- [NTSB MIA06LA019](https://openairdocs.org/ntsb/MIA06LA019.md): Piper PA-28R-180 · Heathrow, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2005 · N7453J · Substantial damage
  > A partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.
- [NTSB DEN06LA014](https://openairdocs.org/ntsb/DEN06LA014.md): Cessna 172L · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Nov 16, 2005 · N2870Q · Substantial damage
  > the loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.
- [NTSB CHI06LA036](https://openairdocs.org/ntsb/CHI06LA036.md): Cessna T310R · Fergus Falls, MN · Accident · No injuries · Limited investigation · Final report · Nov 15, 2005 · N5094C · Substantial damage
  > The presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.
- [NTSB ATL06CA015](https://openairdocs.org/ntsb/ATL06CA015.md): Piper PA-32-260 · Bryson City, NC · Accident · Minor injuries · Data collection · Final report · Nov 14, 2005 · N1186X · Substantial damage
  > The loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.
- [NTSB LAX06CA033](https://openairdocs.org/ntsb/LAX06CA033.md): Rotorway 162F · Chandler, AZ · Accident · No injuries · Data collection · Final report · Nov 13, 2005 · N321JN · Substantial damage
  > a loss of engine power due to fuel contamination (rust, water) as a result of the pilot's inadequate preflight planning preparation.
- [NTSB CHI06LA031](https://openairdocs.org/ntsb/CHI06LA031.md): Piper PA-28-181 · Milwaukee, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 2005 · N2241P · Substantial damage
  > The loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…
- [NTSB LAX06CA035](https://openairdocs.org/ntsb/LAX06CA035.md): Vans RV-4 · Apple Valley, CA · Accident · No injuries · Data collection · Final report · Nov 12, 2005 · N14GK · Substantial damage
  > a partial loss of engine power for undetermined reasons.
- [NTSB LAX06LA030](https://openairdocs.org/ntsb/LAX06LA030.md): Bell 47D1 · Rancho Murieta, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 2005 · N16356 · Substantial damage
  > a separation of the tail rotor assembly due to the reverse bending fatigue fracture of a tail rotor pitch change link bolt, resulting in a loss of control of the helicopter, and a hard landing during the uncontrolled descent.
- [NTSB LAX06FA031](https://openairdocs.org/ntsb/LAX06FA031.md): Beech F33A · Geyserville, CA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2005 · N9204Q · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.
- [NTSB CHI06FA030](https://openairdocs.org/ntsb/CHI06FA030.md): Piper PA-23-160 · Bloomington, IL · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2005 · N4319P · Substantial damage
  > The aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.
- [NTSB NYC06FA027](https://openairdocs.org/ntsb/NYC06FA027.md): Embraer 110P1 · Manchester, NH · Accident · Serious injuries · Field investigation · Final report · Nov 8, 2005 · N7801Q · Destroyed
  > The pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…
- [NTSB DEN06FA013](https://openairdocs.org/ntsb/DEN06FA013.md): Beech A36 · Datil, NM · Accident · 1 fatal · Field investigation · Final report · Nov 8, 2005 · N1548Y · Destroyed
  > the pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.
- [NTSB CHI06FA026](https://openairdocs.org/ntsb/CHI06FA026.md): Piper PA-31-350 · Ankeny, IA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2005 · N27177 · Destroyed
  > The pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…
- [NTSB LAX06CA026](https://openairdocs.org/ntsb/LAX06CA026.md): Piper PA-28-161 · Payson, AZ · Accident · No injuries · Data collection · Final report · Nov 7, 2005 · N2111P · Substantial damage
  > a loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…
- [NTSB MIA06LA015](https://openairdocs.org/ntsb/MIA06LA015.md): Piper PA-28R-180 · Opa-Locka, FL · Accident · No injuries · Limited investigation · Final report · Nov 6, 2005 · N4652J · Substantial damage
  > The failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.
- [NTSB DFW06CA022](https://openairdocs.org/ntsb/DFW06CA022.md): Piper PA38 · Decatur, TX · Accident · No injuries · Data collection · Final report · Nov 6, 2005 · N2593P · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA028](https://openairdocs.org/ntsb/CHI06CA028.md): Cessna 182 · Butler, MO · Accident · No injuries · Data collection · Final report · Nov 6, 2005 · N5784B · Substantial damage
  > The damage to the horizontal stabilizer was a result of the inadvertent deployment of the skydiver's reserve parachute.

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

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