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 CHI85LA361Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Wabash, INThe student plt was on a planned 3 leg x-country. On the second leg, he became ill and was lost for about one hour. He did not refuel as he though enough fuel remained to return to Wabash. The eng stopped about 7 miles from Wabash. The acft nosed down in a…Aug 31, 1985 · N66550 · Substantial damageNTSB SEA85LA205Accident · Minor injuriesLimited investigationFinal reportCessna T210-M · Camano Island, WAThe plt failed to visually verify the fuel on board prior to takeoff and he was aware that one fuel gage was inaccurate.a total loss of pwr occurred over water aprx 30 miles from the intended destination arpt. The plt was able to reach land during the…Aug 30, 1985 · N761VV · Substantial damageNTSB MKC85LA198Accident · No injuriesLimited investigationFinal reportCessna 150G · Camdenton, MOThe pilot and son were on a personal cross-country flight when the engine quit. The airplane nosed forward to the inverted position during the landing roll. The reason for the engine failure could not be determined.Aug 30, 1985 · N3240J · Substantial damageNTSB MIA85FA241Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Daytona Beach, FLPilot did not know how to turn on the instrument panel lights nor did he have a flash light available. He continued flight into darkness of night at which time he became disoriented and lost. He continued to fly until he exhausted all fuel on the aircraft and…Aug 29, 1985 · N6502L · Substantial damageNTSB ATL85IA263Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCThe flight was level at 330 when it encountered turbulance and the arcraft moved an estimated 200 feet down then up before the crew could regain altitude control. Two flight attendents and several passengers initially complained of injuries. No documentation…Aug 29, 1985 · N8832E · No damageNTSB NYC85LA233Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Wheatland, NYAcft departed leroy, NY, on an instructional flt to rochester, NY. Fifteen minutes after departure the flt made a forced landing in a bean field. Examination of the acft showed no useable fuel remained.Aug 28, 1985 · N9787U · Substantial damageNTSB NYC85LA226Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Wrightstown, NJDuring an enroute climb the pilot noticed a manifold pressure loss on the left engine. Oil pressure and temp gauges went off and the left engine was secured by the piilot. During shutdown a passenger informed the pilot that the left wing was turning brown.…Aug 28, 1985 · N90342 · Substantial damageNTSB ATL85FA261Accident · 3 fatalField investigationFinal reportBeech C-99 · Conover, NCAcft was on trng flt for initial copilot qual for commuter air carrier. Instructor and two trainees were on board. The acft departed charlotte at about 2314EDT for the hickoryarea for trng. At about 0015EDT,it was reported that the crew visited the hickory…Aug 28, 1985 · N992SB · DestroyedNTSB SEA85FA203Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Bridge, IDAt 1445 MDT, the 60 yr old plt departed on a routine, VFR, repositioning flt which he had frequently flown before. After takeoff, he leveled the acft at 9500 ft on a direct course toward the destination. While en route at about 1515, the acft began a shallow…Aug 27, 1985 · N2282M · DestroyedNTSB NYC85LA223Accident · No injuriesLimited investigationFinal reportCessna 150G · Reading, PADuring a descent for landing, the eng lost power & the plt made a forced landing in a grass field. However, the grass was damp & the plt was unable to stop the acft before it hit a cyclone fence. According to the local township police, the plt stated the acft…Aug 27, 1985 · N2901S · DestroyedNTSB LAX85FA373Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC Metro II · Fresno, CAWhile in cruise flight at 16,000 feet one of the three propeller blades separated at the shank. The unbalanced condition twisted the eng from its mounts and into the fuselage. The cabin was punctured and rapid decompression followed. The crew was able to…Aug 27, 1985 · N139WW · Substantial damageNTSB LAX85LA367Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, CAAs the acft approached its home arpt, on a westerly heading and looking into the sun, the plt began the descent. The acft's left wing severed the left horizontal stabilizer and elevator from an approaching acft. The plt continued his approach and landed…Aug 26, 1985 · N62868 · 2 aircraft · Substantial damageNTSB FTW85FA331Accident · 2 fatalField investigationFinal reportValentin Taifun 17E · Abilene, TXThe glider was thermaling in a slow right climbing turn about 600 feet above ground level. Witnesses stated it started a right spiraling descent and the nose suddenly dropped until it was in a near vertical attitude. The spiral then developed into a tight…Aug 24, 1985 · N164RB · DestroyedNTSB BFO85FA071Accident · 2 fatalField investigationFinal reportCessna R182 · Browntown, VADrg a wx briefing, flt prctns for ocnl mtn obscn & IMC were relayed to the plt, but he was not provided a forecast for thunderstorms, nor advised VFR flt was not rcmdd. The route of flt was portrayed as marginal VFR, as was the destn at morgantown (mgm).…Aug 24, 1985 · N7393Y · DestroyedNTSB BFO85FA070Accident · 2 fatalField investigationFinal reportCessna 120 · Afton, VAThe plt and his wife departed waynesboro arpt in reported VFR wx conditions at aprx 1700 hrs. According to the assistantarpt mgr the ceiling was about 2500 ft however, the mountain tops were obscured in the direction the acft flew towards. At about 1710 hrs…Aug 24, 1985 · N1812V · DestroyedNTSB ATL85FA256Accident · 5 fatalField investigationFinal reportPiper PA-31T · Flat Rock, NCAcft hit northwest side of ridge in level attitude,cruise speed,heading southeast. Conditions were dark night and the cloud ceiling was about 40 feet above the ridge. Pilot received wx brief before take off and en route which reported a ceiling of 10,000 feet…Aug 24, 1985 · N600CM · DestroyedNTSB ANC85LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Yuki River, AKDuring a normal cruise the aircraft engine quit. The pilot attempted a emergency landing on the Yuki River. During the examination of the aircraft engine no mechanical failure or malfunction was noted. Water was located in both the fuel tanks and fuel lines.Aug 23, 1985 · N83545 · Substantial damageNTSB LAX85LA362Accident · No injuriesLimited investigationFinal reportCessna 210 · Sylmar, CAThe pilot reported that the aircrafts engine experienced mechanical trouble and a forced landing on a freeway was attempted. The aircraft's left wing struck a metal center divider during the landing rollout. The results of an engine oil analysis revealed high…Aug 22, 1985 · N9726X · Substantial damageNTSB SEA85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-25-23-5B · American Falls, IDWhile departing into bright morning sun from a road to spray crops, the pilot pulled up to avoid power lines. A departure stall was then entered into. The pilot dumped his chemical prior to striking the ground hard.Aug 21, 1985 · N76942 · Substantial damageNTSB LAX85LA360Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Tolleson, AZAccording to the pilot,the engine lost partial power while in cruise flt. He selected a cotton field in which to make a precautionary lng. The aircraft over shot the intended landing area and impacted a utility pole. The collision ruptured the fuel system and…Aug 21, 1985 · N6749K · DestroyedNTSB DEN85LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Rocklake, NDThe student plt got lost during her 1st solo x-country flt. She subsequently attempted a lng on a gravel road but swerved the a/c off the road to avoid an oncoming car & the a/c received substantial damage.Aug 21, 1985 · CGZSQ · Substantial damageNTSB DEN85FA227Accident · Serious injuriesField investigationFinal reportPiper PA-31B-310 · Vernal, UTThe plt cancelled his IFR plan and began descent from 13000 ft in preparation for landing at Vernal, UT. The acft impacted ground in wings level attitude under power. Plt was seriously burned by post-crash ground fire. Investigation revealed no evidence of…Aug 21, 1985 · N7497L · DestroyedNTSB CHI85FA354Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot was flying on a south casterly heading of approximately 150' at a low altitude when he struck a set of static lines at approximately 170' AGL. The aircraft flipped over and hit the terrain at approximately 60, nose down in a stand of corn. The pilot…Aug 20, 1985 · N3074K · DestroyedNTSB ATL85LA254Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spring City, TNThe student was on a solo cross-country training flight when the engine lost total power without warning. The plt made an emergency landing in a field and durning the landing the aircraft collided with trees and was substantially damaged. Post crash…Aug 19, 1985 · N23376 · Substantial damageNTSB SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…Aug 18, 1985 · N49282 · Substantial damageNTSB NYC85LA217Accident · No injuriesLimited investigationFinal reportPiper J-3 · Goshen, NYAcft ran out of fuel while plt was returning to orange co arpt. Plt almost froze on controls when acft engine stopped running. Plt overshot emerg landing fcd and hit trees.Aug 18, 1985 · N35515 · Substantial damageNTSB NYC85FNA03Accident · Serious injuriesFinal reportPiper PA-28-151 · Newburyport, MAThe pilot attempted a landing at night with an inoperative landing light and no runway lights. After circling the airport 3 or 4 times he attempted a landing. The aircraft received substantial damage and the pilot received serious injuries. The passenger…Aug 18, 1985 · N8371C · Substantial damageNTSB DEN85FA222Accident · 4 fatalField investigationFinal reportCessna 172P II · Cedar City, UTThe plt took three of his friends up for a pleasure flt in the local area of Cedar City, Utah. VMC prevailed at the time. The plt continued to climb his acft as it passed over rising terrain. The flt terminated in a box canyon with high terrain on all sides.…Aug 18, 1985 · N54168 · DestroyedNTSB CHI85LA352Accident · No injuriesLimited investigationFinal reportHughes 269A · Hector, MNAfter liftoff from an open field, on a short local flight the helicopter experienced fuel exhaustion. During the auto rotation landing, in an open field the helicopter rolled on the side.Aug 18, 1985 · N8777F · Substantial damageNTSB CHI85FEV02Accident · Serious injuriesFinal reportde Havilland DH-82A · Elmore, ILWhile on a x-country flt, the eng lost power & the prop continued to windmill. Subsequently, the acft crashed during an emerg landing. During the crash landing, the plt's shoulder harness failed at the upper attachment point & he received head & back…Aug 17, 1985 · N510AB · Substantial damageNTSB ATL85LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Yanceyville, NCThe non instrument rated private pilot flew into know adverse wx conditions. While receiving vectors to the nearest airport, the eng lost power dur to fuel exhaustion and an emergency landing was made in a field near a private residence.Aug 17, 1985 · N47994 · Substantial damageNTSB ATL85FA252Accident · 4 fatalField investigationFinal reportMooney M20C · Columbus, GAAcft departed airport after enroute stop for fueling.VFR conditions with broken clouds at 2800 feet and turbulence in clouds. Acft was cleared to 4500 and PIC asked to report reaching. During climb PIC was asked his altitude. His response was unintelligible…Aug 17, 1985 · N5844Q · DestroyedNTSB SEA85FA198Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Sparks, NVAcft exhausted fuel enroute to destination during cross coun try night flgt. Plt advised ATCT of loss of engines about 20 miles out. Plt made deadstick landing on hwy, struck bridge divider. No fire or reported injures. Inspection disclosed dry fuel tanks.Aug 16, 1985 · N27476 · DestroyedNTSB NYC85LA214Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Montgomery, NYThe plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing…Aug 16, 1985 · N5405L · Substantial damageNTSB LAX85LA356Accident · No injuriesLimited investigationFinal reportCessna R182RG · Hilo, HIOn August 16, 1985, a Cessna 182 ditched at sea following fuel starvation about 200 miles northeast of Hawaii while on a ferry flight. The pilot reported that he had 23 hours of fuel onboard for the 16 hour flight. The aircraft was equipped with auxiliary…Aug 16, 1985 · N8798Z · DestroyedNTSB LAX85LA352Accident · No injuriesLimited investigationFinal reportCessna 182K · Pioneer, CADocuments provided by the plt established that 45.5 gallons of fuel were loaded on the aircraft prior to departure from watsonville, California, the day prior to theaccident. The flt flew direct to minden, Nevada, a straight line distance of 170 NM, where it…Aug 16, 1985 · N3169Q · Substantial damageNTSB LAX85LA350Accident · No injuriesLimited investigationFinal reportCessna 182A · Santa Paula, CADuring a cross country flt the acft experienced fuel exhaustion and collided with ground obstructions during the subsequent forced landing in a river bed. The plt said 4 hrs and 20 mns of engine run time had elapsed since the last fueling of the acft. At the…Aug 16, 1985 · N5879B · Substantial damageNTSB DEN85LA221Accident · No injuriesLimited investigationFinal reportBeech E18S · Billings, MTThe plt stated that he encountered a 'wind draft' and the acft was struck by lightning. The rt eng mount failed and the rt eng was deflected downward. Plt was unable to maintain alt and executed a forced landing in an open field. Post crash exam of the welded…Aug 16, 1985 · N44N · Substantial damageNTSB CHI85FA351Accident · 1 fatalField investigationFinal reportCessna 404 · South Lyon, MIThe acft took off and climbed to 5000 ft uneventfully. It then dropped off radar and subsequently impacted the ground in a flat upright attitude. A post-crash fire consumed the majority of the airframe. Eng and prop teardowns indicated no abnormalities and…Aug 16, 1985 · N404EX · DestroyedNTSB NYC85LA211Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Del Mar, NYThe plt was reposition the acft at the request of the new owner who was not a rated plt. While climbing thru 2000 ft AGL the plt reported hearing the engine growl and felt a loss of power. During a precautionary descent the engine seized and the plt made a…Aug 14, 1985 · N3431H · Substantial damageNTSB LAX85LA351Accident · No injuriesLimited investigationFinal reportCessna 172P · Saint Helena, CADuring a local personal flt, the plt said the 'engine began to run rough a shake violently.' With not enough power to maintain altitude, the plt elected to make an emergency landing in a field, however, overran the field after touchdown and collided with…Aug 14, 1985 · N5259K · Substantial damageNTSB FTW85LA320Accident · No injuriesLimited investigationFinal reportCessna 172N · Sallisaw, OKThe plt stated he had an electrical failure and elected to make a precautionary landing at Sallisaw municipal arpt. Equipment was on the rwy and the plt elected to land on a grass strip next to the rwy. He touched down and during rollout thought he could not…Aug 14, 1985 · N738XZ · Substantial damageNTSB NYC85LA209Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Carthage, NYAccording to the pilot,while climbing to cruise, the engine began to run rough; however it did not quit. The pilot decided to return to the field for a precautionary landing. While turning onto final approach, the engine quit and the pilot attempted to glide…Aug 13, 1985 · N2661K · Substantial damageNTSB MKC85LA187Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Ottumwa, IAN27492 collided with utility wires which cross the des moines river and crashed into the river.Aug 13, 1985 · N27492 · Substantial damageNTSB MKC85LA184Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Oakley, KSN8541S collided with a fence and crashed while attempting a forced landing. The plt reports that it took longer than expected to dispense his chemical load and he was critically low on fuel when he departed the working area for the arpt. He got to within 2…Aug 13, 1985 · N8541S · Substantial damageNTSB MKC85FA182Accident · 1 fatalField investigationFinal reportRonald Houk RD-1 · St. Charles, MOThe home built gyrocopter was being flown by the owner/builder/designer who had an airplane, single-eng, land rating. Shortly after the gyrocopter took off, the eng was operating at a high RPM when a witness heard a pop/noise. Subsequently, the gyrocopter…Aug 13, 1985 · N4741A · DestroyedNTSB FTW85LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · May, TXThe plt stated the eng RPM dropped to 1500 during level cruise flt at 4200 ft MSL. He could not regain pwr. He diverted the flt and attempted to reach the brownwood, TX, arpt but did not have sufficient alt. A forced landing was made in a rugged, heavily…Aug 13, 1985 · N9912W · DestroyedNTSB DEN85LA218Accident · No injuriesLimited investigationFinal reportDowner Aircraft Industries REP. Seabee RC-3 · Haugan, MTThe plt had reconditioned N6305K and was flying the acft to his home in Texas. He continued to state that while climbing through 6500 ft, he heard an unusual noise followed by a substantial loss in pwr. The plt executed an emergency landing on a forest…Aug 13, 1985 · N6305K · Substantial damageNTSB MIA85LA230Accident · No injuriesLimited investigationFinal reportCessna 177 · Vieques, PRThe CFI and student plt utilized a homemade dipstick to check the fuel tanks & determined they had about 8 gals of fuel in the tanks. About 30 minutes after takeoff the eng failed and all restart attempts were negative. The acft was ditchedin about 25 ft of…Aug 12, 1985 · N30232 · Substantial damageNTSB CHI85LA346Accident · No injuriesLimited investigationFinal reportCessna 177 · Hillsdale, MIThe acft contacted trees during a forced landing following fuel exhaustion. The acft was in cruise flt when the plt noted the fuel gages indicated a low fuel state. He had turned toward an arpt which was closer than his destination and the eng quit. He…Aug 12, 1985 · N3495F · Substantial damage