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 FTW84LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Monterey, LAThe plt landed at an improved private strip. Later, he took off in winds that he reported were down the rwy at 12 KTS gusting to 14 KTS. After lift-off the acft 'climbed normally' & cleared a power line as well as low trees at the end of the strip. However,…Apr 15, 1984 · N8284F · DestroyedNTSB NYC84FA129Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Burlington, CTThe acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff the…Apr 14, 1984 · N9487C · DestroyedNTSB MKC84LA125Accident · No injuriesLimited investigationFinal reportCessna 150K · Paragould, ARA student pilot carrying a passenger landed to refuel. Unaware of the procedure to acquire fuel at this location, he took off for another airport. The engine quit on climb-out and the aircraft was substantially damaged when it landed short of the runway. No…Apr 14, 1984 · N6057G · Substantial damageNTSB MKC84LA123Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARThe owner/plt reported that just after lift-off, he heard a loud squeal & the eng lost power. He dumped his load to clear trees then landed hard in a wheat field just beyond the trees. A dissassembly of the eng revealed that a supercharger bearing had failed…Apr 13, 1984 · N8522V · Substantial damageNTSB DEN84LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Monticello, UTThe pilot departed uphill with a tailwind at near gross weight with a high density altitude. The flight was late gettingstarted & an excessive magneto drop was attributed to a fouled plug. The pilot also stated that he was under mental stress. The acft lifted…Apr 13, 1984 · N4FN · Substantial damageNTSB NYC84FA137Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Marlboro, NJPilot and pax departing 2170 ft rwy at near max gross weight pax stated it didnt appear as if they were going to clear high tension power lines located about 2400 ft from rwy end. Pilot made left turn and impacted unmarked wires about 600 ft left of extended…Apr 10, 1984 · N9950U · DestroyedNTSB NYC84FHM05Accident · 1 fatalFinal reportCessna 182P · Clarkstown, NYStudent plt stated he informed the CFI during takeoff that the acft would not continue to climb. The CFI then took control of the acft. Witnesses stated the eng seemed to stop and the acft entered a glide, banking to the left from aprx 150 ft AGL. The left…Apr 7, 1984 · N1516M · DestroyedNTSB MKC84LA120Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Panama, NEShortly after takeoff, the eng lost power & decelerated to idle RPM. The plt attempted to restore power while making a 180 deg turn back to the arpt. During the landing, the acft struck the ground, nose 1st, collapsing the gear. The acft came to rest after…Apr 7, 1984 · N893IT · Substantial damageNTSB ATL84FMG02Accident · No injuriesFinal reportPiper PA-28-150 · Apex, NCAccording to the plt, the eng lost power during takeoff. He was able to keep the eng running by pumping the throttle but was not able to gain altitude. He made a forced landing on an abandoned railroad bed. Investigation revealed that the resistoflex hose p/n…Apr 5, 1984 · N5839W · Substantial damageNTSB FTW84LA185Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eunice, LAThe plt reported that the engine lost power on takeoff and return to the rwy was not possible, so he landed on the edge of a pond. A post accident investigaiton revealed a crack in the #7 cyl head between the spark plug holes. The engine had just gotten a…Apr 4, 1984 · N9936 · Substantial damageNTSB LAX84LA239Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Davis, CAThe acft made a forced landing in an open field following a power loss during takeoff. The engine was examined after theaccident and test run. No discrepancies were found. At the time of the accident weather conditions were conducive to carburetor icing.Apr 3, 1984 · N95603 · Substantial damageNTSB ANC84LA050Accident · No injuriesLimited investigationFinal reportCessna U206G · Kodiak, AKAccording to the plt, he initiated a takeoff in a northerly direction, but the acft would not climb after lift-off. He chopped the pwr & the acft immediately touched down. Then the acft bounced, yawed left & the rt float hit the water sideways. The acft…Apr 3, 1984 · N4726U · Substantial damageNTSB CHI84LA145Accident · No injuriesLimited investigationFinal reportCessna 150F · Davison, MIThe PIC stated that although he was flying the acft the right seat plt was controlling the flap settings. The right seatplt set 20 deg for takeoff. After takeoff they noticed that they would not be able to clear trees so they right seat pltadded full flaps…Apr 1, 1984 · N6659F · Substantial damageNTSB LAX84LA237Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Happy Camp, CAWhile waiting for fog to 'burn off,' the plt preflighted the acft & then waited for about 45 min at the end of the rwy. He then decided to takeoff while the wx was still IMC. Shortly after lift-off, the acft entered instrument conditions & began turning to…Mar 30, 1984 · N9254U · DestroyedNTSB CHI84LA147Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Kelleys Island, OHAccording to the plt, rotation occurred about 3/5 of the way down the gravel strip and the acft climbed to 20-30 ft when the power loss occurred. In an effort to maintain alt the nose attitude was increased and the tail of the acft struck the trees and then…Mar 30, 1984 · N30204 · Substantial damageNTSB DEN84FA119Accident · No injuriesField investigationFinal reportBeech 65-A90 · Rangely, COShortly after takeoff on a left downwind departure, a power loss on both engines occurred. Both main gear collapsed during a forced landing in a muddy sagebrush covered field. The plt had refueled the acft & had failed to drain the fuel storage tank & acft…Mar 28, 1984 · N114CW · Substantial damageNTSB ATL84FA133Accident · 2 fatalField investigationFinal reportBeech A36TC · Atlanta, GADuring takeoff, the plt radioed that a door had popped open & he needed to return. According to a plt witness, the acft had climbed above treetop level when it started to lose alt. Another witness said the acft leveled off & started to sink, then the nose…Mar 27, 1984 · N3808N · Substantial damageNTSB FTW84LA177Accident · No injuriesLimited investigationFinal reportCessna 150F · Pearland, TXDuring takeoff, the engine lost power at about 150 feet AGL while the aircraft was climbing. The pilot made an emergency landing in a field 1/2 mile from the airport. The engine was later test run and no malfunctons noted that would account for the power loss.Mar 26, 1984 · N8222S · Substantial damageNTSB DEN84FA115Accident · Serious injuriesField investigationFinal reportCessna 172RG · Greeley, COThe acft collided with trees and the ground during a night forced landing. The acft had made some strange sounds and started vibrating after takeoff. A glide was set up for a forced landing. Since the arpt could not be reached a landing was made on a dry…Mar 25, 1984 · N6521R · DestroyedNTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…Mar 24, 1984 · N23968 · DestroyedNTSB ATL84LA130Accident · Serious injuriesLimited investigationFinal reportPiper J-5A · Forest, VAThe acft was taxied directly to takeoff after being handpropped to start. To the witness who handpropped the acft it appeared to climb at about a 70 degree angle after takeoff and stall before diving nose first into the ground. Engine sounds remained constant…Mar 24, 1984 · N33423 · Substantial damageNTSB ATL84FMG03Accident · Minor injuriesFinal reportBowers FLY Baby 1A · New Bern, NCThe plt stated the acft lost lateral control during takeoff. He reduced power and landed the acft off the side of the rwy while maintaining directional control using the rudder. The acft stalled at about 20 ft AGL and was damaged during the hard landing.…Mar 24, 1984 · N4986E · Substantial damageNTSB ATL84FA129Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Woodstock, GAShortly after breaking ground during the takeoff, the engine lost power & the acft came back down to the rwy. The engine regained power & the plt continued the takeoff. The engine again lost power. Subsequently, the acft impacted on an uneven, grassy, open…Mar 23, 1984 · N4809S · Substantial damageNTSB LAX84LA229Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Lakeport, CAThe plt reported that on his preflight he found the eng compression & oil level to be low but after servicing the oil to the proper level he departed & on initial climb, after reaching about 100 ft AGL, the eng started popping & losing RPM. The plt made a…Mar 22, 1984 · N6470K · Substantial damageNTSB FTW84LA172Accident · Minor injuriesLimited investigationFinal reportRobert Mcdonnell KR-2 · Kerrville, TXAccording to the plt/builder of the home built acft acceleration was not up to par during the takoff roll. Takeoff was continued and initial climb was poor. A downwind turn was initiated at about 100 ft AGL. During the turn the plt noticeda strip of tape on…Mar 21, 1984 · N125RM · DestroyedNTSB CHI84LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Ignace, MIThe pilot took off into adverse wx conditions & failed to attain sufficient altitude to clear trees. The purpose of the flight was to search for a missing acft.Mar 21, 1984 · N4354J · Substantial damageNTSB ATL84FA126Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Fletcher, NCDuring takeoff the left eng lost power shortly after the landing gear was retracted. The plt stated that he felt the loss of power at about the same time that he turned off the landing lights. With the left eng manifold pressure gauge reading 25 inches hg,…Mar 21, 1984 · N8300T · DestroyedNTSB NYC84FA113Accident · 1 fatalField investigationFinal reportBeech H-18 · Morrisonville, NYThe plt landed on the ice and snow covered rwy after loading 1512 lbs of cargo in freezing drizzle conditions, he taxied for takeoff for an IFR departure shortly after rotation, the right wing dropped and the acft touched down back onthe rwy. Visual exam of…Mar 20, 1984 · N218X · DestroyedNTSB SEA84LA069Accident · No injuriesLimited investigationFinal reportPiper PA 23-1300 · Battleground, WAThe acft had been parked on the ground for 2 yrs. Prior to the flt, it had been run-up several times. There was about 20 gal of fuel in each tank. The plt checked the fuel before takeoff & some water was found. He drained the fuel until no water was found.…Mar 17, 1984 · N3347P · Substantial damageNTSB NYC84LA112Accident · No injuriesLimited investigationFinal reportBeech 76 · Pittsburgh, PADuring the takeoff portion of a touch-&-go, the student plt forgot to raise the flaps. The instructor (CFI) yelled at the student '...the flaps', & at the same time, reached for the flaps with his right hand under the control wheel. Subsequently, the left…Mar 17, 1984 · N6697L · Substantial damageNTSB MKC84LA105Accident · No injuriesLimited investigationFinal reportBeech A36TC · North Platte, NEThe acft had just departed North Platte airport and retracted the landing gear. The acft door then opened, the pilot elected to land back on the runway and failed to remember to lower the landing gear.Mar 17, 1984 · N222HC · Substantial damageNTSB MKC84FA103Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Springdale, ARAbout 3 minutes after takeoff the acft was observed coming out of the 400-600 ft overcast sky in about a 75 deg nose down, right wing attitude. It impacted a 4-strand high voltage powerline prior to impact with the ground. The plt had received his instrument…Mar 16, 1984 · N6177P · DestroyedNTSB MKC84LA101Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Biscoe, ARAfter spraying operations acft propeller would be pressure sprayed. Water entered propeller pitch change bearings which corroded bearings. Eventually pitch movement was hindered by rust corrosion. The blade counterweight bolt broke allowing the propeller…Mar 14, 1984 · N8945H · Substantial damageNTSB SEA84LA067Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Elmira, ORThe acft collided with power lines and trees after a power loss during the takeoff initial climb. The plt stated he attempted a climbing turn to avoid the power lines and trees but the acft entered a departure stall, the acft was using automotive fuel. An FAA…Mar 13, 1984 · N68925 · Substantial damageNTSB SEA84LA070Accident · No injuriesLimited investigationFinal reportCessna 150-K · Fallon, NVThe student plt said he was departing his privately owned strip & had a 7 ft fence to clear at the departure end. He reported that just as he became airborne, the acft encounter a gust of wind which caused the right wing to hit a fence post, then the acft…Mar 12, 1984 · N6410G · Substantial damageNTSB MIA84FA101Accident · Serious injuriesField investigationFinal reportPiper PA-38 · Jacksonville, FLThe solo student plt was making a local practice flt. Witnesses observed the acft bank sharply to the left immediately after lift off & maintain a nose high attitude. The acft collided with the ground on the airport separating the left wing prior to coming to…Mar 10, 1984 · N25237 · DestroyedNTSB FTW84FU005Accident · Serious injuriesFinal reportEipper Quicksilver MXL · Huntington, TXThe plt made several touch and go landings in his newly acquired ultra light vehicle. On a subsquent flt at about 75 ft AGL, the outboard portion of the left wing folded upward about 90 degrees. The vehicle started to roll inverted and the plt used full…Mar 8, 1984 · UNREG · Substantial damageNTSB FTW84LA159Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Lamesa, TXShortly after takeoff for an aerial application flight a partial loss of power occurred. A hard forced landing was made in an open field which resulted in both main gears collapsing. Inspection of the engine revealed both magneto distributor blocks were…Mar 6, 1984 · N57584 · Substantial damageNTSB FTW84FA156Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Fort Worth, TXThe acft made a forced landing in an open field near the arpt when the right engine stopped at about 50-100 ft AGL during a touch and go landing. The CFI aboard said he had positioned the fuel tank selector to the inboard tanks prior to the last approach or…Mar 6, 1984 · N777RG · DestroyedNTSB MIA84LA097Accident · No injuriesLimited investigationFinal reportGardner Steen SKY Bont · Milton, FLThis was the initial test flt of the homebuilt acft. During takeoff the eng quit. The right landing gear caught on a guy wire during the emergency landing & the acft flipped. The plt/builder, who is a certified mechanic, attributed the power loss to a…Mar 4, 1984 · N90534 · DestroyedNTSB CHI84LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Crawfordsville, INAfter returning to the arpt, the student began practicing touch-&-go landings. While climbing thru about 150 ft AGL, after the 3rd landing, the eng sputtered twice, then quit running. The acft was landed straight ahead on snow covered terrain. When the…Mar 2, 1984 · N6076K · Substantial damageNTSB FTW84LA152Accident · Minor injuriesLimited investigationFinal reportBeech E-55 · Longview, TXShortly after takeoff the left engine ceased operating. A shallow turn back to the airport was being made when the rightengine ceased operating. A field was chosen for a forced landing and at touchdown a hard landing occurred. Investigationrevealed that the…Mar 1, 1984 · N1791W · Substantial damageNTSB MKC84LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Morrilton, ARThe acft lost power during initial climb after takeoff at about 75 ft AGL. A forced landing was made in the trees. The acft was examined after the accident and no failures or malfunctions noted. The existing temperature and dewpoint were in carburetor icing…Feb 27, 1984 · N56255 · Substantial damageNTSB NYC84LA093Accident · No injuriesLimited investigationFinal reportBell 206B · Tarentum, PADuring a practice flt the plt tried to lift off but the right skid seemed to stick. The acrt rolled to the right and although the plt stated he took corrective action the acft rolled over onto its right side.Feb 26, 1984 · N59405 · Substantial damageNTSB LAX84LA199Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Redding, CAThe total power loss occurred due to water contamination in the fuel. Water was found in the carburetor assembly after the accident. The pilot reported that he had drained 4 to 5 gals of fuel from each tank finding no water during the month preceding the…Feb 26, 1984 · N31SR · Substantial damageNTSB SEA84LA061Accident · No injuriesLimited investigationFinal reportBeech A33 · White City, ORThe acft crashed into trees after stalling into the ground during an attempted takeoff from a soggy short sod airstrip. The acft was rotated prematurely after which it stalled at about 40 ft AGL. The plt said he should have walked the fieldto determine its…Feb 25, 1984 · N9432Y · Substantial damageNTSB MKC84LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · N. Stillwell, KSAfter an eng power loss during takeoff climb, the plt landed the acft on the remaining runway. The hard landing resultedin a nose gear collapse. Post accident investigation revealed that the acft had only flown once in 7 months. The old automotive fuel had…Feb 25, 1984 · N3112H · Substantial damageNTSB FTW84LA146Accident · Serious injuriesLimited investigationFinal reportChance Vought F4U-5 · Alief, TXShortly after takeoff the aircraft experienced a power loss. The pilot attempted to land in an area of new residential construction and was forced to dive under power lines, the aircraft impacted the ground in a nose low attitude and slid to a stop in less…Feb 25, 1984 · N4903M · DestroyedNTSB CHI84LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Lima, OHHeavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up…Feb 25, 1984 · N30026 · Substantial damageNTSB MIA84FA092Accident · 3 fatalField investigationFinal reportPiper PA-30 · Sarasota, FLShortly after takeoff the acft entered a descending left turn, struck a wire, a car, and a tree before contacting a building and exploding. A passenger reported that the stall warning horn had activated at least twice during the initial takeoff climb prior to…Feb 23, 1984 · N710SC · Destroyed