NTSB investigations, IA
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, 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' 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.
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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI91LA244Accident · No injuriesLimited investigationFinal reportAerostar Raven 557A · Indianola, IAFailure of the pilot to maintain altitude. Factors associated with the accident are complacency and diverted attention.NTSB CHI91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Manning, IAThe pilot's improper selection of fuel tanks and improper in-flight emergency procedure by the pilot.NTSB CHI91LA225Accident · No injuriesLimited investigationFinal reportCessna 305A · Keokuk, IADiverted attention by the pilot resulting in directional control not being maintained. A factor related to the accident was crosswind.NTSB CHI91LA213Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stockton, IACompensation for wind conditions not performed, wrong runway selected and aircraft control not maintained by the pilot. Factors related to the accident were a tailwind/crosswind component and a rough runway.NTSB CHI91DCD01Accident · 1 fatalFinal reportHeal SONERAI-I · Davenport, IAFailure of the wing spar straps, as the aircraft was being maneuvered around a pylon in an air race.NTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.NTSB CHI91LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manning, IAAirspeed was not attained and aborted takeoff was delayed by the pilot. Factors related to the accident were: over confidence in aircraft's ability to takeoff on the short, grass runway and a dirt embankment on the departure end of the strip.NTSB CHI91LA178Accident · No injuriesLimited investigationFinal reportCessna 172E · Grundy Center, IAFailure by other maintenance personnel to install a safety wire and fuel exhaustion.NTSB CHI91LA155Accident · No injuriesLimited investigationFinal reportPiper J3 · Creston, IAIcing in the induction air control system.NTSB CHI91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IADelayed initiation of remedial action by the flight instructor. Factors related to the accident are gusty crosswinds, inadequate compensation for wind conditions and not maintaining airspeed by the student pilot, and complacency by the instructor.NTSB CHI91IA058Incident · Minor injuriesIncident investigationFinal reportBoeing B727-223 · Des Moines, IAAn oil leak originating from the auxiliary power unit which created smoke in the passenger cabin after it passed through the air conditioning/heating system equipment and associated duct work.NTSB CHI91FA035Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Des Moines, IAThe pilot's improper emergency procedures by not feathering the left engine after it lost power and/or was shut down, and his failure to keep the aircraft at or above the minimum control airspeed (VMC), which resulted in a loss of aircraft control. A factor…NTSB CHI91LA030Accident · No injuriesLimited investigationFinal reportCessna 177 · Mount Ayr, IAProper touch-down point not attained and go-around delayed by the PIC. Contributing factors were a downwind, crosswind, weather evaluation misjudged, wrong runway selected and lack of total experience by the PIC.NTSB CHI91LA021Accident · No injuriesLimited investigationFinal reportCessna 170B · Maquoketa, IAThe pilot's inadequate commpensation for wind conditions.NTSB CHI91GA014Accident · 1 fatalFinal reportCessna 172P · Williamsburg, IAThe pilot-in-command's abrupt pull-up to avoid an obstacle. Contributing was the pilot-in-command's diverted attention to activities on the ground.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB CHI90LA262Accident · Serious injuriesLimited investigationFinal reportNational Balloon AX-7 · Altoona, IAThe passenger's inadvertent contact with a propane tank during a bounced landing which resulted in serious injury to the passenger.NTSB CHI90LA257Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Clutier, IAThe pilot's failure to compensate for wind conditions.NTSB CHI90DCD02Accident · No injuriesFinal reportBell 47G-2 · Wall Lake, IAThe failure of the pilot to maintain rotor RPM during takeoff. The high density altitude and uphill terrain were factors.NTSB CHI90LA222Accident · No injuriesLimited investigationFinal reportNaaman Haren Kitfox 1 · Grundy Center, IAGo-around delayed by the pilot in command.NTSB CHI90LA205Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Hudson, IAImproper touchdown performed by the pilot in command.NTSB CHI90LA204Accident · No injuriesLimited investigationFinal reportWhittman W-8 · Toledo, IAWrong runway selected and aborted takeoff delayed by the pilot in command.NTSB CHI90LA206Accident · No injuriesLimited investigationFinal reportBeech D17S · Oelwein, IAInadequate visual outlook by the pilot in command.NTSB CHI90DCD01Accident · No injuriesFinal reportFinn A. Arnold Glassaire/SH-2 · Shenandoah, IAThe failure of the pilot to maintain directional control of the airplane during the takeoff ground run. A factor in the accident is the pilot's lack of total experience in the type of aircraft involved in the accident.NTSB MKC90LA145Accident · Minor injuriesLimited investigationFinal reportMonnett Sonerai II · Cherokee, IAAircraft control not maintained by the pilot in command.NTSB MKC90LA143Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Marshalltown, IAInadequate visual lookout and clearance not obtained.NTSB MKC90FA130Accident · 3 fatalField investigationFinal reportBell 47G-3B1 · Cedar Rapids, IAThe failure of the pilot to maintain control of the helicopter during maneuvering flight. Darkness and the pilot's manner of flying the aircraft (ostentatious display) were considered to be related factors.NTSB MKC90LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Winfield, IAThe pilot's decision to go-around was delayed and clearance of the power lines was not attained.NTSB MKC90LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, IAFuel exhaustion due to misjudged fuel consumption calculations by the pilot in command, and a forced landing to a field with a hidden obstruction.NTSB MKC90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dubuque, IAWeather evaluation misjudged resulting in uncontrolled descent by the pilot in command and aircraft control not maintained by the pilot in command.NTSB MKC90LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ames, IAThe wrong runway was selected and directional control was not maintained by the pilot in command.NTSB MKC90LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Eldora, IAImproper planning/decision by the pilot, and his failure to maintain clearance from obstructions during the approach to land. Factors related to the accident were: the aircraft's low fuel level, darkness, the pilot's selection of the wrong airport/runway, the…NTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.NTSB MKC90LA068Accident · No injuriesLimited investigationFinal reportMaule M4 · Creston, IASelection of the wrong runway by the pilot, and his failure to go-around while he had sufficient speed and runway to do so. Factors related to the accident were: the gusty tailwind and wet runway condition.NTSB CHI90IA070Incident · No injuriesIncident investigationFinal reportBoeing B737-300 · Cedar Rapids, IAThe failure of all four main landing gear tires on takeoff due to the parking brake being locked.NTSB DEN90FA027Accident · Serious injuriesField investigationFinal reportPiper PA-46P-350 · Des Moines, IALoss of engine power for undetermined reason(s). The light conditions (dusk) and trees in in the emergency landing area were considered to be contributing factors.NTSB MKC90LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Toledo, IAThe pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.NTSB MKC90FA017Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Elkader, IAThe pilot's failure to maintain clearance from the runway marker at the departure end of the runway.NTSB MKC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charles City, IAThe pilot-in-command's failure to maintain adequate control of the aircraft during the landing phase coupled with the cfi's inadequate supervision during the instructional flight. The cfi's lack of familiarity with the accident aircraft was a contributing…NTSB MKC90LA008Accident · No injuriesLimited investigationFinal reportCessna P210 · Waterloo, IAFuel exhaustion, due to poor planning/decision, and fuel consumption calculations misjudged by the pilot in command. The fact that the runway lights were not operating & the accident occurred at night were contributing factors.NTSB MKC90LA003Accident · No injuriesLimited investigationFinal reportStits-Itrich SA6B · Swan, IAThe pilot's failure to adequately compensate for the gusty crosswind conditions which contributed to the accident.NTSB MKC89LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Leon, IABlockage of the engine air induction system by a field mouse nest. The nest was positioned so that it could not be seen during the pre-flight inspection. It became dislodged during the takeoff roll on the rough runway.NTSB MKC89LA175Accident · Minor injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Indianola, IAFailure of the pilot to maintain clearance from the tv tower due to improper in-flight planning/decision. Unfavorable wind/windshear and the tall tower were contributing factors.NTSB MKC89LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Cedar Rapids, IAThe failure of the pilot in command to maintain alignment with the runway and excessive aircraft control in close proximity to the ground. Contributing to the accident was the pilot's diverted attention which resulted from having to shut down the left engine.NTSB DCA89MA063Accident · 111 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-10-10 · Sioux City, IAThe inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…NTSB MKC89LA161Accident · Minor injuriesLimited investigationFinal reportGates Learjet Learjet 35 · Des Moines, IAFailure of the pilot to maintain directional control and runway alignment during the landing. Factors related to the accident were: adverse weather/runway/terrain conditions, failure of the local controller to warn the pilot of possible hydroplaning…NTSB MKC89LA158Accident · Minor injuriesLimited investigationFinal reportBristow KR-2 · Perry, IAFuel starvation caused by fuel contamination.NTSB MKC89GA147Accident · 2 fatalFinal reportMaule MX-7 · Atlantic, IAFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which led to an inadvertent stall and loss of control. A contributing factor was the lack of altitude to recover from a stall.NTSB MKC89LA126Accident · Serious injuriesLimited investigationFinal reportOlson BD-4 · Cedar Rapids, IAPremature lift-off and inadvertent stall by the pilot. A loss of directional control and an inadvertent ground swerve by the pilot were contributing factors.NTSB MKC89LA084Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Dodge, IAThe failure of the pilot to adequately compensate for existing wind conditions, to flare properly, and to recover properly from a bounced landing. The gusty x-wind conditions contributed to the accident.