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 DEN01LA014Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Longmont, COthe total failure of the left main gear strut during the landing roll. A contributing factor was the 6-foot high snow bank that the airplane impacted when it left the runway.NTSB SEA01LA018Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Great Falls, MTThe pilot's improper decision to land on unsuitable terrain. Factors include snow covered terrain.NTSB LAX01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Tucson, AZThe pilot's misjudged landing flare and improper recovery from the bounced landing resulting in the overload failure of the nose gear and the airplane nosing over.NTSB NYC01LA034Accident · No injuriesLimited investigationFinal reportCessna 180H · Long Lake, NYThe pilot's improper recovery from a bounced landing.NTSB MIA01LA025Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · St. Marys, GAThe pilot's failure to maintain directional control during landing, resulting in a sideward skid, a collapsed main landing gear strut, and wing strike.NTSB MIA01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Inverness, FLa loss of directional control on landing due to the pilot's failure to execute a proper flare and recovery from the resultant bounced landing, causing the airplane to depart the runway, enter the uneven grass infield, and sustain a nose over.NTSB SEA01LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hood River, ORThe pilot's failure to maintain directional control during landing.NTSB SEA01LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Spangle, WAThe pilot's inadequately executed remedial action and his failure to ensure that the aircraft touched down at the proper location. Factors include a dark night, an unlighted runway, and trees off the approach end of the runway.NTSB SEA01LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Waldron Island, WAThe pilot's improper distance/speed during the approach, which lead to an overrun during the landing roll and subsequent collision with trees. A factor was the trees beyond the upwind end of the runway.NTSB MIA01LA022Accident · No injuriesLimited investigationFinal reportHorne Bowers Flybaby · Greer, SCA runway overrun as a result of the pilot's failure to maintain proper approach speed and landing touch down point.NTSB MIA01LA020Accident · No injuriesLimited investigationFinal reportJohn S. Eberle Pitts Special S1S · Sebring, FLImproper inspection of the tailwheel assembly by the pilot which resulted in shimmy of the tailwheel assembly during landing due to a worn bearing caused by dirt infiltration which resulted in the pilot being unable to control the airplane and the airplane…NTSB DEN01LA008Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMthe pilot's failure to follow procedures/directives and lower the landing gear for landing. Contributing factors were the damaged propellers making it impossible to perform a go-around, the inadvertent stall to the runway, and the pilot being in a state of…NTSB CHI01LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Carrollton, MOthe misjudged touchdown point by the pilot. Factors were the runway lights not on, the dark night, and the plowed field.NTSB ANC01LA013Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Juneau, AKThe pilot's failure to refuel the airplane, and his inadequate preflight planning/preparation. A factor associated with the accident was the pilot's selection of an unsuitable landing area.NTSB MIA01LA019Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to maintain directional control during landing with a quartering tail wind, resulting in the aircraft nosing over and coming to rest inverted.NTSB MIA01LA018Accident · No injuriesLimited investigationFinal reportMooney M-20J · Deland, FLthe dual student's improper use of the brakes and the flight instructor's inadequate supervision which resulted in a loss of directional control and a subsequent ground swerve during which the aircraft exited the runway and collided with a runway sign.NTSB LAX01LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Ramona, CAThe dual student's habit interference, from his previous training in a different type of airplane, that precipitated his improper use of the elevator control during a go-around.NTSB ANC01FA011Accident · No injuriesField investigationFinal reportBeech 1900D · Bethel, AKThe flight crew's failure to maintain directional control during the landing roll. A factor associated with the accident was the crew's failure to follow appropriate procedures.NTSB MIA01LA014Accident · Minor injuriesLimited investigationFinal reportCraig R. Merrill Luton Beta · Ridgeland, SCThe pilot's failure to maintain airspeed on final approach resulting in the aircraft settling fast, touching down hard, and colliding with an embankment on the side of the runway, where it came to rest inverted.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB CHI01LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pulaski, WIthe evasive maneuver initiated by the pilot. Factors were the presence of the skydiver on the runway, and the pilot's selection of a closed runway.NTSB CHI01LA028Accident · No injuriesLimited investigationFinal reportPiper PT-46 · Eden Prairie, MNthe pilot misjudging the landing flare, and his failure to recover from the bounced landing.NTSB SEA01LA006Accident · No injuriesLimited investigationFinal reportCessna 185F · Driggs, IDThe pilot's failure to maintain directional control. Factors include soft terrain adjacent to the runway.NTSB IAD01LA004Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Berryville, VAThe pilot's improper flare, which resulted in a hard landing and separation of the nose landing gear.NTSB NYC01LA018Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ridgeway, VAThe pilot's failure to maintain proper runway alignment during the landing roll. A factor in this accident was a slight bend in the runway.NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.NTSB NYC01LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHThe pilot's failure to maintain directional control while landing with a crosswind. Factors in the accident were the pilot's lack of familiarity in the make and model airplane, and the crosswind conditions.NTSB MIA01LA005Accident · Serious injuriesLimited investigationFinal reportArthur P. Matthews Acro Sport II · Huntersville, NCthe pilot's misjudgment of the distance/speed and failure to attain the proper touchdown point or affect a timely go-around which resulted in the aircraft overrunning the runway and incurring substantial damage when it ran into a streambed.NTSB LAX01LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sedona, AZThe pilot's inadequate compensation for wind conditions while on short final landing approach. A factor was the unfavorable wind condition.NTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB LAX01LA016Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-BH · Hilo, HIInadequate maintenance by the helicopter manufacturer during manufacture, which installed skins of inadequate thickness on the tail boom. A factor in the accident was the failure of the manufacturer's quality control system to detect the inadequate thickness.NTSB IAD01LA003Accident · Minor injuriesLimited investigationFinal reportPitts S-1A · Mount Pocono, PAPilot's inadequate compensation for wind conditions during landing. A factor was the crosswind.NTSB LAX01LA010Accident · No injuriesLimited investigationFinal reportCessna 170B · San Carlos, CAThe pilot's improper and excessive application of brakes resulting from his failure to maintain directional control during landing rollout.NTSB ANC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-A36 · Nondalton, AKThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB CHI01LA008Accident · No injuriesLimited investigationFinal reportWalton RV-6 · Saint Paul, MNThe rudder tube failure, and aircraft control not possible during the flare by the pilot. A factor was the service bulletin not being complied with by the mechanic during the condition inspection.NTSB CHI01LA007Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Highland, ILthe designated examiner not maintaining clearance from the bank/dike. Factors were the designated examiner's delayed remedial action and the bank/dike.NTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.NTSB SEA01LA003Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Twin Falls, IDThe pilot's failure to maintain adequate rotor rpm. Unsuitable terrain was selected for the maintenance test flight operation.NTSB NYC01LA008Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Fork Union, VAThe pilot's inadequate flare which resulted in a hard landing. A factor related to the accident was the uneven landing area condition.NTSB NYC01LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Shirley, NYThe pilot's failure to maintain directional control during an aborted landing.NTSB SEA01LA002Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Hillsboro, ORClearance from an obstruction was not maintained during the go-around. The pilot's failure to maintain directional control during the landing roll was a factor.NTSB LAX01LA005Accident · Serious injuriesLimited investigationFinal reportGalaxy Balloons Galaxy 7 · Inyokern, CAThe pilot's hard landing during a high wind condition.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB LAX01LA008Accident · No injuriesLimited investigationFinal reportCessna 172H · Hilo, HIAn inadvertent pilot-induced porpoise resulting from the pilot's improper landing flare and inadequate power management.NTSB LAX01LA009Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · El Cajon, CAImproper torquing procedure of the aft tail rotor drive shaft coupling by maintenance personnel after tracking the tail rotor.NTSB ATL01LA005Accident · Serious injuriesLimited investigationFinal reportAlvin R. Kemmet Tango 2 · New Port Richey, FLThe uncertified pilot's improper recovery from a bounced landing which resulted in the collapse of the nose gear asasembly and subsequent nose over. Factors were the pilot's lack of certification and the runway light.NTSB NYC01FA001Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Seven Springs, PAThe pilot's improper recovery from a bounced landing.NTSB DEN01LA001Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Ogden, UTThe pilot's failure to maintain a proper descent rate during landing flare/touchdown. A factor was the tail wheel failure due to overload.NTSB ATL01LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Boone, NCThe pilot's misjudgment of speed and distance which resulted in an overrun of the runway. A contributing factor was the tailwind condition.NTSB LAX00TA355Accident · No injuriesFinal reportHughes TH-55A · Phoenix, AZthe flight instructor's misjudged flare during a simulated autorotation, which led to a hard landing.