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 CHI93LA348Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Blakesburg, IAThe pilot's failure to maintain clearance with the fence post and his midjudging the airplane glidepath.NTSB CHI93LA345Accident · No injuriesLimited investigationFinal reportBeech P35 · Ottumwa, IAan oil leak in the oil filter adapter. A factor was landing in a crop field.NTSB CHI93LA325Accident · No injuriesLimited investigationFinal reportCessna 152-II · Keokuk, IAthe loss of engine power due to an exhaust valve failure. A factor related to the accident is the power line.NTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.NTSB CHI93DCD03Accident · 1 fatalFinal reportHoward W. Dutton Glas AIR II RG · Mt. Pleasant, IAthe pilot-in-command's not maintaining aircraft control.NTSB CHI93LA305Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Clarinda, IAThe commercial pilot's failure to maintain adequate clearance from obstacles during aerial application maneuvers.NTSB CHI93LA264Accident · No injuriesLimited investigationFinal reportBellanca DW-1 · Grinnell, IAthe loss of engine power due to undetermined reason(s). A factor in the accident is the soft field landing site.NTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.NTSB CHI93GA204Accident · 2 fatalFinal reportBeech 95-C55 · Fort Madison, IAthe pilot-in command's failure to maintain control of the aircraft. Factors were door not secured, checklist not followed, diverted attention of the pilot-in-command, and emergency procedure not followed.NTSB CHI93LA197Accident · No injuriesLimited investigationFinal reportCessna 210L · Indianola, IAA fatigue fracture of the crankshaft.NTSB CHI93DCD02Accident · 1 fatalFinal reportPiper PA-25 · Essex, IAFatigue failure of the forward spar fuselage attachment assembly for the right wing. A factor related to the accident was: the lack of a directed inspection procedure that could have been provided with the issuance of an airworthiness directive.NTSB DCA93GA042Accident · 8 fatalClass 1Final reportMitsubishi MU-2B-60 · Zwingle, IAThe fatigue cracking and fracture of the propeller hub arm. The resultant separation of the hub arm and the propeller blade damaged the engine, nacelle, wing, and fuselage, thereby causing significant degradation to aircraft performance and control that made…NTSB CHI93FA103Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Newton, IAVFR flight into IMC conditions. Factors related to the accident were fog, and the pilot's lack of total instrument time.NTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.NTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.NTSB CHI93LA052Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Cedar Rapids, IAThe pilot-in-command's failure to maintain a proper glidepath.NTSB CHI93LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · La Porte City, IAThe pilot's failure to properly align the airplane with the runway.NTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.NTSB CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.NTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.NTSB CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.NTSB CHI93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Marion, IAThe loss of engine power for undetermined reasons.NTSB CHI93DCD01Accident · Serious injuriesFinal reportRichard O. Middlen Glasair III SH-3R · Larchwood, IAThe pilot-in-command's intentional low pass and his inadequate visual lookout.NTSB CHI92DCD10Accident · Minor injuriesFinal reportCurt Hoffstad Pitts S1-S · Council Bluffs, IAThe failure of the pilot to maintain aircraft control while maneuvering during aerobatic flight.NTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.NTSB CHI92DCD08Accident · Minor injuriesFinal reportJohn Schackel Q2 · Rutland, IAA fatigue failure of the engine crankshaft during cruise flight.NTSB CHI92DCD07Accident · Serious injuriesFinal reportBernard W. Resnik ACRO-SPECIAL · Earlham, IAA loss of total engine power when a failed flapper valve in the air box blocked the flow of air through the carburetor throat.NTSB CHI92LA193Accident · No injuriesLimited investigationFinal reportBell 47-2A-1 · Dubuque, IAThe pilot's failure to maintain both directional control of the helicopter and clearance from the truck.NTSB CHI92LA189Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Oxford, IAWas the pilot's failure to maintain directional control of the airplane during the landing. Factors related to the accident were the pilot's lack of experience in tail wheel airplanes and the gusty wind conditions.NTSB CHI92LA181Accident · No injuriesLimited investigationFinal reportNorth American NA-265-50 · Cedar Rapids, IAThe pilot-in-command's selection of the wrong runway for landing. A factor was the tailwind.NTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.NTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.NTSB CHI92DCD04Accident · No injuriesFinal reportHiller UH-12E · Milford, IAA total loss of engine power for an undetermined reason as the helicopter was performing aerial application maneuvers.NTSB CHI92DCD03Accident · Minor injuriesFinal reportPiper PA-36-375 · Deloit, IAInadequate visual lookout by the pilot in command while performing aerial application maneuvers. A factor in the accident is the pilot's diverted attention.NTSB CHI92LA124Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Garnavillo, IAThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in aircraft type.NTSB CHI92DCD02Accident · Minor injuriesFinal reportQuad City Challenger · Blakesburg, IAFailure of the pilot to maintain aircraft control during final approach. Weather conditions, high wind and turbulence, were factors in the accident.NTSB CHI92DCD01Accident · 1 fatalFinal reportRaymond Bristow Rand KR-2 · Boone, IAFailure of the pilot to maintain aircraft control. A factor in the accident is total failure of the airplane canopy.NTSB CHI92LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Cedar Rapids, IAA result of the pilot-in-command not understanding the airplanes emergency procedures and not performing the appropriate emergency procedures. A factor associated with the accident was an electrical system failure.NTSB CHI92LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8-F · Chapin, IAFailed connecting rod which resulted in a catastrophic engine failure. A factor related to the accident was unsuitable terrain.NTSB CHI92LA038Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Iowa, IAThe pilot's failure to extend the landing gear which resulted in the propeller blades contacting the runway during the landing. A factor related to the accident was the pilot's failure to follow a checklist during the approach.NTSB CHI92LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Decorah, IAInadequate compensation for wind conditions, which resulted in a loss of directional control. Factors related to the accident were: the unfavorable wind conditions, snow covered runway, and snowbanks adjacent to the runway.NTSB CHI92LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Shenandoah, IAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. An associated factor is the pilot's lack of experience in this type operation (crosswind takeoffs).NTSB CHI92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Charles City, IAProper glide path not maintained. Factors in the accident are the premature landing gear extension and inadequate airspeed by the pilot in command.NTSB CHI92LA024Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Burlington, IAThe pilot having an improper fuel tank selector position.NTSB CHI92LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Sioux Center, IAThe pilot in command's not maintaining directional control and not performing an aborted takeoff. Windshear was a factor relating to the accident.NTSB CHI91LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly X-7 · Altoona, IAWeather evaluation misjudged and overconfidence in personal ability. A factor related to the accident was high winds.NTSB CHI91DCD03Accident · 2 fatalFinal reportTullis Tierra II · Ottumwa, IAFailure of the pilot to maintain control of the airplane during maneuvering flight.NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB CHI91DCD02Accident · 1 fatalFinal reportCanadian Car & Foundry Harvard Mark IV · Ida Grove, IAThe pilot's failure to maintain airspeed.NTSB CHI91FA254Accident · 2 fatalField investigationFinal reportCessna 172M · Ottumwa, IAImproper IFR procedure by the pilot by not maintaining the proper minimum descent altitude (mda) until established on the ILS localizer and glidepath.