NTSB investigations
14,038 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.\"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."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 SEA91LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Everett, WAThe student pilot's failure to maintain directional control. A factor related to the accident was: the taxiway marker's lack of frangibility due to its construction.NTSB LAX91LA362Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Verona, CAThe pilot's improper planning/decision to depart from a runway with high vegetation along the edge and subsequent collision with terrain.NTSB ANC91LA127Accident · No injuriesLimited investigationFinal reportCessna 180A · King Salmon, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB SEA91LA213Accident · No injuriesLimited investigationFinal reportCessna 177 · Nampa, IDThe pilot's delay in initiating a go-around (aborted landing) and his improper raising of the flaps. Factors related to the accident were: the high density altitude, tailwind, and the pilot's selection of the wrong runway.NTSB DEN91LA136Accident · No injuriesLimited investigationFinal reportCessna 421B · Pagosa Springs, COInadequate preflight of the aircraft by the pilot in command. A factor was: failure of the pilot in command to properly latch the cargo door.NTSB ANC91LA125Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ugashik, AKWas the pilot-in-command's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB LAX91IA297Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Los Angeles, CAThe inadequate runway safety area inherent in the airport design, and, the ATC clearance procedures in use which failed to take into consideration the substandard runway safety area. Factors in the incident were the dark night time conditions and the…NTSB CHI91LA261Accident · No injuriesLimited investigationFinal reportPiper PA-32-R300 · Lake In Hills, ILThe pilot's failure to perform an adequate preflight by assuring the gear lever was in the down and locked position.NTSB SEA91LA206Accident · No injuriesLimited investigationFinal reportBeech V35B · Belgrade, MTThe pilot's failure to maintain a positive rate of climb during the takeoff. Factors contributing to the accident were the open cabin window and the pilot's diverting his attention.NTSB NYC91LA208Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Butler, PAThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway and impacted with the terrain.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 LAX91LA352Accident · No injuriesLimited investigationFinal reportCessna 210 · Chino Valley, AZThe failure of the pilot to maintain directional control. A factor in the accident was the slippery condition of the road surface being used as a runway.NTSB LAX91LA350Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the airport operator to develop animal control procedures for the airport property.NTSB ANC91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the pilot's weather evaluation misjudgment, the high wind, and rough water encountered during takeoff.NTSB ANC91LA118Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Emmonak, AKThat the pilot inadvertently retracted the landing gear during the takeoff roll. Contributing to this accident was that the checklist was not followed.NTSB ATL91LA156Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Camden, TNThe student pilot's delayed decision to abort the takeoff, resulting in his inability to stop the airplane in the remaining runway. Factors were the pilot's lack of total flying experience, and the high outside air temperature at the time of the accident.NTSB ANC91LA120Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKThe pilot-in-command's failure to mantain directional control of the airplane during the takeoff roll. Contributing to the accident was the crosswind.NTSB ATL91LA152Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Manning, SCThe pilot's failure to maintain directional control during the takeoff roll, and his failure to abort the takeoff in a timely manner once the airplane had departed the runway surface. A factor in the accident was the pilot's failure to utilize the entire…NTSB SEA91LA200Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Murtaugh, IDThe improper preflight planning/decision by the pilot, resulting in his attempt to takeoff with the aircraft loaded over maximum certificated gross takeoff weight.NTSB CHI91LA239Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Bridgewater, SDDirectional control was not maintained by the pilot. A factor related to the accident was a fence.NTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.NTSB CHI91LA227Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Hutchinson, KSThe landing gear handle was placed in the gear up postion prematurely resulting in a gear retraction during takeoff. Factors related to the accident were proper procedures were not followed by the pilot.NTSB SEA91LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roy, MTThe failure of the pilot to maintain clearance from obstacles during takeoff.NTSB ATL91FA142Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Manteo, NCThe loss of left engine power for undetermined reasons, and the failure of the pilot to maintain minimum controllable airspeed, which resulted in the stalling of the airplane.NTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.NTSB CHI91FA228Accident · 2 fatalField investigationFinal reportRobinson R 22B · Carmel, INThe pilot's delaying remedial action. Factors in the accident were the pilot's failure to attain adequate rotor RPM for takeoff, failure to abort takeoff and lack of total experience in helicopters.NTSB SEA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Kemmerer, WYThe pilot's poor planning/decision. Factors include selecting the wrong runway under the high density altitude conditions.NTSB CHI91MA224Accident · 3 fatalMajor investigationFinal reportLearjet 23 · Detroit, MIImproper preflight by the pilot, his failure to abort the takeoff while there was sufficient runway remaining, and his failure to assure that the aircraft attained sufficient airspeed for lift-off and climb. Factors related to the accident were: the pilot's…NTSB ANC91FA104Accident · Serious injuriesField investigationFinal reportCessna 152 · Anchorage, AKA loss of power due to undetermined causes. Factors include objects in the flight path encountered during the emergency descent.NTSB DEN91LA102Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Albuquerque, NMThe failure of the right main landing gear tire.NTSB CHI91DTG06Accident · No injuriesFinal reportAyres S2R · Drayton, NDThat the pilot did not perform any preflight planning, and did not use the aircraft performance data.NTSB CHI91DTG05Accident · No injuriesFinal reportCessna T188C · Bathgate, NDA loss of control inflight which resulted in a collision with the crop.NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.NTSB SEA91LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Pullman, WAThe pilot's failure to maintain runway alignment. Factors include high vegetation growing close to the runway.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB FTW91LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Wilburton, OKThe pilot's decision to abort the take off with insufficient distance remaining. Factors were the fluctuating engine and the trees in his path.NTSB SEA91LA173Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Toledo, WADirectional control was not maintained.NTSB LAX91LA307Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · El Cerrito, CAThe instructor pilot's improper slope takeoff technique.NTSB DEN91FA098Accident · No injuriesField investigationFinal reportBoeing 707-323C · Denver, COImproper overhaul of the nose gear assembly by other maintenance personnel.NTSB LAX91LA300Accident · No injuriesLimited investigationFinal reportCessna 320 · Reno, NVThe fatigue failure of the propeller feathering counter weight clamp assembly.NTSB BFO91LA066Accident · No injuriesLimited investigationFinal reportCessna 175B · Farmington, MDAn aborted takeoff due to the pilot's reported binding of the elevator.NTSB SEA91LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Sequim, WAThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was a hidden obstruction.NTSB SEA91FA157Accident · 3 fatalField investigationFinal reportBeech V35B · Roche Harbor, WAThe pilot's failure to plan his takeoff path to provide adequate terrain clearance. The rising terrain and dark night light conditions were contributing factors.NTSB FTW91LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Sonora, TXThe pilot's improper aircraft control during the takeoff ground run. Factors were the density altitude and the rough terrain.NTSB DEN91FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Denver, COImproper planning/decision by the pilot. Factors related to the accident were: a tail wind, the high density altitude, the pilot's failure to properly lean the mixture, and his failure to use all available runway.NTSB CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.NTSB CHI91DER12Accident · Serious injuriesFinal reportLacey B D4 · Albert Lea, MNThe pilot's failure to take adequate remedial action. Related factors are the tall grass runway conditions, and the inadequate airspeed.NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.NTSB ANC91LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Cordova, AKThe pilot's failure to maintain directional control during the takeoff ground run and the intentional ground loop by the pilot. The crosswind was a factor in the accident.NTSB ANC91LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKWas the pilot-in-command's loss of control during the takeoff run, thereby allowing the airplane to stray from the runway's centerline and to strike some high vegetation.