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 MKC85LA225Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Griffithville, ARThe plt reports that the acft fishtailed during the takeoff roll and ran off the side of the rwy. The acft was heading toward a canal and the plt elected to try to fly over the canal. The acft became airborne and flew about 1/4 mi. The plt saw trees ahead and…Jul 15, 1985 · N8561H · Substantial damageNTSB MKC85LA165Accident · Minor injuriesLimited investigationFinal reportde Havilland DH 82A · Ames, IAThe owner had given the plt permission to fly the acft & the plt elected to take a passenger in the front seat. After the accident, the plt stated that he was making a hi speed taxi run on the grass on the right side of the rwy. He reported that the lower…Jul 14, 1985 · N657DH · Substantial damageNTSB MKC85LA155Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Salina, KSThe plt stated that he was receiving a multi-engine flight check from a designated flt examiner. They were still rolling after a landing when the examiner requested a go-around. The plt said that after advancing the throttles, he reached for the flap switch &…Jul 14, 1985 · N1522Z · Substantial damageNTSB LAX85FA314Accident · 1 fatalField investigationFinal reportMooney M20J · Antioch, CAThe acft crashed into a reservoir shortly after departing the Antioch arpt. There were no eye witnesses to the crash. However, an ear witness stated that he heard the acft skipping along the water like the sound of a hydro-plane. He did not hear the eng, but…Jul 11, 1985 · N201HU · Minor damageNTSB ANC85FA118Accident · Minor injuriesField investigationFinal reportDouglas DC-6A · Egegik, AKAirplane accelerated to v 1 and struck through on sandy beach. The nose pitched up and the pilot lost directional control. The airplane struck adjacent bank caught fire. It was totally destroyed.Jul 7, 1985 · N2878F · DestroyedNTSB ANC85LA119Accident · No injuriesLimited investigationFinal reportHelio 250 · Anchorage, AKThe plt reported that he took off downwind with a heavily loaded acft. He estimated the wind was from the north at 4 gusting to 6 KTS. He stated that after climbing about 100 ft, the acft began to mush as he began retracting the flaps. Subsequently, it…Jul 6, 1985 · N5460E · Substantial damageNTSB DEN85LA184Accident · No injuriesLimited investigationFinal reportCessna A188B · Del Norte, COThe plt was attempting to take off from a 3800-FT grass rwy. Field elevation was 7700 ft, temp was 88 deg. The plt said that at about 2500 ft down the rwy he decided to abort the takeoff. Directional control was lost and the airplane groundlooped. The plt…Jul 5, 1985 · N731GN · Substantial damageNTSB MKC85LA148Accident · No injuriesLimited investigationFinal reportCessna 172B · Valley Center, KSThe pilot had been flying with his young son as passenger during daylight hours. He went solo to get current at night. After two full stop landings, he thought the yoke felt heavy for the trim setting he usually used but he started a takeoff anyway. Halfway…Jul 4, 1985 · N51611 · Substantial damageNTSB MKC85LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · El Dorado, KSThe acft had just undergone annual inspection. Pilot failed to remove control lock before test flight. On takeoff roll, pilot was not able to move controls, went off end of 1800 ft runway, through a fence and impacted a dirt pile.Jul 3, 1985 · N2858T · Substantial damageNTSB ANC85LA114Accident · No injuriesLimited investigationFinal reportCessna 172M · Theodore River, AKAfter loading the acft to its max gross wt, the plt initiated a takeoff from a road on level terrain that had numerous dips & bumps. The road was only 11 ft wide & was bordered by heavy brush. The plt reported that prior to reaching the lift-off speed during…Jul 1, 1985 · N20541 · Substantial damageNTSB DEN85LA176Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Gallup, NMDuring a x-country flt from los angeles, CA to tulsa, OK, the plt made an en route stop at Gallup, NM. The fuel tanks were fully serviced & the plt took off with a passenger & aprx 50 lbs of tools & baggage on board. The plt stated that after takeoff, the…Jun 30, 1985 · N5984L · DestroyedNTSB ATL85LA199Accident · No injuriesLimited investigationFinal reportBeech 55 · Savannah, GABefore taking off, the plt checked the trim & the auto-plt. During the takeoff run, he noted that the 'aircraft felt heavy on rotation/takeoff aborted.' The acft continued off the end of the rwy, hit a mound of dirt & was damaged. A post-accident exam…Jun 30, 1985 · N2781F · Substantial damageNTSB CHI85LA263Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Hart, MIDuring a Lake takeoff at near lift off speed the plt stated the acft struck a submerged log and became airborne at a low airspeed. The acft then dropped back to the Lake surface, the right wing float dug in the water and separated the float from the wing. The…Jun 29, 1985 · N516L · Substantial damageNTSB DEN85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lordsburg, NMThe plt attempted to take off from a dirt road at or near max gross wieght and at high density alt conditions. The plt said there was a small rise in the road and he eased back on the control yoke. Directional control was lost and the airplane skidded off the…Jun 27, 1985 · N8180F · Substantial damageNTSB DCA85AA027Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-10 · San Juan, PRAfter landing at San Juan, the acft was parked at the customs area, then was towed to gate 15 & loaded for the next flt. The push-back was such that the crew had to taxi to the gen avn parking area & turn around bfr proceeding to rwy 8 for departure. When…Jun 27, 1985 · N129AA · Substantial damageNTSB LAX85LA290Accident · No injuriesLimited investigationFinal reportLuscombe 8A · San Jose, CAThe pilot lost directional control,during the takeoff phase of a touch and go landing. The acft swerved off the runway as it entered a ground loop that collapsed the right landing gear strut.Jun 24, 1985 · N39087 · Substantial damageNTSB ANC85LA105Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Lewis River, AKThe pilot stated there was a gust of wind about 10 knots, the pilot was not able to reach flying speed, and the aircraft ran off the departure end of the runway.Jun 22, 1985 · N2667Z · Substantial damageNTSB ANC85LA101Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bering River, AKThe plt stated that during a 15 to 20 min period after he had landed, the wind velocity increased greatly. He managed to taxi the float plane to an area where he could takeoff into the wind. As the acft was on the step for takeoff, the left wing lifted as if…Jun 20, 1985 · N99838 · Substantial damageNTSB ANC85FA100Accident · Minor injuriesField investigationFinal reportCessna 180H · Theordore River, AKThe plt landed the float plane on the Theordore River which had a maximum width of about 90 ft & had few straight runs of more than 400 ft. the River had many sharp turns, some in excess of 150 degs, & its depth was as low as 18 inches at low tide. The plt…Jun 20, 1985 · N91390 · Substantial damageNTSB CHI85FEE02Accident · Serious injuriesFinal reportBalloon Works Firefly AX-7 · Somonauk, ILThe Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…Jun 18, 1985 · N40532 · Substantial damageNTSB ANC85LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mulchatna River, AKPlt reported that left wheel axle broke during aborted takeoff from gravel bar, causing acft to ground loop. Plt failed to provide complete info & broken axle for analysis.Jun 17, 1985 · N4876A · Substantial damageNTSB ANC85LAG01Accident · Minor injuriesFinal reportBrians Puffin · Eagle River, AKThe plt was conducting taxi tests on his homebuilt acft when it started to sustain a hull structure failure and control interference from separating parts. The acft pitched off the water, climbed to aprx 100 ft AGL, stalled and spun to ground impact.Jun 16, 1985 · N4933N · Substantial damageNTSB NYC85LA081Accident · No injuriesLimited investigationFinal reportBell 47G-3 · Plainsboro, NJThe helicpopter crashed shortly after takeoff with 55 gallons of fertilizer on board. The plt stated that each time he made a swath run over the field the blades of the helicopter were picking up some of the liquid fertilizer. On takeoff helicopter felt…Jun 15, 1985 · N49882 · Substantial damageNTSB LAX85LA281Accident · No injuriesLimited investigationFinal reportOtis G. Lyons Marquart Charger MA5 · Upper Lake, CAThe plt elected to take off in his taildragger on rwy 19 which is 4050 ft long & 200 ft wide during a period when the wind was estimated at 270 deg, 20 KTS, with gusts to 25 KTS. The plt stated that at rotation full rt rudder was applied, but his homebuilt,…Jun 15, 1985 · N80GL · Substantial damageNTSB ANC85FA093Accident · Serious injuriesField investigationFinal reportCessna 207 · Eek, AKThe pilot-in-command stated that during the takeoff roll he was moving the flap control lever up and down to effect a lift off. The airplane never left the runway and ran off the end of the ten foot embankment, traveled 140 feet before striking a bank and…Jun 15, 1985 · N9828M · Substantial damageNTSB SEA85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Long Valley, NVThe plt chose to land on a country road due to low fuel. After refueling the plt attempted to depart the rough road. During the takeoff roll the acft veered left and struck a wire fence.Jun 14, 1985 · N843 · Substantial damageNTSB LAX85LA268Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Oracle, AZDuring a LCL pleasure flt the plt stated that the acft's eng began running rough so he made a precationary ldg on a dirt road which was at an elevation of 4,000 ft MSL. After inspecting the acft & finding it to be in proper working order the plt decided to…Jun 9, 1985 · N8489U · Substantial damageNTSB MIA85LA186Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City, FLThe plt stated that while taking off in a x-wind he lost control of the acft. The acft contacted the lip of a large drainage ditch, cartwheeled 180 degs to the right and crashed into a ditch.Jun 8, 1985 · N53925 · Substantial damageNTSB CHI85LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Cleveland, OHOn takeoff, a tackel box slid forward and jammed the cyclic. The plt attempted to return to the landing pad, however, one of the skids missed the pad and the acft began to roll until the main rotor contacted the roof of a garage.Jun 8, 1985 · N9296F · Substantial damageNTSB SEA85LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · North Las Vegas, NVLoss of directional control occurred during the student pilot's second attempted touch and go. The aircraft veered let, struck a berm with the nosewheel and then nosed over. FAA inspectors attempted to physically check flight controls but movement was limited…Jun 6, 1985 · N69236 · Substantial damageNTSB NYC85LA140Accident · No injuriesLimited investigationFinal reportCessna 340A · Butler, PAThe plt reported that prior to the flt, he made the usual preflight check & locked the left forward, nose baggage door. During the takeoff roll, the left forward baggage door opened & locked in an upright position. The plt aborted the takeoff, but there was…Jun 6, 1985 · N2669Z · Substantial damageNTSB FTW85LA246Accident · No injuriesLimited investigationFinal reportCessna A188B · Friona, TXThe plt lost directional control and ground looped off the side of the rwy. The purpose of the flt was to check the adjustment of the acft's spray dispensing equipment. Twenty gallons of water were on board to be used as a substitute for chemical spray. The…Jun 4, 1985 · N731AS · Substantial damageNTSB FTW85LA243Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Edna, TXThe pilot lost directional control during a crosswind takeoff from a ranch road. The acft veered off the right (north) side of the road where it contacted a ditch in a rice field.Jun 1, 1985 · N3708E · Substantial damageNTSB CHI85LA219Accident · No injuriesLimited investigationFinal reportCessna T210 · Marion, INShortly after takeoff, the plt discovered that the elevator controls were jammed & pitch changes could only be made with elevator trim & power. An emerg landing was made using the trim, but the plt was unable to flare the acft at landing speed. The acft…Jun 1, 1985 · N6787R · Substantial damageNTSB FTW85LA241Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Fort Worth, TXThe acft was taking off on a test flt to determine the aft c.g. limits in conjunction with an STC modification. As the acft was lifted off in a front skids high attitude, it entered an uncommanded right roll. Full left cyclic would not stop the roll and the…May 31, 1985 · N1072Y · Substantial damageNTSB LAX85LA261Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Glendale, AZThe plt attempted to takeoff fm a 2400-FT-long rwy, he reported that because the acft's airspeed indicator did not appear to properly represent the airspeed, he aborted the takeoff. This occurred after accelerating down the rwy for an estimated 1800 ft. the…May 27, 1985 · N7229N · Substantial damageNTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.May 27, 1985 · N67955 · Substantial damageNTSB FTW85LA232Accident · Minor injuriesLimited investigationFinal reportPitts Special S-1C · Lubbock, TXThe pilot, although well experienced, had recorded only one hour of flight time in this make and model aircraft and no flight time in any aircraft within the 90 day period preceding the accident. This is the information recorded on the pilot/operator aircraft…May 26, 1985 · N22BD · DestroyedNTSB NYC85LA134Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Whitpain, PAThe acft overran the end of the rwy and contacted rough terrain during takeoff. The plt stated the acft lifted off aprx 1/2 the way down the rwy but it did not have enough airspeed to accelerate and climb. The plt attempted to abort the takeoff however, the…May 24, 1985 · N80902 · Substantial damageNTSB CHI85LA206Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · New Hudson, MIThe pilot inadvertently attempted to take off with at least 21 deg. Of flaps. The acft climbed to approximately 30-50 8T. AGL and passed over a hangar on the left side of the runway. Once past the hangar the acft began a rapid descent. Post impact fire…May 23, 1985 · N9581U · DestroyedNTSB CHI85FEP01Accident · Minor injuriesFinal reportBeech 35-C33 · Middleton, WIAt lift-off during the departure, the plt noticed oil spray on the windshield. He initiated an aborted takeoff by retarding the throttle, then realized there was insufficient rwy remaining, so he applied full throttle again. However, the eng did not respond…May 23, 1985 · N6144V · Substantial damageNTSB ATL85LA172Accident · No injuriesLimited investigationFinal reportGalloway B-8M · Milledgeville, GAThe plt stated that the gyroplane was blow off the side of the rwy by a gust of wind during the takeoff portion of a touch and go landing. The acft traveled into a grass area and nosed over. The student plt did not have a solo endorsement and had only two…May 21, 1985 · N991PG · Substantial damageNTSB ATL85FA169Accident · No injuriesField investigationFinal reportLuscombe 8-A · Columbiana, ALThe airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…May 18, 1985 · N28428 · 2 aircraft · Substantial damageNTSB LAX85LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAOn the student plt's third supervised solo flt he landed the acft. After touchdown he applied pwr to make a touch & go, & then raised the flaps. The acft veered left, rolled off the rwy, collided with a small dirt mound & nosed over. The student had 18.2…May 13, 1985 · N25523 · Substantial damageNTSB ANC85LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKPlt did not use all available takeoff area and failed to recognized need to abort until too late. Possible overweight airplane loaded beyond centre of gravity rangeMay 11, 1985 · N1062F · Substantial damageNTSB MIA85LA167Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Winter Haven, FLA Schempp-Hirth ventus b, N40EE, was positioned on rwy 29 to be towed on a competition glider flt. The plt reported that before starting his takeoff, the tow plane was positioned to the left of the glider. The wind was from 030 deg at 8 KTS. As the takeoff…May 7, 1985 · N40EE · 2 aircraft · Substantial damageNTSB BFO85LA044Accident · No injuriesLimited investigationFinal reportCessna 182H · Waynesboro, VADuring the takeoff roll, the pilot noticed that the left door was open. While attempting to close the door, he failed to maintain directional control and the aircraft subsequently struck trees along the south side of runway 23.May 7, 1985 · N8579S · Substantial damageNTSB SEA85FA104Accident · 2 fatalField investigationFinal reportHughes 369D · Spokane, WAThe helicopter was on a flt to a tv station to transport a tv camera man & his gear. The regular plt for this trip was unable to fly, so another was retained for the flt. This was his 1st flt to the station. Helicopter operations at the tv station were…May 5, 1985 · N8365F · DestroyedNTSB LAX85FA240Accident · No injuriesField investigationFinal reportDouglas DC3 · Perris, CAThe aircraft's left engine caught fire during the takeoff roll. The pilot managed to stop the aircraft on the runway and all 31 skydivers and the two member crew evacuated without injury. The left engine propeller had lost one blade which was found several…May 5, 1985 · N157U · DestroyedNTSB NYC85LA115Accident · Serious injuriesLimited investigationFinal reportCessna C172 · Poestenkill, NYCessna 172TD encountered strong gusty crosswind while taking from rensselaer airpark and directional control was lost. The aircraft verred off the left side off the run-way and collid with the terrain. Full right rudder was applied to correct the deviation.…May 4, 1985 · N172TD · Substantial damage