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 SEA87LA189Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cathlamet, WAThe pilot was making soft field takeoffs with no flaps. He lost control of the aircraft at about 10 feet AGL, the aircraft's right wing struck the ground and the aircraft came to a stop.Sep 19, 1987 · N96847 · Substantial damageNTSB ATL87LA263Accident · No injuriesLimited investigationFinal reportCessna 140 · Jesup, GADuring initial takeoff the aircraft's engine lost power and the aircraft collided with the ground. Investigation revealed the carburetor inlet filter was 50 percent plugged with rusty material and two tablespoons of rusty water remained in the carburetor…Sep 19, 1987 · N77126 · Substantial damageNTSB DEN87DTM01Accident · Serious injuriesFinal reportEvans VP-2 · Cedar Valley, UTThe acft was flown by two different plts who complained of stiff ailerons. The aileron system was examined but no deficiencies were noted. A third plt then took off and began a lt turn at about 75 to 100 ft AGL. When he attempted to return to wings level he…Sep 18, 1987 · N84772 · DestroyedNTSB FTW87DPJ07Accident · No injuriesFinal reportMooney M20F · Jenks, OKEngine failed during initial climb. Aircraft collided with airport perimeter fence and slid across road during landing attempt. Water was found in the fuel distributor system following the accident.Sep 17, 1987 · N9520M · Substantial damageNTSB ANC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot of the airplane was an Alaska state trooper performing his official duties and was flying an airplane owned and operated by the state of Alaska. He had landed on a remote ridge top to recover essential items of evidence for a pending case. Upon…Sep 17, 1987 · N7051 · Substantial damageNTSB ANC87LA158Accident · No injuriesLimited investigationFinal reportCessna 207 · Two Lakes, AKThe pilot stated the gravel airstrip was muddy and he lifted off at the end of the strip. The aircraft clipped a tree with the horizontal stabilizer and the airplane settled into the trees.Sep 17, 1987 · N1786U · Substantial damageNTSB ANC87LA157Accident · No injuriesLimited investigationFinal reportCessna 185 · Little Delta Rv, AKThe pilot stated that approximately 1000 feet after commencing the take off the airplane climbed to just above tree top level and then began to settle into the trees. The pilot also stated he believes the airplane stalled.Sep 17, 1987 · N9914X · Substantial damageNTSB FTW87LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Gulf Of MexicoWhile departing from an off-shore oil platform in the Gulf Of Mexico, the helicopter eng lost power. The plt initiated an autorotation & made a mayday call, but did not get the emerg floats inflated before touching down in the water. Subsequently, the…Sep 16, 1987 · N2206F · DestroyedNTSB ATL87LA260Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Louisville, KYThe plt made two attempts to land and during his 2nd go around the eng cut out. The plt stated that he switched from left tank to rt tank but was unable to start the eng prior to making a forced landing which resulted in a collision with a house and tree. The…Sep 16, 1987 · N7378V · Substantial damageNTSB ANC87LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Windy Ridge, AKThe pilot stated that he had just lifted off from the gravel bar hen he stalled the aircraft and crashed.Sep 16, 1987 · N9350D · Substantial damageNTSB LAX87LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Byron, CAWith the wind out of the southwest at 8 to 10 knots, the plt was taxiing the acft in a northerly direction at a high enough speed to keep 'on the step'. When he attempted to turn the acft to a southwesterly heading for tkof, the acft failed to respond. Rather…Sep 15, 1987 · N999BA · DestroyedNTSB ANC87LA160Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt. Watana, AKAfter liftoff from a lake the airplane's engine stopped producing power and the airplane began settling toward the remaining lake. The engine surged and the airplane crashed on the tundra, 200 yards from the lake's edge. The pilot stated that he drained the…Sep 15, 1987 · N5416R · Substantial damageNTSB SEA87LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · John Day, ORPlt departed hay field in hi density alt conds. The pilot was unable to clear trees and stalled/mushed into terrain, collapsing gear and colliding with trees.Sep 14, 1987 · N1394V · DestroyedNTSB ANC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stoney River, AKThe pilot stated that during the initial climbout he lost directional control of the aircraft; stalled and crashed on the gravel bar. Plt did not submit an acc report.Sep 14, 1987 · N5656Y · Substantial damageNTSB ANC87LA150Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Island Lake, AKThe pilot stated that during the initial climbout the aircraft lost power, stalled, and crashed into a row of trees near the lake. The pilot also stated it was fuel contamination which caused a partial power loss.Sep 14, 1987 · N82171 · Substantial damageNTSB ATL87LA258Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Fremont, OHThe eng lost pwr shortly after tkof. A forced lndg was made in a field where the acft impacted a ditch. Post-crash exam of the acft engine revealed water and solid contamination in the fuel injector servo. The plt had recently purchased the acft. The acft…Sep 13, 1987 · N3651Q · Substantial damageNTSB LAX87DJA09Accident · No injuriesFinal reportEmair MA-1-B · Paauilo, HIDuring an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.…Sep 11, 1987 · N9924M · Substantial damageNTSB BFO87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Clinton, MDDuring takeoff with the aircraft over the end of the runway, power loss occurred. The pilot landed straight ahead in a field and nosed over. Examination of the aircraft did not disclose any mechanical malfunctions/failures. The engine was started and operated…Sep 11, 1987 · N5515U · Substantial damageNTSB NYC87DGM03Accident · No injuriesFinal reportWoody Pitts S1 · Irwin, PAThe pilot's inability to maintain control of the aircraft during initial climbout. Inadvertent use of the rudder controls was a factor.Sep 10, 1987 · N290RW · Substantial damageNTSB DEN87LA235Accident · No injuriesLimited investigationFinal reportBell 47-G3B2 · Oakley, UTThe plt had just taken off from a confined area surrounded on two sides with electrical power lines. As he attempted to climb, he said his RPM began to bleed off. He stated that he made a right pedal turn to avoid the wires but was unable to prevent a hard…Sep 10, 1987 · N1038X · Substantial damageNTSB ATL87LA253Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Cartersville, GAThe plt reported a loss of power on climb out. An off arpt landing attempt resulted in impact with trees and substantial damage to the acft. Temperature and dewpoint were within the range for carburetor ice buildup. Examination of the acft revealed a cruise…Sep 10, 1987 · N2600K · Substantial damageNTSB ATL87DEI13Accident · Minor injuriesFinal reportBushby Mustang II · Salem, OHA coml plt (PIC in the left seat) was providing a familiarization flt for a pvt plt (coplt in the rgt seat). The PIC allowed the rgt seat plt to make the takeoff. The PIC rprtd that after the acft lifted off & climbed about 5 to 10 ft, the rgt wing dipped &…Sep 10, 1987 · N80ET · Substantial damageNTSB NYC87DHA02Accident · 2 fatalFinal reportKolb Twinstar · Hilltown, PAAfter the acft took off, witnesses heard a power change & saw what appeared to be a left turn to return to the grass strip. Subsequently, it entered a descent & crashed in a left wing down, nose low attitude. The passenger was taken to a hospital, but died…Sep 9, 1987 · N23EH · Substantial damageNTSB CHI87LA209Accident · No injuriesLimited investigationFinal reportCessna 182RG · Marine City, MIPIC lost directional control during lift-off. The aircraft then drifted left, away from the runway, cartwheeled and came to rest upside down. The PIC and passenger exited the aircraft as it started to burn. The PIC stated that he noted immediately a crosswind…Sep 9, 1987 · N251NW · DestroyedNTSB MIA87LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Ocala, FLShortly after takeoff, the eng began to lose pwr & the plt was unable to maint alt or return to the arpt. He elected to land on a road, but there was oncoming traffic, so he maneuvered to the left side. Subsequently, the left wing collided with a utility…Sep 7, 1987 · N5581U · Substantial damageNTSB ANC87LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Iowa Ridge, AKThe pilot was awakened in the night at his hunting camp by strong winds estimated at 70 - 80 mph. His airplane came loose at its tie-down and he elected to try and fly it to a safer location. Shortly after take off he lost control of the airplane and crashed.…Sep 7, 1987 · N8510C · Substantial damageNTSB CHI87LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Indianapolis, INThe acft was on the third tkof of the day when the eng stopped on initial climb at the pilots estimated alt of 500 ft. he did a 180 turn back to the arpt but touched down short and ran through the perimeter fence. Examination of the acft revealed that the…Sep 6, 1987 · N9287W · Substantial damageNTSB ANC87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tanana, AKThe pilot stated that he just lifted off the lake when the engine quit. The aircraft stalled and crashed into the lake. The pilot stated that he just ran out of fuel.Sep 6, 1987 · N4136E · Substantial damageNTSB ANC87FA138Accident · Serious injuriesField investigationFinal reportCessna 175A · Anchorage, AKThe acft contacted a row of trees and crashed in a residential area shortly after takeoff. The pilot reported, that a downdraft was encountered after establishing a positive rate of climb on takeoff. Airspeed decreased when the downdraft was encountered and…Sep 6, 1987 · N6921E · Substantial damageNTSB FTW87FA210Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Graford, TXThe pilot departed possum kingdom airport and entered a crosswind turn. The pilot heard a loud 'pop' and could not move the aileron control to recover from the turn. The aircraft entered an uncontrolled descent and crashed into a lake. The aileron pulley for…Sep 5, 1987 · N68529 · Substantial damageNTSB MKC87LA170Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Springdale, ARThe plt rprtd that shortly after takeoff, the eng lost power, recovered for a few seconds, then went to idle. Drg the few seconds that power was restored, he initiated a turn back toward the rwy. The plt said the acft started to snap roll to the left & went…Sep 3, 1987 · N3761Q · Substantial damageNTSB LAX87DUG08Accident · Serious injuriesFinal reportBoyles Starduster II · Hemet, CAThe plt rprtd that shortly after takeoff, the eng began to 'cut out.' He moved the fuel selector to the reserve tank & activated the standby fuel pump, but was unable to restart the eng. Subsequently, the acft was damaged as the plt was making an emergency…Aug 31, 1987 · N1189B · Substantial damageNTSB CHI87DEX08Accident · Minor injuriesFinal reportChampion 7KCAB · Sheridan, INOn initial climbout at approximately 400' AGL the aircraft experienced a total power failure. The pilot attempted to maneuver the aircraft to return to the airport, however, the aircraft was forced to land in a farm field 1/4 mile short of the airport. The…Aug 31, 1987 · N6343N · Substantial damageNTSB SEA87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Shelton, WADuring initial climbout the pilot stated that a loss of power occurred. However, no reason for loss of power could be found. An eye witness to the accident stated that he heard power throughout the takeoff to the moment of impact. The propeller showed heavy…Aug 30, 1987 · N4789U · DestroyedNTSB LAX87LA328Accident · No injuriesLimited investigationFinal reportCessna 310D · Lancaster, CAThe pilot-in-command (PIC) rprtd that he heard a loud bang during gear retraction after takeoff. By using the convex mirrors mounted on the tip tanks, he determined that the nose gear was hanging. He cycled the landing gear switch several times, but the nose…Aug 30, 1987 · N39DD · Substantial damageNTSB CHI87FA198Accident · 2 fatalField investigationFinal reportBeech B35 · Martinsville, INShortly after takeoff an engine failure occurred. The aircraft stalled and spun to the ground when the pilot tried to return to the airport. The fuel selector was positioned on the almost empty auxiliary tank (meant for use in level flight only).Aug 30, 1987 · N700T · Substantial damageNTSB LAX87DUJ10Accident · No injuriesFinal reportCessna 188B · Poston, AZJust after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis…Aug 29, 1987 · N8275G · Substantial damageNTSB NYC87FA241Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Selinsgrove, PAThe pilot was conducting a demonstration flight in an overweight aircraft in conditions of low ceilings and fog. After a touch and go landing the aircraft stalled during the takeoff then collided with the ground. Exam of the wreckage did not disclose any…Aug 28, 1987 · N4003P · DestroyedNTSB LAX87FA318Accident · No injuriesField investigationFinal reportBell 206L-1 · Covelo, CAThe pilot performed a vertical takeoff. At aprx 30 ft AGL, while transitioning to forward flight, the engine lost power and the pilot partially lowered the collective to maintain rotor RPM. The helicopter landed hard on sloping terrain and bounced laterally…Aug 27, 1987 · N22HU · Substantial damageNTSB FTW87DRD12Accident · Serious injuriesFinal reportPiper PA-22-150 · Mansfield, LAThe airport was 324 feet above sea level. The OAT was 96 degrees f. the airplane, with the pilot and two passengers, lifted off the rwy but would not climb. A witness stated the engine sounded normal but the nose was very high. The airplane impacted trees and…Aug 24, 1987 · N5700D · DestroyedNTSB NYC87LA239Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Bingham, METhe plt rprtd he was taking off from a lake & was climbing thru about 200-300 ft AGL when the acft enctrd a severe downdraft. Subsequently, the float plane collided with rising terrain. No preimpact part failure or malfunction was rprtd. The plt rprtd the…Aug 23, 1987 · N96241 · Substantial damageNTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…Aug 23, 1987 · N3767C · Minor damageNTSB MIA87FA231Accident · Serious injuriesField investigationFinal reportCessna 182A · Pensacola, FLThe plt stated that just after liftoff he flew into a layer of haze and became disoriented, the aircraft stalled, crashed into a dirt mound, spun around and came to rest off the left side of the runway. The aircraft then exploded and was consumed by post…Aug 23, 1987 · N4741D · DestroyedNTSB LAX87LA316Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Condord, CAAfter an annual inspection the acft was prepared for a test flight. The pilot loaded 3 passengers and began the run-up checks. During run-up the left engine ran rough. After the roughness cleared the pilot initiated the takeoff. As the acft accelerated down…Aug 23, 1987 · N8441 · Substantial damageNTSB LAX87LA312Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Tucson, AZThe plt reported that just after takeoff, the engine lost partial power & he was unable to land back at the airport. During an emergency landing, the aircraft collided with a utility line & pole. An exam of the engine revealed that a rocker arm on the #4…Aug 23, 1987 · N26250 · Substantial damageNTSB ANC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Little Delta, AKThe pilot stated that he was taking off downhill with a 10 knot tailwind. At that time the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft settled into brush and nosed over.Aug 23, 1987 · N3341M · Substantial damageNTSB MKC87FA165Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Batesville, ARThe airplane was at maximum gross weight at takeoff. The field elevation was 613 feet and the density altitude was 3300 feet. There were two runways available. Runway 25 was 6002 feet long and had a slight headwind from the southwest. Runway 35 was 3320 feet…Aug 22, 1987 · N6079D · DestroyedNTSB BFO87DHD08Accident · Minor injuriesFinal reportBede BD5B · Wilmington, DEThe pilot's failure to attain sufficient altitude to clear obstacles located off the departure end of the runway. His overconfidence in the homebuilt aircraft's performance was a contributing factor.Aug 21, 1987 · N533BD · DestroyedNTSB FTW87FA203Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F-1 · Ship Shoal 214cAcft experienced a tail rotor drive shaft failure during t/o from an offshore platform. Acft spun left and completed 6 to 7 revolutions prior to water contact as the single plt could not reach the throttles to reduce pwr to idle. Acft landed hard and the rt…Aug 19, 1987 · N359E · Substantial damageNTSB CHI87LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIWhile the plt was using short field techniques for takeoff, the acft lifted off into ground effect. At about that time, the plt thought there was a partial power loss. He stated, 'after perceiving a partial power loss which was accompanied with a loss in…Aug 19, 1987 · N32387 · Substantial damage