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.

NTSB CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.Jul 2, 2009 · N538ND · Substantial damageNTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.Jul 2, 2009 · N525ND · Substantial damageNTSB WPR09LA480Accident · No injuriesLimited investigationFinal reportCessna R172K · Page, AZThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 1, 2009 · N1055V · Substantial damageNTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.Jun 28, 2009 · N49897 · Substantial damageNTSB 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.Jun 27, 2009 · N1934 · Substantial damageNTSB 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.Jun 25, 2009 · N701PT · Substantial damageNTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.Jun 24, 2009 · N67797 · Substantial damageNTSB 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.Jun 23, 2009 · N34508 · Substantial damageNTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.Jun 22, 2009 · N2320P · Substantial damageNTSB WPR09CA304Accident · No injuriesData collectionFinal reportStucker Virgil A Avid Magnu · Emmett, IDThe pilot's improper landing flare and recovery from a bounced landing.Jun 21, 2009 · N777DV · Substantial damageNTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.Jun 20, 2009 · N2601 · Substantial damageNTSB 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.Jun 3, 2009 · N33UB · Substantial damageNTSB ERA09IA315Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Greenville, SCA pitch control malfunction for undetermined reasons.Jun 1, 2009 · N695CD · No damageNTSB ERA09CA318Accident · No injuriesData collectionFinal reportPiper PA28 · Elberton, GAThe student pilot's improper recovery from a bounced landing.Jun 1, 2009 · N8909W · Substantial damageNTSB ANC09CA049Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Nome, AKThe pilot's selection of an unsuitable landing/takeoff area.Jun 1, 2009 · N94995 · Substantial damageNTSB ERA09CA363Accident · No injuriesData collectionFinal reportCessna 182P · Destin, FLThe pilot's improper recovery from a bounced landing.May 31, 2009 · N1481S · Substantial damageNTSB ERA09CA307Accident · No injuriesData collectionFinal reportAerotek Pitts Spec · Beaver Falls, PAThe pilot’s failure to maintain directional control of the airplane during the landing rollout.May 24, 2009 · N55MF · Substantial damageNTSB 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.May 17, 2009 · N912LM · Substantial damageNTSB 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.May 17, 2009 · N2031U · Substantial damageNTSB 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.May 15, 2009 · N1999P · Substantial damageNTSB 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.May 14, 2009 · N926AF · Substantial damageNTSB CEN09CA305Accident · No injuriesData collectionFinal reportFlight Design CT2K · Mitchell, SDThe pilot's inadequate compensation for the gusting winds during landing.May 13, 2009 · N433CT · Substantial damageNTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.May 10, 2009 · N169PA · Substantial damageNTSB 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…May 6, 2009 · N139WA · Substantial damageNTSB ERA09CA280Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot’s premature rotation during takeoff.Apr 30, 2009 · N739RH · Substantial damageNTSB ERA09CA260Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Chesapeake, VAThe student pilot's improper recovery from a bounced landing.Apr 21, 2009 · N476CT · Substantial damageNTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.Apr 16, 2009 · N7802F · Substantial damageNTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.Apr 13, 2009 · N144ME · Substantial damageNTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.Apr 4, 2009 · N40684 · Substantial damageNTSB ANC09CA027Accident · No injuriesData collectionFinal reportCessna 180K · Bettles, AKThe pilot's selection of an unsuitable landing area.Apr 3, 2009 · N2801K · Substantial damageNTSB ERA09CA225Accident · No injuriesData collectionFinal reportCessna 150L · Brunswick, GAThe student pilot's failure to maintain aircraft control while landing in gusting crosswinds.Mar 29, 2009 · N1505Q · Substantial damageNTSB 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…Mar 23, 2009 · N526FE · DestroyedNTSB ERA09CA190Accident · No injuriesData collectionFinal reportPiper PA-42 · Belmar, NJThe pilot's improper flare, which resulted in a hard landing.Mar 9, 2009 · N28DA · Substantial damageNTSB WPR09CA147Accident · No injuriesData collectionFinal reportRobert Frisbey RV4 · Santa Rosa, CAThe pilot's inadequate recovery from a bounced landing.Mar 8, 2009 · N424RV · Substantial damageNTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.Mar 5, 2009 · N94563 · Substantial damageNTSB 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.Feb 27, 2009 · N2332D · Substantial damageNTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.Feb 24, 2009 · N94626 · Substantial damageNTSB 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.Feb 24, 2009 · N465NW · Substantial damageNTSB CEN09LA173Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pueblo, COThe pilot's improper flare and recovery from a bounced landing.Feb 23, 2009 · N171AF · Substantial damageNTSB 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.Feb 20, 2009 · N3710D · Substantial damageNTSB WPR09CA110Accident · No injuriesData collectionFinal reportErcoupe 415D · Whitehall, MTThe pilot's failure to attain the proper touchdown point and his failure to abort the landing.Feb 4, 2009 · N87349 · Substantial damageNTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.Feb 1, 2009 · N3628T · Substantial damageNTSB 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.Jan 31, 2009 · N2097H · Minor damageNTSB 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.Jan 22, 2009 · N20275 · Substantial damageNTSB 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.Jan 14, 2009 · N9428G · Substantial damageNTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.Jan 10, 2009 · N6272R · Substantial damageNTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.Jan 10, 2009 · N211LC · Substantial damageNTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.Jan 4, 2009 · N815MA · Substantial damage