NTSB investigations, 2003, OK

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, OK per year, 1964–2026: 2,798 cases
1964108
1965105
1966100
1967134
1968100
196999
197081
1971102
197256
197377
197466
197560
197666
197772
197863
197966
198064
198179
198263
198364
198465
198547
198642
198745
198838
198940
199029
199130
199236
199323
199432
199542
199635
199731
199841
199936
200031
200124
200226
200322
200423
200525
200621
200728
200825
200923
201023
201119
201218
201323
201411
201517
201621
201720
201815
201915
202018
202117
202222
202323
202419
202519
202613

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\" = 'OK' 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 FTW04LA046Accident · No injuriesLimited investigationFinal reportBell 206B · Henryetta, OKThe pilot's inadequate visual look out and failure to maintain clearance from guy wire while maneuvering for landing.Dec 20, 2003 · N62HF · Substantial damageNTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.Dec 2, 2003 · N815M · Substantial damageNTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.Nov 6, 2003 · N57V · DestroyedNTSB FTW04LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Henryetta, OKA loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.Oct 26, 2003 · N8090E · Substantial damageNTSB FTW04LA003Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Pauls Valley, OKThe loss of engine power for undetermined reasons.Oct 5, 2003 · N845 · DestroyedNTSB FTW03LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wayne, OKA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. Factors were the lack of suitable terrain for the forced landing.Sep 19, 2003 · N3336M · Substantial damageNTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.Sep 11, 2003 · N9651Q · Substantial damageNTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.Aug 23, 2003 · N113JG · Substantial damageNTSB FTW03CA205Accident · No injuriesData collectionFinal reportCessna 195 · Sand Springs, OKThe pilot's failure to maintain directional control during the landing roll.Aug 22, 2003 · N9882A · Substantial damageNTSB FTW03LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bristow, OKThe pilot's premature retracting of the flaps, and his failure to maintain airspeed which resulted in an inadvertent stall.Jun 25, 2003 · N20679 · Substantial damageNTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.Jun 21, 2003 · N8548S · DestroyedNTSB FTW03LA167Accident · No injuriesLimited investigationFinal reportManweiler Acro Sport II · Bartlesville, OKThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion. A related factor was the lack of suitable terrain.Jun 7, 2003 · N94SM · Substantial damageNTSB FTW03LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Guymon, OKThe pilot's inadequate compensation for the crosswind, and his failure to maintain directional control. A factor was the crosswind.May 25, 2003 · N6578E · Substantial damageNTSB FTW03LA151Accident · No injuriesLimited investigationFinal reportCessna A188B · Kinta, OKThe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's failure to supervise the refueling of the aircraft and failure to use his before takeoff checklist.May 15, 2003 · N4931R · Substantial damageNTSB FTW03FA145Accident · 2 fatalField investigationFinal reportBell Shelby Aero 47G2 · Ardmore, OKThe pilot's failure to control the rate of descent, which resulted in an improper touchdown of the helicopter. A contributing factor was the loss of throttle control for undetermined reasons.May 7, 2003 · N1774 · DestroyedNTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.Apr 28, 2003 · N60819 · DestroyedNTSB FTW03LA140Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Ardmore, OKThe pilot's failure to maintain directional control during liftoff. A contributing factor was the inadvertent encounter of propeller blast from the other airplane starting at the time of takeoff.Apr 20, 2003 · N2341Z · Substantial damageNTSB FTW03LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Apr 7, 2003 · N116SS · Substantial damageNTSB FTW03FA120Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Broken Arrow, OKFailure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…Mar 31, 2003 · N70NZ · DestroyedNTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Mar 26, 2003 · N6947X · Substantial damageNTSB FTW03LA091Accident · No injuriesLimited investigationFinal reportGilbertson Zodiac CH601HDS · Grandfield, OKThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.Feb 1, 2003 · N474BG · Substantial damageNTSB FTW03FA086Accident · 1 fatalField investigationFinal reportCessna 152 · Norman, OKThe pilot's failure to maintain airspeed while maneuvering, resulting in an inadvertent stall . Factors contributing to the accident were the low altitude and the prevailing high winds.Jan 21, 2003 · N47257 · Destroyed