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 LAX00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palo Alto, CAThe failure of the pilot to properly calculate fuel consumption rate, and his improper in-flight planning to continue the flight to the destination airport instead of landing at a closer alternate airport. A factor was the pilot's inadequate aircraft control…Dec 2, 1999 · N4319Y · Substantial damageNTSB NYC00LA042Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Palmerton, PAThe pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.Nov 28, 1999 · N117TB · Substantial damageNTSB IAD00LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Olean, NYthe loss of engine power from water-contaminated fuel due to the pilot's inadequate preflight inspection.Nov 28, 1999 · N7407J · DestroyedNTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.Nov 28, 1999 · N444D · Substantial damageNTSB MIA00FA030Accident · 2 fatalField investigationFinal reportBell 212 · Philadelphia, MSThe failure of the pilot and company maintenance personnel during preflight and periodic inspections to identify the signs of fretting and looseness in the "red" main rotor blade pitch change horn to main rotor blade grip attachment, resulting in the…Nov 27, 1999 · N8144M · DestroyedNTSB NYC00FA039Accident · 3 fatalField investigationFinal reportBeech S35 · Newark, NJThe pilot's failure to maintain aircraft control. Factors in the accident were failure of the horizontal situation indicator for undetermined reasons, and the pilot's use of inappropriate medication.Nov 26, 1999 · N8992M · DestroyedNTSB MIA00FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · Helena, ALThe pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.Nov 25, 1999 · N395WM · DestroyedNTSB DEN00GA022Accident · No injuriesFinal reportBell 206 L-3 · Rifle, COa forced landing on rough, unsuitable terrain. A contributing factor was the partial loss of engine power, which resulted from improper maintenance by repair station personnel.Nov 24, 1999 · N617DE · Substantial damageNTSB MIA00LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Defuniak Spgs, FLWas the pilot's failure to obtain a proper weather briefing resulting in his encounter with fog, his having to make a precautionary landing in a field when the aircraft became low on fuel, and the on ground collision with trees during landing roll.Nov 22, 1999 · N733AH · Substantial damageNTSB LAX00LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hilo, HIAn oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.Nov 21, 1999 · N4148X · DestroyedNTSB LAX00LA037Accident · No injuriesLimited investigationFinal reportCessna 150K · Phoenix, AZFuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.Nov 19, 1999 · N6199G · Substantial damageNTSB SEA00FA021Accident · Minor injuriesField investigationFinal reportBell 206L-3 · Seattle, WAAdequate separation and lookout not maintained by the pilots of both aircraft.Nov 17, 1999 · N206AC · 2 aircraft · Substantial damageNTSB FTW00LA033Accident · No injuriesLimited investigationFinal reportCessna TU206G · Lafayette, LAThe partial blockage of oil within the engine's oil galley resulting in a total power loss. Contributing factors were the failure of the #1 connecting rod, the failure of the pilot to achieve the proper touchdown point during the forced landing, the tailwind…Nov 17, 1999 · N4803U · Substantial damageNTSB CHI00LA031Accident · No injuriesLimited investigationFinal reportCessna 182 · Shelbyville, INthe inadequate preflight planning by the pilot and the exhaustion of usable fuel. A factor was the drainage ditch encountered on landing.Nov 16, 1999 · N5388B · Substantial damageNTSB LAX00LA033Accident · Serious injuriesLimited investigationFinal reportRaven RX-7 · Phoenix, AZThe pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.Nov 13, 1999 · N4046M · Substantial damageNTSB DEN00LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Rawlins, WYThe pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.Nov 12, 1999 · N5225D · Substantial damageNTSB SEA00IA019Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Portland, ORArcing in the electrical system wiring for undetermined reasons.Nov 11, 1999 · N772AS · Minor damageNTSB CHI00LA028Accident · Serious injuriesLimited investigationFinal reportShaffer Evans Volksplane · Stanley, NDrefueling not performed by the non-rated pilot and the lack of total experience of the non-rated pilot. Factors to the accident were fuel exhaustion, the unsuitable terrain for landing encountered by the non-rated pilot, and the rough/uneven terrain condition.Nov 11, 1999 · N78VS · Substantial damageNTSB DEN00FA135Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Lake City, COthe pilot's inadequate flight planning and preparation, and his inadvertent flight into adverse weather during a cross-country flight over mountainous terrain. Contributing factors were, the cloudy obscuration weather condition, the high density altitude, and…Nov 10, 1999 · N6691V · DestroyedNTSB NYC00LA030Accident · No injuriesLimited investigationFinal reportCessna 150 · New Hope, PAThe pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.Nov 9, 1999 · N8323G · Substantial damageNTSB DEN00IA075Incident · No injuriesIncident investigationFinal reportBeech A60 · Boulder, COThe fatigue failure of the #6 cylinder connecting rod cap.Nov 9, 1999 · N457DA · Minor damageNTSB LAX00FA041Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30F · Honolulu, HIThe pilot-in-command initiated an evasive manuver during a near midair collission. The airplane entered a prestall buffet, which resulted in buckling of the elevator skins.Nov 8, 1999 · N602GC · Substantial damageNTSB LAX00TA030Accident · Minor injuriesFinal reportBell OH-58A · La Puente, CAA loss of engine power for undetermined reasons.Nov 6, 1999 · N911RN · DestroyedNTSB MIA00LA022Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCThe flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.Nov 5, 1999 · N714RA · Substantial damageNTSB SEA00TA013Accident · Serious injuriesFinal reportHiller UH-12E · Stites, IDInadequate inspection of the control rotor cuff by a company mechanic and subsequent fatigue fracture of the cuff, resulting in an inflight separation of the control rotor blade. Factors contributing to the accident were: inadequate quality control during…Nov 2, 1999 · N5388V · Substantial damageNTSB NYC00FA023Accident · Serious injuriesField investigationFinal reportCessna T303 · Binghampton, NYThe pilot's improper in-flight decision to descend below the decision height without the runway environment in sight, and his failure to execute a missed approach. A factor in the accident was the failed crankshaft.Nov 1, 1999 · N511AR · Substantial damageNTSB FTW00LA028Accident · No injuriesLimited investigationFinal reportCessna 210K · Ponca City, OKInadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.Oct 30, 1999 · N1162M · Substantial damageNTSB MIA00LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberry, SCa fire in the cockpit caused by the exhaust muffler, which resulted in a forced landing in a field, and subsequent impact with a berm.Oct 29, 1999 · N2648P · Substantial damageNTSB CHI00IA018Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Chicago, ILthe in-flight vibration of the airplane's elevator due to excessive freeplay in the elevator control system. Factors included the corrosion of the elevator PCA reaction link bearings and the elevator hinge bearings, excessive axial and radial wear of the…Oct 29, 1999 · N575UA · No damageNTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.Oct 29, 1999 · N757YQ · Substantial damageNTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.Oct 28, 1999 · N1171F · Substantial damageNTSB ANC00LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Russian Mission, AKThe pilot's continued flight into adverse weather, and an inadvertent stall. Factors in the accident were adverse weather consisting of icing conditions, and airframe icing.Oct 28, 1999 · N31606 · Substantial damageNTSB NYC00LA021Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Westbury, NYthe failure of the operator to ensure the pilot was adequately trained to conduct all inspections required by the flight manual, which resulted in the pilot's inadequate preflight and subsequent failure of the tail rotor pitch change rod. Factors were the…Oct 27, 1999 · N350SL · Substantial damageNTSB ANC00LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's inadequate evaluation of the weather, and his decision to initiate flight into adverse weather conditions. Factors in the accident were adverse weather consisting of low ceilings and icing conditions, inadequate supervision by company management,…Oct 27, 1999 · N207SE · Substantial damageNTSB DCA00MA005Accident · 6 fatalClass 1 · MajorFinal reportLearjet 35 · Aberdeen, SDIncapacitation of the flight crewmembers as a result of their failure to receive supplemental oxygen following a loss of cabin pressurization, for undetermined reasons.Oct 25, 1999 · N47BA · DestroyedNTSB FTW00LA017Accident · No injuriesLimited investigationFinal reportWright Avid Flyer Mark IV · Seabrook, TXThe pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.Oct 23, 1999 · N583AF · Substantial damageNTSB DEN00FA009Accident · 1 fatalField investigationFinal reportCessna 172R · Aspen, COthe pilot's improper decision to fly directly up the center of the valley and not circle climb to gain sufficient terrain clearance altitude. A factor was inadequate route performance planning by the pilot.Oct 23, 1999 · N9548A · Substantial damageNTSB ATL00LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe carburetor icing conditions that were present. Factors were the failure of the pilot to follow the emergency procedures checklist, and the objects that included a flag pole, a road sign and a tractor trailer vehicle.Oct 23, 1999 · N616FT · Substantial damageNTSB CHI00LA014Accident · 1 fatalLimited investigationFinal reportHowlett KR-2 · Denison, IAthe pilot not maintaining altitude/clearance from rising terrain and the intentional low altitude flight. Factors were the known turbulence, rising terrain, and the inadequate in-flight decision to fly at low altitudes.Oct 22, 1999 · N7057V · DestroyedNTSB LAX00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZFuel exhaustion due to the pilot's inadequate preflight verification of the fuel quantity, and, once he became aware of the critical fuel state, his decision to over-fly two alternate airports in order to continue to his destination.Oct 21, 1999 · N738FY · Substantial damageNTSB LAX00LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150H · El Monte, CAA cracked No. 2 engine cylinder, which led to a loss of power. A factor was the ditch in the forced landing area.Oct 19, 1999 · N22795 · Substantial damageNTSB LAX00LA019Accident · No injuriesLimited investigationFinal reportCessna TR182 · Fresno, CAInadequate maintenance inspection mandated by the FAA, and the inadequate design of the exhaust heater core/muffler and deflectors that failed to divert hot exhaust gasses away from the battery and cabin heat valve.Oct 19, 1999 · N756LE · Substantial damageNTSB DEN00FA007Accident · 1 fatalField investigationFinal reportGardner Varieze · Quemado, NMThe pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…Oct 18, 1999 · N13WM · Substantial damageNTSB MIA00LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Lake Wales, FLThe partial loss of engine power due to the inadequate annual inspection of the airplane by the mechanic with IA for his failure to assure that the mixture control cable jam nut at the rod end was secured following the reported adjustment by the airplane…Oct 17, 1999 · N85PR · Substantial damageNTSB MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.Oct 17, 1999 · N6504L · Substantial damageNTSB LAX00LA010Accident · No injuriesLimited investigationFinal reportMintz Vari EZE · Jean, NVThe failure of the engine cylinder head due to detonation and subsequent over temperature for undetermined reasons.Oct 17, 1999 · N86KM · Substantial damageNTSB ANC00LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-T3 · Gambell, AKAn in-flight collision with a bird.Oct 16, 1999 · N220CS · Substantial damageNTSB LAX00FA014Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVThe failure of the pilot-in-command to maintain separation from terrain while operating under visual flight rules. Contributing factors were the improper issuance of a suggested heading by air traffic control personnel, inadequate flight progress monitoring…Oct 15, 1999 · N1024B · DestroyedNTSB LAX00LA009Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waialua, HIThe pilot's delay in recognizing the onset of a wind direction change resulting in the downward flow of wind on the leeward side of the mountain (strong sink rate).Oct 14, 1999 · N17914 · Substantial damageNTSB DEN00FA005Accident · 1 fatalField investigationFinal reportWatkins Christen Eagle · Brigham City, UTThe pilot's inability to maintain aircraft control due to an unknown physical impairment.Oct 11, 1999 · N24JT · Destroyed