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 MKC88LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Crete, NEThe student pilot said he lost control shortly after liftoff while attempting a soft field takeoff. The acft made an uncontrolled descent to the terrain on a farm field adjacent the airstrip, causing substantial damage to the acft, but no injuries to the…Aug 5, 1988 · N3566R · Substantial damageNTSB ATL88IA227Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAAug 5, 1988 · N775NC · Minor damageNTSB ANC88LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft 15A · Wasilla, AKThe pilot stated that during the takeoff roll on a gravel bar type airstrip he lost control of the airplane. The airplane bounced and landed on a stump.Aug 5, 1988 · N6659N · Substantial damageNTSB DEN88LA164Accident · No injuriesLimited investigationFinal reportStinson 108 · Lordsburg, NMDuring takeoff the plane swerved to the lt and the plt aborted the takeoff. On the second takeoff, the airplane again swerved lt and departed the rwy. The plane entered loose sand off the lt side of the rwy and nosed over. The plt stated that he had made 10…Jul 31, 1988 · N97395 · Substantial damageNTSB LAX88LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Placerville, CAThe plt initiated a touch & go landing in an acft that was loaded near its max certificated gross weight. He landed slightly long & applied power for takeoff. However, he stated that the eng sputtered & the acft contd to decelerate, so he rejected the…Jul 30, 1988 · N8414A · Substantial damageNTSB CHI88DER06Accident · No injuriesFinal reportHiller UH-12E · Buffalo Lake, MNWhen the helicopter lifted off, the left tail rotor cable separated. Directional control was lost and the aircraft collided with the terrain. The pilot reported no injuries, however the helicopter sustained substantial damage. An inspection of the left tail…Jul 30, 1988 · N173HA · DestroyedNTSB ATL88LA222Accident · No injuriesLimited investigationFinal reportBeech V35B · Parson, TNThe pilot reported that shortly after a heavy weather system passed over, he attempted a takeoff from a wet runway. During the takeoff roll he did not allow the airspeed to accelerate to the lift off speed. As he prematurely lifted off he lost directional…Jul 30, 1988 · N38573 · Substantial damageNTSB CHI88DEV03Accident · No injuriesFinal reportHughes 369HS · Ashland, ILAs the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the . Tail boom. An inspn of the eng…Jul 28, 1988 · N9033F · Substantial damageNTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INJul 27, 1988 · N6818A · Substantial damageNTSB LAX88LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Redlands, CADuring the takeoff ground run on a solo instructional flight, the student pilot lost control of the airplane. The airplane veered to the left. The pilot applied right rudder, however, the airplane continued to the left, exited the runway and collided with the…Jul 22, 1988 · N9850J · Substantial damageNTSB FTW88LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Oklahoma City, OKThe air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…Jul 22, 1988 · N2970M · Substantial damageNTSB MIA88LA228Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Lambert, MSThe plt stated there were tstrms in the area when he attempted to takeoff on an aerial application flt. He began his takeoff roll from the duster strip & a strong wind gust from the approaching tstrm blew the tail around. The acft came to rest on its belly in…Jul 19, 1988 · N8806Q · Substantial damageNTSB CHI88LA169Accident · No injuriesLimited investigationFinal reportBeech E18S · Elyria, OHDuring the takeoff roll, the right engine 'surged'. The pilot was unable to maintain directional control of the aircraft, and the aircraft swerved to the right, departed the right side of the runway, struck a ditch and groundlooped, collapsing the left main…Jul 19, 1988 · N136JR · Substantial damageNTSB ANC88LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Illiamna, AKDuring the takeoff roll on the beach, the aircraft struck a large rock and the pilot lost directional control of the aircraft.Jul 18, 1988 · N7958H · Substantial damageNTSB NYC88LA182Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Candlewood Lake, CTThe LA-4-200 made a takeoff under reported conditions of gusty wind and waves of 1 to 2 feet. The maximum demonstrated wave height for the aircraft is 1 foot. The pilot reported he aborted the takeoff due to a person on a jet ski in his way and as he tried to…Jul 16, 1988 · N5033L · Substantial damageNTSB LAX88DUG05Accident · No injuriesFinal reportCosta TEENY-TWO · Corona, CAThe homebuilt teeny-two acft was built with a 40 HP, british reliant, hawk ae eng, rather than a volkswagon eng which builders normally used. It had been flown only one time before the acdnt flt. The 1st flt was made in cooler temp conds without incident; the…Jul 16, 1988 · N5428R · Substantial damageNTSB DEN88LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gallup, NMThe private plt & his wife were starting a cross-country personal transportation flt. The acft was loaded to near max gwt, & the fss had reported a density alt of 9,600 ft to the plt. After takeoff on a 6,300 x 100 ft, asphalt rwy, the plt said the acft…Jul 15, 1988 · N1578J · Substantial damageNTSB FTW88FA131Accident · 1 fatalField investigationFinal reportAerospatiale SA330J · Gulf-Of-MexicoNone submittedJul 14, 1988 · N47307 · DestroyedNTSB NYC88LA201Accident · No injuriesLimited investigationFinal reportBell 206B · Plymouth, MAA loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area.Jul 13, 1988 · N543CC · Substantial damageNTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.Jul 11, 1988 · N4605P · Substantial damageNTSB LAX88FA249Accident · Minor injuriesField investigationFinal reportHughes 269C · Van Nuys, CAFlight with undertorqued rotor dampers.Jul 9, 1988 · N750AM · Substantial damageNTSB ANC88LA086Accident · No injuriesLimited investigationFinal reportHughes 369D · Kitoi Bay, AKThe helicopter landed with the left skid against a survey stake which protruded from the ground about 6 inches. Upon liftoff the skid did not clear the metal stake before the helicopter started moving laterally to the left. The left skid remained against the…Jul 9, 1988 · N1089D · Substantial damageNTSB LAX88LA244Accident · No injuriesLimited investigationFinal reportCessna TR182 · Niland, CADuring the takeoff ground run on a dirt road, witnesses stated that the pilot had lifted the nose of the airplane so high that the tail dragged on the ground. The airplane became entangled in weeds near the road, the pilot lost control and the airplane…Jul 6, 1988 · N736UX · Substantial damageNTSB CHI88LA148Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Menomonee Falls, WIJul 3, 1988 · N70916 · Substantial damageNTSB CHI88DEI01Accident · No injuriesFinal reportVan Wormer Emeraude SSE-328R · Elyria, OHAccording to the plt, the eng seemed to lose power as the acft was climbing thru about 50 ft AGL after takeoff. Subsequently, the acft settled to the ground, crossed a road & collided with a chain link fence. It came to rest about 150 ft from where it 1st…Jul 2, 1988 · N85HT · Substantial damageNTSB NYC88LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akron, NYThe pilot's inadequate preflight resulted in a delayed aborted take-off. After an inadvertent retraction of the landing gear the aircraft skidded off the end of the runway into rough terrain.Jul 1, 1988 · N1954H · Substantial damageNTSB ANC88LA076Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe 70 hour private pilot was attempting to take off from a private turf airstrip with her non-pilot husband onboard. As she advanced the throttle to the one-half open position, the airplane veered sharply to the left. She said that she pulled the airplane…Jun 29, 1988 · N9892Y · Substantial damageNTSB ANC88LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Barter Island, AKThe 5100 hour commercial pilot had landed at a remote lake on an air taxi flight to pick up three passengers. On the ensuing takeoff attempt, he elected to abort the takeoff due to what he felt was an insufficent amount of lake remaining for a successful…Jun 27, 1988 · N53042 · Substantial damageNTSB MIA88LA205Accident · No injuriesLimited investigationFinal reportCessna 182R · Tampa, FLThe plt rprtd that drg the takeoff roll, he 'rotated aircraft at 65 kts' but it would not become airborne. He then aborted the takeoff, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit a ditch & nosed over. An exam of the flt…Jun 24, 1988 · N9658X · Substantial damageNTSB LAX88DVG06Accident · No injuriesFinal reportCessna 188 · Upper Lake, CAThe acdt occurred drg an aerial app flt. The pilot reported that he had flown 6 or 7 flights earlier in the day. Each flight the load was reduced due to the increasing temperature of the day. Just prior to the accident, the pilot reported that the takeoff…Jun 23, 1988 · N4946Q · DestroyedNTSB ANC88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Bethel, AKThe 276 hour private pilot attempted to take off from the Bethel airport, Bethel, AK., on runway 36 in a left crosswind condition given by the tower as 280 degrees at 10 knots. The pilot stated that shortly after the takeoff roll began, the left wing lifted…Jun 23, 1988 · N5630H · Substantial damageNTSB CHI88IA141Incident · No injuriesIncident investigationFinal reportSwearingen SA226-TC · Chicago, ILFailure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke.Jun 22, 1988 · N329BA · No damageNTSB LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…Jun 20, 1988 · N6026V · Substantial damageNTSB FTW88DRD09Accident · No injuriesFinal reportGrumman G-164A · Basile, LADuring or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position.Jun 17, 1988 · N4243 · Substantial damageNTSB DEN88LA165Accident · No injuriesLimited investigationFinal reportHall HP-18 · Westcliffe, COThe plt said his glider was being towed for takeoff from a dry, dusty, grass strip. He said the tow plane blew up the dust and he was unable to see to maintain alignment with the 75 ft wide strip. There was a drop off on the lt side of the strip and tall…Jun 13, 1988 · N81940 · Substantial damageNTSB NYC88LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lehighton, PAThe student pilot, on his third solo, experienced a loss of directional control during a go-around and settled into low trees and brush on the south side of the runway. The pilot reported the winds as calm. He stated that the left main wheel went off the left…Jun 11, 1988 · N44699 · DestroyedNTSB FTW88LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roanoke, TXThe pilot lost directional control while attempting a takeoff. The airplane ran off the right side of the runway and struck a wind tetrahedron, a fence, and a low concrete wall. The plt did not submit an acc report.Jun 9, 1988 · N84889 · Substantial damageNTSB FTW88LA116Accident · No injuriesLimited investigationFinal reportCessna 182L · Angola, LAThe pilot stated the airplane was on the takeoff roll when the seat slid to the rear. He was unable to control the airplane and it ran off the side of the runway and struck a fence. The seat track holes were worn enough that the locking pins would not stay in…Jun 8, 1988 · N3153R · Substantial damageNTSB FTW88DRA14Accident · No injuriesFinal reportGrumman G-164B · College Port, TXAcft was substantially damaged when it executed an off-arpt landing following takeoff FR0M a wet sod strip on an ag flt. The plt stated that he was taking off to the north and that during the t/o roll the wind shifted to out of the south. He further stated…Jun 6, 1988 · N6615Q · Substantial damageNTSB NYC88DGT02Accident · Minor injuriesFinal reportBell 47G3B1 · Cove Gap, PAThe helicopter plt was taking off from an area surrounded by trees & buildings for a local spray operation. The wind was calm. Reportedly, during the attempted departure, the plt 'exhausted all power available then made right turn to return to field.' After…May 30, 1988 · N48181 · Substantial damageNTSB ATL88FA186Accident · 1 fatalField investigationFinal reportCessna 402B · West Columbia, SCThe airplane used about 1/2 of the 8,602 ft rwy for the t/o roll. After t/o it pitched nose-down briefly over the rwy during init climb. The plt radioed that he was having a problem with the elevator which required 'full back pressure' to keep the nose up,…May 26, 1988 · N8493A · DestroyedNTSB LAX88LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Hesperia, CAMay 22, 1988 · N5411Q · Substantial damageNTSB FTW88NA106Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Dfw Airport, TXMay 21, 1988 · N136AA · Substantial damageNTSB SEA88LA100Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Clementsville, IDThe pilot was using a road as his base of operations for an aerial applications operation. During takeoff the aircrafts' wingtip struck a moving automobile's windshield. The plt did not file an accident report.May 20, 1988 · N4842Y · Substantial damageNTSB CHI88DET03Accident · No injuriesFinal reportDavis Heath Model V · Valparaiso, INThe plt rprtd that when he applied power to takeoff, the acft 'pulled to the right.' He said the acft became airborne, but touched down again & contd to go to the right. Also, he said he tried to correct the situation with left rudder, but the rudder seemed…May 20, 1988 · N312HD · Substantial damageNTSB FTW88FA103Accident · Serious injuriesField investigationFinal reportGlobe GC-1B · Powderly, TXThe airplane had not been flown for more than seven months. It did not have a current annual inspection. Witnesses said the pilot ran the engine and it ran rough. Then he washed the airplane, then refueled, drained the sumps and ran the engine again at the…May 18, 1988 · N78143 · DestroyedNTSB ATL88LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Florence, SCThe accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of…May 18, 1988 · N757VH · Substantial damageNTSB ANC88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot elected to abort the takeoff of a heavily loaded Piper from a soft strip. His decision was tardy and the airplane struck a cinder bank.May 18, 1988 · N8259V · Substantial damageNTSB SEA88LA097Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Chemult, ORThe pilot was attempting to takeoff with a density altitude of 6,300 feet. The aircraft was operated near its maximum gross weight limitation. 150 feet from the initial takeoff the helicopter rotor stirred up dust and debris from a road, causing the pilot to…May 17, 1988 · N5258C · Substantial damageNTSB ANC88DAG04Accident · No injuriesFinal reportPiper PA-18 · Togiak, AKDuring the takeoff from a beach, the aircraft hit a log causing substantial damage to the landing gear. The pilot stated that during the takeoff run he did not see the log. He then proceeded to an airport where during the landing roll the landing gear…May 17, 1988 · N842JT · Substantial damage