OpenAirDocs.org

NTSB investigations, 1994

498 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\") = 1994
    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 MIA95LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeland, FLFatigue failure of the engine no.1 valve spring that jammed the intake valve open resulting in partial loss of engine power.Dec 31, 1994 · N4300S · Substantial damageNTSB LAX95LA067Accident · 1 fatalLimited investigationFinal reportHarris BD-10 · Gardnerville, NVthe in-flight overload failure of the left vertical stabilizer spars, at force levels substantially below the predicted ultimate failure loads, due to inadequate substantiation by the designer.Dec 31, 1994 · N9WZ · DestroyedNTSB LAX95FA340Accident · 1 fatalField investigationFinal reportCessna 182B · Rancho Cucamong, CAthe failure of the pilot to maintain adequate altitude above mountainous terrain.Dec 31, 1994 · N2569G · DestroyedNTSB LAX95FA068Accident · 2 fatalField investigationFinal reportGrumman AA-5A · San Luis Obispo, CAthe pilot's intentional flight into an area of known marginal weather conditions during a night cross-country flight and the flight's subsequent inadvertent entry into instrument meteorological conditions at an altitude insufficient to remain clear of the…Dec 31, 1994 · N26443 · DestroyedNTSB CHI95LA064Accident · Minor injuriesLimited investigationFinal reportNorth American F-51D · Round Lake, ILfuel starvation resulting from exhaustion of the fuel supply in the left tank. A factor related to the accident was insufficient altitude to switch fuel tanks and effect an engine restart.Dec 29, 1994 · N51TK · Substantial damageNTSB SEA95LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Murphy, IDThe pilot's failure to maintain altitude/clearance from the terrain. Factors include a dark night and a strong headwind.Dec 28, 1994 · N9107X · DestroyedNTSB MIA95FA042Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Plant City, FLThe opening of the engine cowling latch in cruise flight for undetermined reasons. This resulted in the puncture of the engine oil cooler, total exhaustion of the engine oil, failure of the No. 6 connecting rod, rod bolts, forced landing while on final…Dec 28, 1994 · N33456 · DestroyedNTSB LAX95LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · North Las Vegas, NVthe pilot's improper in-flight planning and decisions, and his failure to initiate remedial actions in a timely fashion.Dec 27, 1994 · N7446G · Substantial damageNTSB FTW95FA075Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Van Horn, TXThe pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.Dec 27, 1994 · N8112P · DestroyedNTSB MIA95LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tavares, FLThe failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.Dec 24, 1994 · N2829P · Substantial damageNTSB LAX95LA060Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Searchlight, NVthe pilot's intentional continued flight into instrument meteorological conditions in mountainous terrain.Dec 24, 1994 · N3836T · DestroyedNTSB FTW95LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · La Porte, TXLoss of engine power due to fuel starvation as result of the failure of the glass bowl on the gascolator. A factor was the lack of suitable terrain at the pilot's disposal to execute a forced landing.Dec 24, 1994 · N2820M · Substantial damageNTSB MIA95LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · La Belle, FLPartial loss of engine power due to total failure of the no. 3 cylinder exhaust valve for undetermined reasons. Also, unsuitable terrain encountered during the forced landing.Dec 23, 1994 · N41774 · Substantial damageNTSB ATL95LA030Accident · No injuriesLimited investigationFinal reportCessna 150G · Rhine, GAThe failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.Dec 23, 1994 · N3221J · Substantial damageNTSB CHI95FA061Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Rochester, MNFailure of the pilot to maintain control of the airplane, while climbing in instrument meteorological conditions (IMC) after takeoff. Factors related to the accident were: fog, low ceiling, the pilot's lack of recent instrument experience, and the excessive…Dec 22, 1994 · N133MA · DestroyedNTSB BFO95LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Laurel, MDThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.Dec 22, 1994 · N1620Y · DestroyedNTSB SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.Dec 21, 1994 · N4607Q · Substantial damageNTSB LAX95LA058Accident · Minor injuriesLimited investigationFinal reportRender LONG-EZ · Kailua-Kona, HIa delamination of the wooden propeller.Dec 21, 1994 · N3250K · DestroyedNTSB SEA95FA031Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Grantsville, UTThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.Dec 19, 1994 · N175MC · DestroyedNTSB FTW95LA068Accident · No injuriesLimited investigationFinal reportCessna A150L · Newark, TXThe loss of engine power due to undetermined reasons. Factors were the dark night and lack of suitable terrain to execute a forced landing.Dec 18, 1994 · N6030J · Substantial damageNTSB FTW95FA069Accident · 1 fatalField investigationFinal reportPiper PA-32RT · San Antonio, TXThe loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for the forced landing.Dec 18, 1994 · N21590 · DestroyedNTSB FTW95LA067Accident · Serious injuriesLimited investigationFinal reportTimothy J Brown Pitts S2SE · Grand Prairie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Dec 17, 1994 · N604SB · DestroyedNTSB DCA95MA007Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Fresno, CA1) Improperly installed electrical wiring for special mission operations that led to an in-flight fire that caused airplane systems and structural damage and subsequent airplane control difficulties; 2) improper maintenance and inspection procedures followed…Dec 14, 1994 · N521PA · DestroyedNTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…Dec 13, 1994 · N33049 · DestroyedNTSB MIA95LA039Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe failure of the pilot-in-command to insure the aircraft contained enough fuel to complete the flight resulting in engine failure due to fuel exhaustion.Dec 12, 1994 · N704BJ · Substantial damageNTSB MIA95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLThe pilot-in-command became lost and operated the aircraft until fuel exhaustion.Dec 12, 1994 · N9436U · Substantial damageNTSB MIA95FA037Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sylvan Springs, ALPoor in-flight planning/decision by the pilot-in-command for failure to deviate to an alternate airport after encountering icing conditions in an airplane not certificated for flight in icing conditions. Also, failure of the pilot to maintain altitude…Dec 11, 1994 · N6517C · DestroyedNTSB LAX95LA048Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Cabazon, CAAn unknown event (presumably a component/system failure) that resulted in loss of drive train power to the main rotor system. Factors related to the accident were: darkness and the obstruction (transmission line) in the emergency landing area.Dec 11, 1994 · N214MM · Substantial damageNTSB ANC95FA019Accident · Serious injuriesField investigationFinal reportBoeing 737-3M8 (300) · Anchorage, AKThe failure of the b system channel autopilot elevator actuator.Dec 11, 1994 · N681MA · No damageNTSB SEA95LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Medicine Bow, WYThe failure of the magneto system due to shorting of both magneto coils to the magneto housing and the lack of suitable terrain to make a forced landing.Dec 10, 1994 · N4300V · Substantial damageNTSB NYC95FA042Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Colonie, NYFailure of the pilot to maintain control of the aircraft, possibly from falling asleep.Dec 10, 1994 · N6069T · DestroyedNTSB ANC95FA016Accident · 5 fatalField investigationFinal reportCessna 402C · Elim, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: darkness and the adverse weather conditions.Dec 10, 1994 · N1238K · DestroyedNTSB BFO95LA019Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Montrose, PATotal loss of engine power for undetermined reasons.Dec 9, 1994 · N36YE · Substantial damageNTSB ATL95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Greenwood, SCUnapproved maintenance work done by uncertificated persons which resulted in a broken starter drive which was not properly removed from the engine. The particles sheared the magneto shafts causing the loss of engine power.Dec 9, 1994 · N6949E · Substantial damageNTSB SEA95LA027Accident · No injuriesLimited investigationFinal reportCessna 180 · Lonetree, WYThe restricted movement of the carburebor float.Dec 8, 1994 · N1594C · Substantial damageNTSB LAX95FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Groveland, CAthe failure of the pilot to maintain adequate terrain clearance during a nighttime descent into the airport over an unlighted mountainous area. Contributing to the accident was the pilot's distraction by attempting to make several cellular telephone calls…Dec 6, 1994 · N4510J · DestroyedNTSB ANC95LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Angoon, AKThe pilot's continued flight into adverse weather. A factor related to the accident was the snow conditions.Dec 5, 1994 · N756DA · DestroyedNTSB SEA95LA026Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Kent, WAFuel starvation due to the unporting of the useable fuel supply, and the pilot's failure to follow the airplane's published engine starting procedures after the loss of fuel flow during descent. Factors contributing to the accident are the pilot's lack of…Dec 4, 1994 · N39852 · Substantial damageNTSB FTW95LA058Accident · No injuriesLimited investigationFinal reportCessna 177 · Katy, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the unsuitable terrain at the pilot's disposal for the forced landing.Dec 4, 1994 · N29400 · Substantial damageNTSB BFO95LA018Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sabinsville, PAThe pilot's inadequate visual lookout during cruise flight which resulted in inflight collision with wires.Dec 4, 1994 · N83073 · DestroyedNTSB ANC95LA014Accident · No injuriesLimited investigationFinal reportBell 206B · Kenai, AKThe pilot's failure to follow the information in the flight manual concerning the use of the particle separator kit and deflector kit when operating in falling snow. Factors were the rough terrain in the forced landing area and no installation of the…Dec 4, 1994 · N3179X · Substantial damageNTSB MIA95LA032Accident · 1 fatalLimited investigationFinal reportCessna 172D · Miami, FLThe passenger committed suicide.Dec 3, 1994 · N707PP · No damageNTSB LAX95LA041Accident · Serious injuriesLimited investigationFinal reportBritten-Norman Islander BN2B-20 · Pacific Ocean (Pacific Ocean)An undetermined failure of the left engine. The inability of the airplane to maintain level flight and exceeding the one-engine capability was a factor in the accident.Dec 2, 1994 · N16VM · DestroyedNTSB FTW95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Goldthwaite, TXThe pilot's attempted flight into known adverse weather conditions. Factors were the unsuitable terrain, reduced visibility due fog and low ceilings, and the reduced light conditions.Dec 2, 1994 · N2LK · Substantial damageNTSB CHI95FA050Accident · 3 fatalField investigationFinal reportAgusta A109A II · Ann Arbor, MIthe pilot's failure to obtain/maintain a successful autorotation. Factors were: a loss of engine power of one engine for undetermined reasons, and the pilot's shutdown of the wrong engine.Dec 1, 1994 · N1QF · DestroyedNTSB SEA95FA025Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Brockway, MTa loss of control for undetermined reasons.Nov 30, 1994 · N22CN · DestroyedNTSB FTW95LA056Accident · No injuriesLimited investigationFinal reportBell 206B · Natchitoches, LAThe delayed flare and the improper touchdown by the pilot in command. Factors were the operation of the aircraft with known deficiencies by the operator and the pilot, delayed maintenance, and, an engine compressor assembly stall, combined with erosion and…Nov 29, 1994 · N2183P · DestroyedNTSB CHI95LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · La Porte City, IAa material defect which resulted in the fatigue failure of the crankshaft and the aircraft owner's failure to comply with a Mandatory Service Bulletin addressing the defect. A factor related to the accident was the rough terrain on which the forced landing…Nov 29, 1994 · N1194H · Substantial damageNTSB MIA95LA029Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Lakeport, FLFailure of the pilot to reposition the fuel selector after total loss of engine power due to fuel starvation. Contributing to the accident was her lack of total experience.Nov 27, 1994 · N624FT · Substantial damageNTSB LAX95FA046Accident · 2 fatalField investigationFinal reportMaule M-5-235C · Springville, CAthe pilot's entry into a box canyon at an altitude insufficient to maintain clearance from the surrounding terrain and obstacles. Factors in the accident were the high density altitude condition and the steep, rapidly rising nature of the mountainous terrain.Nov 27, 1994 · N5629J · Destroyed