OpenAirDocs.org

NTSB investigations, 1993

533 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\") = 1993
    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 MIA94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vicksburg, MSThe pilot did not maintain the proper glidepath. Failure of the electrical system and inadequate maintenance by company maintenance personnel were factors in the accident.Dec 31, 1993 · N5192W · Substantial damageNTSB MIA94LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lantana, FLThe pilot-in-command's failure to obtain emergency assistance after becoming temporarily lost, resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the dispatch of the student on the cross-country flight by the CFI…Dec 31, 1993 · N8532G · Substantial damageNTSB FTW94FA057Accident · 3 fatalField investigationFinal reportCessna 177RG · Van Horn, TXThe pilot exceeded the design stress limits of the aircraft after a loss of control which resulted from VFR flight into instrument meteorological conditions. Factors were the weather, the pilot's lack of instrument training and experience, and his failure to…Dec 29, 1993 · N1527H · DestroyedNTSB LAX94LA083Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Scottsdale, AZA failure of the pilot-in-command to adequately conduct a preflight inspection and properly secure a fuselage cowling panel that struck a tail rotor blade, resulting in a subsequent failure of the tail rotor drive system. Factors in this accident were an…Dec 28, 1993 · N7456T · DestroyedNTSB ATL94LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCThe pilot's inadequate in-flight planning in determining fuel requirements for the flight.Dec 27, 1993 · N4320X · Substantial damageNTSB ATL94LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · N. Myrtle Beach, SCThe pilot's improper inflight decision in that he failed to refuel the aircraft prior to exhausting the fuel supply. A factor was the soft terrain at the forced landing site.Dec 27, 1993 · N2205Z · Substantial damageNTSB NYC94LA043Accident · No injuriesLimited investigationFinal reportBeech A-36-TC · Hillsboro, NHLoss of engine power for undetermined reasons.Dec 26, 1993 · N3736F · Substantial damageNTSB NYC94LA044Accident · No injuriesLimited investigationFinal reportMooney 20E · Linden, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel and resulted in the loss of engine power.Dec 24, 1993 · N31617 · Substantial damageNTSB FTW94LA053Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Giddings, TXThe pilot's failure to maintain main rotor RPM. The weather conditions and delayed application of carburetor were factors in the accident.Dec 24, 1993 · N2111U · Substantial damageNTSB FTW94FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Franktown, COWas the pilot's disregard of forecast icing conditions and delayed application of carburetor heat, resulting in structural and induction icing. Factors were the icing conditions and unsuitable terrain for a forced landing.Dec 22, 1993 · N4382P · DestroyedNTSB CHI94LA056Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Mcintosh, SDwas continued VFR flight into IMC and the failure to maintain clearance with the terrain. Factors associated with this accident were an inaccurate weather evaluation by the pilot, snow and the rising terrain.Dec 22, 1993 · N8003P · DestroyedNTSB CHI94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Centerville, IAthe pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.Dec 21, 1993 · N4791D · Substantial damageNTSB MIA94IA040Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Melbourne, FLWas inadequate quality control by the engine manufacturer which resulted in failure of the second stage low pressure turbine disk due to a machining anomaly and reduced fatigue strength due to sub standard heat treat processing.Dec 19, 1993 · N74JM · Minor damageNTSB FTW94LA054Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Madisonville, TXThe pilot's continued flight into adverse weather. Factors were weather conditions and collision with a sign.Dec 19, 1993 · N55133 · Substantial damageNTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Dec 18, 1993 · N96591 · Substantial damageNTSB LAX94LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Showlow, AZthe pilot's poorly planned approach, improper emergency procedures, and his failure to feather the propeller. The inoperative fuel selector valve was a factor in this accident.Dec 17, 1993 · N8769B · Substantial damageNTSB FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.Dec 17, 1993 · N5065G · Substantial damageNTSB SEA94LA041Accident · No injuriesLimited investigationFinal reportCessna 150J · Tonasket, WAThe pilot's failure to attain a proper touchdown point. Factors include an inadequate preflight, fuel exhaustion, and an icy landing area.Dec 16, 1993 · N61215 · Substantial damageNTSB NYC94LA039Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Wilkes-Barre, PAwas the loss of engine oil for undetermined reasons and the subsequent engine failure, resulting in a forced landing and collision with trees.Dec 15, 1993 · N92GP · DestroyedNTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.Dec 13, 1993 · N36CK · DestroyedNTSB CHI94LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lacon, ILThe pilot misjudged the landing flare. Factors related to the accident were: the dark night, the pilot's lack of recent night experience, and the failure of the airplane's electrical system.Dec 13, 1993 · N66CS · Substantial damageNTSB FTW94LA048Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · El Paso, TXThe pilot's inadvertent flight into clear air turbulence.Dec 12, 1993 · N3718X · Substantial damageNTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.Dec 12, 1993 · N757FH · Substantial damageNTSB LAX94LA075Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flagstaff, AZThe pilot's improper initiation of an emergency autorotation into unsuitable terrain and subsequent hard landing and rollover. A false annunciator indication, a failure of the N1 tach generator, the pilot's continued flight with a known aircraft defect, and…Dec 11, 1993 · N2773R · Substantial damageNTSB CHI94LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · C0rnell, ILthe pilot-in-command's misjudgment of fuel supply. A factor was fuel exhaustion.Dec 11, 1993 · N6124P · Substantial damageNTSB ATL94FA030Accident · 3 fatalField investigationFinal reportBeech M35 · Chapel Hill, NCThe improper engine overhaul by maintenance personnel. A factor in the accident was the failure of the engine crankshaft.Dec 11, 1993 · N9864R · DestroyedNTSB ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.Dec 10, 1993 · N8340Y · DestroyedNTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.Dec 9, 1993 · N49215 · Substantial damageNTSB CHI94LA047Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Ashley, INInadequate aircraft preflight by the pilot-in-command. A factor relating to this accident is the dark night.Dec 9, 1993 · N210MD · Substantial damageNTSB MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.Dec 5, 1993 · N2382T · Substantial damageNTSB FTW94FA044Accident · 1 fatalField investigationFinal reportUpton Mustang M-II · Guthrie, OKWas the in flight failure of the left aileron for reasons undetermined.Dec 5, 1993 · N4YP · DestroyedNTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.Dec 4, 1993 · N55719 · Substantial damageNTSB LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.Dec 3, 1993 · N89014 · Substantial damageNTSB NYC94FA028Accident · 2 fatalField investigationFinal reportPiper PA-31T · Norwich, OHThe pilot's loss of aircraft control for an unknown reason, and subsequent flight that exceeded the design stress limits of the airplane, which resulted in an in-flight airframe breakup.Dec 2, 1993 · N515WB · DestroyedNTSB LAX94LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Fallon, NVthe pilot's intentional continued flight into known adverse weather conditions.Nov 30, 1993 · N4081W · DestroyedNTSB LAX94FA278Accident · 2 fatalField investigationFinal reportMooney M20K · June Lake, CAThe pilot allowed the airplane to exceed its design limits (airspeed and/or stress limits) after inadvertently entering a descent. Factors relating to the accident were: darkness (night or late dusk), the pilot's failure to assure adequate…Nov 30, 1993 · N5788U · DestroyedNTSB BFO94LA022Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Waynesburg, PAThe pilot's inadequate preflight and inflight preparations, planning and decisions. The lack of suitable terrain for the forced landing was a factor.Nov 30, 1993 · N1377W · Substantial damageNTSB SEA94FA038Accident · 1 fatalField investigationFinal reportPiper PA-24 · Ashland, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weatheer conditions, and the pilot's lack of…Nov 29, 1993 · N5764P · DestroyedNTSB BFO94LA019Accident · Serious injuriesLimited investigationFinal reportMartin Streak Shadow · Mannington, WVThe pilot's failure to maintain clearance from the surrounding terrain.Nov 26, 1993 · N106JM · DestroyedNTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.Nov 26, 1993 · N7702U · Substantial damageNTSB MIA94LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Jacksonville, FLThe improper positioning of the fuel selector by the pilot-in- command resulting in fuel starvation.Nov 25, 1993 · N89900 · Substantial damageNTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.Nov 25, 1993 · N8833T · Substantial damageNTSB SEA94LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brookings, ORThe pilot's inadequate preflight planning/preparation, and icing of the induction air filter/screen. Factors include weather conditions conducive to icing, and rough/uneven terrain in the area of attempted landing.Nov 22, 1993 · N8829J · Substantial damageNTSB SEA94FA034Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Mountain Home, IDThe pilot's intentional suicide and impairment from consumption of alcohol.Nov 22, 1993 · N84PM · DestroyedNTSB LAX94FA056Accident · 2 fatalField investigationFinal reportCessna 172M · Julian, CAThe pilot's failure to maintain aircraft control. Factors in this accident were: 1) the dark night and lack of ambient light which resulted in the pilot inadvertently flying from visual meteorological conditions into instrument meteorological conditions; 2)…Nov 22, 1993 · N5312R · DestroyedNTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.Nov 21, 1993 · N3011F · DestroyedNTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…Nov 20, 1993 · N911ME · DestroyedNTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.Nov 20, 1993 · N420FL · DestroyedNTSB MIA94LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Tampa, FLWas the improper overhaul and inspection of the engine by company maintenance personnel.Nov 19, 1993 · N8260Q · Substantial damageNTSB LAX94LA051Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-1B-2 · Las Vegas, NVWere the fuel injection line contamination resulting in fuel starvation; the pilot's inadequate 100-hour inspection; the pilot's improper decision to return to the airport at a low altitude; and his failure to maintain the proper airspeed which resulted in a…Nov 19, 1993 · N42597 · Destroyed