NTSB investigations, MA
38 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 2 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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" = '230' 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 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 ERA22LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Hanson, MAThe pilot’s improper landing flare, which resulted in a hard landing and partial loss of directional control. Contributing to the accident was the pilot’s improper decision to depart and land with a known mechanical deficiency with the nose landing gear.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 GAA16CA515Accident · Serious injuriesData collectionFinal reportCessna 172 · Pittsfield, MAThe student pilot’s failure to maintain an appropriate descent rate and runway alignment during the landing flare, which resulted in the airplane touching down left of the runway and impacting a ditch.NTSB GAA16CA389Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Hyannis, MAThe pilot's failure to maintain an appropriate descent rate during landing, which resulted in a hard landing, followed by a loss of directional control, runway excursion, and an impact with a security fence and vehicles during the subsequent attempt to abort…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 ERA15LA360Accident · No injuriesLimited investigationFinal reportJ. Schilling S-19 · East Falmouth, MAThe experimental airplane builder's failure to properly secure the stabilator trim tab push-pull tube’s connection, which resulted in the tube’s separation and a subsequent hard landing. Contributing to the accident was the pilot/owner's failure to detect the…NTSB GAA15CA253Accident · Minor injuriesData collectionFinal reportAir Creation USA Skypper · Stow, MAThe student pilot's improper directional control inputs during the takeoff roll, resulting in a roll over and collision with terrain.NTSB GAA15CA073Accident · No injuriesData collectionFinal reportCessna 182T · Newburyport, MAThe pilot's failure to recover from a bounced landing, which resulted in substantial damage to the airplane during the runway overrun.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 ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.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 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 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.