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 CHI82DA274Accident · No injuriesFinal reportCessna 188B · Loami, ILThe pilot was taking off on the first flight of the day with a reported load of 1080 lbs of wheat seed. During the takeoff, there was a direct crosswind of 6 KTS and the temperature and dew point were 78 and 68 deg, respectively. After using about 3/4 of the…Jul 24, 1982 · N4970Q · DestroyedNTSB FTW82DA293Accident · No injuriesFinal reportCessna A188B · Texline, TXThe pilot started to takeoff with a 145 gal spray load. Reportedly, the main gear dug into the surface of a plowed field during the takeoff roll and collapsed.Jul 23, 1982 · N53309 · Substantial damageNTSB MKC82DA129Accident · No injuriesFinal reportTexas Helicopter OH-13E · 10 Sw Of Milan, MOThe plt had reduced the spray load from 90 to 50 gals to compensate for the increase in density altitude. The winds were blowing lightly during previous takeoffs but were calm during this takeoff. As the helicopter hovered forward during the takeoff it failed…Jul 20, 1982 · N38117 · Substantial damageNTSB FTW82DA287Accident · No injuriesFinal reportGrumman G-164B · Humnoke, ARThe pilot reported that during takeoff, the left main gear got off the side of the rough airstrip and into a rice field. Subsequently, the plane flipped over.Jul 20, 1982 · N6689K · Substantial damageNTSB SEA82DA118Accident · No injuriesFinal reportCessna 182C · Near Dixie, IDThe pilot was taking off from a wet, sod airstrip when he elected to abort at about the midway point of the runway. While aborting, the aircraft hit a soft spot in the runway which sheared off the nose gear. Aircraft continued off end of runway and burned.Jul 19, 1982 · N8548T · DestroyedNTSB FTW82DA284Accident · No injuriesFinal reportBeech 95-A55 · Jonestown, TXThe pilot stated that during the takeoff roll, he encountered a strong pull to the right. The aircraft departed the right side of the runway, went down an eight foot embankment, and was substantially damaged. After the accident, the wheels rolled freely and…Jul 18, 1982 · N34RS · Substantial damageNTSB ATL82DA201Accident · No injuriesFinal reportCessna 182E · Taplin, WVThe pilot stated that the sod runway had just been mowed. During the takeoff roll, the left wheel pant became filled with cut grass and locked the wheel. Subsequently, the aircraft veered to the left. The pilot reported that the left wing contacted low trees…Jul 17, 1982 · N9245X · Substantial damageNTSB SEA82DA121Accident · No injuriesFinal reportLake LA-4 · Newport, ORThe pilot reported that during takeoff, he had accelerated to about 40 mph, and was on the step, when he hit a wave of sufficient size to bounce and become momentarily airborne. He was still accelerating and bounced a second time when it became apparent that…Jul 16, 1982 · N1216L · Substantial damageNTSB LAX82FA255Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B · Schellville, CAAt approximately 800 ft down the left side of the rwy the left eng experienced a power loss. The acft swerved off the left side of the rwy colliding with a drainage ditch & coming to rest inverted. Examination of the fuel control unit revealed that the…Jul 14, 1982 · N27GP · DestroyedNTSB MKC82DA123Accident · No injuriesFinal reportPiper PA-28-140 · Conway Springs, KSThe pilot reported that the wind was from the southwest at 3 KTS, but 16 miles away at wichita, KS, it was from 310 degrees at 9 KTS. He selected runway 17, a sod, 2140 ft, private strip. He said that during the takeoff roll, the aircraft became light on the…Jul 11, 1982 · N555KC · Substantial damageNTSB MKC82FCJ04Accident · 1 fatalFinal reportPiper PA-36 · North Platte, NEThe aircraft ran off the departure end of the runway during takeoff on a planned agricultural flight. After departing the runway, it continued for a distance through uncut wheat until it contacted a shallow washout and small bank, then flipped over. There…Jul 9, 1982 · N57738 · Substantial damageNTSB ANC82DA058Accident · No injuriesFinal reportCessna 310 · Elim, AKAccording to the plt, he was at VMC when he saw the right eng fuel flow needle split away from the left fuel flow needle & the acft started to swerve right. The takeoff was aborted & the acft ran off the end of the rwy. The rwy was heavily rutted & acft had…Jul 9, 1982 · N7745Q · Substantial damageNTSB LAX82FVG28Accident · 1 fatalFinal reportMiller Tufts T-3-160 · Placerville, CAThe home built acft was of the plt's own design. It was a 4 place, low wing acft with a large canopy & smaller vert tail surfaces and was equipped with flaps, folding wings & fixed tail whl gear. The plt/designer was trying a new concept of lateral control by…Jul 6, 1982 · N1051K · DestroyedNTSB SEA82IA101Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Boise, IDAfter a gate delay to load late passengers, the flight was cleared for takeoff on runway 28L. About 4 seconds after rotation speed was called, the stickshaker activated and the takeoff was aborted. A readout of the CVR indicated that the thrust reversers were…Jul 5, 1982 · N919RW · Minor damageNTSB DEN82DA126Accident · No injuriesFinal reportAerospatiale SA 315B · Big Piney, WYThe pilot stated that he felt a shudder while he was taking off with a long line attached. He began a descent, and when the helicopter was about 5 ft above the ground, the long line caught a tree. Subsequently, the helicopter pitched nose down and the rotor…Jul 2, 1982 · N49532 · Substantial damageNTSB ANC82DA057Accident · No injuriesFinal reportBritten-Norman BN-2A · Nome, AKDuring the takeoff roll, a propeller blade tip failure occurred on the left engine. About 9 inches of the blade tip separated and entered the top side of the fuselage about 1 ft behind the pilot's head. The blade tip severed the throttle, fuel mixture,…Jul 2, 1982 · N39MN · Substantial damageNTSB CHI82DA229Accident · Minor injuriesFinal reportClancy Skybaby · Grand Haven, MIDuring the pilots fourth takeoff roll of the day the right wing began to drop and the aircraft drifted off the runway. Power was reduced and brakes applied but the aircraft overturned after encountering a soft sodded area. After the accident it was noted that…Jul 1, 1982 · N211SB · Substantial damageNTSB ATL82DA178Accident · No injuriesFinal reportBellanca 7ECA · Ft. Meade, MDThe pilot reported that the carburetor heat operated during an engine run-up before takeoff, and that he used the carburetor heat during each landing. During a touch-and-go, he lifted off at 65 KTS, but the plane settled and would not climb out of ground…Jun 25, 1982 · N4214Y · Substantial damageNTSB DEN82DA114Accident · No injuriesFinal reportSchweizer SGS 1-34 · Colorado Spring, CODuring the takeoff roll, the canopy of the glider came open while the glider was being towed. The pilot attempted to close the canopy, and in doing so, the glider became airborne, then contacted the runway in a nose low attitude. Subsequently, the glider…Jun 24, 1982 · N7642 · Substantial damageNTSB DEN82FTC06Accident · Serious injuriesFinal reportBellance 7GCBC · Pinedale, WYDuring a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over.Jun 23, 1982 · N57508 · DestroyedNTSB LAX82FUM07Accident · No injuriesFinal reportPiper PA-36-285 · Imperial, CAThe pilot was unable to maintain airspeed and altitude after taking off from a wet and muddy runway. He closed the throttle and landed in a cotton field, but was unable to stop the aircraft before hitting a ditch. Reportedly, the previous (first) takeoff…Jun 22, 1982 · N9979P · Substantial damageNTSB DEN82DA105Accident · No injuriesFinal reportPiper PA-20 · Near Rawlins, WYThe pilot stated that he had landed on a blacktop road, but opted to takeoff on a gravel road because of the proximity of reflector posts to the wings. He stepped off the road and estimated that he had about 800 ft for takeoff. The density altitude was about…Jun 19, 1982 · N3411A · Substantial damageNTSB ATL82DA167Accident · Minor injuriesFinal reportPiper PA-28-161 · Atlanta, GAThe student pilot was practicing touch-and-go landings in winds that were variable 330 to 340 degrees at 10 knots. During the second touch-and-go, the aircraft touched down normally. However, as it was accelerating for takeoff, the plane suddenly swerved to…Jun 19, 1982 · N31883 · DestroyedNTSB NYC82DA127Accident · No injuriesFinal reportCessna 182H · Fort Fairfield, METhe pilot stated that the aircraft was slow to accelerate in loose gravel at the beginning of the takeoff roll. He reported that he rotated for takeoff before reaching his abort point about 1000 ft down the 2100 ft runway. He stated that the aircraft was not…Jun 18, 1982 · N8558S · Substantial damageNTSB DEN82DA109Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDThe student pilot was practicing takeoffs and landings on his third supervised solo flight with a left quartering wind at 10 KTS. Upon landing, the student began his takeoff roll. Subsequently, the aircraft veered off the runway, traveled about 600 ft, and…Jun 18, 1982 · N6145Q · Substantial damageNTSB FTW82DA231Accident · No injuriesFinal reportSouthern Airmotive Corp Sac SAC · Graham, TXThe pilot reported that he began a takeoff on runway 17 to ferry the aircraft from Graham to houston, TX. He reported that the wind was from 340 deg at 15 KTS. Reportedly, he had no previous flight time in this make and model of aircraft. The pilot stated…Jun 17, 1982 · N3800C · DestroyedNTSB FTW82DA226Accident · No injuriesFinal reportWeatherly 201C · Lakewood, ARThe right main gear of the aircraft failed during the takeoff roll. The pilot stated that the gear failed after he had rolled about 150 ft.Jun 14, 1982 · N9044W · Substantial damageNTSB SEA82FYM19Accident · Minor injuriesFinal reportChampion 7GCAA · Independence, ORThe pilot reported that during a full stall landing, the aircraft veered to the left at the moment of touchdown. Full power was applied for a go-around, but reportedly, the pilot was unable to turn the aircraft back to the right toward the runway. After…Jun 13, 1982 · N9528S · DestroyedNTSB CHI82DA205Accident · Minor injuriesFinal reportVolmer Sportsman · Pulaski, WIOn his first flight of the aircraft during this calendar year, the pilot aborted his takeoff. On the second attempt he started to abort but the engine surged and the aircraft became airborne. He stated that he continued to have a problem with the engine and…Jun 12, 1982 · N9011 · DestroyedNTSB LAX82DA212Accident · No injuriesFinal reportCessna 185 · Anza, CAThe student, a rated pilot, and his instructor landed on an unimproved private strip which was at an elevation of about 4750 ft MSL. After landing, the pilots walked through the airstrip and discussed the condition of the strip. There was tall grass on the…Jun 8, 1982 · N2205T · Substantial damageNTSB FTW82DPA13Accident · No injuriesFinal reportCessna 152 · Mckinney, TXThe student pilot practicing touch and go landings lost control of the aircraft and swerved off the runway. The aircraft then contacted a fence and nosed over.Jun 8, 1982 · N89551 · Substantial damageNTSB ANC82DAA04Accident · No injuriesFinal reportCessna 170 · Chicken, AKThe student pilot reported that he made a pleasure/personal flight to an old hunting strip. He reported that it was a rough, gravel strip that was located on sloping terrain. Reportedly after landing, he waited for a rain storm with heavy wind to pass before…Jun 8, 1982 · N4593C · Substantial damageNTSB DEN82DA102Accident · No injuriesFinal reportBellanca 8GCBC · Philip, SDThe pilot flew to an open field where he landed to work on a truck. While he was working on the truck, the wind increased to the point that he was afraid to leave the aircraft on the ground. When he got in the plane, the wind prevented him from turning and…Jun 6, 1982 · N86993 · Substantial damageNTSB ATL82IA154Incident · No injuriesIncident investigationFinal reportBeech 18 · Macon, GAAccording to the pilot, the flight was being conducted under ferry flight provisions. The flight was issued a takeoff clearance for runway 05,with reported surface winds of 320 degrees at 10 knots. The copilot started the takeoff roll and was unable to…Jun 6, 1982 · N171DC · Minor damageNTSB MKC82FA095Accident · No injuriesField investigationFinal reportBeech 65-90 · Wichita, KSThe plt detected a loss of eng torque at about rotation airspeed about 1700 ft down the rwy & the takeoff was aborted. The acft slid into a ditch off the end of the rwy collapsing the main gear. A functional check of the right eng fuel pump, P/N4V146R002,…Jun 4, 1982 · N190BT · Substantial damageNTSB ATL82FKQ13Accident · Serious injuriesFinal reportCessna 182P · Winona, MSThe pilot stated that after a takeoff run, the controls locked and he could not pull the aircraft off of the runway. Subsequently, the plane collided with a dirt bank beyond the end of the runway, became inverted, and slid backwards. An inspection of the…Jun 2, 1982 · N52562 · Substantial damageNTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…Jun 1, 1982 · N7525K · DestroyedNTSB SEA82DA079Accident · No injuriesFinal reportCessna 177 · Waldport, ORThe pilot elected to make a normal takeoff from a field of tall, wet grass. Acceleration was noted to be less than desired and the takeoff was aborted. The aircraft continued into a ditch in the overrun area.May 31, 1982 · N6777T · Substantial damageNTSB MIA82DA126Accident · No injuriesFinal reportPiper PA-38-112 · Ft. Pierce, FLAccording to the student pilot, the nose gear collapsed during the takeoff roll after he applied back pressure for a climb attitude at about 60 to 62 knots. He stated that the aircraft did not want to climb, and simultaneously, the nose dropped. An…May 31, 1982 · N9655T · Substantial damageNTSB NYC82FNA14Accident · 1 fatalFinal reportThurston Teal TSC-1A · Methuen, MAThe pilot was practicing takeoffs and landings on a river in an amphibian aircraft. After a landing, the pilot commenceda high speed taxi takeoff. When violent shaking started the pilot reduced power, pulled back the stick, and landed. The aircraft nosed…May 30, 1982 · N2002T · Substantial damageNTSB MIA82DA125Accident · No injuriesFinal reportBell 47J-2A · Marathon, FLThe pilot reported that an intermittent vibration was felt during the magneto check before takeoff. During a second magneto check at high power, the nose of the helicopter came up, a loud explosive noise was heard, and a fire erupted near the left fuel tank.…May 29, 1982 · N73268 · DestroyedNTSB MIA82FKT10Accident · Minor injuriesFinal reportCessna 172RG · Labelle, FLThe pilot and two passengers planned to depart on a flight to spot hogs for hunters. The aircraft was loaded with about 50 gallons of fuel and was near its maximum gross weight. Before takeoff, the pilot noted the wind. He reported that it was light and…May 27, 1982 · N5143V · DestroyedNTSB FTW82DA198Accident · No injuriesFinal reportBell 47D1 · Jonesboro, ARAfter loading 40 gallons of herbicide on the aircraft the pilot attempted to lift off the back of the loading truck. The takeoff was normal; however, as the helicopter cleared the truck, it was not able to sustain a hover. The pilot then executed a running…May 25, 1982 · N6851 · DestroyedNTSB ATL82DA141Accident · No injuriesFinal reportCessna 170A · Pettibois Islan, MSThe pilot stated that he landed safely on an island after noticing that the engine cowling started to work loose. He successfully repaired the problem but nosed over on the sandy surface during takeoff.May 23, 1982 · N9196A · Substantial damageNTSB MKC82DA086Accident · No injuriesFinal reportPiper PA-28-140 · Columbia, MODue to abnormal engine sounds the pilot elected to abort the takeoff. The aircraft could not be stopped on the remaining runway and rolled into a ditch. The pilot stated that during his preflight he was unable to remove all the water in the fuel by draining…May 20, 1982 · N6527W · Substantial damageNTSB ATL82FIJ03Accident · Serious injuriesFinal reportBell 206B · Gate City, VAThis was an external load operation to move seismographic oil exploration equipment. The pilot flew to the loading zone with a 150 ft cable and an aluminum bucket. After arriving, he lowered the bucket and hovered while the bucket was loaded. The pilot then…May 20, 1982 · N5002X · Substantial damageNTSB ATL82DA147Accident · No injuriesFinal reportPiper J3C-65 · Charlotte, NCThe pilot stated that during takeoff roll he turned and reached for a bag that had started to fall out the door. The right wing of the aircraft struck the ground causing the aircraft to turn sideways and collapse the gear.May 16, 1982 · N42102 · Substantial damageNTSB ATL82DA136Accident · Minor injuriesFinal reportCessna 150 · Buford, GAThe pilot used zero flaps and about 2/3RDS of the available runway in an attempt to practice a short field takeoff. During the takeoff roll the pilot was unable to obtain takeoff speed and elected to abort but was unable to stop the aircraft before it rolled…May 16, 1982 · N7588G · Substantial damageNTSB ANC82DAG25Accident · No injuriesFinal reportCessna 180C · Latouche Island, AKA takeoff was initiated from a dry gravel strip in calm wind conditions. The pilot reported that just prior to lift-off, the main landing gear rolled over a 2 x 12 inch board that flipped up and struck the right elevator. Reportedly, a part of the elevator…May 15, 1982 · N9366T · Substantial damageNTSB FTW82DA177Accident · No injuriesFinal reportGrumman G-164A · Elreno, OKDuring takeoff the pilot encountered standing water on the runway. The aircraft swerved left and nosed over.May 13, 1982 · N7843 · Destroyed