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 LAX99FA003Accident · Minor injuriesField investigationFinal reportBell 222 · Las Vegas, NVThe pilot's failure to ensure that both throttles were in the takeoff position. Factors were the pilot's decision to takeoff with a tailwind, and his lack of recurrent emergency procedure training in this helicopter.Oct 4, 1998 · N213ML · DestroyedNTSB ATL99LA001Accident · No injuriesLimited investigationFinal reportCessna C-172F · Ball Ground, GAThe pilots failure to maintain directional control of the airplane on take-off, during gusty conditions, resulting in a collision with a tree.Oct 1, 1998 · N5588R · Substantial damageNTSB SEA98LA189Accident · No injuriesLimited investigationFinal reportCessna 172D · Ronan, MTThe pilot's failure to attain adequate airspeed during liftoff from a soft field takeoff. Factors include high density alttiude.Sep 29, 1998 · N2479Y · Substantial damageNTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.Sep 27, 1998 · N7353J · Substantial damageNTSB ANC98LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's failure to maintain directional control. Contributing factors were the gusty crosswind conditions.Sep 26, 1998 · N5697Y · Substantial damageNTSB ANC98LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mcgrath, AKThe failure of the pilot to maintain directional control during takeoff. Factors involved in the accident were a crosswind, and the trees adjacent to the takeoff area.Sep 24, 1998 · N2106A · Substantial damageNTSB ANC98LA155Accident · No injuriesLimited investigationFinal reportPiper PA-12 · New Stuyahok, AKThe pilot's selection of an unsuitable takeoff area and his intentional ground loop maneuver. A factor associated with the accident was trees.Sep 22, 1998 · N7689H · Substantial damageNTSB CHI98LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · West Lafayette, INthe student pilot's failure to maintain directional control during the touch and go takeoff.Sep 21, 1998 · N94286 · Substantial damageNTSB MIA98LA249Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Burlington, NCThe pilot's failure to abort the takeoff after recognizing that the airplane was slow to accelerate during the takeoff roll, and his not obtaining/maintaining clearance with the wire during the forced landing. Contributing factors were carburetor icing…Sep 20, 1998 · N48195 · DestroyedNTSB CHI98LA357Accident · No injuriesLimited investigationFinal reportCessna 182K · Baldwin, WIThe pilot's inadequate preflight planning and preparation, and his failure to stop on the wet, grassy runway. A related factor was the wet grass.Sep 20, 1998 · N2689Q · Substantial damageNTSB ANC98LA157Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's inadequate compensation for the gusty wind conditions, and his attempted flight into adverse weather. Factors associated with the accident are high and gusty winds.Sep 19, 1998 · N700NL · 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 ANC98LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Chalkitsik, AKThe pilot's failure to identify an unsafe/hazardous condition. A factor associated with the accident was soft terrain conditions.Sep 18, 1998 · N9407C · Substantial damageNTSB ANC98LA151Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to maintain adequate obstacle clearance.Sep 16, 1998 · N93904 · Substantial damageNTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.Sep 15, 1998 · N733XG · Substantial damageNTSB ANC98LA149Accident · No injuriesLimited investigationFinal reportCessna 207 · Sleetmute, AKThe pilot's selection of unsuitable terrain for departure. A factor in the accident was a narrow runway.Sep 13, 1998 · N1754U · Substantial damageNTSB NYC98FA185Accident · 1 fatalField investigationFinal reportCessna 170A · Lagrangeville, NYThe pilot's failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall/spin.Sep 12, 1998 · N4709Q · Substantial damageNTSB LAX98LA290Accident · No injuriesLimited investigationFinal reportWeber-Mustang II Diamond · Taft, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain proper runway alignment during the takeoff roll.Sep 12, 1998 · N10AW · Substantial damageNTSB FTW98LA397Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tahlequah, OKThe pilot's failure to maintain directional control of the aircraft during takeoff. A factor was the gusty wind conditions at the time of the accident.Sep 12, 1998 · N8548K · Substantial damageNTSB LAX98LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Los Banos, CAThe pilot's decision to takeoff in adverse wind conditions and inadequate compensation for the existing crosswind conditions, which resulted in a failure to maintain runway alignment.Sep 10, 1998 · N22JK · Substantial damageNTSB LAX98LA287Accident · No injuriesLimited investigationFinal reportCessna 170B · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional controlSep 10, 1998 · N8245A · Substantial damageNTSB MIA98TA243Accident · No injuriesFinal reportBell BHT-47-G3B1 · Buckhead Ridge, FLThe failure of the pilot to adequately compensate for a tailwind condition on liftoff from the helipad.Sep 9, 1998 · N73957 · Substantial damageNTSB ANC98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Willow, AKThe pilot's selection of an unsuitable takeoff area from the lake. Factors were the obstruction (point of land) hidden in the glare from the rising sun.Sep 9, 1998 · N30961 · Substantial damageNTSB CHI98LA336Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eaton Rapids, MIthe pilot's improper decision to abort the takeoff while in the air and beyond the point where the pilot could execute a landing on the remaining airstrip runway area. A factor which contributed to this accident was the soybean crop.Sep 7, 1998 · N6759F · Substantial damageNTSB FTW98LA385Accident · Serious injuriesLimited investigationFinal reportJobe'S TE-1 · Alamogordo, NMThe improper maintenance procedures (failure to preserve the engine during numerous storage periods over 30 days) and the lack of suitable terrain for a forced landing. Factors were the pilot's lack of experience in type of aircraft and the high density…Sep 6, 1998 · N6EZ · DestroyedNTSB FTW98LA389Accident · No injuriesLimited investigationFinal reportCessna 401 · Lancaster, TXThe pilot's inadvertent retraction of the landing gear while intending to retract the flaps. A factor was the pilots lack of total experience in the type of aircraft.Sep 4, 1998 · N3239Q · Substantial damageNTSB NYC98LA178Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Skaneateles, NYThe pilot's failure maintain directional control and his delayed decision to abort the takeoff. Contributing factors were trees.Sep 1, 1998 · N6287P · Substantial damageNTSB ANC98LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of an unsuitable area for takeoff. A factor associated with the accident is the pilot's premature liftoff.Sep 1, 1998 · N7279K · Substantial damageNTSB FTW98FA376Accident · Serious injuriesField investigationFinal reportDassault Falcon DA-20 · El Paso, TXThe captain's decision to abort the takeoff at an airspeed above V1, which resulted in a runway overrun. Contributing factors were: the loading of an excessive amout of cargo by the shipper which resulted in an over gross weight airplane, the high density…Aug 28, 1998 · N126R · Substantial damageNTSB IAD98LA099Accident · No injuriesLimited investigationFinal reportMooney M-20C · Kent Island, MDthe pilot's improper takeoff technique and his failure to abort the takeoff.Aug 22, 1998 · N6532U · Substantial damageNTSB MIA98LA228Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Ruleville, MSA fire of undetermined origin.Aug 21, 1998 · N1013Z · DestroyedNTSB LAX98LA273Accident · No injuriesLimited investigationFinal reportBell 206B · Salinas, CAThe failure of the pilot to maintain clearance with the irrigation pipes which resulted in the entanglement of the skids and the subsequent rollover.Aug 21, 1998 · N223HA · DestroyedNTSB ANC98TA128Accident · No injuriesFinal reportPiper PA-18 · Fairbanks, AKThe pilot's inadequate preflight planning/preparation, and his delay in aborting the takeoff. Factors in the accident were a short runway area for takeoff, trees located at the end of the runway, and the pilot's excessive application of brakes.Aug 21, 1998 · N74996 · Substantial damageNTSB CHI98LA322Accident · No injuriesLimited investigationFinal reportFairchild 24R-46A · Scribner, NEthe inadvertent ground loop caused by an unknown person who was in the process of stealing the airplane.Aug 20, 1998 · N28644 · Substantial damageNTSB ANC98LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot's failure to maintain directional control during takeoff. Factors associated with the accident were soft airstrip conditions, and trees.Aug 19, 1998 · N180WH · Substantial damageNTSB ANC98LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Chugiak, AKThe loss of engine power for an undetermined reason.Aug 19, 1998 · N4214H · Substantial damageNTSB LAX98LA268Accident · No injuriesLimited investigationFinal reportCessna 185 · Susanville, CAThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.Aug 17, 1998 · N8482D · Substantial damageNTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.Aug 17, 1998 · N2795A · Substantial damageNTSB CHI98LA324Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Michigan City, INthe pilot departed into known adverse weather and failed to maintain directional control of the airplane. A factor was the fog.Aug 16, 1998 · N30561 · Substantial damageNTSB MIA98LA225Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe student's improper retraction of the landing gear and the instructor's inadequate supervision.Aug 13, 1998 · N144JR · Substantial damageNTSB SEA98LA157Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot-in-command's not lowering flaps prior to takeoff and overload of the nose landing gear. Contributing factors were high density altitude conditions and high brush.Aug 7, 1998 · N7494Q · Substantial damageNTSB NYC98LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Hackettstown, NJThe pilot's failure to use the airplane's takeoff performance data, and his failure to obtain the proper climb airspeed.Aug 2, 1998 · N305RC · DestroyedNTSB CHI98FA296Accident · 1 fatalField investigationFinal reportCessna 340A · Chicago, ILthe pilot's improper use of the throttle in not using full power for takeoff, the pilot's failure to use proper aborted takeoff procedures, and the inadvertant stall/mush. A factor associated with the accident was inadequate preflight/planning by the pilot.Aug 2, 1998 · N5340F · Substantial damageNTSB IAD98LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAFailure to maintain directional control during the takeoff roll. A related factor was wind gusts.Aug 1, 1998 · N89074 · Substantial damageNTSB ANC98LA113Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kodiak, AKThe pilot's inadequate weather evaluation and compensation for wind conditions. Factors associated with the accident are wind gusts, a sudden windshift to a tailwind, the pilot's failure to abort the takeoff, and an inadvertent stall/mush.Jul 31, 1998 · N1083H · Substantial damageNTSB SEA98IA153Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135 · Moses Lake, WAAircraft control was not maintained.Jul 30, 1998 · PTZJA · Minor damageNTSB IAD98LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Salem, NJThe pilot's failure to maintain adequate altitude/clearance from the reeds. A related factor was the wind gusts.Jul 29, 1998 · N32583 · Substantial damageNTSB FTW98LA334Accident · Minor injuriesLimited investigationFinal reportCessna 500 · Rawlins, WYThe captain's use of improper airplane performance data, resulting in inadequate takeoff capability. Factors were his decision to abort the takeoff above V1, the separation of the drag chute, a wet runway, a tailwind, and collision with objects that included…Jul 25, 1998 · CFSKC · DestroyedNTSB CHI98LA280Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, MIthe student pilot's delay in performing the abort, and the instructor pilot's failure to take control of the airplane before passing the end of the runway. A factor contributing to this accident was the ditch.Jul 25, 1998 · N623AF · Substantial damageNTSB CHI98LA276Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Delavan, WIthe pilot's failure to maintain aircraft control during the takeoff roll. Factors contributing to this accident were the pilot's inadequate preflight, his operation of an airplane with a known deficiency, low air pressure on both main tires, the snow fence,…Jul 25, 1998 · N350NW · Substantial damage