NTSB investigations
53,703 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 DEN07CA154Accident · No injuriesData collectionFinal reportCessna 172R · Fort Collins, COThe student pilot's improper flare and recovery from a bounced landing.NTSB SEA07CA230Accident · No injuriesData collectionFinal reportCessna 195 · San Diego, CAThe pilot's inadequate compensation for a wind gust that ballooned the airplane during the landing flare, which resulted in a hard landing. A contributing factor was the wind gust.NTSB NYC07CA190Accident · No injuriesData collectionFinal reportAckert Dakota Hawk DH23 · Sebring, FLPreexisting cracking of the landing gear tubing.NTSB CHI07CA265Accident · No injuriesData collectionFinal reportMooney M20-C · Hicksville, OHThe pilot failed to execute a go-around.NTSB SEA07CA232Accident · No injuriesData collectionFinal reportCirrus Design SR22 · San Diego, CAThe pilot's improper recovery from a bounced landing, which resulted in porpoising and collapse of the nose landing gear.NTSB CHI07CA269Accident · No injuriesData collectionFinal reportAviat A-1 · Kellys Island, OHThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the pole, hangar, and crosswind.NTSB ANC07TA080Accident · No injuriesFinal reportPiper PA-18 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was rough and uneven terrain conditions.NTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.NTSB LAX07CA247Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chino, CAThe private pilot's failure to maintain the proper airspeed and main rotor rpm, which resulted in a high rate of descent and subsequent hard landing. Also causal was the certificated flight instructor's delayed remedial action.NTSB DFW07LA206Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Mason County, TXThe loss of control as result of the collapsed right main landing gear during the landing roll. A contributing factor was the failure of the right main gear as result of corrosion.NTSB ANC07LA100Accident · No injuriesLimited investigationFinal reportCessna 185 · Pedro Bay, AKThe loss of control during the landing roll for an unknown reason.NTSB ATL07LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Leonardtown, MDThe pilot's inadequate performance planning and failure to abort the takeoff.NTSB SEA07CA224Accident · No injuriesData collectionFinal reportCessna 421B · Oceanside, CAThe collapse of the right main landing gear during the landing roll for undetermined reason, which resulted in a loss of directional control and collision with a fence.NTSB ANC07CA075Accident · No injuriesData collectionFinal reportCessna 180 · Skwentna, AKThe failure of the left brake, and the pilot's continued operation with a known defect (the left brake), which resulted in a loss of control during the landing roll, and an on ground encounter with terrain. A contributing factor to the accident was the…NTSB NYC07LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Warrenton, VAThe flight instructor's failure to maintain adequate rotor rpm during touchdown.NTSB CHI07CA258Accident · No injuriesData collectionFinal reportAeronca 7AC · Westerly, RIThe pilot's failure to maintain control of the airplane during landing which resulted in the overload failure of the right main landing gear. The overload failure of the right main landing gear was a factor.NTSB NYC07LA191Accident · No injuriesLimited investigationFinal reportBass RV-6A · Harrisonburg, VAThe limited fork-to-ground clearance provided by the nose gear design. Contributing to the accident was the uneven turf/dirt surface of the runway.NTSB LAX07CA243Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Big Creek, IDThe pilot's misjudgment of distance and speed, which led to a long landing, and his delayed application of brakes that resulted in long landing and a runway overrun.NTSB ATL07LA110Accident · 1 fatalLimited investigationFinal reportCessna T206H · Lovell, METhe pilot's failure to retract the amphibious floatplane's landing gear during a water landing.NTSB NYC07LA248Accident · No injuriesLimited investigationFinal reportTecnam P92 Echo Super · Sebring, FLThe failure of the landing gear bolt, which resulted in the collapse of the landing gear.NTSB LAX07CA248Accident · No injuriesData collectionFinal reportGrumman American AA5A · Elk River, IDThe pilot's misjudged landing flare, inadequate bounced landing recovery, and failure to maintain directional control during landing.NTSB DFW07CA175Accident · Minor injuriesData collectionFinal reportMellema Bede 4 · Ennis, TXThe pilot's inability to maintain control of the airplane following the disconnect of the tailwheel steering chain while landing.NTSB CHI07LA246Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Hampton, IAThe pilot's failure to maintain directional control during landing. Contributing to the accident was a ditch.NTSB CHI07CA253Accident · No injuriesData collectionFinal reportCessna 180A · Duluth, MNThe pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.NTSB DEN07CA131Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Erie, COThe student pilot's failure to maintain rotor rpm resulting in a loss of aircraft control during a simulated 180 degree auto-rotation. Contributing to the accident was the inadequate flight status supervision by the flight instructor and the student pilot's…NTSB SEA07CA222Accident · No injuriesData collectionFinal reportPiper PA-18-150 · St. George, UTThe pilot's failure to maintain directional control and excessive braking during the landing roll.NTSB SEA07CA220Accident · No injuriesData collectionFinal reportHughes 269C · Three Forks, MTThe student pilot's failure to maintain control of the aircraft during autorotation. The flight instructor's inadequate supervision was a factor.NTSB SEA07FA218Accident · 2 fatalField investigationFinal reportMooney M20E · Tonasket, WAThe pilot's failure to maintain an adequate airspeed during initial climb following an aborted landing that resulted in a stall/spin. The pilot's misjudged speed and distance that resulted in a failure to attain a proper touchdown point was a factor.NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB NYC07CA185Accident · No injuriesData collectionFinal reportBeech 65-A90 · Wallkill, NYThe pilot's improper flare, which resulted in a hard landing.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB CHI07CA236Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Berryville, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway and impacting terrain. A factor in the accident was the dirt embankment.NTSB CHI07CA234Accident · No injuriesData collectionFinal reportBeech 23 · Georgetown, OHThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence. Factors contributing to the accident were the quartering tailwind and the…NTSB SEA07CA215Accident · No injuriesData collectionFinal reportCessna 305-C · Chino, CAThe pilot's failure to maintain directional control during the landing roll.NTSB DEN07CA128Accident · No injuriesData collectionFinal reportCessna 182T · Grand Junction, COThe pilot's failure to maintain aircraft control during the landing.NTSB CHI07CA247Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Kansas City, MOThe pilot's failure to manitain directional control during landing which resulted in the airplane striking a taxiway sign during the aborted landing. The crosswind and the sign were factors.NTSB CHI07CA231Accident · No injuriesData collectionFinal reportBeech A36 · Sturtevant, WIThe pilot's improper decision to land with a tailwind, which resulted in an overrun during landing rollout. Factors contributing to the accident include the dirt pile and the tailwind.NTSB ATL07CA109Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe pilot's failure to maintain directional control during the landing roll.NTSB NYC07LA175Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Collegeville, PAThe pilot's inadequate recovery from a bounced landing.NTSB SEA07CA216Accident · No injuriesData collectionFinal reportCessna 182P · Baker City, ORThe pilot's failure to maintain airspeed and misjudged flare during landing.NTSB SEA07CA211Accident · No injuriesData collectionFinal reportArtic S-1B2 · McCall, IDThe pilot's failure to maintain airspeed during the landing flare resulting in a hard landing and subsequent failure to maintain directional control during the landing roll. The soft terrain condition adjacent to the runway was a factor.NTSB LAX07CA230Accident · No injuriesData collectionFinal reportBeech V35B · Yellow Pine, IDThe pilot's failure to attain the proper touchdown point on landing.NTSB LAX07CA229Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta II · Boise, IDThe student pilot's failure to maintain rotor rpm resulting in an excessive descent rate and a hard landing. Factors in the accident were the student's failure to relinquish the controls, and the CFI's inadequate supervision.NTSB DEN07CA123Accident · No injuriesData collectionFinal reportHorton Aviat ChristEagle II · Salida, COThe pilot's failure to maintain aircraft control during the landing, causing the airplane to depart the runway and impact the VASIs.NTSB CHI07CA242Accident · No injuriesData collectionFinal reportMarcellus Starduster SA-300 · Columbia, ILThe pilot's improper flare, which resulted in a hard landing and subsequent left main landing gear collapse.NTSB CHI07CA228Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent impact with the ground.NTSB LAX07CA226Accident · No injuriesData collectionFinal reportBeech C23 · Taylor, AZthe student pilot's misjudged landing flare and inadequate recovery from a bounced landing that resulted in a hard landing and a loss of directional control.NTSB LAX07LA225Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-220T · Battle Mountain, NVThe pilot's failure to maintain directional control.NTSB SEA07LA213Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Spokane, WAThe locking/seizing of a main landing gear brake mechanism during the landing roll.NTSB DEN07CA126Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C2 · Crested Butte, COThe pilot's failure to maintain directional control during the landing roll.