NTSB investigations
679 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '090') 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 GAA19CA470Accident · No injuriesData collectionFinal reportCessna 177 · Placerville, CAThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR19WA208Accident · Serious injuriesForeign investigationVans RV6 · Williams Creek, AustraliaOn July 28, 2019, at 0537 coordinated universal time, a Van's RV-6A , registration VH-ANU, experienced a collapse of the nose landing gear, nosed over and came to rest near William Creek, Southern Australia. The pilot and passenger were seriously injured, and…NTSB WPR19LA196Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 5(205) · Dallesport, ORThe pilot’s improper pitch control during the aborted takeoff, which resulted in a bounced landing and landing gear collapse.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…NTSB GAA19CA392Accident · No injuriesData collectionFinal reportNorth Wing Uum Scout · Westfield, INThe student pilot's improper landing flare, which resulted in a bounced landing and wing strike.NTSB WPR19LA184Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Lincoln, MTA loss of control during landing, which resulted in a nose landing gear collapse and runway excursion.NTSB GAA19CA434Accident · No injuriesData collectionFinal reportSKYBolt Smith Special Skybol · Stafford, VAThe pilot's failure to maintain the runway heading during an aborted go-around, which resulted in a hard landing.NTSB CEN19WA255Accident · No injuriesForeign investigationCessna Cessna 441 · Glasgow, IrelandOn June 25, 2019, about 0800 coordinated universal time, a Cessna 441 airplane, EI-DMG, experienced a propeller strike during landing at the Glasgow Prestwick Airport.The accident investigation is under the jurisdiction and control of the Air Accidents…NTSB CEN19LA183Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Greeley, COThe pilot’s improper landing flare, which resulted in failure of the right main landing gear and a subsequent loss of control.NTSB GAA19CA379Accident · No injuriesData collectionFinal reportCirrus SR22 · Grotten, CTThe pilot's improper landing flare and failure to maintain pitch control, which resulted in a porpoised landing.NTSB DCA19WA175Incident · No injuriesForeign investigationBoeing 737 · Lagos, NigeriaThe government of Nigeria has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Nigeria's investigation under the provisions of…NTSB GAA19CA311Accident · No injuriesData collectionFinal reportCessna 172 · Culpeper, VAThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA19CA305Accident · No injuriesData collectionFinal reportMaule M4 · Fairbanks, AKThe pilot's failure to maintain the runway centerline during landing, which resulted in the airplane landing with the left wheel off the runway, an impact with trees, and a nose-over.NTSB CEN19WA339Accident · No injuriesForeign investigationCessna 172 · Genk/Zwartbeg, BelgiumThe government of Belgium has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on May 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions of…NTSB GAA19CA285Accident · No injuriesData collectionFinal reportPiper PA18 · Cody, WYThe student pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent loss of airplane control after overcorrecting with rudder. Contributing to the accident was the flight instructor's delayed remedial…NTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.NTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.NTSB DCA19LA134Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · New York, NYThe captain’s excessive left rudder pedal input during the takeoff ground roll, which caused a large heading deviation and a left roll upon rotation that resulted in the left wingtip striking the ground.NTSB GAA19CA195Accident · No injuriesData collectionFinal reportRobinson R44 · Taunton, MAThe pilot's improper decision to land with a gusting left quartering tailwind and his subsequent attempt to reposition the helicopter and take off, which resulted in a dynamic rollover.NTSB GAA19CA184Accident · No injuriesData collectionFinal reportPiper PA 16 · Afton, WYThe pilot's improper landing flare, which resulted in a bounced landing and loss of directional control and the airplane’s subsequent impact with a snowbank and nose-over during an attempted go-around.NTSB ERA19LA119Accident · Minor injuriesClass 3 · LimitedFinal reportOstertag Walter G Velocity RG · Stateboro, GAThe pilot’s loss of airplane control while on final approach in gusty wind conditions.NTSB DCA19WA047Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanThe ASC of Taiwan has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on December 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ASC of Taiwan's investigation under the provisions of ICAO Annex…NTSB GAA19CA087Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, NCThe student pilot's improper landing flare, which resulted in a hard, bounced landing and nose landing gear collapse.NTSB GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA19CA064Accident · No injuriesData collectionFinal reportCessna 182 · Charlotte, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA044Accident · No injuriesData collectionFinal reportStoddard Hamilton Glasair II · Laramie, WYThe pilot's failure to maintain a proper pitch attitude during landing at night, which resulted in a porpoised landing.NTSB GAA19CA040Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA035Accident · No injuriesData collectionFinal reportCirrus SR20 · Greenville, SCThe pilot's improper decision to land with a quartering tailwind and his improper landing flare, which resulted in a bounced landing, loss of directional control, runway excursion, and impact with a pole.NTSB DCA19WA007Accident · No injuriesForeign investigationBoeing 737 · Tamil Nadu, IndiaThe government of India has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of…NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB GAA18CA578Accident · No injuriesData collectionFinal reportCirrus SR22 · Frederick, MDThe pilot's improper landing flare, which resulted in the airplane porpoising.NTSB GAA18CA552Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA548Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Carson, NVThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control in gusting, right quartering tailwind conditions.NTSB GAA18CA539Accident · No injuriesData collectionFinal reportSchweizer 269C · Delaware, OHThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA536Accident · No injuriesData collectionFinal reportAeronca 11AC · Midland, TXThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN18WA366Accident · 1 fatalForeign investigationCirrus SR22 · Balchik, BulgariaOn August 24, 2018, at 1608 coordinated universal time, a Cirrus SR22, LZ-SEV, impacted terrain at the Balchik Airfield (LBWB), Balchik, Bulgaria. The airplane was destroyed. The pilot was fatally injured. The flight originated from Lesnovo Airport (LBLS),…NTSB GAA18CA547Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, VTThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB DCA18CA283Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A321-271N · Los Angeles, CAa tailstrike caused by inappropriate recovery technique after a bounced landing. Contributing to the accident was the failure of the radio altimeter, caused by the approach being over calm/flat water, that was not recognized by the flight crew.NTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.NTSB GAA18CA458Accident · No injuriesData collectionFinal reportAllen W Inks Virus SW · Clayton, GAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.NTSB GAA18CA451Accident · No injuriesData collectionFinal reportVans RV 6 · Pickens, SCThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA428Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.NTSB GAA18CA415Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · De Land, ILThe pilot’s selection of unsuitable terrain for landing in crosswind conditions, which resulted in the airplane inadvertently becoming airborne and a subsequent hard landing and loss of directional control.NTSB GAA18CA498Accident · No injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA396Accident · No injuriesData collectionFinal reportCessna 182 · San Luis Obispo, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA500Accident · No injuriesData collectionFinal reportCessna 152 · Sacramento, CAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB ANC18LA079Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAThe National Transportation Safety Board did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of…NTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.