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 GAA17CA579Accident · No injuriesData collectionFinal reportBeech 95 B55 · Statesville, NCThe pilot’s failure to maintain pitch control of the airplane during landing, which resulted in a bounced landing.NTSB CEN17LA367Accident · Serious injuriesLimited investigationFinal reportMiller Steven M RV6 A · Elbert, COThe pilot’s improper landing flare in strong gusting wind conditions, which resulted in a bounced landing, and his loss of directional control during an attempted go-around, which resulted in a runway excursion and impact with objects.NTSB GAA17CA533Accident · No injuriesData collectionFinal reportCessna T182T · Silver Springs, NVThe flight instructor’s failure to maintain a proper descent rate during a simulated engine failure, which resulted in a bounced landing.NTSB GAA17CA538Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Ynez, CAThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard, bounced landing.NTSB GAA17CA526Accident · Serious injuriesData collectionFinal reportCessna 172 · Coolin, IDThe pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.NTSB CEN17WA381Incident · No injuriesForeign investigationGulfstream GV · Le Bourget, FranceOn September 10, 2017, a Gulfstream GV SP 550 airplane, Monaco registration M-SAWO, experienced abnormal runway contact during landing at Le Bourget Airport, Le Bourget, France. A wingtip sustained minor damage during the landing, and the two pilots and four…NTSB GAA17CA577Accident · No injuriesData collectionFinal reportFlight Design Ctls · Newport, RIThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA17CA516Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZThe student pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll.NTSB GAA17CA515Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Winnemucca, NVThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent loss of airplane control during an attempted aborted landing.NTSB GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA503Accident · No injuriesData collectionFinal reportPiper PA 28 · Mohave, AZThe pilot’s improper airspeed and pitch control during landing in variable, gusting wind conditions, which resulted in an aerodynamic stall and hard landing.NTSB GAA17CA493Accident · No injuriesData collectionFinal reportBoyd Bruce RV4 · Yerington, NVThe pilot's improper landing flare, which resulted in a bounded landing and subsequent loss of directional control.NTSB GAA17CA486Accident · No injuriesData collectionFinal reportCessna L19 · Nashville, TNThe pilot’s improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB CEN17LA359Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Raton, NMThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing, and his subsequent failure to attain a proper airspeed during an attempted go-around in shifting wind conditions, which resulted in an aerodynamic stall.NTSB DCA17WA175Incident · No injuriesForeign investigationEmbraer EMB135 · Middlemount, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of a serious incident involving a EMBRAER EMB135 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB WPR17LA181Accident · Serious injuriesLimited investigationFinal reportRans S9 · Athol, IDThe pilot's loss of pitch attitude and ground proximity awareness, which resulted in an unintentionally steep initial climb and an overcorrection into a steep descent and ground impact.NTSB GAA17CA490Accident · No injuriesData collectionFinal reportCessna 208 · Mulino, ORThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.NTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.NTSB GAA17CA456Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD 55-1 · Mocksville, NCThe pilot’s improper landing flare in gusting wind conditions.NTSB GAA17CA455Accident · No injuriesData collectionFinal reportCessna 150 · McKinney, TXThe student pilot’s improper landing flare, which resulted in bounced landing and the collapse of the nose landing gear.NTSB GAA17CA451Accident · No injuriesData collectionFinal reportMark Goldberg Bearhawk Patrol · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB ERA17WA294Accident · No injuriesForeign investigationRaytheon Hawker · Mykonos, GreeceOn July 26, 2017, at 0727 Universal Coordinated Time (UTC), a Raytheon Aircraft Company Hawker 850XP, Turkish registration TC-MAN, operated by Genel Havacilik AS, received substantial damage following an abnormal runway contact during landing at Mykonos…NTSB CEN17LA282Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Wichita Falls, TXThe flight's encounter with adverse weather conditions at night, which resulted in the pilot's loss of airplane control upon landing due to standing water and a subsequent runway overrun.NTSB GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.NTSB GAA17CA414Accident · No injuriesData collectionFinal reportCessna TU206 · Albuquerque, NMThe pilot’s improper landing flare in gusting wind conditions, which resulted in a porpoised landing.NTSB GAA17CA422Accident · No injuriesData collectionFinal reportPiper PA32 · Marion, IAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.NTSB GAA17CA419Accident · No injuriesData collectionFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s improper landing flare, which resulted in a bounced landing and a propeller strike.NTSB GAA17CA448Accident · No injuriesData collectionFinal reportCessna 172 · Manassas, VAThe student pilot’s improper landing flare, which resulted in a porpoised landing.NTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA400Accident · No injuriesData collectionFinal reportRitter John I S D S C · Kemmerer, WYThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.NTSB GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.NTSB CEN17LA257Accident · No injuriesLimited investigationFinal reportCessna 182T · Jackson, MIThe pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.NTSB GAA17CA389Accident · No injuriesData collectionFinal reportCessna 172 · Shreveport, LAThe student’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA394Accident · No injuriesData collectionFinal reportCessna 172 · TamuningThe pilot's improper landing flare, which resulted in a porpoised landing.NTSB ERA17CA221Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA17CA382Accident · No injuriesData collectionFinal reportCessna 170 · Alamogordo, NMThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB ERA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Emporia, VAThe student pilot's failure to maintain an adequate airspeed for landing and his improper landing flare and recovery from a bounced landing.NTSB ERA17CA213Accident · Minor injuriesData collectionFinal reportCessna 207 · Vinalhaven, METhe pilot’s failure to maintain a stabilized approach, which resulted in a bounced landing and subsequent go-around with insufficient distance to clear trees during the climb.NTSB GAA17CA387Accident · No injuriesData collectionFinal reportPiper PA 12 · Chickaloon, AKThe pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.NTSB GAA17CA364Accident · No injuriesData collectionFinal reportCessna 305 · Ukiah, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA366Accident · No injuriesData collectionFinal reportBellanca 1730 · Burnet, TXThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing.NTSB DCA17LA145Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · Atlanta, GAThe first officer's improper landing flare, which resulted in a hard, bounced landing, and the flight crew’s improper bounced landing recovery procedures.NTSB GAA17CA372Accident · No injuriesData collectionFinal reportCessna 172RG · El Cajon, CAThe pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.NTSB GAA17CA346Accident · No injuriesData collectionFinal reportCessna 305C (0 1E) · Rexberg, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA345Accident · No injuriesData collectionFinal reportPiper PA28 · Hartford, CTThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.