NTSB investigations, 2003, IA

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, 2003, IA per year, 1962–2026: 2,216 cases
19622
19632
196472
196574
1966108
1967129
196887
196998
1970101
1971105
197276
197353
197460
197549
197655
197757
197865
197951
198041
198160
198252
198353
198439
198535
198626
198730
198827
198924
199024
199123
199223
199322
199416
199512
199615
199722
199820
199918
200011
20017
200214
200320
200413
200513
20068
200717
200818
200917
201027
201123
201221
201315
20149
201513
201613
201716
201812
20199
202012
202116
202214
202317
20247
202513
202615

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\" = 'IA' 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 CHI04LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Waterloo, IAThe impact with a deer during landing roll. A contributing factor was the night lighting conditions.Dec 26, 2003 · N7575V · Substantial damageNTSB CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…Dec 18, 2003 · N3733W · Substantial damageNTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.Nov 30, 2003 · N7467W · Substantial damageNTSB CHI04LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Davenport, IAA loss of engine power due to fuel starvation as a result of the improper installation of the fuel nozzle. Also causal was the engine manufacturer's improper installation instructions for the nozzle pressure port plug on the fuel manifold valve. A factor…Oct 16, 2003 · N25496 · Substantial damageNTSB CHI04LA004Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Waterloo, IAThe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain control of the airplane while landing. A factor associated with the accident was the strong, gusty wind condition.Oct 3, 2003 · N72701 · Substantial damageNTSB CHI04LA003Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Orange City, IAThe pilot's failure to maintain obstacle clearance from the trees while manuevering at a low altitude. A factor was the trees.Oct 3, 2003 · N1909K · DestroyedNTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.Oct 3, 2003 · N3772D · Substantial damageNTSB CHI03LA309Accident · Minor injuriesLimited investigationFinal reportStrother KR2 · Clarinda, IAFailure of the pilot to maintain clearance from the roadway sign. The loose gravel and the sign were contributing factors.Sep 11, 2003 · N60MS · Substantial damageNTSB CHI03LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Maquoketa, IAThe pilot's excessive use of the brake system, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind.Aug 30, 2003 · N1954B · Substantial damageNTSB CHI03LA289Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Westside, IAThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing factors were the unsuitable terrain encountered, and the terrace/embankment.Aug 22, 2003 · N5007G · Substantial damageNTSB CHI03LA261Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Aplington, IAThe pilot not maintaining proper altitude/clearance from the wire during the aerial application flight. The factor to the accident was the power line.Aug 14, 2003 · N4339S · Substantial damageNTSB CHI03LA217Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Waverly, IAThe main rotor blade push-pull rods being corroded, sustaining fatigue, and separating in cruise and the main rotor blade contacting the tail boom during the emergency landing. Factors were the diminished aircraft control and the vibrations encountered during…Jul 20, 2003 · N51699 · Substantial damageNTSB CHI03LA203Accident · Serious injuriesLimited investigationFinal reportAerotrike DPS · Brandon, IAThe non-certificated pilot selected unsuitable terrain for takeoff when he departed from a bean field, and the airplane stalled as a result of low airspeed during takeoff climb. Factors to the accident included the pilot's total lack of experience, the…Jul 5, 2003 · UNREG · Substantial damageNTSB CHI03LA157Accident · No injuriesLimited investigationFinal reportCessna 140A · Grinnell, IAThe pilot's inadvertent ground loop. Factors contributing to the accident were the wind gusts and crosswind conditions.Jun 5, 2003 · N5667C · Substantial damageNTSB CHI03LA166Accident · No injuriesLimited investigationFinal reportCessna 172H · Council Bluffs, IAMisjudgment of the landing flare by the pilot in command resulting in a hard landing.May 27, 2003 · N1730F · Substantial damageNTSB CHI03FA094Accident · 3 fatalField investigationFinal reportBeech A36 · New Vienna, IAThe improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…Mar 28, 2003 · N1636W · DestroyedNTSB CHI03FA088Accident · 1 fatalField investigationFinal reportCessna 182R · North English, IAThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the CFI's improper decision to attempt to takeoff from a short, grass taxiway instead of departing from a runway aligned with the prevailing winds,…Mar 22, 2003 · N6211E · DestroyedNTSB CHI03LA068Accident · No injuriesLimited investigationFinal reportCessna 182F · Estherville, IAThe pilot failed to maintain adequate control of the airplane while taxiing in high wind conditions. A factor was the high winds.Feb 11, 2003 · N3455U · Substantial damageNTSB CHI03LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Clarence, IAA failure of the crankshaft for undetermined reasons. Factors associated with the accident were the rough terrain on which the forced landing was made and the night conditions.Jan 24, 2003 · N6572X · Substantial damageNTSB CHI03LA049Accident · No injuriesLimited investigationFinal reportCessna 150J · Garner, IAThe students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel…Jan 8, 2003 · N60834 · Substantial damage