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 ATL87DEI10Accident · No injuriesFinal reportCessna 152 · Kent, OHThe student plt was on his third solo flight. As he was flaring to land, the aircraft ballooned twice and he initiated a recovery by adding power. However, the airplane settled and contacted the runway with the nosewheel first, damaging an engine mount &…Jul 16, 1987 · N95469 · Substantial damageNTSB ANC87LA098Accident · No injuriesLimited investigationFinal reportLake LA-4 · Cool Lake, AKThe pilot stated that during the takeoff on the Lake the aircraft would not lift off the water and he lost directional control of the aircraft causing it to collide with the Lake shore.Jul 16, 1987 · N1135L · Substantial damageNTSB SEA87IA139Incident · No injuriesIncident investigationFinal reportBeech 55 · Rigby, IDDuring descent for landing, with both engines being fed from the right main fuel tank, a loss of power occurred due to fuel exhaustion. A forced landing was made on a wheat field and during landing rollout the aircraft struck a ditch. Investigation revealed…Jul 15, 1987 · N321MB · Minor damageNTSB MKC87LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Adams, NEAfter a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation…Jul 15, 1987 · N8097S · Substantial damageNTSB MKC87LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Satanta, KSDuring the takeoff ground run on an aerial application operation, the right main gear leg separated approximately 10 inches above the axle. Acft became uncontrollable and struck the terrain. Post acc examination disclosed no defects which may have assisted…Jul 15, 1987 · N4954R · Substantial damageNTSB LAX87LA268Accident · No injuriesLimited investigationFinal reportCessna 150G · Oakland, CAAt the end of a cross country flt, the plt had just been cleared to land when the engine sputtered then quit. Unable to land at the arpt the plt made an emergency landing on a road where the acft collided with the terrain and nosed over. Inspection of the…Jul 15, 1987 · N3487J · Substantial damageNTSB LAX87FA267Accident · 4 fatalField investigationFinal reportCessna T210L · Marina Del Rey, CAWeather at dept airport was clouds at about 900 ft with tops at 2,400 ft. based on ATC transcripts and the recorded radar flight path, the flt entered the clouds about 1 mile from the end of the runway. Shortly thereafter the flt entered the los angeles tca.…Jul 15, 1987 · N7JT · DestroyedNTSB FTW87FA170Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Mc Kinney, TXOn the third touch and go landing, while on the downwind leg of the approach, the pilot switched fuel tanks and shortly thereafter the engine failed. The pilot attempted 3 to 4 times to restart the engine by switching fuel tanks and activating the boost pump.…Jul 15, 1987 · N28157 · Substantial damageNTSB BFO87LA047Accident · Minor injuriesLimited investigationFinal reportHiller FH-1100 · Capron, VAThe plt made a 60 mph power descent landing apch. When the helicopter descended to a height of about 10 ft AGL, the plt raised collective and applied left rudder pressure. The helicopter abruptly turned right. According to the plt, the helicopter did not…Jul 15, 1987 · N590FH · Substantial damageNTSB ATL87LA214Accident · No injuriesLimited investigationFinal reportCessna 150J · Higginsport, OHThe pilot reported that the aircraft skidded off the runway into a piece of parked farm equipment. The sod runway surface was wet. The pilot further reported that the right wing rose and the a/c veered off the runway. The pilot was unable to maintain…Jul 15, 1987 · N61107 · Substantial damageNTSB ATL87LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Middlefield, OHThe student plt's seat slid back during the takeoff roll, following a touch-and-go ldg. The student lost directional control and the airplane ran off the left side of the rwy. The airplane impacted a ditch and nosed over. Post-crash exam of the seat assy by a…Jul 15, 1987 · N4649M · Substantial damageNTSB ATL87FA212Accident · Serious injuriesField investigationFinal reportPiper PA-28 · Elberton, GAThe plt noted a progressive loss of pwr that began drg the climb to cruise. He diverted back toward the dep arpt & atmtdto restore pwr by activating the boost pump, moving the mixture to full rich, switching fuel tanks & applying carb heat. However, the eng…Jul 15, 1987 · N5502F · Substantial damageNTSB NYC87FA204Accident · 4 fatalField investigationFinal reportPiper PA-30 · Lincolnville, METhe plt was making an approach to knox county arpt, rockland me and after receiving a wx report from UNICOM that the local wx was below approach minimums he indicated that he would make a missed approach. There was no further communications from the acft. A…Jul 14, 1987 · N7617Y · DestroyedNTSB MKC87FA138Accident · Serious injuriesField investigationFinal reportAero Commander 500-B · Mason City, IAThe airplane was in a normal appearing climb after takeoff when it pitched up to a 70 to 80 degree attitude, stalled, dropped the right wing, then leveled the wings and hit the ground in a near-flat attitude. The weight and CG were within limits. No preimpact…Jul 14, 1987 · N9391R · DestroyedNTSB MIA87LA206Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hastings, FLThe plt stated that he had just lifted from the 2300 ft wet grass strip, where he estimated the grass to be about 6 in to 1 ft high, when he sustained a partial power loss. The acft struck an embankment at the end of the rwy & sheared the gear. Air temp in…Jul 14, 1987 · N4647F · Substantial damageNTSB FTW87FA168Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Jenks, OKAlthough it was determined that the engine failed due to fuel exhaustion, the exact sequence of events that led to this event was not determined. The pilot reported that the aircraft was out of fuel over the radio and no fuel was found in the aircraft. There…Jul 14, 1987 · N1976T · Substantial damageNTSB FTW87DRA07Accident · Minor injuriesFinal reportAir Tractor AT-301 · Anahuac, TXThe acft was substantially damaged when it encountered soft terrain and flipped over during a forced landing. The forced landing was executed following a complete loss of eng power during a swath run on an aerial application flight. The cause of the eng…Jul 14, 1987 · N36503 · Substantial damageNTSB DEN87LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Worland, WYThe plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over.Jul 14, 1987 · N4237Z · Substantial damageNTSB CHI87LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Madison, WIThe instructor (CFI) & pvt plt (student) were on a renter's check-out flt to familiarize the student with a Cessna 172. While practicing landings, tower psnl provided a windshear alert. Drg an apch to land, the acft went into a high sink rate over the apch…Jul 14, 1987 · N2501L · Substantial damageNTSB ATL87LA211Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Raleigh, NCThe pilot was vectored for landing on runway 23R behind a Boeing 727. The approach controller advised the pilot that he could land on 23L if he preferred but the pilot elected to continue with the approach to 23R. The tower controller cleared the flight to…Jul 14, 1987 · N80929 · DestroyedNTSB ATL87FA210Accident · No injuriesField investigationFinal reportEmbraer EMB-120 · Atlanta, GAThe commuter airline pilot competency/proficiency check flight was progressing normally, according to the crew, until the sound of the propellers contacting the runway interrupted the routine. No mechanical, electrical, or hydraulic problem was found. The…Jul 14, 1987 · N211AS · Substantial damageNTSB ATL87DEK01Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Columbus, OHThe pilot taxied off an unlighted taxiway into a large drainage ditch while taxiing to a parking ramp. The pilot thought he was on the taxiway but the right landing gear was on a portion of the drainage ditch retaining wall. The rt landing gear collapsed. The…Jul 14, 1987 · N127GS · Substantial damageNTSB ANC87FA097Accident · 1 fatalField investigationFinal reportPiper PA-18 · Kasilof, AKThe student pilot and his non-pilot passenger/father were flying along a salt water beach looking for signs of a recent oil spill, when the pilot saw a fishing net in the water that he wanted a closer look at. He made two 180 degree turns at an altitude of…Jul 14, 1987 · N54106 · Substantial damageNTSB NYC87LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mattituck, NYDrg arrival, the plt tried to contact UNICOM, but was unable. He said he circled the 2200 ft rwy, but was unable to see the windsock due to reduced visibility with haze. He elected to land on rwy 19. The acft touched down about 500' from the departure end.…Jul 13, 1987 · N36509 · Substantial damageNTSB NYC87LA201Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Huntingdon, PAThe flight encountered poor visibility while at cruise altitude. The pilot decided not to continue flight and landed on a football field. During roll out, the right main gear fell into a drain hole to the side of the field causing the aircraft to turn right…Jul 13, 1987 · N33576 · Substantial damageNTSB NYC87IA202Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Boston, MADelta flt 752, a Boeing 767, was nr the outer marker (om) on an ILS rwy 22L apch when the flt control sys sensed an uncommanded go-arnd. The acft drifted rgt of the localizer for ovr 1 min. At abt 1000' AGL, rwy 22R was sighted to the left & a normal landing…Jul 13, 1987 · N106DA · No damageNTSB MIA87FA205Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Palatka, FLWitnesses stated that they heard the acft's eng sounding rough just before it crashed into the trees. Another witness stated that he noticed that there were flames & smoke coming from the left side of the plane. A tail pipe assembly was found on the ramp at…Jul 13, 1987 · N93664 · DestroyedNTSB LAX87LA287Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103A · Maricopa, AZThe plt rprtd that after gliding in a sink for svrl minutes, he began flying about 500' above a north-south mtn ridge in search of lift. While on a northerly heading, the left wing rose & the plt interpreted this as lift. He turned to the left (west) which…Jul 13, 1987 · N103BG · DestroyedNTSB LAX87FA264Accident · 2 fatalField investigationFinal reportRyan ST3KR · Firebaugh, CAAt about 1650 PDT, the plts of 2 Ryan ST3KR acft depd coalinga on a flt to los banos, CA. At about 1709 PDT, the plt of N48777 made a hand signal to the other plt, pointed toward the ground & entered 'a normal glide.' Subsequently, the plt of N48777…Jul 13, 1987 · N48777 · DestroyedNTSB LAX87DUG05Accident · Serious injuriesFinal reportEipper Quicksilver MX II · Corona, CAWhile attempting to land on runway 25 at the Corona airport, Corona, California, in gusting wind conditions, the aircraft stalled and collided with the terrain. The pilot said that the 'extreme gusty wind conditions' combined with a very light and stable…Jul 13, 1987 · N4628G · Substantial damageNTSB FTW87DRA09Accident · No injuriesFinal reportWeatherly 201C · Louise, TXThe acft was loaded with aprx 1100 lbs of fertilizer & the plt attempted to takeoff from a pvt strip on a 'still & muggy' day with a temp of about 95 deg. He rprtd that during the takeoff roll, he opened the dump gate when the acft was midway down the rwy to…Jul 13, 1987 · N1296W · Substantial damageNTSB DEN87LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · New Rockford, NDThe student plt was on a cross country flight. He noticed a drop in engine RPM. An engine vibration began and another aircraft reported seeing a smoke trail. The plt elected to make an off airport landing and selected a wheat field. The plt made an emergency…Jul 13, 1987 · N95876 · Substantial damageNTSB DEN87LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Tierra Amrilla, NMNo witnesses were found who had seen the accident. The man believed to be the plt gave the investigating police officer an assumed name. The wreckage dissappeared soon after the crash and has not been found to date. The acft attempted a takeoff with four…Jul 13, 1987 · N84704 · Substantial damageNTSB CHI87LA165Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Lake Monroe, INThe float equipped acft took off from Lake Monroe with 2 rated plts on board. The plt-in-command (PIC) stated that the takeoff distance may have been about 20% longer than normal. He said that after climbing about 200 to 250 ft, the coplt began a rgt turn,…Jul 13, 1987 · N4365C · Substantial damageNTSB CHI87LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Vincennes, INThe pilot attempted to takeoff with the fuel tank selector selected to an empty tank. Shortly after lift-off the engine stopped and the acft skidded across a road and struck an embankment.Jul 13, 1987 · N8155A · Substantial damageNTSB ATL87FA209Accident · 1 fatalField investigationFinal reportCessna 152 · Yanceyville, NCThe plt was engaged in low alt commercial photography. Witnesses had observed the acft operating at a very low altitude in the area for the past two or three days. The witness closest to the crash site related that the acft would make a straight pass near a…Jul 13, 1987 · N4869B · DestroyedNTSB SEA87LA156Accident · No injuriesLimited investigationFinal reportBoeing IB75A · Spokane, WAThe plt rprtd that when he landed, the wind was from 190 deg at 6 gusting 12 KTS. Drg the landing roll, after slowing to an estimated 15 KTS, the acft encountered a gust of wind which caused 'the right wing to dip.' Subsequently, the acft 'rotated' about 60…Jul 12, 1987 · N400JT · Substantial damageNTSB SEA87FA135Accident · 2 fatalField investigationFinal reportMaule M-4-210C · Sitka, AKPlt was on local VFR flight plan. Witnesses observed acft flying at low level along beaches. Later, witness saw smoke rising from wooded terrain about two miles inland from nearest beach. Investigation revealed no evidence of inflight failure of malfunction…Jul 12, 1987 · N9812M · DestroyedNTSB MKC87LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT301A · Baderville, MODuring an aerial application operation, the pilot experienced a violent engine vibration. He reduced power and attempted an emergency ldg. Acft nosed over on landing. The pilot exited aircraft through side window. Acft caught fire and was destroyed.…Jul 12, 1987 · N3169N · DestroyedNTSB MKC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ottawa, KSDuring a night flight the aircraft's engine lost partial power. The pilot elected to make a precautionary landing in a farm field. During landing the aircraft's right wing struck a fence. An engine teardown revealed a failed exhaust valve on the number 3…Jul 12, 1987 · N5701U · Substantial damageNTSB LAX87DVG08Accident · Serious injuriesFinal reportBudde Cassutt CB-1 · Winter, CAA homebuilt cassutt racer crashed during initial takeoff climb after a loss of power. The pilot assembled the experimental racing airplane in preparation for a flight to an air race and had completed a series of starts and run-ups. 'Everything checked normal'…Jul 12, 1987 · N102 · Substantial damageNTSB FTW87LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Quitman, TXDuring final approach for landing, the pilot allowed the airspeed to drop. The aircraft stalled at approximately 30 to 40 feet AGL. Substantial damage occurred when the aircraft bounced, cartwheeled and slid to a stop backwards 300 feetbeyond the threshold.Jul 12, 1987 · N5594T · Substantial damageNTSB CHI87LA167Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Springfield, MITwo hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…Jul 12, 1987 · N1505F · 2 aircraft · Substantial damageNTSB CHI87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chelsea, MIThe pilot and three passengers attempted a takeoff from a 1800 foot sod, upsloping runway with tall, wet grass. Density altitude was 2700 feet. As the aircraft climbed out of ground effect the pilot said the engine sounded 'funny' and aborted the takeoff. The…Jul 12, 1987 · N2904A · Substantial damageNTSB CHI87FA162Accident · 5 fatalField investigationFinal reportCessna 180 · New Brighton, MNWitnesses observed the floatplane start a climbing left turn shortly after becoming airborne from a water takeoff. The aircraft's right wing dropped and the aircraft dove into the water where it struck the surface right wing first, flipped inverted and sank.…Jul 12, 1987 · N5027E · DestroyedNTSB ATL87LA208Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Monroe, GAThe private plt was on his first flt of the day in a glider that he had not flown recently. He reported the takeoff, tow and traffic pattern as normal. He used the spoilers sparingly until he turned final. He was most surprised, he said, when one of the…Jul 12, 1987 · N7624 · Substantial damageNTSB ANC87LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Mcneil Cove, AKThe pilot and his passenger were flying at approximately 150 feet above the water near the shoreline when the pilot made a steep left climbing turn. The airplane stalled and crashed into the water. The pilot was not rated to fly seaplanes. No mechanical…Jul 12, 1987 · N4322E · Substantial damageNTSB ANC87FA095Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Sheep Mountain, AKThe pilot and his two passengers took off in a two place Piper PA-18 from a glacier after doing repair work on an aircraft that had crashed there earlier. Weather conditions were deteriorating as they approached their destination airstrip located in a nearby…Jul 12, 1987 · N159T · Substantial damageNTSB SEA87LA138Accident · No injuriesLimited investigationFinal reportCessna 185 · Lake Chelan, WADuring takeoff from the water the plt noticed a log protruding out of the water. The acft struck the log and the plt rotated prematurely, became airborne, and then descended striking the water hard.Jul 11, 1987 · N8593Q · Substantial damageNTSB NYC87LA200Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Bargaintown, NJThe pilot reported that during climb out and level off after a banner pickup, the engine would not produce sufficient power to sustain flight. After checking the carburetor heat and mixture, he released the tow ropes and established a glide. Subsequently, the…Jul 11, 1987 · N9085L · Substantial damage