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 SEA03LA097Accident · No injuriesLimited investigationFinal reportCessna 172H · Glasgow, MTA loss of engine power due to carburetor icing. Contributing factors were carburetor icing conditions and the muddy, wet terrain at the landing site.Jun 7, 2003 · N2786L · Substantial damageNTSB LAX03LA183Accident · Minor injuriesLimited investigationFinal reportBell 206B · Malone, TXa fuel starvation induced loss of engine power due to fuel contamination.Jun 6, 2003 · N242TK · Substantial damageNTSB LAX03FA182Accident · 5 fatalField investigationFinal reportBeech A36TC · Los Angeles, CAthe pilot's in-flight loss of control due to spatial disorientation, and failure to maintain airspeed, which resulted in a stall/spin. Also causal was the pilot's disregard of the weather information provided and his attempt to continue VFR flight into IMC. A…Jun 6, 2003 · N1856P · DestroyedNTSB SEA03LA093Accident · No injuriesLimited investigationFinal reportCessna 175 · Middleton, IDThe pilot's failure to follow the checklist which led to fuel starvation and subsequent loss of engine power. A contributing factor was the uneven terrain at the landing site.Jun 5, 2003 · N7238M · Substantial damageNTSB LAX03LA181Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-321 · Payson, AZThe flight's encounter with convectively induced turbulence associated with developing thunderstorms while the flight crew attempted to deviate around an area of adverse weather. The turbulence event occurred while the crew was attempting to maneuver around…Jun 5, 2003 · N644AW · No damageNTSB ATL03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hamilton, ALThe pilot's inadequate preflight inspection by his failure to ensure adequate oil supply, which resulted in oil exhaustion and the failure of the connecting rod cap.Jun 5, 2003 · N44541 · Substantial damageNTSB DEN03LA094Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-111 · Denver, COthe inflight encounter with severe turbulence.Jun 3, 2003 · N910FR · No damageNTSB CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.Jun 3, 2003 · N630SW · DestroyedNTSB DEN03LA095Accident · No injuriesLimited investigationFinal reportCessna 425 · Pueblo, COthe pilot's inadvertent flight into adverse weather conditions. Contributing factors include the encounter with severe turbulence and hail.May 31, 2003 · N425SG · Substantial damageNTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.May 31, 2003 · N389Q · Substantial damageNTSB SEA03FA089Accident · 2 fatalField investigationFinal reportCessna 172 · Republic, WAThe pilot's failure to maintain airspeed resulting in a stall and subsequent loss of control during low altitude maneuvering.May 30, 2003 · N7301A · Substantial damageNTSB LAX03LA172Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Livermore, CAthe pilots acceptance of a clearance meant for another aircraft. Contributing to the accident was the failure of departure controller to detect the pilot's incorrect read back and the controllers improper radio technique, which increased the chances of call…May 30, 2003 · N3060K · Substantial damageNTSB FTW03LA163Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Brazos Blk 532undetermined, aircraft not recovered.May 29, 2003 · N7188K · DestroyedNTSB LAX03LA169Accident · Minor injuriesLimited investigationFinal reportCallahan Rebel · Clearlake, CAfuel starvation due to the pilot's inadequate preflight inspection and failure to correctly position the right fuel valve. Also causal was the pilot's failure to use the checklist.May 28, 2003 · N6324H · Substantial damageNTSB ANC03FA051Accident · 4 fatalField investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall, an uncontrolled descent and in-flight collision with terrain. A factor associated with the accident was rising terrain.May 28, 2003 · N70176 · DestroyedNTSB NYC03LA115Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman D75-N1 · Avis, PAA loss of engine power due to carburetor ice. A factor in this accident were weather conditions favorable to carburetor ice.May 26, 2003 · N59768 · Substantial damageNTSB MIA03LA114Accident · No injuriesLimited investigationFinal reportCessna 172E · Hastings, FLThe failure of the pilot to maintain control of the airplane resulting in in-flight collision with terrain.May 26, 2003 · N817T · Substantial damageNTSB LAX03LA164Accident · No injuriesLimited investigationFinal reportCessna T207A · Page, AZa loss of engine power due to a oil starvation induced catastrophic internal failure of the engine caused by the rotation of the number 2 cylinder main bearing. This narrative was modified on February 16, 2005.May 26, 2003 · N9317M · Substantial damageNTSB LAX03FA162Accident · 2 fatalField investigationFinal reportNorth American T28C · Sherman Oaks, CAThe pilot's in-flight loss of control due to spatial disorientation. Factors in the accident were the distraction caused by the malfunctioning mode C altitude reporting system, and the location of the transponder control head, which necessitated repeated…May 24, 2003 · N537Z · DestroyedNTSB DEN03LA088Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Cedar City, UTthe pilot's inadvertently switching the fuel selector to the right tank, resulting in fuel starvation, and his failure to maintain direction control during the forced landing. Contributing factors were the crosswind and the tree.May 23, 2003 · N8199T · DestroyedNTSB LAX03LA160Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Kahoolawe, HIThe pilot's failure to remove the external load cable before the repositioning flight, which resulted in the cable striking the tail rotor in cruise flight.May 22, 2003 · N3280U · DestroyedNTSB LAX03FA161Accident · 2 fatalField investigationFinal reportCessna 177RG · Ely, NVthe airplane collided with terrain for undetermined reasons.May 22, 2003 · N8034G · Substantial damageNTSB NYC03FA113Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bruceton Mills, WVThe pilot's intentional decision to continue visual flight into instrument meteorological conditions, and his failure to maintain obstacle clearance which resulted in the airplane striking a guy wire on the communications antenna. A factor was the fog.May 21, 2003 · N55995 · DestroyedNTSB CHI03LA133Accident · 1 fatalLimited investigationFinal reportAir & Space 18A · South Shore, SDThe pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.May 19, 2003 · N6155S · DestroyedNTSB SEA03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Salem, ORLoss of power in cruise flight due to a catastrophic engine failure for undetermined reasons.May 15, 2003 · N2913F · Substantial damageNTSB NYC03LA106Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · New Canaan, CTThe inadequate annual inspection performed by maintenance facility personnel, which resulted in a failure of a fuel system bellcrank. Factors were the subsequent inadequate inspections by other maintenance personnel and the pilot.May 15, 2003 · N109JS · Substantial damageNTSB FTW03LA151Accident · No injuriesLimited investigationFinal reportCessna A188B · Kinta, OKThe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's failure to supervise the refueling of the aircraft and failure to use his before takeoff checklist.May 15, 2003 · N4931R · Substantial damageNTSB LAX03TA150Accident · Serious injuriesFinal reportHughes OH 6A · Pan Tak, AZThe pilot in command's failure to adequately secure loose cargo (a jacket), which resulted in the jacket colliding with the tail rotor during cruise flight, and the subsequent separation of the tail rotor and loss of flight control. A factor associated with…May 12, 2003 · N6636H · DestroyedNTSB MIA03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Brooksville, FLThe in-flight collision with a Black Vulture resulting in substantial damage.May 11, 2003 · N7KH · Substantial damageNTSB FTW03FA148Accident · No injuriesField investigationFinal reportBell 407 · Gulf Of MexicoThe short circuit of the C321capacitor in the Electronic Control Unit (ECU) that resulted in a single-point failure of the ECU's -15V power supply which disengaged/reverted the Hydro-mechanical Unit (HMU) from automatic to manual fuel control. Factors…May 11, 2003 · N491PH · Substantial damageNTSB DEN03TA079Accident · 1 fatalFinal reportMcDonnell Douglas A-4N · Salt Lake City, UTThe lose of engine power during descent due to the in-flight collision with a bird which FOD damaged the engine and subsequently melted the turbine section. A contributing factor was the airplane's malfunctioning ejection seat.May 10, 2003 · N263WL · DestroyedNTSB SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.May 8, 2003 · N5030B · DestroyedNTSB ATL03IA090Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Chattanooga, TNExcessive wear on the bushings and the right aileron inboard and outboard power control unit output link resulting in the upward movement of the right aileron during cruise climb, uncommanded right roll. A factor in the accident was inadequate maintenance…May 8, 2003 · N829AS · No damageNTSB NYC03LA104Accident · Serious injuriesLimited investigationFinal reportBoeing B767-300 · New Market, VAThe inadvertent encounter with turbulence.May 7, 2003 · N650UA · No damageNTSB FTW03FA145Accident · 2 fatalField investigationFinal reportBell Shelby Aero 47G2 · Ardmore, OKThe pilot's failure to control the rate of descent, which resulted in an improper touchdown of the helicopter. A contributing factor was the loss of throttle control for undetermined reasons.May 7, 2003 · N1774 · DestroyedNTSB ATL03FA089Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Calhoun, GAThe pilot's failure to obtain a preflight weather briefing, which would have indicated that MVFR to IFR conditions prevailed over the route with embedded thunderstorms and rain, and his decision to continue VFR flight into instrument meteorological…May 5, 2003 · N32038 · DestroyedNTSB LAX03FA147Accident · 1 fatalField investigationFinal reportCessna 411 · Corona, CAThe failure of the pilot to properly configure the airplane for a one engine inoperative condition (including his failure to feather the propeller of the affected engine, retract the landing gear, and maintain minimum single engine speed). Factors related to…May 4, 2003 · N1133S · DestroyedNTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.May 3, 2003 · N2938J · Substantial damageNTSB SEA03LA075Accident · Minor injuriesLimited investigationFinal reportDeJager RV-6 · Bellingham, WAThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power.Apr 29, 2003 · N239D · Substantial damageNTSB SEA03LA070Accident · No injuriesLimited investigationFinal reportCessna 182C · Stanley, IDThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power during descent. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Apr 27, 2003 · N8690T · Substantial damageNTSB LAX03FA142Accident · 2 fatalField investigationFinal reportCessna TR182 · Eagleville, CAthe pilot's encounter with mountain wave activity with downdrafts and severe turbulence, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was the pilot's improper decision to continue flight into an area of…Apr 26, 2003 · N327PC · DestroyedNTSB IAD03MA049Accident · 1 fatalMajor investigationFinal reportSino-Swearingen SJ30-2 · Loma Alta, TXThe manufacturer's incomplete high-Mach design research, which resulted in the airplane becoming unstable and diverging into a lateral upset.Apr 26, 2003 · N138BF · DestroyedNTSB IAD03LA048Accident · Serious injuriesLimited investigationFinal reportDornier 328-300 · Roanoke, VAThe airplane's encounter with unforecasted clear air turbulence during cruise flight.Apr 25, 2003 · N427FJ · No damageNTSB DEN03LA077Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Sedan, NMthe nonmechanical partial loss of engine power due to water contamination of the fuel. Contributing factors include the lack of suitable terrain for a forced landing (due to his low altitude), and the irrigation system (object) that was impacted.Apr 24, 2003 · N318BR · Substantial damageNTSB SEA03LA069Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Bonanza, ORSeparation of the connecting rod cap. Annual maintenance inspections which were disregarded by the owner/pilot was a factor.Apr 23, 2003 · N8159T · Substantial damageNTSB CHI03LA113Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Lithonia, GAThe flight into adverse weather encountered by the flight crew, and the flight attendant's restraint not available when she was informed to take her seat. The convective associated turbulence was a contributing factor.Apr 21, 2003 · N504UA · No damageNTSB SEA03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Trident, MTFuel exhaustion while in cruise flight due to inadequate preflight planning / preparation. A fence was a factor.Apr 20, 2003 · N9705T · Substantial damageNTSB CHI03LA120Accident · No injuriesLimited investigationFinal reportYadon Starflight Stiletto · Peculiar, MOThe pilot's inadvertent shutdown of the engine. Contributing factors were unsuitable terrain and trees.Apr 20, 2003 · N42KY · Substantial damageNTSB SEA03LA076Accident · No injuriesLimited investigationFinal reportFokker F27MK 600 · Port Townsend, WAThe failure of the accessory drive shaft due to deterioration of bearing number 1 in the aft fork of the universal joint for undetermined reasons during cruise flight.Apr 17, 2003 · N730FE · Substantial damageNTSB DEN03IA067Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Salt Lake City, UTtotal failure of a fuel flex line. A contributing factor was a fuel leak, resulting in an inflight engine compartment fire.Apr 17, 2003 · N6712B · Minor damage