NTSB investigations, OR
250 cases where the phase of flight was Takeoff.
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.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
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.
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."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.NTSB SEA97LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldport, ORthe pilot's inadequate preflight planning/preparation to ensure he could execute a safe departure in the meteorological conditions present at the time. Related factors included: the unfavorable/variable/gusty wind conditions; and a power line near the…NTSB SEA97IA071Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Portland, ORimproper installation of four attach bolts on the elevator drive torque tube.NTSB SEA97LA020Accident · Minor injuriesLimited investigationFinal reportKarmy Rotorway Exec · Redmond, ORThe pilot's failure to remove the dolly wheels during the preflight inspection.NTSB SEA96LA162Accident · No injuriesLimited investigationFinal reportConkey/Wapelhorst Lancair 235 · Cottage Grove, ORrelease of the main landing gear locking mechanism for undetermined reason(s).NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB SEA95LA077Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Timber, ORThe pilot's inadequate aircraft preflight during which he failed to notice the main rotor shipping block had not been removed, and the resultant restricted movement of the flight control system.NTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.NTSB SEA95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Salem, ORFuel starvation due to inadequate supervision of the dual student by the pilot-in-command when the dual student improperly adjusted the fuel selector position.NTSB SEA94LA223Accident · Serious injuriesLimited investigationFinal reportCessna 320B · Hood River, ORThe pilot's failure to insure that the fuel selector was in the proper position which resulted in fuel starvation.NTSB SEA94LA181Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics PBY-5A · Lincoln City, ORThe pilot's failure to maintain clearance from a boat dock during the aborted takeoff. Factors include the pilot's poor inflight decision to land on a narrow lake under unfavorable wind conditions, and strong crosswinds during the attempted takeoff.NTSB SEA94LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Hubbard, ORDelayed in flight planning/decision.NTSB SEA93LA146Accident · 1 fatalLimited investigationFinal reportDoellefeld RV6A · Independence, ORAn in flight loss of contol for unknown reasons.NTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.NTSB SEA92LA067Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Miltonfreewater, ORThe inadequate prelight preparation by the pilot in his failure to ensure the filler hose was removed before attempting to takeoff.NTSB SEA91LA166Accident · No injuriesLimited investigationFinal reportWaco UBF · Lincoln City, ORImproper planning/decision by the pilot, and his delay in aborting the takeoff. The tailwind & proximity of trees/brush were related factors.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB SEA91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Princeton, ORThe pilot's failure to maintain clearance from obstacles at the side of the runway.NTSB SEA90LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yamhill, ORPilot did not maintain an adequate airspeed after takeoff which resulted in a loss of control and aborted takeoff. The pilot did not maintain directional control of the airplane and did not properly correct the situation before colliding with trees and a…NTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.NTSB SEA90LA041Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Sun River, ORThe pilot's failure to properly compensate for strong crosswinds during takeoff ground roll.NTSB SEA89LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Mulino, ORImproper installation and routing of the fuel pressure line and/or electrical wiring, due to improper maintenance, which resulted in mechanical binding of the elevator control column. The fence was considered to be a related factor.NTSB SEA88LA191Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Troutdale, ORThe plt rprtd that soon after takeoff, he realized there was insufficient power. Subsequently, the acft mushed into trees & a raspberry field & was damaged. An exam of the eng revealed a piece of the carburetor heat muff had broken off & was ingested into the…NTSB SEA88LA097Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Chemult, ORThe pilot was attempting to takeoff with a density altitude of 6,300 feet. The aircraft was operated near its maximum gross weight limitation. 150 feet from the initial takeoff the helicopter rotor stirred up dust and debris from a road, causing the pilot to…NTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.NTSB SEA86LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Burton Lake, ORThe acft failed to become airborne on the soft, short, rough cinder covered airstrip probably due to a combination of density altitude and poor plt technique. The acft struck a berm at the end of the runway where it nosed over. The plt was also departing…NTSB SEA84LA232Accident · No injuriesLimited investigationFinal reportGlasair None · Burns, ORDuring the takeoff ground run the aircraft drifted to right side of the rwy. Plt attempted to correct the drift using left rudder and he stated that he over corrected for the drift and the acft began to veer to the left. The acft veered left and departed the…NTSB SEA84LA214Accident · No injuriesLimited investigationFinal reportCessna 180A · Scappoose, ORThe pilot stated that during the takeoff ground run, just prior to rotation, he 'took a sharp gust of wind from the left and ground looped the aircraft.'NTSB SEA84LA160Accident · Minor injuriesLimited investigationFinal reportRearwin Rearwin 8125 · The Dalles, ORThe plt inadvertantly taxied the acft to the wrong rwy for takeoff. The plt did say he saw acft departing from another rwy. Takeoff was attempted with a 19 kt x-wind. The acft ran off the side of the rwy before becoming airborne. The arpt manager has since…NTSB SEA84LA122Accident · No injuriesLimited investigationFinal reportCessna 188B · Perrydale, ORThe plt stated that while taking off from the 1,100 ft rough strip, the acft struck a bump causing it to become airborneprematurely. The acft then settled back onto tall wheat past the end of the strip & flipped inverted.NTSB SEA84LA091Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Buxton, ORThe helicopter entered an uncontrolled right roll while lifting off from a trailer & struck the ground with the m/r. the plt reported the trailer was not level.NTSB SEA84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Burns, OROn departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed.NTSB SEA84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Klamath Falls, ORThe plt attempted a takeoff on a slushy soft rwy. The takeoff was aborted at the rwy midpoint due to lack of acceleration. During the abort the acft collided with a fence and nosed over. The plt thought the rwy conditions and carburetor ice.NTSB SEA83LA156Accident · Minor injuriesLimited investigationFinal reportFinamore KR-2 · Hillsboro, ORThe acft lost power at about 100 ft AGL during takeoff. The pilot made a forced landing straight ahead into a grain field. The high vegetation caused enough drag on the landing gear to nose the acft over. Examination of the engine revealed that the high…NTSB SEA83LA082Accident · No injuriesLimited investigationFinal reportStinson L-5 · Haines, ORThe aircraft collided with a fence during a takeoff and nosed over. The runway was an alfalfa field approximately 1000 feet in length with high growth. The density altitude was 4000 feet. The aircraft did become airborne but settled back to the field, and…NTSB SEA83FA040Accident · No injuriesField investigationFinal reportBell 206B · Newport, ORThe helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a…NTSB SEA83IA034Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Klamath Falls, ORDuring takeoff on runway 14 with the winds from 310 deg at 17 knots, satisfactory acceleration occurred through 70 knots followed by a slowing rate of acceleration at 80 knots. The captain then reduced power and shortly thereafter felt the left main tires…NTSB SEA83LA026Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hood River, ORThe aircraft was heavily loaded and took longer than normal for takeoff. The acceleration was marginal. At the end of the runway, when the pilot pulled up over the wires, the airspeed decayed. The pilot maneuvered to avoid houses and large trees and flew into…NTSB SEA82DA121Accident · No injuriesFinal reportLake LA-4 · Newport, ORThe pilot reported that during takeoff, he had accelerated to about 40 mph, and was on the step, when he hit a wave of sufficient size to bounce and become momentarily airborne. He was still accelerating and bounced a second time when it became apparent that…NTSB SEA82FYM19Accident · Minor injuriesFinal reportChampion 7GCAA · Independence, ORThe pilot reported that during a full stall landing, the aircraft veered to the left at the moment of touchdown. Full power was applied for a go-around, but reportedly, the pilot was unable to turn the aircraft back to the right toward the runway. After…NTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…NTSB SEA82DA079Accident · No injuriesFinal reportCessna 177 · Waldport, ORThe pilot elected to make a normal takeoff from a field of tall, wet grass. Acceleration was noted to be less than desired and the takeoff was aborted. The aircraft continued into a ditch in the overrun area.NTSB SEA82DA068Accident · No injuriesFinal reportde Havilland 2 · 15n Of Medford, ORThe pilot started a downwind takeoff on runway 15 with 9 parachutists on board. The runway was unidirectional requiring takeoffs on runway 15 which sloped downhill. After beginning the takeoff roll, the pilot had difficulity in maintaining directional control…NTSB SEA82FYM10Accident · No injuriesFinal reportWeatherly 201C · Wasco, ORThe pilot reported that during takeoff, the engine did not maintain full power. While landing in a residential area, the aircraft struck a telephone wire and three trees. An examination of the engine revealed no obvious defects that would cause a loss of…NTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…NTSB SEA82DYM01Accident · No injuriesClosedCessna 172 · Long Creek, ORNTSB SEA82DYM03Accident · No injuriesClosedCessna 172 · Ukiah, ORNTSB SEA81FYM43Accident · No injuriesClosedPitts S-1C · Troutdale, ORNTSB SEA81DYK18Accident · No injuriesClosedHiller Acft UH-12L · Malin, ORNTSB SEA81FYM37Accident · No injuriesClosedCessna 310J · Hillsboro, OR