OpenAirDocs.org

NTSB investigations

35,885 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 MIA88LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe plt stated that he was enroute to sanford, FL when the engine lost power. He then landed on I-4, striking a van with the left wing and propeller. The operator stated that prior to removing the wings in order to transport the acft back to sanford, all the…Apr 16, 1988 · N714SW · Substantial damageNTSB LAX88FA162Accident · 2 fatalField investigationFinal reportCessna 210L · Maricopa, CAAircraft inadvertent flight into instrument meteorological conditions.Apr 16, 1988 · N29111 · DestroyedNTSB DEN88FA098Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Pintura, UTThe plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…Apr 16, 1988 · N2738R · Substantial damageNTSB DCA88MA052Accident · Serious injuriesMajor investigationFinal reportde Havilland DHC-8 · Seattle, WAShortly after tkof from Seattle-tacoma intl airport, the crew noted a rt eng power loss and decided to return for a precautionary lndg. After lowering the lndg gear, a massive fire was discovered in the rt eng nacelle. After lndg, directional control and all…Apr 16, 1988 · N819PH · DestroyedNTSB MIA88LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Monticello, FLThe plt stated that while enroute to st. petersburg, and in the vicinity of montecello FL, he began to experience severe engine vibrations and a loss of power. He then selected a field to land in & on his apch, the acft struck some trees, sheared off the…Apr 15, 1988 · N5231S · Substantial damageNTSB DEN88LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Garfield, COThe plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…Apr 14, 1988 · N714BK · Substantial damageNTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…Apr 14, 1988 · N3850M · DestroyedNTSB BFO88FA036Accident · Minor injuriesField investigationFinal reportFokker F28 MK 4000 · Charleston, WVEngine and airframe failure were caused by the the separation of the first stage low pressure turbine disk. The disc interstage seal was installed inadequately, resulting in rubbing between the seal and disk, causing failure of the disk. Inadequate procedure…Apr 14, 1988 · N110UR · Substantial damageNTSB ANC88IA047Incident · No injuriesIncident investigationFinal reportCessna 207A · Takslesuk Lake, AKThe scheduled commuter flight, friendship flight 305, was en route from chevak, Alaska to bethel, Alaska. During cruise flight, the airplane experienced an engine failure resulting a a forced landing on rough, snow covered terrain. The pilot-in-command stated…Apr 14, 1988 · N73188 · Minor damageNTSB LAX88LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Coarsegold, CAWhile at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.Apr 13, 1988 · N735SU · Substantial damageNTSB SEA88LA073Accident · No injuriesLimited investigationFinal reportHughes 269C · Sitka, AKDuring sling operations, the long line became separated and entangled in the tail rotor at about 300 feet AGL. The pilot landed the helicopter onto a beach area where it rolled over onto its left side striking the main rotor. No accident report has been filed…Apr 12, 1988 · N92PC · Substantial damageNTSB CHI88IA097Incident · Minor injuriesIncident investigationFinal reportFairchild SA-226-TC · Bloomington, ILPhysical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.Apr 11, 1988 · N332BA · No damageNTSB ATL88FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bowling Green, KYPilot called fss on wrong freq. Another pilot answered & pilot req fss freq. He then called fss, rpted eng quit. Witness heard 'eng starting' momentarily overhead, watched acft pitch over, dive to gnd & impact with no attempt to flare for lnding. Pitch trim…Apr 11, 1988 · N32911 · DestroyedNTSB SEA88LA071Accident · No injuriesLimited investigationFinal reportCessna 172XP · Walla Walla, WADuring descent for landing the pilot noted a surge coming from the engine area, accompanied by an increase in rpm's. both the oil temperature and the oil pressure gauges were reading zero. The cylinder head temperature had reached 500 degrees and smoke was…Apr 10, 1988 · N736KG · Substantial damageNTSB ATL88DKG06Accident · No injuriesFinal reportChristen Industries Eagle II · Chamblee, GAApr 10, 1988 · N722HS · DestroyedNTSB SEA88FA069Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Soda Springs, IDWhile en route on a night IFR cargo flt, the plt reqd & was clrd for a dscnt from an IFR cruise alt of 16,000 ft to proceed vfr-on-top. The last transmission from the acft was at 2106 when the plt acknowledged that he was familiar with the terrain along the…Apr 9, 1988 · N291NC · DestroyedNTSB NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.Apr 9, 1988 · N34JH · 2 aircraft · DestroyedNTSB FTW88DRA06Accident · 1 fatalFinal reportNeff BD-4 · Beaumont, TXDuring the flight, an oil-like odor was detected and oil spots appeared on the windshield. The oil pressure dropped to zero and the engine failed. During the forced landing on a highway, the left wing struck a road sign. The spar/ fuel tank ruptured and the…Apr 9, 1988 · N1HN · DestroyedNTSB ATL88FA137Accident · 2 fatalField investigationFinal reportBeech C50 · Fayetteville, NCThe pilot reported a fuel pump problem to Fayetteville tower and requested landing. The pilot was cleared to land on runway 04. The controller noticed that the pilot had not lowered the landing gear. The pilot was questioned concerning the gear. Instead of…Apr 9, 1988 · N66L · DestroyedNTSB ATL88DMG05Accident · 2 fatalFinal reportBellanca 14-19-3A · Boone, NCApr 8, 1988 · N8880R · DestroyedNTSB ATL88LA135Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Briceville, TNThe plt stated that he had departed coffeyville, KS on apr 5 for an airplane delivery ferry flt to lincolnton, NC he landed at cape girardeau and remained overnight due to enroute weather. He deptd cgi the following morning following a wx brief that indicated…Apr 7, 1988 · N46316 · DestroyedNTSB CHI88LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Sauk Center, MNWhile enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…Apr 6, 1988 · N62218 · DestroyedNTSB LAX88LA154Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Pine Valley, CAFailure of the number one connecting rod bearing. Contributing to this accident was the student pilot's relative inexperience and his inability to judge the glide ratio of the airplane and completing a forced landing in unsuitable terrain.Apr 5, 1988 · N18136 · Substantial damageNTSB CHI88FA091Accident · No injuriesField investigationFinal reportBeech B90 · St. Paul, MNMechanical failure and sticking of the pilots thumb operated trim switch causing nose down pitch command. The failure of the cabin heater and the low cabin temperature are contributing factors.Apr 5, 1988 · N181LL · Substantial damageNTSB LAX88LA153Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bakersfield, CAThe helicopter encountered weather while enroute to its dest and diverted to an alternate arpt. It overflew the alternate and, after the engine failed from fuel exhaustion, crashed during an autorotative forced landing.Apr 4, 1988 · N646JS · Substantial damageNTSB LAX88FA148Accident · 5 fatalField investigationFinal reportPiper PA-31-325 · Orinda, CABefore the acdnt, witnesses observed the acft circling in a valley beneath a low cloud layer & below the surrounding hilltops. They estimated the ceiling was 400' obscured. Two witnesses said the acft entered clouds before it crashed. A 3rd witness, who was a…Apr 4, 1988 · N6ET · DestroyedNTSB ATL88FA136Accident · 7 fatalField investigationFinal reportPiper PA-32R-301T · Middlesboro, KYThe plt received preflt wx briefing that stated VFR flt was not recommended due to low pressure system affecting proposed flt path. Wx forecast included tornadoes, hail, thunderstorms to 42,000', moderate rime icing, moderate turbulence, wind gusts to 70 KTS,…Apr 3, 1988 · N8171P · DestroyedNTSB MKC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Cedar Rapids, IADuring a night cross country trip, PIC experienced a total power loss. An emergency ldg was attempted and the accident aircraft collided with the terrain. Post accident inspection revealed no mechanical or fuel starvation problems. The pilot reported that the…Apr 2, 1988 · N29325 · Substantial damageNTSB DEN88FA091Accident · No injuriesField investigationFinal reportAerospatiale SA316B · Silver Plume, COApr 2, 1988 · N72590 · Substantial damageNTSB MKC88FA070Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Springfield, MOWhile enroute to a vehicle accident the pilot encountered instrument flight conditions. As a result of flying into fog and turning on his night scanner light, the pilot experienced spatial disorientation and failed to maintain aircraft control. The pilot…Apr 1, 1988 · N119AE · Substantial damageNTSB LAX88LA147Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Apple Valley, CADrg a flt from hawthorne to delano, CA, the plt became lost, saw an arpt & landed. After landing, she learned she was at the depue arpt, lenwood, CA. No fuel was available, so she elected to fly to Apple Valley, a distance of about 17 mi. However, before…Apr 1, 1988 · N2498D · Substantial damageNTSB LAX88FA146Accident · 1 fatalField investigationFinal reportCessna 172N · Saticoy, CAA certificated private pilot and his instructor, conducting training in a 172P, were turning left to a southeasterly heading at 3,400 feet MSL, near an uncontrolled airport. A Cessna 172N on a pleasure flight in the vicinity was climbing on a southwesterly…Apr 1, 1988 · N733KS · 2 aircraft · Substantial damageNTSB ATL88FA131Accident · 1 fatalField investigationFinal reportMooney M20G · Jasper, GABefore depg blairsville, the plt reqd the current atlanta wx for the dekalb-peachtree arpt & for an afternoon outlook. He told the briefer that he had received a previous wx briefing. He was informed that the forecast was for instrument conds until noon with…Apr 1, 1988 · N3638N · DestroyedNTSB FTW88FA084Accident · 1 fatalField investigationFinal reportCessna 172M · Hope, ARThe non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…Mar 31, 1988 · N6534H · DestroyedNTSB CHI88FA087Accident · 2 fatalField investigationFinal reportBeech 35-C33A · Onamia, MNPilot's poor judgement in continuing VFR flight into IMC conditions, and his subsequent disorientation and failure to maintain aircraft control.Mar 31, 1988 · N2766T · DestroyedNTSB MIA88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · St Petersburg, FLThe acft was climbing thru 1600 ft when the upper half of the main entry door opened & separated from the acft. The physician plt stated that he was reasonably sure that he had secured the door prior to departure. He stated that although the cabin had not yet…Mar 30, 1988 · N3645E · Substantial damageNTSB MIA88FA134Accident · Minor injuriesField investigationFinal reportBellanca 17-30 · Daytona Beach, FLThe plt stated that he had filled the main tanks and nearly filled the two aux tanks earlier and had flown for about 1 hr using one of the aux tanks for cruise. He had just taken off using the mains & when he leveled at 2600 ft, he switched to one of the aux…Mar 30, 1988 · N4927V · DestroyedNTSB SEA88LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Palmer, WAWhile on a VFR cross country flight the pilot encountered instrument meteorological conditions along his route. The aircraft was not instrument equipped, even though the pilot is instrument rated. The pilot had to make two precautionary landings prior to the…Mar 28, 1988 · N86820 · DestroyedNTSB SEA88LA070Accident · No injuriesLimited investigationFinal reportCessna 305-A · Arlington, WAShortly after takeoff, at about 200 feet AGL, a total loss of power occurred. A forced landing was made onto a turf field next to the runway. During landing the aircraft nosed over inverted. The pilot stated to FAA inspectors that the aircraft had set outside…Mar 27, 1988 · N10442 · Substantial damageNTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…Mar 27, 1988 · N2958D · DestroyedNTSB NYC88LA117Accident · No injuriesLimited investigationFinal reportMooney M20 · Manchester, NHMaintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…Mar 27, 1988 · N2746W · Substantial damageNTSB LAX88FA135Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Torrance, CAPilot-in-command to apply carburetor heat when entering carburetor icing conditions.Mar 27, 1988 · N26022 · Substantial damageNTSB LAX88LA137Accident · Minor injuriesLimited investigationFinal reportAvian Magnum IX · Phoenix, AZDuring a local flight in a hot air balloon, while descending, the deflation line malfunctioned. It was found that the release pulley had no roller and the rope was knotted and jammed in the pulley. The vent could not be activated in this condition.Mar 26, 1988 · N1601D · Substantial damageNTSB MKC88LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Preston, MOThe student pilot was on the second leg of a x-country trng flt when the eng quit. Exam of the acft fuel system revealed that no fuel was present. The pilot departed the original departure arpt without a full load of fuel, and had planned to acquire fuel at…Mar 25, 1988 · N4712D · Substantial damageNTSB FTW88MA083Accident · No injuriesMajor investigationFinal reportBritish Aerospace BAE-3101 · Decatur, TXAirplane's encounter with rought terrain during an attempted forced landing. The forced landing was necessitated after the captain used improper procedures to shutdown the left engine in flight following an unexplained torque fluctuation.Mar 25, 1988 · N411AE · Substantial damageNTSB BFO88FA031Accident · 2 fatalField investigationFinal reportRyan Navion NA-4 · Fancy Gap, VAThe pilot failed to maintain visual contact and clearance with rising terrain after VFR flight encountered IMC.Mar 25, 1988 · N1598V · DestroyedNTSB DEN88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Logan, UTThe plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…Mar 24, 1988 · N9393C · Substantial damageNTSB CHI88IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 767-200 · Cimarron, NMWhile in normal cruise flight at FL 370, the flt crew was advised by ARTCC personnel that other aircraft were experiencing occasional severe turbulence at FL 370 along their route of flight. A descent was made to FL 330 to avoid turbulence. Later, as the…Mar 24, 1988 · N308AA · No damageNTSB ATL88LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Muscle Shoals, ALThe airplane experienced a loss of electrical power during the local, solo flt. The student elected to make a precautionary ldg at Muscle Shoals arpt (MSL) which was the nearest arpt. He made two attempts to land on rwy 36, with a 12-20 kt tailwind: on the…Mar 24, 1988 · N2738S · Substantial damageNTSB LAX88LA133Accident · 1 fatalLimited investigationFinal reportGulfstream American AA5A · Union City, CADuring a pleasure flight, the airplane collided with a power line tower. The airplane was consumed by fire. The weather at the time of the accident was reported to be instrument meteorological conditions with low fog. The pilot did not file an instrument…Mar 23, 1988 · N26851 · Destroyed