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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW96LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Granite, COAn encounter with clear air turbulence.NTSB SEA96FA134Accident · 2 fatalField investigationFinal reportCessna 150B · Hailey, IDthe pilot's improper planning/decision, and his failure to maintain adequate airspeed during a climb over rising terrain, which resulted in a stall and collision with terrain. Factors relating to the accident were: failure of the pilot to ensure the airplane…NTSB FTW96LA269Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-340-200 · Dfw Airport, TXThe flightcrew's abrupt maneuver/descent in response to a TCAS RA. Factors were the company assignment of the captain to the crew position with a lack of captain training.NTSB FTW96LA266Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Abilene, TXfuel mismanagement by the pilot, which resulted in fuel starvation; and the pilot's failure to reposition the fuel selector (follow emergency procedure) while attempting to restart the engine. A factor relating to aircraft damage was: concrete debris (rocks)…NTSB FTW96FA267Accident · 4 fatalField investigationFinal reportBeech 58 · Castle Rock, COfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while reversing course to exit adverse weather conditions. Factors relating to the accident were: the adverse weather conditions (thunderstorm, low ceiling and reduced…NTSB FTW96FA265Accident · 4 fatalField investigationFinal reportMbb BO-105 · Sabine Pass, TXThe failure of the sun gear within the main transmission resulting in the main rotor system not being driven.NTSB CHI96LA212Accident · No injuriesLimited investigationFinal reportBeech C23 · Ainsworth, NEthe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and the pilot's selection of an unsuitable landing area for the forced landing.NTSB FTW96LA263Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec AN-2 · Weir, TXengine seizure for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA208Accident · No injuriesLimited investigationFinal reportAerotechnik L-13 · Wichita, KSthe pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.NTSB SEA96LA126Accident · No injuriesLimited investigationFinal reportPrice Berkut · Jackson, WYfailure of the electrically driven hydraulic pump; and the absence of the main landing gear over-center downlock springs, which were not installed by the previous owner/builder.NTSB SEA96FA130Accident · 1 fatalField investigationFinal reportHughes 269C · Eldon, WAfatigue failure of the connecting rod cap, which resulted in loss of engine power and ditching at sea.NTSB LAX96FA236Accident · 3 fatalField investigationFinal reportBeech C23 · Los Angeles, CAcompany maintenance personnel's inadequate service of the magneto system, and their failure of to replace the electric fuel boost pump, which led to a malfunctioning right magneto and an inoperative fuel boost pump. The inoperative fuel boost pump made it…NTSB IAD96IA098Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Jamaica, NYfailure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.NTSB LAX96LA232Accident · Minor injuriesLimited investigationFinal reportMoore Goshawk 350 · Livermore, CAan overstress failure of the left rudder cable.NTSB LAX96FA244Accident · 2 fatalField investigationFinal reportCessna 152 · Carmel, CAThe pilot becoming lost and disoriented during a night VFR flight in marginal weather conditions. Factors in the accident were: the pilot's lack of night flying experience, his failure to obtain a preflight weather briefing, low ceilings, and his failure to…NTSB IAD96LA097Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Ashton, MDthe pilot's inadequate fuel supply which resulted in a fuel exhaustion and a loss of engine power. A related factor was the pilot's inadequate fuel consumption calculations.NTSB FTW96LA257Accident · Minor injuriesLimited investigationFinal reportOwens/Smyth Sidewinder · Minden, LAThe pilot's improper fuel consumption calculations resulting in fuel exhaustion. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Hobart, OKthe pilot became lost/disoriented, and failed to properly use information that was provided by ATC, which resulted in fuel exhaustion and an encounter with soft terrain during an emergency landing. A factor relating to the accident was: the lack of suitable…NTSB ATL96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lake Placid, FLmaintenance personnel's failure to properly torque the cylinder installation bolts.NTSB LAX96LA233Accident · 1 fatalLimited investigationFinal reportVan Horn Velocity · Goodyear, AZan engine compartment fire, which originated in flight from loose fuel and/or oil lines near the engine's firewall.NTSB CHI96LA205Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Lambertville, MIa total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight, and the pilot's misjudged distance/altitude during the subsequent autorotation. A factor was inadequate maintenance and inspection.NTSB ATL96LA092Accident · No injuriesLimited investigationFinal reportCessna 411 · Rome, GAthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power in both engines, due to an inadequate supply of fuel.NTSB ANC96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKA loss of engine power due to low fuel pressure from the engine driven fuel pump and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96IA200Incident · No injuriesIncident investigationFinal reportBoeing 727-30C · Chicago, ILlow pressure in the fuel lines caused when the crossfeed valve was closed and the boost pumps to the effected fuel tank were turned off, a fuel pressure surge (spike) accompanied by a rapid drop in high pressure pump output and burner line pressures, when…NTSB CHI96LA198Accident · No injuriesLimited investigationFinal reportPiper J-3 · Princeton, MNLoss of engine power for an undetermined reason.NTSB FTW96IA248Incident · No injuriesIncident investigationFinal reportFairchild SA227-DC · Enid, OKfailure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.NTSB CHI96LA218Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waterville, KSthe pilot's inadequate preflight procedure. Factors were fuel exhaustion, a leak in the fuel filtering system, and high vegetation.NTSB NYC96FA123Accident · 2 fatalField investigationFinal reportBeech E90 · Woolwich, MEfailure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…NTSB IAD96LA094Accident · No injuriesLimited investigationFinal reportRotorway Exec 152 · Gretna, VAfailure of the bearing assembly shaft insert inside the main rotor shaft. Related factors are the jammed rotorcraft flight control which restricted the pilot's ability to control the helicopter and resulted in a hard touchdown.NTSB MIA96LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, FLthe pilot's inaccurate fuel consumption calculations which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB CHI96LA195Accident · No injuriesLimited investigationFinal reportCessna 150M · Red Wing, MNthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply. A factor relating to the accident was: soft terrain in the emergency landing area.NTSB FTW96IA240Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COphysical impairment of the captain due to a probable cardiac event.NTSB IAD96LA092Accident · No injuriesLimited investigationFinal reportBeech V35B · Westminster, MDThe fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.NTSB SEA96LA113Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Aberdeen, IDpilot's improper planning/decision, and subsequent incapacitation, which resulted in a loss of aircraft control and collision with the terrain. Factors relating to the accident were: pilot fatigued from a long-distance drive with minimal rest, physical…NTSB CHI96IA191Incident · No injuriesIncident investigationFinal reportBeech 1900 · Lansing, MIthe short in the windshield anti-ice low power braided copper lead wire caused a fire that had resulted from the manufacturer's inadequate design.NTSB ATL96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Lawrenceville, GAThe pilot's inadequate fuel consumption calculations that resulted in fuel exhaustion. A factor was the pilot's failure to follow the emergency procedure for a forced landing, in that the flaps were not extended.NTSB IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.NTSB FTW96IA235Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Childress, TXThe aircraft's encounter with unforcasted and unreported severe turbulence.NTSB LAX96LA215Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Sonora, CAfailure of the number 1 connecting rod due to oil starvation caused by inadequate bearing crush.NTSB CHI96FA184Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · Aitkin, MNthe pilot's continued flight into known adverse weather conditions and the pilot exceeding the design stress limits of the airplane. Factors contributing to this accident were: the thunderstorms, hail, and wind gusts, and the airplane's over maximum gross…NTSB NYC96LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Williamstown, NJinadequate maintenance, which resulted in a failure of the magneto housing hold-down flange, a disconnect of the magneto from the engine, and loss of engine power. The obstruction (fence post) in the emergency landing area was a related factor.NTSB SEA96LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Arock, ORthe pilot's failure to see and avoid the transmission wire. A factor was the low altitude flight.NTSB IAD96LA087Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · New Market, VAa loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.NTSB CHI96FA179Accident · 1 fatalField investigationFinal reportDotson Seabird · Geneseo, ILa loos of power due to a blocked fuel line and the pilot's failure to maintain airspeed.NTSB SEA96IA104Incident · No injuriesIncident investigationFinal reportDornier 328 · Billings, MTpaint overspray on the elevator trim actuator push rods, which damaged the actuator quad rings during normal operation and allowed water to enter the actuators; and the resultant freezing of the actuators. Factors relating to the incident included the…NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…NTSB NYC96IA116Incident · No injuriesIncident investigationFinal reportBoeing 767-31AER · Boston, MANumerous electrical anomalies as a result of a loose main battery shunt connection and undetermined electrical system causes.NTSB SEA96LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12 · Walla Walla, WAthe pilot's inadequate preflight/planning, and his failure to refuel the helicopter with sufficient fuel before flight, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: an inaccurate fuel quantity…NTSB CHI96IA173Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146 · Des Moines, IAfailure of the flight crew to follow proper procedures, which resulted in an accumulation of ice and subsequent loss of engine power. Factors relating to the incident were: thunderstorms, turbulence, icing conditions, and the inaccurate method that was…NTSB CHI96LA187Accident · No injuriesLimited investigationFinal reportCessna P206 · Goshen, INthe parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.