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.

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…Aug 31, 2010 · N67264 · Substantial damageNTSB WPR10LA331Accident · No injuriesLimited investigationFinal reportCessna 210 · Coeur d'Alene, IDThe loss of engine power during cruise flight for undetermined reasons.Jul 5, 2010 · N8133G · Substantial damageNTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.Dec 24, 2009 · N1883V · Substantial damageNTSB 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.Aug 21, 2009 · N333PD · Substantial damageNTSB 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.Aug 13, 2009 · N99BE · Substantial damageNTSB WPR09LA314Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Lewiston, IDA loss of engine power while in cruise flight for undetermined reasons.Jun 26, 2009 · N836SH · Substantial damageNTSB 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.Jun 22, 2009 · N12463 · Substantial damageNTSB WPR09FA282Accident · 1 fatalField investigationFinal reportCessna 182M · Atlanta, IDThe pilot's failure to maintain terrain clearance during cruise flight.Jun 3, 2009 · N70946 · Substantial damageNTSB 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.Apr 6, 2009 · N610RJ · Substantial damageNTSB 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…Feb 16, 2009 · N8810P · DestroyedNTSB 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.Apr 26, 2008 · N706BC · Substantial damageNTSB 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.Sep 8, 2007 · N2420R · Substantial damageNTSB 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.Jul 14, 2007 · N9374Z · Substantial damageNTSB 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.Jun 19, 2007 · N8003U · Substantial damageNTSB 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.Jun 17, 2007 · N2467F · Substantial damageNTSB LAX07LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Paris, IDa loss of power in the right engine for undetermined reasons.Mar 15, 2007 · N7169Y · Substantial damageNTSB 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.Jan 30, 2007 · N4584L · Substantial damageNTSB 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.Jun 4, 2006 · N45CK · Substantial damageNTSB 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.Dec 25, 2005 · N5695V · DestroyedNTSB 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.Aug 13, 2005 · N6677P · Substantial damageNTSB 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.Jun 25, 2005 · N2153G · Substantial damageNTSB 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.Jun 24, 2005 · N4865X · Substantial damageNTSB 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…May 21, 2005 · N8874H · Substantial damageNTSB 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…May 9, 2005 · N8805W · DestroyedNTSB 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.Apr 15, 2005 · N8715E · Substantial damageNTSB 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.Oct 2, 2004 · N214JH · Substantial damageNTSB 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.Sep 13, 2004 · N4661F · Substantial damageNTSB 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.Jun 11, 2004 · N2579N · Substantial damageNTSB 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.May 22, 2004 · N117BS · DestroyedNTSB 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.Apr 17, 2004 · N5XK · Substantial damageNTSB 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.Sep 6, 2003 · N6368R · Substantial damageNTSB SEA03LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Homedale, IDLoss of engine power during descent due to a failed cylinder head.Sep 3, 2003 · N15367 · Substantial damageNTSB 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.…Aug 25, 2003 · N7924V · Substantial damageNTSB 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.Aug 23, 2003 · N33170 · Substantial damageNTSB 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.Jul 21, 2003 · N146NE · Substantial damageNTSB 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…Jul 5, 2003 · N3367F · Substantial damageNTSB 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…Jul 3, 2003 · N2869D · Substantial damageNTSB 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.Jun 22, 2003 · N86182 · Substantial damageNTSB 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.Jun 5, 2003 · N7238M · Substantial damageNTSB 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.Apr 27, 2003 · N8690T · Substantial damageNTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.Mar 15, 2003 · N70FJ · DestroyedNTSB SEA03LA023Accident · No injuriesLimited investigationFinal reportBell 47G · Idaho Falls, IDIn-flight loss of engine power for undetermined reasons.Jan 2, 2003 · N4759R · Substantial damageNTSB 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…Dec 24, 2002 · N8366F · Substantial damageNTSB 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.…Sep 30, 2002 · N4232H · Substantial damageNTSB 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.Jul 4, 2002 · N27069 · Substantial damageNTSB 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.Jun 21, 2002 · N114DR · Substantial damageNTSB 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…May 21, 2002 · N286M · No damageNTSB 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…Mar 2, 2002 · N410QX · No damageNTSB 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.Nov 14, 2001 · N93LF · DestroyedNTSB 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.Oct 17, 2001 · N756CE · Destroyed