NTSB investigations, MA
30 cases where the defining event was Loss of control on ground.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 1 |
| 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 ERA26LA202Accident · No injuriesClass 4 · LimitedFinal reportSherry Grobstein LSA-8X · Hyannis, MAThe pilot’s failure to maintain control of the airplane while landing, which resulted in a ground loop and subsequent nose over.NTSB ERA25LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ERA24LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Sterling, MAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and subsequent landing gear collapse. Contributing was the flight instructor’s delayed remedial action.NTSB ERA22LA374Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Westfield, MAThe pilot’s loss of directional control while taxiing for takeoff.NTSB ERA22LA359Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Fitchburg, MAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB ERA21LA329Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Sterling, MAThe pilot’s failure to maintain the glider’s stability in the roll axis during the takeoff roll, which resulted in a dragged wingtip and ground loop.NTSB ERA21LA093Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Westfield, MAThe pilot’s failure to maintain control of the airplane during the landing and his failure to confirm that the landing gear was extended before landing.NTSB ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.NTSB ERA20CA142Accident · No injuriesData collectionFinal reportCirrus SR20 · Stow, MAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with vegetation.NTSB GAA20CA041Accident · No injuriesData collectionFinal reportMaule MX7 · Nantucket, MAThe pilot's failure to maintain directional control during landing on a grass runway in gusting wind conditions, which resulted in impact with a large bush.NTSB GAA18CA288Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Marlborough, MAThe pilot’s improper decision to land on a runway that was too short for a safe landing and his subsequent failure to maintain directional control in tailwind conditions.NTSB GAA18CA134Accident · No injuriesData collectionFinal reportCessna T303 · Great Barrington, MAThe pilot’s failure to see the taxiway when returning to the ramp from the snow-covered runway, which resulted in the airplane rolling down an embankment.NTSB GAA18CA065Accident · No injuriesData collectionFinal reportAveko Sro VL-3C-1 · Northampton, MAThe pilot’s improper landing flare, which resulted in a loss of directional control and subsequent impact with approach lighting.NTSB ERA18LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A · Montague, MAThe pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.NTSB GAA17CA326Accident · No injuriesData collectionFinal reportCessna 150 · Newburyport, MAThe student pilot's decision to attempt to close the cockpit window during takeoff and his subsequent failure to maintain directional control.NTSB GAA17CA156Accident · No injuriesData collectionFinal reportCessna 120 · Orange, MAThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA17CA062Accident · No injuriesData collectionFinal reportAeronca L 3B · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA16CA344Accident · No injuriesData collectionFinal reportBenjamin Harold E RV-4 · Fitchburg, MAThe pilot's failure to maintain directional control upon landing, which resulted in a runway excursion followed by impact with terrain.NTSB GAA15CA273Accident · No injuriesData collectionFinal reportPiper PA 20 · Marshfield, MAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and impact with terrain.NTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.NTSB ERA14CA139Accident · No injuriesData collectionFinal reportPiper PA 11S · Marlboro, MAThe pilot's loss of directional control during the landing rollout in crosswinds, resulting in a runway excursion and subsequent impact with a snow bank.NTSB ERA12CA220Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Beverly, MAThe pilot's loss of airplane control during takeoff, which resulted in a runway excursion.NTSB ERA12CA129Accident · Minor injuriesData collectionFinal reportKoth Larry Jabiru Calypso · Mansfield, MAThe pilot did not maintain directional control during landing. Contributing to the accident was the pilot’s not closing the throttle upon landing and his improper adjustment of the airplane’s brakes.NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.NTSB ERA10CA169Accident · No injuriesData collectionFinal reportCessna 150H · New Bedford, MAThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA09LA295Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout, which resulted in excessive side loads to the right main landing gear and the separation of the outer main landing gear rib from the right wing.NTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.NTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.NTSB MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.