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 CHI84FA396Accident · 1 fatalField investigationFinal reportRobert Eggebrecht Sonerai 2L · Plato Center, ILThe acft stalled & spun to the ground from about 200 ft AGL after an abrupt pull-up to aprx 45 degree deck angle during a premature liftoff. The plt had been observed making high speed taxi runs 'to get the feel of the acft'. After a run resulted in a…Sep 22, 1984 · N199B · DestroyedNTSB ANC84LA187Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Cairn Mountain, AKThe acft crashed during a takeoff from a remote airstrip. The plt stated that he walked the strip prior to starting the takeoff. He said that immediately after liftoff the acft began to drift left. Before he was able to make a correction the tail of the acft…Sep 22, 1984 · N8028K · Substantial damageNTSB ANC84FA189Accident · No injuriesField investigationFinal reportCessna 188 · Chugiak, AKThe plt stated the acft was covered with ice but he removed the majority of it before taking off. The acft contained a 200 gal load of fuel in the hopper. The plt stated the acft accelerated slower than normal and the takeoff ground run was long. He stated…Sep 22, 1984 · N84490 · Substantial damageNTSB DEN84LA297Accident · No injuriesLimited investigationFinal reportWindecker Research Eagel AC7 · Deming, NMThe acft collided with the rwy gear up after takeoff. The plt said he encountered a microburst which forced the acft to the rwy. There were reported thunderstorms in the area. The plt also said he is going to alter his takeoff proceduresto raising the landing…Sep 21, 1984 · N4198G · Substantial damageNTSB NYC84LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Medford, NJDuring engine run-up, right magneto had excessive RPM drop. Plt leaned mixture for burn-out and inavvertently shut down engine. After restart, plt ran engine with lean mixture; subsequent magneto check was within limits. At 300 ft AGL on initial climb, engine…Sep 19, 1984 · N33396 · Substantial damageNTSB NYC84FNE07Accident · 1 fatalFinal reportFuller/Findlay Varieze · Worcester, MAWitnesses stated, after what appeared to be a longer then normal takeoff roll, acft rotated to a very steep climb angle. Estimates regarding climb angle vary from 'slightly nose up' to vertical. Acft climbed to 100-150 ft AGL and rotated to an extremely nose…Sep 19, 1984 · N67TR · DestroyedNTSB ATL84LA291Accident · No injuriesLimited investigationFinal reportCessna 150L · Vine Grove, KYDuring landing roll on an 1800 ft sod airstrip, nose wheel began to shimmy and the plt initiated an aborted landing. Plt added full power and raised flaps to 10 deg. As acft approached power lines near departure end of the rwy plt made a slight left turn and…Sep 18, 1984 · N5447Q · Substantial damageNTSB ANC84LA181Accident · No injuriesLimited investigationFinal reportCessna 152 II · Skwentna, AKFBO had been experiencing difficulties with spark plugs and magnetos in this acft. The plt had flown this acft before with recurrent rough running and diminished power symptoms. Eng began to run rough on this flt and plt landed on a sand bar (marked for acft…Sep 17, 1984 · N94505 · Substantial damageNTSB CHI84LU011Accident · Serious injuriesFinal reportReicher FP-101 · Mankato, MNThe pilot of the ultra-light stated that he made a take-off and climbed to about 30 ft then attempted a right turn. He said the aircraft stalled and crashed into the soybean field field. The pilot reported 12 previous flights but no pilots certificate.Sep 16, 1984 · UNREG · DestroyedNTSB ANC84LA177Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Point Hope, AKThe acft crashed during an attempted night takeoff with the plt controlled rwy lights turned off. The plt stated he had consumed a couple of alchoholic beverages earlier in the evening; and although approached by several people to fly, he stated he refused…Sep 16, 1984 · N731FT · Substantial damageNTSB FTW84LA398Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seguin, TXThe acft crashed during the takeoff phase of a touch-&-go landing. The student plt stated that the wind direction and speed had changed at lift-off causing the acft to become airborne then to descend and hit the ground before coming to a stop inverted.Sep 15, 1984 · N51250 · DestroyedNTSB ATL84LA289Accident · No injuriesLimited investigationFinal reportWilliam T. Hodges Goldwing · Americus, GADuring the initial takeoff climb at an alt of 150 ft AGL, a ttl loss of power occurred. A forced landing was made in a soybean filed at which time the acft was substantially damaged. The plt stated the loss of power resulted from the installation of a…Sep 15, 1984 · N132GW · Substantial damageNTSB ANC84FA176Accident · No injuriesField investigationFinal reportCessna 170B · Anchorage, AKPlt stated takeoff was slow and acft could not clear on-coming rising terrain and obstacles. Left wing contacted 100 ft tall tree tops aprx 2500 ft from departure end of rwy yawing acft 180 degrees from direction of flt. Plt failed to perform weight and…Sep 15, 1984 · N3010A · Substantial damageNTSB MKC84LA277Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Vilonia, ARThe acft was forced to land after takeoff when the engine lost power. The plt said he had refueled from the automotive pump at his grocery store. The plt suspected water contaminaion in the fuel.Sep 13, 1984 · N1629P · DestroyedNTSB MKC84LA275Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Little Rock, ARThe antique acft was purchased and a ferry flt to California attempted with very limited dual instruction and minimal knowledge of the acft. The propeller installed on the acft was not in accordance with FAA specifications. An STC was available for the…Sep 12, 1984 · N6516K · Substantial damageNTSB NYC84FIG04Accident · 1 fatalFinal reportJett Shoestring · Gaithersburg, MDAccording to witnesses, the acft experienced an engine power loss during the initial climb after takeoff. The acft was observed to descend near vertically to ground impact. Teardown of the engine revealed discrepancies in the carburetor assembly. The plt had…Sep 10, 1984 · N53J · DestroyedNTSB CHI84LA389Accident · Minor injuriesLimited investigationFinal reportDenil Sonera II · De Pere, WIPlt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.Sep 10, 1984 · N2265N · Substantial damageNTSB ANC84LA180Accident · No injuriesLimited investigationFinal reportCessna U206 · Hartman River, AKThe pilot stated that after takeoff the right gear collided with brush slowing the aircraft. The aircraft then touched down in rough terrain and nosed over.Sep 10, 1984 · N5015U · Substantial damageNTSB MKC84LA273Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Pleasant Hill, MOThe acft settled into 10-15 ft tall trees during takeoff. The rwy was 1200 ft long and the wind was 2 KTS. The plt said the trees should be cut as a preventive measure. The plt also said there were no problems with the acft.Sep 9, 1984 · N7262L · DestroyedNTSB ATL84FA282Accident · Serious injuriesField investigationFinal reportPiper PA-31-325 · Lynchburg, VAShortly after takeoff the plt reported to the tower that the left eng had failed. The prop was feathered and a left turn to downwind initiated. In the turn the right eng failed and the acft flew into trees in a residential area about 1 mile from the arpt. No…Sep 9, 1984 · N29RH · DestroyedNTSB ANC84LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle City, AKAfter tkf the plt made a rt turn. The plt was unable to rollout from the turn. The acft pitched down slightly. The plt applied full power and lowered the flaps full down. The plt was unable to stop the descent. The acft collided with the ground in a rt…Sep 9, 1984 · N3816Z · Substantial damageNTSB LAX84LA476Accident · No injuriesLimited investigationFinal reportCessna 152 · Rialto, CAThe plt stated that this was the first flt after the eng had been overhauled. During the takeoff climb at an alt of 500 ft the eng lost pwr. The plt made a hard landing adjacent to the rwy. Exam of the eng after the accident revealed the exhaust rocker arm…Sep 8, 1984 · N4959H · Substantial damageNTSB LAX84FA472Accident · 2 fatalField investigationFinal reportCessna 310 · Redlands, CAGnd witnesses obsvd an initial erratic takeoff gnd roll. After the acft reached 200 ft it experienced a power loss on the left engine. The acft stalled as it turned left, entered into an uncontrolled descent and crashed. The post impact fire consumed the…Sep 8, 1984 · N381LS · DestroyedNTSB ANC84LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKAccording to the plt, he was taking off from a hay field to the east toward trees that were up to 80 ft tall. He estimated a right quartering head wind at 15 KTS gusting to 25 KTS. He stated that he encountered a downdraft just before reaching the area of the…Sep 8, 1984 · N5127Y · Substantial damageNTSB SEA84LA222Accident · No injuriesLimited investigationFinal reportCessna 150 · Spanaway, WAAcft lost power during takeoff. Plt made forced landing straight ahead in open field.Sep 7, 1984 · N5701G · Substantial damageNTSB CHI84LA386Accident · No injuriesLimited investigationFinal reportPiper PA25 · Sheboygan, WIPlt initiated takeoff in strong gusty x-wind. Approaching tree line, acft began to sink. Plt turned to avoid trees and stalled acft. Load jettison was too late to aid in stall recovery and acft mushed into ground.Sep 7, 1984 · N4571Y · Substantial damageNTSB ATL84FKG12Accident · No injuriesFinal reportCessna 411 · Hazlehurst, GAUpon takeoff at alt of 300 ft AGL, plt stated, rt engine failed. Plt feathered rt engine. Acft began to turn to rt so plt reduced pwr on left engine and made a forced landing straight ahead in a field. Acft contacted a small pine tree, slid sideways and gear…Sep 7, 1984 · N666CS · Substantial damageNTSB FTW84LA380Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXFailure to complete both the takeoff and landing check-lists resulted in taking off with the elevator trim improperly set and the gear-up landing. According to the plt, as the acft was cleaned-up after takeoff from rwy 17R the nose became very heavy. The…Sep 6, 1984 · N3675T · Substantial damageNTSB FTW84LA379Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Antonio, TXThe acft did not climb above 25 to 50 ft AGL after takeoff. The plt said 'the engine felt loaded down.' The stall warning horn sounded and the plt told everyone to 'hang on' as he lowered the nose of the acft. The acft touched down about 555 ft beyond the…Sep 6, 1984 · N6842J · Substantial damageNTSB DEN84LA285Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Berlin, NDThe acft collided with the ground in a soft field and nosed over. The plt reported that the engine lost power and he could not dump his load because the dump handle came off. The plt said 100 gallons of liquid fertilizer was loaded on the acft. The plt did…Sep 6, 1984 · N6887Q · Substantial damageNTSB CHI84LA378Accident · No injuriesLimited investigationFinal reportCessna 320B · Clear Lake, MNFollowing maint on an air vent the mechanic failed to secure the map compartment. The ass'y interfered with the rearward movement of the control yoke on rotation for takeoff limiting the climb rate and resulting in a collision with the trees. The flt…Sep 6, 1984 · N32ORD · Substantial damageNTSB ANC84FA157Accident · No injuriesField investigationFinal reportArtic S-1B2 · Clam Gulch, AKPlt stated that on takeoff from a 600 ft long gravel bar, the acft hit a clump of brush with the rt main landing gear. He stated that the acft turn into the path of taller brush, so he reduced the pwr and landed, turn 180 degrees after impact. The plt aslo…Sep 4, 1984 · N62AT · Substantial damageNTSB NYC84LA302Accident · No injuriesLimited investigationFinal reportCessna 305A · Madison, CTPurpose of flt was fam in this make/model for front seat plt by rear seat check-out plt. Preflight fuel quantity was checked by ref to gages only. Left tank read 1/2 full. Neither plt recalled rt tank reading. After takeoff, at about 150 ft, complete pwr loss…Sep 3, 1984 · N11SU · Substantial damageNTSB LAX84LA470Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAAt 100 to 150 ft AGL eng RPM decreased to about 1,500. A turn back to the arpt was initiated. On short final the left wingtip struck a fence causing the acft to cartwheel to a stop on arpt property. Eng exam revealed that the #2 cyl was developing no…Sep 3, 1984 · N29484 · Substantial damageNTSB LAX84FA467Accident · 2 fatalField investigationFinal reportPiper PA-23-235 · Rubidoux, CAThe plt failed to remove the control lock during his preflt inspection; thus, the elevator control was locked & no pitch control was available during the takeoff. Rotation occurred when the acft reach flying speed. The acft became airborne & its pitch angle…Sep 3, 1984 · N4967P · DestroyedNTSB CHI84LA380Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Pontiac, MIDuring a takeoff climb at 400 ft AGL the eng lost pwr. The plt stated that he failed to switch fuel tanks. The right fuel tank was found empty.Sep 2, 1984 · N499LG · Substantial damageNTSB MKC84LU008Accident · Serious injuriesFinal reportEipper Quicksilver MX · North Platte, NEThe ultralight operator said he turned off the selector valve after a previous landing. During a later takeoff, he failed to use a checklist and did not reset the selector. The engine quit at about 30 ft AGL. Ground witnesses heard theengine sputter and…Sep 1, 1984 · UNREG · Substantial damageNTSB MIA84LA245Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Fort Drum, FLThe acft collided with a power line and the ground after a loss of power during takeoff. The plt was not certificated. The passenger said that the plt attributed the power loss to water in the fuel. The acft was being operated on automobile fuel. Attempts to…Sep 1, 1984 · N7580E · Substantial damageNTSB LAX84LA477Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Byron, CADuring takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board.Sep 1, 1984 · N77G · Substantial damageNTSB ANC84LA159Accident · No injuriesLimited investigationFinal reportCessna 172E · Palmer, AKThe acft was taking off from an airport which was an unimproved field site. According to the plt the acft would not accelerate and climb out so he stalled into the brush along a creek bed. The plt said the acft had departed this field before but both times…Sep 1, 1984 · N5425T · Substantial damageNTSB BFO84IA004Incident · No injuriesIncident investigationFinal reportBeech 58 · Washington, DCThe plt made an emergency landing on rwy 18 following a loss of power in the rt eng & a subsequent in-flight fire. Investigation revealed a crack in the #1 cyl that originated at the exhaust port, downstream of the valve. The crack propagated through fatique…Aug 31, 1984 · N72TM · Minor damageNTSB FTW84LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schriever, LAThe plt stated that he had full fuel & a full load of spray when the eng exploded. The nature & cause of the pwr failurewas not determined & external examination of the eng revealed no evidence of a mechanical failure.Aug 30, 1984 · N5469 · Substantial damageNTSB LAX84LA461Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Livermore, CAThe plt visually checked the fuel tanks during his pre-flt & estimated 10-20 gals of fuel remaining in both the left & right tanks. He said that the start, taxi & run-up were performed while using the right rank. He reported that the right fuel gage reading…Aug 29, 1984 · N2876W · DestroyedNTSB LAX84FA463Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Bakersfield, CAThe student plt landed long on an intended touch and go landing and therefore, rolled out to a full stop on rwy 31. A 180 deg turn was made at the end in order to takeoff on rwy 13. Prior to initiating the takeoff, according to the student plt, he placed the…Aug 29, 1984 · N7916W · Substantial damageNTSB CHI84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lake City, MIAccording to the plt, at about 30 ft AGL after takeoff the eng RPM began to decrease. The acft flew into a tree adjacent to a road near the end of the rwy. A visual inspection of the engine revealed no mechanical malfunctions. The property owner reported that…Aug 29, 1984 · N7335D · Substantial damageNTSB CHI84IA373Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Madison, WIShortly after lift-off & while climbing thru about 150 ft AGL, there was a loud noise from the left eng when it failed. The aircrew secured the left eng, returned to the arpt & made a single eng landing without further incident. An investigation revealed that…Aug 29, 1984 · N7351F · No damageNTSB CHI84FA369Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Muncie, INWitnesses reported that when the acft was taking off, the eng sounded 'rough & was backfiring.' They observed the acft cross the departure end of the rwy at a lower alt & slower speed than what they considered as normal. They saw the acft's wings rock, then…Aug 29, 1984 · N4355N · DestroyedNTSB NYC84FFA05Accident · Serious injuriesFinal reportRussell ST. Arnold RLU-1 · Oneonta, NYThe acft was observed making taxi runs up & down rwy 13. On the last run the acft became airborne, climbed to aprx 75 ft, made a steep left bank & impacted the ground. The plt stated he has no recollection of making the takeoff.Aug 28, 1984 · N2B · Substantial damageNTSB MKC84FCA02Accident · Serious injuriesFinal reportMooney M20E · Chesterfield, MOThe acft crashed short of the rwy after making a 180 deg turn after takeoff following a loss of power. The plt stated that after takeoff & at an indicated airspeed of 100 to 110 mph, at an altitude of 50 ft, the acft eng started to lose power. He decided to…Aug 28, 1984 · N9373M · DestroyedNTSB DEN84LA270Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Grand Forks, NDDuring initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the…Aug 27, 1984 · N1268W · Substantial damage