NTSB investigations, 2003, 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, 2003, 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\") = 2003
    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 MIA04FA023Accident · 3 fatalField investigationFinal reportBeech G35 · Okolona, MSThe pilot's intentional low altitude maneuver and buzzing resulting in collision with trees, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the pilot's ostentatious display.Nov 21, 2003 · N4214D · DestroyedNTSB MIA04FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Olive Branch, MSThe student pilot's failure to maintain airspeed (Vso), which resulted in an inadvertent stall/spin, an uncontrolled descent, and an impact with terrain. A factor in the accident was his failure to follow the airplane's operating checklist and retract the…Oct 21, 2003 · N75510 · Substantial damageNTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.Oct 4, 2003 · N77NP · Substantial damageNTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.Oct 1, 2003 · N7219H · Minor damageNTSB MIA03LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Ocean Springs, MSThe failure of the pilot to transfer fuel from the auxiliary fuel tank to the right main fuel tank in-flight resulting in total loss of engine power due to fuel starvation.Sep 19, 2003 · N79491 · Substantial damageNTSB MIA03CA148Accident · No injuriesData collectionFinal reportCessna 172S · Olive Branch, MSThe student pilot's improper landing flare/touchdown and inadequate recovery from a bounced landing which resulted in a hard landing and damage to the airplane.Jul 25, 2003 · N970SP · Substantial damageNTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.Jun 24, 2003 · N929TP · Substantial damageNTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.Jun 16, 2003 · N8378W · Substantial damageNTSB MIA03FA122Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Carthage, MSThe failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…Jun 12, 2003 · N232HC · DestroyedNTSB MIA03LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Olive Branch, MSThe pilot's operation of the airplane with known deficiencies (water contamination of the fuel) resulting in loss of engine power shortly after takeoff and damage to airframe during the subsequent forced landing.Jun 10, 2003 · N4658J · Substantial damageNTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.May 30, 2003 · N258P · Substantial damageNTSB MIA03CA108Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Baxterville, MSThe pilot's decision to continue the takeoff at a low airspeed which resulted in a stall, an uncontrolled descent, and an impact with terrain.May 13, 2003 · N82204 · Substantial damageNTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.May 3, 2003 · N175W · Substantial damageNTSB MIA03LA099Accident · No injuriesLimited investigationFinal reportCessna 172D · South Ponotoc, MSthe pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.Apr 27, 2003 · N2371U · Substantial damageNTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.Apr 13, 2003 · N757AZ · Substantial damageNTSB MIA03LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Foxworth, MSThe failure of the pilot to perform a go-around, his failure to attain the proper touchdown point, and his delay in applying the normal brakes resulting in his inability to stop the airplane and subsequent on-ground collision with a fence.Apr 10, 2003 · N738QM · Substantial damageNTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.Mar 21, 2003 · N89811 · Substantial damageNTSB MIA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Leesburg, MSThe pilot's improper use of flaps, resulting in the degradation of climb performance and collision with the ground.Feb 12, 2003 · N22593 · Substantial damageNTSB ATL03LA038Accident · No injuriesLimited investigationFinal reportBeech 200 · Jackson, MSThe failure of the landing gear system for undetermined reasons.Jan 31, 2003 · N208F · Substantial damage