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 LAX89DVA02Accident · No injuriesFinal reportWSK PZL Mielec PZL-M-18 · Mendota, CAOn takeoff for an aerial application flight, the aircraft failed to clear an agricultural berm 300 ft beyond the end of the runway and nosed over. The pilot stated that the aircraft was loaded with 500 gallons of sodium chlorate and that he should have…Oct 21, 1988 · N4206A · Substantial damageNTSB CHI89LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Indianapolis, INShortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive…Oct 21, 1988 · N7733P · Substantial damageNTSB DEN89LA016Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot was practicing touch-and-go landings in a 15 kt crosswind condition in an acft in which he had 8 hrs experience. During takeoff roll after the sixth landing the plt lost control and the acft departed the side of the rnwy.Oct 17, 1988 · N53949 · Substantial damageNTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…Oct 9, 1988 · N98395 · Substantial damageNTSB NYC89IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Newark, NJThe #3 eng suffered an uncontained turbine blade failure during a takeoff roll. The takeoff was aborted at 120 KTS without further incident. Investigation revealed that all 12 tierods for the 2nd stage low compressor suffered a progessive failure. This…Oct 7, 1988 · N118FE · Minor damageNTSB SEA88LA191Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Troutdale, ORThe plt rprtd that soon after takeoff, he realized there was insufficient power. Subsequently, the acft mushed into trees & a raspberry field & was damaged. An exam of the eng revealed a piece of the carburetor heat muff had broken off & was ingested into the…Oct 1, 1988 · N9550W · Substantial damageNTSB BFO88FA085Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Clarksville, VAInflight loss of control as a result of pilot disorientation when the pilot tried to conduct VFR flight into IMC. Low clouds, poor visibility, fog and poor decision are contributing factors.Sep 29, 1988 · N325X · DestroyedNTSB BFO88LA086Accident · No injuriesLimited investigationFinal reportCessna 172M · Keysville, VAAircraft overran the runway after the pilot aborted the takeoff because the aircraft did not accelerate to takeoff speed. A contributing cause is inadequate prelight planning. A contributing factor is upsloping high grass covered terrain and failure to use…Sep 28, 1988 · N85012 · Substantial damageNTSB NYC88LA242Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Roscoe, NYThe plt said the eng lost power during takeoff past mid-field and he initiated an abort. The acft was unable to stop in the remaining rwy and collided with a dirt embankment past the end of the rwy. The owner of the acft is a student plt and was the passenger…Sep 26, 1988 · N4518N · DestroyedNTSB ANC88LA147Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Zacher Bay, AKThe pilot stated that during the takeoff run on the water, he lost directional control of the airplane, due to the high wind condition. The airplane's wing tip struck the water causing the airplane to nose over on its back.Sep 24, 1988 · N53546 · Substantial damageNTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…Sep 23, 1988 · N8707U · Substantial damageNTSB DEN88LA208Accident · No injuriesLimited investigationFinal reportCessna 421B · Winner, SDThe private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the…Sep 20, 1988 · N44HV · Substantial damageNTSB LAX88DUG07Accident · No injuriesFinal reportBell 47G-5A · Perris, CAOn liftoff, tail rotor control was lost and helicopter spun with main rotor striking terrain. Investigation revealed fatigue failure of engine mounting cage. The eng basket had failed and allowed the t/r drive shaft to pull out of the coupling. The basket had…Sep 18, 1988 · N4099G · Substantial damageNTSB CHI88LA239Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Celina, OHAfter 2 unsuccessful attempts to takeoff, the plt/owner tried a 3rd takeoff in his newly purchased helicopter. He rprtd that during the first 2 attempts to takeoff, he couldn't seem to get 100% of his left pedal authority. Shortly after the helicopter became…Sep 18, 1988 · N249Q · DestroyedNTSB LAX88LA320Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Truckee, CADuring takeoff roll the pilot heard a banging noise on the left wing. The pilot continued the takeoff. At 100 ft a.g.l. he executed a 180 degree turn to the right to return to land. The pilot added 30 degrees of flaps to the 10 that had been set for takeoff.…Sep 17, 1988 · N6406D · Substantial damageNTSB MKC88FA173Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Hays, KSOperation attempted with known deficiencies in equipment, and failure of the pilot to maintain directional control. A contributing factor was: the pilot's use of an improper starting procedure & the fence.Sep 16, 1988 · N1189Z · Substantial damageNTSB ANC88LA141Accident · No injuriesLimited investigationFinal reportCessna 185 · Mcclaren River, AKAccording to the pilot, the landing gear struck either a depression or an object on the riverbed/runway during takeoff roll and veered left. He corrected the deviation and continued taking off. However, when the airplane reached the end of the airstrip, he…Sep 16, 1988 · N73DA · Substantial damageNTSB ANC88LA140Accident · No injuriesLimited investigationFinal reportCessna 170B · Hope, AKThe arpt was located in an area between 2 mtns. It had two windsocks; one was at rwy level; the other was above the treetop level. The plt rprtd that the lower windsock showed the wind was favoring rwy 16, but was shifting about 45 deg to either side of the…Sep 16, 1988 · N170LA · Substantial damageNTSB ANC88LA139Accident · No injuriesLimited investigationFinal reportCessna 180B · Fairbanks, AKThe plt rprtd that drg an aborted takeoff, the acft overran the departure end of the rwy & the left main gear failed. He said he misjudged the performance of the acft, & when he aborted, there was insufficient rwy remaining to stop. Also, he believed the hi…Sep 11, 1988 · N3539E · Substantial damageNTSB MKC88LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrensburg, MOWhile practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were…Sep 10, 1988 · N1462F · Substantial damageNTSB ANC88LA136Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot was an aircraft mechanic for the operator of the airplane, and was enroute to another airport to repair a company airplane. The pilot stated that he did not do a complete job of preflighting the airplane, and attempted to takeoff with the control…Sep 10, 1988 · N6470H · Substantial damageNTSB ANC88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe commercial pilot attempted to takeoff from a rough and soft off-airport site in rural Alaska. During the takeoff roll, the airplane's main landing gear encountered an exceptionally soft spot, causing the airplane to nose over. The pilot stated that the…Sep 9, 1988 · N1759P · Substantial damageNTSB ANC88LA130Accident · No injuriesLimited investigationFinal reportCessna 182TD · September Lake, AKThe 202 hour private pilot was attempting to takeoff in a Cessna 182 converted to a conventional configuration (taildragger) from an off-airport site in rural Alaska. The pilot reported that a strong, gusty crosswind pushed the airplane off the intended track…Sep 6, 1988 · N5369B · Substantial damageNTSB ANC88LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oshetna River, AKThe pilot reported that he was attempting to takeoff from an extremely narrow and short stretch of land situated near a River. He had used this off-airport, unimproved site for several years without difficulty until the accident flight. On this occasion, the…Sep 6, 1988 · N234E · Substantial damageNTSB ANC88LA127Accident · No injuriesLimited investigationFinal reportMaule M-4 · Eureka Creek, AKDuring the takeoff roll on an upsloping gravel airstrip, the pilot lost control of the airplane. The airplane nosed over on its back. The pilot and both passengers exited the airplane without injuries.Sep 6, 1988 · N12020 · Substantial damageNTSB SEA88LA170Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Toledo, WAThe pilot aborted the first takeoff due to the engine not developing full power. After another run up, the pilot elected to make another takeoff. The pilot aborted midfield, by retarding the power and applying heavy braking, due to the aircraft not developing…Sep 5, 1988 · N9559L · Substantial damageNTSB LAX88FA307Accident · 4 fatalField investigationFinal reportCessna 172 · Grand Canyon, AZThe pilot failed to maintain control of the aircraft during nigh visual meteorological conditions. Contributing to this accident was the pilot's lack of recent experience at nigh and the lack of outside visual references due to darkness.Sep 4, 1988 · N54814 · DestroyedNTSB ANC88LA122Accident · No injuriesLimited investigationFinal reportHelio H-295 · Anchorage, AKDuring the takeoff roll on the runway at approximately 20 to 25 mph the pilot lost directional control of the airplane. The airplane looped to the right.Sep 4, 1988 · N456JH · Substantial damageNTSB MIA88LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Orlando, FLThe plt had rented the fully fueled aircraft from an FBO at orl which has hard surfaced 4600 & 6000 ft rwys. He flew to a 130 ft MSL arpt with a 2430 ft grass rwy & picked up his wife for a xc flt. He stated that the acft performed normally during the 10 min…Sep 3, 1988 · N36190 · Substantial damageNTSB NYC88LA232Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Windham, CTThe student pilot said she heard a popping sound during the takeoff roll and almost instantaneously the door came open. She tried to close the door and when that failed she attempted to abort. She retarded the throttle and attempted braking but it was not…Sep 1, 1988 · N94502 · Substantial damageNTSB FTW88LA158Accident · Minor injuriesLimited investigationFinal reportBell 206B · West Cameron 28The pilot landed the heicopter on a drilling platform and instructed the mechanic to install only the forward tie-downs. The mechanic secured the forward and aft tie-downs and secured the forward rotor blades. When the pilot returned to the helicopter, he…Sep 1, 1988 · N5747Z · DestroyedNTSB DEN88LA196Accident · No injuriesLimited investigationFinal reportCessna 182RG · Antelope Wells, NMThe commercial plt was flying three passengers to buy cattle. During takeoff from a 5,000 x 75 ft, wet gravel airstrip, the plt elected to use only the left side of the rwy to avoid mud. He used a soft field takeoff, with a nose high attitude, which limited…Sep 1, 1988 · N3184C · Substantial damageNTSB ANC88LA121Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Kukaklek, AKDuring the takeoff roll on the gravel bar the airplane crossed the gravel area on to the soft tundra. The pilot then lost directional control of the airplane. The airplane nosed over on its back.Aug 31, 1988 · N307X · Substantial damageNTSB CHI88LA227Accident · No injuriesLimited investigationFinal reportCessna 172G · Sparta, MIDuring a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness…Aug 30, 1988 · N6049R · Substantial damageNTSB MKC88LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. Louis, MOThe plt said that during a night takeoff roll, he noticed an inoperative airspeed indicator, and elected to abort the takeoff. Unable to stop in the remaining distance, the acft ran off the end of the runway onto the grass overrun collapsing the nose wheel.…Aug 29, 1988 · N97076 · Substantial damageNTSB ANC88LA116Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Hartman River, AKThe pilot had just taken off from a sand bar. During climb-out on the downwind leg, he felt the engine was not producing the proper power because the airspeed was dropping and the climb had stopped. He made a left turn and crash landed on the sand bar to…Aug 24, 1988 · N55AD · Substantial damageNTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…Aug 19, 1988 · N73089 · Substantial damageNTSB ANC88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yenta Glacier, AKDuring the takeoff roll on the gravel bar, the pilot lost directional control of the airplane causing the plane to nose over on its back. Examination of the left brake revealed that the brake was frozen with mud.Aug 18, 1988 · N2460A · Substantial damageNTSB CHI88FA205Accident · Minor injuriesField investigationFinal reportFairchild SA-226-TC · Cleveland, OHThe captain's late decision to abort after a propeller linkage failure on the right engine and the co-pilot's failure to relinquish engine and braking authority to the captain resulting in confusion and inadequate braking to stop on the runway after the abort.Aug 16, 1988 · N322BA · Substantial damageNTSB ANC88LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKDuring the takeoff roll on a gravel bar, the pilot lost directional control of the airplane & it bounced into the river. The airplane then nosed over on its back. The pilot and passenger both exited the airplane.Aug 15, 1988 · N6893B · Substantial damageNTSB NYC88LA217Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Wellsboro, PAThe pilot attempting a takeoff in an over grossed aiarcraft in high density altitude and flew off the end of the runway into high grass.Aug 14, 1988 · N979LA · Substantial damageNTSB LAX88LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Parker, AZThe pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to…Aug 14, 1988 · N9965Q · Substantial damageNTSB MKC88LA157Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Springfield, MOWhile attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short…Aug 13, 1988 · N93437 · Substantial damageNTSB ATL88DKG16Accident · No injuriesFinal reportCessna 188 · Hazel Green, ALThe plt rprtd he had flown off the strip all day & the temp had risen to 101 deg. As he was on his last takeoff, he realized the chemical load was too great for the conditions. He said he dumped part of the load, but the acft settled back to the ground.…Aug 13, 1988 · N42404 · Substantial damageNTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…Aug 11, 1988 · N4999R · Substantial damageNTSB NYC88LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Plymouth, MAThe acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear…Aug 10, 1988 · N2232K · Substantial damageNTSB MKC88FA154Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Little Rock, ARThe sked air carrier flt was aborted after the capt heard a noise and felt a vibration emanating from the left side of the acft, which at the time, was perceived as a 'blown' tire. The acft was subsequently stopped on the active rwy, and an order fm the…Aug 10, 1988 · N9060U · No damageNTSB CHI88LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Napoleon, OHThe airplane left the runway and struck a ditch during an attempted soft field takeoff. The student pilot lost directional control of the acft and, after striking a runway light on the left side of the runway, continued until he collided with the ditch and…Aug 8, 1988 · N9211U · Substantial damageNTSB NYC88LA207Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Quaker Street, NYThe Bellanca 8KCAB was making a takeoff when it veered to the right. The right main landing gear contacted a rock wall covered by weeds and the aircraft veered further right coming to rest on the right side of the runway. The pilot was unable to explain the…Aug 7, 1988 · N2502Z · Substantial damageNTSB ANC88LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Chignik, AKDuring the takeoff roll on the beach the pilot lost directional control of the aircraft. The aircraft nosed over on its back.Aug 6, 1988 · N2723V · Substantial damage