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 NYC84FA057Accident · 1 fatalField investigationFinal reportPiper J3C-65 · North Hampton, NHThe acft stalled at about 100 ft of alt after takeoff during an instructional flt. One witness said the acft turned through 180 degrees before it collided with the ground in a nose low and right bank attitude. Another witness said he thought the acft was…Dec 17, 1983 · N70779 · DestroyedNTSB LAX84FA106Accident · No injuriesField investigationFinal reportHiller UH-12A · Van Nuys, CAThe instructor plt (CFI) stated that the eng quit 2 times after he refueled the helicopter. He then drained a quantity of water from the fuel gascolator & restarted the helicopter. After that he air taxied the helicopter to the flt school where, without…Dec 16, 1983 · N8108H · Substantial damageNTSB LAX84LA104Accident · Serious injuriesLimited investigationFinal reportBell 47H-1 · Paradise, CAAccording to witnesses, the helicopter lifted off near the north end of rwy 17 while on an eastenly heading. After lift-off, it turned right, as if to proceed down the rwy. After rising to about 5 ft AGL, it settled & contacted the rwy, rose again, then…Dec 13, 1983 · N42403 · DestroyedNTSB FTW84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gallup, NMThe plt reported that he was taking off from a dirt road when the eng lost power shortly after lift-off. Subsequently, the left main gear collapsed during a hard/forced landing.Dec 12, 1983 · N3957P · Substantial damageNTSB MIA84FA043Accident · Serious injuriesField investigationFinal reportTemco Raley D-16A · Everglades City, FLPower was lost on both engs shortly after takeoff. The plt attempted to turn towards the shoreline & land in an open field but was unable to do so. The acft collided with the water while in a left bank & cartwheeled. The fuel line between the main fuel tank…Dec 11, 1983 · N704T · DestroyedNTSB CHI84LA057Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Owosso, MIThe acft crashed shortly after takeoff from owasso airport. The plt stated that he noticed the takeoff roll was longer than normal but everything seemed alright until approximately 100 ft AGL when the acft would no longer climb. The acft impacted about 1/2…Dec 10, 1983 · N7234D · Substantial damageNTSB LAX84FA095Accident · 3 fatalField investigationFinal reportAerospatiale AS 355F · Black Mountain, NVThe helicopter tookoff on an air ambulance flt at about 1219 PST. According to tower personnel, the departure appeared normal. Radar service was terminated at 1227 & there was no further radio contact with the helicopter. Later, the helicopter was found where…Dec 7, 1983 · N57901 · DestroyedNTSB MIA84FA040Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Lakeland, FLThe acft was on its first production flt test. Shortly after lift-off it was observed to enter an abrupt right bank, followed by a steep left bank before crashing. Examination of the left wing revealed that its aileron cables were connected to their…Dec 4, 1983 · N4115K · DestroyedNTSB ATL84FA061Accident · Serious injuriesField investigationFinal reportCessna 210A · Columbia, SCThe acft collided with a wall during a downwind forced landing. The engine had quit at 200 ft after takeoff. The plt turned right with the gear up. He landed on a football field and bounced down a track field into a fence and wall. When the engine was…Dec 4, 1983 · N9491X · DestroyedNTSB LAX84FU023Accident · Serious injuriesFinal reportMotorized Gliders Tierra · Bullhead City, AZAccording to the plt, he had no previous flt time in ultralight acft. Before taking off, he taxied the ultralight several times to get the feel of the vehicle. During departure, the plt took off from a taxi strip west of rwy 17. The strip was used by…Dec 3, 1983 · UNREG · Substantial damageNTSB SEA84LA025Accident · No injuriesLimited investigationFinal reportBell 206-BIII · Kooskia, IDThe helicopter landed hard and rolled over to the right. The events started when the pilot heard the end of a seat belt banging against the outside of the acft where it had been caught in the door. The pilot decided to land and secure the belt. During landing…Dec 2, 1983 · N49584 · Substantial damageNTSB LAX84LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fairfield, CAAfter taking off & while climbing thru about 100 to 300 ft, the eng lost power. During a forced landing, the acft impacted a fence & a berm, and went over railroad tracks, then came to rest inverted in a ditch. An exam of the acft revealed corrosion in the…Dec 2, 1983 · N48886 · Substantial damageNTSB LAX84LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAThe plt reported that he forgot to remove the aileron blocks before the flight. When he was taking off, the acft began to roll to the left. He was unable to control the bank attitude with rudder control, so he 'cut' the power. Seconds later the acft crash…Dec 1, 1983 · N8837Q · Substantial damageNTSB ATL84LA060Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, KYEarlier in the day, an annual inspection had been completed. There were no refueling facilities on the arpt, so the plt/mechanic drove to another location & purchased a can of gasoline (6 gals) which he added to the tanks. He then started the eng &…Dec 1, 1983 · N6185G · Substantial damageNTSB DEN84FA039Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Moose, WYThe acft crashed shortly after takeoff in IFR weather. The plt failed to follow established departure procedures and in fact he did not even call in the fact that he had departed or his departure time as instructed by salt lake center. Attempts by salt lake…Nov 28, 1983 · N107CB · DestroyedNTSB LAX84LA078Accident · No injuriesLimited investigationFinal reportHughes 369D · Caliente, CAReportly, the plt had instructed the ground crew to place the external cable\slings in the cargo area of the helicopter. However, they connected the cable to the external hook. The plt was not aware of this & took off. After takeoff, the cable hit the tail…Nov 27, 1983 · N1112B · DestroyedNTSB ANC84LA019Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Anchorage, AKThe eng quit after takeoff. The plt was able to return to the arpt but landed on a Piper super cub. Water was found in the carburetor & main fuel tank.Nov 27, 1983 · N95666 · DestroyedNTSB CHI84FA051Accident · 1 fatalField investigationFinal reportBeech V35B · Cairo, ILThe acft dove into the ground nose first from a 90 degree bank shortly after takeoff. The acft was observed by witnessesto take off slowly 'with about 1/2 power' being used. The climb was slow and at 300-400 ft the acft turned left with thelanding gear still…Nov 26, 1983 · N9002Q · DestroyedNTSB ATL84FA050Accident · Minor injuriesField investigationFinal reportCessna 182Q · Baltimore, MDThe acft crashed shortly after takeoff when the engine lost power during initial climb. This acft had not been flown forabout one month. The pilot was aware of water accumulation in C-182 bladder equipped acft, so he drained the gascolator for an added length…Nov 26, 1983 · N7473S · Substantial damageNTSB FTW84FA074Accident · 4 fatalField investigationFinal reportPiper PA-23 · Comfort, TXWitnesses stated that the acft barely cleared trees at the end of the arpt & that smoke was seen trailing from the righteng. The acft entered a right turn, stalled & impacted a ridge in a steep, near vertically banked dive. Teardowns of both engs & both props…Nov 25, 1983 · N215EC · DestroyedNTSB MIA84LA034Accident · No injuriesLimited investigationFinal reportCessna 402 · Miami, FLThe plt in command related that he had no experience in the Cessna 402 acft. He reported that while on a local test flt with the second plt, who was experienced flying the acft, the right eng malfunctioned. The co-plt climbed the acft to 500 ft AGL and the…Nov 23, 1983 · N24097 · Substantial damageNTSB ATL84FIA01Accident · No injuriesFinal reportCessna 150K · Newburg, MDThe plt reported that during takeoff at aprx 200 ft AGL, the eng began to sputter & run rough. He elected to make a 180 deg turn in an attempt to reach a clear area. However, the acft struck a tree & impacted in a wooded area. Reportedly, the acft had been…Nov 23, 1983 · N6385G · Substantial damageNTSB NYC84LA044Accident · No injuriesLimited investigationFinal reportCessna 177 · Bayport, NYThe acft dragged a wing tip after encountered a gusty crosswind and aborted his takeoff. According to the plt, as the acft became airborne it seemed to be pushed down and he initiated a landing. The takeoff was aborted by reducing power and the acft touched…Nov 19, 1983 · N692MA · Substantial damageNTSB LAX84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Peach Springs, AZReportedly, the wind was variable & gusty when the acft took off from the hualapai arpt, Peach Springs, AZ. The plt reported that after rotating for takeoff, the acft moved laterally to the left, and as he was correcting for the movement, the left main gear…Nov 19, 1983 · N8178W · Substantial damageNTSB SEA84LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Oregon City, ORThe plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The…Nov 18, 1983 · N6054G · Substantial damageNTSB CHI84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Columbus, OHThe plt stated that during the preflt, he visually checked the fuel & estemated that the left tank was aprx 1/4 full & the right tank was about 1/2 full. He made his pretakeoff checks, but stayed on the ground longer than normal to allow the oil to warm up.…Nov 18, 1983 · N8921P · Substantial damageNTSB NYC84LA043Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJEarlier in the evening, the plt had taken off with 3 passengers on board. Shortly after takeoff, he advised the tower that the eng was not developing full power. He remained in the traffic pattern & landed, then taxied to the ramp. Later, the plt made a 2nd…Nov 16, 1983 · N28271 · Substantial damageNTSB SEA84LA021Accident · Minor injuriesLimited investigationFinal reportEnstrom F28F · Hillsboro, ORThe acft did a hard landing during autorotation after the engine ran rough and quit at 250 ft AGL during takeoff. The pilot had leaned the mixture, he said, prior to takeoff and he was not sure if he pushed the mixture to full rich when the engine started to…Nov 15, 1983 · N8622U · Substantial damageNTSB NYC84LA029Accident · No injuriesLimited investigationFinal reportCessna 150 · Eliot, METhe acft nosed over during a forced landing in soft earth after the engine quit during takeoff. This acft had been scheduled for a flt on 11/13 but due to water in the fuel it was not used. The acft fuel was drained and replaced and the acft was test flown.…Nov 14, 1983 · N704UG · DestroyedNTSB FTW84FA058Accident · No injuriesField investigationFinal reportBell 206L-1 · Houston, TXThe acft lost power during the takeoff climb. During the forced autorotation landing the tail was severed by the main rotor. The engine was still running at 70 percent N-1. No discrepancies were noted in the engine during post-accident examination and run-up.…Nov 14, 1983 · N908S · Substantial damageNTSB NYC84LA027Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Fitchburg, MAThe aircraft's engine lost power on takeoff and the pilot elected to make an emergency landing in a residental area. The pilot maneuvered the aircraft between two homes and crashed into a tree. The aircraft rolled to the left and fell tothe ground.…Nov 13, 1983 · N26445 · Substantial damageNTSB MIA84LA029Accident · No injuriesLimited investigationFinal reportGary Wilson Quickie · Boca Raton, FLAccording to the plt, he had only 2 hrs flt time in quickie acft & this was his 1st flt in N114GW. He reported that after taking off, the acft tried to roll left. He used all available aileron to counteract the roll, but it was not effective. When impact was…Nov 13, 1983 · N114GW · DestroyedNTSB FTW84LA051Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Moore, OKThe acft crashed during a forced landing after the engine quit. The acft had a prior forced landing and the fuel pump was suspect. Post accident investigation showed that only one safety pin was installed in the fuel selector shaft allowing excessive free…Nov 11, 1983 · N7337V · Substantial damageNTSB LAX84FU021Accident · Serious injuriesFinal reportTeman MONO-FLY · Congress, AZReportedly, the plt was on his 1st flt in the ultralight vehicle after he had been taxiing it during the previous week. During takeoff from a ranch, the vehicle collided with the ground. According to the deputy sheriff, who responded to the scene, the plt…Nov 10, 1983 · UNREG · Substantial damageNTSB NYC84FA024Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · West Seneca, NYThe acft was being repositioned by the owner from a maintenance facility at buffalo intl arpt to buffalo airpark. Maintenance personnel at both locations who had dealt with the owner indicated he had attempted to cut costs by performing unauthorized repairs…Nov 9, 1983 · N4708P · DestroyedNTSB NYC84FA022Accident · 2 fatalField investigationFinal reportCessna 210L · Rhinebeck, NYThe above reported basic wx data was the 2050 observation at poughkeepsie, NY located about 20 NM south of the accident site. However, a witness who was 1,000 ft north of the accident site stated the wx consisted of a low overcast & that the visibility was…Nov 6, 1983 · N1177Q · DestroyedNTSB DEN84LA022Accident · No injuriesLimited investigationFinal reportBeech V35B · Greeley, COThe plt reported that immediately prior to rotation speed he saw a deer running towards the acft at a 90 deg collision angle. He 'hauled back' on the control wheel & the acft 'mushed off the ground.' The deer impacted the bottom of the fuselage & the wing…Nov 6, 1983 · N6TH · Substantial damageNTSB LAX84LA053Accident · No injuriesLimited investigationFinal reportSchreder HP-18 · New River, AZThe plt had just purchased the home built, single place, glider & was on his 1st tow. He reported that during takeoff, the glider became airborne prior to the tow plane, he felt a slight tug at the elevator control, had climbed too high behind the tow plane,…Nov 5, 1983 · N17DW · Substantial damageNTSB LAX84FA048Accident · No injuriesField investigationFinal reportBeech B35 · Long Beach, CAThe plt reported that as he raised the landing gear during takeoff, the eng simultaneously lost power. He initiated an emergency landing on the remaining portion of the rwy. Acccording to him, the acft stalled while he was holding it in a nose high attitude &…Nov 5, 1983 · N5254C · DestroyedNTSB LAX84FA046Accident · No injuriesField investigationFinal reportPiper PA38-112 · Corona, CAThe acft landing gear collapsed during an off rwy but on arpt forced landing. The pilot had just completed the annual inspection and was testing the acft. At 150 ft AGL during takeoff the engine quit. The plt landed on rough terrain ABOUT1/4 mile west of the…Nov 5, 1983 · N2556D · Substantial damageNTSB ATL84FA038Accident · 5 fatalField investigationFinal reportCessna T210M · Banner Elk, NCBefore takeoff, the plt obtained wx for ashville & hickory, NC & for the tri-city arpt, all of which were 30 to 54 mi from Banner Elk, NC. At that time, he told the briefer that there were clouds at Banner Elk, but he thought he could get out all right. The…Nov 5, 1983 · N761VK · No damageNTSB LAX84FA045Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Riverside, CAShortly after departure the plt radioed in that he had blown a rod 'or something' and was about two miles out on a right base leg. He then informed the tower that he was not going to make the runway after which the left wing contacted a power pole and the…Nov 4, 1983 · N15039 · DestroyedNTSB CHI84LA036Accident · No injuriesLimited investigationFinal reportJordan Acey Deucy · Chesaning, MIThis was the first flight of the homebuilt. Shortly after takeoff the eng quit due to inadequate grounding. The plt returned to the field & made a smooth landing. At the end of the roll out the anchor plate for the landing gear truss failed causing the left…Nov 3, 1983 · N597HJ · Substantial damageNTSB DEN84LA020Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, NDThe student plt encountered fog immediately after takeoff at about 150 AGL. The plt looked back & could still see the rwy lights, he then began a descending rt turn to the rwy to land. During this descending turn, the rt wing hit the ground followed by the…Nov 2, 1983 · N6141K · DestroyedNTSB FTW84FA038Accident · No injuriesField investigationFinal reportDouglas DC-3-3C · Laredo, TXThe original flt was aborted due to a magneto problem. The defect was corrected, but due to the delayed takeoff, the plt elected to fly to mcallen, TX, for further repairs. During the takeoff roll, the aircrew noted sparks/flares on the left side of the…Nov 1, 1983 · N44896 · DestroyedNTSB FTW84FU002Accident · Serious injuriesFinal reportWaspair Tomcat H.M. 81 · Ozark, ARThe plt was a paraplegic. He had previously purchased a Cessna 172 & had it modified for hand control. However, he had discontinued instruction in the plane when he was denied a medical waiver on the grounds that he had to take valium as a muscle relaxant.…Oct 30, 1983 · UNREG · Substantial damageNTSB SEA84FA013Accident · 2 fatalField investigationFinal reportCessna C-152-II · Belfair, WAThe flight originated at aprx 2100 hrs. The pilot said his intention were to remain in the traffic pattern and practice touch and go landings. The aircraft crashed 1 mile south of the airport.Oct 29, 1983 · N94282 · DestroyedNTSB MIA84LA021Accident · No injuriesLimited investigationFinal reportChampion 7HC · Ft. Lauderdale, FLThe plt of Champion 7HC, N8918R, stated that he taxied over a rough field to rwy 13. While crossing the field, something struck the bottom of the fusellage & broke the ailron bellcrank which connected the control stick to the aileron pushrods. Subsequently,…Oct 29, 1983 · N8918R · 2 aircraft · Substantial damageNTSB MIA84LA020Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Ormond Beach, FLThe acft is a twin-engine conversion of the Grumman G-164B. The plt was on a local test flt with the hopper filled with water to simulate flt conditions near the operating gross weight of the acft. After lift-off a partial power loss was experienced on the #2…Oct 27, 1983 · N8459K · DestroyedNTSB DEN84LA018Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Parker, CODuring the takeoff portion of a touch & go, the eng went to idle 15 ft AGL. The plt made a left turn & landed in a fieldcollapsing the landing gear. Investigation of the wreckage revealed that the carburetor was hanging in place by the throttle & mixture…Oct 27, 1983 · N29037 · Substantial damage