NTSB investigations, ID

255 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\" = 'ID' 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 WPR15LA029Accident · No injuriesLimited investigationFinal reportHenry Steven J Just Acft Superstol · Murphy, IDThe pilot’s failure to properly manage the fuel supply, which resulted in a total loss of engine power due to fuel starvation.Oct 28, 2014 · N682SC · Substantial damageNTSB WPR14CA352Accident · Minor injuriesData collectionFinal reportRans S 6S · Rigby, IDThe student pilot's loss of directional control during takeoff in gusting wind conditions. Contributing to the accident was the flight instructor's failure to intervene and apply corrective flight control inputs.Aug 22, 2014 · N171CT · Substantial damageNTSB WPR14LA341Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Idaho Falls, IDThe pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Aug 12, 2014 · N18GH · Substantial damageNTSB WPR14CA317Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hazelton, IDThe pilot's failure to maintain aircraft control during takeoff roll in variable wind conditions.Jul 28, 2014 · N802TY · Substantial damageNTSB WPR14CA294Accident · Minor injuriesData collectionFinal reportThrush S2RHG T65 · Parma, IDThe pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.Jul 16, 2014 · N4036G · Substantial damageNTSB WPR14CA178Accident · Minor injuriesData collectionFinal reportElemdorf 1002 · Rexburg, IDThe pilot's loss of directional control and early rotation during takeoff. Contributing to the accident was the failure of the pilots to exercise adequate communication techniques.Apr 29, 2014 · C-FOWD · Substantial damageNTSB WPR14CA035Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Twin Falls, IDThe pilot's loss of aircraft control during the rejected takeoff.Oct 26, 2013 · N83417 · Substantial damageNTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.Jul 25, 2013 · N4249Z · Substantial damageNTSB WPR13LA308Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18B · Caldwell, IDThe pilot’s improper decision to continue the takeoff with a tailwind after he recognized a performance problem with the airplane and his delayed action to dump the chemical load.Jul 3, 2013 · N7643J · Substantial damageNTSB WPR13CA199Accident · No injuriesData collectionFinal reportCessna A185E · Cottonwood, IDThe pilot’s failure to see and avoid an object on the grass airstrip during the takeoff.Apr 7, 2013 · N2303Y · Substantial damageNTSB WPR13CA179Accident · No injuriesData collectionFinal reportAeronca 7CCM · Caldwell, IDThe pilot's loss of directional control after an encounter with a wind gust during takeoff.Apr 3, 2013 · N4687E · Substantial damageNTSB WPR12LA283Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Stanley, IDThe pilot’s inadequate preflight planning and decision to takeoff at a density altitude outside of the airplane’s takeoff performance envelope, with a tailwind, and near the airplane’s maximum gross weight, which resulted in the airplane’s inability to climb…Jun 30, 2012 · N773C · Substantial damageNTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.Jun 23, 2012 · N13VC · Substantial damageNTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.Aug 14, 2011 · N7825K · Substantial damageNTSB WPR11LA366Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Hazelton, IDPartial loss of engine power for undetermined reasons.Aug 3, 2011 · N4021S · Substantial damageNTSB WPR11FA349Accident · No injuriesField investigationFinal reportHawker Beechcraft G36 · Hailey, IDThe pilot's inadvertent activation of the auxiliary fuel pump, which resulted in a loss of engine power during takeoff.Jul 23, 2011 · N536BB · Substantial damageNTSB WPR11LA269Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Caldwell, IDThe total loss of power in one engine during takeoff due to the blockage of fuel flow by a foreign object in the fuel tank.Jun 20, 2011 · N3278Q · Substantial damageNTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.Jan 4, 2011 · N90TY · Substantial damageNTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.Sep 18, 2010 · N4427M · Substantial damageNTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.Sep 2, 2010 · N7502Y · Substantial damageNTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.Aug 16, 2010 · N621AL · Substantial damageNTSB WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.Aug 14, 2010 · N992WS · Substantial damageNTSB WPR10CA346Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Yellow Pine, IDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the wet condition of the grass runway.Jul 12, 2010 · N2185K · Substantial damageNTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.Jun 27, 2010 · N51MW · Substantial damageNTSB WPR10LA274Accident · Serious injuriesLimited investigationFinal reportSmithwick/Treidel Tukan · Prairie, IDThe pilot's loss of control of the weight-shift-controlled airplane during takeoff for undetermined reasons.May 30, 2010 · N7513W · Substantial damageNTSB SEA08TA188Accident · No injuriesFinal reportHughes 369D · Bonners Ferry, IDThe pilot's inadequate preflight planning for the takeoff and the helicopter loading that exceeded the lift performance capability of the helicopter.Aug 18, 2008 · N622PB · Substantial damageNTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.Aug 18, 2008 · N6702Q · Substantial damageNTSB SEA08LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Big Creek, IDThe pilot's delayed decision to abort the landing and failure to achieve the proper touchdown point. Contributing to the accident was a high density altitude.Jul 7, 2008 · N5652Q · Substantial damageNTSB LAX08CA210Accident · No injuriesData collectionFinal reportCessna TU206G · Coeur d'Alene, IDThe pilot's failure to maintain proper runway alignment and clearance from a large rock on the side of the runway. Contributing to the accident was the failure of the pilot to maintain the runway environment of his private strip clear of obstructions.Jul 1, 2008 · N4776U · Substantial damageNTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.Jun 29, 2008 · N83056 · Substantial damageNTSB LAX08CA186Accident · No injuriesData collectionFinal reportAlon A2 · Sandpoint, IDThe airplane struck a deer on the runway while performing touch-and-go landings. Contributing to the accident was the dusk light condition.Jun 17, 2008 · N1018S · Substantial damageNTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.Mar 5, 2008 · N2039U · Substantial damageNTSB SEA07CA219Accident · No injuriesData collectionFinal reportCessna 170 B · Arco, IDThe pilot's failure to maintain directional control during takeoff. The crosswind condition was a factor.Jul 28, 2007 · N3446C · Substantial damageNTSB SEA07CA186Accident · No injuriesData collectionFinal reportCessna 182 · Bear Lake, IDThe separation of the bolt that holds the nosewheel steering torque arm to the nose wheel strut during the takeoff roll, resulting in no nosewheel steering being available during the landing roll at the pilot's destination. Factors include the pilot's failure…Jun 22, 2007 · N3570B · Substantial damageNTSB SEA07CA153Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hailey, IDThe pilot's failure to maintain directional control during the takeoff ground roll. A tailwind was a factor.Jun 12, 2007 · N4018Z · Substantial damageNTSB SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.Dec 17, 2006 · N19698 · Substantial damageNTSB SEA06CA148Accident · No injuriesData collectionFinal reportCessna 172F · American Falls, IDThe pilot's failure to maintain an airspeed above stall speed. Factors include his improper decision to takeoff with a tailwind, and the effects of the tailwind upon the aircraft's takeoff performance.Jul 29, 2006 · N8707U · Substantial damageNTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.Jul 12, 2006 · N2434G · Substantial damageNTSB SEA06CA136Accident · No injuriesData collectionFinal reportCessna 206G · Stanley, IDThe pilot's failure to maintain directional control during an aborted takeoff. Factors include a tailwind gust, and a large rock near the side of the runway.Jun 3, 2006 · N7537N · Substantial damageNTSB SEA06CA090Accident · No injuriesData collectionFinal reportCessna A188B · Minidoka, IDThe pilot's failure to abort the takeoff. A berm at the end of the runway was a factor.May 3, 2006 · N8959G · Substantial damageNTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.Apr 26, 2006 · N91JE · Substantial damageNTSB SEA06CA023Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries HK 36 TTC · Sandpoint, IDExcessive speed for the landing roll and inadequate remedial action for the initial takeoff. An object near the end of the runway and snow covered surface were factors.Dec 4, 2005 · N543MD · Substantial damageNTSB SEA05CA152Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.Jul 28, 2005 · N90RW · Substantial damageNTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.Jul 19, 2005 · N6702Q · Substantial damageNTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…Jul 17, 2005 · N721JW · Substantial damageNTSB SEA05CA119Accident · No injuriesData collectionFinal reportAdkins Ridge Runner II · Pocatello, IDThe pilot's failure to maintain directional control during the takeoff roll, which resulted in an inadvertent ground loop/swerve.Jun 19, 2005 · N825PB · Substantial damageNTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.Oct 17, 2004 · N101AM · Substantial damageNTSB SEA04LA180Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Picabo, IDThe pilot's failure to set the propeller control for takeoff performance needed to outclimb obstacles. The pilot's failure to use the checklist, trees, and a fence are contributing factors.Sep 5, 2004 · N880SC · Substantial damageNTSB SEA04LA172Accident · No injuriesLimited investigationFinal reportTubbs PA-18-225 DD · Salmon, IDDirectional control not maintained during the takeoff roll resulting in a runway excursion and subsequent nose over. Factors include a drainage ditch.Aug 21, 2004 · N7993A · Substantial damageNTSB SEA04LA145Accident · No injuriesLimited investigationFinal reportBell 222U · Louie Lake, IDThe failure of the pilot to maintain rotor rpm and his inadequate recovery from a bounced landing. Factors contributing to the accident included the tailwind condition and the tree.Jul 14, 2004 · N277LF · Substantial damage