NTSB investigations, 2003, IN

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

19632026
NTSB investigations, 2003, IN per year, 1963–2026: 2,978 cases
19631
1964107
1965116
1966119
1967132
1968106
196988
197083
197181
197288
197377
197466
197586
197678
197790
197895
197970
198076
198152
198255
198354
198455
198554
198658
198753
198866
198945
199042
199133
199229
199335
199438
199533
199631
199736
199835
199922
200034
200129
200225
200320
200426
200520
200628
200723
200822
200930
201027
201126
201226
201322
201416
201519
201623
201722
201819
201922
202017
202121
202221
202316
202417
202513
20269

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\" = 'IN' 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 CHI04LA032Accident · Serious injuriesLimited investigationFinal reportHughes TH-55A · West Lafayette, INThe fractured cluster fitting resulting in a loss of directional control during initial climb and the improper repair of cluster fitting by unknown personnel. The night conditions were a contributing factor.Nov 18, 2003 · N9240D · Substantial damageNTSB CHI04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 · Florence, INThe pilot prematurely lifted off during the takeoff with inadequate airspeed which resulted in the airplane stalling. Factors associated with the accident were there unsuitable/rough terrain that the pilot used for takeoff.Oct 8, 2003 · N71027 · Substantial damageNTSB CHI04LA005Accident · No injuriesLimited investigationFinal reportWaco CTO · Greenfield, INThe loss of engine power during cruise and subsequent fire for undetermined reasons.Oct 7, 2003 · N9577H · DestroyedNTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.Sep 29, 2003 · N978T · Substantial damageNTSB CHI03LA319Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shoals, INThe pilot not maintaining a proper descent rate during the touchdown once visual reference was reduced by the dust in the rotor downwash. Factors were the dusty gravel landing area and the pilot's visual lookout not being possible due to the dust the rotor…Sep 21, 2003 · N74AE · Substantial damageNTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.Sep 12, 2003 · N8702X · Substantial damageNTSB CHI03FA291Accident · 3 fatalField investigationFinal reportBeech B36TC · Uniondale, INThe pilot's inaccurate preflight planning which resulted in an inadequate fuel supply and subsequent fuel exhaustion. Factors associated with the accident were the low ceiling, dark night conditions, and the utility pole which the airplane contacted during…Sep 2, 2003 · N8018J · DestroyedNTSB CHI03LA268Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tocsin, INThe pilot attempting the low altitude turn and his failure to maintain clearance from the corn crop. A factor to the accident was the corn crop.Aug 19, 2003 · N37923 · DestroyedNTSB CHI03LA241Accident · 1 fatalLimited investigationFinal reportYoung Pietenpol Air Camper · Peru, INThe pilot not maintaining altitude/clearance from the trees during the landing. A factor was the trees he impacted.Aug 3, 2003 · N81171 · DestroyedNTSB CHI03LA229Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingburg, INThe pilot's inadequate flare and the failure to perform a go-around during landing. The planned approach with a quartering tailwind were contributing factors.Jul 25, 2003 · N99040 · Substantial damageNTSB CHI03LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Evansville, INThe pilot's failure to attain the proper touchdown point. The barrels were a factor.Jul 24, 2003 · N9941W · Substantial damageNTSB CHI03LA195Accident · No injuriesLimited investigationFinal reportRuminski Ultra Pup · Richmond, INThe pilot failed to maintain directional control and the airplane ground looped.Jul 5, 2003 · N124TR · Substantial damageNTSB CHI03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Winamac, INA loss of engine power due to the improper installation of the crankshaft gear due to the omission of the retaining bolt and subsequent shear failure of the anti-rotation pin. The unsuitable terrain encountered, and the rough field were factors.Jul 2, 2003 · N6315P · Substantial damageNTSB CHI03LA193Accident · No injuriesLimited investigationFinal reportCessna 172H · Plymouth, INThe collision with a deer during landing.Jun 30, 2003 · N3832R · Substantial damageNTSB CHI03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Brazil, INThe delayed aborted takeoff by the pilot-in-command. A contributing factor was the fence, which the airplane contacted during the aborted takeoff.Jun 29, 2003 · N1660H · Substantial damageNTSB CHI03LA107Accident · No injuriesLimited investigationFinal reportMcBride Avid Flyer · Anderson, INThe pilot's misjudgment of speed which resulted in a landing overrun. The pilot's lack of experience in make and model airplane, and the ditch were contributing factors.Apr 12, 2003 · N29MD · Substantial damageNTSB CHI03LA101Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Richmond, INThe pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.Apr 10, 2003 · N614Q · Substantial damageNTSB CHI03LA095Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Knox, INA loss of engine power due to oil starvation as a result of the failure of the master rod bearing. Contributing factors were the tree line at the edge of the field, and the unsuitable terrain.Mar 31, 2003 · N45297 · Substantial damageNTSB CHI03LA074Accident · 1 fatalLimited investigationFinal reportNorth American/Aero Classics P-51D · Urbana, INThe pilot's failure to maintain aircraft control which resulted in a spin.Feb 20, 2003 · N93TF · DestroyedNTSB CHI03IA055Incident · No injuriesIncident investigationFinal reportBoeing 737-83N · Indianapolis, INThe ground tow personnel not maintaining clearance from the de-icing vehicle during the tow back to the gate. Factors were the de-icing vehicle that parked by the airplane's left wing, the ground personnel not following the operator's towing…Jan 16, 2003 · N303TZ · Minor damage