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 CHI82DA161Accident · No injuriesFinal reportCessna 152 · Romeo, MIThe student pilot was practicing touch and go landings. On the third takeoff the aircraft veered to the left and the student was unable to correct. The aircraft continued into a soft field and nosed over. The wind was calm and the weather clear.May 13, 1982 · N46341 · Substantial damageNTSB FTW82DA233Accident · No injuriesFinal reportCessna 172P · Chandeleur Isla, LAWhile on a local photo and sight-seeing flight, the pilot elected to land on Chandeleur island. After landing, he prepared to depart, using the recommended soft field technique. During the takeoff, there was a strong crosswind which caused the aircraft to…May 12, 1982 · N52049 · Substantial damageNTSB FTW82FQA19Accident · Minor injuriesFinal reportPiper PA-16 · Albuquerque, NMBoth of the occupants were rated pilots and had just purchased the aircraft. They were ferrying the plane from new york state to California. The pilot reported that during takeoff, he lifted off near the mid-point of the runway and held a flat attitude to…May 11, 1982 · N5648H · Substantial damageNTSB NYC82DA093Accident · No injuriesFinal reportPiper PA-38-112 · Endicott, NYDuring takeoff roll the aircraft veered to the left. The pilot stated that he applied right rudder and aileron into the wind, however; the aicraft continued to the left. The pilot then closed the throttle and the aircraft collided with runway lights causing…May 10, 1982 · N2483A · Substantial damageNTSB SEA82DA068Accident · No injuriesFinal reportde Havilland 2 · 15n Of Medford, ORThe pilot started a downwind takeoff on runway 15 with 9 parachutists on board. The runway was unidirectional requiring takeoffs on runway 15 which sloped downhill. After beginning the takeoff roll, the pilot had difficulity in maintaining directional control…May 9, 1982 · N1434Z · Substantial damageNTSB MKC82FCQ09Accident · 2 fatalFinal reportLuscombe 8A · Fredonia, KSThe aircraft crashed after taking off on a test flight. A witness reported that the aircraft was in a steep angle of climb, and the nose pitched down as the pilot was making a left turn. The witness reported that the pilot had been adjusting the magnetos…May 9, 1982 · N2248K · DestroyedNTSB CHI82DA155Accident · No injuriesFinal reportCessna 180 · Aurora, ILOn takeoff the aircraft veered off the side of the runway and struck a drainage ditch. The pilot reported a gust of wind caught the aircraft.May 8, 1982 · N9388C · Substantial damageNTSB LAX82DVG24Accident · Minor injuriesFinal reportBoeing A75 · Maxwell, CADuring the takeoff roll from a local farm strip, the aircraft veered to the right and went off the runway. The pilot reported that the plane went into a small ditch and flipped over. No mechanical failures were reported.May 7, 1982 · N5050V · Substantial damageNTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…May 5, 1982 · N7709T · Substantial damageNTSB FTW82DA165Accident · No injuriesFinal reportPiper PA-18-150 · Marfa, TXDuring the takeoff roll for a dual instructional flight the aircraft began to veer to the left. The instructor was able to overpower the student on the rudder pedals but not the aft stick pressure. The aircraft lifted off then settled back to the runway in a…May 3, 1982 · N7615Z · Substantial damageNTSB ATL82DA123Accident · No injuriesFinal reportCessna 172E · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…May 1, 1982 · N3715S · 2 aircraft · Substantial damageNTSB LAX82DA153Accident · No injuriesFinal reportCessna 182E · Markleeville, CADuring the takeoff roll of a touch and go landing the pilot stated that the aircraft abruptly swerved to the left and went off the runway. Substantial damage occurred when the aircraft collided with two trees.Apr 30, 1982 · N31825 · Substantial damageNTSB ANC82DAG19Accident · No injuriesFinal reportPiper PA-18-150 · Birchwood, AKAfter making one takeoff and landing, the pilot elected to do a short field takeoff. He held the brakes and applied full throttle. His right foot slipped off the right brake and the aircraft turned sharply to the left. During the turn, the aircraft went up on…Apr 30, 1982 · N57617 · Substantial damageNTSB FTW82DA154Accident · No injuriesFinal reportPiper PA-44-180 · Albuquerque, NMThe purpose of the flight was for the pilot-in-command to take his multi-engine airplane check ride. During the takeoff sequence, the examiner reduced power on one engine. The pilot decided there was insufficient runway remaining and aborted the takeoff. The…Apr 26, 1982 · N39669 · Substantial damageNTSB ANC82DAG18Accident · Minor injuriesFinal reportCessna 170 · Big Lake, AKDuring a local flight, the pilot elected to land at the Big Lake airport. Before landing, he noted that weather was moving in from the northwest. Also, he noted that the wind sock was limp, but favored a landing to the west. He landed, and before taking off…Apr 25, 1982 · N170DM · Substantial damageNTSB NYC82DA075Accident · No injuriesFinal reportPitts Special S-1C · Latrobe, PAThe pilot initiated a takeoff in winds that were gusting to 19 knots. As he raised the tail during the takeoff roll, the plane swerved right. The pilot stated that he overcorrected to the left. Subsequently, the plane departed the left side of the runway. The…Apr 21, 1982 · N1750 · Substantial damageNTSB MIA82DA100Accident · No injuriesFinal reportPiper PA-28-140 · Lake Wales, FLDuring takeoff, three/fourths of the way down the runway, the pilot decided to abort because of a slow buildup of airspeed on the wet grass. The aircraft overran the runway colliding with a fence and a tree.Apr 19, 1982 · N56826 · Substantial damageNTSB LAX82DA138Accident · No injuriesFinal reportRobinson R-22 · Perris, CAAfter refueling with 12.9 gallons of fuel, the pilot took off with one passenger on board. The pilot stated that after lifting off with 104% prm, he began a normal shallow takeoff with 25 inches of manifold pressure. He reported reaching about 75 ft AGL and…Apr 17, 1982 · N9043E · DestroyedNTSB ATL82DA107Accident · No injuriesFinal reportCessna 150 · Jacksonville, NCAfter rotation the airspeed would not accelerate past 60 mph during climbout. The instructor took over and after realizing that the aircraft would not climb above 10 feet attempted to land on the remaining 1/3 of the runway. The aircraft floated and ended up…Apr 17, 1982 · N6687G · Substantial damageNTSB ATL82DA106Accident · Minor injuriesFinal reportBeech B19 · College Park, MDDuring the preflight the pilot noted the engine ran rough on the right magneto then smoothed out. The pilot departed the runway with the stall warning horn sounding and began a turn into the wind; however, due to buildings in his path he turned 360 degrees.…Apr 17, 1982 · N1932W · Substantial damageNTSB LAX82DA108Accident · Minor injuriesFinal reportGrum Amer AA-5B · Placerville, CAWhen the pilot arrived at the airport, the top surfaces of the aircraft were covered with about two inches of snow. He stated that his preflight included a complete removal of the snow. However, he also stated that during the takeoff roll, there was a layer…Apr 16, 1982 · N28867 · Substantial damageNTSB ANC82FA037Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Homer, AKThe pilot departed Homer airport on a special VFR clearance after being advised numerous times that VFR flight was not recommended. Shortly after takeoff (8 minutes) the aircraft dove out of the clouds and crashed near the airport. The pilot was not…Apr 16, 1982 · N40343 · DestroyedNTSB NYC82DA072Accident · Minor injuriesFinal reportCessna 172N · Trenton, NJDuring a departure, the pilot initiated an intersection takeoff with about 4000 ft of runway remaining. He reported that the takeoff proceeded normally through lift-off to about 25 ft AGL. From there, the aircraft returned to the runway surface and bounced.…Apr 15, 1982 · N4940G · Substantial damageNTSB FTW82DA129Accident · No injuriesFinal reportQuickie · Cleveland, TXAfter taking off with full power, the pilot turned left to a crosswind position. Shortly thereafter, he noticed a partial power loss and turned further left to a downwind. From this position, there was a powerline between him and the runway. He elected to…Apr 14, 1982 · N1225G · Substantial damageNTSB CHI82DA121Accident · No injuriesFinal reportRand K.R.1 · Plymouth, MIOn takeoff roll the left upwind wing lifted and the pilot lost directional control. The aircraft swerved to the right and struck a parked bonanza, N5587D, causing substantial damage to both aircraft. Investigation revealed that the pilot attempted to takeoff…Apr 14, 1982 · N2263D · Substantial damageNTSB SEA82DA051Accident · Minor injuriesFinal reportCessna 172N · Pocatello, IDThe pilot stated that the aircraft encountered a gust of wind shortly after commencing takeoff roll which moved it directly across the runway. Initially the pilot maintained full power while attempting to regain control of the aircraft however shortly…Apr 11, 1982 · N1075F · DestroyedNTSB MIA82DA094Accident · No injuriesFinal reportPiper PA-23-250 · Jacksonville, FLImmediately after raising the gear handle during takeoff, the pilot heard a loud noise that he thought was an explosion. He aborted the takeoff and landed on the remaining runway without extending the gear. The loud noise occurred when the cabin door popped…Apr 11, 1982 · N4881P · Substantial damageNTSB CHI82DA119Accident · No injuriesFinal reportPiper PA-22-160 · Nova, OHThe aircraft encountered a four inch snowdrift during takeoff roll from a sod strip. It nosed over and came to rest inverted.Apr 11, 1982 · N3402Z · Substantial damageNTSB ANC82DA034Accident · No injuriesFinal reportPiper PA-32 · Montague Island, AKDuring a takeoff from Montague Island, Alaska, the aircraft collided with snow and willows beyond the departure end of a small strip at mccleod harbor. The pilot reported that just as he started to rotate the aircraft for takeoff, the right gear encountered a…Apr 11, 1982 · N28582 · Substantial damageNTSB ANC82DA032Accident · No injuriesFinal reportPiper PA-32 · Akiachak, AKThe pilot began taking off on a soft runway with a left quartering crosswind. He stated that he was unable to get enough speed on the soft mud for a safe takeoff. He cut the power to abort, but was unable to stop on the remaining runway. The plane continued…Apr 8, 1982 · N9304K · Substantial damageNTSB LAX82DA127Accident · No injuriesFinal reportGrumman G-164 · Bakersfield, CAOn takeoff roll the right main tire blew causing the aircraft to veer to the right, leave the runway, and nose over in the soft mud.Apr 7, 1982 · N703Y · Substantial damageNTSB MKC82DA052Accident · No injuriesFinal reportCessna 182RG · Gurley, NEDuring takeoff from a wheatfield the left gear hit a rut and the pilot lost control. The takeoff was aborted and the aircraft traveled across a road and through a fence.Apr 5, 1982 · N1686R · DestroyedNTSB FTW82DA113Accident · No injuriesFinal reportCessna 172N · Tomball, TXThe student pilot lost control of the aircraft during a practice touch and go landing. The aircraft swerved off the left side of runway into a plowed area and nosed down.Apr 4, 1982 · N6374F · Substantial damageNTSB CHI82DA109Accident · No injuriesFinal reportCessna 180 · Nokomis, ILDuring takeoff from a soft sod field the aircraft started gradually turning to the left. The pilot applied full right rudder then reduced power before the aircraft nosed over on its back.Apr 1, 1982 · N4936A · Substantial damageNTSB CHI82IA108Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Chicago, ILThe aircraft veered left at slow speed but the veer was corrected. At 60 KTS the aircraft veered again and was not corrected. Aircraft left runway and damaged props. Service bulletin SA-226 no. 103 dated 01/20/82 states that limits be placed on use of nose…Mar 31, 1982 · N62Z · Minor damageNTSB DEN82DA051Accident · No injuriesFinal reportCessna 182K · St. Ignatius, MTThe pilot stated that he and his passengers attempted to remove as much snow as possible from the aircraft and that he was confident that the propeller blast would blow away whatever snow remained. Although the wind at surrounding stations was generally…Mar 29, 1982 · N2478Q · Substantial damageNTSB ATL82FLA01Accident · Serious injuriesFinal reportPiper PA-28-140 · Hoboken, GAThe pilot reported that during takeoff, he accelerated to 68 mph, then realized he would be unable to clear trees. He stated that he closed the throttle and mixture, aimed the aircraft at an opening in the trees, and maintained a level attitude until impact.…Mar 23, 1982 · N5841U · DestroyedNTSB FTW82IA095Incident · No injuriesIncident investigationFinal reportCessna 402C · Chickasha, OKA checkout was being performed with the PIC in the right seat and the trainee in the left seat. As power was increased for takeoff during a touch and go landing, the PIC heard the propellers strike the runway. The trainee lifted the aircraft off the ground,…Mar 16, 1982 · N6838A · Minor damageNTSB LAX82FUQ11Accident · No injuriesFinal reportCessna 172 · Lancaster, CAAt 1530 PST, the pilot received a weather briefing from the Lancaster fss. At that time, the wind was variable, 230 to 250 degrees, at 20 KTS. The pilot reported the wind was variable from the same direction at 22 to 26 KTS, while taxiing to runway 24. The…Mar 14, 1982 · N7498X · DestroyedNTSB SEA82DA036Accident · No injuriesFinal reportPiper PA-32-301T · Hailey, IDAfter an engine run-up with the parking brake set, the first attempt to takeoff was aborted when the plane failed to accelerate satisfactorily. The brakes operated satisfactorily during the abort and a second run-up revealed no unusual engine indications.…Mar 13, 1982 · N83764 · Substantial damageNTSB MIA82DA071Accident · No injuriesFinal reportCessna 182H · New Port Richey, FLThe pilot stated that moments after takeoff power was applied the seat retaining pins broke, the pilot's seat moved aft breaking the rear retainer leaving him unable to reach the control yoke. The aircraft swerved off the runway and collided with trees. The…Mar 13, 1982 · N8554S · Substantial damageNTSB CHI82DA087Accident · No injuriesFinal reportCessna 182 · Lake Village, INThe pilot reported that the wind was from the west at 25, gusting 40 knots. During landing on runway 36, he touched down long and then attempted to go-around. At the north end of the field, the aircraft encountered soft, soggy terrain, the pilot lost…Mar 13, 1982 · N757XU · Substantial damageNTSB NYC82DA052Accident · No injuriesFinal reportPiper PA-38-112 · Allentown, PAThe student pilot was practicing takeoffs and landings on runway 25 in crosswind conditions. The wind was from 330 degrees at 14 knots. On one of the landings, the aircraft bounced during touchdown. The pilot reportedly added a small amount of power for a…Mar 12, 1982 · N2402C · DestroyedNTSB NYC82FNA11Accident · Minor injuriesFinal reportVarga 2150A · Marlboro, MASnow had fallen on the evening before the accident. The runway was covered with one inch of snow which had not been plowed or treated. Also, the pilot reported that he had removed snow and frost from the airframe during his preflight. He said that the leading…Mar 10, 1982 · N8419J · Substantial damageNTSB FTW82DA084Accident · No injuriesFinal reportCessna U-206 · Angel Fire, NMThe aircraft was hit by a crosswind gust during the takeoff run. The aircraft went off the right side of the runway and collided with a snowbank.Mar 10, 1982 · N3417L · Substantial damageNTSB FTW82DA088Accident · No injuriesFinal reportRockwell S-2R · Hughes, ARThe pilot attempted a downwind takeoff from a soft ag strip with a heavy load. After realizing that he would be unable to lift-off, the pilot initiated an abort. The aircraft continued off of the end of the strip and flipped over in a muddy terrain.Mar 9, 1982 · N4987X · Substantial damageNTSB FTW82FRG24Accident · Minor injuriesFinal reportBeech E18S · Charlotte, TXThe aircraft crashed during takeoff from a clearing on a ranch and then was abandoned. The aircraft landing gear struck a concrete trough for watering cattle. Drugs were found on board the aircraft.Mar 8, 1982 · N700W · Substantial damageNTSB FTW82DA085Accident · No injuriesFinal reportCessna 172M · Houston, TXDuring the demonstration of a short field takeoff the aircraft's tail lowered after encountering a moderate dip at a runway intersection. The tail tie-down ring snagged a runway light cable which had been uncovered by recent rains. The cable broke at one side…Mar 7, 1982 · N1117U · DestroyedNTSB CHI82DA089Accident · No injuriesFinal reportCessna 310 · Freemont, MIThe student was a rated pilot on his first instructional flight in this aircraft. After a practice aborted takeoff, the student applied power to start another takeoff. At about this time, the aircraft veered to the right. The instructorapplied left rudder and…Mar 6, 1982 · N7661Q · Substantial damageNTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.Mar 5, 1982 · N6125B · Substantial damage