NTSB investigations
53,700 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 OPS25LA005IncidentClass 3 · LimitedPreliminary reportBoeing 737-7H4 · Long Beach, CAOn October 19, 2024, at 1450 pacific daylight time (PDT), a Diamond DA40, N895AM, and a Boeing 737-7H4, N250WN, operated as SWA1671, were involved in a runway incursion in Long Beach, CA. There were no injuries reported and none of the aircraft were damaged.…NTSB CEN25LA024Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2A · Stoughton, WIThe pilot’s failure to maintain directional control during landing.NTSB DCA25WA010AccidentClass 5 · ForeignAirbus A321 · Dublin, IrelandNTSB ERA25LA034Accident · No injuriesClass 4 · LimitedFinal reportHunt Exec 162F · North East, PAThe pilot’s failure to maintain control of the helicopter during landing following an encounter with an unanticipated wind gust, which resulted in a dynamic rollover.NTSB ERA25LA021Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Sanford, METhe pilot’s failure to maintain directional control during the landing roll, resulting in a runway excursion and collision with terrain.NTSB CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…NTSB CEN25LA017Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Shreveport, LAThe pilot’s inadvertent failure to lower the landing gear before touching down.NTSB CEN25LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · New Orleans, LAThe failure of a landing gear torque arm which resulted in a landing gear collapse and runway excursion.NTSB DCA25WA005IncidentClass 5 · ForeignBoeing 777 · Rawalpindi, PakistanNTSB WPR25LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Creswell, ORThe pilot’s loss of aircraft control during the landing flare and subsequent aborted landing.NTSB WPR25LA016Accident · No injuriesClass 4 · LimitedFinal reportLindstrand 80E · Albuquerque, NMThe pilot’s loss of control during landing, which resulted in the balloon’s envelope contacting powerlines.NTSB WPR25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Seattle, WAThe pilot’s failure to maintain directional control during landing roll with a crosswind.NTSB GAA25WA014Accident · No injuriesClass 5 · ForeignCessna 525 · Rio de Janeiro, BrazilNTSB ERA25LA014Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · South Charleston, WVThe pilot’s decision to continue landing after encountering a strong tailwind, which resulted in a loss of control and subsequent runway excursion.NTSB ERA25LA013Accident · No injuriesClass 4 · LimitedFinal reportMaule M8 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing.NTSB DCA25WA007IncidentClass 5 · ForeignBoeing 737 · Las Puntillas, SpainNTSB WPR25LA015Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Moriarty, NMThe pilot’s failure to maintain an adequate glidepath, which resulted in the glider landing on rough terrain short of the runway.NTSB ERA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing roll, resulting in the on-ground collision with trees.NTSB CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…NTSB WPR25LA081Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US ZL-70 · Rio Rancho, NMThe pilot’s inability to maintain clearance from a tree during the landing approach due to a gusting wind shift.NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.NTSB ERA25LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisville, KYThe pilot’s improper landing flare and control inputs, which resulted in a hard landing. Contributing was the flight instructor’s delayed remedial action.NTSB DCA25WA289IncidentClass 5 · ForeignBoeing 737 · Phuket, ThailandNTSB CEN25LA008Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Inguadona, MNThe pilot’s failure to properly configure the landing gear on the amphibious airplane before a water landing.NTSB ANC25LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Kasilof, AKThe right main landing gear’s inadvertent contact with uneven terrain, which resulted in a hard landing. Contributing was the pilot’s failure to adequately assess the landing environment prior to touchdown.NTSB WPR25LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Venator, ORThe inadvertent application of brakes during landing that resulted in a ground loop.NTSB ERA25LA009Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher ASK-21 · Front Royal, VAThe pilot’s improper landing flare and subsequent improper recovery from a hard, bounced landing.NTSB ANC25LA004Accident · No injuriesClass 4 · LimitedFinal reportCessna U206B · Skwentna, AKThe pilot’s delayed go-around decision, which resulted in inadvertent contact with the landing surface, loss of directional control, and a nose over in gusting wind conditions.NTSB WPR25FA002Accident · 1 fatalClass 3 · FieldPreliminary reportTaylor J-2 · Roseburg, OROn October 3, 2024, about 1130 Pacific daylight time, a Taylor J-2 airplane, N19252, was substantially damaged when it was involved in an accident near Roseburg, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA009Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Mesa, AZThe pilot receiving instruction’s failure to maintain airspeed during landing and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ANC25LA031Accident · No injuriesClass 4 · LimitedFinal reportLawrence M Zubel Loehle 5151 Mustang · Vernal, UTThe pilot’s improper landing flare, which resulted in a hard, bounced landing which result in the left landing gear collapsing.NTSB WPR25LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Soda Springs, IDThe passenger’s inadvertent application of brakes during landing which resulted in a nose over.NTSB DCA25WA004OccurrenceClass 5 · ForeignBoeing 737 · Milan, ItalyNTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.NTSB CEN25LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Englewood, COThe collapse of the right main landing gear during landing rollout.NTSB OPS24LA045Incident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Brunswick, GAThe flight crew’s failure to properly identify the airport and runway of intended landing, and the lack of verification of their airplane’s position using all available navigation information.NTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.NTSB CEN24LA375Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14 19 · Cortez, COThe pilot’s failure to extend the landing gear before landing.NTSB ERA24FA397Accident · 5 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Kill Devil Hills, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around attempt, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN24LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 210-5(205) · Bryan, TXThe pilot’s failure to maintain aircraft control during the landing.NTSB CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.NTSB DCA24LA318Incident · No injuriesClass 3 · LimitedFinal reportEmbraer ERJ 170-100 LR · Chicago, ILThe flight crew’s misidentification of the intended landing runway, which resulted in an approach to and landing on the wrong runway due to their planned continuation bias. Contributing to the incident was the flight crew’s decision to continue the approach…NTSB GAA24WA312AccidentClass 5 · ForeignLearjet LJ-31A · Chihuahua, MexicoNTSB GAA24WA297Accident · No injuriesClass 5 · ForeignPiper PA-31 · Gloucestershire, United KingdomNTSB CEN24LA379Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Janesville, WIThe student pilot’s improper flare and the flight instructor’s delayed remedial action that resulted in a hard, bounced landing.NTSB WPR24LA316Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1A · Taft, CAThe pilot receiving instruction’s failure to maintain directional control during landing roll and the flight instructor’s delayed remedial action.NTSB WPR24LA310Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Redlands, CAThe pilot’s failure to maintain airplane control during final approach, which resulted in a collision with rocky terrain.NTSB ERA24LA389Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Erie, PAThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing and the flight instructor’s inadequate remedial action.NTSB WPR24LA312Accident · No injuriesClass 4 · LimitedFinal reportConner Michael A Vans Acft RV-9 · Yellow Pine, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an impact with a fence.