NTSB investigations, MA
50 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1990 | 5 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 2 |
| 2004 | 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\" = 220)
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" = 220) 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 NYC04CA166Accident · No injuriesData collectionFinal reportRobinson R-44 II · Beverly, MAThe pilot's inadequate visual lookout, which resulted in a collision with transmission wires.NTSB NYC04CA128Accident · Serious injuriesData collectionFinal reportCameron Balloons N90 · Whately, MAThe pilot's failure to maintain clearance from the trees. A factor was windshear.NTSB NYC03CA157Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS-4 · Ashburnham, MAThe pilot's improper in-flight decision to over fly a suitable landing area. Factors in this accident were weak thermal lift activity, and lack of suitable terrain at the time of the landing.NTSB IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.NTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.NTSB IAD03IA007Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Boston, MAAn inadvertant collision with birds during the initial climb out.NTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.NTSB IAD02LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, MAThe pilot's delayed aborted landing and his failure to attain obstacle clearance. The pilot's misjudgment of distance is a contributing factor.NTSB NYC02LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · Sterling, MAThe student pilots inadequate compensation for wind conditions which resulted in an off-field landing, and the CFI's improper decision to allow the student to fly solo. Factors related to the accident were the gusting wind conditions, and the students lack of…NTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.NTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.NTSB NYC01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Somerset, MAThe pilot's inadequate visual lookout. A factor was the dusk lighting conditions.NTSB NYC01FA005Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-26A · Edgartown, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with a tree. A factor related to the accident was the low cloud ceiling.NTSB NYC00LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nantucket, MAThe pilot's failure to maintain the proper glide path to the runway. Factors related to the accident were the fog conditions and the pilot’s fatigue.NTSB IAD00FA023Accident · 1 fatalField investigationFinal reportAerotechnik L-13 SEH Vivat · Plymouth, MAthe flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.NTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.NTSB NYC98LA171Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Marston Mills, MAThe pilot's improper landing flare and his delayed go-around.NTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.NTSB NYC97FA173Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Hancock, MAThe pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.NTSB NYC96LA145Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Carver, MAthe pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.NTSB NYC95LA101Accident · No injuriesLimited investigationFinal reportBell 206B · Hamilton, MAthe pilot's improper decision to fly at night with a night vision deficiency, and his failure to maintain clearance with trees during takeoff, which resulted in an in-flight collision with the trees and the subsequent hard landing.NTSB NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.NTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.NTSB NYC94LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Chatham, MAThe pilot's failure to see and avoid the birds. The presence of the birds at the airport was a contributing factor.NTSB NYC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hopedale, MAthe certified flight instructor's delay in taking remedial action by not initiating the go-around, resulting in the in-flight collision with the tree.NTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.NTSB NYC94LA017Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Littleton, MAThe flight instructor's inadequate in-flight decision in the selection of the simulated forced landing area, and his delay in initiating a go around which resulted in the airplane colliding with trees.NTSB NYC93FA026Accident · 2 fatalField investigationFinal reportBeech 55 · Leicester, MAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were the pilot's lack of recent flight experience and his lack of recent instrument experienced.NTSB BFO92FA131Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Conway, MAThe pilot's failure to maintain clearance above the trees. A possible factor related to the accident was the pilot's use of a prescription drug.NTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.NTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB NYC91FA080Accident · Serious injuriesField investigationFinal reportBeech F-33A · West Brookfield, MAThe decision of the pilot to fly the airplane in conditions that prevented him from seeing and avoiding higher terrain. Factors related to the accident were the pilot's decision to not follow the instrument approach into palmer, and the reduced visibility due…NTSB NYC91LA024Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Buckland, MAThe pilot's failure to execute an aerobatic maneuver at an altitude sufficient to clear the stand of trees.NTSB NYC90FA176Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · North Andover, MAThe controller issued an unauthorized alternate missed approach procedure that did not provide adequate terrain clearance, and the pilot delayed obtaining a proper rate of climb during the missed approach. Factors related to the accident were: darkness and…NTSB NYC90FA171Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Gt. Barrington, MAThe pilot in command's failure to properly maintain the engine, the inadequate annual maintenance inspection, low compression, and improper magneto timing. A factor was the resultant deteriorated climb performance.NTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.NTSB NYC90FA051Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Great Barrngton, MAFailure of the pilot to maintain proper altitude and clearance from trees while departing from the airport. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, his allowing the aircraft weight and balance to be…NTSB NYC87FA251Accident · 2 fatalField investigationFinal reportCessna 152 · Boxborough, MAThe IFR flight from auburn-lewiston, Maine to the manchester, new hampshire VORTAC facility was without incident. Boston center cleared the flight for the vor/dme instrument approach procedure to runway 21 at the uncontrolled stow/minute man airport, stow,…NTSB ATL87MA041Accident · 6 fatalMajor investigationFinal reportBeech 100 · Windsor, MADrg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM…NTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.NTSB NYC86LA007Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Sterling, MAThe acft contacted trees while making an apch to rwy 34 at Sterling, Massachusetts. The acft crashed about 100 ft short of the rwy. The plt stated that a severe downdraft was encountered and then a rapid rate of descent followed. The left main gear struck…NTSB NYC85LA242Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ware, MAThe student plt and CFI were practicing full stop night landings when the accident occurred. While on final apch for thefourth landing, the acft collided with trees 1.7 NM short of the rwy.NTSB NYC85LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Nantucket, MAThe acft was observed in a medium left bank turning through a south southwest heading as it appeared from the clouds. The acft continued to descend in that attitude until it collided with the trees about 3.5 miles southeast of the arpt. The plt and passenger…NTSB NYC85LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Hancock, MAThe acft was under contract to the Massachusetts state environmental department. It was being used for aerial observation of forest fires & for the disposition of ground fire fighting personel & equipment. The plt reported that while he was attempting to find…NTSB NYC84FU003Accident · 1 fatalFinal reportPanaplane Pappillon · Pepperell, MAThe airman took off on his first solo flt after one and one half hours of ground instruction and no flt instruction. Theflt proceeded after a normal takeoff to turn left at about 50 ft AGL to avoid a hanger. After a precise 90 degree turn, the acft continued…NTSB NYC84FA085Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Templeton, MAThe acft collided with trees on unlgtd terrain at ngt after making a low pass at aprx 60 ft AGL with the gear extended. Witnesses reported that the acft's clearance lights were not operating until the rwy lights were turned on, then they observed the acft's…NTSB NYC83LA225Accident · No injuriesLimited investigationFinal reportCessna 182C · New Salem, MAThe acft collided with high tension wires while flying at about 100 ft AGL. The plt landed in the water and all 4 occupants evacuated safely. The ditching was controlled but the acft nosed over after impact. The passengers said they had no trouble until they…NTSB NYC82DA141Accident · No injuriesFinal reportGrumman American AA-5A · Marstons Mills, MAThe pilot stated that the aircraft was slow to gain normal lift-off speed due to the surface of the airstrip. He also stated that after prematurely vaulting the aircraft into the air the aircraft never gained sufficient airspeed for a climb. The aircraft…NTSB NYC82FNA20Accident · No injuriesFinal reportSmith Aerostar 601 · Martha'S Vineyard, MADuring an ILS with the autopilot coupler on, a high sink rate developed toward the end of the approach. The pilot uncoupled the autopilot and began a missed approach, but the aircraft hit the top of a tree. He diverted and landed at providence, RI without…NTSB NYC82FNA15Accident · Minor injuriesFinal reportAeronca 7AC · Danvers, MADuring the previous flight, the aircraft had run out of fuel and was successfully landed in an open field. This occurred while the fuel gauge was indicating 1/4 full. The pilot serviced the plane with 5 gallons of no-lead auto fuel and stripped it of excess…