OpenAirDocs.org

NTSB investigations

20,559 cases where the phase of flight was Initial climb.

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 = 350)
  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 DEN86LA194Accident · No injuriesLimited investigationFinal reportCessna 120 · Riverton, WYPlt stated after accident '... We could not climb after initial takeoff and a pwr line was coming up so I tried to turn right and the plane stalled.' The density altitude was calculated to be 7,136 feet MSL. The plt stated that he did not lean the mixture for…Jul 11, 1986 · N3099N · Substantial damageNTSB BFO86LA039Accident · No injuriesLimited investigationFinal reportCessna 150M · Clifton, VAAccording to the pilot, he and his wife had departed mount olive, NC on the morning of the accident enroute to romeo, MI. After refueling at danville, VA they departed but ran into weather near beckly and diverted to the east. Unable to locate greenbrier…Jul 11, 1986 · N704VE · Substantial damageNTSB ATL86LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Augusta, GADuring takeoff from an emergency landing zone, the aircraft collided with power lines and made a precautionary landing on the median between the highway. The helicopter was operating as an emergency medical services helicopter and the pilot was responding to…Jul 11, 1986 · N5733X · Substantial damageNTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.Jul 10, 1986 · N2NH · Substantial damageNTSB LAX86LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paso Robles, CAThe plt was informed that he was trailing smoke on climb out. The plt elected to continue the climb due to IMC at the departure arpt and divert to another arpt located 26 NM north. He continued to climb to 4,500 ft MSL to VMC. The oil warning light…Jul 9, 1986 · N39944 · Substantial damageNTSB NYC86FHM01Accident · No injuriesFinal reportPiper PA-25-235 · Goshen, NYA loss of engine power was experienced during takeoff. The plt was unable to maintain altitude and a forced landing was made in an open field. The nose gear dug into soft terrain and the acft nosed over. Post accident inspection of the acft revealed water in…Jul 8, 1986 · N6795Z · Substantial damageNTSB SEA86LA163Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Sandy, ORPlt experienced power surges on takeoff, elected off-airport landing, allowed acft to contact ground nose-low while maneuvering to avoid trees. Inspection did not reveal mechanical failure/malfunction.Jul 7, 1986 · N6606M · Substantial damageNTSB CHI86LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student plt initiated the takeoff, however, the CFI took over control of the acft when it became apparent that the acft was not climbing. The CFI was unable to salvage the takeoff and the acft struck and settled into trees at the departure end of the rwy.Jul 7, 1986 · N32858 · DestroyedNTSB ATL86LA188Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Welch, WVWitnesses reported that the pilot had worked on the engine carburetor for some time as well as just before the accident takeoff. At about 200 feet after takeoff from rwy 27 the engine quit and the pilot made a left turn back to the rwy and tried to align the…Jul 7, 1986 · N70824 · DestroyedNTSB SEA86FA155Accident · 2 fatalField investigationFinal reportAeronca 7AC · Mulino, ORThe pvt plt had been giving rides around the local area for about an hour. He had just dropped off one passenger and picked up another. The acft taxied from the ramp to the rwy 30 and made a normal takeoff. During crosswind turn the engine started to miss and…Jul 5, 1986 · N84463 · DestroyedNTSB NYC86LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · West Dover, VTShortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.Jul 5, 1986 · N43792 · Substantial damageNTSB MKC86LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Iowa City, IAThe flight instructor stated that he had planned to conduct an engine-out drill after takeoff by reducing power to the starboard engine. During the engine-out drill the student reduced power to the operating engine and the aircraft landed hard back on the…Jul 5, 1986 · N1130P · Substantial damageNTSB MKC86LA143Accident · No injuriesLimited investigationFinal reportBeech C23 · Cheney, KSThe pilot stated that the aircraft was barely airborne as it reached the end of the airstrip, on the takeoff roll. At this point he encountered crosswind conditions and the aircraft mush/stalled and impacted the ground. Post-accident computations reveal that…Jul 4, 1986 · N66353 · Substantial damageNTSB NYC86LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Block Island, RIThe eng lost partial power on the initial climb-out as the plt was taking off from rwy 28. He initiated a left turn back to the arpt, but the eng lost all power. Subsequently, the acft was landed in an area of brush & small trees near the west end of the…Jul 3, 1986 · N5533J · Substantial damageNTSB ATL86LA193Accident · No injuriesLimited investigationFinal reportCessna 177A · Huntsville, ALThe acft had set on the ramp with little fuel in it for aprx one week. Just before the accident flt, the pilot took fuel samples, but found no water. He then taxied to the fuel pumps and added aprx 20 gal of fuel in each tank. Another fuel sample was not…Jul 3, 1986 · N30365 · Substantial damageNTSB ANC86LA097Accident · No injuriesLimited investigationFinal reportCessna 305 · Figure Eight Lk, AKThe plt attempted an emergency landing on a lake following a partial pwr loss in-flt. During touchdown the plt lost control of the acft which nosed over on it's back and sank into the lake. The acft was not recovered from the water.Jul 3, 1986 · N5312G · Substantial damageNTSB MKC86LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Lake City, ARThe acft dptd the rwy normally to fertilize a nearby fld. The PIC stated that the acft lost pwr shortly into the climb and he had to make a forced lndg off airport. The PIC was unable to dump the load of fertilizer aboard before impact in a rice field. The…Jul 2, 1986 · N78MH · Substantial damageNTSB DEN86LA183Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bynum, MTAfter the first landing on a gravel road for reloading liquid insecticide the pilot attempted to take off for an aerial application flight. During the take off ground roll the pilot observed that the left door was not properly closed. He momentarily reduced…Jul 2, 1986 · N7099Z · Substantial damageNTSB LAX86FVA10Accident · Serious injuriesFinal reportBell UH-1B · Le Grand, CAThe helicopter experienced an engine failure shortly after lift-off prior to a spray run on a nearby field. The engine decelerated to zero and the acft collided with the ground. Examination of the engine revealed the turbine rotor was destroyed and evidence…Jun 30, 1986 · N64789 · Substantial damageNTSB FTW86FRD17Accident · Minor injuriesFinal reportGrumman G-164 · Rayville, LAThe acft crashed during takeoff after losing pwr during a turn at 150 ft AGL. The plt said that the acft stalled and hit in a cotton field about 1/4 mile from the arpt. The plt also said oil hit the windshield about 3 seconds before pwr failure. The acft was…Jun 30, 1986 · N964X · DestroyedNTSB NYC86LA164Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Marstons Mills, MAThe eng lost power as the acft was climbing thru about 60' AGL during takeoff. The plt rprtd that he was forced to turn back toward the arpt since there was a wooded area & a residential area ahead. Subsequently, the acft was extensively damaged when it crash…Jun 29, 1986 · N3625Q · Substantial damageNTSB CHI86LA161Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, MNThe plt was attempting to takeoff from a field when the accident occurred. During takeoff, the acft failed to clear trees at the departure end of the field. The acft contacted the trees and descended to the terrain. The plt had diverted to this field during a…Jun 29, 1986 · N13363 · DestroyedNTSB MIA86LA194Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Opa Locka, FLThe instructor plt stated that on takeoff just as he turned his crosswind leg, the engine lost power and he turned back to the airport, landed short of the runway and the aircraft flipped over and came to rest inverted. Post crash examination of the engine…Jun 28, 1986 · N714MT · Substantial damageNTSB LAX86LA273Accident · No injuriesLimited investigationFinal reportSchleicher ASW-19 · Warner Springs, CAThe plt became aware of the loss of the elevator control as the glider began it's initial climb during an aerial tow. He released from the tow aircraft and made an off arpt forced landing in tall grass. The glider's right wing became entangled in the grass…Jun 28, 1986 · N5LR · Substantial damageNTSB ANC86LA093Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Tolsona Lake, AKThe private pilot attempted to turn downwind when he encountered downdraft conditions during a floatplane takeoff. The airplane stalled and crashed into the lake he departed from.Jun 28, 1986 · N6910K · DestroyedNTSB FTW86LRG28Accident · No injuriesFinal reportCessna A188B · Temple, TXDuring the initial climb after takeoff the pilot experienced a loss of power and attempted to return to the private airport from which he had departed. Unable to reach the runway the aircraft landed in rough terrain colliding with a mound of dirt. Both main…Jun 27, 1986 · N8245G · Substantial damageNTSB ATL86LA184Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Little River, SCThe plt reported that the glider was violently rolled into a 90 left bank by strong crosswinds at about 250 ft AGL, while it was being towed aloft. The plt's cockpit canopy came open, and the plt attempted to close and secure it. The canopy came open again…Jun 26, 1986 · N302BG · DestroyedNTSB SEA86LA152Accident · No injuriesLimited investigationFinal reportRockwell S2R · Caldwell, IDShortly after departure the pilot could not get any aileron response. A landing was attempted at a nearby airport where a go around became necessary. During the go around control of the aircraft was lost and it descended to ground impact. Investigation…Jun 25, 1986 · N4973X · DestroyedNTSB MIA86LA191Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Ft Lauderdale, FLThe plt stated that just as he rotated the acft for takeoff, the cabin door popped open. The acft then struck the ground hard in a nose down attitude, sheared off the main landing gear and slid to a stop on the runwy. According to the emergency procedures in…Jun 25, 1986 · N313RM · Substantial damageNTSB MKC86LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Wrightsville, ARThe PIC of the PA22 was practicing departures fm a confined field. The PIC stated that the acft engine had been operating normally, and that he had been operating fm this area for about the previous 1/2 hr. The PIC stated the eng quit on climbout fm the pvt…Jun 22, 1986 · N1618P · Substantial damageNTSB LAX86LA263Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Truckee, CADuring an air show 3 North American, AT-6, acft took off in what the plt of the 3rd acft described as 'staggered' sequence. A witness described the departures as being 'information' or in 'close proximity' to each other. The first 2 acft gained altitude…Jun 22, 1986 · N29936 · Substantial damageNTSB SEA86LA149Accident · No injuriesLimited investigationFinal reportMellema Bede 4 · Kent, WAThe engine ceased operating 10 feet a.g.l. during takeoff while on a biennial flight review. A landing straight ahead was made onto the runway, but in order to avoid an overrun an intentional ground loop was made. On engine examination a large bug was found…Jun 21, 1986 · N76VR · Substantial damageNTSB NYC86FNA01Accident · No injuriesFinal reportSteen Skybolt UNK · Beverly, MAThe Steen Skybolt modified with a turbo-prop conversion experienced a power loss on takeoff after achieving an altitude of 200-300 ft AGL and made a hard landing on the runway remaining. The landing gear collapsed and aircraft received substantial damage. The…Jun 21, 1986 · N932JF · Substantial damageNTSB DEN86LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bosler, WYAccording to the plt, the acft had just become airborne when it encountered a gust of wind while simultaneously crossing a gully, lost lift & descended until ground contact. The plt also indicated there was a 'density altitude problem.' The density altitude…Jun 21, 1986 · N79221 · Substantial damageNTSB ATL86LA180Accident · No injuriesLimited investigationFinal reportCessna 172P · Salisbury, NCThe plt reported that the engine lost power and quit shortly after T/0 at about 500-700 ft AGL. He checked the mixture, carb heat and mags but was unable to restart the engine. A 180 turn was made back to the arpt. The plt stated that he let the airspeed…Jun 21, 1986 · N52601 · Substantial damageNTSB ATL86FMG08Accident · 1 fatalFinal reportH. Preiss HP-19C · Boone, NCThe glider made a steep nose high turn, stalled and crashed after a premature tow release at aprx 150 ft AGL. Witnesses said that the glider appeared to be badly controlled from the beginning of the takeoff roll. After the stall during the turn the acft…Jun 21, 1986 · N4259Y · DestroyedNTSB ANC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Egegik, AKThe airplane experienced a power failure and nosed over in one foot of water while making an emergency landing on a beach.Jun 19, 1986 · N5907Z · Substantial damageNTSB ANC86LA084Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe plt reported that a loud bang was heard at an alt of about 25 ft AGL shortly after takeoff. The acft settled to the rwy and pwr was regained. The acft then veered off the left side of the rwy and nosed over. Post accident inspection revealed maintenance…Jun 19, 1986 · N2393C · Substantial damageNTSB FTW86LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Weatherford, TXThe plt experienced a power loss at approximately 200 feet during the takeoff climb portion of the flight. On descent the aircraft collided with a tree before coming to rest in a field. During pre-flight the pilot noted the fuel tanks were half full and there…Jun 18, 1986 · N6469E · Substantial damageNTSB DEN86FTG01Accident · Serious injuriesFinal reportPiper PA25-235 · Stanley, NDThe acft went off the departure end of the rwy and collided with a ditch after which it erupted in flames. The temperature was 87 degrees with light wind. The density alt was computed to be 5000 ft. the plt had stated to the operator that he thought it was…Jun 18, 1986 · N6535Z · DestroyedNTSB MIA86FA184Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Boynton Beach, FLAccording to witnesses, the acft entered a turn shortly after taking off from a touch-&-go landing, then stalled & began to spin to the right. The acft impacted the ground at the edge of a canal, aprx 1000 ft from the dept end of the rwy. One witness stated…Jun 17, 1986 · N1318V · DestroyedNTSB LAX86DVA09Accident · No injuriesFinal reportHiller UH-12E · Delano, CAThe helicopter rotor blade delaminated shortly after departing the operator's north base at Delano, CA. The investigation determined the blade contained extensive voids on the bond line. The blade was rejected by the manufacturer as being unairworthy. The…Jun 17, 1986 · N172ET · Substantial damageNTSB DEN86FTK03Accident · 1 fatalFinal reportPiper PA-25 · Badger, SDThe acft nosed over during a forced landing after takeoff. The acft was landed straight ahead and rolled out into a standing pool of water 8-10 inches deep where it flipped over crushing the canopy and trapping the plts body. During post acc invest sediment…Jun 17, 1986 · N6120Z · Substantial damageNTSB BFO86FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDWitnesses indicated that the engine sounded normal during takeoff run but started to lose power shortly after liftoff. The aircraft departed on runway 30 at lee airport, annapolis, MD. The runway is 2400 feet long and beards creek is located about 200 feet…Jun 17, 1986 · N6959W · DestroyedNTSB ANC86LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · King Salmon, AKThe plt stated that after lift off the acft stalled. He then lost directional control and the acft contacted a ditch.Jun 17, 1986 · N2937P · Substantial damageNTSB ANC86FA081Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Lakecreek River, AKAccording to a witness on the ground, the pilot-in-command landed from west to east and after unloading the supplies decided to takeoff in the same direction. The pilot taxied down to the end of the runway and upon turning around the witness stated the tail…Jun 17, 1986 · N83377 · DestroyedNTSB ANC86LA077Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Vogel Lake, AKAfter takeoff from a small lake the pilot stated that engine started to run rough. The pilot stalled the aircraft and crashed into the lake. Examination of the engine revealed that the number 4 cylinder primer port plug was broken.Jun 16, 1986 · N1556N · Substantial damageNTSB NYC86LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Palmer, MAThe acft climbed in an excessively nose high attitude upon rotation at 60 mph. It then veered left and settled to the left side of the rwy. The plt reduced the power to idle and applied braked. The acft continued to slide and collided with trees. The acft was…Jun 15, 1986 · N1866T · DestroyedNTSB DEN86LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMThe plt stated that shortly after takeoff the engine began running rough and she was cleared by the tower to land on any rwy. The plt chose rwy 10. She added one notch of flaps over the rwy threshold and the acft continued to float, touching down with 1/3 of…Jun 15, 1986 · N52985 · Substantial damageNTSB ATL86LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Middle Bass Is., OHHeavy rains had flooded the causeway that connected Middle Bass island to the main island. A family was in need of transportation off the island and the pilot was attempting to fly them to the mainland using the 2,100 foot grass airstrip. The airstrip was wet…Jun 15, 1986 · N9135W · Destroyed