NTSB investigations, 2002, MA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19632026
NTSB investigations, 2002, MA per year, 1963–2026: 2,104 cases
19633
196464
196578
196681
196771
196869
196956
197087
197163
197258
197372
197468
197572
197645
197751
197868
197934
198035
198143
198238
198341
198453
198538
198640
198754
198829
198925
199044
199126
199231
199331
199433
199521
199628
199721
199822
199921
200029
200123
200223
200322
200428
200518
200616
200719
200812
200914
201024
201118
201210
201310
201412
201510
201612
201710
20189
20199
20208
202110
202211
20236
20247
202510
202610

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\") = 2002
    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.

NTSB NYC03LA028Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Dalton, MAThe pilot's inadequate preflight inspection of the aircraft, which resulted in a total loss of engine power due to fuel contamination. A factor was the cold air temperature.Dec 4, 2002 · C-FXJK · Substantial damageNTSB IAD03LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Leeds, MAThe flight instructor's failure to ensure adequate fuel onboard, which resulted in fuel exhaustion and a total loss of engine power.Dec 4, 2002 · N2706L · Substantial damageNTSB 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.Nov 23, 2002 · N1152F · Substantial damageNTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.Nov 13, 2002 · N2165Y · DestroyedNTSB NYC03LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, MAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel contamination. Factors in this accident were the corroded fuel tanks caps, and an inadequate annual inspection.Oct 20, 2002 · N47147 · Substantial damageNTSB IAD03IA007Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Boston, MAAn inadvertant collision with birds during the initial climb out.Oct 19, 2002 · N607UA · Minor damageNTSB NYC03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Edgartown, MAThe pilot's inadequate in-flight evaluation of the landing facilities wind conditions, and inadequate airspeed resulting in a stall/mush. A factor related to the accident was the tailwind condition.Oct 1, 2002 · N8071Z · Substantial damageNTSB IAD02LA094Accident · 1 fatalLimited investigationFinal reportGarlick OH-58AT · Rochester, MAThe pilot's failure to center the sling load prior to commencing forward flight. Also causal, was the pilot's improper decision to attempt a takeoff with a quartering tailwind, which resulted in an engine compressor stall.Sep 14, 2002 · N444JB · Substantial damageNTSB IAD02LA092Accident · No injuriesLimited investigationFinal reportGoff Glassair · Stow, MAThe pilot's improper positioning of the throttle during engine start, which resulted in his inability to maintain control of the airplane.Sep 6, 2002 · N7223R · Substantial damageNTSB NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.Sep 1, 2002 · N5091X · Substantial damageNTSB NYC02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · New Bedford, MAThe pilots failure to obtain the proper touchdown point, and the CFI's delay in remedial action.Aug 19, 2002 · N9030P · Substantial damageNTSB 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…Aug 16, 2002 · N20787 · Substantial damageNTSB NYC02LA163Accident · No injuriesLimited investigationFinal reportNiemann Champion II · Foxboro, MAThe pilot's failure to maintain aircraft control during the landing flare.Aug 13, 2002 · N7072X · Substantial damageNTSB IAD02TA081Accident · 1 fatalFinal reportCrawford Widebody Long EZ · Martha's Vineyard, MAPilot incapacitation from a massive subarachnoid hemorrhage (stroke.)Aug 3, 2002 · N3R · Substantial damageNTSB NYC02LA143Accident · No injuriesLimited investigationFinal reportBeech 58 · Provincetown, MAThe pilot's failure to initiate a timely go-around, which resulted in his landing the airplane long and fast. Factors included low ceilings and the airplane's initial misalignment with the runway.Jul 19, 2002 · N9280Q · Substantial damageNTSB NYC02LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Newburyport, MAA power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.Jul 6, 2002 · N823DA · Substantial damageNTSB NYC02LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Worcester, MAThe failure of the nose wheel actuator o-ring.Jun 11, 2002 · N4652T · Substantial damageNTSB NYC02LA099Accident · No injuriesLimited investigationFinal reportBoucher Revolution Mini 500 · Sterling, MAA misalignment of the rotor system drive belt, which resulted in belt chaffing, its subsequent separation, and a resultant loss of power to the rotor system. Also causal was the relatively low altitude and airspeed at which the separation occurred, which…Jun 8, 2002 · N54VP · DestroyedNTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.May 10, 2002 · N172EF · Substantial damageNTSB NYC02LA052Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Marlborough, MAThe pilot's failure to achieve a proper touchdown point on the runway which resulted in an overrun. A factor was the pilot's lack of experience in short field operations.Jan 26, 2002 · N28239 · Substantial damageNTSB 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.Jan 14, 2002 · N3997R · Substantial damageNTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.Jan 12, 2002 · N6315R · Substantial damageNTSB 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…Jan 1, 2002 · N117BB · Substantial damage