NTSB investigations
53,702 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 ERA24FA266Accident · Serious injuriesClass 3 · FieldFinal reportLockheed 12 · Jackson, GAMaintenance personnel’s failure to properly secure the right brake line, which resulted in a loss of right brake effectiveness during the landing roll and a subsequent runway excursion.NTSB DCA24WA215OccurrenceClass 5 · ForeignBoeing 737 · Suvarnabhumi, ThailandNTSB GAA24WA192Accident · No injuriesClass 5 · ForeignCessna 172 · Norfolk, United KingdomNTSB ERA24LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Smithfield, NCThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.NTSB CEN24LA224Accident · No injuriesClass 4 · LimitedFinal reportJonker Sailplanes JS3 RES · Elbert, COThe pilot’s failure to maintain directional control during the landing with a right crosswind.NTSB CEN24LA225Accident · No injuriesClass 4 · LimitedFinal reportRobert L Staton Javron INC PA-18 REP · Schell City, MOThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway surface.NTSB ERA24LA264Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6 · Townsend, DEAn inadvertent encounter with rough or soft terrain during landing, resulting in a bent nose landing gear leg and subsequent nose over.NTSB CEN24LA234Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20J · Ava, MOThe pilot’s failure to maintain control of the airplane resulting in a runway excursion during landing. Contributing to the accident was the degraded brake system on the airplane.NTSB WPR24LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Fernley, NVThe pilot’s failure to maintain directional control during gusting wind conditions.NTSB ERA24LA281Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Chesapeake, VAThe pilot’s improper recovery from a bounced landing.NTSB CEN24LA223Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Eaglesnest, MSThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Ada, OKThe student pilot’s failure to maintain directional control during landing resulting in a runway excursion and impact with a sign.NTSB ERA24LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Painted Post, NYThe pilot’s failure to maintain directional control of the airplane during an aborted landing, which resulted in runway excursion and collision with a ditch.NTSB ERA24LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Selma, ALThe pilot receiving instruction’s improper landing flare which resulted in a hard landing and subsequent landing gear collapse.NTSB DCA24WA208Incident · No injuriesClass 5 · ForeignBoeing 747 · Incheon, South KoreaNTSB CEN24LA227Accident · Minor injuriesClass 4 · LimitedFinal reportBeech D55 · Colorado Springs, COThe deflated right main landing gear tire due to a sidewall puncture made by an unknown object, which led to the pilot’s loss of directional control and the landing gear collapse during landing roll.NTSB CEN24LA217Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH 750 · Caney, TXThe pilot’s improper landing flare, which resulted in a hard landing,NTSB ANC24LA050Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Bethel, AKThe pilot's failure to maintain directional control during landing which resulted in a ground loop.NTSB GAA24WA244AccidentClass 5 · ForeignViking DH 6 - 300 · Miriandhoo, Baa Atoll, MaldivesNTSB CEN24LA214Accident · Minor injuriesClass 4 · LimitedFinal reportStinson Vultee V-77 · Slaton, TXThe pilot’s failure to maintain directional control after landing in gusting wind conditions which resulted in a runway excursion and the airplane nosing over. Contributing was the pilot’s decision to conduct the flight in very strong, gusting wind conditions.NTSB WPR24LA189Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Italia S R L Alpha Trainer · Paso Robles, CAThe pilot’s exceedance of the airplane’s critical angle of attack that resulted in an aerodynamic stall and subsequent loss of control on final approach. Contributing to the accident was the pilot’s decision to land with a tailwind.NTSB ERA24LA280Accident · No injuriesClass 4 · LimitedFinal reportLancair LC42-550FG · Beaufort, NCThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway overrun.NTSB ERA24LA255Accident · Minor injuriesClass 3 · LimitedFinal reportTitan T51 · Madisonville, TNThe failure of the right main landing gear weldment due to fatigue cracking.NTSB ERA24LA253Accident · No injuriesClass 4 · LimitedFinal reportDavis Lightning · Jamestown, TNThe non-certificated pilot’s failure to maintain control of the airplane during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ENG25WA006IncidentClass 5 · ForeignDe Havilland DHC6 · Kikori, Papua New GuineaNTSB CEN24LA219Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-23H-15 · Chouteau, OKThe student pilot’s failure to maintain control of the glider while landing. Contributing to the accident was the unclear communications between the student pilot and instructor.NTSB CEN24LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Shuteston, LAThe pilot failure to maintain directional control while landing on a wet grass strip.NTSB ANC24LA047Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Nenana, AKThe pilot providing instruction’s delayed remedial action, resulting in a loss of control during landing roll.NTSB DCA24WA282IncidentClass 5 · ForeignMcdonnell Douglas MD 83 · Santa Clara, CubaNTSB ANC24LA051Accident · No injuriesClass 4 · LimitedFinal reportMorgan Edward L Edge X 582 · Fairbanks, AKThe pilot’s selection of an unsuitable landing site, resulting in a collision with a hole during landing rollout.NTSB WPR24LA168Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Hooper, UTThe inadvertent application of brakes during landing that resulted in a nose over.NTSB WPR24LA166Accident · No injuriesClass 4 · LimitedFinal reportThomas J Spencer RV-10 · Snohomish, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway overrun.NTSB ERA24LA242Accident · Serious injuriesClass 4 · LimitedFinal reportHughes 269A · Danbury, NHThe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of control during landing.NTSB ANC24LA048Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Bethel, AKThe uncertificated pilot’s decision to fly an unairworthy airplane and his failure to maintain directional control during landing, which resulted in a landing gear collapse. Contributing was the failure of the right main landing gear oleo strut.NTSB ANC24LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 170A · Willow, AKThe pilot’s failure to maintain directional control during landing roll, resulting in a ground loop and substantial damage to the airplane.NTSB WPR24LA177Accident · No injuriesClass 3 · LimitedFinal reportBanes John Scott Kitfox Series 6 · Parowan, UTThe pilot’s inability to control the airplane during landing due to tailwheel assembly damage sustained during a previous shimmy event that occurred for reasons that could not be determined based on the available evidence.NTSB WPR24LA176Accident · No injuriesClass 4 · LimitedFinal reportOklahoma Fat Tire Flyers CCX-2000 · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in aground loop.NTSB ERA24LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Greensboro, NCThe pilot's improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB DCA24WA198AccidentClass 5 · ForeignAirbus A320 · Christchurch, New ZealandNTSB ANC24LA039Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor’s failure to implement the correct action for low rotor RPM recovery.NTSB WPR24LA169Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Hillsboro, ORThe pilot’s failure to maintain direction control during the landing roll with a left crosswind.NTSB CEN24LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Forest Lake, MNThe flight instructor’s delayed remedial action and failure to maintain aircraft control during the simulated forced landing.NTSB WPR24LA170Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · McCall, IDThe pilot’s failure to maintain directional control during the landing roll with a gusty right crosswind.NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.NTSB WPR24LA164Accident · No injuriesClass 4 · LimitedFinal reportBoeing-Stearman PT-17 · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC24LA041Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Knik, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB WPR24LA165Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Rome, ORThe pilot’s failure to maintain airplane control during landing.NTSB GAA24WA203IncidentClass 5 · ForeignCessna 210 · Bankstown, AustraliaNTSB ERA24LA231Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Pierson, FLThe flight instructor’s failure to attain a proper touchdown point during a precautionary landing, which resulted in a runway excursion during landing.