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 DCA20WA072Accident · No injuriesForeign investigationBoeing 737 · Komi, RussiaThe Interstate Aviation Committee (MAK) of Russia has notified the NTSB of an accident involving a Boeing 737-500, which occurred on February 9, 2020. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13 as…NTSB CEN20CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-504 · Fort Morgan, COThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in the left main landing gear tire bursting and the tailwheel assembly failing.NTSB ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.NTSB DCA20WA062Incident · No injuriesForeign investigationBoeing 747 · Dammam, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on January 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…NTSB ERA20CA099Accident · No injuriesData collectionFinal reportPiper PA28 · Naples, FLThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and impact with sign.NTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.NTSB ANC20LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe improper installation of a hydraulic line at the right main landing gear (MLG) unlock actuator, which resulted in a total loss of system hydraulic pressure and failure of the landing gear to extend. Contributing to the accident was the failure of the…NTSB ERA20CA072Accident · Minor injuriesData collectionFinal reportBeech 23 · Norfolk, VAThe pilot receiving instruction's failure to maintain airplane control during landing with a crosswind, which resulted in a bounced landing, and the flight instructor's delayed remedial action, which resulted in a loss of control during the go-around.NTSB CEN20CA059Accident · No injuriesData collectionFinal reportZenith CH 750 · Xenia, OHThe pilot’s failure to maintain airplane control during landing, which resulted in the right tire contacting the runway first followed by the left wing.NTSB CEN20CA039Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Delaware, OHThe student pilot’s failure to maintain yaw control during takeoff, which resulted in an aborted takeoff and subsequent landing on grassy terrain, during which the airplane bounced and then nosed over.NTSB WPR20CA048Accident · No injuriesData collectionFinal reportPiper PA22 · Caldwell, IDThe student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.NTSB ERA20LA055Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · New Market, VAThe pilot's improper touchdown, which resulted in a hard landing and an overload failure of the right main landing gear leg and its associated shock/dampener.NTSB DCA20WA041Incident · No injuriesForeign investigationBoeing 747 · Auckland, New ZealandThe Transport Safety Investigation Bureau (TSIB) of Singapore has informed the NTSB of an incident involving a Boeing 747-400, which occurred on December 10, 2019. The NTSB has appointed a U.S Accredited Representative to assist the TSIB investigation under…NTSB CEN20TA030Accident · Serious injuriesClass 3Final reportRotary RAF 2000 · Omaha, NEThe pilot's loss of directional control while landing in gusting wind conditions.NTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB DCA20WA031Incident · No injuriesForeign investigationBoeing 747 · Sydney, AustraliaThe government of Australia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on November 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB CEN20CA033Accident · No injuriesData collectionFinal reportPiper PA18 · Kerrville, TXThe pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.NTSB ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.NTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…NTSB GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA20CA087Accident · No injuriesData collectionFinal reportFisher FP 202 Koala · Erwin, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.NTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.NTSB GAA20CA057Accident · No injuriesData collectionFinal reportCub Crafters CC11 · Palmyra, PAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain lateral control during a go-around, which resulted in impact with a tree.NTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.NTSB GAA20CA048Accident · Minor injuriesData collectionFinal reportBeech A36 · Le Roy, NYThe pilot's improper pitch control during takeoff in high, gusting wind conditions, which resulted in a runway overrun and the nose landing gear collapsing.NTSB GAA20CA051Accident · No injuriesData collectionFinal reportPereyra Aventura · Tavares, FLThe pilot's improper landing flare, which resulted in a bounced landing on water, and his failure to maintain airplane control during a go-around, which resulted in the airplane nosing over.NTSB GAA20CA091Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 · Apopka, FLThe student pilot's improper landing flare, which resulted in a hard, bounced landing and subsequent nose-over.NTSB GAA20CA023Accident · No injuriesData collectionFinal reportCessna 172 · Louisville, KYThe student pilot's improper landing flare, which resulted in a porpoised landing, a subsequent hard landing on grass left of the runway, and a nose-over. Contributing to the accident was the student’s self-imposed pressure to land the airplaneNTSB GAA20CA002Accident · No injuriesData collectionFinal reportRobinson R44 · Carlsbad, CAThe student pilot's incorrect collective and cyclic applications during landing and the flight instructor's delayed remedial action, which resulted in a roll-over.NTSB GAA19CA576Accident · No injuriesData collectionFinal reportPiper PA 22 · Pollock, LAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent ground loop.NTSB GAA19CA571Accident · No injuriesData collectionFinal reportCessna 152 · Lafayette, INThe student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB GAA19CA563Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 · Mountain Village, AKThe pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff…NTSB GAA19CA559Accident · No injuriesData collectionFinal reportPiper PA60 · Sedona, AZThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.NTSB GAA19CA546Accident · No injuriesData collectionFinal reportMooney M20M · Chandler, AZThe pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action.NTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.NTSB CEN19LA315Accident · No injuriesClass 3 · LimitedFinal reportPiper PA34 · Kingman, KSThe malfunction of the landing gear extension system for reasons that could not be determined with the available evidence.NTSB GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.NTSB GAA19CA520Accident · No injuriesData collectionFinal reportPiper PA32RT · Mackinac Island, MIThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway light.NTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.NTSB GAA19CA518Accident · No injuriesData collectionFinal reportPiper PA32RT · Ashland, ORThe pilot's improper landing flare, which resulted in a bounced, hard landing and propeller strike, and his subsequent loss of directional control.NTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.NTSB DCA19WA201Incident · No injuriesForeign investigationBoeing 757 · Ponta Delgada, PortugalThe government of Portugal has notified the NTSB of an accident involving a Boeing 757 airplane that occurred on August 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…NTSB ANC19LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Lahaina, HIThe pilots’ failure to maintain a proper approach speed and their decision to continue the approach for landing, which resulted in the airplane landing long and a subsequent runway overrun.NTSB WPR19LA221Accident · Minor injuriesClass 3 · LimitedFinal reportAutoGyro Cavalon · Shelton, WAThe pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground.NTSB ERA19FA248Accident · Minor injuriesField investigationFinal reportTextron 680A · Elizabethton, TNThe pilot's continuation of an unstabilized approach despite recognizing associated cues and the flight crew's decision not to initiate a go-around before touchdown, which resulted in a bounced landing, a loss of airplane control, a landing gear collapse, and…NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB GAA19CA493Accident · No injuriesData collectionFinal reportNorth American AT 6D · Chino, CAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN19LA264Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Cordell, OKThe pilot's improper landing flare, which resulted in a hard bounced landing.NTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.