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 NYC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Madison, CTThe acft experienced an engine failure during takeoff and the plt made a forced landing in a river. Post accident inspection did not determine cause of the power loss. It should be noted that the acft was under water for several hours prior to examination.May 6, 1986 · N2841M · Substantial damageNTSB LAX86DVA07Accident · 1 fatalFinal reportWright BD5B · Merced, CAGround witnesses and the pilot reported the canopy opened shortly after departing runway 30 at Merced airport, Merced, CA. The pilot executed a steep left banking turn. When the airplane turned abt 140 deg it pitched up, rolled inverted and nosed down into…May 4, 1986 · N357X · DestroyedNTSB LAX86LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CABefore takeoff, the plt tuned in the hayward ATIS & received information alpha, which rprtd the wx was: 2200' scattered,3000' overcast & visibility 8 mi. After taking off from rwy 28R, the plt climbed to about 650' & made a rgt turn. At about that time, the…May 3, 1986 · N9656V · Substantial damageNTSB DEN86LA124Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Britton, SDThe acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…May 2, 1986 · N92283 · Substantial damageNTSB CHI86FEX08Accident · Minor injuriesFinal reportConner KR-2 · Hagerstown, INDrg takeoff, the eng sputtered & quit at about 350' AGL. The plt rprtd that he turned on the electrical fuel pump, but did not get the eng started. Subsequently, the acft hit a tree & crashed inverted on the ground. An investigation revealed the push rod for…May 2, 1986 · N4702Y · Substantial damageNTSB FTW86FA075Accident · Serious injuriesField investigationFinal reportRockwell 112A · El Paso, TXThe plt rprtd that the eng quit immediately after takeoff. During an emerg landing on arpt property, the acft collided with a sand dune & nosed over. An exam of the eng revealed no discrepancies. The extent of damage prevented a thorough exam of the fuel sys.…May 1, 1986 · N1356J · Substantial damageNTSB CHI86LA135Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Indianapolis, INThe acft had sat idle for four days in heavy rains prior to this flt. A loss of power was experienced during takeoff. The plt attempted a 180 deg turn back to the arpt during which the acft stalled and descended to ground impact. Aprx 2.5 ounces of water were…May 1, 1986 · N21139 · Substantial damageNTSB NYC86LA113Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Ridgefield Park, NJA weight imbalance, then a split needle, caused the plt to abort 2 previous attempts to depart. Conditions were corrected & the helicopter departed the waterfront helipad. As it went over the water, the plt noted a loss of eng power. He tried to return to the…Apr 27, 1986 · N60PB · Substantial damageNTSB MIA86LA137Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Ft.Lauderdale, FLThe acft was stolen by a 17 year old non-pilot rated male. While taxiing on a taxiway the acft was reported to be fish tailing before it ran off the taxiway and became airborne. When the acft touched down it bounced aprx 10 ft into the air and performed a…Apr 27, 1986 · N3789X · Substantial damageNTSB CHI86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Griffith, INAfter takeoff and while climbing through 60 ft AGL the plt could not move the aileron to recover from a 15 deg left bank. The plt reduced power and landed the acft in a left wing low attitude. The acft slid and struck a creek bank with the right wing. Post…Apr 27, 1986 · N3321A · Substantial damageNTSB CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…Apr 26, 1986 · N2285Y · Substantial damageNTSB MIA86LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe plt stated that they were doing touch & go landings & on liftoff, the eng sputtered & lost power. She then took over the controls from the student & attempted to land on another rwy & landed hard. Post crash examination of the eng revealed that the eng…Apr 22, 1986 · N528FT · Substantial damageNTSB NYC86FFJ01Accident · No injuriesFinal reportPiper J3C-65 · Bethany, NYThe acft crashed on the arpt after a turn of aprx 120 degrees to avoid 60 ft trees at the departure edge of the arpt. The plt had used the grass beside the airstrip because of standing water at places on the rwy. The takeoff run was started about 500 ft from…Apr 20, 1986 · N88379 · Substantial damageNTSB MIA86LA125Accident · Minor injuriesLimited investigationFinal reportBeech B95A · St. Augustine, FLThe pilot in command did not assure that the fuel selector for the left engine was selected and in the detent prior to takeoff. On the initial climb the fuel selector moved slightly and the left engine failed due to fuel starvation. The pilot then did not…Apr 20, 1986 · N951Q · Substantial damageNTSB CHI86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Remington, INThe aircraft's engine quit at about 200 feet AGL during takeoff climb. The pilot executed a forced landing into a plowed field and the aircraft nosed over. The pilot stated that he believed the fuel selector was in the incorrect position. Examination revealed…Apr 19, 1986 · N76460 · Substantial damageNTSB NYC86LA107Accident · No injuriesLimited investigationFinal reportEnstrom F-280C · Ridgefield, NJSeconds after an over-water takeoff from a shoreline helipad the acft impacted the water and sank. The pilot and pax escaped from the submerged acft and were not injured. The pilot claimed that he had a split needle in which the rotor RPM deteriorated. The…Apr 18, 1986 · N51721 · Substantial damageNTSB LAX86LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · El Monte, CAThe eng cowling opened as the acft took off. The plt slowed the acft to lower the open cowl. The acft descended into unmarked elec wires and received substantial damage. The pilot returned to arpt and landed without further incident.Apr 18, 1986 · N3764R · Substantial damageNTSB MIA86LA123Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ocala, FLPurpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on…Apr 16, 1986 · N9592P · Substantial damageNTSB NYC86LA102Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Newton, NJThe eng lost power during takeoff at an altitude of aprx 100 ft. subsequently, the acft settled into trees near the departure end of the rwy & was damaged. A post-acdnt exam of the acft revealed the fuel tanks were empty.Apr 14, 1986 · N44DN · Substantial damageNTSB MKC86FA088Accident · 5 fatalField investigationFinal reportPiper PA-31 · Norfolk, NEThe airplane departed on runway 31 with a low ceiling and visibility variable from 1/4 mile to 1/16 mile and winds from 290 degrees at 38 knots, gusting to 47 knots. A witness stated that the airplane was airborne no more than two minutes after the engines…Apr 14, 1986 · N6700L · DestroyedNTSB MIA86LA138Accident · No injuriesLimited investigationFinal reportBell UH-1B · North Port, FLThe flt experienced an eng failure at an alt of aprx 8 ft AGL shortly after takeoff and the helicopter sustained substantial damage when a hard landing was made. Post accident inspection of the eng revealed the pwr turbine wheel experienced a loss of two…Apr 14, 1986 · N4242T · Substantial damageNTSB ANC86LA045Accident · No injuriesLimited investigationFinal reportCessna 180-H · Cordova, AKThe pilot stated that after lift off from the water, the left wing tip caught the water causing the aircraft to cartwheel and sink. At the time of the accident the wind was reported as 060 degrees at 15 knots gusting 35 knots.Apr 14, 1986 · N700HJ · DestroyedNTSB LAX86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Salinas, CAThe acft stalled and collided with the ground shortly after departing rwy 31 at Salinas municipal airport. Neither the certified flight instructor nor the dual student was injured. The instructor reported that she was giving the student plt 'touch and go'…Apr 12, 1986 · N24274 · Substantial damageNTSB ATL86LA110Accident · Serious injuriesLimited investigationFinal reportAeronca L-3B · Harrison, OHDuring a demonstration flight to a resident who lived near the airport, the acft crashed in a plowed field in a departure stall. The flight was intended to demonstrate the safe maneuverability of the acft and deception of altitude clearances from the…Apr 12, 1986 · N47187 · Substantial damageNTSB MIA86FA119Accident · 2 fatalField investigationFinal reportBeagle B206-2 · Pedro, FLImmediately after take-off, the left eng seized & the prop stopped due to a connecting rod failure. Witnesses reported that about 200 ft above the ground, the acft rolled to the left and collided with a powerline before crashing to the ground in a near…Apr 11, 1986 · N112CS · DestroyedNTSB MKC86LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Perry, IAShortly after takeoff the PIC noticed a loss of engine pwr and flames erupting from the engine cowling. The PIC executed a turn back to the arpt as thick black smoke filled the cockpit. The PIC opened the side vent window to maintain sight of the ground and…Apr 10, 1986 · N8178N · Substantial damageNTSB BFO86FA021Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake, VABefore the flt, the plt was observed drinking in a bar. He & 3 others then drove to the arpt, where rprtdly, the wx was bad & the visibility was restricted by fog. After awhile, the plt stated he was going to taxi the acft around the arpt & invited the others…Apr 7, 1986 · N9636W · DestroyedNTSB ANC86LA043Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Fairbanks, AKThe pilot stated that during the takeoff on a public road the aircraft struck the road side with the right wing.Apr 6, 1986 · N1042E · Substantial damageNTSB SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…Apr 5, 1986 · N99034 · 2 aircraft · DestroyedNTSB LAX86DVA05Accident · No injuriesFinal reportGrumman G164A · Snelling, CAThe plt stated he had just lifted off during takeoff when the eng quit. The acft then stalled, hitting a canal and shearing off the main landing gear. The plt stated that a broken fuel line is suspect due to the sudden stoppage and intense ground fire. The…Apr 5, 1986 · N8932H · DestroyedNTSB MKC86FPG02Accident · Serious injuriesFinal reportCessna 150H · Lonoke, ARAfter the plt changed a tire & performed maintenance on the carb heat control, he elected to reposition the acft to adams field at little rock, AR. Shortly after lifting off from his private strip, the acft crashed. There was virtually no movement after it…Apr 1, 1986 · N22109 · Substantial damageNTSB LAX86LA157Accident · No injuriesLimited investigationFinal reportCessna 310D · Yermo, CAThe acft collided with rough terrain after an eng failure on takeoff from a private dirt airstrip. The plt indicated that the left eng failed just after liftoff. The acft yawed uncontrolled to the left and drifted off the 30 ft wide strip. The plt aborted the…Mar 31, 1986 · N6762T · Substantial damageNTSB CHI86LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Veedersburg, INThe pilot was attempting a short field takeoff from a 1080 foot wheat field that he had mistaken for a private airstrip 1 1/2 miles to the northeast. The pilot said the engine had a slight RPM loss and then developed full power but he was unable to clear the…Mar 31, 1986 · N9910W · Substantial damageNTSB ATL86LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Fort Rucker, ALThe x-c flt departed killeen, TX, with an intermediate stop at alexandria, LA. A passenger was disembarked at cairns aaf and during departure for dothan, the aircraft's engine sputtered and lost power. The aircraft collided with trees near the airport. Prior…Mar 31, 1986 · N8140Y · Substantial damageNTSB ATL86FEI04Accident · No injuriesFinal reportPiper PA-38-112 · Wauseon, OHThe acft landed & nosed over about 770 ft upwind of the rwy it had used for takeoff. The CFI thought that the sod strip was too soft for the student to make the takeoff so he took the controls. The acft was unable to gain proper airspeed or alt and landed in…Mar 31, 1986 · N2572C · Substantial damageNTSB NYC86LA097Accident · No injuriesLimited investigationFinal reportMooney M20 · Lockport, NYThe cross country flight was departing runway 28 at Lockport, new york in strong quartering wind conditions. At rotation and climb out, the pilot retracted the gears and flps. However as the aircraft flps retracted the aircraft began to drop. The nose was…Mar 30, 1986 · N6433Q · Substantial damageNTSB MKC86LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lytton, IAThe acft was departing from a 2,500 ft long, grass, farm strip. The plt said he noticed after take off that the eng was not developing full power and he could not maintain alt. He attempted to land in an adjacent fld, but the ground was soft and the acft…Mar 29, 1986 · N6167D · Substantial damageNTSB FTW86FA050Accident · 3 fatalField investigationFinal reportLockheed L-402-2 (LASA-60) · Seagoville, TXAcft crashed immediately after takeoff on a flt to discharge jumpers over a drop zone located on the arpt. Witnesses stated that shortly after liftoff the acft entered a steep left bank estimated between 45 and 70 degs. After about 120 degs of turn the acft…Mar 29, 1986 · N3381G · DestroyedNTSB CHI86FEP01Accident · 2 fatalFinal reportCessna 177 · Portage, WISeveral witnesses stated that upon climbout following a low pass, smoke came out of the engine and the engine sputtered. The aircraft was then seen in a steep turn. During this turn the wings reached a vertical position and the aircraft descended to the…Mar 29, 1986 · N29849 · DestroyedNTSB LAX86LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Huntington Bch, CAA Bell 206B collided with a berm after an eng failure while departing a helipad. The plt indicated he had just departed the helipad at night and at aprx 50 ft AGL the eng failed. The acft vertical fin hit the berm causing the tail boom to bend aft of the…Mar 23, 1986 · N49643 · Substantial damageNTSB LAX86FVM04Accident · Minor injuriesFinal reportQuickie II · Watsonville, CAThe acft landed in a wet field off the departure end of the takeoff rwy after the engine lost power during takeoff. The acft nosed over during the landing. The owner reported that the carb heat was on at the scene of the accident. The plt does not remember…Mar 23, 1986 · N3921V · Substantial damageNTSB CHI86LA107Accident · No injuriesLimited investigationFinal reportNavion H · Columbus, INThe pilot was practicing a short field takeoff when at 30 to 40 feet the engine lost power and quit, the aircraft subsequently landed hard damaging the right landing gear box and fuselage behind the right wing. The pilot said he may have taken off on the tip…Mar 23, 1986 · N25342 · Substantial damageNTSB MIA86FA101Accident · 2 fatalField investigationFinal reportDurkota Thorp T-18 · Lakeland, FLWitnesses observed black smoke trailing from the homebuilt acft during takeoff & initial climb. The acft was observed to climb to an estimated alt of 150 to 200 ft where eng sound ceased & the prop stopped. The acft was then observed to attempt a left turn…Mar 19, 1986 · N83GD · Substantial damageNTSB LAX86LA147Accident · No injuriesLimited investigationFinal reportMooney M20F · Burbank, CAThe acft was landed nose low after flying the pattern with a flt control problem. The plt said he noticed the lack of elevator control during initial climb and came back in for a precautionary landing. The elevator was found to be inoperative due to a broken…Mar 19, 1986 · N9591M · Substantial damageNTSB LAX86LA144Accident · No injuriesLimited investigationFinal reportCentrair Schleicher ASW-20 · Phoenix, AZThe plt elected to abort the takeoff because the acft was veering off the rwy. After release from the tow plane the acft wing tip struck a bush causing the afct to ground loop. The plt reported that the winds at the time of the accident were from 200 deg at 5…Mar 18, 1986 · N49946 · Substantial damageNTSB CHI86LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lansing, MIThe student pilot flew a four leg round-robin with touch and go landing after each leg. After his return to his point of origin and following his second touch and go there, the engine quit at 100 ft AGL, halfway down the runway. He bounced into the grass at…Mar 18, 1986 · N50851 · Substantial damageNTSB LAX86LA143Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350D · Tahoe Valley, CAThe helicopter collided with trees and crashed in rough mountainous terrain during takeoff. The acft was shuttling skiers from a landing area located at approximately 8,300 ft mls to a ridgeline at 11,000 ft MSL. The plt reported the EGT (T-4) was at 790 deg…Mar 17, 1986 · N88GT · DestroyedNTSB SEA86LA078Accident · Minor injuriesLimited investigationFinal reportMaule M-4-180C · Orchards, WAThe pilot inadvertently placed the fuel selector to a non-tank position. During initial climb at about 400 m.s.l. a total loss of power occurred. During forced landing the aircraft struck telephone lines, a patio roof, and a parked unoccupied pickup truck.Mar 16, 1986 · N2037U · DestroyedNTSB CHI86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Gregory, MIThe newly purchased acft was being flown off of the seller's turf strip. After taking off, the acft struck 50 ft trees off of the end of the runway. The seller, who watched the takeoff, stated that the pilot overrotated the acft after lift-off.Mar 16, 1986 · N7191M · Substantial damageNTSB ANC86FA035Accident · Serious injuriesField investigationFinal reportCessna A185E · Anchorage, AKAcft hit trees and power lines and crashed on city residential street following engine failure during takeoff climb. Engine driven fuel pump failed due to long term exposure to water in fuel. Over two quarts water was collected from aircraft tanks after…Mar 16, 1986 · N70010 · Substantial damage