OpenAirDocs.org

NTSB investigations

35,889 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 FTW82FA071Accident · 1 fatalField investigationFinal reportRobinson R22 · San Marcos, TXThe helicopter was observed rotating in a counter clockwise motion. A small explosion was seen at the tail section with pieces flying off. The outboard sections of the t/r blades were found about 800 ft from the main wreckage. Examination of the fractures…Feb 26, 1982 · N9061Z · DestroyedNTSB ATL82FA059Accident · 4 fatalField investigationFinal reportCessna 210L · Hilton Head, SCThe aircraft departed dulles international airport at 1630 EST, no flight plan was filed. The next radio contact with the aircraft was by beaufort marine corps air station approach control when the controller transmitted the altimeter setting and the pilot…Feb 26, 1982 · CGMYL · DestroyedNTSB MIA82DA077Accident · Serious injuriesFinal reportCessna 210 · Atlantic Ocean (Atlantic Ocean)The pilot reported departing valkaria, Florida on a VFR round robin flight to great abaco island, Bahamas and return. While on the return leg of the flight, the engine lost power. The pilot was unable to restore power or glide to land; therefore, he ditched…Feb 24, 1982 · N761MG · DestroyedNTSB LAX82FUJ31Accident · Serious injuriesFinal reportRockwell Commander 114 · San Simon, AZAfter refueling at abilene the aircraft departed around noon on the second leg of a flight to repossess the aircraft. The pilot stated that he ran the engine at full rich with the fuel flow meter reading 18 gph. Using this figure the aircraft should have run…Feb 24, 1982 · N4802W · DestroyedNTSB FTW82FQA15Accident · 1 fatalFinal reportBell 206B · Watrous, NMThe helicopter struck power and communication lines after taking off at night. After hitting the lines, it crashed into a railroad grade and bridge. The crash site was about one mile from the departure point. An inspection of the engine revealed no preimpact…Feb 24, 1982 · N2272D · DestroyedNTSB ATL82DA058Accident · No injuriesFinal reportEagle DW-1 · Clarksdale, MSThe pilot reported no indication of engine malfunction during takeoff and climb-out. However, after turning in a downwind direction, he noted a loss of airspeed and power. He stated that the power loss was so gradual that he noticed nothing unusual until the…Feb 24, 1982 · N8803H · Substantial damageNTSB NYC82DA049Accident · No injuriesFinal reportCessna 421C · Westerly, RIThe aircraft touched down hard during a night landing after the pilot encountered icing conditions in flight. Several witnesses reported that the aircraft had 1/2 to 3/4 inch of ice on the leading edges of the wings and verticle stabilizer. The gross landing…Feb 23, 1982 · N5358J · Substantial damageNTSB LAX82FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Truckee, CAThe non-instrument rated pilot was on a return flight from livermore, CA to Truckee. The aircraft crashed on a dark night at an elevation of about 6700 ft MSL in mountainous terrain. The angle of impact was about 25 degrees downward on a down hill slope. A…Feb 22, 1982 · N3646R · DestroyedNTSB DEN82FA062Accident · 2 fatalField investigationFinal reportBellanca 14-19-3A · Selfridge, NDOn the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…Feb 22, 1982 · N8869R · DestroyedNTSB MKC82DA036Accident · No injuriesFinal reportPiper PA-32R-301T · Marceline, MOThe pilot stated that while cruising at 7000 feet the engine began vibrating, lost power, and eventually stopped. He elected to land in an open field resulting in substantial damage to the aircraft. Examination of the engine revealed that the intake valve…Feb 21, 1982 · N8424B · Substantial damageNTSB LAX82FA080Accident · Minor injuriesField investigationFinal reportCessna 172N · Catalina Island, CAWhile circling around Catalina Island turning in an out of canyons at 1700 feet MSL the engine lost power. At los angeles international airport, 38 miles to the nnw, the temperature was 65 degrees and the dew point was 45 degrees. All attemps to restart the…Feb 21, 1982 · N4906G · Substantial damageNTSB DCA82AA016Accident · 1 fatalFinal reportde Havilland DHC-6 · Providence, RIAprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…Feb 21, 1982 · N127PM · DestroyedNTSB NYC82DA039Accident · No injuriesFinal reportPiper PA-44-180T · Mount Pocono, PABefore takeoff, the pilot got a weather briefing and called the airport manager at the destination. Reportedly, the destination airport was open and usable at that time. In flight, the pilot asked ATC about reports of icing in the mt Pocono area and got a…Feb 20, 1982 · N8226A · Substantial damageNTSB ANC82DA020Accident · No injuriesFinal reportGrumman G-21A · N Cape Yakataga, AKAircraft departed merrill field at 1110 with 220 gallons of fuel. Two hours later both engines quit while flying at an altitude of 6500 feet approximately 10 miles offshore. The crew was unable to restart the engines and the aircraft was ditched into 12 to 15…Feb 20, 1982 · N2845D · Substantial damageNTSB LAX82FA077Accident · No injuriesField investigationFinal reportBell 47G2 · Brawley, CAThe pilot visually checked the gas tank before takeoff and estimated there was about 1/4 tank of fuel. He then started the engine and hovered over to the water tanker and loaded 60 gallons of water in the spray tank in order to calibrate the number of gallons…Feb 19, 1982 · N4021A · Substantial damageNTSB DEN82FTM09Accident · 1 fatalFinal reportBeech A36 · St. George, UTThe aircraft was on a flight from las vegas, Nevada to St. George, Utah when it flew past the destination and struck the side of a mountain. The crash site was located about 15 miles beyond the destination at an elevation of about 7600 ft MSL. The site was…Feb 19, 1982 · N4295S · DestroyedNTSB ATL82FA057Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hytop, ALThe pilot filed and departed VFR into forecast marginal flight conditions. While en route the destination went IFR and this information was passed on to the pilot. The pilot replied that he was going to continue on and get as close to chattanooga as possible.…Feb 19, 1982 · N5552F · DestroyedNTSB FTW82FQA13Accident · Serious injuriesFinal reportPiper PA-28RT-201T · Toadlena, NMThe non-instrument rated pilot in Piper PA-28RT, N29665, was using a call sign, N1104X, which was the registration number of a destroyed PA-32. He was cleared to climb to FL200, but as he continued, his speech became slurred. He acknowledged an artc…Feb 18, 1982 · N29665 · Substantial damageNTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…Feb 16, 1982 · N44710 · Substantial damageNTSB CHI82DA057Accident · No injuriesFinal reportBeech 90 · Columbus, OHWith OAT 25 degrees below zero and the aircraft flying through heavy rain the pilot reported the elevator trim tab became inoperative. While attempting to stabilize the aircraft manually during an ILS approach the aircraft descended below glideslope and…Feb 16, 1982 · N3DS · Substantial damageNTSB CHI82FA048Accident · 1 fatalField investigationFinal reportPiper PA-23 · Corydon, INPrior to this flight, the aircraft had not been flown for an extended period. On the day of the accident, it had been sold. The aircraft did not have a current annual inspection and had several maintenance discrepancies. These included problems that prevented…Feb 15, 1982 · N1108P · DestroyedNTSB LAX82FA078Accident · 4 fatalField investigationFinal reportCessna 172K · Hollister, CAThe aircraft flew into the side of a mountain in level cruise. The accident happened during weather in which VFR flight had not been recommended. Clouds were obscuring the mountains. The aircraft was on the return leg of a cross-country flight. No flight plan…Feb 14, 1982 · N99WM · DestroyedNTSB LAX82FA074Accident · 1 fatalField investigationFinal reportPiper PA-34 · Near Sonoma, CAThe pilot proceeded VFR toward a private strip after an instrument approach to napa county airport. The visibility was not good and the aircraft collided with a hillside while en route. About 5 mi north, the weather at the napa county airport was 500 ft…Feb 14, 1982 · N8455Y · DestroyedNTSB LAX82FA073Accident · 2 fatalField investigationFinal reportRockwell 112A · Near Los Banos, CADuring a preflight briefing, the pilot was advised that the mountains were obscured by clouds, the outlook was for marginal VFR ceilings, and the weather conditions in northern California were deteriorating faster than forcasted. The pilot took off at 1333…Feb 14, 1982 · N1433J · DestroyedNTSB LAX82DUG06Accident · Serious injuriesFinal reportCessna 150 · Daggett, CAWhile descending through 4000 ft MSL to land, the engine began to surge. The pilot moved the mixture to full rich and selected carburetor heat, but the engine lost all power. Reportedly, the aircraft was demolished during a forced landing. Disassembly of the…Feb 14, 1982 · N4539U · DestroyedNTSB CHI82DA046Accident · Minor injuriesFinal reportCessna 150 · Altamont, ILAbout five to ten minutes after takeoff at night, the engine began to lose power and then suddenly stopped. Pilot elected to land in a light colored area that was surrounded by darker areas. During the approach, the aircraft struck a tree which damaged the…Feb 14, 1982 · N9447U · Substantial damageNTSB LAX82FA071Accident · 4 fatalField investigationFinal reportBeech J35 · Gilroy, CAThe plt was advised during the wx briefing that VFR flight was not recommeded across the mountains & that san jose was reporting 3,000 ft scattered; 4,000 ft broken; 9,000 ft overcast with 10 mi visibility with light rain. Approximately 36 min after takeoff…Feb 13, 1982 · N8385D · DestroyedNTSB CHI82FEG02Accident · Serious injuriesFinal reportPiper PA-24-250 · Pleasant Hill, OHWhile enroute, the pilot elected to climb over the weather rather than fly through it. At about 12,000 ft MSL over the weather, he encountered an engine problem. He initiated emergency procedures and informed dayton approach control of his problem. Unable to…Feb 13, 1982 · N5266P · DestroyedNTSB NYC82IA036Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-100 · Jamaica, NYDuring cruise flight, the aircraft experienced a power failure and fire in the left engine. The crew secured the engine and discharged the fire extinguisher without effect on the fire. During descent to jfk international the fire extinguished itself. A normal…Feb 12, 1982 · N80701 · No damageNTSB MIA82FA045Accident · 2 fatalField investigationFinal reportCessna 421 · Miami, FLThe flight departed the tamiami airport, Miami, Florida at approximately 2100 EST on February 9, 1982. There was no flight plan filed and the purpose, destination, and locations of possible enroute stops were not determined. The next reported communication…Feb 11, 1982 · N24CC · DestroyedNTSB LAX82FA069Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Twentynine Palm, CAAt 1605, the flt called blythe fss stating he was 25 mi east for landing. When he heard that his business associates in another acft were preparing to depart blythe for Twentynine palms, the plt cancelled his landing intentions & stated that they will be…Feb 11, 1982 · N200WJ · DestroyedNTSB ATL82FA052Accident · No injuriesField investigationFinal reportCessna 401 · Jessup, GAAfter reaching a cruise altitude of 9500 feet the pilot noticed smoke coming out of the left engine cowling. He then proceeded to reduce the left throttle but was unable to move the lever. According to the pilot the fire was extinguished when the left fuel…Feb 10, 1982 · N8299F · Substantial damageNTSB LAX82FA072Accident · 4 fatalField investigationFinal reportCessna P210N · 6 Nm North Of S, AZThe pilot was advised that VFR to flagstaff was not recommended. He advised the briefer that he had just recently flown from sedona and knew he could return VFR. At about 1938 MST, the plane departed phoenix with no flight plan. While en route, the pilot…Feb 8, 1982 · N731NQ · DestroyedNTSB LAX82FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Santa Ysabel, CADrg wx briefings at 1024 & 1247 the plt was advised that VFR flt was not recommended due to low ceilings & icing conditions. At about 1418 the acft departed. At 1439 the plt contacted flight watch (fw) & reported picking up leading edge ice 6.4 mi east of the…Feb 8, 1982 · N733ZR · DestroyedNTSB ATL82DA049Accident · Minor injuriesFinal reportCessna C-172 · Brownsville, KYWhile climbing after takeoff, the pilot noticed smoke in the cockpit. He reported that flames started to come in as he was turning back to the airstrip. When he saw that he could land back on the strip, he reportedly shut- off the fuel, master switch and…Feb 8, 1982 · N13165 · DestroyedNTSB MIA82FA044Accident · 8 fatalField investigationFinal reportCessna 182B · W. Of Homestead, FLCessna N2280G and Piper N7361P collided in midair in a remote area of the everglades national park, Florida.Feb 7, 1982 · N2280G · 2 aircraft · DestroyedNTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…Feb 7, 1982 · N46733 · Substantial damageNTSB MIA82FA042Accident · 2 fatalField investigationFinal reportRobinson R-22 · Ormand Beach, FLAfter being told by the operator to remain on the ground until the weather improved the instructor pilot departed ormond Beach airport. The pilot radioed daytona Beach approach control and requested a special VFR clearance and vectors to daytona Beach…Feb 5, 1982 · N90286 · DestroyedNTSB MIA82DA050Accident · 2 fatalFinal reportPiper PA-28 · 120 Nm Sse Of M, FLAt about 1216 the pilot of a Cessna 402, N69400, heard N1306H announce on the radio that he was 100 miles south of bimini and had 15 minutes of fuel remaining. The captain of American airlines flight 603 heard the pilot state that he was going in and he…Feb 5, 1982 · N1306H · DestroyedNTSB ATL82FA047Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Lambsburg, VAThe aircraft was on an air taxi flight to transport 2 prisoners and was to be operated on a VFR flight plan in VFR conditions only. Prior to takeoff, the pilot had obtained 12 weather briefing. In 2 of the briefings, VFR flight was not recommended. At about…Feb 5, 1982 · N75225 · DestroyedNTSB ATL82DA046Accident · Serious injuriesFinal reportCessna T210L · Luverne, ALThe engine abruptly quit during takeoff after the pilot reduced power and started a crosswind turn. The nose gear collapsed rearward during landing roll in a soft terraced pasture and the aircraft flipped to an inverted position. Two ounces of water were…Feb 5, 1982 · N123WL · Substantial damageNTSB LAX82FUJ27Accident · 1 fatalFinal reportMooney M20J · Paradise Valley, AZThe pilot picked up the new aircraft from the factory at kerrville, Texas on the day of the accident. He was ferrying the plane to his home in new jersey by way of las vegas, Nevada. He declined an offer to be checked out in the plane and departed kerrville…Feb 4, 1982 · N11578 · DestroyedNTSB CHI82DA034Accident · No injuriesFinal reportBell 206L-1 · Indianapolis, INThe engine lost power during a night flight while enroute to obtain fuel. The low RPM audio and warning light were noted when the loss of power occurred. The pilot entered an autorotative descent and turned to land on an interstate highway. As he started to…Feb 3, 1982 · N2777B · Substantial damageNTSB FTW82FRA15Accident · Serious injuriesFinal reportAerospatiale SA-360C · Hitchcock, TXDuring a return flight from an offshore platform, the pilot encountered strong headwinds and elected to land at lake jackson, Texas for fuel. He lacked a proper mode of payment; therefore, he was unable to purchase fuel. He departed for galveston, Texas with…Feb 2, 1982 · N213EH · DestroyedNTSB DEN82DA028Accident · Serious injuriesFinal reportPiper PA-32 · Rock Springs, WYThe aircraft departed vernal,ut at 1810 MST after refueling. During the VFR flight the pilot reported to Rock Springs fss that he was 20 miles south and was given current weather and runway in use. No other transmissions were received. The aircraft struck a…Feb 2, 1982 · N8178F · Substantial damageNTSB MKC82DA024Accident · Serious injuriesFinal reportBeech 36 · Malden, MOThe pilot was briefed on the enroute weather prior to departure. Records indicate that sigmets on icing and turbulence along the route were provided to the pilot. When the pilot encountered icing conditions in flight, he continued instead of turning back to…Jan 31, 1982 · N5005M · Substantial damageNTSB LAX82DA057Accident · No injuriesFinal reportCessna 177B · Elko, NVThe owner of the aircraft stated that he had "topped the tanks" after the previous flight. The pilot of this flight said that he did not visually check the fuel before takeoff. During flight, the right fuel gauge continued to indicate full. About 15 miles…Jan 30, 1982 · N35289 · Substantial damageNTSB LAX82DA055Accident · No injuriesFinal reportMooney M20J · Avalon, CAThe pilot stated that upon touchdown at santa catalina airport she discovered that the trim was stuck. As the aircraft reached midfield the pilot elected to make a go-around. During climbout while passing through 1700 feet the pilot stated that she smelled…Jan 30, 1982 · N4510H · DestroyedNTSB MKC82FA023Accident · 1 fatalField investigationFinal reportCessna 172N · 5m E. Greensbur, KSThe plt received a wx briefing for a flt to dodge city,KS. The fss specialist asked the plt if he was proposing his flight under IFR since his destination was reporting IMC. The plt replied that he was. A ground witness at haviland,KS located about 5 miles…Jan 29, 1982 · N1589E · DestroyedNTSB LAX82FVM09Accident · 1 fatalFinal reportPiper 28-151 · Los Gatos, CAThe pilot prepared to depart on a scheduled courier run in a Piper PA-32, but was unable to start the engine. After consulting with company personnel, he rented a Piper PA-28-151, transferred the cargo and departed monterey, CA on a flight to oakland, CA.…Jan 29, 1982 · N32678 · Destroyed