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 FTW95LA140Accident · Serious injuriesLimited investigationFinal reportBeecher Polliwagen PW-1 · New Waverly, TXThe pilot's failure to abort the takeoff. Factors were his failure to obtain engine performance data, the resulting improper red line marking on the tachometer, and the improper adjustment of the propeller.Mar 18, 1995 · N192EB · Substantial damageNTSB NYC95LA073Accident · No injuriesLimited investigationFinal reportBeech 23 · Plymouth, NHThe pilot's failure to maintain runway alignment during the aborted takeoff. Factors related to the accident were: the adverse runway conditions and snowbank beside the runway.Mar 15, 1995 · N9305S · Substantial damageNTSB CHI95LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · West Fargo, NDthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the soft terrain that the airplane encountered.Mar 15, 1995 · N60564 · Substantial damageNTSB FTW95LA137Accident · No injuriesLimited investigationFinal reportCessna 140 · Fentress, TXThe sudden movement of an animal into the path of the aircraft during takeoff roll. Factors were the inability of the pilot to establish a visual lookout down the runway due to the runway's 'crowned' midpoint.Mar 13, 1995 · N76981 · Substantial damageNTSB NYC95LA072Accident · No injuriesLimited investigationFinal reportCessna 120 · Skaneateles, NYThe student pilot's failure to maintain directional control and his improper use of the brakes.Mar 12, 1995 · N77467 · Substantial damageNTSB BFO95LA031Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDthe helicopter pilot's inadequate control of the aircraft during the attempted takeoff.Mar 11, 1995 · N2346P · Substantial damageNTSB ATL95LA060Accident · No injuriesLimited investigationFinal reportCessna 182P · Alabaster, ALThe pilot's failure to perform an adequate preflight inspection of the aircraft, which resulted in a takeoff with the control wheel lock installed.Mar 11, 1995 · N6236F · Substantial damageNTSB CHI95LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIthe student pilot's failure to maintain directional control during an aborted takeoff. A factor was the snow covered ground which contributed to the airplane nosing over as it departed the runway.Mar 9, 1995 · N4598B · Substantial damageNTSB NYC95LA061Accident · No injuriesLimited investigationFinal reportCessna 172M · West Seneca, NYThe pilot's improper planning/decision to attempt a takeoff on a narrow icy runway with crosswind conditions, which resulted in the loss of control of the airplane, impact with a snow bank, and a nose over.Feb 24, 1995 · N13229 · Substantial damageNTSB DCA95MA020Accident · 3 fatalClass 1 · MajorFinal reportDouglas DC-8-63 · Kansas City, MO(1) The loss of directional control by the pilot in command during the takeoff roll, and his decision to continue the takeoff and initiate a rotation below the computed rotation airspeed, resulting in a premature liftoff, further loss of control and collision…Feb 17, 1995 · N782AL · DestroyedNTSB LAX95LA115Accident · No injuriesLimited investigationFinal reportSkov-Papworth Q2 · Hollister, CAthe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. The pilot's lack of recent experience is a factor in the accident.Feb 16, 1995 · N2103 · Substantial damageNTSB LAX95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corona, CAthe pilot's failure to maintain runway alignment after aborting a takeoff and improper use of the brakes during the abort.Feb 16, 1995 · N9512H · Substantial damageNTSB FTW95LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COThe pilot's premature rotation.Feb 6, 1995 · N80893 · Substantial damageNTSB LAX95LA097Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · San Martin, CAthe failure of the pilot to attain takeoff speed and maintain directional control from a grass airstrip and his improper preflight of the runway for obstructions.Feb 3, 1995 · N8643V · Substantial damageNTSB ATL95LA047Accident · 2 fatalLimited investigationFinal reportBrandt Rutan Longeze · Marietta, GAThe pilot's delayed abort of the ground run which resulted in a runway overrun and collision with the ravine.Feb 1, 1995 · N103JB · DestroyedNTSB LAX95LA090Accident · No injuriesLimited investigationFinal reportBeech F33A · Tucson, AZthe student pilot's poor short field takeoff procedure and excessive nose rotation resulted in an inadvertent stall. A factor is the student pilot's lack of total experience.Jan 31, 1995 · N6635C · Substantial damageNTSB FTW95LA104Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mountain View, ARThe pilot's selection of a downwind runway for takeoff, his failure to use all available runway, and delay in aborting the takeoff. A factor was the tailwind.Jan 31, 1995 · N2610L · Substantial damageNTSB CHI95LA078Accident · No injuriesLimited investigationFinal reportBoeing 747-238B · Belleville, MIthe failure of company maintenance personnel to adequately secure the cargo pallets, and the failure of the flightcrew to detect the deficiency during their preflight inspection.Jan 29, 1995 · N706CK · Substantial damageNTSB SEA95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Salem, ORFuel starvation due to inadequate supervision of the dual student by the pilot-in-command when the dual student improperly adjusted the fuel selector position.Jan 27, 1995 · N9201P · Substantial damageNTSB LAX95IA086Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Albuquerque, NMmaintenance personnel inadvertently overservicing the left main landing gear strut with nitrogen that, during rotation with the aircraft weight on the strut reduced, gave the pilots a rolling sensation to the right.Jan 24, 1995 · N155AW · No damageNTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.Jan 24, 1995 · N8825Z · Substantial damageNTSB CHI95LA072Accident · No injuriesLimited investigationFinal reportStuart/Wagner Mountain Eagle · Halliday, NDThe pilot's premature lift-off and delayed aborted takeoff.Jan 22, 1995 · N2176Z · Substantial damageNTSB LAX95FA082Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Joshua Tree, CAthe operator's inadequate annual inspection by failing to find that the flight control's horizontal section of the 'T' bar was rubbing against the vacuum hoses behind the instrument panel. The jammed 'T' bar and the rough terrain were factors in this accident.Jan 20, 1995 · N4279E · Substantial damageNTSB MIA95LA058Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Natchez, MSInadequate preflight of the helicopter by the pilot for his failure to separate the dolly before attempting flight.Jan 17, 1995 · N8462E · DestroyedNTSB LAX95LA102Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Wickenburg, AZThe pilot-rated passenger's failure to maintain directional control of the airplane during the takeoff ground roll, and the pilot-in-command's inadequate supervision of the pilot-rated passenger, who had sole access to the airplane's brakes.Jan 13, 1995 · N2183B · Substantial damageNTSB NYC95LA048Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Canfield, OHThe pilot's decision to abort the takeoff on a snow and ice covered runway, and once made, the pilot's decision to lower the flaps.Jan 7, 1995 · N560WM · Substantial damageNTSB FTW95LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Torreon, NMThe pilot's failure to attain proper liftoff speed resulting in an inadvertent stall and the failure to remove frost from the wing. A factor was fatigue.Jan 1, 1995 · N30898 · Substantial damageNTSB LAX95LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-161 · Elko, NVThe pilot selected unsuitable terrain for takeoff.Dec 29, 1994 · N2269Z · Substantial damageNTSB BFO95IA023Incident · No injuriesIncident investigationFinal reportDouglas DC-8-54F · New York, NYThe failure of the right main landing gear's shock strut piston lug due to stress corrosion.Dec 25, 1994 · N427FB · Minor damageNTSB MIA95LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe student pilots failure to follow the checklist and assure the door was closed prior to takeoff. Contributing to the accident was the student's diverted attention during the takeoff roll.Dec 18, 1994 · N89515 · Substantial damageNTSB ANC95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Juneau, AKThe pilot's selection of unsuitable terrain for the attempted takeoff.Dec 17, 1994 · N5285J · Substantial damageNTSB LAX95LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Corona, CAthe pilot's failure to maintain directional control due to his improper use of the rudder and brakes.Dec 11, 1994 · N6882W · Substantial damageNTSB ATL95LA026Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe pilot's failure to maintain directional control during a crosswind takeoff.Dec 11, 1994 · N6466D · Substantial damageNTSB MIA95LA036Accident · Serious injuriesLimited investigationFinal reportColvin Kitfox II · Fort Pierce, FLThe failure of the pilot to abort the takeoff when he encountered water on the grass runway.Dec 10, 1994 · N491WC · Substantial damageNTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.Dec 9, 1994 · N6445P · Substantial damageNTSB FTW95LA059Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Village Mills, TXThe pilot's selection of unsuitable terrain for takeoff. A factor was the rough condition of the grass runway.Dec 5, 1994 · N4855J · DestroyedNTSB MIA95LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fajardo, PRThe malfunction of a magneto resulting in a partial loss of power over unsuitable terrain.Dec 4, 1994 · N404FL · Substantial damageNTSB CHI95MA044Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 · Bridgeton, MOThe Cessna 441 pilot's mistaken belief that his assigned departure runway was runway 30R, which resulted in his undetected entrance onto runway 30R, which was being used by the MD-82 for its departure. Contributing to the accident was the lack of Automatic…Nov 23, 1994 · N954U · 2 aircraft · Substantial damageNTSB MIA95LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Indiantown, FLAn evasive maneuver to avoid collision with animals.Nov 22, 1994 · N67390 · Substantial damageNTSB FTW95IA049Incident · No injuriesIncident investigationFinal reportBoeing B-737-200 · Springfield, MOThe failure of either the inboard or the outboard wheel bearing assembly due to undetermined reasons.Nov 18, 1994 · N988UA · Minor damageNTSB FTW95LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COThe pilot's loss of directional control.Nov 16, 1994 · N6386L · Substantial damageNTSB CHI95LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Zeeland, MIthe pilot's loss of directional control during touch and go landings. Factors were the crosswind and the pilot's lack of total experience.Nov 11, 1994 · N3875V · Substantial damageNTSB BFO95LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bucyrus, OHThe pilot's faliure to maintain directional control during the takeoff roll.Nov 10, 1994 · N160UU · Substantial damageNTSB NYC95LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · Nunda, NYthe pilot-in-command's failure to assure that an adequate runway length was available.Oct 30, 1994 · N9235J · Substantial damageNTSB MIA95LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Crystal River, FLA partial loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Oct 30, 1994 · N19264 · Substantial damageNTSB MIA95LA013Accident · Minor injuriesLimited investigationFinal reportSemco Challenger · Miami, FLFailure of the basket suspension cables due to corrosion and overstress separations. Contributing to the accident was an inadequate annual inspection of the basket suspension cables by an authorized FAA repairman.Oct 29, 1994 · N2048J · Substantial damageNTSB BFO95LA008Accident · Serious injuriesLimited investigationFinal reportAmerican General AA1 · Beach City, OHthe pilot-in-command's failure to maintain adequate control of the aircraft during the takeoff. The pilot's inadequate compensation for unfavorable wind conditions is a related factor in this accident.Oct 29, 1994 · N6114L · Substantial damageNTSB MIA95FA010Accident · 2 fatalField investigationFinal reportCessna 182P · Raymond, MSThe pilot's impairment of judgment and performance due to alcohol, and his resulting failure to maintain altitude after takeoff.Oct 26, 1994 · N58792 · DestroyedNTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.Oct 21, 1994 · N6958V · Substantial damageNTSB ATL95FA005Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Lexington, NCThe pilot's operation of the aircraft with a known deficiency (foreign material or particle in the pitot tube), which led to a false airspeed indication and premature lift-off of the aircraft during takeoff, and the pilot's improper remedial action that…Oct 20, 1994 · N26966 · Destroyed