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 ATL87LA098Accident · No injuriesLimited investigationFinal reportMooney M20F · Winnsboro, SCThe acft hit a ditch during a forced landing after a power loss on takeoff. The acft had received annual inspection during which no contamination of the fuel system was found. The acft was parked outside, in the rain, to await the owner's pickup. The fuel…Mar 26, 1987 · N6990V · Substantial damageNTSB CHI87MA101Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…Mar 25, 1987 · N128AA · No damageNTSB LAX87DVD02Accident · 1 fatalFinal reportCulver Cadet LFA · Antioch, CADuring a local pleasure flt, witnesses observed the acft take-off into a headwind. At aprx 1000 ft AGL, the nose of the acft came up then down. The acft entered a spin and collided with the terrain. They also stated that the propeller appeared to be slowing…Mar 24, 1987 · N37838 · DestroyedNTSB MIA87LA116Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Homosassa, FLThe plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.Mar 22, 1987 · N88929 · Substantial damageNTSB MKC87LA063Accident · No injuriesLimited investigationFinal reportGlasair SH2 · Springdale, ARImmediately after takeoff, the engine stopped and the acft collided with trees and then the terrain. Inspection revealed contamination in the fuel tank, the lines and the filter. Contamination was water, dirt, straw and gravel. The fuel being used was regular…Mar 21, 1987 · N67SH · DestroyedNTSB MKC87FA064Accident · No injuriesField investigationFinal reportCessna T337C · Garden City, KSBoth of the acft engs had just been overhauled. The plt decided to make a maint test flt & elected to leave the lndg gear in the down & locked psn. Takeoff & initial climb were normal until about 300 to 400 ft AGL. At that time the rear eng lost power. The…Mar 21, 1987 · N2600S · Substantial damageNTSB CHI87LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Merrill, WIAircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…Mar 21, 1987 · N25333 · Substantial damageNTSB LAX87LA145Accident · No injuriesLimited investigationFinal reportCessna U206A · Williams, AZDuring a crosswind turn, shortly after takeoff, the pilot noticed that the fuel pressure gauge was registering a loss of fuel pressure and the engine was experiencing a smooth loss of power. The pilot said that he turned on the emergency boost pump and…Mar 14, 1987 · N8058Z · Substantial damageNTSB FTW87LA081Accident · No injuriesLimited investigationFinal reportCessna 185A · Midland, TXDuring take off, the aircrafts engine failed due to fuel exhaustion. The pilot made an emergency forced landing in a rough uneven field, causing substantial damage to the left wing spar, left main gear, and left elevator. The pilot did not hold a…Mar 13, 1987 · N3306R · Substantial damageNTSB MKC87LA061Accident · No injuriesLimited investigationFinal reportCessna 182J · Archie, MOThe plt stated that, after refueling with auto gas at the pvt airstrip, water was found in the fuel being drained fm the sumps. After rocking the acft several times and noting no further water accumulation in the fuel samples, the plt further stated, a…Mar 12, 1987 · N3124F · Substantial damageNTSB LAX87LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Chandler, AZWhile clbg fm a go-arnd at abt 400' AGL, the instructor (CFI) shut dwn the l eng by closing the mixture & the student (pvt plt) feathered the left prop. The CFI then moved the prop ctl out of the feather psn, but the prop rmnd feathered. The CFI was unable to…Mar 12, 1987 · N62750 · Substantial damageNTSB MIA87LA104Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Navarre, FLShortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…Mar 11, 1987 · N7645P · Substantial damageNTSB MIA87LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · St. ThomasThe pilot stated that as he lifted off the aircraft encountered a gust of wind. The pilot lost control of the aircraft and it struck a displaced threshold sign and the ground.Mar 10, 1987 · N55682 · Substantial damageNTSB ATL87LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leslie, GAThe plt reported losing power shortly after takeoff; a forced ldg was subsequently made in a freshly-plowed field where the acft flipped over. Examination of the engine revealed a cracked #7 cyl head. FAA service difficulty reports (sdr's) indicated that…Mar 10, 1987 · N8721H · Substantial damageNTSB LAX87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Santa Ynez, CAJust after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…Mar 9, 1987 · N8162X · Substantial damageNTSB LAX87DVA04Accident · No injuriesFinal reportHiller OH-23G · Delano, CADuring an aerial application flight, the pilot returned to the loading truck for approximately 5 additional gallons of chemical to finish the application. The loader; however, loaded 70 gallons and when the pilot took off the rotor RPM began to bleed off. The…Mar 8, 1987 · N99232 · Substantial damageNTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.Mar 8, 1987 · N4200J · Substantial damageNTSB CHI87DEE06Accident · No injuriesFinal reportSchleicher ASK-21 · Plainfield, ILThe glider plt rprtd that drg takeoff, the tow plt released the tow rope at aprx 15' AGL. Rprtdly, he released the tow rope due to a perceived lack of takeoff & climb performance. After being released, the glider plt made a right turn to avoid unacceptable…Mar 7, 1987 · N694KS · Substantial damageNTSB ATL87LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Toronto, OHThe plt reported that the engine quit completely after takeoff at about 50-75 ft AGL without any warning. The plt attempted to land back on the rwy and the acft overran the rwy end. Examination of the acft after the accident revealed no malfunctions, defects,…Mar 7, 1987 · N9412D · Substantial damageNTSB DEN87LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Erie, COAcft lifted off at slow airspeed and stalled/mushed back to rwy.Mar 5, 1987 · N2629G · Substantial damageNTSB ANC87LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Nenana, AKThe pilot lost control on takeoff, stalled and crashed on a frozen lake. During the interview with the pilot, he stated that the engine quit on initial climbout; he believed he did not pre-heat the engine long enough before takeoff. At the time of the…Mar 5, 1987 · N4724M · Substantial damageNTSB ANC87LA049Accident · No injuriesLimited investigationFinal reportChampion &GCBC · Talkeetna, AKThe pilot stated that during the initial climb out he lost directional control of the aircraft causing the plane to stall and strike a small tree next to the runway. At the time of the accident the wind was 330 degrees at 3 knots.Mar 3, 1987 · N2586G · Substantial damageNTSB MKC87LA053Accident · No injuriesLimited investigationFinal reportBeech C23 · Grain Valley, MOThe plt reported that the preflight eng run-up was satisfactory. Shortly after takeoff, the eng faultered briefly and the plt attempted a landing back on the rwy. Upon establishing a point to land, the eng responded and the acft overshot the intended landing…Mar 1, 1987 · N6001M · Substantial damageNTSB LAX87MA125Accident · No injuriesMajor investigationFinal reportBoeing 727-224 · Los Angeles, CAAfter a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…Feb 26, 1987 · N88704 · 2 aircraft · No damageNTSB MIA87LA092Accident · No injuriesLimited investigationFinal reportPiper J5A · Brooksville, FLShortly after take off the eng began to lose power. Unable to maintain alt a forced landing was made in a field, during which, the acft sustained substantial damage. Inspection of the acft revealed that the loss of power was the result of an insufficient fuel…Feb 24, 1987 · N41141 · Substantial damageNTSB LAX87DVA03Accident · No injuriesFinal reportEagle DW-1 · Modesto, CADuring an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…Feb 24, 1987 · N8808E · Substantial damageNTSB FTW87LA069Accident · No injuriesLimited investigationFinal reportBell 47G · Sand Springs, OKInstructor plt was demonstrating a confined area takeoff to the pvt plt taking advance instruction. As the acft cleared the barriers, the quartering head wind shifted to a tail wind and the acft lost translational lift. Application of full power did not…Feb 23, 1987 · N6330D · Substantial damageNTSB LAX87LA118Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · San Diego, CADuring a local pleasure flight, the pilot returned to the airport to practice touch-and-go landings. On take-off, ascending through 200 feet, the engine began to surge then quit. The pilot made a forced landing on an occupied road where the aircraft collided…Feb 19, 1987 · N4590V · Substantial damageNTSB CHI87FA085Accident · 2 fatalField investigationFinal reportBeech E18S · Quincy, ILThe acft, at near gross weight (CG unknown), was on initial climb after takeoff. A witness reported that engines soundednormal. At about 400 ft AGL the acft was reported to pitch up about 10 degrees, then level off and enter a left turn. The acft made another…Feb 18, 1987 · N149R · DestroyedNTSB NYC87LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Old Bridge, NJThe Cessna 152 took off and after becoming airborne, experienced a total loss of power. The student pilot who had made the takeoff turned control of the aircraft over to the flight instructor, who made an emergency landing in a drag strip parking lot which…Feb 14, 1987 · N25498 · Substantial damageNTSB ATL87DEG03Accident · 2 fatalFinal reportRichard A. Brown Falco F-8L · Mc Arthur, OHPIC and acft owner landed at a/p and req fuel which was not avail. Acft left to fly to another a/p. during initial climb engine quit at 300-400 feet. PIC turned back toward rwy, acft stalled, impacted ground in 90 degree left wing low attitude. Other pilots…Feb 13, 1987 · N894RB · DestroyedNTSB SEA87LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Mountain Home, IDAcft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…Feb 12, 1987 · N50724 · Substantial damageNTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.Feb 11, 1987 · N3451X · Substantial damageNTSB LAX87FA112Accident · 1 fatalField investigationFinal reportHughes 369D · Honolulu, HIDrg tkof clb, a loud noise occurred as 1 of 5 main rotors (mrb's) & the tail boom sepd fm the helicopter (hel). The hel then crashed & hit a submerged reef aprx 200' fm the heliport. An exam of the failed mrb showed its retention strap assy(rsa), pn…Feb 9, 1987 · N1102U · DestroyedNTSB LAX87LA110Accident · 2 fatalLimited investigationFinal reportCessna 150L · Ayase, JapanDuring an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…Feb 7, 1987 · N6797G · Substantial damageNTSB CHI87LA080Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Big Fork, MNAfter several unsuccessful attempts to takeoff from a snow-covered lake, the plt found a plowed area leading to a fish house. He taxied to the area and began to takeoff towards the east. On lift-off, the left aileron struck the top of the fish house. The plt…Feb 7, 1987 · N4715E · Substantial damageNTSB CHI87LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Utica, MIThe pilot experienced a loss of power to 900 RPM shortly after takeoff. The plt had climbed to 2000 ft and reduced power. When the RPM dropped to 900 RPM he applied carb heat to no avail. The acft was landed in a field 6 miles north of the departure arpt.…Feb 7, 1987 · N7088Q · Substantial damageNTSB LAX87DVD01Accident · Serious injuriesFinal reportBell 47G4A · Stockton, CAJust after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…Feb 2, 1987 · N28938 · Substantial damageNTSB FTW87LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marfa, TXThe pilot stalled the aircraft while attempting to climb too steeply during takeoff from an old abandoned airport. The aircraft veered left, descended, and struck the ground before flying speed could be regained.Feb 2, 1987 · N47849 · Substantial damageNTSB CHI87LA073Accident · No injuriesLimited investigationFinal reportCessna 182M · East Troy, WIThe aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…Feb 2, 1987 · N71383 · Substantial damageNTSB FTW87LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Worth, TXPrivate pilot in Cessna 172P with three passengers aboard attempted to take off with 60 degree, 9 knot cross-wind component. Pilot rotated aircraft prematurely causing stall warning horn to activate and airspeed to dissipate. Pilot lowered nose of aircraft in…Feb 1, 1987 · N98816 · Substantial damageNTSB ATL87LA068Accident · 1 fatalLimited investigationFinal reportCessna 150M · Pinson, ALDuring intial climb after takeoff the eng quit and restarted more than once. The acft was turned back toward the departure rwy. During the turn, the wing struck a tree, control was lost, and the acft collided with the ground. Examination of the eng revealed…Jan 31, 1987 · N704FT · Substantial damageNTSB CHI87LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, INAt aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…Jan 27, 1987 · N4688D · Substantial damageNTSB LAX87LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Tracy, CAJust after takeoff while climbing through 200 ft AGL the engine quit. The pilot made a forced landing in a gravel pit where the aircraft collided with a bank. Examination of the engine revealed that the #1 cylinder and piston had moderate to severe scuffing…Jan 26, 1987 · N1408R · Substantial damageNTSB FTW87FA047Accident · Serious injuriesField investigationFinal reportCessna 150F · Rio Vista, TXPrivate pilot of Cessna 150K experienced partial power loss after departing private strip near Rio Vista, TX. Pilot attempted to return for landing. After take off he was unablle to sustain climb. Aircraft hit utility pole, aircraft control was lost and…Jan 24, 1987 · N8033F · DestroyedNTSB CHI87DEC01Accident · Serious injuriesFinal reportCessna 150 · Troy, MIOutside air temperature was approximately 5 degress f when the aircraft on initial climb experienced a total power loss. The pilot lowered the nose and attempted to make a turn to return to the runway. The aircraft did complete approximately 180 to 190…Jan 24, 1987 · N5634E · DestroyedNTSB ANC87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKAfter takeoff and during the initial climbout, the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft struck a row of trees at the departure end of the runway. The plts flt time was not reported or available.Jan 24, 1987 · N46362 · Substantial damageNTSB LAX87FA088Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Oceano, CAShortly after takeoff, the surviving pax (s/p) noticed the acft began losing alt. She heard the plt comment about a 'clicking noise in the left wing' which she also heard & said sounded like metal clicking together. Ground witnesses noticed a change in eng…Jan 17, 1987 · N5982P · Substantial damageNTSB FTW87FA045Accident · No injuriesField investigationFinal reportBeech 65-80 · Brownsville, TXCommercial pilot departed Brownsville, TX (bro) on special VFR flight plan. During initial climb, at approximately 300 ft AGL both engines quit due to fuel starvation. Forced landing was made to unimproved field. Aircraft sustained substantial damage. Pilot…Jan 15, 1987 · N1590S · Substantial damageNTSB LAX87FA085Accident · 4 fatalField investigationFinal reportBeech F33A · Sacramento, CAThe winds at the airport had been reported as strong and gusting. After his passengers arrived, the pilot requested and received taxi instructions to the active runway which was aprx 3700 ft from his parking space. About 2-1/2 mins after receiving his taxi…Jan 14, 1987 · N1067W · Destroyed