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 CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.NTSB CHI98LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Salem, INthe pilot's misjudgment of distance and altitude, while on final approach to land at night. Factors relating to the accident included: an undetermined electrical malfunction, inoperative flaps, darkness, the pilot not using the landing light, and the…NTSB CHI98LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, INthe pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.NTSB CHI98FA031Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lynn, INthe pilot's failure to maintain control of the airplane which resulted in the inflight separation of the wings, vertical stabilizer/rudder, and the stabilator. Factors associated with the accident the pilot continued the flight into known adverse weather and…NTSB CHI98LA014Accident · 2 fatalLimited investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain adequate airspeed during a go-around attempt which resulted in an inadvertent stall.NTSB CHI98LA006Accident · Serious injuriesLimited investigationFinal reportBeech V35A · West Lafayette, INthe pilot's improper decision not to land before his airplane ran out of fuel, fuel exhaustion and the inadvertent stall.NTSB CHI98LA008Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Cloverdale, INthe Boeing pilot failed to identify the Waco airplane on the runway before initiating a takeoff. Factors related to the accident were: the restricted forward visibility of both pilots due to the tailwheel configurations of both airplanes.NTSB CHI97LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INthe pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.NTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.NTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.NTSB CHI97FA272Accident · 1 fatalField investigationFinal reportKellums Sonerai 1 · Scottsburg, INa loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.NTSB CHI97LA271Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Zionsville, INfailure of the pilot to maintain adequate airspeed, which resulted in a stall and subsequent spin. A factor associated with the accident was the pilot's lack of experience in this make and model of glider.NTSB CHI97LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft L2A · Shelbyville, INthe inadequate preflight by the pilot and the loose fuel line fitting.NTSB CHI97LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Auburn, INan improper flare by either this pilot or the pilot of a previous flight, which resulted in a hard landing and overload damage to the right main landing gear. The pilot's continued operation with a known deficiency may have been a related factor.NTSB CHI97FA208Accident · 1 fatalField investigationFinal reportCessna 150F · Gary, INthe pilot's not obtaining/maintaining airspeed which resulted in a stall.NTSB CHI97IA205Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Indianapolis, INthe improper installation of the incorrect spherical bearing by the company's maintenance personnel. A factor was the improper plating of the trunnion with chromium by the landing gear overhaul facility.NTSB CHI97LA202Accident · Minor injuriesLimited investigationFinal reportNiquette Pietenpol GN-1 · Lake Village, INthe pilot's inability to maintain sufficient airspeed and climb.NTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.NTSB CHI97LA168Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Franklin, INthe instructor pilot stalled the aircraft as a result of inadequate preflight planning. Factors included the transmission wire, the rising terrain, and the trees at the departure end of the runway.NTSB CHI97LA163Accident · 1 fatalLimited investigationFinal reportSiefert 5151RG · Shelbyville, INthe cause of the accident is undetermined.NTSB CHI97LA162Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Valparaiso, INa delay by the pilot of the other aircraft in turning on his mode C transponder.NTSB CHI97LA154Accident · No injuriesLimited investigationFinal reportCessna 340A · Fort Wayne, INthe pilot did not comply with the decision height and his attention was diverted from his cockpit scan. The factors involved were the weather conditions were at landing minimums and a flight to his destination alternate was not performed.NTSB CHI97LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, INimproper planning/decision by the pilot. Factors related to the accident were: the pilot's selection of the wrong runway for takeoff, and the resultant tailwind.NTSB CHI97LA140Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-365-N2 · Indianapolis, INinadequate visual clearance by the passenger resulting in his being struck with the rotor blade. A factor relating to this accident was the gusting winds.NTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.NTSB CHI97LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Angola, INthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the tailwind, the pilot's selection of runway, and the misjudged landing flare.NTSB CHI97LA129Accident · No injuriesLimited investigationFinal reportBeech B33-35 · Mishawaka, INImproper flare. A factor associated with the accident was the gusty, crosswind condition.NTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.NTSB CHI97GA103Accident · Serious injuriesFinal reportBell OH-58A · Seymour, INimproper action(s) by one or more of the emergency response team members, during a hovering/loading sequence, which resulted in the helicopter's lateral center-of-gravity (CG) limitations to be exceeded. A factor associated with the accident was: the pilot's…NTSB CHI97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INa fatigue failure of the fight main landing gear strut/spar attachment screws.NTSB CHI97FA093Accident · 1 fatalField investigationFinal reportStinson 108 · Greenfield, INa loss of engine power due to restricted movement in the exhaust valve and rotted/weathered ignition harness, and the pilot's failure to maintain airspeed which resulted in an inadvertant stall.NTSB CHI97LA089Accident · No injuriesLimited investigationFinal reportCessna 150 · Petersburg, INThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Low altitude flight is a contributing factor.NTSB CHI97LA086Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Greencastle, INThe student pilot's improper recovery from a bounced landing.NTSB CHI97LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INthe pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.NTSB CHI97LA057Accident · No injuriesLimited investigationFinal reportBeech 300 · Bloomington, INthe pilot's excessive distance/speed during the landing which led to his failure to attain a proper touchdown point on the runway. The factors involved were: the pilot's inadequate in-flight planning/decision, his failure proceed to the destination airport,…NTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.NTSB CHI97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INthe pilot's misjudgment of the landing flare and inadequate airspeed, which resulted in a hard landing.NTSB CHI97IA041Incident · No injuriesIncident investigationFinal reportBoeing 757-225 · Terre Haute, INinadequate installation of electrical wiring for an audio entertainment system associated with Supplemental Type Certificate (STC) SA5537NM, and a subsequent short in the wiring. Factors relating to the accident were: inadequate design (installation…NTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.NTSB CHI96FA334Accident · 2 fatalField investigationFinal reportThocker RV-4 · Muncie, INwas the in-flight disconnection of the horizontal and vertical stabilizer forward attachments.NTSB CHI96FA322Accident · 1 fatalField investigationFinal reportMankovich Sonerai · Jeffersonville, INinadequate maintenance and inspection of the airplane by the pilot/owner and other airframe and powerplant mechanics, which failed to assure adequate sealing of the engine firewall, and led to the pilot's incapacitation due to carbon monoxide.NTSB CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.NTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.NTSB CHI96LA289Accident · Minor injuriesLimited investigationFinal reportMrotek Minicab GY20 · Albion, INthe pilot's misjudgment of distance and altitude during the approach to land, and his failure to attain the proper touchdown point. Factors relating to the accident were: the uneven and uphill terrain conditions at the approach end of the airstrip.NTSB CHI96FA284Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Muncie, INthe inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.NTSB CHI96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rensselaer, INthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA272Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Poseyville, INthe pilot's improper flare during the landing. A factor relating to the accident was: the pilot's lack of familiarity with the make and model of airplane.NTSB CHI96LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lafeyette, INthe pilot's failure to maintain directional control during landing. Factors related to the accident were the pilot's inadequate compensation for the wind conditions and the crosswind.NTSB CHI96LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI96LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Windfall, INfailure of the pilot to maintain adequate airspeed, while maneuvering to avoid an obstruction (transmission line), which resulted in a stall and collision with the terrain. His lack of familiarity with the geographic area was a related factor.