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 ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.NTSB MIA89FA174Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · St. Augustine, FLThe pilot failed to maintain airspeed during the turn to return to the airport, resulting in the loss of control. Contributing to the accident was his continued takeoff with intermittent engine power.NTSB FTW89LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, TXImproper planning/decision by the pilot, which resulted in a loss of aircraft control. The high, gusty, crosswind condition was a related factor.NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.NTSB FTW89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Worth, TXInitially the loss of power on the left engine due to an inadequate preflight by the pilot. A secondary cause was a inadvertent feathering of the wrong propeller by the pilot.NTSB NYC89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Uxbridge, MAImproper maneuvering shortly after takeoff from a private grass strip of marginal length for the caliber of acft being operated. A wind change added to the already exacting conditions.NTSB MKC89LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bolivar, MOImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were the tall grass, inadequate runway maintenance, and trees.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB DEN89MA130Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Big Timber, MTFailure of the pilot to maintain control of the aircraft during takeoff, due to spatial disorientation, which resulted in a collision with the terrain. Contributing factors were: dark night, pilot's visual perception, inadequate initial training of the pilot…NTSB CHI89LA102Accident · No injuriesLimited investigationFinal reportCessna 206 · Flushing, MIPilot's inadequate aircraft control during the aborted takeoff attempt, and the aircraft's resultant collision with trees. The wet runway was a factor in the lack of normal braking action.NTSB MKC89LA121Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Snow Lake, ARThe selection of unsuitable terrain to takeoff from by the pilot and the inadequate runway maintenance by airport personnel. Contributing to the accident was the hidden hole which the airplane contacted resulting in the pilot's inability to control the…NTSB MKC89LA119Accident · Minor injuriesLimited investigationFinal reportRockwell Thrush S2R · Carlisle, ARThe engine failed due to a cracked cylinder and the pilot was forced to attempt a landing in a rice field where the gear collapsed.NTSB LAX89LA206Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Big Sur, CAThe pilot elected to attempt a takeoff from a field that he had previously made a forced landing to and the airplane nosed over during the attempt. Contributing to the accident was the high grass that became entangled in the tailwheel and the soft downhill…NTSB FTW89LA101Accident · No injuriesLimited investigationFinal reportCessna 206D · Saint Jo, TXThe pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.NTSB FTW89LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Amarillo, TXFailure to attain liftoff speed and the pilot in command's failure to abort the takeoff.NTSB FTW89DRD04Accident · No injuriesFinal reportSchweizer G-164A · Oak Grove, LAThe pilot failed to perform adequate prelight planning/preparation before attempting a takeoff by failing to assure the runway condition.NTSB NYC89LA134Accident · No injuriesLimited investigationFinal reportMaule M-4 · Csttltn-Hdsn, NYThe pilot's selection of unsuitable terrain. A contributing factor was the wet, soft grass.NTSB LAX89LA198Accident · No injuriesLimited investigationFinal reportCessna 140 · Placerville, CATotal failure of the landing gear tire. A major factor was the unsuitability of the terrain at the side of the runway.NTSB MIA89LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe instructors decision to attempt a takeoff in a high density altitude situation, with a quartering tailwind.NTSB ANC89IA071Incident · No injuriesIncident investigationFinal reportBoeing 747-121 · Anchorage, AKFailure of tires on the right inside main gear truck. A related factor was: failure of operator/management personnel to follow proper loading procedures, which resulted in an improper lateral weight and balance situation.NTSB CHI89LA090Accident · No injuriesLimited investigationFinal reportCessna 150 L · Eureka, MIStudent pilot's improper aircraft control during the takeoff roll, and the subsequent aborted takeoff was performed with insufficient runway remaining to successfully stop the aircraft before the departure end of the runway.NTSB CHI89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ojibwa, WIImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were: the wet/upward sloping condition of the airstrip, unfavorable wind, high obstructions (tall trees/obstacles at the end of the runway), and high…NTSB MKC89FA109Accident · Serious injuriesField investigationFinal reportBensen B-8KSB · Eldon, MOPilot's failure to maintain aircraft control which resulted in collision with the terrain during take off.NTSB CHI89LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Terre Haute, INPilot's inability to maintain directional control during the takeoff roll. A factor in the accident was the crosswind.NTSB MKC89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Moberly, MOThe failure of the pilot in command to maintain control of the aircraft while on takeoff ground run. Contributing to this lack of control were wind gusts from dust devils in the area, thermal activity, and the pilot's lack of experience.NTSB DEN89LA116Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Deming, NMThe pilot's failure to maintain directional control during the takeoff ground run, resulting in a loss of control and collision with the terrain. The lack of experience in this type of aircraft is considered to be a factor.NTSB LAX89LA177Accident · No injuriesLimited investigationFinal reportCessna 310C · Jackson, CAThe failure of the instructor pilot (pilot in command) to reject the takeoff after the loss of power on one engine when sufficient runway remained to stop the aircraft. Contributing to the accident was the disregard of the aircraft manual, failure to use the…NTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.NTSB NYC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dushore, PACollision with trees during a rejected takeoff from a private turf strip due to the pilots failure to take advantage of the existing wind.NTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.NTSB BFO89LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Laurel, MDThe pilot's failure to obtain adequate airspeed during the attempted short field takeoff for undetermined reasons.NTSB ATL89LA132Accident · No injuriesLimited investigationFinal reportCessna 172F · Elkin Arpt., NCThe failure of the pilot to properly compensate for the gusty wind conditions during takeoff and the delay in his decision to abort the takeoff before colliding with trees. Contributing to the accident were the gusty wind conditions and the pilot's lack of…NTSB ATL89LA135Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Brooks, GAClimb not possible because of a downdraft which exceeded the performance capabilities of the airplane. Factors related to the accident were: inadequate location of the wind sock, the adverse wind conditions, and the trees.NTSB SEA89LA072Accident · No injuriesLimited investigationFinal reportBeech A55 · Arlington, WAA premature/improper retraction of the landing gear by the second pilot (aircraft owner), who was occupying the right front seat.NTSB DEN89LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe pilot's failure to compensate for the wind conditions during the takeoff. Contributing to the accident were the crosswind conditions.NTSB DEN89LA107Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Aurora, COThe inadequate compensation for wind conditions by the pilot. Lack of recent experience in the type of aircraft is considered a contributing factor.NTSB LAX89LA156Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Scottsdale, AZThe pilot's loss of directional control of the airplane during the ground run and abrupt rotation to get airborne.NTSB ATL89LA125Accident · No injuriesLimited investigationFinal reportCessna 150B · Hickory, NCThe pilot's failure to refuel the airplane prior to the flight resulting in fuel exhaustion during takeoff.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.NTSB LAX89DUQ03Accident · No injuriesFinal reportMartin Sorrell Hiperlight · Liano, CAEngine failure due to a seized piston.NTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…NTSB CHI89LA066Accident · No injuriesLimited investigationFinal reportCessna 170B · Freedom, WIThe pilot's failure to maintain directional control during the attempted takeoff on unsuitable terrain. The pilot's lack of recent flight experience was a contributing factor.NTSB LAX89LA145Accident · No injuriesLimited investigationFinal reportLet L-13 · Hemet, CAInadequate crew coordination between the ground lineman and the blanik pilot, and failure of the blanik pilot to maintain clearance between his aircraft and the parked glider. A factor related to the accident was the proximity of the parked glider to the…NTSB SEA89LA063Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sitka, AKThe pilot's continuing the takeoff despite the large boat wake and gusting wind. A contributing factor was the pilot's low flight time in this type of aircraft.NTSB LAX89FA140Accident · 5 fatalField investigationFinal reportPiper PA-60-601P · Newport Beach, CAFailure of the pilot to attain adequate airspeed before maneuvering (turning) back toward the airport, which resulted in a loss of aircraft control. A factor related to the accident was: improper maintenance/installation of a fuel injector reference air line,…NTSB MIA89LA116Accident · Minor injuriesLimited investigationFinal reportBeech B55 · Sarasota, FLUneven runway condition (sunken spot).NTSB DEN89LA096Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, COThe pilot's inadequate compensation for wind conditions, failing to maintain directional control, and inadvertent ground swerve. Gusty crosswinds contributed to the accident.NTSB ANC89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Beluga Mountain, AKPilot's selection of unsuitable terrain for an off-airport landing and takeoff. The uneven terrain (with a snow berm) was a related factor.NTSB DEN89FA093Accident · 2 fatalField investigationFinal reportCessna 177RG · Albuquerque, NMThe pilot's improper use of flaps during takeoff which resulted in inadequate airspeed, a stall, and loss of control.