Skip to content

NTSB investigations, MA

28 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

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 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" = 310) 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 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\" = 310)
  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" = 310)
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 NYC06LA114Accident · Minor injuriesLimited investigationFinal reportEmbraer EMB-145-LR · Boston, MAThe tug driver's inadequate visual lookout, which resulted in a collision with a parked airplane. A factor was the fog.May 12, 2006 · N275SK · Substantial damage NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.Apr 11, 2006 · N4359D · Substantial damage NTSB NYC06LA074Accident · No injuriesLimited investigationFinal reportBoeing 757-232 · Boston, MAThe deice vehicle driver's failure to maintain clearance from a standing airplane, which resulted in a collision between the deice vehicle and left elevator of the airplane.Feb 26, 2006 · N697DL · Substantial damage NTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.Jul 28, 2005 · N28860 · Substantial damage NTSB IAD05CA014Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe pilot's improper decision to taxi on a closed taxiway, and his misjudgment of obstacle clearance.Nov 19, 2004 · N2120M · Substantial damage NTSB NYC04CA003Accident · No injuriesData collectionFinal reportBoeing 737 · Boston, MAThe collision of a ground support vehicle with a parked aircraft, due to the faulty gearshift lever on the ground support vehicle.Oct 4, 2003 · N972AN · Substantial damage NTSB NYC03LA135Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135-KL · Boston, MAThe tug driver's failure to maintain directional control of the tug, which caused the tug to impact the airplane.Jun 24, 2003 · N839AE · Substantial damage NTSB NYC01LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Plymouth, MAThe pilot's failure to ensure the magnetos were off prior to rotating the propeller, which resulted in an unintentional engine start and subsequent unmanned taxi.Jul 3, 2001 · N3042M · Substantial damage NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.Apr 9, 2001 · N328AA · 2 aircraft · Minor damage NTSB NYC01LA077Accident · No injuriesLimited investigationFinal reportFokker F28 MK 0100 · Boston, MAthe failure of the flight crew to follow the checklist prior to engine start, and their subsequent diverted attention during engine start.Feb 6, 2001 · N1457B · Substantial damage NTSB NYC01LA067Accident · No injuriesLimited investigationFinal reportRockwell 112A · Norwood, MAThe pilot's improper starting procedure, which resulted in an on-ground collision with a parked aircraft.Dec 24, 2000 · N1307J · Substantial damage NTSB NYC00LA252Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Northampton, MAThe pilot's improper preflight planning which resulted in an attempted takeoff from a taxiway. A factor in the accident was the fog.Sep 7, 2000 · N601WK · Substantial damage NTSB NYC97LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Norwood, MAfailure of the pilot to perform a go-around, when an animal obstructed the runway; and his failure to maintain clearance from an obstruction (VASI). Factors relating to the accident were: darkness, an animal (deer) on the runway, and the proximity of the…Nov 2, 1996 · N1216T · Substantial damage NTSB NYC96LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAan animal (deer) that wandered onto the runway. The light condition (at dusk) was a related factor.Jun 30, 1996 · N48750 · Substantial damage NTSB BFO94LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-32 · Plymouth, MAThe pilot-in-command's improper in-flight planning and decision. A factor related to the accident is a downdraft.Jun 26, 1994 · N1175S · Substantial damage NTSB NYC94LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Norwood, MAThe inadequate supervision by the instructor pilot during the landing, resulting in the improper runway alignment by the student pilot, and the subsequent collision with a snowbank. A factor related to the accident was the incomplete runway snow removal.Mar 16, 1994 · N7303R · Substantial damage NTSB NYC94LA050Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Plymouth, MAThe pilot's failure to maintain adequate clearance of the fuel truck from the aircraft, which resulted in the main rotor striking the fuel hose and truck during refueling operation. A factor was the pilot's failure to follow company policy pertaining to the…Mar 1, 1994 · N7043J · Substantial damage NTSB BFO93LA172Accident · No injuriesLimited investigationFinal reportCessna 172L · Gr Barrington, MAThe pilot's inadequate compensation for the crosswind which resulted in his loss of directional control during the landing roll and subsequent collision with the parked airplanes. A related factor was the pilot's lack of experience.Sep 12, 1993 · N7064Q · Substantial damage NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.Jun 13, 1992 · N3117 · Substantial damage NTSB NYC90LA214Accident · No injuriesLimited investigationFinal reportCessna 120 · Southbridge, MAThe pilot improper starting procedures.Sep 8, 1990 · N89697 · Substantial damage NTSB NYC89LA215Accident · No injuriesLimited investigationFinal reportBeech 1900C · Boston, MAThe failure of the ground personnel to safely guide the aircraft so that it would have cleared the jetway.Sep 1, 1989 · N318BH · Substantial damage NTSB NYC88LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage.Dec 24, 1987 · N32560 · Substantial damage NTSB NYC87LA117Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Boston, MADuring taxi operations in preparation for a takeoff from Boston logan airport, the Beech aircraft was struck by a ground vehicle and substantially damaged.Apr 7, 1987 · N811BE · Substantial damage NTSB NYC87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Bedford, MADuring taxi operation in preparation for takeoff, the left main gear of the aircraft impacted an unmarked open manhole and the aircraft was substantially damaged.Mar 27, 1987 · N40958 · Substantial damage NTSB NYC84LA299Accident · No injuriesLimited investigationFinal reportBeech A23A · Mansfield, MAAfter a night landing, the plt went to the end of the rwy, then started a 180 deg turn to the right onto a parallel taxiway. He intended to head the opposite direction on the taxiway, which was not lighted. As he turned, the landing light (installed on the…Sep 2, 1984 · N613AW · Substantial damage NTSB NYC84LA252Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAN49985 landed on rwy 32 and turned off rwy at midfield intersection. Acft came to full stop to retract flaps and turn off carb heat. Plt stated a check for other traffic who made at this time. Student plt began taxiing to ramp with landing light off, nav…Jul 25, 1984 · N49985 · 2 aircraft · Substantial damage NTSB NYC84LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chatham, MAAfter landing, as the plt was taxiing to the parking area, the acft hit a rwy identifier sign. The left horizontal stabilizer, elevator & rudder were damaged. The plt said the sign was painted black & was not clearly visible. Also, the sign was not of a…Mar 25, 1984 · N84074 · Substantial damage NTSB NYC82FNA13Accident · No injuriesFinal reportBeech E33 · Bedford, MAThe pilot was unable to start the aircraft with the electric starter when the battery had insufficient power to crank the engine. The pilot stated that he shut off the battery and alternator switches, turned off the magneto switch, and removed the keys. He…May 11, 1982 · N7457N · Substantial damage