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 ANC86LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Tyonek, AKThe pilot stated that during the initial climb, the aircraft started to settle. The pilot stalled and crashed into a wooded area at the departure end of the runway.NTSB NYC86FA201Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Duxsbury, VTThe plt was on a VFR flight from montpelier, VT to burlington, VT; a distance of about 80 mis. A mountain range is between the two location. Shortly after takeoff the plt radioed burlington approach control and requested an IFR clearance to land at…NTSB MIA86LA230Accident · No injuriesLimited investigationFinal reportMooney M20E · Arcadia, FLDuring cruise, the plt attempted to switch fuel tanks and the fuel selector valve became stuck in the 'off' position. A successful gear-up forced ldg was made in a field. An exam of the valve confirmed that it was stuck due to corrosion and rust, the…NTSB LAX86LA317Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Big Bear, CAThe plt planned a cross country flight from palm springs, CA. To the nearby mountain resort community of Big Bear, CA. Enroute, the plt navigated the acft over an area where the terrain was rising at a rate faster than his acft was climbing. The plt attempted…NTSB LAX86DVA13Accident · No injuriesFinal reportBell 47G-4A · Shafter, CAShortly after departing the loading rig, en route to an agricultural aerial application operation, the forward coupling tail rotor drive shaft failed. The helicopter was about 10 ft above ground level and about 100 ft west of the loading rig. The pilot…NTSB FTW86LA144Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe eng lost power during flt, & subsequently, the plt made a forced landing in a wooded area about 4 mi from the destn arpt. During an investigation, insufficient fuel was found remaining in the tanks & lines to permit continued eng operation. The eng…NTSB DEN86LA228Accident · No injuriesLimited investigationFinal reportE. E. Schilling Q-2 · Billings, MTPlt stated after accident that he had a minor eng problem prior to departure from big timber. He stated that the problem was corrected and the flight commenced to Billings. While on final approach to rwy 04 at Billings the plt experienced a partial loss of…NTSB DEN86LA227Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Clark, COAfter the accident the pltstated that he was departing from a landing zone that was surrounded by tall trees. He also stated that after liftoff, as the helicopter climbed above the trees the wind either shifted direction or stopped and the helicopter began to…NTSB DEN86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Worland, WYOn landing, wind gust lifted left wing and tail section. Acft nosed over.NTSB DEN86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Monument Valley, UTThe plt was on an approach for landing when the acft began to settle. He said that increasing power did not seem to have an effect. Subsequently, the acft landed hard, collapsing the nose gear. The plt believed that he had encountered wind shear during the…NTSB ATL86LA221Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Bowling Green, KYPlt reported that he failed to reposition the fuel selector from auxillary fuel tank to main fuel tank during the landing check. Engine quit due to fuel starvation on short final approach at too low an altitude for corrective action.NTSB SEA86LA196Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stibnite, IDThe pilot executed a steep, reduced power descent into the destination airstrip. He then reported that when he attempted to reduce the rate of descent with a power application, the engine did not respond. There was no evidence of any mechanical malfunction…NTSB NYC86LA203Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Hazleton, PAThe Bell 47G2 made a hard landing in a field. The main rotor contacted the tail rotor and boom. The helicopter received substantial damage and the pilot received minor injuries. On scene examination revealed no evidence of any defect or malfunction of the…NTSB MKC86LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Emporia, KSThe pilot stated that he was cruising at 6,000 feet in IMC with light to moderate rain and turbulence when he heard a bang followed by the left engine losing power. The engine was shut down, the propeller feathered and ATC was notified. ATC cleared, and the…NTSB LAX86FVM07Accident · No injuriesFinal reportCessna 177RG · San Jose, CAThe acft was landed with the gear in the partially extended. Tower personnel attempted to warn the plt of the gear position with use of the radio and light gun signals; however, the landing was continued. Post accident examination of the landing gear system…NTSB LAX86FA315Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Phoenix, AZThe recently certificated private pilot initiated flt with an over loaded acft into high density alt conditions. The acft stalled as it made a climbing left turn to the crosswind leg of the traffic pattern. The stall resulted in an uncontrolled collision with…NTSB DEN86LA222Accident · No injuriesLimited investigationFinal reportBoeing E75 · Tooele, UTThe plt rprtd that he encountered a downdraft while crossing a ridgeline in mountainous terrain, aprx 5 mi NE of Tooele,UT. The elev of the acdnt site was about 9,000 ft & the temp was rprtd by the plt to be 80 deg. This would have resultedin a density alt of…NTSB DEN86LA221Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Albuquerque, NMThe plt rprtd the acft was refueled to capacity at longmont, CO. Full capacity should have provided at least 3.6 hrs of flying time at normal consumption. After refueling, the acft was flown 1.3 hrs to fowler, CO, where it remained parked for a week. The plt…NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…NTSB CHI86LA189Accident · No injuriesLimited investigationFinal reportRobinson R22A · Eden Prairie, MNThe CFI reported that upon liftoff, the aircraft began drift left. When he tried to correct this condition he found that he could not move the cyclic to the right. While drifting to the left, the left rear skid hit the ground, the aircraft tilted back and the…NTSB ANC86LA123Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kuskatan River, AKDuring the takeoff roll on a River gravel bar, the pilot lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB SEA86FA194Accident · 1 fatalField investigationFinal reportCessna 310C · Vancouver, WAPlt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.…NTSB NYC86LA202Accident · Minor injuriesLimited investigationFinal reportLearjet 55 · Rutland, VTThe lear 55 taxied out for takeoff and inadvertently attempted a takeoff on the wrong runway. When he realized his mistake, he aborted the takeoff because he knew the runway length was significently less than his required field length. Insufficient runway…NTSB LAX86FA314Accident · 1 fatalField investigationFinal reportCessna 421C · Callahan, CAAfter dropping company executives off at medford, the pilot was to return to santa rosa empty. Witnesses along the 25 NM valley which ends at the accident site reported that the aircraft buzzed their locations at AGL altitudes variously described as '10 feet'…NTSB FTW86LRG31Accident · No injuriesFinal reportRolladen-Schneider LS-6 · Uvalde, TXPilot of a Rolladen-Schneider LS-6 glider, N25SG, impacted terrain short of runway at Uvalde, TX airport. Pilot held U.S.-foreign private pilot certification based on german certification and was representing the aircraft manufacturer during glider…NTSB CHI86FA200Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Shelby, INThe non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…NTSB ANC86LA122Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot stated that during the climbout the engine began to sputter, lost power and crashed into a wooded area. Examination of the aircraft revealed heavy carburetor icing.NTSB NYC86LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grove City, PAThe instructor plt (CFI) rprtd that shortly after takeoff, after climbing out of gnd effect, the acft seemed to lvl off & stop climbing. He took control fm the student & proceeded to check the instruments, but no specific abnormality was determined. He…NTSB NYC86LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Farmingdale, NYThe Piper PA-38-112 had just taken off and was on crosswind when it experienced a power loss. The pilot landed in a cemetary and both the pilot and passenger received minor injuries. The aircraft received substantial damage. Examination of the acft revealed…NTSB MKC86LA168Accident · No injuriesLimited investigationFinal reportCessna 188B · Edison, NEThe PIC had made 5 or 6 passes to the corn field he was spraying. During this pass, the PIC stated he struck a pwr line that ran diagonally across the fld. The PIC stated he did not observe this particular strand during the other passes on the fld. Pwr lines…NTSB MIA86LA229Accident · Serious injuriesLimited investigationFinal reportBoeing 727-224 · Gulf Of MexicoThe commercial air carrier domestic flight was operating in an aera of known thunderstorm activity and encountered a jolt of turbulence. The passenger who was injured disregarded the illuminated seat belt sign and two announcements to remain seated by the…NTSB MIA86LA228Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Indiantown, FLThe aerial application helicopter crashed just after lift-off after sustaining a power failure, the plt stated that he thought the reason for the failure could have been fuel starvation since he had observed some foreign matter in the fuel when he drained the…NTSB LAX86LA313Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Apple Valley, CAA Cessna 152 overran rwy 36 and nosed over on the overrun area. The student plt indicated that he attempted the takeoff from mid-field on rwy 36 without taking into account the density alt. He also stated that he attempted to abort the takeoff after reaching…NTSB FTW86LA143Accident · No injuriesLimited investigationFinal reportForney F-1A · Wagoner, OKAn 80 yr old stu plt with an expired medical certificate was using auto fuel in the acft without an STC. FAA records forthe acft showed a sale was pending for svrl yrs. During flt, the plt decided to make a precautionary landing when the engine began 'running…NTSB DEN86LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Center, COThe plt reported that he was landing on a 50 ft wide dirt strip and allowed the acft to drift to the left during the landing roll. The left wing collided with wheat growing along the left side of the strip and the acft swerved further to the left. During the…NTSB DEN86LA218Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMAccording to the instructor (CFI), the student was making a practice landing when a sudden windshift occurred. He rprtd that when they were on the downwind for their 5th landing, the wind was from the wsw, but just before the landing, it changed to a…NTSB DEN86FA216Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lander, WYThe flt departed Lander, Wyoming, arpt in high density altitude conditions and in an over gross weight condition. The acft was observed flying low over rising terrain until it impacted the ground. The acft was destroyed in a post accident fire and two pax was…NTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…NTSB ATL86LA216Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Ridgeland, SCThe pilot was performing a test flight to test a new spray pump which was recently installed on the aircraft. Following a low pass over the runway the pilot heard a grinding noise from the left side of the aircraft. Shortly thereafter the aircraft lost total…NTSB ATL86FLQ06Accident · 1 fatalFinal reportBernard Sonerai II · Trenton, KYWitnesses reported seeing the acft spin to ground impact with a section of the right wing hanging. Post accident exam revealed the outboard half (aprx 4 ft) of the right wing was bent aprx 120 degrees to the inside half of the right wing. Monnett experimental…NTSB ANC86LA120Accident · No injuriesLimited investigationFinal reportNavion D-16 · Kotzebue, AKThe left fuel valve was in the off position at the time of the takeoff. The pilot attempted to lift-off below the recommended VMC speed. The pilot lost control of the aircraft causing the aircraft to exit the left side of the runway into a lake.NTSB SEA86LA192Accident · Minor injuriesLimited investigationFinal reportCessna 185FII · Reno, NVPlt attempted takeoff with acft 540 pounds over max cert wt and 8500 ft density altitude conditions. Acft became airborne but positive climb and airspeed increase not possible. Plt turned to avoid obstructions, putting acft into semi-controlled collision with…NTSB SEA86LA191Accident · No injuriesLimited investigationFinal reportCessna T210 · Las Vegas, NVDuring landing roll the aircraft departed the runway to the right despite the pilots attempt to correct with left rudder. The acft struck a ditch and the nose gear separated from the acft. During acft repair the mechanic found the right master cylinder was…NTSB NYC86LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Reamstown, PAThe plt made a precautionary landing in a corn field following a decrease in engine RPM during cruise flt. Examination of the engine revealed a coating of carbon and lead on the valves of the #2, #3 and #4 cylinders which caused the valves to become stuck in…NTSB NYC86LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, PAThe student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then…NTSB NYC86FHM04Accident · 1 fatalFinal reportWard Skybolt · Cranford, NJWitnesses heard the aircraft engine pop, sputter and then go silent. The aircraft was observed to continually lose altitude, then visual contact was lost due to the tree line. Post-accident wreckage examination disclosed no evidence of fuel on board the…NTSB NYC86FA199Accident · 4 fatalField investigationFinal reportRockwell 114 · Bedford, PAThe acft nearing the close of a x-country flight had requested a decent to start an approach to land at its final destination. ATC had granted the request, but stated to the pilot that he most remain VFR, the pilot acknowledged the clearance. Acft was located…NTSB NYC86FA196Accident · 1 fatalField investigationFinal reportGrumman TBM-3E · Brooklyn, CTThe acft was being flown to the owner's residence when the accident occurred. Shortly after takeoff black and white smoke was observed emitting from the eng cowling and the eng was heard sputtering. According to witnesses, the acft leveled off at an alt of…NTSB FTW86FRG30Accident · Serious injuriesFinal reportSchleicher ASW-20 · Uvalde, TXAcft was competing in the natl soaring championships and had just crossed the finish line at 50' AGL and 85 kns a/s when it entered a maneuver to reverse direction and climb to pattern alt for landing. During the turn the acft stalled and struck a power line…NTSB FTW86FA142Accident · Serious injuriesField investigationFinal reportBell 206B · Watson, OKPilot of Bell 206B conducting forestry operations experienced problem with fire dispensing apparatus being slung beneath aircraft while returning to helipad for fuel. Pilot landed, released external load, and got out of aircraft to release electrical…