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 NYC85FNA02Accident · Serious injuriesFinal reportMcpherson Evans VP-1 · Boxborough, MAThe pilot experienced an engine failure and allowed the airspeed to decrease until the aircraft stalled and spun to the ground. The cause of the engine failure was not determined. The pilot received serious injuries and the homebuilt aircraft received…Jun 11, 1985 · N106JM · Substantial damageNTSB MIA85LA189Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Kissimmee, FLThe plt stated that just after takeoff, at about 800 ft alt the eng lost pwr. He then made an emerg landing in a fld and the acft struck a ditch during the landing roll. Post accident examination revealed both magneto cases were cracked and the #1 cly fuel…Jun 11, 1985 · CGIBB · Substantial damageNTSB FTW85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tahlequah, OKThe plt stated the acft was in flt slightly more than three hrs after it was refueled, before fuel exhaustion occurred. The acft reportedly was leaned during the flt. Post accident examination revealed no evidence of any fuel system leaks. Reason for the fuel…Jun 11, 1985 · N1601S · Substantial damageNTSB SEA85LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kendrick, IDThe plt had finished spraying a field & was returning to the ag strip when the eng failed. He made an emerg landing in a barley field which was muddy & soft. During the landing roll, the wheels sank in the terrain & the acft nosed over. An exam revealed that…Jun 9, 1985 · N7997 · Substantial damageNTSB LAX85LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Biggs, CAThe plt stated that while loading the acft with spray mix he looked at his fuel quantity gage and believed he had enough fuel for one more aerial application flt. The plt continued to state that shortly after liftoff the engine quit and a forced landing was…Jun 9, 1985 · N363Y · Substantial damageNTSB CHI85FEX02Accident · Serious injuriesFinal reportCessna 310C · Greenfield, INWhile en route, the l eng suddenly lost power & would not restart, so the plt feathered the l prop. After letting it cool aprx 5 min, he tried restarting it again, but still was unable. He stated he thought he then secured (feathered) the l eng. The plt…Jun 9, 1985 · N1773H · Substantial damageNTSB DEN85LA151Accident · No injuriesLimited investigationFinal reportBeech B35 · Chinook, MTAbout 10 min after takeoff, the acft was damaged during a forced landing after the eng began sputtering & then lost power. The plt reported that he made a normal takeoff with the cowl flaps open & the mixture rich. After climbing about 1100 ft (to 3500 ft…Jun 7, 1985 · N5099C · Substantial damageNTSB ATL85FA181Accident · Minor injuriesField investigationFinal reportPiper PA-32R-301T · Newnan, GAThe eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then…Jun 6, 1985 · N8215B · Substantial damageNTSB MKC85LA121Accident · No injuriesLimited investigationFinal reportCessna A188B · Marvell, ARPlt stated that the engine stopped producing power after a reduction to cruise power. Touchdown during the forced lanidng was hard. The engine ran satisfactorily during post crash testing and cause of the loss of power could not be determined.Jun 3, 1985 · N4865Q · Substantial damageNTSB ATL85FA179Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Kennesaw, GAPrior to takeoff the plt and his brother-in-law added 20 gallons of automotive fuel to the acft fuel tanks. The level of the fuel, according to the brother-in-law, was below the filler neck tabs. After about three hrs of flt the plt radioed a mayday and…Jun 3, 1985 · N8704N · Substantial damageNTSB BFO85IA050Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30F · Chantilly, VAAfter climbing up to and leveling off at 37,000 feet, the crew of the DC-10-30F noticed that the york control of the captain and the first officer moved laterally independently of each other for approximately two inches. After making an unscheduled uneventful…Jun 2, 1985 · N106WA · No damageNTSB DEN85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-25-260-C · Ordway, COThe airplane departed the airport on an aerial application operation. Immediately after takeoff the pilot retarded the propeller control to climb setting and turned east. The pilot said he was aware of and saw power lines ahead. He said he advanced the…Jun 1, 1985 · N4926Y · DestroyedNTSB DEN85LA145Accident · No injuriesLimited investigationFinal reportCessna 182 · Byers, COPlt stated that he was 'in a rush to get home' after his extended trip. He continued to state 'I wanted to get home thatafternoon without another stop and I wanted the performance figures to show me that I could.' The plt executed an emerg landing after the…Jun 1, 1985 · N759QY · Substantial damageNTSB BFO85FA049Accident · No injuriesField investigationFinal reportBell 222U · Milford, VAThe helo was in level cruise flt at 1500 ft and 115 KTS when the no. 2 eng chip light illuminated, accompanied by lowering oil pressure. The plt reduced pwr and started a rt turn to return to base when half way thru the turn a loud bang occurred followed by…May 31, 1985 · N3180K · Substantial damageNTSB ATL85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia, SCThe plt reported that during a descent to 2100 ft, intermediate level offs were made at 5000, 4000, & 3000 ft. he stated that at 2200 ft, carb heat was removed & power was applied for the level off. However, when the throttle was advanced, the eng began…May 31, 1985 · N5221F · Substantial damageNTSB NYC85FNC04Accident · Serious injuriesFinal reportBell 206B · W. Brattleboro, VTThe acft lost pwr during normal cruise. The plt attempted to autorotate into a clearing in the trees. Post accident exam discovered an air leak in the fuel control. The pressure compressor discharge (pcd) line 'b' nut was disconnected from the fuel control.…May 30, 1985 · N23LV · DestroyedNTSB NYC85FHD02Accident · Serious injuriesFinal reportCessna 210F · Princeton, NJThe acft collided with trees & crashed after overflying mercer cty arpt on a special VFR clearance. The acft had descended to 900 ft to overfly mercer and was attempting to proceed VFR to Princeton arpt to land when it contacted trees and crashed. The wx was…May 29, 1985 · N5807F · DestroyedNTSB NYC85FA138Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-10-10 · Jamaica, NYThe forward one-third portion of the core cowl door on no. 3 engine separated in flight first striking the leading edge of the right wing, then puncturing the fuselage. Causing rapid decompression at FL 170. The core cowl door latches were not adjusted & core…May 28, 1985 · N108AA · Substantial damageNTSB MIA85FA178Accident · Serious injuriesField investigationFinal reportAirbus Industrie A-300B4-2C · Atlantic Ocean (Atlantic Ocean)While established in cruise flight conditions the commercial airliner encountered an area of forecast thunderstorms. The captain elected to attempt to fly through the area. As the airliner was attempting to avoid the thunderstorms it encountered one rapid up…May 28, 1985 · N206EA · No damageNTSB ATL85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Athens, ALThe acft lost pwr while en route from kenosha, WI, to decatur, AL, and attempted a forced landing on an ag strip. Duringthe landing roll the acft struck a truck which was parked in the middle of the runway. During post crash examination of the acft no fuel…May 28, 1985 · N8816N · Substantial damageNTSB SEA85LA123Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wamic, ORA forced landing was made following a loss of pwr. The acft contacted two fences, a ditch then nosed over during the forced landing. Post accident inspection revealed no fuel in the carburetor float chamber or in the accelerator pump chambers.May 27, 1985 · N5914G · Substantial damageNTSB MKC85LA112Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goddard, KSOn a final leg of a x-country flt, the eng of the acft began to faulter finally quitting a few minutes later. The subsequent forced landing resulted in the acft nosing over. An inspection of the acft revealed a residual amt of fuel in the wing fuel tanks.…May 27, 1985 · N95623 · Substantial damageNTSB SEA85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, CAThe acft contacted power lines during a night forced landing following fuel exhaustion. The plt had flown from Concord, CA, to reno, NV, and was returning to Concord when the accident occurred. The plt was recently checked out in the acft and was used to…May 26, 1985 · N66942 · Substantial damageNTSB NYC85FHJ03Accident · Minor injuriesFinal reportPiper PA-28-161 · Lewisboro, NYThe acft nosed over on a golf course after striking trees during a forced lndg. The acft had lost power during climb to cruise. Post acc exam showed a failed exhaust valveMay 24, 1985 · N2172N · Substantial damageNTSB FTW85LA233Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Hamilton, TXThe plt stated the acft and engine assy had experienced execssive vibrations while in flt followed by the windshield being covered with oil immediately after the vibration started. The propeller assy had become loose from the engine mount and separated at…May 24, 1985 · N853B · DestroyedNTSB CHI85LA207Accident · No injuriesLimited investigationFinal reportMooney M-20G · Bessemer, MIThe pilot felt he had enough fuel for the planned trip. Prior to reaching his destination the engine lost power & would not restart using either fuel tank. The pilot failed to lower the landing gear prior to landing on a road. The acft struck a utility pole…May 24, 1985 · N3910N · Substantial damageNTSB BFO85LA031Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Piney Point, MDWhile descending in IFR conditions near the destination, the eng lost power at an alt of about 3800 to 4000 ft. the plt requested vectors toward land & the nearest arpt; however, when it broke out of the clouds at about 1000 ft AGL, the acft was still over…May 24, 1985 · N1803Q · Substantial damageNTSB SEA85FA233Accident · 2 fatalField investigationFinal reportCessna 172N · Remote, ORDuring a wx briefing, the non-instrument plt was adzd that VFR flt was not recommended due to low clouds & adverse wx along the route. However, he filed a VFR flt plan & depd arcata, CA at 1240 PDT. At 1339, in the vcnty of wilderville, OR, the plt got a wx…May 23, 1985 · N4871G · DestroyedNTSB FTW85FA230Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Junction City, KSArmy UH-1V and N7053R, a Piper PA-28, collided in mid air at 700 feet AGL. Both acft were in lvl flt. UH-1V was operating on a medical evacuation flt with a crew of four, one patient and two attendants. The UH-1V executed a successful autorotation with…May 22, 1985 · N7053R · 2 aircraft · DestroyedNTSB ATL85FA171Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Charleston, WVThe acft collided with the terrain about 1 mile short of the rwy threshold during an IFR apprch on a dark night in IMC wx. The plt had been briefed on the wx and was given the ceiling at his destination as below VFR minimums . The non-instrument rated plt…May 22, 1985 · N8460M · DestroyedNTSB ATL85LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monticello, GAAbout 20 min after takeoff, while cruising at 5000 ft, the plt observed oil on the windshield & noted a decrease in oil pressure. He turned back toward the departure arpt & reduced the power in an attempt to prolong eng life. A short time later, the eng began…May 21, 1985 · N6201E · DestroyedNTSB SEA85LA118Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Wenatchee, WAWhile returning to the arpt to land, the acft encountered strong downdrafts of 600 to 800 fpm. An off arpt landing was made and while turning from base to final, the left wing tip struck the ground. A groundloop then occurred.May 20, 1985 · N65907 · Substantial damageNTSB SEA85FA121Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Blyn, WAThe acft impacted rising terrain at the 1860 ft level during an IFR flt in IMC conditions. The acft was reportedly to fly 'VFR on top' or IFR at 3000 plus ft enroute to portland. The plt was off course for destination when it impacted mt. Blyn. The acft trim…May 20, 1985 · CFCTC · DestroyedNTSB DEN85LA139Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Grand Junction, COThe plt reported that as he arrived at the destination (canyonlands, UT), there was a storm over the arpt, so he diverteded toward delta, CO. About 10 mi from delta, he encountered another storm, so he turned toward Grand Junction, CO. Before reaching the…May 19, 1985 · N49926 · Substantial damageNTSB CHI85LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Michigan City, INShortly after takeoff the acft experienced a total loss of power & made an emerg landing into a corn field. Investigation disclosed that there was no gas in the carburetor. The plt stated that there was about 10 gals in the acft prior to takeoff. No fuel was…May 19, 1985 · N44345 · Substantial damageNTSB CHI85LA201Accident · No injuriesLimited investigationFinal reportCessna 150 · Durand, ILWhile on a night flight the acft experienced a complete loss of engine power. An emergency landing was made to a road. During the landing the right wing of the acft strucka street sign & power pole. The plt stated to the authorities that the acft had…May 19, 1985 · N50125 · Substantial damageNTSB SEA85LA119Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Rosa, CAWhile on a short local flight to a costal area and return. The engine lost some power. Carburetor heat was applied but no increase in power was noted. The plt then set up a glide with intentions of making a landing onto the beach area. At about 500 feet…May 18, 1985 · N704UV · Substantial damageNTSB DEN85LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Loma, MTThe acft contacted power lines which cross over the Missouri river. The lines are aprx 150-200 ft above the river on one side and aprx 45 ft above the river on the opposite side. The plt stated he was flying along the river at an alt of aprx 75 ft when…May 18, 1985 · N6462D · Substantial damageNTSB CHI85LA200Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Golden Valley, MNShortly after takeoff, on the last leg on it's flight, the engine of the air cargo acft started to sputter. The plt turned the fuel selector handlr from the left tank to another position & turned on the boost pump. The engine stopped running & the plt elected…May 18, 1985 · N91043 · DestroyedNTSB ATL85FA165Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Milledgeville, GAAcft left home airport at 0400. Flt plan left with FBO indicated 6 hours to destination, no en route stops, and 4+30 hours fuel on board. Fuel consumption calculated, 4+36 hours endurance available. Acft flew 4+47 hours. The pilot told approach control acft…May 18, 1985 · N8289H · Substantial damageNTSB MKC85LA103Accident · No injuriesLimited investigationFinal reportAirship Industries Skyship · Columbus, KSIn cruise flt nearing Columbus, Kansas the plt at the controls of the Airship experienced a pitching up of the Airship's nose. The elevator control did not respond to the plt input to counter the nose up pitch. Also noted was a loss of pressure from the rear…May 17, 1985 · GSKSB · Substantial damageNTSB MIA85FKG02Accident · Serious injuriesFinal reportCessna 150H · Tallahassee, FLThe acft collided with wires during a forced landing off the arpt. The plt had called on the radio saying he was unable to make the arpt and was landing in a clearing. The acft ended up inverted after the collision with the wires. Post accident examination…May 17, 1985 · N50239 · Substantial damageNTSB ANC85FA085Accident · 2 fatalField investigationFinal reportCessna C-207A · Golovin, AKAccording to the pilot-in-command, he was attempting to fly through a mountain saddle. As he turned towards the mountain and began his climb the weather deteriorated rapidly with ceilings zero, visibility zero and severe turbulence. The airplane struck the…May 16, 1985 · N73635 · Substantial damageNTSB SEA85FA113Accident · 2 fatalField investigationFinal reportCessna 177RG · Murphy, IDPlt received a preflight wx brief indicating a recent frontal passage in the area with strong winds and trubulence associated with thundershowers along the initial route of flight until clear of the owyhee mountains. No flt plan was filed. Radar tracked the…May 14, 1985 · N1815Q · DestroyedNTSB ANC85LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKWhile cruising at about 2000 ft, the top eng cowling came off, rupturing an eng oil line & breaking a hole in the left side of the windshield. Oil then covered the windshield. Due to the loss of oil, the plt shut down the eng & landed on a beach. During the…May 14, 1985 · N4080W · Substantial damageNTSB SEA85LA111Accident · No injuriesLimited investigationFinal reportBeech H-35 · Owyhee Reserv., IDThe flt departed from boise, Idaho, on the left main fuel tank. Fifteen minutes into the flt the plt switched to the left auxiliary tank. Several minutes later, the engine ceased operating dispite the plts switching back to the left main fuel tank. An engine…May 13, 1985 · N5425D · Substantial damageNTSB ANC85IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Cape Simpson, AK# 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut.May 13, 1985 · N9943M · Minor damageNTSB DEN85FA134Accident · 1 fatalField investigationFinal reportEnstrom F-28F · Carrizozo, NMThe student pilot departed albiquerque, NM with less than full fuel tanks and a worn out eng driven fuel pump which allowed fuel to be pumped overboard. No flt plan was filed. During his VMC x-country flt, the eng failed and an unsuccessful autorotation…May 12, 1985 · N8618A · Substantial damageNTSB ATL85LA160Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Atkins, VAThe acft nosed over during a forced landing following a loss of pwr which resulted from fuel exhaustion. On the day prior to the accident the acft had experienced a total electrical failure. The plt stated that on the day of the accident, he lowered a rope…May 12, 1985 · N51347 · Substantial damageNTSB NYC85FFJ02Accident · No injuriesFinal reportRotec Engineering Rally 3 · Constantia, NYThe pilot and passenger in a rally 3 had been airborne for approximately 3 minutes when he experienced a engine failure. The pilot set up for a landing and eventually got the engine restarted. After flying close to the ground for about 1/4 mile he started…May 11, 1985 · N302RE · Substantial damage