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 ANC83LA132Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Tyonek, AKAccording to the pilot, during takeoff at rotation the floats struck a sandbar. He lost control of the aircraft and it nosed over in the water.Jul 25, 1983 · N4535F · Substantial damageNTSB SEA83LA158Accident · Serious injuriesLimited investigationFinal reportBensen B8M · Wenatchee, WAReportedly, the plt had received 7 hrs of dual instruction in the benson gyrocopter. He had been observed taxiing the acft on an unused portion of the arpt during the winter months of 1982 & 1983. However, no flts were observed & the student plt had no…Jul 23, 1983 · N2279C · DestroyedNTSB SEA83LA156Accident · Minor injuriesLimited investigationFinal reportFinamore KR-2 · Hillsboro, ORThe acft lost power at about 100 ft AGL during takeoff. The pilot made a forced landing straight ahead into a grain field. The high vegetation caused enough drag on the landing gear to nose the acft over. Examination of the engine revealed that the high…Jul 22, 1983 · N3382F · Substantial damageNTSB FTW83LA345Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Houma, LAThe acft had previously been submerged in water. After it was salvaged & repaired, a ferry permit was obtained to fly it to amarillo, TX. According to a witness, the eng began running rough after the 1st 50 ft of the ground roll during takeoff. However. The…Jul 22, 1983 · N4959Q · DestroyedNTSB FTW83LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Whitewright, TXThe acft collided with a fence and nosed over after the seat lock pin failed and the seat slid all the way to the rear. The plt was unable to reach the rudder pedals and the acft veered off the road being used as a rwy.Jul 20, 1983 · N46909 · Substantial damageNTSB MKC83LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Nebraska City, NEThe student plt lost directional control during a takeoff on his 2nd solo flt. He reported that as he started the takeoff, the acft began moving to the left of the rwy, so he applied right rudder, but too much, then too much left rudder. Subsequently, the…Jul 18, 1983 · N714VP · Substantial damageNTSB SEA83LA151Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Ellensburg, WAThe acft nosed over during an aborted takeoff. The pilot stated that the acft was subjected to a gusty tailwind just before takeoff and the acft started to skip and skid with the nose to the left. The pilot started abort procedures and said the tail of the…Jul 17, 1983 · N3033A · Substantial damageNTSB ATL83FA282Accident · No injuriesField investigationFinal reportPiper PA-34-22OT · Atlanta, GAThe acft was on a takeoff roll when the left main and nose gear retracted. Investigation revealed a flt switch for the hobbs meter had been installed to automatically record only flt time when the switch was in the flt position. In this postion the hobbs…Jul 17, 1983 · N8387X · Substantial damageNTSB CHI83LA316Accident · No injuriesLimited investigationFinal reportCessna 188-B · Springfield, MNThe acft crashed into a cornfield during a takeoff to spray crops. The pilot stated that there were no mechanical problems with the acft. Investigaiton showed that the pilot attempted a takeoff on rwy 31 with a 5 kt tailwind. The acftdid not become airborne.Jul 16, 1983 · N21700 · Substantial damageNTSB NYC83LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Canandaigua, NYThe plt initiated a takeoff on a 1900 ft grass rwy with 2 notches of flaps. He stated that after lift-off, he had climbed 50 to 75, but was unsure whether or not he could clear the tops of the trees at the end of the rwy. He elected to abort, but was unable…Jul 15, 1983 · N733MW · Substantial damageNTSB CHI83LA290Accident · Minor injuriesLimited investigationFinal reportEipper MX-2 · Pylmouth, INThe acft was taking off for dual instruction when a gust of wind picked up the wing and the aircraft cartwheeled ending on the nose and rt. Wing. The instructor stated that as the acft accelerated a sudden gust of wind caught the acft from the left. The…Jul 15, 1983 · N38802 · Substantial damageNTSB LAX83FVG14Accident · Serious injuriesFinal reportSikorsky S-58 · Biggs, CAThe plt reported that he brought the helicopter to a hover in the loading area & eased forward to the rwy where he attempted to 'transition from a hover to flt.' He became aware that the helicopter was not going to have sufficient performance, so he elected…Jul 14, 1983 · N9043P · DestroyedNTSB DEN83LA164Accident · No injuriesLimited investigationFinal reportCessna T188C · Carthage, SDThe acft was using a county road near the field being sprayed for takeoff. The pilot reported that the herbicide sloshedout onto the windscreen during takeoff and obscured his vision. The acft veered right and entered the ditch. The pilot said the hopper lid…Jul 14, 1983 · N2060J · Substantial damageNTSB FTW83LA330Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Delaplaine, ARThe acft nosed over after running off the end of the rwy during takeoff. The plt had a heavy load of fertilizer and a passenger in the single seat acft. The temperature was 94 degrees and the rwy was only 1500 ft long rather than 2300 ft as reported by the…Jul 11, 1983 · N90135 · Substantial damageNTSB CHI83LA306Accident · No injuriesLimited investigationFinal reportCessna 150J · Hibbing, MNThe acft collided with a ditch during takeoff roll. The takeoff was on rwy 31 with the wind from 270 degrees at 8 KTS. The plt said that at 30-40 mph he lost directional control and swerved off the rwy into a drainage ditch. The rwy was 150 ft wide and made…Jul 11, 1983 · N51228 · Substantial damageNTSB CHI83LA314Accident · No injuriesLimited investigationFinal reportFlug-Und Fahrzeugwerke Diamant · Frankfort, MIThe plt reported that during a winch tow takeoff the right wing caught in tall grass & soft sand, & the glider ground-looped.Jul 10, 1983 · N37AC · Substantial damageNTSB ATL83FA267Accident · Minor injuriesField investigationFinal reportCessna 172M · Sylvester, GAThe pilot had accomplished two takeoffs and two full stop landings. The pilot stated that on the third takeoff RPM was lost about the time for liftoff. He elected to abort the takeoff about halfway down the runway. When he pulled the power/throttle back to…Jul 10, 1983 · N80329 · Substantial damageNTSB ATL83LA264Accident · 1 fatalLimited investigationFinal reportBensen B8M · Somerville, TNThe acft crashed during takeoff while on a pleasure flight. A witness stated that he saw the acft take off and climb outat a gradual climb to about 100 ft and then start a gradual descent to about 30 ft. at which time the acft nosed over and went almost…Jul 9, 1983 · N47BH · DestroyedNTSB FTW83LA322Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMThe tow plane collided with a van on the rwy during takeoff. The van had been parked there on purpose by the arpt owner to close the rwy. He stated that he had notified the FAA of the closing but no NOTAM had been issued on 7/7/83. A NOTAM was issued for…Jul 7, 1983 · N8999 · Substantial damageNTSB ANC83FA113Accident · Minor injuriesField investigationFinal reportCessna 207A · Dillingham, AKThe acft collided with a beached unoccupied 18 ft skiff during a takeoff attempt from a soft beach. This acft is a 7 place model. At the time of the accident there were 12 occupants on board. The acft was not overweight because several occupants were children…Jul 6, 1983 · N6271H · Substantial damageNTSB FTW83LA312Accident · Serious injuriesLimited investigationFinal reportBeech C-23 · Albuquerque, NMThe aircraft impacted 2.2 miles off the departure end of runway 35 at coronada airport. Witnesses stated the aircraft used almost all of the 4020 ft runway before becoming airborne and the aircraft achieved an altitude of only 20 feet. Investigation revealed…Jul 4, 1983 · N1932L · DestroyedNTSB ATL83LA276Accident · No injuriesLimited investigationFinal reportPiper L-21B · Vernon, ALThe acft departed the rwy & nosed over inverted during an unauthorized flight. After the accident the non-certificated plt told the owner that he had flown the acft several times based on the permission of a friend who was authorized to fly the acft.Jul 4, 1983 · N8056W · Substantial damageNTSB MIA83LA189Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe acft collided with a tree during an aborted takeoff when the plt realized that the airspeed was not registering. During the abort, directional control was lost and the acft veer to the left. Inspection revealed the airspeed indicatormalfunctioned due to a…Jul 2, 1983 · N9103A · Substantial damageNTSB LAX83LA315Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hayward, CAThe plt stated that during the takeoff roll he attempted to lift the acft off at about 65-75 KTS indicated airspeed. The plt said that he thought the acft was not responding properly so he cut the power and tried to land on the rwy. The acft kept bouncing, so…Jul 2, 1983 · N4957G · DestroyedNTSB ANC83IA111Incident · No injuriesIncident investigationFinal reportDouglas DC-7C · King Salmon, AKAcft overran the end of the rwy when takeoff was aborted after failure to rotate. No mechanical difficulties were noted. The rwy was dry and adequate. The CG was at or near the forward limit.Jul 2, 1983 · N284 · Minor damageNTSB FTW83LA305Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Port Mansfield, TXAccording to the plt, the nose gear position light flickered & the nose gear unsafe light illuminated, just prior to rotation. He reportedly aborted the takeoff at that time, but was unable to stop before going off the end of the rwy at 65 to 70 KTS. As the…Jun 29, 1983 · N39589 · Substantial damageNTSB CHI83LA284Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Crane Lake, MNThe plt reported that while he was taking off on an easterly heading, the float plane was on the step & became airborne sooner than he expected. While he was correcting the stituation by lowering the nose, the left float dug into the water. Subsequently,…Jun 29, 1983 · N96333 · Substantial damageNTSB DEN83LA157Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Vernon, COThe acft collided with a mailbox during takeoff from a gravel road.Jun 26, 1983 · N43344 · Substantial damageNTSB ANC83LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe acft collided with trees alongside the runway during takeoff. The runway was a dirt strip 1200 feet long and 30 feetwide. The pilot stated after the accident that he lost control of the acft and ran off the runway into the wooded area. The wind was from…Jun 26, 1983 · N3074A · Substantial damageNTSB MKC83LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Denton, NEThe acft went off the runway during takeoff. The pilot said the acft drifted to the left after the tailwheel was raised. He said he brought the acft back to the centerline but it drifted left again and entered tall grass beside the runway. As the pilot…Jun 24, 1983 · N2506D · Substantial damageNTSB LAX83IA302Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-32 · Las Vegas, NVDuring the ground run for takeoff a fatigue precipitated failure of the third stage turbine blade occurred with secondary damage to several guide vanes and the fourth stage turbine wheel. Imbalance of the turbine wheel caused the failure of the number six…Jun 24, 1983 · N942N · Minor damageNTSB CHI83LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Minneapolis, MNThe acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…Jun 24, 1983 · N8310L · Substantial damageNTSB MKC83LA132Accident · No injuriesLimited investigationFinal reportCessna 182F · Dows, IAThe acft nosed over during takeoff. The rwy used was 090 and the wind was from 170 degrees at 17 KTS. The plt said the acfts right wing raised followed by the tail and then the left wing dropped impacting the sod rwy before the acft nosed over.Jun 21, 1983 · N3568U · Substantial damageNTSB FTW83LA284Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Abilene, TXThe agricultural acft collided with a pole during an aborted takeoff after directional control was lost. The plt stated that a soft spot in the rwy caused the acft to veer left. The takeoff was aborted but the acft continued off the rwy andcollided with the…Jun 19, 1983 · N6303Z · Substantial damageNTSB DEN83LA146Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Burlington, WYThe acft departed the rwy in an evasive maneuver to avoid a deer. The acft contacted small trees and brush off the rwy and collapsed the landing gear. The pilot said he was about 150 yards down the rwy with the tail of the acft up when thedeer ran onto the…Jun 19, 1983 · N9789V · Substantial damageNTSB ANC83LA100Accident · No injuriesLimited investigationFinal reportCessna 140 · Bettles, AKThe acft nosed over during an aborted takeoff. The acft was damaged but the occupants were not injured. The pilot statedthat he decided to take off to the south since there was no wind. The acceleration for takeoff was slow according to thepilot so he closed…Jun 19, 1983 · N89410 · Substantial damageNTSB DEN83LA145Accident · No injuriesLimited investigationFinal reportCessna 195A · St. George, UTThe prop blade separated causing the acft to veer sharply to the left out of control. The acft came to rest about 30 ft from the rwy with the right main landing gear broken off. A metallurgical exam revealed that the blade failed from fatigue. The fatigue…Jun 18, 1983 · N1537H · Substantial damageNTSB ATL83LIJ03Accident · No injuriesFinal reportPiper PA-28-140 · Bruceton Mills, WVThe acft collided with a fence during an attempted takeoff from a short sod private strip. The privately owned grass strip is approx. 800 feet long with a 5 deg upgrade from the midway point. The pilot said he realized he could not climbfast enough so he…Jun 18, 1983 · N6575W · Substantial damageNTSB DEN83LA141Accident · No injuriesLimited investigationFinal reportCessna A188 · Leola, SDThe plt was using a gravel road, aprx 20 ft wide, for an aerial application operation. During takeoff, the acft swerved to the right, went into the ditch beside the road & was substantially damaged. The plt believed that the right wheel had become locked.…Jun 16, 1983 · N8181V · Substantial damageNTSB NYC83LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Latrobe, PAThe acft ran off the runway when the student pilot attempted to close a window during the takeoff roll. As the acft left the runway the nose wheel collapsed rearward and the prop, main gear and fuselage were damaged. The pilot received minor injuries.Jun 14, 1983 · N65615 · Substantial damageNTSB FTW83LA277Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAThe acft collided with a dirt levee during takeoff after an engine malfunction. According to the plt he experienced a power failure at liftoff. He dumped his spray load and applied brakes. The engine regained partial power and failed again. At about 60 mph…Jun 14, 1983 · N4025P · Substantial damageNTSB FTW83LA275Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Newport, ARAccording to the plt, after he took off, he was unable to maintain alt & began dumping his load of 1500 lbs of chemicals. He turned back toward the airstrip, but was forced to land short of a bean field. After touchdown, the acft rolled into a small drainage…Jun 13, 1983 · N6581 · Substantial damageNTSB CHI83LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Strongville, OHThe acft collided with trees at the departure end of the runway during an aborted takeoff. The instructor pilot who was doing a demonstration flt stated that 'the acft rotated to a normal climb attitude but did not climb out of ground effect. After electing…Jun 12, 1983 · N24802 · Substantial damageNTSB CHI83FA251Accident · Serious injuriesField investigationFinal reportBoeing 727-222A · Chicago, ILDuring the takeoff roll, the #1 eng failed & the takeoff was aborted at aprx 70 KTS. The aircrew taxied the acft clear of the rwy & stopped on the reverse high speed turnoff. The aircrew of another company acft transmitted that the #1 eng was on fire. There…Jun 11, 1983 · N7273U · Substantial damageNTSB FTW83LA269Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · San Antonio, TXWhile on the takeoff roll, with aprx 1400 ft of rwy remaining, the plt noticed that there was no indication of airspeed. He therefore elected to abort the takeoff, the rwy was a combination of asphalt & turf. Following his decision to abort, the remaining…Jun 7, 1983 · N1757W · Substantial damageNTSB NYC83LA135Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 109 · Finleyville, PAThe motorized glider collided with trees and the terrain during an emergency landing after the prop had struck the ground during takeoff. During the takeoff roll the propeller 1st collided with high grass and then a bump in the ground after the pilot lost…Jun 5, 1983 · N903BG · Substantial damageNTSB ATL83FA213Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Calhoun, GAThe plt had flown to the arpt to perform aerobatic maneuvers at a fly-in. He had a low altitude waiver to perform down to 500 ft AGL. Before the flight, he told several spectators he was going to do a maneuver right after takeoff. Witnesses reported that the…Jun 4, 1983 · N111UD · DestroyedNTSB MIA83LA150Accident · No injuriesLimited investigationFinal reportCessna 207 · Sebring, FLAccording to the plt, he heard a 'thump' when he was taking off from orlando west arpt, but attributed it to the grass strip. When he landed at Sebring arpt, he heard a scraping sound as he lowered the nose & elected to go around. He decided the nosewheel was…May 31, 1983 · N75773 · Substantial damageNTSB ANC83LA088Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Venetie, AKThe plt initiated his takeoff from a downhill, uni-directional rwy (rwy 17) with a tail wind from 020 deg at 15 gusting 25 KTS. He stated that he climb to an alt of 100 to 200 ft then encountered severe turbulence. Subsequently the acft struck the ground 2…May 31, 1983 · CGPZP · DestroyedNTSB FTW83LA257Accident · No injuriesLimited investigationFinal reportCessna 170B · Roswell, NMThe solo student plt was practicing touch and go landings. According to the plt, after landing and rolling about 200 ft he applied power to takeoff, the acft turned left and then ground looped 180 degrees. The right main landing gear collapsed.May 29, 1983 · N113E · Substantial damage