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 NYC89LA087Accident · No injuriesLimited investigationFinal reportCessna 172RG · Durhamville, NYFailure of the pilot to extend the landing gear before landing after allowing his attention to be diverted.NTSB ATL89LA092Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot delayed his landing/touchdown, misjudged the distance of the remaining runway and did not go around. The slick/thawing runway conditions and the fences were contributing factors.NTSB MIA89LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Lauderdale, FLFaulty installation of avionics equipment which caused wiring in the landing gear system to be improperly reinstalled.NTSB CHI89LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Quincy, ILThe pilot's failure to achieve a proper touchdown point and to maintain adequate visual lookout during the landing.NTSB SEA89LA061Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35J · Spokane, WAThe failure of the pilot to maintain directional control and runway alignment during the landing roll. Factors related to the accident were: light conditions at dawn, snow and ice on the runway, and the runway lights.NTSB ATL89LA089Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wilmington, OHThe failure of the pilot to adequately compensate for wind conditions, to maintain proper runway alignment, and his delay in aborting the landing. Contributing factors were: variable crosswind conditions and a small tree.NTSB NYC89FA085Accident · Serious injuriesField investigationFinal reportDassault/Sud FAN JET Falcon D · Binghamton, NYImproper planning/decision by the pilot(s). Factors related to the accident were: icy runway conditions and failure of the drag chute to properly open after it was deployed.NTSB ANC89LA044Accident · No injuriesLimited investigationFinal reportPiper J-5 · Skwentna, AKThe pilot's selection of unsuitable terrain. A contributing factor is the pilot's lack of experience in off airport landings.NTSB LAX89LA108Accident · No injuriesLimited investigationFinal reportMooney M20J · San Martin, CAFailure of the student to follow instructions and inadequate supervision of the flight by the CFI which resulted in adequate airspeed not being maintained by the CFI. During an attempted go-around.NTSB DEN89LA077Accident · No injuriesLimited investigationFinal reportBalloon Works AX8-24 · Telluride, COIce forming in the fuel tank shut off valve, and the burner blast valve resulting in a loss of control during landing.NTSB MKC89LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNPremature raising of flaps and the failure of the instructor pilot to maintain runway alignment during the attempted go around.NTSB LAX89LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Sacramento, CAThe pilot's selection of the wrong runway for landing and his delay in initiating a go-around after landing long. Contributing factors were: light conditions as dusk and a tailwind.NTSB LAX89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZThe pilot's failure to raise the wing flaps during the aborted landing, and his failure to maintain airspeed during the climbing right turn.NTSB CHI89LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Stevens Point, WIFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.NTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…NTSB MIA89LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLLocking of the left brake, which resulted in a ground swerve and loss of control during the landing roll.NTSB LAX89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Flagstaff, AZThe pilot's failure to maintain proper runway alignment while expediting to exit the runway. His lack of experience in this type of aircraft, self-induced pressure & the snow covered terrain were contributing factors.NTSB DEN89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COFailure of the dual student to maintain directional control and the failure of the pilot in command (CFI), to provide adequate remedial action in a timely manner, to correct the swerve. A second probable cause was the cfi's failure to provide adequate…NTSB DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.NTSB LAX89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Novato, CAFire in the engine compartment area for undetermined reasons.NTSB FTW89LA046Accident · No injuriesLimited investigationFinal reportCessna 180B · Nocona, TXThe pilot's disregard of the aircraft performance data/operational limitations by landing in excess of the crosswind capability of the aircraft, and the resultant loss of directional control during the landing roll.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.NTSB SEA89LA043Accident · No injuriesLimited investigationFinal reportGulfstream 112TCA · Reno, NVThe failure of the pilot to maintain control of the airplane and the cfi's inadequate supervision of the pilot.NTSB NYC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Seneca Falls, NYFailure of the pilot of the C-150, N17109, to maintain proper separation from other aircraft during landing at an uncontrolled airport.NTSB MIA89LA075Accident · No injuriesLimited investigationFinal reportCessna T310R · Pensacola, FLFailure of the pilot to maintain the proper airspeed during the approach resulting in landing short of the runway and failure to maintain directional control during the landing roll.NTSB LAX89DVG03Accident · Minor injuriesFinal reportEaa WAG-AERO Sport · Placerville, CAThe student's improper application of brakes during the touchdown/flare phase of the landing causing the aircraft to nose over.NTSB MIA89LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLFailure of the pilot to flare for landing and improper recovery from a bounced landing.NTSB ANC89LA038Accident · No injuriesLimited investigationFinal reportCessna 207 · Kalskag, AKThe pilot failed to properly align the airplane on the runway for landing, then failed to maintain directional control after landing. Contributing to the accident was the pilots operation of the airplane with an inoperative landing light and the dark night…NTSB SEA89LA037Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Townsend, WAImproper approach and flare technique on the part of the pilot, resulting in a hard landing. Contributing to the accident were tall trees surrounding the airstrip.NTSB LAX89LA096Accident · No injuriesLimited investigationFinal reportCessna 150H · Napa, CAThe cfi's delay in aborting the takeoff, leading to a loss of directional control.NTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…NTSB NYC89LA071Accident · No injuriesLimited investigationFinal reportMooney M20J · Lumberton, NJFailure of the pilot to maintain directional control during a touch-and-go, which resulted in an inadvertent ground swerve. The presence of trees near the runway was considered to be a factor.NTSB CHI89MA047Accident · No injuriesMajor investigationFinal reportDassault-Breguet Falcon 900 · South Bend, INFailure of the thrust reverser actuator links due to a manufacturing/design problem. Factors related to the accident were: the adverse runway conditions and the crosswind.NTSB DEN89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Medicine Lake, MTSelection of unsuitable terrain by the pilot, resulting in a collision with snowdrifts during landing ground run.NTSB LAX89LA089Accident · No injuriesLimited investigationFinal reportCessna 190 · Sonoma, CAA jammed brake mechanism resulting in the pilot's inability to maintain directional control.NTSB DEN89LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMImproper use of brakes which resulted in an inadvertent ground swerve.NTSB ATL89DEK01Accident · No injuriesFinal reportCessna 182Q · Columbus, OHThe pilot's improper flared and improper recovery from a bounced landing. A factor related to the accident was: the gusty wind condition.NTSB LAX89LA085Accident · No injuriesLimited investigationFinal reportCessna TR182 · Oakland, CAPrevious damage due to previous hard landing.NTSB ATL89LA077Accident · No injuriesLimited investigationFinal reportBeech 58 · Walnut Cove, NCThe pilot made the landing approach too high and too fast for the available runway, and failed to abort the landing. The fence was a related factor.NTSB MKC89LA052Accident · No injuriesLimited investigationFinal reportStinson 108-1 · South St. Paul, MNThe failure of the pilot to maintain directional control of the airplane. Contributing to the accident were the crosswind conditions.NTSB ATL89LA076Accident · No injuriesLimited investigationFinal reportBeech A90 · Montgomery, ALThe instructor pilot (CFI) inadvertently actuated the landing gear handle to the up position.NTSB BFO89LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Ashland, VAThe pilot's failure to maintain directional control of the airplane during landing and the failure to achieve sufficient airspeed during the go-around to initiate a climb.NTSB ANC89LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Port Lions, AKThe pilots inadequate compensation for wind conditions which resulted in a stall/mush and subsequent hard landing. The downdraft which the aircraft encountered was a factor in the accident.NTSB NYC89LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Shirley, NYA poorly planned final approach, an improper landing flare, and failure of the pilot to correct a bounced landing.NTSB NYC89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Turners Falls, MALoss of control during landing roll due to ice on the runway, and collision with a snow bank off the runway which sheared the left main landing gear.NTSB MIA89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Terra Ceia, FLThe improper in-flight planning/decision by the student pilot. Factors related to the accident were: tailwind conditions during the landing and the proximity of the ditch to the selected landing area.NTSB DEN89IA060Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-7-102 · Gunnison, COThe fatigue failure of the down lock mechanism resulting from the non-compliance with a service bulletin by company maintenance personnel.NTSB SEA89LA033Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKImproper flare attitude at touchdown, causing the left float to dig into the water.NTSB SEA89LA032Accident · No injuriesLimited investigationFinal reportCessna 185F · Juneau, AKThe misjudgement of the runway conditions on the part of the pilot prior to landing. Contributing to the accident were deep snow on the runway, box canyon configuration of the area precluding runway overflight, marginal weather/light conditions for assessing…NTSB MKC89LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Audubon, IAThe failure of the pilot to maintain control of the airplane. Contributing to the accident were the crosswind conditions.