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 NYC85FA003Accident · 1 fatalField investigationFinal reportBeech V35 · Middletown, PAAbout 2 weeks before the accident, the acft was forced landed in a pasture due to a loss of power. The plt made repairs to the aircraft & attempted to fly out of the pasture. Witnesses observed the left wing come in contact with the ground during takeoff,…Oct 6, 1984 · N4447V · DestroyedNTSB DEN85FA002Accident · 3 fatalField investigationFinal reportHamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SDThe hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…Oct 5, 1984 · N127MW · DestroyedNTSB ANC84LA195Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tikchik Lodge, AKThe plt attempted a takeoff from a 500 ft sand bar and during the takeoff roll the main landing gear struck soft spots. Realizing the acft was not going to become airborne he closed the throttle attempting to stop in the remaining distance. The acft left the…Sep 30, 1984 · N411X · Substantial damageNTSB LAX84LA471Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAAccording to the pilot at 50 KTS rotation was attempted but unsuccessful. At 70 KTS the takeoff abort was initiated by reducing power. At that time the acft 'jumped' into the air at about a 45 degree nose up attitude. The pilot the pushed the yoke forward and…Sep 28, 1984 · N738PS · Substantial damageNTSB SEA84LA232Accident · No injuriesLimited investigationFinal reportGlasair None · Burns, ORDuring the takeoff ground run the aircraft drifted to right side of the rwy. Plt attempted to correct the drift using left rudder and he stated that he over corrected for the drift and the acft began to veer to the left. The acft veered left and departed the…Sep 26, 1984 · N197RL · Substantial damageNTSB LAX84LA495Accident · No injuriesLimited investigationFinal reportSchweizer G164 · Tulare, CAThe aircraft had a full load of fuel and chemicals on board for this takeoff. The pilot stated that the brakes locked on the takeoff ground run and reduced the aircrafts acceleration. A railroad cross tie barrier at the end of the runway made an on ground…Sep 25, 1984 · N10230 · DestroyedNTSB ANC84LA188Accident · No injuriesLimited investigationFinal reportMaule M-4 · King Salmon, AKThe plt stated that after he lifted the tail off the rwy the acft encountered a gust of wind and he lost control swerving into a ditch adjacent to the rwy.Sep 23, 1984 · N12023 · Substantial damageNTSB LAX84LA497Accident · No injuriesLimited investigationFinal reportChampion 7FC · Merced, CADuring takeoff the plt lost control of the acft. It veered off the rwy & collided with a dirt bank. The plt indicated that his wife may have unknowingly been applying pressure to the heel brakes during the attempted takeoff.Sep 22, 1984 · N7545B · Substantial damageNTSB CHI84LA403Accident · No injuriesLimited investigationFinal reportCessna 150H · Indianapolis, INThe plt stated that during the takeoff roll, the window popped open. At about that time, the acft began traveling to the left side of the rwy, but the plt elected to continue the takeoff. While in a nose high attitude to takeoff, the aft fuselage contacted a…Sep 22, 1984 · N22667 · Substantial damageNTSB LAX84LA486Accident · No injuriesLimited investigationFinal reportCessna 414A · Carlsbad, CAThe acft was on IFR departure in minimal weather conditions. On takeoff roll, a pwr loss occurred on the rt eng and the acft veered to the rt. PIC (owner) in left seat initiated aborted takeoff, but rt seat plt took control, continued takeoff and feathered…Sep 20, 1984 · N2700S · DestroyedNTSB DEN84FA294Accident · 1 fatalField investigationFinal reportCessna A185F · Fort Peck, MTPlt attempted to takeoff from a calm part of reservoir. The wave heights were estimated to be 4 to 6 feet. The arft struck several waves during the takeoff run. The rt wing tip dragged in the water causing the acft to nose over. The acft came to rest…Sep 20, 1984 · CGZWQ · Substantial damageNTSB ANC84LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Montague Island, AKPlt was attempting takeoff from a sand bar which was not only soft but sloped to the right toward the water. On takeoff roll, the tailwheel was raised prematurely and directional control could not be maintained with rudder. The aircraft drifted downslope…Sep 17, 1984 · N8469D · Substantial damageNTSB LAX84LA482Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Calistoga, CAThe starboard entrance hatch opened during takeoff roll. The pilot aborted the takeoff. The acft could not be stopped on the remaining rwy & collided with a ditch. The takeoff was attempted with a light tailwind on a unidirectional rwy.Sep 16, 1984 · N80504 · Substantial damageNTSB FTW84LA399Accident · No injuriesLimited investigationFinal reportCessna 172N · Katy, TXPrior to the accident the CFI and student were in the acft when it rolled into a bean field while landing on a road which divided the field. After pushing the acft back onto the road a takeoff was attempted. Directional control was lostand the acft nosed over…Sep 16, 1984 · N4858G · Substantial damageNTSB DEN84FA278Accident · 2 fatalField investigationFinal reportPiper PA-18 · Meadow Lake, NMAccording to witnesses, the plt make a x-wind apch for a landing from west to east in winds that were from the south at 10 to 12 mph. Reportedly the acft touched down with the right wing high, then the plt applied power & initiated a go-around at about…Sep 16, 1984 · N5895D · DestroyedNTSB FTW84LA397Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Flatonia, TXThe plt stated he applied full power to the eng as he started his takeoff run on rwy 15. He applied forward pressure on the control yoke to raise the tail and the acft started to drift left. The rt wing hit a tree and the acft continued into a lake.Sep 15, 1984 · N4653C · Substantial damageNTSB SEA84LA227Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kasaan Penninsu, AKPlt attempted takeoff from glassy water with a deer tied to the left float. The right float would not come up on the step to attain lift off. The pilot's decision to abort was too late to avoid a collision with rocks at the end of the lake.Sep 13, 1984 · N86922 · Substantial damageNTSB FTW84LA385Accident · No injuriesLimited investigationFinal reportCessna A188B · Maysville, OKWith aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The…Sep 11, 1984 · N9560G · DestroyedNTSB DEN84LA287Accident · No injuriesLimited investigationFinal reportCessna 140 · Belgrade, MTThe plt stated that during the takeoff ground roll on the grass airstrip the engine did not seem to produce full power when 2/3 the way down the rwy. Plt applied brakes to abort the takeoff before the tailwheel was on the ground. The acft nosed over.Sep 11, 1984 · N2628N · Substantial damageNTSB ANC84LA172Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Big Lake, AKAccording to the plt, he was taking off from a lake when he decided that he did not have sufficient room to clear trees in his flt path. He aborted the takeoff & the acft settled onto a gravel berm & slid into tundra. The plt believed that the accident would…Sep 11, 1984 · N235LY · Substantial damageNTSB ANC84LA170Accident · No injuriesLimited investigationFinal reportCessna A185F-II · Iliamna, AKThe float plane plt began taking off from a small lake in calm wind & glassy water conditions. Realizing the situation was marginal, he reduced power to abort (before lifting off) & began a step turn to the left. The plt reported that the radius of the turn…Sep 9, 1984 · N61556 · Substantial damageNTSB CHI84LA387Accident · No injuriesLimited investigationFinal reportMooney M20E · Lansing, ILThe plt had just demonstrated the acft for sale and filed an IFR flt plan. Run up and pre-takeoff checks were rushed to beat void clearance time. Just before liftoff, plt noted sluggish acceleration but believed insufficient runway remained to successfully…Sep 8, 1984 · N10SF · Substantial damageNTSB DEN84LA283Accident · No injuriesLimited investigationFinal reportCessna 140 · Butte, MTThe plt taxied to rwy 11 and got out of the acft to check the wind. The rwy lights were not operating at the time. The pilot decided that rwy 11 was the most favorable rwy and the takeoff was attempted. The wind conditions at the time off the accident were…Sep 6, 1984 · N77271 · Substantial damageNTSB ANC84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Chistochina, AKThe acft collided with a car during an aborted takeoff. The plt said that the acft would not attain flying speed so halfway down the rwy she aborted the takeoff. She also said that she and her passengers removed frost off the acft for about 25 minutes before…Sep 2, 1984 · N4362V · Substantial damageNTSB ANC84LA156Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Chandalar Lake, AKThe plt stated that during the takeoff roll aprx 1/2 way down the gravel strip, the acft went into brush off the side of the rwy. There were no reported mechanical malfunctions.Sep 2, 1984 · N5023P · Substantial damageNTSB SEA84LA214Accident · No injuriesLimited investigationFinal reportCessna 180A · Scappoose, ORThe pilot stated that during the takeoff ground run, just prior to rotation, he 'took a sharp gust of wind from the left and ground looped the aircraft.'Sep 1, 1984 · N601N · Substantial damageNTSB LAX84FUJ03Accident · Serious injuriesFinal reportCessna T337E · Chandler, AZThe plt reported that on the first attempt to rotate, the stall warning horn activated. The plt noticed the rear eng in an overboost cond so he retarded the throttle completely, then advanced it to below red line. He continued the takeoff and attempted to…Sep 1, 1984 · N1280M · Substantial damageNTSB ANC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rohn River, AKThe acft would not lift off in the distance the plt thought. The density alt was near 1500 ft and the plt had 130 lbs in the rear seat and baggage area. The plt said that the acft bounced during the roll and then ground looped.Sep 1, 1984 · N9474D · Substantial damageNTSB MKC84LA266Accident · No injuriesLimited investigationFinal reportBeech BE 58 · Bridgeport, NEPlt initiated take-off from rough, 2800 ft sod strip in light wind conditions and known high density alt situation. Slight back yoke pressure was being used during takeoff roll to moderate effect of rough surface on nose gear. Additional back pressure was…Aug 31, 1984 · N9726S · Substantial damageNTSB ANC84LA151Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bettles, AKThe acft collided with an overhanging tree branch during a river takeoff. The plt was trying to negotiate a bend in the river while on the 'step' for takeoff. The plt said he had very limited experience in the model acft and it got light on the floats and…Aug 31, 1984 · N5651D · Substantial damageNTSB LAX84LUJ02Accident · No injuriesFinal reportCessna 188A · Salome, AZThe plt said his prop stirred up a cloud of dust during takeoff and in a state of reduced visibility he collided with a mound of dirt. The collision separated the left main landing gear from the acft. Subtantial damage was done to the acft.Aug 27, 1984 · N8138V · Substantial damageNTSB SEA84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Shoshone, IDThe plt attempted takeoff from a wet alfalfa field. High vegetation and soft terrain prevented proper acceleration to lift off speed. The nosewheel struck an embankment and the aircraft nosed over.Aug 25, 1984 · N7249D · Substantial damageNTSB MIA84IA242Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Orlando, FLJust prior to V1 and rotation both left main landing gear tires failed. Takeoff was aborted and acft was stopped on rwy. Pax & crew deplaned without injury. Cause of tire failure could not be determined.Aug 25, 1984 · N411EA · Minor damageNTSB NYC84LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Manville, NJAcft swerved on rwy before rotation and climbed aprx 10 feet before settling back on the rwy. Plt aborted the takeoff but was unable to stop before end of rwy.Aug 21, 1984 · N65665 · Substantial damageNTSB NYC84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellicottville, NYThe plt started taking off from an unimproved, grass covered fld, but the acft would not accelerate above 50 KTS. He aborted the takeoff, but the acft continued off the end of the rwy where the nose gear was torn off & the left main gear & right wing tip were…Aug 19, 1984 · N4905B · Substantial damageNTSB NYC84LA282Accident · No injuriesLimited investigationFinal reportCessna 150M · Claremont, NHAfter a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,…Aug 19, 1984 · N63351 · Substantial damageNTSB DEN84LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Durango, COThe acft collided with a rwy light during takeoff. The plt said the acft got to about 6 ft AGL for about 100 ft and whenthe plt pushed foward on the control column the acft settled back on the rwy. During the roll the horizontal stabilizer hit a rwy light.…Aug 18, 1984 · N6431R · Substantial damageNTSB CHI84LA357Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Rice, MNPilot stated that during the takeoff roll the acft suddenly began to pull to the left. The pilot reduced power and applied right brake and rudder to correct but the left wing struck corn stalks. Examination of the acft after the accident revealed the left…Aug 18, 1984 · N600T · Substantial damageNTSB ANC84FA140Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt stated that he was taking off to the southeast & the acft was on the step when a x-wind hit, lifting the right wing. He said the left wing then hit the water, spinning the acft to the left & the nose hit the water. The acft went over on its back &…Aug 18, 1984 · N9062M · Substantial damageNTSB NYC84LA273Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAThe certified flt instructor (CFI) stated that he was instructing a 10 hour student pilot. He continued to state that they were doing touch and go's and had applied power for the second takeoff when the aircraft began to veer to the right side of the rwy. The…Aug 14, 1984 · N4332E · DestroyedNTSB NYC84LA272Accident · No injuriesLimited investigationFinal reportCessna 152II · E. Windsor, CTPlt failed to note inoperative airspeed indicator until well into takeoff run. When the defect was noted, takeoff abort procedures were performed but the acft continued beyond the airport boundary into a rough field and nosed over. Investigation revealed the…Aug 13, 1984 · N89980 · DestroyedNTSB LAX84FA439Accident · 1 fatalField investigationFinal reportCessna 182RG · Prescott, AZAs the acft proceeded on takeoff down the rwy, it exited the rwy on the left side over a berm into a wide shallow ditch area, then about 122 feet later the acft traveled back over the berm onto the rwy and took off. The nose then pitched up, the acft banked…Aug 13, 1984 · N6612S · DestroyedNTSB MKC84LA253Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Plains, KSThe acft collided with a tall crop during an attempted takeoff from a dirt road. The acft had failed to become airborne on another road after about 2600 ft of run and the attempt was aborted. This takeoff run was about 2800 ft according to the plt. The plt…Aug 12, 1984 · N4906Q · DestroyedNTSB FTW84LA345Accident · No injuriesLimited investigationFinal reportCessna A185F · Tomball, TXBefore takeoff 2 paxs boarded so the instructor could demonstrate to the student the effect that additional weight has on acft handling on water. According to the instructor the acft would not become airborne during takeoff. The acft overran the waterway,…Aug 12, 1984 · N802DM · DestroyedNTSB NYC84LA268Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seven Springs, PAAfter refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to…Aug 11, 1984 · N9202Y · Substantial damageNTSB FTW84LA346Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fulshear, TXOn the takeoff roll, a 'short duration cross control condition occurred' between the student and instructor pilots, resulting in the acft departing the right side of the runway, power was reduced but the acft rolled into a dirt bank and mud holes, collapsing…Aug 11, 1984 · N85625 · Substantial damageNTSB ATL84LA253Accident · No injuriesLimited investigationFinal reportCessna 152 II · Clarksville, TNThe 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the…Aug 11, 1984 · N67810 · Substantial damageNTSB ATL84FA252Accident · Minor injuriesField investigationFinal reportBoeing A75N1 · Cumming, GAThe acft experienced a partial pwr loss during takeoff. The pilot released the banner the acft was towing, made a left turn into a valley and collided with a ditch during a forced landing. Investigation revealed maintenance deficiencies in both the carburetor…Aug 11, 1984 · N1357N · Substantial damageNTSB MKC84LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot stated that during an aborted takeoff, due to an engine power loss, he was not able to stop before running off the end of the 2600 foot long runway. He said that when he felt that the airplane was ready to fly he glanced down at instrument panel and…Aug 9, 1984 · N444ZH · Substantial damageNTSB LAX84LA431Accident · Minor injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Carefree, AZThe acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…Aug 8, 1984 · N3012 · Substantial damage