NTSB investigations, 1993, MA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 3 |
|---|---|
| 1964 | 64 |
| 1965 | 78 |
| 1966 | 81 |
| 1967 | 71 |
| 1968 | 69 |
| 1969 | 56 |
| 1970 | 87 |
| 1971 | 63 |
| 1972 | 58 |
| 1973 | 72 |
| 1974 | 68 |
| 1975 | 72 |
| 1976 | 45 |
| 1977 | 51 |
| 1978 | 68 |
| 1979 | 34 |
| 1980 | 35 |
| 1981 | 43 |
| 1982 | 38 |
| 1983 | 41 |
| 1984 | 53 |
| 1985 | 38 |
| 1986 | 40 |
| 1987 | 54 |
| 1988 | 29 |
| 1989 | 25 |
| 1990 | 44 |
| 1991 | 26 |
| 1992 | 31 |
| 1993 | 31 |
| 1994 | 33 |
| 1995 | 21 |
| 1996 | 28 |
| 1997 | 21 |
| 1998 | 22 |
| 1999 | 21 |
| 2000 | 29 |
| 2001 | 23 |
| 2002 | 23 |
| 2003 | 22 |
| 2004 | 28 |
| 2005 | 18 |
| 2006 | 16 |
| 2007 | 19 |
| 2008 | 12 |
| 2009 | 14 |
| 2010 | 24 |
| 2011 | 18 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 12 |
| 2017 | 10 |
| 2018 | 9 |
| 2019 | 9 |
| 2020 | 8 |
| 2021 | 10 |
| 2022 | 11 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 10 |
| 2026 | 10 |
Where
Latest 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 year(c.\"eventDate\") = 1993
AND c.\"eventStateOrRegion\" = 'MA' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1993 AND c."eventStateOrRegion" = 'MA' AND c."eventCountry" = 'USA' 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 NYC94LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-301T · Norwood, MAThe pilot's delay in aborting the takeoff which resulted in a overrun of the runway. Factors were a snow covered runway, takeoff speed not attained, brakes not used, and a ditch.NTSB NYC94LA034Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's inability to control the airplane due to alcoholic impairment.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 BFO94LA010Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Sterling, MASeparation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.NTSB BFO94FA008Accident · 2 fatalField investigationFinal reportMooney MO-20J · Seekonk, MAThe pilot's inadequate in flight planning/decision to continue flight into known adverse weather conditions after the engine's dry air vacuum pump failed and the pilot's failure to maintain airplane control during approach. A factor in the accident was the…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 NYC94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Tewksbury, MAwas an improperly planned approach, and excessive compensation for the winds by the pilot which resulted in an overrun, and on ground collision with a fence and vehicle. A factor was the gusty crosswinds.NTSB NYC94LA010Accident · Minor injuriesLimited investigationFinal reportSchlappi RV3 · Hatfield, MAThe pilot misjudged his distance and altitude which resulted in an undershoot of the runway. A factor was his delay in intiating a go around.NTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.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.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.NTSB BFO93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Byfield, MALoss of engine power during climb for undetermined reasons.NTSB BFO93LA149Accident · Serious injuriesLimited investigationFinal reportLach Bensen B-8M · Fall River, MAFATIGUE FAILURE OF THE GYROCOPTER'S MAIN ROTOR CONTROL ARM. fACTORS RELATED TO THE ACCIDENT WERE: A LOOSE CLAMP ON THE ROTOR CONTROL ARM, DUE TO INADEQUATE MAINTENANCE OR INSPECTION, WHICH RESULTED IN CHAFING OF THE CONTROL ARM.NTSB NYC93FA166Accident · 1 fatalField investigationFinal reportPiper PA-25-260 · Plymouth, MAwas the failure of the pilot to attain proper alignment for the banner pickup which resulted in picking up the banner tow rope on the wing, and an inflight loss of control and uncontrolled contact with the ground.NTSB NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.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 BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.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 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.NTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesNTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.NTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.NTSB NYC93FA110Accident · 1 fatalField investigationFinal reportSkillman Thorp T-18 · Chatham, MAthe pilot's performance of an aerobatic maneuver, with insufficient altitude for recovery, resulting in a collision with the waterNTSB NYC93LA106Accident · Serious injuriesLimited investigationFinal reportHenry J. Camacho Seahawk · Orange, MAThe pilot's excessive rotation and failure to obtain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the pilot's inexperience in the type aircraft.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.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 BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC93LA086Accident · No injuriesLimited investigationFinal reportPitts S1T · Halifax, MADetachment of the throttle cable at the fuel injector arm. Soft terrain in the emergency landing area was a related factor.NTSB NYC93FA076Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Oxford, MAThe pilot's selection of the wrong runway for takeoff which resulted in not being able to obtain adequate airspeed for climbout. A factor which contributed to the accident was the tailwind.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 BFO93FA018Accident · 1 fatalField investigationFinal reportCessna 182P · Stow, MAAn inadequate preflight by the pilot, which allowed water contamination in the fuel and subsequent loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall.