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 MIA85LLD03Accident · No injuriesFinal reportBrokaw Bullet · Eustis, FLThe acft contacted a ditch during an attempted takeoff on a taxiway. The plt reportedly decided to use the taxiway for takeoff rather than the rwy because of the soft rwy conditions which resulted from recent rains. During takeoff the leftmain gear contacted…Sep 14, 1985 · N520BJ · Substantial damageNTSB MKC85LA215Accident · No injuriesLimited investigationFinal reportCessna 421B · Olathe, KSDuring the takeoff roll on an IFR flt, the right eng lost pwr and the plt aborted the takeoff. The acft ran off the end of the rwy, across two ditches, one road, through a fence and struck a post in a fld. During post accident tests, the right eng would run…Sep 13, 1985 · N88DM · Substantial damageNTSB CHI85IA369Incident · No injuriesIncident investigationFinal reportFokker F27-500 · Chicago, ILAt about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &…Sep 9, 1985 · N242MA · Minor damageNTSB ANC85LA173Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Rainey Pass, AKThe plt was taking off on a strip of tundra about 1000 ft long in calm wind conditions. During the takeoff roll, he lost directional control & the acft ground looped & was damaged. No mechanical problems were reported.Sep 9, 1985 · N27696 · Substantial damageNTSB MKC85LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bridgeport, NEN2920E was taking off on a 2,800 ft long, turf rwy. There was a lt crosswind of 12 KTS and the density alt was 5,000 ft. the plt said the acft encountered a dip in the rwy and swerved to the lt momentarily. He said he regained directional control but then…Sep 8, 1985 · N2920E · Substantial damageNTSB MIA85IA246Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · West Palm Bch, FLDuring take off roll the #4 engine failed causing catostrophic destruction of the engine. During subsequent examination the left vgv actuator pin was found to be missing. Without this pin the vgv ARM8 are aysemetrically driven. The vgv arms were found broken…Sep 8, 1985 · N1300L · Minor damageNTSB LAX85FA385Accident · 1 fatalField investigationFinal reportJonas Humming Bird · Tucson, AZThe experimental homebuilt acft was designed by the plt and incorporated a lifting body symetrical airfoil shaped fuselage. Pitch control was to be accomplished with a narrow chord canard. Witnesses saw the acft lift off briefly to about 10 ft AGL during the…Sep 8, 1985 · N14GJ · Substantial damageNTSB LAX85LA387Accident · No injuriesLimited investigationFinal reportCessna 170B · Buckeye, AZThe plt attempted to depart on soft silt & sand. During the takeoff roll the acft wheels sank into the soft terrain necessatating differential braking to maintain directional control. As the acft approached a ditch the plt forced the acft airborne. The acft…Sep 5, 1985 · N1659D · Substantial damageNTSB FTW85LA342Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Port Sulphur, LAThe plt stated he initiated his water takeoff run on a canal which had a left bend. When he rounded the bend he observed a 15-20 foot high piling (post) in the middle of the canal and a peninsula of land about 300 yards beyond the piling. He steered to the…Sep 5, 1985 · N5513E · DestroyedNTSB FTW85LA337Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Westbrook, TXThere were no known eye witnesses to the accident. Available evidence reveals that the pilot most probably made a successful landing in the remotely located field and rolled to a stop. The sheriff reported that the engine oil was drained onto the ground at…Sep 3, 1985 · N8043C · Substantial damageNTSB ATL85LA267Accident · No injuriesLimited investigationFinal reportBryan HP-14 · Aiken, SCPlt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to…Sep 2, 1985 · N5DB · Substantial damageNTSB ANC85LA166Accident · No injuriesLimited investigationFinal reportMaule M-5 · Cape Yakataga, AKThe plt reported that he started to depart from a gravel strip, then elected to abort the takeoff. While rolling on the ground, the acft hit a 'wash-out' which bent a structural tube on the landing gear assembly.Sep 1, 1985 · N51566 · Substantial damageNTSB CHI85FEP04Accident · Serious injuriesFinal reportPZL-Bielsko SZD-45A Ogar · Ft. Atkinson, WIWitnesses reported seeing the acft shortly after takeoff at an alt of aprx 40 to 50 ft AGL. At this time, according to witnesses, the eng slowed down, the acft turned left and dove into the terrain. No mechanical failure/malfunction was discovered during an…Aug 31, 1985 · N35AS · Substantial damageNTSB ANC85LA164Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Chetaslina Rvr, AKThe pilot stated that he run out of runway and he did not reach min flying speed for lift off. The tundra run way created more drag than the pilot had anticipated. The pilot then departed thr tundra runway lost directional control of the aircraft crusing a…Aug 29, 1985 · N83725 · Substantial damageNTSB NYC85LA225Accident · No injuriesLimited investigationFinal reportBeech G18S · Newark, NJWhile taking off with a left x-wind, the acft began to veer to the left. The plt corrected by using differential power & right brake, but the acft continued to veer left & went off the rwy. Subsequently, the right main gear collapsed & the acft was…Aug 28, 1985 · N9990R · Substantial damageNTSB ANC85LA161Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dillingham, AKThe pilot stated that approximately 200 ft into the rollout the right wing lifted into the air, veering the plane to the right losing directional control of the aircraft causing the aircraft to exit the runway into a gravel pit.Aug 25, 1985 · N86090 · Substantial damageNTSB LAX85LA363Accident · No injuriesLimited investigationFinal reportCessna 172N · Turlock, CAOn August 22, 1985, a Cessna 172N, N7338F, collided with a 3FT tall pole while taking off from Turlock, CA. VMC existed at the time. The ac was substantially damaged and the plt and his 2 pax were not injured. The plt stated that he was on the rwy when in…Aug 23, 1985 · N7338F · Substantial damageNTSB CHI85LA355Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ashkum, ILThe left wing of the acft contacted crops during an attempted takeoff. The plt reported liftoff was too soon and the acft veered left contacted crops. The plt stated that he should have stayed on rwy longer.Aug 21, 1985 · N99666 · Substantial damageNTSB CHI85LA353Accident · No injuriesLimited investigationFinal reportCessna 170B · West Chicago, ILDuring application of pwr during a touch-and go landing the acft 'started to get sideways' on the rwy. The plt allowed the acft to drift off the left side of the rwy into the grass. A ground loop subsequently occurred which substantially damaged the acft.…Aug 21, 1985 · N2209D · Substantial damageNTSB DEN85LTG07Accident · No injuriesFinal reportAeronca 058B · Mott, NDWhile departing a stubble field, the aircraft's tire ran into a soft spot in the ground and the aircraft turned and struck the shoulder of a road. The right gear broke and the right wing tip struck the ground, the right strut broke, the tail wheel and rudder…Aug 19, 1985 · N47500 · Substantial damageNTSB LAX85FA355Accident · Serious injuriesField investigationFinal reportCessna 150L · Rialto, CAThe christian eagle biplane was returning from a local instructional flight and entered the pattern on a normal 45 degree entry, announcing position and intentions on the UNICOM frequency. The Cessna 150 was departing the airport on a local instructional…Aug 18, 1985 · N19530 · 2 aircraft · DestroyedNTSB FTW85LA327Accident · No injuriesLimited investigationFinal reportCessna 150M · Lubbock, TXThe plt was advised that he was cleared for an intersection takeoff on rwy 17R. After his run up, the plt attempted a night takeoff to the north on an unlighted taxiway that ran parallel to the active runway. Controllers advised the pilot to abort, which he…Aug 18, 1985 · N714AE · Substantial damageNTSB MKC85FA189Accident · Serious injuriesField investigationFinal reportBell 47G-2A · Sedalia, MOThe plt was taking 2 passengers on a helicopter ride at a fair. Immediately after lift-off, he encountered a situation where he was unable to maintain directional control, so he reduced power & landed. Before coming to rest, the tail of the helicopter struck…Aug 17, 1985 · N3951U · Substantial damageNTSB MIA85LA236Accident · No injuriesLimited investigationFinal reportMooney M20F · Ft. Myers, FLThe acft settled to the rwy during the takeoff roll after the landing gear retracted. The plt stated that the landing gear collapsed for an unknown reason. A post accident inspection of the landing gear and related components revealed no defects or…Aug 16, 1985 · N7122V · Substantial damageNTSB CHI85LA350Accident · No injuriesLimited investigationFinal reportCessna C-172P · Zanesville, OHPlt aborted takeoff from taxiway when he realized that he as not on rwy. Plt stated he was confused by taxiway marking & he believes taxiway arrows are misleading.Aug 16, 1985 · N5279K · Substantial damageNTSB LAX85LA347Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hollister, CAThe plt and gnd witnesses reported that during the takeoff roll, the nose gear collapsed, followed by the main landing gears. Post-accident investigation disclosed the landing gear control handle was in the down position. All of the landing gear…Aug 14, 1985 · N7982Y · Substantial damageNTSB DEN85LA217Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ruidoso, NMAcft was 20 lbs over the max gross weight. Plt said he aborted the first takeoff due to a rough running eng. The plt performed a runup and attempted a second takeoff which was aborted again due to rough running eng. The acft ran off end of rwy and struck a…Aug 13, 1985 · N2905B · Substantial damageNTSB CHI85FA344Accident · No injuriesField investigationFinal reportLearjet 23 · Madison, WIThe plt elected to take off with a heavy loaded acft on the short rwy. The plt stated a loud noise was heard as the acft approached 80 KTS. The takeoff was aborted at 100 KTS. Hydroplaning was experienced and a loss of control occurred. The acft traveled off…Aug 13, 1985 · N61TS · Substantial damageNTSB CHI85LA343Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlette, MIThe student plt was cleared by his CFI for his second solo flt immediately following a period of dual traffic pattern instruction. As he began his takeoff run he failed to use sufficient right rudder quickly enough to prevent the acft from eventually…Aug 11, 1985 · N49292 · Substantial damageNTSB CHI85LA333Accident · No injuriesLimited investigationFinal reportCessna 172XP · Int'L Falls, MNThe acft veered hard to the rt & collided with the water during takeoff at about 45 mph. It was discovered that the left float failed and allowed the left float to turn rt and go under the rt float.Aug 10, 1985 · N1254V · Substantial damageNTSB SEA85FA190Accident · 2 fatalField investigationFinal reportBeachner Quick Silver · Vancouver, WAPlt was observed working on engine distributor prior to departure for weekend demo at airshow for design sales promotion. Witnesses noted engine sound on takeoff seemed less than normal. Acft lifted off, gear were retracted and acft climbed to about 200 ft…Aug 7, 1985 · N824CB · DestroyedNTSB ATL85LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCStudent pilot was on solo flight. He stated that another acft called on final as he was on runway for takeoff . Unsure of action to take since taxiway behind him was blocked, he rushed takeoff. A soft field takeoff was attempted. Nose was raised, tail dragged…Aug 7, 1985 · N48005 · Substantial damageNTSB FTW85FA306Accident · 1 fatalField investigationFinal reportCessna A150M · Levelland, TXThe plt had been observed to make takeoffs using maximum up elevator for liftoff. The elevator was found in a nineteen degree up position and both the left horizontal stabilizer and elevator were bent upward at the tip. The down elevator clevis was observed…Aug 6, 1985 · N9807J · Substantial damageNTSB CHI85LA341Accident · No injuriesLimited investigationFinal reportCessna 172H · Whitewater, WIAccording to the plt he planned to use max performance takeoff procedures out of the owner's manual for the takeoff. After brake release the acft began to roll down the sod rwy. Acceleration continued, but according to the plt, his airspeed increase seemed…Aug 6, 1985 · N8229L · Substantial damageNTSB ANC85LA148Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague Island, AKThe plt stated that during the takeoff roll, the acft was kept close to the waterline to stay on the hard sand. After rolling aprx 700 ft, the tail wheel was raised. At about that time, the left gear sank in soft sand & pulled the acft to the left.…Aug 6, 1985 · N4000C · Substantial damageNTSB ANC85LA147Accident · No injuriesLimited investigationFinal reportCessna 172 · Chickaloon Flat, AKThe plt made an off-arpt landing on an area of clay silt with sparse grass. After slowing the acft to about 20 to 25 mph, the nosewheel went into a shallow gully of soft clay. The acft then stopped abruptly & nosed over.Aug 6, 1985 · N61684 · Substantial damageNTSB NYC85LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Wildwood, NJN21521 taxied onto runway 10 at the intersection of runway 14 after observing another aircraft taxi and take off from that point. N21521 did not attain sufficient airspeed for takeoff prior to running out of available runway. The pilot did not apply hard…Aug 5, 1985 · N21521 · Substantial damageNTSB SEA85LA185Accident · No injuriesLimited investigationFinal reportBeech B-35 · Auburn, WADirectional control of the acft was lost for unknown reasons just prior to rotation. The acft then veered off the right side of the rwy.Jul 30, 1985 · N3729N · Substantial damageNTSB DEN85FA203Accident · 2 fatalField investigationFinal reportCessna C-182 · La Salle, COThe plt and his girlfriend t/o from a pvt airfield north of denver co in a C182 in heavy fog conditions. The pilot was not inst rated. Shortly after t/o the aircraft hit the ground and was destroyed. Both occupants rec'd fatal injuries.Jul 30, 1985 · N5642B · DestroyedNTSB BFO85LA064Accident · No injuriesLimited investigationFinal reportStampe SV4C · Fredericksburg, VAThe acft lost directional control and veered to the right. Colliding with a tied down Cessna 210, N2542X, while taking off from rwy 23 at shannon airport, Fredericksburg, Virginia.Jul 28, 1985 · N10WN · Substantial damageNTSB ANC85FA136Accident · Minor injuriesField investigationFinal reportCessna 180H · Anchorage, AKThe pilot attempted to takeoff uphill from a short airstrip with a steep incline during a no wind condition. The airplane drifted off the centerline after liftoff and struck three parked airplanes before hitting trees and turning over. Uphill takoffs are not…Jul 28, 1985 · N71RD · Substantial damageNTSB ANC85LA134Accident · No injuriesLimited investigationFinal reportCessna 206 · Kustatan River, AKThe plt reported that he was taking off from a River/lake area with glassy water on a hot/sultry day. After initial lift-off, the acft settled & touched down on the water, then lifted off again. It flew beyond the edge of the lake, then settled & nosed over…Jul 27, 1985 · N4649U · Substantial damageNTSB NYC85LA193Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Worcester, MAThe instructor (CFI) & student were practicing touch-&-go landings. On the 4th landing, the apch & touchdown were made with full flaps extended. The CFI began to retract the flaps while the student applied full power for takeoff. The acft became airborne &…Jul 24, 1985 · N999RH · Substantial damageNTSB NYC85LA188Accident · No injuriesLimited investigationFinal reportLake LA-4 · Sidney, MEAccording to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was…Jul 21, 1985 · N6668L · Substantial damageNTSB FTW85LA295Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · South MarshThe plt was initiating a takeoff from a hover off an offshore oil rig. As he lowered the nose for takeoff, he heard a loud noise emit from the tailboom area & the acft began rotating to the right. The plt continued to apply pwr and autorotated to the water.…Jul 21, 1985 · N5753D · DestroyedNTSB CHI85LA288Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Eden Prairie, MNThe acft collided with the fence during an aborted takeoff. The tires of the acft showed signs of hydroplaning after the accident. No mechanical discrepancies were noted during the investigation. The takeoff was aborted the plt said because the acft yawed…Jul 18, 1985 · N22PG · Substantial damageNTSB ATL85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt Sterling, KYThe insturctor (CFI) was demonstrating a soft field takeoff from a grass area beside the rwy. At that time, the acft lifted off, then settled back onto the grass. The CFI reported that the right main gear touched down in a hole which caused the acft to veer…Jul 18, 1985 · N67825 · DestroyedNTSB ANC85FA130Accident · No injuriesField investigationFinal reportPiper PA-22/20 · Alexander Lake, AKThe plt lost directional control of the acft during takeoff and the acft rolled into rough terrain along side of the rwy where it nosed over.Jul 18, 1985 · N3445Z · Substantial damageNTSB CHI85LA295Accident · No injuriesLimited investigationFinal reportRobert Thibodeau JR ACE · Troy, MIOn July 17,1985 at 1015 EDT, a Robert Thibodeau jr ace N3642, registered to and flown by Robert Thibodeau, lost control and collided with the terrain on takeoff at Troy oakland airport, Troy,Michigan, while on a personal flight. Visual meteorological…Jul 17, 1985 · N3642 · Substantial damageNTSB ATL85LA214Accident · Minor injuriesLimited investigationFinal reportWag-Aero Cubbie (J-3) · Stockbridge, GADuring a departure, the eng had a partial loss of power. The plt reported that after climbing to about 75 ft, neither the acft's speed nor alt would increase. He lowered the nose to increase the eng RPM & speed, but the eng did not respond. Subsequently, the…Jul 16, 1985 · N909GH · Substantial damage