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 ATL82IA042Incident · No injuriesIncident investigationFinal reportBeech B200 · Atlanta, GAWhile at cruise with recommended power settings, the left engine oil pressure and torque indications began fluctuating and dropping. As the power lever was retarded a popping sound was heard and the engine was shut down. A precautionary landing was made in…Jan 29, 1982 · N1851S · No damageNTSB DEN82DA024Accident · Minor injuriesFinal reportHughes 369D · 10mi. Nw Walsen, COThe helicopter was flying 200-300 AGL over 8,000 ft terrain elevation at 80 knots. The plt reported encountering wind gusts slowing his ground speed to zero. The acft then started a rapid vertical descent while still indicating 80 k. the plt attempted to…Jan 26, 1982 · N58214 · Substantial damageNTSB ANC82FA017Accident · Minor injuriesField investigationFinal reportCessna 152II · Anchorage, AKWhile descending to about 3000 ft the student pilot stated that the engine started sputtering. Since the fuel gages read empty he attempted a landing at sky harbor/o'malley airstrip but came in high on the initial approach. As he maneuvered for another…Jan 25, 1982 · N4825B · Substantial damageNTSB ANC82DAG16Accident · 2 fatalFinal reportCessna 182M · Bethel, AKThe pilot filed a VFR, round robin, flight plan. When the time on the flight plan had elapsed, a search was initiated. Later, the plane was found where it had crashed on a frozen lake surrounded by low terrain. An examination of the wreckage revealed that the…Jan 25, 1982 · N71734 · DestroyedNTSB CHI82FA032Accident · 1 fatalField investigationFinal reportBeech A23A · London, OHThe pilot received two weather briefings for a flight from columbus to springfield, Ohio. VFR flight was not recommended. The pilot took off after the tower closed at 2300 EST. At about 2341 a witness near the crash site heard the loud sound of an aircraft…Jan 24, 1982 · N6940Q · DestroyedNTSB ATL82DA040Accident · No injuriesFinal reportCessna 177 · Athens, GADuring an enroute refueling stop on 1/21 the pilot noticed fuel leaking around the left tank cap. After arriving at sanford the acft was refueled with appx 50 gals & a local flight of about 12 min was flown. The acft has a usable fuel capacity of 59 gals. The…Jan 24, 1982 · N34975 · Substantial damageNTSB LAX82FA050Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · 10nm N. Of Mcna, AZWhile on a cross country flight the pilot flew into weather which included severe to moderate icing conditions. Although the weather was forecast for the intended route of flight in a SIGMET it was not provided to the pilot during the initial weather…Jan 22, 1982 · N41664 · DestroyedNTSB ATL82IA041Incident · No injuriesIncident investigationFinal reportDassault/Sud Falcon 20 · Louisville, KYDuring a cruise descent from FL 330 in clear air (RAT-22 deg c) a double engine flameout occurred. Pwr had been adjusted to 86 pct with engine anti-ice on prior to the descent. When the throttles were advanced at FL 220, there was no engine response.…Jan 22, 1982 · N18FE · No damageNTSB SEA82FA032Accident · 4 fatalField investigationFinal reportCessna P210N · Boise, IDAfter takeoff while climbing through 10,000 ft MSL the pilot declared an emergency. The pilot stated he was having vacuum problems and was on partial panel. Salt lake city ARTCC answered his request for guidance to a VFR landing with no gyro vector…Jan 21, 1982 · N4947K · DestroyedNTSB LAX82FA045Accident · 3 fatalField investigationFinal reportCessna 182N · Escondido, CABefore takeoff, the pilot received a complete weather briefing. The briefer warned him that the weather system in southern California was extremely hazardous and advised him several times not to go. The briefing included numerous pilot reports that confirmed…Jan 21, 1982 · N92387 · DestroyedNTSB LAX82FA048Accident · 2 fatalField investigationFinal reportBeech 58 · Cherry Valley, CAAt 0702 the plt received a weather briefing for a VFR flight to fresno. The area forecast contained flight precautions for obscured mountains & IMC in the sierra nevadas, and occassional moderate icing below 15,000 ft. the flight departed at 0728. The…Jan 20, 1982 · N9395Q · DestroyedNTSB DEN82FTA09Accident · 1 fatalFinal reportCessna 177B · Wolf Pt., MTThe pilot reported that he encountered a snow squall while cruising at 5000 ft MSL on a VFR flight plan at night. He stated that he descended to 4000 ft MSL to try to get under the squall and continue. He was unable to remember what happened after descending…Jan 20, 1982 · N35147 · DestroyedNTSB ATL82IA038Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Washington, DCAircraft was being ferried to Washington, DC following rework in toronto, Canada. During letdown in IFR conditions and moderate icing, pilot noticed a glow on the right wing. As he leaned over to check it, the right engine fire warning light and fire bell…Jan 20, 1982 · N9240N · Minor damageNTSB NYC82DA024Accident · No injuriesFinal reportCessna 152 · Enfield, NHWhile the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…Jan 19, 1982 · N68292 · Substantial damageNTSB MKC82DA018Accident · Minor injuriesFinal reportCessna 182P · Topeka, KSDuring an aerial line patrol flight the pilot encountered low stratus clouds and started to return to billard airport when the engine ceased to operate. The pilot attempted to restart the aircraft but could not. A forced landing was made into a mowed pasture…Jan 19, 1982 · N52757 · Substantial damageNTSB MKC82DA017Accident · No injuriesFinal reportCessna 177RG · Urbandale, IAAfter takeoff, the engine lost power at about 2000 ft MSL. The plane was damaged during a forced landing on an interstate highway. When checked after the accident, the engine would start but lost power when accelerated above 1000 RPM. The bendix servo fuel…Jan 19, 1982 · N1969Q · Substantial damageNTSB LAX82FUJ26Accident · Minor injuriesFinal reportBeachner Quick Silver · Kingman, AZAfter climbing up to pattern altitude the engine lost power. The pilot made a turn back towards the airport while trying to restart the engine but had to land in an old B-17 parking area. The aircraft struck a fence and ditch during rollout and nosed over.…Jan 19, 1982 · N824CB · Substantial damageNTSB CHI82DA056Accident · No injuriesFinal reportCessna 340A · Near Lansing, MIDuring flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…Jan 19, 1982 · N4140G · Substantial damageNTSB SEA82FYM08Accident · Serious injuriesFinal reportBeech C23 · Orchards, WADuring a descent with the carburetor heat on, the pilot added power 2 times to verify the engine performance. No difficulty was noted. However, when the throttle was advanced to level off at 1800 ft MSL, the engine sputtered and lost power. The pilot was…Jan 18, 1982 · N2127W · DestroyedNTSB LAX82FA047Accident · 1 fatalField investigationFinal reportCessna 172M · Downieville, CAThe aircraft departed yuba city about 1030 PST after the pilot received a partial weather briefing from the marysville flight service station in which VFR flight was not recommended. Radar plots on the aircraft indicate a non-linear flight path from the…Jan 18, 1982 · N5295R · DestroyedNTSB ATL82FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Blairsville, GAThe aircraft departed atlanta, GA on a flight with no flight plan to an intended final destination of morristown, TN. However, during a weather briefing, the pilot had inquired about the tri-cities airport at bristol, TN. While en route, the aircraft crashed…Jan 18, 1982 · N4583J · DestroyedNTSB FTW82FA041Accident · 1 fatalField investigationFinal reportBell Helicopter 206L-1 · Houma, LAThe acft was enroute to the ship shoal area in the gulf of Mexico. Another plt who departed earlier advised the plt that he & another acft had turned around & was returning after encountering a low ceiling & reduced visibility. The surviving pax stated that…Jan 16, 1982 · N1081H · DestroyedNTSB DEN82FA018Accident · 3 fatalField investigationFinal reportCessna T210N · 28 Mi Ene Ogden, UTDuring an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…Jan 16, 1982 · N6520Y · DestroyedNTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…Jan 14, 1982 · N47442 · Substantial damageNTSB MIA82DA033Accident · No injuriesFinal reportGrumman AA5B · Monticello, FLAfter being denied a special VFR clearance to land at tampa-st. petersburg the pilot elected to cancel his flight plan to tallahassee and fly to new orleans. About 5 1/2 hours into the flight he decided to divert to gulfport, ms and tuned in the gulfport VOR…Jan 13, 1982 · N28607 · DestroyedNTSB CHI82IA026Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Chicago, ILThe aircraft had departed boston on a scheduled flight with the #1 generator placarded inoperative and noted in the minimum equipment list. En route to los angeles, CA at FL 350, about 80 mi northeast of bay city, MN., the crew noted a simultaneous loss of #2…Jan 13, 1982 · N31031 · No damageNTSB FTW82FPA10Accident · Serious injuriesFinal reportBeech P35 · Addison, TXThe aircraft was attempting to go around from an ILS approach when the pilot made visual contact with the runway. The pilot attempted to land, stalled the aircraft, and dropped to the runway. Ice had accumulated on the leading edge of the wings, the tail, and…Jan 12, 1982 · N8678M · Substantial damageNTSB ATL82FKQ09Accident · Minor injuriesFinal reportCessna 414 · Aberdeen, MSThe non-instrument rated pilot crashed about 3 hrs after taking off with 4 1/2 hours of fuel on board. He crashed while attempting an off-airport landing in a large field. The field was located less than half way to his destination. The sheriff reported…Jan 12, 1982 · N7706 · DestroyedNTSB DEN82FTI10Accident · Serious injuriesFinal reportPiper PA-28-140 · Near Bozeman, MTThe pilot was on an early morning flight over mountainous terrain at 8500 feet. While inbound to his destination, he encountered an area of restricted visibility with snow. As he started a right turn to correct to his desired course, his passenger alerted him…Jan 11, 1982 · N7273J · DestroyedNTSB ATL82FA032Accident · 1 fatalField investigationFinal reportMooney M20G · Henderson, NCThe pilot and his wife were at 6000 ft on a VFR cross-country when he became unconscious. The aircraft was equipped with a wing leveler and continued in level flight while the pilot's wife attended to him. When the pilot's wife could do nothing more for him,…Jan 10, 1982 · N3688N · DestroyedNTSB ANC82DA013Accident · Minor injuriesFinal reportCessna U206 · Quinhagak, AKEnroute the center seat passenger unfastened his seat belt and crawled up between the two front seats. While approaching Quinhagak the pilot had difficulty making the passenger return to his seat. After finally getting the passenger settled down he turned…Jan 10, 1982 · N756YN · Substantial damageNTSB NYC82DA019Accident · No injuriesFinal reportCessna 152 · Cutchogue, NYAfter experiencing a partial loss of engine power in flight, the instructor took control of the aircraft. He applied carburetor heat, and headed back toward the airport. There was a gradual loss of power and the instructor elected to land in an open field.…Jan 8, 1982 · N46681 · Substantial damageNTSB DEN82FA016Accident · 2 fatalField investigationFinal reportCessna 210 · Helena, MTThe aircraft crashed into a mountain at the 9300 foot level. The pilot was on course for his destination. The minimum obstacle clearance altitude for his location was 10,800 feet. Weather was not a problem but the accident did occur during hours of darkness.…Jan 7, 1982 · N9763X · DestroyedNTSB LAX82FUM06Accident · 3 fatalFinal reportNavion A · Ramona, CAThe accident occurred during the final leg of a "share the expenses" commuting flight from hawthorne to romona, CA, when the aircraft collided with the southwest face of mount woodson. Marginal VFR conditions prevailed over the route of flight. During the…Jan 6, 1982 · N4520K · DestroyedNTSB LAX82DVA10Accident · Serious injuriesFinal reportBoeing A75 · Near Bakersfiel, CAThe pilot was enroute to las vegas, Nevada for a banner towing operation. As he proceeded eastbound along highway 58, he encountered fog that was forming in the tehachapi foothills. He initiated a 180 degree turn to go back, but inadvertently entered IFR…Jan 6, 1982 · N59737 · Substantial damageNTSB DEN82DA015Accident · No injuriesFinal reportBeech 35 · Jackson, WYThe temperature was approximately a minus 15 degrees fahrenheit. The pilot reported the engine was preheated for 30 minutes and that everything was in the green before takeoff. Shortly after takeoff, the engine began to overspeed. The pilot throttled back and…Jan 6, 1982 · N8070Q · Substantial damageNTSB SEA82FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Pleasant Hill, ORThe plane tookoff at 1505 PST on a local VFR pleasure flight with 4 occupants and about 48 gallons of fuel on board. The plane was estimated to be about 140 lbs over the maximum gross weight limit. At about 1622 PST, it was observed to break up in flight.…Jan 5, 1982 · N8265A · DestroyedNTSB LAX82FA038Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Near Las Vegas, NVThe aircraft, a Piper PA-34, was on a VFR flight to transport bank checks on a part 135 operation. Another company pilot in a Cessna 207 stated that he encountered instrument conditions at 9500 ft while he was flying from tonopah to las Vegas, NV. The Cessna…Jan 5, 1982 · N1956H · DestroyedNTSB LAX82FA036Accident · 1 fatalField investigationFinal reportPiper PA-22 · Black Canyon Ci, AZThe wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.Jan 5, 1982 · N4696Z · DestroyedNTSB FTW82DA037Accident · Serious injuriesFinal reportPiper PA-24-250 · Lonoke, ARThe pilot stated that the engine failed at 2000 ft as he was descending for an approach. He switched the fuel selector from the right tank to the left tank, turned on the boost pump, and pumped the throttle but the engine failed to start. The aircraft landed…Jan 5, 1982 · N5304P · Substantial damageNTSB ATL82IA029Incident · No injuriesIncident investigationFinal reportRockwell 114 · Pensacola, FLPilot advised approach control that he smelled smoke and had erratic engine instrument readings when 20 miles from destination. The gear was extended and three green lights observed but shortly afterwards the warning light and horn activated. During the…Jan 5, 1982 · N5782N · Minor damageNTSB ATL82DA028Accident · No injuriesFinal reportPiper PA-28R-200 · Gastonia, NCDuring flight, the engine surged and the propeller speed went to 3000 RPM. The pilot retarded the prop control, and maintained 2400 RPM. He proceeded to the Gastonia airport and landed without further incident. A ground run-up was made and all instruments and…Jan 5, 1982 · N2139T · Substantial damageNTSB LAX82FA040Accident · 2 fatalField investigationFinal reportGrumman AA-5B · 10 Nm W Lee Vin, CAWhile on the ground the pilot was refused a route over the sierra mountains, after departure the pilot requested and was given a change in his flight plan that cleared him over the mountains. At 1654 the pilot advised oakland center that he was climbing…Jan 4, 1982 · N28912 · DestroyedNTSB FTW82DA035Accident · Minor injuriesFinal reportPiper PA-28R-200 · Estancia, NMThe pilot stated he experienced an engine stoppage in flight and attempted to land on a dirt road. Both fuel tanks were found empty and a total of 3 to 4 ounces of fuel was drained from the aircraft fuel system.Jan 4, 1982 · N32335 · Substantial damageNTSB CHI82FA019Accident · 2 fatalField investigationFinal reportCessna T337G · Fort Wayne, INOn 1/31/83 at 2134 CST, the acft departed grand island, NE on an IFR flt plan to toledo, OH, with appx 125 gal of fuel on board. While en route, the plt received updated wx for toledo. At that time, the toledo wx was indefinite 100 ft obscd, vis 1-1/2 mi with…Jan 4, 1982 · N2CU · DestroyedNTSB MIA82DA030Accident · Minor injuriesFinal reportCessna 210L · Cocoa, FLUpon arriving in the vicinity of the destination airport the pilot started to reduce power in preparation for the descent when he observed that the engine experienced a power loss. All attempts made to restore power on the engine were to no avail and the…Jan 3, 1982 · N94252 · Substantial damageNTSB MIA82DA029Accident · Minor injuriesFinal reportNorth American Navion L-17B · Jacksonville, FLThe flight experienced engine roughness and a drop in oil pressure while in instrument weather conditions. The pilot elected to make a precautionary landing and was vectored to runway 7. The prevailing weather was sky obscured, ceiling and visibility zero.…Jan 2, 1982 · N3906K · Substantial damageNTSB MIA82DA028Accident · No injuriesFinal reportSmith WCS-222 (Bell 47G) · Miami, FLDuring flight, the engine lost power and fire erupted on the engine compartment. Subsequently, the engine driven hydraulic boost for the flight control system became inoperative. The pilot was flying over a populated area. During his forced landing, he was…Jan 2, 1982 · N23BS · Substantial damageNTSB FTW82FRJ07Accident · Minor injuriesFinal reportBellanca 17-30A · Homer, LADuring an IFR flight at 5000 ft MSL, the engine began running rough. The pilot attempted to restore power, but eventually, the engine began to windmill with no apparent thrust. Unable to maintain altitude, the pilot descended through a cloud layer and broke…Jan 2, 1982 · N14779 · DestroyedNTSB FTW82FPJ10Accident · 1 fatalFinal reportNavion A · Chickasha, OKThe aircraft departed from a private airport 2 miles south of Chickasha at 0330. At 0336 power was interrupted on electric power lines southwest of Chickasha. The wreckage was found 6 miles south and 4 and 1/2 miles west of Chickasha a few feet west of a 35…Jan 2, 1982 · N4876K · Destroyed