NTSB investigations, IN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\" = 'IN' 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" = 'IN' 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 CHI96LA219Accident · No injuriesLimited investigationFinal reportNavion NA1 · Evansville, INthe pilot did not maintain control of the aircraft during landing roll.NTSB CHI96LA187Accident · No injuriesLimited investigationFinal reportCessna P206 · Goshen, INthe parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.NTSB CHI96LA178Accident · Minor injuriesLimited investigationFinal reportDickinson Fisher Classic · Mooresville, INthe pilot failed to maintain adequate altitude and clearance from the trees, and had made an improper in-flight decision when he got to far from a suitable landing area. The reason for the loss of power failure was undetermined.NTSB CHI96IA170Incident · No injuriesIncident investigationFinal reportBeech 1900D · Indianapolis, INfailure of a forward cabin ventilation blower motor bearing, which resulted in binding of the blower motor; and inadequate design of the electrical system, which allowed overheating of the electrical circuit and smoke in the cabin of the aircraft.NTSB CHI96IA157Incident · Minor injuriesIncident investigationFinal reportBoeing 727-290 · Indianapolis, INthe failure of the captain and flight engineer to utilize a checklist to troubleshoot a pressurization system problem, and the flight engineer's improper control of the pressurization system which resulted in an inadvertent opening of the outflow valve and…NTSB CHI96LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lafayette, INthe flight instructor's inadequate supervision and the dual student's failure to extend the landing gear. Factors were the distraction of the flight instructor and the student's failure to use checklist procedures.NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Terre Haute, INthe pilot's improper planning/decision, which resulted in his inadequate compensation (or inability to compensate) for the wind condition. The high/gusty wind condition was a related factor.NTSB CHI96LA110Accident · No injuriesLimited investigationFinal reportYakovlev YAK C-11 · North Vernon, INFailure of the pilot to maintain adequate airspeed during an aborted landing, which resulted in an inadvertent stall.NTSB CHI96LA108Accident · 1 fatalLimited investigationFinal reportBishop-Christian Eagle II · Cambridge, INthe pilot allowed the airplane to enter a flat spin, while performing an acrobatic maneuver, and was unable to recover before ground impact. Factors relating to the accident were: the pilot's overconfidence in his personal ability, and his lack of familiarity…NTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.NTSB CHI96FA095Accident · 1 fatalField investigationFinal reportCessna 310 · Portland, INthe pilot's failure to maintain an altitude adequate for terrain clearance. A factor was the weather.NTSB CHI96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Brookston, INthe pilot's disregard for the forecast adverse weather conditions, his inadvertent flight into adverse weather conditions, and his disorientation. Factors relating to this accident were the pilot's lack of experience in instrument conditions, the snow and fog.NTSB CHI96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Marion, INthe pilot's failure to maintain directional control during landing.NTSB CHI96LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zionsville, INthe pilot's failure to maintain directional control of the airplane on the ground. A factor relating to this accident is the snowbank.NTSB CHI96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Zionsville, INthe pilot's failure to properly align the airplane for a safe landing on the runway. Related factors were: the pilot's inadequate preflight planning/preparation, snow, the snow-covered runway, and snowbanks on the sides of the runway.NTSB CHI96LA060Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe failure of the turbocharger, caused by a unapproved rebuild of the turbocharger which contained automotive parts. Debris from the failed turbocharger damaged the oil pump resulting in lack of engine lubrication.NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB CHI96LA047Accident · No injuriesLimited investigationFinal reportCessna 310R · Michigan City, INthe pilot-in-command's selecting and maintaining an improper approach speed.NTSB CHI96LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Wabash, INdeer that went onto the runway as the aircraft was landing. The light condition at dusk was a related factor.NTSB CHI96LA022Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Rochester, INfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall. A factor relating to the accident was: the gusty wind condition.NTSB CHI96LA021Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Indianapolis, INthe pilot's failure to lower the landing gear. Factors which contributed to the accident were: inadequate preflight necessitating a precautionary landing and the pilot's failure to use the pre-landing checklist.NTSB CHI96LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Anderson, INinadequate maintenance in that an engine oil line was not properly tightened after routine maintenance. A factor was the disconnected oil line.NTSB CHI96LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Crawfordsville, INThe pilot's premature raising of the flaps and the low airspeed.NTSB CHI95LA335Accident · Minor injuriesLimited investigationFinal reportBell 206B · Indianapolis, INThe pilot not maintaining adequate terrain clearance during his maneuvering exercise and his abrupt lowering of the collective. A factor associated with the accident was the pilot's lack of experience.NTSB CHI95LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Poseyville, INthe pilot's poor judgement in making a night takeoff on an unlit runway and his failure to maintain proper runway alignment. Factors associated with the accident were the hay bale, the night conditions and the unlit runway.NTSB CHI95LA333Accident · Minor injuriesLimited investigationFinal reportFairchild FA-24 · Blountsville, INpartial loss of engine power for an undetermined reason, and the pilot's improper in-flight planing/decision. Factors relating to the accident were: the pilot's misuse of flaps, and his encounter with high obstruction during the forced landing.NTSB CHI95LA341Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · South Bend, INthe Pilot-in-Command's inadequate supervision of the flight and failure to assure that proper airspeed, rate of climb, and clearance from trees were obtained/maintained.NTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.NTSB CHI95LA287Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Anderson, INseizure of the landing gear wheel bearing and separation of the landing gear outer wheel-half and tire from the aircraft after which directional control of the aircraft by the pilot was not possible.NTSB CHI95LA268Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Auburn, INthe pilot's impairment of judgement and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB CHI95LA269Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Tell City, INthe pilot initated the flight with an inadequate fuel supply and failed to add sufficient fuel en route which resulted in fuel exhaustion. A factor related to the accident was the rough terrain.NTSB CHI95LA284Accident · No injuriesLimited investigationFinal reportVan Zwoll Viking · Decker, INthe failure of the head gasket resulting in a coolant leak and subsequent engine overtemperature. A factor was the unsuitable terrain encountered in the cornfield.NTSB CHI95LA275Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Lowell, INa loss of engine power due to carburetor ice. The lack of suitable terrain for a forced landing was a factor.NTSB CHI95LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Wyandotte, INthe number three intake valve became stuck (seized), which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI95DEX01Accident · Minor injuriesFinal reportCraig Long E-Z · Shelbyville, INthe pilot's improper recovery from a bounced landing which resulted in the nose wheel striking the runway first. A factor associated with the accident was excessive airspeed during the landing.NTSB CHI95LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student pilot's failure to maintain directional control of the airplane, while performing a go-around. A factor relating to the accident was: the proximity of trees beside the runway.NTSB CHI95LA208Accident · No injuriesLimited investigationFinal reportCessna 177B · Nappanee, INThe failure of the pilot to do adequate preflight planning and failure to refuel when he had the opportunity. A factor in the accident was the soft field due to recent rains.NTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.NTSB CHI95LA197Accident · Minor injuriesLimited investigationFinal reportGriner Bushby Mustang I · Shelbyville, INthe pilot's allowing the airplane to inadvertently liftoff. A factor was a malfunction of the flight control system.NTSB CHI95LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INThe pilot's improper execution of the ILS approach. Factors related to the accident were the fog and the pilot's lack of total flight time in actual instrument conditions.NTSB CHI95LA234Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INreason for the occurrence was undetermined.NTSB CHI95LA157Accident · No injuriesLimited investigationFinal reportCessna 182P · French Lick, INthe pilot's not attaining a recovery from a bounced landing. Factors were high obstructions, and the pilot's intentional precautionary landing on rough/uneven and soft terrain.NTSB CHI95FA148Accident · 1 fatalField investigationFinal reportCessna 177B · Nappanee, INairplane control was not maintained by the pilot during the his turn to an emergency landing area. Factors associated with this accident were the pilot not complying with the manufacturer's mandatory service bulletin, and an excessive fuel flow caused by the…NTSB CHI95LA145Accident · Minor injuriesLimited investigationFinal reportFranklin EAA BI-PLANE/P1 · Rockville, INthe pilot's improper maintenance installation and his inadvertent takeoff. A factor was the pilot's inadequate pre-flight planning.NTSB CHI95LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot misjudged the landing flare. Factors related to the accident were the dark light conditions and the pilot's lack of visual cues for the runway environment.NTSB CHI95LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INthe pilot's failure to perform a go-around. The gusty crosswind was a factor in the accident.NTSB CHI95FA082Accident · 1 fatalField investigationFinal reportCessna 310L · Valparaiso, INspatial disorientation of the pilot while descending into the clouds. Factors were the moderate turbulance and snow.NTSB CHI95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Angola, INOverload failure of the right main landing gear shock strut sleeve for an unknown reason.