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 WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB ERA11CA482Accident · No injuriesData collectionFinal reportQuestair Venture · Memphis, TNThe pilot's inability to maintain directional control during landing with a flat tire. Contributing to the accident was the failure of the left main landing gear tire for undetermined reasons.NTSB CEN11WA628Accident · No injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.NTSB WPR11FA426Accident · Serious injuriesField investigationFinal reportEnstrom 280FX · Heber City, UTThe pilot’s failure to ensure that there was sufficient fuel onboard to conduct the flight, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the severity of the passengers’ injuries was the operator’s failure to provide…NTSB WPR11CA433Accident · No injuriesData collectionFinal reportSherman Craig W Glasair III · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll, as a result of a flat left main landing gear tire.NTSB WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.NTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.NTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.NTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…NTSB CEN11CA670Accident · No injuriesData collectionFinal reportCessna 140 · Conroe, TXThe pilot's excessive use of brakes during the landing.NTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.NTSB ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.NTSB ERA11CA517Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Stonington, METhe pilot's inadequate landing flare, which resulted in a hard landing during crosswind conditions.NTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR11CA414Accident · No injuriesData collectionFinal reportMaule M-6-235 · Hailey, IDThe pilot’s failure to maintain directional control during the landing rollout in a gusty, crosswind condition.NTSB ENG11IA047Incident · No injuriesIncident investigationFinal reportEmbraer EMB145 · Moline, ILThe uncommanded left deflection of the airplane's nose wheel likely due to seal deterioration and subsequent contamination within the Electrohydraulic Servo Valve (EHSV). Contributing to the incident was the undersized condition of the filter plugs within the…NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB CEN11CA604Accident · No injuriesData collectionFinal reportCessna 172M · Plymouth, MIThe pilot's failure to perform a go-around when the airplane was not in a position to make a safe landing and his excessive use of bank control during the landing attempt, which resulted in the wing striking the ground.NTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.NTSB WPR11LA436Accident · No injuriesLimited investigationFinal reportTubbs S/Performance PA-18 225DD · Mile Hi Landing Strip, IDThe collapse of the left landing gear during landing for undetermined reasons.NTSB CEN11LA595Accident · No injuriesLimited investigationFinal reportCessna 140 · Monmouth, ILThe pilot's loss of airplane control during the landing roll.NTSB CEN11CA640Accident · No injuriesData collectionFinal reportCessna T210M · Cahokia, ILA failure of a spring in the main landing gear actuation system that prevented the landing gear from extending.NTSB ERA11CA471Accident · No injuriesData collectionFinal reportPayne/Foster Glasair · Ocala, FLThe failure of the tailwheel locking mechanism to remain engaged while landing in a crosswind, which resulted in a loss of directional control and runway excursion.NTSB ANC11CA085Accident · No injuriesData collectionFinal reportMaule M-5-210C · Tok, AKThe pilot's failure to go-around soon enough to preclude the necessity of a forced landing due to the airplane's inability to outclimb ascending terrain.NTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.NTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR11CA406Accident · No injuriesData collectionFinal reportCessna A185F · Polson, MTThe pilot's failure to maintain directional control during landing.NTSB CEN11CA590Accident · No injuriesData collectionFinal reportRans Designs S-7LS · Joplin, MOThe pilot's failure to maintain aircraft control during the landing.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB ANC11LA084Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKA loss of directional control during landing due to a rock lodged in the main landing gear wheel brake, resulting in a runway excursion and collision with terrain.NTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.NTSB ANC11CA083Accident · No injuriesData collectionFinal reportCessna 180A · Igiugig, AKThe pilot's decision to take off in a variable wind, resulting in a shallow climb and collision with terrain.NTSB WPR11CA396Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Casper, WYThe pilot's failure to maintain directional control during landing.NTSB ERA11LA466Accident · No injuriesLimited investigationFinal reportPiper PA46 · Manasses, VAAn undetermined nose landing gear steering anomaly or anomalies, which resulted in the pilot's inability to maintain directional control of the airplane during the landing rollout. The damage to the nose landing gear precluded a determination of the cause of…NTSB WPR11LA405Accident · No injuriesLimited investigationFinal reportJuneau Stol CH-701 · Snohomish, WAThe pilot's improper landing flare, which resulted in a stall and a hard landing.NTSB ERA11CA465Accident · No injuriesData collectionFinal reportLet L 33 Solo · Wakefield, VAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing.NTSB CEN11LA596Accident · No injuriesLimited investigationFinal reportSuminski Walter M Jabiru SP · Columbia, ILSeparation of the right main wheel during landing rollout for undetermined reasons.NTSB ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN11LA579Accident · No injuriesLimited investigationFinal reportCessna 180 · Stillwater, OKThe pilot's on-ground loss of control during the landing roll upon encountering a sudden wind shift and gust.NTSB WPR11LA384Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Oakesdale, WAThe pilot's decision to land with a high tailwind, which resulted in a nose-over.NTSB ERA11CA452Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Front Royal, VAThe pilot’s failure to attain the proper touchdown point.NTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.NTSB ANC11CA076Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · Coldfoot, AKThe pilot's inadvertent application of the right brake pedal during the landing roll, which resulted in a nose-over.