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 FTW88FA066Accident · 3 fatalField investigationFinal reportAero Commander 680 · El Paso, TXThe non-instrument rated, non multiengine rated pilot, whose medical had expired, lost control of the aircraft during an IFR flight in instrument meteorological conditions. The aircraft crashed and burned. The pilot was attempting to return and land after he…Feb 19, 1988 · N634SA · DestroyedNTSB NYC88LA090Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Oswego, NYDuring a local pleasure flight, a decrease in engine power was experienced and a puff of smoke observed in the cockpit. The pilot applied full power in an attempt to return to the airport, but realized it was not possible. The pilot put the aircraft down in…Feb 18, 1988 · N6939M · Substantial damageNTSB MIA88LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLWhile on a personal flt, the passenger requested the instructor plt to demonstrate a forced landing. The plt descended, set up for a normal landing, & when the acft was at an alt of aprx 50- 100 ft, discontinued the descent & added power for climbout. At that…Feb 17, 1988 · N93137 · Substantial damageNTSB FTW88DRG05Accident · No injuriesFinal reportAir Tractor 301 · Circleville, TXThe airplane was being ferried to a new location, and an en route refueling stop was planned. A low ceiling and low visibility set in and the pilot tried to extend the flight to a different town. The fuel was exhausted 6 miles short of a town. The airplane…Feb 17, 1988 · N3164Y · Substantial damageNTSB NYC88LA083Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Waterfall, PAShortly after takeoff, the pilot heard a loud 'boom' and experienced a loss of tail rotor control accompanied by an increase in N2 and RPM. A radio transmission was made to the aircraft that was trailing and then an approach for landing set up. On landing,…Feb 16, 1988 · N5093Y · DestroyedNTSB CHI88LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Martinsville, INWhile engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…Feb 16, 1988 · N21197 · Substantial damageNTSB SEA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Stevens Pass, WAPlanned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…Feb 14, 1988 · N6642E · Substantial damageNTSB FTW88LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Crowley, TXThe engine stopped as a result of fuel starvation, due to a large amount of contamination throughout the fuel system. The source of the contamination and the length of time it had been in the system was not determined. The pilot was not in gliding distance of…Feb 14, 1988 · N3180B · Substantial damageNTSB DEN88GA068Accident · 1 fatalFinal reportCessna T-337H · Galisteo, NMFeb 13, 1988 · N602SP · DestroyedNTSB FTW88LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilots experienced a sudden total and complete loss of engine power during climbout after takeoff. Suitable terrain for a safe landing was not available and the aircraft was damaged during landing on a golf course. Examinations of the aircraft and engine…Feb 12, 1988 · N669ST · Substantial damageNTSB FTW88FA064Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Laplace, LAPlt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…Feb 12, 1988 · N4882S · Substantial damageNTSB NYC88LA079Accident · 1 fatalLimited investigationFinal reportCessna 172P · East Hampton, NYThe flight departed East Hampton airport for a pleasure flt. Shortly thereafter, the pilot called on frequency 122.7 stating that he had struck some birds and could not maintain control of the aircraft. There as no further transmission as to his location, and…Feb 11, 1988 · N52535 · DestroyedNTSB FTW88FA057Accident · Serious injuriesField investigationFinal reportCessna 120 · Ada, OKThe pilot was flying low up the river and hit the upper strand of a two strand high voltage power line. Both the pilot and passenger received serious injuries when the airplane crashed on a sand-bar in the river.Feb 10, 1988 · N2431N · DestroyedNTSB DEN88FA071Accident · 3 fatalField investigationFinal reportCessna 172M · Red Lodge, MTThe plt and two pax were returning to twin falls, id from billings, MT. The plt rec two wx briefings prior to dep. The wx forecast indicated low clouds, snow, turb and icing cond along the intended route of flight. The route of flight required the plt to…Feb 7, 1988 · N20484 · DestroyedNTSB CHI88DET02Accident · No injuriesFinal reportBeech A35 · Wheeler, INThe acft was being operated iaw a ferry permit to obtain an annual inspn. The prev annual inspn was on 3/13/85. Drg flt abt 1.3 hrs after takeoff, the eng lost pwr. The plt noted the fuel pres was zero. He said he turned on the aux fuel pump & insured the…Feb 7, 1988 · N8568A · Substantial damageNTSB ATL88LA087Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Liberty, NCThe plt rptd that he overestimated the amount of fuel on board the acft prior to departure. The engine subsequently lost pwr at cruise due to fuel exhaustion. A forced ldg was made in a field. During the rollout, the airplane vaulted the crest of a small hill…Feb 7, 1988 · N2633W · Substantial damageNTSB DEN88FA064Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Roswell, NMFeb 5, 1988 · N8417F · DestroyedNTSB LAX88FA101Accident · 2 fatalField investigationFinal reportCessna U206F · Lk Havasu City, AZPilot's decision to continue flight in forecast marginal VFR conditions in mountainous terrain. Contributing to this accident was the failure of the pilot to obtain an aviation weather briefing and his lack of recurrent training.Feb 2, 1988 · N60566 · DestroyedNTSB DEN88LA060Accident · No injuriesLimited investigationFinal reportCessna 150L · Reynolds, NDFeb 1, 1988 · N11312 · Substantial damageNTSB ATL88LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Barnwell, SCThe CFI and her student became lost on the last leg of a dual x-c flt after encountering rainshowers and low ceilings. After unsuccessfully attempting to locate their destination arpt, the CFI located another arpt and elected to land there. The engine…Jan 31, 1988 · N6254G · Substantial damageNTSB FTW88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe airplane was descending toward the airport when the engine lost power. Application of carburetor heat restored power until next descent. Second descent was started with full carburetor heat applied and power was lost again and could not be restored. Pilot…Jan 30, 1988 · N6614H · DestroyedNTSB ANC88LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Cold Bay, AKThe ATP certificated pilot in command departed on a solo, cargo-only air-taxi flight at 1104 a.k.s.t. for a destination 83SM to the n.e. the pilot was normally assigned to copilot duties on a multi-engined airplane, and was not familiar with the terrain he…Jan 30, 1988 · N123TA · Substantial damageNTSB SEA88LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Twin Falls, IDWhen the pilot attempted to reduce power to descend to land he was unable to obtain a power reduction due to the throttle rod end separating in flight. The pilot made a spiralling descent and then shut down the engine. The pilot misjudged his altitude and…Jan 29, 1988 · N4290R · Substantial damageNTSB NYC88LA074Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Decatur, MIThe flight attendant was pulling a beverage cart up the aisle when the pad the coffee pot was resting on caught against a curtain. The pad was pulled off the cart and the full pot of coffee spilled in a passengers lap. The passenger service cart has a…Jan 28, 1988 · N262AA · No damageNTSB ATL88FA085Accident · Serious injuriesField investigationFinal reportBell 204B · Stockton, ALJan 28, 1988 · N8514F · DestroyedNTSB MIA88LA093Accident · No injuriesLimited investigationFinal reportCessna 305A · Chuluota, FLPlt stated electric boost pump was operated longer than normal during power off glide for banner pickup. After banner pickup when full throttle was applied for climb the engine sputtered and lost power. The nose was lowered in preparation for a landing…Jan 27, 1988 · N5290G · Substantial damageNTSB CHI88LA054Accident · Minor injuriesLimited investigationFinal reportMooney M20A · La Porte, INThe aircraft experienced a complete power failure and while the pilot was attempting to make an emergency landing ran through a fence and between two trees substantially damaging the aircraft. The pilot sustained minor injuries. Post acc invest revealed a…Jan 27, 1988 · N6072X · Substantial damageNTSB NYC88IA078Incident · No injuriesIncident investigationFinal reportBeech 1900C · Philadelphia, PAThe Beech 1900C took off on a scheduled commuter flt. When attempting to level the aircraft at 5000 ft, the co-pilot was unable to push the control wheel forward FAR enough to level off. By reducing power, the crew was able to compensate. The crew…Jan 26, 1988 · N818BE · No damageNTSB LAX88LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Diamond Springs, CADuring a dual instructional flt, approaching the airport the engine experienced a total loss of power. The plt made a forced landing in a field where during the landing roll the acft nosed over. There were no mechanical failures or malfunctions reported. The…Jan 26, 1988 · N1706Q · Substantial damageNTSB LAX88LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Redbluff, CADuring a cross country flt, the engine experienced a complete pwr loss. The plt made a forced landing where the acft collided with the terrain 1 mile short of the rwy. Inspection of the acft revealed that the fuel tanks were near empty. There were no reported…Jan 26, 1988 · N7929E · Substantial damageNTSB CHI88LA053Accident · No injuriesLimited investigationFinal reportCessna T310R · Urbana, ILAfter the aircraft experienced a complete electrical failure the gear was extended manually and a precautionary landing was made. On roll out the landing gear collapsed. Subsequent investigation revealed that 10 turns remained on the manual gear extension…Jan 26, 1988 · N5120J · Substantial damageNTSB ATL88LA084Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Block Island, RIThe capt rptdly advised the flight attendants to secure the cabin and be seated due to turbulence expected during descent. About 5 minutes later, the airplane briefly encountered severe turbulence while passing through about FL230. A flight attendant…Jan 26, 1988 · N117DL · No damageNTSB FTW88LA054Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Borger, TXShortly after takeoff there was smoke in the cabin. The plt started a turn back toward the runway. When he turned off the electrical master switch the engine stopped producing power. Attempts to restart the engine were not successful. He impacted a heavy…Jan 25, 1988 · N8250R · Substantial damageNTSB LAX88LA095Accident · No injuriesLimited investigationFinal reportHughes 369D · Rialto, CAJan 24, 1988 · N8366F · Substantial damageNTSB NYC88LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Mendon, MAOff airport landing due to engine power loss for undetermined reasons.Jan 23, 1988 · N663FL · DestroyedNTSB LAX88LA093Accident · 2 fatalLimited investigationFinal reportCessna TU206G · Kirkland, AZDuring a cross country flt, the acft struck power lines that were stretched across a canyon. The unmarked wires were aprx 500 ft AGL. There were no reported mechanical failures or malfunctions. No explanation was given for the low flying.Jan 23, 1988 · N4884U · DestroyedNTSB LAX88FA094Accident · 2 fatalField investigationFinal reportCessna 172 · Temple City, CAPilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.Jan 23, 1988 · N5113A · 2 aircraft · DestroyedNTSB SEA88FA039Accident · 3 fatalField investigationFinal reportBeech B23 · Hamer, IDThe two non instrument rated pilots (owner/pilot in command and second pilot) as well as a passenger departed medicine hat, alberta, Canada, on a pleasure flight to las vegas, Nevada. Upon arrival at great falls, Montana, both pilots were briefed on the…Jan 22, 1988 · CFWET · DestroyedNTSB FTW88IA052Incident · No injuriesIncident investigationFinal reportDassault-Breguet DA-10 · Dallas, TXThe flight experienced in-flight fire resulting from an electrical short in an auxiliary circuit breaker panel installed after aircraft manufacture. The short resulted from the use of a mounting bracket that chafed against the input wires. The flightcrew…Jan 21, 1988 · N79PB · Minor damageNTSB NYC88IA067Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-35 · Teterboro, NJThe MU-2 made a departure and while climbing through approximately 800 ft AGL, there was an inadvertent auto-pilot engagement. The nose pitched down and right. Both pilots got on the controls and control was maintained. A normal landing was made at the point…Jan 20, 1988 · N349MA · No damageNTSB MKC88FA042Accident · 1 fatalField investigationFinal reportGulfstream 500B · Pierceville, KSThe acft dptd garden city under extremely poor wx cond's. more than half way to dodge city, the PIC rptd eng pblms to Kansas city (ARTCC). Vectors were provided to the dodge city arpt, but the PIC did not maintain assigned hdgs. The acft headed back towards…Jan 20, 1988 · N611CA · DestroyedNTSB CHI88FA048Accident · Serious injuriesField investigationFinal reportBoeing 767-200 · Chicago, ILA flight attendant and a passenger received serious and minor injuries respectively during an inflight encounter with severe turbulence during an enroute descent. Greater than moderate turbulence was forecast to be in the area and severe turbulence had been…Jan 20, 1988 · N306AA · No damageNTSB SEA88LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Port Angeles, WADuring cruise the pilot noticed a gradual loss of RPM. Carburetor heat was applied but the pilot stated that he noted no improvement in the engine power. The power loss continued to deteriorate so a landing was made onto a rough field where the nose gear…Jan 19, 1988 · N9894J · Substantial damageNTSB MKC88DPG01Accident · 1 fatalFinal reportMeyer VARI-EZE · Little Rock Afb, ARPilot received a wx briefing and was told VFR was not recommended. The pilot did not file a flight plan and flew an aircraft not equipped for IFR into weather with 100-feet obscured ceiling and .3 mile visibility. The aircraft crashed into the ground at a…Jan 19, 1988 · N748BC · DestroyedNTSB MIA88LA090Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-82 · Hickman, KYThe capt left the seat belt sign on after takeoff. The flight attendants made a followup announcement for the passengers to remain seated and keep their seatbelts fastened due to the turbulence they were encountering. A passenger elected to get up from her…Jan 19, 1988 · N915TW · No damageNTSB CHI88IA045Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Waterloo, IAJan 19, 1988 · N421MQ · Minor damageNTSB LAX88LA091Accident · No injuriesLimited investigationFinal reportAerospatiale SA-341G · Bowie, AZJan 18, 1988 · N61DR · Substantial damageNTSB ATL88FA081Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Barnardsville, NCJan 18, 1988 · N55WP · DestroyedNTSB LAX88LA089Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Sun City, AZJan 17, 1988 · N90165 · Substantial damageNTSB LAX88FA088Accident · 4 fatalField investigationFinal reportCessna 182L · Newhall, CAPilots decision to continue VFR flight after encountering instrument meteorological conditions.Jan 17, 1988 · N42450 · Destroyed