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 LAX95LA030Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · Willits, CAthat the pilot misjudged the distance between the helicopter and the trees.Nov 1, 1994 · N5088J · Substantial damageNTSB DCA95MA001Accident · 68 fatalClass 1 · MajorFinal reportATR ATR-72-212 · Roselawn, INthe loss of control, attributed to a sudden and unexpected aileron hinge moment reversal that occurred after a ridge of ice accreted beyond the deice boots while the airplane was in a holding pattern during which it intermittently encountered supercooled…Oct 31, 1994 · N401AM · DestroyedNTSB ATL95FA009Accident · 4 fatalField investigationFinal reportCessna 172N · Gerton, NCThe pilot's inadequate weather evaluation and his intentional visual flight into IMC.Oct 31, 1994 · N5338D · DestroyedNTSB NYC95LA019Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Westfield, MAthe pilot's improper in-flight planning and inaccurate fuel consumption calculations, resulting in fuel exhaustion and the subsequent forced landing at night.Oct 30, 1994 · N85JW · Substantial damageNTSB LAX95LA024Accident · Serious injuriesLimited investigationFinal reportKaman HH-43F · Willits, CAthe pilot's improper fuel consumption calculations resulting in fuel exhaustion. The hilly terrain was a factor in this accident.Oct 30, 1994 · N90944 · DestroyedNTSB FTW95LA034Accident · 1 fatalLimited investigationFinal reportBrisendine Pterodactyl/Ascender · Las Animas, COA failure of the right wing into the propeller.Oct 29, 1994 · UNREG · DestroyedNTSB LAX95LA022Accident · No injuriesLimited investigationFinal reportForney F-1 · Searchlight, NVthe pilot's failure to maintain directional control by improperly compensating for the existing wind conditions. The leaking cylinder, the prevailing crosswind, the soft terrain, and the dirt bank were factors in this accidentOct 28, 1994 · N3019G · Substantial damageNTSB SEA95FA011Accident · 4 fatalField investigationFinal reportCessna 310R · Rawlins, WYThe pilot-in-command's not maintaining clearance with terrain. Factors contributing to the accident were high terrain, dark night conditions, and the pilot-in-command's not obtaining/ maintaining the proper climb rate.Oct 27, 1994 · N69350 · DestroyedNTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.Oct 26, 1994 · N505KS · DestroyedNTSB CHI95IA030Incident · Minor injuriesIncident investigationFinal reportCessna 150 · Chesterfield, MOthe cracked heater exhaust muffler which resulted from an improper repair. Factors were the physical impairment of the solo flight student as a result of her inadequate training concerning carbon monoxide hazards.Oct 26, 1994 · N7XC · No damageNTSB LAX95LA019Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350D · Kaupo, HIa total loss of engine power by the corrosion fatigue failure of the compressor impeller due to the failure of company maintenance personnel to perform the prescribed daily compressor wash procedures and the inadequate maintenance inspections, which failed to…Oct 24, 1994 · N5771L · Substantial damageNTSB CHI95LA022Accident · No injuriesLimited investigationFinal reportCessna 210A · Manhattan, KStotal loss of engine power for reason(s) undetermined. A factor was the dark night.Oct 24, 1994 · N6663X · Substantial damageNTSB BFO95FA006Accident · 2 fatalField investigationFinal reportCessna T337G · Hyannis, MALoss of aircraft control for an undetermined reason. Darkness and the weather conditions were related factors.Oct 24, 1994 · N807J · DestroyedNTSB NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.Oct 23, 1994 · N740FA · Substantial damageNTSB LAX95FA016Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Kettleman City, CAFailure of the student pilot to maintain control of the airplane for an unknown reason. Factors related to the accident were: darkness and the pilot's lack of qualification/instructor endorsement for a cross-country flight at night.Oct 23, 1994 · N2326G · DestroyedNTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.Oct 23, 1994 · N999BW · DestroyedNTSB CHI95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Grand Forks, NDthe fatigue failure of the crankshaft.Oct 22, 1994 · N587PA · Substantial damageNTSB CHI95LA023Accident · No injuriesLimited investigationFinal reportCessna 172F · Cross Plains, WIthe pilot's failure to use carburetor heat. Factors were carburetor icing conditions and rough/uneven terrain.Oct 22, 1994 · N7969U · Substantial damageNTSB ANC95LA005Accident · No injuriesLimited investigationFinal reportAeronca Sedan AR-15 · Nikolai, AKThe pilot's continued flight into adverse weather. Factors to the accident were falling snow, an obstruction of the fuel system vents, restriction of the fuel flow and lack of a suitable landing area.Oct 21, 1994 · N1428H · Substantial damageNTSB FTW95IA022Incident · No injuriesIncident investigationFinal reportCanadair CL 600 · Nacogdoches, TXThe flight crew's improper use of the anti-ice system, which resulted in engine ice, subsequent ice ingestion, and engine flameout. Factors related to the accident were: failure of the flight crew to follow the checklist procedures after flight into adverse…Oct 17, 1994 · N600RE · Minor damageNTSB FTW95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fredericksburg, TXImproper maintenance resulting in an engine fire, and the pilot's improper propeller feathering procedure, causing the propeller not to feather and the airplane's engine out capability to be exceeded. A factor was the unsuitable terrain conditions.Oct 16, 1994 · N821AC · Substantial damageNTSB CHI95FA012Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Winfield, ILCollision with the ground for an undetermined reason. The pilot's psychological condition was a probable factor.Oct 16, 1994 · N9089U · DestroyedNTSB LAX95LA008Accident · Serious injuriesLimited investigationFinal reportRey Avid Flyer · Bakersfield, CAthe inadequate maintenance on the engine's liquid cooling system fittings and lines.Oct 15, 1994 · N827H · DestroyedNTSB LAX95LA007Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Atherton, CAthe pilot's inadequate fuel consumption calculations and failure to refuel the aircraft while en route.Oct 15, 1994 · N67358 · Substantial damageNTSB FTW95FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Eunice, LAThe pilot's failure to properly use carburetor heat, the formation of carburetor ice, and failure of the pilot to maintain rotor RPM after loss of engine power, which resulted in a loss of control and collision with terrain. A factor related to the accident…Oct 14, 1994 · N80546 · DestroyedNTSB FTW95IA013Incident · No injuriesIncident investigationFinal reportGates Learjet 35A · San Antonio, TXThe uncontained failure of the turbine wheel. A factor was the resultant loss of hydraulic power.Oct 11, 1994 · N46TJ · Minor damageNTSB FTW95LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Livingston, TXThe improper flare resulting in an undershoot of the intended landing area. A factor was the bird strike.Oct 10, 1994 · N9616F · Substantial damageNTSB CHI95LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Lakota, NDPartial loss of engine power due to preignition and/or detonation, which resulted in failure of the number 4 cylinder. The unfavorable tailwind for landing was a related factor.Oct 10, 1994 · CGHRG · Substantial damageNTSB BFO95FA001Accident · 1 fatalField investigationFinal reportCessna 172N · Fancy Gap, VAThe pilot's inadequate inflight planning and his failure to maintain adequate terrain clearance. Other related factors are: fog, rain, VFR flight into IMC, inexperience and mountainous terrain.Oct 9, 1994 · N734NB · DestroyedNTSB ATL95LA059Accident · 1 fatalLimited investigationFinal reportHayes LONG-EZ · Collinsville, ALThe pilot continued visual flight into instrument weather conditions, and collided with the ground.Oct 9, 1994 · N33EZ · Substantial damageNTSB SEA95LA007Accident · Minor injuriesLimited investigationFinal reportBony MB-1 · Madras, ORThe jamming of the rudder during due to undetermined reasons. Contributing to the accident was the pilot-in-command's failure to maintain adequate flying speed while attempting to take remedial action.Oct 8, 1994 · N51MB · DestroyedNTSB SEA95LA004Accident · No injuriesLimited investigationFinal reportMonocoupe 110 Special · Langley, WACorrosion and subsequent failure of the elevator hinge attach fitting weld. This allowed the elevator to bend and impinge upon the rudder, subsequently jamming it to the full right position and rendering the aircraft impossible to control.Oct 8, 1994 · N2064 · Substantial damageNTSB NYC95LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · New London, NHthe failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.Oct 8, 1994 · N8903G · Substantial damageNTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.Oct 8, 1994 · N258CH · DestroyedNTSB CHI95FA007Accident · 1 fatalField investigationFinal reportAero Commander 690B · Springfield, MOFailure of the pilot to maintain control of the airplane, due to spatial disorientation. A factor related to the accident was: the pilot's lack of recent instrument experience.Oct 8, 1994 · N27MT · DestroyedNTSB LAX95FA003Accident · 1 fatalField investigationFinal reportAero Commander 560 · Essex, CAThe pilot's inadvertent flight into IMC conditions. Contributing to the accident was a loss of control of the aircraft and exceeding the structural limits of the aircraft. The weather conditions were factors.Oct 5, 1994 · N251VW · DestroyedNTSB CHI95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carbondale, ILthe pilot's inadequate visual lookout, and improper altitude.Oct 5, 1994 · N66224 · Substantial damageNTSB ANC95LA001Accident · No injuriesLimited investigationFinal reportPiper J5C · Anchorage, AKThe loss of engine power for undetermined reasons and the lack of a suitable forced landing area.Oct 4, 1994 · N38532 · Substantial damageNTSB FTW95FA008Accident · 3 fatalField investigationFinal reportCessna T337G · Milford, UTThe pilot's continued flight into adverse weather conditions, which resulted in airframe (structural) ice, a loss of control, and subsequent in-flight breakup of the airplane. A factor related to the accident was: the icing/weather condition.Oct 3, 1994 · N531J · DestroyedNTSB CHI95LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Decatur, ILthe failure of the roller springs in the freewheeling unit of the transmission which caused the unit to disengage.Oct 3, 1994 · N5193B · Substantial damageNTSB ATL95FA003Accident · 2 fatalField investigationFinal reportCessna 182L · Ft. Mcclellan, ALThe pilot's continued VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the low ceiling, fog, and drizzle weather conditions, and the mountainous terrain at the accident site.Oct 3, 1994 · N3499R · DestroyedNTSB FTW95FA004Accident · Minor injuriesField investigationFinal reportBeech 1900D · Denver, COThe captain's inaccurate evaluation of weather conditions, and his decision to fly into known adverse weather. A factor was the hail.Oct 2, 1994 · N31YV · Substantial damageNTSB FTW95LA007Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Houston, TXThe pilot's selection of unsuitable terrain.Oct 1, 1994 · N5996X · Substantial damageNTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.Oct 1, 1994 · N732VK · DestroyedNTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.Oct 1, 1994 · N99600 · Substantial damageNTSB CHI94LA351Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · West Chicago, ILthe pilot's failure to use the manual hydraulic pump to lower the landing gear. Factors were the failure of the fuel selector handle, the subsequent fuel starvation, and the pilot's failure to properly crossfeed and restart the left engine.Sep 30, 1994 · N5272A · Substantial damageNTSB ATL94LA180Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Ozark, ALThe failure of the engines' main bearings because of a lack of lubrication. A factor was the heavily wooded terrain.Sep 29, 1994 · N41870 · Substantial damageNTSB FTW94LA317Accident · No injuriesLimited investigationFinal reportCessna 172B · Poteau, OKThe loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.Sep 28, 1994 · N7617X · Substantial damageNTSB ATL94FA179Accident · 1 fatalField investigationFinal reportRobinson R-22B · Knightdale, NCDivergence of the main rotor from its normal plane of rotation for an undetermined reason(s) resulting in rotor blade contact with the tailcone.Sep 28, 1994 · N83112 · DestroyedNTSB LAX94LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · San Mateo, CAA deteriorated magneto grounding ('P' lead) and failure of maintenance personnel to detect this condition when the engine was reinstalled in the airframe after overhaul. The lack of suitable terrain for the forced landing was a factor.Sep 25, 1994 · N39658 · Destroyed