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 NYC08CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Lincoln, METhe pilot-rated-passenger's failure to maintain directional control during takeoff.Apr 6, 2008 · N2209K · Substantial damageNTSB DEN08CA073Accident · No injuriesData collectionFinal reportCessna 170B · Fort Collins, COthe pilot's failure to maintain directional control during takeoff.Apr 6, 2008 · N2232D · Substantial damageNTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.Apr 3, 2008 · N1755T · Substantial damageNTSB LAX08CA111Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Grand Canyon, AZThe pilot's inadequate compensation for the wind conditions and delay in aborting the takeoff. Contributing to the accident were wind gusts and a crosswind.Mar 30, 2008 · N5521J · Substantial damageNTSB DEN08CA068Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Mankato, KSthe student pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the fence and trees.Mar 28, 2008 · N50GM · Substantial damageNTSB SEA08IA096Incident · No injuriesIncident investigationFinal reportRaytheon 1900D · Page, AZThe flight crew’s unprofessional behavior and deviation from standard operating procedures which resulted in an in-flight emergency.Mar 26, 2008 · N261GL · Minor damageNTSB NYC08IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS355F1 · New York, NYThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from the other helicopter due to his focus on the engine instruments during the initial departure. Contributing to the accident was insufficient helipad spacing.Mar 22, 2008 · N406LH · Minor damageNTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.Mar 20, 2008 · N3304W · Substantial damageNTSB LAX08CA079Accident · No injuriesData collectionFinal reportCessna 180H · Moab, UTThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. A contributing factor was the unexpected dust devil.Mar 18, 2008 · N180LH · Substantial damageNTSB NYC08CA140Accident · No injuriesData collectionFinal reportRobinson R44 · Montgomery, NYThe pilot's loss of control during takeoff.Mar 17, 2008 · N3027Y · Substantial damageNTSB SEA08LA087Accident · No injuriesLimited investigationFinal reportMaule M-4 · Bishop, CAA loss of engine power due to foreign object ingestion in the induction system, which resulted in a stuck/jammed exhaust valve during the takeoff.Mar 7, 2008 · N51430 · Substantial damageNTSB NYC08LA124Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · West Chester, PAThe pilot's failure to ensure that the pitch trim was properly set for takeoff.Mar 6, 2008 · N4623W · Substantial damageNTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.Mar 5, 2008 · N2039U · Substantial damageNTSB ANC08CA041Accident · No injuriesData collectionFinal reportCessna 185 · Takotna, AKThe pilot's selection of unsuitable terrain for takeoff.Mar 5, 2008 · N1224F · Substantial damageNTSB DFW08CA075Accident · No injuriesData collectionFinal reportRobinson R-22 · Meraux, LAThe pilot's failure to ensure calculate weight and balance prior to flight. A contributing factor was the prevailing gusty winds.Mar 4, 2008 · N120KC · Substantial damageNTSB MIA08CA069Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control of the airplane during an aborted takeoff.Feb 29, 2008 · N9204L · Substantial damageNTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.Feb 24, 2008 · N455JS · Substantial damageNTSB DEN08LA061Accident · No injuriesLimited investigationFinal reportHardy Midget Mustang M-1 · Buena Vista, COThe pilot's failure to maintain directional control. Contributing to the accident was the gusty crosswind.Feb 23, 2008 · N53041 · Substantial damageNTSB CHI08CA086Accident · No injuriesData collectionFinal reportRans S-4 Coyote I · Lakeville, MNThe pilot's failure to maintain directional control and his inadequate compensation for the crosswind conditions. Factors included the pilot's lack of experience in the make and model of the airplane and the crosswind gust.Feb 23, 2008 · N215LY · Substantial damageNTSB NYC08CA108Accident · No injuriesData collectionFinal reportAviat A-1B · Winder, GAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the gusty crosswind condition.Feb 19, 2008 · N47EA · Substantial damageNTSB MIA08CA064Accident · No injuriesData collectionFinal reportClutton Eric Fred S1 · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff.Feb 16, 2008 · N4499Y · Substantial damageNTSB MIA08CA061Accident · Minor injuriesData collectionFinal reportStephen F. Graves SG-3 · Fort Pierce, FLThe failure of the student to maintain directional control during a cross wind takeoff. A factor in the accident was inadequate supervision by the CFI.Feb 16, 2008 · N6232Y · Substantial damageNTSB NYC08CA095Accident · No injuriesData collectionFinal reportSonex Waiex · New Smyrna Bch., FLThe pilot's failure to maintain directional control during the takeoff. Contributing was the crosswind.Feb 8, 2008 · N35YX · Substantial damageNTSB OPS08IA006Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · St. Augustine, FLThe pilot's failure to adhere to the controller's takeoff instruction. Contributing to the incident was the controller's failure to properly monitor the flight, and the controller's decision to perform lesser duty priorities during the takeoff roll.Feb 7, 2008 · N140FT · Minor damageNTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.Feb 5, 2008 · N120SC · Substantial damageNTSB ANC08CA034Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · McGrath, AKThe pilot's failure to maintain directional control of the airplane during an aborted takeoff.Feb 5, 2008 · N323KT · Substantial damageNTSB CHI08CA073Accident · Serious injuriesData collectionFinal reportSquier Pauper II · Stockbridge, WIThe pilot's spatial disorientation while maneuvering after takeoff and his subsequent failure to maintain clearance from the terrain. Contributing factors were the snow-covered lake and overcast clouds, which resulted in the pilot's spatial disorientation due…Feb 3, 2008 · N70727 · Substantial damageNTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.Jan 20, 2008 · N71730 · Substantial damageNTSB NYC08CA080Accident · No injuriesData collectionFinal reportCessna C-152 · Labelle, FLThe pilot's improper decision to takeoff from an inadequate field after a forced landing.Jan 11, 2008 · N48251 · Substantial damageNTSB DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.Dec 29, 2007 · N33MF · Substantial damageNTSB DFW08CA051Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot's failure to maintain aircraft control. A contributing factor was prevailing crosswind.Dec 28, 2007 · N1458U · Substantial damageNTSB OPS08IA004Incident · No injuriesIncident investigationFinal reportGulfstream American G5 · Teterboro, NJThe probable cause of this incident was the TEB tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll.Dec 27, 2007 · N90AM · 2 aircraft · No damageNTSB NYC08LA070Accident · No injuriesLimited investigationFinal reportCessna 182R · Pittstown, NJA loss of engine power for undetermined reasons.Dec 26, 2007 · N9412X · Substantial damageNTSB MIA08CA045Accident · No injuriesData collectionFinal reportCessna 172P · Northampton, MAThe student pilot's failure to maintain directional control of the airplane during the takeoff roll and inadequate supervision by the CFI.Dec 26, 2007 · N5425K · Substantial damageNTSB ANC08TA028Accident · Minor injuriesFinal reportDouglas DC-3T · McMurdo Station, AYThe captain's decision to lift off before attaining a proper airspeed, resulting in a loss of control during takeoff.Dec 20, 2007 · C-FMKB · Substantial damageNTSB MIA08CA031Accident · No injuriesData collectionFinal reportCessna 310P · Dunnellon, FLThe improper installation of the right main landing gear scissors by company maintenance personnel, resulting in the collapse of the right main landing gear during takeoff.Dec 19, 2007 · N5811M · Substantial damageNTSB ANC08IA026Incident · Minor injuriesIncident investigationFinal reportBeech 1900 · Aniak, AKA hazardous leak from carbon dioxide cylinders due to the failure of the flight crew to properly load and secure the cylinders, resulting in crew incapacitation. Factors contributing to the incident were improper hazardous materials procedures used by the…Dec 17, 2007 · N111AX · No damageNTSB SEA08LA043Accident · No injuriesLimited investigationFinal reportBell UH-1B · Ennis, MTThe loss of collective control friction during takeoff that resulted in a collective bounce oscillation. Contributing to the accident was the pilot's failure to maintain aircraft control during the aborted takeoff and the snow covered terrain.Dec 5, 2007 · N46969 · Substantial damageNTSB OPS08IA002Incident · No injuriesIncident investigationFinal reportBombardier CRJ1 · Baltimore, MDThe probable cause of this incident is local controller's failure of maintaining awareness of the situation and failing to provide the appropriate separation between the two aircraft operating on intersecting runways. Providing separation between aircraft is…Dec 3, 2007 · N781CA · 2 aircraft · No damageNTSB NYC08LA050Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Talladega, ALThe pilot's inadequate visual lookout, which resulted in an in-flight collision with a wire.Dec 1, 2007 · N95CH · Substantial damageNTSB CHI08LA046Accident · 1 fatalLimited investigationFinal reportSwearingen T R/Masters W Rand KR 2 · Benton, ILThe reason for this accident is undetermined.Nov 29, 2007 · N7016M · DestroyedNTSB ANC08CA024Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Seward, AKThe pilot's failure to maintain directional control during takeoff.Nov 29, 2007 · N1181Y · Substantial damageNTSB DEN08IA033Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Phoenix, AZDelamination of the right outboard tire tread during the takeoff roll due to underinflation and/or overloading during use in service.Nov 25, 2007 · N3744F · Minor damageNTSB SEA08CA026Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Sedona, AZThe pilot's inadequate compensation for the wind condition, which resulted in his failure to maintain directional control during takeoff. Factors associated with the accident included the gusty crosswind condition and the taxiway sign.Nov 12, 2007 · N3656R · Substantial damageNTSB LAX08CA014Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Napa, CAThe pilot's failure to latch the cargo door during preflight.Nov 11, 2007 · N3038P · Substantial damageNTSB SEA08LA014Accident · No injuriesLimited investigationFinal reportRaytheon Corporate Jets Hawker 800XP · Santa Ana, CAThe failure of the pilot-in-command to follow procedures stipulated in the airplane flight manual regarding brake cooling time periods. Factors contributing to the accident were the intentional aborted takeoffs which resulted in the hot brakes, and the…Oct 29, 2007 · N800CC · Substantial damageNTSB CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.Oct 29, 2007 · N77LU · Substantial damageNTSB NYC08LA021Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Pensacola, FLThe fatigue fracture of the tail wheel spring during takeoff.Oct 26, 2007 · N2099K · Substantial damageNTSB ANC08CA005Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Wasilla, AKThe flight instructor's delayed remedial action during the takeoff roll, which resulted in an overrun during an aborted takeoff, and a collision with trees.Oct 20, 2007 · N6628N · Substantial damageNTSB CHI08CA024Accident · No injuriesData collectionFinal reportCessna C-182 · Cedar Springs, MIThe pilot's decision to takeoff with strong, gusty winds and his inability to stop the airplane prior to it traveling off the end of the runway during the delayed aborted takeoff. Factors associated with the accident were the wet, grass airstrip and gusty…Oct 19, 2007 · N1431S · Destroyed