Final NTSB investigations, IA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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 c.\"eventStateOrRegion\" = 'IA' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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 CEN11FA436Accident · 1 fatalField investigationFinal reportRay Aerial Spraying 773 Racer · Ottumwa, IAThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane’s engine and ignition system did not reveal any anomalies that would have precluded normal operation, and extensive postaccident fire damage…Jun 30, 2011 · N773RY · DestroyedNTSB CEN11LA402Accident · Serious injuriesLimited investigationFinal reportCessna P210R · Albia, IAThe pilot's inadequate preflight inspection, in which he did not detect that less fuel was on board the airplane than planned, which precipitated a loss of engine power due to fuel exhaustion during initial descent.Jun 18, 2011 · N900SR · Substantial damageNTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.May 31, 2011 · N7818F · Substantial damageNTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.May 30, 2011 · N204TJ · Substantial damageNTSB CEN11CA282Accident · No injuriesData collectionFinal reportDelf Tim Zenith CH-701 · Davenport, IAThe improper installation of the rudder cable to rudder pedal attachment hardware.Apr 12, 2011 · N701YB · Substantial damageNTSB CEN11IA270Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Dubuque, IAThe airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.Apr 3, 2011 · N377SK · Minor damageNTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.Feb 15, 2011 · N51DN · Substantial damageNTSB CEN11LA168Accident · No injuriesLimited investigationFinal reportErtz Mark G Zodiac 601XL · Burlington, IAThe Model 1 pilot's inadequate visual lookout and subsequent failure to see and avoid the Zodiac.Jan 29, 2011 · N200BE · 2 aircraft · Substantial damageNTSB CEN11LA148Accident · No injuriesLimited investigationFinal reportBeech H35 · Des Moines, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Dec 18, 2010 · N5537D · Substantial damageNTSB CEN11LA066Accident · 1 fatalLimited investigationFinal reportGearn Geary D Swearingen SX300 · Milford, IAA loss of control for undetermined reasons.Nov 10, 2010 · N3ZX · Substantial damageNTSB CEN11CA065Accident · No injuriesData collectionFinal reportWelch Thomas RV9 · Sac City, IAThe pilot's loss of directional control while landing with a gusting wind.Nov 3, 2010 · N475TW · Substantial damageNTSB CEN11LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Waterloo, IAThe separation of a stabilator control cable turnbuckle due to stress corrosion cracking, which resulted in a loss of airplane control during takeoff.Oct 29, 2010 · N8370L · Substantial damageNTSB CEN11FA040Accident · 1 fatalField investigationFinal reportBeech 95-B55 (T42A) · Clarion, IAThe pilot's failure to maintain control of the airplane. Contributing to the accident was the loss of left engine power for undetermined reasons.Oct 21, 2010 · N784CB · DestroyedNTSB CEN10CA565Accident · No injuriesData collectionFinal reportNorth American AT-6 · Blakesburg, IAThe pilot's excessive airspeed during the landing, which resulted in his decision to perform an intentional ground loop to avoid a runway overrun.Sep 3, 2010 · N77TX · Substantial damageNTSB CEN10LA514Accident · 1 fatalLimited investigationFinal reportCessna 150L · Boone, IAThe pilot’s failure to maintain airplane control while performing low-level banner towing operations with a gusting wind.Sep 2, 2010 · N10128 · Substantial damageNTSB CEN10CA446Accident · Minor injuriesData collectionFinal reportBell 206 · St. Olaf, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.Jul 28, 2010 · N275RA · Substantial damageNTSB CEN10CA445Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Zwingle, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.Jul 28, 2010 · N6030U · Substantial damageNTSB CEN10CA434Accident · No injuriesData collectionFinal reportAir Tractor 502B · Whittemore, IAThe pilot's failure to abort the takeoff, which resulted in an aerodynamic stall.Jul 23, 2010 · N4203B · Substantial damageNTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.Jul 23, 2010 · N40TA · Substantial damageNTSB CEN10LA401Accident · 1 fatalLimited investigationFinal reportKlemme William H Zenith CH 701 · Iowa Falls, IAThe pilot’s failure to maintain adequate airspeed while on final approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the model of airplane.Jul 15, 2010 · N701KC · Substantial damageNTSB CEN10CA402Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Independence, IAThe pilot's failure to pay attention to the power lines and his subsequent failure to maintain clearance from the corn field during the aerial application flight.Jul 13, 2010 · N8260K · Substantial damageNTSB CEN10LA335Accident · No injuriesLimited investigationFinal reportCessna 525A · Storm Lake, IAThe pilot’s decision to land on a water contaminated runway, which resulted in a runway excursion during the landing roll. Contributing to the accident was the pilot’s lack of knowledge regarding the landing distance required and the limited braking…Jun 21, 2010 · N800VT · Substantial damageNTSB CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.Jun 13, 2010 · N6036U · DestroyedNTSB CEN10CA323Accident · Serious injuriesData collectionFinal reportMcculley Ronald W-8 · Lamoni, IAThe non-certificated pilot's decision to attempt a takeoff that exceeded the airplane's performance capability, which resulted in an overrun.Jun 12, 2010 · N8519N · Substantial damageNTSB CEN10LA312Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Ankeny, IAThe failure of the stabilator control cable due to wear. Contributing to the accident was the inadequate maintenance inspection of the stabilator control cable.Jun 9, 2010 · N104NW · Substantial damageNTSB CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.May 9, 2010 · N8083C · Substantial damageNTSB CEN10LA240Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Fort Dodge, IAThe flight crew's inadequate separation from convective activity that resulted in serious injury to an unrestrained flight attendant.Apr 30, 2010 · N320AA · No damageNTSB CEN10LA189Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-100 SE · Runnells, IAA clear air turbulence encounter during cruise flight, during which an unrestrained cabin flight attendant sustained a hip fracture.Apr 3, 2010 · N869RW · No damageNTSB CEN10CA178Accident · No injuriesData collectionFinal reportCessna 172N · Ankeny, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight fuel monitoring.Mar 31, 2010 · N883AV · Substantial damageNTSB CEN10CA177Accident · No injuriesData collectionFinal reportCessna 182T · Lansing, IAThe pilot's failure to attain a proper touchdown point, resulting in an overrun and intentional ground loop.Mar 29, 2010 · N3503H · Substantial damageNTSB CEN10FA119Accident · 1 fatalField investigationFinal reportPiper PA-31T · Forest City, IAThe pilot's failure to maintain airplane control during final approach.Feb 12, 2010 · N250TT · Substantial damageNTSB CEN10CA106Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Cherokee, IAThe pilot misjudged his altitude while on short final approach.Jan 21, 2010 · N8916P · Substantial damageNTSB CEN10LA105Accident · No injuriesLimited investigationFinal reportBeech B200 · Sioux City, IAThe flight crew's decision to attempt a flight that was below takeoff, landing, and alternate airport weather minimums, which led to a touchdown off the runway surface by the pilot-in-command.Jan 19, 2010 · N586BC · Substantial damageNTSB CEN10CA100Accident · Minor injuriesData collectionFinal reportCessna P172D · Cedar Rapids, IAThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain a proper glidepath during the approach. Contributing to the accident was the pilot's lack of instrument proficiency.Jan 18, 2010 · N8584X · Substantial damageNTSB CEN10LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cedar Rapids, IAThe pilot's failure to maintain aircraft control while flying an instrument approach. Contributing to the accident was the pilot's lack of experience in actual instrument conditions.Jan 17, 2010 · N53120 · Substantial damageNTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.Dec 18, 2009 · N99930 · Substantial damageNTSB CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.Sep 21, 2009 · N57354 · Substantial damageNTSB CEN09LA534Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Audubon, IAA loss of engine power due to failure of the compressor turbine resulting from exposure to elevated operating temperatures for undetermined reasons.Aug 18, 2009 · N2065B · Substantial damageNTSB CEN09CA533Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Whittemore, IAThe pilot's lack of preflight planning and remedial action with resulted in the airplane's inability to climb out of ground effect.Aug 17, 2009 · N5003C · Substantial damageNTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.Aug 16, 2009 · N47539 · Substantial damageNTSB CEN09LA527Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Corning, IAThe in-flight loss of control due to the pilot's impairment as a result of hypoxia. Contributing to the accident was the pilot's decision to operate the unpressurized airplane at an altitude requiring supplemental oxygen without having any oxygen available.Aug 15, 2009 · N802LL · DestroyedNTSB CEN09CA516Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Harlan, IAThe pilot's failure to perform accurate weight and balance calculations which resulted in exceeding the maximum takeoff weight and the airplane's climb capability.Aug 10, 2009 · N4598 · Substantial damageNTSB CEN09LA503Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Waterloo, IAA loss of engine power for undetermined reasons.Aug 4, 2009 · N60747 · Substantial damageNTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.Aug 3, 2009 · N6701Z · Substantial damageNTSB CEN09LA492Accident · Serious injuriesLimited investigationFinal reportStirling Starduster · Earlham, IAThe pilot's failure to maintain clearance from the ground during an aerobatic maneuver.Aug 1, 2009 · N1XY · Substantial damageNTSB CEN09LA491Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Iowa Falls, IABoth pilots' failure to execute adequate visual lookout, resulting in the two airplanes colliding over the runway.Jul 31, 2009 · N989TP · 2 aircraft · Substantial damageNTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.Jul 22, 2009 · N7BT · Substantial damageNTSB CEN09LA451Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaman, IAThe loss of engine power during initial climb for undetermined reasons.Jul 10, 2009 · N6683K · Substantial damageNTSB CEN09LA409Accident · 1 fatalLimited investigationFinal reportCessna 172 · Latimer, IAThe pilot's failure to maintain clearance from the power line while flying at a low altitude.Jul 3, 2009 · N8138B · Substantial damageNTSB CEN09LA403Accident · Serious injuriesLimited investigationFinal reportAyres S2R-G6 · Ainsworth, IAA component failure of the fuel control unit, which resulted in a loss of engine power.Jul 1, 2009 · N60015 · Substantial damage