NTSB investigations
234 cases where the defining event was Landing area overshoot.
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\" = '380') 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" = '380') 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 WPR12CA291Accident · No injuriesData collectionFinal reportStinson 108-2 · Mile Hi Landing Strip, IDThe pilot's misjudgment of the speed and distance required to land, which resulted in a runway overrun.NTSB ERA12CA393Accident · No injuriesData collectionFinal reportNorth American AT-6C · Delmar, DEThe pilot's failure to go around after not attaining the proper touchdown point, which resulted in a runway excursion and noseover.NTSB CEN12LA333Accident · Serious injuriesLimited investigationFinal reportWalters RV-8 · Hutchinson, MNThe pilot's failure to maintain proper airspeed during the landing attempt, his failure to maintain directional control, and his delayed attempted aborted landing at an airspeed that was too low, which resulted in an aerodynamic stall.NTSB DCA12WA080Incident · No injuriesForeign investigationBoeing MD83 · Taipei, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an accident involving a MD-80 that occurred on May 16, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex 13 as the…NTSB ERA12LA292Accident · Serious injuriesLimited investigationFinal reportMooney M20F · McKinnon, TNThe pilot's delayed decision to go-around after failing to recognize that he was attempting to land with a tailwind, and his failure to retract the landing gear and wing flaps for the go-around, which resulted in a collision with trees and terrain near the…NTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB CEN12CA225Accident · No injuriesData collectionFinal reportBeech V35B · Malvern, ARThe pilot did not fly a stabilized approach and elected not to perform a go-around, which resulted in a runway excursion.NTSB ERA12IA166Incident · No injuriesIncident investigationFinal reportGulfstream G150 · Baltimore, MDThe pilot-in-command's failure to obtain the proper touchdown point or landing reference speed and failure to initiate a go-around when it became evident that the airplane was landing long and fast. Contributing to the incident was a lack of effective flight…NTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.NTSB DCA12WA025Incident · No injuriesForeign investigationBoeing 737 · Fort Nelson, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Boeing 737 that occurred on January 9, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions of ICAO…NTSB DCA12WA022Accident · No injuriesForeign investigationBoeing 737 · Yogyakarta, IndonesiaThe Komite Nasional Keselamatan Transportasi of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737 that occurred on December 20, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…NTSB ERA12CA078Accident · No injuriesData collectionFinal reportBray Verle G JR Kitfox IV 1200 · Bunn, NCThe pilot did not attain a proper touchdown point while attempting to land with a tailwind and delayed his decision to abort the landing.NTSB CEN11CA665Accident · No injuriesData collectionFinal reportEsselstyn Chuck RV-6 · Lyons, WIThe pilot's failure to obtain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.NTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.NTSB ERA11LA421Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJThe pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.NTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.NTSB DCA11WA119Incident · No injuriesForeign investigationHawker Siddeley HS125 · Benin, NigeriaOn July 10, 2011 about 1050 UTC, 5N-BEX, Hawker Siddeley HS-125, operated by Associated Airline Limited, overran runway 23 during landing at Benin Airport, Edo State, Nigeria. There were no injuries to the 3 occupants. The aircraft received minor damage.…NTSB ERA11CA381Accident · Minor injuriesData collectionFinal reportSchleicher ASW-28 · Hugguenot, NYThe pilot's failure to attain the proper touchdown point during a tailwind landing.NTSB CEN11LA426Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphia, OHThe pilot's incorrect identification of the wind direction before landing, which resulted in a tailwind landing and subsequent runway excursion.NTSB ERA11CA372Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carbondale, PAThe pilot's inadequate recovery from a bounced landing, which resulted in a runway overrun. Contributing to the accident was that the pilot did not attain the proper landing point.NTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.NTSB ERA11LA345Accident · No injuriesLimited investigationFinal reportCessna 525A · Nashville, TNThe pilot-in-command's failure to execute a go-around when the airplane was high and fast on the final approach.NTSB ERA11CA273Accident · No injuriesData collectionFinal reportCessna 172M · Suchez, GAThe failure of the pilot to initiate a go-around and his excessive airspeed on the final landing approach.NTSB DCA11IA047Incident · No injuriesIncident investigationFinal reportBoeing 737-7Q8 · Chicago, ILThe flight crew's delayed deployment of the speedbrakes and thrust reversers, resulting in insufficient runway remaining to bring the airplane to a stop. Contributing to the delay in deployment of these stopping devices was the flight crew's inadequate…NTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.NTSB CEN11LA223Accident · No injuriesLimited investigationFinal reportLearjet 25 · Houston, TXThe flying pilot's failure to attain the proper touchdown point in low-visibility conditions, which resulted in a runway overrun. Contributing to the accident was mission pressure to land at that airport.NTSB ERA11LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Welch, WVThe unlicensed pilot’s decision to land on a closed runway with a tailwind, his failure to attain the proper touchdown point, and his delayed decision to attempt a go-around, resulting in a collision with trees.NTSB DCA11WA029Incident · No injuriesForeign investigationBoeing 737 · Pekanbaru, IndonesiaOn February 15, 2011, at 10:55 UTC, a Boeing 737-900, Indonesian registration PK-LHH, overran runway 36 at the Sultan Syarif Kasyim II airport, Pekanbaru, Indonesia. The airplane departed the pavement and had minor damage, there were no injuries to the 8 crew…NTSB DCA11WA028Incident · No injuriesForeign investigationBoeing 737 · Pekanbaru, IndonesiaOn February 14, 2011, at 14:20 UTC, a Boeing 737-900, Indonesian registration PK-LFI, overran runway 36 at the Sultan Syarif Kasyim II airport, Pekanbaru, Indonesia. The airplane departed the pavement and had minor damage, there were no injuries to the 7 crew…NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.NTSB DCA11WA001Incident · No injuriesForeign investigationBoeing 737 · Amsterdam, NetherlandsOn October 2, 2010, Turkish Airlines flight CAI603, a Boeing 737-400, registered in Turkey as TC-TJF, overran runway 22 at Schiphol Airport (EHAM), Amstedam, the Netherlands. Only the nose landing gear exited the paved surface and the airplane was undamaged.…NTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…NTSB CEN11CA004Accident · No injuriesData collectionFinal reportCessna 172N · Wabash, INThe student pilot's failure to maintain proper airspeed during the landing and certificated flight instructor's failure to execute a go-around.NTSB CEN10CA577Accident · No injuriesData collectionFinal reportCessna T182T · Downers Grove, ILThe pilot's improper airspeed during landing, which resulted in a runway overrun, and his delayed decision to execute a go-around.NTSB CEN10CA562Accident · Minor injuriesData collectionFinal reportCessna 172M · Point Lookout, MOThe pilot receiving instruction's failure to attain the proper touchdown point and execute a go-around and the CFI’s delayed remedial action, which resulted in a runway overrun.NTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.NTSB WPR10WA443Accident · 4 fatalForeign investigationCessna 550 · Bugoiya, Papua New GuineaOn August 31, 2010, about 0630 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 550, PA-TAA, was substantially damaged following an overrun and post-crash fire after landing at the Misima Airport (MIS), Bugoiya, Papua, New Guinea.…NTSB ERA10CA447Accident · No injuriesData collectionFinal reportCessna T206H · Clayton, GAThe pilot's improper touchdown point while landing on the wet grass.NTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.NTSB WPR10CA402Accident · No injuriesData collectionFinal reportCessna 182P · Compton, CAThe pilot's failure to attain the proper touchdown point that resulted in an overrun of the runway and collision with a wall.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB CEN10CA405Accident · No injuriesData collectionFinal reportCessna 172K · Boyne City, MIThe pilot's failure to attain the proper touchdown point and delayed go-around.NTSB ERA10LA345Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fairfield, PAThe pilot's improper touchdown point which resulted in an overrun.NTSB ERA10LA322Accident · Serious injuriesLimited investigationFinal reportCessna 172N · West Milford, NJThe student pilot’s control interference which resulted in a landing with a higher than normal airspeed, and the commercial pilot’s failure to initiate a go-around to avoid the runway overrun.NTSB ERA10LA294Accident · Minor injuriesLimited investigationFinal reportSwanson RV-9A · Ashland, VAThe pilot's failure to obtain the proper touchdown point during a forced landing in gusting wind. Contributing to the accident was a total loss of engine power, likely due to carburetor ice.NTSB WPR10CA244Accident · Minor injuriesData collectionFinal reportSchweizer SGS136 · Reno, NVThe student pilot’s selection of the wrong runway for the wind conditions and his failure to attain the proper touchdown point. Contributing to the accident was the student's lack of total experience, lack of experience in the operating area, lack of…NTSB ERA10CA274Accident · No injuriesData collectionFinal reportCessna T210N · Fuquay-Varina, NCThe pilot's improper decision to land with a tailwind resulting in an overrun.NTSB CEN10CA177Accident · No injuriesData collectionFinal reportCessna 182T · Lansing, IAThe pilot's failure to attain a proper touchdown point, resulting in an overrun and intentional ground loop.