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 CEN21LA433Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Council Bluffs, IAThe student pilot’s failure to maintain directional control during a touch and go landing.Sep 15, 2021 · N767CG · Substantial damageNTSB CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.Sep 9, 2021 · N306TA · Substantial damageNTSB CEN21LA406Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Kingsley, IAThe total loss of engine power due to fuel exhaustion as a result of an unsecured fuel bladder, which reduced the fuel capacity of the affected tank.Sep 6, 2021 · N7574N · Substantial damageNTSB CEN21LA393Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Storm Lake, IAThe pilot’s failure to maintain adequate airspeed during a landing approach with a tailwind that resulted in a landing overrun and impact with terrain.Sep 1, 2021 · N5081W · Substantial damageNTSB CEN21LA350Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Waukon, IAThe pilot’s failure to maintain adequate clearance from a powerline during an agricultural application pass.Aug 4, 2021 · N775AK · Substantial damageNTSB CEN21LA339Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · West Liberty, IAThe pilot’s failure to see and avoid a wire while maneuvering at low altitude during an aerial application flight, resulting in a collision with the wire.Jul 20, 2021 · N983HA · Substantial damageNTSB CEN21LA329Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Amana, IAThe loss of engine power for reasons that could not be determined.Jul 19, 2021 · N8422K · Substantial damageNTSB CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.Jul 14, 2021 · N2801T · DestroyedNTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.Jul 13, 2021 · N7315P · Substantial damageNTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.Jul 11, 2021 · N949TM · Substantial damageNTSB CEN21FA299Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Lamoni, IAThe pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.Jul 1, 2021 · N123RE · DestroyedNTSB CEN21LA257Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Wallingford, IAImpact with trees and terrain during takeoff for reasons that could not be determined based on the available information.Jun 2, 2021 · N3281P · Substantial damageNTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.May 2, 2021 · N1215M · DestroyedNTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.Feb 24, 2021 · N3209U · Substantial damageNTSB CEN21LA118Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Davenport, IAThe pilot’s failure to maintain directional control of the airplane, and the flight instructor’s inadequate oversight during a simulated engine out takeoff that resulted in a runway excursion and impact with a snowbank.Jan 28, 2021 · N217US · Substantial damageNTSB CEN20LA385Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28-140 · Red Oak, IAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a loss of engine power.Sep 5, 2020 · N2875T · Substantial damageNTSB CEN20LA330Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Logan, IAThe failure of the lower actuator bearing support brackets, which resulted in the misalignment of the clutch actuator, a loss of belt tension on the main rotor drive system, and a subsequent forced landing.Aug 8, 2020 · N89LA · Substantial damageNTSB CEN20LA294Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Harlan, IAThe fatigue fracture of the upper rudder hinge that resulted in a partial separation of the rudder from the airplane during a spray pass.Jul 20, 2020 · N1662S · Substantial damageNTSB CEN20LA276Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R R1340 · Keokuk, IAThe improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.Jul 12, 2020 · N3104S · Substantial damageNTSB CEN20LA261Accident · Minor injuriesClass 3 · LimitedFinal reportEnstrom 280 · Des Moines, IAThe partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…Jul 4, 2020 · N282SH · DestroyedNTSB CEN20CA253Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 23 · Davenport, IAThe pilot's failure to properly configure the airplane for takeoff, which resulted in the exceedance of the airplane's critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.Jun 27, 2020 · N18873 · Substantial damageNTSB CEN20CA244Accident · Serious injuriesClass 4 · Data collectionFinal reportCoyote S-6ES · Pisgah, IAThe uncertificated pilot's failure to attain/maintain a proper angle-of-attack during an initial climb that resulted in an aerodynamic stall and subsequent impact with terrain.Jun 23, 2020 · N7764W · Substantial damageNTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.Apr 23, 2020 · N24DE · Substantial damageNTSB CEN20LA145Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sidney, IAA loss of engine power for reasons that could not be determined.Apr 10, 2020 · N1258Z · Substantial damageNTSB CEN20LA136Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Audubon, IAThe pilot’s failure to recognize and avoid the power line during the low-altitude flight. Contributing to the accident was the pilot’s fatigue, which affected the pilot’s ability to see and avoid the power line.Mar 31, 2020 · N107EH · DestroyedNTSB CEN20CA120Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Ankeny, IAThe pilot's improper starting procedure, which allowed the airplane to move forward over the wheel chocks and impact him and a hangar when he subsequently hand propped the engine.Mar 11, 2020 · N83032 · Substantial damageNTSB CEN20CA064Accident · Serious injuriesData collectionFinal reportGuimbal Cabri G2 · Independence, IAThe student pilot's failure to maintain helicopter control while maneuvering to land, which resulted in impact with an airplane and a hangar.Jan 21, 2020 · N715RK · Substantial damageNTSB CEN20LA014Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Swea City, IAThe pilot's failure to replace the oil filler cap during his preflight inspection, which resulted in oil starvation and a subsequent total loss of engine power.Oct 25, 2019 · N1443E · Substantial damageNTSB CEN19LA322Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Pocahontas, IAOverload failure of the left main landing gear during landing, which resulted in a loss of directional control.Sep 6, 2019 · N9895A · Substantial damageNTSB CEN19FA259Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Sumner, IAThe pilot’s impairment by medical conditions and/or medications, which resulted in the airplane’s impact with power lines and terrain.Aug 8, 2019 · N6113C · DestroyedNTSB CEN19LA230Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Ida Grove, IAA total loss of engine power during an aerial application flight for undetermined reasons.Jul 21, 2019 · N459TA · Substantial damageNTSB GAA19CA428Accident · Minor injuriesData collectionFinal reportRobinson R44 · Council Bluff, IAThe pilot's improper cyclic input during liftoff from a landing deck, which resulted in the right skid hooking onto an opening on the landing deck and a subsequent dynamic rollover.Jul 16, 2019 · N124LA · Substantial damageNTSB GAA19CA363Accident · No injuriesData collectionFinal reportCessna 150 · Elkader, IAThe pilot's delayed decision to go around, which resulted in a collision with trees and terrain.Jun 20, 2019 · N6471F · Substantial damageNTSB GAA19CA193Accident · No injuriesData collectionFinal reportCessna 172 · Pella, IAThe student pilot's failure to maintain the runway heading and the flight instructor's delayed remedial action during landing, which resulted in the instructor landing the airplane in grass left of the runway and a subsequent nose-over.Mar 26, 2019 · N7127G · Substantial damageNTSB GAA19CA173Accident · Minor injuriesData collectionFinal reportPereira Osprey · Independence, IAThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Mar 15, 2019 · N822GC · Substantial damageNTSB GAA19CA172Accident · No injuriesData collectionFinal reportCessna 172 · Oskaloosa, IAThe student pilot's failure to maintain directional control during landing with a left quartering tailwind, which resulted in a runway excursion, impact with a snowbank, and a nose-over.Mar 11, 2019 · N334SL · Substantial damageNTSB WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.Nov 9, 2018 · N91770 · Substantial damageNTSB GAA19CA001Accident · No injuriesData collectionFinal reportCessna 340 · Keokuk, IAThe pilot's failure to correctly identify the runway environment during an instrument approach at night in instrument meteorological conditions because he mistook building lights for runway lights, which resulted in landing short of the runway.Oct 1, 2018 · N89AM · Substantial damageNTSB GAA18CA545Accident · Minor injuriesData collectionFinal reportCirrus SR22 · Mason City, IAThe pilot’s improper hand propping procedure, which resulted in a runaway airplane and subsequent impact with a hangar.Sep 8, 2018 · N669HT · Substantial damageNTSB GAA18CA453Accident · Minor injuriesData collectionFinal reportRobinson R44 · Elma, IAThe pilot's failure maintain clearance from power lines during an agricultural application flight.Jul 27, 2018 · N466EL · Substantial damageNTSB CEN18LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Milford, IAThe pilot's loss of airplane control during takeoff for reasons that could not be determined because no anomalies consistent with a flight control system malfunction were observed.Jul 22, 2018 · N3169H · Substantial damageNTSB CEN18LA278Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Vinton, IALoss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.Jul 17, 2018 · N5553X · Substantial damageNTSB GAA18CA412Accident · No injuriesData collectionFinal reportBeech A36 · Spencer, IAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s failure to use the Before Landing checklist due to being distracted while communicating with other aircraft and controlling the airplane in the…Jun 29, 2018 · N67CD · Substantial damageNTSB GAA18CA341Accident · No injuriesData collectionFinal reportPiper PA 28 · Marion, IAThe pilot’s improper pitch during the first landing, which resulted in a porpoise, and the failure of the nose landing gear during the second landing after a subsequent go-around.Jun 10, 2018 · N4295T · Substantial damageNTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.May 28, 2018 · N84163 · Substantial damageNTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.May 16, 2018 · N77273 · Substantial damageNTSB CEN18LA137Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Maxwell, IAThe noncertificated pilot's unfamiliarity with the airplane, which resulted in a loss of airplane control when the pilot encounter a wind gust.Apr 5, 2018 · N2433Z · Substantial damageNTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.Mar 11, 2018 · N9457K · Substantial damageNTSB CEN18FA060Accident · 1 fatalField investigationFinal reportX-Air XA85 · Oskaloosa, IAThe pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.Dec 23, 2017 · N20XA · Substantial damageNTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.Dec 9, 2017 · N8856B · Substantial damage