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 DEN82FTC08Accident · Minor injuriesFinal reportCessna T210N · Near Laramie, WYThe pilot reported that on a previous flight, he had an engine problem, in which, he was unable to obtain more than 27 to 28 inches of manifold pressure. He had the engine checked, no problem was found that would have caused the loss of manifold pressure, and…Aug 5, 1982 · N5433A · Substantial damageNTSB CHI82DA295Accident · No injuriesFinal reportBoeing Stearman A75-300N1 · Whitehall, WIThe pilot received a weather briefing before takeoff, and reportedly, was advised that VFR flight was not recommended. During the flight, the ceiling and visibility began to decrease. The pilot decided to make a precautionary landing in a field. He stated…Aug 5, 1982 · N802RB · Substantial damageNTSB CHI82DA294Accident · No injuriesFinal reportBreezy RLU1 · Milwaukee, WIThe pilot stated that he got a weather briefing before departing oshkosh, WI. While en route, he encountered fog and rain. The pilot attempted to continue to find timmerman or rainbow airport. The engine lost power due to fuel exhaustion. While landing on a…Aug 5, 1982 · N59Y · Substantial damageNTSB ANC82IA067Incident · No injuriesIncident investigationFinal reportPiper J-3 · Near Big Lake, AKDuring cruise flight, the aircrafts engine lost power and began vibrating severly. After the pilot tried unsuccessfully to remedy the problem, he executed an emergency landing in a marsh. Shortly after touchdown the aircraft bogged down and nosed over. A…Aug 5, 1982 · N70604 · Minor damageNTSB LAX82FVD20Accident · No injuriesFinal reportCessna 210 · Livermore, CAApproximately 4 to 5 minutes after takeoff the eng failed. The acft struck a fence while attempting to return to the airport. The right fuel tank gauge indicated 30 gals & the right tank was found empty. The left fuel tank gauge indicated 10 gals & it…Aug 4, 1982 · N6976N · Substantial damageNTSB FTW82DA314Accident · No injuriesFinal reportPiper PA-18-150 · Newellton, LADuring flight, the engine lost power and the pilot made a forced landing in a plowed field. While landing on the soft terrain, the aircraft flipped over. The pilot reported that the engine had failed due to fuel starvation when one fuel tank ran dry while the…Aug 4, 1982 · N2375J · Substantial damageNTSB ANC82DAG40Accident · Minor injuriesFinal reportAeronca 7GC · Tyonek, AKThe plt stated he departed anchorage for the kustatan river. He encountered ground fog enroute & landed on a beach. About 1-1/2 hrs later the fog cleared & he took off. He again encountered fog at the mcarther river, but it looked clearon the other side.…Aug 4, 1982 · N8933R · Substantial damageNTSB NYC82FNC10Accident · No injuriesFinal reportPiper PA-24-180 · Woodstock, VTApproximately 5 min after departure the eng lost most of its oil pressure & started to lose power. The acft landed on a rough plowed field & the gear were torn off. The aluminum oil line that connects to the oil cooler broke off at the flare. The "b" nut was…Aug 3, 1982 · N7502P · Substantial damageNTSB ANC82DA064Accident · Serious injuriesFinal reportCessna 207 · Near Kenai, AKSeveral black bears were spotted in a narrow canyon and the pilot began making tight, descending turns so his sightseeing passengers could get photographs. Reportedly, the stall warning horn came on, but the pilot continued the turns. He finally rolled out of…Aug 3, 1982 · N1751U · Substantial damageNTSB NYC82FNC13Accident · 1 fatalFinal reportPiper PA-28-140 · Beans Purchase, NHThe acft impacted an obscured mountain. An observation log & a pilot-certificated witness confirmed that IFR conditions existed at the time of the accident.Aug 2, 1982 · N5566F · DestroyedNTSB NYC82DA180Accident · No injuriesFinal reportPiper PA-12 · Long Branch, NJEven though he had performed several banner pick-ups during the afternoon the pilot did no refueling. After 4 hours of towing banners the engine quit. The pilot stated the gauges read 1/3 full of fuel. The pilot ditched the aircraft which sank and has not…Aug 2, 1982 · N2705M · DestroyedNTSB LAX82FA287Accident · Minor injuriesField investigationFinal reportCessna 150M · Los Angeles, CAThe flight was doing traffic reporting when the engine failed. The pilot selected a place for a forced landing. During the landing, the aircraft bounced out of this lot, went over some buildings, then touched down into an athletic field. During a short…Aug 2, 1982 · N63572 · Substantial damageNTSB FTW82DA310Accident · No injuriesFinal reportCessna 182P · Abbeville, LAThe pilot was on a cross-country ferry flight when the engine lost power. A forced landing was made in a field of tall rice. The pilot stated that during the landing, the aircraft struck a rice levee and nosed over. The source of engine failure was not…Aug 2, 1982 · N5787J · Substantial damageNTSB ATL82DLQ08Accident · Serious injuriesFinal reportBell 206B · 2nm Sw Of Lynch, KYThe pilot was on a flight to spray powerline right-of-ways with defoliant. During climb, near a 3500 foot ridgeline, the aircraft began to spin to the right. The pilot took corrective action but was not able to stop the spin. The pilot did not have sufficient…Aug 2, 1982 · N33TA · DestroyedNTSB ATL82DA227Accident · No injuriesFinal reportHiller UH12D · Dothan, ALThe pilot calculated his fuel for the flight and determined it adequate for the flight. He drained the fuel sump while the crew was loading fungicide at the loading area. After the spraying was completed, the pilot started his return flight and when over a…Aug 2, 1982 · N79SW · Substantial damageNTSB ATL82DA223Accident · No injuriesFinal reportAero Commander 680FL · Alabaster, ALPrior to the post-maintenance inspection flight the pilot/owner, who is a certificated A&P mechancic, had been calibrating the fuel flow on the right eng fuel injector pump. An external line had been connected to the fuel flow transmitter fitting of the fuel…Aug 2, 1982 · N11GT · DestroyedNTSB NYC82FA176Accident · 1 fatalField investigationFinal reportCessna 150L · West Brattlebor, VTAt 2036 the plt contacted bradley approach control (a/c) on freq 121.5 & stated he was lost, at an altitude of 4,000 ft & in "almost IFR weather." Since the acft was not transponder equipped a/c had the plt use VOR orientation procedures to determine his…Aug 1, 1982 · N17135 · DestroyedNTSB NYC82DA178Accident · No injuriesFinal reportPiper PA-28-181 · Dubois, PAAfter power interruption during cruise the pilot returned to the airport for landing. Turning base leg the engine ouit. The pilot cut short the base leg and landed on the grass beside runway 25. No reasons for engine malfunction was found.Aug 1, 1982 · N2852E · Substantial damageNTSB FTW82DA304Accident · No injuriesFinal reportCessna 421B · Cotulla, TXWhile on a cross-country business flight the left engine started running rough. The pilot shut down the engine and diverted to Cotulla, TX, where he made a single engine approach and landing. The pilot landed with a 20 kt tail wind, was unable to stop the…Aug 1, 1982 · N832BW · Substantial damageNTSB SEA82DA135Accident · No injuriesFinal reportMooney M20F · Sandy, ORAfter the engine was overhauled, the pilot and a mechanic took off on a test flight. During the takeoff climb the engine lost power and when force landed on soft terrain, the nose and right main landing gear collapsed. An examination revealed that the left…Jul 31, 1982 · N9707M · Substantial damageNTSB NYC82DNC12Accident · No injuriesFinal reportBoeing PT-17 · Hamlin, METhe pilot departed a private strip with 150 gallons of water mixed with fungicide and insecticide. After takeoff, he turned and began climbing over rising terrain. The terrain sloped upward from a river, rising about 400 ft. the pilot reported that he failed…Jul 31, 1982 · N1344M · Substantial damageNTSB LAX82DA284Accident · No injuriesFinal reportPiper PA-28R · San Pedro, CAPilot was flying near catalina island and when he switched tanks the engine quit. Procedures to restart did not work so aircraft was ditched.Jul 31, 1982 · N3935T · DestroyedNTSB ANC82DAA10Accident · No injuriesFinal reportCessna 180A · Manley Hot Spri, AKThe pilot reported that the weather at the departure point was 1500 ft broken, visibility 20 miles wind from the southwest at 5 to 10 KTS. After taking off in a float plane, he elected to follow a slough. After turning a corner about 1 1/2 miles from the…Jul 31, 1982 · N9749B · Substantial damageNTSB NYC82DA174Accident · No injuriesFinal reportCessna 150M · Watertown, NYWhile en route on a night flight, the engine lost power. During a forced landing, the aircraft struck a power line while on final approach. The power line failed and the pilot continued the landing, but the propeller, spinner, nose cowling, lift strut, and…Jul 30, 1982 · N9169U · Substantial damageNTSB DEN82DA139Accident · No injuriesFinal reportSikorsky S-55B · Wahpeton, NDAfter receiving his last load of chemical, the pilot thought he had enough fuel to complete two spray passes to finish the field before proceeding to the fuel truck. He completed the passes, then pulled to about 150 ft AGL to fly about three miles to refuel.…Jul 30, 1982 · N6704 · Substantial damageNTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…Jul 30, 1982 · N25814 · Substantial damageNTSB LAX82FA282Accident · 1 fatalField investigationFinal reportCessna 177 · 11mi.Sw Of Silv, NVAt 0237 the plt contacted ARTCC & verified that he was VFR at 9,500 ft MSL enroute to reno. At 0238 he located his position as 10 mi south of lidat intersection & was advised that oakland enroute radar was out of service. Lidat is on V105 between the beatty &…Jul 29, 1982 · N13310 · DestroyedNTSB DEN82FA148Accident · 1 fatalField investigationFinal reportEnstrom F-280 · Medora, NDDuring flt the plt noticed that eng RPM was about 500 over rotor RPM. The acft crashed during an unsuccessful autorotation. The overrunning clutch linkage & clutch was found in the disengaed position. A successful autorotation requires that the collective…Jul 29, 1982 · N4202S · Substantial damageNTSB CHI82DA280Accident · Minor injuriesFinal reportSIAI Marchetti S.205-22/R · Carrollton, ILThe aircraft engine failed inflight and during the forced landing on a road the aircraft collided with posts. An investigation showed that a #4 connecting rodcap attaching bolt had failed.Jul 29, 1982 · N956W · Substantial damageNTSB ATL82DA221Accident · No injuriesFinal reportGrumman G-164 · Donalsonville, GAWhile en route back to the airport, the engine lost power and the pilot landed in a rain soaked, soybean field. During the landing roll, the wheels bogged down in soft earth and the plane nosed over. According to the pilot, there was 10 to 12 gallons of fuel…Jul 29, 1982 · N10286 · Substantial damageNTSB ANC82DAG54Accident · No injuriesFinal reportCessna 185F · Mcgrath, AKThe pilot departed Mcgrath, AK at 2200 adt on a flight to bear creek, AK. He reported that the weather became rainy and hazy, and he could not land at bear creek due to the deteriorating weather. He started to divert back to Mcgrath, but low clouds prevented…Jul 29, 1982 · N1453Q · Substantial damageNTSB MIA82DA161Accident · No injuriesFinal reportCessna R182 · Plymouth, FLThe pilot had a flight of over 4 hours total with one enroute stop. At this stop the pilot did not refuel. After 2 hoursand 9 minutes of return flight the eng lost power & the plt made a wheels up landing on a highway.Jul 28, 1982 · N2334C · Substantial damageNTSB DEN82FTM16Accident · 2 fatalFinal reportVarieze · Milcreek Canyon, UTThe aircraft crashed into trees in a Canyon at an elevation of 9300 MSL. The weather was reported as marginal VFR. No flight plan was filed. VFR flight was not recommended. A toxicological check of the pilot's blood showed an alcohol level of 91 mg%; however,…Jul 28, 1982 · N104P · DestroyedNTSB ATL82DA217Accident · Minor injuriesFinal reportCessna 172 · Laurinburg, NCThe weather briefing forecast thunderstorms however the pilot took off on a cross country and circumnavigated two cells. The air became turbulent so the pilot decided to land in a plowed field. A downdraft caught the plane and it landed nosedown and nosed…Jul 28, 1982 · N733JU · Substantial damageNTSB MKC83LA055Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Pawnee City, NEThe owner of the aircraft was flying with the CFI for a biennial flight review. Shortly after takeoff, at approximately 700 feet, the engine quit. The owner selected what he thought was the best field and began the forced landing. The CFI took over the…Jul 26, 1982 · N31094 · Substantial damageNTSB FTW82DA294Accident · Minor injuriesFinal reportVarga 2150A · Oklahoma City, OKThe student reported that before he began his flight, he visually checked both tanks and estimated that he had two hours of fuel remaining. He flew 1.1 hrs and was on his way home when the engine lost power. While landing in a plowed field, the plane flipped…Jul 26, 1982 · N8265J · Substantial damageNTSB CHI82DA275Accident · Minor injuriesFinal reportErcoupe 415C · Port Sheldon Tw, MIDuring a VFR flight along lake Michigan shoreline the pilot encountered a decrease in ceiling height. The pilot chose to make a 180 degrees maneuver and return to the airport but during the turn encountered a fog bank. The pilot decended to avoid the fog bank…Jul 26, 1982 · N3247H · DestroyedNTSB SEA82DA130Accident · Minor injuriesFinal reportCessna 175 · Sunnyside, WAWhen the pilot arrived on a flight from Sunnyside to the clark county airport, all fuel facilities were closed. He estimated that he had enough fuel to return and took off without refueling. About 12 miles from the Sunnyside airport, fuel exhaustion occurred.…Jul 25, 1982 · N7694M · Substantial damageNTSB DEN82DA146Accident · Minor injuriesFinal reportPiper PA-23C-250 · Gunnison, CODuring takeoff, the pilot was distracted by inbound traffic and delayed retracting his gear. At the same time, the engines were not synchronized and he was having difficulty getting them to sound good. He then noticed that a fire had started in the vicinity…Jul 25, 1982 · N6383Y · Substantial damageNTSB SEA82FA129Accident · 4 fatalField investigationFinal reportCessna A185F · 11nm East Of Si, AKAfter departing sitka the acft proceeded generally east via blue lake, blue lake pass & the "cut", a ridge oriented ne/sw with an elevation of approximately 3000 ft MSL. The impact site was about 1 NM se of the cut on the north face of the valley. Both stall…Jul 24, 1982 · N9682Q · DestroyedNTSB MKC82DA131Accident · No injuriesFinal reportCessna 152II · Near Wright Cit, MOThe student pilot was on a solo cross country and landed at an intermediate stop and refueled with 6 gallons of fuel. During the return flight the aircraft's engine quit. During the forced landing the aircraft collided with trees. Post accident examination of…Jul 24, 1982 · N49789 · Substantial damageNTSB LAX82FA275Accident · 2 fatalField investigationFinal reportPiper PA-601P · South Of Wicken, AZAt about 1005 MST the plt received a wx briefing for a flt to Florida with an overnight stay in Texas. Thunderstorm activity was forecast along the proposed route of flt. The briefer advised the plt to get an updated briefing before departure because of the…Jul 24, 1982 · N3642T · DestroyedNTSB FTW82DA305Accident · No injuriesFinal reportAlon A2 · Poyen, ARAs the pilot approached his destination, malverne, AR, he descended into hazy conditions under a cloud layer. As he continued, he mistook Poyen, AR for malverne. He was unable to find the airport and elected to make a precautionary landing before dark. He…Jul 24, 1982 · N5637F · Substantial damageNTSB SEA82AA126Accident · 6 fatalFinal reportCessna 172 · Mercer Island, WAN2428E, a C-172, had departed sea-tac arpt for a VFR flt to snohomish, WA, about 27 mi on the 355 deg radial from the sea-tac VORTAC. It proceeded nnw over the west shore of Mercer Island located approximately 10 mi north of the sea-tac arpt. N761EL, a…Jul 23, 1982 · N2428E · 2 aircraft · DestroyedNTSB DEN82FTE20Accident · No injuriesFinal reportSteen Skybolt · Glenwood Spring, COThe aircraft crashed into trees in mountainous terrain about 10 miles southwest of the Glenwood springs county airport. This occurred while the pilot was flying low over the mountainous area and was unable to outclimb the rising terrain. The density altitude…Jul 23, 1982 · N58D · DestroyedNTSB ATL82DA209Accident · No injuriesFinal reportCessna T188C · Moultrie, GAA catastrophic engine failure occurred at an altitude of about 500 ft AGL while the pilot was returning to the airport. The pilot elected to land on a highway. He reported that during the landing, he ran the plane off the road to avoid an oncoming car. An…Jul 23, 1982 · N2998J · Substantial damageNTSB LAX82FA273Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Tonopah, NVThe acft impacted the east slope of a ridge at 6500 ft MSL.Jul 22, 1982 · N8408X · DestroyedNTSB CHI82FA266Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Hartsburg, ILAt 1223 CDT the plt contacted peoria approach control & requested radar vectors to the Mt. Hawley arpt located just northof the peoria arpt. At 1227 CDT he stated the weather was getting bad & he would like to fly to the logan county arpt. One witness stated…Jul 22, 1982 · N7304W · DestroyedNTSB SEA82FA122Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · 10 Nm E. Of Ken, IDThe plt declared an emergency & reported out of fuel. While approaching a field the plt observed a power/telephone line in his flt path & instinctively pulled the nose up. On-scene examination revealed no evidence of fuel.Jul 21, 1982 · N33329 · DestroyedNTSB NYC82FGM14Accident · Serious injuriesFinal reportPiper PA-28-140 · Shanksville, PADuring preflight the plt estimated he had about 18 gals of fuel on board. Approximately 10 min after takeoff the eng quit due to fuel exhaustion. The acft collided with a power line pole during the forced landing. The arpt's FBO stated that fuel was not…Jul 21, 1982 · N1885T · Substantial damage