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 ERA24LA350Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Shirley, NYThe pilot’s excessive speed during the final approach, which resulted in a collision with a fence during the subsequent aborted landing.NTSB DCA24WA283Incident · No injuriesClass 5 · ForeignBoeing 737 · Monrovia, LiberiaNTSB ERA24LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orlando, FLThe student pilot's failure to maintain directional control during while landing with a crosswind. Contributing was the instructor’s delayed remedial action.NTSB ERA24LA347Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Gainesville, FLThe separation of a nose landing gear axle retaining nut and the subsequent the failure of the nose landing gear during landing.NTSB GAA24WA261Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Kingston, JamaicaNTSB ERA24LA355Accident · No injuriesClass 4 · LimitedFinal reportYates Elden H Avipro Bearhawk · Roxbury, METhe pilot’s unstable approach which resulted in a landing with insufficient runway remaining to stop and subsequent impact with a river embankment. Contributing was the engine coolant system anomaly.NTSB CEN24LA322Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Chetek, WIThe pilot’s improper landing flare and hard landing.NTSB GAA24WA310Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Suffolk, United KingdomNTSB ERA24LA345Accident · No injuriesClass 4 · LimitedFinal reportKlutts Joe A CUB · DeLand, FLThe pilot’s failure to maintain directional control during landing.NTSB CEN24LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Whitewright, TXThe pilot’s incomplete flare which resulted a hard, flat landing.NTSB WPR24LA278Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Watsonville, CAThe pilot’s inadvertent use of the landing gear control handle instead of the flaps selector switch during the landing rollout, which resulted in the collapse of the nose landing gear.NTSB WPR24LA277Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Sequim, WAAn encounter with a downdraft, which resulted in a hard landing.NTSB ERA24LA343Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · North Kingstown, RIThe non-certificated pilot’s lack of experience in the tailwheel-equipped airplane and his decision to land in a quartering tailwind, which resulted in a loss of directional control on landing.NTSB CEN24LA324Accident · No injuriesClass 4 · LimitedFinal reportRans RV8 · Morris, ILThe student pilot’s failure to maintain directional control and the flight instructors delayed remedial action while landing with a gusty crosswind.NTSB WPR24LA272Accident · Minor injuriesClass 4 · LimitedFinal reportRenquist George GS-2 Sportsman · Hawthorne, CAThe flight crew’s failure to maintain airspeed during a short field landing and the instructor’s delayed remediation, which resulted in a hard landing.NTSB ANC24LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control while landing at a short remote airstrip.NTSB CEN24LA380Accident · Serious injuriesClass 3 · LimitedFinal reportXag P100 PRO · Francesville, INThe remote pilot’s in-flight loss of control of the unmanned aircraft due to GPS signal fluctuations, which resulted in a collision with, and serious injury to, a person assisting the operation.NTSB ANC24LA076Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 · Skwentna, AKThe pilot's failure to maintain directional control during the landing roll.NTSB WPR24LA276Accident · No injuriesClass 4 · LimitedFinal reportMaule M4 · Scappoose, ORThe pilot’s loss of directional control after an encounter with a wind gust.NTSB ERA24LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Medina, OHThe student pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and subsequent noseover.NTSB CEN24LA310Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Crystal, MNThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB CEN24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Kalamazoo, MIThe pilot’s failure to extend the landing gear before landing.NTSB ANC24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe pilot's continuation of an unstabilized approach and his failure to monitor the aircraft's altitude and airspeed during the approach, resulting in a loss of control.NTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandNTSB ERA24LA335Accident · Serious injuriesClass 3 · LimitedFinal reportHendrickson Glasair 3 · Oxford, MEA loss of engine power for reasons that could not be determined.NTSB ANC24LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Goose Bay, AKThe pilot's failure to maintain directional control during the landing roll.NTSB CEN24LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Colorado Springs, COThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing.NTSB CEN24LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Palmyra, WIThe student pilot’s failure to maintain directional control during the landing with gusty wind conditions.NTSB CEN24LA306Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cleveland, MSThe pilot’s failure to attain/maintain directional control and the flight instructor’s delayed remedial action during landing.NTSB ERA24LA337Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · North Myrtle Beach, SCThe pilot’s failure to use the emergency landing gear extension system, resulting in a gear-up landing. Contributing to the accident was an alternator belt failure.NTSB CEN24LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Lincoln, NEThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB ANC24LA071Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Huntsville, UTThe pilot's failure to navigate in hazy conditions, which resulted in a forced landing in a field and a collision with a pole.NTSB GAA24WA238Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · West Oxfordshire, United KingdomNTSB ERA24LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Moultonborough, NHThe student pilot’s improper remedial response to a bounced landing, which resulted in a hard landing.NTSB CEN24LA288Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Ft. Atkinson, WIThe pilot’s failure to extend the landing gear before landing due to distractions and his failure to conduct the Before Landing checklist.NTSB WPR24LA256Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Oshkosh, WIThe pilot’s failure to maintain control during an approach to land, which resulted in a hard landing.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.NTSB WPR24LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Camarillo, CAThe pilot’s loss of directional control during landing, which resulted in a nose over.NTSB WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.NTSB CEN24LA283Accident · No injuriesClass 4 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Cahokia Heights, ILThe student pilot’s failure to maintain directional control during landing rollout that resulted in a lateral runway excursion and impact with a runway sign.NTSB WPR24FA252Accident · 2 fatalClass 3 · FieldFinal reportTextron T206H · Kneeland, CAThe pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.NTSB ERA24LA325Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Cuba, NYA separation of the left main landing gear wheel assembly during landing.NTSB ERA24LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Rural Retreat, VAA loss of directional control during the landing roll.NTSB CEN24LA282Accident · No injuriesClass 3 · LimitedFinal reportJust Highlander · Oshkosh, WIThe reported uncommanded retraction of the flaps while on short final for unknown reasons, which resulted in a hard landing.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB CEN24LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Greenville, MIThe pilot’s loss of directional control during landing which led to a ground-loop.NTSB WPR24LA250Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1/N2S-3 · Hollister, CAThe pilot’s loss of directional control on landing, which resulted in a nose over.NTSB ERA24LA320Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Port St. Lucie, FLThe pilot’s failure to correctly identify the airport runway, which resulted in a landing on a road and contact with a power line. Contributing to the outcome was the sun glare.