NTSB investigations, 2002, NE

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

19622026
NTSB investigations, 2002, NE per year, 1962–2026: 1,895 cases
19621
196458
196567
196672
196789
196880
196988
197074
197193
197264
197352
197471
197547
197664
197752
197849
197941
198036
198134
198242
198339
198440
198531
198627
198721
198816
198922
199013
199124
199220
199321
199420
199516
199614
199714
199828
199923
200013
200119
200214
200312
200411
200515
200617
200711
200813
200915
201013
20117
201221
201311
201411
201511
201610
20179
201812
201913
20209
20219
202214
202310
202417
202511
20264

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\" = 'NE' 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 CHI02LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369D · O'Neill, NEA loss of engine power due to turbine blade separation as a result of hot corrosion damage to the turbine blades. Contributing to the accident was the pilot misjudging the flare at the completion of the autorotation resulting in a hard landing. The dark night…Sep 17, 2002 · N500EK · Substantial damageNTSB CHI02CA253Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Ohiawa, NEThe pilot failed to verify the aircraft refueling and he did not follow emergency procedures for engine restart. Factors to the accident included fuel starvation and the fence post.Aug 17, 2002 · N8851V · Substantial damageNTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.Aug 12, 2002 · N49998 · DestroyedNTSB CHI02LA242Accident · No injuriesLimited investigationFinal reportRare Waco T-10 · Omaha, NEThe partial loss of engine power due to fuel starvation as a result of a restricted fuel line, and the unsuitable terrain for landing encountered by the pilot. A contributing factor was the bean field.Aug 10, 2002 · N98TW · Substantial damageNTSB CHI02LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, NEThe pilot not maintaining sufficient airspeed during the takeoff, and the inadvertent stall encountered by the pilot. The low altitude was a factor.Aug 4, 2002 · N739VN · Substantial damageNTSB CHI02LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Central City, NEThe pilot was not able to maintain clearance with the trees when the airplane encountered a downdraft at a low altitude. An additional cause was the pilot's inadequate evaluation of the approaching weather conditions. Factors associated with the accident were…Jul 25, 2002 · N5296 · Substantial damageNTSB CHI02LA207Accident · No injuriesLimited investigationFinal reportCessna C180A · Ogallala, NEThe pilot's failure to maintain directional control of the aircraft. The open window diverting the pilot's attention was a contributing factor.Jul 22, 2002 · N5359D · Substantial damageNTSB CHI02CA198Accident · No injuriesData collectionFinal reportBaughman KR-2 · Scribner, NEThe pilot's excessive rotation and his failure to attain climb which resulted in a stall/mush.Jul 13, 2002 · N290KB · Substantial damageNTSB CHI02LA179Accident · No injuriesLimited investigationFinal reportWaltz RV-8 · Omaha, NEA loss of engine power due to a loose connecting rod cap bolt and the resulting fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain.Jun 30, 2002 · N877TC · Substantial damageNTSB CHI02FA174Accident · 3 fatalField investigationFinal reportEurocopter France AS-350-B2 · Norfolk, NEA loss of tail rotor effectiveness and the pilot's failure to maintain control of the helicopter. Factors associated with the accident were the binding of the tail rotor pitch changed rod, the gusty wind conditions, and the pilot’s lack of total experience in…Jun 21, 2002 · N852HW · Substantial damageNTSB CHI02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hordville, NEA loss of engine power due to a fractured rocker arm shaf. Contributing to the accident was the soft, furrowed field.May 10, 2002 · N48485 · Substantial damageNTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.May 9, 2002 · N9135C · Substantial damageNTSB CHI02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Falls City, NEThe deer striking the airplane during landing. A factor relating to this accident was the dark night.Jan 29, 2002 · N56729 · Substantial damageNTSB CHI02LA064Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Wahoo, NEThe student, who was a private pilot, used excessive braking during the landing roll.Jan 18, 2002 · N71677 · Substantial damage