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 FTW96FA030Accident · 1 fatalField investigationFinal reportBeech 95-B95 · Tulsa, OKInadequate preflight by the pilot by failing to remove the flight control lock and failing to check the flight controls before takeoff, and the pilot's failure to abort the takeoff.NTSB MIA96FA013Accident · No injuriesField investigationFinal reportBoeing 747-121 · Miami, FLfailure of the No. 4 engine fifth stage turbine hub due to a cyclic stress rupture for undetermined reasons, which resulted in an uncontained failure of the engine.NTSB NYC96LA015Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chester, CTThe pilot's failure to attain adequate airspeed, and his delay in aborting the takeoff, which resulted in a runway overrun and collision with trees. Factors relating to the accident were: the wet runway and hydroplaning conditions.NTSB FTW96LA014Accident · No injuriesLimited investigationFinal reportCessna 172M · Sugar Land, TXthe student pilot's diverted attention and failure to maintain directional control.NTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.NTSB MIA96LA004Accident · 1 fatalLimited investigationFinal reportLouks Pulsar XP · Inverness, FLPremature rotation by the pilot during takeoff, which resulted in an inadvertent stall/mush, while attempting to accelerate in ground effect after lift-off.NTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB SEA96LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Ola, IDThe pilot's inadequate preflight preparation by failing to determine that the takeoff area was clear of obstructions. The rock was a factor.NTSB FTW96FA004Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Roanoke, TXthe pilot's inadequate weather evaluation and encounter with a sudden windshift and tailwind. The wind gusts and turbulence were factors.NTSB ATL96LA002Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Decatur, ALThe student pilot's failure to maintain directional control during an aborted takeoff attempt. A factor was the stripped throttle knob threads.NTSB FTW96LA002Accident · No injuriesLimited investigationFinal reportBeech A36 · Cotulla, TXThe pilot's delay in aborting the takeoff. A factor was the pilot's improper use of the aircraft performance data.NTSB CHI95LA338Accident · No injuriesLimited investigationFinal reportHelio U-10D · Wellsville, KSThe pilot's improper weather evaluation. A factor was the pilot's inadequate compensation for the wind conditions.NTSB NYC95LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rutland, VTLoss of engine power during takeoff for undetermined reason(s), which resulted in a forced landing and subsequent collision with a tree and barn.NTSB BFO95LA099Accident · No injuriesLimited investigationFinal reportDeangelo Kitfox Speedster · Youngstown, OHthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A related factor was the pilot's lack of familiarity with the aircraft while carrying a passenger.NTSB CHI95LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Poseyville, INthe pilot's poor judgement in making a night takeoff on an unlit runway and his failure to maintain proper runway alignment. Factors associated with the accident were the hay bale, the night conditions and the unlit runway.NTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.NTSB MIA95FA226Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-35 · Smyrna, TNFailure of the pilot to maintain a proper climb rate after takeoff, and his inadvertent entry in a descending spiral, which he failed to correct. Factors relating to the accident were: darkness, and the pilot becoming spatially disoriented during the initial…NTSB CHI95LA341Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · South Bend, INthe Pilot-in-Command's inadequate supervision of the flight and failure to assure that proper airspeed, rate of climb, and clearance from trees were obtained/maintained.NTSB CHI95LA322Accident · Minor injuriesLimited investigationFinal reportBenham F8L Falco · Augusta, KSa sudden shift in wind direction which resulted in diminished airspeed during takeoff.NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB ANC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Kivalina, AKThe pilot's selection of unsuitable terrain for takeoff. A factor relating to the accident was: the rough/uneven terrain.NTSB FTW95LA387Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cibolo, TXThe pilot's improper planning/decision and failure to abort the takeoff, while there was sufficient runway remaining.NTSB CHI95LA318Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Belvidere, ILinadequate visual lookout by the pilots of both airplanes, which resulted in failure of each pilot to see-and-avoid the other airplane.NTSB ANC95LA164Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot's selection of an unsuitable area for takeoff. The water condition with large waves/swells was a related factor.NTSB FTW95LA386Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kerrville, TXthe pilot's inadequate preflight preparation and his failure to use all the available runway. A factor was the dark night.NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB ANC95LA161Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aniak, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.NTSB SEA95FA199Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Sheridan, WYfuel starvation for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB LAX95FA322Accident · 2 fatalField investigationFinal reportFloyd Lancair 200 SE · Georgetown, CAa partial loss of engine power for undetermined reasons, and the pilot's failure to abort the takeoff in a timely manner. The tailwind was a factor.NTSB ANC95LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Igiugig, AKThe pilot's inadequate preflight planning/preparation to assure the airplane would maintain adequate altitude/clearance from the river bank during takeoff.NTSB SEA95LA202Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 · Blakely Island, WAThe pilot's inadequate compensation for wind conditions during takeoff. A factor was the sudden change in wind direction.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 LAX95LA312Accident · No injuriesLimited investigationFinal reportRobinson R-22 · El Monte, CAthe student's improper use of the cyclic control; the flight instructor's inadequate supervision of the flight; and the flight instructor's failure to maintain an adequate obstacle clearance distance in selection of a practice slope landing area.NTSB FTW95LA368Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oklahoma City, OKThe failure of the low side of the turbine governor. A factor the lack of suitable terrain for the forced landing.NTSB NYC95LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Orson, PAThe pilot's improper planning/decision, and his delay in aborting the takeoff, which resulted in a collision with a pile of dirt and shrubs. The upsloping terrain (for takeoff) was a factor.NTSB MIA95LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lumberton, MSThe failure of the landing gear, steering system (rod end bolt) due to a bending overstress separation which resulted in loss of directional control.NTSB SEA95LA193Accident · No injuriesLimited investigationFinal reportHall Kitfox 1 · Pompeys Pillar, MTthe pilot's delayed decision to abort the takeoff. High density altitude, unavailabilty of aircraft takeoff performance data, and the short rough takeoff area were factors in the accident.NTSB FTW95LA362Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dalhart, TXthe pilot's failure to maintain control of the airplane during takeoff.NTSB BFO95LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Batavia, OHwas the the second pilot's loss of directional control during the takeoff roll, and the flight instructor/pilot-in-command's inadequate supervision of the flight instructor/second pilot. A related factor was the flight instructor/second pilot's lack of total…NTSB ANC95LA146Accident · No injuriesLimited investigationFinal reportCessna 180 · Fort Yukon, AKThe pilot's selection of an unsuitable takeoff area.NTSB MIA95LA209Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLThe pilot-in-command's decision to allow the student to land long and not use all the available runway and his delay in aborting the takeoff resulting in a runway overrun.NTSB CHI95LA287Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Anderson, INseizure of the landing gear wheel bearing and separation of the landing gear outer wheel-half and tire from the aircraft after which directional control of the aircraft by the pilot was not possible.NTSB FTW95LA354Accident · No injuriesLimited investigationFinal reportBeech C24R · Mineola, TXThe pilot's inadequate preflight planning/preparation, and his failure to obtain the required aircraft performance data for the flight. A factor was the high density altitude.NTSB ATL95LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Raeford, NCthe loss of the abutment seal which resulted in the fatigue failure of the cylinder head.NTSB FTW95IA348Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Lubbock, TXinstallation of an incorrect bearing in the number three main wheel by the wheel assembly supplier, which led to subsequent failure of the wheel bearing and separation of the wheel during takeoff.NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB ANC95LA142Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff. High vegetation and upsloping terrain were related factors.NTSB ANC95LA139Accident · Serious injuriesLimited investigationFinal reportMaule MA-4 · Port Alsworth, AKThe pilot's improper planning/decision and failure to attain sufficient airspeed to sustain a climb before hitting trees. The unfavorable wind condition was a related factor.