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 CHI88DEX08Accident · No injuriesFinal reportContinental Copters Tomcat MK-6 · Straughn, INAerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…NTSB CHI88LA164Accident · No injuriesLimited investigationFinal reportCessna 210M · Indianapolis, INThe pilot reported that he was on his way back from another local airport. He thought that he had lowered the gear when he had entered the traffic pattern. The aircraft landed gear up. Post-accident exam disclosed no mechanical failures or system malfunctions…NTSB CHI88DEX07Accident · Minor injuriesFinal reportCessna 175A · Bloomington, INAircraft experienced partial loss of engine power at 150 feet AGL after takeoff. Pilot made 180 degree turn in attempt to return to airport, but experienced further power loss and elected to make emergency landing in field. Right wingtip hit tree, and…NTSB CHI88IA157Incident · No injuriesIncident investigationFinal reportBeech C99 · Indianapolis, INComponent failure due to improper lubrication by the operators maintenance personnel.NTSB CHI88FA160Accident · 1 fatalField investigationFinal reportCessna 172N · Middletown, INAttempted operation of the accident airplane by the PIC when he was under the influence of alcohol.NTSB CHI88IA159Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Indianapolis, INFailure to ensure proper alignment and closure of the auxillary power unit lower shroud with the fire seal upon completion of a maintenance action.NTSB CHI88LA158Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Mishawaka, INAfter short personal flight, the pilot of the balloon made a landing in an open field. The gondola turned over and was dragged through the field. The pax suffered serious injuries.NTSB CHI88LA151Accident · No injuriesLimited investigationFinal reportCessna 177 · Lowell, INThe student pilot was on final approach for landing when the aircraft began to drift to the left of the runway. The pilot decided to go-around and added full power, pushed the carburetor heat in and retracted the flaps to '1/2'. According to the pilot he…NTSB CHI88DEX06Accident · No injuriesFinal reportPiper J3 · Bedford, INAircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure…NTSB CHI88FA144Accident · 1 fatalField investigationFinal reportCessna 150G · Ft Wayne, INInadvertent stall/spin due to the failure to maintain adequate airspeed, and failure to avoid the adverse wind conditions associated with a thunderstorm.NTSB CHI88DEX05Accident · No injuriesFinal reportBeech V35A · Seymour, INAircraft was in cruise flight at 6500 feet when engine began to run rough. Pilot navigated to nearest airport and made intentional gear-up landing with cruise power. Postcrash investigation revealed number 2 exhaust valve had failed and become wedged between…NTSB CHI88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Noblesville, INDuring initial climbout the pilot stated that he experienced a partial loss of power and was unable to maintain sufficient rate of climb to continue flight. The pilot executed a forced landing in a field, striking trees. Post-accident investigation failed to…NTSB CHI88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Marion, INThe pilot became disoriented during flight and made an unscheduled stop in a corn field to ask for directions to his destination airport. During taxi for takeoff from the field, the pilot failed to maintain adequate visual lookout, and struck a manhole cover…NTSB CHI88LA130Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bedford, INThe pilot landed beyond his intended touchdown point on the runway due to excessive airspeed during the approach to landing and touchdown. When the aircraft ran off the departure end of the runway the pilot elected to perform an intentional ground loop/swerve…NTSB CHI88LA119Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Gary, INWhile on the return leg of a local flight, the pilot was flying at 150' above the water along the shoreline. The pilot's attention was diverted from the task of flying the airplane by navigation duties (the frequency, and adjustment, and tuning of the VOR),…NTSB CHI88LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172 · North Liberty, INWhile departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose…NTSB CHI88LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INNTSB CHI88DET03Accident · No injuriesFinal reportDavis Heath Model V · Valparaiso, INThe plt rprtd that when he applied power to takeoff, the acft 'pulled to the right.' He said the acft became airborne, but touched down again & contd to go to the right. Also, he said he tried to correct the situation with left rudder, but the rudder seemed…NTSB CHI88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INNTSB CHI88LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lake Village, INThe pilot had landed long and, realizing he would not stop before running off the runway, attempted a go-around. The pilot stated he had one notch of flaps down, approximately 10 degrees, and after adding full power attempted to lift-off. The aircraft ran off…NTSB CHI88DEX04Accident · No injuriesFinal reportCessna 172M · Alexandria, INAircraft experienced intermittent engine operation while on final, followed by complete engine failure on landing rollout. Pilot noticed smoke entering cockpit during restart attempt. Aircraft was evacuated by pilot and three passengers. There was an engine…NTSB CHI88IA096Incident · No injuriesIncident investigationFinal reportSwearingen SA-227AC · Fort Wayne, INInadequate design of the strut for the intended service conditions in commuter air carrier operations.NTSB CHI88LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Muncie, INWhen the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move…NTSB CHI88LA085Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Indianapolis, INFifteen minutes after the pilot had taken off on a tow plane operation he returned to the local arpt. After landing he turned downwind to taxi to the ramp. The wind raised the tail of the tailwheel acft and nosed the acft inverted. The pilot estimated the…NTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.NTSB CHI88DEX03Accident · Minor injuriesFinal reportPiper PA-28-140 · Evansville, INPilot attempted maximum gross weight take-off from soft soggy field with 10 degree flaps selected. Stall warning activated on lift-off, aircraft climbed to approximately 50 feet then began losing altitude and airspeed, made uncontrolled landing in muddy field…NTSB CHI88LA072Accident · No injuriesLimited investigationFinal reportCessna P210 · Indianapolis, INWhile landing on the ice-covered runway, the pilot failed to stop his aircraft before the end of the runway. The aircraft ran off the departure end of the runway, encountered soft terrain and nosed over. The pilot had received two partial weather briefings,…NTSB CHI88LA071Accident · No injuriesLimited investigationFinal reportCessna 150M · Crane, INN66452, collided with a street signpost at the Crane naval depot, Crane, IN, during landing roll after a precautionary emergency landing. The right wing of the aircraft was substantially damaged. The student was on the return leg of a two-leg solo cross…NTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.NTSB CHI88FA067Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Martinsville, INPilot to take into caonsideration the wind direction and velocity before selecting his takeoff direction.NTSB CHI88LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Martinsville, INWhile engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…NTSB CHI88LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Wayne, INAirplane nosed over in soft snow during a crosswind landing attempt. The PIC tried to recover from a loss of directional control by attempting to roll out on snow covered sod after hopping over a snowbank that was next to the runway landing surface.NTSB CHI88DET02Accident · No injuriesFinal reportBeech A35 · Wheeler, INThe acft was being operated iaw a ferry permit to obtain an annual inspn. The prev annual inspn was on 3/13/85. Drg flt abt 1.3 hrs after takeoff, the eng lost pwr. The plt noted the fuel pres was zero. He said he turned on the aux fuel pump & insured the…NTSB CHI88LA054Accident · Minor injuriesLimited investigationFinal reportMooney M20A · La Porte, INThe aircraft experienced a complete power failure and while the pilot was attempting to make an emergency landing ran through a fence and between two trees substantially damaging the aircraft. The pilot sustained minor injuries. Post acc invest revealed a…NTSB CHI88LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Converse, INThe plt had flown one closed circuit pattern of the local arpt and landed to pick up two additional passengers. Purpose of the local flight was for sightseeing. The acft was parked with engine at idle. One boarding passenger approached the acft from the left…NTSB CHI88FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Warsaw, INAircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No…NTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.NTSB CHI88DET01Accident · Minor injuriesFinal reportPiper PA-28-181 · Fort Wayne, INPilot on night cross country flight with clear, very cold weather, experienced total loss of engine power while cruising at 7500 feet MSL. Approach control gave position of closest field, but pilot elected to continue to destination which was five miles…NTSB CHI88LA027Accident · No injuriesLimited investigationFinal reportCessna 150J · Patoka, INWhile enroute to Patoka airport for fuel the aircraft experienced fuel exhaustion and the pilot was forced to make an emergency landing in a field. The aircraft landed approximately two miles northeast of the airport. The nose gear of the aircraft became…NTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…NTSB CHI88LA013Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Leavenworth, INAccording to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff…NTSB CHI88LA009Accident · No injuriesLimited investigationFinal reportCessna R182RG II · Indianapolis, INAfter take-off, the pilot attempted to retract the landing gear when the hydraulic line on the right main gear actuator failed. The left main landing gear was stuck in the trailing position while the nose gear and right main gear remained down and locked. The…NTSB CHI87LA225Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Rochester, INThe tailwheel aircraft was landed into a strong left crosswind, experienced a loss of directional control, followed by a ground loop, and nose over.NTSB CHI87DEX09Accident · Serious injuriesFinal reportde Havilland Dragonfly DH-90 · Sellersburg, INAircraft began left drift during takeoff roll. Pilot corrected with right rudder, and aircraft veered sharply right. Aircraft did not respond to application of left rudder or increased thrust from right engine; departed runway and crashed into drainage ditch.…NTSB CHI87LA216Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Washington, INThe pilot was landing the aircraft, after returning from a personal cross-country flight, when he encountered a crosswind gust and 'veered strongly to the right.' The pilot then decided to abort the landing and proceeded to add full power for a go-around.…NTSB CHI87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Belleville, INThe aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…NTSB CHI87LA210Accident · No injuriesLimited investigationFinal reportBeech 100 · Batesville, INThe aircraft was approaching hillenbrand airport when the pilot noticed a thunderstorm cell moving in on the airport. The pilot elected to expedite into hillenbrand. During the approach the landing gear was never placed in the extended position. The pilot…NTSB CHI87LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Indianapolis, INThe acft was on the third tkof of the day when the eng stopped on initial climb at the pilots estimated alt of 500 ft. he did a 180 turn back to the arpt but touched down short and ran through the perimeter fence. Examination of the acft revealed that the…NTSB CHI87DEX08Accident · Minor injuriesFinal reportChampion 7KCAB · Sheridan, INOn initial climbout at approximately 400' AGL the aircraft experienced a total power failure. The pilot attempted to maneuver the aircraft to return to the airport, however, the aircraft was forced to land in a farm field 1/4 mile short of the airport. The…NTSB CHI87FA198Accident · 2 fatalField investigationFinal reportBeech B35 · Martinsville, INShortly after takeoff an engine failure occurred. The aircraft stalled and spun to the ground when the pilot tried to return to the airport. The fuel selector was positioned on the almost empty auxiliary tank (meant for use in level flight only).