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 CHI97IA134Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Saint Louis, MOfailure of company maintenance personnel to properly install a mounting eyebolt (and associated cotter pin, washer, spacer and castellated nut) on the lower forward bracket of the left main landing gear strut door.May 15, 1997 · N11003 · Minor damageNTSB MIA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Yakkama City, FLa complete loss of engine power due to the separation of the connecting rod bolts, resulting in a forced landing and impact with a tree. A factor in this accident was improper installation of the rod bolts by a mechanic.May 14, 1997 · N7931P · Substantial damageNTSB FTW97LA190Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Laredo, TXloss of engine power due to fuel contamination, and the pilot's failure to properly check the fuel system for evidence of water during the preflight inspection. A factor was the lack of suitable terrain for the forced landing.May 13, 1997 · N107SM · Substantial damageNTSB LAX97LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Burbank, CAimproperly secured upper cowl fasteners by unknown person(s).May 12, 1997 · N3609Q · Substantial damageNTSB DCA97MA049Accident · Serious injuriesMajor investigationFinal reportAirbus Industrie A300B4-605R · West Palm Beach, FLThe flightcrew's failure to maintain adequate airspeed during leveloff which led to an inadvertent stall, and their subsequent failure to use proper stall recovery techniques. A factor contributing to the accident was the flightcrew's failure to properly use…May 12, 1997 · N90070 · Minor damageNTSB LAX97LA176Accident · 2 fatalLimited investigationFinal reportHughes 369D · Puako, HIerosion of second stage stator vanes, inadequate maintenance inspection for the erosion, and subsequent fatigue failure of a stator vane, which resulted in loss of engine power and a forced landing on mountainous/hilly terrain. Also causal was: the pilot's…May 11, 1997 · N5105N · DestroyedNTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…May 10, 1997 · N5434B · 2 aircraft · DestroyedNTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.May 10, 1997 · N5734L · DestroyedNTSB FTW97LA189Accident · No injuriesLimited investigationFinal reportTownsend Kitfox · Greeley, COThe engine manufacturer's inadequate quality control by failing to install the harmonic balancer, causing the engine to fail catastrophically. A factor was the lack of suitable terrain on which to make a forced landing.May 10, 1997 · N950AW · Substantial damageNTSB FTW97LA185Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Torreon, NMfailure of the forward number four piston pin plug, and the subsequent obstruction of internal oil passages of the lubricating system, which resulted in partial loss of engine power. Factors relating to the accident were: the crosswind condition and lack of…May 9, 1997 · N7853V · Substantial damageNTSB LAX97LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T-34 · Tonopah, AZthe failure of the power turbine due to an overtemperature condition created by an improperly adjusted fuel control. A factor in the accident was the tripped circuit breaker which prevented the wing lights from operating during the forced night landing.May 8, 1997 · N4011G · Substantial damageNTSB FTW97FA181Accident · 1 fatalField investigationFinal reportCessna 172RG · Intracoastal, LAthe pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.May 8, 1997 · N6505V · DestroyedNTSB CHI97IA127Incident · No injuriesIncident investigationFinal reportCessna T210 · Winona, MNLoss of engine power due to improper maintenance installation.May 8, 1997 · N7398M · No damageNTSB FTW97LA180Accident · No injuriesLimited investigationFinal reportCessna 172N · Las Cruces, NMThe improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.May 7, 1997 · N733WJ · Substantial damageNTSB ATL97LA080Accident · No injuriesLimited investigationFinal reportLearjet 31A · Atlantic Ocean (Atlantic Ocean)the pilot-in-command's failure to maintain airspeed within the design structural limits of the airplane.May 7, 1997 · N31PV · Substantial damageNTSB SEA97LA099Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Rosalia, WAThe pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.May 6, 1997 · N7926 · DestroyedNTSB NYC97LA085Accident · 1 fatalLimited investigationFinal reportMarsh-Turner BG-12A · Marion, OHDisconnection of the elevator control rod which resulted in the loss of elevator control. A factor was failure to complete the required maintenance inspection.May 4, 1997 · N8711R · DestroyedNTSB IAD97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Washington, DCtotal loss of power on both engines due to fuel exhaustion as a result of the pilot's improper fuel consumption calculations.May 2, 1997 · N1044P · Substantial damageNTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.May 1, 1997 · N5778Z · Substantial damageNTSB ANC97LA065Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Hope, AKa loss of engine power resulting from fuel starvation due to the pilot's improper positioning of the fuel selector, and the pilot's failure to identify and correct the deficiency during the ensuing emergency descent.May 1, 1997 · N14C · Substantial damageNTSB FTW97LA170Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · El Dorado, ARThe pilot misjudging his altitude above the airport, resulting in not attaining the proper touchdown point. A factor was the separation of teeth from the aft gear of the spur gear assembly, which resulted in the interruption of fuel.Apr 29, 1997 · N31575 · Substantial damageNTSB CHI97LA119Accident · No injuriesLimited investigationFinal reportBeech D35 · Lexington, KYflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.Apr 29, 1997 · N5985C · Substantial damageNTSB CHI97IA122Incident · No injuriesIncident investigationFinal reportBeech 35 · Spokane, WAthe vibration of the fuselage was due to flutter.Apr 29, 1997 · N2839V · No damageNTSB ATL97LA069Accident · No injuriesLimited investigationFinal reportBeech 33 · Carrollton, GAThe inadequate maintenance inspection of the airplane that resulted in the disconnection of the propeller governor linkage and the subsequent reduction in engine power. The pilot also failed to maintain flying speed that resulted in an inadvertent stall…Apr 29, 1997 · N5863S · Substantial damageNTSB ATL97LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Hazelhurst, GAThe loss of engine power for undetermined reasons. Factors were, conditions were favorable for the formation of carburetor ice, and the pilot lack of qualification for the flight.Apr 29, 1997 · N4979L · Substantial damageNTSB ATL97LA064Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Atlanta, GAThe failure of the flight crew to alert the cabin crew to the possibility of turbulence, leading to a serious injury when severe turbulence was encountered..Apr 28, 1997 · N14245 · No damageNTSB LAX97LA168Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Hemet, CAthe pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…Apr 26, 1997 · N5482N · DestroyedNTSB FTW97FA171Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Rye, COThe pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.Apr 26, 1997 · N2225A · DestroyedNTSB MIA97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLloss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.Apr 24, 1997 · N6299A · Substantial damageNTSB FTW97FA166Accident · 1 fatalField investigationFinal reportSocata TB-20 · Pagosa Springs, COinadvertent flight by the pilot into known adverse weather conditions, and his failure to maintain altitude or clearance from terrain. Factors relating to the accident were: low ceiling, rain, snow, icing conditions, and mountainous terrain.Apr 23, 1997 · N20NK · DestroyedNTSB ANC97LA075Accident · No injuriesLimited investigationFinal reportCessna 207A · Minto, AKThe pilot's inadequate preflight inspection of the airplane, which resulted in an unlatched door opening in-flight.Apr 23, 1997 · N1785U · Substantial damageNTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…Apr 21, 1997 · N6601Q · Substantial damageNTSB ATL97IA061Incident · No injuriesIncident investigationFinal reportBritish Aerospace 125-800A · Chamblee, GAphysical impairmant of the captain during flight, which was the resulted of a kidney stone.Apr 21, 1997 · N900KC · No damageNTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.Apr 19, 1997 · N9063K · Substantial damageNTSB MIA97IA147Incident · No injuriesIncident investigationFinal reportBoeing 747-2R7F · Miami, FLdisbonding and separation of the right inboard wing fixed trailing edge panel during cruise flight, which resulted in damage to the inboard fore flap and inboard mid flap, and a subsequent precautionary landing at the departure airport.Apr 19, 1997 · N639FE · Minor damageNTSB LAX97FA164Accident · Serious injuriesField investigationFinal reportBoeing 737-3S3 · Las Vegas, NVinadequate service provided by the TRACON controller, by issuing a radar vector to the Boeing 737 flight, which resulted in inadequate separation from a Beech 99 that the controller had just terminated from radar service; and failure of the controller to…Apr 19, 1997 · N313AW · No damageNTSB SEA97LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sequim, WAThe pilot-in-command's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor was trees in the forced landing area.Apr 14, 1997 · N8645P · Substantial damageNTSB ATL97LA059Accident · No injuriesLimited investigationFinal reportCessna 210D · Huntsville, ALcorrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.Apr 14, 1997 · N3761Y · Substantial damageNTSB LAX97LA157Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Hilo, HIthe pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.Apr 13, 1997 · N242CA · DestroyedNTSB CHI97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Elk Falls, KSfracture of the fuel selector assembly which resulted in fuel starvation.Apr 12, 1997 · N8739P · Substantial damageNTSB ANC97LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Quinhagak, AKA disconnected exhaust manifold collector, improper maintenance of the airplane by company maintenance personnel, and the pilot's poor judgement in electing to initiate another flight after observing smoke in the cockpit.Apr 12, 1997 · N9000N · Substantial damageNTSB MIA97LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · La Crosse, FLThe student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…Apr 10, 1997 · N5442B · Substantial damageNTSB MIA97LA127Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Tullahoma, TNFuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…Apr 10, 1997 · N2515G · Substantial damageNTSB LAX97LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Pacific Ocean (Pacific Ocean)The loss of engine power in one engine for undetermined reasons. A factor in the accident was the aircraft's diminished single engine performance during the early portion of the overweight ferry flight.Apr 10, 1997 · N27659 · DestroyedNTSB ANC97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Alsworth, AKloss of engine power, due to failure of the number 2 connecting rod assembly (rod, bearing, & bolts). The lack of suitable terrain for a forced landing was a related factor.Apr 10, 1997 · N6472R · Substantial damageNTSB ANC97FA051Accident · 2 fatalField investigationFinal reportCessna 185 · Tatitlek, AKThe command pilots of both airplanes inadequate visual outlook which led to their failure to see and avoid each other's airplane. A factor associated with the accident was sunglare.Apr 9, 1997 · N59AK · 2 aircraft · Minor damageNTSB NYC97LA071Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Newark, NJan encounter with unforecasted turbulence, during cruise flight, which resulted in serious injury to the flight attendant.Apr 7, 1997 · N413UA · No damageNTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Apr 6, 1997 · N50918 · Substantial damageNTSB MIA97LA115Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Columbia, SCThe pilot's inadequate planning/decision and failure to assure an adequate supply of fuel was on board the airplane.Apr 6, 1997 · N52507 · Substantial damageNTSB LAX97FA148Accident · 1 fatalField investigationFinal reportCessna 152 · S. Lake Tahoe, CAThe pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…Apr 6, 1997 · N64845 · Destroyed