NTSB investigations, IN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI90LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greenwood, INThe pilot misjudged the landing flare and the airplane stalled and landed hard.NTSB CHI90LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mooresville, INThe pilot in commands failure to land with enough runway remaining resulting in a runway overun and on ground collision with a wall.NTSB CHI90FA161Accident · 1 fatalField investigationFinal reportCessna 152 · Hagerstown, INThe pilot's failure to use all available runway and failure to abort the takeoff.NTSB CHI90LA147Accident · No injuriesLimited investigationFinal reportCessna C205 · Anderson, INThe pilot's encounter with unsuitable terrain during the landing roll after a forced landing. Contributing factors in this accident were the total powerplant failure and the IFR weather conditions which limited the landing site selection.NTSB CHI90DEX01Accident · Minor injuriesFinal reportSattler Aeroduster SA750 · Columbus, INFailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The pilot's lack of experience in the airplane was a related factor.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB CHI90LA134Accident · No injuriesLimited investigationFinal reportCessna 172N · Jeffersonville, INThe engine started for an undetermined reason, when the prop was moved after the pilot experienced an inoperative starter. (Most probably, there was either an isolated/intermittent problem in the ignition system or the pilot did not move the magneto switch…NTSB CHI90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Anderson, INThe pilot-in-command failed to select the fuel valve to a tank containing usable fuel resulting in fuel starvation.NTSB CHI90LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Anderson, INThe pilot failed to adequately compensate for the wind conditions. The gusty crosswind was a factor.NTSB CHI90LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Auburn, INThe pilot misjudged distance and speed during the approach and landing, which resulted in an overrun of the landing area. Factors related to the accident were: darkness and the ditch.NTSB CHI90LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Angola, INFailure of the pilot to maintain directional control of the aircraft, while landing in gusty/crosswind conditions. The adverse wind was a related factor.NTSB CHI90LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Franklin, INThe pilot's improper planning/decision in choosing to continue flight to the destination airport without refueling. The dark night conditions, and a known intermittent radio problem were contributing factors.NTSB CHI90IA106Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600F · West Lafayette, INAn undetected accumulation of ice on the horizontal stabilizer. Relating factors were the manufacturer's lack of information and aircraft manuals relative to the understanding of, and appropriate procedures to prevent the loss of control.NTSB CHI90LA104Accident · No injuriesLimited investigationFinal reportCessna 150M · Indianapolis, INFailure of pilot-in-command to adequately compensate for wind conditions which resulted in a loss of aircraft control. The unfavorable wind conditions (windshear, crosswind & turbulence) were related factors.NTSB CHI90LA100Accident · No injuriesLimited investigationFinal reportCessna 150B · Shelbyville, INThe private pilot's failure to maintain directional control of the aircraft during the landing. The crosswind was a related factor.NTSB CHI90LA098Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Greenfield, INThe pilots selection of the wrong runway relative to the wind and his failure to go-around in a timely manner.NTSB CHI90LA088Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Gary, INFailure of snow removal personnel to recognize the potential hazard of the snow ridge on the runway and communicate this information to the control tower. Factors related to the accident were: the runway/terrain/light conditions, and failure of airport…NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.NTSB CHI90LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Elkhart, INThe pilot's improper in-flight planning/decision and inadequate fuel consumption calculations, which resulted in a loss of engine power & subsequent off-airport forced landing. The stronger than anticipated wind aloft was a contributing factor.NTSB CHI90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INFailure of the student pilot to maintain directional control during the landing roll. The student's lack of aviation experience was a related factor.NTSB CHI90FA075Accident · 1 fatalField investigationFinal reportBoeing 727 · Indianapolis, INThe tug operator's failure to maintain control of the tug, possibly due to having inadvertently placed or caught his built-up, steel-toe boot under the brake pedal.NTSB CHI90DET03Accident · 1 fatalFinal reportPterodactyl Ascender II+2 · Lake Village, INIn-flight structural failure of the right wing spar.NTSB CHI90DET02Accident · 1 fatalFinal reportAir Command 532 · Munster, INThe pilot's exceeding the design stress limits of the aircraft. Factors in the accident were the pilot's ostentatious display and his lack of total experience in type aircraft.NTSB CHI90LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Sullivan, INThe student pilot's inadequate compensation for the wind gust and lack of total experience.NTSB CHI90LA067Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Lafayette, INThe helicopter student's iproper use of the collective pitch lever during the landing phase of flight. The pilot's lack of total expereince, the relatively high wind, and inadvertent liftoff of the helicopter were factors related to the accident.NTSB CHI90LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, INFailure of the student pilot to maintain directional control and/or properly compensate for the wind conditions. Factors related to the accident were: the unfavorable wind conditions and the ditch.NTSB CHI90LA059Accident · No injuriesLimited investigationFinal reportCessna 150F · Elkhart, INFailure of the pilot to maintain directional control of the aircraft, which resulted in his failure to maintain proper runway alignment. Factors related to the accident were the pilot's lack of experience in winter operations, the icy runway condition, and…NTSB CHI90LA057Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Lizton, INSelection of unsuitable terrain by the pilot and his failure to abort the takeoff. Factors related to the accident were: interpersonal relations of the pilot, terrain condition and fence on or near the airstrip, the pilot's lack of experience in the type of…NTSB CHI90LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INFailure of the student pilot to maintain directional control and his improper use of (normal) brakes. His decision to make a running takeoff, his lack of total experience, and the snowbank were contributing factors.NTSB CHI90DET01Accident · No injuriesFinal reportPiper PA-24-250 · Decatur, INThe pilot's misjudgement of the fuel supply, inaccurate fuel consumption calculations, and his improper in-flight planning/decision, which resulted in fuel exhaustion. The lack of suitable terrain for an emergency landing was a related factor.NTSB CHI90LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's inadequate compensation for wind conditions. Factors related to the accident were: inadequate supervision by the student's flight instructor (CFI), the student's failure to obtain weather information (use a preflight briefing service)…NTSB CHI90LA024Accident · No injuriesLimited investigationFinal reportBeech A36 · Angola, INFailure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness and adverse weather conditions.NTSB CHI90LA020Accident · No injuriesLimited investigationFinal reportBell 47G-2A-1 · Plymouth, INThe student's improper use of the cyclic control and the instructor's (cfi's) inadequate supervision.NTSB CHI89FA196Accident · 3 fatalField investigationFinal reportBeech A36TC · Greencastle, INFailure of the pilot to maintain proper altitude during a visual approach at dusk. Factors related to the accident were: light conditions at dusk, the pilot's visual perception, and the trees.NTSB CHI89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Delphi, INThe pilot-in-command's failure to properly compensate for the high sink rate that developed on final approach to land. Factors related to the accident were: the downdraft and the student pilot's failure to maintain a proper rate of descent on final approach.NTSB CHI89LA187Accident · No injuriesLimited investigationFinal reportCessna 120 · Shelbyville, INThe pilot failed to maintain proper alignment during the landing roll.NTSB CHI89LA184Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Columbus, INThe co-pilot's failure to relinquish control of the aircraft to the pilot-in-command after encountering directional control difficulties during roll-out, and excessive braking by the co-pilot.NTSB CHI89IA179Incident · Minor injuriesIncident investigationFinal reportBoeing 767-231 · Knox, INThe radar controlller's failure to maintain radar separation. Factors contributing to the incident were: misunderstanding of an ATC instruction by the pilot of the incident airplane, and unclear phraseology used in the instructions issued by the radar…NTSB CHI89LA177Accident · No injuriesLimited investigationFinal reportCessna 177B · Auburn, INFailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. Contributing factors were: the pilot's misjudgement of distance, speed, and altitude on final approach and high vegetation (tall grass & brush) beside…NTSB CHI89LA171Accident · No injuriesLimited investigationFinal reportCessna 172H · Lake Village, INWater contamination in the fuel/fuel system and inadequate preflight by the pilot. Soft terrain in the emergency landing area was a contributing factor.NTSB CHI89LA161Accident · No injuriesLimited investigationFinal reportCessna R172K · Vincennes, INThe pilot had excessive airspeed, misjudged the landing distance, and did not go around. Contributing factors were: the pilot misread wind information and selected the wrong runway. Also, the tailwind and ditch were considered to be contributing factors.NTSB CHI89DEX06Accident · No injuriesFinal reportGrumman G-164A · Sullivan, INA failure of the supercharger oil seal which resulted in a partial loss of engine power during takeoff and the uncontrolled touchdown during the forced landing. Factors related to the accident were: partial failure of the supercharger and spark plub fowling.NTSB CHI89LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INThe student's failure to maintain directional control of the aircraft and the cfi's delay in taking remedial action to regain control. Contributing to the accident was the students lack of total experience.NTSB CHI89LA146Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Nappanee, INThe pilot-in-command's improper preflight calculation of weight and balance and the aircraft's inadequate climb capability due to low compression.NTSB CHI89LA138Accident · No injuriesLimited investigationFinal reportCessna 182 · New Castle, INFailure of the pilot to maintian directional during the aborted takeoff, which resulted in an inadvertent ground swerve. The ditch was a contributing factor.NTSB CHI89DEX05Accident · No injuriesFinal reportTexas Helicopter OH-13H/M74A · New Richmond, INThe pilot's misjudgement of the fuel supply which resulted in fuel exhaustion.NTSB CHI89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Logansport, INPoor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…NTSB CHI89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INImproper recovery from a bounced landing and failure to maintain directional control by the pilot. The student pilot's lack of flight experience contributed to the accident.NTSB CHI89FA122Accident · No injuriesField investigationFinal reportPiper PA-60-700P · Griffith, INFailure of the turbocharger exhaust tailpipe assembly retaining clamp.NTSB CHI89LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Indianapolis, INFuel contamination from a deteriorating part in the carburetor. The trees and improper maintenance/servicing of the aircraft were probable contributing factors.