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 CHI82DA176Accident · Minor injuriesFinal reportBell 47G-1 · Cincinnati, OHThe fore and aft cyclic control linkage tube became disconnected in flight. An emergency descent, using collective "s" turns to reduce airspeed was performed. The pilot intentionally collided with trees during the forced landing to cushion the fall.…May 20, 1982 · N141B · Substantial damageNTSB MKC82DA083Accident · Minor injuriesFinal reportCessna 150 · Chadron, NEAfter flying 1.2 hours with an instructor pilot the student pilot was released for solo flight. The student then flew for .7 hours before running out of fuel. The aircraft nosed over after touching down in a pasture. The instructor pilot stated that the fuel…May 19, 1982 · N2259J · Substantial damageNTSB DEN82DA091Accident · No injuriesFinal reportCessna 180 · Backoo, NDThe pilot flew to the vicintiy of his destination by following the path of recent showers. He was a farmer and was interested in the amount of standing water. He had arranged to fly over a friend's house so the friend would pick him up at the airport. After…May 19, 1982 · N2195C · Substantial damageNTSB ATL82DA138Accident · No injuriesFinal reportBellanca 17-30 · Havelock, NCAbout eight minutes after takeoff, the pilot declared an emergency and reported an engine failure. He diverted, but was unable to reach the airport. A gear-up landing was made about one mile short of the runway. An examination of the aircraft revealed that…May 19, 1982 · N6690V · Substantial damageNTSB LAX82FUA15Accident · Minor injuriesFinal reportCessna 150 · Torrance, CAThe purpose of the flight was to provide instrument training to a non-instrument rated pilot. The aircrew estimated that there was 10 gallons of fuel on board when they took off. About 1 hr later, the engine lost power as the aircrew were entering the traffic…May 18, 1982 · N5910J · Substantial damageNTSB NYC82DA100Accident · No injuriesFinal reportPiper PA-38 · Punxsutawney, PAWhile descending to confirm his position because of encountering rain on a cross country flight the student pilot discovered an engine RPM loss. After attempting to restore power several times an emergency landing was made into a plowed field during which the…May 17, 1982 · N2363A · Substantial damageNTSB LAX82FA183Accident · 4 fatalField investigationFinal reportBeech A24R · Near Mt. Shasta, CAThe flight originated at reno, NV, but the pilot landed at red bluff, CA after receiving an in-flight weather briefing. After landing, he obtained another weather briefing and was advised that VFR flight was not recommended. He then filed a VFR flight plan…May 17, 1982 · N9715L · DestroyedNTSB LAX82DA179Accident · No injuriesFinal reportCessna 172B · Crows Landing, CAAfter climbing to 3000 ft the engine began to lose power, the pilot pumped the throttle and the engine power became erratic. The pilot attempted to land at a naval air station but was forced to land in a plowed field when the engine lost all power. The…May 17, 1982 · N7444X · Substantial damageNTSB FTW82FRG31Accident · Serious injuriesFinal reportPiper PA-30 · San Antonio, TXDue to unfavorable weather conditions enroute to austin, TX the pilot diverted to San Antonio, TX. The engines lost power as the aircraft approached the destination airport. The pilot was unable to restart the engines or glide to the airport and the pilot…May 17, 1982 · N7705Y · Substantial damageNTSB DEN82DA089Accident · No injuriesFinal reportEnstrom F-28C · Marmath, NDThe pilot reported that while he was in flight at about 75 to 80 ft AGL, the engine lost power. During an autorotative landing in an open pasture, a skid dug into the ground and the helicopter rolled over. A subsequent engine teardown revealed evidence that…May 17, 1982 · N8617J · Substantial damageNTSB CHI82DA171Accident · Minor injuriesFinal reportBell 47G-5 · Sublette, ILPrior to this flight, the helicopter had been flown about 1 hr from roselle to Sublette, IL, then it was flown another 1/2 hr to survey the area to be sprayed. About 10 minutes after departing to spray, the engine lost power. The pilot started an autorotative…May 17, 1982 · N7841S · Substantial damageNTSB NYC82FHD12Accident · No injuriesFinal reportCessna 188A · Winslow, NJThe acft ran out of fuel while returning to the arpt. The acft landed into a plowed field & then on into an orchard.May 16, 1982 · N3520Q · Substantial damageNTSB NYC82DA095Accident · No injuriesFinal reportNorth American SNJ-5 · Toughkenamon, PAAccording to the pilot, takeoff and departure were normal, however, shortly after the first power reduction the engine lost power and windmilled to touchdown. The pilot in the rear seat took control of the aircraft and landed in a plowed field. The loss of…May 16, 1982 · N3673F · Substantial damageNTSB LAX82DA176Accident · No injuriesFinal reportPiper PA-28-201T · Van Nuys, CADuring flight at about 1500 ft, the engine suddenly lost power and the propeller stopped turning. The pilot attempted a restart, but the starter would not turn the propeller. The pilot maneuvered to make a forced landing at the Van Nuys airport. The aircraft…May 16, 1982 · N8089N · Substantial damageNTSB LAX82DA175Accident · No injuriesFinal reportCessna 177B · 6 Nm S. Of Lake, CAThe pilot stated that when he performed his preflight of the aircraft the visual check of the fuel tanks indicated fuel to the bottom of the tabs. Twenty two minutes after takeoff the engine quit. He executed a landing and the aircraft collided with a ditch…May 16, 1982 · N16150 · Substantial damageNTSB FTW82FRG29Accident · 4 fatalFinal reportBeech 95-C55 · Eagle Pass, TXThe wreckage was located approximately 16 mi se of Eagle Pass & with the exception of the elevators, all major components of the acft were identified at the scene. The outboard half of the r elevator was found 2 mi nw & the counterweight on the elev tip was…May 16, 1982 · N14RR · DestroyedNTSB CHI82FA168Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Joilet, ILWhen the aircraft was about 1 1/2 miles from the destination, a fire started on the left side of the floorboard against the firewall. The pilot turned off the electrical system, and before landing, shut off the fuel selector. After landing, the occupants…May 16, 1982 · N3723Z · DestroyedNTSB SEA82FYM15Accident · 3 fatalFinal reportBeechcraft S35 · Walla Walla, WAWhile en route on a dark night, the aircraft collided with mountainous terrain in a heavily wooded, snow covered area. An investigation revealed that the plane crashed while in or near level flight at an altitude of about 4500 ft MSL. The top of the mountain…May 15, 1982 · N175Q · DestroyedNTSB NYC82DA098Accident · No injuriesFinal reportAero Commander 680F · Prospectville, PAThe pilot had planned to purchase the aircraft and was ferrying it to buffalo, NY for inspection and repair. While en route, the right engine lost power. He feathered the right propeller and diverted to turner field. When he lowered the gear, he did not get a…May 15, 1982 · N567D · Substantial damageNTSB NYC82DA097Accident · No injuriesFinal reportBell 47G-2 · Brookville, NYWhile returning to the heliport, the pilot noticed a decay in the engine and rotor rpm's. he elected to make a precautionary landing in a plowed field. During landing, the manifold pressure went to the red line while the RPM decayed. The helicopter touched…May 15, 1982 · N911X · Substantial damageNTSB LAX82DA172Accident · Minor injuriesFinal reportBeech A23-19 · Peach Springs V, AZDuring a cross country air race the aircraft failed to clear a ridgeline. The pilot stated that with full throttle and adequate rpm's the aircraft was unable to climb out of a downdraft after having flown into a box canyon.May 15, 1982 · N5792V · DestroyedNTSB FTW82DA180Accident · Minor injuriesFinal reportNash Cassutt Racer 111M · Sebastian, TXDuring cruise flight the engine misfired then quit and would not restart. The pilot made a forced landing in a grain field and the aircraft nosed over. No preimpact mechanical malfunction or failure was found.May 15, 1982 · N176N · DestroyedNTSB FTW82DA178Accident · No injuriesFinal reportBell 206L-1 · Cameron, LAWhile enroute to refuel the pilot experienced a loss of power and elected to autorotate to the ground. The aircraft rocked forward then back on landing and the main rotor severed the tailboom. Investigation revealed both fuel flow switches were stuck in the…May 15, 1982 · N2048X · Substantial damageNTSB CHI82DA170Accident · Serious injuriesFinal reportPlaymate SA11A · Pendleton, INThe pilot was cruising at 2000 feet with one passenger when the engine quit. He made a forced landing in a soft soybean field and the aircraft nosed over during deceleration. The aircraft revealed the exhaust system baffles were collapsed. "Blow by" was…May 15, 1982 · N4652 · Substantial damageNTSB FTW82DA182Accident · No injuriesFinal reportCessna T210N · Tulsa, OKWhile cruising at 17,500 feet the aircraft encountered clear air turbulence and went inverted. During recovery the aircraft entered a spin. Recovery was made at 16,750 feet. The pilot continued on to Tulsa and landed safely. The aircraft received substantial…May 14, 1982 · N4608C · Substantial damageNTSB SEA82FA070Accident · Minor injuriesField investigationFinal reportHughes 369D · 6nm Sse Wrangel, AKThe pilot reported that the aircraft was on a reconnaissance flight to survey a proposed powerline project. He reported that during the flight, the engine flamed out and an autorotation was initiated. He maneuvered the helicopter to land in a clearance, but…May 13, 1982 · N1107T · Substantial damageNTSB SEA82DA069Accident · No injuriesFinal reportPiper PA 28-181 · Port Angeles, WAAbout 10 minutes after takeoff, the pilot realized that he was south of course. After beginning a shallow turn back to course, he realized that he was in close proximity to mountainous terrain. He made an abrupt 40 degree left bank to get away from the…May 13, 1982 · N8113B · Substantial damageNTSB MKC82DA078Accident · Serious injuriesFinal reportCessna T210N · Near O'Neill, NEThe aircraft landed successfully at centerville, IA on its first leg of the flight. The aircraft was not refueled and the pilot estimated 4 hrs fuel on board for a 2 hr and 40 minute flight. The flight made 4 missed approaches before proceeding to an…May 12, 1982 · N9649Y · Substantial damageNTSB FTW82FA171Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Lorenzo, TXThe aircraft crashed while the pilot was trying to return to the departure airport after a night takeoff. Marginal VFR conditions were forecast with thunderstorms predicted. The aircraft accident occurred in area where a thunderstorm was in progress. His…May 12, 1982 · N9697C · DestroyedNTSB DCA82IA021Incident · No injuriesIncident investigationFinal reportGates Learjet 24B · Ft. Myer, FLWhile climbing to a cruise altitude of 41000 feet, the pilot engaged the autopilot at approximately 29500 feet. The aircraft started to pitch nose down several seconds later. The pitch trim switch was turned off and the circuit breakers pulled. The pilots…May 12, 1982 · N721J · No damageNTSB CHI82DA162Accident · No injuriesFinal reportHiller 12E · Benson, MNHelicopter flying at 250 feet to stay below clouds had engine failure. Landed downwind in muddy field. Right skid collapsed.May 12, 1982 · N4030C · Substantial damageNTSB CHI82FA160Accident · 1 fatalField investigationFinal reportCessna 172C · Sunburg, MNThe pilot received several weather briefings and was advised of a severe cold front and thunderstorms in an area on his route. Prior to takeoff, he was advised that VFR flight was not recommended. While en route, the pilot reported that he was "totally…May 11, 1982 · N8432X · DestroyedNTSB LAX82FA167Accident · 2 fatalField investigationFinal reportCessna 172 · Morman Lake, AZThe acft departed winslow, AZ on a flt to long beach, CA with an en route stop scheduled for prescot, AZ. Before departing winslow, the plt was warned by another plt that he had encountered extreme turbulence in the vicinity of mormon mtn. The plt and pax's…May 10, 1982 · N78810 · DestroyedNTSB FTW82FRG30Accident · 2 fatalFinal reportCessna 182E · Armstrong, TXBefore taking off, the pilot reviewed the weather in person at the college station fss, but declined an official weather briefing. He departed in good VFR conditions and flew into an area of known and forcasted low ceilings. While en route, his flight path…May 10, 1982 · N9330X · DestroyedNTSB MKC82FA075Accident · Serious injuriesField investigationFinal reportBeech A36 · Smithville, MOThe plt reported a loss of power & unable to reach the arpt. The acft collided with trees during the forced landing & then landed hard, gear up, in a farmyard. Examination revealed that the left fuel tank was empty. The right fuel tank was full & the fuel…May 9, 1982 · N1877L · Substantial damageNTSB MKC82DA076Accident · Minor injuriesFinal reportBellanca 14-19 · Hays, KSThe pilot had purchased the aircraft in Iowa and had obtained a ferry permit to fly it to his home in California. In the vicinity of Hays, Kansas, the fuel tank he was using ran dry. He switched to another tank, turned on the electric boost pump and tried to…May 9, 1982 · N501A · Substantial damageNTSB LAX82FA171Accident · 3 fatalField investigationFinal reportCessna 172N · El Portal, CAThe wreckage was located at 4,750 ft MSL on the east side of a north/south oriented ridge. The acft had traveled uphill approximately 110 ft on a 45 deg slope on a heading of 236 deg, coming to rest about 50 ft below the top of the ridge.May 9, 1982 · N2996E · DestroyedNTSB LAX82FA168Accident · 2 fatalField investigationFinal reportCessna T210M · Mt. Wilson, CAAt the fss the plt requested the current & forecast salt lake city wx. The wx was furnished & the specialist advised that VFR flt was not recommended. The plt did not wish a full briefing & was heard to say to his passenger "let's go check it out." The acft…May 9, 1982 · N6812B · DestroyedNTSB FTW82DA170Accident · No injuriesFinal reportCessna 152 · Coahama, TXThe pilot was on a cross country flight for his commercial pilot's license. He became lost, landed in a plowed open field and the aircraft nosed over. There was no evidence of propeller rotation or fuel at the scene of the accident.May 9, 1982 · N757RS · Substantial damageNTSB CHI82FA157Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Milwaukee, WIEngine failure forced pilot to land in an open plowed field. Aircraft collided with wires but a successful landing was made. Oil pump gear tooth had failed.May 9, 1982 · N6837J · Substantial damageNTSB ATL82FLQ05Accident · 1 fatalFinal reportBeech J35 · Magan, KYAt about 2017 EDT, approach control cleared the pilot to descend from 7000 ft to 2500 ft and began providing vectors for an ILS approach. About 9 minutes later, approach control advised that radar contact was lost, but no reply was received. At about 2042,…May 9, 1982 · N8376D · DestroyedNTSB ATL82FIJ01Accident · 1 fatalFinal reportBrantley B-2B · Athens, WVThe helicopter crashed in a wooded, rocky area while the pilot was en route from the welch hospital to his residence in Athens, WV. An investigation revealed that the fuel tank bladder had ruptured, but no odor of fuel was noted. Later, the engine was…May 9, 1982 · N2255U · Substantial damageNTSB ATL82DA127Accident · No injuriesFinal reportBeech 35-B33 · Herndon, VAFollowing an engine failure, the pilot had a limited choice of terrain for landing. He landed hard and slid into trees. A metallurgical examination revealed that the shaft on the engine oil pump drive gear, pn 538609, had failed from fatigue. Evidence of…May 9, 1982 · N969H · Substantial damageNTSB ANC82DAG23Accident · No injuriesFinal reportBellanca 7ECA · Culkana, AKDuring the flight the pilot descended to about 500 feet AGL. Carburetor heat was not applied. When the throttle was advanced the engine RPM did not respond. Attempts to restore power were unsucessful and the aircraft came to rest inverted after colliding with…May 9, 1982 · N5513K · Substantial damageNTSB LAX82FA161Accident · 3 fatalField investigationFinal reportSmith Aerostar 600 · Burbank, CAThe aircraft departed into IFR conditions with a non-instrument rated pilot in the left front seat and his wife, an instrument rated pilot, in the right front seat. After the pilot reported climbing through 2800 ft MSL, the radar controller observed that the…May 8, 1982 · N8007J · DestroyedNTSB SEA82DA065Accident · Minor injuriesFinal reportCessna 182P · Walla Walla, WAAfter arriving in the Walla Walla area the pilot executed a spiraling descent, using carburetor heat, so as to arrive at pattern altitude. When he commenced a level-off the engine would not respond. A force landing was executed into a nearby field.…May 7, 1982 · N6319F · Substantial damageNTSB MIA82DA118Accident · Minor injuriesFinal reportCessna T210M · Fort Lauderdale, FLApproximately 18 miles west of the Fort Lauderdale airport, while cruising at 7500 feet, the engine lost power. After advising the tower of the problem, ATC suggested attempting a landing at a closer airport. At this point the pilot stated that power had been…May 7, 1982 · N613C · Substantial damageNTSB MIA82DA116Accident · No injuriesFinal reportAerospatiale SA-319B · Jacksonville, FLThe pilot and crew were using an air ambulance helicopter while participating with the fire department in a simulated disaster drill. During the drill, the helicopter took off with two other occupants that had volunteered to act as immobilized patients. With…May 7, 1982 · N90825 · Substantial damageNTSB NYC82FNC09Accident · No injuriesFinal reportCessna U206 · Millinocket, MEBefore departing smith pond, Maine, the pilot checked the fuel and estimated he had between 30 and 40 gallons on board. He flew to waterville, then to katachdine lake, and was on the next leg of the flight when the engine lost power. He switched tanks and the…May 6, 1982 · N60166 · Substantial damageNTSB DCA82AA020Accident · 4 fatalFinal reportGates Learjet 23 · Near Savannah, GAThe flt was cleared to descend from FL410 to FL390. The flightcrew acknowledged the clearance & ATC observed the radar target descend. The acft suddenly pitched up when within 600 ft of FL390 & climbed. The pitchup was followed by two pitch oscillations which…May 6, 1982 · N100TA · Destroyed