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 DEN86FA069Accident · No injuriesField investigationFinal reportBell 206L-1 · Missoula, MTThe helicopter, equipped with landing skid snow pads, was parked on a narrow ramp extension to a roof top helipad that was surrounded by a concrete curb. Upon takeoff to a hover, the right snow pad struck and became momentartily caught on bolts protruding…Jan 27, 1986 · N5019K · Substantial damageNTSB CHI86LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · St. Ignace, MIThe pilot stated that after the application of full power for takeoff his seat slid back to its full aft position. He could not reach any of the controls. He then unfastened his seat belt and lunged forward to pull the power off. At this time the right wing…Jan 20, 1986 · N1573F · Substantial damageNTSB ATL86LA059Accident · No injuriesLimited investigationFinal reportBeech A36TC · Louisville, KYPlt attempted t.o. from slush covered rwy with about 1/2 to 3/4 inch of snow on acft. When snow did not blow off the wings, abort attempted at between 80-100 knots. Acft went off the end of the rwy and through fence before coming to a stop on the golf course…Jan 19, 1986 · N345CC · Substantial damageNTSB MKC86LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, MODuring an aborted takeoff in strong crosswinds, the acft veered off the rwy and into a ditch near the runways edge. The nose gear collapsed rearward and the right wing dropped striking the ground. The plt stated he aborted the takeoff when the acft felt like…Jan 18, 1986 · N4977P · Substantial damageNTSB MKC86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbia, MOThe pilot stated that he was showing his passenger a procedure that he used in multi-engine airplanes when he inadvertently stalled the airplane at 300 feet AGL just after takeoff. He could not complete the recovery before impacting the runway.Jan 15, 1986 · N7013W · Substantial damageNTSB NYC86LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTThe purpose of instructional flight was to practice soft field landings and takeoffs, stall series and VOR naviagtion. After airwork, the pilot flew to robertson field for short and soft field landings and takeoffs. During final soft field takeoff, 10 degrees…Jan 10, 1986 · N6267Q · Substantial damageNTSB MKC86LA046Accident · No injuriesLimited investigationFinal reportCessna 177A · Sidney, NEN30535 was making a night takeoff on a rwy covered by 3' deep snow. There were also drifts along the lt side of the rwy which were 8 to 10 inches deep. During the takeoff roll moisture blew onto the windshield and the acft drifted to the lt. the acft then…Jan 7, 1986 · N30535 · Substantial damageNTSB FTW86FA033Accident · Minor injuriesField investigationFinal reportBell 206B · Port O'Connor, TXThe helicopter sustained a loss of tailrotor drive on lift off. A bonding in a shaft coupling failed. Extensive research and analysis discovered no discrepancies in design, production, quality assurance, maintenance or operating environment that could have…Jan 7, 1986 · N520EH · DestroyedNTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…Jan 5, 1986 · N6422Q · Substantial damageNTSB FTW86MA030Incident · No injuriesMajor investigationFinal reportBoeing 737-2H4 · Dallas, TXThis incident occurred when the no. 2 engine experienced an aft engine mount cone bolt failure and the subsequent failure of the secondary support link (stainless steel cable). The failure of both aft engine support assemblies during the takeoff roll allowed…Jan 3, 1986 · N86SW · Minor damageNTSB DEN86LA062Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Hope, NDThe plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that…Jan 3, 1986 · N50384 · Substantial damageNTSB LAX86LA103Accident · No injuriesLimited investigationFinal reportCessna T210N · Tucson, AZThe plt planned to fly nonstop fm houston, TX, to phoenix, AZ. He reported that during the trip he encountered 'fluctuating head winds' & he miscalculated the acft's endurance. Fuel exhaustion occurred 8 miles fm Tucson, AZ., & the plt made a successful…Jan 2, 1986 · N6594Y · Substantial damageNTSB FTW86FPA13Accident · No injuriesFinal reportBeech E18S · Terrell, TXThe plt reported the acft yawed left on takeoff and despite attempted remedial action the acft would not clear odstaclesalong the flt path. Pwr was reduced and a straight in landing was made in a fld aprx 1/4 mile north of the rwy. A witness reported the acft…Jan 2, 1986 · N27Y · Substantial damageNTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…Dec 31, 1985 · N4649X · Substantial damageNTSB DEN86LA055Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NMAccording to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about…Dec 28, 1985 · N4849V · Substantial damageNTSB MIA86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe instructor pilot simulated an engine failure after takeoff. The student pilot failed to lower the airplane nose to maintain flying speed. The instructor took over the controls and lowered the nose, but was unable to avert the hard landing and ensuing…Dec 22, 1985 · N2569L · Substantial damageNTSB MKC86LA038Accident · No injuriesLimited investigationFinal reportCessna 140 · Coy, ARThe pilot reports that the engine of N3587V was run at idle for an extended time before the takeoff was attempted. After several minutes, the engine died. It was restarted and the takeoff was commenced immediately. According to the pilot, the engine was…Dec 21, 1985 · N3587V · Substantial damageNTSB ATL86LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Manning, SCDuring takeoff ground run on the wet grass runway the aircraft hit a soft spot in the runway and nosed over to an inverted attitude. Both the private pilot and passenger escaped without injury.Dec 15, 1985 · N19099 · Substantial damageNTSB DEN86LA046Accident · No injuriesLimited investigationFinal reportCessna 206 · Hardin, MTAfter ldg to the east on a snow covered dirt rwy, the pilot elected to t/o on an intersecting rwy to the south. He could not see the entire rwy surface from the position due to dwn slope from center of rwy. The acft impacted snowdrifts 40-50 mph on t/o gnd…Dec 14, 1985 · N5173U · DestroyedNTSB MIA86LA042Accident · No injuriesLimited investigationFinal reportBeech E-18S · Opa Locka, FLThe plt stated that while on his takeoff roll, the left main wheel started to shimmy, the acft pulled left then veered off the right side of the rwy, collapsing the tail wheel & coming to rest in the grass.Dec 13, 1985 · N43T · Substantial damageNTSB LAX86FA066Accident · 1 fatalField investigationFinal reportCessna 150 · Oxnard, CAThe acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and…Dec 13, 1985 · N7310X · DestroyedNTSB NYC86LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · East Moriches, NYThe acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice.Dec 4, 1985 · N3530S · Substantial damageNTSB ATL86LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCDuring the takeoff phase of a touch & go landing the student plt lost directional control of the acft and ran off the side of the rwy. The student plt was on his third solo training flight.Nov 18, 1985 · N45363 · Substantial damageNTSB DEN86LA027Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ft. Collins, COThe acft collided with large chunks of snow on the rwy during takeoff roll. The plt stated that during the roll about mid-way down the rwy he spotted the snow and decided to abort but was unable to avoid the snow. The left gear contacted the snow and the acft…Nov 16, 1985 · N2601G · Substantial damageNTSB ATL86LA019Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Sylacauga, ALDuring takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted.Nov 6, 1985 · N601PC · Substantial damageNTSB LAX86LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Angwin, CANear the completion of a dual instructional flt with a pre-solo student, the CFI followed the procedures recommended in the aim 7 & announced his Cessna acft's position over the CTAF stating his intentions & identifying his location on the 45 deg. Entry &…Nov 3, 1985 · N21491 · 2 aircraft · Minor damageNTSB MIA86LA019Accident · No injuriesLimited investigationFinal reportBeech G35 · Destin, FLThe acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind.Oct 26, 1985 · N4275D · Substantial damageNTSB LAX86LUG01Accident · No injuriesFinal reportTexas Helicopter M74A · Daggett, CAThe plt stated he had just lifted off for a fertilizer spreading operation with an external load bucket, when the eng had a partial pwr loss at 100 ft AGL. A descent was started and the bucket was disengaged. However, while the plt was attempting to land the…Oct 19, 1985 · N51862 · Substantial damageNTSB LAX86LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino Valley, AZWhen the flt departed prescott for the local flt, the plt said the rwys switched several times between 11 & 03 due to the winds. The official prescott surfact observation reported the winds from 110 degrees at 8 KTS with gusts to 17 KTS. After departing…Oct 15, 1985 · N9660W · Substantial damageNTSB ATL86LA005Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Chapman, ALDuring an attempted takeoff from a field adjacent to a grove of trees the aircraft was unable to climb over the trees and crashed into them. The engine was test run and although it ran rough during initial start up it later operated normally and the reason…Oct 10, 1985 · N7451F · DestroyedNTSB ANC86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe acft cartwheeled after dragging the right wing during an attempted takeoff from a gravel strip. The plt reported the takeoff was attempted to the west with a 10 to 15 mph left x-wind. Another person in the area when the accident occurred stated the wind…Oct 8, 1985 · N9960Q · Substantial damageNTSB SEA86LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Burton Lake, ORThe acft failed to become airborne on the soft, short, rough cinder covered airstrip probably due to a combination of density altitude and poor plt technique. The acft struck a berm at the end of the runway where it nosed over. The plt was also departing…Oct 7, 1985 · N50120 · Substantial damageNTSB LAX86LA005Accident · Minor injuriesLimited investigationFinal reportWillie II · Blythe, CAOn oct 5, 1985 a Willie ii homebuilt crashed on takeoff after its left main landing gear collapsed. VMC existed at the time and no flt plan was filed. The ac sustained substantial damage and the two occupants received minor injuries. The winds were from 050.…Oct 5, 1985 · N7919 · Substantial damageNTSB ANC86LAG01Accident · No injuriesFinal reportCessna 140 · Beluga, AKThe student plt attempted takeoff from am unimproved, overgrown river bed. He stated he paced off the distance availablefor takeoff and it was too short, however, he decided to takeoff anyway. The acft impacted alders and a stream bank just as it was lifting…Oct 4, 1985 · N2181N · Substantial damageNTSB ANC86LAG03Accident · No injuriesFinal reportPiper PA-18A-150 · Homer, AKThe landing gear axle failure was due to the oversize tires that were installed on the aircraft.Oct 3, 1985 · N3992P · Substantial damageNTSB SEA86LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Winnemucca, NVDirectional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over.Oct 1, 1985 · N53432 · Substantial damageNTSB CHI86LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHAccording to the initial solo stufent pilot, he landed uneventfully, applied takeoff power and reached down to retract the flaps. As the aircraft began to accelerate it began to drift to the left. The student pilot applied right rudder but the aircraft…Oct 1, 1985 · N5331P · Substantial damageNTSB NYC85LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittstown, NJDuring an attempted takeoff on a 2439 ft rwy, the plt was unable to apply back elevator pressure thus the acft was prevented from becoming airborne. The acft traveled off the end of the rwy where it contacted a fence and trees. Inspection of the acft…Sep 29, 1985 · N2335R · Substantial damageNTSB ATL85LA287Accident · No injuriesLimited investigationFinal reportHughes 269A · Winchester, KYThe accident occurred as the student pilot was attempting to takeoff for hover training. As the pilot was applying collective torque, the student said, he lost control and crashed. There were no system malfunctions or failures reported.Sep 28, 1985 · N9308F · Substantial damageNTSB LAX85LA406Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, CAThe acft was observed to turn to the left during the takoeff ground roll on rwy 32R at buchanan airport, Concord, California and exit the rwy environment. The certificated private plt reported that shortly after applying full power the acft 'swerved' to the…Sep 25, 1985 · N64981 · Substantial damageNTSB FTW85LA356Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sanderson, TXOn landing, the plt noticed a quantity of brush on the rwy, however, he did not think it would be an obstacle to his intended takeoff and therefore did not remove it. During takeoff, the left main gear struck the brush causing the plt to lose control of the…Sep 25, 1985 · N9937B · Substantial damageNTSB DEN85LA248Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Deming, NMWhile practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a…Sep 24, 1985 · N7467D · Substantial damageNTSB SEA85LA223Accident · No injuriesLimited investigationFinal reportCessna A185F · Eastsound, WADuring takeoff roll the acft veered right and the plt overcorrected to the left. The acft then departed the rwy to the left striking VASI lights.Sep 23, 1985 · N61298 · Substantial damageNTSB MIA85FA261Accident · Serious injuriesField investigationFinal reportAerofab Lake LA-4-250 · Medley, FLThe non seaplane rated plt whose airman certificate was under suspension. Attempted a downwind take-off from an intermediate point on the lake's surface. The plt stated he thought the non seaplane rated plt/pax attempted to abort the take-off by closing the…Sep 23, 1985 · N1401K · Substantial damageNTSB SEA85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Winnemucca, NVThe plt was attmepting to depart rwy 02 and the wind was from 300 degs at 15 KTS gusting to 20 KTS. Directional control of the acft was not maintained and it veered off the side of the rwy during the takeoff ground run.Sep 21, 1985 · N1930C · Substantial damageNTSB NYC85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Bayport, NYAccording to the CFI, the student raised the nose of the acft too early during takeoff. This resulted in the acft becoming airborne prematurely. The student was unable to climb out of ground effect and the decision to abort the takeoff was made. The acft…Sep 21, 1985 · N7505P · Substantial damageNTSB MIA85LA259Accident · No injuriesLimited investigationFinal reportCessna C-152 · Lantana, FLThe plt stated that he was hovering at an altitude of about three feet. Approximately 100 feet north of the rwy. When an out-of-control Cessna 152 tore off their right landind skid. The helicopter landed safely using a wooden dolly for support of the right…Sep 19, 1985 · N49873 · 2 aircraft · Substantial damageNTSB MKC85LA218Accident · No injuriesLimited investigationFinal reportCessna 210N · Mullen, NEThe takeoff was being made from a hay meadow that was soft due to recent rains. The property owner said the field was 1/4 mi long. The density alt was calculate to be 5600 ft. the plt said the acft did not attain takeoff speed & that it collided with a fence…Sep 18, 1985 · N5278A · Substantial damageNTSB LAX85FVA05Accident · No injuriesFinal reportBeech E-33 · Coalinga, CAThe acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft…Sep 16, 1985 · N3493A · Substantial damageNTSB ANC85LA178Accident · No injuriesLimited investigationFinal reportCessna 180 · Tutna Lake, AKThe plt elected to takeoff from a lake that was aprx 1/2 mi long & oriented on an east/west heading. During a x-wind takeoff, the plt had difficulty getting the acft to lift off, but elected to continue the takeoff. The acft finally lifted off, but failed to…Sep 15, 1985 · N2490C · Substantial damage