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 ANC02FA014Accident · 1 fatalField investigationFinal reportCessna 206 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate ground clearance, which resulted in an in flight collision with terrain. Factors associated with the accident were flat light conditions, and…Feb 4, 2002 · N756HL · DestroyedNTSB LAX02LA077Accident · No injuriesLimited investigationFinal reportBeech T-34B/D-45 · San Simeon, CAthe pilot's inadequate preflight of the airplane in which he failed to close the fuel drain resulting in a fuel leak and fuel exhaustion.Feb 3, 2002 · N34NL · Substantial damageNTSB MIA02LA057Accident · Serious injuriesLimited investigationFinal reportCessna R172E · River Ranch, FLThe reported loss of engine power due to undetermined reasons. Contributing factors in the accident were an improper flap setting, excessive landing speed, and terrain consisting of berms.Feb 1, 2002 · N7878N · Substantial damageNTSB LAX02FA073Accident · 1 fatalField investigationFinal reportPiper Aerostar 601P · Stonyford, CAthe pilot's failure to maintain terrain clearance during cruise flight, which resulted in the in-flight collision with mountainous terrain. Factors in the accident were the mountainous terrain and the dark night light conditions.Jan 31, 2002 · N3636M · DestroyedNTSB LAX02LA072Accident · 2 fatalLimited investigationFinal reportHillyer XL-RG Velocity · San Diego, CAThe pilot's improper in-flight planning and decision making, which resulted in exhaustion of the airplane's fuel supply and loss of engine power.Jan 30, 2002 · C-FPDL · DestroyedNTSB CHI02FA074Accident · 2 fatalField investigationFinal reportCessna 441 · Winfield, KSThe pilot's spatial disorientation resulting in a loss of control and collision with the ground. Additional factors included the pilot operating the airplane with known deficiencies and the instrument flight conditions.Jan 30, 2002 · N441AR · DestroyedNTSB MIA02LA054Accident · 1 fatalLimited investigationFinal reportQuitzau, Carl Vortex · Immokalee, FLThe failure of the pilot to maintain directional control of the gyroplane resulting in the in-flight loss of control and subsequent in-flight collision with terrain.Jan 26, 2002 · None · Substantial damageNTSB MIA02LA051Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Levittown, PRthe failure of maintenance personnel to comply with aircraft manufacturer's inspection procedures, resulting in corrosion and separation of the aileron control cable in flight and the subsequent forced landing in a swamp.Jan 26, 2002 · N99295 · Substantial damageNTSB NYC02FA051Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Chittenden, VTThe pilot's failure to maintain aircraft control while holding.Jan 25, 2002 · N104CS · DestroyedNTSB MIA02LA053Accident · No injuriesLimited investigationFinal reportCessna 182L · Boca Raton, FLThe pilot's failure to perform a proper preflight inspection and refueling of the aircraft, resulting in an in-flight loss of engine power due to fuel exhaustion and a collision with a road sign during the emergency landing.Jan 25, 2002 · N182JM · Substantial damageNTSB CHI02FA067Accident · 1 fatalField investigationFinal reportCessna 402B · Bronson, MIThe maneuver to avoid the utility wire while maneuvering resulting in an inadvertent stall and subsequent impact with the ground. Factors were the pilot's inadvertent activation of the elevator trim, resulting in a loss of control during flight in instrument…Jan 23, 2002 · N371JD · DestroyedNTSB NYC02LA049Accident · 1 fatalLimited investigationFinal reportStiles Choctaw · Danville, KYFailure of a connecting rod bearing, which resulted in a loss of engine power during climb.Jan 22, 2002 · N97CS · Substantial damageNTSB SEA02FA030Accident · Serious injuriesField investigationFinal reportAgusta A109A II · Baring, WAThe sequential non-mechanical total loss of power in both engines 1 and 2 for undetermined reasons and the pilot's failure to maintain adequate rotor RPM to prevent a hard landing. Contributing factors were the tripped "RPM WARN" circuit breaker which…Jan 20, 2002 · N55NW · Substantial damageNTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.Jan 17, 2002 · N339S · DestroyedNTSB ANC02FA010Accident · 1 fatalField investigationFinal reportPiper PA-32 · Haines, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with trees while in cruise flight. Factors in the accident were weather conditions consisting of freezing rain, mist, and low ceilings.Jan 15, 2002 · N30004 · Substantial damageNTSB LAX02LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Groveland, CAthe pilot's improper preflight planning and improper weather evaluation.Jan 14, 2002 · N3624R · Substantial damageNTSB SEA02LA028Accident · No injuriesLimited investigationFinal reportCessna 150M · Clinton, WAFuel exhaustion while in cruise flight resulting in a loss of engine power and the pilot's failure to refuel the aircraft. The pilot's inadequate preflight planning/preparation and a fence post were factors.Jan 13, 2002 · N704NY · Substantial damageNTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.Jan 13, 2002 · N2669J · DestroyedNTSB CHI02LA063Accident · No injuriesLimited investigationFinal reportBeech V35B · Mattoon, ILA loss of engine power for undetermined reasons. Factor to the accident was the unsuitable rough/uneven terrain encountered during the forced landing.Jan 13, 2002 · N4217S · Substantial damageNTSB DEN02LA019Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 902 · Aurora, COthe pilot's failure to maintain aircraft control due to inadvertent settling with power resulting in a hard landing. Contributing factors include the improperly planned approach, the high density altitude, and the encounter with vortex ring state.Jan 11, 2002 · N902AM · Substantial damageNTSB FTW02LA064Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Grand Isle 74The pilot's misjudged landing flare. A contributing factor was the fatigue fracture of the PC air line due to the improper installation by company maintenance personnel, which resulted in a loss of engine power.Jan 8, 2002 · N349AL · Substantial damageNTSB CHI02LA060Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Sturgis, MIthe inadequate in-flight emergency planning/decision, the checklist not followed and excessive approach altitude by the pilot. Contributing factors were the loose oil return line and weather.Jan 6, 2002 · N6560C · Substantial damageNTSB LAX02FA059Accident · 1 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe pilot's intentional flight of the airplane into terrain in an act of suicide.Jan 5, 2002 · N24223 · DestroyedNTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.Jan 5, 2002 · N2371N · DestroyedNTSB ATL02FA031Accident · 5 fatalField investigationFinal reportCessna 441 · Rio Grande, PRThe pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.Jan 5, 2002 · N441AW · DestroyedNTSB SEA02TA022Accident · No injuriesFinal reportHughes 369D · Butte, MTLoss of engine power for undetermined reasons.Jan 3, 2002 · N8393F · Substantial damageNTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.Jan 1, 2002 · N3525Y · Substantial damageNTSB IAD02LA022Accident · No injuriesLimited investigationFinal reportCessna 310H · Tappahannock, VAThe pilot's inadequate compensation for the gusty wind conditions. Factors in the accident were the gusty wind conditions and the total loss of left engine power due to the alternate air valve becoming disconnected and embedded in the fuel injector servo.Dec 30, 2001 · N10MS · Substantial damageNTSB ATL02FA025Accident · 1 fatalField investigationFinal reportCessna C-210N · Lilburn, GAThe pilot's failure to maintain aircraft control.Dec 29, 2001 · N139JP · DestroyedNTSB CHI02IA058Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Chicago, ILThe wake turbulence encounter.Dec 28, 2001 · N941UA · No damageNTSB ATL02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Trenton, FLThe pilot's improper in-flight decision to make a precautionary landing after sustaining a total loss of electrical power with sufficient fuel remaining to reach his destination airport. This resulted in an off field landing to an off site location in a…Dec 28, 2001 · N4452Q · Substantial damageNTSB NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.Dec 27, 2001 · N660DD · Substantial damageNTSB FTW02TA060Accident · No injuriesFinal reportBell OH-58A · El Paso, TXThe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the moving ground vehicle.Dec 27, 2001 · N76PD · Substantial damageNTSB ATL02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kennesaw, GAThe pilot's improper in-flight planning/decision resulting in a total loss of engine power due to fuel exhaustion,which resulted in a forced landing, and subsequent in-flight collision with transmission wires.Dec 27, 2001 · N3035L · Substantial damageNTSB LAX02LA055Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAThe pilot's inadequate preflight and in-flight planning/decision resulting in miscalculation of fuel consumption, fuel exhaustion and loss of engine power. Factors were rough terrain in a vineyard, power lines in the landing area, and night time.Dec 25, 2001 · N1309M · Substantial damageNTSB LAX02FA056Accident · 2 fatalField investigationFinal reportCessna 172N · San Clemente, CAa loss of engine power due to a loss of magneto to engine timing resulting from stress corrosion crack induced fracture, and separation of the magneto impulse coupling spring.Dec 25, 2001 · N738BC · DestroyedNTSB IAD02LA020Accident · No injuriesLimited investigationFinal reportCessna 401A · Martinsburg, WVthe owner/mechanic's failure to comply with an Airworthiness Directive, which resulted in a cracked fuel supply line and subsequent in-flight fire.Dec 17, 2001 · N4062Q · Substantial damageNTSB CHI02LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-34 · Clinton, MOthe pilot's inadequate prefight, his failure to feather the propellers, and the fuel exhaustion.Dec 17, 2001 · N4354A · Substantial damageNTSB FTW02LA053Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Sierra Blanca, TXthe pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.Dec 13, 2001 · N4530K · Substantial damageNTSB CHI02IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILReason for occurrence is undetermined.Dec 13, 2001 · N359UA · No damageNTSB CHI02FA049Accident · 1 fatalField investigationFinal reportRobinson R44 · Waukesha, WIThe pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.Dec 13, 2001 · N7007F · DestroyedNTSB FTW02FA048Accident · 2 fatalField investigationFinal reportGates Learjet 24D · Sierra Blanca, TXloss of control during descent for undetermined reasons.Dec 11, 2001 · N997TD · DestroyedNTSB LAX02LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIFuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.Dec 10, 2001 · N6136G · Substantial damageNTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.Dec 10, 2001 · N2359C · DestroyedNTSB FTW02FA054Accident · 2 fatalField investigationFinal reportCessna T210-M · Monticello, ARThe separation of the #2 connecting rod and subsequent catastrophic failure of the engine. A factor was the in-flight collision with a vehicle while maneuvering to a emergency landing area.Dec 9, 2001 · N317RG · DestroyedNTSB CHI02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · O'Neill, NEThe inadequate preflight planning by the pilot resulting in the exhaustion of the fuel supply, and the pilot not maintaining directional control during the forced landing. A factor was the unsuitable landing area selected by the pilot, and the ditch.Dec 9, 2001 · N2492K · Substantial damageNTSB FTW02LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Haltom City, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Dec 7, 2001 · N1212B · Substantial damageNTSB ATL02LA016Accident · Minor injuriesLimited investigationFinal reportWhitty, Philip J. Mustang II · Hampstead, NCA loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over during landing roll. A factor was the soft, unsuitable terrain.Dec 4, 2001 · N888PW · Substantial damageNTSB LAX02FA038Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · El Dorado, CAthe pilot's intentional flight into adverse weather conditions and his subsequent failure to maintain aircraft control.Dec 3, 2001 · N6946P · DestroyedNTSB CHI02LA043Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Romulus, MIThe turbulence encountered in-flight and the passenger not complying with the flight and cabin crew’s warning of the turbulance.Nov 30, 2001 · N488AA · No damage