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 DEN86LA144Accident · No injuriesLimited investigationFinal reportHispano Aviacion ME109 · Casper, WYDuring takeoff ground roll on a test flt, the acft left brake failed causing the left main wheel to lock up. The plt lost directional control and the acft departed the left side of the runway where it ground looped. The aircraft was destroyed. The pilot was…May 28, 1986 · N3109 · Substantial damageNTSB MKC86LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, MOThe pilot stated he thought he could get airborne from the turf field although it was wet, soft, and muddy. After rolling some distance, he decided he would have to fly through powerlines or trees so he aborted. The airplane ran past the end of the runway,…May 26, 1986 · N32143 · DestroyedNTSB MKC86LA115Accident · No injuriesLimited investigationFinal reportCessna A185F · Bernie, MOThe pilot stated that they were on the takeoff roll when his seat failed and he fell backward away from the flight controls and the throttle. The airplane veered left, off the runway, crossed a small ditch, a road and then impacted in a very large drainage…May 20, 1986 · N1096F · DestroyedNTSB DEN86FTK02Accident · No injuriesFinal reportAero Commander Callair A-9B · Dell Rapids, SDThe plt stated that during the takeoff roll, he lost rudder effectiveness after accelerating to about 60 KTS. He applied brakes to stop, but the acft veered off the left side of the rwy & struck a fence. No preimpact part failure or malfunction was reported.…May 20, 1986 · N7757V · Substantial damageNTSB NYC86LA130Accident · No injuriesLimited investigationFinal reportCessna 206 · Greenville, METhe pilot experienced problems on takeoff from moosehead lake, but eventually was able to get airborne and fly to the Greenville airport. The aircraft remained on the ground for a few hours, then was preflighted for deparapure. Runway 21 was the favorable…May 18, 1986 · N60638 · DestroyedNTSB NYC86FA131Accident · 2 fatalField investigationFinal reportCessna 414A · Atlantic City, NJDuring tkf gnd run, at a speed of 95 KTS, the plt pulled the control wheel back to lift off. The control wheel, according to the plt, would not go back more than about 2 inches; which is less than half the normal full aft travel. The acft reached a speed of…May 18, 1986 · N414NY · DestroyedNTSB FTW86LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150F · San Antonio, TXPilot failed to obtain sufficient airspeed to clear the trees at the end of the runway. The runway was soft and there was a left crosswind.May 18, 1986 · N7902F · Substantial damageNTSB MIA86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe plt stated that during the takeoff portion of a touch and go landing he lost directional control of the acft. The acft veered left off the rwy, struck a ditch and the landing gear collapsed.May 17, 1986 · N69133 · Substantial damageNTSB LAX86LA224Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tonopah, AZThe acft collided with a truck during takeoff ground run from an interstate. The plt indicated the acft had run out of fuel on the x-country flt and he had not refueled at the departure point. He landed on the interstate without incident and sent his pax for…May 17, 1986 · N714UL · DestroyedNTSB CHI86MA142Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILU.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty…May 17, 1986 · N973VJ · 2 aircraft · Minor damageNTSB MKC86LA106Accident · No injuriesLimited investigationFinal reportCessna 188 · Lawrence, KSThe pilot stated that the right main tire rolled over sharp rocks and was subsequently destroyed during the takeoff roll. The pilot further stated that he apparently over corrected and drifted left, digging into a soft spot on the runway, and nosed over.May 11, 1986 · N5531S · Substantial damageNTSB NYC86LA124Accident · No injuriesLimited investigationFinal reportCessna 305A · Salem, NHThe Cessna 305, being used a tow plane for glider operations, ran through a fence at the departure end of the rwy during takeoff. The plt stated he experienced a wind shift during takeoff. He did not have a pre-decided point at which to either release the…May 10, 1986 · N16576 · Substantial damageNTSB CHI86LA139Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Plainwell, MIWhile departing to the north in light wind conditions, the pilot made a decision to abort the takeoff, then realized he would not be able to stop on the remaining runway. He attempted to continue the takeoff. He zoomed the aircraft to clear wires in his path,…May 10, 1986 · N48102 · Substantial damageNTSB FTW86LA088Accident · No injuriesLimited investigationFinal reportCessna 337D · Edinberg, TXThe pilot stated he lost both engines while in cruise flight. However, no evidence of engine malfunction was found during the investigation. The pilot is under investigation for illegal drug trafficking. A dea agent suspects the pilot had unloaded his cargo…May 9, 1986 · N337D · Substantial damageNTSB DEN86LA130Accident · No injuriesLimited investigationFinal reportCessna A188B · Berino, NMThe pilot reports that he was taking off on his third aerial app flt of the day. He said the wind was from the nw and very light and he was departing to the n. the density alt was calculated to be 5,200 ft. acceleration seemed to be normal until about two…May 9, 1986 · N4491Q · Substantial damageNTSB LAX86LA211Accident · 1 fatalLimited investigationFinal reportBell 47G-5A · AganaThe helicopter crashed into the ocean when the plt attempted to lift off from a tuna boat. Reportedly, only three of the four tiedown ropes, which had secured the helicopter to the boat, had been released. The plt's medical certificate was dated 1/18/84.May 6, 1986 · N2996W · DestroyedNTSB ANC86LA052Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee L-13 · Fairbanks, AKDuring the takeoff roll the pilot lost control of the aircraft, the acft exited the runway and rolled over on its right side. The inspection of both tailwheel and tailwheel assembly revealed very loose cables between the locking handle and the tailwheel. At…May 2, 1986 · N2536B · Substantial damageNTSB NYC86LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTThe student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and…Apr 28, 1986 · N3235V · Substantial damageNTSB SEA86LA114Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20-D · Minden, NVThe cockpit canopy opened during takeoff roll. The glider became airborne and climbed to an alt of aprx 10 ft AGL before descending to ground impact in a nose low attitude.Apr 27, 1986 · N6VS · Substantial damageNTSB ANC86LA050Accident · Minor injuriesLimited investigationFinal reportInterstate 15B2 · Port Heiden, AKThe pilot stated that during the takeoff roll he lost control of the aircraft causing the plane to nose over on its back.Apr 26, 1986 · N64AT · Substantial damageNTSB LAX86LA184Accident · No injuriesLimited investigationFinal reportCessna 310N · Fullerton, CAThe acft overran the rwy during an aborted takeoff. The plt had flown the acft the day prior on his bfr and conducted a 'thorough preflight' insp. On the day of the accident, he preflighted the acft again and flew it without incident. He then refueled the…Apr 21, 1986 · N4162Q · Substantial damageNTSB CHI86FER05Accident · Serious injuriesFinal reportCessna A188B · Greenbush, MNThe plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient…Apr 21, 1986 · N9220R · Substantial damageNTSB MKC86LA090Accident · No injuriesLimited investigationFinal reportCessna 172D · Garden Grove, IAThe plt stated that he was attempting a no-flap takeoff from his pvt strip when the wheels hit a wet spot. He said that the acft slowed down but he extended flaps and continued the takeoff. When he saw that he was running out of rwy, he aborted the takeoff…Apr 17, 1986 · N2502Y · Substantial damageNTSB ATL86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Charlotte, NCDuring the attempted takeoff the acft skipped, climbed a few feet, settled to the ground then climbed again before the plt attempted to abort the takeoff. The acft overran the end of the rwy, crossed a road and hit a ditch and nosed over. An estimated weight…Apr 8, 1986 · N2851Q · DestroyedNTSB NYC86LA100Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · Pittsburgh, PAThe pilot-in-command lifted off the helipad vertically to an altitude of 30 feet at which time he experienced a power loss. He backed up the helicopter 20 feet and allowed it to yaw to the right as it descended to the helipad. He landed on the helipad hard…Apr 5, 1986 · N2354 · Substantial damageNTSB LAX86LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Novato, CAA PA-38 lost directional control during a takeoff with both the student and instructor pilot at the controls. The aircraft sustained substantial damage but both pilots were uninjured. The wind was 90 degrees crosswind at 10 knots gusting to 15 knots. The…Apr 4, 1986 · N91301 · Substantial damageNTSB FTW86LA057Accident · No injuriesLimited investigationFinal reportCessna 185F · Point Aufer, LAThe pilot reported losing control of his aircraft, during takeoff from a canal at Point Aufer island, LA, when gusty wind conditions lifted a wing, causing the aircraft to collide with a bank. After the collision, the aircraft continued up onto the canal…Apr 4, 1986 · N1867Q · Substantial damageNTSB LAX86LA163Accident · No injuriesLimited investigationFinal reportCessna 150M · Glendale, AZThe student's CFI said that a dual session was flown earlier in the morning and that the accident session was the student's first supervised solo. The CFI said that on the first landing of the accident flight, the aircraft touched down on the left main gear…Apr 3, 1986 · N7563U · Substantial damageNTSB SEA86LA086Accident · Minor injuriesLimited investigationFinal reportMaule M5-180C · Sand Point, IDWhile attempting to take off in strong gusty crosswinds, the plt lost control of the acft. The acft veered off the rwy, struck a fence post, and nosed over inverted. The reported winds at coeur d'alene, ID, 33 nmi ssw of Sand Point, were reported as being…Mar 30, 1986 · N119JC · Substantial damageNTSB NYC86LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsfield, MAThe Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial…Mar 29, 1986 · N49107 · Substantial damageNTSB FTW86LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Houston, TXA flight instructor was showing his student how to takeoff from a crass strip when he noticed another aircraft taking off on an intersecting runway. He elected to abort the takeoff, and the aircraft collided with a ditch, damaging the main gear, left wing and…Mar 29, 1986 · N71611 · Substantial damageNTSB LAX86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Tucson, AZA Cessna 150 collided with terrain during a takeoff from a road. The student plt indicated he was practicing aerial maneuvers in the training area when the engine quit. He successfully accomplished a power off landing to an asphalt road. A certified mechanic…Mar 25, 1986 · N22613 · Substantial damageNTSB LAX86DVA04Accident · 1 fatalFinal reportGlen Davis Glasair · Chinese Camp, CAA glasair homebuilt aircraft collided with a barn shortly after takeoff on a night time business trip. The aircraft departed from the extreme left side of the runway which had a high growth of vegetation. The aircraft was observed to be about 40 to 50 ft…Mar 23, 1986 · N84GD · DestroyedNTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…Mar 23, 1986 · N97266 · Substantial damageNTSB NYC86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hartford, CTThe cross country solo flight was taking off on runway 02 at Hartford, Connecticut. The pilot performed a runup and was cleared for takeoff. The pilot attempted rotation at about 60 KIAS, but aircraft did not lift off. Trim tab was set at neutral on runup. As…Mar 22, 1986 · N4347G · Substantial damageNTSB ANC86LA038Accident · No injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKThe pilot stated that during the takeoff roll he added power too fast for the takeoff. The pilot failed to compensate with rudder.Mar 21, 1986 · N46362 · Substantial damageNTSB FTW86LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, OKDuring takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a…Mar 15, 1986 · N7576G · Substantial damageNTSB ATL86LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Stone Mountain, GAShortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams…Mar 15, 1986 · N7374G · Substantial damageNTSB SEA86LA076Accident · No injuriesLimited investigationFinal reportBeech 18 · Seattle, WAThe pilot lost control of the aircraft on takeoff and a subsequent groundloop occurred. Although the pilot has a DC-3 type rating, he had only 20 hours in this aircraft.Mar 11, 1986 · N926T · Substantial damageNTSB MKC86LA067Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Jacksonville, ARThe pilot was attempting a takeoff from a sod strip in an Aeronca tail dragger aircraft in gusty wind conditions. The air strip runway is situated along a north-south heading with the rptd winds fm 290 degrees magnetic at 13 knots with gusts to 18 knots. As…Mar 10, 1986 · N82202 · Substantial damageNTSB SEA86LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · American Falls, IDThe student pilot was attempting to make a touch and go, when the aircraft veered to the left of the runway and struck an embankment. The student failed to use enough right rudder to maintain directional control. The runway's width is 50 feet.Mar 3, 1986 · N6486J · Substantial damageNTSB NYC86LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Nashua, NHThe student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to…Feb 24, 1986 · N303DW · Substantial damageNTSB FTW86LQA01Accident · Minor injuriesFinal reportCessna 152 · El Paso, TXThe acft went off the rwy and nosed over in the rough sand. The plt said that she looked into the cockpit to locate the flap switch to raise the flaps for a running takeoff. Power had already been added and the acft started to the left by the time the plt…Feb 24, 1986 · N67888 · Substantial damageNTSB DEN86FA080Accident · No injuriesField investigationFinal reportBoeing 737-300 · Denver, COF/o was on the 3rd initial operating experience flt with a check airman. Capt and f/o had discussed rapid rate of rotation on previous flts and again on accident flt. The f/o performed the takeoff from Denver and exceeded rotation rate of 3 degrees per sec.…Feb 20, 1986 · N17309 · Substantial damageNTSB FTW86LQG08Accident · No injuriesFinal reportWayne Mathews Glas AIR SH2R · Ranger, TXThe acft drifted left off the rwy during takeoff and collided with trees. This was a home built acft that had just been certified. The owner/builder had made high speed taxi runs but did not feel comfortable to fly it. Another plt was asked and after a short…Feb 17, 1986 · N9660N · Substantial damageNTSB CHI86LA087Accident · No injuriesLimited investigationFinal reportCessna 340A · Wheeling, ILAccording to the plt the left eng lost pwr at rotation. He could then not correct the left ground track deviation with right rudder. To avoid obstacles at the edge of the rwy he pulled the acft off the ground but the acft soon settled back down, sustaining…Feb 16, 1986 · N2743Y · Substantial damageNTSB SEA86LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Renton, WAThe pilot failed to maintain directional control during takeoff. Although a crosswind from the left was present the pilot lost control for unknown reasons to the left, crossing the taxiway and then striking a parked vehicle and building. No mechanical reason…Feb 12, 1986 · N739UW · Substantial damageNTSB LAX86FA114Accident · 2 fatalField investigationFinal reportNaval Aircraft Factory N3N-3 · Middletown, CAThe acft departed the privately owned dirt strip on a sales demonstration flt. The PIC occupied the rear seat and the prospective buyer occupied the front seat. Shortly after departing the eng began to run rough. The acft entered into a course reversal turn.…Feb 8, 1986 · N45105 · DestroyedNTSB DEN86FA076Accident · Serious injuriesField investigationFinal reportCessna T-210M · Albuquerque, NMThe plt took off on the 13,373 foot rwy in IMC conditions on an IFR flt plan. The arpt control twr controller observed the acft at midfield after takeoff, emitting black smoke and informed the plt. The plt requested and was cleared for landing. The acft was…Feb 8, 1986 · N210TA · DestroyedNTSB MKC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Des Moines, IAThe student pilot stated he was on the takeoff roll for a practice flight when he lost directional control and ran off the left edge of the runway and stayed there until it impacted a taxi/intersection sign.Jan 31, 1986 · N25735 · Substantial damage