OpenAirDocs.org

NTSB investigations

35,885 cases where the phase of flight was Enroute.

Cases, newest first

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 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 LAX94LA022Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Indian Springs, NVFailure of the pilot to properly operate the airplane's fuel selector, which resulted in fuel starvation, and his improper emergency procedure for restarting the engine. A factor related to the accident was: the pilot's lack of experience in this make and…Oct 24, 1993 · N5005C · Substantial damageNTSB CHI94LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Frankenmuth, MIImproper use of the mixture control by the pilot. Factors related to the accident were: the similarity of shape, size, and color of the mixture and carburetor heat controls and the terrain condition (with crop) in the emergency landing area.Oct 24, 1993 · N73003 · Substantial damageNTSB NYC94LA017Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Littleton, MAThe flight instructor's inadequate in-flight decision in the selection of the simulated forced landing area, and his delay in initiating a go around which resulted in the airplane colliding with trees.Oct 23, 1993 · N67197 · Substantial damageNTSB MIA94LA010Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300 · Atlantic Ocean (Atlantic Ocean)Encounter with unforecasted weather (moderate turblence) resulting in injury to three passengers.Oct 22, 1993 · N649UA · No damageNTSB NYC94FA014Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 369E · Richfield, OHAn in flight collision with power lines while the pilot was maneuvering the helicopter at a low altitude. A factor in this accident was reduced visibility due to foggy weather conditions.Oct 19, 1993 · N1605Z · DestroyedNTSB LAX94IA018Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-605R · Los Angeles, CAa separation of the number 6 stage high pressure compressor disk for an undetermined reason.Oct 19, 1993 · N41063 · Minor damageNTSB FTW94FA014Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Texarkana, ARThe pilot's continued VFR flight into instrument meteorological conditions. Factors that contributed to the accident were: the pilot's failure to obtain a weather briefing, the existing weather, his lack of instrument flying experience, and the dark night…Oct 18, 1993 · N98143 · DestroyedNTSB NYC94FA011Accident · 2 fatalField investigationFinal reportCessna 310Q · Tiro, OHLoss of aircraft control for an undetermined reason, and subsequent flight that resulted in the stress limits of the airplane being exceeded and airframe failure.Oct 17, 1993 · N1972D · DestroyedNTSB ATL94FA006Accident · 2 fatalField investigationFinal reportMooney M20B · Bethpage, TNThe pilot's VFR flight into IMC, and his failure to maintain aircraft control. Factors were the pilot's failure to use a preflight briefing service, and the low ceilings and fog at the accident site.Oct 17, 1993 · N74724 · DestroyedNTSB FTW94LA013Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's failure to follow proper emergency procedures to troubleshoot the electrical system. A factor was an electrical system irregularity of an undetermined nature.Oct 16, 1993 · N7825T · Substantial damageNTSB ANC94FA011Accident · 1 fatalField investigationFinal reportCessna 207 · Kenai, AKThe pilot's failure to maintain adequate altitude for terrain clearance. Factors which contributed to the accident were: the pilot's lack of usual sleep, the night light condition and hilly terrain.Oct 16, 1993 · N208SC · DestroyedNTSB NYC94LA009Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Skaneateles, NYThe pilot's inadequate preflight preparation which failed to adequately secure cargo, resulting control interference. A factor was the overgross weight condition of the airplane.Oct 15, 1993 · N61563 · Substantial damageNTSB LAX94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Daggett, CAthe pilot's poor fuel consumption calculations which culminated in engine losing power due to fuel exhaustion. The soft desert terrain was a factor in this accident.Oct 15, 1993 · N6538T · Substantial damageNTSB NYC94LA012Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Vernon, NJThe pilot's inadequate preflight inspection, which failed to detect an unsecured dipstick, resulting in oil starvation and the loss of engine power.Oct 14, 1993 · N1859B · Substantial damageNTSB LAX94LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Hilo, HIthe failure of the right engine's magnetos for undetermined reasons and the resulting overtemperature of the remaining left engine.Oct 14, 1993 · N7079J · DestroyedNTSB CHI94IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Thief Rvr Falls, MNFatigue failure of the propeller blade, originating from a corrosion pit.Oct 14, 1993 · N6846P · No damageNTSB NYC94LA008Accident · 1 fatalLimited investigationFinal reportFeatherston Titan Tornado · Mechanicsville, VAFailure of the pilot to correct the descent. Factors related to the accident were: the light conditions at dusk, impairment of the pilot from use of a medication (prescription drug), and possible lack of visual ques (pilot's visual perception).Oct 9, 1993 · N7020J · DestroyedNTSB LAX94FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Sedona, AZthe pilot's decision to continue VFR at an improper altitude into mountainous terrain at night and the inadvertent encounter with clouds along the route. Self-induced pressure due to a low fuel state contributed to the accident.Oct 8, 1993 · N5365D · DestroyedNTSB LAX94FA006Accident · 2 fatalField investigationFinal reportCessna 182M · Seligman, AZthe separation of the carburetor float and needle valve from the upper half of the carburetor bowl, due to improper installation of the float kit.Oct 8, 1993 · N91849 · DestroyedNTSB ANC94LA007Accident · No injuriesLimited investigationFinal reportHelio H-391-B · Beaver Creek, AKThe pilot's failure to maintain the required airspeed during the emergency descent as published in the pilot's manual. A factor is the loss of engine power for undetermined reasons.Oct 8, 1993 · N173K · Substantial damageNTSB SEA94LA016Accident · No injuriesLimited investigationFinal reportCessna 180K · Garfield, WAConnecting rod bolt fatigue.Oct 7, 1993 · N61946 · Substantial damageNTSB CHI94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Allendale, MIImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.Oct 6, 1993 · N8339C · Substantial damageNTSB CHI94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Frankfort, MIthe pilot's failure to perform refueling.Oct 5, 1993 · N6862Z · Substantial damageNTSB ATL94LA002Accident · No injuriesLimited investigationFinal reportHughes 269B · Linville, NCThe pilot's failure to maintain airspeed that would have avoided a loss of tail rotor effectiveness (lte), and his improper compensation for tailwind condition. A factor was the lack of information in the pilot's operating handbook regarding the conditions…Oct 5, 1993 · N9333F · Substantial damageNTSB SEA94LA007Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Shoshoni, WYFuel exhaustion and the pilot in command's failure to refuel the aircraft.Oct 3, 1993 · N44492 · Substantial damageNTSB MIA94FA001Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-83 · Miami, FLThe failure of the water heater relay and the overpressure relief valve to operate properly. In addition, the design of the relief valve was inadequate in that it allowed the o-ring to migrate from its normal position preventing the valve from opening.Oct 3, 1993 · 9YTHR · Substantial damageNTSB LAX94FA005Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Kernville, CAthe pilot's inadvertent flight into a box canyon and his failure to attain a safe altitude. A factor in the accident was the pilot's lack of familiarity with the geographic area.Oct 3, 1993 · N4018W · DestroyedNTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.Oct 3, 1993 · N4646X · Substantial damageNTSB CHI94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Monroe, MIThe pilot's inadequate preflight planning/preparation, when he misjudged the (inadequate) supply of fuel before takeoff, which resulted in fuel exhaustion. Soft terrain in the emergency landing area was a related factor.Oct 2, 1993 · N2759S · Substantial damageNTSB CHI94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cheboygan, MIInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to and inadequate supply of fuel. Factors related to the accident were: the lack of suitable terrain for a forced landing, and trees in the emergency landing area.Oct 2, 1993 · N5695U · DestroyedNTSB CHI94FA002Accident · 2 fatalField investigationFinal reportBeech 95 · Roodhouse, ILwas the inadequate supervision by the flight instructor which resulted in the inadvertent stall/spin by the student.Oct 2, 1993 · N2711Y · DestroyedNTSB CHI94FA001Accident · 1 fatalField investigationFinal reportBeech G35 · Webster, WIIn-flight breakup of the airplane for an undetermined reason.Oct 2, 1993 · N4421D · DestroyedNTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.Oct 1, 1993 · N667B · Substantial damageNTSB LAX93LA371Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Kepuhi Molokai, HIA loss of main rotor RPM for undetermined reasons.Sep 30, 1993 · N150CA · DestroyedNTSB FTW93LA271Accident · No injuriesLimited investigationFinal reportCessna 310Q · Edgewood, NMA propeller control unit failure, and loss of the pilot's option to feather the propeller. A factor was the lack of suitable terrain for a forced landing.Sep 30, 1993 · N777HB · Substantial damageNTSB ATL93LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Sylvania, GAWas the pilot's failure to properly plan sufficient fuel for the flight which resulted in fuel exhaustion short of the destination airport.Sep 30, 1993 · N1141Z · Substantial damageNTSB BFO93FA189Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Akron, OHContinued flight by the pilot to an altitude that was not appropriate without supplemental oxygen, which resulted in a loss of aircraft control due to hypoxia and subsequently exceeding the design stress limits of the aircraft. Factors related to the accident…Sep 29, 1993 · N6489P · DestroyedNTSB CHI93LA380Accident · No injuriesLimited investigationFinal reportCessna 177B · Fayette, IAthe pilot-in-command's failure to refuel the airplane. A factor was a road sign and fuel exhaustion.Sep 27, 1993 · N35163 · Substantial damageNTSB CHI93FA378Accident · 2 fatalField investigationFinal reportAero Commander 690A · Lansing, MIwas the pilot-in-command not maintaining aircraft control during the intermittent operation of the electrically operated attitude gyro. Factor's associated with this accident are an fluctuating (intermittent) electrical system inverter and the…Sep 27, 1993 · N242TC · DestroyedNTSB CHI93LA379Accident · No injuriesLimited investigationFinal reportCessna 150M · Burlington, WIthe improper fuel calculations by the pilot-in-command. Factors were the pilot-in-command's not refueling and uphill terrain.Sep 26, 1993 · N704ZF · Substantial damageNTSB CHI93LA376Accident · No injuriesLimited investigationFinal reportCessna 150H · Gary, INan improper climb airspeed established by the pilot-in-command after banner pickup.Sep 26, 1993 · N22313 · Substantial damageNTSB FTW93LA268Accident · No injuriesLimited investigationFinal reportCessna 182G · Baytown, TXThe fuel starvation power loss due to a sticking carburetor float. A factor was the lack of suitable terrain onto which a forced landing could be executed.Sep 25, 1993 · N2149R · Substantial damageNTSB LAX93FA369Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Wildomar, CAThe failure of the tail rotor blade after being struck by the pilot's knee board, and the failure of the pilot to adequately secure the knee board while in flight.Sep 24, 1993 · N40049 · DestroyedNTSB LAX93LA366Accident · 1 fatalLimited investigationFinal reportCessna 182H · Flagstaff, AZthe pilot's sudden incapacation due to a fatal heart attack.Sep 23, 1993 · N1982X · Substantial damageNTSB FTW93LA264Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A · San Antonio, TXFuel starvation induced power loss due to the pilot's improper fuel tank selection and his failure to switch tanks after the power loss. A factor was the lack of suitable terrain onto which a forced landing could be executed.Sep 23, 1993 · N261A · Substantial damageNTSB LAX93LA375Accident · 2 fatalLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)a loss of engine power for undetermined reasons.Sep 22, 1993 · N285CA · DestroyedNTSB CHI93LA371Accident · No injuriesLimited investigationFinal reportPiper PA-60-601 · Lone Rock, WIInadequate maintenance and excessive airspeed during the landing approach.Sep 21, 1993 · N9825Q · Substantial damageNTSB CHI93IA372Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Indianapolis, INan undetermined problem which resulted in the physical impairment of flight attendants, passengers and the first officer.Sep 21, 1993 · N527AU · No damageNTSB SEA93FA206Accident · 1 fatalField investigationFinal reportCessna 180B · Mullan, IDThe pilot's poor in flight decision, and his inadvertent continuation of a VFR flight into instrument meteorological conditions. Factors include low ceilings, snow, fog, rain, and mountainous/hilly terrain.Sep 20, 1993 · N985DB · DestroyedNTSB LAX93FA360Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Pine Mountain, CAThe pilot in command did not maintain adequate clearance with the terrain. Factors in this accident were: the dark night, and the poor in flight planning and decision making by the pilot.Sep 20, 1993 · N9778Y · Destroyed