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 FTW89LA039Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · S. Timbalier 75 (Gulf of Mexico)The loss of control of the helicopter due to an undetermined failure of the tail rotor control system.Jan 9, 1989 · N27555 · DestroyedNTSB ATL89MA070Accident · 2 fatalMajor investigationFinal reportSwearingen SX-300 · Wilmington, OHFatigue and resulting failure of the right wing's lower attachment fitting and inadequate quality control by the Swearingen SX-300 production/design personnel.Jan 9, 1989 · N6Y · DestroyedNTSB ATL89LA068Accident · Serious injuriesLimited investigationFinal reportBeech B-90 · Paducah, KYPilot failed to maintain proper altitude while maneuvering to land. Probable contributing factors were inoperative weather radar, thunderstorms, lightning, an undetermined electrical problem, dark night, the pilot's improperly planned approach and visual…Jan 8, 1989 · N784K · Substantial damageNTSB FTW89FA037Accident · 2 fatalField investigationFinal reportBeech B33 · New Braunfels, TXThe pilot's decision to continue VFR flight into IMC. Contributing factors were the adverse weather conditions and the dark night.Jan 7, 1989 · N1530Z · DestroyedNTSB LAX89FA091Accident · 1 fatalField investigationFinal reportCessna 172M · Oxnard, CAContinued VFR flight by the pilot into instrument meteorlogical conditions which resulted in an in-flight collsion with terrain. Related factors were: failure of the pilot to use a preflight briefing service, his decision to initiate flight into known adverse…Jan 6, 1989 · N61587 · DestroyedNTSB MKC89DCG02Accident · 1 fatalFinal reportWells Varieze · Macon, MOContinued flight by the pilot into known adverse weather and his failure to maintain sufficient altitude/clearance above obstacles. Contributing factors were: low ceiling, fog, rain, pilot delaying flight to an alternate destination, his lack of recent flight…Jan 5, 1989 · N66WR · DestroyedNTSB LAX89FA078Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · San Bernardino, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions while attempting to transit through a mountain pass. Contributing factors was: the pilot's self-induced pressure knowing that a co-worker was probably waiting…Jan 5, 1989 · N5157L · DestroyedNTSB DEN89LA057Accident · No injuriesLimited investigationFinal reportBumgartner/Hirt Steen Skybolt · Quemado, NMFailure of the pilot to select a suitable landing strip/area. Factors related to the accident were: high terrain and low ceiling along the route of flight, haze, and the soft condition of the selected landing strip.Jan 5, 1989 · N312BH · Substantial damageNTSB ATL89FA066Accident · 1 fatalField investigationFinal reportPiper PA-31 · Springfield, OHFuel exhaustion precipatated by the inadequate fuel consumption calculations performed by the pilot, pressure from the company president to not carry excess fuel and improper in-flight planning/decisions by the pilot by not refueling enroute before fuel was…Jan 3, 1989 · N9034Y · DestroyedNTSB CHI89FA040Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Carmel, INThe pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft.Jan 2, 1989 · N2CL · DestroyedNTSB CHI89FA039Accident · 2 fatalField investigationFinal reportCessna 210D · Alvin, ILContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument…Jan 1, 1989 · N3767Y · DestroyedNTSB LAX89FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Wrightwood, CAAccording to the passenger, during a cross country flight the airplane encountered instrument meteorological conditions. The pilot flew the airplane toward a mountain range and entered a valley with rising terrain. Still in IMC, just prior to the accident,…Dec 31, 1988 · N5369L · Substantial damageNTSB NYC89IA063Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Atlantic Ocean (Atlantic Ocean)American flt 1180 (McDonnell-douglas DC-10) was northbound ovr the Atlantic Ocean at flt lvl 350 as a british royal air force vickers VC10 was cruising east at the same alt (non-standard alt for the VC10'S drctn of flt). They were in a non-radar airspace…Dec 30, 1988 · N153AA · 2 aircraft · No damageNTSB ATL89LA064Accident · No injuriesLimited investigationFinal reportMooney M20F · Perdido, ALWhile descending to 6000 feet the pilot experienced a complete loss of engine oil supply. The windscreen was covered with oil and the pilot had to use the side window to gain forward visibility. After completing the emergency landing check the engine seized.…Dec 30, 1988 · N6969V · Substantial damageNTSB DEN89LA050Accident · No injuriesLimited investigationFinal reportCessna 152 II · Gilcrest, COThe plt, with his wife as a pax, departed greeley, CO, on a cross-country flt to clayton, NM. After landing, the pilot had his aircraft refueled. It took 23.5 gallons of fuel to fill the fuel tanks. The plt then took off, flew 46 miles southeast, then turned…Dec 29, 1988 · N46974 · Substantial damageNTSB MIA89LA059Accident · No injuriesLimited investigationFinal reportCessna 177A · West Palm Beach, FLThe private pilot contacted lakeland tower in flt about 2115 and was told that no fuel was available. He elected to continue flt. The pilot experienced an engine failure due to fuel exhaustion after 4 hours and 12 minutes of flight. He then executed a forced…Dec 28, 1988 · N30564 · Substantial damageNTSB FTW89LA033Accident · Serious injuriesLimited investigationFinal reportCessna TU206D · Alamo, TXAirplane's collision with trees and terrain during an attempted forced landing at night following an engine faiure. The engine failure was caused by fuel starvation as a result of a faulty fuel system which the operator had failed to correct.Dec 28, 1988 · N72249 · DestroyedNTSB SEA89LA030Accident · 1 fatalLimited investigationFinal reportCessna 205 · Cottage Grove, ORThe student pilot took off on a solo flight from an uncontrolled airport at Cottage Grove in marginal weather conditions. Shortly after takeoff, he transmitted to eugene tower (which was approximately 15 miles north) that he had encountered 'white-out'…Dec 27, 1988 · N8403Z · DestroyedNTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INDec 27, 1988 · N5457A · Substantial damageNTSB DCA89IA016Incident · Minor injuriesIncident investigationFinal reportBoeing 727-25 · Morgantown, WVFuselage skin 'flapped' open between body stations 1090 and 1110 and peeled downward from stringer #4 left to stringer #5 left. A scratch or scribe mark was co-located with the longitudinal crack along stringer #4. The area of damage was located on the aft…Dec 26, 1988 · N8148N · Minor damageNTSB ATL89DKJ01Accident · Serious injuriesFinal reportSloan RV-4 · Russellville, ALWhile cruising at 2500 feet with ram air gate open, engine began to run rough. The plt closed the ram air gate and applied carb heat but the engine continued to run rough and then stopped. The pilot attempted to land in an open field, clearing several large…Dec 26, 1988 · N77SA · Substantial damageNTSB LAX89FA074Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Yucca, AZPilot's failure to maintain directional control. Contributing factors included the pilot's improper in-flight decision which was related to his overconfidence in his personal ability, spatial disorientation upon encountering inclement weather during the…Dec 25, 1988 · N9276M · DestroyedNTSB NYC89LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180T · Princeton, NJThe acft experienced a loss of power of both engines and crashed into trees near Princeton airport, Princeton, NJ. The pilot flew 4.5 hrs and after a missed approach one engine quit. While attempting to make Princeton airport the other engine quit. According…Dec 24, 1988 · N91PA · DestroyedNTSB LAX89FA069Accident · 2 fatalField investigationFinal reportCessna T210L · Norco, CAAccident was that the pilot became disoriented and was unable to arrest the ensuing descending spiraling turn.Dec 24, 1988 · N94210 · DestroyedNTSB DEN89IA047Incident · No injuriesIncident investigationFinal reportCessna 210L · Roswell, NMPlt preflighted acft and noted indication of 9 qts of oil in crankcase. Flt departed Roswell (row) in night VMC en route to abq. Plt had just leveled off at 6500 ft MSL when he noticed oil pressure gauge fluctuating. Oil pressure then began dropping and plt…Dec 24, 1988 · N59217 · Minor damageNTSB LAX89LA068Accident · Serious injuriesLimited investigationFinal reportBoeing 747SP-21 · Midway Islands (Pacific Ocean)Aircraft's encounter with unforecast severve clear turbulence.Dec 23, 1988 · N146UA · No damageNTSB LAX89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Victorville, CADuring cruise flight, the engine lost power. The pilot initiated a forced landing on an interstate. During the descent, the airplane collided with transmission wires and subsequently came to rest on interstate 15. During an inspection of the wreckage, it was…Dec 23, 1988 · N4297X · Substantial damageNTSB ATL89FA058Accident · 2 fatalField investigationFinal reportCessna 414 · Bloomville, OHDec 23, 1988 · N84UM · DestroyedNTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.Dec 22, 1988 · N50331 · Substantial damageNTSB MIA89FA054Accident · 2 fatalField investigationFinal reportCessna 310L · Cedar Key, FLThe evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be…Dec 21, 1988 · N2251F · DestroyedNTSB LAX89LA073Accident · 1 fatalLimited investigationFinal reportBell 206L-1 · Oakland, CAPilots intentional flight into known adverse weather condititions from which he inadvertently descended into the water at a high rate of speed. Contributing to the accident was the pilot's failure to obtain a weather briefing; lack of recent instrument flying…Dec 21, 1988 · N1072S · DestroyedNTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…Dec 20, 1988 · N17696 · Substantial damageNTSB MKC89LA041Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Linwood, KSPoor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command.Dec 18, 1988 · N5012J · Substantial damageNTSB NYC89LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stacyville, METhe student pilot became lost during a cross country flt. The flight was continued until the acft ran out of fuel. The aircraft collided with trees during an emergency landing and nosed over. The plt told the state police at the acc site that the acft had run…Dec 17, 1988 · N6558P · DestroyedNTSB MKC89LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Rolla, MOWhile returning from a personal cross country flight, the newly certificated private pilot said that the winds picked up and he was blown 30 miles east of his intended course. In addition, he was running one hour over the time allotted for the trip. He landed…Dec 17, 1988 · N704LB · Substantial damageNTSB CHI89DEE01Accident · No injuriesFinal reportCessna 210L · Bannock Burn, ILFuel starvation caused by ice blocked fuel lines.Dec 17, 1988 · N5225K · Substantial damageNTSB SEA89LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Medford, ORThe pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual…Dec 16, 1988 · N67638 · Substantial damageNTSB NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.Dec 16, 1988 · N63136 · Substantial damageNTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…Dec 15, 1988 · N3110Q · DestroyedNTSB ATL89LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Athens, GADuring descent toward his intended destination, the pilot noted a floating ammeter needle and shortly thereafter he noted his oil pressure was zero. The engine seized and he selected a straight stretch of paved road for his forced landing. In the final stages…Dec 12, 1988 · N14695 · Substantial damageNTSB NYC89LA047Accident · No injuriesLimited investigationFinal reportMooney M20J · New Alexandria, PALoss of control experience during landing rollout after an off airport landing was made due to a power loss caused by contaminated fuel. Water had been removed prior to departure.Dec 11, 1988 · N3820H · Substantial damageNTSB LAX89IA062Incident · Minor injuriesIncident investigationFinal reportCessna 152 · Haleiwa, HIThe aircraft experienced a partial loss of power and collided with the terrain while completing an emergency landing in a sugar cane field. During this particular maneuver the CFI indicated that he was reasonably sure he cleared the engine at least once a few…Dec 11, 1988 · N94825 · Minor damageNTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…Dec 11, 1988 · N704KV · Substantial damageNTSB MKC89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jacksonville, ARDuring a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.…Dec 10, 1988 · N8356P · Substantial damageNTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.Dec 7, 1988 · N16502 · Substantial damageNTSB MKC89LA031Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Martelle, IAAnticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…Dec 7, 1988 · N198V · Substantial damageNTSB MIA89FA048Accident · Serious injuriesField investigationFinal reportCessna 150J · Gainesville, FLPlt obtained weather briefing prior to departure at which time he was told the possibility of IFR conditions on arrival at destination existed due to fog. Plt failed to obtain en route weather briefing. Near his destination, the plt encountered IFR…Dec 7, 1988 · N60029 · DestroyedNTSB LAX89LA061Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Arbuckle, CADuring cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just…Dec 7, 1988 · N9569R · Substantial damageNTSB FTW89LA031Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · South Marsh 113Failure and separation of one of the tail rotor blades for undetermined reasons. Thr resulting imbalance and vibration caused the separation of the 90 degree gearbox and a portion of the vertical pylon which necessitated the emergency autorotation to the…Dec 5, 1988 · N2785B · Substantial damageNTSB ATL89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vidalia, GAAircraft experienced loss of power and returned to airport. Departed second time and experienced rough running engine. Aircraft attempted emergency landing and overturned in field. Examination of the engine revealed piston failure in #4 cylinder. Post acc…Dec 5, 1988 · N9107M · Substantial damage