NTSB investigations, MA
30 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 2 |
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\" = 240)
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" = 240) 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 ATL07LA115Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Siassconset, MAThe non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.NTSB ATL07FA102Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Tyringham, MAThe pilot's inadvertent encounter with thunderstorms during cruise flight. Contributing to the accident was the failure of air traffic control to appropriately issue weather information and initiate an in-flight deviation around known and clearly observed…NTSB NYC05CA127Accident · No injuriesData collectionFinal reportYakovlev 55M · New Marlboro, MAThe pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.NTSB NYC04FA136Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Leominster, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with trees. A factor related to the accident was the low cloud ceiling, and dark night.NTSB NYC04FA093Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · Pittsfield, MAThe pilot's loss of aircraft control for undetermined reasons, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB NYC03FA061Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Monterey, MAThe pilot's improper decision to attempt a visual flight rules (VFR) flight in marginal VFR weather conditions over mountainous terrain, which resulted in an in-flight collision with trees. Factors in this accident were clouds and night light conditions.NTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…NTSB NYC01LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Falmouth, MAThe pilot's improper decision to takeoff and attempt VFR flight in IMC conditions.NTSB IAD01LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Boston, MAThe airplane's inadvertent encounter with severe turbulence.NTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.NTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…NTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.NTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…NTSB NYC95FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Rehoboth, MAThe pilot's inadvertent flight into hazardous weather, which subsequently resulted in exceeding the design stress limits of the airplane and an in-flight breakup. Factors relating to the accident were: embedded thunderstorms, turbulence, and failure of the…NTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…NTSB NYC92FA047Accident · 1 fatalField investigationFinal reportPiper PA-23-235 · Fall River, MAThe pilot did not follow IFR proceedures and was manuvering at too low an altitude to remain clear of the terrain. Factors in the accident were; fatigue, fog and no visual ground clues.NTSB NYC91FA115Accident · 2 fatalField investigationFinal reportCessna 172G · New Bedford, MAThe pilot's improper planning/decision and failure to maintain proper altitude after encountering adverse weather at low altitude. The adverse weather (fog) was a related factor.NTSB NYC90LA159Accident · No injuriesLimited investigationFinal reportCessna 310R · Hyannis, MAA hard landing due to the pilot stalling the airplane during the landing flare. Contributing to this accident was gusty wind conditions.NTSB NYC89FA099Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Southbridge, MAPoor judgement of the pilot by flying while physically impaired by alcohol, and his continued VFR flight into instrument meteorological conditions (IMC). Related factors were: the pilot's inadequate preflight planning/preparation, dark night, adverse weather…NTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.NTSB NYC86LA174Accident · No injuriesLimited investigationFinal reportHughes 500A · Fall River, MAThe flight encountered fog and haze during return flight to new bedford, Massachusetts. The pilot failed to maintain direction control of the helicopter and crashed into the north watuppa pond.NTSB NYC86FA216Accident · 3 fatalField investigationFinal reportBell 206B · Noman'S Land, MAThe Bell 206 helicopter was en route to nantocket island when the pilot received an inflight weather briefing with VFR flight not recommended. The pilot acknowledged this report and it appears he elected to continue the flight. The acft did not reach it's…NTSB NYC85LA116Accident · No injuriesLimited investigationFinal reportCentrair 101A · Barre, MAThe acft encountered windshear during the approach to land and landed in trees. By the time the plt realized his situation it was too late and his wing tip hit a tree top. The acft camp to rest in trees.NTSB NYC85LA107Accident · No injuriesLimited investigationFinal reportBeech D95A · Boston, MAAccording to the plt, the gear warning horn circuit breaker was pulled en route to stop the horn from sounding while the pwr was at a low setting because of turbulence. The circuit breaker was not reset prior to landing. During the apch,the plt lowered the…NTSB NYC85FA099Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Nantucket, MAAcft collided with trees during final approach to runway 24. No evidence of pre-impact failure or malfunction of the acft was found. Reported wx at crash site indefinite 100 feet sky obscured. RVR 2400 feet. Acft should have encountered a decreasing headwind…NTSB NYC85LA096Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsfield, MADuring a preflt wx briefing, the plt was advised of possible moderate icing in clouds from the surface to 4000 ft. while in flt, structural icing conditions were encountered & rime ice accumulated on the windshield. Also, carb ice conditions were encountered…NTSB NYC84FNA02Accident · No injuriesFinal reportAir & Space Gyroplane 18A · Harwich, MACruising at 500 ft over water the plt encountered fog. In an effort to maintain visual contact with the shoreline the plt began a descent and began a turn to avoid the fog. During the descending turn the acft got low and slow and the plt was unable to control…NTSB NYC83LA143Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Marlboro, MAThe acft ran off the end of the runway while making a precautionary landing due to weather. During the overrun the acft collided with a fence. The pilot was not injured.NTSB NYC83FA078Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · North Adams, MAAt 1145 the plt reported VFR conditions & requested radar vectors to the arpt. He was issued a cruise clearance of 5,000 ft & given a heading. 18 mi from the arpt he reported visual contact with the ground. At 1151 he was asked if he was familiar with the…NTSB NYC82FNA10Accident · Minor injuriesFinal reportCessna 172 · Taunton, MAThe student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported…