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 GAA15CA194Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Monte Vista, COThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with objects.NTSB ANC15CA054Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's inadequate compensation for wind conditions, and improper recovery from a bounced landing resulting in a loss of control and collision with terrain.NTSB GAA15CA197Accident · No injuriesData collectionFinal reportHughes 269C · Atlanta, TXThe non-helicopter rated pilot's improper landing flare, which resulted in impact with terrain.NTSB WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…NTSB GAA15CA162Accident · No injuriesData collectionFinal reportCessna 172N · Lubbock, TXThe student pilot's improper flare during landing which resulted in abnormal runway contact and damage to the firewall.NTSB GAA15CA170Accident · No injuriesData collectionFinal reportCessna T182T · Oak Island, NCThe pilot's improper level off and flare, which resulted in a bounced landing and firewall damage.NTSB GAA15CA149Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Novato, CAThe pilot's improper pitch control which resulted in a bounced landing, runway excursion, and collision with terrain.NTSB GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.NTSB CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…NTSB DCA15WA135Incident · No injuriesForeign investigationBoeing 737 - 3S3 · Sao Luis City, BrazilThe Centro de Investigacao Provencao de Accidentes (CENIPA) has notified the NTSB of an incident involving a Boeing 737-300 which occurred on June 9, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA investigation under the…NTSB GAA15CA100Accident · No injuriesData collectionFinal reportCessna 305 · Richfield, UTThe pilot's loss of directional control during landing, which resulted in a ground loop.NTSB ERA15CA222Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s improper landing flare, which resulted in a bounced landing and damage to the airplane.NTSB CEN15LA229Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Chesterfield, MOThe collision of the helicopter's skid shoe with the runway centerline light during landing, which abruptly stopped the helicopter and resulted in damage to the fuselage.NTSB ANC15CA024Accident · No injuriesData collectionFinal reportRobert M. Jones Zenith CH 701 · Palmer, AKThe pilot's excessive descent rate and subsequent hard landing during the landing flare/touchdown.NTSB GAA15CA049Accident · No injuriesData collectionFinal reportCessna 172M · Clearwater, FLThe pilot's excessive airspeed during landing, which resulted in abnormal runway contact, a runway excursion, and substantial damage to the airplane.NTSB CEN15LA207Accident · No injuriesLimited investigationFinal reportCessna 177B · Jennings, LAThe pilot's improper landing flare, which resulted in a hard landing, the nosewheel tire bursting, and a subsequent porpoise and nose-over.NTSB GAA15CA026Accident · No injuriesData collectionFinal reportCessna 172S · Vernal, UTThe student pilot's failure to maintain attitude control during landing flare.NTSB GAA15CA011Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Boulder, COThe pilot's loss of directional control during a bounced landing, which resulted in a runway excursion.NTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.NTSB ERA15CA086Accident · No injuriesData collectionFinal reportCessna 310N · Liberty, NCThe pilot's improper landing flare, which resulted in a hard landing and collapse of the left main landing gear.NTSB ERA15CA074Accident · No injuriesData collectionFinal reportCessna R182 · Vero Beach, FLThe pilot's improper landing flare, resulting in a hard landing.NTSB WPR15CA031Accident · No injuriesData collectionFinal reportSIAI Marchetti S211 · Borrego Valley, CAThe private pilot's premature landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing.NTSB ERA15CA033Accident · No injuriesData collectionFinal reportCessna 172M · Apopka, FLThe student pilots improper landing flare which resulted in a hard landing and loss of aircraft control. Contributing to the accident was the flight instructor's delayed remedial actions.NTSB WPR15CA028Accident · No injuriesData collectionFinal reportCessna 172 - S · Hawthorne, CAThe pilot's improper flare which resulted in a loss of aircraft control and subsequent hard landing.NTSB DCA15WA015Incident · No injuriesForeign investigationBoeing 747 422 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Boeing 747 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under…NTSB ANC14CA090Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Port Alsworth, AKThe pilots failure to maintain control of the airplane during an aborted landing in gusty wind conditions.NTSB WPR14CA386Accident · Minor injuriesData collectionFinal reportCessna E162 · Bellingham, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB DCA14CA161Accident · No injuriesData collectionFinal reportBoeing 757 223 · Miami, FLThe failure of the first officer to control the airplane pitch after touchdown. Contributing to the accident was the first officers inexperience in the aircraft type.NTSB ANC14CA080Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Aniak, AKThe pilot's inability to maintain directional control of the airplane resulting in a separation of the wheel axle, resulting in a collision with terrain.NTSB CEN14CA503Accident · No injuriesData collectionFinal reportMaule MT 7-260 · Largo Vista, TXThe pilot's inadequate compensation for gusting wind conditions during takeoff, which resulted in the nose landing gear impacting the runway and the subsequent collapse of the nose landing gear.NTSB ANC14CA072Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot's inadequate recovery from a bounced landing, resulting in a runway excursion and collision with trees.NTSB CEN14CA470Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Minneapolis, MNThe pilot's loss of control while landing with a crosswind. Contributing to the accident was the pilot lack of experience flying in similar weather conditions.NTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.NTSB CEN14CA428Accident · Minor injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Frankfort, MIThe pilot's improper recovery from a bounced landing in gusty, crosswind conditions. Contributing to the accident was the pilot lack of recent tail wheel landing experience.NTSB ERA14CA353Accident · No injuriesData collectionFinal reportJannakos Gregory P Zodiac 601 HDS · Lawrenceville, GAThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN14CA386Accident · No injuriesData collectionFinal reportBlack Christopher Sparrow Sport Spec · Moriarty, NMThe pilot's loss of directional control while landing in gusty crosswind conditions. Contributing to the accident was the pilot's operation of the engine above its normal temperature limit on takeoff.NTSB WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.NTSB ERA14CA354Accident · No injuriesData collectionFinal reportCessna 172P · Hagerstown, MDThe student pilot's improper landing flare.NTSB WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…NTSB WPR14TA278Accident · No injuriesFinal reportRockwell International 500 S · Willcox, AZThe pilot’s failure to compensate for tailwind conditions and maintain directional control during landing, which resulted in a runway excursion.NTSB WPR14CA376Accident · No injuriesData collectionFinal reportCessna 182K · Mesa, AZThe student pilot's inadequate landing flare which resulted in a loss of aircraft control and hard landing.NTSB ERA14LA324Accident · No injuriesLimited investigationFinal reportBeech 95 55 · Gulf Shores, ALThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN14LA296Accident · Minor injuriesLimited investigationFinal reportBell 206B · Decatur, TXThe flight instructor’s improper recovery from a practice autorotation, which resulted in a hard landing.NTSB DCA14WA123Incident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Kinmen, ChinaThe Aviation Safety Council (ASC) of Taiwan, R.O.C. has notified the NTSB of an incident involving a Boeing MD-82 which occurred on June 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of…NTSB CEN14CA355Accident · No injuriesData collectionFinal reportCessna 182S · Put in Bay, OHThe pilot's improper flare, which resulted in a hard landing.NTSB ERA14CA286Accident · No injuriesData collectionFinal reportCessna 162 · Cross City, FLThe student pilot's improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB WPR14CA217Accident · No injuriesData collectionFinal reportCessna 210 · Moab, UTThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB WPR14CA213Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Cedar Valley, UTThe pilot's failure to maintain aircraft control during the takeoff roll, which resulted in inadvertent terrain contact by the wing.