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 ATL00LA057Accident · No injuriesLimited investigationFinal reportJohn Thomas Cloud Dancer 2 · Franklin, NCThe pilot's failure to maintain directional control of the gyroplane during takeoff roll, resulting in a roll over.May 26, 2000 · N6314T · Substantial damageNTSB ANC00LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Nenana, AKThe pilot's inadequate compensation for wind conditions during landing. A factor in this accident was the tailwind.May 26, 2000 · N43863 · Substantial damageNTSB MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.May 22, 2000 · N6744K · Substantial damageNTSB CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.May 22, 2000 · N68182 · Substantial damageNTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.May 20, 2000 · N231X · Substantial damageNTSB DEN00FA092Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Denver, COpropeller blade fatigue failure due to stress corrosion.May 19, 2000 · N235BA · Substantial damageNTSB MIA00LA159Accident · Minor injuriesLimited investigationFinal reportRichard Shaffer Aircamper GN-1 · Florence, SCThe failure of the pilot to maintain directional control after takeoff resulting in the uncontrolled descent and impact on a closed runway.May 17, 2000 · N2308C · Substantial damageNTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.May 13, 2000 · N8319A · Substantial damageNTSB FTW00FA146Accident · 6 fatalField investigationFinal reportBeech BE-95-B55 · Houston, TXthe loss of control on takeoff as a result of the pilot's failure to remove the flight control lock due to his inadequate preflight inspection. A contributing factor was the pilot exceeding the aircraft's certificated maximum weight and balance limitations.May 12, 2000 · N4005A · DestroyedNTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.May 9, 2000 · N7345Z · Substantial damageNTSB NYC00LA130Accident · Minor injuriesLimited investigationFinal reportLudeman HP-18 · Kutztown, PAThe pilot's failure to maintain control of the glider. A factor related to the accident was the pilot's lack of experience in make and model.May 7, 2000 · N67TT · DestroyedNTSB FTW00LA139Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Socorro, NMThe pilot's failure to maintain directional control during the aborted takeoff, which resulted in an inadvertent groundloop.May 6, 2000 · N6905M · Substantial damageNTSB DEN00FA085Accident · No injuriesField investigationFinal reportde Havilland DHC-6-300 · Monument Valley, UTThe pilot-in-command's failure to maintain directional control. A factor was wind shear.May 5, 2000 · N241SA · Substantial damageNTSB ATL00LA049Accident · No injuriesLimited investigationFinal reportde Havilland DH-82C Tigermoth · Daytona Beach, FLThe pilot's inadequate pre-flight inspection of the fuel supply that resulted in the loss of engine power due to fuel contamination.May 1, 2000 · N819DH · Substantial damageNTSB LAX00LA180Accident · No injuriesLimited investigationFinal reportTracy Lancair 235 · Redding, CAThe pilot's loss of directional control during takeoff for undetermined reasons.Apr 29, 2000 · N235RL · DestroyedNTSB FTW00LA134Accident · No injuriesLimited investigationFinal reportCessna 140 · Tulsa, OKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the runway sign struck by the aircraft.Apr 28, 2000 · N140RE · Substantial damageNTSB NYC00FA122Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJStress rupture of the 2nd-stage low pressure turbine anti-rotation nozzle locks, resulting from inadequate nozzle lock design.Apr 25, 2000 · N39081 · Substantial damageNTSB CHI00LA124Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340B · Hancock, MIthe deer which ran onto the runway and were subsequently struck by the airplane.Apr 25, 2000 · N404XJ · Substantial damageNTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…Apr 25, 2000 · N779AN · No damageNTSB CHI00LA122Accident · No injuriesLimited investigationFinal reportCunningham Pietenpol Aircamper · Boone, IAthe pilot not maintaining directional control. Factors were the gusts and the fence.Apr 23, 2000 · N899TC · 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 SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.Apr 21, 2000 · N3579V · Substantial damageNTSB LAX00LA166Accident · No injuriesLimited investigationFinal reportPZL-Mielec M-18A · Williams, CAA momentary interruption in engine power for undetermined reasons.Apr 21, 2000 · N62587 · Substantial damageNTSB FTW00LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Gould, ARThe stall/mush encountered by the pilot. A factor was the crosswind.Apr 21, 2000 · N8699S · Substantial damageNTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.Apr 20, 2000 · N9187V · Substantial damageNTSB ATL00LA044Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colquitt, GAA loss of engine power for undetermined reasons.Apr 20, 2000 · N8899S · Substantial damageNTSB LAX00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAThe student pilot's loss of directional control on takeoff that resulted in a collision with a taxiway surface.Apr 11, 2000 · N2500T · Substantial damageNTSB CHI00LA105Accident · Minor injuriesLimited investigationFinal reportWeinzierl Titan Tornado II · Maple Plain, MNthe obstructed fuel system filter, the inadequate silicone material the builder used, and the rough and uneven terrain. A factor was that suitable landing terrain was not available.Apr 2, 2000 · N196KW · Substantial damageNTSB LAX00LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · Sacramento, CAThe failure of the pilot to maintain directional control of the aircraft during the takeoff roll. A rough, uneven runway surface was a factor in the accident.Mar 18, 2000 · N80205 · Substantial damageNTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.Mar 16, 2000 · N251RS · Substantial damageNTSB FTW00LA110Accident · No injuriesLimited investigationFinal reportCessna A188B · Perryton, TXThe pilot's failure to maintain directional control during the takeoff roll. A factor was the crosswind.Mar 13, 2000 · N4833Q · Substantial damageNTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.Mar 13, 2000 · N6637 · Substantial damageNTSB FTW00LA095Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Midland, TXThe separation of the right main landing gear tire tread which resulted in damage to the right main landing gear mounting structure.Mar 10, 2000 · N8071R · Substantial damageNTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…Mar 9, 2000 · N79960 · 2 aircraft · DestroyedNTSB ANC00IA034Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Fairbanks, AKA delayed rotation during takeoff for an undetermined reason.Mar 7, 2000 · N949AS · No damageNTSB ANC00LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Lake, AKThe pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft, snow-covered terrain, and an inadvertent ground loop.Mar 5, 2000 · N2814C · Substantial damageNTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.Feb 21, 2000 · N22017 · Substantial damageNTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…Feb 20, 2000 · N811CK · Substantial damageNTSB FTW00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Weir, TXThe delayed aborted takeoff by the pilot. Factors were the pilot's intentional ground loop/swerve and the tail wind.Feb 19, 2000 · N76190 · Substantial damageNTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.Feb 16, 2000 · N757XG · Substantial damageNTSB NYC00LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJEngine failure due to the disconnection of the intake manifold from the #3 cylinder, as a result of improper maintenance.Feb 16, 2000 · N4531F · Substantial damageNTSB LAX00LA100Accident · No injuriesLimited investigationFinal reportBell 47G5 · Riverbank, CAthe pilot's failure to verify that ground personnel had disconnected the loading hose from the hopper before takeoff, resulting in restricted directional control and a hard landing.Feb 16, 2000 · N4754R · Substantial damageNTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.Feb 13, 2000 · N5679R · Substantial damageNTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…Feb 8, 2000 · N6630F · Substantial damageNTSB ANC00LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuluksak, AKThe pilot's failure to maintain proper alignment during the takeoff roll. A factor associated with the accident was a soft area of snow on the runway.Feb 7, 2000 · N327CT · Substantial damageNTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.Feb 5, 2000 · N738EJ · Substantial damageNTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.Jan 26, 2000 · N7VS · Substantial damageNTSB LAX00LA079Accident · No injuriesLimited investigationFinal reportRobinson R22B · Piru, CAFailure of the pilot to maintain control after encountering a dynamic rollover.Jan 22, 2000 · N4072T · Substantial damageNTSB FTW00FA070Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-26A · San Antonio, TXthe pilot's failure to maintain the minimum controllable airspeed following a loss of engine power during the initial takeoff climb. Contributing factors to the accident were both pilot's lack of total experience in the make and model of the accident airplane…Jan 22, 2000 · N386TM · DestroyedNTSB CHI00LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · East Troy, WIThe proper alignment not being maintained by the dual student during an attempted running takeoff and the inadequate supervision of the pilot-in-command (CFI).Jan 22, 2000 · N4047C · Substantial damage