NTSB investigations, ID
453 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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
AND 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 WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB WPR10LA331Accident · No injuriesLimited investigationFinal reportCessna 210 · Coeur d'Alene, IDThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.NTSB WPR09CA415Accident · No injuriesData collectionFinal reportPaul B. Johnson Avid Mark IV · Nampa, IDThe airplane's encounter with tall vegetation that ensnared the landing gear during an off-field precautionary landing.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09LA314Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Lewiston, IDA loss of engine power while in cruise flight for undetermined reasons.NTSB WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.NTSB WPR09FA282Accident · 1 fatalField investigationFinal reportCessna 182M · Atlanta, IDThe pilot's failure to maintain terrain clearance during cruise flight.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.NTSB WPR09FA116Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Hagerman, IDThe student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…NTSB SEA08LA114Accident · No injuriesLimited investigationFinal reportCanup Titan Tornado S · Council, IDThe failure of the tip of the wood propeller due to damage caused by a foreign object.NTSB SEA07LA255Accident · No injuriesLimited investigationFinal reportCessna 182G · Fairfield, IDThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight inspection. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA07TA203Accident · No injuriesFinal reportCessna TU206G · New Meadows, IDThe loss of engine power due to the loss of engine oil pressure following the oil pump's drive shaft failure for an undetermined reason. Contributing factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain.NTSB SEA07LA173Accident · Minor injuriesLimited investigationFinal reportHalsted Flightstar Pioneer · Nampa, IDThe failure (fracture) of the crankshaft of the non-certificated two-cycle engine during cruise flight. Factors include a ditch running through the field in which the pilot executed his engine-out forced landing.NTSB SEA07CA164Accident · Minor injuriesData collectionFinal reportCessna 180H · Nampa, IDThe pilot's failure to stop for additional fuel, which resulted in a loss of engine power due to fuel exhaustion.NTSB LAX07LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Paris, IDa loss of power in the right engine for undetermined reasons.NTSB SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.NTSB SEA06CA111Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · American Falls, IDThe pilot's performance of low altitude flight and his failure to maintain clearance with a power line, which resulted in an in-flight collision with the power line.NTSB SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.NTSB SEA05LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Challis, IDThe installation of an improper oil gasket by maintenance personnel, which resulted in a loss of engine oil and subsequent loss of engine power during the emergency descent.NTSB SEA05LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Star, IDA loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.NTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.NTSB SEA05LA103Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Emmett, IDThe partial loss of engine power during cruise flight as a result of air being sucked into the fuel system due to a worn fuel selector valve stem and a hardened and brittle fuel selector valve O-ring. Factors include no suitable landing area within the…NTSB SEA05FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Lowell, IDThe number four exhaust valve sticking in the open position during cruise flight. Factors include the pilot's failure to have an Airframe and Powerplant mechanic look at the engine after it had run rough immediately after start-up prior to this and a number…NTSB SEA05CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McCammon, IDA loss of engine power due to the pilot's inadequate in-flight decision/planning by failing to refuel while en route, resulting in fuel exhaustion. Factors contributing to the accident included the trees and fence.NTSB SEA05LA008Accident · No injuriesLimited investigationFinal reportHiggins Acro-Sport II · Coeur d'Alene, IDThe airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.NTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB SEA04LA095Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL M-18B · Borah Peak, IDThe pilot's inadequate planning/decision, VFR into IMC, and his failure to maintain terrain clearance. Factors include mountainous terrain and instrument meteorological condition.NTSB SEA04LA071Accident · Serious injuriesLimited investigationFinal reportKeller Prospector FK1 · Gibbonsville, IDThe pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing , trees and mountainous terrain.NTSB SEA03LA187Accident · No injuriesLimited investigationFinal reportCessna 172RG · Blanchard, IDThe loss of engine oil as a result of the inadequate installation of the idler gear shaft set screw and the lack of a safety wire on the hex head (oil) plug. A contributing factor was the rough and uneven terrain.NTSB SEA03LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Homedale, IDLoss of engine power during descent due to a failed cylinder head.NTSB SEA03FA179Accident · No injuriesField investigationFinal reportAero Commander Callair A-9B · Driggs, IDA loss of engine power due to the improper installation of a counterweight roller pin retaining washer circlip, leading to the circlip coming out of its groove and the counterweight roller pin coming in contact with two of the engines connecting rods.…NTSB SEA03LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Nampa, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. A factor was the unsuitable terrain for the forced landing.NTSB SEA03LA146Accident · No injuriesLimited investigationFinal reportCessna 182S · Henry's Lake, IDA set of inadequately torqued vacuum pump retaining nuts, leading to the failure of the vacuum pump gasket, resulting in oil exhaustion, which resulted in a loss of engine power during cruise. A ditch and rough uneven terrain were factors.NTSB SEA03LA129Accident · No injuriesLimited investigationFinal reportCessna 182J · Athol, IDThe failure of one of the number five connecting rod cap bolts during cruise flight due to the associated number five rod cap bolt nut being insufficiently torqued at the last major overhaul. Factors include a culvert alongside the road where the pilot found…NTSB SEA03LA202Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Jerome, IDThe malfunction of the cooling system pressure relief valve and the pilot's failure to follow procedures. An engine over temperature, a coolant leak as a result of a relief valve failure, an obstructed windshield which was covered with coolant fluid, and an…NTSB SEA03LA117Accident · No injuriesLimited investigationFinal reportCessna T337D · Driggs, IDThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor contributing to the accident was the unsuitable terrain for the forced landing.NTSB SEA03LA093Accident · No injuriesLimited investigationFinal reportCessna 175 · Middleton, IDThe pilot's failure to follow the checklist which led to fuel starvation and subsequent loss of engine power. A contributing factor was the uneven terrain at the landing site.NTSB SEA03LA070Accident · No injuriesLimited investigationFinal reportCessna 182C · Stanley, IDThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power during descent. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.NTSB SEA03LA023Accident · No injuriesLimited investigationFinal reportBell 47G · Idaho Falls, IDIn-flight loss of engine power for undetermined reasons.NTSB SEA03LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Boise, IDThe failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the…NTSB SEA02LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Oakley, IDFailure (fracture) of the two number four piston compression rings, leading to the erosion of a section of the piston sidewall, resulting in the exhaustion of the engine's oil supply during cruise flight, followed by a forced landing on a country road.…NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB SEA02FA108Accident · 1 fatalField investigationFinal reportGarlick UH-1H · Clark Fork, IDA failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.NTSB SEA02IA096Incident · No injuriesIncident investigationFinal reportKaman K-600 (HH-43B) · Cocolalla, IDThe reverse installation of the RPM compensator assembly control box bolts resulting in the threaded end of the bolt impinging on a clevis and jamming the collective during climb. A contributing factor was the lack of adequate documentation provided by the…NTSB SEA02IA044Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-401 · Boise, IDThe partial failure of one of the number two hydraulic system elevator hydraulic lines, leading to the loss of fluid and pressure in that system during cruise flight. This loss resulted in reliance upon the sole remaining activation system (number one…NTSB SEA02LA014Accident · Serious injuriesLimited investigationFinal reportBölkow BO 105 LS · Mud Lake, IDPilot's failure to maintain adequate separation from terrain during the initial climb. Factors include spatial disorientation and a dark moonless night.NTSB SEA02FA007Accident · 2 fatalField investigationFinal reportCessna TR182 · Dixie, IDThe pilot's failure to refuel en route resulting in fuel exhaustion, and his inadvertent entry into a stall condition during the emergency descent. Contributing factors were dark night conditions and mountainous/hilly terrain.