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 CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.Jul 26, 1994 · N2564R · Substantial damageNTSB SEA94LA186Accident · No injuriesLimited investigationFinal reportEiriavion PIK20D-78 · Rexberg, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a vehicle parked near the runway.Jul 19, 1994 · N686CE · Substantial damageNTSB LAX94LA293Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Tehachapi, CAthe pilot's failure to secure the canopy before takeoff, and his failure to maintain directional control during landing rollout.Jul 19, 1994 · N38366 · Substantial damageNTSB SEA94FA182Accident · 1 fatalField investigationFinal reportCessna 172K · Patos Island, WAThe pilot's impairment of judgment and performance due to drugs (marijuana), and his improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees, while taking off toward the closed end of a cove.Jul 18, 1994 · N7417G · Substantial damageNTSB CHI94DCA02Accident · Minor injuriesFinal reportSchweizer G-164B · Harviell, MOthe separation of the oil supply line to the propeller governor, which resulted in the propeller inadvertently going into feather. Factors were the pilots intentional ground loop of the airplane to avoid impacting obstructions at the end of the runway.Jul 18, 1994 · N48484 · Substantial damageNTSB ANC94LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's failure to maintain directional control.Jul 18, 1994 · N9278C · Substantial damageNTSB ANC94FA087Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Mccarthy, AKThe pilot's inadvertent use of the parking brake during the takeoff and not aborting the takeoff. A factor in the accident was the pilot's improper use of the airplane checklist.Jul 18, 1994 · N6CC · Substantial damageNTSB ANC94LA082Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKThe pilot did not use the takeoff checklist to confirm that the flaps were extended for the takeoff.Jul 16, 1994 · N2297R · Substantial damageNTSB SEA94LA178Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Easton, WAImproper planning/decision by the pilot-in-command, and inadequate supervision by the check pilot, which resulted in their failure to remain clear of trees during takeoff. Factors related to the accident were: a downdraft and the proximity of trees to the…Jul 13, 1994 · N65857 · Substantial damageNTSB NYC94FA123Accident · No injuriesField investigationFinal reportGates Learjet 35 · Atlantic City, NJUnder-inflation of the tires, due to improper maintenance, which resulted in overheating and subsequent tire failure; the incorrect checklist that was provided to the aircrew; and failure of the pilot-in-command to deploy the drag chute, when the thrust…Jul 13, 1994 · N69PS · Substantial damageNTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.Jul 13, 1994 · N1257 · Substantial damageNTSB NYC94LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-700P · White Plains, NYThe pilot's delay in aborting the takeoff. A factor was internal obstruction of the pitot tube.Jul 12, 1994 · N323CB · DestroyedNTSB NYC94LA116Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Blairstown, NJThe pilot's failure to maintain directional control during takeoff, resulting in a loss of control and collision with the terrain.Jul 11, 1994 · N2899G · Substantial damageNTSB ANC94FA080Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Portage Creek, AKThe pilot's inadequate preflight planning and preparation, and his failure to ensure that the airplane was within its gross weight and center-of-gravity limits, which resulted in an inability to obtain sufficient airspeed for sustained flight and a resultant…Jul 11, 1994 · N8297X · Substantial damageNTSB ANC94LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate compensation for the wind condition. A factor in the accident was the gusty wind condition.Jul 9, 1994 · N2297R · Substantial damageNTSB SEA94LA181Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics PBY-5A · Lincoln City, ORThe pilot's failure to maintain clearance from a boat dock during the aborted takeoff. Factors include the pilot's poor inflight decision to land on a narrow lake under unfavorable wind conditions, and strong crosswinds during the attempted takeoff.Jul 8, 1994 · N2172N · Substantial damageNTSB CHI94LA226Accident · 2 fatalLimited investigationFinal reportCessna T210M · Beaver Island, MISpatial disorientation of the pilot-in-command due to flight into known instrument meteorological conditions; factors in the accident were the fog and low ceiling.Jul 8, 1994 · N88XH · DestroyedNTSB CHI94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Crosby, NDthe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the rough runway, and the pilot's improper preflight planning.Jul 8, 1994 · N9561P · Substantial damageNTSB LAX94LA277Accident · No injuriesLimited investigationFinal reportCessna 172 · Hanford, CAThe failure of the pilot to stop the aircraft in a timely manner after landing back on the runway following a loss of engine power for undetermined reasons.Jul 7, 1994 · N61569 · Substantial damageNTSB LAX94LA283Accident · Minor injuriesLimited investigationFinal reportMeyers ME 200 · Chico, CAA separation of the exhaust pipe from the cabin heat control valve and the lack of insulation on electrical wiring between the ammeter and the avionics bus.Jul 6, 1994 · N7MV · Substantial damageNTSB LAX94LA275Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Las Vegas, NVThe failure of the pilot to obtain the proper takeoff speed. Factors are the high density altitude and the crosswind.Jul 5, 1994 · N6959U · Substantial damageNTSB CHI94LA214Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Jefferson City, MOthe pilot allowing the airplane to get into an uncontrolled porpoising situation. A factor related to the accident was the choppy water.Jun 30, 1994 · N1404Z · Substantial damageNTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.Jun 27, 1994 · N45332 · Substantial damageNTSB ATL94LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe loss of engine power for undetermined reasons. Factors were wet and soft terrain.Jun 27, 1994 · N36484 · Substantial damageNTSB MIA94FA167Accident · 2 fatalField investigationFinal reportPiper PA-31-325 · Lantana, FLThe pilot's impairment of judgment and performance due to drugs, his failure to abort the takeoff after experiencing reduced takeoff performance, and his failure to maintain minimum control speed. Factors in the accident were: a partial loss of engine power…Jun 24, 1994 · N27872 · Substantial damageNTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.Jun 23, 1994 · N3627V · DestroyedNTSB SEA94LA158Accident · No injuriesLimited investigationFinal reportCessna A188 · Cut Bank, MTThe pilot's failure to adequately compensate for wind conditions. The crosswind and the ditch were factors.Jun 22, 1994 · N9879V · Substantial damageNTSB NYC94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphi, OHThe pilot's inadequate decision and his delay in aborting the takeoff, which resulted in an overrun of the runway and collision with obstaclesJun 22, 1994 · N5543F · Substantial damageNTSB SEA94LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Hubbard, ORDelayed in flight planning/decision.Jun 21, 1994 · N19297 · Substantial damageNTSB IAD94LA109Accident · No injuriesLimited investigationFinal reportbourque experimental Kitfox · Chester, CTThe fracture of the tailwheel assembly for undetermined reasons during the takeoff roll, and the subsequent loss of directional control and collision with a hangar.Jun 19, 1994 · N528AB · Substantial damageNTSB LAX94LA258Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Apple Valley, CAthe pilot's failure to maintain an adequate airspeed in the takeoff initial climb and the resultant inadvertent entry into a stall/mush condition. High density altitude and downdraft conditions were factors in the accident.Jun 18, 1994 · N4553R · Substantial damageNTSB BFO94LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250B · Kent, OHThe pilot's failure to maintain directional control.Jun 17, 1994 · N5257Y · Substantial damageNTSB MIA94LA159Accident · 1 fatalLimited investigationFinal reportHruby Cayuse · Bay St. Louis, MSThe pilot-in-command's attempt to continue the takeoff when the engine was not producing full power and his attempt to reverse course to return to the airport without sufficient altitude to complete the turn.Jun 12, 1994 · N12057 · DestroyedNTSB LAX94LA249Accident · Minor injuriesLimited investigationFinal reportPrue Irving Owen 160 · Jean, NVThe pilot's failure to properly connect the aileron control linkage during assembly, and his inadequate preflight which did not detect the problem before flight.Jun 11, 1994 · N90614 · DestroyedNTSB LAX94LA248Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Wickenburg, AZthe pilot's failure to remove the control lock prior to flight.Jun 11, 1994 · N4764U · Substantial damageNTSB LAX94LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dateland, AZThe pilot's inadequate preflight planning and his failure to maintain an adequate visual lookout for obstacles. Night lighting conditions and the dust were factors in the accident.Jun 9, 1994 · N3629P · DestroyedNTSB LAX94LA245Accident · No injuriesLimited investigationFinal reportCessna 180J · Sedona, AZa loss of directional control due to a locked brake from a leaking hydraulic system.Jun 9, 1994 · N180DK · Substantial damageNTSB SEA94LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Angela, MTDirectional control was not maintained. Factors to the accident were: wet terrain and inadequate aircraft preflight.Jun 4, 1994 · N2535J · Substantial damageNTSB LAX94LA238Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Valencia, CAthe pilot's selection of an unsuitable field for an off-airport landing and attempted takeoff.Jun 4, 1994 · N734ZK · Substantial damageNTSB ATL94LA112Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Summerdale, ALThe pilot's failure to maintain airspeed during takeoff.Jun 2, 1994 · N53819 · Substantial damageNTSB ANC94LA059Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's failure to maintain directional control during takeoff.May 29, 1994 · N93769 · Substantial damageNTSB NYC94LA095Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Warrenton, VAthe pilot did not maintain directional control of the airplane during an aborted takeoff, which resulted in the airplane veering off the runway and nosing over. A factor in this accident was the pilot's lack of experience on grass strips in this make and…May 28, 1994 · N3200H · Substantial damageNTSB CHI94LA178Accident · 1 fatalLimited investigationFinal reportCessna 150L · Richmond, INInadequate visual lookout by the pilots of both airplanes.May 28, 1994 · N153KA · 2 aircraft · DestroyedNTSB LAX94LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Los Banos, CAthe student pilot's inadequate compensation for the existing crosswind conditions and his resultant loss of directional control. A factor in the accident was the student's lack of total flight experience.May 25, 1994 · N93069 · Substantial damageNTSB CHI94LA175Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Toulon, ILthe improper reassembly of the main rotor blade dampers and the underservicing of the landing gear skid hydraulic struts which resulted in ground resonance of the helicopter when the first takeoff after reassembly was attempted.May 25, 1994 · N9375S · DestroyedNTSB NYC94LA092Accident · No injuriesLimited investigationFinal reportCessna 172N · Fredericksburg, VAThe pilot's premature lift-off, resulting in an inadvertent stall/mush back onto the runway, and the pilot's failure to maintain directional control during the aborted takeoff, which resulted in the airplane veering off the runway and colliding with a dirt…May 24, 1994 · N737SE · Substantial damageNTSB CHI94LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Harlan, IAthe delayed remedial action by the flight instructor. A factor related to the accident was the wet runway surface.May 23, 1994 · N80812 · Substantial damageNTSB ANC94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pilot Point, AKThe Pilot's failure to maintain control of the airplane during takeoff.May 23, 1994 · N99PJ · Substantial damageNTSB FTW94LA171Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pottsboro, TXThe pilot's failure to determine, prior to landing at the airport, that the runway length would be inadequate for a safe takeoff, and his subsequent failure to follow the manufacturer's recommended short-field takeoff procedures. Factors in the accident were:…May 22, 1994 · N9687W · Substantial damageNTSB CHI94LA169Accident · No injuriesLimited investigationFinal reportCessna 150K · Jasonville, INthe loss of engine power due to fuel exhaustion as a result of an inadequate aircraft preflight inspection.May 22, 1994 · N6039G · Substantial damage