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 MIA86LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLWhile on approach to runway the pilots vision was restricted by the glare from the rising sun. The pilot failed to see the operating approach light system which is located in the closed first 2000 feet of runway, and collided with the approach light system.…NTSB MIA86FA252Accident · 2 fatalField investigationFinal reportCessna 152II · Clewiston, FLPurpose of the flt was to spot stray cattle. The acft made a low pass after chasing a cow. According to witnesses, the acft stalled and descended to ground impact during the pull-up maneuver following the low pass.NTSB CHI86FA230Accident · 2 fatalField investigationFinal reportCessna 172K · East Tawas, MIAircraft collided with trees while in low level flight following a predawn departure. An airport 10 miles to the north was reporting very low ceilings with visibilities lower than 1/2 mile in fog and drizzle. The proximity to the departure airport and the…NTSB ATL86FA264Accident · 3 fatalField investigationFinal reportBell 222UT · Galax, VAThe helicopter was dispatched on an emerg med svc (ems/med-evac) flt to transport a patient with subcranial bleeding back to a hospital in winston-salem. Bfr takeoff, the plt received a wx briefing. At that time, widespread IMC prevailedthru-out the area &…NTSB NYC86LA239Accident · No injuriesLimited investigationFinal reportHiller UH12C · E.Conway, NHPilot lost control of the helicopter while at hover then decided to land. However the pilot set the aircraft down hard. The main rotor blade severed the tail.NTSB CHI86FEC07Accident · No injuriesFinal reportPiper PA-36-285 · Imlay City, MIThe pilot stated that takeoff acceleration did not seem normal. He rotated approx 5 mph early and could not climb out. He delayed emergency dumping of the load of insecticide until clearing a drainage ditch. He stated that if he would have dumped at the end…NTSB NYC86LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-140C · Indiana, PAThe acft was substantially damaged during a forced landing following a loss of eng power. Examination of the acft showed the fuel selector was on the the left tank which contained no useable fuel. There was useable fuel remaining in the right tank. The plt…NTSB DEN86LA257Accident · No injuriesLimited investigationFinal reportBeech V35 · Albuquerque, NMThe plt landed hard at the abq municipal arpt. The plt said he had runaway trim causing loss of control. The pax felt the plt lost control due to temporary physical incapacitation. Exam of the flt control system revealed no evidence of a flt control system…NTSB DEN86FTE03Accident · 1 fatalFinal reportHomebuilt Bushby Mustang · Casper, WYThe Homebuilt acft crashed during low alt maneuvers from about 150 ft AGL. A witness who helped build the acft was taking pictures and recording data of the flt at the time of the accident. This witness stated that the plt attempted an aileron roll. The first…NTSB DEN86FA256Accident · Serious injuriesField investigationFinal reportCessna 185C · Broomfield, COPlt stated that he made an 'extra smooth landing' on rwy 11L and during the landing roll the right main landing gear collapsed. Examination of landing gear mounting bolt revealed evidence of an overload failure. The engineer that examined the bolt, nut, and…NTSB CHI86LA226Accident · No injuriesLimited investigationFinal reportCessna 150M · Terre Haute, INThe acft was equipped with an O-320-E2D eng, but the plt calculated his fuel consumption based on the original eng, which was an O-200-A. The O-200-A eng used aprx 8 gal/hr, whereas, the O-320-E2D used about 10 gal/hr. Before reaching the destination on the…NTSB CHI86FEV05Accident · No injuriesFinal reportNord Stampe SV4C · Lacon, ILThe plt lost control of the acft during the landing roll, & subsequently, one of the main landing gear collapsed. He stated that he applied the left 'drag brake' (a braking device activated during the last portion of rudder travel) & overcorrected to the…NTSB ATL86LA263Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Louisville, KYFollowing a normal touchdown and landing, the pilot lost directional control and the aircraft veered off the left side of runway. The pilot stated that he was unable to correct the directional problem after the aircraft departed the runwaysurface. Examination…NTSB ANC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork Rive, AKThe pilot lost control of the aircraft and nosed over during landing on a gravel bar. The pilot stated that the airplane nosed over because he stood on the brakes hard during the landing roll to prevent traveling into the river. The plt could not be contacted…NTSB ANC86LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wood River, AKThe pilot stated that after lift off the pilot lost control of the aircraft due to the left crosswind.NTSB ANC86LA161Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tutna Lake, AKThe pilot stated that just after lift off, a left crosswind forced the left wing up, causing the right float to strike the water.NTSB SEA86FA248Accident · 2 fatalField investigationFinal reportCessna 172 · Overton, NVThe UNICOM operator at boulder city made radio contact with '81J' at about 2300 PDT, after hearing an acft maneuvering in the area. The plt stated he did not plan to lnd at boulder city, but said he intended to fly 'up the vegas wash' area. At aprx 2300 to…NTSB NYC86FNC09Accident · Minor injuriesFinal reportCessna 205 · Twin Mountain, NHDuring a 'bomb drop' contest at an organized 'fly-in', the pilot was maneuvering at low airspeed so his passenger could drop a water-filled balloon on a target which had been placed on runway 27. The acft suddenly banked to the right and pitched down striking…NTSB MKC86LA198Accident · No injuriesLimited investigationFinal reportCessna 150G · Weeping Water, NEThe pilot stated that the grass runway threshold dropped off at the lip giving an impression of being too high on final approach. The aircraft struck the incline three feet short of the runway lip, buckling the nose gear. The aircraft slid to a stop off to…NTSB MKC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · Arkansas City, KSThe plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing…NTSB MKC86LA191Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Creston, IAThe pilot of the hot air balloon made a landing that was hard enough to break her right ankle. The pilot stated the accident possibly could have been avoided if she had been wearing hightop shoes with laces.NTSB MIA86IA250Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Atlantic Ocean (Atlantic Ocean)The helicopter ditched in the Ocean after sustaining a flameout. After the helicopter was towed ashore on its floats the fuel system was found to contain at least 4 gals of fuel. Info contained in helicopter manual revealed all fuel was usable except about 1…NTSB CHI86FEP09Accident · 1 fatalFinal reportPiper PA-32R-300 · Wisconsin Rapid, WIATC had cleared the aircraft for an approach to an airport with several nonprecision instrument approaches and to maintain an altitude until established on a segment of an approach to that airport. Shortly after that time witnesses located 4.5 miles northwest…NTSB ATL86LA262Accident · No injuriesLimited investigationFinal reportAlexander AS-K13 · Tullahoma, TNDuring an automobile tow/launch, the auto experienced a loss of power before the glider reached a safe release altitude. The pilot had steered the glider off of the paved rwy and was unable to return to the rwy. The glider pilot was forced to land in high…NTSB ATL86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Montgomery, ALDuring initial climb phase of an experimental flt from mgm, AL, the plt rpted that the left engine had failed and an attempt was made to feather the prop. The plt radioed dannelly tower that the acft was returning to the arpt. Then the plt rpted that the…NTSB ATL86FA259Accident · 2 fatalField investigationFinal reportCessna 150M · Screven, GAThe plt and his best man for his wedding scheduled for later in the day dep LCL apt early in the am. The acft was observed maneuvering at a low alt over the plts parents home. Witnesses described the maneuvers to be like a crop duster making pull ups and…NTSB ANC86LA160Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-3 · American River, AKAfter landing on a 1200 ft gravel bar, the plt paced off the available area, estimated the load to pick up, then loaded the acft. Due to the x-wind, he used less than takeoff flaps. He began taking off, but after lift-off, the acft 'seemed to hit a…NTSB SEA86LA249Accident · No injuriesLimited investigationFinal reportCessna P-210 · Pasco, WAWhile in cruise at 14,000 feet MSL, a catastrophic engine failure with a flash fire at the turbocharger occurred. A turn to reverse direction for a forced landing was initiated while making a rapid descent. An undershoot to the runway occurred with the…NTSB NYC86FA237Accident · 2 fatalField investigationFinal reportCessna 337D · Lapeer, NYThe acft collided with the terrain during the plts attempt to complete a night x-country in IMC wx conditions. The flt had progressed aprx 4 hrs & 34 min from SC to NY prior to the crash. The plt was not currently rated to fly IFR. The plt reported by radio…NTSB LAX86FUJ06Accident · No injuriesFinal reportForbes-Wolfram Special DSA-1M · St. Johns, AZThe plt reported that persons over 5 ft 9 in tall experience limited right aileron control authority due to the small cockpit of the homebuilt experimental acft, which is used exclusively for air racing. The plt said the right knee of tall persons limits the…NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB FTW86LA169Accident · Serious injuriesLimited investigationFinal reportBell 206B · Eugene IslandCommercial helicopter pilot engaged in off-shore flight operations failed to remove aircraft tie-down lines prior to take off from the oil rig. Pilot lost control of aircraft in a hover causing the aircraft to collide with a metal safety net and,…NTSB DEN86LA255Accident · No injuriesLimited investigationFinal reportBeech B58 · Fargo, NDThe pilot stated that during the landing roll he inadertently retracted the landing gear along with the flaps.NTSB SEA86LA247Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tillamook, ORA precautionary landing was made on a field due to low fuel, lowering ceiling and visibility, ensuing darkness, and the pilot not knowing his exact position. Landing was made on an uphill field with a slight tail wind. The aircraft struck a swale and then…NTSB LAX86LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mesa, AZAt the end of the first leg of a solo cross-country flight the plt experienced a hard landing and the acft porpoised. On the second bounce the plt added power. The acft then bounced a third time collapsing the nose gear.NTSB LAX86FVA14Accident · Minor injuriesFinal reportHiller UH-12E · Lemoore, CAThe plt reptd that while returning to the loading area after spraying a field, he heard a loud pop emanating from the engine compartment. Shortly thereafter he observed a fire in the engine compartment and lost forward and aft control of the helicopter. The…NTSB DEN86FA254Accident · 2 fatalField investigationFinal reportCessna 182Q · Ovid, COThe plt and his pax had flown to ogallala, NE, for boating and water skiing. The next day the plt called his wife who reminded him of an engagement that evening. The plt called the fss 5 different times and each time was told VFR flt was not recommended. He…NTSB CHI86LA228Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · St. Paul, MNAt the end of an uneventful flight the pilot lowered the landing gear and noted three gear down indicator lights. Upon landing rollout the nose gear collapsed. An inspection following the accident revealed that a hydraulic leak was present near the hydraulic…NTSB CHI86LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grosse Ile, MIThe pilot stated that he had a habit of landing left of the centerline. While landing with a right crosswind, the aircraft drifted to the left and the left wing struck three construction sawhorses, placed off the left side of the runway.NTSB CHI86LA224Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Quincy, ILAccording to the ATC report, N71650 indicated he would use the ILS rwy 04 and circle to rwy 18. The plt stated that he was in and out of fog while on downwind for rwy 18 and that he then encountered a 'bank of ground fog' as he turned short final. According…NTSB CHI86IA225Incident · No injuriesIncident investigationFinal reportBoeing 727-25 · Evansville, INAfter the aircrew of eastern flt 254 (a Boeing 727, N8107N) had landed on rwy 22 at night & was slowing, the tower controller (ctlr) instructed them to 'turn right on taxiway bravo, if able, hold short of rwy 18 and remain this frequency.' The crew of flt 254…NTSB LAX86LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Monterey, CAThe private plt landed her acft & began taxiing toward a parking area. The driver of an acft fuel service truck observed the approaching acft, & he brought his truck to a complete stop in an authorized area for truck traffic. He was clear of the taxiway. The…NTSB LAX86LA355Accident · No injuriesLimited investigationFinal reportAero Commander 112A · El Monte, CAThe pilot stated that the engine would not start so he secured the left wing and hand propped the engine. When the engine started, the aircraft began moving in a circular path to the left and collided with a parked aircraft.NTSB LAX86LA353Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe plt & passenger, each weighing 185 pounds, planned a local flight in the rented Cessna 152. The acft's fuel tanks were full. The plt reported that during his pretakeoff engine run up no mechanical difficulties/malfunctions were observed. The plt also…NTSB ATL86LA261Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Plymouth, NCDuring a turn to reverse direction while dispersing chemicals over a peanut crop, the engine lost power. The pilot dumped the load of chemicals and made a hard full stall forced landing in the peanut field. Inspection of the engine revealed that the left…NTSB ATL86LA258Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Chardon, OHDuring final landing approach to runway 14, the sutdent pilot deployed spoilers and attempted to maintain altitude. The glider collided with trees and descended out of control to the ground 200 feet short of the runway. The student pilot had a total flight…NTSB ANC86LA158Accident · No injuriesLimited investigationFinal reportCessna 207A · Mountain Villag, AKThe airline transport pilot who is also a certificated airframe and powerplant mechanic elected to defer brake repairs until the end of the flying day. The fatigued right brake line failed before the end of the day's flying activity. During lndg the brakes…NTSB NYC86LA238Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashburnham, MAWhile crusing at an altitude of about 3500 feet, the flight suffered fuel exhaustion and lost engine power causing the pilot to execute a forced landing in a field.NTSB MKC86LA190Accident · No injuriesLimited investigationFinal reportBeech A36 · Horton, KSDrg arrival, the plt noted an 'x' on rwy 35, so he tansitioned to a downwind for rwy 33. At that time, the windsock showed a direct left x-wind for the 1860 ft turf rwy which had a fence across the apch end. The acft touched down about 400 to 500 ft down the…NTSB MKC86FA189Accident · 2 fatalField investigationFinal reportPiper PA28-151 · Foristell, MORadar signal data recorded the subj acft moving northwest in a shallow climb. The track data terminated abt 0538 c.d.t. or abt 12 minutes into the flt. A witness near the VOR station stated he heard an acft flying overhead, abt the time the FAA reported…