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 SEA84LA073Accident · No injuriesLimited investigationFinal reportCessna 152II · Preston, IDThe solo student plt was making a takeoff after a touch-and-go landing. The acft swerved to the left, collided with a snowbank, and nosed over.Mar 16, 1984 · N48757 · Substantial damageNTSB DEN84LA110Accident · No injuriesLimited investigationFinal reportHiller FH 1100 · Provo, UTThe acft was landed in soggy terrain and the right skid sank into the surface. One of the occupants of the helicopter deplaned to'lighten the load'and the plt overcorrected in an attempt to takeoff. The acrt rolled over onto its left side.Mar 16, 1984 · N5042F · Substantial damageNTSB LAX84IA219Incident · No injuriesIncident investigationFinal reportBeech C-45G · Ontario, CAA Beech E18S, N3657G, operating as federal express flt 954L, was cleared for takeoff on rwy 8L after a Boeing 747, N8172G, operating as interflight 429, was cleared to cross the same rwy. The Boeing 747'S cargo included race horses. The Boeing crew were…Mar 15, 1984 · N3657G · No damageNTSB ATL84LA121Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Warrenton, VAThe CFI shut down one engine during takeoff for a simulated emergency and the plt taking instruction applied the incorrect rudder action during the aborted takeoff and left full power on the operating right engine. The CFI was unableto correct the resulting…Mar 15, 1984 · N63857 · Substantial damageNTSB ATL84LA139Accident · No injuriesLimited investigationFinal reportCessna 150F · Bardstown, KYThe CFI flew one pattern with the student and sent him solo. During the attempted takeoff the acft veered off the rwy & hit a dirt bank. The student said the rudder pedals would not move. Reportedly a wrench was found jammed in the rudder pedals. Some…Mar 14, 1984 · N7717F · Substantial damageNTSB FTW84LA173Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Blanco, TXAccording to the plt, the acft was standing unattended with the eng running at 1000 RPM when an inexperienced person attempted to shut down the eng. He reportedly pushed the throttle in, instead of pulling it out & the acft jumped the chocks. According to 2…Mar 12, 1984 · N4004C · DestroyedNTSB ANC84FA043Accident · Minor injuriesField investigationFinal reportCessna 207A · Crooked Creek, AKThe plt was using soft field procedures to takeoff from a 1600 ft dirt/gravel strip. The strip was wet & soft from melting snow, it sloped downhill with a 3% slope & 15 to 20 ft trees were located at the departure end. Also, the plt reported there were 3…Mar 12, 1984 · N7350U · Substantial damageNTSB LAX84LA218Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sonoma, CAThe student plt had previously soloed on 12/4/83 & had accumulated about 30 hrs of total time of which 3.7 hrs were solo. Just prior to the accident flt, the student's instructor had flown with him & he had completed 4 landings on that flt. The student then…Mar 11, 1984 · N23882 · Substantial damageNTSB CHI84LA126Accident · No injuriesLimited investigationFinal reportBeech BE-90 · Columbus, OHWhile taking off on rwy 27L, the acft contacted a ridge of snow at the intersection of rwy 14, where rwy 14 had been plowed. After striking the snow, the acft drifted to the right & the plt noted a reduction of power from the right eng. The right main gear…Mar 11, 1984 · N642DH · Substantial damageNTSB LAX84LA214Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Willcox, AZAn unknown person attempted to steal the acft. The acft was taxied out from its tie-down spot & accelerated down the mile-long dirt rwy. It failed to become airborne, impacted 5 fences, a power pole & came to rest inverted. The injury index is presumed.Mar 10, 1984 · N52488 · DestroyedNTSB FTW84LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Braithwaite, LAThe plt said that when he applied power for takeoff he overcorrected and the acft veered right. He attempted to abort but saw a ditch and reapplied power. The acft hit the ditch and collapsed the landing gear. The plt thought maybe the brakes locked but an…Mar 3, 1984 · N7368H · Substantial damageNTSB NYC84FA096Accident · Serious injuriesField investigationFinal reportCessna A185F · Waitsfield, VTThe acft collided with trees during takeoff. The rwy was snow covered 4 to 6 inches deep and was only 1800 ft long. The takeoff was on a bearing of 130 degrees. The wind was from 280 degrees at 14 KTS. The skis on the acft had wheels protruding through at the…Mar 2, 1984 · N4643C · DestroyedNTSB MKC84LA090Accident · No injuriesLimited investigationFinal reportRobert H. Low Mustang II · Des Moines, IAOne of the purposes of the flt was for the plt to experience a takeoff at max gross wt. He put a 150 lb bag of cement in the right front seat to simulate the wt of a passenger, then initiated a takeoff from a sod rwy that was soft after a recent thaw, using…Feb 25, 1984 · N53BL · Substantial damageNTSB LAX84LA192Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe acft ran off the left side of the rwy during the takeoff portion of a touch and go landing. After colliding with a ditch the acft nosed over.Feb 22, 1984 · N24971 · Substantial damageNTSB LAX84IA188Incident · No injuriesIncident investigationFinal reportCessna 152 · Riverside, CAN6496M executed a takeoff on taxiway 'a' & collided with Cessna N7831F holding short of rwy 09 at taxiway 'h'.Feb 21, 1984 · N6496M · 2 aircraft · Minor damageNTSB MKC84LA078Accident · No injuriesLimited investigationFinal reportGulfstream American AA5B · Papillion, NEThe plt overran during an attempted takeoff on the water covered rwy. The acft failed to attain the proper airspeed for lift off. During the overrun the nose gear sheared off. The plt said the standing water on the turf rwy prevented proper acceleration.Feb 20, 1984 · N28673 · Substantial damageNTSB NYC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Hastings, NYThe acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear…Feb 12, 1984 · N3264P · Substantial damageNTSB CHI84LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Cleveland, OHThe passenger reported that on takeoff he heard a bang & saw a puff of blue smoke. The plt pulled the pwr off but did not lower the nose so the passenger, who had flt experience, pushed the nose forward & impacted the rwy. Post crash examination of the eng…Feb 11, 1984 · N1987Y · Substantial damageNTSB SEA84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Burns, OROn departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed.Feb 10, 1984 · N16333 · Substantial damageNTSB SEA84LA051Accident · No injuriesLimited investigationFinal reportCessna 172 Rgii · Seattle, WADuring a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft…Feb 10, 1984 · N9557B · Substantial damageNTSB DEN84LA088Accident · No injuriesLimited investigationFinal reportMooney M20C · Angel Fire, NMThe plt reported that during takeoff, the acft slowed as it hit patches of slush. He lifted off at the end of the rwy & retracted the gear while in ground effect. The acft would not maintain flying speed & settled in snow. It then went thru a fence beyond the…Feb 10, 1984 · N6210U · Substantial damageNTSB CHI84LA103Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Logansport, INThe plt stated that the acft eng was running rough at rotation. He climbed to approx 300 ft AGL and began a left trafficpattern back to rwy 27. A landing was made 225 ft short of the rwy. During the post-accident eng run-up the eng started easily and ran…Feb 6, 1984 · N2514V · Substantial damageNTSB DEN84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dixon, WYThe acft began to wander back & forth across the rwy on the takeoff roll. The CFI took control as the acft veered to theleft. The left wheel hit a snowbank & the acft ground looped to the left substantially damaging the right wing before coming to rest. There…Feb 3, 1984 · N3553A · Substantial damageNTSB DEN84LA080Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe plt noticed the throttle sticking on takeoff and tried to abort the takeoff but the throttle was binding. The acft tookoff at a below normal speed and had to be landed. Subsequently, the acft impacted the ground & several trees. An engineer said the…Feb 1, 1984 · N4096B · Substantial damageNTSB CHI84LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Lone Rock, WIDuring the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over.Jan 31, 1984 · N25216 · Substantial damageNTSB DEN84LA078Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Billings, MTThe plt stated that during takeoff a gust of wind blew the acft to the right and he decided to abort the takeoff. Duringthe abort the acft departed the rwy, went down a bank and came to rest upside down.Jan 30, 1984 · N6741H · Substantial damageNTSB DCA84AA015Accident · 3 fatalFinal reportSwearingen SA226TC · Terre Haute, INAfter taking off from rwy 23, the acft crashed ssw of the arpt about 6300 ft from the departure end of the rwy & about 1800 ft to the left of the rwy centerline. Impact occurred while the acft was in a steep descent. The wreckage path was scattered along a…Jan 30, 1984 · N63Z · DestroyedNTSB LAX84LA172Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Camarillo, CAAccording to witnesses, the plt had been drinking & decided to prove to his friends that he could fly a helicopter. Reportedly, he 'threw on a bunch of switches, and got the engine started.' When he attempted the takeoff, the helicopter rolled over on its…Jan 28, 1984 · N2045U · DestroyedNTSB NYC84LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashua, NHThe helicopter left skid hooked on the guard rail as takeoff began from a trailer. As the plt continued to increase power to lift, the acft rolled over and the main rotor hit the hood of the tractor.Jan 27, 1984 · N8431Y · Substantial damageNTSB CHI84LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · West Bend, WIThe acft went out of control during the takeoff roll after a touch and go landing. The plt stated that, as he applied power and went to raise the flaps the acft began to drift to the left. When he applied right rudder the acft began to skid to the right. He…Jan 26, 1984 · N63178 · Substantial damageNTSB CHI84IA093Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILAs the capt applied power & released brakes to begin the takeoff, the acft started to drift to the right. The capt stated that he closed the throttles & put the #1 & #2 throttles in reverse. The acft then began to veer left & spun around nearly 1-1/2 times.…Jan 24, 1984 · N8081U · Minor damageNTSB SEA84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Klamath Falls, ORThe plt attempted a takeoff on a slushy soft rwy. The takeoff was aborted at the rwy midpoint due to lack of acceleration. During the abort the acft collided with a fence and nosed over. The plt thought the rwy conditions and carburetor ice.Jan 22, 1984 · N99620 · Substantial damageNTSB NYC84IA071Incident · Serious injuriesIncident investigationFinal reportBoeing 747-230 · Jamaica, NYAt the time of the incident, rwy 31L was the only active rwy. Aprx 9 snow removal vehicles were being used to remove snow from rwy 4L/22R. The vehicle drivers were instructed to hold short of rwy 31L, then Boeing 747, d-abyo, was cleared for takeoff. The plt…Jan 18, 1984 · DABYO · No damageNTSB ATL84LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Beckley, WVDuring the takeoff roll the acft traveled about 2400 ft before starting a drift to the left. It covered another 425 ft prior to colliding with a snow bank shearing off the nose gear & collapsing both main landing gear. The rwy was covered with about 4 inches…Jan 18, 1984 · N8461H · Substantial damageNTSB CHI84LA085Accident · No injuriesLimited investigationFinal reportCessna 140 · Huntley, ILThe student plt allowed the acft to drift left during takeoff in spite of verbal instructions by the CFI to correct the situation. The acft continued toward a snowbank and the CFI did not take corrective action on the controls in time to avoid a collision…Jan 15, 1984 · N76310 · Substantial damageNTSB MIA84LA061Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Pensacola, FLDuring takeoff, the eng began losing power at about 200 ft AGL. The plt applied carb heat & began a descent. Power was restored for about 5 sec, then all power was lost. The acft was landed straight ahead in a wooden swampy area & was substantially damaged.…Jan 13, 1984 · N42774 · Substantial damageNTSB LAX84LA137Accident · No injuriesLimited investigationFinal reportRockwell 114 · Las Vegas, NVThe acft veered off the rwy in a strong gusty crosswind. As the acft left the rwy the landing gear collapsed. The plt stated that she over-corrected having never attempted a takeoff in wind that strong.Jan 11, 1984 · N50BG · Substantial damageNTSB CHI84LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIThe student plt lost control of the acft on a snowy rwy and collided with a snowbank. The student added power for takeoff after a touch and go landing and the acft veered to the left. The acft was not corrected before a collision witha snowbank occurred. This…Jan 11, 1984 · N63546 · Substantial damageNTSB DEN84LA101Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Fortuna, NDThe plt made an off arpt landing on upward sloping terrain which was covered with aprx 4 inches of snow. About 1/2 hr later, he initiated a takeoff on a different section of the field on downward sloping terrain. The snow in that area was initially 4 inches…Jan 4, 1984 · N314X · Substantial damageNTSB LAX84LA128Accident · No injuriesLimited investigationFinal reportBeech C-45H · Coolidge, AZThe plt stated that during the initial application of power, the left eng backfired due to a possible too sudden application of power. He said that due to 'inattention' he let the acft 'drift to the left side of the runway.' Just after the acft became…Jan 2, 1984 · N3736G · Substantial damageNTSB DEN84LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Limon, COThe student plt on his 2nd supervised solo flt. After returning from te local practice area, he entered the traffic pattern for a touch-&-go landing. When he added power for the takeoff portion. The acft veered to the left. The left main wheel entered deeper…Jan 2, 1984 · N1667Q · Substantial damageNTSB MKC84LA055Accident · No injuriesLimited investigationFinal reportMooney M20C · Pittsburg, MOThe acft ran off of the snow covered rwy into trees after an attempted downwind takeoff. The plt had packed the 8 inch snow by driving his car on the rwy. During the aborted takeoff the plt was unable to stop the acft before tree contact.Jan 1, 1984 · N2998L · Substantial damageNTSB MKC84LA054Accident · No injuriesLimited investigationFinal reportCessna 182 · Marion, IAThe acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted.Jan 1, 1984 · N3641C · Substantial damageNTSB NYC84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Mifflin, PADuring the cockpit preflight the plt noticed an unsafe nose gear indication. The plt checked the nose gear & could see nothing unusual, & concluded that there was a faulty indicating system. During rotation the nose gear collapsed & this acft slid down the…Dec 29, 1983 · N14360 · Substantial damageNTSB CHI84LA068Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INThe acft ran off the snow covered rwy into soft ground and collapsed the nose gear. The plt said that during acceleration for takeoff he felt the left main landing gear go off the left side of the rwy. He reduced power but by this time the gear was in soft…Dec 28, 1983 · N54828 · Substantial damageNTSB NYC84FA061Accident · Serious injuriesField investigationFinal reportAerospatiale SA-360C · Newark, NJThe helicopter arrived at the Newark intl arpt at 1531 after an uneventful flt from new york, NY with 2 en route stops. At 1540, the plt taxied from the passenger gate for departure. According to him, he had no control problems, while taxiing. He checked the…Dec 27, 1983 · N360CP · Substantial damageNTSB MIA84LA050Accident · No injuriesLimited investigationFinal reportCessna 210 · Ft. Myers, FLDuring tkof roll abt halfway down the rwy the plt noticed the acft was not accelerating normally. Aft liftoff he atmptd to return to the arpt however was forced to ditch the acft in the caloosahatche river due to a loss of pwr. Exam of the eng revealed that…Dec 23, 1983 · N9510T · DestroyedNTSB DCA84AA013Accident · Serious injuriesFinal reportMcDonnell Douglas DC-10-30CF · Anchorage, AKA Piper PA-31, N35206, (south central air flt 59) was cleared to taxi to rwy 6L. The wx at that time was foggy with about 1/8 mi vsiibility, but the RVR was improving & the arpt was expected soon to be acceptable for takeoffs. The PA-31 crew taxied & waited…Dec 23, 1983 · H7339 · 2 aircraft · DestroyedNTSB LAX84LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Rosa Island, CAAccording to the plt, the nose of the acft felt heavy just before lift-off & when he became airborne. He felt something was wrong with the tail of the acft & that he was unable to obtain full elevator response, so he aborted the takeoff. The acft rolled 300…Dec 22, 1983 · N2697K · Substantial damageNTSB MKC84LA043Accident · No injuriesLimited investigationFinal reportGates Learjet 25 · Kansas City, KSDuring takeoff on a snow covered rwy at night the aircraft ran off the left side of the runway & was damaged. At that time, the rwy was covered with a thin layer of dry snow over the top of hard packed snow. A 50 ft strip had previously been plowed along the…Dec 21, 1983 · N242AG · Substantial damage