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 FTW83FPG02Accident · 2 fatalFinal reportCessna R172K · Near Paris, ARThe plt & pax were on a flt from amarillo, TX to little rock, AR. An enroute stop was made at haskell, ok at appr 1900 to refuel. The owner of the afpt at haskell stated that the plane arrived in a fairly heavy rainstorm. At that time, a winter type cold…Nov 12, 1982 · N736QD · DestroyedNTSB ATL83AA029Accident · 1 fatalFinal reportPiper PA-31-350 · Brevard, NCAfter a missed approach at asheville the flt was cleared to the greenville-spartanburg arpt at greer,SC. Enroute to greer radar contact was lost. In response to a query from atlanta ARTCC the plt verified his position as being on the 235 deg radial of…Nov 12, 1982 · N59771 · DestroyedNTSB MIA83FA027Accident · 1 fatalField investigationFinal reportBoeing 707-300 · Miami, FLDuring climbout from Miami, a cabin pressurization problem was encountered. All crew members donned their oxygen masks & the cabin altitude stabilized at 20,000 ft as the acft was leveled at 33,000 ft. about 40 minutes from destination the flight engineer…Nov 11, 1982 · N707GB · No damageNTSB LAX83FA033Accident · No injuriesField investigationFinal reportPiper PA-28R-201T · Coaling, CAThe pilot reported that during flight, the engine started missing, then lost 10 inches of manifold pressure. He immediately positioned the mixture to full rich, switched fuel tanks and started the fuel boost pump, but the engine continued to worsen. Shortly…Nov 11, 1982 · N3035M · DestroyedNTSB FTW83FPM04Accident · 2 fatalFinal reportPiper PA23-250 · 8 Miles Se Bris, OKThe acft departed at 2220 with a planned enroute stop at holdenville, OK. 55 minutes later the acft crashed approximately 8.5 miles from its original departure point. Witnesses describe the wx as very bad due to heavy rain & fog.Nov 11, 1982 · N6145Y · DestroyedNTSB ATL83IA028Incident · No injuriesIncident investigationFinal reportConvair 340 · Greenboro, NCThe pilot stated that while at cruise at 4000 feet that there was a sharp jolt in the airframe and on further investigation discovered that the left engine was on fire. The propeller stopped turning shortly thereafter. Immediately the pilot pulled the…Nov 11, 1982 · N4814C · Minor damageNTSB SEA83FYK01Accident · Serious injuriesFinal reportPiper PA-32-300 · 27ne Rogue Rive, ORAt 9,500 ft the eng failed. The acft impacted a large tree while maneuvering to land on a rural road in heavily forested mountains. Eng examination revealed that the top of the case had a large hole on the rear portion. Pushrod housings were missing from #5 &…Nov 10, 1982 · N656ZM · DestroyedNTSB MKC83LA018Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Anthony, KSWhile returning from a spraying operation the aircraft ran out of fuel and the pilot made an emergency landing. In a field. The pilot stated that after rolling for about 300 feet during the landing, he observed a terrace ahead and applied heavy braking. The…Nov 10, 1982 · N23539 · Substantial damageNTSB FTW83LA035Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Midland, TXThe pilot advised Midland approach control that he was out of fuel over the west side of Midland, TX at 4800 feet. The aircraft was observed to disappear from the radar approximately 1/4 to 1/2 mile north of the airport. The pilot stated he ran the tanks dry.Nov 9, 1982 · N1767X · Substantial damageNTSB FTW83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · El Paso, TXWhile on a business cross country flight the fuel pressure began dropping with a subsequent drop in power. The pilot attempted to reduce manifold pressure to keep the engine running. Approximately 3-5 miles from El Paso airport the pilot landed on the desert.…Nov 9, 1982 · N8705P · Substantial damageNTSB SEA83LA017Accident · No injuriesLimited investigationFinal reportFroehlich M-II · Everett, WAPilot acting as safety pilot for a friend in formation under the hood in another aircraft. He noticed his fuel was low, called his friend and headed for home. When his engine quit 2 miles from paine field he ditched. The aircraft sank and was not recovered.Nov 8, 1982 · N33RF · DestroyedNTSB SEA83FAD01Accident · 2 fatalFinal reportAerospatiale S350D · Starfish, AKWhen the flt arrived at anita bay there were areas of ground fog moving in & out over the logging camp landing sight. The helicopter was observed to fly over the camp & back out across the bay. Shortly after the helicopter was out of sight a noise sounding…Nov 8, 1982 · N3597Q · Substantial damageNTSB MIA83LA026Accident · No injuriesLimited investigationFinal reportPiper J-3 · Near Melbourne, FLPilot made forced landing off airport due to power loss. Landing gear collapsed. No malfunctions found.Nov 8, 1982 · N6875H · Substantial damageNTSB DEN83FA133Accident · 1 fatalField investigationFinal reportCessna 182A · Orderville, UTThe acft crashed in mountainous terrain on a x-country in bad weather. The plt had received a weather briefing which hadincluded the caution that VFR flt was not recommended. Also the acft had no radio so the plt told the briefer to assume him off at 1330…Nov 8, 1982 · N5149D · DestroyedNTSB ATL83LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Birmingham, ALPilot made a hard off airport landing after loss of power. He had used a prolonged slip to lose altitude and the engine stopped. Then he could not reach the runway. The fuel selector was found on left tank. Left tank had less than two gallons of fuel.Nov 8, 1982 · N2633L · Substantial damageNTSB MKC83LA014Accident · No injuriesLimited investigationFinal reportBeech C23 · Des Moines, IAThe pilot executed a forced landing after the engine stopped. The pilot successfully landed the aircraft on a highway, the left wing struck a pole and the aircraft came to rest in a ditch.Nov 7, 1982 · N6012J · Substantial damageNTSB LAX83DA031Accident · No injuriesFinal reportCessna 152 · Marana, AZDuring cruise the aircraft ran out of fuel prior to reaching the pilot's intended point of landing. The pilot attempted a forced landing in the desert. Records indicated the aircraft had flown about 5.3 hours since it was last refueled.Nov 7, 1982 · N69199 · Substantial damageNTSB DEN83LA014Accident · Minor injuriesLimited investigationFinal reportGrumman AA1 · Bicknell, UTThe pilot stated that shortly after departing the Bicknell airport, a strong downdraft forced the aircraft into the ground while approaching the lee side of a ridge line. He indicated the aircraft was at about 100 mph indicated airspeed when ground contact…Nov 7, 1982 · N555AW · DestroyedNTSB ATL83FA025Accident · No injuriesField investigationFinal reportGates Learjet 25 · Elizabeth City, NCAfter the two acft were established at 14,000 ft during a target towing operation, N13MJ(lead acft) maintained straight & level flt on autopilot while N47MJ(chase) came up along the left side to observe the target on the left wing. While moving forward &…Nov 6, 1982 · N47MJ · 2 aircraft · Minor damageNTSB MIA83LA024Accident · No injuriesLimited investigationFinal reportCessna 210 · Near Miami, FLAbout 15 minutes after takeoff the aircraft engine quit. All attempts to restart the engine were unsuccessful and the pilot landed in the everglades swamp. Examination of the aircraft revealed that the fuel manifold valve, PN-631427-A15 was stuck in the…Nov 5, 1982 · N6545X · Substantial damageNTSB MIA83FA022Accident · 6 fatalField investigationFinal reportCessna 172P · Near Myakka Cit, FLThe plt was wx briefed four times prior to departure & again one minute after takeoff at 1821 when he activated his flt plan. He was advised that a cold front was moving se along st. petersburg & tampa, & the area was IMC at the time. At 1916 the plt called…Nov 5, 1982 · N63836 · DestroyedNTSB LAX83LA025Accident · No injuriesLimited investigationFinal reportCessna 150B · Los Angeles, CAAccording to the pilot, the aircraft departed on a cross-country flight with partially filled fuel tanks. Enroute, over the santa monica mountains the engine quit from fuel exhaustion. After hitting a highway sign during the approach, the aircraft landed on…Nov 3, 1982 · N7280X · Substantial damageNTSB FTW83FA298Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Canjilon, NMPrior to departing helena, mt at 1209, the plt received a wx briefing from the great falls fss. The dfw 021240Z area forecast, valid until 0700Z on 11/3/82, was not available. The fss briefer made this deficiency known to the plt & recommended that he receive…Nov 3, 1982 · N8096D · DestroyedNTSB ATL83FA024Accident · No injuriesField investigationFinal reportCessna 210E · Chattanooga, TNThe eng lost power passing 4,000 ft during climbout. The plt immediately reversed course & attempted to reach lovell field. He was unable to reach the rwy & landed in a shopping center parking lot 1 mi short of the rwy. The right wing struck a signpost & the…Nov 3, 1982 · N4958U · Substantial damageNTSB FTW83LA033Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Austin, TXThe pilot penetrated the top of a cumulus cloud while climbing from 18000 to 20000 feet. A sharp jolt was felt and turbulence continued for 3-4 seconds. A stewardess fell and broke her ankle.Nov 2, 1982 · N55SW · No damageNTSB FTW83FA031Accident · 4 fatalField investigationFinal reportCessna P210N · Normangee, TXA company plt received two wx briefings from the san antonio fss, one was at about 1700 the day before the accident & the other on 11/2. After each wx briefing the company plt briefed the plt of the accident acft. The acft departed at about 0835. At 0953 the…Nov 2, 1982 · N612J · DestroyedNTSB ATL83LA023Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Exmore, VADuring flight, the pilot noticed a decrease in oil pressure and elected to land at an alternate airport. While en route, a complete loss of oil pressure occurred and the pilot executed an emergency landing in an open field. While on the landing roll, the…Nov 1, 1982 · N981C · Substantial damageNTSB NYC83FNE01Accident · Serious injuriesFinal reportFairchild M-62A-3 · Durham, CTDuring a climb to a higher altitude the engine failed. The plt attempted a 180 deg turn to land at an arpt but was unable to make it to the arpt. The acft touched down approximately 15 ft before impacting a barn.Oct 31, 1982 · N3983A · Substantial damageNTSB DEN83FTA02Accident · Serious injuriesFinal reportCessna 177 · Hardin, MTThe aircraft had been fully serviced with fuel (48 gal usable supply) and had been flown 1.8 hrs prior to this flight. Reportedly, the pilot had relied on his fuel log and fuel gauges, and did not visually check the fuel quantity during the preflight. While…Oct 31, 1982 · N2824X · DestroyedNTSB LAX83LA023Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Morgan Hill, CAThe purpose of the flight was to perform a biennial flight review. During the preflight, about 1 pint of fuel was drained from the wings/sumps and about 1/2 teaspoon of water was found. After taking off, the power was reduced to about 2500 RPM and 25 inches…Oct 30, 1982 · N2947X · Substantial damageNTSB LAX83FA024Accident · 3 fatalField investigationFinal reportCessna 172N · Panoche, CAAt 1615 on 10/29 the plt obtained a fss wx briefing & filed a VFR flt plan to taft. The plt was advised his trip would be in VFR conditions to taft, but the wx would deteriorate tnto thunderstorms along his route as the evening progressed. The acft arrived in…Oct 30, 1982 · N5223J · DestroyedNTSB FTW83LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ardmore, OKPilot tookoff with prop governor inoperative. While cruising 21 miles south of Ardmore, he began to loose oil pressure and turned toward Ardmore. Engine quit 4 miles from airport. Pilot declared an emergency and descended through the clouds. He went through…Oct 30, 1982 · N29632 · DestroyedNTSB ATL83LA020Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Corinth, MSDuring a VMC cross country flight the pilot encountered low ceilings and rain. The pilot stated that the engine also started running rough and was losing power. At this point he executed a forced landing into trees. The investigation disclosed that serious…Oct 29, 1982 · N5537U · DestroyedNTSB LAX83FVD03Accident · Serious injuriesFinal reportBeech B35 · Linden, CAThe aircraft engine lost power during a night cross-country. The pilot was forced to land in a grove of young walnut trees. The aircraft hit with one wing low and spun around. All motion stopped in a very short distance. An examination revealed that both fuel…Oct 27, 1982 · N5236C · DestroyedNTSB DEN83FTE02Accident · 1 fatalFinal reportCessna 172G · Mack, COWhile on a flt from evanston, WY to glenwood, CO, the plt encountered "cloud to ground" conditins & diverted toward grand junction, CO. He stated that due to a nav problem, he radioed grand junction tower to verify his position. Grand junction had no radar &…Oct 27, 1982 · N5803R · DestroyedNTSB LAX83FA020Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Vallejo, CAAt 1830, the plt received a wx briefing for a flt from fair oaks to san jose, CA with a passenger pickup stop at sacramento, CA. During the briefing, he was told that he ought to be able to make it if he traveled below 4000 ft MSL & left within the next hr.…Oct 25, 1982 · N4583F · DestroyedNTSB CHI83LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe acft had a complete electrical failure & the plt made an emergency landing at Lansing. The plt was unable to lower the flap, & after encountering ground fog landed long, bounced, & ground looped to avoid running off the end of the rwy. Invest of the elect…Oct 25, 1982 · N23388 · Substantial damageNTSB ATL83LA016Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Indian Mound, INApproximately 10 minutes after departure the pilot of N739RJ reported "engine problems." The pilot stated that he tried various power settings and fuel selections without success. He advised fort campbell approach control that he was landing into trees.…Oct 25, 1982 · N739RJ · DestroyedNTSB NYC83FA012Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Dexter, NYThe aircraft made a forced landing going upslope on a river bank following an engine failure. The landing was made just short of an open field. The engine failure occurred at 1404 feet. The power loss was due to failure of crankshaft gear indexing dowel pin.Oct 24, 1982 · N4031W · Substantial damageNTSB DEN83FA010Accident · 2 fatalField investigationFinal reportCessna 320E · Kemmerer, WYThe flt departed big piney at approximately 2200 & was observed to climb straight out from rwy 31 to an estimated 7,800 ft MSL. The acft then turned to a southwesterly heading toward Kemmerer. Shortly thereafter a witness at big pineyheard the plt attempt to…Oct 24, 1982 · N3460Q · DestroyedNTSB FTW83LA019Accident · No injuriesLimited investigationFinal reportNorth American F-51D · Piedmont, OKThe eng failed at 5,500 ft MSL. During an emergency landing at a 5,000 ft dirt strip (under construction for paving), gear extension was delayed to increase glide. The right gear did not have time to lock down & retracted during landing. Initial exam of the…Oct 23, 1982 · N11T · Substantial damageNTSB MIA83LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-39 · N. Ft. Lauderda, FLPilot says he refueled at nassau with 20 gals in aux. Tanks. Estimated 10 gals each main tank. 45 minutes after departure #1 eng. Failed. 5 minutes later #2 failed. Aircraft sank.Oct 22, 1982 · N8856Y · DestroyedNTSB CHI83FA022Accident · 1 fatalField investigationFinal reportCessna R182 · Lemont, ILThe pilot took off at 0642 CDT, and at 0645, he reported level at 4000 ft MSL. At 0659:08, he preported that he was encountering icing conditions and requested a climb to 6000 ft. at 0700:16, after changing from TRACON to center frequency, he was cleared as…Oct 20, 1982 · N736NA · DestroyedNTSB SEA83LA008Accident · No injuriesLimited investigationFinal reportCessna T210M · Ashton, IDDuring a flight from el paso, TX to three forks, MT, the pilot noted clouds below his cruising altitude while crossing the Montana border. When he arrived at his destination, he was above a solid overcast, so he diverted to west yellowstone, MT. During…Oct 18, 1982 · N1982M · Substantial damageNTSB FTW83FA017Accident · 3 fatalField investigationFinal reportBell 206B · Gulf Of MexicoN55AL had departed vermillion block 84 at about 0956 enroute to vermillion block 39 with an ETA of 1010. The plt called at about 1011 stating he would be landing in about 1 minute. N9914K had departed vermillion block 64 at about 1010 enroute to vermillion…Oct 18, 1982 · N55AL · 2 aircraft · DestroyedNTSB CHI83LA018Accident · 2 fatalLimited investigationFinal reportMooney M20E · Sault Ste Marie, MIThe pilot was on a VMC flight plainwell, MI. To Sault st Marie, MI. Prior to and during the flight the pilot obtained weather briefings on conditions relative to his intended route of flight. A witness near the crash site stated the aircraft passed over her…Oct 17, 1982 · N9192V · DestroyedNTSB FTW83LA016Accident · Minor injuriesLimited investigationFinal reportVolksplane VP-2 · Houston, TXAfter taking off, the pilot flew back by the airport and then began to climb again. While climbing through about 700 ft, the engine lost power. The pilot was unable to reach the airport. During a landing, he cleared over an area with trees but struck a power…Oct 16, 1982 · N3SW · Substantial damageNTSB MKC83LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Topeka, KSOn a flight from poplar bluff, MO to Topeka, KS, the pilot encountered headwinds. About 4 to 5 miles from his destination airport, the engine lost power. The aircraft was damaged during a forced landing in a plowed field between 2 north-south power lines.…Oct 15, 1982 · N757JT · Substantial damageNTSB CHI83FA014Accident · 1 fatalField investigationFinal reportBeech A24R · Lansing, MIWitnesses observed the acft flying in an easterly direction, level but in a slightly descending flight path. No smoke, flame or parts falling from the acft were observed. The eng sound was steady & loud. The descent continued at a shallow angle until impact.…Oct 11, 1982 · N24639 · DestroyedNTSB SEA83FYM01Accident · 1 fatalFinal reportBellanca 7GCBC · 1/4nm S. Of Peo, ORThe pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water.Oct 10, 1982 · N57457 · Substantial damage