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 MIA86LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Daytona Beach, FLFlt experienced engine failure while descending for landing. While approaching a field for a forced landing the aircraft struck electrical power lines and then crashed into the field. The engine was operated to full power after the accident with no evidence…May 11, 1986 · N4374E · Substantial damageNTSB NYC86FA127Accident · 1 fatalField investigationFinal reportRobinson R-22A · East Fishkill, NYA loss of control in flight for undetermined reasons.May 10, 1986 · N8511Z · DestroyedNTSB LAX86LA215Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Angels Camp, CANumerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…May 10, 1986 · N56760 · DestroyedNTSB DEN86FA131Accident · 1 fatalField investigationFinal reportPiper PA-28B-140 · Salt Lake City, UTPlt and pax departed slc at 0930 for sightseeing cross country trip to heber city and return. Plt said plan was to fly through lambs canyon and parley's canyon. Acft hit tree and crashed at 8040 ft MSL level in lambs canyon at approximately 0955. Terrain…May 10, 1986 · N8043N · DestroyedNTSB NYC86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Otselic, NYThe Cessna 182P was cruising at 2500 ft when it experienced an engine failure. The pilot made a landing in a plowed field across the furrows. The nose wheel broke off on landing and the aircraft flipped over. The pilot received minor injuries while the…May 8, 1986 · N7313Q · Substantial damageNTSB NYC86LA121Accident · Minor injuriesLimited investigationFinal reportCessna T337HPII · Newburg, PAThe Cessna 337P experienced fuel exhaustion and attempted a landing on a road. During the landing the aircraft struck telephone poles and received substantial damage. The pilot did not receive any injuries in the accident which occurred in visual…May 8, 1986 · N1030V · Substantial damageNTSB MIA86LA150Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Shelby, MSAfter departure while making a turn the pilot reported the engine lost power and the aircraft settled into the trees. There was no evidence of a preexisting mechanical failure/malfunction.May 8, 1986 · N3632C · Substantial damageNTSB DEN86MA129Accident · 6 fatalMajor investigationFinal reportGulfstream 690D · Price, UTAt 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…May 7, 1986 · N200PR · DestroyedNTSB SEA86LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Juneau, AKAcft had history of water in fuel and the system was purged. During winter, the plt did not fly acft but ran the eng periodically. On the day of the accident, the plt refueled the acft, completed a normal pwr run-up and took off. Shortlyafter takeoff, a pwr…May 5, 1986 · N1312B · Substantial damageNTSB DEN86FA125Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Almosa, COA southwest airline company Boeing 737, flt no. 558 en route from denver, Colorado, to albuquerque, new Mexico, at FL 350, encountered severe clear air turbulence. The unexpected wx phenomena caused the acft to 'drop' suddenly resulting in two flt attendants…May 5, 1986 · N28SW · No damageNTSB MIA86FA146Accident · 1 fatalField investigationFinal reportCessna 150F · Pembroke Pines, FLA witness stated that he was standing in his front yard when he heard an acft eng sputter & then completely quit. He looked up & saw the lights of the acft disappear behind trees, & moments later, he heard the acft crash. A post crash exam of the acft…May 4, 1986 · N8268S · DestroyedNTSB FTW86FA076Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Anadarko, OKThe pilot radioed that he had smoke in the cockpit. He immediately made an emergency landng, down wind, in a farmer's field. Witnesses saw the aircraft's right wing drop before the plane touched down. The resulting impact tore the wings and engine off,…May 4, 1986 · N43775 · DestroyedNTSB DEN86LA127Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Longmont, COThis experimental glider has a stowable 2 cycle eng mounted behind the cockpit. When the eng is stowed the glide ratio is about 40:1. When the eng is deployed but not running, the glide ratio is about 10:1. While returning after a 4 hr and 50 min flt the plt…May 4, 1986 · N40Z · Substantial damageNTSB DEN86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Riverton, WYThe plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…May 4, 1986 · N1949V · Substantial damageNTSB CHI86FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Warren, MIThe acft developed a small oil leak during a x-country flt. The plt reduced power to idle to conserve oil even though the oil pressure was still in the normal range. During the descent the acfts airspeed was not maintained and the acft contacted the ground in…May 4, 1986 · N1373P · DestroyedNTSB ATL86FEK01Accident · No injuriesFinal reportCessna 182D · Mt. Gilead, OHThe acft collided with the ground in a plowed field during a forced landing after a power loss. Post acc inspection of the eng revealed 3 pieces of felt like seal material lodged in the carburetor venturi. This felt was identical to the missing seal from the…May 4, 1986 · N8880X · Substantial damageNTSB MIA86LA145Accident · No injuriesLimited investigationFinal reportPiper 601P · Miami, FLNearing completion of an international flt of nearly 5 hrs duration, the flt advised ATC they were low on fuel & would like vectors to the nearest arpt. The flt was unable to make the arpt & a forced ldg was made in the everglades aprx 6 mi from the arpt. An…May 3, 1986 · N246G · Substantial damageNTSB LAX86FA207Accident · Serious injuriesField investigationFinal reportCessna P210N · Long Beach, CAWhile enroute from cincinnati, oh (luk), to torrance, CA, the airplane experienced a total engine power loss about 10 miles south of Long Beach airport (lgb), Long Beach, CA. The pilot attempted to land at lgb but the acft alt was insufficient. The acft…May 3, 1986 · N55MM · Substantial damageNTSB LAX86FA206Accident · 3 fatalField investigationFinal reportMooney M20F · Morgan Hill, CAThe pilot requested and received preflight weather briefings, twice, and was advised that VFR flight was not recommended. The flight departed and crashed into mountainous terrain that was obscured by adverse weather conditions. Witnesses reported that the…May 3, 1986 · N9309V · DestroyedNTSB FTW86FA073Accident · 1 fatalField investigationFinal reportPartenavia P68C · Goudeau, LAThe pilot received a weather briefing indicating IMC conditions existed at the point of departure and at reporting stations near the point of the first intended landing. (There was no reporting stations at the airport of intended landing). Weather conditions…May 1, 1986 · N3832E · DestroyedNTSB MIA86LA139Accident · Serious injuriesLimited investigationFinal reportWing D-1 · Bunnell, FLThe plt stated that his canopy had come open and he was trying to hold it closed and make an emergency landing on runway 29 at flagler co. airport, but being too low and fast the acft struck the ground about 100 ft short of the runway and slid to a stop.Apr 30, 1986 · N8601E · Substantial damageNTSB LAX86LA202Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Vacaville, CAAccording to the plt, the acft encountered a downdraft after being released from the tow plane. The plt selected a field in which to land, however, the glider contacted a tree while maneuvering to the field.Apr 30, 1986 · N2750Z · Substantial damageNTSB DEN86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Lamar, CODuring the initial telephone interview, the plt stated the eng quit due to fuel exhaustion while returning from an ag spraying flt. However, in the plt accident report, the plt states that he could not rule out mechanical problems.Apr 30, 1986 · N76LF · Substantial damageNTSB LAX86LA199Accident · No injuriesLimited investigationFinal reportCessna 177RG · Placerville, CAWhile enroute to san francisco, CA the engine began to overspeed & the prop gov control was not effective in arresting/controlling the overspeed condition. Shortly thereafter the engine oil pressure depleted to zero. The pilot elected to land in the ice house…Apr 29, 1986 · N34020 · DestroyedNTSB LAX86LA201Accident · No injuriesLimited investigationFinal reportCessna 150M · Torrey Pines, CAThe student plt was on the final leg of a x-country flt when the eng quit. A forced landing was attempted on a beach during which the acft nosed over. The plt stated that he purchased 5.9 gallons of fuel at one of his points of landing. He did not report how…Apr 28, 1986 · N704PL · Substantial damageNTSB SEA86LA251Accident · 2 fatalLimited investigationFinal reportStinson 108-1 · Grangeville, IDPlt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…Apr 27, 1986 · N8165K · DestroyedNTSB LAX86LA193Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Keaau, HIA hiller 1100 was destroyed by fire after a forced landing. The plt indicated that the EGT had risen to approximately 800 deg c from 700 deg and then rose to 1100 deg. The heat warning light illuminated. The plt initiated a precautionary landing. The eng…Apr 27, 1986 · N5067F · DestroyedNTSB LAX86FVM05Accident · Minor injuriesFinal reportHiller UH12E · Castroville, CAThe acft landed hard and rolled over after the lndg skid failed in a forced lndg. The plt said he was crusing at 500 ft AGL over an open field when he heard a loud bang. The helicopter began to vibrate severely and spiral to the right. The plt lost ground…Apr 27, 1986 · N5374V · DestroyedNTSB CHI86LA134Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Mt Clemens, MIAfter aprx 20 successful takeoffs & landings, the eng of the helicopter lost power at about 300 ft AGL, due to a #1 connecting rod failure. During an autorotation, the helicopter landed in trees & was destroyed. Although the pilot was instructing a new…Apr 27, 1986 · N2194U · DestroyedNTSB MIA86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Lauderdale, FLWhile towing a banner near the beach the aircraft's engine failed. The aircraft was ditched in the atlantic ocean and the pilot swam to shore. The pilot stated he became distracted watching the boats and failed to switch fuel tanks causing the right fuel tank…Apr 26, 1986 · N2411P · Substantial damageNTSB MIA86FA135Accident · Serious injuriesField investigationFinal reportCessna 172D · St. Petersburg, FLWhile on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…Apr 26, 1986 · N2321U · Substantial damageNTSB LAX86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Coolidge, AZThe plt shut down the acft eng when it surged during an encounter with turbulence. The plt initiated a precautionary downwind landing on a nearby airstrip and the acft overran the rwy and collided with a fence.Apr 26, 1986 · N7280Y · Substantial damageNTSB SEA86LA110Accident · No injuriesLimited investigationFinal reportRobinson R22-A · Portland, ORAt aprx 500 ft AGL, while on a local traffic watch, a loss of pwr occurred. A 15 kt tail wind was present. Pwr lines had to be cleared and a hard landing resulted. An examination and test run of the eng failed to disclose any failure/ malfunction which would…Apr 25, 1986 · N8536Z · Substantial damageNTSB MIA86LA133Accident · No injuriesLimited investigationFinal reportBell 206-L-3 · Miami Shores, FLThe plt stated that he experienced generator failure upon departure from key west & elected to continue his flt to opa-locka, FL, making two stops enroute. He noted that his battery was dead after passing ocean reef, landed at watson island & then took off…Apr 25, 1986 · N71FW · Substantial damageNTSB DEN86FA120Accident · Serious injuriesField investigationFinal reportConvair 580 · Denver, CON73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…Apr 25, 1986 · N73104 · No damageNTSB ATL86LA118Accident · No injuriesLimited investigationFinal reportTaylorcraft BLT-65 · Mount Airy, NCThe pilot stated that the engine lost power to idle RPM followed by a forced landing in trees. Examination of the aircraft determined that a snap ring which held the throttle cable housing in place in the instrument panel came loose. Without the snap ring the…Apr 25, 1986 · N27529 · Substantial damageNTSB SEA86LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mattawa, WAShortly after takeoff a loss of pwr occurred accompanied by an eng vibration. A forced landing was made onto a highway where a x-wind existed. Directional control was lost and the acft veered into a ditch and struck a fence before coming to a stop. No reason…Apr 24, 1986 · N57608 · Substantial damageNTSB LAX86LA191Accident · No injuriesLimited investigationFinal reportCessna 150J · Flagstaff, AZThe pilot was flying a round-robin flight from cottonwood, AZ to page, AZ, and return. The pilot had landed at page, AZ. While on the return leg of the flight the pilot noted his fuel gauges were 'low' and diverted to Flagstaff, AZ. When the acft was…Apr 24, 1986 · N60126 · Substantial damageNTSB SEA86LA109Accident · No injuriesLimited investigationFinal reportGrumman G164-A · Echo, ORA loss of power occurred shortly after takeoff on a downwind departure. A forced landing was accomplished onto a wheat field downhill. The aircraft nosed over during the landing roll. Post accident inspection of the aircraft disclosed fuel contamination.Apr 23, 1986 · N25SK · Substantial damageNTSB LAX86LA187Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Hemet, CAA glider struck wires while on final apch to a field. The plt indicated that he was towed to an alt of 5,000 ft MSL (aprx 3,500 ft AGL). On release, he encountered a downdraft of more than 500 ft per minute and was only able to stay airborne 6 to 7 minutes.…Apr 23, 1986 · N2032T · Substantial damageNTSB CHI86LA127Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Ft. Wayne, INApprox 10-15 minutes after takeoff the student pilot lost control of the helicopter and crash landed into trees. Following the accident, the only unusual thing FAA personnel could locate was a failed horizontal stabilizer spar. Post-crash examination of the…Apr 23, 1986 · N8752F · DestroyedNTSB SEA86LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bonners Ferry, IDThe plt utilized updrafts to climb to 7800 ft to clear a mountain ridge which was covered with 'cap clouds'. On the lee side of the ridge a downdraft was experienced and the acft descended into the 'fog'. The plt reported the acft instruments were used to…Apr 20, 1986 · N70040 · DestroyedNTSB MIA86FA126Accident · Serious injuriesField investigationFinal reportBlythe Quickie · Eustis, FLThe student pilot departed on a student cross-country flight with 2 gallons of fuel in the tank of the homebuilt quickie. About 30 to 45 minutes later the engine failed at 1800 ft MSL. The student attempted to stretch the glide to a road and struck trees and…Apr 20, 1986 · N316Q · DestroyedNTSB FTW86LA070Accident · Serious injuriesLimited investigationFinal reportBellanca 17-300 · El Paso, TXThe eng quit due to fuel starvation. The acft had been flown 2.6 hours on the main tanks. Normal operating time on the main tanks is 2.5 hours according to the owner's manual of the Bellanca viking 300 series. At the crash site the main tanks were found empty…Apr 18, 1986 · N4881V · DestroyedNTSB CHI86FA122Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Westville, INThe plt was taking a friend and two of her acquaintances on a sightseeing ride when the acft crashed into a plowed farm field. The acft's weight was estimated to be 60 lbs under max allowable gross weight at the time of the crash. A witness near the crash…Apr 18, 1986 · N4491J · DestroyedNTSB LAX86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Colusa, CAThe pilot reported that while on a pipeline aerial observation flight he encountered moderate to severe turbulence, snow showers and freezing rain. When he attempted to depart the area the aircraft began to shudder and vibrate to the extent that any further…Apr 16, 1986 · N82182 · Substantial damageNTSB LAX86LA180Accident · No injuriesLimited investigationFinal reportCessna 150K · Joshua Tree, CAThe plt landed at the yucca valley arpt to refuel, but no fuel was available. The acft fuel gages registered 1/8 & 1/4 full, so the plt took off on a planned 7 min flt to another arpt. About 4 min after departing, fuel exhaustion occurred. During an emergency…Apr 16, 1986 · N6398G · Substantial damageNTSB LAX86FA178Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Beaumont, CAWhen the non-instrument rated plt departed for the flt at about 2110 hrs, the wx conditions were marginal and deteriorating in the area. No record of a wx briefing was found. For unkn reasons, the plt was returning to the arpt after about 1 hr and 20 mns,…Apr 16, 1986 · N28891 · DestroyedNTSB LAX86DVA06Accident · Minor injuriesFinal reportBell UH-1B · Chowchilla, CAWhile returning from a spraying operation the plt observed that the main transmission oil pressure gage indicated zero. The plt reported that the engine master caution did not illuminate and that the oil temperature gage was normal. The plt stated that he…Apr 16, 1986 · N910PD · DestroyedNTSB SEA86LA105Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORThe plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…Apr 15, 1986 · N9417A · Substantial damage