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 NYC86LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Middletown, CTThe student pilot was on the third leg of an approved three leg cross country solo flight. He was instructed to refuel at the second stop. However, he made a decision not to refuel since the fuel tanks indicated about 1/2 full. The aircraft ran out of fuel…Jun 3, 1986 · N31SD · Substantial damageNTSB FTW86MA097Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Bartlett, TXAbout 6 min after takeoff, at 2138:31 CDT, the plt rprtd level at 9000 ft MSL. At 2140:17, he transmitted that he had trouble & said he could not control or disconnect the autopilot (a/p) which was causing the acft to descend. At 2141:14,he stated he was…Jun 3, 1986 · N8CC · DestroyedNTSB FTW86FA098Accident · 3 fatalField investigationFinal reportCessna T210N · Sperry, OKThe airplane departed jones (riverside) airport and climbed, on course, to its assigned altitude. It was in IMC conditions and a IFR flight plan had been filed. The pilot told ATC (after being asked) that his ride was 'smooth so far'. Shortly thereafter the…Jun 3, 1986 · N9444Y · DestroyedNTSB FTW86LRG23Accident · No injuriesFinal reportNorth American Rockwell S2-R · Mercedes, TXThe acft experienced a complete loss of eng power at an alt of 200 ft AGL shortly after takeoff. The plt was forced to land against the rows in a muddy cotton field. Shortly after touchdown, the acft flipped over. The exact nature of the eng failure was not…Jun 2, 1986 · N34956 · Substantial damageNTSB FTW86LA099Accident · No injuriesLimited investigationFinal reportCessna 150K · Eagle Pass, TXThe pilot failed to take appropriate steps to prevent water from entering the magnetos while washing the aircraft. As a result the water caused the magnetos to cut out and in turn caused the engine failure.Jun 2, 1986 · N6079G · Substantial damageNTSB DEN86LA148Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Frederick, COAccording to the plt, he had descended from 8,200 ft AGL to 700 ft AGL in preparation for landing. The plt stated that when he started to add power, he noticed the engine had quit and a forced landing was made. During the investigation, the plt did not…Jun 1, 1986 · N92807 · Substantial damageNTSB FTW86LA095Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Orange Grove, LADuring a part 135 check ride, the check plt had the plt execute a pwr off landing from an alt of 150 ft AGL. The plt reacted to the pwr loss by attempting a left turn to land. The acft then stalled and impacted the ground after the failure maintain airspeed.May 31, 1986 · N96158 · DestroyedNTSB ATL86LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GADuring a normal landing, the plt lost directional control of the acft which subsequently collided with a parked C-172. The plt reported that the right tire was inflated during the preflt inspection. Following the accident the tire was found deflated. The plt…May 31, 1986 · N1321Q · Substantial damageNTSB CHI86LA147Accident · No injuriesLimited investigationFinal reportCessna 195 · Port Huron, MIThe flight was to be a currency flight for the plt who indicated the acft had sat unused for over 8 months. After 10-15 minutes of flight the engine stopped. A hard landing was made on lake st. clair and the acft was substantially damaged. When interviewed…May 30, 1986 · N4745G · Substantial damageNTSB BFO86IA031Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Calverton, NYN1031T a DC-9-31, was in a descent for landing at jamaica, NY. The captain reported he heard a noise that he thought was a failing cabin door pressure seal and advised the copilot. The copilot indicated he thought the noise was the soundof a jet eng. Between…May 30, 1986 · N1310T · 2 aircraft · No damageNTSB BFO86FA029Accident · Minor injuriesField investigationFinal reportCessna 150L · Upper Marlboro, MDThe acft made a forced landing after the eng began to overheat during cruise flt about 20 minutes after departure. The plt stated that as soon as he smelled the oil heating up he knew what the problem was. He had not removed the foam plugs from the air…May 30, 1986 · N11463 · Substantial damageNTSB ATL86LA141Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Daniels, WVThe plt stated that he noted a 'large vibration' after he had taken off. He suspected a psbl bird strike or bearing failure, & subsequently, the helicopter crashed into trees. According to the plt, the eng did not fail; however, witnesses saw the helicopter…May 29, 1986 · N8889F · Substantial damageNTSB LAX86FA233Accident · 4 fatalField investigationFinal reportPiper PA 28-236 · Chino, CAThe private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The…May 27, 1986 · N43504 · Substantial damageNTSB MIA86LA167Accident · No injuriesLimited investigationFinal reportCessna 172 · Windermere, FLAfter leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.…May 26, 1986 · N7850X · Substantial damageNTSB BFO86FA027Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Riverdale, MDAircraft's engine sputtered and quit while the aircraft was climbing through 400 feet after departure. In an attempt to turn back to the runway the pilot stalled the aircraft and it descended out of control crashing into trees and the ground. Post crash…May 26, 1986 · N14781 · DestroyedNTSB ATL86LA143Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Eufaula, ALDuring a descent of 400-500 fpm at 120-125 mph the windshield blew into the aircraft. A portion of the windshield remained attached to the acft, folded up so as to jut above the cabin roof and acted as a spoiler. Level flight could not be maintained due to…May 26, 1986 · N4003X · Substantial damageNTSB SEA86LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Nyssa, ORDuring aerial application the engine ceased operating due to a broken shaft in the fuel pump. The boost pump was turned on and the engine ran momentarily. The pilot was unable to dump his 700 pounds of dry chemical and had to keep a nose down attitude in…May 24, 1986 · N53177 · DestroyedNTSB FTW86FA092Accident · 2 fatalField investigationFinal reportCessna 210M · Calumet, OKAcft on a night xc flt in marginal VFR to IMC conditions impacted in an 80 deg nose down attitude in a left spiral. Immediately prior to the accident the non-instrument rated pvt plt had indicated that he was IMC and was going to attempt to climb out of it.…May 24, 1986 · N750RS · DestroyedNTSB SEA86LA129Accident · No injuriesLimited investigationFinal reportCessna 310 · Skinner Ranch, ORThe pilot elected to make a precautionary landing due to a stated electrical problem. The runway was only 30 feet wide and the aircraft struck a dirt mound to the right of the center line. The aircraft's main landing gear then collasped.May 23, 1986 · N2634C · Substantial damageNTSB NYC86FA216Accident · 3 fatalField investigationFinal reportBell 206B · Noman'S Land, MAThe Bell 206 helicopter was en route to nantocket island when the pilot received an inflight weather briefing with VFR flight not recommended. The pilot acknowledged this report and it appears he elected to continue the flight. The acft did not reach it's…May 23, 1986 · N2776V · DestroyedNTSB CHI86FEM05Accident · No injuriesFinal reportEagle DW-1 · Baroda, MIThe plt shut down the acft engine after noticing oil on the canopy and a loss of oil pressure. A forced landing was performed in a corn field and the acft nosed over. Post accident inspection disclosed the oil pressure hose had ruptured.May 23, 1986 · N8807Z · Substantial damageNTSB ATL86LA140Accident · No injuriesLimited investigationFinal reportCessna 150E · Gulfshore, ALThe pilot related that the aircraft ran out of fuel and he attempted a forced landing in a field 3 miles from his airport of intended landing. The fuel cells were not visually inspected to determine the fuel quantity, however, the pilot stated that the fuel…May 23, 1986 · N6108T · Substantial damageNTSB ATL86IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-295 · Nashville, TNThe flight experienced a fire warning light descending through 10500 feet for landing at Nashville. The aircraft landed without incident. The passengers evacuated the aircraft using evacuation slides. Examination of the aircraft disclosed that the detection…May 23, 1986 · N1644 · No damageNTSB FTW86FRG19Accident · 1 fatalFinal reportSoward Rutan Longeze · Georgetown, TXThe acft crashed after hitting trees on short final following an inflight fire and an eng failure. The acft was on it's first flt following an eng overhaul and had been airborne about 2 minutes when ground and air observers noticed smoke trailing from the eng…May 22, 1986 · N196MS · DestroyedNTSB DEN86FA142Accident · 3 fatalField investigationFinal reportCessna T210N · Elgin, NDPlt received wx briefing prior to departure. VFR flt not recommended by fss. Plt radioed that he was in thunderstorm activity, IFR conditions and was attempting to turn around. Witnesses stated that they observed acft descending at a high rate of speed of a…May 22, 1986 · N5280A · DestroyedNTSB MIA86LA165Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Fellsmere, FLThe plt stated that he had about 350 lbs of fuel onboard when he took off on his 4th night crop dusting mission. He indicated that each mission is 6 to 8 mins in duration and that the average fuel consumption is about 570 lbs per hr. He stated that the 20 min…May 21, 1986 · N3879G · DestroyedNTSB FTW86LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Rio Hondo, TXThe right eng failed during cruise flt and the plt was unsuccessful in his attempt to restart the eng. The acft was unable to maintain alt and impacted the ground resulting in substantial damage to the acft. Although there was no evidence of any…May 21, 1986 · N717WL · Substantial damageNTSB FTW86FRG20Accident · No injuriesFinal reportAir Tractor AT301 · Taylor, TXCommercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was…May 21, 1986 · N3168H · Substantial damageNTSB CHI86LA144Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia City, INThe pilot had become disoriented and was concerned about his low fuel state when he decided to make a precautionary landing. The weather was deteriorating and it was getting dark although the pilot stated he could distinguish the trees from the ground. He…May 21, 1986 · N6612G · Substantial damageNTSB BFO86LA030Accident · Serious injuriesLimited investigationFinal reportShort Brothers SD3-30 · Hopewell, VAThe captain reported that moderate to severe turbulence was encountered while passing through some clouds. He called the flight attendant on the intercom and told her to sit down; while she was attempting to answer the intercom, an object from the galley area…May 21, 1986 · N331SB · No damageNTSB DEN86FA141Accident · Serious injuriesField investigationFinal reportCessna 150-H · Glen Canyon, UTWhile in a descent 20 miles before reaching the destination, the acft engine quit due to fuel exhaustion. The plt initiated an emergency forced landing to a dry stream bed in rough desert terrain. After touchdown, the acft impacted an embankment and flipped…May 20, 1986 · N22796 · Substantial damageNTSB CHI86LA143Accident · No injuriesLimited investigationFinal reportBeech BE-F90 · Eaton, INThe acft had made a stop at muncie to pick up a fourth passenger. After boarding, the passenger closed the cabin door. After departure and climbing thru 6,000 ft the airstair separated from the aircraft and struck the vertical stabilizer.May 20, 1986 · N960V · Substantial damageNTSB SEA86LA128Accident · No injuriesLimited investigationFinal reportAyres S-2R · Odessa, WAA rough running engine accompanied by smoke rising from the left side of the engine occurred shortly after takeoff. The landing gear then collapsed during the subsequent forced landing and the acft was destroyed by fire. The number one cylinder was found to…May 19, 1986 · N4945X · DestroyedNTSB CHI86FA141Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Angola, INThe pilot diverted into Angola, an airfield he had never landed at before, due to an unidentified electrical problem at night. He was given vectors to the airport and reported the field in sight. He then said he was going to circle to lose altitude prior to…May 18, 1986 · N44603 · DestroyedNTSB MIA86LA162Accident · No injuriesLimited investigationFinal reportCessna 182E · Crystal River, FLThe plt stated that just before descent he pushed the propeller control full forward, experienced a runaway prop and lost oil pressure. Moments later a connecting rod failure was experienced and an emergency landing was executed in amarshy area northwest of…May 17, 1986 · N9218X · Substantial damageNTSB LAX86FA223Accident · 2 fatalField investigationFinal reportGeneral Balloon AX-6 · Temecula, CAThe balloon was going to participate in a 'hare and hound' event and had departed a festival staging area on a positioning flight. Prior to departing the area the balloon had flown for about 45 minutes. While enroute to the positioning area the balloon had…May 17, 1986 · N2490Z · Substantial damageNTSB DEN86LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Pierre, SDPlt said that while in cruise flt eng loss power. Plt made forced landing on road and lost directional control. Acft struck ditch, fence, then overturned. Acft last refueled two days before and was flown for one hour. Plt did not service acft prior to…May 17, 1986 · N3559E · Substantial damageNTSB BFO86LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEThe acft impacted trees while attempting to release a banner at the drop zone. The acft was reportedly equipped with separate towing and release mechanisms, so that up to four banners could be towed in succession without the acft having to land. The plt…May 17, 1986 · N4004J · DestroyedNTSB ATL86FA132Accident · 1 fatalField investigationFinal reportCessna 172D · Athens, GADuring the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed…May 17, 1986 · N2592U · DestroyedNTSB MIA86LA160Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Kiln, MSThe plt stated that while on local flight he ran out of fuel & upon landing in a field, the acft struck a tree, severing the wings.May 16, 1986 · N5601G · Substantial damageNTSB DEN86FA137Accident · No injuriesField investigationFinal reportBeech BE-99C · Laramie, WYThis part 135 IFR flt was inbound for landing at Laramie, Wyoming. During the en route and approach for ldg portions of the flt the acft picked up a moderate to heavy load of ice. During the landing flare the acft stalled, hit the rwy, bounced, veered off the…May 16, 1986 · N6728J · Substantial damageNTSB FTW86LA087Accident · No injuriesLimited investigationFinal reportBoeing PT-13/E-75 · Dallas, TXThe plt had just departed the arpt, started to turn crosswind at 500 ft and began climbing, when the eng started sputtering and lost pwr. He did not have enough alt to return to the arpt and had to ditch the acft 200 yds off the north end of the rwy. No…May 15, 1986 · N10583 · Substantial damageNTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…May 15, 1986 · N52911 · Substantial damageNTSB NYC86LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Ephrata, PAThe Enstrom F28C was cruising enroute when it experienced a loss of power for reasons unknown. During the landing, in a large open field, the main rotor was damaged and the tail rotor separated from the tail boom. The lone occupant, the pilot, was uninjured…May 14, 1986 · N100WZ · Substantial damageNTSB SEA86LA125Accident · Serious injuriesLimited investigationFinal reportMaule M-6-235 · Fallon, NVThe plt was attempting a precautionary landing on a remote ranch strip after encountering turbulence and high winds enroute. Control was lost on short final when the acft was caught by a gust of wind. The acft contacted the ground on one wingtip and…May 13, 1986 · N5644J · DestroyedNTSB FTW86FA086Accident · 1 fatalField investigationFinal reportCessna 172G · Blackwell, OKThe pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…May 13, 1986 · N5878R · 2 aircraft · DestroyedNTSB ATL86LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Natural Bridge, ALThe student plt reported making an error during preflt planning for the solo x-country flt. The student's instructor didnot detect the error. The student plt flew an incorrect hdg, became lost and ran out of fuel. A forced ldg was made in a field.May 13, 1986 · N89339 · Substantial damageNTSB NYC86LA126Accident · No injuriesLimited investigationFinal reportCessna P206A · Wellsboro, PAThe acft was cruising at 5,500 ft when the plt experienced a total loss of power. He tried to make it to the Wellsboro arpt, however, he was unable to and landed the acft in a field. The acft ran through a fence and was substantially damaged. When the engine…May 12, 1986 · N4626F · Substantial damageNTSB MKC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ashby, NEThe plt stated that he and a passenger were sightseeing when he increased the mixture to full rich, applied carb heat and reduced power for a glide across a valley. When he advanced the throttle to level off the engine did not respond. During the forced…May 11, 1986 · N7255D · Substantial damageNTSB MKC86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Louisburg, KSDuring a fly-by over a pvt airstrip owned by the plt, the acft contacted power lines bordering the south end of the airstrip which the plt stated he forgot about. The plt reported he failed to pull up during the over fly and flew under the power lines. The…May 11, 1986 · N7027M · Substantial damage