NTSB investigations, 2009
98 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 year(c.\"eventDate\") = 2009
AND 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 year(c."eventDate") = 2009 AND 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 CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.NTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB WPR09LA480Accident · No injuriesLimited investigationFinal reportCessna R172K · Page, AZThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.NTSB CEN09CA394Accident · Minor injuriesData collectionFinal reportSidler Mike Rotorway · Waxahachie, TXThe pilot’s failure to control his rate of descent during autorotation, which required an aggressive recovery maneuver and resulted in a sudden loss of tail rotor effectiveness.NTSB CEN09LA389Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · St. Louis, MOThe pilot’s failure to establish and maintain a stabilized final approach which resulted in a hard landing and runway overrun.NTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09CA381Accident · Minor injuriesData collectionFinal reportCessna 177B · Elyria, OHThe student pilot's failure to maintain aircraft control and adequate airspeed during the aborted landing, which resulted in an aerodynamic stall at a low altitude.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB WPR09CA304Accident · No injuriesData collectionFinal reportStucker Virgil A Avid Magnu · Emmett, IDThe pilot's improper landing flare and recovery from a bounced landing.NTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.NTSB CEN09CA336Accident · No injuriesData collectionFinal reportBeech F33A · Midland, TXThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the inadequate oversight of the flight by the instructor pilot.NTSB ERA09IA315Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Greenville, SCA pitch control malfunction for undetermined reasons.NTSB ERA09CA318Accident · No injuriesData collectionFinal reportPiper PA28 · Elberton, GAThe student pilot's improper recovery from a bounced landing.NTSB ANC09CA049Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Nome, AKThe pilot's selection of an unsuitable landing/takeoff area.NTSB ERA09CA363Accident · No injuriesData collectionFinal reportCessna 182P · Destin, FLThe pilot's improper recovery from a bounced landing.NTSB ERA09CA307Accident · No injuriesData collectionFinal reportAerotek Pitts Spec · Beaver Falls, PAThe pilot’s failure to maintain directional control of the airplane during the landing rollout.NTSB CEN09CA303Accident · No injuriesData collectionFinal reportAirborne XT912 · Newark, ILThe pilot's inadequate preflight preparation, which led to the inability to accelerate to takeoff speed after encountering wet and soft runway conditions.NTSB ANC09CA044Accident · No injuriesData collectionFinal reportMaule M-4-220C · Nenana, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB ANC09CA043Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane.NTSB CEN09CA300Accident · Minor injuriesData collectionFinal reportDiamond DA20 · Olathe, KSThe student pilot's improper landing flare and recovery from a bounced landing, as well as his improper decision to continue the takeoff after striking the propeller on the runway.NTSB CEN09CA305Accident · No injuriesData collectionFinal reportFlight Design CT2K · Mitchell, SDThe pilot's inadequate compensation for the gusting winds during landing.NTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.NTSB DCA09FA048Accident · Serious injuriesField investigationFinal reportBoeing DC-10 · Baltimore, MDthe captain’s inappropriate control inputs following a firm landing, resulting in two hard nose-gear impacts before executing a go-around. Contributing to the inappropriate control inputs was the captain’s fatigue and physical discomfort; and a possible lack…NTSB ERA09CA280Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot’s premature rotation during takeoff.NTSB ERA09CA260Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Chesapeake, VAThe student pilot's improper recovery from a bounced landing.NTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.NTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.NTSB ANC09CA027Accident · No injuriesData collectionFinal reportCessna 180K · Bettles, AKThe pilot's selection of an unsuitable landing area.NTSB ERA09CA225Accident · No injuriesData collectionFinal reportCessna 150L · Brunswick, GAThe student pilot's failure to maintain aircraft control while landing in gusting crosswinds.NTSB DCA09RA041Accident · 2 fatalClass 5 · ForeignMcdonnell Douglas MD11 · Narita, JapanOn March 23, 2009, at 0649 local time, a FedEx Boeing (McDonnell Douglas) MD-11 crashed upon landing at Narita International Airport (NRT), Narita, Japan. The flight originated at Guangzho Baiyun International Airport (CAN), Guangzho, China. Both pilots were…NTSB ERA09CA190Accident · No injuriesData collectionFinal reportPiper PA-42 · Belmar, NJThe pilot's improper flare, which resulted in a hard landing.NTSB WPR09CA147Accident · No injuriesData collectionFinal reportRobert Frisbey RV4 · Santa Rosa, CAThe pilot's inadequate recovery from a bounced landing.NTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.NTSB ANC09CA024Accident · No injuriesData collectionFinal reportCessna 170B · Homer, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane. Factors contributing to the accident were a tailwind, and the pilot's decision to land downwind.NTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.NTSB CEN09CA175Accident · No injuriesData collectionFinal reportGates Learjet 35A · Kansas City, MOThe copilot's failure to maintain control of the airplane during the go-around. Contributing to the accident was the flight crew's delayed decision to perform a go-around.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.