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 DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…NTSB CHI87LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nobelsville, INThe 160 hr tt pilot, recently checked out in this make/model acft, was returning to home base on a x-country flt. He ld long and was unable to stop before hitting a fence off the departure end of the rnwy.NTSB FTW87FA183Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Kokomo, INThe plts preflt wx briefing revealed marginal VFR & IFR wx along his proposed route, with a precaution for thunderstorms. An IFR flt plan was filed and the acft departed. Later during flt the plt was radioed info about a convective SIGMET that contained a…NTSB CHI87LA180Accident · No injuriesLimited investigationFinal reportHughes 369HS · Griffith, INThe tail boom of the helicopter was severed after rotor blade contact during a hard landing. The acc occurred during an autorotation demo for the police dept with a power recovery. Application of power was late and the helicopter landed hard and bounced. The…NTSB CHI87LA165Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Lake Monroe, INThe float equipped acft took off from Lake Monroe with 2 rated plts on board. The plt-in-command (PIC) stated that the takeoff distance may have been about 20% longer than normal. He said that after climbing about 200 to 250 ft, the coplt began a rgt turn,…NTSB CHI87LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Vincennes, INThe pilot attempted to takeoff with the fuel tank selector selected to an empty tank. Shortly after lift-off the engine stopped and the acft skidded across a road and struck an embankment.NTSB CHI87LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Ft. Wayne, INThe pilot reported that the airspeed indicator failed in flight. The aircraft landed hard and porpoised. The nose wheel broke off and the aircraft skidded down the runway grinding off the bottom of the carburetor. A fire broke out destroying the aircraft.…NTSB CHI87DET07Accident · 1 fatalFinal reportMcentee Stitsplaymate SA-11A · Rolling Prairie, INAircraft crashed in open rising field killing pilot and destroying aircraft. Homebuilt aircraft was not ifr-equipped or certified. Pilot had less than ten hours on aircraft. No flight plan filed. No record of weather briefing, or in-flight weather advisory.…NTSB CHI87DEX07Accident · Serious injuriesFinal reportBoeing E75 · Mccordsville, INDuring initial climb the engine sustained a total power failure and the pilot attempted to return to the airport. The aircraft impacted in a soybean field approximately 200 feet short of the runway in a 20 degree nose down attitude. Investigation revealed the…NTSB CHI87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Muncie, INAfter landing on rwy 32 the acft veered to the left, crossing a parallel taxiway and striking a taxiway light. The plt stated that the acft then became airborne before striking a terrain depression, at which time the nosewheel sheared off and the propeller…NTSB CHI87LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Anderson, INThe plt rprtd that shortly after lift-off, the eng bgn 'hitting & missing.' He made a shallow left turn to avoid a house & land in a corn field. However, the acft stalled & the left wing struck the ground. An exam of the eng revealed that a screw (which held…NTSB CHI87LA146Accident · No injuriesLimited investigationFinal reportCessna 210M · La Porte, INThe acft was damaged when the left main gear collapsed drg a landing. An investigation revealed that a swaged fitting at the end of a hydraulic line in the gear sys had failed. The plt rprtd that with this failure, the left main gear only partially extended.NTSB CHI87DET06Accident · No injuriesFinal reportKennedy Avid Flyer · Goshen, INWhile cruising at 1600 feet MSL, one propeller blade failed in the root area and departed the engine. The pilot made a successful emergency landing in a farmer's field. Vibrations, resulting from the unbalanced propeller condition, were of sufficient…NTSB CHI87DET05Accident · Serious injuriesFinal reportBannwart Maxair XP-503 · Michigan City, INWhile in cruise flight the carburetor of this amateur built aircraft became detached and the engine failed. An emergency land was attempted, however obstacles prevented a landing at primary landing site and an alternate was selected. The aircraft was unable…NTSB CHI87LA144Accident · No injuriesLimited investigationFinal reportCessna 182M · Lake Village, INThe aircraft bounced twice while landing on runway 36 and nosed over after the third bounce. Pilot reports being high on final with 20 degrees flaps so she applied full flaps and steepened glide angle. She also reports a northwest crosswind at 15 to 20 knots,…NTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…NTSB CHI87LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marion, INAs the student plt was making a x-wind takeoff on a dual instructional flt, the instructor (CFI) reduced the power at about 15 ft AGL to simulate an eng failure. The student reacted by raising the nose of the acft, but the instructor corrected this by…NTSB CHI87DEX06Accident · Minor injuriesFinal reportCessna 172E · Huntingburg, INWhile on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…NTSB CHI87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Plymouth, INWhile on final approach about 200 feet from the end of the runway, the right front seat passenger told the pilot she thought she saw a deer. The pilot added power for a possible go-around. Since he did not see any deer, the pilot continued his landing. He…NTSB CHI87DET04Accident · Minor injuriesFinal reportCessna 172P · Peru, INThe pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain.NTSB CHI87LA125Accident · No injuriesLimited investigationFinal reportCessna 120 · Lebanon, INWhile landing on runway 18, pilot lost directional control and veered off left side of runway into a gully. The pilot stated prior to landing he received winds reported from 220 degrees at 11 knots through ATIS.NTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…NTSB CHI87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kentland, INPilot reported a loss of power approx. 10 to 30 feet above the runway. The aircraft came to rest along the left side and approx. 1500 feet down the 3500-foot runway. Inspection of the aircraft after the accident did not reveal any evidence of engine problems.…NTSB CHI87LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Terre Haute, INAircraft stalled on takeoff during an instructional flight. No malfunctions or mechanical problems were reported by either pilot. Witnesses reported that the engine sounded smooth but did not seem to be developing full power. Inspection of aircraft after the…NTSB CHI87DET03Accident · Serious injuriesFinal reportJagger Tierra II · Columbia City, INShortly after takeoff at about 100 feet AGL the engine lost power. The aircraft stalled and impacted the ground in a plowed area adjacent to the runway. The owner/pilot stated that an unidentified substance almost totally blocked the fuel filter closest to…NTSB CHI87FA114Accident · 1 fatalField investigationFinal reportCessna 182G · West Point, INDrg an IFR arrival, the plt was clrd for an ILS rwy 10 apch. No radar facilities were available, but at 1026 EST, he rprtd he was established on the localizer. Aprx 4 min later, he declared a missed apch & was cleared back to the outer marker (om), then was…NTSB CHI87FA106Accident · Serious injuriesField investigationFinal reportAirbus Industrie A300B4-203 · Indianapolis, INWhile cruising at ngt in clr air (well abv clds), eastern ai lines flt 477 was in light chop at FL 310 with the seat belt sign on. The captain stated that when the turbulence increased to a moderate cond, he made an announcement for the flt attendants (f/a's)…NTSB CHI87LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Shelbyville, INThe plt's original destn was lexington, KY, however between bluefield, KY and lexington, he amended his destn to indianapolis, IN. The plt stated that fuel consumption was calculated as 7.1 gph, but he did not take into consideration the Cessna 172 time/fuel…NTSB CHI87FA099Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Attica, INAfter completing a cable patrol flt, the plt landed at sullivan, IN, to refuel before starting a night flt to reposition the acft at lafayette, IN. The plt departed in clear wx. However, as he was arriving at lafayette, he advised the tower controller that…NTSB CHI87LA098Accident · No injuriesLimited investigationFinal reportHughes 269B · South Bend, INAccording to the plt, after departure from aurora municipal airport, he landed at an airfield west of elgin, Illinois and picked up the two passengers. The plt stated that he then departed for elkhart, Indiana. According to an Indiana state police aircraft…NTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…NTSB CHI87DET02Accident · No injuriesFinal reportCessna 170B · Angola, INPilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop.NTSB CHI87LA088Accident · No injuriesLimited investigationFinal reportBeech C-35 · Lake Station, INThe aircraft struck a guard rail during an emergency landing on interstate 80 after experiencing fuel exhaustion. The pilot had visually inspected his fuel supply prior to the first leg of the flight and thought there was enough fuel for the trip. Inspection…NTSB CHI87LA074Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntington, INWhile executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest…NTSB CHI87LA072Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martinsville, INWhile landing to the east the plt was blinded by the sun and the acft struck telephone wires.NTSB CHI87LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, INAt aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…NTSB CHI87LA071Accident · No injuriesLimited investigationFinal reportCessna 152II · West Middleton, INDuring the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing.NTSB CHI87IA067Incident · No injuriesIncident investigationFinal reportBoeing 727-122 · Fort Wayne, INAircraft exterior skin failed in fatigue while in cruise flight. The aircraft lost cabin pressure and the passenger oxygen masks automatically deployed. The flight crew donned oxygen masks, declared an emergency to ATC and descended to 10,000 ft. the aircraft…NTSB CHI87DEX05Accident · No injuriesFinal reportCessna 340A · Bloomington, INThe plt rprtd that drg preflt, there was snow on the acft which would move with hand brushing, so he elected not to remove it. Drg departure, as he rotated the acft to lift-off, he noted the acft did not feel right. He intentionally aborted the takeoff, but…NTSB CHI87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INNose gear collapsed after student pilot failed to recover from a bounced landing. The student plt was on the second landing (touch and go) of a supervised solo flight. He stated that he thought that the accident could have been avoided if he had been given…NTSB CHI87IA061Incident · No injuriesIncident investigationFinal reportNihon YS-11A-500 · Remmington, INThe flight crew failed to adhere to appropriate procedures and directives when they failed to select the HP cock levers to the hswl (lock out) position while performing an approach to landing stall during a training/test flight. When stall recovery was…NTSB CHI87FA058Accident · 1 fatalField investigationFinal reportPiper PA-31T · Merrillville, INThe acft was enroute to the chicago midway arpt. While letting down to 16000 ft the pilot reported he was shutting down the right eng. ARTCC cleared the acft to 5000 ft. ten minutes later ARTCC lost radio transponder and mode c contact. 15 minutes later the…NTSB CHI87DET01Accident · No injuriesFinal reportPitts S1S · Warsaw, INAccording to the pilot after touchdown the right brake seemed to lock up with a 'skidding' noise as the aircraft left the runway. The pilot stated he was having difficulty keeping his toes off the brakes as he was attempting to maintain directional control.…NTSB CHI87LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Bloominton, INAccording to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…NTSB CHI87LA046Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Lake Village, INThe pilot stated that he gradually lost power while on final approach. He finally stalled the aircraft and pancaked it into the trees before the runway. The pilot also stated that he suspected carburetor ice was involved.NTSB CHI87DEX04Accident · Serious injuriesFinal reportAero Commander 500B · Hagerstown, INThe pilot was on the fourth leg of a night cargo flight cruising at approximately 500' AGL enroute to Mt. Vernon, IL, when the aircraft struck some trees and subsequently collided with the ground. The engines and propellers were both torn down and tested and…NTSB CHI87MA053Accident · 2 fatalMajor investigationFinal reportHughes 269B · Cross Plaines, INThe plt & observer were on a power line patrol flt. While proceeding southbound, they apchd an area were the lines were about 23 ft AGL & were crossed by another set of power lines, oriented in an east-west direction. The other power lines were about 45 ft…NTSB CHI87LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Evansville, INAccording to the plt, just after starting a descent from 300O feet, while inbound to Evansville dress regional airport(evv), the engine 'suddenly and without warning quit.' The plt stated that after deciding he could not make evv, he turned left and set up a…NTSB CHI87DEX02Accident · Minor injuriesFinal reportRohdecap/Thorp T-18 · Elwood, INThe plt departed anderson, Indiana to check farm fields for standing water, then elected to land at the Elwood arpt at Elwood, Indiana. The sod rwy at the arpt had an uneven gradient & was soft from recent rains. While landing on the soft,uneven rwy, the acft…NTSB CHI87LA028Accident · No injuriesLimited investigationFinal reportBeech 23 · Laporte, INThe plt stated that at the initial full throttle position the acft developed 2450 RPM. According to the plt, at approximately 200 feet of altitude he noticed a loss of rpm's to 2050 and he immediately rechecked the throttle and mixture controls, the magneto…