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 FTW98IA130Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lawton, OKthe collapse of the left main landing gear during landing roll as result of a shorted weight-on-wheels relay. Contributing factors were the insufficient information available to the flight crew in the company's quick reference handbook (QRH), and the…Feb 22, 1998 · N396AE · Minor damageNTSB CHI98FA096Accident · 2 fatalField investigationFinal reportWasielak Sonerai II L · Malta, ILThe pilot's failed to maintain adequate clearance from the other aircraft.Feb 22, 1998 · N38NL · 2 aircraft · DestroyedNTSB ATL98FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Clinton, MSThe pilot's lack of recent instrument flight experience that led to spatial disorientation and loss of airplane control; and his improper use of carburetor heat that resulted in a loss of engine power and subsequent collision with the ground during an…Feb 22, 1998 · N9166W · DestroyedNTSB ATL98LA051Accident · Minor injuriesLimited investigationFinal reportPZL-Bielsko SZD-48-3 · Pikeville, TNThe loss of thermal lift.Feb 21, 1998 · N25MZ · Substantial damageNTSB ATL98LA050Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Perry Foley, FLa loose (or missing) carburetor drain plug and fuel line, due to an inadequate maintenance/annual inspection, which resulted in a fuel leak, fuel exhaustion, loss of engine power, and a forced landing. The obstructions (trees in the emergency landing area)…Feb 21, 1998 · N8648L · Substantial damageNTSB CHI98LA094Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Wood Lake, NEthe pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings.Feb 19, 1998 · N99270 · DestroyedNTSB IAD98LA028Accident · No injuriesLimited investigationFinal reportBeech 55B · Buffalo, NYImproper use of the fuel selector, which resulted in fuel starvation and loss of engine power.Feb 18, 1998 · N1072W · Substantial damageNTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.Feb 18, 1998 · N48878 · Substantial damageNTSB IAD98FA027Accident · 2 fatalField investigationFinal reportBeech C-90 · Newton, WVThe pilot inadequate management of the fuel system which resulted in fuel starvation to both engines. Factors in the accident were the pilot's concern about maintenance being completed prior to executing a scheduled flight later in the day, and operating the…Feb 16, 1998 · N5WU · DestroyedNTSB CHI98IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-212 · Memphis, TNthe inadequate (bronze) material used by the fuel pump's manufacturer, which wore and ultimately blocked the fuel filter bypass and partially blocked the fuel nozzles, causing the fuel spray to burn through the low pressure turbine case.Feb 16, 1998 · N341NW · Minor damageNTSB FTW98LA129Accident · No injuriesLimited investigationFinal reportEnstrom F-28C-2 · Broomfield, COwater contamination in the fuel, which resulted in loss of engine power and a forced (autorotative) landing. Factors relating to the accident were: darkness; and a high obstruction in the emergency landing area.Feb 15, 1998 · N5693M · Substantial damageNTSB LAX98FA086Accident · 1 fatalField investigationFinal reportBeech J35 · Morgan Hill, CAThe pilot-in-command's failure to maintain visual separation from N8343D approaching from his right. The controller's failure to provide a traffic advisory and the copilot's and flight engineer's inadequate visual lookout were factors.Feb 11, 1998 · N8343D · 2 aircraft · DestroyedNTSB ATL98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Deland, FLThe loss of engine power due to the pilots inadequate fuel management.Feb 8, 1998 · N925IT · Substantial damageNTSB FTW98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Sheridan, WYthe pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing.Feb 6, 1998 · N316T · Substantial damageNTSB ANC98LA020Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKThe pilot's poor in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power.Feb 6, 1998 · N7678L · Substantial damageNTSB FTW98FA121Accident · 1 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot attempting VFR flight into instrument meteorological conditions and his lack of an instrument rating. Factors were weather conditions that included mountain wave activity conducive to turbulence, and clouds obscuring the mountainous terrain.Feb 5, 1998 · N9213M · DestroyedNTSB FTW98FA117Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Graford, TXThe pilot's failure to maintain clearance with the ground. Factors were the dark night, the rising terrain, and the ground fog obscuring the ground.Feb 4, 1998 · N15566 · DestroyedNTSB MIA98LA066Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ochopee, FLpartial loss of engine power due to a fractured number 4 exhaust valve, which resulted in a forced landing; and the lack of sufficient airspeed to maneuver over power lines during an attempt to abort (go around from) an emergency landing, which resulted in an…Feb 1, 1998 · N94929 · Substantial damageNTSB MIA98LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Valkaria, FLthe pilot's inadequate preflight, and subsequent loss of engine power, due to fuel exhaustion, which resulted in a forced landing and impact with trees.Jan 31, 1998 · N6261E · Substantial damageNTSB MIA98LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe failure of the student to recover (pull-up) from the intentional maneuver resulting in the in-flight collision with terrain. Contributing to the accident was the ostentatious display by the student.Jan 31, 1998 · N738YK · Substantial damageNTSB SEA98LA031Accident · 1 fatalLimited investigationFinal reportCessna 150F · Havre, MTThe student pilot's loss of control after his failure to maintain airspeed. Factors include his lack of total flight experience and incapacitation due to alcohol.Jan 30, 1998 · N8798G · Substantial damageNTSB FTW98LA115Accident · No injuriesLimited investigationFinal reportCessna 182E · Steamboat Sprng, COThe total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made.Jan 30, 1998 · N2804Y · Substantial damageNTSB ANC98LA018Accident · Minor injuriesLimited investigationFinal reportCessna 208A · Port Heiden, AKThe pilot's inadequate in-flight decision resulting in airframe ice accumulation to the extent that degraded aircraft performance and insufficient airspeed occurred followed by a stall. Contributing factors were freezing rain and icing conditions.Jan 30, 1998 · N9316F · DestroyedNTSB FTW98LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lone Grove, OKThe total loss of engine power for an undetermined reason. Factors were the total loss of electrical power resulting from a separated alternator cable due to improper maintenance by unknown maintenance personnel, the lack of suitable terrain for the forced…Jan 29, 1998 · N43763 · Substantial damageNTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.Jan 28, 1998 · N16866 · DestroyedNTSB CHI98FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Faribault, MNwas the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot.Jan 26, 1998 · N5099W · DestroyedNTSB ATL98LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Laurens, SCThe pilot's inadequate weather evaluation that resulted in initiating flight in marginal visual conditions, and resulted in fuel exhaustion.Jan 24, 1998 · N2609K · Substantial damageNTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.Jan 23, 1998 · N8422P · Substantial damageNTSB FTW98TA104Accident · Minor injuriesFinal reportHughes 269C · Brackettville, TXfailure of splines on the drive shaft coupling after separation of the forward bubber boot and loss of lubrication (grease), which resulted in a disconnect of the rotor drive system and an autorotation/forced landing. Lack of suitable terrain in the forced…Jan 22, 1998 · N1093N · Substantial damageNTSB ATL98FA036Accident · 3 fatalField investigationFinal reportTwin Commander Acft. 695A · Delray Beach, FLThe pilot flew into known convective meterological conditions and lost control of the airplane. Factors were low clouds, and moderate to heavy rain.Jan 21, 1998 · N269M · DestroyedNTSB CHI98LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Naperville, ILimproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.Jan 19, 1998 · N8277W · DestroyedNTSB LAX98FA075Accident · 1 fatalField investigationFinal reportCessna 402C · Walker, CAThe pilot's encounter with a downdraft while approaching high terrain at an altitude insufficient to ensure adequate terrain or obstacle clearance.Jan 17, 1998 · N114GP · DestroyedNTSB ATL98LA032Accident · 2 fatalLimited investigationFinal reportVia Aero Comp AC6 · Rockledge, FLThe loss of engine power for undetermined reasons. A factor was the trees in the emergency landing area.Jan 17, 1998 · N656AC · DestroyedNTSB ATL98LA031Accident · No injuriesLimited investigationFinal reportChristopher Coats Challenger II · Evergreen, ALThe undetermined failure of the propeller bolts that resulted in the inflight separation of the propeller assembly. A factor was the overpass bridge.Jan 17, 1998 · N132BC · Substantial damageNTSB LAX98FA068Accident · 1 fatalField investigationFinal reportCessna 182P · Salinas, CAA loss of engine power due to a missing valve keeper. Also causal was the failure by engine maintenance personnel during engine top overhaul to install the second valve keeper in the No. 3 cylinder exhaust valve and the failure of inspection personnel to…Jan 10, 1998 · N8158M · DestroyedNTSB FTW98FA092Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Ennis, TXfailure of the flight crew to maintain minimum control speed (Vmc) during go-around from a single-engine approach, which resulted in loss of control and collision with power lines and the ground. Related factors were: a ruptured diaphragm in the distributor…Jan 10, 1998 · N556BW · DestroyedNTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.Jan 9, 1998 · N757CH · Substantial damageNTSB FTW98FA089Accident · Serious injuriesField investigationFinal reportCameron R-420 · Yeso, NMThe rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for…Jan 9, 1998 · N298AR · DestroyedNTSB FTW98FA088Accident · 2 fatalField investigationFinal reportMooney M20K · Vernon, TXthe loss of control during cruise flight for undetermined reasons.Jan 7, 1998 · N231DS · DestroyedNTSB CHI98FA080Accident · 1 fatalField investigationFinal reportCessna P210N · Decatur, ILThe pilot's failure to maintain control of the airplane. Contributing factors were low ceiling and freezing drizzle.Jan 7, 1998 · N6669P · DestroyedNTSB MIA98LA054Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Orlando, FLinadvertent encounter with turbulence, which resulted spillage of hot coffee in a passenger's lap.Jan 6, 1998 · N618DL · No damageNTSB FTW98FA086Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tremonton, UTThe pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow.Jan 4, 1998 · N23371 · DestroyedNTSB LAX98FA066Accident · 2 fatalField investigationFinal reportCessna 172M · Chandler, AZThe pilot's intentional flying at a low altitude and failure to see and avoid the power lines during dusk conditions.Jan 2, 1998 · N20118 · DestroyedNTSB MIA98FA047Accident · 2 fatalField investigationFinal reportCessna 414A · Guyton, GAInadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.Dec 29, 1997 · N414MT · DestroyedNTSB NYC98LA056Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Ferncliff, VAthe improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on…Dec 28, 1997 · N9717M · DestroyedNTSB FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…Dec 28, 1997 · N2815V · Substantial damageNTSB DCA98MA015Accident · 1 fatalMajor investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)The pilot-in-command's inadvertent flight into adverse weather conditions, and the difficulty of obtaining adequate weather forecasts of over-ocean turbulence. Factors contributing to the accident include the presence of clear air turbulence, and the failure…Dec 28, 1997 · N4723U · Minor damageNTSB NYC98LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Riverside, PAthe pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.Dec 26, 1997 · N8015V · Substantial damageNTSB MIA98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, SCThe pilot's inadequate preflight planning, and his poor in-flight decision making.Dec 26, 1997 · N9514K · Substantial damageNTSB MIA98LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Everglades City, FLthe pilot's improper fuel management and improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: the light conditions at dusk, and the lack of suitable terrain for a forced…Dec 22, 1997 · N9640J · Substantial damage