NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 ATL86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Memphis, TNWhile returning from an instrument training flight, the aircraft lost total power and the CFI attempted an emergency landing on a road. During the attempted landing the aircraft collided with a road sign and was substantially damaged. The pilot related that…NTSB ANC86LA091Accident · No injuriesLimited investigationFinal reportCessna 170A · Tyonek, AKThe relatively inexperienced private pilot attempted to land his airplane on a gravel beach as the tide was receding. He failed to maintain directional control and the airplane was substantially damaged in the ensuing ground loop.NTSB SEA86LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pullman, WAAfter takeoff during a 180 degree turn the aircraft developed a rapid rate of sink which the pilot was unable to arrest. While attempting to dump 140 pounds of water, the aircraft struck power lines and then struck the ground inverted. The aircraft was then…NTSB MKC86LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mammoth Spring, ARThe pilot stated that the aircraft had plenty of oil prior to departure and that the flight was proceeding normally when, suddenly, the oil pressure dropped to zero. While subsequently heading for a nearby airport, the engine lost power and seized, forcing an…NTSB MKC86LA134Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Wellman, IAThe PIC stated that during the last 3rd of his procedure turnaround the acft descended to just below the powerlines at the edge of the field he was spraying. The acft struck the powerlines with the main landing gear which nosed the acft over. Full power was…NTSB MKC86LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Wathena, KSThe plt stated that according to the acft manual, he had enough fuel to fly to his destination in the usa. As such, he felt that no refueling was necessary when he landed at his designated airport-of-entry to clear customs. The acft ran out of fuel two miles…NTSB MIA86FLT01Accident · Serious injuriesFinal reportAmateur Built Eenie TWO · Waynesboro, MSThe acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not…NTSB ATL86LA184Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Little River, SCThe plt reported that the glider was violently rolled into a 90 left bank by strong crosswinds at about 250 ft AGL, while it was being towed aloft. The plt's cockpit canopy came open, and the plt attempted to close and secure it. The canopy came open again…NTSB ATL86FEI07Accident · 1 fatalFinal reportBell 47G2 · Lisbon, OHThe aerial application helicopter was being serviced by a chemical truck that was parked adjacent to the acft. The acft engine was at high idle with the main rotor turning at 250 RPM. The ground crewman jumped off the side of the chemical truck into the main…NTSB ANC86LA087Accident · No injuriesLimited investigationFinal reportCessna 305/L-19 · Barrow, AKThe non-certificated flight instructor failed to respond in time to improper control input by the student. The airplane ground looped and went on its nose sustaining substantial damage.NTSB SEA86LA152Accident · No injuriesLimited investigationFinal reportRockwell S2R · Caldwell, IDShortly after departure the pilot could not get any aileron response. A landing was attempted at a nearby airport where a go around became necessary. During the go around control of the aircraft was lost and it descended to ground impact. Investigation…NTSB NYC86LA173Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · New York, NYThe plt performed a go-around due to excessive groundspeed during the first landing attempt. The plt reported that as he applied upward collective to terminate the second landing apch over the helipad, the helicopter descended rapidly. The helicopter…NTSB MIA86LA191Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Ft Lauderdale, FLThe plt stated that just as he rotated the acft for takeoff, the cabin door popped open. The acft then struck the ground hard in a nose down attitude, sheared off the main landing gear and slid to a stop on the runwy. According to the emergency procedures in…NTSB LAX86LA269Accident · No injuriesLimited investigationFinal reportBeech B-19 · Scottsdale, AZThe acft was fast and long during a landing attempt according to the student plt. He elected to make a go-around but in doing so he raised the flaps too rapidly and the acft landed hard after which it bounced into the dirt off to the side of the rwy.NTSB ATL86FA182Accident · Minor injuriesField investigationFinal reportCessna P210N · Lawrenceville, GAThe acft was damaged during a forced lndg on a hiway after the engine quit. The flt was nearing its destination on a VFR x-country when the engine lost power. The acft fuel tank selector was on the rt tank for 2 hrs before and during the emergency. After the…NTSB MKC86LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Siloam Springs, ARThe PIC was practicing touch and go landings, and decided to change rwys for his final landing. The PIC stated he landed long on the 1650 foot turf rwy, but went off the end. The PIC stated he should have added pwr and made a go around. The PIC was late in…NTSB MKC86FCD02Accident · Serious injuriesFinal reportPiper PA18 · Sloan, IAThe acft stalled during a low alt steep turn immediately after takeoff. The acft collided with the ground aprx 300 ft east of the rwy. No malfunctions in equipment were found. The plt stated that he was turning steeply to avoid another acft. Statements of two…NTSB MIA86LA190Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley Park, MSThe plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph.NTSB LAX86MA275Incident · No injuriesMajor investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)While ual flt 1 was cruising at FL 310, aprx 1.8 hr after takeoff, a flt attendant (f/a) rprtd a headache & lightheaded-ness. The flt climbed to FL 350, then another f/a & svrl pax rprtd similar symptoms. At that time, the tropopause was AT40,000'. As the flt…NTSB FTW86LRD15Accident · No injuriesFinal reportGrumman G-164B · Church Point, LAThe acfts left wingtip caught in weeds during takeoff and the acft was pulled left. The plt had turned to avoid a wet spot on the airstrip and contacted the high weeds then swerved into a rice levee.NTSB FTW86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Georgetown, TXThe instructor pilot was demonstrating night landings to his student pilot, when the aircraft veered to the right on touchdown. The instructor thought his student was on the right rudder, but failed to override him by applying left rudder. The next morning…NTSB FTW86LA120Accident · No injuriesLimited investigationFinal reportBeech E18S · Oklahoma City, OKA swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.…NTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.NTSB BFO86FIA01Accident · Minor injuriesFinal reportGrumman AA1B · Brandywine, MDPrior to reaching the lom during an ILS rwy 01L apch, a loss of pwr was experienced. The plt applied carb heat and pwr was momentarily restored. A total pwr loss was then experienced and the plt executed a forced landing in a field during which the acft nosed…NTSB NYC86LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bally, PAThe pilot landed on ruwnay 34 in winds he estimated to be from 270 degrees at 10-15 knots. He stated that at touchdown, the left wing was caught by a gust and raised. The aircraft drifted right. The pilot stated there was sufficent runway to continue the…NTSB NYC86LA156Accident · No injuriesLimited investigationFinal reportBeech B-60 · Toms River, NJAn inflight fire occurred shortly after takeoff. Smoke was observed trailing from the right eng & it was shut down. The plt returned & landed at the arpt. After landing, the fire was extinguished by linemen, a fireman & plts who were standing by. An…NTSB NYC86FA158Accident · 1 fatalField investigationFinal reportBeech V35B · Bradford, PAThe private, instrument rated pilot flying a Beechcraft V35 collided with the ground, in an inverted attitude 1.5 miles from the approach end of the runway while on an ILS approach during IFR conditions. Heavy rainshowers fog and lightning were observed in…NTSB LAX86LA266Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Planada, CAThe plt reported the eng coughed during cruise flt at an alt of 2000 ft AGL. He applied carburetor heat and the eng coughed again and lost power. The plt made a forced landing in a plowed field. The landing gear dug into the terrain and the acft nosed over.…NTSB LAX86LA265Accident · No injuriesLimited investigationFinal reportCessna 150M · Prescott, AZAfter completing a solo instructional flight the 80-HR student plt landed. During rollout the plt inadvertently applied excessive brake & rudder pressure to the left pedal. The plt lost directional control of the acft & it veered off the rwy. The acft…NTSB FTW86LRD20Accident · Serious injuriesFinal reportPiper PA-25-235 · Marksville, LAThe pilot delayed in his pullup from a spray swath run until there was insufficient time and distance to clear the line of trees at the end of the field. Airspeed decreased rapidly during the pullup. Tree impact occurred and the pilot was unable to recover…NTSB FTW86FPA23Accident · 1 fatalFinal reportCessna A188B · Malone, TXThe acft crashed before beginning a spraying operation after making a low pass over the field to alert a workman. According to one witness, a young bicyclist, the acft was turning around and began 'flopping' before it disappeared behind a hill. The field…NTSB DEN86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Provo, UTThe student & instructor (CFI) were practicing touch-&-go lndgs. The CFI rprtd that drg a lndg, when the acft was aprx 6 inches above the rwy, the student suddenly applied full left rudder. The acft yawed sharply to the left & the CFI attempted corrective…NTSB CHI86FET02Accident · 1 fatalFinal reportPiper PA-28-180 · Syracuse, INThe acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent…NTSB ANC86LA086Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bulchitna Lake, AKThe airplane struck a wingtip on the water while step taxiing downwind attempting a left turn.NTSB SEA86LA150Accident · No injuriesLimited investigationFinal reportPiper J3C · Kent, WAA forced landing was made after a total loss of power. Landing was accomplished onto very rough rising terrain. During landing roll the left main gear collapsed. Investigation revealed a broken crankshaft. A top overhaul had been done less than 30 hours prior…NTSB NYC86LA155Accident · No injuriesLimited investigationFinal reportMaule MX7-235 · Ardara, PAThe aircraft made a forced landing in a field after the pilot claimed control malfunction. However there was nothing found during the wreckage examination to substantiate this statement and the cause of this accident is undetermined.NTSB NYC86FNC04Accident · 1 fatalFinal reportRolladen-Schneider LS-4A · Rochester, VTThe pilot was participating in a x-country soaring race. Aprox 15 miles from destination and for unknown reasons, the pilot experienced in flight collision with terrain. There was no evidence of pre-impact malfunction or failure. The pilot was certificated…NTSB MKC86LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Wrightsville, ARThe PIC of the PA22 was practicing departures fm a confined field. The PIC stated that the acft engine had been operating normally, and that he had been operating fm this area for about the previous 1/2 hr. The PIC stated the eng quit on climbout fm the pvt…NTSB MKC86LA131Accident · No injuriesLimited investigationFinal reportCharles S.Hatchette Quickie Q2 · Goodland, KSThe pilot experienced a gradual loss of engine power during cruise and made a forced landing to a field. During the landing roll, the plane hit a hole and nosed over. Examination found that a fuel vent line had melted closed in the vicinity of the exhaust…NTSB MKC86LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSA witness stated that the he observed the acft in a normal approach for landing but that it appeared slow. The witness observed the left wing drop just before the acft was to touchdown to the rwy. Tire scuff marks were seen by the witness on the rwy near…NTSB MIA86LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe plt stated that after a 20 minute flight on a long final approach the engine sputtered & quit. A forced landing was made in a residential area and the acft went through a ditch severing the landing gear. Post crash examination of the carburetor revealed…NTSB LAX86LA270Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Aguanga, CAA Schweizer sgs 1-26C glider collided with a wire fence while the plt was landing on a closed airstrip. The closed strip was marked with x's. several fences were stretched across the airstrip to control livestock. The pilot indicated that during flt, he had…NTSB LAX86LA264Accident · No injuriesLimited investigationFinal reportPiper J-3 · Columbia, CAThe acft nosed over in soft ground during landing roll after veering off rwy 17. The plt indicated that the right brake pedal was jammed by 1/2 inch carpet that had been installed in the acft. The acft veered off the right side of the rwy 17. When the plt…NTSB LAX86LA263Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Truckee, CADuring an air show 3 North American, AT-6, acft took off in what the plt of the 3rd acft described as 'staggered' sequence. A witness described the departures as being 'information' or in 'close proximity' to each other. The first 2 acft gained altitude…NTSB LAX86LA262Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Flagstaff, AZThe pilot stated that, on the landing roll, the right main landing gear collapsed and the right wing was damaged as a result of contact with the runway. The mechanic who examined the aircraft stated that the right landing gear failed to lock, however he was…NTSB LAX86LA261Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAWhile practicing takeoffs and landings on an authorized solo instructional flight the student pilot ballooned and began to porpoise down the runway. On the third nose gear contact with the runway the nose gear collapsed.NTSB DEN86LA173Accident · No injuriesLimited investigationFinal reportBeech K35 · Kim, COThe plt reports that he was cruising at 9,500 ft MSL when he encountered low broken clouds. He decided to descend below the clouds to assure remaining VFR. The plt said he retarded the throttle and descended to 7,000 ft MSL (1,000 ft AGL). When the throttle…NTSB DEN86LA172Accident · No injuriesLimited investigationFinal reportCessna 180K · Ronan, MTAccording to the plt, during the takeoff ground run, his seat slid to the full aft position. The plt stated he lost control & the acft ground looped.NTSB DEN86LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Cope, COThe plt reports that the eng quit during a pull-up at the end of a swath run. A forced landing in a field straight ahead was attempted but the field had been cultivated recently and was soft. After a short ground roll the gear dug in and the acft nosed over.…NTSB DEN86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Last Chance, COThe plt said while on landing roll a cross wind drifted N8844W off right hand side of rwy on a farm strip. Lost control in soft dirt and nosed over. The vehicle was substantially damaged, and the plt was uninjured.