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 ANC84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunavachak, AKThe plt of a Piper PA-32, N4143W, was taking off toward the west-northwest on a tidal beach at the same time that another plt was taxiing west onto the beach. The other plt was taxiing a high wing, Bellanca 7GCBC, N2677Z. The Bellanca was angling down onto…May 24, 1984 · N4143W · 2 aircraft · Substantial damageNTSB NYC84FGT01Accident · Serious injuriesFinal reportMooney M20C · Slate Run, PAThe acft crashed shortly after takeoff from the black forestairport. Investigation revealed that the acft traveled approx 2/3RDS of the rwy distance, became airborne, settled back on the rwy & became airborne again. At the time of takeoff the acft was loaded…May 22, 1984 · N5818Q · DestroyedNTSB CHI84LA203Accident · No injuriesLimited investigationFinal reportHughes 269B · Toulon, ILThe plt landed the helicopter in a grassy area to talk to a friend. During departure, he flew over a corn field, & at that time, an empty paper/plastic corn seed sack was drawn up into the main rotor & a severe vibration began. He then landed in the field &…May 20, 1984 · N9471F · Substantial damageNTSB LAX84FA300Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Corona, CAThe acft experienced an eng power failure during takeoff & collided with the ground while maneuvering to return to the airport. The plt stated that he 'turned right trying to return to the runway,' & at the same time, 'maintain 80 (KTS IAS), but it (the acft)…May 19, 1984 · N5387F · Substantial damageNTSB LAX84FA299Accident · Serious injuriesField investigationFinal reportCessna TR182 · Big Bear City, CAJust after takeoff, shortly after landing gear retraction, the eng backfired and experienced a total power loss. The plt lowered the landing gear and landed straight ahead just off the rwy. The acft bounced once and came to rest in a city park. It immediately…May 19, 1984 · N756BS · DestroyedNTSB CHI84LA199Accident · Serious injuriesLimited investigationFinal reportMeyers LIL Toot · White Bear Lake, MNPlt reported power loss while on initial climb. The left wing contacted the ground and the acft cartwheeled. Examinationof aircraft by FAA disclosed no malfunction of aircraft or of powerplant.May 19, 1984 · N12G · Substantial damageNTSB NYC84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 152 · West Milford, NJThe plt stated that during the initial climb of a max performance takeoff the best angle rate of climb could not be maintained. The acft contacted trees and subsequently crashed in an abandoned parking lot.May 18, 1984 · N67809 · Substantial damageNTSB ATL84LA174Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Thomasville, NCThe plt reported that the acft suffered a partial power loss at 150 ft AGL while on initial climb. The plt attempted to return to the airport to land and the eng lost total power. The pilot made a forced landing in a mature wheat field. Examination of the eng…May 18, 1984 · N35LP · Substantial damageNTSB FTW84LA235Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXA tlt loss of power occurred during the initial takeoff climb. The landing gear collapsed when a forced landing was made in an open field. The acft just came out of an annual inspection. After the accident a fuel leak was found where the main inlet fuel line…May 17, 1984 · N7393V · Substantial damageNTSB DEN84IA152Incident · No injuriesIncident investigationFinal reportCessna U206G · Dulce, NMThe plt reported that the arpt was in a valley surrounded by mountains & the elevation was about 6800 ft. with the wind out of the northwest, rwy 33 was the most favorable for the takeoff. There was a ridge about 1/2 mi north of the arpt making it necessary…May 17, 1984 · N756SS · Minor damageNTSB ATL84FA172Accident · 2 fatalField investigationFinal reportBeech 35 · Chesapeake, VAThe acft was being flown on a test flt after a new fuel pump had been installed. While taxiing for takeoff, the eng stopped. The plt restarted the eng & subsequently performed a takeoff. Witnesses saw the acft climb to about 500 ft AGL & begin a turn onto the…May 17, 1984 · N934 · DestroyedNTSB FTW84LA233Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colcord, OKThe flight departed downwind from an unimproved field to avoid power lines at the upwind end of the field. During the takeoff roll sufficient speed could not be attained to lift off and clear a fence at the departure end of the runway. The pilot attempted to…May 16, 1984 · N45906 · Substantial damageNTSB CHI84LA189Accident · No injuriesLimited investigationFinal reportCessna 190 · St. Anne, ILThe plt stated that during his 2nd takeoff from a restricted landing area, the eng hesitated at an alt of about 10 ft AGL. He then aborted the takeoff & tried to land on the remaining rwy. However, the acft touched down in a plowed field where it nosed over.…May 14, 1984 · N9854A · Substantial damageNTSB ANC84FA068Accident · Minor injuriesField investigationFinal reportCessna 182N · Fairbanks, AKDuring takeoff, the acft lifted off at about mid-field, then it touched down & became airborne again before it crashed. It came to rest in an inverted position, 1017 ft beyond the end of the rwy. No abnormalities of the eng were found other than impact…May 14, 1984 · N9096G · Substantial damageNTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…May 13, 1984 · N2434L · Substantial damageNTSB DEN84FA148Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Parker, COAccording to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…May 13, 1984 · N1425P · Substantial damageNTSB CHI84LA188Accident · No injuriesLimited investigationFinal reportAyres S2R · Vincennes, INThe plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…May 13, 1984 · N4006U · Substantial damageNTSB NYC84LA169Accident · No injuriesLimited investigationFinal reportCessna C150 · So.Bethlehem, NYThe student pilot and instructor had just started the inital climb when the engine quit at about 100 ft. the application of carburator heat caused a few second burst of power then the engine stopped again. The CFI took the controls and turned left. He landed…May 12, 1984 · N4024U · DestroyedNTSB LAX84LA295Accident · No injuriesLimited investigationFinal reportCessna A150K · Trona, CAThe acft settled back to the rwy and veered of the left side during takeoff. The plt stated that he attempt a short field takeoff and the acft would not accelerate to more than 60 mph. It settled onto the dirt off the left side of the rwy and groundlooped to…May 12, 1984 · N8376M · Substantial damageNTSB DEN84LA147Accident · No injuriesLimited investigationFinal reportCessna TU206F · Strasburg, CODuring the takeoff phase of a touch-&-go, the eng quit about 100 ft AGL. The plt landed back on the rwy but the acft ran-off the end collapsing the nose gear. Evidence of water contamination was found throughout the fuel system. 1/2 of liquid drained from…May 12, 1984 · N222LS · Substantial damageNTSB DCA84IA026Incident · No injuriesIncident investigationFinal reportBoeing 747 · Los Angeles, CADuring rotation the #2 eng sustained an explosive rupture of its compressor rear frame(crf). The crew observed a rapid drop in the #2 eng performance parameters & the illumination of the #2 eng thrust reversers 'unlock and in transit' lites. The crew…May 12, 1984 · FBPVS · Minor damageNTSB SEA84LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Touchet, WAThe acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…May 8, 1984 · N8624W · Substantial damageNTSB NYC84FA165Accident · Serious injuriesField investigationFinal reportBeech B19 · College Park, MDThe flt had arrived at the arpt between 1600 & 1615, & had landed on rwy 15. Winds generally were out of the sw at ABOUT10 KTS. The plt stated that during the flt he had observed a thunderstorm west of andrews afb (10 mi south.) After loading an ATC simulator…May 8, 1984 · N18786 · DestroyedNTSB CHI84FA179Accident · 2 fatalField investigationFinal reportMooney M20J · Highland Hgts, OHTwo mins after takeoff, acft impacted terrain left wing down, measured 63 degrees nose down, well left of designated departure course. Investigation revealed no malfunction or failure in the acft structure, power plant or systems. Plt's actual instrument…May 8, 1984 · N3833H · DestroyedNTSB NYC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Muskeget Island, MAThe acft was unable to clear trees during the initial takeoff climb. The plt raised the nose of the acft and the acft stalled contacted the trees.May 6, 1984 · N15520 · Substantial damageNTSB NYC84FA158Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Shirley, NYWhile climbing with a glider in tow, the tow acft pitched nose up. The glider & tow plts released the tow rope & the glider plt landed safely. The tow acft maintained a nose high attitude, stalled, then entered an uncontrolled descent & crashed. An…May 6, 1984 · N4410Z · DestroyedNTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…May 6, 1984 · N5173A · DestroyedNTSB CHI84LA181Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ridge Farm, ILThe helicopter rolled over after a hard landing following loss of rotor RPM. The plt reported that during initial climb at about 300 ft AGL the rotor decreased about 500 RPM. He tried to regain rotor RPM until about 100 ft AGL and then tried an autorotation.…May 6, 1984 · N13012 · Substantial damageNTSB MKC84LA138Accident · No injuriesLimited investigationFinal reportSoneria II · Kansas City, KSThe plt of the home built acft was practicing touch-&-go landings. While climbing out after the 5th landing, the plt's canopy unlatched & opened. The plt attempted to close the canopy & nosed the acft down to maintain a safe airspeed. While trying to close…May 5, 1984 · N1355K · Substantial damageNTSB LAX84LA281Accident · No injuriesLimited investigationFinal reportCessna 180K · San Miguel Is, CAThe plt was taking off in a 35 kt wind with the flaps extended. The acft became airborne in a 3 point attitude, & when 2 to 3 ft in the air, it began a left turn. Subsequently, the wing dragged the ground & the acft nosed over. The plt said he should have…May 5, 1984 · N66597 · Substantial damageNTSB CHI84LA174Accident · Serious injuriesLimited investigationFinal reportGable Sonerai II · Berlin, WIThis homebuilt acft stalled during a forced landing after an engine failure. The plt reported that the engine temperature went to 650 degrees which was an overheat condition. The plt stated that he tried to return to the arpt but stalled 20 ft short of rwy 27…May 5, 1984 · N3994G · Substantial damageNTSB DEN84FA144Accident · 1 fatalField investigationFinal reportBeech B23 · Ruidoso, NMThe pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…May 4, 1984 · N9137T · DestroyedNTSB CHI84LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ft Atkinson, WIThe acft stalled during a short field takeoff after a landing during which full up trim was used. The student plt did not use a checklist or reset the trim prior to takeoff.May 4, 1984 · N25583 · Substantial damageNTSB LAX84FA280Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Placerville, CAThe plt lived near the arpt & had been commuting to sacramento, CA for about 3 weeks. Rwy 27 was the prominant rwy & the arpt was surrounded by hills. Shortly after taking off, the acft crashed about 2 mi west of the arpt while in a right wing low attitude on…May 3, 1984 · N28867 · DestroyedNTSB FTW84FA218Accident · 2 fatalField investigationFinal reportde Havilland Tiger Moth DH 82A · San Antonio, TXThe acft crashed in an open pasture with trees on the western perimeter. The acft attitude at impact was nose down at a 30 to 50 degree angle in a right spiral. The main fuel tank mounted on the top wing over and behind the engine broke from its mount on…May 3, 1984 · N82DS · DestroyedNTSB SEA84LA098Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Spangle, WAAccording to FAA inspectors, the plt polished the lower leading edges of wings before departing, as they were covered with frost. The plt stated that during climb out the acft entered an inadvertent stall, followed by a three point landing onto soft field.…Apr 30, 1984 · N8813J · Substantial damageNTSB NYC84LA155Accident · No injuriesLimited investigationFinal reportBell 206 · Boston, MAAfter takeoff, the helicopter was climbing thru 200 to 300 ft AGL, at 50 to 60 KTS, when a partial loss of power occurred. This was followed immediately by a complete loss of power. The plt initiated an autorotation & landed in a railroad switching area where…Apr 30, 1984 · N3913W · Substantial damageNTSB DEN84LA140Accident · No injuriesLimited investigationFinal reportBeech F35 · Moab, UTDuring takeoff, the eng lost power at about 100 ft AGL. The plt decided to land the acft back on the rwy to avoid rough terrain beyond the end. The acft was landed with the gear up. During an investigation, fuel was found in the main tanks & the right…Apr 30, 1984 · N3366C · Substantial damageNTSB NYC84FNE02Accident · Serious injuriesFinal reportBenson B8M · Willimantic, CTThe gyrocopter crashed after the plt lost control of the acft in a windy condition, during takeoff. A 20 degree x-wind velocity of 10 KTS gusting to 35 KTS existed at the time of the accident. The plt told his wife (who wrote the report on the 6120.1 NTSB…Apr 29, 1984 · N196JB · Substantial damageNTSB CHI84LA168Accident · No injuriesLimited investigationFinal reportCessna 182P · Cinncinati, OHThe acft made a forced landing after a total power loss. On the landing flare the right main gear caught the edge of a sand trap & sheared off. Approximately 8 ounces of water were drained from the sumps & carburetor. The engine was subsequently started & ran…Apr 28, 1984 · N1233M · Substantial damageNTSB ATL84LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Smyrna, TNThe CFI simulated an engine failure on the right engine during takeoff after having simulated a left engine failure during the landing approach. The left engine failure was simulated with the left throttle retarded during the approach and landing. After the…Apr 28, 1984 · N1027U · Substantial damageNTSB ATL84FA150Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Suffolk, VADuring the initial takeoff climb the acft contacted power lines located 584 ft from the end of the rwy. This was an initial test flt of the acft after having the engine overhauled. The plt stated at an alt of aprx 50 ft AGL the engine began to lose power and…Apr 27, 1984 · N37MA · DestroyedNTSB CHI84LA161Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa City, WIAfter takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…Apr 26, 1984 · N6737W · Substantial damageNTSB FTW84FA209Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Pryor, OKThe student plt taxied upwind & took off downwind. Witnesses reported that the acft lifted off at the departure end & never left ground effect. After about 1/2 mi, the acft stalled as the plt attempted to clear electric lines. The acft then crashed, hitting a…Apr 25, 1984 · N27165 · DestroyedNTSB NYC84FA148Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Hopwood, PAThe ATP rated pilot obtained a complete wx briefing including forecasts of occasional moderate icing, a cleveland center wx advisory, winds aloft with temps at the flt planned alt of 6000 ft ranging from -1 to -4 deg c and pireps of moderate icing from 5000…Apr 24, 1984 · N2209A · DestroyedNTSB DEN84FA137Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Reserve, NMThe acft collided with trees shortly after takeoff. The acft, according to the plt, reached about 500 ft AGL when the airspeed dropped and the acft stalled into trees. Later the density alt was figured to be 9091 ft. this was over 2000 fthigher than the…Apr 24, 1984 · N9769W · DestroyedNTSB MIA84FA149Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Panacea, FLAcft crashed in water shortly after takeoff. One witness stated the acft entered the water in a steep left bank at a high rate of descent. Witnesses also stated that at the time of the accident, the ceiling was about 50 to 200 ft MSL, visibility was less than…Apr 23, 1984 · N1734J · DestroyedNTSB DEN84LA132Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Jackson, WYThe acft crashed during takeoff from Jackson airport. Investigation revealed that the plt and CFI were in the process of ferrying the acft to Washington state. The plt stated that during taxi the airport UNICOM reported the wind to be from the northeast at 18…Apr 20, 1984 · N2577M · Substantial damageNTSB SEA84LA087Accident · Minor injuriesLimited investigationFinal reportPZL-Mielec PZL-M-18 · Rockford, WAThe plt said the acft was a 'little heavier' than it should have been. The acft bounced settled after takeoff and the right wing hit a fence post. The collision jammed the right aileron down and the acft became uncontrollable and crashed.Apr 16, 1984 · N28951 · Substantial damageNTSB FTW84LA201Accident · No injuriesLimited investigationFinal reportCessna A185F · Grand Isle, LAThe plt estimated that the wind was from the northeast at 15 KTS gusting to 25 KTS. During an easterly takeoff from a private strip, the acft encountered a gust which lifted the left wing causing the plane to drift right & lift off. The acft climbed to an alt…Apr 15, 1984 · N2177Q · Substantial damage