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 CHI85LA093Accident · Minor injuriesLimited investigationFinal reportSaabye Cassutt Sport Racer · Lake Village, INThe acft nosed over after colliding with a snow bank during landing. A snow covered driveway, which parallels the rwy was used for landing. The driveway measures 2600'X 25' and the landing was made to the north. The acft was blown to the right during the…NTSB CHI85LA092Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Lafayette, INPlt diverted due to icing/unfavorable wx at dest. Plt stated the windshield iced over during the apch at purdue university arpt (the alternate) and he flared high resulting in a hard landing.NTSB CHI85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Central, INThe acft contacted a tree and nosed over during a forced landing following fuel exhaustion. The student plt was observed by several witnesses to to remove the fuel caps during preflight and check the fuel quantity. The plt stated the fuel level was up to the…NTSB CHI85FA067Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Albion, INCarburetor icing conditions existed on the day of the accident. The plt stated that after takeoff, he stayed in the traffic pattern to ensure he would not experience carburetor icing problems. He then departed the traffic pattern & overflew a wooded area…NTSB CHI85LA068Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Lafayette, INWhile turning the prop by hand to lubricate the engine it unintentionally started and ran at aprx 1700 RPM. The acft was not chocked or tied down and the parking brake was not set. The acft traveled across the ramp and collided with an empty t-hangar. After…NTSB CHI85LA055Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Lagrange, INPlt was landing in gusty, crosswind conditions. On late final, a gust of wind caused the left wing to drop and strike the top of an 80 ft tree. Acft touched down nose low, collapsing the landing gear.NTSB CHI85FA053Accident · 5 fatalField investigationFinal reportCessna 310N · Valparaiso, INThe aircraft stalled and impacted the terrain during a forced landing. Witnesses observed the acft flying at 'tree top level' with the wings 'wagging'. One witness reported hearing no engine sounds. The acft impacted the terrain (open field) in a near…NTSB CHI85LA051Accident · No injuriesLimited investigationFinal reportCessna 182H · Terre Haute, INPlt stated he was unable to activate the runway lights by radio so visual cues of arpt bldgs were used to line up with runway. Acft lndg/taxi light was inoperative. Plt did not realize he had undershot the approach turn and was, IN fact, lined up to the left…NTSB CHI85LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Bloomington, INPlt stated that while in cruise flt, the acft nose pitched down abruptly. Plt disengaged the autopilot and noted vacuum system was inoperative. Flt continued on manual control without further incident until late final approach at destination. When flaps were…NTSB CHI85LA040Accident · No injuriesLimited investigationFinal reportCessna 150M · Wyatt, INWhile practicing ground reference maneuvers at 800 ft AGL the engine power dropped from 2,500 to 1,500 RPM. During the forced landing rollout the nose gear collapsed when it contacted a dirt bank. Investigation revealed that the throttle control rod end bolt…NTSB CHI85FA034Accident · No injuriesField investigationFinal reportHughes 500D/369D · Mc Cordsville, INThe helicopter landed hard during an autorotative descent while on a test flt & chopped off the tail boom. The plt stated he lost power at 150 ft AGL & entered autorotation. Investigation revealed that the fuel quantity float had become intangled with the…NTSB CHI85LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Lake Village, INThe plt reported that he was on final apch to land on a wet, sod rwy when he noticed a flock of geese over the apch end. He added power to fly over the geese then proceeded to touchdown further down the rwy than what he had planned. Due to his speed & the wet…NTSB CHI85LA002Accident · Minor injuriesLimited investigationFinal reportBrewer Corsair · Ft. Wayne, INAfter touchdown and an initial rollout of aprx 480 ft, the acft began veering to the right. The acft departed the right side of the rwy and contacted a plowed trench, 29 ft from the rwy, where it nosed over.NTSB CHI84IA404Incident · No injuriesIncident investigationFinal reportBeech A36TC · Lafayette, INThe plt reported that when he leveled off at 3000 ft MSL, the aux fuel boost switch was still on, so he switched it 'off.' When the switch was turned off, the eng began to run with a bit of vibration, so he returned the switch to 'on' & left it in that…NTSB CHI84LA403Accident · No injuriesLimited investigationFinal reportCessna 150H · Indianapolis, INThe plt stated that during the takeoff roll, the window popped open. At about that time, the acft began traveling to the left side of the rwy, but the plt elected to continue the takeoff. While in a nose high attitude to takeoff, the aft fuselage contacted a…NTSB CHI84LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Richmond, INThe acft collided with power lines and crops after a loss of power while on a training flt. The CFI and student plt were practicing in cruise, single eng simulation by leaning the rt eng and setting a 'zero' thrust condition. The student was then to set the…NTSB CHI84LA400Accident · Minor injuriesLimited investigationFinal reportSteen Skybolt · Valparaiso, INThe acft dragged a wing and flipped over after the plt made a hard landing and lost control. The plt attempted a go-around in an uncontrolled situation. The acft was destroyed.NTSB CHI84LA394Accident · No injuriesLimited investigationFinal reportBeech A-24R · Evansville, INShortly after take off, plt experienced complete electrical failure, later traced to a broken field wire on the acft alternator terminal. Plt returned for landing & placed gear handle in down position. Gear failed to extend (electrically operated). Plt made…NTSB CHI84LA393Accident · No injuriesLimited investigationFinal reportPickel Smith Miniplane · Covington, INThe pilot stated after the accident that during the landing roll the left wheel separated from the aircraft. The aircraft slid aprx 40 feet and nosed over. The plt stated that he had removed the main landing gear aprx 10 hrs prior to the accident to repack…NTSB CHI84LA390Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Westfield, INThe acft collided with a powerline during landing. The plt said he 'found himself too low and gunned the engine to stay over the corn field but did not see the wires. Had never known they were there.'NTSB CHI84LA379Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Point, INFollowing a crosswind landing on a narrow runway bordered by a corn crop on both sides, the acft rolled into an area where the x-wind was blocked by the corn. The plt failed to maintain directional control, caught a wing tip in the high corn and verred off…NTSB CHI84FA369Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Muncie, INWitnesses reported that when the acft was taking off, the eng sounded 'rough & was backfiring.' They observed the acft cross the departure end of the rwy at a lower alt & slower speed than what they considered as normal. They saw the acft's wings rock, then…NTSB CHI84LA367Accident · No injuriesLimited investigationFinal reportCessna 182G · Crawfordsville, INPlt stated that while en route the generator circuit breaker popped and attempts to reset it proved futile. A loss of pwr occurred later in the flt and a forced landig was made in a field during which the acft was damaged. No fuel was found in the acft after…NTSB CHI84LA362Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Michigan City, INThe engine quit as a result of fuel exhaustion. Twenty ounces of fuel remained in the tank. The pilot stated he was flying on the aircraft's fuel gage which indicated three eights of a tank remained. An autorotation was initiated, but the landing skid caught…NTSB CHI84LA375Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INPlt stated the acft was 1/2 way down the rwy and had not touched down so back pressure on the yoke was released. The acft then bounced three times on the rwy. On the third bounce the nose gear collapsed and the acft nosed over. Plt stated airspeed was…NTSB CHI84LU010Accident · Serious injuriesFinal reportPioneer Flightstar · Westfield, INThe ultralight dove into the ground from about 100 ft AGL while in the traffic pattern. The plt at first interview said the engine quit. Later, the plt's father said he was told by the plt that the vehicle just stalled. Witnesses heard the engine running and…NTSB CHI84FA342Accident · 1 fatalField investigationFinal reportPiper PA28-140E · Montmorenci, INThe acft crashed while on a x-country personal transportation flt. Prior to departure, the plt telephoned a relative at the destination, 118 miles away, & had been informed that the flt conditions (wx) at brazil were good. The plt did not obtain a wx briefing…NTSB CHI84LA331Accident · No injuriesLimited investigationFinal reportAeronca 65-LA · Monon, INThe plt stated that after he had landed, he shut off the fuel valve & was going to put the acft in the hangar then decided to fly a little more. He took off, but forgot to turn on the fuel switch. After climbing aprx 150 ft, the eng lost power. Subsequently,…NTSB CHI84LA326Accident · No injuriesLimited investigationFinal reportBede Bede 4 · Evansvile, INThe acft experienced a total power loss & the plt made a forced landing on a hwy median. The landing gear collapsed & the acft slid to a stop. Post accident inspection revealed that a large portion of the foam air filter had broken off & became lodged in the…NTSB CHI84LA296Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Madison, INThe pilot stated after the accident that he performed a preflight inspection of the acft and did an engine run-up before takeoff. During climbout, at an altitude of 150 feet the plt experienced an engine failure. An emergency landing was made in trees. The…NTSB CHI84LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · North Liberty, INThe plt had changed departure runway due to shifting winds of 10-15 KTS, electing rwy 18 when wind seemed favorable. On initial climb, aircraft performance was insufficient to clear trees at end of runway. Acft came to rest in trees. Acft manual specifies…NTSB CHI84FA292Accident · Serious injuriesField investigationFinal reportCessna 182A · Henryville, INThe aircraft's annual inspection was thirteen years overdue and the pilot had not logged any flight time inn almost one year. Twenty eight airworthiness directives had not been complied with. The engine quit shortly after take off, when the magneto coils…NTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…NTSB CHI84FA278Accident · 4 fatalField investigationFinal reportCessna 414A · Winchester, INThe acft entered an embedded thunderstorm after being advised by artc of several large areas of heavy precip in his area& along the vicinity of his flt path. The plts response was that his acft radar showed no build-ups or returns. ATC allowed deviations at…NTSB CHI84IA294Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Muncie, INAccording to the plt, he was in a 20 deg left bank with an airspeed of about 40 KTS when the helicopter began rotation to the right. He entered an autorotation & landed with a forward speed of about 5 KTS. An exam revealed that the tail rotor drive shaft had…NTSB CHI84LA275Accident · No injuriesLimited investigationFinal reportNorth American P-51 Mustang X · Indianapolis, INA bounced landing occured during which the left main gear collapsed followed by a ground loop.NTSB CHI84LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Wayne, INDuring a landing, the acft bounced & landed on the nose wheel, collapsing the nose gear.NTSB CHI84LA256Accident · No injuriesLimited investigationFinal reportCessna 150G · Spindle, INThe pilot stated that he ran out of useable fuel while in cruise flt. The pilot executed an emergency landing in a newly mowed hayfield and the acft sustained substantial damage. The pilot stated that he should have 'gotten fuel at lafayette.'NTSB CHI84LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INPlt stated airspeed appeared too fast on final so a go-around was initiated. Power was advanced and plt raised the flaps which were full down. Plt stated, when flaps came up the acft started sinking and it settled into trees off the end of rwy. Plt stated…NTSB CHI84LA228Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INThe student plt was practicing touch-&-go landings with an Aeronca in the traffic pattern ahead of him. He stated that when he touched down, the Aeronca was still on the rwy, so he decided to abort the landing to avoid the other acft. The plt stated he had…NTSB CHI84LA188Accident · No injuriesLimited investigationFinal reportAyres S2R · Vincennes, INThe plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…NTSB CHI84LA186Accident · No injuriesLimited investigationFinal reportHughes 500D · Rensselaer, INHard forced landing made after loss of pwr at cruise alt of 500 ft AGL. Main rotor blades contacted tail boom. Examination disclosed fuel pump gears showed signs of corrosion. Gear teeth and end faces were severly etched and pitted. Bronze particles were…NTSB CHI84LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Porte, INThe pilot stated that he initiated the landing flare 'too late,' and the acft landed hard. There was subst damage to theto the landing gear and left wing.NTSB CHI84LA321Accident · No injuriesLimited investigationFinal reportCessna 177 · Hobart, INThe plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the…NTSB CHI84LA171Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Marion, INThe student plt reported that during a landing, he reduced the power too soon & flared the acft too high, then the acft bounced about 8 to 10 ft in the air. The hard landing resulted in spar damage to the right wing.NTSB CHI84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, INThe plt was attempting a takeoff on a country road. He stated that during the takeoff he noticed the acft was not set-up for a short field takeoff so he decided to abort. During the takeoff abort the acft struck a tree alongside the road and the the acft…NTSB CHI84FA153Accident · 1 fatalField investigationFinal reportMooney M20C · Gary, INVFR plt received 2 wx briefings, filed an IFR flt plan and departed in night IFR conditions. Aprx 1 min after contacting chicago ARTCC plt reported he was having 'problems.' Aprx 1 min later plt reported, 'nine nine victor, I'm breaking up.' Acft wreckage was…NTSB CHI84LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lafayette, INThe pilot was practicing accuracy landings when he noticed that the acft had blown away from the rwy. When he attempted to increase the throttle setting there was no response. In an attempt to land on a highway on-ramp the acft struck an electric wire, a…NTSB CHI84LA129Accident · No injuriesLimited investigationFinal reportCessna 150M · Hagerstown, INDuring the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft.NTSB CHI84LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Crawfordsville, INAfter returning to the arpt, the student began practicing touch-&-go landings. While climbing thru about 150 ft AGL, after the 3rd landing, the eng sputtered twice, then quit running. The acft was landed straight ahead on snow covered terrain. When the…