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 FTW95FA177Accident · 1 fatalField investigationFinal reportBeech 60 · Cheyenne, WYThe pilot's failure to maintain aircraft control. Factors were the instrument weather conditons and the excessive workload imposed on the solo pilot attempting to deal with an emergency situation while flying in instrument meteorological conditions.NTSB FTW95LA176Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · Utopia, TXClear air turbulence encountered.NTSB FTW95LA175Accident · No injuriesLimited investigationFinal reportBriggs Glasair III · Crescent, OKTotal non-mechanical power loss due to a fuel system vapor lock. A factor was the uneven terrain on which the forced landing was made.NTSB FTW95LA174Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Estancia, NMThe loss of engine power due to exhaust valve separation resulting from inadequate maintenance. A factor was the dark night and the lack of suitable terrain for the forced landing.NTSB CHI95LA130Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winfield, KSThe total failure of the rotor drive system clutch assembly due to excessive wear of the clutch assembly. A factor in this accident was the soft ground in the emergency landing area.NTSB LAX95FA173Accident · 4 fatalField investigationFinal reportCessna 182P · Jerome, AZthe pilot's improper in-flight decision to continue the daytime flight into known adverse weather conditions at an inadequate altitude to clear mountainous terrain.NTSB SEA95LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wheatland, WYThe pilot's continued flight into known adverse weather conditions. A factor in the accident was the airframe icing encountered during the flight.NTSB LAX95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yolo, CAthe pilot's improper preflight preparation which led to fuel exhaustion.NTSB SEA95IA082Incident · No injuriesIncident investigationFinal reportFairchild SA-227 · Pasco, WAImproper installation of the rudder trim actuator rod by company maintenance personnel which resulted in binding and fracture of the rod.NTSB MIA95LA109Accident · No injuriesLimited investigationFinal reportCessna 172H · Hattiesburg, MSThe pilot-in-command's improper use of carburetor heat during descent, resulting in a total loss of engine power due to carburetor icing, and subsequent forced landing to unsuitable terrain.NTSB ATL95LA085Accident · No injuriesLimited investigationFinal reportCessna 150H · Bath, NCA bird, which collided with and fractured the aircraft windshield, resulting in an emergency landing. A factor was the soft terrain at the emergency landing site.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB MIA95LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Panacea, FLThe pilot's failure to attain the proper touchdown point during a forced landing to a runway. This resulted in the airplane rolling off the departure end of the runway, and subsequent on ground collision with a fence and a telephone booth. Contributing to the…NTSB MIA95FA107Accident · 2 fatalField investigationFinal reportBeech 55-E55 · Daytona Beach, FLThe failure of the pilot-in-command to manage the fuel available in flight by improperly selecting the fuel selectors to fuel available in other tanks, resulting in both engines losing power. Contributing to the accident was the lack of suitable terrain for…NTSB ANC95FA044Accident · 2 fatalField investigationFinal reportCessna 180B · Cantwell, AKThe pilot's continued VFR flight into IMC conditions. Weather conditions consisting of low ceilings and turbulence were factors in the accident.NTSB SEA95FA079Accident · 1 fatalField investigationFinal reportCessna 182P · Index, WAthe pilot's continued flight into known adverse weather, and his improper use of carburetor heat. Factors include: weather conditions conducive to carburetor icing and airframe icing, airframe ice, and mountainous/hilly terrain in the area of the forced…NTSB MIA95LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLThe inadequate preflight planning by the pilot-in-command to assure that adequate fuel was on-board the airplane to complete the flight, which resulted in a loss of engine power, forced landing and the collision with a tree on touchdown.NTSB MIA95FA105Accident · 1 fatalField investigationFinal reportPackard/Squire RV-4 · Davie, FLEngine fuel starvation due to the pilot's fuel mismanagement. A loss of control followed as the pilot inadvertently stalled the airplane while maneuvering for the forced landing.NTSB CHI95FA124Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Great Bend, NDthe pilot/mechanic's inadequate maintenance (inspection) of aircraft and the pilot's failure to maintain airspeed (VMC). Factors were icing conditions, deteriorated induction air ducting, and failure of a piston assembly.NTSB CHI95FA121Accident · 3 fatalField investigationFinal reportCessna P-210N · Belle Plaine, MNthe failure to replace the deteriorated deicing boots, and the failure of the boots to operate when the airplane encountered icing condition. An additional causes were the pilot's failure to maintain adequate airspeed and the excessive pullup performed by the…NTSB ANC95GA048Accident · 1 fatalFinal reportCessna 182Q · Bumping Lake, WAA loss of engine power for an undetermined reason. Factors relating to the accident were: lack of suitable terrain for a forced landing in mountains, low ambient temperatures that contributed to hypothermia, the lack of survival equipment, an erratic ELT…NTSB FTW95LA164Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlin, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. Factors were the lack of suitable terrain available for the forced landing and the dark night condition.NTSB LAX95FA157Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Pollack Pines, CAThe pilot's disregard of a hazardous weather advisory; his decision to fly into known adverse weather conditions; his failure to maintain control of the airplane with an accumulation of airframe ice; and his improper use of the flight controls during recovery…NTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.NTSB BFO95LA044Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Finksburg, MDloss of engine power for undetermined reasons. A related factor was the lack of suitable terrain.NTSB FTW95LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Tijeras, NMFuel starvation due to foreign material partially blocking the fuel screen, and the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95IA156Incident · Minor injuriesIncident investigationFinal reportBoeing 727-276 · Dfw Airport, TXThe improper use of the evacuation slide by the flight attendant. A factor was the short in the number 1 engine fire warning system, which motivated the captain to order an evacuation.NTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.NTSB LAX95LA150Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · El Cajon, CAa loss of engine power due to an in-flight separation of the fuel system gascolator glass bowl resulting in a premature fuel exhaustion. The rough/uneven terrain is a factor in this accident.NTSB LAX95LA149Accident · No injuriesLimited investigationFinal reportBulsky Skybolt · Goodyear, AZfuel starvation due to the partial failure of the fuel pump caused by the broken crankshaft idler gear attachment screw lockplate. The unsuitable terrain and trees were factors in this accident.NTSB NYC95FA080Accident · 1 fatalField investigationFinal reportCessna 172P · Naples, NYThe pilot's continued VFR flight into instrument meteorological conditions. Factors contributing to the accident were: the night conditions, fog, low ceiling, and hilly terrain.NTSB FTW95FA150Accident · 1 fatalField investigationFinal reportCessna 177RG · Dalhart, TXThe pilot's VFR flight into IMC conditions and the ensuing spatial disorientation. Factors were the pilot's self-induced pressure to reach his destination, his failure to obtain a weather briefing for the flight, and the weather conditions.NTSB FTW95IA148Incident · 1 fatalIncident investigationFinal reportDouglas DC-9-32 · Abilene, TXIncapacitation of the first officer due to a heart attack.NTSB CHI95LA111Accident · Minor injuriesLimited investigationFinal reportBaker Long EZE · Salina, KSfailure of the engine driven fuel pump. Factors associated with the accident were fuel starvation, insufficient altitude and soft terrain.NTSB LAX95FA144Accident · 1 fatalField investigationFinal reportCessna 310Q · Kahului, Maui, HIthe pilot's failure to maintain an adequate terrain clearance altitude while flying in a mountainous area at night.NTSB FTW95LA146Accident · No injuriesLimited investigationFinal reportHughes 369HS · Burnet, TXFailure by the pilot-in-command to maintain rotor RPM during the autorotation and his delayed flare. A factor was: the pilot's failure to use the fuel boost pump while using aviation gasoline vice jet fuel.NTSB LAX95FA148Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Toms Place, CAthe pilot's decisions to initially attempt and then continue flight into known forecast and observed adverse weather. Factors in the accident were: the pilot's inadequate preflight planning and his use of a drug.NTSB FTW95LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Devine, TXA power loss due to the inadvertent opening of an unapproved quick oil drain installed by maintenance personnel. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95FA087Accident · 2 fatalField investigationFinal reportCessna 337F · Vero Beach, FLThe pilot's failure to avoid a thunderstorm. The thunderstorm was a factor.NTSB NYC95LA075Accident · No injuriesLimited investigationFinal reportCumberland-Pitts Special S1C · New Windsor, MDthe failure of the fuel pump diagram which resulted in fuel starvation and a subsequent forced landing.NTSB ATL95LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Alma, GAThe aircraft's encounter with unforecast clear air turbulence.NTSB ATL95LA061Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Collegedale, TNThe mechanic's failure to follow approved engine overhaul procedures which resulted in the separation of the oil return line, and the complete loss of engine power.NTSB SEA95LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Boise, IDFuel exhaustion due to the pilot's failure to refuel.NTSB CHI95LA112Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Norton, KSthe reason for the loss of engine power was undetermined. The rough, uneven terrain encountered during the forced landing was a factor.NTSB FTW95LA141Accident · No injuriesLimited investigationFinal reportBurken Ultimate · New Braunfels, TXThe loss of engine power due to fuel starvation due to a fuel leak resulting from a loose fuel line fitting. A factor was the lack of suitable terrain for the forced landing.NTSB ANC95LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Skwentna, AKA frozen engine breather tube which resulted in a loss of oil and engine power.NTSB CHI95LA096Accident · No injuriesLimited investigationFinal reportCessna T210N · Rockford, ILA disconnect of the alternator belt, and failure of the pilot to attain a down and locked condition of the gear with the emergency extension system.NTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.NTSB LAX95LA127Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Gaviota, CAinadequate maintenance and service of the aircraft's carburetor heat system, and the pilot's intentional flight into adverse weather conditions. The lack of a suitable area for the emergency landing was a factor.NTSB LAX95IA128Incident · No injuriesIncident investigationFinal reportATR 42 · Las Vegas, NVan unexpected lateral control movement associated with in-flight turbulence.