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 CHI86FA102Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Frankfort, MIThe plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…Mar 14, 1986 · N123RM · DestroyedNTSB SEA86LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Morgan, ORDuring takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.Mar 12, 1986 · N45174 · Substantial damageNTSB MIA86FA093Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kissimmee, FLThe flt departed with 18 gals in each fuel tank. After 1.8 hrs of flying, doing takeoffs and landings and a short flt to another arpt, the flt experienced an eng failure during takeoff from a touch and go landing. The plt failed to maintain directional…Mar 8, 1986 · N877AP · Substantial damageNTSB FTW86FPA21Accident · Minor injuriesFinal reportCessna 150K · Cresson, TXThe flt departed with an estimated 8 to 9 gallons of fuel (auto gas) on board with a dual student and a flt instructor. Forty five minutes of touch-and-go landing practice was accomplished. On the sixth takeoff and about 30 feet above the ground the engine…Mar 7, 1986 · N6307G · Substantial damageNTSB DEN86LA093Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bountiful, UTAcccording to the student plt, touch and go landings were being practiced when the acft stalled on takeoff. Witnesses stated the plt lowered the nose in an attempt to recover from the stall, however, the acft contacted the rwy.Mar 7, 1986 · N91319 · Substantial damageNTSB MIA86LA090Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLThe plt stated that just after picking up a banner, the acft stalled and started to roll to the left. The plt was unable to recover before the acft impacted the ground.Mar 4, 1986 · N53805 · Substantial damageNTSB DEN86FTI01Accident · Minor injuriesFinal reportMiller Sievers Special · Gillette, WYOn March 3, 1986 at approximately 1715 MST, an experimental Miller, sievers special, struck the ground during takeoff at the Gillette-campbell county airport, Gillette, Wyoming. The pilot stated that just after takeoff on runway 34, the aircraft appeared to…Mar 4, 1986 · N1175 · Substantial damageNTSB MIA86LA088Accident · No injuriesLimited investigationFinal reportBeech D-18S · Pascagoula, MSThe plt stated that he sensed a loss of pwr on one eng after takeoff, just prior to gear retraction. He elected to remove all pwr and land straight ahead on the remaining rwy. The acft went off the end of the rwy and entered a wet grass area. The acft could…Mar 2, 1986 · N4446K · Substantial damageNTSB DEN86LA091Accident · No injuriesLimited investigationFinal reportCessna 175 · Kulm, NDAccording to the plt, the eng lost partial pwr on takeoff due to carberetor ice. A forced landing was made during which the nose gear collapsed resulting in substantial damage to the acft.Mar 2, 1986 · N7647M · Substantial damageNTSB DEN86LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Rosa, NMAccording to the plt, the eng quit during the initial climbout and the acft was substantially damaged during the subsequent forced landing. Post accident inspection disclosed the gascolator was broken which resulted in fuel starvation to the engine.Mar 2, 1986 · N85255 · Substantial damageNTSB NYC86FNE02Accident · No injuriesFinal reportFolsom Sonerai II · Middlebury, CTThe plt reported that the acft was slow to climb after takeoff and had reached an alt of only 100' AGL at the end of the 5000' lond rwy. The plt continued to state the acft was unable to clear rising terrain aprx 1/2 mile from the arpt. The acft contacted the…Mar 1, 1986 · N27EF · Substantial damageNTSB NYC86LA079Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Lyndonville, VTAfter the pilot performed a run up and all appeared normal a ground run was commenced. About 700' down the runway trim was set to climb out at about 76IAS. However, the pilot stated that a bad downdraft was encountered. A check of the airspeed was ok. At 200…Feb 27, 1986 · N108DT · Substantial damageNTSB DEN86LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Quemado, NMThe plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…Feb 26, 1986 · N8935V · Substantial damageNTSB ATL86FA081Accident · 1 fatalField investigationFinal reportRobinson R22 · Greenville, TNThe flt was last seen to depart rwy 23 at the Greenville arpt & enter a low cloud layer at ngt. A witness estimated the helicopter entered the clouds at about 300 to 400 ft AGL. No flt plan was filed. The wreckage was found the next day, located about 1/4 mi…Feb 23, 1986 · N90459 · DestroyedNTSB LAX86LA122Accident · Serious injuriesLimited investigationFinal reportHenley Aerodrome Fokker DR1 · Santa Ynez, CAA homebuilt aerodrome fokker DR1 crashed after takeoff. The acft had been in storage for over 5 yrs and had just completed an annual inspection. The flt was a post annual inspection test flt. The plt had extensive experience maintaining and flying homebuilt…Feb 21, 1986 · N50CH · DestroyedNTSB FTW86LQG10Accident · No injuriesFinal reportPiper PA-22-150 · Skellytown, TXThe pilot stated that his take off roll was longer than expected. Reaching the end of the runway, he rotated & the acft left the ground, but it did not establish a good rate of climb. Subsequently, the acft collided with a pole & crashed. The takeoff was…Feb 20, 1986 · N9995D · Substantial damageNTSB ATL86LA076Accident · Minor injuriesLimited investigationFinal reportPiper J3L-65 · Sevierville, TNDuring takeoff initial climb the engine lost power and a forced landing was initiated. During the descent the aircraft contacted treetops prior to ground impact. Post-crash examination of the engine disclosed that one of the cylinders had broken away from the…Feb 16, 1986 · N30233 · Substantial damageNTSB MIA86FA076Accident · 2 fatalField investigationFinal reportCessna 340A · Dania, FLShortly after takeoff on a check-out flight the aircraft was observed on crosswind leg to descend until impact. There was an extensive post impact fire. Witnesses heard the aircraft make a 'poof' type of noise just as the pilot radioed the control tower and…Feb 14, 1986 · N1923E · DestroyedNTSB MIA86IA075Incident · No injuriesIncident investigationFinal reportPiper PA-31-1020 · Panama City, FLThe plt stated that all attempts to extend the landing gear were to no avail & he elected to land with the nose gear not fully locked down. On landing rollout the nose gear completely collapsed. Post crash examination of the nose landing gear revealed that…Feb 13, 1986 · N41703 · Minor damageNTSB SEA86LA059Accident · No injuriesLimited investigationFinal reportAlon A2 · Woodburn, ORThe pilot was attempting to depart the sod 1300 foot runway and due to poor soft field technique failed to clear a fence.Feb 12, 1986 · N5632F · Substantial damageNTSB ATL86FLQ05Accident · Serious injuriesFinal reportBeech H-18 · Louisville, KYThe acft collided with the ground after stalling during takeoff. Witnesses reported that the acft pitched up in two increments, climbed sharply to about 200 ft AGL, stalled dropped the rt wing and descended, impacting the ground in a flat attitude.Feb 12, 1986 · N148PA · Substantial damageNTSB LAX86LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAA Cessna 172 collided with a berm after an aborted takeoff. The pilot indicated after liftoff from the runway, the aircraft climbed to 100 feet AGL and began to sink. The pilot then elected to abort the takeoff. The aircraft landed on the departure end of the…Feb 9, 1986 · N1507V · Substantial damageNTSB ATL86LA071Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Columbia, SCWhile on crosswind following takeoff the engine lost total power after climbing to 500 feet AGL. The pilot initiated a turn toward a field and collided with trees on the approach end of the field. Post-crash examination of the aircraft revealed that the…Feb 9, 1986 · N3773F · Substantial damageNTSB ANC86LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot lost control of the airplane while taxiing, inadvertently took off in gusty wind and crashed into adjacent trees.Feb 7, 1986 · N4431Z · Substantial damageNTSB DEN86FA075Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Bismarck, NDThe acft was observed descending out of a low ceiling when it suddenly made an abrupt left turn. Engine noise seemed to increase momentarily and then the nose of the acft dropped to a near vertical position. The twin engine acft crashed into a vacant house…Feb 6, 1986 · N55654 · DestroyedNTSB MKC86IA058Incident · No injuriesIncident investigationFinal reportSAAB-Fairchild SF340 · St. Louis, MOOn initial climbout fm lambert field, St. Louis, Missouri, the control tower at lambert rptd to the PIC of flt 1163 that one of the main landing gear wheels had fallen off the acft. The acft was returned and landed safely. Initial inspection revealed what…Feb 5, 1986 · N342AM · No damageNTSB SEA86IA058Incident · No injuriesIncident investigationFinal reportCessna T210 · Roche Harbor, WAOn initial climb after takeoff, electrical fire broke out in back of pilot's yoke. Pilot managed to extinguish five- inch flames by hand, climbed to 2000 feet and evaluated situation. Noting no further problems, flight was continued to destination. Enroute,…Feb 4, 1986 · N5205A · No damageNTSB ATL86FKG06Accident · 2 fatalFinal reportBushby Mustang II · Brownsboro, ALThe acft collided with the ground in an inverted attitude during a forced landing after a power loss at 400 ft AGL during takeoff. The acft was observed to turn after the power loss and then the wings leveled. Power was heard to resume at about 100 ft AGL.…Feb 2, 1986 · N32RH · DestroyedNTSB LAX86LA105Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Fremont, CAOn February 1, 1986 at about 1045 PST a grob 103 glider, N103BK, ground looped in mud following an aborted takeoff at sky sailing airport, freemont California. The pilot elected to abort the takeoff because it appeared the tow aircraft was not climbing…Feb 1, 1986 · N102BK · Substantial damageNTSB LAX86FVG01Accident · No injuriesFinal reportCommings Vari EZE · Lower Lake, CAThe acft struck a tree during forced landing off the arpt after a reported power loss. Post-accident engine exam showed no reason for a power loss. Plt suspects carb ice.Feb 1, 1986 · N82RC · Substantial damageNTSB ATL86LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Alexander City, ALThe acft was observed to make one takeoff and landing from an umimproved pasture. The second takeoff attempted was unsuccessful and the acft collided with a tree and crashed to the ground. The plt did not report any mechanical problems with the acft. There…Feb 1, 1986 · N52238 · Substantial damageNTSB ATL86LA067Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lumberton, NCThe plt was on takeoff from rwy 05 when rwy 13 was being reported by the arpt operator over UNICOM as the active rwy. During climb out the plt spotted another acft lined up with rwy 13 (apparently to land). He entered a steep climb and started looking for the…Feb 1, 1986 · N25350 · DestroyedNTSB CHI86FA079Accident · 2 fatalField investigationFinal reportCessna 421C · Birmingham, MIAt rotation the right eng failed. The acft entered a skidding turn to the rt and continued to climb to about 100 ft AGL. During the turn 110 deg from t.o. heading acft rolled inverted and descended into a car port. Extensive post impact fire destroyed acft,…Jan 29, 1986 · N68653 · DestroyedNTSB SEA86FA046Accident · 3 fatalField investigationFinal reportCessna 401 · S. Lake Tahoe, CAAcft took off in clear wx but below-freezing temps with heavy frost on acft surfaces. No preflight, run-up or warm-up performed. On initial climb, left eng power loss occurred for undet reason, but probably associated with temp/cold eng operation. Plt turned…Jan 27, 1986 · N988JM · DestroyedNTSB MIA86IA066Incident · Minor injuriesIncident investigationFinal reportBoeing 747-123 · Miami, FLShortly after departure the crew noted smoke in the cabin and the cockpit. The captain declared an emergency and landed back at the departure airport. He then directed an emergency evacuation. During the evacuation several emergency slides failed to deploy…Jan 27, 1986 · N9674 · No damageNTSB LAX86LA098Accident · Minor injuriesLimited investigationFinal reportBell 222UT · La Habra, CAOn January 26, 1986 a Bell 222UT collided with a 3/8 inch support cable. The pilot saw the lower of two of the three support cables about 75 feet AGL as he was transitioning to forward flight from a vertical max performance t/o. the pilot applied aft cyclic…Jan 26, 1986 · N3177G · Substantial damageNTSB LAX86FVD04Accident · 1 fatalFinal reportVangrunsven RV-3A · Fortuna, CAThe acft stalled in a turn during a forced landing after the engine lost power. Post acc investigation revealed an inoperative fuel selector valve. Witnesses said that the acft did not sound like it was developing full pwr during take off roll. Shortly after…Jan 25, 1986 · N661S · DestroyedNTSB CHI86FEI02Accident · Serious injuriesFinal reportCessna 150H · Strongsville, OHDuring preflight, the student pilot noticed water in the fuel tank when he checked the fuel drain. He notified his instructor, but no further action was taken. Shortly after takeoff the engine quit. An emergency landing was performed in a parking lot and one…Jan 24, 1986 · N22755 · Substantial damageNTSB ANC86LA022Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe pilot stated that during the initial climb out approximately 50 feet above the ground the engine quit. The aircraft crashed into a row of trees and the pilot was not injured. Examination of the aircraft engine revealed no malfunction or mechanical…Jan 20, 1986 · N3165D · Substantial damageNTSB MKC86FA053Accident · 4 fatalField investigationFinal reportCessna 210H · Fremont, NEThe plt of N5961F received a wx brf about 40 min before the acdt for a VFR flt from Fremont to cheyenne. The 3 reporting stations nearest to Fremont were IFR and local authorities who helped search for the acdt site reported low clouds and haze. There were no…Jan 19, 1986 · N5961F · DestroyedNTSB MIA86LA060Accident · No injuriesLimited investigationFinal reportBeech B24R · Fernandina Bch, FLThe plt stated that just after he rotated, he experienced a loss of power, extended his landed gear & landed hard causing a collapse of the landing gear. Post crash examination of the eng revealed that the right magneto was improperly timed & the left magneto…Jan 19, 1986 · N2520W · Substantial damageNTSB SEA86FA041Accident · 1 fatalField investigationFinal reportCessna 182 · Juneau, AKPilot requested clearance to return to airport after takeoff due to eng power loss. Clearance was given by ATC. Pilot made rt turn from about 100 ft alt. Acft crashed about 1500 foot south of rwy. No shoulder harnesses installed. Pax survived. Ice found on…Jan 18, 1986 · N9331G · DestroyedNTSB NYC86LA065Accident · No injuriesLimited investigationFinal reportCessna 305-L-19 · Hilltown, PAThe Cessna was towing a glider when at an altitude of about 150 feet to about 200 feet, a decrease in RPM was experienced. The glider was detached from the aircraft, the nose was lowered and a left turn made while still over the gliderport. A rapid descent…Jan 18, 1986 · N5171G · Substantial damageNTSB LAX86LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Cottonwood, AZThe acft had not been flown for about 4 yrs. The plt intended to fly it to chandler, AZ, for an annual inspn. The pax stated the plt had previously made a test flt, but had a problem starting the eng. Rprtdly, the plt 'cleaned the fuel system and filled the…Jan 18, 1986 · N21995 · Substantial damageNTSB LAX86LA093Accident · No injuriesLimited investigationFinal reportRockwell 112TC · San Carlos, CAThe acft experienced a loss of eng pwr at an alt of aprx 400 ft AGL during a takeoff climb. The plt made a forced landing in a muddy fld next to the rwy and the acft nosed over. The plt thought the single drive dual magneto had failed but could not be…Jan 17, 1986 · N1317J · Substantial damageNTSB NYC86LA060Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJThe student and instructor (CFI) were performing touch-and-go landings. On the third touch-and-go, the student rotated the acft and initiated his climb. The CFI stated 'I realized the acft was not climbing and that the flaps were not retracted even though the…Jan 13, 1986 · N68214 · Substantial damageNTSB MIA86FA059Accident · 1 fatalField investigationFinal reportCessna 150M · Summerfield, FLThe private pilot departed the sod airfield and was observed to perform a steep rotation and intital climb. The winds were off the aircrafts left tail and were observed to be gusty. The aircraft was then observed to lose control and enter a spin to the left.…Jan 13, 1986 · N714AY · DestroyedNTSB LAX86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Kalaupapa, HIThe plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…Jan 13, 1986 · N53SA · Substantial damageNTSB FTW86FQG05Accident · No injuriesFinal reportPiper PA-24-260 · Big Spring, TXThe aircraft collided with barriers marking a displaced threshold during an emergency landing immediately after departure. The pilot reported that the engine began running rough, then quit completely. The engine ran successfully following the accident. The…Jan 12, 1986 · N9183P · Substantial damageNTSB LAX86FA089Accident · 3 fatalField investigationFinal reportCessna 172N · Grand Canyon, AZThe acft deptd runway 03 at Grand Canyon airport, Grand Canyon, AZ on a moonless night. Shortly after departure the aircraft entered into a left turn. The aircraft collided into some trees in about a 45 deg nose down and about a 15 deg left wing down attitude…Jan 9, 1986 · N2113E · Destroyed