NTSB investigations
53,703 cases where the phase of flight was Landing.
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 = 550)
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 = 550)
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 CHI99LA086Accident · No injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not obtaining proper runway centerline alignment during landing. Associated factors were the pilot's obscured view through the iced windshield, the runway lights not activating simultaneously with the approach lights, incomplete visual detection of…NTSB ATL99LA047Accident · No injuriesLimited investigationFinal reportBalloon Works AX-8 · Beech Island, SCThe pilot's failure to follow the balloon checklist that resulted in a ground fire that destroyed the balloon envelope.NTSB LAX99TA088Accident · No injuriesFinal reportMcDonnell Douglas 369D · Las Vegas, NVThe pilot's failure to properly judge the landing flare maneuver during a practice autorotative landing resulting in a hard landing.NTSB CHI99LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Alliance, NEthe unsuitable terrain for landing selected by the pilot-in-command. Factors were the tailwind landing condition and excessive braking by the pilot-in-command.NTSB CHI99LA078Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Chicago, ILthe second pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall mush.NTSB LAX99LA082Accident · No injuriesLimited investigationFinal reportCessna 172L · Santa Paula, CAThe instructor pilot's misjudged altitude and speed, which resulted in a failure to attain the proper touchdown point causing an overrun and collision with a block wall. A factor was the wet runway, which may have hindered brake effectiveness.NTSB CHI99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elmo, MNthe student pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the snow covered, icy runway condition and the snowbank which the airplane contacted.NTSB NYC99LA052Accident · No injuriesLimited investigationFinal reportBeech 1900D · Hyannis, MAThe captain's improper placement of the power levers in the BETA position, while the airplane was inflight. Factors were the fog and dusk conditions.NTSB NYC99LA051Accident · No injuriesLimited investigationFinal reportCessna 650 · Columbus, OHThe collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.NTSB FTW99LA068Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Edmond, OKThe pilot's failure to attain the proper touchdown point due to excessive airspeed and his failure to abort the landing. Factors were the pilot's excessive braking and the short, grass runway.NTSB CHI99LA071Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOthe instructor pilot's failure to maintain aircraft control. Factors contributing to this accident were the snow covered grassy field area along the side of the runway and the pile of snow.NTSB CHI99LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Hillsdale, MIthe pilot's disregarding preparation for the flight. Factors were a frozen landing gear wheel, and the snowbank.NTSB CHI99LA070Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Schaumburg, ILthe pilot's failure to maintain directional control of the airplane. A factor associated with the accident was the snowbank which the airplane contacted.NTSB ANC99IA025Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Fairbanks, AKThe improper overhaul of the thrust reverser pneumatic drive unit, and the subsequent failure of the thrust reverser actuator. Factors associated with the incident were the inadequate quality assurance procedures by the overhaul company.NTSB IAD99LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Fairfield, NJThe flight instructor's failure to maintain rotor rpm and his failure to complete the autorotational descent. A factor in the accident was the flight instructor's failure to fully deploy carburetor heat as directed in the Pilot's Operating Handbook.NTSB IAD99LA027Accident · No injuriesLimited investigationFinal reportCessna 421B · Youngstown, OHThe pilot's failure to maintain aircraft control. A factor was the icy runway.NTSB ATL99LA043Accident · Minor injuriesLimited investigationFinal reportTrohoski VARI-EZE · Tupelo, MSThe pilot's improper flare and compensation for wind conditions upon landing. Factors in the accident were the pilot's inadequate recurrent training and lack of experience with the airplane.NTSB CHI99LA064Accident · No injuriesLimited investigationFinal reportGulfstream 695A · Wheeling, ILThe pilot-in-command (CFI)'s poor in-flight planning and decision making, and his inadequate supervision of the dual student. Factors were the tailwind condition, icing conditions, and the dual student's improper flare.NTSB ATL99LA041Accident · No injuriesLimited investigationFinal reportCessna 172 · Centre, ALThe pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.NTSB CHI99LA063Accident · No injuriesLimited investigationFinal reportBeech BE-C-45H · St. Joseph, MOthe pilot not maintaining directional control during the landing rollout. A factor in this accident was the patchy snow on the runway.NTSB LAX99LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Tucson, AZThe student pilot's inadvertent activation of the right heel brake on the conventional geared aircraft, which resulted in a loss of directional control and an inadvertent ground loop. A contributing factor was inadequate supervision.NTSB CHI99LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILthe pilot's failure to maintain proper runway alignment during the landing flare. A factor related to the accident was the snowbank which the airplane contacted.NTSB NYC99LA048Accident · No injuriesLimited investigationFinal reportCessna 310R · Allentown, PAThe pilot's improper decision to reduce too much power during the landing flare.NTSB ATL99LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Palmetto, FLThe failure of the wheel fairing attach bolts that resulted in the loss of control during the landing roll when the fairing became lodged under the left wheel.NTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.NTSB CHI99LA061Accident · No injuriesLimited investigationFinal reportBeech BE-V35B · Olathe, KSThe pilot's continued flight into adverse weather that resulted in structural icing and subsequently an aerodynamic stall on landing flare. A factor was the pilot's inadequate weather evaluation .NTSB CHI99LA059Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Plymouth, INthe pilot's failure to maintain directional control of the airplane while landing. Factors associated with the accident were the tailwind condition and the pilot landing in the wrong direction.NTSB FTW99LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe student pilot's failure to compensate for a crosswind resulting in a loss of control. Factors were the gusty high winds and the flight instructor's improper decision to allow the student to solo during high winds.NTSB CHI99LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIthe pilot-in-command's loss of directional control during landing roll. Factors to the accident were the icy terrain condition, crosswind, and the snow bank.NTSB LAX99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hayward, CAThe pilot-in-command's failure to maintain directional control. A factor in this accident was the inadvertent ground loop swerve.NTSB CHI99LA068Accident · No injuriesLimited investigationFinal reportCessna P210N · Eau Clare, WIthe delayed gear extension by the pilot. Contributing factors were the checklist not used by the pilot, the inoperative gear warning, and the maintenance replacement of the throttle control/gear warning interconnect cable not performed by company/operator…NTSB ATL99LA036Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Murfreesboro, TNThe pilot's inadequate flare and his diverted attention, which resulted in a hard landing.NTSB LAX99LA060Accident · No injuriesLimited investigationFinal reportAegerter, Simon Velocity 173E-RG · San Diego, CAThe pilot's inadequate modification to the control systems, which resulted in a restricted elevator control.NTSB SEA99LA029Accident · No injuriesLimited investigationFinal reportBeech 200 · Weiser, IDAirport snow removal was not properly performed. A snowbank was a factor.NTSB CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.NTSB SEA99LA024Accident · No injuriesLimited investigationFinal reportCessna 120 · Omak, WAThe pilot-in-command's failure to maintain directional control. Contributing factors were the snow covered runway and a snowbank (berm) at the runway's edge.NTSB CHI99LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Appleton, WIThe pilot's failure to maintain directional control. A related factor was the crosswind.NTSB SEA99LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bellingham, WAA hard landing due to the pilot's failure to maintain a proper descent rate. Factors include gusts and turbulence.NTSB MIA99LA049Accident · No injuriesLimited investigationFinal reportCessna 170 · Lawrenceville, GAThe pilot's failure to maintain directional control.NTSB LAX99LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Bear, CAThe pilot's misjudged landing flare, which lead to an inadvertent stall/mush 10 feet above the ground.NTSB CHI99LA055Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Traverse City, MIThe crew's failure to execute a missed approach and the flying pilot's (captain) failure to maintain directional control upon touchdown with a seven degree left bank and a right quartering tailwind. Factor's were the snow covered runway/landing area and the…NTSB SEA99LA021Accident · No injuriesLimited investigationFinal reportElliott RAF 2000 · Walla Walla, WAThe pilot's failure to maintain directional control after landing.NTSB FTW99LA053Accident · Serious injuriesLimited investigationFinal reportDennis Pointer KR-2 · Denton, TXThe pilot's loss of control as result of his improper recovery from a bounced landing.NTSB FTW99FA049Accident · 2 fatalField investigationFinal reportCessna 150H · Marksville, LAThe pilot's failure to visually identify the hazardous condition of the runway. Factors were the dusk light condition and the pilot's failure to obtain NOTAMs.NTSB DEN99LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Glenwood Spring, COThe pilot's failure to maintain directional control. A contributing factor is his inadequate recovery from a bounced landing.NTSB MIA99LA062Accident · No injuriesLimited investigationFinal reportBeech C-45G · Charlotte AmaliThe inadequate flare by the pilot-in-command resulting in a hard landing on the nose landing gear causing it to collapse.NTSB LAX99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Tucson, AZFailure of the instructor pilot to maintain directional control and properly supervise the landing. A contributing factor was the unavailability of brakes on the instructor's side (the right side) of the airplane.NTSB ATL99LA032Accident · No injuriesLimited investigationFinal reportCessna 310C · Ft Myers, FLThe inadequate preflight inspection of the airplane by the pilot and subsequent malfunction of the nose gear strut, and the pilot's failure to follow the landing checklist.NTSB NYC99LA035Accident · No injuriesLimited investigationFinal reportBeech 36 · Mathews, VAThe pilot's decision to land with less than full-down flaps. Contributing factors were the wet landing surface and the tree.NTSB NYC99LA034Accident · No injuriesLimited investigationFinal reportUnivair 7GC-AA · Garner, VAA jammed right wheel for undetermined reasons.