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 DEN01LA114Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Provo, UTinadvertent retraction of the landing gear by the pilot rated student during landing roll. A contributing factors was the failure of the instructor to adequately supervise the student.NTSB SEA01LA114Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mattawa, WAThe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors were the gusty crosswind condition and the high vegetation (sage brush) which the aircraft rolled into before nosing over.NTSB FTW01LA138Accident · No injuriesLimited investigationFinal reportCessna 172M · Hot Springs, ARthe student pilot's delayed go-around, which resulted in the airplane impacting trees during the aborted landing.NTSB LAX01TA204Accident · No injuriesFinal reportGates Learjet LR-24A · Victorville, CAThe copilot inadvertently induced a lateral oscillation resulting in an in-flight loss of control. The pilot-in-command failed to adequately surpervise the copilot.NTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.NTSB NYC01LA137Accident · No injuriesLimited investigationFinal reportGraham Acro Sport · Hampton, NHA soft area in the turf runway, which resulted in a loss of directional control during the landing rollout.NTSB LAX01FA201Accident · No injuriesField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVfatigue failure of the right main landing gear retraction arm.NTSB IAD01LA063Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Louisville, KYThe flight instructor's failure to maintain directional control after landing.NTSB ATL01IA064Incident · No injuriesIncident investigationFinal reportBoeing 757 · Atlanta, GAThe pilots improper landing flare that resulted in the tail section collision with the runway.NTSB CHI01LA153Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Cambridge, MNThe pilot's inadequate compensation for the wind conditions and the failure to maintain control of the airplane. A factor associated with the accident were the trees that the airplane contacted during the aborted landing.NTSB LAX01LA202Accident · No injuriesLimited investigationFinal reportBeech 76 · Prescott, AZThe certified flight instructor's inadequate supervision of the student who failed to maintain adequate airspeed on approach, resulting in a stall/mush, and delayed remedial action when the flight instructor ordered a go-around.NTSB IAD01LA062Accident · No injuriesLimited investigationFinal reportEaa Chapter 40 Cubby Sport Trainer · Elkton, MDThe Cubby pilot's inadequate visual lookout for the Bellanca on the runway, prior to landing.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB ATL01LA086Accident · No injuriesLimited investigationFinal reportCessna R172-K · Culebras Island, PRPilots improper flare which resulted in a hard landing.NTSB SEA01LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Boise, IDThe pilot's failure to adequately compensate for wind conditions. Wind gusts were a factor.NTSB MIA01LA148Accident · No injuriesLimited investigationFinal reportCessna A188B · Humboldt, TNthe pilot's failure to maintain directional control of the aircraft during the landing rollout, resulting in a ground loop/ground swerve and substantial damage to the aircraft.NTSB ANC01LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alexander, AKThe instructor pilot's inadequate supervision of the flight. Factors in the accident were the dual student's selection of unsuitable terrain for landing, and the presence of a sand bar in the landing area.NTSB NYC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Clinton, MDThe pilot's failure to maintain directional control during landing rollout. Factors related to the accident were the pilot's lack of experience in tail-wheeled airplanes, and the wind gusts.NTSB ATL01LA061Accident · No injuriesLimited investigationFinal reportConrad Menzel SA-300 Starduster · Jackson, MSThe pilot failure to maintain directional control during a crosswind landing.NTSB DEN01LA104Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West Jordan, UTthe pilot inadvertently flaring the airplane too high above the ground, resulting in a hard landing that sheared a bolt in the tail wheel assembly. This rendered directional control impossible and induced an uncontrolled ground loop. A contributing factor was…NTSB SEA01LA104Accident · No injuriesLimited investigationFinal reportCurtis Lionheart · Bremerton, WAthe pilot's failure to ensure the aircraft's longitudinal axis was aligned with the runway prior to touchdown, and his failure to maintain directional control during the landing roll. Factors include landing with a tailwind, and the pilot's lack of recent…NTSB LAX01LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Cottonwood, AZthe student's inadequate compensation for the gusty crosswind conditions and the subsequent loss of aircraft control during landing roll. The flight instructor’s inadequate supervision and his inadequate remedial action is also causal. Contributing factors…NTSB FTW01FA127Accident · No injuriesField investigationFinal reportFokker F28 Mk 0100 · DFW Airport, TXA forging fold that was introduced during the manufacture of the right main landing, which resulted in a fatigue crack in the right main landing gear cylinder, and its subsequent failure during landing.NTSB LAX01LA189Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Reno, NVFailure of the left main landing gear axle due to an improper weld repair.NTSB FTW01LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Fort Worth, TXthe inadvertent ground loop during the landing roll. A contributing factor was the gusty crosswind.NTSB LAX01LA187Accident · Minor injuriesLimited investigationFinal reportBennett Glastar · Grass Valley, CAThe pilot's failure to arrest the excessive descent rate. A contributing factor was the gusty wind conditions.NTSB CHI01LA316Accident · No injuriesLimited investigationFinal reportCessna 172R · Alton, ILThe misjudged flare by the pilot.NTSB LAX01LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Concord, CAThe pilot's inadequate compensation for wind conditions, resulting in a loss of directional control and the inadvertent ground loop.NTSB CHI01LA134Accident · No injuriesLimited investigationFinal reportAir Tractor G-164A · Casselton, NDThe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. A factor was the collapse of the right main landing gear.NTSB DEN01LA099Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Sterling, COfailure by the pilot to control descent rate during approach to land. A factor was a temperature inversion.NTSB SEA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · McMinnville, ORThe student pilot's failure to adequately compensate for wind conditions while doing a touch-and-go landing.NTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB LAX01LA171Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Hollister, CAThe pilot's inadequate aircraft handling procedure and failure to maintain directional control while landing in a known crosswind.NTSB FTW01LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Decatur, TXthe flight instructor's failure to maintain directional control during the landing roll. A contributing factor was the left main wheel brake which was locked for an undetermined reason.NTSB DEN01LA097Accident · Minor injuriesLimited investigationFinal report1977 Colfer-Chan Steen Skybolt · Gallup, NMthe pilot's failure to maintain directional control during landing roll. Contributing factors were gusting crosswinds and the pilots's lack of experience in aircraft make and model.NTSB LAX01LA170Accident · No injuriesLimited investigationFinal reportAviat A-1B · Apex, NVThe pilot's failure to maintain directional control during landing rollout in a gusty and crosswind condition.NTSB IAD01LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe pilot's improper landing flare. A factor was the crosswind.NTSB LAX01LA175Accident · No injuriesLimited investigationFinal reportAviat A-1A · TontoNat.Forest, AZThe pilot's inadequate crosswind correction compensation during landing and his failure to maintain proper alignment with the usable runway. A contributing factor was the presence of bushes in proximity to the airstrip.NTSB LAX01LA169Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Angwin, CARight main landing gear brake lockup during landing rollout for undetermined reasons.NTSB CHI01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · West Chicago, ILThe inadequate compensation for the crosswind by the student pilot. Additional factors included the student pilot's lack of total flight time, the runway sign and the crosswind.NTSB CHI01FA136Accident · No injuriesField investigationFinal reportCessna 172S · Springfield, MOthe excessive touchdown airspeed by the pilot.NTSB ANC01LA055Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKA failure of the tailwheel spring assembly due to fatigue during touch and go landings. A factor in the accident was an inadequate annual inspection by maintenance personnel.NTSB LAX01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAthe student pilot's misjudged landing flare and improper use of the elevator control.NTSB SEA01LA096Accident · No injuriesLimited investigationFinal reportCessna 180A · Mercer Island, WAthe pilot's inadequate visual lookout during an approach and landing in open water. Factors include a large wave/swell at the location where the pilot elected to land his float-equipped airplane.NTSB SEA01LA086Accident · No injuriesLimited investigationFinal reportCessna U206 · Yamhill, ORthe pilot's failure to adequately compensate for gusty tailwind conditions, resulting in an excessive rate of descent at touchdown. Factors include gusty tailwinds during the landing sequence.NTSB SEA01LA091Accident · No injuriesLimited investigationFinal reportLet L-23 · Arlington, WAthe flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.NTSB SEA01LA084Accident · No injuriesLimited investigationFinal reportCessna U206F · Imnaha, ORThe pilot's inadequate compensation for the wind conditions. Wind gusts were a factor.NTSB LAX01LA183Accident · No injuriesLimited investigationFinal reportNorth American AT-6 D · Prescott, AZThe pilot's inadequate compensation for an existing crosswind condition.NTSB LAX01LA173Accident · No injuriesLimited investigationFinal reportAero Commander 112A · Riverside, CAFailure of the pilot to maintain directional control of the airplane during the landing roll. A factor was the worn nose wheel steering assembly.