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.
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
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 CHI02LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164A · Cascade, IAThe pilot's inadequate preflight planning/preparation and his failure to maintain clearance with the wire. A factor associated with the accident was the wire that the airplane contacted.NTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.NTSB CHI02LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Ottumwa, IAthe student pilot failed to maintain directional control during takeoff. A contributing factor was the snowbank.NTSB CHI02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-42-720 · Ames, IAThe pilot's failure to maintain the proper glide path during the final portion of the approach. Factors relating to this accident were the low altitude and the utility pole.NTSB CHI02LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Iowa Falls, IAThe pilot's inadequate compensation for the crosswind condition and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind and the rough terrain encountered.NTSB CHI02LA029Accident · No injuriesLimited investigationFinal reportSchenfield Acro Sport II · Keosauqua, IAAircraft control not maintained by pilot during landing.NTSB CHI02FA009Accident · 1 fatalField investigationFinal reportBeech 58 · Dubuque, IAThe pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.NTSB CHI01LA300Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Atlantic, IAThe loss of engine power for undetermined reasons during the takeoff and initial climb, and the unsuitable terrain encountered during the forced landing. Factors relating to this accident were the corn crop and the low altitude.NTSB CHI01LA303Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sheldon, IAthe in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.NTSB CHI01FA230Accident · 2 fatalField investigationFinal reportBeech K35 · Grafton, IAThe pilot's improper inflight decision to continue into known adverse weather. A factor was the thunderstorm.NTSB CHI01LA178Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28A · Eldridge, IAThe inadequate autorotation and disregarded wind information by the pilot. Factors were the gusting tailwind and the loss of engine power for undetermined reasons.NTSB CHI01LA142Accident · Minor injuriesLimited investigationFinal reportBaldwin RV-6 · Muscatine, IAThe engine failure for undetermined reasons. Factors were the low altitude, the trees, the presence of the irrigation system, the ditch and the soft ground.NTSB CHI01LA039Accident · No injuriesLimited investigationFinal reportAeronca 7CCM-200 · Corning, IAThe pilot did not adequately compensate for the wind conditions and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind, the runway light, and the tree.NTSB CHI01FA026Accident · 1 fatalField investigationFinal reportLuscombe 8A · Des Moines, IAThe pilot not maintaining aircraft control during the final turn, and the pilot's improper decision to fly the tight pattern to the closer runway. Factors relating to the accident were the pilot's inadequate distance/altitude in the traffic pattern and the…NTSB CHI01LA029Accident · Minor injuriesLimited investigationFinal reportFowler Varieze · Iowa City, IAthe inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…NTSB CHI01LA022Accident · Minor injuriesLimited investigationFinal reportBollinger BD-4 · Hedrick, IAthe pilot not obtaining/maintaining clearance from the fence. A factors was fence.NTSB CHI00LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mason City, IAthe unsuitable terrain for landing encountered by the pilot and the failure of the oil filter converter plate gasket. Factors to the accident were the total loss of oil and the soft terrain condition.NTSB CHI00LA281Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Blakesburg, IAThe pilot failed to add full power during a go around which resulted in descreased airspeed and a subsequent stall. A factor associated with the accident was the airplane stopped on the edge of the airstrip.NTSB CHI00LA278Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Des Moines, IAA hydraulic fluid leak which resulted in a landing gear brake fire.NTSB CHI00FA171Accident · 1 fatalField investigationFinal reportCessna 210J · Sumner, IAfailure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB CHI00LA122Accident · No injuriesLimited investigationFinal reportCunningham Pietenpol Aircamper · Boone, IAthe pilot not maintaining directional control. Factors were the gusts and the fence.NTSB CHI00LA086Accident · Minor injuriesLimited investigationFinal reportAlon Ercoupe · Osceola, IAfuel starvation due to an undetermined blockage in the fuel line from the header tank to the gascolator. Factors relating to this accident were the blocked fuel line and the rough terrain.NTSB CHI00LA052Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Indianola, IAloss of engine power for undetermined reason. A factor relating to this accident was the tree.NTSB CHI00LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Waukon, IAthe pilot failed to maintain directional control of the airplane during the aborted landing. Factors relating to the accident included the crosswinds, the fence, and the trees.NTSB CHI00LA014Accident · 1 fatalLimited investigationFinal reportHowlett KR-2 · Denison, IAthe pilot not maintaining altitude/clearance from rising terrain and the intentional low altitude flight. Factors were the known turbulence, rising terrain, and the inadequate in-flight decision to fly at low altitudes.NTSB CHI99FA356Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clinton, IAthe pilot's continued flight into known adverse weather conditions and not maintaining altitude/clearance. Factors were the low clouds, rain, and dark night conditions.NTSB CHI99LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Des Moines, IAthe pilot's improper in-flight planning and decisions which led to fuel exhaustion. A factor relating to this accident was the telephone pole.NTSB CHI99LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Perry, IAthe student pilot's inadequate compensation for the wind conditions which resulted in her failure to maintain control of the airplane. A factor associated with the accident was the gusty crosswind condition.NTSB CHI99FA284Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Titonka, IAThe low altitude maneuver attempted and altitude/clearance not being maintained by the pilot, which resulted in an impact with a pine tree. A factor to the accident was the pine tree.NTSB CHI99LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Harlan, IAthe failure of the pilot to maintain directional control of the aircraft during landing. Factors to the accident were the crosswind, the failure of the pilot to maintain compensation for the crosswind condition on approach, and the inadvertent ground loop…NTSB CHI99LA247Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Keokuk, IALoss of engine power for undetermined reasons.NTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.NTSB CHI99LA207Accident · No injuriesLimited investigationFinal reportPiper J-3C · Independence, IAThe insufficient information from the weather forecast resulting in an in-flight encounter with turbulence/gusts and the subsequent precautionary landing. Contributing factors were the gusty/turbulent conditions and the terrain condition (crop).NTSB CHI99LA187Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5KB · Iowa City, IAthe pilot stalled the airplane. Factors included the instructor pilot's inadequate preflight briefing and improper in flight decision.NTSB CHI99LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Traer, IAThe pilot's not maintaining proper runway alignment during the aborted takeoff, and the airport personnel not maintaining the runway. Factors were rough terrain and a dirt bank.NTSB CHI99LA150Accident · No injuriesLimited investigationFinal reportBeech A-36 · Buffalo Center, IAThe pilot not attaining a proper touchdown point and not performing a go around. Factors were the wet grass and the tailwin.NTSB CHI99FA147Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Newton, IAthe failure of the pilot to maintain flying speed resulting in a stall and spin into the ground.NTSB CHI99IA136Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dubuque, IAthe frozen elevator control. Factors to the incident were the rain and the low temperature.NTSB CHI99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ankeny, IAThe student pilot's failure to maintain directional control during landing.NTSB CHI99LA114Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAthe pilot's failure to maintain directional control.NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.NTSB CHI99LA045Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Ankeny, IAthe elevator control system jammed for undetermined reasons.NTSB CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.NTSB CHI99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Iowa Falls, IAthe pilot's improper preflight planning and preparation, and his not refueling the airplane. Factors were fuel exhaustion and the fence.NTSB CHI99LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Clinton, IAthe failure of the 90 degree gearbox for reasons undetermined. Factors were the failure of the gearbox, and it not being possible for the pilot to maintain control of the aircraft.NTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.NTSB CHI98LA346Accident · No injuriesLimited investigationFinal reportNeedham Glastar · Allison, IAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB CHI98FA323Accident · 3 fatalField investigationFinal reportBell 222 · Spencer, IAThe below standard (loose) fit of the 'white' swashplate outer ring pin resulting in fatigue and subsequent separation of the pin, and ultimately the in-flight breakup of the rotorcraft. A factor was the manufacturer's dissemination of the pin which did not…