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 ATL83LA137Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Fort Belvoir, VAThe aircraft was being taxied to the runway for takeoff when it was overturned by the wind. Local weather station had issued a 'point warning' of winds at 25 KTS, gusting to 35 KTS. The aircraft was taxied from its protected place behind a hangar to an…Mar 12, 1983 · N42587 · DestroyedNTSB DEN83LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe aircraft piloted by a solo student ran off the runway and nosed over in a snow bank during landing. The pilot was practicing short field landings. The accident occurred during the first touch and go. The landing was good and the pilotretracted flaps to 10…Mar 10, 1983 · N46546 · Substantial damageNTSB LAX83LA145Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-33A · Fremont, CAThe acft banged into the ground during the takeoff ground run. The glider had swerved off the rwy during the tow into a muddy grass area, the plt attempted a premature takeoff to prevent getting struck in the mud. He stated that lack of forward speed and the…Mar 7, 1983 · N7547 · Minor damageNTSB ATL83LA130Accident · No injuriesLimited investigationFinal reportRockwell Intl S-2R · Marshallville, GAThe plt reported that he was taking off with a load of fertilizer from a newly constructed strip that was wet and soft. He stated that he failed to clear a mud-hole at the end of the strip, the wheels mired in the mud, and the acft nosed over.Mar 7, 1983 · N8515V · Substantial damageNTSB CHI83LA128Accident · No injuriesLimited investigationFinal reportCessna 150D · Wilmington, OHThe aircraft operated by a student pilot swerved off the runway during a touch and go landing and nosed over. The pilot had been practicing touch and go landing for about 40 minutes preceding the accident. During the last landing he toucheddown in a crab and…Mar 5, 1983 · N3064S · Substantial damageNTSB ANC83LA051Accident · No injuriesLimited investigationFinal reportCessna 150M · Chugiak, AKThe student plt & his instructor had just completed a dual instruction flt & the student was on his 1st solo. He took off from the uncontrolled arpt which had snow on the rwy, except the middle 10 ft of the rwy was clear & dry. As the student was in the…Mar 3, 1983 · N704VT · Substantial damageNTSB NYC83FHJ01Accident · Minor injuriesFinal reportHarrison Volmer VJ-22 Amphibian · Schinnecock Bay, NYWhile gaining speed on step to make water takeoff the hull of the aircraft collided with something not seen in the waterand began to sink. The aircraft filled with water and sank until it rested on the bottom with only the prop tip showing the weather was VFR…Feb 27, 1983 · N3509 · Substantial damageNTSB DEN83LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Havre, MTThe plt reported that he was taking off from a dirt strip on his farm to check on some cattle from the air. During the takeoff roll, the left main gear went into some mud & pulled the acft to the left. Subsequently, the acft contacted frozen dirt piles & some…Feb 26, 1983 · N7917S · Substantial damageNTSB FTW83LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Midlothian, TXWhile on a local flt, the plt noticed fluctuating oil pressure & elected to make a precautionary landing in a field. He stated that after landing, he checked the oil & ran up the eng, but noted no malfunctions, so he elected to takeoff again. While attempting…Feb 25, 1983 · N6164W · Substantial damageNTSB DEN83LA066Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cut Bank, MTThe acft nosed over after overrunning the end of the runway during an aborted takeoff. The runway was grass and there was a 90 degree crosswind. During takeoff a downdraft put the acft back on the ground. The pilot decided to abort the takeoff and retarded…Feb 25, 1983 · N9929T · Substantial damageNTSB FTW83LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Sugarland, TXThe student plt had become lost & landed on a dirt road to ask for directions back to his home arpt. After receiving directions, he turned the acft around & started to takeoff. However, before reaching flying speed, the acft struck a partially buried pipe &…Feb 23, 1983 · N66730 · Substantial damageNTSB NYC83LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe turf rwy was wet from melting snow with snowbanks on both sides. The plt decided to take off from the left side staying clear of mud. Acceleration was slower than normal due to the wet grass & as the plt tried to rotate a loud bang was heard. The plt…Feb 21, 1983 · N757ER · Substantial damageNTSB NYC83LA067Accident · No injuriesLimited investigationFinal reportMooney M20E · Butler, PAAfter landing on rwy 25 the plt exited onto a taxiway near midfield to wait for another acft departing rwy 7. The wind was calm & the plt elected to depart rwy 7 as did the other acft. The gear was prematurely retracted during the takeoff roll.Feb 19, 1983 · N2694W · Substantial damageNTSB LAX83FA104Accident · 5 fatalField investigationFinal reportPiper 601P · San Diego, CAWhile taking off, the acft climbed aprx 100 to 200 ft, then began loosing alt. During a forced landing on a street, it hit a parked car & a light pole & burst in flames. The plt, who later expired, said that neither eng developed full power (2575 RPM). He…Feb 18, 1983 · N90353 · DestroyedNTSB FTW83LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Winslow, ARDuring dual instructional flt, the student plt was practicing a short field takeoff. After lifting off into ground effect, he elected to abort the takeoff when he did not think the acft was accelerating fast enough. The instructor pilot (CFI) stated that he…Feb 17, 1983 · N9981W · Substantial damageNTSB ATL83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Leonardtown, MDPilot did not maintain alignment during takeoff and collided with a pile driver. The aircraft was then landed gear up inan adjacent field. The wind was calm and there was no known reason for failure to maintain runway alignment.Feb 15, 1983 · N8425T · Substantial damageNTSB MIA83FA074Accident · 2 fatalField investigationFinal reportRockwell 690A · Winter Haven, FLThe acft crashed into a ditch off the departure end of the rwy and burst into flames during takeoff. Witnesses said the acft did not sound like it was developing normal RPM for takeoff. One mechanic said the engines sounded like they were still in ground idle…Feb 13, 1983 · N81416 · DestroyedNTSB CHI83LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Bellefontaine, OHThe acft ground looped off the runway during a takeoff. The solo student said he encountered nosewheel shimmy during thetakeoff roll. He raised the nose to stop the shimmy and looked at his airspeed indicator. At about that time, the acft weathervaned to the…Feb 13, 1983 · N5089P · Substantial damageNTSB ANC83FAG04Accident · No injuriesFinal reportCessna 140 · Iliamna, AKThe aircraft collided with some hidden obstructions during an aborted takeoff. Th pilot realized his heavily loaded aircraft was not accelerating fast enough and aborted the takeoff. After turning left to avoid some metal drums, the aircraft collided with a…Feb 12, 1983 · N7G · Substantial damageNTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…Feb 11, 1983 · N1461G · Substantial damageNTSB ANC83IA044Incident · No injuriesIncident investigationFinal reportCessna 207A · Kwigillingok, AKWhile on takeoff the right main landing gear broke through the crust of a snow drift. The aircraft then veered to the right into a snowbank.Feb 9, 1983 · N75551 · Minor damageNTSB ANC83IA043Incident · No injuriesIncident investigationFinal reportCessna 207A · Kivalina, AKThe acft departed the left side of the runway on its takeoff roll due to misting or frosting of the windshield reducing visibility. The phenomenon is common to the area. The rwy is in poor condition with precautions to use the center only for takeoff &…Feb 9, 1983 · N73100 · Minor damageNTSB LAX83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-32 · So. Lake Tahoe, CAThe takeoff was initiated downwind on runway 36, which was 8544 ft long and was wet. The field elevation was 6264 ft. the aircraft was observed by tower personnel to rotate about 3000 ft down the runway, then climb to about 50 ft AGL. The pilot elected to…Feb 7, 1983 · N4069R · Substantial damageNTSB MIA83LA067Accident · No injuriesLimited investigationFinal reportPace THORP-T-18 · Tampa, FLThe acft drifted left during takeoff and collided with a VASI light. The pilot stated to a witness that he knew he was going left but thought he would be airborne before leaving the runway. The left rudder cable was frayed and broke sometime in the takeoff…Jan 31, 1983 · N679JB · Substantial damageNTSB ATL83LA094Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dyersburg, TNThe helicopter crashed shortly after takeoff on a solo training flight. The weather was VMC and no flight plan was filed. The pilot was uninjured. The pilot lost directional control at liftoff and started drifting toward parked acft. He attempted to go over…Jan 31, 1983 · N9069N · Substantial damageNTSB NYC83LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Bridgeport, CTAfter practicing three takeoffs and landings, a fourth takeoff was aborted. The student completed a run-up, checked the controls and received clearance to takeoff. He stated that he began rolling straight down the centerline, then at about 45 KTS, the plane…Jan 30, 1983 · N62264 · Substantial damageNTSB LAX83LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Lake Wohlford, CAThe acft ran off the departure end of the runway during an aborted takeoff and nosed over. The pilot started a takeoff on a 1500 foot dry runway. After about 1000 feet of runway had been used the pilot decided to abort the takeoff. Brakes were applied and the…Jan 30, 1983 · N517OK · Substantial damageNTSB NYC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student plt was taking off on rwy 08 with a wind from the northeast at 11 KTS. He reported that he was aprx 100 ft into the takeoff roll when the acft swerved to the left. Subsequently, the acft collided with a snowbank on the left edge of the rwy.Jan 28, 1983 · N6279P · Substantial damageNTSB FTW83LA099Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Isle B43qDue to the location of a gas separator, the plt started to takeoff from an oil rig platform with a left cross- wind at aprx 30 KTS, gusting 35 to 40 KTS. After lifting off to a hover, wind gusts were encountered. The plt reported that the acft turned 10 to 15…Jan 27, 1983 · N5012T · Substantial damageNTSB CHI83FA092Accident · No injuriesField investigationFinal reportObryon Mustang II · West Chicago, ILThe home built acft was on its 1st flt after being constructed. The takeoff was initiated on rwy 33 with the wind from 030 deg at 10 KTS. The plt reported that during the takeoff, the right wing lifted, but the left wing would not come up. When control became…Jan 26, 1983 · N77HJ · Substantial damageNTSB LAX83LA078Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Yucca Valley, CAThe pilot was attempting a takeoff from Yucca Valley airport when he lost control of the aircraft and it swerved off therunway into a wash where it flipped over onto its back. The pilot said he encountered a dust devil which made the aircraft uncontrollable.…Jan 21, 1983 · N9923K · DestroyedNTSB NYC83LA053Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · New Cumberland, PADuring the takeoff roll at about 117 KTS, the acft began to vibrate, pull to the left and decelerate. The takeoff was aborted. The acft continued off the left side of the rwy and came to stop against a small embankment. An exam of the rwy reveal tire markings…Jan 19, 1983 · N250RA · Substantial damageNTSB LAX83LA075Accident · No injuriesLimited investigationFinal reportCessna 188 · Five Points, CAThe pilot lost control of his aircraft during takeoff in a cross wind. The aircraft ground looped collapsed the right main landing gear and nosed over. The agricultural operations were canceled at this provisional strip because of wind and the aircraft was…Jan 18, 1983 · N5636J · Substantial damageNTSB DEN83FA049Accident · 1 fatalField investigationFinal reportRobinson R22 · Sisseton, SDThe helicopter crashed in an open field shortly after takeoff in adverse weather. The pilot was not instrument rated andhad received weather briefings by telephone from a flight service station. The forecast was not favorable, but the pilotstated 'well I…Jan 15, 1983 · N9079B · DestroyedNTSB SEA83FA040Accident · No injuriesField investigationFinal reportBell 206B · Newport, ORThe helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a…Jan 12, 1983 · N644PH · Substantial damageNTSB FTW83LA081Accident · No injuriesLimited investigationFinal reportCessna 170A · Temple, TXThe student plt reported he was taking off, directly into the wind, when directional contorl was lost. Subsequently, the acft veered off the left side of the rwy & the right gear failed.Jan 11, 1983 · N1781D · Substantial damageNTSB ATL83LA087Accident · No injuriesLimited investigationFinal reportLockheed 18-56 · Madison, GAThe plt reported that after he taxied to the rwy, the #1 oil temp was not up to the minimum temp. He set the parking & advanced the #1 throttle to 1500 RPM until the engine warmed up. When both oil temps were within limits, he advanced both throttles to 30…Jan 11, 1983 · N520R · Substantial damageNTSB ANC84LA001Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Togiak, AKAccording to the plt, he was assisted by a wing walker while taxiing to the takeoff position. The wind had been increasing steadily during his stop & it changed direction as he arrived at the takeoff position. As he turned the acft into position on rwy 27,…Jan 6, 1983 · N4924E · Substantial damageNTSB FTW83LA073Accident · No injuriesLimited investigationFinal reportBeech V-35B · Big Spring, TXThe aircraft crashed shortly after takeoff from a slush-covered runway. The pilot stated that preflight, engine start, taxi and run up were normal. He further stated that takeoff from the slush covered runway was routine to an altutide of approx 200 ft AGL…Jan 2, 1983 · N9435Q · Substantial damageNTSB MKC83LA050Accident · No injuriesLimited investigationFinal reportCessna 182P · Maryville, MOAircraft ran off runway during takeoff. Pilot said he was unable to control veer and the aircraft continued off into soft terrain and nosed down.Jan 1, 1983 · N58664 · Substantial damageNTSB ANC83LAG01Accident · No injuriesFinal reportCessna 152 · Chugiak, AKThe student pilot reported that he was practicing touch-and-go landings on a runway with patches of ice. He stated that on his second touch-and-go, he touched down to the right of the centerline. Reportedly, he retracted the flaps, added full power, and…Dec 31, 1982 · N68291 · Substantial damageNTSB ANC83LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunapitchuk, AKThe aircraft was taking off from a frozen seaplane landing area when it struck several snow banks and crashed. The pilot stated that he had selected an area of ice, about 1100 ft long, and began taking off in an 8 kt crosswind with 6 passengers on board.…Dec 31, 1982 · N4246T · Substantial damageNTSB MIA83FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Ft. Lauderdale, FLThe aircraft crashed while the pilot was apparently attempting to return to land after takeoff. No radio calls were made, but landing gear had been lowered. High speed and excessive rate of descent are not consistant with a normal or even emergency attempt to…Dec 30, 1982 · N4055C · DestroyedNTSB ATL83LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nelly'S Ford, VADuring takeoff roll the aircraft swerved to the left. The pilot applied full right rudder but was not able to straighten the aircraft. The pilot reduced the power and applied brakes. The aircraft collided with a fence at the end of the runway. Fifteen knot…Dec 25, 1982 · N32804 · Substantial damageNTSB SEA83IA034Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Klamath Falls, ORDuring takeoff on runway 14 with the winds from 310 deg at 17 knots, satisfactory acceleration occurred through 70 knots followed by a slowing rate of acceleration at 80 knots. The captain then reduced power and shortly thereafter felt the left main tires…Dec 23, 1982 · N5475M · Minor damageNTSB ATL83LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Benning, GAStudent was doing a touch and go landing. While changing flap, carb heat and applying full throttle aircraft veered left. Recovery was attempted throttle off but aircraft left runway and collapsed nose gear, before flipping over.Dec 23, 1982 · N129SC · Substantial damageNTSB NYC83LA046Accident · No injuriesLimited investigationFinal reportBeech 56TC · Gasport, NYDuring the takeoff roll from a snow covered runway the aircraft slid to the left of the runway and into a snow bank. The left main and nose gear collapsed.Dec 21, 1982 · N12WB · Substantial damageNTSB DEN83LA036Accident · No injuriesLimited investigationFinal reportSwearingen SA-227AC · Gillette, WYDirectional control was lost in the early stage of the takeoff roll. The acft departed the rwy 400 ft down the rwy & travelled 85 ft off the side of the rwy. One rwy light was destroyed. The acft had come from the factory equipped with an anti-skid brake…Dec 21, 1982 · N2671V · Substantial damageNTSB LAX83LVW02Accident · No injuriesFinal reportPiper PA-28-161 · Beatty, NVThe pilot landed on a 1700 long strip at the elevation of about 3500 ft MSL. He elected to takeoff to the north in calm wind conditions and avoid sun glare off the cover of his engine and on the windshield. He stated that soft field procedures were used in…Dec 19, 1982 · N8154X · Substantial damageNTSB MIA83LA052Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · New Port Richey, FLAccording to the instructor (CFI), the tail wheel equipped aircraft veered left and headed toward trees after the tail rose, but while the main wheels were still on the ground. He attempted to recover with right rudder and brakes. Fearing a ground loop, the…Dec 18, 1982 · N88214 · Substantial damage