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 NYC87LA058Accident · Minor injuriesLimited investigationFinal reportAgusta A109AII · So. Dartmouth, MAAgusta N300CC departed a helipad in front of claremont corp president's residence in south Dartmouth, Massachusetts. As the helicopter was hovering prior to moving forward, the tail rotor blade, s/n 124, failed. The tail rotor assembly and gearbox separated…Jan 13, 1987 · N300CC · Substantial damageNTSB MIA87LA071Accident · No injuriesLimited investigationFinal reportCessna 182 · Ft.Lauderdale, FLThe acft collided with a powerline, trees & a truck after sustaining a complete power loss right after take-off. The acft was being ferried to be sold & had not flown for about two months. During the pre-flt inspection, the plt stated that he drained a…Jan 13, 1987 · CGOXD · Substantial damageNTSB LAX87FA084Accident · 1 fatalField investigationFinal reportCessna T210M · Pacoima, CADuring initial climb after takeoff the aircraft experienced a complete loss of power. The pilot attempted to return to the airport and collided with a large warehouse. The airframe was totally consumed in the post crash fire. Examination of the engine…Jan 13, 1987 · N112DW · DestroyedNTSB ATL87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student plt was unable to recall anything about the acdt. A plt/a&p observing the t.o. stated that the acft lifted off and climbed to 50-60 ft. when a flock of black birds flew up into the path of the acft. The acft pitchedup, yawed slightly, turned about…Jan 13, 1987 · N757XP · Substantial damageNTSB LAX87LA079Accident · No injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Fremont, CADuring a towing operation, just after lift-off the aircraft lost engine power at approximately 75 feet AGL. The glider released and landed without incident. The aircraft continued straight ahead, ran into a fence and came to rest in a plowed field. The fuel…Jan 10, 1987 · N7232V · Substantial damageNTSB ATL87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Tuskegee, ALDuring a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…Jan 9, 1987 · N3971L · Substantial damageNTSB LAX87LA075Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Tucson, AZThe plt lost control and collided with the surface of runway 24 during initial takeoff climb. The pilot indicated that he encountered a crosswind gust from his left during the initial takeoff/climb. The aircraft right wing or landing gear dragged along the…Jan 4, 1987 · N68557 · Substantial damageNTSB ATL87LA053Accident · No injuriesLimited investigationFinal reportCessna 182J · Kennasaw, GADuring initial climb for a local pleasure flight the pilot reported that the aircraft began to lose power. The pilot made a 180 degree turn to make an emergency downwind landing. He reported that the power increased and he decided to make a normal approach to…Jan 3, 1987 · N3473F · Substantial damageNTSB LAX87FA072Accident · 1 fatalField investigationFinal reportNorth American T-28C · Van Nuys, CAThe plts were practicing lndgs, and were on the 3rd flt after the eng had been overhauled. After takeoff from a tough-&-go, the instructor noticed that the oil temp was high. Soon thereafter, the eng began to run rough, then it seized. Unable to get back to…Jan 1, 1987 · N9022Y · DestroyedNTSB SEA87LA039Accident · No injuriesLimited investigationFinal reportHughes 269 · Matlock, WADuring takeoff the aircraft nosed over inverted and then struck the ground. The pilot found after the accident that a strap had hooked under the skid of the aircraft.Dec 29, 1986 · N9365F · Substantial damageNTSB SEA87LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, ORA power loss occurred during takeoff at about 100 feet AGL due to fuel exhaustion. A turn to the left was made so that a landing could be made on a field. During landing roll the aircraft's wing struck two trees.Dec 27, 1986 · N11537 · Substantial damageNTSB LAX87FA069Accident · 6 fatalField investigationFinal reportBeech E-55 · East Palo Alto, CAThe pilot and 5 passengers departed for a planned vacation in Mexico in dark night conditions. The aircraft was observedto depart from runway 30, turn from the crosswind to the downwind leg and the aircraft 'lost altitude rapidly' and impacted in the san…Dec 27, 1986 · N111FC · DestroyedNTSB ATL87DEG02Accident · No injuriesFinal reportCessna 150H · Harrison, OHThe engine quit after takeoff at about 200 ft AGL. A ldg was made in a plowed field where the acft flipped over inverted. The CFI PIC reported that, prior to takeoff, he had calculated there was adequate fuel on board for the flt; his calculations were based…Dec 27, 1986 · N7190S · Substantial damageNTSB NYC87FA049Accident · 1 fatalField investigationFinal reportCessna 172M · Kingston, NYCessna 172M, N64342, was on his initial climb after taking off on runway 33 at the uncontrolled Kingston-ulster airport when the pilot failed to see Cessna 177, N2981X, or hear, on the UNICOM frequency, the transmissions by N2981X who was on his final…Dec 21, 1986 · N64342 · 2 aircraft · DestroyedNTSB FTW87LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Cresson, TXAfter about 45 min of flt time, the instructor (CFI) & student plt entered the traffic pattern to practice touch-&-go landings. As they were taking off from the 1st touch-&-go, the eng lost power. Subsequently, they made a forced landing in an open area near…Dec 20, 1986 · N714KY · Substantial damageNTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…Dec 19, 1986 · N8062A · DestroyedNTSB LAX87DUJ03Accident · Minor injuriesFinal reportSolem KR-2 · Mesa, AZThe pilot said that shortly after takeoff the control stick shuddered and he felt 'back pressure' on the stick. The nose started pitching up so he pushed forward on the stick. He continued pushing the stick forward until it reached the forward stops. Despite…Dec 13, 1986 · N3762S · Substantial damageNTSB MKC87FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Grain Valley, MOThe pilot stated, after takeoff the engine sputtered and began losing power during initial climb. According to the pilot, he tried to land on a highway but there were numerous vehicles in transit and he decided to attempt an off-airport landing. On initial…Dec 11, 1986 · N44291 · DestroyedNTSB CHI87LA042Accident · No injuriesLimited investigationFinal reportCessna 152II · Anoka, MNThe acft was on the fifth touch & go of the student plt training flt when a loss of power occurred at 100-200 ft AGL during climbout. The CFI had to land the acft in unsuitable terrain which resulted in substantial damage to the acft. Examination of eng and…Dec 8, 1986 · N753AA · Substantial damageNTSB NYC87LA046Accident · No injuriesLimited investigationFinal reportBeech B23 · Trenton, METhe plt rprtd that after takeoff, the acft had climbed to 600 ft & was climbing at 300 ft/min, when the eng 'started to labor,' then quit running. He used carburetor heat & 'primed through power reduction,' but the eng would not restart. During an emerg lndg…Dec 7, 1986 · N7651R · Substantial damageNTSB ATL87FA038Accident · 2 fatalField investigationFinal reportCessna 185D · Hammonton, NJThe mid-air collision occurred while the Cessna 185 was attempting a steep climbout during takeoff from rwy 21 and the Mooney was making a landing to the same runway. Another aircraft attemped to warn both aircraft over the UNICOM freq. Neither aircraft…Dec 7, 1986 · N5878T · 2 aircraft · DestroyedNTSB CHI87DEM05Accident · Serious injuriesFinal reportCessna T210L · Lawton, MIThe plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having…Dec 6, 1986 · N999WF · Substantial damageNTSB MKC87LA028Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B-600 · Earle, ARThe pilot stated that the powerplant was performing normally during initial climb when, suddenly, the engine experienced a power loss after backfiring. Immediate remedial action resulted in a partial power output but not enough to sustain flight. Emergency…Dec 3, 1986 · N6898Q · Substantial damageNTSB ATL87IA034Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Atlanta, GAAt about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld…Dec 3, 1986 · N802MX · Minor damageNTSB LAX87DUM01Accident · No injuriesFinal reportBell UH-1B · Calipatria, CADuring the initial climb at the beginning of an aerial application flight, the pilot made a climbing 180 degree right turn in the reverse direction when the rotor RPM began to drop. The pilot continued to raise collective, lost directional control and…Dec 1, 1986 · N2770N · Substantial damageNTSB DEN87LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellicott, CODuring the initial climb phase of takeoff the plt encountered a wind shear with strong gusty tail winds. The acft entered an uncontrolled descent from 25 feet AGL, struck a wire fence off the end of the rwy and nosed over.Nov 29, 1986 · N757TN · Substantial damageNTSB FTW87LA023Accident · 2 fatalLimited investigationFinal reportNorth American Navion A · Springtown, TXThe pilot told rescue personnel that he had taken off with empty tanks selected. The engine quit, and the aircraft impacted the ground before he could restart. Initial reports of serious injury only, but both occupants expired two weeks later.Nov 28, 1986 · N91548 · Substantial damageNTSB CHI87LA038Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rockford, ILShortly after takeoff at about 100 feet AGL, pilot reports the engine lost power, aircraft stalled, entered a spin, and collided with the ground. Inspection of the aircraft and magnetos did not disclose any discrepancies other than possible coil deterioration.Nov 28, 1986 · N8703S · DestroyedNTSB SEA87LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Kennewick, WAThe private pilot was seated in the right front seat with the student pilot in the left front seat. The pvt pilot allowed the student pilot to takeoff. The student over rotated and the stall warning was sounding. The pvt pilot took command of the aircraft but…Nov 26, 1986 · N2349U · Substantial damageNTSB SEA87FA031Accident · 1 fatalField investigationFinal reportCessna 177RG · Republic, WAA witness observed the acft taxi out ot the rwy in light snow showers and taxi to the north end of the rwy. During the takeoff the area was covered with a heavy snow shower, with winds from the north gusting T0 20-25 mph. The acft was observed to depart to…Nov 25, 1986 · N52069 · DestroyedNTSB MIA87LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that…Nov 22, 1986 · N24298 · Substantial damageNTSB ATL87LA026Accident · No injuriesLimited investigationFinal reportMullinax KR-2 · Augusta, GAThe plt stated that the eng always ran rough at full pwr due to a rich mixture setting on the carburetor. Normally the eng roughness could be corrected by retarding the throttle or mixture control. The plt said that he adjusted the mixture on the carburetor…Nov 22, 1986 · N313RR · DestroyedNTSB ANC87LA014Accident · Minor injuriesLimited investigationFinal reportCessna 305E · Barrow, AKThe pilot stated that during the takeoff he had full right aileron and left rudder. The pilot lost directional control of the aircraft and crashed off the left side of the runway. At the time of the accident the wind was five knots or less.Nov 19, 1986 · N68396 · Substantial damageNTSB ANC87LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Big Lake, AKThe student plt stalled the acft at aprx 20 to 30 ft AGL during the initial climbout. Subsequently, the acft impacted the rwy & went off to the side.Nov 17, 1986 · N1ZA · Substantial damageNTSB MIA87LA033Accident · No injuriesLimited investigationFinal reportHickham Twinstar · Bay St. Louis, MSShortly after takeoff on the initial test flt, severe vibration was felt and the plt attempted to return the float equipped acft to the water for a forced ldg. Due to low alt, the plt had to land in trees. An exam of one of the blades of the 3 bladed…Nov 16, 1986 · N9731N · Substantial damageNTSB CHI87LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, ILThe plt rprtd he enctrd IFR conds at aprx 400' AGL drg takeoff. He elected to 'fly out of it' & 'was in the clear' afterclbg to 4500' MSL. He elected to return to the arpt & indcd he could see the arpt 'on and off' thru brkn clds. On an apch to lnd, the acft…Nov 16, 1986 · N2311R · Substantial damageNTSB CHI87LA032Accident · No injuriesLimited investigationFinal reportBurkhart Grob 109B · Gregory, MIWhile landing, the aircraft bounced twice, so the pilot decided to go around and make a second attempt. On climb out, the landing gear struck 65 ft tall trees at the end of the runway. The aircraft then stalled and collided with the terrain. Reportedly, the…Nov 15, 1986 · N58287 · Substantial damageNTSB LAX87FA039Accident · 2 fatalField investigationFinal reportBeech D55 · Livermore, CAWitnesses stated that the aircraft started the takeoff roll, became airborne at about 1000 feet down the runway, climbed to an altitude of about 50 feet, rolled to the left and crashed inverted onto a parallel taxiway at about mid field. There was no fire.…Nov 13, 1986 · N8386N · DestroyedNTSB CHI87LA028Accident · No injuriesLimited investigationFinal reportBeech 23 · Laporte, INThe plt stated that at the initial full throttle position the acft developed 2450 RPM. According to the plt, at approximately 200 feet of altitude he noticed a loss of rpm's to 2050 and he immediately rechecked the throttle and mixture controls, the magneto…Nov 11, 1986 · N2335Q · Substantial damageNTSB CHI87DEX01Accident · No injuriesFinal reportTurnbloom Kitfox · Crawfordsville, INThe plt rprtd that when he was preparing for the acft's 1st test flt, he made a hi speed run with the tail raised & acft control was good. On the next run, he planned to let the acft lift off the rwy, then let it settle back on the surface. He stated that he…Nov 9, 1986 · N371DT · Substantial damageNTSB MKC87FA015Accident · 1 fatalField investigationFinal reportCessna 310Q · Liberal, KSThe acft impacted the terrain just off the departure end of rwy 17 at Liberal, KS, while on a return flt to Texas. Dark night conditons prevailed and no horizon visual cue were available shortly after takeoff. Reliance on flt attitude instruments would have…Nov 6, 1986 · N510SU · DestroyedNTSB ATL87LA148Accident · 1 fatalLimited investigationFinal reportCessna 150J · Memphis, TNPrior to its discovery on may 20, 1987, this acft had last been seen on x-wind leg on climb out after a touch and go at dewitt spain arpt. Parts of the acft were recovered from the Mississippi river northwest of the arpt. The plt's remains had not been…Nov 4, 1986 · N50736 · DestroyedNTSB MKC87FA012Accident · 2 fatalField investigationFinal reportPiper PA-24 · Siloam Springs, ARThe plt had logged 3 hrs of simulated instrument training prior to this accident. He received a wx briefing which reported wx conditions nearby were IFR due to low ceilings and fog. Immediately after takeoff, the acft started a left turn and impacted terrain…Nov 3, 1986 · N7062P · DestroyedNTSB DEN87LA013Accident · No injuriesLimited investigationFinal reportPitts S-1D · Shelby, MTThe plt took off with little or no warmup, pushed the acft to max performance at 10 ft, performed a max performance climb to 300 to 400 ft and reduced throttle to idle. As the acft reached stall speed, the plt dived at a 45 degree angle and impacted the…Nov 2, 1986 · N255NK · DestroyedNTSB ATL87FA016Accident · 1 fatalField investigationFinal reportKoons-Donald Sonerai II · Macon, GADuring climbout, the pilot allowed the aircraft to stall while turning to a left crosswind. The acft impacted the ground in a nose low attitude after colliding with two trees. The pilot was unable to exit the aircraft and local residents were unable to assist…Nov 2, 1986 · N23DK · DestroyedNTSB MIA87FA019Accident · Serious injuriesField investigationFinal reportCessna 210 · Jacksonville, FLThe flt, transporting banking records, had executed a VOR apch to the rwy after being given the arpt wx which was ceiling indefinate with 1 mi visibility in fog. The plt stated that after landing, he realized he had touched down too FAR down the rwy to…Nov 1, 1986 · N6123U · Substantial damageNTSB FTW87FA007Accident · Serious injuriesField investigationFinal reportBell 206B · Mustang IslandAcft experienced a power loss immediately after takeoff from an offshore platform in the gulf of Mexico. The plt held collective to clear the rig and then popped the floats and autorotated to the water. The auto was successful, however, the acft was struck by…Nov 1, 1986 · N5741K · Substantial damageNTSB FTW87DPJ01Accident · No injuriesFinal reportSnow AT-301 · Hennessey, OKThe acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear.Nov 1, 1986 · N7309D · Substantial damageNTSB LAX87IA029Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Santa Ana, CAJust after takeoff the aircraft experienced a fire in the number 3 engine which was extinguished by the on board fire bottles. Investigation revealed that a secondary fuel line had pulled out of a b-nut ferrule fitting at the fuel flow divider manifold which…Oct 31, 1986 · N363PS · Minor damageNTSB MIA87FA015Accident · 1 fatalField investigationFinal reportde Havilland DHC-3 · San Juan, PRWitnesses stated that the acft used most of the rwy to takeoff, reached an aprx altitude of 60 feet, then pulled up to clear an embankment. However, the acft struck a tall palm tree & crashed between 2 roads, near an intersection, where the roads merged. The…Oct 29, 1986 · N778L · Destroyed