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 ANC85LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Barrow, AKThe plt reported that when he returned to the arpt, he made a 3-point landing in gusty x-wind conditions. Reportedly, the acft then ground looped & was damaged. At 1534 adt, the wind at Barrow was from 050 deg at 13 gusting 18 KTS.NTSB SEA85FA162Accident · 2 fatalField investigationFinal reportBeech B36TC · Idaho City, IDThe plt failed to obtain a preflt wx briefing prior to departing both butte, MT, and salmon, ID. En route at FL180 he entered instrument and icing conditions which he attempted to avoid by climbing to FL200. During the climb, the plt reported encountering…NTSB NYC85LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cherry Valley, NYDurng a climb to cruise, theengine RPM dropped to 2000. The pilot check the carburetor heat and other instruments and did not find any abnormalities. The engine RPM dropped a second time to 1800 a sound described by the pilot as a loud band was heard and the…NTSB MIA85LA209Accident · 4 fatalLimited investigationFinal reportPiper PA-32R-301 · Bahamas, BahamasThe acft failed to arrive at it's intended destination on a flt from nassau, Bahamas to opa locka arpt, miami, FL. The acft was reported missing by the miami fss. The U.S. Coast guard initiated a search on 07-12-85 at about 1831 EDT & search was suspended on…NTSB LAX85FA315Accident · 2 fatalField investigationFinal reportBell 206-B · Page, AZOn July 12, 1984, a Bell 206B helicopter collided with a steel bridge 10 miles so of Page, AZ. The helicopter was being filmed in flt during the making of a movie. VMC existed at the time. The helicopter was destroyed and the plt and pax, an italian actor,…NTSB FTW85LA291Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Patterson, LAThe acft was substantially damaged when it was rammed by a speed boat after it had landed on a canal and was water taxiing to its tie down area. The boat came out of a crossing canal at high speed and struck the amphib in the area of the left float. The boat…NTSB FTW85LA286Accident · No injuriesLimited investigationFinal reportCessna T210N · College Station, TXAbout 25 minutes after takeoff from a planned intermediate stop, the right fuel tank ran dry. After switching tanks, theplt decided to divert to a nearby arpt to refuel. During the descent, the left fuel tank ran dry and the eng quit due to fuel exhaustion.…NTSB FTW85FA283Accident · No injuriesField investigationFinal reportGates Learjet 35A · Fort Worth, TXThis acft ran off the departure end of the 4001' runway following a normal approach, touchdown and initial braking. After about 1000' of norm braking, the acft began a drift to the right which was partially overcome by full left rudder and asymmetrical…NTSB DEN85FA186Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Aspen, COCFI and student departed Aspen, Colorado, on a dual x-country flt. The density altitude at the time of departure was calculated to be 9954 feet. The CFI directed student to fly up a canyon in an area of rising terrain. The CFI took control of acft and was…NTSB DEN85FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Columbus, MTAfter making a low pass over his pax home, the plt pulled the acft up abruptly and stalled at a very low altitude. The alt was too low for the plt to effect a successful recovery before ground impact.NTSB CHI85LA289Accident · No injuriesLimited investigationFinal reportBensen B8M · Hebron, OHThe gyrocopter lost partial pwr while in the traffic pattern and the plt executed an autorotation into a corn field. The throttle cable was found loose after the accident.NTSB SEA85LA161Accident · No injuriesLimited investigationFinal reportMooney M20-F · Salem, ORThe acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be…NTSB NYC85LA194Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Savoy, MAThe pilot was attempting to land on a dirt runway approximately 800 feet long with a small dirt embankment at the threshold. During the approach, the aircraft landed short and the landing gear collided with the embankment. The aircraft nosed over and came to…NTSB NYC85LA165Accident · No injuriesLimited investigationFinal reportBeech C23 · Penn Yan, NYThe plt was familiar with the arpt, during the landing the plt observed the wind sock indicating calm winds and the acft was landed into the sun. During the landing roll, pwr was added for takeoff. When the acft was aprx 2/3 the way down the rwy, the plt…NTSB NYC85LA164Accident · No injuriesLimited investigationFinal reportCessna 182M · Block Island, RIThe plt was checked out in the C-182 on July 9, 1985 and had flown this acft for 1 hr in the previous year. During a normal power off landing with ten degrees of flaps extended, the plt added power and noticed no change in performance. The acft touched down…NTSB NYC85FA163Accident · No injuriesField investigationFinal reportMitsubishi MU-2B-26 · Southbridge, MADuring lndg the acft impacted hard and skidded down the rwy before it went off the left side of the rwy. The left main wheel separted and the nose gear collapsed. Both plts stated the lndg apch was normal until the acft was aprx 15 ftabove the rwy at which…NTSB MKC85LA153Accident · No injuriesLimited investigationFinal reportCessna 172M · Olathe, KSPlt stated that she used left aileron and right rudder for x-wind correction and did not release the rudder pressure on touchdown. The acft went off side of rwy, crossed a taxiway, went down an embankment and through a fence into a plowed field where it nosed…NTSB MKC85FCQ05Accident · Serious injuriesFinal reportCessna 150M · Manhattan, KSThe acft contacted the terrain aprx 175 yds short of rwy 21 and aprx 50 ft right of the centerline. A witness reported the acft appeared slow on final apch and it was rolling slightly from side to side. The nose of the acft then suddenly dropped and the acft…NTSB LAX85LA313Accident · No injuriesLimited investigationFinal reportCessna 182 · Sawmill, AZDuring the plt's preflight inspection of his acft, he removed the fuel caps to examine the quantity of fuel in the acft's tanks. Thereafter, he failed to securely refasten the caps. At 0700 MST the plt & his 2 pax departed for a planned flt from AZ to co. 56…NTSB LAX85FA314Accident · 1 fatalField investigationFinal reportMooney M20J · Antioch, CAThe acft crashed into a reservoir shortly after departing the Antioch arpt. There were no eye witnesses to the crash. However, an ear witness stated that he heard the acft skipping along the water like the sound of a hydro-plane. He did not hear the eng, but…NTSB FTW85LA284Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Sonora, TXWhile landing at an unfamiliar strip, the plt observed a rough surface at the apch end, and landed one halfway down the down-sloping 2300 ft rwy. He tried to go around, but could not accelerate enough, and the acft rolled thru 2 fences, trees, then stopped…NTSB FTW85FA282Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Matagorda Islng, LAThe acft touched down hard during an attempted autorotation to an abandoned air base. Initial touchdown occurred on the stinger and the acft yawed to the left of rwy heading 30 to 40 degrees. The next touchdown was on the skids and the acft yawed further to…NTSB ANC85FA125Accident · No injuriesField investigationFinal reportCessna 152 · Big Lake, AKThe glider plt was in training for a single eng land rating & was indorsed for solo flt. During her training, she & her instructor plt had landed at the Big Lake arpt. She thought that that was her approval to land there solo. However, there were sandy soft…NTSB SEA85IA160Incident · No injuriesIncident investigationFinal reportCessna 207 · Bellevue, WAA complete loss of power occurred during a CFR 135 passenger flight. The oil filter adapter was found to be safety wired in a position with 3/4' of threads visable. Causing a complete and sudden loss of oil and power.NTSB MKC85LA152Accident · Minor injuriesLimited investigationFinal reportBell 47G · Pella, IAThe purpose of the flt was to provede training in aerial application procedures and techniques for the plt/owner of N75273. The instructor plt has extensive experience in this m/m and was at the controls. He was demonstrating a turn around at the end of a…NTSB FTW85LA281Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Rosharon, TXThe plt stated he failed to switch fuel selector to the left tank prior to takeoff (right tank empty). The engine quit abruptly at low altitude. Plt switched to left tank but could not regain engine power prior to hard landing in cotton field.NTSB DEN85LTG03Accident · No injuriesFinal reportPiper PA-25-235 · Kramer, NDThe acft collided with the shoulder of a hwy when the plt attempted to avoid power lines during an aerial application flt.NTSB DEN85LQA01Accident · No injuriesFinal reportPetracca Glasair SH-2 · Aztec, NMThe acft sustained substantial damage after it stalled and contacted the ground during takeoff. Plt stated lift off was made with minimal airspeed and the right wing dropped shortly after becoming airborne. Plt overcorrected for the right bank, the acft…NTSB CHI85LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Roseau, MNThe aircraft had been airborne about 15 min engaged in ag spray operations when the pilot described hearing a loud band. Engine power decreased to idle. Pilot ld in soft soil and nosed over inverted. Exam disclosed #2 piston had failed.NTSB CHI85LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, MNThe student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down.NTSB CHI85LA280Accident · No injuriesLimited investigationFinal reportHughes 269A1A · Coal Valley, ILDuring an aerial application run the plt reported a 'split second loss of power.' He lost directional control of the helicopter and it settled into tall corn. Impact resulted in loss of the main rotor blades, severence of the tail cone and separation of the…NTSB CHI85LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Almont, MIThe student plt stated that during touchdown the acft bounced back into the air. On the second touchdown, the acft swerved to the left and departed the rwy. It then rolled until the left wing struck a small tree, causing substantial damage to that wing. The…NTSB ATL85LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALWhile on a solo training flight the aircraft lost power while on downwind and the student pilot made an mergency landing on the runway, however, during landing roll the aircraft went off the side of the rwy and nosed over in the soft soil. Post crash…NTSB ANC85LA122Accident · No injuriesLimited investigationFinal reportTaylorcraft DF-65 · Eklutna, AKAcft landed hard, collapsing both main landing gear after making a steep apch to a short area on a gravel road. Plt was landing to drain some acft fuel out in order to get better climb performance for a mountain sightseeing flight.NTSB ANC85FA124Accident · Minor injuriesField investigationFinal reportCessna A-185F · Elmendorf Afb, AKImmediately after takeoff from a lake the acft stalled, did a half spin & nosed into the water. Witnesses reported seeing acft nose pitching up & down & wings wobbling just prior to the stall. This was plt's first flt in this type acft without an instructor.…NTSB SEA85LA159Accident · No injuriesLimited investigationFinal reportCessna 150 · La Grande, ORThis was the student pilot's second solo flight. He had a total time of less than 9 hours. A bounced landing occurred and the student was unable to make an adequate recovery. A witness who saw the accident stated that the aircraft started a climb out with…NTSB FTW85LA278Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Austin, TXThe eng failed at about 2000 ft MSL while the acft was climbing to cruise flt. The plt attempted to turn back to the arpt but realized it was too FAR away. The plt then made a forced landing in a grass area adjacent to a large hwy at about a 45 deg angle to…NTSB ATL85LA209Accident · No injuriesLimited investigationFinal reportWilliam G. Cloaninger VARI-EZE · Albemarle, NCDuring the initial climb after takeoff, the eng lost power as the plt made a left turn. He tried to glide back to the rwy, but was unable. The acft was landed in a field about 300 yds short of the rwy. During the landing, all 3 gear were torn off the acft,…NTSB ATL85LA208Accident · Minor injuriesLimited investigationFinal reportCessna T303 · Shelby, NCThe plt stated that after takeoff from rwy 23, he noticed oil coming from the left eng. He initiated a turn to land on rwy 05 but was unable to line up with the rwy. He elected to go-around and when he added full power the left eng oil pressure went to zero…NTSB ATL85LA207Accident · No injuriesLimited investigationFinal reportCessna 150 · Geneva, ALDuring instructional flight acft collided with trees after takeoff. Instructor said flaps would not retract while in go around. Acft owner told FAA inspector instructor told him flaps would not retract after final landing. Fuse was then replaced with no…NTSB SEA85LA158Accident · Serious injuriesLimited investigationFinal reportRand/Robinson KR2 · Pullman, WAThe plt had been having numerous problems with his homebuilt acft's eng running rough before this flt. Shortly after takeoff a loss of pwr occurred. It was a hot day with the temp being 90 degs f or better. FAA inspectors found the tourque value to be…NTSB LAX85FA311Accident · 2 fatalField investigationFinal reportCessna 152 · Marana, AZThe passenger had just purchased property at the accident site and intended to take aerial video tape footage of the property. Witnesses saw the plt and passenger board the acft with video camera and recorder. After departue, the acft flew directly to the…NTSB LAX85FA310Accident · 2 fatalField investigationFinal reportPolliwagen Unknown · Bakersfield, CAOn July 7, 1985, at 1917 PDT, a Polliwagen, N81PW, collided with the ground during an attempted go around at bakersfieldairpark, Bakersfield, California, while on a personal flight. VMC prevailed at the time; no flight plan was filed. The aircraft was…NTSB BFO85LA054Accident · No injuriesLimited investigationFinal reportCessna 172-RG · Thurmont, MDUpon encountering a low ceiling, precipitation, and haze at approximately 1500 feet MSL, the plt descended in order to locate a suitable landing area. The plt observed a grass airstrip below him, and executed a hard landing. The aircraft bounced once, and…NTSB ATL85LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAAccording to the pilot, he forgot to extend the landing gear. He stated most of his flight time had been in fixed gear aircraft. On this flight he had been told by his instructor to work on smoothing his radio technique on the second landing of the flight he…NTSB ANC85LA123Accident · No injuriesLimited investigationFinal reportCessna 185F · Egegik, AKEngine failed at 200 ft AGL, due to fuel starvation. Plt attempted to reach lake, & crashed in trees at edge of lake.NTSB LAX85LA309Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Durham, CAThe purpose of the LCL flight was for the CFI to demo the newly acquired helicopter to its owner. The CFI reported that during the flt a 'somewhat common' vibration was detected, & he associated the vibration with the acft's wooden main rotor blades. He…NTSB LAX85LA308Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Vacaville, CAWitnesses stated that, on departure, the aircraft climbed to about 50 feet, appeared to stall, and crashed on the runway. The winds were reported as gusty, from 15 to 22 knots, and the temperature was about 95 degrees.NTSB FTW85LA279Accident · No injuriesLimited investigationFinal reportCessna 150L · Killeen, TXThe student pilot failed to properly flare the aircraft and touched down hard on the nose gear. This caused the aircraft to start porpoising from which recovery was not made. Aircraft continued to bounce until the nose gear collapsed. It then slid to a stop,…NTSB FTW85LA277Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Midland, TXThe plt stated that on a pass over the pvt strip the wind sock as indicating the wind out of the north. In actuality, Midland regional arpt was reporting the winds from 110 degs at 13 KTS. Touchdown was made at a higher than normal airspeed. The acft landed…