OpenAirDocs.org

NTSB investigations

14,038 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.\"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 NYC04LA119Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Morrisville, VTThe improper installation of an electrical wire, which resulted in arching and the initiation of a fuel vapor explosion. A factor related to the accident was the failure of maintenance personnel to detect a cracked rubber fuel vent line nipple.May 9, 2004 · N151LL · Substantial damageNTSB FTW04LA127Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Brinkley, ARThe pilots failure to attain flying airspeed after takeoff. A factor was the overloading of agricultural chemicals that exceeded the airplane's maximum takeoff weight.May 8, 2004 · N203H · Substantial damageNTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.May 5, 2004 · N65752 · Substantial damageNTSB IAD04LA019Accident · Minor injuriesLimited investigationFinal reportKrotje VM-1 Esqual · Cambridge, OHThe pilot's failure to maintain directional control. A factor was the inadequate brake system installed on the airplane.May 1, 2004 · N626EA · Substantial damageNTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.Apr 25, 2004 · N6228A · DestroyedNTSB ATL04LA100Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Fort Pierce, FLThe loss of engine power due to fuel starvation resulting from a crack in the gascolator bowl.Apr 24, 2004 · N5674F · Substantial damageNTSB ANC04LA041Accident · No injuriesLimited investigationFinal reportChampion 7GC · Wasilla, AKThe flight instructor's inadequate supervision of the student pilot which resulted in a loss of directional control during the takeoff roll, and subsequent collision with a ditch. A factor contributing to the accident was the student pilot's failure to…Apr 19, 2004 · N8529E · Substantial damageNTSB DEN04CA062Accident · No injuriesData collectionFinal reportCessna 180A · Las Vegas, NMthe pilot's decision to takeoff in wind conditions that consisted of a quarterly tailwind and a crosswind in excess of the maximum demonstrated crosswind component, and his failure to maintain directional control.Apr 14, 2004 · N8956Q · Substantial damageNTSB IAD04CA015Accident · No injuriesData collectionFinal reportWaco ASO · Lexington, KYThe pilot's inadequate remedial action to wake turbulence. A factor was the pilot's failure to recognize that the takeoff conditions were conducive to wake turbulence.Apr 9, 2004 · N11253 · Substantial damageNTSB CHI04LA100Accident · 1 fatalLimited investigationFinal reportChristen A-1 · Curtis, NEThe pilot's ostentatious display of a "hammerhead stall" during intial climb and his failure to maintain clearance from terrain. A factor was the post impact fire.Apr 5, 2004 · N9599B · DestroyedNTSB CHI04LA096Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · Omaha, NEThe pilot failed to maintain directional control during takeoff. Contributing factors to the accident were the runway light and the soft terrain.Mar 31, 2004 · N636SP · Substantial damageNTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.Mar 14, 2004 · N1883V · Substantial damageNTSB LAX04CA154Accident · Minor injuriesData collectionFinal reportAyres S-2R · Los Banos, CAthe pilot's failure to maintain proper runway alignment due to visual restrictions from the light condition, resulting in a nose over. Factors in the accident were the dusk light conditions and sun glare.Mar 12, 2004 · N8930Q · Substantial damageNTSB ANC04LA034Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe pilot's delayed response in initiating an aborted takeoff, which resulted in an overrun and collision with a snowbank.Mar 5, 2004 · N515N · Substantial damageNTSB NYC04CA080Accident · No injuriesData collectionFinal reportBellanca 7ECA · Hornell, NYAn inadvertent encounter with soft snow during takeoff.Feb 29, 2004 · N86715 · Substantial damageNTSB NYC04LA078Accident · 1 fatalLimited investigationFinal reportRaven Industries Rally RX7 · Nicholasville, KYThe pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.Feb 28, 2004 · N4110M · Substantial damageNTSB CHI04LA079Accident · No injuriesLimited investigationFinal reportRobinson R44 · Burlington, WIThe pilot's inadequate visual lookout and his failure to obtain/maintain clearance from the transmission wire during the takeoff. Factors contributing to the accident were the transmission wire and the pole.Feb 28, 2004 · N7184G · Substantial damageNTSB FTW04IA078Incident · No injuriesIncident investigationFinal reportBeech C90 · Oklahoma City, OKThe failure of the right main landing gear to extend due to an improperly installed attachment bolt by other maintenance personnel.Feb 19, 2004 · N21 · Minor damageNTSB ANC04LA032Accident · No injuriesLimited investigationFinal reportCessna 208B · Toksook Bay, AKThe pilot's inadequate planning and decision to initiate a takeoff into a crosswind that exceeded the airplane's demonstrated crosswind component, which resulted in a loss of directional control during the takeoff roll, and subsequent collision with terrain…Feb 10, 2004 · N1276P · Substantial damageNTSB SEA04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · McCall, IDThe failure of the right rear ski cable and the owner's improper substitution of the right rear ski cable with an unapproved ski cable. A factor was the slushy snow.Feb 8, 2004 · N5753Z · Substantial damageNTSB FTW04LA072Accident · No injuriesLimited investigationFinal reportCessna 172-SP · McKinney, TXThe student pilot's failure to maintain directional control of the aircraft during the take-off roll.Feb 7, 2004 · N2124Z · DestroyedNTSB ANC04LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Girdwood, AKThe pilot's delay in aborting the takeoff, which resulted in an overrun and collision with a snowbank. A factor in the accident was an inoperative airspeed indicator.Jan 25, 2004 · N1361U · Substantial damageNTSB LAX04CA104Accident · Serious injuriesData collectionFinal reportBeech F33A · Shoshone, CAthe CFI's failure to verify the wind direction prior to takeoff, which resulted in his failure to attain an adequate airspeed and led to an inadvertent stall-mush. The short runway and variable winds were factors.Jan 22, 2004 · N33HY · Substantial damageNTSB CHI04LA060Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Minneapolis, MNA loss of engine power for undetermined reasons.Jan 19, 2004 · N1968W · Substantial damageNTSB MIA04CA040Accident · No injuriesData collectionFinal reportCessna 210L · Fort Meade, FLThe failure of the pilot to abort the takeoff after encountering fog during the preflight and engine run-up, and also his failure to maintain proper alignment with the runway during the takeoff roll due to a fogged windshield resulting in the collision with a…Jan 14, 2004 · N453MC · Substantial damageNTSB LAX04CA093Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZfailure of the pilot to maintain directional control on the takeoff roll. A factor in the accident was the pilot's failure to retract the flaps.Jan 14, 2004 · N4160A · Substantial damageNTSB ATL04LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Allendale, SCThe failure of the hydraulic brake system accumulator due to a ruptured diaphragm. A factor was the ditch.Jan 11, 2004 · N800SL · Substantial damageNTSB ATL04LA063Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Taylorsville, NCThe pilot's failure to follow the checklist, resulting in a loss of directional control on the takeoff roll when the seat moved rearward, and on ground collision with an embankment.Jan 3, 2004 · N3102S · Substantial damageNTSB LAX04CA082Accident · No injuriesData collectionFinal reportCessna 172N · Angels Camp, CAthe CFI's inadequate compensation for a crosswind condition, which resulted in the loss of directional control. The crosswind and wind gusts were factors.Dec 29, 2003 · N461BD · Substantial damageNTSB NYC04LA050Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's inadequate pre-flight inspection, which resulted in a decrease in airplane performance due to ice, and a subsequent hard landing.Dec 20, 2003 · N9469B · Substantial damageNTSB FTW04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Harrison, ARThe collapsing of the right main landing gear during the landing roll out as a result of impacting an animal on the runway during takeoff.Dec 20, 2003 · N69RS · Substantial damageNTSB NYC04IA054Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Teterboro, NJThe captain's inadequate preflight planning, which resulted in an overrun during an aborted takeoff.Dec 16, 2003 · N95EB · Minor damageNTSB FTW04LA041Accident · Serious injuriesLimited investigationFinal reportBull SE5-A · Rio Hondo, TXThe pilot's failure to maintain control of the tailwheel equipped airplane during takeoff. Contributing factors were the pilot's selection of the wrong runway for takeoff and the prevailing tailwind.Dec 13, 2003 · N42LB · DestroyedNTSB FTW04CA030Accident · Minor injuriesData collectionFinal reportBell 206L1 · Paris, ARThe pilot's failure to remove the main rotor tiedown prior to engine startup. Contributing factors were the pressure induced by conditions/events, improper preflight of the aircraft, and dark night conditions,Nov 29, 2003 · N103AE · Substantial damageNTSB CHI04LA037Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Menominee, MIThe Phillips screwdriver impacting the left tire on takeoff roll, and the deflated tire which did not allow directional control to be maintained during the subsequent landing.Nov 26, 2003 · N297JB · Substantial damageNTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.Nov 23, 2003 · N22XL · Substantial damageNTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.Nov 20, 2003 · N971PA · Substantial damageNTSB FTW04IA023Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Is. 27The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.Nov 16, 2003 · N405PH · Minor damageNTSB LAX04LA050Accident · No injuriesLimited investigationFinal reportBoeing 747-422 · San Francisco, CAa tail strike due to a combination of the wind shifting from a headwind to a tailwind during rotation, and the pilot's control inputs for the crosswind condition.Nov 14, 2003 · N178UA · Substantial damageNTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Nov 12, 2003 · N95604 · Substantial damageNTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.Nov 6, 2003 · N6463S · Substantial damageNTSB CHI04LA024Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakota, NDThe student pilot not maintaining directional control during takeoff roll on a solo instructional flight. The factor to the accident was the wind gusts.Nov 2, 2003 · N730SP · Substantial damageNTSB ATL04IA028Incident · No injuriesIncident investigationFinal reportPiper PA-32RT-300T · Fayetteville, NCFlight control elevator attachment turnbuckle corrosion and fracture resulting in the loss of aircraft control in flight.Oct 25, 2003 · N39541 · Minor 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 MIA04CA005Accident · Minor injuriesData collectionFinal reportCessna 172N · Everglades City, FLThe pilot's improper preflight planning/preparation which resulted in the airplane's gust lock being left installed, which resulted in the airplane not being able lift off during the takeoff roll, and damage to the airplane when it overran the runway and…Oct 19, 2003 · N933JH · Substantial damageNTSB NYC04IA010Incident · No injuriesIncident investigationFinal reportBeech 1900D · Albany, NYThe maintenance technician's improper maintenance performed on the airplane, and his failure to perform a functional check, which resulted in a restricted movement of the elevator trim wheel. Factors were the captain's inadequate preflight inspection, and…Oct 16, 2003 · N850CA · No damageNTSB CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…Oct 15, 2003 · N5204F · Substantial damageNTSB CHI04LA010Accident · No injuriesLimited investigationFinal reportWright Redux Association 1903 Wright Flyer · Bolingbrook, ILThe inadequate planning/decision by the pilot to begin a flight in gusting wind conditions, the pilot's lack of experience in the airplane, and the stall encountered by the pilot during takeoff. The wind gusts were a contributing factor.Oct 14, 2003 · N203WF · Substantial damageNTSB NYC04LA008Accident · Minor injuriesLimited investigationFinal reportSibila VP 1 · Cincinnati, OHThe pilot's delayed decision to abort the takeoff, which resulted in a collision with trees.Oct 13, 2003 · N4087F · Substantial damageNTSB MIA04CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Archer, FLThe pilot's failure to maintain directional control during the takeoff roll/run, which resulted in the airplane veering off the centerline of the runway and impacting an object, incurring damage.Oct 12, 2003 · N9291P · Substantial damage