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 FTW01LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Marfa, TXfuel exhaustion resulting in a total loss of engine power in cruise flight due to the pilot's failure to refuel the aircraft. Contributing factors were the lack of suitable terrain for the forced landing, and the dark night condition.Apr 30, 2001 · N6388F · Substantial damageNTSB LAX01LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Henderson, NVThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion and a forced landing in rough terrain.Apr 29, 2001 · N2567C · Substantial damageNTSB NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.Apr 28, 2001 · N55588 · DestroyedNTSB LAX01LA161Accident · Serious injuriesLimited investigationFinal reportTaylor Bandit · Marysville, CAThe pilot performed an inadequate preflight inspection resulting in a loss of engine power at a low altitude because of water contamination.Apr 28, 2001 · N8057T · DestroyedNTSB MIA01LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 42-300 · Atlantic Ocean (Atlantic Ocean)The in-flight encounter with moderate to severe turbulence in clouds resulting in the serious injury to the flight attendant. A contributing factor in the accident was the poor in-flight planning by the captain for his allowing beverage service to continue…Apr 26, 2001 · N223AT · No damageNTSB MIA01LA130Accident · No injuriesLimited investigationFinal reportCessna 210N · Gainesville, FLThe pilot's delay in securing all non-essential electrical equipment in-flight resulting in battery depletion before complete gear extension was accomplished using the normal system and subsequent collapse of the main landing gear. A contributing factor in…Apr 26, 2001 · N6585A · Substantial damageNTSB IAD01LA048Accident · No injuriesLimited investigationFinal reportCessna 208B · Plattsburgh, NYThe incorrect installation of the propeller reversing lever and carbon block assembly, which resulted in a loss of propeller thrust.Apr 26, 2001 · N974FE · Substantial damageNTSB NYC01IA107Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Norfolk, VAThe manufacturer's inadequate quality control, which resulted in a jammed elevator trim actuator.Apr 25, 2001 · N29917 · No damageNTSB MIA01LA128Accident · No injuriesLimited investigationFinal reportSteen Aero Lab Skybolt I · Germantown, TNThe pilot's failure to conduct proper preflight planning and preparation, resulting in fuel exhaustion during cruise flight, and the subsequent emergency descent and forced landing to a residential street colliding with a vehicle, utility pole, mail box, and…Apr 25, 2001 · N14DE · Substantial damageNTSB LAX01FA152Accident · 1 fatalField investigationFinal reportCessna 310F · Carmel Valley, CAThe in-flight loss of control of the airplane in instrument meteorological conditions for undetermined reasons.Apr 22, 2001 · N5834X · DestroyedNTSB IAD01LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · King George, VAThe failure of cylinder case and thru studs due to fatigue, which resulted in a loss of engine power over unsuitable terrain.Apr 22, 2001 · N40066 · Substantial damageNTSB CHI01LA120Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Culver, INthe wrong runway selected by the pilot which resulted in a tailwind landing condition. Factors to the accident were the tailwind, the wet runway, the reduced braking action, and the airport perimeter fence.Apr 22, 2001 · N118VU · Substantial damageNTSB ANC01LA050Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Glennallen, AKA total failure of the engine and subsequent rupture of the crankcase during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.Apr 22, 2001 · N6912M · DestroyedNTSB MIA01LA127Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Alexander City, ALA total loss of engine power during cruise flight due to an internal disconnection in the fuel injector control assembly as a result of a failure of the maintenance facility to follow proper installation procedures, resulting in a forced landing and collision…Apr 20, 2001 · N181DM · Substantial damageNTSB LAX01LA136Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the pilot-in-command to properly evaluate a hazardous weather advisory and his failure to adequately alter course and flight altitude to avoid the area of hazardous weather.Apr 19, 2001 · N654AW · No damageNTSB LAX01LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Lancaster, CAThe pilot's delay reversing course while flying toward rising terrain in a box canyon. Factors in the accident included a downdraft on the lee side of a ridge forming the box canyon, high density altitude, and the pilot's improper use of flaps.Apr 18, 2001 · N4672L · Substantial damageNTSB ATL01LA049Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLThe flight dispatcher failure to provide the flight crew with current in-flight turbulence information that resulted in the in-flight encounter with turbulence during climb. A factor was the pilots failure to obtain adequate weather information.Apr 17, 2001 · N253US · No damageNTSB LAX01LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Flagstaff, AZThe loss of engine power during cruise flight for undetermined reasons that resulted in a forced landing in rough terrain.Apr 14, 2001 · N8731W · Substantial damageNTSB CHI01LA115Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180AC · Buffalo, MNthe water contamination of the aircraft's fuel system and the inadequate preflight performed by the pilot. The muddy terrain was a contributing factor.Apr 14, 2001 · N4261E · Substantial damageNTSB FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…Apr 13, 2001 · N5638T · DestroyedNTSB LAX01FA145Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Sierra Vista, AZthe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting conditions.Apr 11, 2001 · N116CD · DestroyedNTSB NYC01LA096Accident · Serious injuriesLimited investigationFinal reportDornier 328-100 · Springfield, VAAn inadvertent encounter with turbulence during descent.Apr 10, 2001 · N423JS · No damageNTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…Apr 8, 2001 · N6460D · Substantial damageNTSB NYC01LA095Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Slanesville, WVa loose mixture control cable housing which resulted in an intermittent running engine, and the pilot's subsequent decision to perform a precautionary landing. A factor was the soft terrain.Apr 7, 2001 · N974CA · Substantial damageNTSB MIA01LA115Accident · Minor injuriesLimited investigationFinal reportJerome Wells KR-2 · Nashville, NCthe pilot's improper preflight inspection, which resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and and a forced landing to a field and damage to the aircraft during the forced landing.Apr 7, 2001 · N8089K · Substantial damageNTSB FTW01FA095Accident · 2 fatalField investigationFinal reportCessna 190 · Lurton, ARthe pilot's continued VFR flight into IMC, which resulted in spatial disorientation and the ensuing loss of aircraft control while in cruise flight. Contributory factors were the haze and fog weather conditions.Apr 7, 2001 · N1055D · DestroyedNTSB LAX01LA140Accident · No injuriesLimited investigationFinal reportCessna 210B · Camp Verde, AZThe throttle linkage disconnection resulting in the engine producing idle power. A factor was the lack of suitable terrain for a forced landing.Apr 6, 2001 · N126RA · Substantial damageNTSB ATL01FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Jasper, GAThe pilot disregarded preflight weather briefing information, and continued visual flight into known instrument weather conditions and collided with trees.Apr 6, 2001 · N31566 · DestroyedNTSB MIA01LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Osteen, FLThe pilot in command, flight instructor's delayed feathering of the right propeller after engine failure resulting in the airplane being unable to maintain altitude with the remaining engine and damage to the airplane during a forced landing in a field.Apr 4, 2001 · N3060D · Substantial damageNTSB ATL01LA047Accident · No injuriesLimited investigationFinal reportBell OH-58A · Lakeland, FLThe pilots failure to properly use the helicopter checklistApr 3, 2001 · N921MC · Substantial damageNTSB MIA01LA113Accident · 1 fatalLimited investigationFinal reportLarry R. Kinsey Variez O-235 · Pinson, ALThe pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.Mar 31, 2001 · N49LK · DestroyedNTSB LAX01LA133Accident · No injuriesLimited investigationFinal reportCessna 150J · Fortuna, CALoss of engine power in cruise flight for undetermined reasons and subsequent forced landing in water.Mar 31, 2001 · N60051 · Substantial damageNTSB LAX01LA131Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Redlands, CAA total loss of engine power during cruise flight over rough terrain for undetermined non-mechanical reasons.Mar 31, 2001 · N8158K · Substantial damageNTSB IAD01FA039Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Paris, VApilot's continued visual flight into instrument meteorological conditions.Mar 31, 2001 · N5841P · Substantial damageNTSB FTW01LA090Accident · No injuriesLimited investigationFinal reportMooney M20J · Pecos, TXthe pilot's failure to obtain a proper glide path during landing, which resulted in the airplane's impact with terrain short of the runway. Contributory factors were the open baggage door and the pilot's diverted attention to the open door.Mar 30, 2001 · N4498H · Substantial damageNTSB ATL01LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cross City, FLThe fracture of the crankshaft assembly that resulted in a total loss of engine power.Mar 30, 2001 · N7640P · Substantial damageNTSB ANC01LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's continued VFR flight into instrument metrological conditions during cruise flight. Factors associated in the accident were low ceilings, whiteout conditions, and snow-covered terrain.Mar 29, 2001 · N4028H · Substantial damageNTSB DEN01LA077Accident · No injuriesLimited investigationFinal reportBell UH-1H · Zuni, NMa hard landing due to the pilot's failure to maintain aircraft control during autorotation/flare. A factor was the total loss of engine power due to mechanical failure.Mar 25, 2001 · N56CF · Substantial damageNTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.Mar 24, 2001 · N4823V · Substantial damageNTSB SEA01LA067Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Carr Inlet, WAFatigue fracture of the propeller attaching bolts resulting in the total separation of the propeller assembly from the crankshaft flange.Mar 23, 2001 · N6295K · Substantial damageNTSB NYC01LA088Accident · Serious injuriesLimited investigationFinal reportBell 206 L-1 · Seneca Falls, NYthe loss of a bolt in a Thomas coupling on the tail rotor drive shaft, for undetermined reasons, during climb, while operating over unsuitable terrain.Mar 23, 2001 · N2138Y · Substantial damageNTSB FTW01TA084Accident · No injuriesFinal reportCessna 152 · Antlers, OKfuel exhaustion in cruise flight due to the pilot's delay in refueling. A contributing factor was the lack of suitable terrain for the forced landing.Mar 23, 2001 · N5308M · Substantial damageNTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.Mar 21, 2001 · N8346E · Substantial damageNTSB LAX01LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Stanford, CAFailure of company maintenance personnel to properly install and safety wire the oil filter, which subsequently lead to a loss of engine power.Mar 20, 2001 · N6307R · Substantial damageNTSB LAX01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Ojai, CAA loss of engine power for undetermined reasons.Mar 19, 2001 · N6123A · Substantial damageNTSB DEN01LA072Accident · No injuriesLimited investigationFinal reportCessna 182A · Richfield, UTloss of engine power during cruise as a result of fuel exhaustion due to the pilots failure to refuel. Contributing factors were the pilots inadequate aircraft preflight and the unsuitable terrain for a forced landing.Mar 19, 2001 · N4918D · Substantial damageNTSB DCA01MA031Accident · No injuriesMajor investigationFinal reportEmbraer EMB-120 · West Palm Beach, FLthe failure of the flight crew to maintain airspeed during an encounter with severe icing conditions, which resulted in an inadvertent stall, loss of control, and structural damage to the airplane.Mar 19, 2001 · N266CA · Substantial damageNTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.Mar 16, 2001 · N9277X · Substantial damageNTSB ATL01FA040Accident · No injuriesField investigationFinal reportDouglas DC-3 · Donalsonville, GAThe failure and separation of No.12 cylinder from the engine case that resulted in an in-flight oil fed fire; and the subsequent separation of the right engine from airframe.Mar 16, 2001 · N842MB · Substantial damageNTSB ATL01LA039Accident · No injuriesLimited investigationFinal reportCessna 182B · Boynton Beach, FLThe failure of a propeller actuator pin that resulted in an engine vibration and the loss of thrust. The airplane nosed over during the emergency landing roll. A factor was rough/uneven terrain.Mar 15, 2001 · N2502G · Substantial damage