NTSB investigations, 2002, MS

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

19642026
NTSB investigations, 2002, MS per year, 1964–2026: 1,742 cases
196454
196569
196662
196758
196850
196954
197040
197158
197252
197332
197451
197544
197636
197756
197849
197944
198043
198145
198236
198321
198429
198523
198626
198734
198826
198936
199020
199125
199220
199326
199420
199535
199622
199722
199825
199938
200024
200123
200216
200319
200418
200519
200612
200720
200816
200919
20108
201116
201219
201313
201412
201510
20167
201711
20186
201913
20207
202111
20229
20238
20248
202510
20267

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\" = 'MS' 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 MIA03LA014Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · Foxworth, MSThe pilots failure to properly recover from a stalled/mush/high sink rate condition during an approach and attempted aborted landing into a gusting crosswind, resulting in a hard touchdown, bounced landing, loss of directional control and in-flight collision…Nov 10, 2002 · N990PT · Substantial damageNTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.Sep 11, 2002 · N5724P · Substantial damageNTSB ATL02LA174Accident · No injuriesLimited investigationFinal reportBeech B-55 · Jackson, MSThe left wing tank fuel quantity transmitter unit was leaking fuel, and the leaking fuel was ignited by engine exhaust during engine start.Sep 5, 2002 · N8821M · Substantial damageNTSB MIA02LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hernando, MSThe pilot's operation of the airplane with known deficiencies ( contaminated fuel system) which resulted in fuel starvation, a forced landing to a cotton field, and damage to the airplane during the landing.Aug 27, 2002 · N120S · Substantial damageNTSB MIA02LA143Accident · No injuriesLimited investigationFinal reportCessna A188B · Indianola, MSThe failure of the pilot to maintain clearance with a transmission wire resulting in the collision and substantial damage.Aug 2, 2002 · N4723Q · Substantial damageNTSB ATL02LA146Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A · Indianola, MSThe pilot's failure to maintain airspeed which resulted in a stall and the subsequent uncontrolled collision with the ground while maneuvering for an aerial application run.Jul 31, 2002 · N6236M · Substantial damageNTSB MIA02LA134Accident · Serious injuriesLimited investigationFinal reportSaab-Scania SF340B · Tupelo, MSThe failure of the ground agent to follow procedures and directives and to maintain a visual lookout due to a diversion of attention caused by paperwork being sucked toward the rotating propeller, resulting in collision between her hand and the propeller.Jul 16, 2002 · N403XJ · No damageNTSB ATL02LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Picayune, MSThe pilot's misjudged the touch down point on the runway and collided with the ground short of the runway.Jun 27, 2002 · N6708W · Substantial damageNTSB MIA02LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Meridian, MSinadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.Jun 7, 2002 · N697MA · Substantial damageNTSB ATL02LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Tunica, MSThe pilot's improper control of cyclic, resulting in impact with terrain and a subsequent dynamic rollover.Jun 4, 2002 · N8380H · Substantial damageNTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.May 23, 2002 · N2925B · Substantial damageNTSB ATL02LA100Accident · 2 fatalLimited investigationFinal reportTaber Lancair Super ES · Hattiesburg, MSThe pilot's failure to maintain airspeed during takeoff which resulted in an inadvertent stall and subsequent collision with the ground.May 16, 2002 · N600MT · DestroyedNTSB MIA02LA088Accident · No injuriesLimited investigationFinal reportCessna 180 · Canton, MSthe pilot's failure to maintain directional control after landing which resulted in the airplane departing the runway, and the subsequent impact with a ditch.Apr 21, 2002 · N180CW · Substantial damageNTSB ATL02IA065Incident · No injuriesIncident investigationFinal reportBeech C24R · Greenville, MSAn overload failure of the nose gear assembly for undetermined reasons.Mar 14, 2002 · N6753L · Minor damageNTSB ATL02LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Schlater, MSan unknown person at an unknown time exceeded the engine temperature limitations that resulted in the failure of compressor turbine and the subsequent loss of engine power during takeoff.Mar 5, 2002 · N9185F · Substantial damageNTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.Jan 8, 2002 · N48031 · Substantial damage