OpenAirDocs.org

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 CHI89LA002Accident · No injuriesLimited investigationFinal reportCessna 152II · Ashland, OHWhile enroute on a cross country flight from buffalo, new york to mansfield, Ohio, the aircraft experienced a total loss of engine power. The pilot performed emergency procedures and executed a forced landing in a farmer's open field. The pilot stated that…Oct 9, 1988 · N49135 · Substantial damageNTSB MIA89LA007Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Flora, MSAfter dispensing a chemical load, the plt was rtrng to re-load when the eng began running rough. He said he noted the fuel flow was erratic, so he turned on the boost pump. The eng stabilized momentarily, then smoke entered the cockpit & the eng began…Oct 8, 1988 · N2896J · DestroyedNTSB FTW89LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Navasota, TXAcft struck a tree during a night forced landing following an eng failure in cruise flt. The eng failure was caused by fuel exhaustion. The flt had been airborne for 4 hours and 44 minutes; however, the plt had calculated that he had sufficient fuel to make…Oct 8, 1988 · N51112 · Substantial damageNTSB DEN89LA012Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pueblo, COThe commercial plt & his pvt plt wife were flying x-country on vacation. While en route, the eng began running rough & lost power. Drg an emergency dscnt, the plt restarted the eng & initiated a climb to select a better lndg site, but the eng lost power…Oct 8, 1988 · N102EC · Substantial damageNTSB CHI89FA005Accident · Minor injuriesField investigationFinal reportPiper PA-28 · Schaumburg, ILEngine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence.Oct 8, 1988 · N4608R · DestroyedNTSB ATL89FA006Accident · 1 fatalField investigationFinal reportCessna 210N · Alexander City, ALThe airplane crashed about 2 mi short of the destination arpt. Witnesses reported that it impacted nose down after clearing trees; no engine sounds were heard. According to rescue personnel, the plt indicated that there were no engine or other mechanical…Oct 7, 1988 · N6510N · Substantial damageNTSB MIA89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · La Belle, FLThe pilot while on a ferry permit flight experienced a failure of the #4 cyl of the left engine and did not attain the vyse speed and the aircraft started to descend. The pilot ditched the aircraft in a lake and it was not recovered. No records on the engines…Oct 6, 1988 · N6815Y · Substantial damageNTSB FTW89DRG01Accident · No injuriesFinal reportShamgaugh Pitts Special · San Benito, TXImproper torquing of the 'b' nut fitting on the main fuel supply line to the powerplant at the firewall and the pilot's inadequate pre-flight inspection.Oct 6, 1988 · N3S · Substantial damageNTSB DEN89LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Price, UTThe pilot was performing a business flight over mountainous terrain. About 1 hr into the flight, he noticed smoke or oil vapor in the cockpit. He saw oil on the lower cowling and wing and communicated his position and problem to the salt lake city ARTCC. The…Oct 6, 1988 · N7335N · Substantial damageNTSB DEN89FA007Accident · 3 fatalField investigationFinal reportMooney M20E · Walsh, COThere is no record plt obtained wx briefing, filed flt plan, or obtained in-flt wx advisories. Plt and two pax departed san marcos, TX, at 1400 CDT in VMC, enroute to springfield, CO. Acft was seen by two witnesses at aprx 1630 MDT, 11 mi w of Walsh, CO,…Oct 5, 1988 · N5997Q · DestroyedNTSB DEN89LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally II · Rio Rancho, NMThe commercial balloon plt and one pax were participating in a balloon fiesta. The acft took off from albuquerque, on a local flight in calm winds. At altitude, the balloon encountered south winds that carried the balloon to Rio Rancho, where a landing was…Oct 4, 1988 · N4098G · Substantial damageNTSB LAX89LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Palmdale, CAAt approximately 6000 ft MSL two airplanes collided in flight. N49382 was climbing to altitude, N31386 was descending in a shallow left turn. The airplane descending colliding with the climbing airplane from behind and to the right. Both airplanes were able…Oct 2, 1988 · N31386 · 2 aircraft · Substantial damageNTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…Oct 2, 1988 · N6176K · Substantial damageNTSB ATL89FA004Accident · 1 fatalField investigationFinal reportPiper PA-30 · La Follette, TNThe pilot reported an autopilot problem and was not able to maintain control of the airplane. The airframe components were scattered in a circular pattern. All fractures displayed overload failures. The wreckage examination failed to disclose any system or…Oct 2, 1988 · N7484Y · DestroyedNTSB SEA89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Fork, IDThe pilot flew the aircraft into a box canyon at dawn. The aircraft was unable to outclimb rising terrain. The aircraft impacted heavily wooded terrain at a slow airspeed at 8,000 feet MSL about 50 yards short of the crest.Oct 1, 1988 · N7548R · DestroyedNTSB MKC88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Harrison, ARWhile in normal cruise flt, the plt declared an emergency. He stated the eng had failed & that he thought it had 'thrown a rod.' Subsequently, the acft was extensively damaged drg an emerg landing in a wooded area. An investigation revealed the #6 connecting…Oct 1, 1988 · N3943S · Substantial damageNTSB MIA89LA002Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Fort Lauderdale, FLThe plt stated that aprx 15 minutes after takeoff from Fort Lauderdale, the eng quit completely & he was unable to make it back to the arpt. While attempting a forced landing in a field, he landed nose down, the nose gear collapsed, and the acft slid to a…Oct 1, 1988 · N8076R · Substantial damageNTSB ATL89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monroeville, ALAccording to the plt, he had requested the acft be fully svcd with fuel before takeoff; however, he did not visually check the fuel. He rprtd that after takeoff, he had flown about 50 min when he noted the rgt tank, which he was using, indcd empty. He said he…Oct 1, 1988 · N100J · DestroyedNTSB CHI88FA248Accident · 2 fatalField investigationFinal reportCessna 210L · Monroe, WISep 30, 1988 · N5268V · DestroyedNTSB SEA88LA189Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Toledo, WAThe plt took off from an uncontrolled strip in marginal wx conds, believing he could affect a departure to good VFR conds. Shortly after takeoff, he enctrd solid IMC & momentarily lost control of the acft. After regaining control & having lost altitude, he…Sep 25, 1988 · N1047Y · Substantial damageNTSB ATL88LA255Accident · No injuriesLimited investigationFinal reportCessna 150 · Bessemer City, NCThe pilot reported that he had observed a cloud layer forming along his flt route. At about the same time, the acft VOR rcvr failed. The plt elected to continue vfr-on-top to his planned destination based on VFR wx reported by an ATIS broadcast from an arpt…Sep 25, 1988 · N7831E · Substantial damageNTSB SEA88LA183Accident · 1 fatalLimited investigationFinal reportCessna 150L · Hadlock, WAThe recently certificated pilot departed on a two hour round-robin flight to attend a meeting and was advised to expect fog on return. The aircraft was flown for one hour prior to this flight and was not refueled. No record of a wx brief was found. Prior to…Sep 22, 1988 · N11582 · DestroyedNTSB NYC88FA238Accident · Serious injuriesField investigationFinal reportde Havilland DH-7-58C · Albany, NYThe acft experienced an uncontained disintegration of the no.2 engine. Scorched engine fragments ripped through the fuselage injuring two passengers, one seriously. The uncontained failure was the result of wear or spalling of the 1st stage reduction gear and…Sep 22, 1988 · N170RA · Substantial damageNTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…Sep 22, 1988 · N6022C · DestroyedNTSB DEN88LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kerrville, TXThe commercial plt was 6 miles from his ranch and noted smoke in the cockpit, accompanied by a rough running engine. He turned back to the ranch for a forced landing. He overflew the landing area, decided he was too high for landing and turned for another…Sep 22, 1988 · N3621K · DestroyedNTSB ATL88LA253Accident · No injuriesLimited investigationFinal reportCessna 150G · Luverne, ALThe plt reported that he was flying at about 7-800 ft AGL while inspecting timber for insect damage when the engine suddenly lost power. He could not recover enough power to sustain flt, so he selected a pasture for his impending forced ldg. He reported that…Sep 22, 1988 · N3772J · Substantial damageNTSB NYC88IA246Incident · Minor injuriesIncident investigationFinal reportBoeing 747-100 · Georgetown, GuyanaIncident that led to the death of the passenger in row #6 was apparently not related to turbulence, because the passenger died of choking two hours after the turbulence encounter.Sep 21, 1988 · N9674 · No damageNTSB MKC88FA175Accident · 1 fatalField investigationFinal reportCessna 310R · Latimer, IAThe pilot had completed his normal flight schedule and was assigned an additional trip from des moines, Iowa to st paul, Minnesota. Calculations show that the pilot had flown an estimated 5 hours in the 8 1/2 hours preceding the accident. The line attendant…Sep 21, 1988 · N36HD · DestroyedNTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…Sep 21, 1988 · N7015C · DestroyedNTSB LAX88LA326Accident · No injuriesLimited investigationFinal reportCessna 172L · Banning, CADuring a crosscountry flt, while enroute from lake havasu city, AZ, to Banning, CA, the engine experienced a loss of power. The airplane collided with the terrain after a forced landing. Inspection of the fuel system revealed there was no fuel on board.Sep 20, 1988 · N7233Q · Substantial damageNTSB DEN88FA213Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Curtin, OROn 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had…Sep 20, 1988 · N3863P · DestroyedNTSB SEA88LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Bend, ORAt aprx 1239 PDT, while on an IFR x-country flt at 14,000', the acft enctrd icing conds. Drg the next 1.4 hrs, the plt changed altitude in increments, climbing to 17,000', then descending to 11,000' to avoid icing. At aprx 1411 PDT, he indcd the eng had lost…Sep 19, 1988 · N8765P · DestroyedNTSB LAX88LA324Accident · No injuriesLimited investigationFinal reportRobinson R22-HP · Yosemite, CAThe pilot was flying in high terrain at 10,000 ft MSL when he noticed his airspeed had dropped to 0. He stated that he had encountered a strong tailwind and he lost control of the helicopter. The helicopter collided with the terrain in an uncontrolled…Sep 19, 1988 · N9077N · Substantial damageNTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…Sep 18, 1988 · N47806 · DestroyedNTSB CHI88FA237Accident · 2 fatalField investigationFinal reportCessna 182RG · Zanesville, OHThe pilot's poor judgement/decision-making, and his over confidence in his own ability which led to his repeated decisions to operate his aircraft in adverse weather conditions. The fact that the pilot had operated the aircraft in adverse weather conditions…Sep 18, 1988 · N9877C · DestroyedNTSB CHI88DEG01Accident · No injuriesFinal reportPiper PA-22-160 · Jackson, OHWhile in cruise flight, the eng began running rough & would not produce enough power to maintain level flt. The plt selected a pasture for an emergency landing. Just before landing, the acft struck & severed a transmission line. It then brushed a treetop &…Sep 18, 1988 · N9053D · Substantial damageNTSB SEA88LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cottage Grove, ORWhen plt realized strong headwinds at cruise alt would preclude reaching intended destination, he attempted to divert to another alternate. Fuel exhaustion occurred before reaching arpt. During a lndg, executed in dark, acft collided with a fence.Sep 17, 1988 · N1223T · Substantial damageNTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.Sep 17, 1988 · N6586J · DestroyedNTSB DEN88IA207Incident · No injuriesIncident investigationFinal reportBeech 1900 · Denver, COSep 17, 1988 · N32017 · Minor damageNTSB LAX88LA322Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, CADuring an external load operation, there was an indication of high torque and the oil chip light illuminated. The engine lost power and the pilot initiated an autorotation. The helicopter collided with the sloping terrain and rolled over. Inspection of the…Sep 16, 1988 · N9110F · Substantial damageNTSB ANC88LA138Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Mcgrath, AKWhile cruising, the pilot-in-command experienced a rough engine and finally an unexplained power reduction to idle. He was unable to glide the float equipped airplane to a body of water and executed a forced landing on the tundra where the airplane sustained…Sep 16, 1988 · N98JH · Substantial damageNTSB MKC88LA174Accident · No injuriesLimited investigationFinal reportBeech A23 · Davenport, IAThe PIC said there was a loud metallic explosion in the engine compartment. When the acft was about 7 miles from the destination apt and beginning a descent. The aircraft began vibrating violently and the windshield became covered with engine oil. Attempts…Sep 15, 1988 · N6917Q · Substantial damageNTSB MIA88LA268Accident · No injuriesLimited investigationFinal reportCessna 177 · Polk City, FLPlt failed to insure acft had adequate fuel supply for flt. The engine failed due to fuel exhaustion and a forced landing was made in a field. The plt said that he experienced stronger than expected head winds. Post acc invest revealed that the acft fuel…Sep 15, 1988 · N2357Y · Substantial damageNTSB DEN88IA204Incident · No injuriesIncident investigationFinal reportCessna 206 · Glade Park, COThe failure of the #1 connecting rod assembly in the engine, resulting in a forced landing. A factor in the incident was that the pilot did not see & avoid power wires in the forced landing path.Sep 15, 1988 · N71001 · No damageNTSB ATL88LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Covington, TNThe plt reported that the engine suddenly began to run rough and backfire during a pipeline patrol flight at 300 ft AGL. The roughness worsened and the plt made a forced ldg on a dirt road. During rollout, one of the wings caught vegetation bordering the road…Sep 15, 1988 · N2833M · Substantial damageNTSB LAX88LA317Accident · No injuriesLimited investigationFinal reportCessna 150L · Salinas, CADuring a cross-country flt, while descending to the arpt, the engine lost power. The airplane collided with the terrain and nosed over. Inspection of the fuel system revealed there was no fuel on board.Sep 14, 1988 · N6804G · Substantial damageNTSB CHI88DEP12Accident · 1 fatalFinal reportPiper PA-36-300 · Pulaski, WIThe aircraft descended at a high rate of speed, 75 degrees nosedown, into the terrain. His widow stated that the pilot had left home at approximately 2100 CST on the accident night, in an inebriated condition. After a discussion about his drinking, he…Sep 14, 1988 · N57847 · DestroyedNTSB MKC88FA171Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Goodman, MOEngine ignition and lubrication problems which resulted in the pilot's election to execute a precautionary landing. A contributing factor was the pilot's inability to see and avoid power lines in his approach path due to bright sunshine.Sep 13, 1988 · N3533N · Substantial damageNTSB DEN88FA202Accident · 1 fatalField investigationFinal reportBeech 200 · Jackson, WYThe plt and his two pax had just arrived at the Jackson hole airport (jax) approximately 30 minutes prior to the accident. The plt dropped off his pax and stepped into operations for a short break. He then returned to the acft by himself for a return flt to…Sep 12, 1988 · N1283 · DestroyedNTSB ANC88LA135Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKThe private pilot and his son were returning from a hunting trip when the airplane ran out of fuel. The pilot attempted an emergency landing on an unlighted roadway and struck a telephone wire or small powerline during the approach. The airplane landed hard…Sep 12, 1988 · N3059G · Substantial damage