NTSB investigations
1,515 cases where the sequence of events included Abnormal runway contact.
Cases, newest first
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CEN09LA173Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pueblo, COThe pilot's improper flare and recovery from a bounced landing.NTSB CEN09LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Kelleys Island, OHThe pilot's failure to maintain aircraft control while landing in gusty winds due to inadequate aileron cable tension.NTSB WPR09CA110Accident · No injuriesData collectionFinal reportErcoupe 415D · Whitehall, MTThe pilot's failure to attain the proper touchdown point and his failure to abort the landing.NTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.NTSB CEN09CA159Accident · Serious injuriesData collectionFinal reportCameron Balloons US V-90 · La Junta, COThe pilot's failure to maintain a safe rate of descent during landing. Contributing to the accident was the strong surface winds.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.NTSB WPR09CA084Accident · No injuriesData collectionFinal reportCessna U206E · Crane Island, San Juan Is., WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.NTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.NTSB ERA09CA103Accident · No injuriesData collectionFinal reportCessna 172 · Corning, NYThe student pilot's failure to maintain directional control during landing. Contributing to the accident were the gusty wind conditions and the flight instructor's delayed remedial action.NTSB ERA09CA102Accident · Minor injuriesData collectionFinal reportPiper PA-34-200 · Folkston, GAThe student's improper flare and the flight instructor's delayed remedial action.NTSB ERA09FA083Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-60 · Millington, TNThe pilot’s improper configuration of the airplane following an engine shutdown, which resulted in a low-altitude, unstabilized approach. Contributing to the accident was a loss of engine power for undetermined reasons.NTSB CEN09CA084Accident · No injuriesData collectionFinal reportRockwell International 114 · Meacham Int'l Airport, TXThe pilot's failure to maintain pitch control during landing.NTSB ERA09IA056Incident · No injuriesIncident investigationFinal reportDeHavilland DHC-8-311 · Philadelphia, PAThe mechanical overload of the nosewheel steering links for undetermined reasons, which resulted in nose landing gear rotation and its subsequent wedging within the wheel well structure.NTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.NTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.NTSB ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.NTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.NTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA042Accident · No injuriesData collectionFinal reportCessna 172H · Ingleside, TXThe pilot's decision to land in crosswind conditions, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.NTSB ANC09CA006Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Skwentna, AKThe pilot's selection of unsuitable terrain for landing.NTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.NTSB SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.NTSB MIA08LA205Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA42 · Lancaster, PAThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.NTSB DFW08CA236Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Augusta, KSA loose oil line that resulted in a total loss of engine oil, causing the engine to cease.NTSB SEA08CA203Accident · No injuriesData collectionFinal reportSnelling Zodiac · Rexburg, IDThe private pilot's excessive use of the flight controls and improper landing flair, which resulted in a hard landing and subsequent gear collapse.NTSB NYC08CA314Accident · No injuriesData collectionFinal reportCessna 172R · Brunswick, GAThe student pilot's improper flare while landing.NTSB MIA08CA194Accident · No injuriesData collectionFinal reportGlasflugel H-301 · Blairstown, NJThe pilot's inadvertent retraction of flaps during the landing flare.NTSB ANC08CA120Accident · No injuriesData collectionFinal reportCessna T207 · Nyac, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the nose wheel separating from the airplane during the landing roll.NTSB NYC08CA301Accident · No injuriesData collectionFinal reportSteppling RV-6A · Toughkenamon, PAThe pilot's improper recovery from a bounced landing.NTSB ANC08CA132Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing.NTSB DFW08CA221Accident · No injuriesData collectionFinal reportCessna 560 · Telluride, COThe pilot's failure to maintain control during landing. A factor was the reported wind shear.NTSB ANC08CA117Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe student pilot's inadequate recovery from a bounced landing.NTSB NYC08CA303Accident · No injuriesData collectionFinal reportCessna 172 · Newton, MSThe pilot's failure to maintain aircraft control while landing.NTSB CHI08CA259Accident · No injuriesData collectionFinal reportPiper PA-34-200T · East Tawas, MIThe pilot's failure to lower the landing gear prior to touchdown.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB MIA08CA153Accident · No injuriesData collectionFinal reportBeech C23 · Winter Haven, FLThe student pilot's improper recovery from a bounced landing.NTSB CHI08CA229Accident · No injuriesData collectionFinal reportPrendergast RV-7A · Manchester, MIThe pilot's inadequate flare during landing. Contributing to the accident was the uneven terrain.NTSB ANC08CA091Accident · No injuriesData collectionFinal reportCessna T206H · King Salmon, AKThe pilot's misjudged speed and distance during a water landing.NTSB CHI08LA214Accident · Minor injuriesLimited investigationFinal reportBolenbaugh Phillip William Rans S-6ES · Oshkosh, WIThe pilot's improper landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB NYC08LA258Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Atlanta, GAThe pilot's improper flare during landing.NTSB CHI08LA216Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot's failure to maintain adequate airspeed during the go-around, resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed recovery from the bounced landing.NTSB DEN08LA118Accident · No injuriesLimited investigationFinal reportMooney M20M · Elbert, COThe pilot's failure to maintain aircraft control during a go-around, resulting in an aerodynamic stall. Contributing to the accident was the high density altitude.NTSB NYC08LA226Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Ganesvoort, NYA loss of engine power for undetermined reasons.NTSB MIA08CA112Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Roseboro, NCThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB NYC08TA183Accident · Minor injuriesFinal reportRobinson R44 II · Lake Wales, FLThe pilot's improper recovery from a practice autorotation.NTSB DFW08CA138Accident · No injuriesData collectionFinal reportJihlavan KP-5 · Norfolk, NEA hard landing as a result of the pilot's improper flare. A contributing factor was the prevailing wind.