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 CHI87DCA01Accident · Minor injuriesFinal reportBeech 3NM · Cahokia, ILThe acft experienced a loss of pwr in the rt eng immediately aft tkof. The plt was not able to feather the propeller and was forced to land in a wheat field on arpt property. Conditions were conducive to carburetor icing at the time of the accd. Investigation…Jun 16, 1987 · N37CB · Substantial damageNTSB ANC87LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kvichak Bay, AKThe pilot stated that during the takeoff the aircraft's engine lost power; the aircraft stalled and crashed on the gravel bar. The pilot also stated he did not know how much fuel was on board the aircraft and he did not remember the last time he fueled the…Jun 15, 1987 · N92558 · Substantial damageNTSB MIA87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 150H · St. Cloud, FLThe plt stated that the engine ran good during the run up & on his takeoff roll the acft accelerated normally until he reached 45 knots, he looked down and noticed that the carburetor heat was on & he wasn't getting any more power. Realizing he was going to…Jun 14, 1987 · N6647S · DestroyedNTSB FTW87LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Cameron, TXDuring takeoff climb the aircraft struck a powerline then trees and impacted the ground. The aircraft was being flown bya student pilot with no medical certificate or solo endorsement.Jun 14, 1987 · N5079A · Substantial damageNTSB DEN87FA148Accident · 2 fatalField investigationFinal reportMooney M20K · Broomfield, CODrg takeoff, the baggage door (bd) came open. Twr psnl advised the plt, but recd no discernible reply. At aprx 100' AGL,the acft pitched up & rolled left, then entered a steep dscnt & crashed aprx 500' left of the rwy. Except for the bd, nopreimpact mech…Jun 14, 1987 · N4047H · DestroyedNTSB CHI87LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Anderson, INThe plt rprtd that shortly after lift-off, the eng bgn 'hitting & missing.' He made a shallow left turn to avoid a house & land in a corn field. However, the acft stalled & the left wing struck the ground. An exam of the eng revealed that a screw (which held…Jun 14, 1987 · N7306W · DestroyedNTSB MIA87LA179Accident · No injuriesLimited investigationFinal reportCessna A188B · Senatobia, MSThe plt stated that the acft was slow to climb after takeoff. He then dumped the load of chemical in an effort to clear trees. After clearing the trees the acft stalled and crashed into an open field. The plt also stated that there was no engine failure or…Jun 10, 1987 · N4776R · Substantial damageNTSB FTW87FA139Accident · 2 fatalField investigationFinal reportBeech V35A · El Paso, TXAcft experienced a complete pwr loss shortly after takeoff and subsequently struck a house during the ensuing forced landing. No evidence of mechanical failure or malfunction was found during the investigation. Evidence did indicate that one tank was either…Jun 10, 1987 · N39JB · DestroyedNTSB MKC87FA121Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Hope, ARThe PIC had last student certificate and medical in 1978. On this flight with passenger, takeoff was made from rough hay meadow, 1372 feet long. When airplane could not climb over powerline at end of meadow, pilot decided to fly under powerline. Right wing…Jun 9, 1987 · N27424 · Substantial damageNTSB SEA87LA111Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Sedro Woolley, WAShortly after takeoff a loss of power occurred and the aircraft struck trees in flight. Less than 1/2 fuel was available in all three fuel tanks. The fuel selector valve was tested and found that the selections plate was indexed off center for all selections…Jun 8, 1987 · N64384 · DestroyedNTSB MKC87LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Ankeny, IAWhile practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to…Jun 8, 1987 · N1990N · Substantial damageNTSB ANC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Salcha, AKThe pilot was indecisive during his attempted takeoff. He first elected to abort the effort, then changed his mind and added full power to continue the take off. The airplane rose a few feet off the river bar before stalling and crashing into the river.Jun 8, 1987 · N733UP · Substantial damageNTSB NYC87LA163Accident · No injuriesLimited investigationFinal reportSchweizer ASW-20 · Middletown, NYThe glider pilot failed to hook up the elevator control cable before launch and during takeoff there was no pitch control. The aircraft pitched up uncontrollably overstressing the rope. The rope broke and the glider impacted hard on a road bouncing 150 feet…Jun 7, 1987 · N98TX · DestroyedNTSB NYC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Speculator, NYThe plt had been practicing short water takeoffs with full flaps. After svcg the acft with a full load of fuel, he began a takeoff with 20 deg of flaps & got the float plane on the step. He rprtd that as he was applying full flaps, the acft enctrd a gust of…Jun 6, 1987 · N8118 · Substantial damageNTSB FTW87FA137Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Bulverde, TXThe plt attempted liftoff two or three times but after each try the acft would settle back onto the rwy. When about 50 yards from the end of the rwy, the acft again lifted off the ground and climbed to about 15 ft. the plt stated that the stall warning…Jun 6, 1987 · N1403R · Substantial damageNTSB LAX87DUG04Accident · Minor injuriesFinal reportGaston/Lakes Baby Lakes · Corona Airport, CAThe aircraft engine power reduced during the initial climb phase of the takeoff. The pilot attempted to return to the runway of departure. The aircraft landed hard on the airport and nosed over on its back.Jun 4, 1987 · N32G · Substantial damageNTSB DEN87LA144Accident · No injuriesLimited investigationFinal reportCessna 188B · Malta, MTAfter takeoff on initial climb the acft had a pwr loss which resulted in a forced landing. A hard landing occurred in an open field which sheared off the main landing gear and damaged the airframe. The cause of the pwr loss could not be determined.Jun 4, 1987 · N417J · DestroyedNTSB LAX87LA223Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oxnard, CAThe pilot departed Oxnard arpt on a VFR flt to whitemant arpt, los angeles, CA. Grnd witness obsvd the airplane enter clouds and fog after crossing the western edge of the arpt boundary. The airplane was then obsvd in a descending left turn south of the arpt.…Jun 3, 1987 · N7320A · DestroyedNTSB ATL87LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Andalusia, ALThe CFI was giving instruction to a beginning student. During preflight he noted that the lt tank fuel gauge indicated 'full' while the rt tank gauge inidated '1/2 full '. After about 40 minutes of flying the engine began to run rough, during climbout after a…Jun 1, 1987 · N22553 · Substantial damageNTSB NYC87LA157Accident · No injuriesLimited investigationFinal reportPiper J-3 · Mercer, PAThe flight departed from runway 27 uphill with the wind at 180 degrees in uncut grass. There were trees on the left side of the departure end of the runway. The plt stated that he lost lift as he approached the departure end of the runway.May 31, 1987 · N38346 · Substantial damageNTSB MIA87LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Wales, FLThe plt selected 20 degrees of flaps for a short field takeoff. At aprx 75 ft AGL he raised them 10 degrees resulting in a nose high altiude. The acft then stalled and crashed uncontrolled in a nose low altitude causing the nose gear to collapse. The acft…May 31, 1987 · N63597 · Substantial damageNTSB MIA87LA167Accident · No injuriesLimited investigationFinal reportNorth American Navion · Defuniak Spring, FLThe plt reported that after takeoff, at aprx 500 ft, the eng lost power. He then turned on the electric fuel pump in an attempt to restore it. Unable, he then elected to land the acft, during which, it collided with trees, fell to the ground & came to rest.…May 31, 1987 · N4007K · Substantial damageNTSB CHI87LA137Accident · No injuriesLimited investigationFinal reportAircoupe A-2-DEX · Iola, WIThe aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a…May 31, 1987 · N6509Q · DestroyedNTSB MKC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Carbondale, KSThe PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,…May 26, 1987 · N5868D · Substantial damageNTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…May 26, 1987 · N5448Z · Substantial damageNTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…May 26, 1987 · N331CY · DestroyedNTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…May 26, 1987 · N704YK · Substantial damageNTSB FTW87DPA02Accident · No injuriesFinal reportMoni Motor Glider · Terrell, TXThe pilot stated the cockpit canopy opened during initial climb at about 12 feet AGL and that this disrupted the air flow sufficiently that the aircraft became uncontrollable. The aircraft settled back onto the runway with a hard touchdown and then departed…May 23, 1987 · N59MA · Substantial damageNTSB FTW87LA126Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Austin, TXThe plt was unable to retract the landing gear after takeoff. The plt elected to return to the arpt and perform a precautionary landing. The touchdown was normal followed by the right main landing gear collapsing during the landing roll. The acft had…May 22, 1987 · N3980X · Substantial damageNTSB ATL87LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Huntersville, NCThe plt reported that he closed the throttle to simulate an engine failure after takeoff from rwy 06, at about 400-500 ft AGL. He subsequently made a 180 degree turn back toward the arpt to practice a simulated forced ldg, and the acft sink rate increased to…May 22, 1987 · N9796K · Substantial damageNTSB FTW87LA121Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Olla, LAShortly after takeoff, witnesses observed the acft in a steep climb. Rprtdly, it then entered a left turn & appeared to stall. The plt stated that after about 180 deg of turn, he rolled out, nose low, leveled the wings, then a vibration started. Rprtdly, the…May 21, 1987 · N56QQ · DestroyedNTSB SEA87LA099Accident · No injuriesLimited investigationFinal reportMeyer 77-1 · Bellingham, WAA gusting 90 degree crosswind was present during the takeoff. A gust raised the aircrafts left wing and the pilot over-corrected with left aileron and left rudder. The aircraft then stalled, impacting the runway in a left wing down, nose low attitude. This…May 20, 1987 · N28LM · Substantial damageNTSB LAX87LA209Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Apple Valley, CAThe pilot lost control of the aircraft and entered an inadvertent spin during the initial climbout following a touch-and-go landing. The pilot reported a loss of power after climbing to 500 feet. Another pilot on the airport observed the aircraft in a very…May 18, 1987 · N9220U · DestroyedNTSB ATL87DMG01Accident · No injuriesFinal reportGrumman G-164B · Beaufort, NCThe plt had just loaded the hopper with dylox chemical. As the acft became airborne, the plt stated, he experienced wind shear and the acft rolled to the right. The plt corrected by leveling the wings and immediately experienced a second more violent wind…May 18, 1987 · N3628Z · DestroyedNTSB SEA87LA096Accident · No injuriesLimited investigationFinal reportMooney M20F · Wagontire, ORDuring takeoff with full flaps and a density altitude of about 6,200 feet the aircraft failed to gain flying speed. Shortly after becoming airborne the aircrafts gear caught on a barbed wire fence at the departure end of the runway. The aircraft then struck…May 17, 1987 · N3523X · Substantial damageNTSB LAX87FA207Accident · Serious injuriesField investigationFinal reportCessna 182L · Santa Monica, CAThe acft lost power during initial climb and crashed on a residential street during an attempted forced landing. The throttle arm was found separated from the throttle shaft. The arm had been replaced 19 hours prior to the accident. Examination of the…May 17, 1987 · N42814 · DestroyedNTSB DEN87LA126Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COThe private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.…May 17, 1987 · N201MK · Substantial damageNTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…May 17, 1987 · N50499 · DestroyedNTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…May 16, 1987 · N5747G · DestroyedNTSB DEN87LA127Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Limon, COThe plt reports that he was using a dirt road for aerial app operations. The acft was loaded with 40 gals fuel and 140 gals chem and the density alt is EST to have been 8100 ft. the plt said the takeoff was made to the e with a quartering tailwind of about 15…May 14, 1987 · N70164 · Substantial damageNTSB NYC87FA146Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Sayre, PADrg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.…May 13, 1987 · N32774 · DestroyedNTSB FTW87LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nowatta, OKDuring takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially…May 12, 1987 · N9845C · Substantial damageNTSB DCA87MA031Accident · 2 fatalMajor investigationFinal reportLearjet 35A · West Mifflin, PAThe coplt (dual student) was to get a prof check on the 1st leg of the flt with a simulated single eng pwr loss on tkof. According to witnesses, the tkof was normal until lift-off aprx 3200' down the rwy; but after lift-off, the acft clbd only about 50' &…May 12, 1987 · N100EP · DestroyedNTSB BFO87LA036Accident · No injuriesLimited investigationFinal reportBeech C-24R · Chestertown, MDThe pilot, unfamiliar with the airport, intended to perform a trial takeoff run to determine how the aircraft accelerated on the grass runway. During the trial run when the aircraft was about half way down the runway, the pilot felt the aircraft was ready to…May 12, 1987 · N18880 · Substantial damageNTSB NYC87LA144Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Caldwell, NJDrg a ngt takeoff, the eng lost pwr shortly after lift-off & the plt chose an area away from bldgs & obstructions for an emerg landing. However, drg the landing, the acft was extensively damaged. An exam revealed the rgt fuel tank was empty & the left tank…May 9, 1987 · N9374V · DestroyedNTSB SEA87LA089Accident · 2 fatalLimited investigationFinal reportWoehrle FLUT-R-BUG SA6B · Gleneden Beach, ORImmediately after takeoff and while engaged in a tight climbing turn at low alt the pilot allowed the aircraft to enter a stall condition. Plt failed to recover before impacting the ground.May 8, 1987 · N3769G · DestroyedNTSB NYC87LA142Accident · Serious injuriesLimited investigationFinal reportPik 20 · Julian, PAThe glider was assembled and all controls checked for freedom of movement prior to takeoff. During initial takeoff and climb, while in tow, the acft pitched nose up abruptly breaking the tow rope. The acft was then observed to turn right and nose down into…May 8, 1987 · CGPIK · DestroyedNTSB LAX87DVG07Accident · No injuriesFinal reportGrumman G-164A · Lambertsville, CAThe pilot stated that shortly after takeoff the engine 'cut out' several times then quit completely. The pilot made an emergency landing on a plowed field and during the landing roll the aircraft nosed over. The accident was not reported for 4 days and during…May 8, 1987 · N4623 · Substantial damageNTSB ATL87LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Butler, ALThe student plt reported that a gust of wind 'caught' the airplane's left wing shortly after takeoff at about 100 ft AGL; he subsequently 'lost control' and the airplane 'went down'.May 8, 1987 · N8024L · Substantial damageNTSB MIA87FA157Accident · Serious injuriesField investigationFinal reportCessna 150M · San Juan, PRThe plt stated that he performed his run up check with 'normal results.' Ten degrees of flaps were set for a soft field takeoff, & during the takeoff roll, 'the aircraft ran normal.' At aprx 55 mph 'the aircraft left the ground and immediately it settled down…May 6, 1987 · N202CR · Destroyed