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 GAA19CA309Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Sedona, AZThe pilot's failure to maintain pitch control during landing in gusting wind conditions, which resulted in a nose-over.NTSB GAA19CA306Accident · No injuriesData collectionFinal reportCirrus SR22 · Denver, COThe pilot's improper control inputs on approach, which resulted in a hard landing near the runway edge, a runway excursion, and impact with runway lighting. Contributing to the accident was the flight instructor's delayed remedial action.NTSB GAA19CA304Accident · No injuriesData collectionFinal reportPiper PA32R · Flippin, ARThe airplane’s collision with deer during the landing and the airport’s failure to provide an adequate barrier to prevent wildlife from entering the runway environment despite previous deer strikes.NTSB GAA19CA302Accident · No injuriesData collectionFinal reportDale Berkbigler CCX-2000 · Gunnison, COThe pilot's excessive brake application during the landing roll, which resulted in a noseover.NTSB GAA19CA307Accident · No injuriesClass 4 · Data collectionFinal reportDavid S Meek SUN Devil · Junction City, KSThe pilot rated passenger's failure to maintain directional control during landing. Contributing to the accident was the improperly maintained main landing gear brake pads.NTSB GAA19CA300Accident · Minor injuriesData collectionFinal reportVans RV6 · Rose Hill, KSThe pilot's unintentional engagement of the brakes before landing, which resulted in a nose-over.NTSB GAA19CA041Accident · No injuriesData collectionFinal reportVans RV 6 · Paola, KSThe pilot's failure to maintain directional control, which resulted in a runway excursion during the aborted landing and subsequent impact with vegetation and a nose-over.NTSB GAA19CA353Accident · No injuriesData collectionFinal reportCessna 177 · Festus, MOThe pilot's improper landing flare and failure to maintain pitch control with a crosswind, which resulted in a hard landing and a tail strike.NTSB GAA19CA318Accident · No injuriesData collectionFinal reportBeech 55 · Youngstown, OHThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA305Accident · No injuriesData collectionFinal reportMaule M4 · Fairbanks, AKThe pilot's failure to maintain the runway centerline during landing, which resulted in the airplane landing with the left wheel off the runway, an impact with trees, and a nose-over.NTSB GAA19CA299Accident · Minor injuriesData collectionFinal reportCirrus SR20 · San Antonio, TXThe pilot's inadequate approach, delayed decision to abort the landing, and failure to properly configure the flap setting for the initial climb during the attempted aborted landing, which resulted in impact with trees.NTSB GAA19CA298Accident · No injuriesData collectionFinal reportPiper PA18 · Sparta, ILThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA19CA295Accident · No injuriesData collectionFinal reportPipistrel Alpha Trainer · Salida, COThe pilot's failure to replace the fuel cap after fueling, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing to a field and subsequent collision with a fence.NTSB CEN19WA339Accident · No injuriesForeign investigationCessna 172 · Genk/Zwartbeg, BelgiumThe government of Belgium has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on May 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions of…NTSB GAA19CA294Accident · No injuriesData collectionFinal reportRatheon A36 · Hilton Head, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB GAA19CA108Accident · No injuriesData collectionFinal reportDe Havilland DHC 2 · Hollister, CAThe pilot's failure to retract the amphibious float's landing gear wheels before landing on the water. Contributing to the accident was the pilot's failure to use the after takeoff and before landing checklists.NTSB GAA19CA358Accident · No injuriesData collectionFinal reportBeech 35 · Bowie, MDThe pilot's failure to extend the landing gear before landing.NTSB ERA19TA182Accident · No injuriesClass 3Final reportAeronca 7AC · Concord, GAThe pilot's inability to maintain directional control during landing for reasons that could not be determined because postaccident examination of the airplane brake assemblies revealed no anomalies that would have caused the right brake to lock, which…NTSB GAA19CA288Accident · No injuriesData collectionFinal reportLuscombe 8 · Carbondale, ILThe pilot's inadvertent left heel brake application during the landing roll, which resulted in a noseover.NTSB GAA19CA285Accident · No injuriesData collectionFinal reportPiper PA18 · Cody, WYThe student pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent loss of airplane control after overcorrecting with rudder. Contributing to the accident was the flight instructor's delayed remedial…NTSB GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.NTSB GAA19CA279Accident · No injuriesData collectionFinal reportGuimbal Cabri · St. Louis, ILThe flight instructor's improper emergency procedure instruction to the student pilot, which resulted in the student improperly using the throttle to correct the loss of yaw control, which resulted in ground impact and a dynamic rollover.NTSB ERA19TA192Accident · No injuriesClass 3Final reportCessna 172 · Stafford, VAThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.NTSB WPR19LA153Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Socorro, NMThe pilot's failure to maintain airplane control while landing with a quartering tailwind.NTSB GAA19CA276Accident · No injuriesData collectionFinal reportPiper J3C · Louisa, VAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the landing gear collapsing.NTSB WPR19FA152Accident · 1 fatalClass 3 · FieldFinal reportCessna A185 · Whittier, AKThe pilot’s failure to configure the landing gear for a water landing, which resulted in a nose-over. Contributing to the accident was the pilot's distraction due to his talking passengers.NTSB ANC19FA019Accident · 2 fatalClass 2 · FieldFinal reportDe Havilland DHC 2 · Metlakatla, AKThe pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…NTSB GAA19CA373Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Blairesville, GAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.NTSB GAA19CA296Accident · No injuriesData collectionFinal reportCessna 182 · Orangeburg, SCThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA19CA310Accident · No injuriesData collectionFinal reportPiper PA23 · Atlanta, GAThe airplane’s impact with a deer on the runway during landing.NTSB GAA19CA292Accident · No injuriesData collectionFinal reportStearman B75N1 · Bradford, PAThe passenger’s inadvertent brake application during landing, which resulted in a nose-over.NTSB GAA19CA267Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in impact with a ditch.NTSB ERA19LA173Accident · No injuriesClass 3 · LimitedFinal reportHughes 269B · Hampton, GAGround resonance during landing for reasons that could not be determined based on the available information.NTSB GAA19CA269Accident · No injuriesData collectionFinal reportCessna 172 · Tomball, TXThe student pilot's failure to maintain directional control during landing with a left crosswind, which resulted in a runway excursion and subsequent nose-over.NTSB CEN19LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 162 · Las Animas, COThe pilot's decision to land on soft, muddy terrain, which resulted in a nose over.NTSB WPR19LA144Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Gila Bend, AZThe pilot's failure to configure the landing gear in a timely manner before landing, which resulted in a propeller strike.NTSB GAA19CA261Accident · No injuriesData collectionFinal reportSiai-Marchetti SM · Belgrade, MTThe pilot receiving instruction's overapplication of rudder during the landing roll and his subsequent failure to maintain directional control, which resulted in a ground loop.NTSB GAA19CA259Accident · No injuriesData collectionFinal reportCessna 182 · Crossett, ARThe pilot's failure to maintain the runway centerline and his subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA263Accident · No injuriesData collectionFinal reportStinson 108 · Soldotna, AKThe pilot's overapplication of the brakes during landing on a soft runway, which resulted in a nose-over.NTSB GAA19CA260Accident · No injuriesData collectionFinal reportCessna A185 · Northway, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and subsequent nose-over.NTSB GAA19CA256Accident · No injuriesData collectionFinal reportJordan Valley CCX-2000 · Logandale, NVThe pilot's failure to maintain directional control during landing and during a subsequent attempted go-around, which resulted in the airplane cartwheeling.NTSB GAA19CA255Accident · No injuriesData collectionFinal reportElmwood Christavia MK I · Roseburg, ORThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA280Accident · No injuriesData collectionFinal reportPiper PA28 · Charlotte, NCThe student pilot's improper attempted go-around and the flight instructor's delayed remedial action, which resulted in an aerodynamic stall followed by a hard landing, runway excursion, and impact with vegetation.NTSB ERA19LA169Accident · No injuriesClass 3 · LimitedFinal reportHawker Siddeley Hunter · Newport News, VAThe failure of the right main landing gear due to a fatigue cracking.NTSB GAA19CA293Accident · No injuriesData collectionFinal reportPiper PA 20 · Canandaigua, NYThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR19LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Minden, NVA partial extension of the landing gear due to the poor condition of the electric landing gear motor, which resulted in a gear collapse upon landing.NTSB WPR19LA138Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Reno, NVThe pilot’s inability to maintain directional control during landing in gusty crosswind conditions for reasons that could not be determined based on available evidence.NTSB GAA19CA242Accident · No injuriesData collectionFinal reportFlight Design Ctls · Sandy Valley, NVThe pilot's steep bank turn at low altitude, which resulted in a rapid descent and hard landing.