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 MIA90LA058Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · San Juan, PRInadvertent flight of the airplane into an area of turbulence associated with a developing rain storm.NTSB NYC90LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Brogue, PAOff airport landing due to an engine power loss due to failure of the no. 2 crankshaft bearing.NTSB NYC90LA052Accident · Serious injuriesLimited investigationFinal reportCessna C150 · E. Prospect, PAPilot's improper execution of emergency procedures after the engine failed. The pilot lost control of the airplane while maneuver the airplane back to the airstrip during the forced landing. The pilot stalled the airplane at too low an altitude to recover.NTSB ATL90MA051Accident · 2 fatalMajor investigationFinal reportLearjet 23 · Ansonia, OHThe flight crew became incapacitated for undetermined reasons and lost control of the airplane.NTSB DEN90FA043Accident · 1 fatalField investigationFinal reportCessna 208A · Leadville, CODiversion of the pilot's attention, resulting in an in flight collision with terrain during normal cruise flight.NTSB MKC90FA044Accident · Serious injuriesField investigationFinal reportCessna P210N · Newton, KSLoss of engine power for an undetermined reason. Darkness and the resultant delay in flaring to land were related factors.NTSB LAX90LA271Accident · 1 fatalLimited investigationFinal reportCessna R172K · Lone Pine, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors to the accident were the adverse weather conditions, mountainous terrain, and the likely effect of hypoxia on the pilot.NTSB FTW90LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Liberty, TXLoss of engine power due to failure of the tappet faces. A factor in the accident was the unsuitable terrain in which the forced landing was made.NTSB MKC90LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · York, MNPowerplant failure due to undetermined causes.NTSB MIA90LA052Accident · No injuriesLimited investigationFinal reportCessna 210M · Ocala, FLSeparation of the throttle plate, due to improper securing of the attach screws during an overhaul.NTSB FTW90FA051Accident · 1 fatalField investigationFinal reportBell UH-1B · San Diego, TXThe pilot intentionally flew into instrument meteorological conditions during night VFR flight, and the helicopter subsequently collided with terrain.NTSB NYC90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Messena, NYThe airplane striking a light pole during an off airport landing on a road, due to a double power loss for unknown reasons. Factors related to the accident were: the pilots unfamiliarity with the airplane.NTSB ATL90LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lithia Springs, GAImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB MIA90LA051Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Jacksonville, FLFailure of the owner/operator to obtain proper maintenance and inspection of the aircraft. Factors related to the accident were: operation of the aircraft by the pilot without a current annual inspection (known deficiency), an oil leak in the left engine…NTSB ATL90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Talladega, ALThe pilot's improper inflight decision to attempt to continue VFR flight IMC conditions with no instrument rating, clearance or experience.NTSB ATL90LA048Accident · No injuriesLimited investigationFinal reportCessna 172B · Killen, ALInadequate pre-flight planning by the pilot in command which resulted in fuel exhaustion during cruise flight.NTSB MIA90LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Astatula, FLLoss of engine power for an undetermined reason during a simulated forced landing.NTSB MIA90IA047Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Madison, FLThe failure of company service personnel to properly service the airplane forward lavatory.NTSB FTW90LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hammond, LAPilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…NTSB NYC90LA045Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Slippery Rock, PALoss of airspeed and an inadvertent stall by the pilot during an attempted return to the airport, following a power loss due to carburetor ice.NTSB BFO90FA017Accident · Serious injuriesField investigationFinal reportDouglas DC-10 · Baltimore, MDInjuries associated with the evacuation of the aircraft.NTSB LAX90FA061Accident · Minor injuriesField investigationFinal reportBoeing 737-204 · Tucson, AZFailure of the operator's maintenance personnel to detect an electrical wire which had chafed against a hydraulic line and which eventually arced causing a leak in the hydraulic line and subsequent fire and hydraulic system failure. In addition, previous wear…NTSB MIA90FA046Accident · 1 fatalField investigationFinal reportCessna 172N · Meridian, MSIn flight loss of control by the pilot while flying in instrument meteorological conditions. Contributing factor(s) was: the pilot's apprehension toward instrument flying and the adverse weather conditions that existed at the time.NTSB DEN90LA037Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Tularosa, NMThe pilot's VFR flight into instrument meteorological conditions (IMC), and his failure to see and avoid the road sign during the precautionary landing. The adverse weather was a realted factor.NTSB ATL90LA047Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Winston Salem, NCA blocked fuel vent line, which prevented normal fuel flow to the engine and subsequent loss of power.NTSB CHI90FA055Accident · 3 fatalField investigationFinal reportBeech A24R · Merrill, WIFlight into known adverse weather by the pilot, and structural/wing ice. Factors related to the accident were: the icing conditions and trees in the area of the accident.NTSB MIA90LA042Accident · 1 fatalLimited investigationFinal reportBoeing 727-225B · Miami, FLFatal injury to a stowaway due to asphyxia and hypothermia.NTSB LAX90LA057Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Gorman, CAThe malfunctioning propeller governor, and the pilot's misjudgement of altitude and distance of the approach path during an emergency landing. Factors contributing to the accident were: the power lines across the approach path to the runway and the…NTSB CHI90LA054Accident · No injuriesLimited investigationFinal reportBeech V35B · North Canton, OHContinued flight by the pilot into known adverse weather conditions, and his delay in diverting to an alternate airport, which resulted in accumulation of airframe icing. Factors related to the accident were: the adverse weather and runway/terrain conditions.NTSB NYC90FA041Accident · 3 fatalField investigationFinal reportCessna 172N · Washington Twp, NJThe failure of the pilot to properly pre-flight plan and execute the VFR flight. Factor's related to the accident were: the pilot's inexperience; no visual cues (lights) due to dark night conditions; the pilot's disregard of the weather briefing.NTSB CHI90LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · New Phila, OHThe pilot's failure to drain all of the trapped water from the fuel system prior to flight. Factors related to the accident were: the unfavorable wind condition and trees in the emergency landing area.NTSB MIA90LA040Accident · No injuriesLimited investigationFinal reportMooney M20 · Fort Lauderdale, FLPartial loss of engine power for an unknown reason.NTSB SEA90FA027Accident · 2 fatalField investigationFinal reportCessna 172N · Nordland, WAUndetermined.NTSB NYC90FA040Accident · 1 fatalField investigationFinal reportPiper PA-60-602P · Frenchtown, NJThe inadequate maintenance and inspection of the turbocharger tailpipe exhaust stack on the right engine by the mechanic(s). The failure of the tailpipe permitted heat from the exhaust to weaken the main spar of the right wing resulting in a catastrophic…NTSB CHI90LA048Accident · No injuriesLimited investigationFinal reportCessna 310Q · Grand Rapids, MIThe undetermined engine compartment fire during the initial climbout. A factor was the failure of the pilot to shut off the fuel supply to the engine.NTSB LAX90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bumble Bee, AZThe failure of the student pilot to apply carburetor heat in a timely manner. Contributing to the accident were the carburetor icing conditions and the desert terrain.NTSB CHI90LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lacrosse, WIThe student pilot's improper pre-flight planning/preparation, which did not include a plan to refuel the aircraft as necessary. The student pilot's lack of total experience contributed to this accident, as did the cfi's inadequate supervision of the student.NTSB ATL90LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Nashville, NCA loss of engine power for undetermined reasons. A factor related to the accident was the ditch the airplane contacted.NTSB SEA90FA030Accident · 1 fatalField investigationFinal reportCrawford-Gordon Thorp T-18 · Austin, NVAn improper major alteration performed by the pilot. As a result of this modification, the propeller failed in flight.NTSB NYC90FA039Accident · 6 fatalField investigationFinal reportPiper PA-31-350 · Cairo Township, NYThe pilot's decision to fly into the known adverse weather and his failure to select an altitude that would provide terrain clearance. Factors were: the adverse weather and the pilot's disregard for the forecasted conditions.NTSB MIA90IA039Incident · No injuriesIncident investigationFinal reportBoeing 727 · Ormond Beach, FLFailure of the pilot in command in the Beech 300 to comply with an ATC clearance in a timely manner, while diverting his attention, and failure of the ATC controller to assure that IFR separation was maintained.NTSB ANC90FA020Accident · No injuriesField investigationFinal reportBoeing 747-400 · Anchorage, AKInadvertent encounter with volcanic ash cloud, which resulted in damage from foreign material (foreign object) and subsequent compressor stalling of all engines. A factor related to the accident was: the lack of available information about the ash cloud to…NTSB CHI90DEV01Accident · Minor injuriesFinal reportCessna 210D · Jerseyville, ILA total loss of engine power for an undetermined reason. A factor in the accident was the rough uneven terrain in the forced landing area.NTSB NYC90FA038Accident · No injuriesField investigationFinal reportBoeing 727-31 · Newark, NJThermal distress of the first stage turbine blades of the nuber one engine causing a degradation of material properties which resulted in blade fractures. The reason for the thermal distress was not determined.NTSB LAX90LA050Accident · No injuriesLimited investigationFinal reportHughes 369HS · Waimea, HIThe improper installation of the pc tube by company maintenance personnel, which resulted in fatigue failure of the tube due to induced bending stresses.NTSB SEA90FA028Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Rainier, WAContinued flight by the pilot into known adverse weather conditions, and his failure to maintain sufficient altitude/clearance from wooded mountainous terrain. Factors related to the accident were: darkness and the weather/terrain conditions.NTSB MIA90LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The engine seized from oil starvation (lack of oil or oil pressure), which resulted in the aircraft being ditched at sea.NTSB LAX90LA049Accident · No injuriesLimited investigationFinal reportCessna 150D · Inyokern, CAThe pilot's failure to use carburetor heat when climatic conditions were conducive to the formation of carburetor ice.NTSB ATL90LA037Accident · No injuriesLimited investigationFinal reportBeech A36 · Charlotte, NCThe failure of the airplane engine due to fuel exhaustion over terrain unsuitable for the forced landing.NTSB DEN90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDFailure of the CFI to utilize carburetor heat prior to the induction icing and power loss. Contributing to the accident was the cfi's continued VFR flight into known and forecast instrument meteorological conditions.