Fatal NTSB investigations, 2002, NJ

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

19642026
Fatal NTSB investigations, 2002, NJ per year, 1964–2026: 341 cases
19648
19657
19667
19679
19689
196911
197010
197113
19725
19737
197410
19757
19767
19773
19787
19798
198010
19816
19824
19839
198410
198511
198613
19876
19885
19896
19903
19915
19925
19938
19948
19956
19967
19976
19983
19998
20002
20012
20026
20032
20042
20058
20064
20072
20085
20093
20103
20112
20122
20132
20142
20153
20164
20173
20183
20192
20212
20223
20233
20254

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\" = 'NJ' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 NYC03FA021Accident · 2 fatalField investigationFinal reportMooney M10 · Fairfield, NJThe inadequate visual lookout of both pilots. Factors in the accident were the FAA controller's failure to provide a traffic advisory, the improper decision among the three controllers to leave only one controller in the cab, and night conditions.Nov 16, 2002 · N9502V · 2 aircraft · Substantial damageNTSB NYC02FA200Accident · 1 fatalField investigationFinal reportMooney M20E · West Creek, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.Sep 30, 2002 · N5556Q · DestroyedNTSB IAD02FA091Accident · 2 fatalField investigationFinal reportPiper PA 32R-301T · Byram Township, NJthe improper manufacturing of the crankshaft gear bolt, which resulted in the failure of the bolt due to hydrogen embrittlement, and the subsequent loss of engine power. Also causal was the engine manufacturer's failure to remove the affected bolts from fixed…Sep 8, 2002 · C-GKLY · DestroyedNTSB IAD02FA074Accident · 1 fatalField investigationFinal reportWehrlen Glassair II RG · Jackson, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with terrain.Jul 20, 2002 · N79CW · DestroyedNTSB NYC02FA126Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Farmingdale, NJThe pilot's failure to maintain directional control during takeoff.Jul 1, 2002 · N2414P · DestroyedNTSB NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…Mar 9, 2002 · N2BS · Destroyed