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 NYC84LA238Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau SF-27M · Grove City, PAThe motorglider lost power after takeoff. According to the plt the takeoff seemed long but he did not abort because thiswas his first self-launch and he was unsure of the operation. About 200 ft AGL a turn was made to the east to return to the arpt and the…Jul 8, 1984 · N100LH · Substantial damageNTSB NYC84LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23 · No. Andover, MAThe acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…Jul 8, 1984 · N1257P · Substantial damageNTSB NYC84FGM06Accident · Serious injuriesFinal reportTeratorn II · Brownsville, PAThe owner/plt had previous flown the home built acft which was constructed similar to an ultralight. An optional pilot enclosure (canvas covering over the plt compartment) had just been installed. On 7/7/84, the owner/plt taxi checked the acft for about 30…Jul 8, 1984 · N4475V · Substantial damageNTSB SEA84LA165Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Juneau, AKThe cowling of the acft came loose and the plt reduced power because of the vibration. An emergency was declared and theplt attempted a 180 degree turn at an alt of 400 ft AGL. A stall was entered and the acft hit a channel where the water was about 10 ft…Jul 7, 1984 · N6332N · DestroyedNTSB CHI84LU006Accident · Serious injuriesFinal reportPterodactyl Fledgling · Hartford, WIThe ultralight was in the takeoff climb at about 75 ft AGL when the engine failed. During the emergency forced landing, the acft landed hard on upsloping terrain & the nose gear failed in overload. Investigation revealed that an ignition wire was worn and had…Jul 7, 1984 · UNREG · Minor damageNTSB CHI84LA286Accident · No injuriesLimited investigationFinal reportGillmore Moni · Joliet, ILThe prop separated from the acft at aprx 500 ft AGL during the initial takeoff climb. A forced landing was made in a corn field. The prop was attached by means of 4 5/16 inch bolts and retaining nuts. Two of the four bolt portions remaining after the accident…Jul 7, 1984 · N157LG · Substantial damageNTSB SEA84FA164Accident · Serious injuriesField investigationFinal reportBellanca 7GCBC · Gorst, WAAccording to witnesses the acft departed rwy 19 & initiated a climbing left turn. The acft was then observed to increase angle of bank to the left and climb rate. At about 50 to 75 ft, the acft entered a steep uncontrolled descent & collide with the ground.…Jul 6, 1984 · N57396 · DestroyedNTSB MKC84LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cuba, MOThe acft nosed over during a forced landing immediately after takeoff. The acft had been parked outdoors and not flown for six months and according to witnesses the plt did nothing except add 10 gallons of fuel to the acft tanks. The acft engine quit when the…Jul 6, 1984 · N21249 · Substantial damageNTSB LAX84LA384Accident · No injuriesLimited investigationFinal reportCessna 172N · Chester, CAThe plt reported that he attempted to takeoff on rwy 15 with a wind from the west at 15 gusting to 25 KTS. Also, the outside air temp was 94 deg & the density altitude was about 7800 ft. the plt stated that about halfway down the rwy, the acft lifted off in…Jul 6, 1984 · N6301E · Substantial damageNTSB FTW84LA306Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamesa, TXThe acft collided with the ground after takeoff and the left main gear was knocked off. The plt did not dump the chemical load when the acft started to settle. According to the plt, the acft was too heavy and density alt was a factor.Jul 6, 1984 · N7521Z · Substantial damageNTSB FTW84FA300Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Georgetown, TXThe acft crashed into trees during takeoff following a reported loss of power. The engine by observation was running at impact. Investigation showed a worn magneto and fouled spark plugs; #3 bottom plug was coated with unburned oil and foreign matter. The…Jul 5, 1984 · N25466 · Substantial damageNTSB NYC84FA228Accident · 1 fatalField investigationFinal reportBeech B55 · N. Haverhill, NHA friend who observed the plt preflighting the acft saw him drain fuel from the sumps to check for water. However, he did not see the plt check the fuel level in the tanks. The plt taxied to the rwy, performed an eng run-up & took off. Shortly after lift-off,…Jul 3, 1984 · N8101R · DestroyedNTSB NYC84FU006Accident · 1 fatalFinal reportPterodactyl Pfledgling · Canandaigua, NYDuring takeoff, the ultralight vehicle was observed to enter a steep climb. A witness stated that when it was climbing over the midpoint of the rwy, it entered a steep dive. The plt recovered from the descent & began another steep climb. After reaching about…Jul 2, 1984 · UNREG · DestroyedNTSB MKC84FA195Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Osage Beach, MOWitness stated acft touched down midfield and bounced several times on the rwy. Two witnesses heard power applied and the acft lifted off 300 ft from the end of the rwy. They stated flaps were fully extended for the total transition and the gear was retracted…Jul 2, 1984 · N5019P · DestroyedNTSB SEA84LA150Accident · No injuriesLimited investigationFinal reportCessna 172 · Bend, ORThe plt was taking off from a cinder road. He stated that the acft used about 2,300 ft of ground run & he rotated at about 66 mph. At about 15 ft AGL the nose dropped & the acft struck the ground. Both wing tips were damaged. Density altitude was 6400 ft.Jul 1, 1984 · N8467U · Substantial damageNTSB MKC84LA193Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersville, IAThe acft was over max gross wt by aprx 147 lbs and exceeded the fwd CG limit with a 1200 lb chemical load. During the initial climb at 50-100 ft AGL the acft could not maintain flying speed, stalled, and entered an uncontrolled descent. The acft impacted…Jul 1, 1984 · N9857V · Substantial damageNTSB CHI84LA276Accident · No injuriesLimited investigationFinal reportCessna 150G · Williamston, MISome cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.Jul 1, 1984 · N3495J · Substantial damageNTSB ATL84LA214Accident · Serious injuriesLimited investigationFinal reportMooney M-20F · Red Bay, ALThe acft landed gear up short of the rwy in an attempt to return to the rwy after a power loss at low alt. During takeoff the arpt manager said the engine sound change was consistent with power loss from fuel starvation. FAA did a post accident engine test…Jul 1, 1984 · N3207F · Substantial damageNTSB NYC84FFA03Accident · 1 fatalFinal reportAeronca 11AC · Glens Falls, NYA witness noted that, on takeoff, the acft appeared to be out of control. It entered a nose high attitude, then 'fell.' The plt recovered before the acft hit the ground, but the airplane 'oscillated in altitude until out of line of sight.' Subsequently, the…Jun 30, 1984 · N3283E · DestroyedNTSB DEN84LA203Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Recluse, WYThe plt stated that while taking off from a grass strip the acft drifted to the left. He could not then define the strip from the remaining area of the field due to the tall grass. He applied full right rudder but the acft continued to swerve to the left &…Jun 30, 1984 · N1790X · Substantial damageNTSB DEN84FTE02Accident · No injuriesFinal reportJohn R Jones PDQ2VW · Aurora, COThe homebuilt acft was being tested for flt even though previous tests had proven that the engine would not support flt. The plt said the carburetor had been improved prior to this test. The acft tookoff and climbed to about 15 ft AGL and stayed at that alt…Jun 30, 1984 · N44222 · Substantial damageNTSB DEN84FA202Accident · 2 fatalField investigationFinal reportBeech 35 · Albuquerque, NMAccording to arpt personnel the plt was known to perform maintenance on his acft. The plt was not a licensed A&P. According to witnesses, the acft tookoff and climbed to aprx 200 to 250 ft and the eng quit. The acft climbed 'a little more', then made a left…Jun 30, 1984 · N3267V · DestroyedNTSB CHI84LA272Accident · Minor injuriesLimited investigationFinal reportHoward E. Lee Rutan Long EZ · Minneapolis, MNThe plt claimed a loss of power during takeoff. He turned and attempted a landing on the arpt. The rwy was overrun and the acft stopped in a wheat field. Post accident examination of the engine revealed no discrepancies.Jun 30, 1984 · N373JH · Substantial damageNTSB ATL84LA213Accident · 1 fatalLimited investigationFinal reportCessna 172N · Summerville, SCA witness observed the aircraft as the pilot attempted a downwind takeoff. The takeoff roll was longer than normal. The aircraft was observed to become airborne about 2000 ft down the rwy. The aircraft never established a positive rate of climb but the nose…Jun 30, 1984 · N3JR · Substantial damageNTSB MKC84LA189Accident · No injuriesLimited investigationFinal reportCessna T210M · Kirksville, MOAfter taking off, the plt noted a malfunction of the landing gear sys. He then tried to lower the gear, but the nose gear would not extend. All attempts to extend the nose gear were unsuccessful, so the plt elected to make a wheels-up landing. After the…Jun 29, 1984 · N761YR · Substantial damageNTSB DEN84LA204Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Page, NDEngine siezed during takeoff climb at alt of aprx 100 ft AGL. Acft contacted trees during the forced landing. Examination of engine turbo section revealed the blower section had separated as a result of bearing failure. According to a mechanic who…Jun 29, 1984 · N5332 · Substantial damageNTSB NYC84FA224Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Lincoln Park, NJThe acft collided with the ground shortly after takeoff. A following acft plt said the acft was slow and long on takeoffroll and stayed low after takeoff. The acft made a 90 degree right turn and then a 270 degree left turn and was about lined up to land…Jun 28, 1984 · N4342T · DestroyedNTSB DEN84FA199Accident · 2 fatalField investigationFinal reportMooney M20J · Broomfield, COThe aircraft had been idle for 40 days and was refueled to capacity with 30 gals the night before the flight. Plt and pass were departed at 0819 for a scheduled 0830 meeting 150 miles away. On initial climb, plt reported a power loss. Acft observed to…Jun 28, 1984 · N3713H · DestroyedNTSB ATL84FU005Accident · 1 fatalFinal reportHumer Unknown · Carrollton, KYThe ultralight took off from an airstrip and climbed to about 100 ft AGL. At this point the operator turned to the left and a witness noticed the wings rocking until a right turn was established. This turn continued until the vehicle hit the ground. The…Jun 28, 1984 · UNREG · DestroyedNTSB LAX84LA373Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Yuba City, CAAfter dispensing 8 loads, the plt refueled & took off with the 9th load. About 4 to 6 seconds into the flt, while approaching transitional lift at aprx 6 ft AGL, the helicopter began a vibration & immediately lost rotor RPM. The plt initiated a landing…Jun 27, 1984 · N530HA · Substantial damageNTSB ANC84LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Ekuk, AKThe acft collided with a water pipe about 6 ft AGL during takeoff. Witnesses said that the plt did not use all availablerwy. Witnesses also said that he drifted off the rwy centerline after a premature takeoff. The plts employer said that he had warned him at…Jun 27, 1984 · N8941N · Substantial damageNTSB SEA84LA145Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Levenworth, WAThe amphibious acft started to 'porpoise' in the air after takeoff and stalled aprx 25 ft above water level. The acft dragged a wing, crashed and sank. The plt said that water in the hull had caused the unstable condition.Jun 26, 1984 · N65627 · Substantial damageNTSB DEN84FA196Accident · 3 fatalField investigationFinal reportCessna 172RG · Red Feather Lak, COAcft departed downwind into rising terrain with density altitude calculated to be 10,935 ft. acft was observed to mush into rising terrain 300 ft higher than and 3 mi west of the rwy.Jun 26, 1984 · N5096R · DestroyedNTSB CHI84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mahnomen, MNShortly after taking off, the eng lost power. The plt stated that the eng stopped completely 'like fuel starvation.' He dumped his load of chemicals & made an emergency landing. During the landing, the acft hit a ditch & nosed over. An investigation revealed…Jun 26, 1984 · N6584 · Substantial damageNTSB NYC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marlboro, NJOn initial climb after takeoff, plt noted a loss of climb performance, executed steep 180 degree turn to avoid high voltage lines on rising terrain ahead. This maneuver, coupled with reduced power resulted in an airspeed decrease to near stall speed. Plt…Jun 25, 1984 · N40921 · Substantial damageNTSB FTW84FA287Accident · Minor injuriesField investigationFinal reportBell 212 · Galveston, TXDuring takeoff, the helicopter lifted off in an 80% power check & the plt began a northerly departure. Before achieving translational lift, the rotor RPM dropped to aprx 85%. The torque meter indicated a split with the #1 eng indicating about 55% & the #2 eng…Jun 25, 1984 · N2180J · Substantial damageNTSB CHI84LA265Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kankakee, ILThe eng quit shortly after takeoff & the acft landed in a bean field. The fuel selector was found on the empty right main fuel tank. The left main fuel tank & tip tanks were full of fuel.Jun 25, 1984 · N40712 · Substantial damageNTSB ATL84LA209Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Williamsport, TNPilot stated that while departing from a small 2000 foot long private strip the engine appeared to loose power. The aircraft would not climb and collided with a tree at the departure ens of the rwy. The acft then collided with several other trees prior to…Jun 25, 1984 · N6418N · DestroyedNTSB SEA84LA143Accident · No injuriesLimited investigationFinal reportEipper Quicksilver Mark II · Salem, ORPlt attempted takeoff on short grass field at gross wt with a OAT of aprx 80 deg f. once airborne the acft drifted to the left of the airstrip. Plt pulled up to clear a fence. After clearing the fence the acft stalled striking the ground with the left wing…Jun 24, 1984 · N4451T · Substantial damageNTSB MKC84LA182Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Overland Park, KSPrior to a sight-seeing flt, the plt orbained a wx briefing & released test balloons to check the wind spd & drctn. The prevailing wind was in a southerly direction at about 8 KTS. The plt of N4070W initiated his departure from a school yard after another…Jun 24, 1984 · N4070W · Substantial damageNTSB CHI84LA258Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Mears, MIThe pilot reported that when the amphibious aircraft reached 8 to 10 feet AGL during takeoff, a x-wind gust caused the left sponson to contact the water surface. This caused loss of control and resulted in the plane crashing inverted in the Lake.Jun 24, 1984 · N8003H · Substantial damageNTSB ATL84LA211Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · Gilbertsville, KYThe acft was used for public rides at an amusement park. During the takeoff to ferry the acft back to an overnight parking space the engine quit at 100 ft AGL. The plt said he started the acft and hovered using fuel from the aft fuel tank. When the engine…Jun 24, 1984 · N90414 · Substantial damageNTSB NYC84FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Keymar, MDWitness stated acft was performing touch & go landings. On third or forth initial climb at about 300 ft AGL the acft began 'zigzagging.' The acft then entered a nose low atitude and descended to ground impact aprx 1/2 mile from the arpt. Inspection of…Jun 23, 1984 · N704GV · DestroyedNTSB ATL84FKG08Accident · No injuriesFinal reportCessna 177RG · Pell City, ALDuring the takeoff sequence, the alternate air door hinge failed, allowing the door to separate and progressively block the induction air system to the point that insufficient power was available to sustain further flight. A forced landing was effected in a…Jun 23, 1984 · N7554V · Substantial damageNTSB ANC84LA098Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Healy, AKShortly after lifting off from an airstrip, the eng lost power. The plt tried to make an emergency landing on a highway, but was unable to reach it. The acft was damaged when he landed in the tops of trees. The reason for the power loss was not found.Jun 23, 1984 · N1210H · Substantial damageNTSB FTW84LA281Accident · No injuriesLimited investigationFinal reportCessna 150G · Ennis, TXAfter the plt experienced a rough running eng while doing touch & go landings he executed a precautionary ldg. Upon rollout the acft nosed over in a ditch & came to rest inverted. Post crash examination of the eng revealed no evidence of a mechanical failure…Jun 22, 1984 · N2204J · Substantial damageNTSB SEA84FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Burley, WAThe non-rated plt was employed as an acft cleaner & had access to the ignition keys of several acft, including N6950J. Earlier during the evening, he was seen consuming beer. At about 0024 PDT, he took off from rwy 18. About 1 min later, the acft collided…Jun 21, 1984 · N6950J · DestroyedNTSB MIA84FA190Accident · Serious injuriesField investigationFinal reportCessna 182P · Chattahoochee, FLDuring the takeoff climb at an altitude of aprx 100 AGL, the acft entered a right diving turn. It impacted the ground and came to rest in a wooded area to the right of the rwy departure end. The plt stated the engine was operating normally. The acft is equipt…Jun 21, 1984 · N21335 · DestroyedNTSB ANC84LA096Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Rainbow Lake, AKThe plt stated that the acft 'was sluggish getting on the step. After lift-off it still performed under par. We cleared the hills and trees. On the downside of the hill we hit a downdraft. We hit the trees nose high; climb power.' The reported wind was calm.…Jun 21, 1984 · N3694T · DestroyedNTSB LAX84FA361Accident · No injuriesField investigationFinal reportCessna 404 · San Francisco, CAThe nose baggage door of the acft came open right after the gear was raised during takeoff. The plt said the acft began to pitch up & roll right. He felt that control of the acft was in doubt, so he aborted the intersection takeoff & landed gear-up on the…Jun 20, 1984 · N5340J · Substantial damage