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 CHI87LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Evansville, INAccording to the plt, just after starting a descent from 300O feet, while inbound to Evansville dress regional airport(evv), the engine 'suddenly and without warning quit.' The plt stated that after deciding he could not make evv, he turned left and set up a…Nov 22, 1986 · N3871L · Substantial damageNTSB FTW87LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Leander, TXThe pilot made an emergency landing on a highway 20 miles nw of austin due to fule exhaustion. The aircraft received substantial damage to the right wing. The pilot then refueled the aircraft with auto gas from a passing truck and continued on to his…Nov 21, 1986 · N3230V · Substantial damageNTSB ATL87LA024Accident · Minor injuriesLimited investigationFinal reportBeech BE-19A · Waverly, TNThe pilot reported an electrical failure, however the exact reason for the broken alternator belt was not determined. The wreckage examination disclosed that there was no fuel found in the aircraft system. There was also no fuel spillage. The pilot was not…Nov 21, 1986 · N6093N · DestroyedNTSB SEA87FA027Accident · 1 fatalField investigationFinal reportCessna U206F · Moose Creek, IDAfter departure and during the initial cruise climb the plt and pax heard a metallic clicking described as sounding like a 'valve tap' in an automobile and coming from the eng area. The plt executed an immediate course reversal back to the airstrip while…Nov 20, 1986 · N7311Q · DestroyedNTSB LAX87LA043Accident · No injuriesLimited investigationFinal reportCessna A150M · Corona, CADuring a local flight, the pilot was practicing a simulated engine out procedure toward an open field on rolling terrain. He stated that he misjudged the rising terrain and got too low and slow to initiate a go-around. Subsequently, he was forced to land.…Nov 19, 1986 · N2731J · Substantial damageNTSB CHI87DEM04Accident · Serious injuriesFinal reportDevries Sonerai II · Wayland, MIThe volkswagen engine of this homebuilt aircraft lost power sometime during flight. Subsequently, the aircraft crashed during a forced landing in a field. The pilot received serious head injuries during impact and could not remember details of the accident.…Nov 19, 1986 · N28KD · DestroyedNTSB MKC87FA020Accident · 1 fatalField investigationFinal reportCessna 182A · Bluff City, KSThe plt stated that he was cruising at 2,500 ft MSL en route southbound to enid, Oklahoma, when he encountered fog but flew for 15 to 20 minutes before executing a 180DEG northerly turn back to hutchinson, KS. According to the plt, he was in the clouds trying…Nov 17, 1986 · N2038G · DestroyedNTSB LAX87FA045Accident · 2 fatalField investigationFinal reportCessna 150L · Lake Isabella, CAThe aircraft departed the kern valley airport, kernville, California, on a direct cross-country route to its home base at general william j. fox airfield, lancaster, California. The flight route was over mountainous terrain that was obscured by clouds. A…Nov 17, 1986 · N18235 · DestroyedNTSB NYC87LA033Accident · No injuriesLimited investigationFinal reportCessna 33TC · Phillipsburg, PAThe Cessna 337 experienced engine surging and plt made a precautionary landing at an airport while enroute to destination. The aircraft landed 200 ft short of the runway and received substantial damage while the two occupants were not injured. On scene…Nov 14, 1986 · N2581S · Substantial damageNTSB MIA87FA031Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Columbus, MSThe acft departed Columbus, MS, en route to meridian, MS, to pick up cargo for a return flt to Columbus. The acft did not arrive at its destination and was later found in an open field about 2 miles southwest of the golden triangle regional airport in…Nov 12, 1986 · N21188 · DestroyedNTSB ATL87IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Livingston, TNThe braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…Nov 12, 1986 · N471BN · 2 aircraft · No damageNTSB MKC87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Gretna, NEThe instructor stated that this training flight would emphasize power reduction manuevers, to include: slow flight, power-off stalls, and flight at minimum controllable airspeed. Thirty minutes into the flight, and during the application of power for…Nov 11, 1986 · N5175M · Substantial damageNTSB CHI87LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · South Bend, INDuring cruise at 7000' MSL, the plt assumed that he was having an electrical failure because he had not heard any ARTCC transmissions, fuel gauges were indicating low fuel, ammeter reading was zero, and landing gear would not cycle. He shut off all electrical…Nov 10, 1986 · N578PA · Substantial damageNTSB ANC87IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Adak, AKA canadian pacific Mcdonnell Douglas DC-10 (flt 3), cg-cpj, & a reeve aleutian Boeing 727 (flt 724), N832, were clrd to fly at FL 290 on 2 different airways. The airways crossed at picum intxn, ovr the bearing sea. While traveling in nrly opposite drctns at…Nov 10, 1986 · CGCPJ · 2 aircraft · No damageNTSB LAX87LA036Accident · No injuriesLimited investigationFinal reportCessna 150L · Elk Grove, CAAs the plt was returning from a local flight, the engine lost power for about 15 seconds, then restarted. The plt checked the fuel gauges which indicated one tank was empty and the other was 1/4 full. At about 1-1/2 miles from the airport, the engine lost…Nov 9, 1986 · N5360Q · Substantial damageNTSB ATL87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCOne blade of the fixed pitch propeller separated 3' from the hub during a routine instructional flight. The imbalance resulted in a broken engine mount and a total loss of power was experienced. A forced landing was made in a soft field during which, the…Nov 9, 1986 · N6537P · Substantial damageNTSB ATL87LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCDuring a local instructional flight, the CFI was demonstrating a simulated emergency landing to a field to a 5 hour pre-solo student pilot. During recovery the aircraft was reportedly affected by a downdraft and collided with a wire. The acft began losing…Nov 9, 1986 · N6617L · DestroyedNTSB SEA87LA021Accident · Serious injuriesLimited investigationFinal reportBellanca BL17-30 · Beatty, NVWhile in cruise at 11,500 ft MSL, fuel pressure and engine pwr were lost. Plt tried variations of fuel tank selections and boost pump with no success. During forced landing attempt at remote airstrip, plt misjudged approach, stalled acft about 100 yds short…Nov 8, 1986 · N4797V · Substantial damageNTSB MIA87LA027Accident · Minor injuriesLimited investigationFinal reportBeech A100 · Brooksville, FLThe pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence…Nov 8, 1986 · N78L · DestroyedNTSB BFO87MA007Accident · 1 fatalMajor investigationFinal reportBeech 65-A80 · Baltimore, MDDrg clb after tkof, l eng seized. Plt said he atmtd 1 eng restart; prop would not rotate or feather. No emerg declared. Plt stated eng shut-dwn proc was used, scientific bus sws were shut off, r gen was recycled & appeared to oper normally. Plts got imt…Nov 8, 1986 · N304D · DestroyedNTSB SEA87FA019Accident · 2 fatalField investigationFinal reportBeech BE35K · Marysville, WAA witness observed the acft impact in an open field during a heavy rain. Rain, fog, and turbulence in the clouds were reported in the area at the time. The acft impacted in a right turn. The new instrument rated plt was getting complex acft time in…Nov 7, 1986 · N9536R · DestroyedNTSB MIA87LA026Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLWhile being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated…Nov 7, 1986 · N2107C · DestroyedNTSB LAX87MA044Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAThe captain stated that about 90 min after departure, the acft experienced an abrupt pitch-up, followed by an abrupt pitch-down. Drg the occurrence, one flt attendant was seriously injured; two flt attendants & one passenger received minor injuries. The…Nov 7, 1986 · N68043 · No damageNTSB DEN87FA018Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Billings, MTWhile on takeoff from a hospital roof top helipad on an emergency medical service flt, a synchronized elevator cover blew off and struck the tail rotor. This resulted in an inflight separation of one tail rotor blade and a loss of anti-torque control. The plt…Nov 7, 1986 · N3889S · DestroyedNTSB CHI87FA021Accident · 1 fatalField investigationFinal reportCessna 182P · Goreville, ILThe acft crashed and burned following a collision with a guy-wire supporting a micro-wave tower. The plt had initiated the flt in MVFR weather and continued the VFR flt into IMC conditions. The crash site was located adjacent to interstate hwy 57 and…Nov 7, 1986 · N9124M · DestroyedNTSB SEA87MA018Accident · 2 fatalMajor investigationFinal reportCessna 401 · Henderson, NVApproximately 5 1/2 minutes after departure and while the aircraft was climbing enroute, an unknown ignition source triggered an explosion of fuel/air vapor which existed within the interior of the left wing. Wing skin from the upper/lower wing surface was…Nov 6, 1986 · N3219Q · DestroyedNTSB NYC87LA030Accident · Serious injuriesLimited investigationFinal reportBell 206B · Staten Island, NYThe on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury.Nov 6, 1986 · N83086 · Substantial damageNTSB MIA87FA025Accident · 2 fatalField investigationFinal reportCessna 152 · Woodville, FLThe non-instrument rated private plt had received his certificate two days prior to the accident. The flight was receiving stage three radar service when it advised that it was in the clouds and was turning around. Radar contact was lost moments later and the…Nov 6, 1986 · N49083 · DestroyedNTSB CHI87IA026Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Washington, DCDrg an en route climb, aileron control (ctl) bcm progressively more stiff. At cruise alt, the autoplt disengaged & the ailerons would not move. Aileron ctl was restored after a dscnt below the freezing level. The acft was flown below the freezing lvl for the…Nov 6, 1986 · N516US · No damageNTSB MKC87LA016Accident · No injuriesLimited investigationFinal reportCessna 150F · Louisburg, KSThe instructor stated that he had observed the student visually check the fuel supply bu that he did not personally inspect the tanks, assuming they were full. According to the pilot, his only confirmation of full tanks was the students repeated statements…Nov 5, 1986 · N3507L · Substantial damageNTSB MIA87LA021Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Jacksonville, FLWhile in cruise flight, the pilot noted that the left engine began losing power and oil pressure. He stated that he then shut down the engine and feathered the propeller. He declared an emergency and descended to land. While on final approach, he lowered the…Nov 5, 1986 · N8002J · DestroyedNTSB CHI87LA017Accident · No injuriesLimited investigationFinal reportCessna 150M · Ramsey, MNThe newly certficated pilot thought his fuel gages were not indicating properly and did not dip the tanks during preflight. On the last leg of the round robin flt fuel exhaustion occurred and the acft nosed over during the forced landing. The plt reported he…Nov 5, 1986 · N7680U · Substantial damageNTSB CHI87FA018Accident · Serious injuriesField investigationFinal reportGates Learjet 23 · Charleston, WVThe PIC lost consciousness during cruise near Charleston WV while on a revenue flt. The co-plt assumed command and landed at Charleston WV without further incident. The PIC was hospitalized and the flt continued on to detroit mi after a replacement PIC was…Nov 5, 1986 · N344WC · No damageNTSB SEA87LA017Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Paisley, ORThe acft contacted power lines during a night forced landing on a highway following a loss of pwr. The power lines paralleled the road. Investigation revealed no discrepancies with the engine or fuel system. Planned fuel reserve was found in the tanks. The…Nov 4, 1986 · N8338V · Substantial damageNTSB SEA87LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Oregon City, ORShortly after takeoff, an eng failure occurred. The plt elected to make a forced lndg on a freeway. During the landing, the acft collided with two vehicles. An inspection revealed an eng oil line had ruptured which led to oil exhaustion. Evidence indicated…Nov 2, 1986 · N8419P · Substantial damageNTSB LAX87LA031Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Half Moon Bay, CAThe acft collided with the terrain during a forced landing following a loss of engine power. The plt indicated that he retarded the throttle and applied the carburetor heat to descend from 3,000 to 2,000 ft when the engine quit. He was unable to restart the…Nov 1, 1986 · N71745 · Substantial damageNTSB FTW87LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Plainview, TXThe plt rprtd that aprx 25 min after he took off, the eng lost power. He made an emergency landing in a plowed field where the acft nosed over. During an investigation, only traces of fuel were found in the acft. There was no evidence that fuel had drained…Nov 1, 1986 · N97814 · Substantial damageNTSB NYC87LA028Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Linden, NJThe flight experienced an engine power loss during cruise. Pwr was restored and the acft proceeded the pilot was able to return to the airport and made a soft field landing, collapsing the nose wheel during landing roll. The reason for the pwr loss was not…Oct 31, 1986 · N758YR · Substantial damageNTSB LAX87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Eleele Kauai, HIA Piper pa 31-350 lost power and collided with sign posts after landing on a road. It was reported to the FAA that the aircraft's right engine was producing partial power and the aircraft was unable to maintain altitude on the left engine. The pilot never…Oct 31, 1986 · N33WH · Substantial damageNTSB NYC87FA027Accident · Serious injuriesField investigationFinal reportPiper PA-31-325 · Mansfield, MAPiper PA-31, N200GG, was on a VFR flt to boston, MA. The PA-31 plt contacted boston TRACON & adzd he had ATIS info & would be lndg at boston. TRACON suggested a hdg & alt of 070 deg & 2500' for rwy 33R & told the plt to maint VFR. At aprx the same time, a…Oct 30, 1986 · N200GG · 2 aircraft · Substantial damageNTSB MKC87LA011Accident · No injuriesLimited investigationFinal reportGrumman G164B · Memphis, MOThe aerial application acft was en route to seed a wheat field when smoke came into the cockpit. The plt made a precautionary landing on a blacktop road. The road was the best available, but was not adequate and acft flipped forward to the inverted position.…Oct 30, 1986 · N6608Q · DestroyedNTSB NYC87LA026Accident · No injuriesLimited investigationFinal reportCessna U206F · Marshfiled, MAElectrical failure occurred in flight due to an alternator belt failure. The acft landed in the grass beside the rwy and was damaged. The landing was difficult due to darkness, fog and no lights. The plt tried to use flaps but failed due to no elec power. The…Oct 29, 1986 · N9585G · Substantial damageNTSB NYC87FA025Accident · 1 fatalField investigationFinal reportBell 206B · Brattleboro, VTThe helicopter crashed into a wooded ridge aprx 2 NM from it's liftoff location. Persons who reside under the flt path were awakened by the acft as it was descending into IMC at what sounded like full power. The plt's heliport was at an elevation of 950 ft…Oct 29, 1986 · N52EG · DestroyedNTSB DEN87FA046Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Leyba, NMThe plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased…Oct 29, 1986 · N8323P · Substantial damageNTSB MIA87FA013Accident · 1 fatalField investigationFinal reportGrumman G-73 · St. CroixThe plts lost aileron control shortly after takeoff while in a left turn. The left turning tendencies of the acft could not be corrected and the acft crash landed in the carribean sea. Post crash inspection of the acft revealed the left aileron control cable…Oct 28, 1986 · N604SS · Substantial damageNTSB ATL87FA012Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Lawrenceville, GAAbout 20 min after takeoff, while cruising at 6500', the eng lost power. Rprtdly, the eng went to either idle or a wind-milling cond & the fuel pressure dropped to zero. The plt tried to restart the eng by using emerg procedures, but was unable. He initially…Oct 28, 1986 · N3285W · DestroyedNTSB SEA87FA014Accident · 2 fatalField investigationFinal reportPiper PA-38 · Port Townsend, WAThe plt had flown this acft over the same route many times. While en route, the acft collided with tall trees on rising terrain about 3 miles south of a direct course to the destination. The wx in the vicinity was characterized by low clouds, fog & haze. Aprx…Oct 26, 1986 · N2565P · DestroyedNTSB ATL87LA011Accident · No injuriesLimited investigationFinal reportHughes 269B · Danville, KYDuring a local pleasure flight to film the color change of autumn leaves, the low fuel warning light illuminated. Aprx 2 minutes later the engine lost power and the pilot executed an emergency landing in a field. The helicopter lost main rotor RPM prior to…Oct 26, 1986 · N9372F · Substantial damageNTSB LAX87LA026Accident · No injuriesLimited investigationFinal reportCessna 172 · Weed, CADuring a cross country flight, the engine quit approximately 6 miles north of Weed, California. The pilot initiated a forced landing and the aircraft collided with the terrain 150 feet short of the airport. An examination of the aircraft revealed that both…Oct 24, 1986 · CGZWK · Substantial damageNTSB DEN87LA009Accident · No injuriesLimited investigationFinal reportCessna TU206G · Greybull, WYThe plt departed aurora, co at 1000 en route to great falls, mt at 8000 ft MSL. At 1237 the plt advised worland fss that the eng had lost power and he was going down. The plt said that on final apch he had to pull up to avoid power lines. The acft stalled and…Oct 24, 1986 · N6277Z · Substantial damage