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 LAX82FA134Accident · 3 fatalField investigationFinal reportCessna 182M · Lake Hughes, CAThe pilot requested the en route weather conditions at 1545, 1625, 1732 and 2150 PST from the bakersfield fss. The pilot was informed, on each occasion, that VFR flight was not recommended; however, at 2213 the pilot departed bakersfield. No flight plan was…Apr 11, 1982 · N70939 · DestroyedNTSB ANC82FA036Accident · 3 fatalField investigationFinal reportHughes 369D · Near Tanana, AKThe aircraft crashed on a snow covered mountain slope while in a steep left bank/nose low turn. The 1754 ast weather at Tanana, AK (19 NM sse) was, in part: 1800 ft broken, 3500 ft overcast, visibility 7 mi with light snow, wind 320 deg at 18 KTS. Flight…Apr 11, 1982 · N11058 · DestroyedNTSB LAX82DA132Accident · No injuriesFinal reportCessna 150 · Tuscon, AZThe pilot stated that he filled the fuel tanks with 22 gallons of fuel. Three hours and 15 minutes after takeoff, he ran out of fuel. He made a forced landing about 1.5 miles from the intended destination and encountered desert shrubbery.Apr 10, 1982 · N6497S · Substantial damageNTSB SEA82DA049Accident · No injuriesFinal reportPiper PA-28-181 · Spokane, WAStudent pilot/copilot reset the aircraft clock in anticipation of the time zone change that would occur in flight. This caused the pilot to think he had another hour of flight time. In addition the fuel gage was found to show fuel in the right tank when all…Apr 9, 1982 · N80769 · Substantial damageNTSB SEA82DA048Accident · No injuriesFinal reportPiper PA-25-235 · Basin City, WADuring a return trip to the landing area from a dusting run the engine stopped. The main landing gear caught wires during an attempted landing to a field and the aircraft turned over before colliding with the ground. The fuel tanks were found empty and the…Apr 9, 1982 · N9546P · Substantial damageNTSB FTW82DA124Accident · No injuriesFinal reportCessna 152 · Lafayette, LAEn route to Lafayette, LA on a cross country the engine quit. A forced landing in a soft plowed field caused the landing gear to separate and the aircraft to nose over.Apr 9, 1982 · N5361M · Substantial damageNTSB FTW82DA119Accident · Minor injuriesFinal reportCessna 150 · Santa Fe, NMOne blade of the propeller failed in cruise. Power was reduced due to vibration and a forced landing was made. During the hard landing on upslope rangeland the landing gear failed.Apr 9, 1982 · N5870E · Substantial damageNTSB FTW82DA117Accident · No injuriesFinal reportBeech C-18S · Hereford, TXThe pilot experienced total electrical failure during flight. Before landing he allowed the gear to free fall and attempted to crank it into the fully extended and locked position. When the crank would not turn he assumed the gear was in the locked down…Apr 9, 1982 · N64463 · Substantial damageNTSB ANC82DA033Accident · Minor injuriesFinal reportCessna 206 · Near Nightmute, AKThe pilot stated that during flight the aircraft inadvertently drifted north of his intended flight path into an area of higher terrain. When the aircraft encountered a whiteout condition the pilot elected to turn to the right toward what he observed as…Apr 9, 1982 · N9938M · Substantial damageNTSB ATL82DA097Accident · No injuriesFinal reportCessna 172 · Brook Haven, MSThe pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot…Apr 8, 1982 · N6444B · Substantial damageNTSB DEN82FA056Accident · 3 fatalField investigationFinal reportCessna 320F · Missoula, MTDuring arrival for an ILS-2 approach to runway 11, the pilot was advised to hold at the kona NDB while snowplows finished clearing the runway. At that time, the Missoula weather was 1200 ft obscured, 2 mi visibility with light snow and fog, temperature and…Apr 7, 1982 · N999LS · DestroyedNTSB SEA82FA046Accident · Serious injuriesField investigationFinal reportCessna 177RG · 10 East Of Till, ORDuring flight at 13,000 ft MSL, the engine began losing power. The aircraft was vectored toward the prospect airport near tiller, Oregon. However, about two minutes later, all engine power was lost. During a forced landing, the aircraft struck a dead…Apr 6, 1982 · N2114Q · Substantial damageNTSB NYC82FGM10Accident · 2 fatalFinal reportBeech E55 · Scandia, PAAt 0834 EST, the pilot departed bradford airport on an IFR flight to alton, IL. About 4 minutes later, he advised that he was having difficulty with his flight instruments while in IFR conditions. He attempted to return to the departure airport by using d.f.…Apr 6, 1982 · N4375A · DestroyedNTSB DEN82FA057Accident · 2 fatalField investigationFinal reportMooney M20B · Near Salida, COAfter departing Salida at approximately 0820 the plt radioed over UNICOM that the clouds in the local area had bases of 12,500 ft MSL & tops at 16,500 ft MSL. About 15 min later the acft impacted a mountain at the 13,500 ft level. There were flt precautions…Apr 6, 1982 · N74734 · DestroyedNTSB ATL82DA095Accident · No injuriesFinal reportPiper PA-24-250 · Tazewell, VAThe pilot stated that the engine failed at 8000 ft in clear air and level flight. He immediately attempted to switch the fuel selector to one of the two remaining full fuel tanks but the selector would not move. After repeated attempts to switch tanks using a…Apr 6, 1982 · N7841P · Substantial damageNTSB ATL82FA092Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Baconton, GAAs the pilot was descending from 7000 to 5000 ft, he heard a loud bang, followed by a temporary vibration and a violent swerve to the right. He looked out the right window and thought the right engine had fallen off since all he could see was the tops of the…Apr 5, 1982 · N123CB · DestroyedNTSB MIA82DA093Accident · No injuriesFinal reportCessna 182 · Quincy, FLAfter completing the drop on a skydiving flight, the engine lost power during a power-off descent. The pilot reported that the carburetor heat was not used during the descent prior to the loss of power. However, the probability of weather conditions for…Apr 4, 1982 · N4049D · Substantial damageNTSB NYC82DA068Accident · No injuriesFinal reportCessna 150M · Washington, CTWhile practicing power on stalls and gliding turns the pilot stated that the engine would not respond with half throttle. A forced landing was made after passing up two rough fields for a more distant one at a higher altitude. The pilot stated he should have…Apr 3, 1982 · N7652U · Substantial damageNTSB MIA82IA110Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tallahassee, FLWhile cruising at 8000 feet, the right alternator light came on and the pilot accomplished the required procedures for an alternator failure. Shortly thereafter, he noticed an area of discoloration on the inboard nacelle of the right engine and saw flames…Apr 3, 1982 · N41045 · Minor damageNTSB MIA82DA127Accident · No injuriesFinal reportPiper PA-18 · Hollywood, FLThe pilot was towing a banner along a beach when the engine failed. He landed in the water just offshore and escaped without injury. The aircraft was subsequently destroyed by the surf. An examination of the engine revealed that the no. 3 cylinder had…Apr 3, 1982 · N294T · DestroyedNTSB LAX82DA125Accident · No injuriesFinal reportCessna 150 · Death Valley, CAThe pilot reported that during a cross-country flight, the engine began running rough and decreasing thrust resulted in a forced landing. While landing on a soft, dry lake bed, the plane crossed a small wash where the nose gear collapsed and the aircraft…Apr 3, 1982 · N5682E · Substantial damageNTSB FTW82DQG17Accident · Serious injuriesFinal reportBalloon Works 7-B · Masterson, TXAfter making weather observations and obtaining a weather briefing, the instructor pilot (ip) briefed the chase crew of the expected northerly track. The ip and student took off at 0705 CST and ascended to 1200 to 15000 ft AGL and began tracking…Apr 3, 1982 · N1524U · Minor damageNTSB ATL82FKG10Accident · 2 fatalFinal reportBeech A36 · Darien, GAThe pilot filed a VFR flight plan, but did not activate it after takeoff. While en route, he encountered deteriorating weather and obtained an IFR clearance. As he continued, he entered an area of thunderstorms, turbulence, and heavy rain. As the pilot was…Apr 3, 1982 · N4382W · DestroyedNTSB SEA82DA044Accident · No injuriesFinal reportHiller UH-12E · Near Toutle, WAAbout 1 1/2 minutes after takeoff, the pilot heard a loud "bang" which was followed by a vertical and lateral vibration. The helicopter began to descend, pitch forward, and roll right as the vibration increased. The pilot elected to make an autorotative…Apr 2, 1982 · N9060F · Substantial damageNTSB MIA82FKT09Accident · Minor injuriesFinal reportPiper PA-36 · Delray Beach, FLWhile climbing after takeoff, the pilot noted a partial loss of power. He thought he could smell smoke and turned the master and alternator switches off. The engine continued to lose power and the pilot dumped the load. He elected to land in a canal. As he…Apr 2, 1982 · N57750 · Substantial damageNTSB DEN82FA054Accident · 4 fatalField investigationFinal reportBeech M35 · Lamar, CODuring the wx briefing the plt was advised that the wx along his proposed route of flt would be generally good VFR with the exception of possible turbulence & that blowing dust would be the big problem. There were pireps of 65K winds at 3,000 ft over Oklahoma…Apr 2, 1982 · N9733R · DestroyedNTSB CHI82FA110Accident · Minor injuriesField investigationFinal reportCessna 210N · Wadsworth, OHWhile descending through about 4500 ft MSL, the pilot heard a rattling sound in the engine and noticed a loss of power. He declared an emergency and was provided vectors to the Wadsworth municipal airport. However, he was unable to reach the airfield. The…Apr 2, 1982 · N7599P · Substantial damageNTSB ATL82IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31P · Savannah, GADuring flight, electrical fumes, smoke and sparks began emitting from the circuit breaker panel immediately left of the pilot's seat. The pilot was forced to move to the right seat. He tried to suppress the sparks with a chemical fire extinguisher and tried…Apr 2, 1982 · N25MA · Minor damageNTSB LAX82DA126Accident · No injuriesFinal reportCessna 206-F · Winters, CAAfter takeoff as the aircraft climbed through 550 feet AGL the engine lost power. The pilot attempted to turn the aircraft around and land on a taxiway but landed in a soft area near it. The nose gear collapsed and the aircraft slid across the taxiway and…Apr 1, 1982 · N35919 · Substantial damageNTSB FTW82FA109Accident · 2 fatalField investigationFinal reportBeech B35 · Dulce, NMApproximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft…Mar 30, 1982 · N5237C · DestroyedNTSB DEN82DA052Accident · Minor injuriesFinal reportCessna 180K · Montrose, CODuring flight over mountainous terrain, the pilot encountered "horizontal snow squalls." He reported that he flew through the snow squall for about 25 miles while maintaining ground contact. He approached a cloud layer, but was able to fly over it at 16,500…Mar 30, 1982 · N2809K · DestroyedNTSB NYC82FNA12Accident · Serious injuriesFinal reportPiper PA-32R · Rochester, MAThe pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An…Mar 29, 1982 · N1104Q · Substantial damageNTSB MIA82FA088Accident · 2 fatalField investigationFinal reportMooney M2OJ · Ormond Beach, FLThe non-instrument rated pilot had filed for an IFR climb to vfr-on-top. He took off after receiving a clearance to the bulli intersection with instructions to maintain 9000 ft, if not vfr-on-top by that altitude. At 1720 EST, the pilot transmitted that he…Mar 29, 1982 · N1118R · DestroyedNTSB FTW82DA105Accident · No injuriesFinal reportPiper PA-28-180 · Norman, OKThe aircraft's engine quit 15 minutes short of the destination on a cross country flight. The aircraft had 36 gallons of fuel on departure at 1600 CST and the accident occurred at 1915. A forced landing was made on a street in Norman, Oklahoma.Mar 29, 1982 · N2153T · Substantial damageNTSB ATL82DA088Accident · No injuriesFinal reportPiper PA-24-250 · Macon, GAThe non-instrument rated pilot reported departing ft lauderdale, FL with 4 hrs of fuel on board on a 40 minute flight to okeechobee, FL. The next day, he departed okeechobee without refueling on a flight to Macon, GA. He reported that he had to climb to…Mar 29, 1982 · N9LT · Substantial damageNTSB FTW82DA104Accident · No injuriesFinal reportCessna T210N · Pampa, TXWhile en route, the pilot encountered icing conditions as he got near his destination and was unable to maintain altitude. Subsequently, he made an off airport landing and the plane was damaged.Mar 27, 1982 · N6220C · Substantial damageNTSB ATL82FA086Accident · 3 fatalField investigationFinal reportMooney M20F · Mchenry, MDAt 0635 the plt received a wx briefing which included forecasted icing conditions along his route of flt. At 1215 received an updated briefing & was informed that IMC existed along his route of flt & VFR flt was not recommended. At 1536 he called & received…Mar 27, 1982 · N6896V · DestroyedNTSB NYC82DA065Accident · No injuriesFinal reportPiper PA-28R-180 · Perry Warsaw, NYThe pilot elected to takeoff at night with low visibility, rain, and fog. Soon after takeoff visual ground contact was lost due to what the pilot stated as quickly lowering ceilings and visibility. The pilot then decided to make a precautionary landing in a…Mar 26, 1982 · N4909J · Substantial damageNTSB NYC82DA063Accident · No injuriesFinal reportCessna 152 · East Aurora, NYDuring a local flight in marginal weather conditions with light snow, there was a gradual loss of power. At first, the instructor thought the student had throttled back and told him to increase the power. When the instructor realized the problem, he took the…Mar 26, 1982 · N757HZ · Substantial damageNTSB FTW82FA103Accident · 6 fatalField investigationFinal reportBeech 58 · Magdalena, NMThe plt was advised of the icing conditions to be expected three different times during his wx briefing. At 1524 while enroute at 14,000 ft, the plt was advised of a PIREP of light to moderate icing between 14,O00 & 22,000 ft. the plt replied that was about…Mar 26, 1982 · N36969 · DestroyedNTSB MKC82FCJ02Accident · 1 fatalFinal reportPiper PA-28-140 · Davenport, NEAt 1242 CST, the pilot received a weather briefing including a forecast of marginal VFR conditions at the destination. Between 1649 and 1848 CST, there were three weather reports from the destination of ceilings between 300 and 500 ft, visibilities between…Mar 25, 1982 · N32329 · DestroyedNTSB MIA82DA085Accident · No injuriesFinal reportPiper PA-38-112 · Jasper, FLWhile on a cable inspection mission at 500 ft MSL, the engine began to lose power after the pilot had made an erratic maneuver to avoid birds. He initiated emergency procedures to restore power, but was unable. The nose gear failed and the aircraft flipped…Mar 25, 1982 · N2558C · Substantial damageNTSB CHI82DA101Accident · Minor injuriesFinal reportCessna 150 · West Chicago, ILThe student and an instructor had previously flown this aircraft to recertify the student for solo flight. After the dual flight, the student had some problem with obtaining fuel and took off without refueling. While flying at night, the student became lost.…Mar 25, 1982 · N9239U · Substantial damageNTSB MIA82DA084Accident · No injuriesFinal reportRockwell Commander AC-100 · Chipley, FLThe student pilot/mechanic was attempting to fly the aircraft from where the owner kept the aircraft to the maintainance facility approximately 4 miles away. The pilot stated that just after level off the engine quit. A road was selected to land on but at the…Mar 24, 1982 · N3870X · Substantial damageNTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…Mar 24, 1982 · N714KR · Substantial damageNTSB LAX82FA117Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Near Brideport, CAAfter taking off in a mountainous area, the pilot began climbing in up-currents on the side of a canyon. While following a ridge at about 100 ft AGL (11,000 ft MSL), he heard a loud noise that was followed by a shudder and vibrations. The helicopter began…Mar 22, 1982 · N9829C · DestroyedNTSB FTW82DA101Accident · No injuriesFinal reportSnow AT-301 · Spearman, TXWhen the aircraft lost power after spraying crops the pilot executed a forced landing in a field. During the landing the aircraft nosed over. Investigation revealed that an induction hose had failed and blocked the carburetor. A service letter relating to…Mar 22, 1982 · N2326S · Substantial damageNTSB NYC82FA060Accident · 2 fatalField investigationFinal reportCessna U206G · Stratford, NHBefore takeoff, the pilot received a partial weather briefing by telephone. He was advised of reported icing conditions and was told that snow and rain showers were moving through the area causing marginal VFR conditions. Before terminating the conversation,…Mar 21, 1982 · N734KJ · DestroyedNTSB LAX82DA114Accident · No injuriesFinal reportCessna 150 · Delano, CAThe student made a scheduled stop at lompoc, California, but was unable to obtain 80 octane fuel. He then flew to santa maria, California, which was not a part of his planned flight. He was also unable to get 80 octane fuel at santa maria. From there, he…Mar 21, 1982 · N63335 · DestroyedNTSB MKC82DA046Accident · No injuriesFinal reportEnstrom F-28A · Parsons, KSThe pilot was rated in fixed wing aircraft, but he was a student pilot in helicopters. He had only 40 hours in rotorcraft. During a cross-country in his own helicopter, he ran out of fuel and struck trees during an auto-rotative landing. The pilot stated that…Mar 20, 1982 · N101AE · Substantial damage