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 MIA00LA135Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Athens, GAthe pilot's failure to maintain control of the helicopter resulting in his misjudging the flare and a subsequent hard landing. Factors in this accident were, the pilot's inadequate planned approach in trail of two heavier helicopters, a crosswind landing…NTSB MIA00LA143Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Lakeland, FLthe pilot's improper inflight planning/decision to land long, with a tailwind, on a wet grass runway that resulted in the loss of control and the airplane exiting the runway, incurring substantial damage.NTSB FTW00LA125Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, TXThe failure of the pilot to maintain directional control during the landing roll. A factor was the pilot's total lack of experience in tailwheel airplanes.NTSB ANC00LA046Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Anchorage, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was a frozen puddle.NTSB ANC00LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Chickaloon, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an open service door, and snow-covered terrain.NTSB SEA00LA071Accident · No injuriesLimited investigationFinal reportCessna 150H · Lopez Island, WAProper touchdown point not attained by the pilot. Factors include excessive speed at touchdown, a wet runway, a fence, and the pilot's inadvertent flight into IMC.NTSB CHI00LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOthe pilot misjudged the landing flare which resulted in the airplane porpoising on the runway during the landing.NTSB ANC00LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Delta Junction, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were snow-covered terrain, and a short runway/landing area.NTSB MIA00LA137Accident · Minor injuriesLimited investigationFinal reportWalden A. Cooper Pitts S1S · Daytona Beach, FLCollapse of the tail wheel to the right during landing rollout when the forward attach bolt sheared for undetermined reasons. This resulted in the aircraft's rudder deflecting to the right, the pilot losing directional control, and the aircraft running off…NTSB LAX00LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAThe pilot's decision to continue with a high, steep, and fast approach, which resulted in a touchdown beyond the halfway point of the runway and the inability to stop on the remaining pavement, and, his delayed decision to initiate a landing abort. Also…NTSB LAX00LA150Accident · Minor injuriesLimited investigationFinal reportTaylor Smith Witman W-10 · Riverside, CAfailure of the pilot to recover from a bounced landing resulting in a loss of directional control and collision with a fence.NTSB SEA00LA065Accident · No injuriesLimited investigationFinal reportAero Design Eleven 12 · Spokane, WACracking of the weld between the tailwheel stinger housing and longitudinal cross tube, resulting in separation of the tube/tail wheel assembly from the airframe.NTSB LAX00LA142Accident · No injuriesLimited investigationFinal reportCessna 305A · Jackson, CAfailure of the pilot to adequately compensate for a crosswind condition, resulting in a loss of directional control and collision with a rock.NTSB FTW00LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fayetteville, ARThe failure of the inboard half of the right main landing gear wheel as a result of fatigue.NTSB DEN00LA071Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly F-15 · Anthony, NMFailure by the pilot to keep the burner operating until the balloon was secured. A factor was the passengers disregarding the instructions they had been given by the pilot.NTSB DEN00LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Collins, COOn ground loss of control resulting in collision with airport markings due to inadequate compensation for wind conditions during landing roll. Factors were inaccurate in flight planning by landing with a tail wind component and lack of total pilot experience.NTSB LAX00LA147Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Herlong, CAThe failure of the pilot to maintain directional control of the airplane during landing in gusting crosswind conditions.NTSB IAD00FA034Accident · No injuriesField investigationFinal reportTaylorcraft BC12D-4-85 · Dameron, MDThe failure of the float landing gear system due to non-standard repairs, improper modifications, and corrosion.NTSB NYC00LA109Accident · No injuriesLimited investigationFinal reportCessna 172 · North Adams, MAThe pilot's failure to obtain the proper touchdown point. A factor was a tailwind.NTSB ANC00LA042Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Delta Junction, AKThe pilot's inadequate compensation for wind conditions during landing. Factors associated with the accident were an unfavorable wind, a crosswind, and an inadvertent swerve.NTSB SEA00LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Creswell, ORThe pilot's failure to maintain directional control. Factors include a drainage ditch and a crosswind.NTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.NTSB NYC00LA107Accident · Minor injuriesLimited investigationFinal reportPagan RV-8A · East Liverpool, OHThe pilot's loss of control during the landing.NTSB CHI00LA101Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Shelbyville, ILthe proper touchdown point and proper alignment not attained by the pilot. Contributing factors were the unmarked golf cart, color, and lack of a radio. Additional factors were the runway maintenance performed by the driver of the golf cart and the NOTAM(s)…NTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.NTSB IAD00LA030Accident · Serious injuriesLimited investigationFinal reportMaule M-4-220C · Lincoln Park, NJthe pilot's failure to maintain control during landing roll. A factor was the crosswind.NTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.NTSB NYC00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · East Haddam, CTThe private pilots failure to obtain the proper touchdown point and the CFI's delay in remedial action.NTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.NTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.NTSB NYC00LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHThe CFI's failure to perform remedial action in a timely manner which resulted in a hard landing during the practice autorotation. A factor in this accident was the CFI's lack of total experience as a flight instructor.NTSB CHI00LA096Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Bucklin, KSthe right main gear brake was binding for an undetermined reason which resulted in the pilot's inability to maintain directional control of the airplane.NTSB ANC00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe pilot's misjudgment of distance/altitude, and subsequent undershoot during landing. Factors in the accident were light snow precipitation, flat light conditions, snow-covered terrain, and the absence of a visual approach slope indicator.NTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…NTSB IAD00LA028Accident · No injuriesLimited investigationFinal reportBellanca B17-30A · Shenandoah, VAthe pilot's failure to maintain control during landing roll-out. A factor was the pilot's lack of total experience.NTSB DEN00LA068Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Las Cruces, NMThe pilot's failure to maintain directional control, resulting in an inadvertent ground loop/swerve. Factors were a burnt and unseated intake valve, and the tail wind.NTSB SEA00LA055Accident · No injuriesLimited investigationFinal reportCessna 180K · Roundup, MTThe pilot's failure to adequately compensate for wind conditions and subsequent loss of control.NTSB MIA00LA116Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Fort Lauderdale, FLThe pilot's failure to maintain directional control after touchdown and the subsequent wing tip strike, ground loop, and runway excursion.NTSB FTW00FA101Accident · Minor injuriesField investigationFinal reportSaab 340B · Killeen, TXthe captain's failure to follow standard operating procedure for landing on a contaminated ruway in that he touched down long, which combined with his delayed braking resulted in a runway overrun. Contributing factors were the captain's failure to maintain…NTSB LAX00LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1 · Scottsdale, AZThe pilot's failure to ensure that the landing gear was lowered before touchdown.NTSB DEN00FA063Accident · No injuriesField investigationFinal reportDornier 328-100 · Denver, COuncommanded retraction of the nose and right main landing gears during landing roll for reasons undetermined.NTSB CHI00LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Festus, MOthe pilot inadvertently retracted the landing gear instead of the flaps during the landing roll.NTSB NYC00FA092Accident · Minor injuriesField investigationFinal reportDassault DA-900 · Hyannis, MAThe flightcrew's inadequate coordination and improper weather evaluation. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length and his failure to obtain the proper touch down point on the runway.…NTSB MIA00LA110Accident · Minor injuriesLimited investigationFinal reportAeronca-Bubeck Irving BUBECK-AERONCA · Merritt Island, FLThe flight instructors inadequate supervision of the dual student resulting in the student pushing forward on the control stick during a bounced landing until the aircraft impacted the runway, bounced, landed hard, and broke the main landing gear.NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB SEA00LA052Accident · No injuriesLimited investigationFinal reportCessna A185-F · Bend, ORThe pilot's failure to adequately compensate for wind conditions.NTSB FTW00LA099Accident · No injuriesLimited investigationFinal reportCessna 402C · San Antonio, TXThe pilot's inadequate handling of the aircraft during the landing flare/touchdown resulting in a hard landing that collapsed the left main landing gear.NTSB DEN00LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Provo, UTThe pilot misjudging the flare. Factors were dark night conditions, and the pilot's lack of recent experience in the type of operation (night landings).NTSB DEN00LA060Accident · No injuriesLimited investigationFinal reportBeech B55 · Ogden, UTInadvertent landing gear retraction by person(s) undetermined. A factor was the inadequate supervision of the flight by the flight instructor.