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 CHI83LA196Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Logansport, INThe plt had recently purchased the amphibious acft, had received 6.7 hrs dual instruction & was indorsed for solo flt. During a x-country from elizabethton, TN, he landed at richmond, KY & purchased 23. 8 gal of fuel. On the next leg to lafayette, IN, he made…NTSB CHI83LA189Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Greencastle, INThe acft experienced power loss at about 300 feet AGL after takeoff. The pilot landed in a cornfield after attempting a restart of the engine. The pilot had put 5 gallons of fuel in the right tank on the day of the accident in preparation for a test flight.…NTSB CHI83LA169Accident · No injuriesLimited investigationFinal reportCessna 172M · Michigan City, INThe pilot stated that the aircraft bounced during landing and settled on the left side of the runway. During the landing roll, the left main wheel rolled off the pavement and the aircraft pulled further left and went off the runway onto wet sod. It slid on…NTSB CHI83FA160Accident · No injuriesField investigationFinal reportGates Learjet 35A · Indianapolis, INThe aircraft struck trees one mile from the runway during an ILS approach to Indianapolis intl airport after a flight from chicago. The pilot successfully executed a missed approach and diverted to hulman regional airport, terre haute, IN, for an emergency…NTSB CHI83LA157Accident · No injuriesLimited investigationFinal reportMooney M20-K · Indianapolis, INThe acft landed hard and bounced enough to make the propeller hit the rwy during landing. The pilot had made an ILS approach and when the acft broke out of the clouds it crossed the rwy threshold at about 70 KTS. At 10 ft AGL the pilot cut the power, flared,…NTSB CHI83LA146Accident · No injuriesLimited investigationFinal reportStinson 108 · Rochester, INThe acft collided with a snow bank and nosed over during landing. The weather was VMC and the wind was from 210 degrees at 5 KTS. The pilot reported his right foot slipped off the the rudder pedal and 'attributes this to stinsons and many other acft were not…NTSB CHI83LA126Accident · No injuriesLimited investigationFinal reportVarieze Varieze · West Lafayette, INThe pilot landed fast and went off the side of the runway after about 3000 feet of roll. A collision with VASI lights stopped the Varieze. This was the pilot's first solo flight in this type aircraft. She had a very short 1/2 hour checkout by the owner of the…NTSB CHI83FA114Accident · Serious injuriesField investigationFinal reportPiper PA-44-180T · Indianapolis, INDuring an ILS apch to rwy 22R, apch control asked the plt to keep his speed up as much as practical. At a later inter- view, the plt could not remember details of the apch. He recalled putting the gear down at the outer marker (om) & using the autopilot to…NTSB CHI83LA102Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kentland, INThe acft veered off the right side of rwy 27 and collapsed the landing gear during landing. The wind was from 180 degrees at 15 KTS. The pilot did not report any mechanical problems with the tailwheel acft.NTSB CHI83LA098Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Warsaw, INThe plt reported that during arrival, he contacted UNICOM for an advisory. Reportedly, the wind at that time was from 090 deg at 15 KTS, within the x-wind capability of the acft. During the approach and landing, the plt slipped the plane to a normal…NTSB CHI83LA093Accident · No injuriesLimited investigationFinal reportBeech D18S · Plymouth, INPilot landed the aircraft with the landing gear up. He said he put the gear selector down but after landing the lever was up. He also mistook gear up warning horn for a stall warning. No malfunctions were reported.NTSB CHI83LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenburg, INThe pilot reported that the engine RPM began dropping while he was crusing at 2500 ft. when carburetor heat was applied, the engine stopped running. The pilot was able to restart the engine and get it to 1200 prm, but it stopped again. A forced landing was…NTSB CHI83LA066Accident · No injuriesLimited investigationFinal reportCessna 182N · Jeffersonville, INThe aircraft engine quit at 2500 feet after takeoff. The pilot could not restart engine. A forced landing was made in anopen field and the aircraft nosed over during the rollout. No reason for the engine power loss was determined.NTSB CHI83LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Batesville, INAfter completing an NDB approach to the airport, runway 18, the aircraft touched down past the midpoint of the runway. The pilot stated that during his initial attempt to brake the aircraft, before retracting flaps, the aircraft ballooned and departed the…NTSB CHI83FA042Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Mccutchanville, INAt about 0401 EST, the pilot took off on an IFR flight and was cleared to climb and maintain 6000 ft MSL. Radar contact was established at about 0402. After about another 30 seconds, radar contact was lost. The aircraft impacted about 3 to 4 mi from the…NTSB CHI83LA033Accident · No injuriesLimited investigationFinal reportCessna 421C · Evansville, INDuring 100 hour inspection a leak was found in the left main landing gear actuator. The seals were replaced and the aircraft was test flown. The gear down green light would not come on during the test but the aircraft was landed uneventfully and put on jacks…NTSB CHI83LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Boonville, INOn takeoff the pilot reported the aircraft would not climb but kept settling back to the ground. The left wing hit a fence post and the aircraft nosed over.NTSB CHI83LA027Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Georgetown, INThe pilot started to takeoff from area that was difficult to exit. He relanded once. During the 2nd attempt to fly out, the helicopter collided with trees and crashed. The pilot was not rated in helicopters, but he said he had soloed.NTSB ATL83LA016Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Indian Mound, INApproximately 10 minutes after departure the pilot of N739RJ reported "engine problems." The pilot stated that he tried various power settings and fuel selections without success. He advised fort campbell approach control that he was landing into trees.…NTSB CHI83FA024Accident · 1 fatalField investigationFinal reportC. EFF VARI-EZE · Seymour, INAircraft was being taxi tested when it became airborne and flew a fast, low tentative pattern. Turning final the turn was very steep and aircraft descended to ground impacting a tree prior to ground impact. The pilot had no recorded flight time in this…NTSB CHI83LA021Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Indianapolis, INThe left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft.NTSB CHI83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Indianapolis, INThe landing gear retracted at 64 mph during the takeoff roll. The takeoff was aborted and the aircraft slid on its fuselage. The landing gear systems all operated normally when checked after the accident.NTSB CHI83LA005Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INAfter takeoff from a touch & go the eng lost power. The #1 cyl upper plug lead nut had backed off & the lead was found resting in the plug. The #2 & #4 cyl upper plug lead nuts had backed off & both leads were not in the spark plugs but were resting on the…NTSB CHI82DA355Accident · No injuriesFinal reportBeech G18S · Indianapolis, INThe pilot stated that the aircraft veered to the left just after rotation. He pushed the propeller, power and mixture controls forward. The left wing and left main gear struck the ground. The aircraft then began to spin while in ground contact. The left…NTSB CHI82DA353Accident · No injuriesFinal reportPiper PA-23-250 · Fort Wayne, INPlt taxied off rwy onto grass to give way to landing traffic. Paved taxiways are not available & 50 ft either side of runway is used for taxiing with the grass being kept mowed. Before he was able to taxi back onto the paved rwy the ground gave way & the nose…NTSB CHI82DA324Accident · No injuriesFinal reportPiper PA-28-160 · Knox, INThe pilot departed on a flight from lake village to Knox, IN. While en route, he landed to refuel at rensselaer, IN. During the flight from rensselaer to Knox, the engine began loosing power when he was about 5 mi from the destination. When the pilot realized…NTSB CHI82DA272Accident · No injuriesFinal reportStinson 108-1 · Laporte, INThe pilot/mechanic was preparing to make an annual inspection of the aircraft. He was in the process of flight testing the plane to find defects when engine stoppage occurred. While landing in a bean field. The left tire blew out and the left gear dug into…NTSB CHI82FA259Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Winamac, INThe plt was practicing aerial application maneuvers, & after making a low pass down the rwy at his private airstrip, theengine quit. The acft collided with 30-FT high power lines located at the end of the strip. A state trooper who arrived at the scene 10 to…NTSB CHI82DA252Accident · No injuriesFinal reportCessna 150 · Bloomington, INThe student pilot reported that during arrival, he was unable to contact UNICOM. He stated that he saw other aircraft using runway 35. A landing was made on runway 35 with the wind from 180 at 12 KTS. The pilot stated that during the roll-out, the aircraft…NTSB CHI82DA240Accident · No injuriesFinal reportPiper PA-24-250 · Lafayette, INDuring arrival, the pilot was unable to extend the gear by using the normal (electrical) system or the manual emergency handle. After repeated attempts to correct the malfunction, he elected to land with the gear up.NTSB CHI82DA239Accident · No injuriesFinal reportCessna 170B · Plymouth, INPilot practicing touch and go landings. During roll aircraft swerved off runway and in jumping a ditch dug a wing into ground and nosed over.NTSB ATL82DA194Accident · Minor injuriesFinal reportCessna 182 · Madison, INThe pilot reported that he experienced a gradual loss of power on a dark night. The terrain was hilly and covered with trees, and reportedly, the pilot elected to land upwind on the Ohio river. After ditching, the occupants egressed and swam to shore, but the…NTSB CHI82DA232Accident · No injuriesFinal reportCessna 152 · Harlan, INReportedly, the pilot was demonstrating a forced landing to the passenger by moving the mixture to cut-off. He stated that another aircraft interferred with his approach and he was unable to restart the engine to go around. Subsequently, the aircraft nosed…NTSB CHI82DA220Accident · Minor injuriesFinal reportPiper PA-18 · Hobart, INDuring takeoff, the engine lost power at an altitude of about 150 to 200 ft AGL. Subsequently, during a forced landing, the aircraft flew through a row of trees when the pilot tried to reach an open area that turned out to be a grave yard. The pilot believed…NTSB CHI82DA217Accident · Minor injuriesFinal reportTaylorcraft BC12-D · La Porte, INThe pilot had flown to the airport to participate in activities of a contest that included spot landings and balloon busting. He stated that on his third pass of a balloon busting contest, he turned too tight, too slow, and the aircraft stalled. The pilot…NTSB ATL82DA171Accident · Minor injuriesFinal reportPiper PA-25-235 · Ripley, INWhen the pilot arrived to spray the field for the first time, he saw powerlines along a road and saw poles on both sides of a creek. He assumed that all of the lines followed the road. He was unaware that a powerline crossed the narrow field that he was about…NTSB CHI82FA203Accident · 2 fatalField investigationFinal reportBellanca 7KCAB · Centerpoint, INThe non-rated owner/pilot crashed after taking off from a private sod strip. The impact point was about 400 ft from the departure end of the runway and 200 ft left of the centerline. According to a witness, the takeoff roll was started from a crown on the…NTSB CHI82DA197Accident · No injuriesFinal reportAdams A55 · Fritchton, INThe pilot decided to land due to deteriorating weather. A descent was initiated but the pilot was waved off by the owner of the property. The pilot regained altitude and landed in a corn field. A gust of wind caused the balloon to drift, the basket was drug…NTSB CHI82DA189Accident · No injuriesFinal reportCessna 172 · Evansville, INThe pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…NTSB DEN82IA098Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-61 · Near Goshen, INThis aircraft encountered unforecast severe clear air turbulance (cat) while in cruise flight at FL350 Near Goshen, IN. As a result of the encounter, the aircraft entered an uncontrolled descent which was arrested at 31,500 feet. A total of seventeen…NTSB CHI82DA190Accident · No injuriesFinal reportCessna 310R · Evansville, INAfter the aircraft had touched down from an ILS approach, tower personnel asked the pilot if he could make the first turnoff. Shortly after that, the right gear collapsed when the landing gear rod assembly, pn 0840125-15, failed. A metallurgical examination…NTSB CHI82DA170Accident · Serious injuriesFinal reportPlaymate SA11A · Pendleton, INThe pilot was cruising at 2000 feet with one passenger when the engine quit. He made a forced landing in a soft soybean field and the aircraft nosed over during deceleration. The aircraft revealed the exhaust system baffles were collapsed. "Blow by" was…NTSB CHI82DA152Accident · Minor injuriesFinal reportPiper PA-12 · Quincy, INDuring a pleasure flight, the pilot elected to make an approach to a new runway that he was building. His approach was made from west to east; the wind was reported to be from the north at 7 KTS. The pilot stated that he throttled the engine back to a normal…NTSB CHI82DA148Accident · No injuriesFinal reportBeech C35 · Dillsboro, INThe aircraft operated normally during taxi, run-up, takeoff, and climb to 3500 ft MSL. About 17 miles from the departureairport, the engine stopped running. During a forced landing in a dirt field, one of the main gear failed. The propellerseparated and the…NTSB CHI82DA147Accident · Serious injuriesFinal reportMong Sport MS-1 · Pendleton, INWhen the pilot arrived at anderson, Indiana, he was unable to find the ace airport. He saw huntzinger airport, a private strip, and decided to land to find out exactly where ace airport was located. During an approach to the sod runway, the aircraft collided…NTSB CHI82DA133Accident · No injuriesFinal reportCessna 182 · Brazil, INThe pilot elected to land on the grass adjacent to a paved runway. While on landing roll the landing gear contacted the edge of a paved taxiway that ran perpendicular to the runway. The aircraft nosed over and came to rest inverted.NTSB CHI82DA130Accident · No injuriesFinal reportCessna 150 · Gary, INThe aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the…NTSB CHI82DA126Accident · No injuriesFinal reportRaven RX-6 · Sellersburg, INDuring a landing approach, the pilot was aware of powerlines to the left of his course. Just prior to touchdown, he became aware of a branch off of the powerlines that crossed in front of the balloon's path. He ripped out the top inflation panel; however,…NTSB CHI82DA115Accident · No injuriesFinal reportSwearingen SA226TC · Fort Wayne, INPrior to landing the crew was advised by Fort Wayne ATC that the 150 foot wide runway had been plowed 140 feet wide with 18 inch windrows on each side of the runway. The runway was reported to be 40 percent covered with finger drifts. The wind was from 010…NTSB CHI82DA099Accident · No injuriesFinal reportPiper PA-38 · Fort Wayne, INThe student pilot was practicing landings with a headwind directly down the runway at 7 knots. During touchdown on his third landing, he lost directional control and the plane veered left and skidded off the runway. The nose gear encountered a side load and…