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 ANC82DAA16Accident · No injuriesFinal reportPiper 18 · Kotzebue, AKThe pilot attempted a takeoff from a rough dirt strip approximately 1000 feet in length. The wind was blowing from the east and the takeoff was to the southwest due to the downhill slope of the runway. The aircraft lifted off at an unknown airspeed…Sep 16, 1982 · N345BG · Substantial damageNTSB ATL82IA281Incident · No injuriesIncident investigationFinal reportPiper PA-34-22OT · Montgomery, ALThe pilot stated that a normal runup was completed before takeoff. During the takeoff roll, the aircraft accele- rated through 75 knots when a loud bang was heard from the left side. The takeoff was aborted and a rollout accomplished. Examination of the left…Sep 15, 1982 · N220HB · Minor damageNTSB DEN82AA191Accident · 6 fatalFinal reportMitsubishi MU-2B-25 · Hayden, COA maint supervisor & 2 plts noted that the l eng did not respond normally while being started. Aft starting, the plt taxied to rwy 10 for an IFR departure. Since the twy did not extend to the end of the rwy, the plt of another acft waited on the twy, just…Sep 12, 1982 · N66U · DestroyedNTSB SEA82DA160Accident · No injuriesFinal reportCessna 152 · Bonners Ferry, IDAfter refueling, the pilot attempted to takeoff from a field. The first takeoff attempt was aborted. During the second takeoff roll the aircraft nose gear struck a ditch, causing the aircraft to nose over.Sep 11, 1982 · N67323 · Substantial damageNTSB DEN82FTE27Accident · No injuriesFinal reportVari-Eze · Pagosa Springs, CODue to an approaching thunderstorm from the west, the pilot elected to make a takeoff on runway 04 with a quartering tail wind. The surface was wet and there was about a 20 ft rise in the last half of the runway. The runway was 5600 ft long, but its elevation…Sep 10, 1982 · N123EZ · Substantial damageNTSB ANC82DA088Accident · No injuriesFinal reportPiper PA-32-260 · Naknek, AKAt the point of rotation the acft struck a large puddle of water causing a reduction in speed. The acft continued down the rwy approximately another 150 ft at 5 ft AGL when it became evident that further flight was impossible. The takeoff was aborted & the…Sep 10, 1982 · N3884W · Substantial damageNTSB ANC82DA086Accident · No injuriesFinal reportCessna 170 · Near Anchorage, AKPilot tried stop landing on sandbar he had done touch and go landings on. Sand was soft and flying speed not attained before curve in sandbar during takeoff attempt. Pilot could not negotiate turn and continued into river.Sep 10, 1982 · N2584V · Substantial damageNTSB ANC82DA087Accident · No injuriesFinal reportCessna 185F · Naknek, AKThe pilot made a takeoff downwind in gusty conditions on a lake with marginal capabilities. Surrounding terrain makes wind swirling eddies. The aircraft lost lift and impacted on the bank of the lake in alder brush.Sep 9, 1982 · N80124 · Substantial damageNTSB SEA82DA157Accident · No injuriesFinal reportErcoupe 415C · Kingston, WAPilot thought he could not clear power lines and trees after takeoff so he aborted takeoff & slid 250 ft off the runway, nosing over. The pilot mentioned that it was hot & there was a slight tailwind. This was the first time the pilot has used the airstrip.Sep 7, 1982 · N2932H · DestroyedNTSB DEN82DA187Accident · No injuriesFinal reportCessna 150 · Faith, SDThe pilot reported that the aircraft lifted off the runway nicely, but after climbing to about 75 ft AGL, it started to lose lift and airspeed. He elected to land on a gravel road, but reported that a car was on the roadway. The aircraft was damaged during a…Sep 7, 1982 · N8127S · Substantial damageNTSB ANC82DA085Accident · No injuriesFinal reportBellanca 7GCBC · Mt. Range, AKDownhill takeoff into gusty crosswind raised wing which pilot could not control with aileron. Wing dragged and aircraft nosed over after 200 foot roll.Sep 7, 1982 · N62972 · Substantial damageNTSB SEA82FYA11Accident · Serious injuriesFinal reportBeech C24R · Galena, IDPrior to takeoff the mixture was leaned to compensate for the high density altitude. The arpt is at an elevation of 7,160 ft MSL. The acft rolled the 5,075 ft length of the rwy & may have become airborne prior to striking fences at the end of the rwy. The…Sep 6, 1982 · N18894 · Substantial damageNTSB DEN82DA188Accident · Serious injuriesFinal reportPiper PA-24-180 · Pueblo, COThe aircraft landed at rueblo, CO for fuel on a return flight to Texas. After landing, the pilot asked a female attendant if there were any liquor stores open. The pilot returned to the airport about 1/2 hour later and observed the pilot carrying a brown…Sep 6, 1982 · N7291P · Substantial damageNTSB FTW82DA368Accident · No injuriesFinal reportBellanca 8GCBC · Katy, TXN1052Y an I.c.a brasov glider was being towed for takeoff. During the takeoff run the towplane aborted and continued to roll straight ahead on the center line of a relatively narrow turf airstrip. The pilot of N1052K deployed his spoilers and attempted to…Sep 5, 1982 · N4167Y · 2 aircraft · Minor damageNTSB LAX82DA331Accident · No injuriesFinal reportPiper 601P · Burbank, CADuring lift-off the right engine failed. The takeoff was aborted & the plt swerved the acft to avoid a blast fence at the end of the rwy. The left main landing gear failed & the acft collided with the fence. Maintenance records revealed a total of 12…Sep 4, 1982 · N3642Y · Substantial damageNTSB MIA82DA188Accident · No injuriesFinal reportCessna 188T · Jay, FLDuring takeoff the aircraft lost power at rotation, settled onto the runway, overran the end and flipped over. The pilot had borrowed fuel for this flight and when some was put in a pickup truck the truck would not idle and had no power. An attempt to get the…Sep 2, 1982 · N4790Q · Substantial damageNTSB ANC82FAA14Accident · No injuriesFinal reportCessna 402 · Fairbanks, AKThe plt reported that during taxi there was a light trace of dew on the windshield. The passenger stated that during the initial application of takeoff power the windshield became fogged & completely obscured forward visibility. The plt's attention was also…Sep 2, 1982 · N3299Q · Substantial damageNTSB ANC82DAA17Accident · No injuriesFinal reportPiper PA-18 · 20 Ese North Po, AKAfter previously landing at an off-airport hunting site, the plt & pax started cutting the brush to clear a suitable area for takeoff. Due to the approaching night, the plt considered the area to be suitable. Drg takeoff the left wingtip struck some brush.Sep 2, 1982 · N83593 · Substantial damageNTSB LAX82DA325Accident · No injuriesFinal reportCessna 188 · Casa Grande, AZThe pilot initiated his takeoff with a light quartering tail wind from a 2300 ft runway that was covered with tall grass. The temperature and elevation were 95 deg and about 1500 ft, respectively. He reported that the plane accelerated slowly, but was about…Aug 31, 1982 · N1562M · Substantial damageNTSB CHI82DA316Accident · No injuriesFinal reportBeech G18S · Chicago, ILDuring takeoff on runway 13R, the aircraft swerved to the left just as it obtained tailwheel lift-off speed. The aircraft then struck a dirt bank and was damaged. Both the pilot and the aircraft operator stated that the left main tire lost pressure, but they…Aug 31, 1982 · N38RM · Substantial damageNTSB FTW82DA352Accident · Minor injuriesFinal reportGrumman AA-1 · Pearland, TXThe pilot reported that during an engine run-up, before takeoff, the engine ran rough on one magneto. He did not state which. He reported that after the engine was leaned, the roughness disappeared and a takeoff was made. He stated that after lift off, thrust…Aug 29, 1982 · N5788L · Substantial damageNTSB LAX82DA319Accident · No injuriesFinal reportPiper PA-28-140 · Twenty-Nine Pal, CAWhile preparing to takeoff, the pilot taxied to a position near the midpoint of runway 8/26 where it intersected with a 750 ft taxiway. At that point, the taxiway angled toward the south-southwest to the north end of runway 17/35. The pilot mistook the…Aug 28, 1982 · N5624U · Substantial damageNTSB FTW82DA354Accident · No injuriesFinal reportGrumman G-164A · Columbia, LADuring takeoff, the left wing of the aircraft contacted the cotton that was growing on the left side of the runway. The pilot reported that he could not lift the wing out of the cotton. When he reduced the power, the aircraft turned left and slid sideways.…Aug 25, 1982 · N8390 · Substantial damageNTSB FTW82DA344Accident · No injuriesFinal reportCessna 401A · Silver City, NMThe aircraft was being flown to check it after some minor maintenance had been performed. During the takeoff roll at about 84 KTS, the pilot noted a drop in the fuel flow to the right engine, followed by a loss of power on the right side. He aborted the…Aug 23, 1982 · N9867F · Substantial damageNTSB LAX82IA309Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30F · Honolulu, HIAt rotation, the fire bell and the #2 engine fire warning light came on and the crew noted a power loss on the #2 engine. The takeoff was continued, the engine secured and the fire bottles discharged. The fire continued to burn. The aircraft circled and made…Aug 22, 1982 · N104WA · Minor damageNTSB NYC82DA205Accident · No injuriesFinal reportCessna 150M · Ceres, NYThe pilot made a precautionary landing on a private airstrip to await passage of thunderstorms. Two plus hours later, a takeoff was attempted and aborted. The aircraft contacted a ditch and nosed over. No flaps were used for short field takeoff. Braking was…Aug 20, 1982 · N714EY · DestroyedNTSB MKC82DA154Accident · No injuriesFinal reportPiper PA-25-235 · Fisk, MOThe pilot was taking off from a small ag strip when his left wing went into milo growing beside the strip. Subsequently, the aircraft spun around and flipped over. This was the pilot's tenth takeoff on that day. He reported that the wind was from the…Aug 20, 1982 · N8787L · DestroyedNTSB MIA82DA173Accident · Minor injuriesFinal reportAir & Space 18A · Orlando, FLDuring takeoff, the gyrocopter lifted off to only about 3 ft, instead of the usual 10 to 15 ft. it then settled back to the runway and encountered a ground resonant condition. The pilot stated that once the wheels were carrying the weight, the blades would…Aug 20, 1982 · N6140S · DestroyedNTSB DEN82DA169Accident · Serious injuriesFinal reportQuicksilver Mxii · Broomfield, COReportedly, the pilot made an intersection takeoff from about midfield on runway 02. He stated that he took off at rotation speed plus 2 KTS. The passenger reported that they reached about 40 ft AGL, then lost lift and begun to settle. As the two-place…Aug 20, 1982 · N3149Z · Substantial damageNTSB FTW82DA329Accident · No injuriesFinal reportCessna 152 · Santa Fe, NMThe student pilot was on his first supervised solo flight. During a touch-and-go landing, when power was added for takeoff, at about 50 KTS, he lost control of the aircraft departed the runway, it struck a bush and nosed over.Aug 15, 1982 · N67834 · Substantial damageNTSB LAX82DA303Accident · Minor injuriesFinal reportCessna 172N · Pine Springs, AZPlt stated he landed at what he thought was his destination arpt. The field was soft & an attempted takeoff was unsuccessful. He then taxied to an adjacent paved road & a second takeoff was attempted. The main landing gear went off the shoulder & the acft…Aug 14, 1982 · N5357J · Substantial damageNTSB LAX82DA298Accident · No injuriesFinal reportCessna 152 · Livermore, CAThe student pilot was departing on a solo cross-country flight. He lost control of the aircraft on the takeoff roll, hit a ditch and nosed over. The aircraft owner, who was also his instructor, stated that a moderate crosswind existed during the takeoff roll.…Aug 14, 1982 · N48886 · Substantial damageNTSB CHI82DA309Accident · No injuriesFinal reportCessna 152 · Boyceville, WISolo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over.Aug 12, 1982 · N25325 · Substantial damageNTSB FTW82DA349Accident · No injuriesFinal reportCessna 172N · Antoine, ARThe pilot stated that during the takeoff run from a private airstrip he allowed the aircraft to veer to the left and struck a drainage ditch.Aug 10, 1982 · N75548 · Substantial damageNTSB MKC82DA139Accident · No injuriesFinal reportPiper PA-20 · Scottsbluff, NEDuring takeoff, the pilot raised the tail at about 50 mph and the aircraft veered to the left. Despite the pilot's countermeasures, it departed the left side of the runway. The right gear then collapsed and the right wing and propeller were damaged. An…Aug 9, 1982 · N1970A · Substantial damageNTSB FTW82DA321Accident · No injuriesFinal reportCessna 152 · Iredell, TXThe student pilot originally took off at temple, TX and proceeded to mcgregor, TX to practice touch-and-go landings. After departing mcgregor to return to temple, he became lost. After about two hours, he landed in a pasture and received directions to temple.…Aug 9, 1982 · N6279M · Substantial damageNTSB NYC83LA017Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, CTThe pilot began taking off on runway 19 with a right crosswind. Reportedly, a strong gust of wind was encountered and the aircraft veered off the left side of the runway. It headed toward the opening of a culvert that went under the runway. To avoid the…Aug 8, 1982 · N1836A · Substantial damageNTSB DEN82FTC09Accident · 1 fatalFinal reportBell 47G-3B-L · Kaycee, WYThe pilot was having cooling fan problems, some blades had broken. He landed in a canyon stayed overnight to cool engine and planned to fly to top of the canyon to get repairs. After takeoff, the helicopter had climbed almost level with the top of the canyon…Aug 8, 1982 · N8529F · DestroyedNTSB MIA82DA164Accident · No injuriesFinal reportPiper PA-38 · Vero Beach, FLThe pilot was on an instructional flight when he flew to andther airport to practice grass field landings. According to the 1450 EDT weather report from Vero Beach, the wind was from 110 degrees at 10 KTS and the temperature was 90 degrees. During a…Aug 7, 1982 · N2406D · Substantial damageNTSB NYC82DA191Accident · No injuriesFinal reportPiper PA-38-112 · Poestenkill, NYDuring a touch & go the plt retracted the flaps & applied full power, but the acft seemed sluggish in gaining speed. The plt applied brakes & cut the throttle, but the acft ran off the end of the rwy coming to rest at the edge of a swamp.Aug 6, 1982 · N2361K · Substantial damageNTSB DEN82IA154Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Denver, COThe captain said he felt a "thump" and the aircraft slumped to the left as it was rotated for takeoff. At this point, the aircrew were committed to continue the takeoff which accomplished successfully. A low pass was made for tower personnel to check the…Aug 6, 1982 · N7356F · Minor damageNTSB CHI82DA297Accident · No injuriesFinal reportLake LA-4-200 · Standard Rock, MIAfter landing on a Lake to fish, the water got rough, so the pilot attempted a takeoff. During the takeoff run, the left float hit a wave and broke off. The takeoff was aborted without further damage.Aug 2, 1982 · N6164V · DestroyedNTSB MKC82DA134Accident · No injuriesFinal reportCessna R172K · Hansell, IAThe pilot reported that during the takeoff roll, he was blinded by the sun and allowed the aircraft to drift into tall corn beside the runway. Subsequently, the aircraft nosed over.Jul 31, 1982 · N758AG · Substantial damageNTSB MKC82FCD09Accident · Serious injuriesFinal reportHughes 269B · Tipton, IAThe helicopter crashed during takeoff on a flight to pollenate corn. The pilot reported that he made a running takeoff across the runway. He stated that the helicopter became airborne at the north edge of the runway, but started to settle as it went over the…Jul 29, 1982 · N9357F · Substantial damageNTSB DEN82FTM15Accident · No injuriesFinal reportOar Acapella · Woods Cross, UTThe pilot reported that as he was lifting the nose wheel during takeoff when the left tire encountered 1 to 2 inches of water and broken pavement. He stated that the plane veered left and he applied full right rudder to recover, then the aircraft went off the…Jul 28, 1982 · N360CB · Substantial damageNTSB ANC82DA062Accident · 1 fatalFinal reportHughes 369D · Near Bornite, AKTwo workers were transported to a mine drilling site where the helicopter was landed on a man-made heli-pad. The heli-pad was an area about 50 ft long and 12 ft wide that had been cut into the side of a rocky hill. After off-loading the workers, the pilot…Jul 28, 1982 · N820Y · DestroyedNTSB ATL82DA216Accident · Minor injuriesFinal reportCessna 150G · Huntsville, ALThe pilot landed long and fast and pushed the flap lever to an up position for takeoff. The flap lever is spring loaded to the neutral position. When the flaps did not come up the pilot pushed the switch again and the flaps started up. As the runway end was…Jul 27, 1982 · N3124J · Substantial damageNTSB DEN82DA145Accident · No injuriesFinal reportCessna 152 · Woods Cross, UTThe student pilot stated that during the takeoff roll, he discovered the airspeed indicator was not operating. Also, he said that he accumulated excessive ground speed and made a decision to abort the takeoff. The aircraft was damaged when the pilot was…Jul 26, 1982 · N758YP · Substantial damageNTSB ANC82DA069Accident · No injuriesFinal reportAeronca Champ 7EC · Lake Clark, AKDuring takeoff the aircraft contacted willow trees which swerved the aircraft farther into brush. The pilot aborted the takeoff and braked to a stop. Engine fire started which consumed the aircraft.Jul 26, 1982 · N4314C · DestroyedNTSB MKC82DA132Accident · No injuriesFinal reportCessna 150 · Davenport, IAUnauthorized persons stole money and aircraft keys and attempted a takeoff in a Cessna 150 from a taxiway. The aircraft collided with a runway light and stalled after flying a few hundred feet. The parties involved have not been identified. Injury index is…Jul 24, 1982 · N9270U · Substantial damage