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 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.NTSB 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.NTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09LA503Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Waterloo, IAA loss of engine power for undetermined reasons.NTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.NTSB CEN09LA492Accident · Serious injuriesLimited investigationFinal reportStirling Starduster · Earlham, IAThe pilot's failure to maintain clearance from the ground during an aerobatic maneuver.NTSB 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.NTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.NTSB CEN09LA451Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaman, IAThe loss of engine power during initial climb for undetermined reasons.NTSB CEN09LA409Accident · 1 fatalLimited investigationFinal reportCessna 172 · Latimer, IAThe pilot's failure to maintain clearance from the power line while flying at a low altitude.NTSB CEN09LA403Accident · Serious injuriesLimited investigationFinal reportAyres S2R-G6 · Ainsworth, IAA component failure of the fuel control unit, which resulted in a loss of engine power.NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.NTSB CEN09CA344Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Murray, IAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude.NTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09CA044Accident · No injuriesData collectionFinal reportCessna 172M · Carroll, IAThe improper preflight planning/decision made by the pilot in attempting a taxi in high wind conditions. Contributing to the accident was the winds.NTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.NTSB CHI08CA290Accident · No injuriesData collectionFinal reportUnknown Supercat · Redding, IAThe pilot's failure to properly manage the fuel supply of the airplane which resulted in fuel exhaustion. Contributing to the accident was the hilly terrain encountered during the subsequent forced landing.NTSB CHI08CA261Accident · Minor injuriesData collectionFinal reportNtbk Wag Aero Sport · Oxford, IAThe pilot misjudged his approach path which resulted in insufficient altitude and the subsequent failure to maintain clearance with the trees. Contributing to the accident were the trees and the dusk lighting conditions.NTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.NTSB CHI08CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301B · Monticello, IAPoor preflight planning in that the pilot failed to assure an adequate fuel supply was on board for the flight which resulted in fuel exhaustion. Factors associated with the accident were the low altitude of the airplane when the loss of power occurred and…NTSB CHI08CA213Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Ida Grove, IAA failure of the turbocharger blower which resulted in the partial loss of power. Factors associated with the accident were the low altitude of the airplane and the embankment.NTSB CHI08CA242Accident · No injuriesData collectionFinal reportSchweizer G-164A · Jefferson, IAThe loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.NTSB CHI08CA240Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Salem, IAThe loss of engine power for an undetermined reason. Contributing to the accident was the high grass encountered during the landing roll.NTSB CHI08CA218Accident · No injuriesData collectionFinal reportCessna T188C · Marion, IAThe pilot not maintaining airspeed while performing an aerial application maneuver and the inadvertent stall he encountered. Contributing to the accident was the gust of wind during the maneuver.NTSB CHI08CA220Accident · Minor injuriesData collectionFinal reportAir Tractor AT-401 · Lake View, IAThe pilot not obtaining/maintaining altitude/clearance from the power line while performing an aerial application maneuver.NTSB CHI08CA205Accident · Minor injuriesData collectionFinal reportHowell FW2C80TR · Washington, IAThe low airspeed and proper climb rate not attained by the pilot during takeoff and the inadvertent stall by the pilot.NTSB CHI08CA204Accident · Serious injuriesData collectionFinal reportIndy T-Bird II · Independence, IAThe takeoff airspeed not attained and the aborted takeoff not performed by the pilot. An additional cause was the lack of familiarity with the airplane by the pilot.NTSB CHI08LA189Accident · Serious injuriesLimited investigationFinal reportRoof Curtis Hawk P6E · Iowa City, IAThe loss of engine power for an undetermined reason and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB CHI08FA150Accident · 1 fatalField investigationFinal reportSocata TBM 700 (850) · Iowa City, IAThe pilot's improper decision to depart with a preexisting tailwind and failure to abort takeoff. Contributing to the severity of the injuries was the failure to properly restrain (FAA-required) the child passenger.NTSB CHI08LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Fairfax, IAFuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.NTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.NTSB CHI08LA037Accident · 2 fatalLimited investigationFinal reportPadelt PG37-1 · Hampton, IAThe pilot's inadequate in-flight planning which resulted in the failure to maintain clearance with the power lines. Contributing to the accident was the power line.NTSB CHI07LA312Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Waterloo, IAThe pilot's failure to maintain adequate clearance from the trees and terrain during a night visual approach for landing. Contributing to the accident were the pilot's lack of recent night flying experience, the night conditions, and the trees.NTSB CHI07CA300Accident · Serious injuriesData collectionFinal reportCameron Balloons O-77 · Creston, IAThe pilot's inadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. Contributing to the accident was the high wind encountered during the balloon flight and the barbed-wire fence.NTSB CHI07CA285Accident · No injuriesData collectionFinal reportNavion Navion H · Atlantic, IAThe pilot's improper flare and touchdown during landing resulting in overload failure of the left main landing gear. A contributing factor was the pilot's distraction due to the unlatched cabin door.NTSB CHI07CA259Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Creston, IAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel calculations.NTSB CHI07CA250Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Vinton, IAThe pilot failed to maintain clearance from the power line while maneuvering during an aerial application flight. A factor was the power line.NTSB CHI07LA246Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Hampton, IAThe pilot's failure to maintain directional control during landing. Contributing to the accident was a ditch.NTSB CHI07CA220Accident · Minor injuriesData collectionFinal reportSchweizer G-164B · West Liberty, IAThe pilot's inadvertent encounter with birds immediately after takeoff and the resulting loss of engine power. Contributing factors were the fence and ditch encountered during the overrun.NTSB CHI07LA213Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Laurel, IAThe pilot failed to maintain clearance with the upsloping terrain for undetermined reasons.NTSB CHI07CA210Accident · No injuriesData collectionFinal reportBoeing A-75N1 · Oelwein, IAThe pilot's failure to maintain directional control of the airplane during a landing roll. Factors associated with the accident was the gusty crosswind condition and the corn crop.NTSB CHI07CA212Accident · No injuriesData collectionFinal reportBell 47G-5 · Jesup, IAThe pilot's inability to maintain control of the helicopter when it unexpectedly encountered a whirlwind shortly after takeoff.NTSB CHI07LA203Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Belle Plaine, IAThe pilot's failure to maintain directional control during landing rollout.NTSB CHI07CA196Accident · Minor injuriesData collectionFinal reportAnderson Glasair FT II · Cedar Rapids, IAThe loss of engine power for undetermined reasons during the downwind leg, which resulted in a forced landing. A factor in the accident was the unsuitable terrain encountered.