Skip to content

NTSB investigations, 2011

20 cases where the defining event was Landing area overshoot.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2011 AND 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

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 year(c.\"eventDate\") = 2011
    AND 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 year(c."eventDate") = 2011
  AND 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 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…Dec 20, 2011 · PK-CKM · Substantial damage 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.Nov 20, 2011 · N6844B · Substantial damage 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.Sep 23, 2011 · N6YC · Substantial damage 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.Aug 13, 2011 · N5080M · Substantial damage 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.Aug 9, 2011 · N30731 · Substantial damage 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.Jul 23, 2011 · N869BC · Substantial damage 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.Jul 11, 2011 · N6YM · Substantial damage 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.…Jul 10, 2011 · 5N-BEX · 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.Jul 5, 2011 · N41ZX · Substantial damage 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.Jun 25, 2011 · N6980W · Substantial damage 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.Jun 18, 2011 · N3068E · Substantial damage 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.Jun 16, 2011 · N99136 · Substantial damage 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.Jun 15, 2011 · N129SG · Substantial damage 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.Apr 30, 2011 · N12839 · Substantial damage 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…Apr 26, 2011 · N799SW · Minor damage NTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.Mar 20, 2011 · N6555S · Substantial damage 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.Mar 4, 2011 · XA-TWH · Substantial damage 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.Feb 27, 2011 · N739NY · Substantial damage 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…Feb 15, 2011 · PK-LHH · Minor damage 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…Feb 14, 2011 · PK-LFI · Minor damage