OpenAirDocs.org

NTSB investigations, 2004

380 cases where the phase of flight was Enroute.

Cases per year

19622026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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\") = 2004
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB NYC05LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lawrenceburg, KYThe pilot's inadequate pre-flight planning and in-flight planning decision, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing.Dec 31, 2004 · N8141T · Substantial damageNTSB LAX05LA057Accident · No injuriesLimited investigationFinal reportOrr Long-Ez · Yucca Valley, CAa loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.Dec 31, 2004 · N321EZ · Substantial damageNTSB DFW05IA048Incident · No injuriesIncident investigationFinal reportBeech A36 · Natchitoches, LAThe loss of engine power due to pre-ignition and detonation. Contributing factors were the lack of suitable terrain available for the forced landing and the unapproved installation of a turbocharger.Dec 29, 2004 · N920GL · Minor damageNTSB DEN05FA045Accident · 1 fatalField investigationFinal reportPiper PA-31P · Gallup, NMthe pilot's failure to maintain minimum controllable airspeed which resulted in the loss of control, and impact with wires, a tree and terrain.Dec 29, 2004 · N573B · DestroyedNTSB CHI05FA049Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Ironwood, MIFatigue fracture of an engine cylinder resulting in a loss of power on the left engine. Additional causes were the pilot's failure to maintain minimum control airspeed (Vmc), the resulting loss of aircraft control, and an inadvertent stall/spin. Contributing…Dec 28, 2004 · N5398M · Substantial damageNTSB LAX05CA055Accident · No injuriesData collectionFinal reportTop Dog Trike · Torrey Pines, CAthe pilot's inadequate visual lookout, which resulted in the in-flight collision with a power line and a subsequent forced landing. Low altitude flight was a contributing factor.Dec 26, 2004 · UNREG · Substantial damageNTSB IAD05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150C · East Moriches, NYSeveral mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.Dec 25, 2004 · N7857Z · Substantial damageNTSB CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…Dec 25, 2004 · N5631K · Substantial damageNTSB DEN05LA043Accident · No injuriesLimited investigationFinal reportMooney M20E · Telluride, COthe pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.Dec 23, 2004 · N5550Q · Substantial damageNTSB LAX05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jean, NVthe pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.Dec 19, 2004 · N32034 · Substantial damageNTSB DEN05LA041Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Steamboat Spngs, COthe loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.Dec 18, 2004 · N78AT · Substantial damageNTSB DFW05FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Abita Springs, LAThe loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…Dec 14, 2004 · N4873C · DestroyedNTSB CHI05LA045Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · South Bend, INFailure of the fuel control unit (FCU) bellows which resulted in a significant loss of engine power and the pilot's encounter with unsuitable terrain during the subsequent forced landing. A contributing factor was the pilot's inadvertent exceedence of the…Dec 14, 2004 · N922RG · Substantial damageNTSB ANC05LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Sleetmute, AKA loss of engine power during cruise flight due to a fractured exhaust valve, which resulted in a forced landing, and subsequent nose over of the airplane. A factor associated with the accident was the lack of suitable terrain for a successful emergency…Dec 14, 2004 · N801FS · Substantial damageNTSB LAX05LA050Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Ontario, CAa loss of engine power due to the Designated Pilot Examiner's failure to follow the flight manual procedures and directives regarding throttle settings to be used for practice autorotations.Dec 11, 2004 · N130JS · Substantial damageNTSB LAX05LA049Accident · No injuriesLimited investigationFinal reportRobinson R22B · Los Angeles, CAThe activation of the low main rotor rpm warning system for undetermined reasons.Dec 11, 2004 · N145RJ · Substantial damageNTSB DFW05LA033Accident · No injuriesLimited investigationFinal reportMooney M20F · Fabens, TXThe loss of engine power as a result of the failure of a connecting rod due to oil starvation/exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Dec 9, 2004 · N3208F · Substantial damageNTSB LAX05FA046Accident · 1 fatalField investigationFinal reportCessna T207A · Meadview, AZa loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.Dec 8, 2004 · N1783U · DestroyedNTSB IAD05LA024Accident · Minor injuriesLimited investigationFinal reportHare Seawind · Trenton, NJThe pilot's improper fuel management which resulted in fuel starvation and subsequent loss of engine power. A contributing factor to the accident was the pilot's inadvertent loss of airspeed.Dec 8, 2004 · N42HA · Substantial damageNTSB CHI05CA041Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlantic, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The dark night light conditions was a contributing factor.Dec 5, 2004 · N7803Y · Substantial damageNTSB ANC05IA016Incident · No injuriesIncident investigationFinal reportBoeing 747SR-146B SF · Anchorage, AKThe fatigue and subsequent fracture of a portion of the airplane's pressure bulkhead, which resulted in a rapid decompression during cruise flight.Dec 5, 2004 · JA8158 · Minor damageNTSB NYC05IA029Incident · No injuriesIncident investigationFinal reportFairchild-Heliporter Pilatus PC6/B2-H2 · Cross Keys, NJA total failure of the left elevator attachment point for undetermined reasons.Dec 4, 2004 · N7391U · Minor damageNTSB MIA05FA040Accident · No injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340 · N. Miami Beach, FLThe improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…Dec 4, 2004 · N41626 · Substantial damageNTSB DFW05LA027Accident · No injuriesLimited investigationFinal reportCessna P210N · Pawhuska, OKThe pilot's mismanagement of the fuel by his failure to adequately set the fuel selector position which resulted in fuel exhaustion and the loss of engine power.Dec 1, 2004 · N6300P · Substantial damageNTSB LAX05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Big Pine, CAoil exhaustion due to an improper oil breather tube installation, which became plugged in flight due to frozen moisture build-up. The blocked breather tube then created a crankcase over pressure that caused a failure of the crankshaft seal. The rough, uneven…Nov 28, 2004 · N4913Z · Substantial damageNTSB CHI05LA037Accident · No injuriesLimited investigationFinal reportCessna 172H · Belle Plaine, MNA loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.Nov 28, 2004 · N2663L · Substantial damageNTSB SEA05FA019Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Arlington, WAThe divergence of the main rotor from its normal plane of rotation for an undetermined reason, resulting in rotor contact with the aircraft's left windscreen. The failure of the door pins to be installed was a factor.Nov 27, 2004 · N4029Q · DestroyedNTSB IAD05LA017Accident · No injuriesLimited investigationFinal reportChumsae Kitfox Speedster · Sterling, MAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and a total loss of engine power.Nov 27, 2004 · N124KF · Substantial damageNTSB IAD05FA023Accident · 6 fatalClass 1 · FieldFinal reportCASA 212-200-CC · Bamiyan, Afghanistanthe captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…Nov 27, 2004 · N960BW · DestroyedNTSB DFW05LA025Accident · Minor injuriesLimited investigationFinal reportWingo Long-Ez · Huntsville, TXLoss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.Nov 25, 2004 · N234BW · Substantial damageNTSB CHI05CA036Accident · No injuriesData collectionFinal reportSpaulding Tailwind W-8 · Davey, NEThe loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.Nov 24, 2004 · N191AS · Substantial damageNTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.Nov 21, 2004 · N3750S · Substantial damageNTSB CHI05CA032Accident · Serious injuriesData collectionFinal reportOlson Sonex · Oconomowoc, WIThe loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…Nov 21, 2004 · N478SX · Substantial damageNTSB MIA05CA030Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Panama City Bch, FLThe pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.Nov 17, 2004 · N595H · Substantial damageNTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.Nov 14, 2004 · N56960 · Substantial damageNTSB LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.Nov 14, 2004 · N6111C · DestroyedNTSB DEN05LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Lyons, COthe pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.Nov 14, 2004 · N48943 · DestroyedNTSB ATL05CA024Accident · No injuriesData collectionFinal reportCessna 172N · Wilmington, NCThe student pilot's failure to recognize the proper emergency procedure, which resulted in a precautionary landing in a field and subsequent collision with a ditch. Factors were the undetermined electrical malfunction, smoke in the cockpit, and the student…Nov 14, 2004 · N75776 · Substantial damageNTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.Nov 12, 2004 · N6539P · DestroyedNTSB LAX05FA032Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Santa Barbara, CAThe pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…Nov 11, 2004 · N803ZG · DestroyedNTSB LAX05CA030Accident · No injuriesData collectionFinal reportCessna P210N · Rancho Cordova, CAThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…Nov 11, 2004 · N6416W · Substantial damageNTSB LAX05LA020Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350-BA · Oxnard, CAThe inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…Nov 9, 2004 · N655TV · Substantial damageNTSB DFW05LA019Accident · Minor injuriesLimited investigationFinal reportBell 206L1 · Sapulpa, OKThe loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.Nov 9, 2004 · N1075P · Substantial damageNTSB DFW05LA023Accident · No injuriesLimited investigationFinal reportCessna 150M · Longview, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 6, 2004 · N704KX · Substantial damageNTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.Nov 6, 2004 · N90JW · Substantial damageNTSB MIA05FA024Accident · 2 fatalField investigationFinal reportSocata TB 20 · Key West, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.Nov 5, 2004 · N1905S · DestroyedNTSB DFW05LA017Accident · Serious injuriesLimited investigationFinal reportBell 206B · S.Timbelier 187The loss of engine power for undetermined reasons.Nov 5, 2004 · N496RL · DestroyedNTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.Nov 5, 2004 · N2695W · Substantial damageNTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.Nov 5, 2004 · N711AH · Substantial damageNTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.Oct 31, 2004 · N95902 · Destroyed