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 DEN06CA049Accident · No injuriesData collectionFinal reportStinson 108-1 · Limon, COthe pilot's failure to maintain aircraft control during the aborted landing resulting in an impact with a ditch. Contributing factors were the gusty wind conditions and the pilot's improper compensation for the wind conditions during landing.NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.NTSB LAX06CA127Accident · No injuriesData collectionFinal reportCessna 140 · Mesa, AZthe pilot's improper use of the flight controls during landing, which resulted in a nose over.NTSB LAX06CA128Accident · No injuriesData collectionFinal reportCirrus SR22 · Scottsdale, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB DEN06CA047Accident · Minor injuriesData collectionFinal reportBoeing D75N1 · Santa Teresa, NMthe pilot's failure to maintain directional control during the landing. Contributing factors include the high airspeed, the improper recovery from a bounced landing, the crosswind, and the soft dirt.NTSB NYC06CA077Accident · No injuriesData collectionFinal reportCessna 172S · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point, which resulted in an overrun of the runway.NTSB ANC06CA033Accident · No injuriesData collectionFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane colliding with a snowbank and nosing over.NTSB MIA06CA059Accident · No injuriesData collectionFinal reportPiper PA-18 · SanJuan, PRThe pilot's failure to maintain directional control during landing.NTSB NYC06IA075Incident · No injuriesIncident investigationFinal reportDassault Falcon 900EX · Teterboro, NJThe co-pilot's failure to obtain the proper touchdown point, which resulted in an overrun. Contributing were the gusty wind conditions, the failure of the flight crew to utilize the air brake after touchdown, and a partially contaminated runway.NTSB NYC06CA183Accident · No injuriesData collectionFinal reportCessna 180H · Blue Bell, PAThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in the right wing contacting the runway. A factor was the crosswind.NTSB ATL06CA046Accident · No injuriesData collectionFinal reportCessna 172L · Long Island, NCThe student pilot's failure to achieve the proper touch down point on landing resulting in an overrun, on-ground collision with a ditch, and subsequent nose over. A factor in the accident was the inadequate supervision of the student pilot by the flight…NTSB ANC06CA031Accident · No injuriesData collectionFinal reportRobinson R22 · Anchorage, AKThe pilot's decision to land the helicopter on an icy airport parking ramp, which resulted in a loss of control on touchdown, and subsequent collision with another parked and unoccupied helicopter.NTSB LAX06CA119Accident · No injuriesData collectionFinal reportBeech 95 · Kingman, AZthe flight instructor's failure to perform the before landing checklist and extend the landing gear prior to touchdown. A contributing factor was the pilot's diverted attention with another airplane that had departed from the opposite runway.NTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.NTSB MIA06LA057Accident · No injuriesLimited investigationFinal reportCessna 525A · Tampa, FLFailure of both the left main and auxiliary brake lines due to fatigue cracking, rendering directional control impossible. A contributing factor in this accident was the airport sign concrete pad.NTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.NTSB MIA06LA055Accident · No injuriesLimited investigationFinal reportBeech C90A · Tampa, FLThe collapse of the right main landing gear for an undetermined reason during the landing roll, which resulted in a collision with the runway. A factor contributing to the accident was the pilot's failure to follow the published emergency/abnormal procedures.NTSB MIA06CA053Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe improper landing flare by the pilot-rated student and the inadequate supervision of the pilot-rated student by the certified flight instructor, resulting in the improper touchdown of the helicopter and the helicopter rolling over.NTSB MIA06LA052Accident · No injuriesLimited investigationFinal reportCessna 501 · Fort Pierce, FLmechanical binding of the normal brake system, rendering directional control impossible. Contributing factors were the improper overhaul, inadequate quality control procedures by the overhaul facility, and the rough terrain.NTSB LAX06LA112Accident · Minor injuriesLimited investigationFinal reportGlobe Swift GC-1A · Rancho Murieta, CAthe pilot's failure to maintain directional control of the airplane on the landing roll.NTSB CHI06CA083Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe solo student pilot's failure to properly compensate for the crosswind, resulting in his failure to maintain directional control during landing. Factors were the crosswind and the snow bank.NTSB MIA06LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Sarasota, FLThe collapse of the nose landing gear for undetermined reasons.NTSB MIA06CA129Accident · No injuriesData collectionFinal reportTharp S Richard Challenger II · Apopka, FLThe pilot's inadequate selection of a landing area which resulted in one of the seaplane's floats impacting a submerged stump.NTSB DEN06LA038Accident · No injuriesLimited investigationFinal reportCanadair CL-600 · Aspen, COthe flight's encounter with wake turbulence from the departing airplane resulting in the pilot's inability to control the airplane and the subsequent impact with the runway.NTSB CHI06CA079Accident · No injuriesData collectionFinal reportSocata TBM 700 · Canton, OHThe pilot failed to flare the airplane properly.NTSB ATL06LA041Accident · No injuriesLimited investigationFinal reportCessna 500 · Burnsville, NCThe pilot's misjudged distance/altitude that led to an undershoot and the pilot's failure to attain the proper touchdown point.NTSB ATL06CA040Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Burlington, NCThe pilot's misjudgment of altitude/distance which resulted in an undershoot of the runway and subsequent impact with the runway collapsing the main landing gear.NTSB SEA06CA048Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, IDThe failure of the left main landing gear attaching bolt, which resulted in the left main gear collapsing during the landing roll.NTSB NYC06CA067Accident · No injuriesData collectionFinal reportPergerson Highlander · Appomattox, VAThe pilot's failure to maintain directional control during landing. A factor in the accident was the pilot's improper use of flaps.NTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.NTSB DFW06CA061Accident · No injuriesData collectionFinal reportMaule M-7-260C · Lakeview, ARThe pilot's failure to compensate for existing wind conditions during the landing roll. Contributing factors were the prevailing crosswind, and wet terrain.NTSB LAX06CA083Accident · No injuriesData collectionFinal reportPiper J5 · Carefree, AZthe pilot's selection of unsuitable terrain for the precautionary landing and failure to avoid obstacles during the landing roll.NTSB DFW06LA060Accident · No injuriesLimited investigationFinal reportCessna 175 · Lindsay, OKThe hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…NTSB DFW06CA062Accident · No injuriesData collectionFinal reportEurocopter France AS-350-B2 · Port Isabel, TXThe pilot's failure to maintain rotor RPM and his improper touchdown during a simulated hovering autorotation. A contributing factor was the flight instructor's delayed remedial action.NTSB DEN06LA035Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe student pilot's improper flare, resulting in a hard landing. Contributing factors were the flight instructor's inadequate supervision of the pilot, and the dark night light conditions.NTSB DFW06CA058Accident · No injuriesData collectionFinal reportBell 206L-4 · Fort Worth, TXThe flight instructors failure to maintain main rotor RPM and improper flare, which resulted in a hard landing.NTSB SEA06MA047Accident · 4 fatalMajor investigationFinal reportCessna 560 · Carlsbad, CAThe captain's delayed decision to execute a balked landing (go-around) during the landing roll. Factors contributing to the accident include the captain's improper decision to land with a tailwind, his excessive airspeed on final approach, and his failure to…NTSB MIA06CA047Accident · No injuriesData collectionFinal reportCessna 152 · Lantana, FLThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in the nosegear collapsing, the airplane veering off the runway, and nosing over.NTSB NYC06CA058Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lincoln Park, NJThe pilot's failure to maintain directional control during an aborted landing.NTSB NYC06CA057Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Haven, CTThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of aircraft control during landing and subsequent impact with a ditch.NTSB NYC06CA059Accident · No injuriesData collectionFinal reportCessna R182 · Bedford, MAThe pilot's improper flare resulting in a hard landing. A factor in the accident was the wind gusts.NTSB MIA06CA046Accident · No injuriesData collectionFinal reportPiper PA-46/Jetprop · Tampa, FLThe pilot's improper flare.NTSB DFW06CA059Accident · No injuriesData collectionFinal reportPietenpol Aircamper · Lometa, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the sun glare and the rough and uneven landing area.NTSB MIA06LA048Accident · No injuriesLimited investigationFinal reportCessna 310N · Destin, FLThe down limit switch, which operates the landing gear mechanical stop, was bent in the up position and allowed the gear motor to continued to run, causing the gearbox to over-travel, pull on the landing gear rods, and retract the landing gear.NTSB CHI06CA068Accident · No injuriesData collectionFinal reportCessna 310Q · Griffith, INThe overload failure of the right main landing gear locking mechanism due to undetermined reasons.NTSB CHI06CA065Accident · No injuriesData collectionFinal reportPiper PA-28-161 · West Branch, MIAn encounter with a deer during landing.NTSB ATL06CA034Accident · No injuriesData collectionFinal reportLabarre Hatz CB1 · Walhalla, SCThe pilot's selection of unsuitable terrain to land. Contributing factors were the wet, soft, grassy runway.NTSB CHI06LA281Accident · No injuriesLimited investigationFinal reportUnivar Ercoupe · Howell, MIThe student pilot's improper landing flare and lack of total experience.NTSB LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.NTSB LAX06CA085Accident · Minor injuriesData collectionFinal reportPiper Seneca · Van Nuys, CAThe pilot's failure to maintain directional control during landing. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.