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 ANC93LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Kasigluk, AKThe pilot's improper planning/decision and delay in aborting the takeoff. Factors related to the accident were: loose gravel on the surface of the runway and the snowbank (berm) on the overrun (stopway).Apr 12, 1993 · N13147 · Substantial damageNTSB LAX93LA171Accident · Minor injuriesLimited investigationFinal reportMong SPORT-S · Fallbrook, CAFailure of the pilot to visually clear the runway before starting the takeoff ground run. Factors in the accident were inadequate airspeed at the time of liftoff which resulted in an aerodynamic stall.Apr 10, 1993 · N36JD · Substantial damageNTSB FTW93LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind.Apr 10, 1993 · N5283P · Substantial damageNTSB FTW93LA119Accident · No injuriesLimited investigationFinal reportVaughan Mustang II · Las Cruces, NMThe aircrafts takeoff performance exceeded and pilot's failure to maintain directional control. A factor was the windApr 8, 1993 · N20JV · Substantial damageNTSB NYC93LA070Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Norridgewock, METhe pilot at the controls failed to maintain directional control of the airplane, and the flight instructor provided inadequate supervision. A related factor was the pilot at the controls had no flight experience in the make and model of airplane being flown.Apr 6, 1993 · N8775K · Substantial damageNTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.Apr 6, 1993 · N89098 · Substantial damageNTSB LAX93LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Diego, CAThe failure of the wing flap control due to the improper type of fuse installed by unidentified persons. Factors relating to this accident were the flap motor partial failure due to corrosion and the total failure of the fuse due to the wrong type amperage.Apr 3, 1993 · N50287 · DestroyedNTSB CHI93LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Lyons, WIThe pilot's use of an unsuitable runway.Mar 29, 1993 · N7058P · Substantial damageNTSB CHI93LA121Accident · No injuriesLimited investigationFinal reportManville Avid Flyer · Lincoln, MOThe pilot's failure to maintain control of the airplane, and his operation of an airplane with known defects.Mar 28, 1993 · N714J · Substantial damageNTSB BFO93LA053Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJThe flight instructor's failure to successfully take remedial action to maintain control of the airplane during takeoff. A factor related to the accident was the student pilot's improper control of the airplane during liftoff, while practicing a soft field…Mar 20, 1993 · N714XH · Substantial damageNTSB SEA93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Hailey, IDThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the snowbank.Mar 19, 1993 · N24WW · Substantial damageNTSB MIA93LA087Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa-Locka, FLFailure of the pilot-in-command to perform weight and balance calculations, exceeding the gross weight of the airplane, and disregarding wind information provided by the tower controller.Mar 19, 1993 · N6383X · Substantial damageNTSB FTW93LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Overbrook, OKThe pilot's failure to assure that the elevator trim was properly set for takeoff and his delay in aborting the takeoffMar 15, 1993 · N9689H · Substantial damageNTSB SEA93LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Logan-Cache, UTThe pilot's failure to maintain directional control, and insufficient remedial action. Factors include a snow bank near the edge of the runway.Mar 13, 1993 · N13008 · Substantial damageNTSB CHI93FA109Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Saint Louis, MOThe captain's improper use of thrust reversers and excessive use of engine power. Factors which contributed to the accident were: the crosswind and the first officer's failure to raise the flaps.Mar 12, 1993 · N978Z · Substantial damageNTSB MIA93IA083Incident · No injuriesIncident investigationFinal reportAero Commander 500 · Everglades City, FLThe preexisting fatigue cracking of the propeller hub arm in the bearing retention radius due to polishing and wear of the radius from contact with the split rings, resulting in a propeller blade separating from the propeller hub on the takeoff ground run,…Mar 7, 1993 · N3836C · Minor damageNTSB LAX93FA141Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Big Bear City, CAA partial loss of takeoff power due to inadequate maintenance and inspection which failed to detect magneto and spark plug deficiencies. In addition, the pilot failed to abort the takeoff after two unsuccessful attempts to get airborne. Factors which…Mar 7, 1993 · N2221G · DestroyedNTSB CHI93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIThe student pilot's failure to maintain directional control during the takeoff roll.Mar 7, 1993 · N67475 · Substantial damageNTSB BFO93LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Putnam, CTInadequate compliance with applicable air worthiness directives, leaky fuel cap seal, water contamination of the fuel, and wrinkles in the fuel tank bladders that interfered with the ability to drain water from the tanks.Mar 7, 1993 · N3035F · Substantial damageNTSB ATL93FA059Accident · 3 fatalField investigationFinal reportCessna 172G · Jackson, GAThe pilots inadequate preflight planning and his failure to properly compensate for the wind. A factor was the unfavorable wind condition at the time of take off.Mar 7, 1993 · N5972R · Substantial damageNTSB SEA93LA074Accident · No injuriesLimited investigationFinal reportCessna 150L · Provo, UTDirectional control was not maintained.Mar 6, 1993 · N150KC · Substantial damageNTSB SEA93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Riverton, WYThe pilot did not perform an abort of the takeoff after observing a partial loss of power. Factors include improper use of the mixture control.Mar 3, 1993 · N821SC · DestroyedNTSB BFO93LA043Accident · No injuriesLimited investigationFinal reportCessna 150 · Knoxville, PAThe pilot's failure to maintain directional control. Contributing to the accident was the pilot's failure to plow the runway adequately.Feb 27, 1993 · N8958S · Substantial damageNTSB ANC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Egegik, AKThat the lift off airspeed was not attained by the pilot in command because of the snow covered runway.Feb 27, 1993 · N8257A · Substantial damageNTSB CHI93LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, WIThe student pilot's failure to maintain aircraft directional control during the takeoff ground run.Feb 25, 1993 · N3044N · Substantial damageNTSB LAX93LA136Accident · No injuriesLimited investigationFinal reportCessna T188C · Delhi, CAThe pilot selected unsuitable terrain for takeoff and failed to maintain directional control of the aircraft. A factor in the accident was the standing water on the runway.Feb 24, 1993 · N2086J · Substantial damageNTSB ANC93LA035Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Bradley Lake, AKThe pilot in command not removing the frost from the plane's airfoil surfaces before takeoff and not aborting the takeoff when the airplane showed no sign of wanting to fly at the initial rotation point/airspeed. A factor in the accident was the icing…Feb 20, 1993 · N5036U · DestroyedNTSB BFO93LA027Accident · No injuriesLimited investigationFinal reportCessna 210K · Sunbury, OHThe pilot's failure to maintain directional control during the takeoff roll. The soft terrain was a related factor.Feb 15, 1993 · N8110G · Substantial damageNTSB LAX93LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Chowchilla, CAThat the pilot failed to maintain directional control. The pilot's failure to use the tailwheel lock and the soft and wet terrain were factors relating to this accident.Feb 12, 1993 · N10212 · Substantial damageNTSB ANC93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run.Feb 5, 1993 · N4882P · Substantial damageNTSB ANC93LA030Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot's failure to maintain control of the airplane during the takeoff run. Factors were the unfavorable winds and rough water.Feb 4, 1993 · CFZEX · Substantial damageNTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.Feb 2, 1993 · N6402M · Substantial damageNTSB NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…Jan 30, 1993 · N5725G · Substantial damageNTSB NYC93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Dover, VTThe pilot's failure to maintain directional control during takeoff, and his inadequate remedial actions, resulting in a collision with a snowbank. Factors related to the accident were the ice covered runway and the snowbank along the runway edges.Jan 29, 1993 · N40586 · Substantial damageNTSB FTW93LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Baytown, TXThe loss of power due to a stuck exhaust valve in the number 3 cylinderJan 23, 1993 · N73405 · Substantial damageNTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.Jan 17, 1993 · N24908 · Substantial damageNTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.Jan 17, 1993 · N48863 · Substantial damageNTSB LAX93FA095Accident · 2 fatalField investigationFinal reportCessna 414 · Reno, NVThe failure of the pilot to use pitot static system covers during icing conditions which resulted in a blocked pitot tube and subsequent loss of airspeed indications. This led to pilot disorientation and an invertant stall. Factors to the accident were…Jan 15, 1993 · N4733G · DestroyedNTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsJan 12, 1993 · N734GD · Substantial damageNTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.Jan 9, 1993 · N433AW · Minor damageNTSB BFO93LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Philipsburg, PAThe inadequate removal of snow from the runways by airport personnel and the procedures/directives for airport snow removal not understood.Jan 2, 1993 · N15141 · Substantial damageNTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.Jan 1, 1993 · N4292N · Substantial damageNTSB ATL93LA042Accident · No injuriesLimited investigationFinal reportPitts S2B · Tuscaloosa, ALThe failure of the pilot to maintain directional control of the aircraft, during the take off roll. A factor was the wind gust.Dec 26, 1992 · N92AP · Substantial damageNTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.Dec 19, 1992 · N1848A · Substantial damageNTSB SEA93FA040Accident · Serious injuriesField investigationFinal reportDassault-Breguet Falcon 10 · Mccall, IDThe failure of the flight crew to follow the checklist and release the parking brake before takeoff. The inoperative parking brake warning light and the failure of the pilot to abort the takeoff were factors.Dec 18, 1992 · N50TE · Substantial damageNTSB NYC93LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Alberta, VAThe pilot attempted to take off on rough uneven terrain and could not attain rotation speed, which resulted in the airplane striking a tree during the ground run. A factor in this accident was inadequate pre flight planning.Dec 6, 1992 · N58ND · Substantial damageNTSB NYC93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · Jaffrey, NHAn improper weld by other maintenance personnel which resulted in the nose gear collapsing, and a loss of directional control on takeoff.Dec 6, 1992 · N3017P · Substantial damageNTSB ATL93LA032Accident · No injuriesLimited investigationFinal reportVan Arsdell/Brent,M. Rutan Long EZ · Charleston, SCThe pilot's inadequate pre-flight planning and his failure to note the raised arresting device near the runway threshold.Nov 29, 1992 · N989LE · Substantial damageNTSB SEA93LA028Accident · No injuriesLimited investigationFinal reportCessna A152 · Tremonton, UTDelayed remedial action. Factors include a tailwind.Nov 21, 1992 · N46762 · Substantial damageNTSB DEN93LA013Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Broomfield, COA failure by FBO personnel to properly connect the nose wheel torque link after towing the aircraft.Nov 21, 1992 · N473FW · Substantial damage