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 LAX87LA174Accident · Serious injuriesLimited investigationFinal reportGrumman G-44A · Ventura, CADuring a local pleasure flight, the pilot had reduced power and descended to a lower altitude to take pictures of a sailboat race. At approximately 200 feet the pilot made a descending right turn, then leveled off. The aircraft stalled and the pilot lowered…NTSB FTW87LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Jackson, LAEngine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33.NTSB ATL87LA113Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ridgeland, SCThe plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was…NTSB ATL87LA110Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Branchville, ALThe plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind…NTSB ATL87FA111Accident · 1 fatalField investigationFinal reportAeronca 7AC · Sharpsburg, GAPlt dep a pvt grass airstrip for a LCL VFR flt. Acft was observed to lift off the grass rwy at about 1000 ft. it climbed to about 30 ft AGL and leveled off. At about the end of the 1800 ft rwy the acft nosed up into a 'fairly steep' climb attitude. The ground…NTSB SEA87LA079Accident · No injuriesLimited investigationFinal reportHughes 369HS · Yakima, WASix miles from the airport, at cruise, the engine ceased operating due to fuel exhaustion. The plt had noticed the low fuel warning light on 10 minutes prior to the engine failure but elected to continue his flight. Autorotation was made from 1,000 feet AGL…NTSB NYC87FA120Accident · 4 fatalField investigationFinal reportCessna 172P · Berwick, METhe acft was observed doing stalls. A witness said that prior to the crash he saw the nose lower and the right wing drop. The aircraft then entered into a spiral. It was observed descending into trees in a spiral. The plt was found in the right front seat.…NTSB NYC87FA119Accident · 4 fatalField investigationFinal reportCessna 172N · Ferguson Twnshp, PAThe pilot, who had not completed his checkout in a Cessna 172, was observed to make a long landing and lift off with approximately 750 ft of runway remaining. The aircraft was observed to enter a nose high pitch attitude and drift into a right turn. The…NTSB MKC87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brewster, KSThe PIC rptd verring left and off the side of the sod strip where he was attempting a lndg. The PIC stated that the lndg gear began sinking into soft grnd off the side and the acft slowed rapidly. After slowing the nose wheel collapsed rearward flipping the…NTSB LAX87IA176Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Agana (Pacific Ocean)As the aircraft approached its home airport at Agana, guam the captain passed out. The first officer took over the controls and landed the acft without further incident. The cause of the incapacitation was not determined.NTSB LAX87FA173Accident · Serious injuriesField investigationFinal reportHughes 369E · Palm Desert, CAThe helicopter dscndd uncontrolled & crashed in a residential area. After the acdnt, the plt said he agreed to orbit the residence of his pax. At the aprx 135 deg point of a left orbit, he felt 'a bang & severe vibration in the tail.' The plt lost drctnl ctl…NTSB FTW87DRG01Accident · 1 fatalFinal reportDavis Pitts S-1S · Coleman, TXThe pilot had completed several aerobatic maneuvers for an air show and was in the process of doing a series of five snap rolls at an altitude of 200-300 feet AGL when the accident occurred. Witnesses observed the nose of the acft to drop during the third…NTSB DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…NTSB DEN87LA094Accident · No injuriesLimited investigationFinal reportHughes 269C · Scoffield, UTThe plt and his brother were on a long cross country flt, through mountainous terrain. After one hour of flt and while flying at 8,000 feet the plt noticed a change in engine noise and the acft had a partial power loss. The plt elected to autorotate to a snow…NTSB ATL87LA109Accident · No injuriesLimited investigationFinal reportCessna 150F · Branchville, ALThe plt reported that the acft appeared to be 'hot' on final approach due to a tailwind, while ldg at the private airstrip. He initiated a go-around to avoid 50-60 ft trees at the FAR end of the rwy and made a climbing right turn. The stall warning system…NTSB NYC87DNE02Accident · 1 fatalFinal reportSprague Christian Eagle II · North Adams, MAThe christian eagle was coming in for a touch and go when it sank into trees, turned around and became involved in a postcrash fire. The acft was destroyed and the plt fatally injured. A pilot who preceded the accident aircraft said the winds were gusty and…NTSB LAX87FA172Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Malibu, CAThe plt & his 3 passengers met at a bar then decided to go on a local night scenic flt. Subsequently, the acft crashed into the ocean as the plt was demonstrating low flt over the water. The plt & 1 passenger were hospitalized & treated for injuries &…NTSB LAX87DJA05Accident · Serious injuriesFinal reportNihon YS-11A · Honolulu, HIDuring the takeoff ground run approaching V1/VR, the #1 engine fire warning light illuminated and the fire bell sounded. The takeoff was aborted and the acft was turned off the rwy onto a taxiway. The engines were shutdown and the captain ordered a right side…NTSB FTW87IA097Incident · No injuriesIncident investigationFinal reportBeech 58 · Bridgeport, TXDuring cruise flight, the aircraft's right engine caught fire. The pilot shutdown the engine and feathered the prop, extinguishing the fire. The pilot declared an emergency with ATC and landed safely at an alternate airport, with only minor damage to the…NTSB FTW87FA093Accident · No injuriesField investigationFinal reportCessna 150G · Post, TXSubstantial damage occurred during an attemtped touch and go landing by a student pilot. The acft landed hard, collapsing the nose gear and empennage. After initial impact the acft became airborne for approximately 1000 ft before contacting the runway again…NTSB DEN87LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Idalia, COAn ag plt was attempting a takeoff on a dirt road for an aerial application flt. The wind was from the northwest and the acft was aligned to the south. During the takeoff ground run a gust from the rear lifted the acft. The acft departed the road to the left,…NTSB DEN87LA092Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Gillette, WYThe plt reports that just after the tail was raised on the takeoff roll, his seat slid full aft on the rails. He said he was unable to reach the rudder pedals and the acft swerved to the lt, ground looped, and nosed over. The plt was not injured but the…NTSB CHI87DER05Accident · Minor injuriesFinal reportPiper PA-25 · Henning, MNAfter experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of…NTSB CHI87DER04Accident · Minor injuriesFinal reportPiper PA-32-260 · Pine Center, MNAfter noticing a loss in oil pressure, the pilot initiated an emergency landing in a swamp. The aircraft impacted trees and received substantial damage. The pilot reported minor injuries. Subsequent investigation revealed that the oil sump contained several…NTSB ATL87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ravenna, OHThe student plt was making a touch and go ldg on rwy 27. After touchdown, he retracted the flaps and applied full power to takeoff again. The acft began to veer left after power was applied. The CFI reported that she told the student to apply right rudder as…NTSB MKC87LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirksville, MODrg a night landing, the plt did not get the acft flared before touchdown. Subsequently, it contacted the rwy with the nose wheel. Drg the occurrence, the nose gear, prop & eng fire wall were damaged.NTSB MIA87LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Pine Key, FLThe plt stated that during cruise flt the eng began to run rough. He then attempted to solve the problem to no avail. Unable to maintain alt he elected to land the acft on a road. While taxiing, both wings collided with street signs. Post crash examination of…NTSB DCA87MA024Accident · 5 fatalMajor investigationFinal reportLockheed L-382G · Travis Afb, CACrashed in steep left turn drg go-around after balked landing. Instructor took controls and initiated go-around after student lndd in improper attitude. Engines number 1 & 2 failed to respond when throttles advanced. Both engines decelerated. Airspeed…NTSB CHI87LA111Accident · No injuriesLimited investigationFinal reportCessna 150M · Pontiac, ILThe plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm.NTSB BFO87LA029Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Midland, VAThe plt stated that this was the first time he had ever landed on rwy 32. During the lndg apch, about 15 secs before touchdown, his eyeglasses broke and fell off his face. He reached for his spare eyeglasses that were on top of the instrument panel; however,…NTSB ATL87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Vidalia, GAThe plt reported that he apparently had his left foot too high on the left rudder pedal while making a x-wind ldg. The left wheel skidded on the touchdown and the acft ran off the left side of the rwy. The nose wheel subsequently broke off and the acft nosed…NTSB NYC87IA118Incident · Minor injuriesIncident investigationFinal reportde Havilland DHC-7-102 · Wrightstown, NJRansom flt 444 (DHC-7) rprtd a near collision with USAF C-141 (gleek 41) as flt 444 was at 5000' & gleek 41 was clbg to 7500' fm a combat aircrew training (cat) mnvr. Flt 444 was under IFR ctl of mcguire afb rapcon; gleek 41 was VFR, rcvg radar adzys fm…NTSB MKC87LA101Accident · No injuriesLimited investigationFinal reportCessna 140 · Eldon, MOAccording to the pilot, winds were light prior to the final approach, but a gust of wind picked up the right wing and the aircraft ballooned during the flare, running out of airspeed while in a full-stall/three-point attitude. Upon impact, both main gears…NTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…NTSB DEN87LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bountiful, UTThe stud plt was practicing stalls about 10 n of arpt. During recovery from a stall the eng began to run rough. The plt said he advanced throttle, applied carb heat, and tried to adjust mixture. The eng continued to run rough and lose pwr and the plt returned…NTSB DEN87FA091Accident · 1 fatalField investigationFinal reportGrumman G-164A · Lamar, COThe aircraft had completed a formation aerial application operation and were in the process of single airplane spraying around the perimeters of a field. They collided at 10 feet above the ground on perpendicular flight paths, descended out of control and…NTSB NYC87LA117Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Boston, MADuring taxi operations in preparation for a takeoff from Boston logan airport, the Beech aircraft was struck by a ground vehicle and substantially damaged.NTSB MKC87LA080Accident · No injuriesLimited investigationFinal reportFairchild SA-227 · Springfield, MOOn April 6, 1987 a crew operating a metro iii, commuter acft noticed damage on both eng nacelles during a preflt insp. The commuter operator chief pilot was notified and an on site insp was made. The crew originally rptng the damage claimed they were not at…NTSB MIA87IA131Incident · No injuriesIncident investigationFinal reportCessna 310Q · Ft.Lauderdale, FLDuring the landing roll the right main gear collapsed. Inspection of the acft by FAA personnel revealed that this was caused by a twisted torque tube which failed to fully extend the gear.NTSB DEN87LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, UTN67880 experienced VOR receiver failure during a flt from ogden, UT to st. george, UT. The plt diverted to Milford, UT and another plt checked the receiver which functioned on the ground. The flt then departed Milford en route to st. george. Shortly after…NTSB DEN87FA090Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Berthold, NDThe plt took off to the east from a farm driveway to return home. Witnesses saw the airplane make an immediate right turn, followed by a left turn at aprx 35-50 ft AGL. The acft approached the farm at aprx 50-100 ft AGL. The acft suddenly pulled up, banked…NTSB CHI87IA109Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Chicago, ILA united airlines Boeing 727 domestic passenger flight was holding short of runway 32L at the Chicago-o'hare international airport awaiting clearance for an intersection takeoff. A northwest airlines Boeing 747 international passenger flight was holding in…NTSB CHI87DEP03Accident · No injuriesFinal reportErickson Sonerai 2L · Algoma, WIWhile in normal cruise flight the crankshaft failed at the propeller flange and the propeller departed the aircraft. The pilot executed a forced landing to a farm field. He was unable to flare successfully and lost control during landing.NTSB SEA87LA077Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Scott Mills, ORWith a gusting crosswind from the left the pilot allowed the student pilot to make the take off. The student pilot rotated prematurely and the aircraft weathercocked to the left. The pilot then took the controls of the aircraft but by then it was pointed 90…NTSB LAX87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Calexico, CAAt the end of a pleasure cross country flight, the plt reported that upon landing, the acft veered to the left, the plt corrected to the right. The acft veered to the left again and the plt corrected to the right. The acft then began to turn in a clockwise…NTSB DEN87LA087Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · La Salle, COWhile conducting an aerial application flt, the plt misjudged the distance to the end of the field and initiated the pull-up too late to avoid impact with a tree. After striking the tree, the acft descended out of control until impact with the ground.NTSB DEN87LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Cando, NDThe acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and…NTSB CHI87LA108Accident · No injuriesLimited investigationFinal reportCessna 150H · Tinley Park, ILApproximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident…NTSB CHI87DEE07Accident · No injuriesFinal reportCessna 172 · Lansing, ILThe pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the…NTSB SEA87LA075Accident · No injuriesLimited investigationFinal reportVerbeek Rotorway · Redmond, WAThe plt stated that while at cruise the acft developed a vibration and noise, followed by a power los. The plt then entered into an autorotation and landed onto a rough field. The acft touched down hard and then rolled onto its side. During engine inspection…