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 ANC85LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Bethel, AKThe pilot reported that during the takeoff roll the aircraft could not obtain airspeed and the aircraft lost directional control striking a snow bank at the departure end of the runway.May 3, 1985 · N4246T · Substantial damageNTSB LAX85LA247Accident · No injuriesLimited investigationFinal reportCessna 182P · Oasis, CATo accomodate his pax's request to be transported close to his destination, the plt landed the acft on a 350 foot-long dirt road. The pax disembarked & the plt attempted to take off on the same road. The acft became airborne in grnd effect, climbed aprx 5 ft…May 1, 1985 · N58613 · Substantial damageNTSB LAX85LA235Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Mesa, AZFollowing a dural engine chang, the plt test flew the acft. On initial climb, at about 500 ft AGL, both engines began backfiring violently & lost power. According to the plt, power sufficient for flt could not be obtained, & a forced ldg was made about 0.75…May 1, 1985 · N7415C · Substantial damageNTSB MIA85IA155Incident · Minor injuriesIncident investigationFinal reportGrumman G-73-T · St. CroixWhile on an FAA observed proving flight, water take off, the left propeller electrical terminal failed. The part then penetrated the left forward passenger window and struck the FAA observer causing minor injury. The plastic part failed in over load due to…Apr 24, 1985 · N632SS · Minor damageNTSB ANC85LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Beluga, AKThe plt stated that the right ski hit something during the takeoff run & bent the right main gear/ski down & aft. He elected to land on snow covered terrain near the small village of Beluga, AK. Before coming to rest during the landing, the acft went over on…Apr 24, 1985 · N1827A · Substantial damageNTSB MIA85LA154Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Myers, FLPlt stated that on takeoff ground run from a turf runway he felt severe vibration in the nose gear and lifted it off the ground. As he did he thought he felt a loss of engine power an aborted the takeoff. Before the aircraft could be stopped it overran the…Apr 22, 1985 · N739DA · Substantial damageNTSB ATL85LA205Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Union City, TNPilot with 7900 total hours and four hours in gyoplane was on solo cross country training flight. During takeoff at enroute stop rotor blades struck vertical stabilizer. Pilots instructor said witnesses reported that the gyroplane was rotated abruptly during…Apr 21, 1985 · N4374G · Substantial damageNTSB MKC85LA085Accident · No injuriesLimited investigationFinal reportCessna 177B · Alliance, NEAcft collided with ditch at end of strip while aborting takeoff. Takeoff was being made from a 2200 ft long dirt farm strip. The strip had a slight upslope and the density altitude was 6,800 ft. wing flaps were found in retracted position after the accident.Apr 18, 1985 · N34908 · Substantial damageNTSB ANC85FA063Accident · No injuriesField investigationFinal reportPiper PA-12 · Anchorage, AKDuring takeoff roll acft veered left off rwy, hit a snow bank and nosed over onto its back. Acft was 265 lbs over gwt. Two pax were in rear seat. Rear control stick was installed. There was a 10 kt right x-wind.Apr 17, 1985 · N3153M · Substantial damageNTSB ANC85LA062Accident · No injuriesLimited investigationFinal reportCessna 207 · Port Graham, AKThe plt lost directional control while taking off from a rwy covered with 4 to 6 inches of snow, ice & slush. The acft then swerved sideways, collided with a snow bank & was damaged. The arpt was located on public domain & was not regularily attended or…Apr 15, 1985 · N9970M · Substantial damageNTSB NYC85LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Kintnersville, PAThe pilot decided to abort the takeoff when he realized that too much runway was being used. During the rollout, the pilot began to turn the aircraft to the right. The wind lifted the tail of the aircraft until it nosed over onto its back.Apr 9, 1985 · N7073A · Substantial damageNTSB FTW85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Carney, OKPlt attempted to abort takeoff from grass strip mowed in pasture. Plt lost control and acft received substantial damage when it ran off rwy and collided with dirt bank rwy estimated to be between 1,000 ft to 1200 ft long.Apr 6, 1985 · N8052T · Substantial damageNTSB DEN85LA110Accident · Minor injuriesLimited investigationFinal reportCessna 310N · Abiquiu, NMThe pilot attempted to takeoff from a rough, unimproved airstrip with a 3% uphill gradient, high density altitude, and gusty crosswind conditions. During the takeoff roll, the pilot lost directional control, lifted the airplane off the ground, cleared a…Apr 3, 1985 · N5060Q · DestroyedNTSB DEN85LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Logan, UTThe acft departed the rwy during a touch and go landing. The plt stated that after touchdown, the acft pulled to the right. The acft impacted a snowbank to adjacent to the rwy and nosed over. It was reported that the plt had applied wheel brakes with the…Mar 31, 1985 · N50511 · Substantial damageNTSB MIA85LA136Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Melbourne, FLThe acft was departing on rwy 27L, when aprx 1200 ft down the rwy, on the takeoff roll, it veered off the left side of the rwy & crossed two taxiways. The acft came to rest about 350 ft off the left side of rwy 27L. A post crash exam of the landing gear…Mar 29, 1985 · N7390V · Substantial damageNTSB MIA85LA131Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Fort Myers, FLThe acft landed with both main wheel brakes locked as evidenced by skid marks in the touchdown zone of the rwy. After aprx 200 feet of skidding the left brake released and due to the right brake not releasing the plt lost control. The acft veered off the…Mar 25, 1985 · N79CM · Substantial damageNTSB MIA85LA127Accident · No injuriesLimited investigationFinal reportBeech E18S · St. ThomasThe plt lost control of the acft during takeoff with a slight tailwind component & the acft ground looped. Later, the plt realized that the tail wheel was not locked.Mar 20, 1985 · N49MA · Substantial damageNTSB DEN85LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Wesbter, SDThe student pilot made a touch and go landing on a grass runway. The airplane bounced 6 feet in the air during landing and a go around was initiated. The airplane was then on a collision course with airport obstacles. The pilot initiated a left turn, the…Mar 19, 1985 · N7979B · DestroyedNTSB BFO85LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Leesburg, VAThe plt enplaned 3 adult paxs and taxied to rwy 17 for tkof. Rptd wnd was 310 at 8KTS. Tkof roll was iniated and continued until near midfld at which time it became apparent to the plt that the acft would not rotate. The plt then abtd the tkof but as the acft…Mar 16, 1985 · N7586G · Substantial damageNTSB MIA85IA120Incident · No injuriesIncident investigationFinal reportDouglas DC-6B · Miami, FLCrew stated that on takeoff roll the number four engine failed and an aborted takeoff was intiated. During the decelleration after the throttles were closed the number four engine seized and the number four propeller separated when the propeller shaft failed.…Mar 15, 1985 · N55CA · Minor damageNTSB LAX85LA174Accident · No injuriesLimited investigationFinal reportEngel Engel AIR · Truckee, CAPlt built this acft and this was the 4th test flight. Plt was lined up on rwy 28 for takeoff. Upon rolling lift off plt lost directional control and ran into a tall snow bank.Mar 15, 1985 · N5823X · DestroyedNTSB DEN85FA096Accident · 3 fatalField investigationFinal reportPiper PA-28 · Logan, UTThe plt (non-inst rated) & 2PAX dept Logan airport under extreme IMC conditions. Visability in ice fog was down to just a few feet. The a/c crashed during a rt turn after t/o.there were no survivors.Mar 14, 1985 · N8460Z · DestroyedNTSB ANC85LA055Accident · No injuriesLimited investigationFinal reportCessna 170B · Circle, AKThe plt took off at night from a snow covered rwy with no rwy lights. He reported that after the acft lifted off, he lost visual references due to the darkness. Shortly after that, the acft settled into alders, willow brush & deep snow & was substantially…Mar 13, 1985 · N2859C · Substantial damageNTSB MIA85LA117Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Titusville, FLA group of T-6 type acft were taking off in sections of two acft each. Each section of two were making a formation takeoff with a 5 to 6 second interval between sections. N58740 was in the left position of the 2nd section; N9801C was in the left position of…Mar 10, 1985 · N9801C · 2 aircraft · Substantial damageNTSB DEN85LA092Accident · No injuriesLimited investigationFinal reportCessna 180 · Arroyo Seco, NMThe acft collided with trees off the end of the 1000 ft long grass airstrip during an aborted takeoff attempt. Calculations show it would have taken aprx 1171 ft for the plt to successfully perform the aborted takeoff.Mar 10, 1985 · N2242C · DestroyedNTSB FTW85LA145Accident · No injuriesLimited investigationFinal reportCessna 150G · Miami, OKStudent pilot was on a solo cross country flight from siloam springs ar. To Miami, ark. And return. The pilot had landed at Miami previously. He had started his takeoff run when a wind gust caused the aircraft to veer left. The aircraft went off the runway…Mar 9, 1985 · N495RA · Substantial damageNTSB DEN85LA091Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Taos, NMThe plt said that he made a late decision to abort his takeoff and that he was unable to stop the acft before it ran off the end of the rwy into sage brush covered terrain. The acft sustained damage but no one was injured.Mar 9, 1985 · N9735E · Substantial damageNTSB MKC85LA068Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Bradley, ARThe plt said that after liftoff the acft encountered a gust of wind and the acft swerved off the airstrip into rough terrain.Mar 6, 1985 · N8909Q · Substantial damageNTSB FTW85LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Houma, LAThe plt was attempting to takeoff from a short muddy strip near Houma, LA. He elected to abort the takeoff & applied brakes. The acft then rolled over a dry area on the strip, where braking action became effective & the aircraft nosed over. No mechanical…Mar 3, 1985 · N2878K · Substantial damageNTSB BFO85LA020Accident · No injuriesLimited investigationFinal reportBellanca 7-ECA Citabria · Annapolis, MDDuring final apch to rwy 30, a go-around was executed due to a shift in wind direction, according to the plt. He subsequently entered the pattern for rwy 12, made a full stop lndg with no difficulties, and took off again for a planned touch and go on the next…Mar 3, 1985 · N8682V · Substantial damageNTSB MIA85LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Brunswick, GAThe plt stated that his takeoff roll was normal, but just before he rotated, the nose gear collapsed. No determination could be made as to the nature of the malfunction during a post crash exam & retraction test of the landing gear.Mar 1, 1985 · N6429Y · Substantial damageNTSB LAX85LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CADuring an authorized local solo practice flt, the 31-hour student was performing takeoffs and landing. According to plt, second landing was 'hard' and a nose wheel shimmy was noted during the taxi-back for takeoff. Just before liftoff on the next takeoff, the…Mar 1, 1985 · N89716 · Substantial damageNTSB DEN85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lapoint, UTThe acft collided with a snowbank while taking off from a road near Lapoint, Utah. The acft was being used to count elk on an indian reservation. The plt landed to relieve himself. On the subsequent takeoff the acft hit a chuckhole in the road which caused it…Feb 25, 1985 · N17RK · Substantial damageNTSB DEN85LA079Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Steamboat Sprng, COPurpose of the flt was to test the helicopter after an annual inspection. The plt flew the acft for aprx 1 hour from the left seat with the acft owner in the right seat before the owner deplaned the acft and the plt moved into the right seat. Plt stated that…Feb 18, 1985 · N4035G · Substantial damageNTSB ATL85LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Pontotoc, MSThe pilot ran off the end of the 1500 ft wet & soggy sod rwy during takeoff ground run. The plt stated that he did not realize that he was not going to liftoff , until the acft was too FAR down the rwy to stop on the remaining rwy surface.Feb 16, 1985 · N2512F · Substantial damageNTSB ATL85FA097Accident · 1 fatalField investigationFinal reportBeech H18 · Cartersville, GAThe flt had not yet been scheduled when the plt retired for the evening at 2230 to 2300 EST. At 0230, he was awoken & notified to make a ngt cargo flt. The owner obtained a wx briefing & filed a flt plan, then briefed the plt later. The plt arrived at the…Feb 12, 1985 · N18AW · DestroyedNTSB DEN85LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe student plt lost directional control of the acft when pwr was added to takeoff during a touch and go landing. The plt stated the acft began to veer right when pwr was added and he applied 'too much right rudder' to correct. The acft veered left and…Feb 8, 1985 · N94703 · Substantial damageNTSB LAX85LA134Accident · Minor injuriesLimited investigationFinal reportMilentz Quickie 02 · Camarillo, CAOn a local test flt for the recently constructed experimental homebuilt acft, plt experienced an on ground loss of control during the takeoff ground roll, veered off the runway and cartwheeled after encounterimg plowed furrow. Pltstated that the takeoff roll…Feb 6, 1985 · N3258P · DestroyedNTSB LAX85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAAfter spending the day skiing, the plt & passengers planned to depart on a return flt to san diego. The wind was from 210 to 220 deg at about 10 mph. The plt elected to takeoff on rwy 7 since low clouds were approaching from the west & the visibility was near…Feb 4, 1985 · N30069 · Substantial damageNTSB FTW85LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Corsicana, TXThe student plt was on a x-country flt with intermediate stops at Corsicana & terrell, TX. At Corsicana, he initiated a touch & go landing on a partially ice covered rwy. After he applied power to takeoff, the acft began to swerve. The student stated that the…Feb 2, 1985 · N68422 · Substantial damageNTSB MKC85LA053Accident · No injuriesLimited investigationFinal reportCessna A152 · Olathe, KSThe acft collided with a snow bank on the left side of the rwy following a loss of directional control during a touch and go landing. The plt stated control of the acft was lost when he attempted to reconfigure the acft for the takeoff portion of the touch…Feb 1, 1985 · N4781A · Substantial damageNTSB ANC85LA043Accident · No injuriesLimited investigationFinal reportCessna U206G · Unalakleet, AKAcft veered to the left and contacted a snowbank during the takeoff ground roll. Inspection revealed plt failed to remove the rudder gust lock before takeoff was attempted.Jan 31, 1985 · N410WR · Substantial damageNTSB ATL85LA084Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Andrews Murphy, NCThe nose gear collapsed when the acft contacted a snow bank during takeoff.Jan 30, 1985 · N9528R · Substantial damageNTSB MKC85LA052Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ottawa, KSRight main gear struck an object during takeoff ground run. Plt aborted the takeoff. Acft veered to the right and impacted a snowbank which paralled the side of the rwy. The arpt operator reported that there was snow knocked onto the rwy 5O to 100 ft prior to…Jan 29, 1985 · N8127F · Substantial damageNTSB LAX85LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Hollister, CAThe acft attempted to takeoff from a taxiway. The takeoff was aborted. But the acft continued off the end of the taxiway. Plt's medical certificate had expired, and he did not file an accident report.Jan 28, 1985 · N5343Q · Substantial damageNTSB CHI85LA099Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Alexandria, MNThe acft on a ferry flt after an annual insp was on to climb 100 ft AGL when power began to deteriorate while manuvering to ld on an adjacent runway the acft struck a VASI installation and ground impacted no 5 lower spark plug improper installationJan 28, 1985 · N9011K · Substantial damageNTSB FTW85LA101Accident · No injuriesLimited investigationFinal reportSwearingen SA26-T · Dallas, TXThe landing gear retracted during the takeoff roll & the acft dropped to the rwy surface & slid to a stop. No obvious reason for the unwanted retraction was noted by FAA maintenance personnel who did a post accident exam of the acft. The gear selector handle…Jan 25, 1985 · N600P · Substantial damageNTSB ANC85FA042Accident · No injuriesField investigationFinal reportPiper PA-18 · Minto, AKThe plt had landed the ski equipped acft on the shore of a lake that was covered with grassy tundra & snow. For a subsequent takeoff, he elected to continue straight ahead rather than back taxi to where he had a known surface condition. During the takeoff,…Jan 25, 1985 · N4242Z · Substantial damageNTSB SEA85FA040Accident · Serious injuriesField investigationFinal reportBell 206BIII · Yerington, NVThe plt made an en route emergency landing due to deteriorated wx. After waiting some period of time, a takeoff was attempted but the helicopter was unable to become airborne. The helicopter bounced down hilly terrain and rolled over to the left. Wx at the…Jan 13, 1985 · N3185Z · Substantial damageNTSB NYC85LA051Accident · No injuriesLimited investigationFinal reportBeech B58 · New Bedford, MAThe acft experienced a gear collapse during landing. During the first landing and takeoff the plt noticed the left main gear began to collapse. The takeoff was continued and two passes were performed in front of the ATC twr. Twr personnel advised that the…Jan 12, 1985 · N17824 · Substantial damage