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 WPR24LA163Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Livermore, CAThe flight instructor’s delayed remedial action, which resulted in an aerodynamic stall and abnormal contact with the runway. Contributing to the accident was the student pilot’s improper landing flare and go-around.NTSB ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.NTSB WPR24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportEngineering & Research Ercoupe 415-C · Ontario, ORThe non-certificated pilot’s unstable approach to landing, which resulted in a collision with approach lighting, hard landing, and postimpact fire.NTSB GAA24WA314Accident · No injuriesClass 5 · ForeignRobinson R22 · Municipio de Berazategui, ArgentinaNTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB CEN24LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Midland, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s failure to take remedial action.NTSB WPR24LA192Accident · No injuriesClass 4 · LimitedFinal reportSIAI Marchetti SM. 1019 · Twin Bridges, MTThe binding of the parking brake cable, which resulted in un-commanded brake application during the landing roll and subsequent nose over.NTSB ANC24LA034Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Wellsville, UTThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a nose over.NTSB ERA24LA398Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · St. Augustine, FLThe pilot’s improper landing flare resulting in a hard, bounced landing.NTSB ANC24LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 190 · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a failure of the right main landing gear and subsequent ground loop.NTSB CEN24LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Shreveport, LAThe airplane’s collision with a deer on the runway during landing.NTSB ANC24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Dry Creek, AKThe pilot receiving instruction’s excessive use of brakes during landing, and the pilot providing instruction’s inadequate supervision, resulting in a nose-over.NTSB WPR24LA149Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Bonners Ferry, IDThe student pilot’s failure to maintain control of the airplane during landing in gusting wind conditions.NTSB GAA24WA211AccidentClass 5 · ForeignBeech B200 · Williamtown, AustraliaNTSB WPR24LA151Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman G164 · Maxwell, CAThe pilot’s failure to ascertain a proper touchdown point and late decision to initiate a go-around, which resulted in a subsequent collision with vegetation.NTSB WPR24LA147Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Emmett, IDThe pilot’s loss of directional control during landing roll due to a loose tailwheel leaf spring assembly.NTSB CEN24LA183Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV9 · Linn Grove, IAThe pilot’s mismanagement of the airplane’s approach resulting in a collision with terrain.NTSB CEN24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Chesaning, MIThe pilot’s failure to maintain control while landing on a wet turf runway, which resulted in a runway excursion and impact with trees. Contributing to the accident was the pilot’s failure to ensure the passenger’s proper use of seatbelts before the landing.NTSB CEN24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Davis, OKThe pilot’s failure to maintain proper airspeed on approach which resulted in an extended touchdown, bounced landing, and runway overrun.NTSB DCA24WA181Accident · No injuriesClass 5 · ForeignBoeing 737 · Antalya, TürkiyeNTSB DCA24WA180Incident · No injuriesClass 2 · ForeignBoeing 767-3S2F · Istanbul, TürkiyeNTSB ANC24LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Anchorage, AKThe student pilot’s failure to maintain directional control during landing.NTSB CEN24LA204Accident · No injuriesClass 4 · LimitedFinal reportTecnam P2010 · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and his improper pitch control while he attempted a recovery from the bounced landing which resulted in a significant nose-down pitch attitude upon the second touchdown.NTSB ERA24LA210Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Titusville, FLThe pilot’s failure to maintain directional control while landing in variable wind conditions, which resulted in runway excursion and collision with an approach light.NTSB ENG24WA017AccidentClass 5 · ForeignBoeing 737 · Kinshasa, Congo - KinshasaNTSB WPR24LA140Accident · No injuriesClass 4 · LimitedFinal reportMichael Milburn Vans RV8 · Cascade, MTThe pilot’s failure to maintain aircraft control during landing roll.NTSB ERA24LA218Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Conway, SCThe pilot’s failure to extend the landing gear before landing.NTSB DCA24FA179Accident · Minor injuriesClass 2 · FieldFinal reportEmbraer EMB-145LR · Houston, TXThe captain’s unintentional use of the nose down pitch trim during final approach which limited the elevator control authority resulting in a hard landing that collapsed the left main landing gear.NTSB WPR24LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna T206H · Halls Crossing, UTThe airplane’s collision with a tree during an aborted landing. Contributing to the accident was the airplane’s reported brake malfunction for undetermined reasons.NTSB ERA24LA212Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Georgetown, OHAn inadvertent encounter with the rotor wash of a nearby hovering helicopter during landing, which resulted in a loss of control and a runway excursion.NTSB ERA24LA213Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Apex, NCThe loss of directional control during the landing roll for reasons that could not be determined, due to impact damage sustained to the brake system.NTSB ERA24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Westminster, MDThe pilot’s failure to attain a proper touchdown point during a simulated loss of engine power approach, which resulted in a hard landing short of the runway. Also causal was the flight instructor’s delayed remedial action during the approach and subsequent…NTSB CEN24LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Belle Chasse, LAThe inadequate landing flare by the flight instructor that resulted in a loss of directional control and impact with terrain.NTSB CEN24LA176Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Watervliet, MIThe pilot’s failure to maintain control during the landing roll on a soft turf runway.NTSB WPR24LA144Accident · No injuriesClass 4 · LimitedFinal reportRans S7 · Hemet, CAThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR24LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Scappoose, ORThe pilot’s failure to maintain aircraft control during the landing roll in gusting wind conditions.NTSB GAA24WA163Incident · No injuriesClass 5 · ForeignPiper PA46 · Cuiabá, BrazilNTSB CEN24LA169Accident · Serious injuriesClass 4 · LimitedFinal reportBaby Great Lakes - · Castroville, TXThe failure of the right main landing gear axle due to multiple fatigue crack initiation points joining into a single larger crack.NTSB ERA24LA202Accident · No injuriesClass 4 · LimitedFinal reportStephen R Kunkle Mustang II · Philadelphia, PAA loss of directional control during the landing roll.NTSB ERA24LA195Accident · No injuriesClass 4 · LimitedFinal reportReddick Jonathan L Zodiac 601XLB · Dunbar, PAA total loss of engine power as a result of an improperly fabricated fuel-air mixture cable bracket. Contributing was the pilot’s decision to fly the airplane with a known mechanical engine issue, and the presence of another airplane that was back taxiing on…NTSB ERA24LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Endicott, NYThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, and subsequent collision with trees.NTSB ERA24LA193Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Greenville, SCThe pilot’s failure to extend the landing gear before landing.NTSB CEN24LA166Accident · No injuriesClass 4 · LimitedFinal reportRans S-6ES · Emporia, KSThe pilot’s failure to maintain control during the landing flare.NTSB CEN24LA165Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Olney, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.NTSB WPR24LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Placerville, CAThe pilot’s loss of directional control during the landing roll.NTSB WPR24LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Challis, IDThe pilot’s failure to attain a proper touchdown point during landing which resulted in a runway excursion and subsequent nose over.NTSB GAA24WA188Accident · No injuriesClass 5 · ForeignDe Havilland Canada DHC-8 · Guernsey, United KingdomNTSB GAA24WA155Accident · Minor injuriesClass 4 · ForeignLearjet 75 · Erechim, BrazilNTSB ENG24WA020Incident · No injuriesClass 5 · ForeignDe Havilland DHC8 · La Villiaze, United KingdomNTSB DCA24WA173Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD80 · Lagos, Nigeria