NTSB investigations, MA
15 cases where the sequence of events included Landing area overshoot.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'MA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '380' 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."eventStateOrRegion" = 'MA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '380' 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 ERA26LA246Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 402 · Provincetown, MAOn June 15, 2026, about 0810 eastern daylight time, a Cessna 402C, N499CA, was substantially damaged when it was involved in an accident at Provincetown Municipal Airport (PVC), Provincetown, Massachusetts. The airplane transport pilot (pilot flying) and…NTSB ERA26LA059Accident · No injuriesClass 4 · LimitedFinal reportColumbia Aircraft Mfg LC41-550FG · Chatham, MAThe pilot’s failure to attain a proper touchdown point while landing with a quartering tailwind, which resulted in a long landing and subsequent runway excursion.NTSB ERA25LA296Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Muskeget Island, MAThe pilot’s failure to obtain a proper touchdown point while attempting to land on a very short and rough turf runway, which resulted in a runway overrun and collision with vegetation and terrain.NTSB ERA22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Barnstable, MAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun in gusting wind conditions.NTSB ERA20CA111Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Hanson, MAThe flight instructor's delayed remedial action, which resulted in his decision to perform an off field landing and the airplane's subsequent impact with terrain.NTSB ERA18TA236Accident · No injuriesFinal reportCessna 182 · Hanson, MAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the pilot's decision to land with a quartering tailwind.NTSB ERA18LA136Accident · No injuriesLimited investigationFinal reportCessna 402 · Barre Plains, MAThe pilot's improper decision to land with a tailwind, which resulted in a touchdown with insufficient runway remaining to stop the airplane.NTSB ERA14CA364Accident · No injuriesData collectionFinal reportCessna 177B · Falmouth, MAThe pilot's misjudgment of speed and distance on final approach resulting in a touchdown near the departure end of the runway, a runway excursion, and collision with trees.NTSB ERA13LA241Accident · No injuriesLimited investigationFinal reportCessna 182E · Southwick, MAThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any malfunctions or failures that would have precluded normal operation.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 ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.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 ERA10CA124Accident · No injuriesData collectionFinal reportCessna 150 · Taunton, MAThe pilot's failure to obtain the proper touchdown point during landing.NTSB ERA10CA122Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's improper approach, failure to perform a go-around, and failure to maintain directional control while braking after a long landing.NTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.