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.

NTSB LAX87LA165Accident · Minor injuriesLimited investigationFinal reportCessna T206F · Grand Canyon, AZThe plt said that on short final the acft began to drift off the left side of the rwy and control inputs to correct the drift had no effect. The plt added pwr to initiate a go around and he said that the 'airspeed suddenly dropped to 40 and we were in a stall…Mar 31, 1987 · N9026B · Substantial damageNTSB LAX87LA164Accident · No injuriesLimited investigationFinal reportBeech S35 · Tucson, AZThe aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing…Mar 31, 1987 · N13W · Substantial damageNTSB LAX87DVM02Accident · Serious injuriesFinal reportBowers Flybaby 1A · San Luis Obispo, CADuring a pleasure flt in an experimental acft, during the takeoff roll, the eng sputtered, however, the plt continued the flt. After takeoff at aprx 30 ft the eng sputtered again. The plt made a sharp 45 deg turn which put him on downwind, however, the acft…Mar 31, 1987 · N792JB · Substantial damageNTSB FTW87FA087Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Leakey, TXFlight instructor and student pilot flying Piper PA-28-140 departed uncontrolled airport after switching fuel tanks on runway. Fuel selector valve was inadvertently moved to off position by student pilot. Aircraft engine quit on initial climb at approximately…Mar 31, 1987 · N4602R · Substantial damageNTSB DCA87MA023Accident · 3 fatalClass 1 · MajorFinal reportCessna 172N · Oakland, CAAt 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…Mar 31, 1987 · N75584 · 2 aircraft · DestroyedNTSB CHI87IA112Incident · No injuriesIncident investigationFinal reportDassault-Breguet 50 · Cleveland, OHAn opnl error developed as a falcon 50, N52DC, was proceeding se toward the dryer VOR at FL290 & northwest flt 427 was proceeding westbound at the same alt toward the same fix (dryer VOR). When the full performance lvl (fpl) controller (ctlr) saw the…Mar 31, 1987 · N52DC · No damageNTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…Mar 30, 1987 · N4GH · Minor damageNTSB LAX87LA162Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Paula, CAAt the end of a pleasure cross country flt the plt prior to entering the pattern noted the wind direction and speed as 060 degs at aprx 16 KTS. The plt then entered the pattern for rwy 4. On final apch the plt had to slip the acft to keep alligned with the…Mar 30, 1987 · N6339K · Substantial damageNTSB FTW87FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Marlin, TXThe acft had been involved in pipeline patrol throughout its history of 7490 flt hrs. Just before the acdnt, the acft was observed in straight & lvl flt along a pipeline right-of-way. According to witnesses, the acft was at low alt when a wing separated & the…Mar 30, 1987 · N8191V · DestroyedNTSB DEN87LA077Accident · Serious injuriesLimited investigationFinal reportPitts Special S2C · Deming, NMThe acft swerved during takeoff and the swerve severity increased during acceleration. The plt lifted off before reaching proper speed to sustain flt. The acft stall mushed into the ground to the left of the rwy, bounced into the air and stalled again. The…Mar 30, 1987 · N58DC · Substantial damageNTSB CHI87FA106Accident · Serious injuriesField investigationFinal reportAirbus Industrie A300B4-203 · Indianapolis, INWhile cruising at ngt in clr air (well abv clds), eastern ai lines flt 477 was in light chop at FL 310 with the seat belt sign on. The captain stated that when the turbulence increased to a moderate cond, he made an announcement for the flt attendants (f/a's)…Mar 30, 1987 · N230EA · No damageNTSB ATL87FA101Accident · Serious injuriesField investigationFinal reportBeech A36 · Dalton, GAOn t/o at 1st power change PIC noted loss of performance. He turned left to downwind leg for landing. PIC and ground witnesses said eng quit and acft crashed into trees and ground. Post crash fire destroyed acft. PIC rpted taking fuel sample before t/o with…Mar 30, 1987 · N6170U · DestroyedNTSB ANC87LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Nikolai, AKThe student pilot stated that he was on a solo cross country flight when he reported that he was lost and low on fuel. He attempted an emergency landing but crashed 200 feet short of the runway. The flight instructor stated that the aircraft was out of fuel…Mar 30, 1987 · N67767 · Substantial damageNTSB SEA87LA071Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Issaquah, WADuring a local training flight a downdraft was encountered. At about two miles from the airport the acft was at about 200 feet MSL. The instructor plt decided to land the acft on a field. On short final the acft struck a barbed wire fence prior to touchdown.Mar 29, 1987 · N33924 · Substantial damageNTSB LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…Mar 29, 1987 · N90153 · DestroyedNTSB LAX87LA159Accident · No injuriesLimited investigationFinal reportJones Pitts Special S1A · Franklin, CADuring the landing roll, the pilot was unable to maintain directional control when a gust of wind from the right pushed the aircraft off the left side of the runway. The aircraft collided with the terrain and nosed over. There was no mechanical failure or…Mar 29, 1987 · N9GD · Substantial damageNTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…Mar 29, 1987 · N4211Q · No damageNTSB BFO87LA028Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Dover, DEThe rockwell was in level flight at 2800 ft and the Piper was climbing when midair collision occurred. Neither acft was operating under ATC. Neither plt saw the otr acft before the collision occurred. The bottom of the rockwell cabin and the left tiptank of…Mar 29, 1987 · N5216Y · 2 aircraft · Substantial damageNTSB SEA87LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORSeated at the controls in the left front seat was a plt who had not flown in ten years. Seated in the right front seat was the owner/student plt. The purpose of the flt according to the plt, was to familiarize the plt with the acft so that the plt could…Mar 28, 1987 · N4298T · Substantial damageNTSB MKC87LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Fremont, MOThe student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot…Mar 28, 1987 · N6978F · Substantial damageNTSB MIA87LA132Accident · No injuriesLimited investigationFinal reportCessna 172M · Clarksdale, MSThe pilot stated that while flying at a low altitude over a dried up lake bed the aircraft collided with an unmarked telephone wire. A landing was made in a field where damaged was inspected. The pilot then elected to takeoff and return to the departure…Mar 28, 1987 · N12497 · Substantial damageNTSB MIA87LA121Accident · No injuriesLimited investigationFinal reportCessna 310L · Venice, FLThe left main landing gear collapsed during the landing roll after the plt inadvertently retracted the landing gear instead of the flaps. The pilot left the scene of the accident and his identity is unknown.Mar 28, 1987 · N3304X · Substantial damageNTSB LAX87LA166Accident · No injuriesLimited investigationFinal reportCessna 310 · Agua Dulce, CAThe non-multiengine rated pilot attempted to land his multiengine airplane on a 4600 foot runway. The aircraft touched down approximately half way down the runway and slid off the departure end. The aircraft impacted trees after departing the runway.Mar 28, 1987 · N223H · Substantial damageNTSB LAX87LA158Accident · No injuriesLimited investigationFinal reportThorp T-18 · Riverside, CAWhile on a flt to practice aerobatics, the plt was flying at 3500' when he felt a cold liquid on his rgt leg & noted the odor of fuel in the cockpit. Moments later, flames erupted in the cockpit. The plt bailed out & the airplane crashed on the southeast…Mar 28, 1987 · N26CK · DestroyedNTSB LAX87DUJ04Accident · 1 fatalFinal reportBenson B-8M · Fountain Hills, AZWitnesses stated that the homebuilt gyrocopter entered a steep climb and appeared to roll completely over. Halfway through the engine backfired and then quit. The aircraft went into a steep dive. The aircraft impacted the terrain near vertically.Mar 28, 1987 · N282A · Substantial damageNTSB FTW87NA086Accident · 3 fatalFinal reportLearjet 24A · Eagle, COMar 28, 1987 · N31SK · DestroyedNTSB FTW87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Palestine, TXDuring flare/touchdown the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted some trees off the right side of the runway causing substantial damage to the wings, tail and landing gear.Mar 28, 1987 · N22064 · Substantial damageNTSB FTW87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Many, LAAcft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around…Mar 28, 1987 · N2946Y · Substantial damageNTSB FTW87DQG01Accident · No injuriesFinal reportReplica P51 · Midland, TXPilot reported prop surging in flt. During landing roll the pilot lost control, groundlooped and the main landing gear collapsed. Investigation could not reveal a reason for the prop surging.Mar 28, 1987 · N51JR · Substantial damageNTSB DEN87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Cavalier, NDThe pilot was landing with a cross wind. The aircraft bounced and drifted into snow bank along the right edge of the runway. The nose gear was broken off in the collision with the snow bank and the engine was pushed into the firewall.Mar 28, 1987 · N2848V · Substantial damageNTSB DEN87LA075Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Columbus, MTA pre-solo student and CFI were practicing landings. The CFI reduced pwr on climbout at 300 to 400 feet. During the discussion of what to do in case of lost pwr on takeoff, the student executed a steep, 180 degree turn, toward the arpt. The acft stalled, and…Mar 28, 1987 · N6050V · Substantial damageNTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.Mar 28, 1987 · N1156H · Substantial damageNTSB CHI87FA133Accident · 1 fatalField investigationFinal reportBeech V35-TC · Mount Vernon, ILThe acft was on a test flt after a top-overhaul had just been completed. Mechanics rprtd that before the flt, the eng had been properly rigged & operated normally drg run-up. Drg initial climb after takeoff, witnesses said the eng lost power. The plt…Mar 28, 1987 · N2820S · DestroyedNTSB ATL87FA100Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Georgetown, DEThe plt was cleared for approach with instructions to close flt plan upon landing. Aprx thirty min later approach control called the fss and asked if the plt had been in contact. The reply was negative. No further action was taken by approach control.…Mar 28, 1987 · N2221E · DestroyedNTSB SEA87LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Medford, ORA total and sudden loss of power occurred at about 3,500 feet MSL during climb for cruise. The pilot made a 180 degree turn back to the airport. Since an undershoot was assured the pilot elected to land the aircraft on a field. During landing rollout at about…Mar 27, 1987 · N4878V · Substantial damageNTSB NYC87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Bedford, MADuring taxi operation in preparation for takeoff, the left main gear of the aircraft impacted an unmarked open manhole and the aircraft was substantially damaged.Mar 27, 1987 · N40958 · Substantial damageNTSB MIA87LA120Accident · No injuriesLimited investigationFinal reportCessna 210C · Ponch, PRThe acft was found abandoned in a sugar beet field with the landing gear collapsed. Information pertaining to the occupant(s), history of flt, and facts pertaining to the accident could not be determined. Injury index presumed.Mar 27, 1987 · N3643Y · Substantial damageNTSB LAX87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · San Luis Obispo, CAAfter take-off, the pilot was flying a downwind departure when the engine quit. The pilot was unable to return to the runway and collided with the terrain a half mile from the airport. Inspection of the engine at the time of the accident found that the main…Mar 27, 1987 · N9306W · Substantial damageNTSB FTW87DPJ05Accident · Serious injuriesFinal reportde Havilland DHC-1B-2S5 · Claremore, OKMud daubers plugged the fuel tank vents resulting in fuel starvation and engine failure. The acft received substantial damage during the forced lndg and the plt was seriously injured.Mar 27, 1987 · N320HP · DestroyedNTSB DEN87LA073Accident · No injuriesLimited investigationFinal reportMooney M20C · Wahpeton, NDA CFI and a dual student were making practice landings. On the sixth landing, the student failed to lower the landing gear. The CFI did not notice that the acft did not have landing gear extended. The acft landed with gear fully retracted.Mar 27, 1987 · N6550U · Substantial damageNTSB CHI87FA104Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Frankfort, ILAircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…Mar 27, 1987 · N452BH · DestroyedNTSB ATL87LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shelbyville, TNThe acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left…Mar 27, 1987 · N654Y · DestroyedNTSB ATL87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Toccoa, GAThe pilot overshot runway 20 and skidded off the departure end which caused substantial damage to the aircraft. The pilot stated that he should have descended to the normal visual traffic pattern altitude before attempting a landing. There were no reported…Mar 27, 1987 · N3042U · Substantial damageNTSB SEA87IA068Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Tuba City, AZWhile engaged in cruise on a scheduled transcontinental flight from new york to los angeles, several stage 1 high pressure turbine rotor blades within the #1 engine separated without warning from their platforms. The initial separation was found to have…Mar 26, 1987 · N151AA · Minor damageNTSB MIA87LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Gainesville, FLThe non instument rated private pilot filed an instrument flight plan for a 5 hour flight. The flight lasted 5 hours and 26 minutes when the pilot radioed controllers that he had run out of fuel and the engine failed. The aircraft crashed at the destination…Mar 26, 1987 · N6143P · Substantial damageNTSB LAX87FA156Accident · 2 fatalField investigationFinal reportCessna 310Q · Half Moon Bay, CAWhile flying northwest over water along the pacific coast on an IFR clnc, the plt rprtd to the sector controller (ctlr) 'we've got a problem.' The ctlr inquired about the nature of the problem. The plt then stated, 'going down fast, out of control.' The ctlr…Mar 26, 1987 · N7603Q · DestroyedNTSB DEN87LA074Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Park City, UTThe Balloon was landing in an open field and struck a rock. One pax had prepared for hard landing and one had elected to continue filming. The photographer was thrown forward out of the basket and the basket passed over him, coming to rest 50 feet away.Mar 26, 1987 · N1521G · Substantial damageNTSB DEN87LA072Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Greeley, CODuring landing roll, after a normal pattern, an unusual noise was heard by the pilot. He described it as a 'thud' or a loud 'pop' noise. The pilot lost directional control and departed the runway to the left. The landing gear was severely damaged. No prempact…Mar 26, 1987 · N8793V · Substantial damageNTSB CHI87LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Shelbyville, INThe plt's original destn was lexington, KY, however between bluefield, KY and lexington, he amended his destn to indianapolis, IN. The plt stated that fuel consumption was calculated as 7.1 gph, but he did not take into consideration the Cessna 172 time/fuel…Mar 26, 1987 · N19984 · Substantial damageNTSB ATL87LA098Accident · No injuriesLimited investigationFinal reportMooney M20F · Winnsboro, SCThe acft hit a ditch during a forced landing after a power loss on takeoff. The acft had received annual inspection during which no contamination of the fuel system was found. The acft was parked outside, in the rain, to await the owner's pickup. The fuel…Mar 26, 1987 · N6990V · Substantial damage