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 CHI99LA126Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Atchison, KSThe loss of engine power for unknown reasons.Apr 9, 1999 · N2990G · Substantial damageNTSB SEA99LA048Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Pendleton, ORA loss of power due to water contamination of the fuel. Factors include the inability of the helicopter to perform a successful autorotation immediately after takeoff.Apr 7, 1999 · N51770 · Substantial damageNTSB ATL99LA067Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Lantana, FLThe pilot's failure to secure the engine oil filler cap during the preflight inspection that resulted the subsequent loss of engine power, and his in-flight decision to attempt a single engine go-around with full wing flaps extended.Apr 5, 1999 · N838MA · Substantial damageNTSB NYC99LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln Univ., PAThe student pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. Also causal was the certified flight instructor's inadequate supervision.Apr 3, 1999 · N2472N · Substantial damageNTSB ANC99LA038Accident · No injuriesLimited investigationFinal reportCessna 170B · Mccarthy, AKThe pilot's failure to abort the takeoff in a timely manner. Factors associated with the accident were a tailwind, the pilot's inadequate weather evaluation, and the pilot's premature liftoff.Mar 28, 1999 · N3200A · Substantial damageNTSB LAX99LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Scottsdale, AZFailure of the student pilot to maintain directional control of the aircraft while retracting the flaps during a touch-and-go.Mar 27, 1999 · N73859 · Substantial damageNTSB CHI99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marquette, MIthe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain directional control. Factors associated with the accident were the gusty crosswind conditions and the taxiway sign which the airplane contacted.Mar 27, 1999 · N66BH · Substantial damageNTSB ATL99LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Dahlonega, GAThe pilot's failure to maintain directional control during takeoff.Mar 27, 1999 · N1766K · Substantial damageNTSB MIA99LA111Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Zephyrhills, FLThe student pilot's improper use of flight controls (cyclic and collective) during a takeoff to a hover. This resulted in the helicopter encountering dynamic rollover and rolling over on its right side.Mar 24, 1999 · N4412C · Substantial damageNTSB CHI99LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · New Hudson, MIThe pilot's misjudgment of speed and distance and his failure to execute a go-around. A related factor was the crosswind.Mar 24, 1999 · N75BG · Substantial damageNTSB ATL99LA057Accident · No injuriesLimited investigationFinal reportBeech 23 · Jacksonville, FLThe overload failure of the landing gear attach points during takeoff from a turf airstrip. Factors are rough and uneven terrain.Mar 21, 1999 · N3621Q · Substantial damageNTSB FTW99LA097Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Hobart, OKThe loss of engine power due to an undetermined reason. A factor was the ditch.Mar 19, 1999 · N5647X · DestroyedNTSB FTW99FA094Accident · 2 fatalField investigationFinal reportEurocopter AS-350-B2 · Eugene Is. 193the loss of control as a result of the spring-steel extension becoming entangled with the hatch door handle during takeoff. A contributing factor was the flat design of the spring-steel extension.Mar 17, 1999 · N6100R · DestroyedNTSB ATL99LA051Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Finley, TNThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the gusting winds.Mar 12, 1999 · N36484 · Substantial damageNTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.Mar 10, 1999 · N89084 · Substantial damageNTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.Mar 9, 1999 · N41096 · Substantial damageNTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…Mar 6, 1999 · N4312A · 2 aircraft · DestroyedNTSB LAX99LA112Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · San Jose, CAThe loss of aircraft control due to the pilot's sudden application of collective combined with excessive cyclic inputs.Feb 27, 1999 · N5700C · Substantial damageNTSB NYC99LA064Accident · No injuriesLimited investigationFinal reportBoeing 757 · Covington, KYA flock birds were ingested into both engines, resulting in substantial damage to the engines.Feb 22, 1999 · N682DA · Substantial damageNTSB MIA99LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Everglades City, FLThe failure of the PIC to maintain directional control on takeoff roll following a loss of power brought about by fuel starvation due to the PIC's failure to verify the proper setting of the fuel selector valve, and the subsequent collision with trees during…Feb 21, 1999 · N8309P · Substantial damageNTSB MIA99LA077Accident · Minor injuriesLimited investigationFinal reportLee S. Harvard LONG-EZ · Spring Hill, FLThe failure of the pilot to insure the canopy was closed prior to takeoff resulting in an aborted takeoff, overheating of the brakes, and a roll over when the aircraft was turned off the runway into the grass in an attempt to stop.Feb 11, 1999 · N96LH · Substantial damageNTSB MIA99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, NCThe student pilots failure to maintain directional control during an attempted touch and go landing. This resulted in the airplane veering off the left side of the runway, and subsequent on-ground collision with a ditch and nosed over inverted..Feb 8, 1999 · N6294M · Substantial damageNTSB CHI99LA087Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Cahokia, ILthe pilot's improper decision to initiate the takeoff with insufficient runway remaining. A factor associated with the accident was pilot's failure to obtain clarification from the controller regarding the clearance.Feb 6, 1999 · N544PC · Substantial damageNTSB ANC99IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Fairbanks, AKThe restricted/delayed movement of the elevator flight control due to extremely cold weather conditions.Feb 5, 1999 · N934AS · No damageNTSB MIA99LA074Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Crystal River, FLThe failure of the pilot to maintain directional control during takeoff and his failure to abort the takeoff after directional control was lost.Feb 3, 1999 · N68573 · Substantial damageNTSB ATL99LA137Accident · No injuriesLimited investigationFinal reportGettis H. Hudson Corban Baby ACE · Pleasant View, TNThe failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.Jan 30, 1999 · N24562 · Substantial damageNTSB ANC99LA024Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Anchorage, AKA frozen brake.Jan 13, 1999 · N9190D · Substantial damageNTSB LAX99LA070Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 Broussard · Minden, NVThe pilot's failure to maintain proper runway alignment during a rejected takeoff. A factor in the accident was the undetermined pitch control/trim system problem, which led to the pilot's rejected takeoff decision and may have distracted him during attempts…Jan 1, 1999 · N4022 · Substantial damageNTSB LAX99LA062Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Furnace Creek, CAThe pilot's inadequate preflight inspection when he failed to remove the gust lock from the flight controls.Dec 31, 1998 · N2313L · Substantial damageNTSB MIA99LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Pembroke Pines, FLThe pilot's decision to abort the takeoff with insufficient runway remaining.Dec 24, 1998 · N252WM · Substantial damageNTSB NYC99LA038Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Cincinnatti, OHThe flight instructor's delay in initiating remedial action. Factors include a wet runway, and the student's inability to maintain airplane directional control during a simulated, on-ground engine failure.Dec 19, 1998 · N42RR · Substantial damageNTSB ANC99LA017Accident · No injuriesLimited investigationFinal reportCasa C-212 · Mcgrath, AKThe flightcrew's inadequate compensation for wind conditions. A factor associated with the accident was a crosswind.Dec 18, 1998 · N502FS · Substantial damageNTSB FTW99LA050Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Mesquite, TXThe student pilot's failure to maintain directional control during a simulated engine failure during takeoff maneuver and the instructor's inadequate supervision. Factors were; the student's lack of total flight time in multiengine airplanes, and the soft…Dec 15, 1998 · N6DL · Substantial damageNTSB FTW99LA048Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-BA · San Angelo, TXthe rollover during take off for undetermined reasons.Dec 13, 1998 · N911MV · Substantial damageNTSB NYC99FA037Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Greenville, PAThe pilot's failure to maintain directional control during touch-and-go landing, and his failure to maintain obstacle clearance. A factor was the tree.Dec 12, 1998 · N43778 · Substantial damageNTSB MIA99LA041Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fort Gains, GAa power loss due to internal damage to the second- and third- stage turbine rotor blades, due to thermal heat, rendering the engine incapable of producing full power, resulting in a forced landing, and subsequent impact with the terrain.Dec 1, 1998 · N6630Q · Substantial damageNTSB IAD99LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Akron, OHThe pilot's inadequate preflight which resulted in a takeoff with the fuel cap unsecured.Nov 25, 1998 · N3396Y · Substantial damageNTSB FTW99LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Matagorda 713The pilot's loss of control due to his failure to untie ground straps. A factor was his inadequate preflight inspection.Nov 15, 1998 · N21466 · Substantial damageNTSB LAX99LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Lancaster, CAThe failure of the pilot to maintain directional control of the aircraft.Nov 14, 1998 · N733AM · Substantial damageNTSB CHI99LA027Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Monticello, INlow altitude stall and an ostentatious display by the pilot. Factors associated with this accident were the performance of a low altitude maneuver and an abrupt pullup by the pilot.Nov 13, 1998 · N5213B · DestroyedNTSB CHI99LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Liberty, MOThe excessive rotation by the pilot-in-command. The climb not obtained by the pilot-in-command, the fence and the trees were contributing factors.Nov 6, 1998 · N42342 · Substantial damageNTSB FTW99LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe student pilot's failure to maintain directional control of the airplane.Nov 3, 1998 · N46887 · Substantial damageNTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.Nov 2, 1998 · N185Z · Substantial damageNTSB CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.Nov 1, 1998 · N5908D · Substantial damageNTSB LAX99LA018Accident · No injuriesLimited investigationFinal reportBeech C90 · Sedona, AZThe instructor's failure to maintain runway alignment during the takeoff roll.Oct 27, 1998 · N37PT · Substantial damageNTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.Oct 25, 1998 · N5139B · Substantial damageNTSB ANC99LA006Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A · English Bay, AKThe pilot-in-command's inadequate compensation for the crosswind conditions, and failure to maintain adequate clearance from the parked airplane. Factors associated with this accident were the gusty crosswinds, and the congested takeoff area due to no parking…Oct 16, 1998 · N6522T · Substantial damageNTSB LAX99LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Apple Valley, CAThe pilot's inadvertent use of the aircraft's brakes while using the rudder pedals to maintain directional alignment during the takeoff roll.Oct 12, 1998 · N4316L · Substantial damageNTSB ANC99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Napaskiak, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. Factors in the accident were the pilot's inadequate planning/decision to continue a second takeoff following an engine surge and aborted takeoff, and unsuitable…Oct 8, 1998 · N6874M · Substantial damageNTSB MIA99FA005Accident · No injuriesField investigationFinal reportBoeing 727-224 · Miami, FLThe catastrophic failure of the 8th stage high pressure compressor disk from cadmium embrittlement as a result of improper adherence to the prescribed plating procedures and requirements by the company that last plated the disk. Contributing to the accident…Oct 7, 1998 · N66734 · Substantial damage