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 ANC91LA083Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Louise, AKThe pilot not maintaining directional control during the takeoff roll. Contributing to the accident was the rough condition of the airstrip.NTSB ANC91LA084Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Blair Lakes, AKWas the pilot-in-command's failure to assure sufficient obstruction clearance for his airplane during the takeoff roll. Contributing to the accident was the high vegetation.NTSB ANC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of control during the takeoff sequence caused by the failure of the tail wheel steering spring. Factors contributing to the accident were the gusty wind conditions and soft terrain.NTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.NTSB LAX91LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Payson, AZA premature liftoff, stall, and subsequent in flight collision with terrain. A factor related to the accident was the high density altitude.NTSB CHI91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-201R · Wheeling, ILThe pilot in command's inadequate pre-flight inspection. Factors contributing to this accident were the landing gear lever not being engaged, the use of an inadequate procedure by the pilot-in-command, and the inadvertent gear retraction during takeoff roll.NTSB ANC91LA080Accident · No injuriesLimited investigationFinal reportCessna 170A · Kakeen, AKThe pilot's failure to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident was the soft, rough, and uneven terrain.NTSB MIA91LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Doddsville, MSPoor planning decision by the pilot for failure to take into account the temperature extremes and what effect this would have on the ground roll distance. Contributing to the accident was his lack of total experience in the type of operation.NTSB CHI91LA195Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Cadillac, MIImproper preflight, inattentiveness, failure to maintain airspeed, and poor inflight planning/decision.NTSB CHI91LA194Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mundelein, ILThe pilot in command's not maintaining visual contact with the previously identified airplane.NTSB ANC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot-in-command's improper preflight and the contaminated fuel system. A factor was the rough, uneven terrain.NTSB CHI91LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manning, IAAirspeed was not attained and aborted takeoff was delayed by the pilot. Factors related to the accident were: over confidence in aircraft's ability to takeoff on the short, grass runway and a dirt embankment on the departure end of the strip.NTSB LAX91LA256Accident · No injuriesLimited investigationFinal reportWeaver WACO-ASO · Montague, CAFailure of the pilot to maintain directional control of the airplane and improper use of the brakes.NTSB DEN91LA080Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Santa Fe, NMA forward aft pilot seat adjustment locking mechanism failure.NTSB NYC91IA137Incident · No injuriesIncident investigationFinal reportBoeing 727-214 · Boston, MAThe failure of the third stage turbine blade on the number two engine, due to high cycle fatigue.NTSB ANC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKThe pilot's failure to maintain directional control during the attempted takeoff. Contributing to the accident was the rough takeoff area and the trees along the side of the takeoff area.NTSB LAX91LA287Accident · No injuriesLimited investigationFinal reportCessna C-U206B · Novato, CAThe pilot improperly used the mixture control, failed to attain the airspeed and delayed in aborting the takeoff.NTSB SEA91LA122Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Friday Harbor, WAThe pilot's poor preflight planning/preparation. Contributing to the accident were: the pilot did not maintain a proper clearance from an object, the pilot misjudged the wind conditions, and delayed remedial action.NTSB CHI91DEE05Accident · Minor injuriesFinal reportCharles Raucci, JR. Firebolt · Schaumburg, ILThe pilot not following the specification for installation of the fuel tank vent.NTSB CHI91DCA01Accident · Serious injuriesFinal reportGremminger Kolb Twinstar · St. Genevieve, MOThe failure of the pilot to abort the takeoff and improper remedial action by the pilot rated passenger after assuming control of the airplane. A factor associated with the accident is the pilot losing directional control during the takeoff ground run.NTSB CHI91DEV01Accident · No injuriesFinal reportCessna A188B · Bluffs, ILThe pilot's failure to maintain directional control.NTSB CHI91LA171Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIFailure of the pilot to maintain directional control during the takeoff ground run. A factor associated with the accident is the pilot's lack total experience.NTSB CHI91LA170Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Albany, MNThe cfi's failure to take timely and proper remedial action when the student pilot lost directional control during the takeoff roll. Factors in the accident are the tall grass edging the runway, and the student pilot's lack of total experience.NTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.NTSB ATL91LA100Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe pilot's failure to remove the control lock prior to attempting flight and his failure to follow the 'before takeoff' checklist. A factor in the accident was the pilot's diverted attention.NTSB ANC91LA062Accident · No injuriesLimited investigationFinal reportCessna 172-N · Egegik, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the high winds.NTSB CHI91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · St. Charles, MOThe pilot's failure to maintain directional control of the airplane during the takeoff ground run. Factors related to the accident were the gusty crosswind conditions, the pilot's lack of total experience and the vehicles which the airplane contacted.NTSB CHI91LA165Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Big Rapids, MIExcessive application of the flight controls by the student pilot. A factor related to the accident is delayed remedial action by the flight instructor.NTSB ATL91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe student pilot's delay in aborting the takeoff. The pilot's continued operation of the airplane with a known discrepancy and the operator's previous improper maintenance/inspection of the pitot/static system were factors related to the accident.NTSB MIA91LA148Accident · No injuriesLimited investigationFinal reportHughes 269C · Tarpon Springs, FLDelay by the pilot-in-command to apply adequate throttle & collective during transition off a dock for a takeoff over a lake. Contributing to the accident was his lack of total experience in the type operation.NTSB DEN91LA073Accident · No injuriesLimited investigationFinal reportBeech D18-S · Englewood, COThe loss of directional control by the pilot. Factors were: the cross, failure of the pilot to lock the tail wheel, and the pilot's disregard of crosswind limitations.NTSB LAX91LA217Accident · No injuriesLimited investigationFinal reportFarrington 18A · Long Beach, CAGround resonance remedial action not performed by the pilot.NTSB MIA91LA145Accident · Serious injuriesLimited investigationFinal reportCorley Hubert KR-2 · Venice, FLThe pilot's improper use of flight controls.NTSB FTW91DPG07Accident · No injuriesFinal reportCessna A188B · Eudora, ARThe pilot's exceeding the airplane's takeoff performance capability for the climatic conditions.NTSB NYC91LA131Accident · No injuriesLimited investigationFinal reportCessna 185C · New Hanover, PAThe loss of directional control by the pilot during a crosswind takeoff and subsequent collision with rough terrain. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB CHI91LA150Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hillsbord, WIDirectional control was not maintained by the pilot. A factor related to the accident was a drainage ditch.NTSB CHI91LA276Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monticello, MNThe pilot in command's (CFI) delayed remedial action. Related factors are the gusty crosswind, the student pilot's lack of total experience, inadequate compensation for crosswind conditions, and the cfi's failure to maintain directional control.NTSB LAX91LA200Accident · No injuriesLimited investigationFinal reportCessna T-337-D · Fullerton, CAThe loss of power in the front engine due to the improper and incomplete installation of the engine in the aircraft by a mechanic.NTSB LAX91LA192Accident · No injuriesLimited investigationFinal reportCessna 180 · Truckee, CAThat the pilot improperly used the flight controls and brakes to arrest the runway excursion. Contributing to this accident was encountering unfavorable winds, crosswind conditions, and lack of experience in this type of airplane.NTSB NYC91FA125Accident · No injuriesField investigationFinal reportBoeing 727-100QC · Windsor Locks, CTA catastrophic and uncontained failure of the no.3 engine which resulted in a fuel fed fire.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB LAX91LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Grass Valley, CAThe failure of the pilot to maintain directional control and to adequately compensate for the wind conditions resulting in an on ground loss of control and subsequent on ground collision with a drainage ditch.NTSB NYC91LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomvale, NYThe pilot's delay in aborting the takeoff.NTSB MIA91LA121Accident · No injuriesLimited investigationFinal reportBeech A36 · Punta Gorda, FLDelay of the pilot to abort the takeoff from the private grass airstrip resulting in the airplane overrunning the runway and colliding with a ditch.NTSB BFO91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the unfavorable wind condition.NTSB NYC91LA105Accident · No injuriesLimited investigationFinal reportCessna 170B · Newburyport, MAThe pilot failing to compensate adequately for adverse wind conditions during takeoff.NTSB LAX91LA231Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Julian, CAThe pilot's failure to maintain control of his experimental glider during takeoff. A contributing factor was the pilot's encounter with gusty winds.NTSB BFO91FA040Accident · 2 fatalField investigationFinal reportCessna 195 · California, MDThe loss of power for undetermined reasons.NTSB ATL91LA079Accident · No injuriesLimited investigationFinal reportCessna 120 · Pinebluff, NCThe pilot's delay in aborting the takeoff. The pilot's failure to calculate the aircraft's performance for the existing conditions was a factor related to the accident.NTSB ATL91FA074Accident · 3 fatalField investigationFinal reportBeech 60 · Kinston, NCThe pilot diverted his attention and failed to maintain control of the aircraft, while maneuvering for a precautionary landing. Factors related to the accident were: the unsecured baggage compartment door and the pilot's inadequate preflight.