NTSB investigations, IN
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.NTSB CHI89LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Michigan City, INFailure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall & collision with the ground. Related factors were: failure of the pilot to follow procedures/directives and his operation of the aircraft…NTSB CHI89LA111Accident · No injuriesLimited investigationFinal reportBoeing E75 · Shelbyville, INThe pilot allowed his attention to be devaited, misjudged altitude and distance to the runway while on final approach, and failed to maintain clearance above the power lines. Contributing factors were: the power lines and parked aircraft.NTSB CHI89LA110Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Indianapolis, INImproper compensation for wind conditions by the pilot, his failure to maintain runway alignment, and his misjudgement of wingtip clearance above the ground as he was maneuvering to avoid the runway & VASI lights. The crosswind and runway/vasi lights were…NTSB CHI89DET07Accident · No injuriesFinal reportGood Varieze · Spencerville, INThe pilot's failure to maintain proper runway alignment during the soft field landing.NTSB CHI89DET06Accident · No injuriesFinal reportDilley P51R · Hamilton, INThe failure of the #3 connecting rod. A factor was the unsuitable terrain.NTSB CHI89DEX04Accident · Serious injuriesFinal reportNorth American SNJ-5 · Sellersburg, INThe ingestion of a foreign object and subsequent supercharger impeller failure.NTSB CHI89FA101Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Bristol, INContinued flight by the pilot into known adverse weather and his exceeding the design stress limits of the aircraft, which resulted in failure of the wing spars and separation of the right wing and empennage (stabilizers). Contributing factors were: continued…NTSB MKC89FA116Accident · 2 fatalField investigationFinal reportBeech D55 · Greenwood, INInadequate preflight and improper use of the fuel system, which resulted in fuel starvation, and improper use of emergency procedures. Factors related to the accident were: self induced pressure by the pilot to meet an arrival time, his failure to extend the…NTSB CHI89LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Terre Haute, INPilot's inability to maintain directional control during the takeoff roll. A factor in the accident was the crosswind.NTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.NTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…NTSB CHI89DET04Accident · 1 fatalFinal reportAmerican AA-1A · Bluffton, INInadequate airspeed resulting in a stall/spin by the pilot. Factors related to the accident were: a tailwind and wrong runway selected by the pilot.NTSB CHI89LA072Accident · No injuriesLimited investigationFinal reportBeech A60 · Indianapolis, INThe pilot misjudged altitude and/or distance to the runway wile on final approach to land. Factors related to the accident were: dark night and pilot fatigue.NTSB CHI89DET03Accident · No injuriesFinal reportNorth American F-51D · Fort Wayne, INPilot's failure to maintain aircraft control during the crosswind takeoff. Contributing to the accident was the premature lift off and the crosswind condition.NTSB CHI89LA063Accident · Minor injuriesLimited investigationFinal reportBeech 95-B-55 · Crothersville, INA failure of the engine due to a crankshaft counterweight failure. The pilot performed emergency procedures and executed a forced landing in an open field, where the aircraft encountered a large muddy area, bogged down and nosed over.NTSB CHI89LA059Accident · No injuriesLimited investigationFinal reportCessna 150L · Sellersburg, INThe failure of the student pilot to control the airplane during the landing flare and touchdown. The student pilots lack of experience and gusty crosswinds are contributing factors to the accident.NTSB CHI89MA057Accident · 2 fatalMajor investigationFinal reportNihon YS-11A-600 · West Lafayette, INA loss of control due to the improper inflight decisions by the crew and the undetected accumulation of ice on the leading edge of the horizontal stabilizer, during flight in a forward center of gravity condition and exacerbated by the extension of full…NTSB CHI89MA047Accident · No injuriesMajor investigationFinal reportDassault-Breguet Falcon 900 · South Bend, INFailure of the thrust reverser actuator links due to a manufacturing/design problem. Factors related to the accident were: the adverse runway conditions and the crosswind.NTSB CHI89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Valparaiso, INInadequate preflight preparation by the pilot, which resulted in inadvertent flight in icing conditions and rapid accumulation of airframe ice, and the pilot's failure to maintain sufficient airspeed to flare during the landing. Factors related to the…NTSB CHI89DEX03Accident · No injuriesFinal reportGrumman American AA-1C · Richmond, INThe pilot's attempt to continue the takeoff with a partial loss of power. Contributing to the accident were the carburetor icing conditions.NTSB CHI89FA040Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Carmel, INThe pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft.NTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INNTSB CHI89FA036Accident · 4 fatalField investigationFinal reportBeech B23 · Jeffersonville, INPilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.NTSB CHI89FA035Accident · 2 fatalField investigationFinal reportCessna 310R · Madison, INPilot-in-command's disregard of IFR procedures in descending below the minimum decision height for the approach to a point where collision with towers and/or wires became possible. His abrupt maneuver to avoid such collision resulted in a stall/spin, from…NTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.NTSB CHI89FA027Accident · 2 fatalField investigationFinal reportGulfstream AA1A · North Vernon, INThe aircraft was observed to make a high speed low level pass adjacent to the runway and a climbing left turn away from the airport, heading north. A witness in a field north of the airport reported seeing the aircraft descending from a low altitude, level…NTSB CHI89DEX01Accident · 1 fatalFinal reportPitts S-15 · Delphi, INFailure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.NTSB CHI89LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Indianapolis, INThe plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…NTSB CHI89LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Indianapolis, INShortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive…NTSB CHI89LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Indianapolis, INThe pilot and his family of three were returning from a vacation in Florida. They made a fuel stop at columbus, Georgia, then tried to fly non-stop from there to kokomo, Indiana. About 50 miles short of the intended destination, the engine lost power due to…NTSB CHI89LA001Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Tell City, INThe pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…NTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB CHI88LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Butler, INDuring a solo flight, the student pilot attempted a landing on a neighbor's cow pasture. The student stated that he misjudged the approach to landing and landed long on the field. He was unable to adequately handle the aircraft and failed to get it stopped…NTSB CHI88DET06Accident · 1 fatalFinal reportJones None · Elkhart, INInadequate aircraft design which resulted unacceptable aircraft takeoff and climb capability.NTSB CHI88LA234Accident · No injuriesLimited investigationFinal reportFairchild PT-19 · Converse, INDuring initial climbout after takeoff, the aircraft experienced a loss of engine power. After an unsuccessful attempt to restart the engine, the pilot executed a forced landing in a corn field. Post accident exam revealed a broken universal joint in the fuel…NTSB CHI88FA203Accident · 2 fatalField investigationFinal reportPiper PA-20 · Claypool, INPilot-in-command's failure to maintain a sufficient visual lookout and perform a pull up in time to avoid collision with a tree.NTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.NTSB CHI88LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Elkhart, INWhile enroute on the second leg of a solo student cross country, the aircraft experienced a total loss of engine power due to fuel exhaustion. The student pilot executed a forced landing in a bean field and the aircraft nosed over during the landing roll,…NTSB CHI88IA217Incident · No injuriesIncident investigationFinal reportBell 206L · Indianapolis, INNTSB CHI88LA211Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hobart, INWhile on a solo instructional flight for the purpose of practicing crosswind takeoffs and landings, the student pilot failed to adequately compensate for the crosswind and experienced a loss of directional control shortly after the aircraft touched down. The…NTSB CHI88FA201Accident · 4 fatalField investigationFinal reportCessna 210B · Noblesville, INNTSB CHI88FA198Accident · 2 fatalField investigationFinal reportPiper PA-28 · Auburn, INFlight known adverse weather conditions.NTSB CHI88DEX11Accident · 1 fatalFinal reportContinental Copters MK-5 · Redkey, INPhysical impairment of the pilot due to drugs which resulted in a misjudged approach and subsequent contact with trees during the approach to an aerial application swath run.NTSB CHI88DET04Accident · No injuriesFinal reportCessna A188B · Preu, INAerial applicator experienced total failure of throttle cable during application swath run. Aircraft received substantial damage when pilot executed forced landing in adjacent crop field. Aircraft and engine had received annual inspection 125 hours prior to…NTSB CHI88LA197Accident · No injuriesLimited investigationFinal reportCessna 310RII · Noblesville, INDuring the landing roll, shortly after touchdown and brake application, the left main landing gear collapsed due to the failure of the drag brace. The pilot was unable to maintain directional control of the aircraft and it veered off the left side of the…NTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INNTSB CHI88DEX10Accident · No injuriesFinal reportWilliams Waco · Madison, INThe plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the…NTSB CHI88LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Greenfield, INDuring a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…NTSB CHI88DEX09Accident · Serious injuriesFinal reportSollars Rotorway Executive · Newburgh, INThe eng lost power as the homebuilt helicopter was on an apch to land at a private heliport. The student plt rprtd the helicopter was at aprx 50 ft AGL when the power loss occurred. Subsequently, during an autorotation, the helicopter touched down hard. No…