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 MIA08CA154Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mc Kinnon, TNThe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.NTSB CHI08LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Tomahawk, WIA total loss of engine power due to a loss of all of the engine's oil as a result of the safety wire on the governor idler gear shaft's oil plug breaking, leading to the oil plug coming unscrewed. Contributing to the accident was the lack of a suitable area…NTSB MIA08LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB LAX08LA253Accident · 2 fatalLimited investigationFinal reportLong Lancair ES · Cliffdell, WAThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident was turbulence and clouds.NTSB LAX08LA251Accident · No injuriesLimited investigationFinal reportCessna TU206E · Murrieta, CAA malfunction of the flight control system and loss of engine power for undetermined reasons.NTSB LAX08CA249Accident · No injuriesData collectionFinal reportFowler SX300 · Cheyenne, WYLoss of engine power due to fuel starvation.NTSB LAX08CA248Accident · No injuriesData collectionFinal reportBristol Titan Tornado II · Green River, UTThe encounter with rough terrain during an off-field precautionary landing.NTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB CHI08CA203Accident · No injuriesData collectionFinal reportEnstrom F28F · Amberg, WIThe unsuitable terrain encountered by the pilot during a forced landing following a loss of engine power due to a cylinder head separation. Contributing to the accident was the tree.NTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…NTSB ANC08LA089Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3 · Iliamna, AKA total loss of engine power due to the separation of the number 8 cylinder from the engine, which separated an oil line, resulting in a loss of oil and oil pressure. Contributing to the accident was the float-equipped airplane's forced landing on a road.NTSB CHI08CA199Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Bryan, OHThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations. A contributing factor was the inaccurate fuel gauge.NTSB NYC08LA251Accident · No injuriesLimited investigationFinal reportHolmes Arthur Orman Kitfox IV · Burkesville, KYThe total loss of engine power due to the installation of an engine oil filter that did not meet the engine manufacture's specifications.NTSB CHI08IA200Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Rockford, ILThe improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…NTSB MIA08CA140Accident · Minor injuriesData collectionFinal reportQuad City Ultralight Challenger II · Windslow Twp, NJThe pilot's inaccurate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.NTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.NTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.NTSB LAX08LA213Accident · 2 fatalLimited investigationFinal reportSchweizer 269 C-1 · Sunol, CAThe pilots' failure to maintain adequate clearance from transmission wires during cruise flight. Contributing to the accident were the dark night and low fog.NTSB LAX08CA215Accident · Minor injuriesData collectionFinal reportCessna 150J · Seal Beach, CAFuel starvation due to the pilot's improper fuel management procedures and failure to select a tank containing fuel. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI08CA177Accident · No injuriesData collectionFinal reportRobinson R44 II · Ottawa, ILThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the unmarked power transmission lines.NTSB ANC08LA085Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe pilot's improper fuel management which resulted in fuel starvation and a loss of engine power during cruise flight. Contributing to the accident was an aerodynamic stall during the emergency landing, the pilot's fatigue, and his unfamiliarity with the…NTSB DFW08LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Stotesbury, MOFracture of the engine's number eight cylinder barrel resulting in a loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN08LA120Accident · Serious injuriesLimited investigationFinal reportChomo EAA Biplane B1 · Schuyler, NEThe pilot's failure to maintain clearance from the wire due to his diverted attention resulting in in-flight collision with the wire. Contributing to the accident was the pilot's failure to locate an emergency landing site.NTSB CHI08CA188Accident · No injuriesData collectionFinal reportCessna 177A · Rhinelander, WIThe loss of engine power for an undetermined reason. A factor was the berm encountered during the forced landing.NTSB SEA08LA156Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Bend, ORThe failure of the crankshaft during cruise flight due to fatigue.NTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.NTSB NYC08CA236Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Front Royal, VAAircraft control was not maintained during cruise flight. Contributing to the accident was turbulence and inadvertent flight into adverse weather.NTSB LAX08FA203Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Mount Charleston, NVThe pilot's failure to maintain clearance from mountainous terrain and his selection of a cruise altitude that provided inadequate terrain clearance. Contributing to the accident were the high density altitude and the rapidly rising terrain.NTSB CHI08CA194Accident · Minor injuriesData collectionFinal reportCessna 150F · Johannesburg, MIThe pilot's failure to recognize the onset of carburetor icing resulting in a loss of engine power and the unsuitable terrain encountered during the forced landing. Contributing to the accident were the carburetor icing conditions, and the rough terrain.NTSB MIA08LA128Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Goodland, FLThe pilot’s inaccurate fuel consumption calculations, which resulted in a total loss of engine power to both engines due to fuel exhaustion.NTSB NYC08CA288Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Carrollton, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and subsequent loss of engine power.NTSB DFW08CA168Accident · Minor injuriesData collectionFinal reportGrumman G-164 · Tallulah, LAThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's failure to maintain adequate airspeed.NTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.NTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.NTSB DFW08LA166Accident · 1 fatalLimited investigationFinal reportBeech 99 · Bowling Green, MOThe parachutist's failure to follow procedures/directives by not waiting to jump until the green jump light was illuminated, resulting in his collision with the airplane's tail. Contributing to the accident was the parachutist's impairment by the use of…NTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.NTSB SEA08CA152Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Vernal, UTThe pilot's failure to verify the airplane's fuel quantity during his preflight, resulting in fuel exhaustion. Contributing to the accident was the presence of a vehicle on the road where the pilot executed his forced landing.NTSB MIA08FA122Accident · 1 fatalField investigationFinal reportYates Lancair IV-P · Springfield, KYA total loss of engine power due to a loss of engine oil as a result of the installation of the wrong oil adapter O-ring seal.NTSB LAX08FA190Accident · 3 fatalField investigationFinal reportCessna 172M · Pahala, HIThe pilot's continued visual flight into instrument meteorological conditions and his failure to remain clear of rising terrain while deviating from his planned route of flight. Contributing to the accident were clouds and mountainous terrain.NTSB NYC08FA215Accident · 2 fatalField investigationFinal reportCessna P337H · Cape Elizabeth, METhe pilot's improper decision to continue the flight in instrument meteorological conditions after experiencing an attitude indicator malfunction.NTSB MIA08CA120Accident · Minor injuriesData collectionFinal reportBeech S35 · Creola, ALThe pilot's inadequate fuel calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX08LA183Accident · Minor injuriesLimited investigationFinal reportRobinson R44 II · Topanga, CAThe in-flight separation of the tail rotor gear box for an undetermined reason. Contributing to the accident was the hilly terrain, which was unsuitable for a forced landing.NTSB CHI08CA164Accident · Minor injuriesData collectionFinal reportHughes 269B · Cook, MNThe pilot not maintaining tail rotor effectiveness while turning in cruise.NTSB DCA08FA075Accident · No injuriesField investigationFinal reportDouglas MD-10 · Raymond, PAThe flight crew's failure to adequately monitor the airplane's airspeed during the holding pattern, leading to the onset of an aerodynamic stall and subsequent structural damage to the tail from buffet.NTSB DFW08CA163Accident · No injuriesData collectionFinal reportCessna CE-152 · Foss, OKA total loss of engine power for undetermined reasons.NTSB DCA08WA073Accident · 4 fatalForeign investigationCessna 210 · Nairegi Enkera, KenyaOn June 10, 2008, about 1200 UTC, a Cessna 210, registration 5Y-BE, a chartered flight, was en route when it collided with high terrain near Nairegi Enkera, Kenya. The airplane was on a visual flight; instrument meteorological conditions prevailed due to low…NTSB LAX08LA168Accident · No injuriesLimited investigationFinal reportMkii Lancair Legacy 2000 · Bend, ORA total loss of engine power due to the fatigue failure of the Number 3 cylinder connecting rod.NTSB CHI08LA154Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MNA loss of engine thrust due to the propeller separating from the aircraft as a result of fatigue failure of the propeller attachment bolts caused by the insufficient torque of the bolts during installation.NTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.NTSB CHI08LA160Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Battle Creek, MIThe in-flight separation of the tip of a propeller blade due to metal fatigue that resulted from an inadequate inspection and repair.