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 NYC86LA188Accident · No injuriesLimited investigationFinal reportBeech BE-20 · Farmingdale, NYAfter a short distance on the takeoff roll, the aircraft veered sharply to the left. Pilot attempted to correct, but was unsucessful and the aircraft collided with parked unoccupied aircraft.Jul 27, 1986 · N83BA · Substantial damageNTSB DEN86LA212Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the…Jul 27, 1986 · N3056A · Substantial damageNTSB DEN86LA205Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Grandin, NDPlt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks…Jul 24, 1986 · N8379 · Substantial damageNTSB ATL86FA208Accident · 2 fatalField investigationFinal reportPiper PA-60-600 · Raleigh, NCThe plt was issued rwy 5, 7,500', for IFR departure with favoring 4 kt quartering headwind. Plt requested rwy 14, 4,498', for takeoff with a 4 kt quartering tailwind. Ground witness and control tower observed acft use nearly all of the rwy on takeoff roll.…Jul 24, 1986 · N3643Q · DestroyedNTSB DEN86LA204Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Sisseton, SDThe plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…Jul 22, 1986 · N8629L · Substantial damageNTSB SEA86LA173Accident · No injuriesLimited investigationFinal reportCessna 180 · Thomas Creek, IDThe plt reported not being lined up properly on the airstrip when power was applied for takeoff. A witness reported seeing the tail of the acft pulling to the left causing the acft to slide down the airstrip. The left landing gear dug into the terrain,…Jul 20, 1986 · N7583K · Substantial damageNTSB LAX86LA298Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZA Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right…Jul 20, 1986 · N76553 · Substantial damageNTSB NYC86LA190Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTWhen the plt checked the airspeed indicator on takeoff, he saw no indication of speed & aborted the takeoff, but was unable to stop on the remaining rwy. The acft contd off the departure end, when down an embankment & became inverted. An exam revealed the…Jul 18, 1986 · N65612 · DestroyedNTSB MKC86LA153Accident · Minor injuriesLimited investigationFinal reportStevenson Glasair · Oakley, KSThe PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the…Jul 18, 1986 · N2440H · Substantial damageNTSB LAX86LA294Accident · No injuriesLimited investigationFinal reportCessna 310J · Stockton, CAA C-31OJ went out of ctl on the rwy and collided with a dirt bank. The CFI indicated that they were practicing single eng procedures in the tfc pattern. After td on a single eng apch the CFI gave the left eng back to the student and annc go-around. Init climb…Jul 18, 1986 · N3195L · Substantial damageNTSB FTW86LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B · Conroe, TXThe pilot reported that he lost tail rotor control during the transition part of the takeoff. As the helicopter rotated to the right, the pilot reduced power and pulled in collective before impact. Examination of the tail rotor showed no evidence of any tail…Jul 15, 1986 · N352AT · Substantial damageNTSB FTW86LA129Accident · No injuriesLimited investigationFinal reportCessna 182C · Decker'S Island, TXDuring a beach take-off run of approximately 200 feet, the aircraft nose wheel sunk into the soft sand. The pilot tried to add power and pull the column back, however the aircraft nosed over into an inverted position.Jul 14, 1986 · N8654T · Substantial damageNTSB MKC86LA149Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Arkansas City, KSThe certified flight instructor stated that his intentions for this flight were to simulate an engine power loss during the early stages of the takeoff roll and have the student perform a rejected takeoff procedure. According to the c.f.I., at approximately…Jul 13, 1986 · N7259Y · Substantial damageNTSB NYC86FA182Accident · 1 fatalField investigationFinal reportAeronca 7AC · Durhamville, NYAircraft departed rwy 35 at kamp airport, climbed to about 200 feet, turned right, stalled and crashed vertically into the ground. A witness said that the aircraft climbed, the engine sputtered, and then stopped. No preimpact malfunction/failure was…Jul 11, 1986 · N84854 · DestroyedNTSB DEN86LA198Accident · No injuriesLimited investigationFinal reportCessna A188B · Center, COAccording to the plt involved in the accident the acft crashed during takeoff because the eng was not developing full power. The owner of the ag spraying business (to whom the acft belongs) and another plt for the operator, stated the mixture was improperly…Jul 11, 1986 · N53353 · Substantial damageNTSB MIA86LA203Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Pompano Beach, FLThe student plt lost control of the acft as power was applied to takeoff. The instructor plt then took control of the acft as it left the rwy, after which the left gear became stuck in sand. The acft nosed over and came to rest inverted.Jul 10, 1986 · N31496 · Substantial damageNTSB ANC86LA112Accident · No injuriesLimited investigationFinal reportCessna 180B · Kvichak, AKThe plt attempted to become airborne without sufficient airspeed after noticing that there was not enough rwy remaining to complete the takeoff. The acft mushed and one of the main gears contacted a dirt bank. A loss of directional control resulted and the…Jul 10, 1986 · N5159E · Substantial damageNTSB CHI86LA167Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Middleton, WIThe student pilot stated that he was practicing soft field takeoffs on a grass strip. He aborted his first attempt to make an intersection takeoff. On his second try, he thought he could get airborne, but did not. The aircraft struck an embankment near the…Jul 9, 1986 · N761UA · Substantial damageNTSB LAX86FJA02Accident · 1 fatalFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The plt was attempting to take off from the deck of a tuna boat when it contacted the side of the boat and sank in the Ocean. Post accident inspection revealed one of two nose tiedown straps had not been removed from the helicopter prior to the takeoff. The…Jul 7, 1986 · N4835A · DestroyedNTSB LAX86FA282Accident · 1 fatalField investigationFinal reportCessna 150H · Phoenix, AZThe plt performed 1 normal touch & go operation, & touched down normally on the second planed touch & go which was to terminate with a right dep out of the pattern. After touchdown, witnesses observed the acft roll straight along the rwy centerline for about…Jul 7, 1986 · N23222 · DestroyedNTSB SEA86LA162Accident · Minor injuriesLimited investigationFinal reportLazarini LONG-EZ · Jackpot, NVDuring takeoff at about rotation speed, the pilot diverted her attention to the right wing. The acft drifted to the edge of the runway and caught a wingtip, then nosed over.Jul 5, 1986 · N8183K · Substantial damageNTSB LAX86FA278Accident · 4 fatalField investigationFinal reportBeech C24R · Meyers, CAWith a density altitude of about 8400 ft, and an aircraft near its max certificated gross weight, the plt & 3 pax departed on rwy 18. During takeoff either the pilot's door was not closed or it came open. The open door degraded the acft's climb performance.…Jul 5, 1986 · N66287 · DestroyedNTSB MKC86LA137Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Wynne, ARThe plt stated that he had been fertilizing rice crops the morning prior to the accident flt and that there was nothing wrong with the acft. He further stated that on the accident flt he had already initiated the takeoff roll, when he realized that the flt…Jul 2, 1986 · N4685B · Substantial damageNTSB LAX86LA274Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ukiah, CAThe Piper PA-18-150 encountered turbulent wind conditions and dragged the left wing during a takeoff ground run from rwy 33. The plt reported that during the takeoff ground run, the right wing lifted causing the left wing to drag on the rwy. The aircraft then…Jun 30, 1986 · N2406J · Substantial damageNTSB NYC86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot was cleared for closed traffic touch and go landings; however, during his acceleration for takeoff, he lost directional control and the aircraft veered left off the runway. Not being able to regain control, the takeoff was aborted. The…Jun 27, 1986 · N6150Q · Substantial damageNTSB DEN86FA175Accident · 3 fatalField investigationFinal reportMartin 404 · Buffalo, WYN40443 was contracted by the Wyoming dept of ag to spray grasshoppers. Investigation revealed the plt held a pvt certificate with asmel ratings. His medical certificate was denied because he failed to provide information concerning high blood pressure and…Jun 27, 1986 · N40443 · DestroyedNTSB MIA86LA190Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley Park, MSThe plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph.Jun 24, 1986 · N8946Q · Substantial damageNTSB FTW86LRD15Accident · No injuriesFinal reportGrumman G-164B · Church Point, LAThe acfts left wingtip caught in weeds during takeoff and the acft was pulled left. The plt had turned to avoid a wet spot on the airstrip and contacted the high weeds then swerved into a rice levee.Jun 24, 1986 · N48585 · Substantial damageNTSB DEN86LA172Accident · No injuriesLimited investigationFinal reportCessna 180K · Ronan, MTAccording to the plt, during the takeoff ground run, his seat slid to the full aft position. The plt stated he lost control & the acft ground looped.Jun 22, 1986 · N61999 · Substantial damageNTSB LAX86LA259Accident · Serious injuriesLimited investigationFinal reportBeech A-36TC · San Rafael, CAThe acft stalled and collided with the ground initial during a takeoff initial climb. He indicated that he misjudged the stall buffet as turbulent airflow from a crosswind. The right wing dropped and the acft stalled. The plt also indicated the stall warning…Jun 20, 1986 · N3823A · Substantial damageNTSB FTW86LA113Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Palacios, TXDuring the ground run portion of the takeoff, the acft contacted a mud hole which resulted in it veering off the grass and into bushes alongside the strip. The plt did not select suitable terrain for the takeoff.Jun 19, 1986 · N48398 · Substantial damageNTSB DEN86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Onida, SDThe plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be…Jun 19, 1986 · N3856E · DestroyedNTSB ANC86LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Theodore River, AKThe pilot stated that upon attempting a soft field takeoff the aircraft drifted to the left. The left main landing gear struck a sand berm which caused the aircraft to exit the road into an open ditch.Jun 18, 1986 · N73419 · Substantial damageNTSB LAX86LA255Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Quincy, CAThe commercial plt/cfi, attempted to takeoff when a left 40 deg, 15 to 25 knot crosswind existed. The plt lost directional control of the acft, & when attempting to abort the takeoff the acft's gear collapsed & the acft collided with a drainage ditch. The plt…Jun 16, 1986 · N97201 · Substantial damageNTSB LAX86LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Glendale, AZThe pilot said that during the takeoff roll on the 2,400 foot long runway he noticed the aircraft aceleration was slow and the airspeed was still below 55 KTS at 3/5 of the way down the runway and he elected to abort the takeoff. The aircraft overran the end…Jun 15, 1986 · N8156E · Substantial damageNTSB CHI86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Indianapolis, INThe plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.Jun 15, 1986 · N5370H · Substantial damageNTSB BFO86FIG02Accident · Minor injuriesFinal reportAero Commander 560A · Easton, MDThe acft overran the end of the rwy and struck an embankment during an aborted takeoff. The plt reported that shortly after takeoff, the acft settled back on the rwy. He reduced the engine power to idle, raised the flaps and attempted to stop the acft to no…Jun 14, 1986 · N2756B · Substantial damageNTSB ANC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Theodore River, AKThe pilot stated that during the takeoff roll he lost directional control of the aircraft causing the aircraft to strike a row of trees.Jun 12, 1986 · N5837D · Substantial damageNTSB MIA86LA178Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt stated that he was attempting a practice soft-field takeoff from rwy 18. Just prior to rotation the main gear contacted a bump in the airstrip and the acft drifted to the left. The acft continued left where it struck trees alongside the rwy.…Jun 11, 1986 · N2378D · Substantial damageNTSB ATL86IA167Incident · No injuriesIncident investigationFinal reportBeech H35 · Birmingham, ALDuring takeoff ground run the aircraft would not develop full power according to the pilot. The pilot elected to abort the takeoff and during the aborted takeoff the aircraft ran off the end of the runway.Jun 11, 1986 · N7989D · Minor damageNTSB FTW86LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Witchita Falls, TXDuring the ground run portion of the takeoff, the pilot lost directional control of his taildragger aircraft. As the aircraft was spinning around the right gear struck a small ditch and broke the landing gear off, causing the aircraft to come to rest on its…Jun 8, 1986 · N37RA · Substantial damageNTSB DEN86LA158Accident · No injuriesLimited investigationFinal reportBeaver Evans VP-1 · Glade Park, COThe plt said that during the take-off roll, high grass restricted the acft from attaining sufficient airspeed to achieve flt. According to the plt the acft struck a barbed wire fence, substantially damaging the acft.Jun 8, 1986 · N23RB · Substantial damageNTSB MKC86LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hickory Ridge, ARThe plt stated that the takeoff was normal up to the initial climb when, at this point oil began streaking from the engine and it lost power. According to the plt, he immediately tried to dump the fertilizer and look for a place to land but, due to the…Jun 7, 1986 · N4921X · Substantial damageNTSB NYC86LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PADuring takeoff roll and as the aircraft was brought to full power, the flight started to veer left. Attempts to correct with right rudder but the aircraft continued to roll left. The aircraft could not be brought under control before contact with two parked…Jun 4, 1986 · N1009F · Substantial damageNTSB FTW86LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Timbalier, LADuring the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the…Jun 4, 1986 · N20379 · Substantial damageNTSB MKC86LA124Accident · No injuriesLimited investigationFinal reportCessna A188 · Blaine, KSThe plt stated that a calf, weighing aprx 500 lbs, ran in fnt of the acft, just as it was apchg lift-off. Subsequently, the acft went out of control & skidded, collapsing the main landing gear. Until just prior to impact, the calf was hidden from the plt's…Jun 3, 1986 · N8140V · Substantial damageNTSB FTW86LA102Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Winnie, TXThe pilot experienced partial loss of power during takeoff when the #3 cylinder quit firing. The aircraft then settled back down onto the grass strip and collided with a levy. At this point the pilot lost control of the aircraft, which went through some…Jun 3, 1986 · N4226N · DestroyedNTSB LAX86LA237Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Goodyear, AZThe student pilot was on her first supervised solo on runway 03 at Goodyear airport, Goodyear, AZ. Her instructor advised her to make three touch & go takeoff's and landings. The instructor positioned herself near the landing area and advised the student…May 31, 1986 · N2002E · Substantial damageNTSB MKC86LA120Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Corning, ARThe plt was making his second flt in this acft when the accident occurred. He failed to lock the cockpit canopy before start of takeoff roll. During the takeoff roll the canopy opened and separated from the acft. The plt diverted his attention from flying the…May 29, 1986 · N8814M · Substantial damageNTSB MKC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Olathe, KSDuring a takeoff roll fm johnson county executive airport, the PIC stated that the left landing gear collapsed and the aircraft impacted the rwy and veered off into soft terrain. Inspection revealed that when electrical power was initiated and the gear switch…May 28, 1986 · N1581X · Substantial damage