NTSB investigations
20,559 cases where the phase of flight was Initial climb.
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 = 350)
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 = 350)
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 FTW95LA345Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Wilmot, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA342Accident · No injuriesLimited investigationFinal reportBeech 19 · Lago Vista, TXThe loss of engine power for undetermined reasons.NTSB CHI95LA283Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Ironwood, MIthe pilot's failure to maintain control of the airplane during the aborted takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB MIA95LA203Accident · Serious injuriesLimited investigationFinal reportFairchild 24-G · Harold, FLThe engine missing for undetermined reasons, and the failure of the pilot in command to maintain airspeed while turning toward a landing area.NTSB LAX95LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Truckee, CAA failure in the aircraft electrical system, and the pilot's failure (or inability) to extend the landing gear with the emergency extension system. A factor relating to the accident was: the pilot's decision to continue the flight with a known deficiency.NTSB ATL95LA156Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mckenzie, TNThe pilot's failure to comply with the performance data for the aircraft in his attempt to takeoff, downwind, from the short sod runway, with high density altitude, and with the aircraft weight in excess of the maximum gross weight allowed.NTSB ATL95LA153Accident · No injuriesLimited investigationFinal reportYothment KOLB-FIRESTAR II · Lawrenceville, GAThe pilot's failure to maintain flying speed. A factor was the pilot's lack of familiarity with the aircraft.NTSB CHI95LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Fremont, NEa loss of engine power for undetermined reasons. A factor in the accident was the unsuitable landing terrain.NTSB CHI95LA266Accident · No injuriesLimited investigationFinal reportGrumman G164B · Bloomington, NEthe disintegration of the engine's super charger bearings. Factors associated with the accident were the total failure of the engine's super charger and the unsuitable terrain surrounding the airplane's departure path encountered by the pilot.NTSB MIA95LA195Accident · No injuriesLimited investigationFinal reportCessna 195B · Macon, GAa total loss of engine power for undetermined reasons. Contributing to the accident was an engine compartment fire of undetermined origin.NTSB SEA95LA177Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Boise, IDimproper adjustment of the engine fuel control units by company maintenance personnel which led to excessive fuel flow and subsequent partial loss of engine power. Factors contributing to the accident were the rough terrain and high density altitude.NTSB FTW95LA330Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, COThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ANC95LA127Accident · No injuriesLimited investigationFinal reportCessna 206 · Sterling, AKFailure of both pilot's to maintain adequate visual lookout. The low angle of the sun was a related factor.NTSB MIA95LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Holly Springs, MSThe failure of the pilot-in-command to insure the oil dip stick was secure prior to departure resulting in loss of engine oil, overheating of the engine, and loss of engine power.NTSB ANC95LA126Accident · No injuriesLimited investigationFinal reportCessna 206G · Skwentna, AKThe pilot's improper handling of the aircraft (prolonged yawing maneuver during step taxi turn), which resulted in uncovering of the fuel tank outlets and subsequent fuel starvation during takeoff.NTSB NYC95LA209Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Frankfort, NYInflight collision with the ground for undetermined reasons.NTSB CHI95LA246Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Springfield, MOthe partial loss of engine power due to fouled spark plugs as a result of an improper fuel/air mixture. A factor in the accident was the powerlines.NTSB SEA95LA159Accident · No injuriesLimited investigationFinal reportCessna 402B · Wenatchee, WAImproper installation (failure to install cotter key) by company maintenance personnel.NTSB ANC95LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Port Alsworth, AKThe pilot's inadequate compensation for the crosswind condition, which resulted in a failure to maintain runway alignment. The crosswind and proximity of trees were related factors.NTSB FTW95LA318Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Muskogee, OKThe pilot's evasive manuever to take off with insufficient runway available for attaining takeoff airspeed. Factors which contributed to the accident were: the unauthorized use of the airplane, the pilot's anxiety, and the dark night.NTSB CHI95LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Park River, NDthe loss of power due to the primary lead in the left magneto being grounded against the case, and the improper clearance of the breaker point gaps. A factor was the lack of suitable terrain on which to perform the forced landing.NTSB NYC95LA175Accident · Minor injuriesLimited investigationFinal reportVarga TRI-Q200 · Elyria, OHthe pilot's decision to perform a staggered takeoff on the downwind side of the runway, which resulted in a wake turbulence encounter, loss of control in flight, and uncontrolled descent onto the runway. A factor was the pilot's lack of experience in…NTSB SEA95LA160Accident · No injuriesLimited investigationFinal reportCessna 172 · Mazama, WAThe pilot's failure to maintain adequate airspeed for the wind conditions during climbout. The gusty wind condition was a factor.NTSB FTW95LA313Accident · No injuriesLimited investigationFinal reportSteinke Early Bird · Akron, COFailure of the pilot to properly flare the airplane for landing during an emergency landing after takeoff. Factors relating to the accidents were: a malfunction of the side rave valve, an excessively rich fuel mixture, and the high density altitude, which…NTSB ANC95LA125Accident · No injuriesLimited investigationFinal reportCessna 207 · Shishmaref, AKThe pilot's failure to adequately compensate for the downdraft. Factors associated with the accident were: the short, uphill runway, and downdrafts.NTSB LAX95LA263Accident · 1 fatalLimited investigationFinal reportCessna 182P · Kneeland, CAthe non-instrument rated pilot's decision to takeoff in known adverse weather conditions, which resulted in spatial disoreintation and an in-flight loss of control.NTSB CHI95LA229Accident · 1 fatalLimited investigationFinal reportDarrell Falconar F9 · Grand Haven, MIFailure of the pilot to maintain adequate airspeed during the climb after takeoff, which resulted in an inadvertent stall. Factors relating to the accident were: the pilot's use of an unapproved drug while flying, his lack of experience in the make and model…NTSB NYC95LA166Accident · No injuriesLimited investigationFinal reportBeech V35B · Goshen, OHthe pilot's premature liftoff which resulted in an inadvertent stall and a subsequent collision with trees.NTSB ANC95LA107Accident · No injuriesLimited investigationFinal reportHughes 500D · Paxson, AKFuel starvation due to acrylamide contamination in the fuel control inlet filter. The lack of suitable terrain for a forced landing was a related factor.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB SEA95LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Kent, WAThe pilot's failure to maintain clear of the trees. The dark night light condition was a factor.NTSB LAX95LA254Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's improper planning/decision and failure to obtain or maintain adequate airspeed during takeoff. A factor relating to the accident was: the high density altitude.NTSB CHI95FA226Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Festus, MOan improper annual inspection, the fouled spark plugs, the arcing magneto distributor, and the pilot's attempt to take off with known deficiencies.NTSB ATL95LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Statesville, NCA cracked cylinder that resulted in a loss of engine power.NTSB FTW95LA297Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe loss of engine power due to a failed supercharger/blower. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.NTSB SEA95LA146Accident · No injuriesLimited investigationFinal reportMooney M20G · Rigby, IDThe pilot's premature liftoff and failure to attain adequate airspeed during takeoff. The high density altitude was a factor.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB FTW95LA290Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · De Witt, ARThe pilot's failure to maintain airspeed and the resulting inadvertent stall/mush.NTSB FTW95FA277Accident · 4 fatalField investigationFinal reportBellanca 17-31A · Hot Springs, ARThe partial loss of engine power as a result of the disengagement of the throttle cable housing due to improper maintenance. Factors were the night condition and the lack of suitable terrain.NTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…NTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.NTSB LAX95LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rubidoux, CAthe pilot's inadequate preflight planning/preparation in that he attempted to fly an aircraft without first verifying the aircraft's gross weight and published performance capabilities.NTSB CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.NTSB MIA95FA174Accident · 2 fatalField investigationFinal reportCessna 172RG · Ft. Lauderdale, FLThe failure of the pilot to maintain airspeed after a momentary loss of engine power during takeoff, resulting in an inadvertent stall/spin. The reason for power loss could not be determined.NTSB FTW95LA286Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe failure of the pilot to maintain airspeed resulting in an inadvertent stall.NTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.NTSB SEA95LA142Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Island Park, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was wind gusts.NTSB MIA95LA176Accident · No injuriesLimited investigationFinal reportKashpureff Nieuport II · Venice, FLThe pilot-in-command's inability to maintain airspeed after encountering a sudden wind shift after lift off resulting in an inadvertent stall, uncontrolled descent, and ground collision.NTSB LAX95LA253Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Maricopa, AZan undetermined internal failure of the carburetor.