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 CHI87LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Winamac, INAfter noticing a vague shape off the right side of the aircraft, during takeoff run at night, the pilot continued down the runway until the aircraft collided with a 180 pound deer.NTSB CHI87LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · South Bend, INDuring cruise at 7000' MSL, the plt assumed that he was having an electrical failure because he had not heard any ARTCC transmissions, fuel gauges were indicating low fuel, ammeter reading was zero, and landing gear would not cycle. He shut off all electrical…NTSB CHI87DEX01Accident · No injuriesFinal reportTurnbloom Kitfox · Crawfordsville, INThe plt rprtd that when he was preparing for the acft's 1st test flt, he made a hi speed run with the tail raised & acft control was good. On the next run, he planned to let the acft lift off the rwy, then let it settle back on the surface. He stated that he…NTSB CHI87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INDuring an instructional flight a bird strike was encountered while practicing steep turns at about 2500' MSL. The horizontal stabilator was damaged to the point that it was barely operative. Landing was accomplished by using extreme forward pressure to the…NTSB CHI87LA007Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lake Village, INThe plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the…NTSB CHI86LA234Accident · No injuriesLimited investigationFinal reportBeech BE-95-55 · Shelbyville, INWhile at cruise after sunset, the pilots discovered that the left panel lights and the overhead light were not operating. A white beam flashlight was used to observe the airspeed indicator, however, continued use of the flashlight blinded the pilots' vision…NTSB CHI86LA226Accident · No injuriesLimited investigationFinal reportCessna 150M · Terre Haute, INThe acft was equipped with an O-320-E2D eng, but the plt calculated his fuel consumption based on the original eng, which was an O-200-A. The O-200-A eng used aprx 8 gal/hr, whereas, the O-320-E2D used about 10 gal/hr. Before reaching the destination on the…NTSB CHI86IA225Incident · No injuriesIncident investigationFinal reportBoeing 727-25 · Evansville, INAfter the aircrew of eastern flt 254 (a Boeing 727, N8107N) had landed on rwy 22 at night & was slowing, the tower controller (ctlr) instructed them to 'turn right on taxiway bravo, if able, hold short of rwy 18 and remain this frequency.' The crew of flt 254…NTSB CHI86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greenwood, INThe brake pads on the aircraft were allowed to wear beyond their limits. When the brakes were applied, the right brake cylinder moved out past its limit and released the o-ring. This resulted in a loss of brake fluid from the right brake. All of this happened…NTSB CHI86LA223Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, INThe aircraft veered off the left side of the gravel runway during the takeoff ground roll. The pilot stated that the airstrip was surrounded by cornstalks, and that on the left side of the airstrip, there was deep loose gravel. Reportedly, the loose gravel…NTSB CHI86LA219Accident · Minor injuriesLimited investigationFinal reportHughes 500 (369HS) · West Lafayette, INThe helicopter was at a low altitude hover video taping an athletic event when the aft flex coupling on the tail rotor failed. The plt was unable to regain control and during descent the main rotor blades struck the roof of a residence. The helicopter then…NTSB CHI86FA200Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Shelby, INThe non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…NTSB CHI86FA191Accident · 2 fatalField investigationFinal reportHawker Siddeley DH-125-1A · Bedford, INThe plt canceled IFR 8 miles from the arpt to continue on a visual apch and landing. Witnesses stated a strong thunderstorm had just passed over the arpt. Wind info issued to the plt by UNICOM were west at 20 KTS. Witnesses observed the acft apch rwy 31 and…NTSB CHI86LA197Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Perrysville, INThe acft was substantially damaged during a forced landing in a corn field following a loss of power. Post accident inspection of the acft failed to reveal any fuel in either the fuel tanks or carburetor.NTSB CHI86LA177Accident · No injuriesLimited investigationFinal reportCessna 150 · Indianapolis, INThe student plt had been practicing touch and go landings for aprx 1 hour. On the accident landing, the acft veered to the left. The plt overcorrected and the acft began to travel off the right side of the rwy. While attempting a go-around the acft's wing…NTSB CHI86LA168Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Indianapolis, INThe aircraft landed gear up at Indianapolis international airport. Pilot and witness report that gear was down. However, FAA inspectors and mechanics who inspected the aircraft state that the left main and nose gear were found in the wheels wells and the…NTSB CHI86LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student plt initiated the takeoff, however, the CFI took over control of the acft when it became apparent that the acft was not climbing. The CFI was unable to salvage the takeoff and the acft struck and settled into trees at the departure end of the rwy.NTSB CHI86FEX10Accident · Minor injuriesFinal reportBell 206L-II · Kokomo, INThe helicopter experienced a loss of power during cruise, for undetermined reasons, and was forced to make an emergency landing. Prior to touchdown the helicopter experienced a loss of directional control, due to a failed hydraulic pump, and collided with the…NTSB CHI86FEX09Accident · Serious injuriesFinal reportCessna 150F · Marion, INThe plt rprtd that while circling around farm fields, he entered a turn & was looking behind the acft when it entered a power-on stall, then began to spin. Rprtdly, the acft was in a nose high attitude when it stalled. The plt stopped the rotation & was…NTSB CHI86LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt stated his left brake failed during landing roll on the 3,200 ft long rwy. The landing was made with a 20 deg right quartering 10 knot tailwind. To prevent running off the departure end of the rwy in to a 50 ft dropoff, the plt ground looped the acft…NTSB CHI86FET02Accident · 1 fatalFinal reportPiper PA-28-180 · Syracuse, INThe acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent…NTSB CHI86LA158Accident · No injuriesLimited investigationFinal reportCessna 182P · Gary, INThe student pilot was on a supervised solo flight. According to him, he closed the throttle over the threshold due to excessive speed and the plane floated for some distance as he brought the control column back. The nose of the aircraft then dropped and the…NTSB CHI86LA157Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Griffith, INThe student plt & instructor (CFI) were on a dual instructional flt, practicing landings. During an apch to rwy 8, the student began to undershoot on final apch. As the helicopter was apchg a fence near the apch end of the rwy, he became alarmed & applied aft…NTSB CHI86FET03Accident · No injuriesFinal reportEdward R. Merkner MUSTANG-II · Valparaiso, INAfter three apparent hard touch-&-go landings, the left main landing gear collapsed on the fourth & final landing. The pilot stated that there were no mechanical malfunctions of the aircraft prior to the accident.NTSB CHI86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Indianapolis, INThe plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.NTSB CHI86FET01Accident · Serious injuriesFinal reportPiper PA-20 · Rolling Prairie, INDuring a go-around from an aborted landing the acft struck unmarked power lines at the departure end of the landing rwy. The acft collided with terrain during the resulting uncontrolled descent. The rwy being used was a 2400 ft long and 50 ft wide sod private…NTSB CHI86LA144Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia City, INThe pilot had become disoriented and was concerned about his low fuel state when he decided to make a precautionary landing. The weather was deteriorating and it was getting dark although the pilot stated he could distinguish the trees from the ground. He…NTSB CHI86LA143Accident · No injuriesLimited investigationFinal reportBeech BE-F90 · Eaton, INThe acft had made a stop at muncie to pick up a fourth passenger. After boarding, the passenger closed the cabin door. After departure and climbing thru 6,000 ft the airstair separated from the aircraft and struck the vertical stabilizer.NTSB CHI86FA141Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Angola, INThe pilot diverted into Angola, an airfield he had never landed at before, due to an unidentified electrical problem at night. He was given vectors to the airport and reported the field in sight. He then said he was going to circle to lose altitude prior to…NTSB CHI86FEX08Accident · Minor injuriesFinal reportConner KR-2 · Hagerstown, INDrg takeoff, the eng sputtered & quit at about 350' AGL. The plt rprtd that he turned on the electrical fuel pump, but did not get the eng started. Subsequently, the acft hit a tree & crashed inverted on the ground. An investigation revealed the push rod for…NTSB CHI86LA135Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Indianapolis, INThe acft had sat idle for four days in heavy rains prior to this flt. A loss of power was experienced during takeoff. The plt attempted a 180 deg turn back to the arpt during which the acft stalled and descended to ground impact. Aprx 2.5 ounces of water were…NTSB CHI86FEX07Accident · Minor injuriesFinal reportAir Tractor AT301 · Bruceville, INThe acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft…NTSB CHI86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Griffith, INAfter takeoff and while climbing through 60 ft AGL the plt could not move the aileron to recover from a 15 deg left bank. The plt reduced power and landed the acft in a left wing low attitude. The acft slid and struck a creek bank with the right wing. Post…NTSB CHI86LA127Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Ft. Wayne, INApprox 10-15 minutes after takeoff the student pilot lost control of the helicopter and crash landed into trees. Following the accident, the only unusual thing FAA personnel could locate was a failed horizontal stabilizer spar. Post-crash examination of the…NTSB CHI86LA125Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Noblesville, INTwo successful takeoffs and landings had previously been completed during the training flight. On the approach for the third landing, the crew received a three-green indication, but after touchdown, the nose gear folded and the aircraft settled on its nose.…NTSB CHI86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Remington, INThe aircraft's engine quit at about 200 feet AGL during takeoff climb. The pilot executed a forced landing into a plowed field and the aircraft nosed over. The pilot stated that he believed the fuel selector was in the incorrect position. Examination revealed…NTSB CHI86FA122Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Westville, INThe plt was taking a friend and two of her acquaintances on a sightseeing ride when the acft crashed into a plowed farm field. The acft's weight was estimated to be 60 lbs under max allowable gross weight at the time of the crash. A witness near the crash…NTSB CHI86LA118Accident · No injuriesLimited investigationFinal reportCessna 411 · Bloomington, INThe plt rprtd that while while on final apch to rwy 35, the acft encountered 'extreme wind-shift' & was blown about 550' rgt of course with a 30 kt loss of airspeed (fm 130 to 100 KTS). He stated the acft lost about 300', then was blown back on course with an…NTSB CHI86LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Veedersburg, INThe pilot was attempting a short field takeoff from a 1080 foot wheat field that he had mistaken for a private airstrip 1 1/2 miles to the northeast. The pilot said the engine had a slight RPM loss and then developed full power but he was unable to clear the…NTSB CHI86FEX06Accident · Serious injuriesFinal reportPiper PA-32-260 · Henryville, INShortly after leveling the acft off at 9000 ft MSL, the plt experienced an engine failure. During the subsequent forced landing the acft struck a tree and was further damaged during the forced landing roll. Metallurgical exam revealed the crankshaft failed…NTSB CHI86FEX05Accident · 1 fatalFinal reportChristen Industries Eagle II · Aurora, INThe aircraft impacted the ground when an unsuccessful aerobatic loop maneuver was attempted on takeoff. The pilot of the aircraft was issued a statement of acrobatic compentency which allowed all maneuvers within the limitations of the aircraft and with a…NTSB CHI86LA107Accident · No injuriesLimited investigationFinal reportNavion H · Columbus, INThe pilot was practicing a short field takeoff when at 30 to 40 feet the engine lost power and quit, the aircraft subsequently landed hard damaging the right landing gear box and fuselage behind the right wing. The pilot said he may have taken off on the tip…NTSB CHI86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Carmel, INThe student plt was on a x-country flt. He took off from an en route arpt with aprx 12 gal of fuel on board & was returning to his home base. Due to high winds at the destination arpt, the student diverted to an alternate arpt. While en route, the acft ran…NTSB CHI86LA093Accident · No injuriesLimited investigationFinal reportBeech C23 · Elkhart, INThe plt was unable to start the acft eng and got out to pull the prop through by hand. The magneto switch had been left in the both position and the eng started as the passenger primed the eng while the plt pulled the prop through. The plt was unable to stop…NTSB CHI86LA089Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Muncie, INThe pilot intentionally landed gear up after an electrical failure and the gear failed to extend normally. The alternator switches were found off after the accident. It was beginning to get dark with ceilings at 2200 ft.NTSB CHI86FA077Accident · 2 fatalField investigationFinal reportMooney M20C · Loogootee, INPlt experienced loss of pwr during cruise flt at 6,000 feet. ATC vectored acft toward daviess county arpt, approximately 10 miles away. Plt reported acft on fire. Witnesses saw N9307V in a left bank turn then 'nose dive into ground.' Post crash exam of engine…NTSB CHI86LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Indianapolis, INThe student pilot flared too high, damaging the aircraft upon touchdown.NTSB CHI86LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Anderson, INThe acft touched down hard on the nose gear during a x-wind landing. The plt reported the acft dropped to the rwy from an alt of aprx 10 ft AGL. Reported winds at the time of the accident were from 240 degs at 15 KTS gusting to 23 KTS.NTSB CHI86LA057Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Indianapolis, INOn the second approach to rwy 22R the private pilot (in the left seat) attempted to land. The right main gear hit hard and the acft bounced coming down on the left wing tip. The acft then hit on its right main gear, then the left main gear. The right main…NTSB CHI86LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Rochester, INUpon takeoff and after reaching an altitude of approx ten feet the right side of the cowl became unlatched and whipped up into the airstream, blocking the pilots forward view and causing some control problems. He elected to abort the takeoff and ran off the…