# NTSB investigations: Initial climb NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 197 of 412 · 20,559 cases ## Cases, newest first - [NTSB MIA84FA090](https://openairdocs.org/ntsb/MIA84FA090.md): Cessna 310R · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1984 · N3447G · Destroyed > Prior to departure the plt noticed thunderstorms & lightning to the north of the arpt. He stated that immediately after takeoff he remembered a flash of light & a noise. His next recollection is impact & being in the water. The area around St. Petersburg at… - [NTSB ANC84FA036](https://openairdocs.org/ntsb/ANC84FA036.md): Cessna 172N · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Feb 20, 1984 · N734LX · Substantial damage > The plt reported that after taking off, the acft climbed to about 50 ft AGL, then 'didn't have any power to gain any alt.' He began shallow turns, then the acft entered a spin & crashed. Several minor discrepancies were noted, but no reason for a loss of… - [NTSB NYC84FU003](https://openairdocs.org/ntsb/NYC84FU003.md): Panaplane Pappillon · Pepperell, MA · Accident · 1 fatal · Final report · Feb 19, 1984 · UNREG · Minor damage > The airman took off on his first solo flt after one and one half hours of ground instruction and no flt instruction. Theflt proceeded after a normal takeoff to turn left at about 50 ft AGL to avoid a hanger. After a precise 90 degree turn, the acft continued… - [NTSB ATL84FA105](https://openairdocs.org/ntsb/ATL84FA105.md): Grumman G-164B · Dawson, GA · Accident · 1 fatal · Field investigation · Final report · Feb 19, 1984 · N6558K · Destroyed > A failed cylinder head assembly resulted in a total power loss very shortly after takeoff. Witnesses observed the aerial application acft at 30-50 ft AGL over the rwy before it pulled up steeply, rolled and entered a near vertical uncontrolled descent to… - [NTSB SEA84LA056](https://openairdocs.org/ntsb/SEA84LA056.md): Navion A · Albany, OR · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N91123 · Substantial damage > The acft crashed into a tree and a fence during a forced landing following engine stoppage during the initial climb after takeoff. Investigation revealed that the acft had only one cup of fuel mixed with water and rust in the tank beingused. The right tip… - [NTSB MIA84LA086](https://openairdocs.org/ntsb/MIA84LA086.md): Piper PA-32R-301 · Ft. Myers, FL · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N8170D · Destroyed > The eng quit during takeoff & the gear collasped during the subsequent forced landing. Investigation revealed that the set screw on bendix D-2000 series magneto had backed out of the cam & caused the cam to stop activating the breaker points. - [NTSB DEN84LA093](https://openairdocs.org/ntsb/DEN84LA093.md): Bell 206L-3 · Lake City, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1984 · N3893U · Substantial damage > The helicopter took off in marginal VMC conditions at close to conditions requiring maximum performance for takeoff. The plt attempted to hover at 90 percent RPM waiting he said 'for a breeze'. The hover stirred up snow causing a whiteout and loss of visual… - [NTSB MIA84LA083](https://openairdocs.org/ntsb/MIA84LA083.md): Piper PA-28R-201T · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Feb 17, 1984 · N1642H · Substantial damage > The plt reported the eng lost partial power shortly after becoming airborne. He attempted to return to the field & land on rwy 24, but he missed the rwy & landed hard north of the rwy. Disassembly of the eng fuel pump revealed that the o-ring sealing the… - [NTSB LAX84LA181](https://openairdocs.org/ntsb/LAX84LA181.md): Bellanca 14-13-2 · Rialto, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1984 · N74490 · Substantial damage > During the initial climb after takeoff, the eng lost power. The plt then made a wheels-up landing on rough terrain & the acft was damaged. An exam revealed that the left fuel tank was empty & the right tank was full. The plt reported that he may have taken… - [NTSB ATL84IA104](https://openairdocs.org/ntsb/ATL84IA104.md): Mcdonnell Douglas DC-9-31 · Forest Park, GA · Incident · No injuries · Incident investigation · Final report · Feb 16, 1984 · N8924E · Minor damage > Captain heard a muffled explosion accompanied by a moderate left yaw and 'a deterioration of readings on #1 engine' shortly after takeoff. Acft returned for an uneventful landing. Examination revealed that the engine failure initiated in 'the T3 disk/blades… - [NTSB SEA84FA055](https://openairdocs.org/ntsb/SEA84FA055.md): Piper J3C-65S · Haines, AK · Accident · 2 fatal · Field investigation · Final report · Feb 15, 1984 · N88327 · Destroyed > According to a witness the acft made an intersection takeoff and immediately started an almost vertical climb. At about 300 ft AGL the acft winged over to the left and dove into the ground 100 ft from the rwy center and near the upwind end. The horizontal… - [NTSB MKC84LA076](https://openairdocs.org/ntsb/MKC84LA076.md): Cessna 172 · Chariton, IA · Accident · No injuries · Limited investigation · Final report · Feb 15, 1984 · N2502Y · Substantial damage > The acft lost power during takeoff and was forced to land in a muddy field. The CFI said he examined the fuel in a sightglass after refueling the acft and did not notice any water in the fuel. Later examination of the acft by FAA showed water in the fuel… - [NTSB CHI84FA110](https://openairdocs.org/ntsb/CHI84FA110.md): Cessna 177RG · Salem, OH · Accident · 2 fatal · Field investigation · Final report · Feb 15, 1984 · N52697 · Destroyed > The plt got a weather briefing and was advised of areas of fog. While taking off toward the west, he encountered fog. The acft entered a right turn about 1000 ft from the end of the rwy & subsequently crashed about 1 mi northwest of the arpt. Initial impact… - [NTSB LAX84FUG01](https://openairdocs.org/ntsb/LAX84FUG01.md): Bellanca 8KCAB · Riverside, CA · Accident · Minor injuries · Final report · Feb 9, 1984 · N5037G · Substantial damage > The plt tried to takeoff from a grassy area adjacent to the paved rwy. The takeoff was hindered by high grass. Just after takeoff the acft collided with a fence and cartwheeled. - [NTSB ATL84FA093](https://openairdocs.org/ntsb/ATL84FA093.md): Piper PA-32RT-300T · Bluefield, WV · Accident · 4 fatal · Field investigation · Final report · Feb 9, 1984 · N22457 · Destroyed > The non-instrument rated plt began his takeoff during the hours of darkness, but in VMC wx. He stated that during the takeoff roll at about 65 to 75 KTS just prior to rotation, the landing light extinguished. Plt stated that 2 to 3 seconds later, he rotated &… - [NTSB FTW84LA236](https://openairdocs.org/ntsb/FTW84LA236.md): Beech D17S · Stratford, TX · Accident · No injuries · Limited investigation · Final report · Feb 7, 1984 · N1038M · Substantial damage > The pilot stated after the accident that the engine failure occurred as the acft climbed through 6500 feet. According to the plt the no. 1 cylinder separated from the radial eng. The acft nosed over during the landing on unimproved terrain. - [NTSB FTW84FA126](https://openairdocs.org/ntsb/FTW84FA126.md): Piper PA-30B · Hugo, OK · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1984 · N1VE · Destroyed > According to witnesses, the acft was having some kind of problem after takeoff. It entered a nose high attitude, went to the right & crashed. An exam revealed that it had impacted in a nose down attitude. The landing gear was found in a down & locked… - [NTSB MKC84FA069](https://openairdocs.org/ntsb/MKC84FA069.md): Bellanca 17-30 · Kansas City, KS · Accident · Minor injuries · Field investigation · Final report · Feb 3, 1984 · N7314V · Destroyed > The acft caught fire shortly after takeoff, the plt declared an emergency and the acft was cleared to 'take any runway or any taxiway.' The plt landed in an open field on the airport. The acft was destroyed by fire. Investigation revealed that the main source… - [NTSB FTW84LA128](https://openairdocs.org/ntsb/FTW84LA128.md): Ryan PT-22C · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Feb 2, 1984 · N49086 · Substantial damage > Investigation revealed a touch-and-go landing was completed when the acft became airbourne prematurely and drifted slowly left in a light crosswind. After flying about 2000 ft the main gear struck the top of a sand dune and the acft nosed over. - [NTSB ANC84LA034](https://openairdocs.org/ntsb/ANC84LA034.md): Helio H-250 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1984 · N5966X · Substantial damage > According to witnesses, the ski equipped acft took off toward the north. They reported that after taking off, the acft made a tight left turn, then spiraled to the ground. They estimated that the maximum alt was aprx 150 ft. also, they reported that the eng… - [NTSB FTW84LA123](https://openairdocs.org/ntsb/FTW84LA123.md): Bellanca 7KCAB · Huntsville, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 30, 1984 · N4186Y · Substantial damage > The plt had flown the acft with students earlier in the day, & it was his habit to fly the acft around the pattern once at the end of the day prior to securing it in the hangar. Shortly after lift-off the acft crashed on the rwy. Evidence found in the rear… - [NTSB NYC84LA077](https://openairdocs.org/ntsb/NYC84LA077.md): Cessna 150 · Akron, NY · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N63678 · Substantial damage > The acft lost power during takeoff and landed off arpt in the snow collapsing the nose gear. Weather conditions were conductive to carburetor icing and the abnormally long taxi and ground time added to the potential hazard. - [NTSB DEN84LA075](https://openairdocs.org/ntsb/DEN84LA075.md): Hughes 369HS · Buffalo, WY · Accident · No injuries · Limited investigation · Final report · Jan 27, 1984 · N4507C · Substantial damage > The helicopter lost power a few minutes after takeoff and made a forced landing. The acft had been refueled from a fuel truck shortly before takeoff. Samples of fuel from the acft and the fuel truck were examined and found to contain water. - [NTSB LAX84LA156](https://openairdocs.org/ntsb/LAX84LA156.md): Beech A-36 · Victorville, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1984 · N1875W · Substantial damage > The acft landed gear up during a forced landing after the engine quit on takeoff. The plt thinks he left the fuel selector in an improper position after showing a customer the alternate location of the tip tank indicator switch. - [NTSB NYC84FA073](https://openairdocs.org/ntsb/NYC84FA073.md): Cessna 310G · Pequannock, NJ · Accident · 4 fatal · Field investigation · Final report · Jan 22, 1984 · N8969Z · Destroyed > An FBO mechanic reported that the plt had requested a jumpstart. The wx was cold (20 deg) & the initial attempted eng start was unsuccessful. After being preheated, both engs were started. Nothing abnormal was noted during taxi, run-up & the takeoff roll.… - [NTSB LAX84LA140](https://openairdocs.org/ntsb/LAX84LA140.md): Jodell D-9 · Livermore, CA · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N3411G · Substantial damage > The plt stated that after departing on rwy 07 for touch and go landings, the eng 'sagged 400-450 RPM.' With insufficientpower for continued flight, he landed in a plowed field. The plt reported carburetor ice. - [NTSB ANC84IA031](https://openairdocs.org/ntsb/ANC84IA031.md): Cessna 207 · Kotzebue, AK · Incident · No injuries · Incident investigation · Final report · Jan 14, 1984 · N75738 · Minor damage > The plt stated that shortly after takeoff the eng started to run rough & then failed completely. Investigation revealed that the crankshaft had failed in fatique. Laboratory test showed a core hardness below the minimum specified. - [NTSB DCA84AA014](https://openairdocs.org/ntsb/DCA84AA014.md): Fokker F27-100 · Jamaica, NY · Accident · Serious injuries · Final report · Jan 13, 1984 · N148PM · Substantial damage > During the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling… - [NTSB ATL84FA080](https://openairdocs.org/ntsb/ATL84FA080.md): Piper PA-32RT-300 · Basye, VA · Accident · Serious injuries · Field investigation · Final report · Jan 12, 1984 · N36791 · Destroyed > After the acft landed, slush was observed to have accumulated under the wings & lower aft fuselage & was freezing. The acft was parked with the tail facing the sun, but none of the arpt personnel noticed whether the sun had melted the ice. The plt indicated… - [NTSB MKC84MA060](https://openairdocs.org/ntsb/MKC84MA060.md): Douglas DC-3C · St. Louis, MO · Accident · 1 fatal · Major investigation · Final report · Jan 10, 1984 · CGSCA · Substantial damage > After landing, the plt-in-command (PIC) placed a refueling order to fill the acft's two 210 gal main tanks for a return flt to toronto, ontario, Canada. After the cargo was unloaded & the acft was refueled, the aircrew aborted the 1st 2 attempts to takeoff… - [NTSB CHI84LA079](https://openairdocs.org/ntsb/CHI84LA079.md): Cessna 150G · Plato Center, IL · Accident · No injuries · Limited investigation · Final report · Jan 8, 1984 · N2396U · Substantial damage > The acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage. - [NTSB MKC84FA058](https://openairdocs.org/ntsb/MKC84FA058.md): Cessna 152 · St. Charles, MO · Accident · 1 fatal · Field investigation · Final report · Jan 7, 1984 · N5396P · Destroyed > The acft was progressing from a touch-and-go landing when it collided with transmission wires, 926 ft from the rwy at about 27 ft AGL. The weather was conducive to carburetor icing and the carburetor heat control was found partially open. Several gallons of… - [NTSB MIA84FA056](https://openairdocs.org/ntsb/MIA84FA056.md): Cessna T207A · Zolfo Springs, FL · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1984 · N73180 · Destroyed > The acft collided with trees and the ground during takeoff in IMC weather. The visibility was zero due to ground fog. There were no known witnesses to the accident but there was evidence of a collision with a 60 ft high tree at the end of the 3000 ft rwy. It… - [NTSB SEA84FA032](https://openairdocs.org/ntsb/SEA84FA032.md): Stinson 108-1 · Vashon, WA · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1984 · N97016 · Destroyed > Just after taking off in IMC at night, the acft crashed near the departure end of rwy 36. According to a witness, the acft climbed after takeoff to about 200 ft above the trees, then entered a descent & disappeared behind a tree line. After crashing, the acft… - [NTSB DEN84LA062](https://openairdocs.org/ntsb/DEN84LA062.md): Piper Aerostar 601P · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 1984 · N234AD · Substantial damage > The acft crashed shortly after takeoff in IMC weather. Investigation revealed that following a distraction from a cabin door being left ajar, coupled with solid IFR flight conditions, resulted in the acft entering a stall profile. The plt executed a forced… - [NTSB MKC84LA056](https://openairdocs.org/ntsb/MKC84LA056.md): Cessna 150 · Kirksville, MO · Accident · No injuries · Limited investigation · Final report · Jan 2, 1984 · N45638 · Substantial damage > The acft lost power and emitted black smoke during takeoff. The acft was forced to land in a field off the arpt. The weather was conducive to carburetor icing. The plt said that he had not used carburetor heat anytime during the sequenceof events. - [NTSB LAX84LA127](https://openairdocs.org/ntsb/LAX84LA127.md): Cessna 172E · Selma, CA · Accident · No injuries · Limited investigation · Final report · Jan 2, 1984 · N5314T · Substantial damage > The plt stated he was practicing landings when after takeoff following a full stop landing, the 'motor stopped then started again momentarily.' He landed in a vineyard. Responding officers from the sherriff's department observed no fuelin the aircraft tanks. - [NTSB CHI84LA071](https://openairdocs.org/ntsb/CHI84LA071.md): Cessna 172 · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N6600D · Substantial damage > The plt reported that he began a touch-and-go landing after a light twin acft took off. He stated that he did not have a clear recall of the complete procedure that he followed. However, after the acft reached an altitude of about 30 to 40 ft AGL, the stall… - [NTSB NYC84LA063](https://openairdocs.org/ntsb/NYC84LA063.md): Navion G · Spring Valley, NY · Accident · No injuries · Limited investigation · Final report · Dec 30, 1983 · N2459T · Substantial damage > The eng lost power during takeoff & the acft crashed beyond the perimeter of the arpt. During an exam of the acft, only a few drops of water & a slight amount of sediment were found in the fuel. No preimpact/mechanical problem was found. - [NTSB NYC84FHM04](https://openairdocs.org/ntsb/NYC84FHM04.md): Beech C23 · Farmingdale, NJ · Accident · Serious injuries · Final report · Dec 30, 1983 · N37123 · Destroyed > The plt reported that 'at 450 MSL fuel pressure went to zero. The plt verified the boost pump was on, then the eng quit. He lowered the nose, switched fuel tanks. He could not make runway and saw clearing to the left of the runway. Witnesses reported hearing… - [NTSB LAX84LA123](https://openairdocs.org/ntsb/LAX84LA123.md): Cessna 180K · Melville Lake, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1983 · N2991K · Substantial damage > The acft landed hard during an aborted takeoff from a dry lake bed after the landing gear had snagged a tent. In preparing to leave the plt noticed a small tent on the lake bed. He believed he could overfly it on takeoff but the landing gear did not clear the… - [NTSB CHI84LA069](https://openairdocs.org/ntsb/CHI84LA069.md): Cessna U206F · Eveleth, MN · Accident · No injuries · Limited investigation · Final report · Dec 29, 1983 · N9611G · Substantial damage > The plt reported that after taking off, the cabin began to fill with smoke. He returned to the arpt for a precautionary landing; however, during touchdown, the left wing collided with a snowbank beside the rwy. An exam of the acft revealed that with the eng… - [NTSB NYC84LA060](https://openairdocs.org/ntsb/NYC84LA060.md): Mooney M20-E · Lakeville, NY · Accident · No injuries · Limited investigation · Final report · Dec 25, 1983 · N9385V · Substantial damage > The acft lost power during takeoff and landed gear up on the takeoff rwy, continuing off the end of the rwy. Into a frozen plowed field. Prior to flt, the acft was preheated, both sumps were drained and an engine run-up performedfor 20-30 min while defrosting… - [NTSB ANC84FAG01](https://openairdocs.org/ntsb/ANC84FAG01.md): Cessna C-185 · Naknek, AK · Accident · Minor injuries · Final report · Dec 23, 1983 · N1296F · Substantial damage > The acft crashed during takeoff. The plt said that during takeoff at an alt of about 10 ft AGL it felt as though the fltcontrols were not responding. The acft stalled and hit the runway. The plt suspected the controls had been tampered with, but when the acft… - [NTSB LAX84LA112](https://openairdocs.org/ntsb/LAX84LA112.md): Beech H35 · Modesto, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 22, 1983 · N5441D · Destroyed > The plt taxied & initiated a takeoff without obtaining a clearance. The tower controller observed the acft take off, immediately turn left, then collide with a 10 ft dirt bank, located between the parallel rwys. After hitting the dirt bank, the acft skidded… - [NTSB FTW84FA100](https://openairdocs.org/ntsb/FTW84FA100.md): Mooney M20F · Ada, OK · Accident · 2 fatal · Field investigation · Final report · Dec 22, 1983 · N7165V · Minor damage > The eng lost power shortly after takeoff & the acft stalled while in a slight left turn. Examination revealed that the left wing fuel sump drain contained frozen water in the drain ports. The fuel injector screen, after thawing out, contained frozen water… - [NTSB MIA84FA048](https://openairdocs.org/ntsb/MIA84FA048.md): Piper PA-32-300 · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Dec 21, 1983 · N4095R · Destroyed > Shortly after takeoff from rwy 29L the eng began to lose power. A turn back to the arpt was made when the eng quit & the acft struck trees & bushes about 350 ft short of rwy 11L. Teardown of the eng & fuel injector system revealed that the injector for the #5… - [NTSB LAX84FA107](https://openairdocs.org/ntsb/LAX84FA107.md): Piper PA-28R-201T · Tehachapi, CA · Accident · 2 fatal · Field investigation · Final report · Dec 21, 1983 · N47947 · Destroyed > The acft collided with the ground after stalling during a right climbing turn into clouds. Witnesses reported that the initial climb attitude was 'very steep'. No one observed the crash but the engine RPM 'revved up' to a very high RPM 4-5SECONDS prior to the… - [NTSB ANC84FA027](https://openairdocs.org/ntsb/ANC84FA027.md): Cessna C-185-D · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Dec 19, 1983 · N5886T · Substantial damage > The acft crashed shortly after takeoff following a power loss. The plt stated that smoke entered the cockpit from the heat vents. He thought the smoke was from residual oil spilled on the engine during an oil change and he pulled the engine cut off mistaking… - [NTSB NYC84LA056](https://openairdocs.org/ntsb/NYC84LA056.md): Cessna 150M · Belfast, ME · Accident · No injuries · Limited investigation · Final report · Dec 18, 1983 · N8795U · Substantial damage > The acft lost power during takeoff and landed in the trees. The student plt was on his second solo flt. The loss of power occurred at about 700 ft. an attempt to land on an old closed rwy failed and the plt tried to go around but the engine quit completely… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=198 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=197 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.