NTSB investigations, MA
74 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 7 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 3 |
| 1996 | 6 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 3 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 MIA08CA045Accident · No injuriesData collectionFinal reportCessna 172P · Northampton, MAThe student pilot's failure to maintain directional control of the airplane during the takeoff roll and inadequate supervision by the CFI.NTSB ATL07CA114Accident · No injuriesData collectionFinal reportWaco Classic YMF-5 · Nantucket, MAThe pilot's failure to maintain control of the airplane during takeoff roll, which resulted in an on ground collision with an airport sign.NTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.NTSB NYC06CA065Accident · No injuriesData collectionFinal reportCessna A185F · Pembroke, MAThe pilot's failure to maintain control during the takeoff roll, which resulted in a ground loop and subsequent impact with trees. A factor was the soft runway as reported by the pilot.NTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB IAD05LA030Accident · No injuriesLimited investigationFinal reportBeech G35 · Falmouth, MAThe pilot's failure to maintain control of the airplane during taxi. A factor was the snow-covered taxiway.NTSB NYC05CA019Accident · No injuriesData collectionFinal reportVigneau RAF 2000 GTX · Chatham, MAThe pilot's failure to maintain aircraft control during a takeoff. A factor related to the accident was the pilot's lack of experience in gyroplanes.NTSB NYC04CA184Accident · No injuriesData collectionFinal reportPascucci RAF 2000 · Beverly, MAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB NYC04CA031Accident · No injuriesData collectionFinal reportPiper PA-18 · Westfield, MAThe pilot's failure to maintain aircraft control while landing.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB NYC03LA159Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Taunton, MAThe pilot's failure to maintain directional control while landing and the CFI's delayed remedial action.NTSB NYC03LA125Accident · No injuriesLimited investigationFinal reportCessna 172L · Newburyport, MAThe pilot's failure to attain the proper touchdown point.NTSB NYC03LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Taunton, MAThe pilot's inadequate compensation for the winds, and his failure to maintain airspeed which resulted in the inadvertent stall. A factor in the accident was the tailwind.NTSB IAD02LA092Accident · No injuriesLimited investigationFinal reportGoff Glassair · Stow, MAThe pilot's improper positioning of the throttle during engine start, which resulted in his inability to maintain control of the airplane.NTSB NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB NYC01LA195Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Hanson, MAThe pilot's failure to maintain aircraft control during the takeoff.NTSB NYC01LA093Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falmouth, MAThe pilot's failure to maintain directional control while landing. Factors were the pilot's inadequate weather evaluation and a tailwind.NTSB NYC00LA238Accident · No injuriesLimited investigationFinal reportAviat A-1B · Newberryport, MAthe failure of the pilot to maintain directional control during landing and a subsequent rejected landing. Factors were the crosswind, and the delayed corrective action by the pilot.NTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.NTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.NTSB NYC99LA204Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mansfield, MAWas the student pilot's failure to maintain lateral control of the helicopter while bringing it to a hover. A factor in the accident was the student pilot's lack of total experience in helicopters.NTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB IAD98LA006Accident · No injuriesLimited investigationFinal reportAviat A-1 · Duxbury, MAFailure of the pilot to maintain control of the airplane. A related factor was the wind gusts.NTSB IAD97LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Edgartown, MAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Related factors were the crosswind, wind gusts and high vegetation.NTSB NYC97LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering into a snowbank. The proximity of the snowbank was a related factor.NTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.NTSB NYC96LA166Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Bedford, MAThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a ground loop/swerve. The variable wind condition was a related factor.NTSB NYC96LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshfield, MAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control, on-ground collision with terrain, and the aircraft nosing over. The sudden windshift was a related factor.NTSB NYC96LA092Accident · No injuriesLimited investigationFinal reportCessna 175 · Pittsfield, MAthe pilot's inadequate crosswind compensations during the landing roll.NTSB NYC96LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwood, MAFailure of the student pilot to maintain directional control of the airplane after touchdown, which resulted in an inadvertent ground swerve and collision with a snowbank.NTSB NYC95LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Fitchburg, MAThe pilot's failure to adequately compensate for the crosswind condition during landing, which resulted in a ground loop and the subsequent wing tip collision with the runway.NTSB BFO94LA151Accident · Minor injuriesLimited investigationFinal reportGrumman G-44 · Nantucket, MAThe pilot's failure to maintain aircraft control. A factor in the accident was the rough water.NTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.NTSB BFO93LA127Accident · No injuriesLimited investigationFinal reportCessna 172P · Edgartown, MAThe pilot failed to maintain directional control during takeoff. Other related factors were: the tailwind, and the gross weight of the airplane being exceeded.NTSB BFO93LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Marlboro, MAThe pilot failed to maintain control of the airplane during landing. Related to the accident was the excessive airspeed.NTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.NTSB BFO92LA148Accident · No injuriesLimited investigationFinal reportMooney M20E · Stow, MAFailure of the pilot to attain proper runway alignment during landing. Factors related to the accident were darkness, a lack of runway lighting on the left side of the runway, and the pilot's lack of visual ques.NTSB BFO92LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Great Barringto, MAThe pilot's failure to recover from a bounced landing. Factors related to the accident were the pilot's inadequate flare and failure to maintain directional control.NTSB BFO92LA113Accident · No injuriesLimited investigationFinal reportStinson JR.SR. · Hanson, MAThe pilot inadequate compensation for wind which resulted in the loss of directional control.NTSB NYC91LA105Accident · No injuriesLimited investigationFinal reportCessna 170B · Newburyport, MAThe pilot failing to compensate adequately for adverse wind conditions during takeoff.NTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.NTSB NYC91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · North Hampton, MALoss of directional control after landing.NTSB NYC90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Norfolk, MAThe pilot in command's failure to maintain airspeed during an aborted landing resulting in an inadvertent stall and descent into trees.NTSB NYC90LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Marshfield, MAThe pilots failure to maintain directional control during an aborted landing. Factors related to the accident were: the pilots limited experienced in type of airplane, and variable winds.NTSB NYC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Northampton, MAPilot's improper handling of the airplane, resulting in the loss of directional control. Contributing to the accident were gusty wind conditions and the pilot's lack of total experience.NTSB NYC90LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Westfield, MALoss of control during landing due to an improper flare and recovery from a bounced landing. A factor relating to the accident was the lack of total experience of the student pilot.NTSB NYC89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Turners Falls, MALoss of control during landing roll due to ice on the runway, and collision with a snow bank off the runway which sheared the left main landing gear.NTSB NYC89LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hyannis, MAThe acft ran off the runway and hit a landing light and terrain as the pilot attempted to make a crosswind landing, at barnstable airport, Hyannis, MA.NTSB NYC88LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Marlboro, MAThe pilot was attempting a landing at Marlboro airport. Upon touchdown brakes were applied. According to the pilot, the aircraft was not stopping but instead was sliding down the runway. The pilot turned the nosewheel to the left to slow the aircraft but…