Skip to content

NTSB investigations, MA

46 cases where the first occurrence was “Hard landing”.

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" = 200) 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\" = 200)
  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" = 200)
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 ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.Jul 15, 2007 · N13151 · Substantial damage NTSB NYC07CA046Accident · No injuriesData collectionFinal reportCessna 172R · Northhampton, MAThe pilot's inadequate recovery from a bounced landing.Dec 10, 2006 · N9421Z · Substantial damage NTSB NYC06CA168Accident · No injuriesData collectionFinal reportLiberty Aerospace XL2 · Mansfield, MAThe pilot's improper recovery from a bounced landing.Jul 2, 2006 · N771SF · Substantial damage NTSB NYC06CA059Accident · No injuriesData collectionFinal reportCessna R182 · Bedford, MAThe pilot's improper flare resulting in a hard landing. A factor in the accident was the wind gusts.Jan 21, 2006 · N6278T · Substantial damage NTSB NYC06CA049Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Lawrence, MAThe pilot's improper flare and recovery from a bounced landing.Jan 2, 2006 · N323RB · Substantial damage NTSB IAD05LA111Accident · No injuriesLimited investigationFinal reportCessna 182T · Chatham, MAthe pilot's improper recovery from a bounced landing.Jul 20, 2005 · N1328N · Substantial damage NTSB NYC04CA102Accident · No injuriesData collectionFinal reportCessna 172P · Westfield, MAThe student pilot's improper flare and his failure to maintain aircraft control while landing.Apr 9, 2004 · N5425K · Substantial damage NTSB NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.Mar 24, 2004 · N6535J · Substantial damage NTSB NYC03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Newburyport, MAThe pilot's inadequate compensation for the wind conditions and his inadequate flare.Jul 25, 2003 · N8146Y · Substantial damage NTSB NYC02LA010Accident · No injuriesLimited investigationFinal reportCessna 172L · Northampton, MAThe pilots' failure to maintain airspeed, which resulted in a loss of control and a hard landing.Oct 17, 2001 · N811P · Substantial damage NTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.Apr 9, 2001 · N2462T · Substantial damage NTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.Jul 3, 2000 · N48858 · Substantial damage NTSB IAD99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Nantucket, MAthe pilot's inadequate recovery from a bounced landing which resulted in a hard landing and the fracture and collapse of the right main landing gear.Sep 2, 1999 · N6915Z · Substantial damage NTSB NYC99LA195Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chatham, MAThe pilot's improper flare and improper recovery from a bounced landing.Aug 10, 1999 · N31743 · Substantial damage NTSB NYC99LA086Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrence, MAThe student pilot's improper flare, and his improper recover from a bounced landing.Apr 2, 1999 · N66162 · Substantial damage NTSB NYC99LA052Accident · No injuriesLimited investigationFinal reportBeech 1900D · Hyannis, MAThe captain's improper placement of the power levers in the BETA position, while the airplane was inflight. Factors were the fog and dusk conditions.Jan 22, 1999 · N215CJ · Substantial damage NTSB NYC98LA190Accident · No injuriesLimited investigationFinal reportCessna 172 · Stow, MAThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of a single engine experience/certification. Also a factor was the flying club's inadequate oversight of pilot qualifications.Sep 19, 1998 · N1729V · Substantial damage NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.Jul 23, 1998 · N7406J · Substantial damage NTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.Jul 19, 1998 · N2608Q · Substantial damage NTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.May 16, 1998 · N42770 · Substantial damage NTSB IAD97LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAInadequate compensation for wind conditions by the pilot. A related factor was the crosswind.Aug 2, 1997 · N89242 · Substantial damage NTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.Oct 5, 1996 · N3707R · Substantial damage NTSB NYC96LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Worcester, MAthe pilot's improper recovery from a bounced landing, and his failure to maintain control of the airplane, which resulted in a nose over. His improper flare was a related factor.Aug 10, 1996 · N5431Q · Substantial damage NTSB NYC95LA200Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Hopedale, MAthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a loss of control and collision with a fence and a building.Aug 20, 1995 · N8885V · Destroyed NTSB NYC95LA025Accident · 1 fatalLimited investigationFinal reportLee Pazmany PL-4A · Orange, MAThe pilot's improper flare which resulted in a hard landing, collapse of the main gear, and inflight collision with the ground.Nov 13, 1994 · N337RL · Substantial damage NTSB NYC95LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grt Barrington, MAthe pilot's improper flare during landing, which resulted in a hard landing and the subsequent collapsed landing gear. A factor in this accident was the pilot's lack of total recent flying experience and recent experience in make and model.Oct 7, 1994 · N44794 · Substantial damage NTSB BFO93LA174Accident · No injuriesLimited investigationFinal reportCessna 182L · Oxford, MAThe failure of the CFI to maintain a proper descent rate, and his delay in performing remedial action. Factors related to the accident are the downdraft, the gusting winds, and the soft runway.Sep 13, 1993 · N42233 · Substantial damage NTSB BFO93LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Falmouth, MAThe pilot's inadequate compensation for wind conditions and improper recovery from a bounced landing. The gusty wind condition was a related factor.Jul 6, 1993 · N4325W · Substantial damage NTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.Jun 8, 1993 · N64932 · Substantial damage NTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.May 1, 1993 · N49394 · Substantial damage NTSB NYC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Edgartown, MAImproper recovery from a bounced landing by the pilot. Factors related to the accident were improper use of the flight controls and throttles.Oct 19, 1991 · N14189 · Substantial damage NTSB NYC90DNE04Accident · Minor injuriesFinal reportRotorway RW 152 · Southwick, MAA hard landing due to improper use of the rotorcraft flight controls, and the decision to put fuel in only one side.Aug 4, 1990 · UNREG · Substantial damage NTSB NYC88LA123Accident · No injuriesLimited investigationFinal reportCessna 185 · Hopedale, MAThe pilot said he flared too high and landed hard. The pilot stated that the prop contacted the ground, the right landing gear broke, and the rt wing contacted the ground and was bent rearward during the hard landing. The plt did not file an acc report.Apr 11, 1988 · N4695E · Substantial damage NTSB NYC88LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chatham, MAThe duration of the pleasure flight was about 25 minutes and was uneventful. The pilot made the approach and entered the traffic pattern in the standard manner and radioed UNICOM of her intentions to land. The pilot stated that she landed longer than usual…Nov 1, 1987 · N757PY · Substantial damage NTSB NYC87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marlboro, MAThe pilot allowed the aircraft to stall and touch down hard causing substantial damage. The pilot was unfamiliar with the short field at this airport.Feb 6, 1987 · N1486X · Substantial damage NTSB NYC86LA204Accident · No injuriesLimited investigationFinal reportHughes 369HS · Norwood, MAThe plt was practicing an autorotation from a closed traffic pattern to the numbers on rwy 35. He rprtd that he made a normal flare & power recovery. However, as the helicopter was nosing forward out of the flare, the plt heard a noise & felt a percussion…Aug 10, 1986 · N369B · Substantial damage NTSB NYC85LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stow, MAPiper PA28-181N82054 landed hard on runway 3 at minute man airport, Stow, mass. The student was performing touch and go landings, on one landing, the pilot stated that the aircraft bounced and then veered to the left. Rudder was applied but there was no…May 7, 1985 · N82054 · Substantial damage NTSB NYC84LA197Accident · No injuriesLimited investigationFinal reportCessna C172 · Mansfield, MAStudent plt on first solo landed hard due to late flare. The acft touched down on the nose gear resulting in substantialdamage. A go-around was accomplished followed by an uneventful landing.May 15, 1984 · N9654Q · Substantial damage NTSB NYC84LA171Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Spencer, MAAccording to the plt, the purpose of the flt was to practice autorotations. During practice, the acft touched down hard & was substantially damaged.May 11, 1984 · N9220 · Substantial damage NTSB NYC84LA303Accident · No injuriesLimited investigationFinal reportCessna R182 · Boston, MAAccording to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS.Mar 3, 1984 · N9159C · Substantial damage NTSB NYC84FNA01Accident · Serious injuriesFinal reportMooney M20E · Falmouth, MAAccording to witnesses, the acft circled the field and then came in for landing. On final aprch the acft was in a left wing low crab. Upon touchdown the acft bounced touched again and then the left wing touched the ground. The pilot applied full power and the…Oct 8, 1983 · N3438X · Substantial damage NTSB NYC82DA234Accident · No injuriesFinal reportCessna 150D · Hyannis, MAThe pilot stated that she was cleared for landing on runway 24. She stated that as she turned onto final, and the aircraft was high, an additional notch of flaps was added. The descent to the runway was at approximately 90 mph. The aircraft touched down in…Sep 25, 1982 · N4149U · Substantial damage NTSB NYC82DA228Accident · No injuriesFinal reportCessna 152 · Hyannis, MAAfter returning from a cross-country, the pilot landed on runway 23. The wind was reported to be from 240 deg at 10, gusting to 20 KTS. The pilot reported that during the landing, the plane touched down on the main gear, and nosed over onto the propeller. He…Sep 18, 1982 · N46872 · Destroyed NTSB NYC82DA194Accident · No injuriesFinal reportCessna 172M · Marlboro, MAThe solo student was practicing landings, flared the aircraft too high, then stalled and made a hard landing. The nose gear collapsed and the aircraft nosed over.Aug 12, 1982 · N5451H · Substantial damage NTSB NYC82DA144Accident · Minor injuriesFinal reportErcoupe 415-C · Mansfield, MAWitnesses reported that the aircraft bounced during touchdown and began porpoising. After bouncing 4 or 5 times, the nose tire blew out. Subsequently, the aircraft vee ed off the runway and nosed over.Jul 3, 1982 · N93358 · Substantial damage NTSB NYC82DA092Accident · No injuriesFinal reportPiper PA-28-140 · North Andover, MADuring landing the aircraft bounced and touched down on the center of runway 05. When the nosewheel was lowered the aircraft swerved to the right. According to the pilot, manipulation of the rudder pedals failed to change the direction or rate of turn of the…May 13, 1982 · N15878 · Substantial damage