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 NYC82DA138Accident · No injuriesFinal reportGrumman AA-1C · West Haven, CTThe student pilot departed bridgeport, CT at 1200 hours and arrived at nantucket, ma at 1345 hours. While en route, he made a touch-and-go at fishers island and practiced stall maneuvers. He departed nantucket at about 1430 hours without refueling.…Jul 2, 1982 · N39050 · Substantial damageNTSB LAX82FA247Accident · No injuriesField investigationFinal reportHughes 369B · Jenner, CAHelicopter was on routine police patrol when engine failed and it autorotated to a rough landing on a rocky beach. The 1st stage of the gas producer section of the turbine was found frozen. The turbine wheel blades were rubbing & seized to the 1st stage…Jul 2, 1982 · N1108T · Substantial damageNTSB LAX82FA240Accident · 2 fatalField investigationFinal reportBeech V35B · 37 Nm Nw. Of Re, CADuring a weather briefing before takeoff, the pilot was advised of flight precautions for turbulence, IFR conditions, and icing. While en route at 12,000 ft, the pilot reported that he was picking up rime ice. He was cleared to 11,000 and then 10,000 ft. when…Jul 2, 1982 · N23725 · DestroyedNTSB DEN82DA125Accident · Minor injuriesFinal reportErcoupe 415-C · Wamsutter, WYThe pilot became sick during the flight and elected to land on a highway. He took spacing behind a truck, but the truck slowed down, so he continued the landing beside the highway. After lowering the nosewheel, it hit a ditch and collapsed, and the aircraft…Jul 2, 1982 · N99481 · Substantial damageNTSB ATL82DA183Accident · No injuriesFinal reportBell 47D1 · Louisville, KYThe pilot was en route to have a radio installed when the engine lost power. He made an autorotative landing in an open field. When the helicopter contacted the ground, the main rotor, tail rotor, tail boom, and skids were damaged. The pilot stated that he…Jul 2, 1982 · N929B · Substantial damageNTSB NYC82DA136Accident · No injuriesFinal reportCessna 182Q · Sidman, PAAt approximately 10 miles out of johnstown, PA while descending through 5000 ft, the pilot realized he was running out of fuel. At about 4000 ft the pilot spotted a field and an approach to landing was initiated. During the landing roll the front wheel…Jul 1, 1982 · N735TR · Substantial damageNTSB CHI82DA230Accident · No injuriesFinal reportPiper PA-28-161 · Ladysmith, WIThe student pilot collided with a fence and rough terrain during a forced landing on a cross-country flight. The student heard a loud knocking from the engine after about 35 minutes of flight. He reduced power which helped but the engine was still noisy. The…Jul 1, 1982 · N40037 · Substantial damageNTSB ATL82FLQ07Accident · Serious injuriesFinal reportKR-2 · Mcwhorter, KYThis was a home built aircraft that was equipped with an uncertificated, variable pitch, propeller. During flight, a propeller blade separated and the plane was substantially damaged when a forced landing was made on upward sloping terrain. The aircraft and…Jul 1, 1982 · N27JK · DestroyedNTSB FTW82DA256Accident · No injuriesFinal reportCessna 150A · Fabens, TXThe pilot reported that on a flight from midland to el paso, TX, he encountered marginal weather. Flight watch had reported rain and thunderstorm activity about 30 miles east of el paso. As the weather on his route worsened and became more turbulent, he…Jun 30, 1982 · N7027X · Substantial damageNTSB ATL82DA181Accident · No injuriesFinal reportCessna 172 · Martinsburg, WVShortly after level-off to cruise, the engine began to lose power. The pilot attempted to restore the power, but the engine RPM continued to decrease. A turn was made back toward the airport. While scanning the instruments, zero oil pressure and a high oil…Jun 30, 1982 · N61791 · Substantial damageNTSB SEA82DA098Accident · No injuriesFinal reportPiper PA-32-300 · Glacier Bay, AKThe aircraft engine stopped during normal cruise and an emergency landing was made in a dry river bed. The landing gear collapsed from overload during the landing. Examination of the engine revealed a connecting dowel for a drive gear driven by the crankshaft…Jun 29, 1982 · N2947N · Substantial damageNTSB DEN82DA121Accident · No injuriesFinal reportAyres S-2C · Greeley, COAfter takeoff the plt noticed the oil temp was increasing & the eng began losing power at about 100 ft AGL. He was unable to gain any additional altitude. He continued flying for another 15 minutes when the eng failed completely. The eng teardown & inspection…Jun 29, 1982 · N1648S · Substantial damageNTSB ATL82DA180Accident · No injuriesFinal reportCessna 185 · Scooba, MSThe aircraft was climbing to cruise altitude of 8500 feet. The engine began to lose power, then quit entirely. The pilot called the accompaning aircraft and made an emergency landing in a plowed field. The aircraft nosed over during landing. Examination…Jun 29, 1982 · N93DM · Substantial damageNTSB FTW82FPA14Accident · Minor injuriesFinal reportMooney M20E · Paris, TXAbout 20 min after takeoff, the pilot noticed oil on the left side glass and windshield while cruising at 7000 ft. he then checked oil pressure and it was near zero. He shut down the engine, and during a forced landing, the aircraft was substantially damaged.…Jun 28, 1982 · N79831 · Substantial damageNTSB FTW82DA252Accident · No injuriesFinal reportBeech 35 · Graham, TXWhile descending through about 2800 ft AGL to land, the engine lost power. The pilot was unable to restart the engine and elected to land in an OAT field with oats about 2 to 3 ft high. The pilot reported that during the landing roll, the nose gear collapsed…Jun 28, 1982 · N2880V · Substantial damageNTSB NYC82DA173Accident · Minor injuriesFinal reportCessna 150L · Shapleigh, METhe pilot departed on a cross-country flight from jackman, ME to rochester, NH and return. Prior to takeoff, the fuel tanks were topped off. During the preflight, the left fuel gauge was found to be "pinned" at the full position and was inoperative. After…Jun 27, 1982 · N11457 · Substantial damageNTSB LAX82FVM15Accident · Minor injuriesFinal reportCessna 150 · Point Lobos, CAThe pilot reported that his standard procedure was to keep the fuel tanks topped off. However, the refueling facility was closed after he returned from the previous flight. While calculating fuel for this flight, he forgot to account for the fuel that had…Jun 27, 1982 · N45477 · Substantial damageNTSB LAX82FA236Accident · 3 fatalField investigationFinal reportCessna 182 · Trinity Center, CAThe plt contacted the redding, CA tower & stated he was on top & 41 mi from the redding VOR. He then reported he was going into the clouds & requested radar service. He then contacted oakland ARTCC who provided assistance until the plt stated he had found a…Jun 27, 1982 · N759NE · DestroyedNTSB DCA82AA027Accident · 1 fatalFinal reportPterodactyl Ascender · Near Largo, MDWhile preparing for a flight to film a segment for a tv program about ultralights,the pilot completed a series of taxi tests & climbs to about 50FT AGL followed by an immediate landing. He had been previously instructed to use no more THAN3/4 power & never…Jun 27, 1982 · NONE · DestroyedNTSB FTW82DA250Accident · No injuriesFinal reportBeech D18S · Belen, NMThe pilot stated that during flight, the left engine began leaking oil and the cockpit filled with smoke. He shut down the left engine, but stated that the propeller would not completely feather due to the loss of oil. While approaching to land at a nearby…Jun 26, 1982 · N3962 · Substantial damageNTSB SEA82DA095Accident · No injuriesFinal reportCessna U206 · Juneau, AKThe float equipped aircraft crashed into trees after taking off from samonn creek reservoir while departing with overnight campers. The reservoir was located in a steep walled canyon. The pilot reported that he took off heading north into the canyon, raised…Jun 24, 1982 · N8320Q · Substantial damageNTSB LAX82DA233Accident · No injuriesFinal reportAeronca 7AC · Porterville, CAThe student pilot was on a local flight with two passengers. He reported that he was flying at about 600 ft AGL with 2100 RPM when he throttled back to 1500 RPM for about 10 seconds. He stated that when he advanced the throttle back to cruise power, the…Jun 24, 1982 · N1938E · Substantial damageNTSB FTW82DA289Accident · No injuriesFinal reportPiper PA-28-160 · Quinlan, TXWhile the pilot was inspecting a power line, the aircraft struck a feeder line that was located perpendicular to the line being checked. The line snapped, but the plane contacted the ground and sheared off the right gear. The aircraft became airborne again.…Jun 24, 1982 · N5514W · Substantial damageNTSB NYC82FNA17Accident · No injuriesFinal reportS.N.I.A.S. SA-330J · Hyannis, MAThe pilot reported that he took off, and during a climb through about 800 ft, he heard a loud snap and immediately felt severe lateral vibrations. He declared an emergency and landed without further incident. An investigation revealed that the inboard…Jun 23, 1982 · N3601U · Substantial damageNTSB MKC82FA110Accident · Serious injuriesField investigationFinal reportBellanca 17-30 · Columbia, MOThe plt stated he did not refuel or visually verify fuel quantity prior to departing Kansas city. The flt to st. louis was on the left tank. As the acft approached the Columbia, MO VOR at an altitude of 3000 ft MSL the eng failed. The pilot stated he…Jun 23, 1982 · N6656V · Substantial damageNTSB MIA82DA140Accident · Minor injuriesFinal reportPiper PA-38-112 · Deerfield Field, FLThe engine lost power during cruise flight. The pilot made a forced landing on a beach and collided with rocks and nosed over. The fuel bowl was found loose which lowered the fuel pressure.Jun 23, 1982 · N2434K · DestroyedNTSB ANC82FAA05Accident · No injuriesFinal reportCessna 185 · Fairbanks, AKThe acft departed emmonak at 0157 adt. While approaching Fairbanks the engine quit & the acft nosed over during an emergency landing on a mudflat. No useable fuel was found in the fuel tanks & the fuel lines were empty.Jun 23, 1982 · N2635S · Substantial damageNTSB NYC82FNA16Accident · 1 fatalFinal reportDavis DA-2A · Lincoln, RIThe pilot was on a local pleasure flight to see that the aircraft was functioning properly after a routine inspection. Just prior to the accident, witnesses heard the engine sputter, then become quiet. The plane was observed to continue straight ahead for…Jun 22, 1982 · N2281Z · DestroyedNTSB LAX82FUG13Accident · Serious injuriesFinal reportBeech 95-C55 · Ontario, CAWhile descending near banning, CA, the pilot lowered the gear after becoming aware of a popped circuit breaker. At the destination, there was an overcast with the tops at 4500 ft, so he diverted toward burbank, CA with the gear down. The overcast extended…Jun 22, 1982 · N707JF · DestroyedNTSB FTW82DA239Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe pilot had just finished spraying and was on his way back to the airport when the engine failed. A field with grass was selected for an emergency landing. During the landing roll, the aircraft encountered ruts and nosed over. The operator reported that the…Jun 22, 1982 · N9684 · Substantial damageNTSB ATL82DA175Accident · No injuriesFinal reportCessna 150M · Christiansburg, VAAfter flying from blacksburg, VA to monroe, NC. The pilot took off on a return flight to blacksburg without refueling. The pilot stated that before takeoff, he took the fuel tank caps off to visually check the fuel. However, he did not use the dip stick that…Jun 22, 1982 · N704LX · Substantial damageNTSB ATL82DA174Accident · No injuriesFinal reportCessna R182 · Abbeville, SCDuring flight, the pilot encountered adverse weather conditions and elected to make a precautionary landing at a nearby airport. He reported that he landed about 700 ft from the approach end of the runway at 70 knots, hydroplaned, and continued off the…Jun 22, 1982 · N5104S · Substantial damageNTSB MIA82DA139Accident · No injuriesFinal reportCessna 310 · Near Horseshoe, FLThe pilot reported that during an over water flight, he noticed the right engine fuel flow was fluctuating while the engine was cutting in and out. This was followed by intense white smoke which was observed coming out of the louvers on top of the engine…Jun 21, 1982 · N5193C · DestroyedNTSB MIA82DA138Accident · No injuriesFinal reportBrantly B-2B · Ruskin, FLThe plt experienced heavy vibration followed by loss of control of the acft. Witnesses described the acft in abrupt changes in attitude. Exam of the pitch link assemblies revealed failure under static overload conditions. A third pitch link assembly was not…Jun 21, 1982 · N2282U · DestroyedNTSB LAX82FA226Accident · Serious injuriesField investigationFinal reportCessna 172 · Granada Hills, CAThe student pilot departed van nuys, CA at about 1530 PDT on a round-robin, cross-country flight to turlock, CA. It was a combination personal and training flight. His instructor pilot (CFI) had verbally approved the flight, but did not endorse the student's…Jun 21, 1982 · N738GF · DestroyedNTSB NYC82FHM07Accident · Serious injuriesFinal reportPiper PA-18-150 · Sandy Hook Beac, NJThe pilot reported that while he was towing a banner, the engine RPM began to decrease. He initiated emergency procedures, but could not restore the power. The plane was maneuvered for a forced landing on a beach. The plane crashed on the beach while the…Jun 20, 1982 · N6879B · Substantial damageNTSB CHI82DA221Accident · Serious injuriesFinal reportPeter Clark Super Acro CUB · Delaware, OHAfter completing several aerobatic flights, the pilot proceeded to another airport to obtain fuel. While en route, the engine lost all power and would not restart. Subsequently, the aircraft was damaged during a forced landing in a soybean field. An…Jun 20, 1982 · N222PC · Substantial damageNTSB ATL82DA169Accident · Minor injuriesFinal reportCessna 182B · Tuscaloosa, ALThe pilot had flown from eutaw to seale, AL to participate in a parachute activity. Although the plane was equipped for parachuting, it was not used for that purpose on that trip. Before returning to eutaw, the pilot used a dipstick to check the fuel and…Jun 20, 1982 · N2519G · Substantial damageNTSB FTW82DA228Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKThe aircraft lost power during climb at 1300 feet. The engine would not restart. The pilot made a forced landing in the Arkansas river. No preimpact malfunction or failure of the aircraft's engine could be found.Jun 17, 1982 · N49482 · DestroyedNTSB ANC82DA049Accident · No injuriesFinal reportPiper PA-32-300 · Near Ekwok, AKThe pilot made a forced landing when power would not develop more than 1500 rmp. Takeoff and climb had been normal up to 1000 feet when the engine began to lose power. Since not enough power was available to continue flight a landing was made in the tundra.…Jun 17, 1982 · N9561K · Substantial damageNTSB MKC82DA104Accident · No injuriesFinal reportCessna 152 · 10 Sw Falls Cit, NEThe pilot stated that he took off to take photographs in nemaha county, KS. While enroute, he shot 6 rolls of film and then continued toward falls city, NE. He reported that about 7 miles from the airport, he ran out of fuel and landed in a wheat field. After…Jun 16, 1982 · N49974 · Substantial damageNTSB FTW82DA227Accident · No injuriesFinal reportBoeing 75A · Picher, OKThe pilot had just completed spraying a field and was climbing to return to his home airstrip when the engine failed. He landed in a nearby pasture but was unable to stop on the wet terrain before hitting a low fence. The main gear caught on the fence and the…Jun 16, 1982 · N450LR · Substantial damageNTSB ANC82IA048Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-6-100 · Near Port Heide, AKWhile in cruise flight, the left engine surged twice and the pilot observed fire emitting from the exhaust and cowling. After securing the engine and discharging the fire bottle without effect, the pilot made a precautionary landing at Port heiden airport.…Jun 16, 1982 · N525N · Minor damageNTSB FTW82FA223Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Hartshorne, OKWhile on a cross-country flight, the pilot was advised by radio of a severe thunderstorm and tornado watch along his route. At 1613 CDT, he was advised of a line of radar returns about 10 miles ahead. He replied that it "looks like a soft spot through there,…Jun 15, 1982 · N8442T · DestroyedNTSB ATL82FA164Accident · Serious injuriesField investigationFinal reportCessna 172P · Asheville, NCThe flt reportedly involved mountain flying techniques. The student observed that the acft was not climbing normally & the CFI suggested they slow to 70K. The student started a turn toward a wide valley but the CFI urged him to continue toward the mtns which…Jun 15, 1982 · N6545K · DestroyedNTSB ATL82DA165Accident · Minor injuriesFinal reportBeech A36 · Myrtle Beach, SCAs the pilot approached his destination, he descended from 9000 ft MSL and leveled at 1600 ft MSL. At about the time he leveled, the engine quit abruptly. He stated that he switched the fuel selector to the right tank and tried to start the engine, but was…Jun 15, 1982 · N1691W · DestroyedNTSB SEA83FA196Accident · 1 fatalField investigationFinal reportMooney M-20 · Sandy, ORThe acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating…Jun 14, 1982 · N231AW · DestroyedNTSB SEA82DA088Accident · No injuriesFinal reportPiper PA-38-112 · Oakley, IDAt about 1045 MDT, the pilot departed ogden, ut on a solo, cross-country flight to jackpot, NV, pocatello, ID and return. While en route to jackpot, he encountered turbulence and decreasing visibility over a mountainous area and descended from 8500 ft MSL to…Jun 14, 1982 · N91319 · Substantial damageNTSB LAX82FA231Accident · 2 fatalField investigationFinal reportCessna 182 · Truckee, CAAt aprx 2015 PDT on 6/13/82, the acft departed petaluma, CA on a ngt, VFR, x-country flt to riverton, WY. An en route stop was planned for elco, NV. No records were fnd of a wx briefing or flt plan. The acft was declared overdue on 6/16/82 & the wreckage was…Jun 14, 1982 · N42488 · DestroyedNTSB SEA82DA087Accident · No injuriesFinal reportCessna 206 · Renton, WAAccording to the pilot, the aircraft was on its first flight after a major engine overhaul and was being flown for maintenance evaluation. About 45 minutes after takeoff, the pilot requested a descent from 7500 feet MSL. After entering an overcast, the engine…Jun 13, 1982 · N60092