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 CHI82DA077Accident · No injuriesFinal reportSmith Aerostar 600 · Elyria, OHDuring takeoff on an icy runway, the pilot lost directional control after rolling a few hundred feet. He reported that the plane was sliding left and was below VMC, so he retarded the throttles. The plane struck a snowbank beside the runway and was…Mar 4, 1982 · N9530Q · Substantial damageNTSB LAX82DA090Accident · No injuriesFinal reportSchweizer SGS1-260 · Phoenix, AZDuring the takeoff roll the glider's right wing collided with the left tire of a parked aircraft. The pilot stated that the accident could have been prevented by pulling the glider out farther.Mar 1, 1982 · N7740S · Substantial damageNTSB NYC82DA030Accident · No injuriesFinal reportPiper PA-38-112 · Easton, PAA takeoff was initiated on runway 17 with the wind from the southwest at 15 knots. During the takeoff roll, control of the aircraft was lost when a gust of wind was encountered. The plane struck a snowbank beside the runway and was substantially damaged.Feb 27, 1982 · N9344T · Substantial damageNTSB CHI82DA076Accident · Serious injuriesFinal reportBarnes FIREFLY-7 · Cincinnati, OHPilot stated that after a normal inflation, before the balloon was hot enough to sustain flight, a gust of wind blew it into a school building. After striking the building, the balloon was dragged through a line of trees.Feb 27, 1982 · N1522W · Substantial damageNTSB CHI82DA073Accident · No injuriesFinal reportCessna 150 · Manchester, MIDuring takeoff the student pilot lost directional control and struck a snowbank. The student stated at 40-50 knots the left wheel bogged down in snow or encountered a rut and the aircraft twisted sharply left.Feb 26, 1982 · N9101U · Substantial damageNTSB SEA82FYM10Accident · No injuriesFinal reportWeatherly 201C · Wasco, ORThe pilot reported that during takeoff, the engine did not maintain full power. While landing in a residential area, the aircraft struck a telephone wire and three trees. An examination of the engine revealed no obvious defects that would cause a loss of…Feb 24, 1982 · N9243W · Substantial damageNTSB CHI82DA070Accident · No injuriesFinal reportCessna 152II · Oxford, OHAfter a normal landing the pilot retracted the flaps and opened the throttle. As the aircraft gained speed it started drifting off the runway. The pilot attempted to correct with rudder but the aircraft veered off the runway. Power was reduced before the nose…Feb 23, 1982 · N68298 · Substantial damageNTSB CHI82DA068Accident · No injuriesFinal reportPiper PA-60 · Cleveland, OHDuring takeoff roll from a dry runway the pilot reported the aircraft started veering to the left. The pilot attempted to straighten the aircraft with power & brakes to no avail then pushed in throttle in an attempt to fly out. The aircraft departed the…Feb 23, 1982 · N8035J · Substantial damageNTSB MKC82DA038Accident · No injuriesFinal reportGrumman AA-5A · Monona, IAThe pilot taxied to the south end of the runway to depart with three passengers. He began a soft field takeoff roll on a soft, wet runway with 10 degrees of flaps. The nose wheel was lifted off early. It was held off as the plane accelerated. The pilot…Feb 21, 1982 · N9958U · Substantial damageNTSB MKC82DA035Accident · No injuriesFinal reportCessna 152 · Tipton, IAThe student pilot said that he was on the takeoff roll when the aircraft veered left and collided with a snowbank beside the runway. He reported that the runway was clear and dry, and the wind was not a factor.Feb 21, 1982 · N64998 · Substantial damageNTSB CHI82DA066Accident · No injuriesFinal reportCessna 152 · Plainfield, ILThe student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the…Feb 21, 1982 · N6112Q · Substantial damageNTSB CHI82DA062Accident · No injuriesFinal reportBeech 56TC · Huntington, INDuring a night touch and go landing, the aircraft veered left and struck a snowberm as the pilot was adding power to takeoff. Snowberms were located inside of the runway lights making the usable runway less than 75 ft and possibly restricting the lighting.…Feb 21, 1982 · N291T · Substantial damageNTSB FTW82DA065Accident · No injuriesFinal reportCessna 150M · Lubbock, TXAfter electing to abort takeoff the pilot realized he had insufficient room to stop on the remaining runway. He reapplied power to attempt to fly over a road but reported that the engine lost power. The aircraft bounced over a road into a plowed field and…Feb 20, 1982 · N9320U · Substantial damageNTSB SEA82IA029Incident · No injuriesIncident investigationFinal reportEmbraer EMB-11OP1 · Boise, IDThis aircraft, which was departing on a scheduled flight to lewiston, ID., was just accelerated to rotation speed when the crew heard one of the passengers scream. The takeoff WA successfuly aborted and the aircraft was returned to the gate. Investigation…Feb 18, 1982 · N101RA · Minor damageNTSB MIA82FA051Accident · Serious injuriesField investigationFinal reportBoeing 727-235 · Miami, FLDuring takeoff roll a loud bang was heard & the takeoff aborted. The tower advised the flt of extensive fire in the tailarea. The plt cleared the active rwy & the acft was evacuated. 1 pax suffered a fractured ankle & another a sprained ankle. An explosion…Feb 17, 1982 · N4734 · Substantial damageNTSB MKC82DA032Accident · No injuriesFinal reportCessna 152 · Chesterfield, MOThe student pilot was making a touch and go landing. He failed to keep the aircraft on the runway during the takeoff. The plane departed the runway to the left and ran up onto a snowbank. The right side of the aircraft tipped down. The propeller and right…Feb 15, 1982 · N24311 · Substantial damageNTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…Feb 15, 1982 · N56979 · Substantial damageNTSB MIA82DA057Accident · No injuriesFinal reportPiper PA-28-140 · Miami, FLTakeoff was made on a north/south roadway with the surface winds reported out of the east at 18 knots. The aircraft veered off the road and collided with a tree.Feb 14, 1982 · N98367 · Substantial damageNTSB MIA82DA046Accident · No injuriesFinal reportHoward 500 · Ft. Lauderdale, FLThe pilot stated that partial power failure of the left engine combined with torque and a crosswind caused a loss of directional control approximately 100 yards into the takeoff roll.Feb 12, 1982 · N1515V · Substantial damageNTSB LAX82DA066Accident · No injuriesFinal reportCessna 310R · Carlsbad, CADuring the takeoff roll, the pilot noticed that the passenger door was not closed. He tried unsuccessfully to close the door, then elected to abort the takeoff. The pilot was unable to stop on the remaining runway. The aircraft continued off the end and went…Feb 9, 1982 · N69DH · Substantial damageNTSB ATL82DA048Accident · No injuriesFinal reportBeech C-23 · Nashville, TNThe accident occurred while the pilot was making a touch and go landing on his second supervised solo flight. After touchdown on his first landing, the pilot inadvertently pulled back on the control yoke while adding power and raising the flaps. The nose…Feb 8, 1982 · N60427 · Substantial damageNTSB MKC82DA028Accident · No injuriesFinal reportPiper PA-38 · Washington, IAThe student pilot began taking off on runway 17 with a right quartering headwind. There was snow and ice on the runway. During the takeoff roll, the aircraft started toward the left and the pilot added right rudder for directional control. The aircraft…Feb 7, 1982 · N2501N · Substantial damageNTSB CHI82DA039Accident · No injuriesFinal reportPiper PA-28-181 · East Lansing, MIThe pilot initiated his takeoff on a snow covered, sod runway that had been plowed with a 50 ft wide strip. The plowed area had a snow base and there were four foot snow banks at the edges. Although the runway had been plowed on the previous night and it had…Feb 6, 1982 · N7644F · Substantial damageNTSB DCA82AA014Accident · Serious injuriesFinal reportMcdonnell-Douglas DC-10-10 · Philadelphia, PAThe aircrews of a united DC-10 (flt 99 heavy) and two U.S. Air DC-9'S (flt 25 and flt 199) taxied for takeoff at about the same time. Due to delays, the no. 2 engine of flt 199 was shut down in accordance with applicable fuel conservation procedures. After…Feb 3, 1982 · N1814U · Minor damageNTSB LAX82FVD09Accident · No injuriesFinal reportBellanca 7ECA · Sonoma, CAControl was lost during takeoff when, according to the pilot's statement, a sudden extreme wind gust caused the aircraftto change its heading. The aircraft contacted water at the side of the runway and came to rest nose down. Winds were reportedly gusting to…Feb 1, 1982 · N5067C · Substantial damageNTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…Jan 31, 1982 · N89963 · Substantial damageNTSB DEN82DA027Accident · No injuriesFinal reportPiper PA-22 · Trinidad, COThe pilot reported that the aircraft started to veer left as the tail came up during the takeoff roll. He corrected with rudder, but did not maintain directional control. As a ground loop developed, he noted there was insufficient airspeed to lift off and…Jan 31, 1982 · N3921P · Substantial damageNTSB LAX82FVA11Accident · 1 fatalFinal reportCessna TR182 · Oakdale, CAThe aircraft was observed to porpoise several times during the takeoff roll, become airborne with the landing gear immediately retracting, then nose down with the propeller striking, the runway. The pilot continued the takeoff and the aircraft climbed to…Jan 30, 1982 · N5173R · Substantial damageNTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…Jan 28, 1982 · N4604N · Substantial damageNTSB FTW82DA048Accident · No injuriesFinal reportCessna A185F · S. Of Morgan Ci, LAThe pilot was making a westbound takeoff from a canal with a 15 knot south crosswind when his boot and pant leg became entangled in the aircraft's water rudder lever. This caused the pilot to lose control and the aircraft drifted to the right into a moored…Jan 28, 1982 · N6265E · Substantial damageNTSB DEN82DA023Accident · No injuriesFinal reportBellanca 7GCBC · Havre, MTWhile taking off to help gather cattle, the right axle failed as the left wing was picked up by gusty winds. The plane spun around 180 degrees and flipped over. The pilot reported that the axles were not heavy enough for consistent rough field use.Jan 26, 1982 · N88202 · Substantial damageNTSB CHI82DA029Accident · No injuriesFinal reportMooney M-20 · Shell Lake, WIThe pilot initiated his takeoff roll on a runway covered with hard packed snow. As the nosewheel was lifted off of the runway, the aircraft started to drift left. The pilot stated that when he applied right rudder and slightly lowered the nose, the plane came…Jan 22, 1982 · N6029Q · Substantial damageNTSB MIA82FA037Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · 15nm W. Opa Loc, FLDuring a touch & go the dual student added power rapidly & the left eng sputtered causing the acft to swerve left. The instructor took control but felt resistance on the controls from the student. He then reduced power on both engs & then reapplied power at…Jan 21, 1982 · N211TA · DestroyedNTSB LAX82DA046Accident · No injuriesFinal reportAir Tractor 301 · Dos Palos, CADuring the takeoff roll the pilot decided that he was not going to clear an 8 foot chain-link fence at the end of the runway. He stated that he pulled the dump-gate, chopped the throttle, and put on the brake but the aircraft went into soft dirt and the right…Jan 21, 1982 · N8793S · Substantial damageNTSB CHI82DA028Accident · No injuriesFinal reportPiper PA-38-112 · Grand Rapids, MIThe pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was…Jan 19, 1982 · N26093 · Substantial damageNTSB ANC82DA019Accident · No injuriesFinal reportPiper PA-32 · Tuntutuliak, AKDuring takeoff on a runway covered with 7 to 8 inches of snow,the aircraft pulled to the right. The pilot reduced engine power,but was unable to maintain directional control. The aircraft veered off the side of the runway. Pilot reported snow removal…Jan 19, 1982 · N4246T · Substantial damageNTSB FTW82DA045Accident · No injuriesFinal reportCessna 180K · S.E. Of Houma, LAThe pilot elected to takeoff from a canal with a quartering tailwind due to approaching fog. The aircraft drifted left and its wing struck a piling.Jan 18, 1982 · N2705K · Substantial damageNTSB FTW82DA040Accident · No injuriesFinal reportBeech A23-24 · Hobbs, NMThe pilot attempted to takeoff on a runway with icy patches, lost control and slid off the side into a snowbank. The pilot did not possess any type of pilots certificate due to the fact that he could not pass a medical examination.Jan 14, 1982 · N2396W · Substantial damageNTSB DEN82FTE16Accident · No injuriesFinal reportCessna 180 · Saquache, CODuring a round-robin VFR flight the pilot landed at cochetopa strip and shut down for 1 hour. The pilot stated that at the time of takeoff the wind velocity had increased to 20-25 knots with almost a direct crosswind. During takeoff the aircraft drifted left…Jan 11, 1982 · N2332C · Substantial damageNTSB LAX82FUG05Accident · No injuriesFinal reportQuickie 1 · Upland, CAThe pilot took off on an upward sloping runway towards rising terrain. The pilot stated that he was unable to maintain enough speed to clear obstacles with the 22 horsepower engine. He elected to land on a residential street. While maneuvering around a street…Jan 10, 1982 · N234Q · Substantial damageNTSB CHI82DA023Accident · No injuriesFinal reportCessna 152 · Peoria, ILReportedly, the student tookoff without his instructor's appproval. He initiated a takeoff roll on runway 35 with the wind from 230 degrees at 11 knots. He stated that the wind shifted and caught him from behind as he was about to lift off. Directional…Jan 8, 1982 · N6265P · Substantial damageNTSB DEN82DTI09Accident · No injuriesFinal reportAir Tractor AT-301 · Greenough, MTDuring takeoff the aircraft struck a snow berm. The aircraft received substantial damage to both wings and prop. The aircraft had been landed on a county road about a week earlier due to deteriorating weather.Jan 3, 1982 · N23069 · Substantial damageNTSB CHI82FEC08Accident · No injuriesFinal reportCessna 152 · Ypsilanti, MIDuring takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right…Jan 2, 1982 · N68812 · Substantial damageNTSB SEA82DA022Accident · No injuriesFinal reportCessna 140 · Pullman, WAThe pilot started to takeoff on a snow covered runway in calm wind conditions. He reported that about 3 inches of snow had fallen since the runway had been cleared. In his judgement, the aircraft did not accelerate fast enough to assure a safe takeoff, so he…Jan 1, 1982 · N2482N · Substantial damageNTSB NYC82FGT07Accident · No injuriesClosedAeronca 7AC · Wellsboro, PADec 31, 1981 · N83073 · Substantial damageNTSB NYC82DA013Accident · No injuriesClosedAeronca 7AC · Wellsboro, PADec 31, 1981 · N83073 · Substantial damageNTSB MKC82DA015Accident · No injuriesClosedSwearingen SA227 · Lincoln, NEDec 24, 1981 · N807M · Substantial damageNTSB MKC82FCG14Accident · No injuriesClosedCessna 421C · Olathe, KSDec 22, 1981 · N990MB · Substantial damageNTSB DEN81DTK03Accident · No injuriesClosedCessna 172 · Timber Lake, SDDec 21, 1981 · N8831Z · Substantial damageNTSB MKC82DCG13Accident · Minor injuriesClosedPiper PA-28 · St.Joseph, MODec 19, 1981 · N33574 · Substantial damage