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 NYC04LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Cynthiana, KYThe inoperative left main landing gear brake check valve, which resulted in a loss of directional control during the takeoff.Aug 28, 2004 · N888LC · Substantial damageNTSB FTW04LA222Accident · No injuriesLimited investigationFinal reportLancair 320 · Houston, TXThe pilot's premature lift-off before attaining adequate airspeed resulting in a stall and collision with the ground.Aug 27, 2004 · N30KR · Substantial damageNTSB ANC04LA097Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to abort the takeoff, which resulted in a collision with a river bank during the takeoff run.Aug 26, 2004 · N49GB · Substantial damageNTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.Aug 23, 2004 · N9573 · Substantial damageNTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…Aug 22, 2004 · N5410T · DestroyedNTSB 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 LAX04FA300Accident · 2 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Oroville, CAthe pilot's failure to maintain clearance from the water's surface, which resulted in his dragging of the right wing pontoon during low-altitude flight. The glassy-surfaced water was a contributing factor to the accident.Aug 21, 2004 · N1238L · DestroyedNTSB FTW04LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · New Braunfels, TXThe student pilot's failure to maintain directional control of the airplane. A contributing factor was the high wind condition.Aug 18, 2004 · N739AM · Substantial damageNTSB LAX04CA315Accident · Minor injuriesData collectionFinal reportBell 206B · Kahului, HIthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a dynamic rollover. Contributing factors were the direct crosswind and his lack of total experience in the accident helicopter make and model.Aug 16, 2004 · N529RS · Substantial damageNTSB NYC04LA193Accident · Minor injuriesLimited investigationFinal reportGlobe Swift GC-1B · Wolfeboro, NHThe pilot's inadequate compensation for wind condition. The windshear was a contributing factor.Aug 14, 2004 · N78176 · Substantial damageNTSB DCA04IA066Incident · No injuriesIncident investigationFinal reportBoeing B-777 · Houston, TXthe failure of a high pressure turbine blade which damaged an oil seal and allowed smoke to enter the cabin. Contributing to the blade failure was the mis-labeling of the blade's part number by the manufacturer, which allowed the blade to remain in service…Aug 11, 2004 · G-VIID · Minor damageNTSB CHI04CA221Accident · No injuriesData collectionFinal reportCessna 310Q · Nappanee, INThe delay in the pilot's performance of an aborted takeoff. A factor was the reported restricted movement of the elevator. Additional factors were the rising easement and roadway the airplane went over before coming to rest in the farmers field.Aug 10, 2004 · N7940Q · Substantial damageNTSB LAX04CA288Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe student pilot's failure to abort the takeoff. A contributing factor was the pilot's failure to maintain directional control.Aug 8, 2004 · N5327G · Substantial damageNTSB CHI04CA218Accident · No injuriesData collectionFinal reportCessna 305A · Frankfort, MIThe tow pilot failed to maintain directional control during takeoff roll and failed to abort the takeoff. Additionally, the tow pilot failed to attain adequate airspeed which resulted in a stall. The tailwind and the tall grass were contributing factors.Aug 8, 2004 · N54517 · Substantial damageNTSB DEN04IA124Incident · No injuriesIncident investigationFinal reportBoeing 737-500 · Denver, COthe inaccurate radar information due to the failure of the Airport Movement Area Surveillance radar resulting in the tower calling for the airplane to abort the takeoff, subsequently causing tire and brake damage to the airplane.Aug 7, 2004 · N929UA · Minor damageNTSB LAX04CA286Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZthe pilot's failure to maintain directional control during the takeoff roll.Aug 5, 2004 · N1529A · Substantial damageNTSB CHI04LA212Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Chesterfield, MOThe pilot's inadequate preflight planning due to his selection of an unsuitable takeoff area and his failure to maintain clearance from the open hangar door. A contributing factor was the open hangar door.Aug 5, 2004 · N7036J · Substantial damageNTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.Aug 3, 2004 · N7957U · Substantial damageNTSB CHI04FA205Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Point Lookout, MOThe pilot's failure attain adequate flying speed and his delay in aborting the takeoff which resulted in premature liftoff and an overrun of the runway. Contributing factors were the descending embankment, trees and ravine.Aug 2, 2004 · N4230R · DestroyedNTSB CHI04CA219Accident · No injuriesData collectionFinal reportLake LA4-200 · Oshkosh, WIThe unsuitable rough water conditions encountered during the attempted water takeoff.Aug 1, 2004 · N1056L · Substantial damageNTSB CHI04LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Custer, SDThe pilot's poor preflight planning/preparation and the pilot used improper aborted takeoff procedures by not reducing the throttle. Factors associated with the accident were the high density altitude and the tailwind.Jul 31, 2004 · N4345J · Substantial damageNTSB ANC04LA099Accident · No injuriesLimited investigationFinal reportCessna U206G · Yakutat, AKThe pilot's inadequate preflight inspection, and his failure to secure the cargo door, which resulted in the cargo door coming open during the takeoff roll.Jul 29, 2004 · N9178G · Substantial damageNTSB ANC04CA083Accident · No injuriesData collectionFinal reportPiper J5A · Kotzebue, AKThe pilot's inadvertent use of the airplane's brakes during the takeoff roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.Jul 23, 2004 · N2364 · Substantial damageNTSB FTW04LA195Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Columbus, TXthe pilot's failure to maintain directional control during the takeoff roll and abort the attempted takeoff.Jul 22, 2004 · N5118Q · Substantial damageNTSB DEN04LA112Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Rifle, COthe pilot's failure to maintain aircraft control during the aborted takeoff resulting in the airplane departing the runway and striking a runway light and two taxiway signs. Factors contributing to the accident were the broken sensor wire to the left engine's…Jul 21, 2004 · N84GA · Substantial damageNTSB CHI04CA189Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Merrill, WIThe dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…Jul 21, 2004 · N45628 · Substantial damageNTSB SEA04CA138Accident · No injuriesData collectionFinal reportCessna A185F · Cut Bank, MTThe pilot's failure to maintain directional control during the takeoff roll.Jul 16, 2004 · N185S · Substantial damageNTSB SEA04CA136Accident · Minor injuriesData collectionFinal reportCessna 150L · La Center, WAThe private pilot receiving the flight review's failure to follow the Owner’s Manual's procedures for a go-around. Contributing factors were the flight instructor's delay in telling the private pilot to go-around, and the trees.Jul 16, 2004 · N18542 · 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 damageNTSB DEN04CA100Accident · No injuriesData collectionFinal reportAeronca 7AC · Limon, COthe pilot's inadequate preflight planning/preparation. A contributing factor was the soft terrain in the takeoff area.Jul 5, 2004 · N1480E · Substantial damageNTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.Jul 3, 2004 · N2546H · Substantial damageNTSB IAD04LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chatsworth, NJA blocked internal oil passage, which resulted in inadequate lubrication of the blower impeller shaft, and the subsequent partial loss of engine power.Jul 2, 2004 · N915X · Substantial damageNTSB MIA04CA104Accident · Minor injuriesData collectionFinal reportWilliam K. Crawford Tango 2 · Williston, FLThe failure of the pilot to maintain directional control of the airplane during a high speed taxi test resulting in the airplane veering off the left side of the runway, becoming airborne, and nosing over.Jun 30, 2004 · N56KC · Substantial damageNTSB FTW04LA171Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Tulsa, OKThe loss of engine power for undetermined reasons.Jun 29, 2004 · N6183M · Substantial damageNTSB LAX04LA249Accident · 1 fatalLimited investigationFinal reportBell 206B · Mesa, AZthe pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.Jun 25, 2004 · N97AZ · Substantial damageNTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…Jun 20, 2004 · N7690E · Substantial damageNTSB FTW04LA164Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe separation of the right main landing gear wheel and axle during take-off. Contributing factors were the fatigue of the bolts on the right main landing gear and the rough and uneven terrain.Jun 17, 2004 · N6567 · Substantial damageNTSB 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 ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.Jun 13, 2004 · N98981 · Substantial damageNTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.Jun 12, 2004 · N1970K · Substantial damageNTSB FTW04LA159Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eagle Lake, TXThe partial collapse of the left main landing gear as a result of a failure of the fuselage structure due to corrosion.Jun 11, 2004 · N3104S · Substantial damageNTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.Jun 8, 2004 · N7094D · DestroyedNTSB MIA04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lake Wales, FLThe pilot's delay in aborting the takeoff resulting in an overrun of the runway and subsequent impact with water. A finding in the accident was the pilot's failure to extend the flaps to the second notch (25 degrees).Jun 7, 2004 · N41916 · Substantial damageNTSB ANC04LA060Accident · No injuriesLimited investigationFinal reportCessna 180E · Kenai, AKThe pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control which resulted in an inadvertent ground loop and nose over. A factor contributing to the accident was a direct crosswind.Jun 3, 2004 · N5180 · Substantial damageNTSB LAX04LA227Accident · No injuriesLimited investigationFinal reportBeech A36 · Hollister, CAthe pilot's inadequate preflight inspection which failed to detect the mis-rigged elevator trim system, and the pilot's delay in aborting the takeoff.May 30, 2004 · N6797Y · Substantial damageNTSB FTW04FA144Accident · 2 fatalField investigationFinal reportAviat A-1 · Harwood, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.May 29, 2004 · N623KD · Substantial damageNTSB NYC04CA131Accident · No injuriesData collectionFinal reportCessna 120 · New Castle, PAThe pilot's failure to use all available takeoff area and his delay in aborting the takeoff.May 25, 2004 · N1996V · Substantial damageNTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.May 19, 2004 · N4508Y · DestroyedNTSB IAD04LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Old Town, METhe pilot's failure to abort the takeoff. Factors were the pilot's incorrect assessment of the airplane's weight and the muddy terrain.May 17, 2004 · N7793E · Substantial damageNTSB FTW04LA131Accident · No injuriesLimited investigationFinal reportCooke Rotorway Exec · Willis, TXThe partial loss of engine power due to the failure of the #1 cylinder valve retainer clip. A contributing factor was the lack of suitable terrain for the forced landing.May 15, 2004 · N319RC · Substantial damage