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 LAX83LA026Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-226TC · San Francisco, CAFlight 238, was cleared for takeoff from runway 28L at San Francisco intl airport. While accelerating through V2 with the gear in upward transit at approximately 50 feet AGL, the red left engine fire warning light illuminated. The flight crew elected to abort…Nov 6, 1982 · N65SA · Substantial damageNTSB NYC83LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, PAAircraft seemed to lose power after takeoff and pilot stall-mushed into trees. Aircraft then slid to ground and rolled inverted.Nov 5, 1982 · N203CB · Substantial damageNTSB MKC83LA013Accident · No injuriesLimited investigationFinal reportCessna 182D · Bucklin, KSDuring takeoff, the engine lost power from fuel exhaustion and the pilot made a forced landing in a plowed field. While landing, the wheels dug into the soil and the aircraft nosed over. The pilot stated that he regularily flew another aircraft with a larger…Nov 5, 1982 · N7432N · Substantial damageNTSB CHI83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Schaumburg, ILThe newly purchased aircraft had just been delivered and the pilot elected to fly it a short period to check its operation. He performed one takeoff and landing, then started another takeoff. He reported that during the second takeoff, the engine lost power…Nov 5, 1982 · N56311 · Substantial damageNTSB ANC83LA011Accident · No injuriesLimited investigationFinal reportBeech 50 · Quinhagak, AKLeft engine lost power after takeoff. Pilot feathered left engine and returned to runway on one engine. Since he was overshooting he elected to land on grass wheels up to avoid overrun and collision with ditch. The following discrepancies were found: exhaust…Nov 3, 1982 · N3582B · Substantial damageNTSB CHI83LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marshall, MNDuring a preflight weather briefing, the pilot was warned that VFR flight was not recommended. Also, a fixed base operator warned him of the weather (there were patches of ground fog). After takeoff, fog was encountered at about 200 to 500 ft AGL. During a…Nov 1, 1982 · N6246J · DestroyedNTSB SEA83LA015Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Midvale, IDShortly after lift-off, the engine lost power. The pilot elected to make a forced landing in a plowed field near the end of the runway. The right main gear failed to clear the barbed-wire perimeter fence. Subsequently, the aircraft touched down in a yaw and…Oct 31, 1982 · N3177N · Substantial damageNTSB FTW83FRG02Accident · Serious injuriesFinal reportLuscombe 8A · San Antonio, TXThe pilot tookoff in gusty winds and accelerated to about 85 KTS. The aircraft then climbed steeply, stalled and crashed.Oct 31, 1982 · N71557 · DestroyedNTSB FTW83FPG01Accident · Serious injuriesFinal reportCessna 177 · North Little Ro, ARShortly after takeoff, the engine lost power. One witness stated that the engine did not completely quit. Another witness reported that it quit, but restarted and then operated with partial power. Reportedly, the aircraft remained in a nose high attitude,…Oct 31, 1982 · N29457 · DestroyedNTSB FTW83FA027Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Baton Rouge, LAThe aircraft crashed and burned shortly after taking off in darkness on an IFR flight plan. The weather was reported as indefinite ceiling, zero obscuration, visibility 1/4 mi with fog, wind 120 deg at 5 KTS. A number of witnesses heard the aircraft, both…Oct 31, 1982 · N41045 · DestroyedNTSB FTW83LA029Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Pine Bluff, ARPilot just loaded seeds and tookoff when he noticed smoke and the engine lost power. During a forced landing the aircraft nosed over. Cause of power loss undetermined.Oct 30, 1982 · N8418K · DestroyedNTSB CHI83LA029Accident · No injuriesLimited investigationFinal reportFlagg 13 · Lansing, ILThe pilot stated he took off to the west and just after becoming airborne the engine lost power. The aircraft landed in a bean field. Examination of the fuel system revealed that the inlet fuel line to the fuel pump had rotted and large pieces of the interior…Oct 30, 1982 · N13625 · Substantial damageNTSB DCA83IA003Incident · No injuriesIncident investigationFinal reportBeech E90 · Wilmington, DEThe aircraft crashed shortly after taking off from the greater Wilmington airport, Wilmington, DE. The pilot stated that the left engine lost power at about 100 ft AGL, just as the landing gear was being retracted. He said the autofeather was armed, but the…Oct 28, 1982 · N213DS · Minor damageNTSB CHI83LA027Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Georgetown, INThe pilot started to takeoff from area that was difficult to exit. He relanded once. During the 2nd attempt to fly out, the helicopter collided with trees and crashed. The pilot was not rated in helicopters, but he said he had soloed.Oct 28, 1982 · N929B · Substantial damageNTSB ATL83LA019Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Adel, GAFollowing maintenance performed on the aircraft the pilot conducted a check flight. After takeoff the pilot discovered fuel splashing on the windshield and proceeded to abort the takeoff. Upon landing the pilot lost control of the aircraft. The aircraft…Oct 27, 1982 · N7231 · DestroyedNTSB MKC83FCA01Accident · 4 fatalFinal reportPiper PA-28-161 · St. Charles, MOThe acft crashed on the north boundary of the arpt within minutes after having been seen departing rwy 27. Dense ground fog prevailed at the crash site. Approximately 1-1/2 hours after the accident examination disclosd very heavy frost on all acft parked…Oct 25, 1982 · N8184Y · Substantial damageNTSB LAX83FVM02Accident · Minor injuriesFinal reportBeech F17D · Hollister, CAThe eng quit immediately after takeoff & the acft landed in an orchard. The fuel selector was found on the empty fuselage tank. The left wing auxillary tank was empty & the right wing auxillary tank was approximately full.Oct 20, 1982 · N19473 · Substantial damageNTSB MIA83LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Augustine, FLUpon landing, the pilot noticed he was too high and executed a go-around. On the next landing the aircraft veered left on the landing roll so the pilot again attempted a go-around. On liftoff the nosewheel hit the airport perimeter fence and the aircraft came…Oct 19, 1982 · N12927 · Substantial damageNTSB CHI83LA020Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Vandalia, OHThe pilot estimated that he had 40 gal of fuel on board when he departed parkersburg, WV for new carlisle, OH. During a night arrival at new carlisle, he was unable to activate the runway lights by keying his microphone. Therefore, he diverted to Vandalia,…Oct 18, 1982 · N4740S · Substantial damageNTSB MIA83LA013Accident · No injuriesLimited investigationFinal reportCessna 177RG · Brooksville, FLDuring takeoff, the engine lost power at about 700 to 800 ft AGL while the plane was climbing. The pilot was unable to restart the engine. Subsequently, the aircraft crashed in an orange grove and was destroyed. An examination and partial teardown of the…Oct 17, 1982 · N1892Q · Substantial damageNTSB LAX83FA012Accident · 14 fatalField investigationFinal reportBeech C-45H · Taft, CAThe aircraft was on a local flight involving a parachute jumping activity. In addition to the pilot, there were 12 parachutists and an observer on board. The pilot initiated his takeoff on runway 18. A witness stated that shortly after takeoff, the engine…Oct 17, 1982 · N403SE · DestroyedNTSB DEN83FTA01Accident · Serious injuriesFinal reportAero Commander 100 · Red Lodge, MTAfter takeoff, the aircraft lost airspeed and started an uninitiated descent. The pilot was unable to power out of it and the aircraft contacted two buildings and a fence before stopping in an open field. The winds were from 200 degrees at 30 KTS, gusting to…Oct 17, 1982 · N5539M · DestroyedNTSB ATL83LA011Accident · No injuriesLimited investigationFinal reportTomcat MK68 · Cope, SCBefore starting his takeoff from a trailer, the pilot failed to insure that his helper had released the right rear tiedown chain. During lift-off, the helicopter raised the trailer about 2 to 3 ft before the chain. Broke. Simultaneously, the helicopter was…Oct 15, 1982 · N9080T · DestroyedNTSB SEA83LA007Accident · No injuriesLimited investigationFinal reportCessna 340 · Bellevue, WAAccording to the pilot, the right engine lost power at or shortly after rotation for takeoff. Reportedly, there was insufficient room to stop on the runway with a house near the end. He opted to continue the takeoff and fly to a safe landing area. He stated…Oct 13, 1982 · N6GD · Substantial damageNTSB ANC83LAA02Accident · 2 fatalFinal reportCessna 150 · Nulato, AKThe acft struck trees 600 ft from the departure end of the rwy at a high rate of speed after taking off from the unlighted rwy at night. The plt's blood alcohol level was 31 mg% & the urine alcohol level 90 mg%.Oct 11, 1982 · N714SQ · DestroyedNTSB MKC83LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Cuba, MOPilot says aircraft lost power at 200 feet AGL. Forced landing resulted in collision with a tree stump. No reason for engine malfunction found.Oct 10, 1982 · N5829B · Substantial damageNTSB LAX83LVM01Accident · No injuriesFinal reportBell 47G2 · 5nm East Of Sal, CAAfter takeoff, during an aerial application flight, the pilot felt a sudden jolt and the engine RPM revved then decayed very rapidly. The pilot made a hard landing and the main rotor severed the tail rotor. The aircraft was within the weight and balance…Oct 10, 1982 · N5159B · Substantial damageNTSB CHI83LA008Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Sparta, MIWitnesses observed a normal climb out, but as the acft cleared trees the plt began jettisoning the load. The plt stated that about 1/2 mi from the departure end of rwy 6 the acft seemed to mush & then descend into the trees. The wind at grand rapids, 20 mi…Oct 5, 1982 · N2892J · Substantial damageNTSB ATL83LA004Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Rowland, NCThe aircraft was being ferried to a nearby airport for winter storage. Immediately after takeoff, the engine began running rough and RPM was lost. The pilot turned and landed in a plowed field where the aircraft nosed over during the landing roll. The pilot…Oct 5, 1982 · N48498 · Substantial damageNTSB FTW83LA008Accident · No injuriesLimited investigationFinal reportHughes TH-55A · Balmorhea, TXA Hughes helicopter was damaged when it lost power during takeoff and was crashed into a tree to prevent it from rolling down a hill. The weather was VMC and no flight plan was filed. The pilot said the manifold pressure decayed FROM22 inches to 18 inches and…Oct 4, 1982 · N8045F · Substantial damageNTSB CHI83LA005Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INAfter takeoff from a touch & go the eng lost power. The #1 cyl upper plug lead nut had backed off & the lead was found resting in the plug. The #2 & #4 cyl upper plug lead nuts had backed off & both leads were not in the spark plugs but were resting on the…Oct 4, 1982 · N8055W · Substantial damageNTSB ATL83LLQ01Accident · Serious injuriesFinal reportBeech 35 · Hazard, KYThe pilot reported that the airport was located in a valley, and due to the terrain, it was necessary to takeoff on runway 17 with a quartering left tail wind. He reported that a mountain was located close to the runway centerline (to the right) as well as…Oct 4, 1982 · N188CB · DestroyedNTSB ANC83LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Near King Salmo, AKAccording to the pilot, he began taking off with a right quartering headwind. As the plane lifted off, a gust of wind was encountered and the aircraft moved sideward and down. Subsequently, the right main gear contacted the ground and separated. The nose then…Oct 4, 1982 · N54247 · DestroyedNTSB MIA83LA002Accident · No injuriesLimited investigationFinal reportCessna 182 · Cocoa, FLDuring takeoff, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot s-turned and landed on a clear area beside the runway to keep from going into a river. Subsequently, the nose gear collapsed and the aircraft flipped over.…Oct 3, 1982 · N2101R · Substantial damageNTSB LAX83LA007Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Santa Ana, CAThe pilot reported that the engine lost power after he had raised the gear during takeoff. He lowered the nose to avoid a stall and landed gear-up at and off the end of the runway. Reportedly, tower personnel observed black smoke trailing from the bottom of…Oct 3, 1982 · N66909 · Substantial damageNTSB LAX83FUG01Accident · Minor injuriesFinal reportCougar A · El Mirage, CAAfter takeoff, the engine lost power. The pilot made a forced landing on the desert. The aircraft encountered sand and nosed over. The homebuilt aircraft had a common bracket for throttle and mixture. Advancing the throttle would leaned the mixture.Oct 3, 1982 · N87DS · DestroyedNTSB FTW83IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Kenner, LAThe plt departed with a tail wind which exceeded the allowable component. Rotation was observed to have occurred at the departure threshold. The acft was estimated to be at 25 to 30 ft AGL when it was 1330 ft beyond the departure end of therunway. Two persons…Oct 3, 1982 · N817EA · No damageNTSB CHI82DA368Accident · Minor injuriesFinal reportLake LA-4 · Lancaster, OHPilot says aircraft lost power after takeoff. He made a forced landing in a cornfield. No malfunction found.Sep 30, 1982 · N39786 · Substantial damageNTSB NYC82FHA10Accident · Serious injuriesFinal reportNavion G · Doylestown, PAAt approximately 75-100 ft the eng quit. The acft landed with the gear up & slid off the end of the rwy approximately 200-300 ft. the plt acknowledged taking off with the fuel selector on the empty left tip tank.Sep 28, 1982 · N2476T · Substantial damageNTSB ATL82FIG11Accident · Serious injuriesFinal reportCessna 177B · Forest Hill, MDAfter takeoff, the engine lost power and the aircraft crashed in a cornfield. The pilot turned left to avoid a congestedarea and made ground contact with the left wing first. The aircraft was demolished by impact and fire. The pilot says hehad a quarter of a…Sep 28, 1982 · N11562 · DestroyedNTSB LAX82DA360Accident · No injuriesFinal reportBell 47G-5 · Soledad, CAThe pilot experienced a power loss during lift-off. A hard landing was made. No reason for the malfunction was found.Sep 27, 1982 · N8562F · Substantial damageNTSB ATL82FKJ14Accident · Serious injuriesFinal reportGrumman G-164 · Bay Minnette, ALThe pilot reported that during takeoff, he noticed extreme heat in the cockpit and the engine began to surge, then lose power. He landed on the remainder of the runway and stopped after running off the end. However, the engine was on fire and the plane was…Sep 27, 1982 · N463RF · DestroyedNTSB LAX82DA358Accident · No injuriesFinal reportNorth American SNJ-6 · Santa Rosa, CAEngine quit at 500 feet AGL after takeoff. Pilot turned back but overshot field.Sep 26, 1982 · N3579 · Substantial damageNTSB NYC82DA235Accident · No injuriesFinal reportCessna TR-182 · Honesdale, PAThe aircraft experienced a power loss at 300 feet after takeoff and a forced landing was made with the wheels up in a plowed field. An investigation revealed that a seal around the carburetor air mixing box had come loose and an oil seal in the turbocharger…Sep 25, 1982 · N9369R · Substantial damageNTSB FTW82AA391Accident · 1 fatalFinal reportBeech 58P · Midland, TXAn intersection tkof was started nr the middle of rwy 25 with 2096 ft remaining. The plt stated the tkof was normal until he started making an initial pwr reduction to 34 inches and 2400 RPM. At that time, the l eng reportedly continuedto lose pwr and…Sep 24, 1982 · N2027C · DestroyedNTSB FTW82DA387Accident · No injuriesFinal reportMaule M-5-235C · Edna, TXThe pilot took off with the fuel selector in the off position. The engine quit at 500 feet AGL. The pilot landed hard in a plowed field and the aircraft nosed over to an inverted position. The pilot and passenger were not hurt.Sep 23, 1982 · N5631R · Substantial damageNTSB SEA82DA171Accident · No injuriesFinal reportPiper PA-38-112 · Hillsboro, ORThe dual student was executing touch and go landings. During the takeoff, at an altitude of approximately 20 ft AGL, the instructor reduced power simulating an engine failure. The student pilot maintained a nose high attitude and the aircraft landed hard on…Sep 22, 1982 · N6377A · Substantial damageNTSB MKC82FCJ06Accident · Serious injuriesFinal reportStinson 108-2 · Chadron, NEAfter departure, the pilot experienced a loss of power. The pilot made a forced landing in a field approximately one mile from the airport. Examination of the aircraft engine revealed that the mixture control was not attached at the carburetor and that the…Sep 22, 1982 · N225C · Substantial damageNTSB FTW82DA390Accident · No injuriesFinal reportHelio H-295 · Waller, TXA witness observed the aircraft depart from a hard surface runway. The aircraft remained close to the runway surface after lift-off and was observed to make an abrupt pull-up to a nose-high climb angle. The aircraft cleared wires then appeared to fall off to…Sep 22, 1982 · N6453V · Substantial damageNTSB DEN82DTM18Accident · No injuriesFinal reportCessna A185 · Huntington, UTThe aircraft struck trees with the left wing after takeoff. The pilot stated that he experienced a downdraft and that he was unable to recover altitude that was sufficient to clear the trees. The wind was reported to be from 270 degrees at 10 knots, gusting…Sep 22, 1982 · N6093E · Substantial damage