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 NYC84LA013Accident · No injuriesLimited investigationFinal reportBeech G18S · Syracuse, NYShortly after lift-off, at 25-50 ft AGL & the gear extended, the acft began a gradual roll to the right. The plt appliedfull left aileron but was unable to correct the roll. The plt sensed a rapidly deteriorating situation & decided to abort the takeoff. The…Oct 24, 1983 · N876U · Substantial damageNTSB ANC84LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe eng quit during takeoff. The plt stated the fuel selector was initially on the left tank which was found empty. The right tank was 1/8/ full.Oct 24, 1983 · N97MM · Substantial damageNTSB LAX84FA028Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · Compton, CAThe acft experienced a total power loss on takeoff & was demolished in the impact sequence & post crash fire. According to several interviewees the pilot had performed extensive non-stc'd modifications to the acft including the fuel system. An 'automotive…Oct 23, 1983 · N3630H · DestroyedNTSB FTW84LU001Accident · Serious injuriesFinal reportPterodactyl Ascender II · Manvel, TXThe plt reported that during takeoff, the eng began to lose power, just after he passed the end of the rwy. He turned back toward the rwy & the eng stopped. Shortly after that the ultralight vehicle struck a strand of barbed wire which was mounted about 30 ft…Oct 23, 1983 · UNREG · Substantial damageNTSB ATL84LA027Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Arlington, TNAccording to both occupants, the eng lost power during takeoff at night. Subsequently, the acft was damaged when it hit a fence & metal pole during an emergency landing. No preimpact part failure or malfunction was found. The rear seat occupant, a female plt,…Oct 22, 1983 · N35280 · Substantial damageNTSB CHI84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indianapolis, INAfter takeoff from dyersburg the gear would not fully retract. The plt attempted to lower the gear manually but it was stuck in the transient position. The plt then diverted to Indianapolis & landed with the gear in the transient position. Investigation…Oct 21, 1983 · N7536Y · Substantial damageNTSB SEA84LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Coos Bay, ORThe helicopter snagged a cable with its skid during takeoff and rolled over. The acft had landed for fuel and was takingoff after refueling when a cable attached to a fertilizer dispencer caught on the helicopter's skid. The acft rolled to the right and…Oct 20, 1983 · N82W · Substantial damageNTSB FTW84LA027Accident · No injuriesLimited investigationFinal reportCessna U206G · Midland, TXThe plt took off to check the wx & intended to proceed on a business flt, if conditions permitted. After taking off, he noted that the wx would not be satisfactory, so he elected to land & travel by other means. His apch to land was high & the acft touched…Oct 20, 1983 · N756DV · Substantial damageNTSB DEN84FA008Accident · No injuriesField investigationFinal reportConvair 340/440 · Pierre, SDAfter landing at Pierre, SD, 2070 lbs of cargo was off-loaded from the aft section of the aft & a new wt & balance was calculated. The aircrew then prepared to takeoff in conditions of low ceiling & fog. The plt-in-command (PIC) initiated the takeoff roll,…Oct 20, 1983 · N199CF · Substantial damageNTSB ATL84IA024Incident · No injuriesIncident investigationFinal reportBritish 1-11/204/AF · Washington, DCOn initial climb but the foward right galley service door blew open for undetermined reasons. The acft returned and landed without further incident. The door warning light did not come on.Oct 17, 1983 · N2111J · Minor damageNTSB ANC84FA008Accident · Minor injuriesField investigationFinal reportBell B-206B · Paxson, AKAccording to the plt, he took off upslope into the wind in an easterly direction. Immediately after taking off, he made a right turn to a x-wind, & seconds later, he made a further turn the right (downwind). Visibility toward the east was about 1/4 mi, but to…Oct 17, 1983 · N215AL · Substantial damageNTSB NYC84FFJ01Accident · Serious injuriesFinal reportRyan Navion · Ischua, NYThe acft had been parked at the arpt for about 7 months prior to this flt. During that time, the eng had been overhauled. Before taking off on a maintenance test flt, 37 gal of fuel was added to the center tank. Also, the plt was observed working in the eng…Oct 16, 1983 · N4613K · DestroyedNTSB DEN84LTI01Accident · Serious injuriesFinal reportBenson B8M · Libby, MTThe acft crashed into trees during a takeoff and descended inverted to the ground. The pilot stated he had not intended to fly a pattern but merely takeoff and land in a modified high speed taxi run. But on this last run he ran out of rwy and decided to go…Oct 16, 1983 · N4415W · Substantial damageNTSB CHI84LA023Accident · No injuriesLimited investigationFinal reportBeech B35 · Northfield, OHDuring takeoff, the acft collided with trees. According to the arpt manager, the acft was rotated prematurely during the takeoff & the plt flew the acft on the back side of the power curve until tree impact. Reportedly, there was no preimpact part failure or…Oct 16, 1983 · N8719A · Substantial damageNTSB CHI84LA024Accident · Minor injuriesLimited investigationFinal reportAlderfer Gyroplane · Hamilton, OHThe plt struck he made a normal takeoff & reached an alt of about 20 ft when he lowered the nose to gain airspeed. As he reached 30 ft the gyroplane rolled over & impacted the grass on the right of the rwy. The plt reported he had a strong gusty headwind…Oct 15, 1983 · N1388Q · DestroyedNTSB ATL84FA017Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Knoxville, TNAcft stalled during a steep climbing turn after takeoff.Oct 14, 1983 · N5547K · Substantial damageNTSB FTW84LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Copeville, TXThe plt had landed in a pasture area that was about 1500 ft long. While on the ground, a wx front began moving in & the plt elected to takeoff to move the acft to a safer location. He initated his takeoff to the south; however, the ground was soft due to…Oct 11, 1983 · N48774 · Substantial damageNTSB DEN84LA006Accident · Minor injuriesLimited investigationFinal reportArtic S-1A Cadet · Fullerton, NDThe acft collided with trees during a takeoff from an open OAT field.Oct 11, 1983 · N37286 · Substantial damageNTSB FTW84LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKThe student plt reported that shortly after takeoff, the eng lost power. He made an emergency landing in a field, but before he could stop the acft, it collided with a fence. Later, the acft eng was examined, but no reason for the power loss was found.Oct 10, 1983 · N49980 · Substantial damageNTSB ANC84LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Kodiak, AKAccording to the plt, the wind was gusting to 30 KTS or more and changing directions on the lake very rapidly. He further stated that 'you could see swirls of water on the lake's surface.' He departed the lake towards the east and when about 350 AGL…Oct 10, 1983 · N2797P · Substantial damageNTSB SEA84LA009Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Portland, ORAccording to the plt, he had made a right turn into the wind after lift-off & had just cleared a fence at 40 to 50 ft AGL, when he began to lose power. He then turned to the right to clear power lines. Since the helicopter did not have enough room to clear…Oct 9, 1983 · N222NT · Substantial damageNTSB ANC84FA004Accident · 1 fatalField investigationFinal reportCessna 206 · Egegik River, AKThe plt flew the acft with 4 passengers to a dirt/gravel strip near the Egegik River & becharof lake, aprx 45 mi south of king salmon, AK. The plt was aware that the operator (ft richardson flying club) prohibied the operation of its acft into unapproved…Oct 9, 1983 · N8193G · DestroyedNTSB FTW84LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Clarksville, TXThe acrt crashed into trees during a forced landing when the engine lost power during takeoff climb after a power reduction. The plt said he was too low to maneuver so he landed straight ahead into the trees. The plt suspected carburetor icing. The…Oct 8, 1983 · N4979D · Substantial damageNTSB ANC84IA002Incident · No injuriesIncident investigationFinal reportBoeing 727-247 · Juneau, AKAcft developed smoke in the cockpit on takeoff & subsequently the smoke abated. A second episode occurred at the top of the climb. The right hand taxi light switch had failed in an overheat condition & burned the insulation from an adjacentwire.Oct 8, 1983 · N2808W · Minor damageNTSB LAX84LA003Accident · No injuriesLimited investigationFinal reportBeech S35 · Elgin, AZWhile taking off from a dirt, ranch strip, the plt elected to use tracks that were worn in the vegetation beside the strip. He believed that these tracks had been formed by other acft & thought the takeoff would be smoother if he used them. However, the…Oct 7, 1983 · N6851Q · Substantial damageNTSB CHI84LA010Accident · No injuriesLimited investigationFinal reportCessna 177B · Northfield, OHThe acft collided with trees after loss of power during initial climb. The engine reportedly lost power at about 50 ft AGL. During the descent the engine restarted but the acft was too low and slow to continue a climb out. The acft struck trees beyond the…Oct 3, 1983 · N34010 · Substantial damageNTSB ATL84LA010Accident · No injuriesLimited investigationFinal reportCessna C-150 · Parkersburg, WVThe acft collided with a deer during climbout on a night training mission. The weather was VMC but the night was dark. The CFI said they were doing touch and go landings. After completing a landing and during climbout the acft struck a deer. The acft was…Oct 3, 1983 · N63666 · Substantial damageNTSB FTW84FA001Accident · 1 fatalField investigationFinal reportCessna 152 · La Porte, TXCessna 152, N6281Q, & Piper PA-38, N9132A, were both on local, solo student flts. The plt of a 3rd acft, who was holding short for takeoff on rwy 12, observed the Cessna 152 & Piper PA-38 on final apch. Recognizing the potential for a mid-air collision, he…Oct 2, 1983 · N6281Q · 2 aircraft · DestroyedNTSB MIA84LA001Accident · No injuriesLimited investigationFinal reportde Havilland DHC2 · Titusville, FLThe acft collided with a truck while taking off but managed to stay airborne, fly a mission and return to a normal landing. The private plt was reportedly carrying 8 passengers for a parachute drop. He would not admit he was carrying passengers and none of…Oct 1, 1983 · N31339 · Substantial damageNTSB FTW84LA002Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Midland, TXThe acft stalled and landed hard off the side of the rwy during a forced landing. The plt said the engine was misfiring during initial climb at 150-200 ft AGL. He tried to land on the remaining rwy. The plt later said he thought the power loss was due to…Oct 1, 1983 · N28745 · Substantial damageNTSB CHI84LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · East Peoria, ILAt about 10 ft AGL a 300-400 RPM decrease in power occurred. The plt elected to land straight ahead into a cut bean field. He touched down about 400 ft from the end of the rwy, traveled about 500 ft further where a large rut was struck. About 10 flt hours…Oct 1, 1983 · N2347E · Substantial damageNTSB CHI84LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Howell, MIThe acft was on its 1st flt after an annual inspection. During takeoff, a partial power loss occurred at aprx 200 ft AGL. The plt initiated a turn back toward the arpt, then elected to land on or near the median of an interstate highway. During the landing, a…Oct 1, 1983 · N30027 · DestroyedNTSB CHI84LA002Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Hastings, MIThe instructor plt (CFI) knew that the acft was getting low on fuel, but he wanted the student to make one more takeoff & landing. When the acft was climbing thru about 200 ft after takeoff, the eng began losing power. The CFI assumed control of the acft &…Oct 1, 1983 · N76639 · Substantial damageNTSB ATL84FA001Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Pliny, WVThe helicopter was being used in the construction of elect transmission lines. A 150-FT longline cable had been utilizedon an earlier flight for lifting external loads. However, there was no reason for the longline to be attached on the accident flight as the…Oct 1, 1983 · N1334X · DestroyedNTSB LAX83LA464Accident · No injuriesLimited investigationFinal reportGrumman 164B · Tracy, CAThe acft crashed during a forced landing shortly after takeoff when the engine lost power at about 10 ft AGL. Heavy rainhad fallen the night before and the acft are generally parked outside. After the engine lost power the plt landed off the end of the rwy…Sep 30, 1983 · N6708K · Substantial damageNTSB DEN83LA225Accident · No injuriesLimited investigationFinal reportMooney M20F · La Junta, COThe acft stalled into the ground during a takeoff in windy conditions. The winds were reported to be from 210 degrees at 22 KTS gusting to 28 KTS. The plt received a weather briefing from the fss and knew a strong crosswind from the left was present. He used…Sep 30, 1983 · N3280F · Substantial damageNTSB ANC83LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe acft crashed shortly after takeoff in a forced landing after the engine lost power. The weather was VMC with the temperature at 53 degrees f and the dew point at 41 degrees f. the acft lost power at about 200 ft AGL and the pilot attempted an emergency…Sep 30, 1983 · N1582C · Substantial damageNTSB MIA83LA241Accident · No injuriesLimited investigationFinal reportBeech A35 · Orlando, FLThe pilot heard a loud bang when the gear was retracted. After many attempts to extend the gear, the pilot burned off fuel, had the rwy foamed & a gear up landing was made. During the last annual inspection the landing gear actuator was removed and the worm…Sep 29, 1983 · N8678A · Substantial damageNTSB ATL83LA383Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Apison, TNThe acft collided with trees and crashed during takeoff from a short grass strip in a downwind direction. The wind velocity was 9 KTS. The strip was 2300 ft long with 75 ft trees at the end. Under the existing conditions the takeoff could not be accomplished…Sep 29, 1983 · N25814 · Substantial damageNTSB LAX83FA462Accident · No injuriesField investigationFinal reportBell 47G-4G · Lodi, CADuring takeoff, the helicopter lost power after climbing aprx 20 ft. the plt made an autorotative landing, but after touchdown, the helicopter slid down a river bank, rolled over & began burning. The fuel tanks did not rupture & still contained fuel. When…Sep 28, 1983 · N7956S · DestroyedNTSB LAX84IA461Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Santa Ana, CAJust after takeoff the left engine failed due to a fatigue failure of the 7 th stage rear compression stator assembly several homes under the fligh path sustained fire & debris damage when engine parts departed the acft. The acft returnedto the airport and…Sep 27, 1983 · N302RC · No damageNTSB NYC83FA256Accident · 1 fatalField investigationFinal reportMooney M20F · Burlington, VTAcft had been parked on ramp at syracuse for aprx 5 days with partially full tanks & exposed to rainy wx. According to the plt, there was no evidence of water during preflight. Plt taxied to another area where 40 gals of fuel was added. Flt from syracuse to…Sep 24, 1983 · CGOEL · DestroyedNTSB LAX83FA458Accident · 2 fatalField investigationFinal reportCessna TU206-G · Flagstaff, AZThe acft collided with trees shortly after takeoff. The weather was marginal with 700 ft scattered, ceiling 3000 ft WITH8 miles visibility. The plt received two weather briefings about an hour apart while waiting for weather improvement. The briefer commented…Sep 24, 1983 · N7353N · DestroyedNTSB DEN83FA221Accident · 3 fatalField investigationFinal reportMooney M20F · Salt Lake City, UTThe acft crashed in an uncontrolled descent shortly after takeoff. A witness noticed the acft in a tail low attitude at low alt and slow airspeed. He said the plane looked like it was shifting from side to side. The left wing dipped. The acft rolled to the…Sep 24, 1983 · N9464V · DestroyedNTSB CHI83FA438Accident · 1 fatalField investigationFinal reportBensen B8M · Paoli, INShortly after takeoff, the gyrocopter crashed on the west side of rwy 02/20. Witnesses observed the acft turn to the right after lift-off, then it disappeared behind trees. They reported hearing an unusual noise & stated that the eng stopped operating, then…Sep 23, 1983 · N6469 · DestroyedNTSB ANC83LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKAccording to the pilot the engine started running intemittently after he was over trees at the departure end of the runway. The engine stopped and the pilot set up for and accomplished a forced landing. After the accident the pilot and a mechanic found water…Sep 23, 1983 · N4008M · Substantial damageNTSB MKC83LA226Accident · No injuriesLimited investigationFinal reportEipper Quicksilver · Wichita, KSThe instructor plt (CFI) & student were on a dual instructional flt, using a registered, 2 place, ultralight acft with a single control stick. According to the CFI, the student was making a takeoff toward the southwest when the acft encountered a gust of wind…Sep 22, 1983 · N3150X · Substantial damageNTSB LAX83FUG23Accident · No injuriesFinal reportErcoupe 415C · Hesperia, CAThe pilot reported that he was departing the apt, using the two preceding acft as referenced, as his acft had no taxi or landing lights. His acft was caught in the wake of the acft ahead, causing the pilot to lose control. The acft struck a bush aprx 100 feet…Sep 22, 1983 · N2865H · DestroyedNTSB NYC83LA251Accident · No injuriesLimited investigationFinal reportMooney M20J · Erie, PADuring takeoff, the eng lost power at aprx 50 ft AGL after the gear was retracted. The plt reported that his only safe reaction was to land with the gear retracted on 'what little rwy was left.' Water was found in the gascolator & right fuel tank. The acft…Sep 19, 1983 · N25XX · Substantial damageNTSB LAX83FA448Accident · No injuriesField investigationFinal reportBell 47G · Oceanside, CAShortly after takeoff, the eng lost power at an alt of aprx 400 ft AGL. An autorotative landing was made on uneven terrain beside a stream with weeds aprx 3 ft high. During touchdown, the main rotor struck the tail boom. An inspection of the engine revealed…Sep 19, 1983 · N62221 · Substantial damage