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 MIA88LA198Accident · No injuriesLimited investigationFinal reportHughes 369D · Horn Lake, MSBfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the…Jun 19, 1988 · N1109P · Substantial damageNTSB SEA88FA113Accident · Minor injuriesField investigationFinal reportBeech 58P · Bellevue, WAThe plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the…Jun 18, 1988 · N17795 · DestroyedNTSB NYC88LA169Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Copake Falls, NYDuring a practice autorotation to an open field, the aircraft struck a wire that had not been observed. An attempt to fly over the wire was unsuccessful and the tail rotor and aft 1/3 of the tail cone was severed from the helicopter. A hovering autorotation…Jun 18, 1988 · N622SC · Substantial damageNTSB BFO88LA055Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Capon Bridge, WVLoss of power because of carburetor ice which obstructed airflow to the engine. The aircraft nosed over on landing because of soft terrain and high grass. The pilot's failure to use carburetor heat is a contributing factor.Jun 18, 1988 · N1841E · Substantial damageNTSB NYC88FA166Accident · 2 fatalField investigationFinal reportBell 206L-1 · Springtown, PAWhile in cruise flight, ground witnesses observed the helicopter make two violent roll maneuvers followed by an in-flight breakup. Aircraft wreckage was spread over an area of approximately 10 acres. Examination of the wreckage revealed that the collective…Jun 17, 1988 · N114FH · DestroyedNTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…Jun 17, 1988 · N7499G · Substantial damageNTSB SEA88LA110Accident · Minor injuriesLimited investigationFinal reportAeronca O58B · Bremerton, WADuring cruise, eng lost power. Plt attempted to restore power with no success; eng power was surging but less than enough to sustain flight. Forced landing was executed into rough terrain. Inspection revealed fuel selector deteriorated by age and use. The…Jun 15, 1988 · N49203 · Substantial damageNTSB NYC88LA165Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Wantagh, NYThe pilot was on a return VFR flight to republic airport after having repairs performed on the aircraft. The pilot stated that he experienced an engine power loss and prepared for an emergency landing with the gears retracted. The aircraft landed between two…Jun 14, 1988 · N6110V · Substantial damageNTSB DEN88LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rifle, COThe student plt was flying a x-country training flt. The flt was not on the planned route. The plt flew into a box canyon too narrow to complete a turn and could not climb fast enough to clear the terrain at the end of the canyon. The pilot attempted a turn…Jun 14, 1988 · N2262E · Substantial damageNTSB LAX88LA222Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Palm Springs, CAPilot misjudged the altitude of the mountain peak.Jun 12, 1988 · N43310 · DestroyedNTSB LAX88LA221Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Fremont, CADuring a local flt, the glider encountered a windshear and lost altitude. The pilot was unable to regain the lost altitude and a forced landing was made where during the landing roll the glider collided with rough terrain.Jun 12, 1988 · N103BK · Substantial damageNTSB FTW88FA119Accident · 4 fatalField investigationFinal reportCessna 205 · Elgin, TXThe pilot radioed that he was running out of fuel while being vectored for landing. The ceiling was about 900 feet with 5 miles visibility and the accident occurred in a level grass field. Witnesses heard the engine cutting out and a loss of control occurred…Jun 10, 1988 · N8181Z · DestroyedNTSB LAX88DVA06Accident · Minor injuriesFinal reportCraven Teenie TWO · Fowler, CADuring cruise flight, the pilot reported a loss of oil pressure. The engine then sputtered and quit. The pilot initiated a forced landing where the airplane collided with several wooden crates short of the intended ldg area. Inspection of the engine revealed…Jun 9, 1988 · N6052 · DestroyedNTSB ATL88FA191Accident · 1 fatalField investigationFinal reportCessna 421B · Knoxville, TNJun 9, 1988 · N700SC · DestroyedNTSB SEA88LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Wenatchee, WAAirframe ice was accumulating on the aircraft at 13,000 feet so the pilot requested an altitude of 14,000 feet. At 14,000 feet the pilot lost control of the aircraft and descended down to 6,500 feet before recovering. The pilot had stated that he felt he had…Jun 8, 1988 · N7243X · Substantial damageNTSB LAX88LA216Accident · No injuriesLimited investigationFinal reportCessna 150M · Ramona, CADuring the climb to cruise phase of the flt, the engine experienced a loss of power. The pilot applied carburetor heat and the power began to return. Due to the loss in altitude, the plt opted to make a forced landing in a field where just prior to touchdown,…Jun 7, 1988 · N66167 · Substantial damageNTSB LAX88LA214Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Bakersfield, CAWhile on an instructional flt, the CFI instructed the student to fly above the power line poles at all times. While in cruise flight the instructor was looking away when the helicopter collided with power lines. The instructor took control of the helicopter…Jun 6, 1988 · N2634N · Substantial damageNTSB LAX88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grand Canyon, AZFailure of the an tee fitting, thereby allowing the oil to be pumped overboard causing the engine failure. The failure of the tee fitting was caused by the tie wrap used to secure the line. The tie wrap pulled the oil line and stressed one side of the tee…Jun 5, 1988 · N2131N · Substantial damageNTSB CHI88LA125Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Ellsworth, WIDuring cruise flight the pilot experienced an engine failure which he believed to be caused by fuel exhaustion, and executed a forced landing in unsuitable terrain. Post accident inspection revealed that the left fuel tank contained 23 gallons of fuel at the…Jun 5, 1988 · N4757F · Substantial damageNTSB MKC88LA105Accident · No injuriesLimited investigationFinal reportBeech 35C · Manhattan, KSArriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10…Jun 4, 1988 · N5878C · Substantial damageNTSB LAX88LA212Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Lihue, HIFatigue failure of the engine to transmission drive shaft engine coupling due to an angular misalignment of the drive shaft.Jun 4, 1988 · N53EP · Substantial damageNTSB FTW88DRD08Accident · Minor injuriesFinal reportCessna T-210N · Ruston, LADuring climbout, the engine lost power and the airplane made a forced landing in a wooded area. After hitting trees and the terrain, the airplane burned. No pre-impact problems were found with the powerplant. Vented fuel caps had been installed but were…Jun 4, 1988 · N6449Y · DestroyedNTSB DEN88FA121Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rock Springs, WYShortly after departure on the second leg of a cross country flt the plt informed the fss located on the arpt that he was returning. The fss technician on duty observed the acft turn final at an abnormally low altitude. The acft disappeared from view. The…Jun 4, 1988 · N9728J · DestroyedNTSB MKC88DCQ03Accident · Serious injuriesFinal reportAeronca 11AC · Ada, KSThe a/c contacted powerlines about 25 feet AGL, contacted a tree, broke another powerline, and then crashed into a pickup truck. No evidence of preimpact mechanical problems were found with either airframe or powerplant. A toxicological test of the pilot…Jun 3, 1988 · N85985 · Substantial damageNTSB NYC88LA152Accident · No injuriesLimited investigationFinal reportBeech H18 · Utica, NYThe flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could…Jun 1, 1988 · N20PA · Substantial damageNTSB LAX88LA207Accident · No injuriesLimited investigationFinal reportBeech M35 · Scottsdale, AZDuring the climb out the engine experienced a loss of power. A forced landing was made where during the landing roll the airplane collided with the terrain. Inspection of the engine revealed that the number two connecting rod broke.Jun 1, 1988 · N9896R · Substantial damageNTSB FTW88DRG10Accident · Minor injuriesFinal reportPiper PA-28RT-201 · Lampasas, TXThe pilot experienced a partial loss of engine power during cruise, while on a night, VFR, cross-country flight. He attempted to spiral down to an airport for an emergency landing but reported that he became disoriented and attempted to land downwind,…May 31, 1988 · N8209H · DestroyedNTSB CHI88DEM05Accident · No injuriesFinal reportBell 47G-2A · Midland, MIThe plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter…May 31, 1988 · N440TG · Substantial damageNTSB LAX88FA204Accident · 2 fatalField investigationFinal reportTaylorcraft BL65 · Eloy, AZFailure of the pilot to maintain control of the aircraft during takeoff climb resulting in an inadvertent spiral. Contributing to this accident was the pilot's lack of total experience in the aircraft make and model.May 30, 1988 · N27463 · DestroyedNTSB LAX88FA196Accident · 1 fatalField investigationFinal reportBeech H-35 · Phoenix, AZThe plt had just completed a flight from farmington, n.m., to Phoenix, AZ (phx) where she deplaned her pax. The plt dept phx enroute to mesa, AZ, (ffz). After t.o. the LCL controller instructed the plt to turn right to 300 deg and to turn on the xpndr; the…May 30, 1988 · N904Q · DestroyedNTSB NYC88FA147Accident · 1 fatalField investigationFinal reportLake LA4-250 · Shaftsbury, VTThe Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…May 29, 1988 · N1405F · DestroyedNTSB MKC88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Des Moines, IADuring a cross country flight, an emergency landing was made within three miles of destination airport. The aircraft nosed over after landing attempt, and passenger and PIC were not injured. Post flight inspection revealed engine had failed due to fuel…May 29, 1988 · N67360 · Substantial damageNTSB LAX88FA215Accident · 4 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAInflight encounter with forcasted severe icing and turbulence beyond the capability of either the aircraft or the pilot , which led to an inflgiht loss of control. Factors in the accident were the pilots lack of understanding of high altitude flight aspects…May 29, 1988 · N98683 · DestroyedNTSB LAX88FA197Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pinecrest, CAPilots decision to continue VFR flight through a mountain area after encountering instrument meteorological conditions.May 29, 1988 · N1259T · DestroyedNTSB CHI88LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five…May 28, 1988 · N4812B · Substantial damageNTSB NYC88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lairdsville, PAThe Cessna 172 took off on a solo x-c flight with a student pilot/owner operator at the controls. After takeoff. The pilot reported a loss of engine power and made an off airport forced landing in a plowed field. The nose wheel dug in after approx 200 ft and…May 27, 1988 · N5164H · Substantial damageNTSB DEN88FA111Accident · 1 fatalField investigationFinal reportCessna T210N · Seboyeta, NMThe plt departed el paso, TX, and flew to Douglas, AZ, where three pax boarded. The plt then flew to a ranch near Seboyeta, NM, and landed on a dirt road. After conducting business, the plt and his pax took off for pagosa springs, CO. As the acft turned on a…May 27, 1988 · N5536A · DestroyedNTSB CHI88LA119Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Gary, INWhile on the return leg of a local flight, the pilot was flying at 150' above the water along the shoreline. The pilot's attention was diverted from the task of flying the airplane by navigation duties (the frequency, and adjustment, and tuning of the VOR),…May 27, 1988 · N5658G · DestroyedNTSB ATL88FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCA Piper PA-28R (lead acft, N44018) & a Cessna 172 (#2 acft, N737GU) were departing Raleigh-durham arpt on a formation flt to petersburg, VA. The Cessna plt (wingman) rprtd that drg takeoff & initial climb, the lead acft bgn to accelerate ahead of him. The…May 26, 1988 · N44018 · 2 aircraft · DestroyedNTSB MIA88IA177Incident · Minor injuriesIncident investigationFinal reportBritish BAC-111-203 · Orlando, FLThe flt was descending thru 13000 ft when turbulence was encountered. Four passengers and two flight attendents were injured. The passengers were injured when their seatbelts' end fittings detached from their seats' tie-down shackles and the passengers struck…May 24, 1988 · N1544 · Minor damageNTSB FTW88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737-3T0 · New Orleans, LAA double engine flameout due to water ingestion which occurred as a result of an inflight encounter with an area of very heavy rain and hail. A contributing cause of the incident was the inadequate design of the engines and the FAA water ingestion…May 24, 1988 · N75356 · Minor damageNTSB ATL88LA183Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Whiteville, NCThe student plt reported that the engine began to skip and lose pwr about 20 minutes after departure. The engine subsequently lost all pwr and the student made a forced ldg in a plowed field. The airplane nosed over during the ldg. Post-crash exam of the…May 24, 1988 · N41886 · Substantial damageNTSB NYC88LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner, METhe pilot said he preflighted the aircraft before departure. The pilot stated that he flew in the local area taking photos, then had started back towards the airport when the engine began to sputter. The pilot called bangor air rescue, checked instruments and…May 23, 1988 · N46413 · Substantial damageNTSB MIA88IA176Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Near San Juan, PRPan am flt 217 (Airbus A300, N209PA) was clrd by new york center oceanic ctl area (oca) to proceed south on airway amber 300 at FL 290 over the atlantic ocean. As it was en route, American flt 902 departed san Juan (sju), PR for a northbound flt on the same…May 23, 1988 · N209PA · 2 aircraft · No damageNTSB NYC88LA144Accident · No injuriesLimited investigationFinal reportCessna 150F · West Chester, PAThe pilot preflighted the aircraft and performed a runup before takeoff. The flight departed from runway 27. When the aircraft reached about 200 feet, the engine experienced a power loss and altitude could not be maintained. The pilot elected to land in a…May 22, 1988 · N8154S · Substantial damageNTSB MIA88LA175Accident · No injuriesLimited investigationFinal reportGlobe GC1-B · Miami, FLHydraulic motor activated light remained on after landing gear retraction. The pilot believing this to indicate a landing gear malfunction slowed the acft and extended the gear. A gear down indicator illuminated. However, the hydraulic motor activated light…May 22, 1988 · N90379 · Substantial damageNTSB ATL88LA181Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1A · Blue Ridge, GAThe plt reported that he encountered deteriorating wx conditions during the flt. He made a 180 degree turn and other course changes in an attempt to return to better wx, but was unable to maintain VFR flt. He subsequently elected to make a precautionary ldg…May 22, 1988 · N80582 · Substantial damageNTSB MKC88LA094Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Cassville, MOThe PIC dptd Texas enr to bolivar, MO with a stop for fuel in pinebluff, ark with two revenue pax's aboard. The PIC stated that the pax would try to locate the arpt by visually identifying the lights of the city. The PIC stated they wandered to several…May 21, 1988 · N2585V · Substantial damageNTSB SEA88LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ritzville, WAWhile on an aerial applications flight, the pilot was climbing to clear power lines when a whirlwind was encountered. The aircraft struck a power pole and descended onto the ground.May 20, 1988 · N6963K · DestroyedNTSB ATL88LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe pilot was conducting a maintenance test flight when he experienced a drop in engine RPM. After a series of bangs the engine quit. The pilot made a forced landing into a rough field. The engine examination disclosed that no. 1 piston had failed. The engine…May 20, 1988 · N94533 · Substantial damage