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 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.Mar 20, 2002 · N9763 · Substantial damageNTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.Mar 4, 2002 · N5985C · Substantial damageNTSB CHI02LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Ottumwa, IAthe student pilot failed to maintain directional control during takeoff. A contributing factor was the snowbank.Feb 5, 2002 · N733FT · Substantial damageNTSB 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.Jan 31, 2002 · N66MT · Substantial damageNTSB 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.Jan 21, 2002 · N9248D · Substantial damageNTSB CHI02LA029Accident · No injuriesLimited investigationFinal reportSchenfield Acro Sport II · Keosauqua, IAAircraft control not maintained by pilot during landing.Nov 12, 2001 · N90287 · Substantial damageNTSB 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.Oct 23, 2001 · N7235R · DestroyedNTSB 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.Sep 3, 2001 · N6598K · DestroyedNTSB 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.Sep 1, 2001 · N5593E · Substantial damageNTSB CHI01FA230Accident · 2 fatalField investigationFinal reportBeech K35 · Grafton, IAThe pilot's improper inflight decision to continue into known adverse weather. A factor was the thunderstorm.Jul 21, 2001 · N6062E · DestroyedNTSB 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.Jun 19, 2001 · N612B · Substantial damageNTSB 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.May 16, 2001 · N4348Q · Substantial damageNTSB 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.Nov 18, 2000 · N4706E · Substantial damageNTSB 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…Nov 3, 2000 · N71134 · DestroyedNTSB 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…Oct 22, 2000 · N82JF · Substantial damageNTSB CHI01LA022Accident · Minor injuriesLimited investigationFinal reportBollinger BD-4 · Hedrick, IAthe pilot not obtaining/maintaining clearance from the fence. A factors was fence.Oct 21, 2000 · N108BC · Substantial damageNTSB 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.Sep 1, 2000 · N8304C · Substantial damageNTSB 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.Sep 1, 2000 · N82748 · Substantial damageNTSB CHI00LA278Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Des Moines, IAA hydraulic fluid leak which resulted in a landing gear brake fire.Aug 31, 2000 · N451X · Substantial damageNTSB 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.Jun 25, 2000 · N3396S · DestroyedNTSB 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…Jun 11, 2000 · N9315W · Substantial damageNTSB CHI00LA122Accident · No injuriesLimited investigationFinal reportCunningham Pietenpol Aircamper · Boone, IAthe pilot not maintaining directional control. Factors were the gusts and the fence.Apr 23, 2000 · N899TC · Substantial damageNTSB 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.Mar 5, 2000 · N6560Q · Substantial damageNTSB CHI00LA052Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Indianola, IAloss of engine power for undetermined reason. A factor relating to this accident was the tree.Dec 28, 1999 · N6144R · DestroyedNTSB 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.Oct 27, 1999 · N52569 · Substantial damageNTSB 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.Oct 22, 1999 · N7057V · DestroyedNTSB 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.Sep 28, 1999 · N5747U · DestroyedNTSB 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.Sep 27, 1999 · N738FA · Substantial damageNTSB 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.Aug 9, 1999 · N66271 · Substantial damageNTSB 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.Aug 8, 1999 · N5033G · DestroyedNTSB 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…Aug 1, 1999 · N98FP · Substantial damageNTSB CHI99LA247Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Keokuk, IALoss of engine power for undetermined reasons.Jul 22, 1999 · N4902K · Substantial damageNTSB 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.Jul 14, 1999 · N19752 · Substantial damageNTSB 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).Jul 2, 1999 · N3371N · Substantial damageNTSB 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.Jun 17, 1999 · N4531R · Substantial damageNTSB 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.Jun 8, 1999 · N4525R · Substantial damageNTSB 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.May 9, 1999 · N53LE · Substantial damageNTSB 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.May 9, 1999 · N96876 · Substantial damageNTSB 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.Apr 9, 1999 · N205ME · No damageNTSB CHI99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ankeny, IAThe student pilot's failure to maintain directional control during landing.Mar 28, 1999 · N82164 · Substantial damageNTSB CHI99LA114Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAthe pilot's failure to maintain directional control.Mar 24, 1999 · N812TB · Substantial damageNTSB 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.Dec 17, 1998 · N5314B · DestroyedNTSB CHI99LA045Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Ankeny, IAthe elevator control system jammed for undetermined reasons.Dec 3, 1998 · N7278R · Substantial damageNTSB 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.Nov 22, 1998 · N92585 · Substantial damageNTSB 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.Nov 22, 1998 · N2691T · Substantial damageNTSB 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.Oct 24, 1998 · N9739C · Substantial damageNTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.Sep 27, 1998 · N7353J · Substantial damageNTSB CHI98LA346Accident · No injuriesLimited investigationFinal reportNeedham Glastar · Allison, IAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Aug 30, 1998 · N37JN · Substantial damageNTSB 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…Aug 23, 1998 · N5210C · Substantial damageNTSB 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…Aug 21, 1998 · N30SV · Destroyed