NTSB investigations, OR

250 cases where the phase of flight was Takeoff.

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\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
  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 WPR12LA329Accident · No injuriesLimited investigationFinal reportInterplane Skyboy EX · Sandy, ORA partial loss of engine power during takeoff due to carburetor icing. Contributing to the accident was the lack of a carburetor heat system installed on the airplane.Jul 28, 2012 · N582YB · Substantial damageNTSB ENG12IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-10-30F · Portland, ORThe fracture of the fan mid shaft due to a stress corrosion cracking initiated by local regions of corrosion pitting, which resulted from oil migration within the shaft and its subsequent degradation.Feb 13, 2012 · N304FE · Minor damageNTSB WPR11FA333Accident · 2 fatalField investigationFinal reportDavidson Zenith Stol CH701 · Glendale, ORA total loss of engine power due to fuel starvation and the pilot’s subsequent failure to maintain airplane control during the forced landing. Contributing to the accident was the pilot’s failure to ensure that the fuel valves were in the correct position for…Jul 18, 2011 · N701RD · Substantial damageNTSB WPR11LA064Accident · 1 fatalLimited investigationFinal reportKennedy Lancair 320 · Hubbard, ORThe loss of control during takeoff for undetermined reasons. Contributing to the accident was the pilot's impairment from an over-the-counter sedating medication.Nov 29, 2010 · N42BK · Substantial damageNTSB WPR10CA436Accident · No injuriesData collectionFinal reportCessna TU206F · Seneca, ORThe pilot's failure to maintain directional control after takeoff, resulting in a collision with a tree.Aug 29, 2010 · N1406Q · Substantial damageNTSB WPR10LA353Accident · Serious injuriesLimited investigationFinal reportTopdog Ultralights TOP DOG 582 · Eagle Point, ORThe separation of the left wingtip.Jul 16, 2010 · N82047 · Substantial damageNTSB WPR10CA360Accident · No injuriesData collectionFinal reportMeyer MEYER-LEGACY · Burns, ORThe pilot's inadequate compensation for the wind conditions, resulting in a loss of lateral and directional control during takeoff.Jun 25, 2010 · N29MM · Substantial damageNTSB WPR10LA147Accident · No injuriesLimited investigationFinal reportBeech 58 · Portland, ORThe overstress failure of a nose landing gear mechanism bolt, which precluded the nose gear retract brace assembly from locking the nose gear in the extended position and allowed the nose landing gear to collapse. Contributing to the accident was the failure…Feb 9, 2010 · N3700N · Substantial damageNTSB WPR09LA446Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-1B · Creswell, ORA partial loss of engine power due to the malfunction of the engine's right magneto.Sep 12, 2009 · N9682L · Substantial damageNTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…Aug 23, 2009 · N6353Z · Substantial damageNTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.Jul 5, 2009 · N3198D · Substantial damageNTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.Sep 4, 2008 · N185ZZ · Substantial damageNTSB SEA07CA116Accident · No injuriesData collectionFinal reportCessna 172M · Astoria, ORThe student pilot's failure to adequately correct for changing wind conditions, leading to a loss of directional control during the takeoff ground roll. Factors include wet, soft terrain along the side of the runway.Apr 29, 2007 · N1911V · Substantial damageNTSB LAX07CA073Accident · No injuriesData collectionFinal reportRobinson R-22 Beta 2 · Salem, ORThe student pilot's improper remedial action when a dynamic rollover was encountered.Jan 21, 2007 · N924SH · Substantial damageNTSB SEA06CA176Accident · No injuriesData collectionFinal reportCessna 185 · Cove, ORThe pilot’s failure to maintain directional control during the takeoff roll. Factors include wet grass and trees.Jul 24, 2006 · N477G · Substantial damageNTSB SEA06FA142Accident · 1 fatalField investigationFinal reportHawker Siddeley MK-58A Hunter · Hillsboro, ORLoss of aircraft control for undetermined reasons during the takeoff sequence.Jul 16, 2006 · N58MX · DestroyedNTSB SEA06IA105Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Portland, ORThe inadvertent deployment of the off-wing escape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel.May 17, 2006 · N506UA · No damageNTSB SEA06CA059Accident · No injuriesData collectionFinal reportBeech V35B · Burns, ORThe pilot's failure to maintain clearance from the terrain during the takeoff sequence. Factors include his inadequate removal of snow and ice from the wings prior to takeoff, his improper decision to retract the landing gear before it had been positively…Mar 4, 2006 · N3511V · Substantial damageNTSB SEA06CA034Accident · Minor injuriesData collectionFinal reportCessna 182G · Sweet Home, ORThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the paved runway surface, encountering muddy terrain and nosing over. Contributing factors were the night light condition and the muddy terrain.Dec 28, 2005 · N3199S · Substantial damageNTSB SEA05CA131Accident · No injuriesData collectionFinal reportMaule M-7-235B · Hermiston, ORThe pilot's failure to maintain directional control during the takeoff ground roll which resulted in overload damage to the main landing gear. During the landing roll, it was not possible to maintain aircraft control due to the previously damaged gear.…Jun 24, 2005 · N333DD · Substantial damageNTSB SEA05CA093Accident · No injuriesData collectionFinal reportJohnson Johnson Chris-Tena · Lebanon, ORThe loss of engine power on takeoff for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.May 3, 2005 · N72JJ · Substantial damageNTSB SEA05LA016Accident · Minor injuriesLimited investigationFinal reportHannah Avid Amphibian · Creswell, ORCarburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.Nov 14, 2004 · N80AH · Substantial damageNTSB SEA04LA178Accident · Serious injuriesLimited investigationFinal reportHelio H800 · Fossil, ORThe pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.Sep 1, 2004 · N4033G · DestroyedNTSB SEA04LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Bend, OROn ground encounter with terrain during the takeoff roll as a result of the left side brake not operating. Inadequate maintenance inspection, overload of the nose landing gear and soft terrain were factors.Jun 16, 2004 · N332CC · Substantial damageNTSB SEA04LA014Accident · Serious injuriesLimited investigationFinal reportTracy Kolb Mark III · Prineville, ORThe pilot in command's failure to maintain aircraft control during an aborted takeoff. Factors include the pilot's lack of experience in this type of aircraft (pusher).Oct 19, 2003 · NONE · Substantial damageNTSB SEA03CA178Accident · No injuriesData collectionFinal reportBeech C24R · Bend, ORThe first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.Aug 26, 2003 · N6536C · Substantial damageNTSB SEA03LA126Accident · No injuriesLimited investigationFinal reportDruckman 102 · Alsea, ORThe pilot's failure to maintain directional control during the take-off roll, when his foot became lodged between the rudder pedal and the heel brake. An additional factor is a fence near the area where he was taking off from.Jul 7, 2003 · N102DR · Substantial damageNTSB SEA03LA090Accident · No injuriesLimited investigationFinal reportBeech 95 C-55 · Canby, ORThe pilot's inadequate preflight planning resulting in fuel starvation and subsequent loss of power after takeoff. High vegetation was a factor.May 31, 2003 · N660K · Substantial damageNTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.Apr 19, 2003 · N7057F · Substantial damageNTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.Apr 15, 2003 · N606HS · Substantial damageNTSB SEA03LA039Accident · No injuriesLimited investigationFinal reportKesterson Nieuport 11 · Independence, ORAircraft control not maintained during takeoff. Factors include soft/muddy terrain.Feb 13, 2003 · N110DK · Substantial damageNTSB SEA03LA010Accident · No injuriesLimited investigationFinal reportLearjet 36A · Astoria, ORCollision with an elk during the takeoff roll. Factors include dark night VFR conditions.Dec 3, 2002 · N546PA · DestroyedNTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.Oct 15, 2002 · N885CR · Substantial damageNTSB SEA02LA152Accident · No injuriesLimited investigationFinal reportBeech B35 · Halfway, ORThe pilot's delay in initiating an aborted takeoff and his failure to establish climb out of ground effect. Contributing factors were the high aircraft weight and high density altitude as well as the fence and berm, which the aircraft struck.Aug 11, 2002 · N5029C · Substantial damageNTSB SEA02LA082Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gaston, ORThe pilot's failure to maintain clearance from object(s) while executing a forced landing following a total loss of power for undetermined cause(s). Contributing factors where the pole impacted during the emergency landing and the pilot's diverted attention.May 16, 2002 · N43085 · Substantial damageNTSB SEA01LA176Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Estacada, ORThe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. A tailwind, fence and the pilot's lack of total experience in the type of aircraft were factors.Sep 30, 2001 · N1021E · Substantial damageNTSB SEA01LA178Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Glide, ORInadequate compensation for wind conditions during takeoff resulting in the pilot's failure to maintain directional control. Wind gusts, down sloping terrain and a fence post were factors.Jun 13, 2001 · N3422N · Substantial damageNTSB SEA00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gleneden Beach, ORThe pilot's failure to remove the control lock during his preflight inspection. Factors contributing to the accident were the pilot's failure to follow the BEFORE TAKEOFF checklist, trees beyond the upwind end of the runway, and the pilot's self-induced…Aug 9, 2000 · N737CM · Substantial damageNTSB SEA00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Lexington, ORThe pilot's failure to adequately compensate for wind conditions upon encountering a wind shift on takeoff. A factor was variable winds.Apr 22, 2000 · N82698 · Substantial damageNTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.Jun 10, 1999 · N24MP · Substantial damageNTSB SEA99FA060Accident · No injuriesField investigationFinal reportBeech 36 · Portland, ORImproper installation of the strobe light system. Factors include a leak in the fuel bladder and electrical arcing.May 8, 1999 · N6222V · Substantial damageNTSB SEA99LA048Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Pendleton, ORA loss of power due to water contamination of the fuel. Factors include the inability of the helicopter to perform a successful autorotation immediately after takeoff.Apr 7, 1999 · N51770 · Substantial damageNTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.Mar 9, 1999 · N41096 · Substantial damageNTSB SEA98LA182Accident · 1 fatalLimited investigationFinal reportCora Allegro · Cresent Lake, ORThe pilot's failure to maintain clearance from trees located off the departure end of the runway. Factors include strong, variable, gusty winds, terrain-induced turbulence, a high density altitude, and trees off the departure end of the runway.Sep 18, 1998 · OKDUU · DestroyedNTSB SEA98LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Aurora, ORDirectional control was not maintained by the pilot in command. Factors include rough terrain and hidden obstructions.Jul 7, 1998 · N2646A · Substantial damageNTSB SEA98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manzanita, ORThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a crosswind gust during the takeoff roll.Jun 20, 1998 · N6556J · Substantial damageNTSB SEA98FA047Accident · No injuriesField investigationFinal reportAerospatiale SN-601 · Portland, ORThe pilot-in-command's decision to attempt takeoff with the right engine inoperative, resulting in his failure to maintain directional control or attain adequate airspeed during the takeoff attempt. Factors included a fractured right engine starter-generator…Mar 19, 1998 · N600RA · Substantial damageNTSB SEA98LA030Accident · No injuriesLimited investigationFinal reportRaser Mini 500 · Newberg, ORa power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.Jan 28, 1998 · N500YY · Substantial damageNTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.Nov 22, 1997 · N7528D · Substantial damageNTSB SEA98LA012Accident · No injuriesLimited investigationFinal reportAerostar PA-60-700P · Portland, ORThe pilot's selection of an improper remedial action for an unanticipated yaw excursion during takeoff roll, resulting in the aircraft becoming airborne with inadequate airspeed and consequent loss of aircraft control.Nov 7, 1997 · N700HS · Substantial damage