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 LAX87LA282Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Rancho Calif, CAWhile landing on runway 12, the plt lost control of the Champion 7ECA and it collided with three other aircraft. About 31 mi northwest at riverside, CA, the 1755 PDT wind was from 290 deg at 9 KTS. A witness at the airport estimated the wind was from 270 deg…Jul 25, 1987 · N5144X · DestroyedNTSB LAX87LA279Accident · No injuriesLimited investigationFinal reportCessna 320B · Bermuda Dunes, CADrg a landing, the left main gear hit a raised lip at the apch end of the rwy & failed. The plt held the left wing off the rwy by using aileron until the acft slowed, then the acft drifted off the left side. The rwy lip had been created by construction on the…Jul 25, 1987 · N44RM · Substantial damageNTSB FTW87DRD10Accident · No injuriesFinal reportCessna T188C · Oak Grove, LAThe pilot was attempting to take off with an over gross weight condition. The wheels left the surface only after the ground fell away into a bayou. The aircraft then remained airborne until it collided with bayou's opposite bank but did not climb during this…Jul 25, 1987 · N2092J · DestroyedNTSB DEN87LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe plt was practicing touch-and-go landings on rwy 26. He estimated the wind to be 180 deg at 8 KTS. The plt said that on the third landing attempt, a 15 kt gust of wind caused the acft to drift to the right. He attempted to correct with left aileron and…Jul 25, 1987 · N52MA · Substantial damageNTSB DEN87LA193Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Pisek, NDThe plt was preparing to spray a potato field with a mixture of water and 2 lbs of 'blight-out.' He made one observation pass over the field to check for obstructions and noticed two sets of power lines, one on the east side of a road and the other on the…Jul 25, 1987 · N2037J · DestroyedNTSB ATL87LA224Accident · No injuriesLimited investigationFinal reportCessna R182 · Calera, ALThe airplane collided with trees during a forced ldg attempt. The plt reported that he observed the fuel gauges indicating near empty shortly after departure. As he executed a 'steep' 180 deg turn back toward the arpt, the engine sputtered and 'quit'. During…Jul 25, 1987 · N737ZZ · Substantial damageNTSB SEA87LA147Accident · No injuriesLimited investigationFinal reportCessna T210K · Bellevue, WAAfter tkof, the plt leveled at about 1500' & adjusted the pwr to a low cruise setting. A short time later, the eng bgn missing & subsequently lost all pwr. The plt followed the emerg procedures, but was unable to restart the eng. He manuevered the acft to…Jul 24, 1987 · N5768J · Substantial damageNTSB SEA87LA146Accident · No injuriesLimited investigationFinal reportDavis Starship Alpha · Burley, IDA loss of power occurred shortly after takeoff at about 100 feet AGL. Due to obstacles in the pilot's flight path landing had to be made in a river where the aircraft was substantially damaged. The reason for the power loss could not be determined.Jul 24, 1987 · N5531N · Substantial damageNTSB NYC87LA210Accident · Minor injuriesLimited investigationFinal reportBell 47G3 · Marston Mills, MAThe helicopter reached an altitude of about 50 feet when a loss of power was experienced. Immediately the pilot set up for an emergency landing and set the helicopter down. The aircraft, however, collided with the ground hard and incurred substantial damage.…Jul 24, 1987 · N6355 · Substantial damageNTSB LAX87LA280Accident · No injuriesLimited investigationFinal reportCessna 320D · Banning, CAWhile taxiing to the runway, the right main and nose gear traveled off of the taxiway. The plt added power to the right engine and applied left brake, however, the plt stated that when power was added, the ground speed also increased. The acft traveled off…Jul 24, 1987 · N3322Q · Substantial damageNTSB LAX87LA278Accident · No injuriesLimited investigationFinal reportCessna 182A · Strathmore, CADuring a cross country flight, upon landing, the aircraft touched-down approx 500 ft from the approach end of the rwy. The plt lost directional control of the acft when he stated that the brakes failed to respond. The runway on which the acft landed is approx…Jul 24, 1987 · N3884D · Substantial damageNTSB LAX87FA281Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Monterey, CALoss of control of the aircraft, by the pilot, while excuting a missed approach.Jul 24, 1987 · N82793 · DestroyedNTSB FTW87LA188Accident · No injuriesLimited investigationFinal reportBeech 35 · Richwood, TXThe acft impacted a tree after a forced landing to a field near Richwood, Texas. The pilot stated that he was on final approach to the airport when the engine quit due to fuel starvation. The fuel selector was on the right tank at the time of the accident.…Jul 24, 1987 · N470MC · Substantial damageNTSB FTW87FA174Accident · 1 fatalField investigationFinal reportCessna 421C · Crystal City, TXThe pilot landed downwind on his private strip. The exact amount of the tailwind could not be determined. A thunderstorm was located just to the east of the runway and could have readily given N448 a strong tailwind. The aircraft touched down 390 feet beyond…Jul 24, 1987 · N448 · DestroyedNTSB CHI87DER11Accident · 1 fatalFinal reportHendrickson Polliwagon · Ely, MNWhile on downwind to the airport the aircraft departed level flight and impacted in a wooded area in an approximate 80 degree nose down attitude. The aircraft was destroyed and the plt who was the sole occupant, received fatal injuries. This was an…Jul 24, 1987 · N48876 · DestroyedNTSB ANC87LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot was reconnoitering for game animals when he overlooked the rising terrain until he could no longer outclimb or turn away from it. The acft collided with a large rock and came to rest in a grass area.Jul 24, 1987 · N2571H · Substantial damageNTSB MKC87LA145Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Ulysess, KSDuring a helicopter aerial application operation, acft suffered a main rotor system hub failure. PIC was unable to control the acft and an uncontrolled descent resulted. Acft struck the terrain and was substantially damaged and the PIC suffered minor…Jul 23, 1987 · N67139 · Substantial damageNTSB MIA87FA213Accident · Serious injuriesField investigationFinal reportCessna 152 · Hollywood, FLWhile in the traffic pattern on an instructional flt, the instructor (CFI) elected to demonstrate a short field lndg, followed by a short field takeoff. The student rprtd that after lift-off on the short field takeoff, the CFI flew the acft to a nose hi…Jul 23, 1987 · N101FP · DestroyedNTSB LAX87LA276Accident · No injuriesLimited investigationFinal reportBeech A36TC · Los Angeles, CAJust after takeoff at an altitude of aprx 50 ft AGL, the engine quit. The plt landed the acft straight ahead and was unable to stop before colliding with a fence. Inspection of the engine revealed no mechanical failures or malfunctions.Jul 23, 1987 · N3707Z · Substantial damageNTSB FTW87FA175Accident · No injuriesField investigationFinal reportCessna 337B · Laporte, TXThe aircraft had been sitting outside in the wx since its last annual inspection on 12/1/84. After purchasing the aircraft, the pilot (who is an aircraft and powerplant maintenance technician) examined it and a ferry permit was issued by FAA for the proposed…Jul 23, 1987 · N2315S · Substantial damageNTSB ATL87LA222Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Huntsville, ALThe helicopter impacted the water during a low-altitude turn over a river. The plt made a low pass to the south over an island at about 30 ft AGL, to show the island to the policewoman/traffic observer onboard. As he was making a climbing right turn at about…Jul 23, 1987 · N972B · Substantial damageNTSB SEA87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · The Dalles, ORThe pilot was at 50 feet AGL on final approach to land at his private airstrip when he lost control. Reportedly, a gust of wind turned the aircraft 180 degrees. The aircraft descended and struck trees and the ground. Winds were reported variable at 40 to 45…Jul 22, 1987 · N5030H · Substantial damageNTSB SEA87FA149Accident · 4 fatalField investigationFinal reportAero Commander 560-A · Ashland, ORThe non-instrument rated pilot took off in overcast weather conditions and flew toward a mountain pass that was obscured in clouds. When the flight failed to arrive at the destination, a search was initiated and the wreckage located in a box canyon on the…Jul 22, 1987 · N2794B · DestroyedNTSB NYC87LA208Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Bedford, MADuring a practice autorotation with power recovery, the rotor RPM bled off. Directional control was lost and the helicopter turned several times before hitting the ground. The helicopter rolled to the left and came to rest on its side.Jul 22, 1987 · N8384F · Substantial damageNTSB MKC87LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, MOThe instructor and the student were making a landing on a short grass runway. The instructor stated they landed fast and were not able to stop. He considered a go-around but decided sufficient runway did not remain to perform the go-around. The airplane…Jul 22, 1987 · N47354 · Substantial damageNTSB MIA87LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Orlando, FLShortly after rotation a wasp landed on the passenger. In his attempt to kill it he inadvertently contacted the yoke, causing the acft to descent onto the rwy. After the propeller contacted the rwy the plt aborted the takeoff, & landed. The acft continued off…Jul 22, 1987 · N42921 · Substantial damageNTSB LAX87LA277Accident · No injuriesLimited investigationFinal reportCessna A185F · Chandler, AZThe CFI indicated that the tailwheel began to shimmy during rollout. As forward control yoke pressure was applied the shimmy went away, however, as the acft began to slow down, the tailwheel was lowered and began to shimmy again. As the acft continued to slow…Jul 22, 1987 · N252W · Substantial damageNTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…Jul 22, 1987 · N5510X · Substantial damageNTSB DEN87LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Romeo, COThe plt reports that the acft encountered a downdraft during the turn around following a swath run. The aircraft began to settle and collided with the ground, bounced, hit a second time and nosed over. The aircraft was loaded with 280 gals of amine and 70…Jul 22, 1987 · N5398 · Substantial damageNTSB CHI87LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit, MIOn touchdown the aircraft ballooned and bounced up about 5-7 feet off the runway. The aircraft then landed on the nose wheel and the prop struck the ground.Jul 22, 1987 · N757JG · Substantial damageNTSB BFO87LA049Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Gordonsville, VAThe plt began taking off from a downward sloping, 2300 ft rwy in light winds. The rprtd temp was 92 deg; the density alt was about 2500 ft. the plt rprtd the acft accelerated normally to V1 speed; however, it hit the tops of trees about 350 to 500 ft beyond…Jul 22, 1987 · N9764J · DestroyedNTSB ATL87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Edmund, SCThe CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI…Jul 22, 1987 · N45648 · Substantial damageNTSB ANC87LA104Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Charley River, AKThe pilot stated that during the takeoff roll he struck a hidden tree stump; he lost directional control of the aircraft causing the plane to nose over.Jul 22, 1987 · N1023H · Substantial damageNTSB SEA87LA143Accident · No injuriesLimited investigationFinal reportCessna 170B · Coeur D'Alene, IDOn initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…Jul 21, 1987 · N3063A · Substantial damageNTSB SEA87FA145Accident · 2 fatalField investigationFinal reportCessna T210N · Avery, IDWhile in cruise at 15000 ft MSL, plt requested ATC deviation around tstm shown on acft stormscope. After passing, ATC gave vector to rejoin airway. Plt requested further deviation around another cell. Radio and radar contact were then lost. Investigation…Jul 21, 1987 · N6326Y · DestroyedNTSB MKC87LA143Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Lilbourn, MOWhile returning from an aerial application flight, the aircraft's engine lost power and quit. The pilot made a forced landing in a soft field and nosed over. Post accident inspection revealed a cylinder was cracked. Several hours after the accident, the…Jul 21, 1987 · N8911H · DestroyedNTSB MKC87DCQ03Accident · 1 fatalFinal reportPiper PA-36 · Nickerson, KSAfter a swath run to the east, the acft was observed to pull up & begin turning back to the west. The witness then saw a big cloud of smoke. She did not see spray coming from the acft drg the last swath run, although her vision was limitedby foliage & bldgs.…Jul 21, 1987 · N9935P · DestroyedNTSB FTW87DRG04Accident · Minor injuriesFinal reportAir Tractor AT301 · Santa Rosa, TXThe pilot was dusting a sugar cane field which bordered a dirt road with parallel electrical transmission lines. The pilot had been terminating his swath runs by flying underneath the electrical wires at the edge of the field. To prevent becoming a hazard to…Jul 21, 1987 · N4407S · DestroyedNTSB DEN87LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Fargo, NDThe plt was spraying a field with orthine, used to exterminate grasshoppers. The plt said he was making his last pass at the field and was flying into a setting sun. He said he did not see the powerline. The acft struck the powerline and the plt made a crash…Jul 21, 1987 · N9750P · Substantial damageNTSB CHI87FA176Accident · 1 fatalField investigationFinal reportCessna 402B · Chicago, ILFailure of maintenance personnel to perform proper installation of the left throttle linkage.Jul 21, 1987 · N3742C · DestroyedNTSB CHI87DEP10Accident · Serious injuriesFinal reportRobinson Avid Flyer · Tomah, WIThe homebuilt, hiwing acft had just been assembled by the owner/plt & was readied for its 1st flt. After takeoff from rwy 25, the acft entered a climb, turned back over the arpt & crossed over the rwy. Subsequently, it was maneuveredabout 500 to 800 ft south…Jul 21, 1987 · N228MC · DestroyedNTSB ATL87LA220Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Columbus, OHThe plt experienced a loss of directional control on ldg as the tailwheel touched down, and he executed a go-around. On the 2nd ldg attempt, the airplane veered off the rwy, traveled across a grassy area, and impacted a parked C-172. Post-crash exam of the…Jul 21, 1987 · N443WB · Substantial damageNTSB MIA87LA211Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Greenwood, MSShortly after takeoff from a 1,800 ft grass strip on a 93 degree f day, the acft, loaded with 1,500 pounds of chemical, began to settle. It then touched down in a field, nosed over & came to rest inverted. The plt stated there was no eng failure or…Jul 20, 1987 · N10AA · Substantial damageNTSB LAX87LA275Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Milpitas, CAWhile climbing to cruise plt heard a loud knocking noise followed by 'violent vibrations' & a loss of power. Plt made a frcd lnding in a newly excavated construction site & went over an embankment. Inves revealed deformation of the #4 cylinder valve cover. #4…Jul 20, 1987 · N91338 · Substantial damageNTSB LAX87LA273Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Lake Tahoe, CAWhile taxiing to the rwy, the plt stated that the right brake failed. The acft rolled off the taxiway and collided with a transformer. Inspection of the brake revealed that the brake linings were worn and that the piston in the hydraulic cylinder had traveled…Jul 20, 1987 · N28452 · Substantial damageNTSB LAX87DVD03Accident · Serious injuriesFinal reportTemco TT-1 · Hayward, CAWhile on final approach after an extended descent at idle, the engine flamed out as the pilot advanced the throttle to reduce the rate of descent. During a forced landing short of the airport, the aircraft struck a light pole and telephone wires. After coming…Jul 20, 1987 · N8K · DestroyedNTSB FTW87LA171Accident · No injuriesLimited investigationFinal reportCessna 152 · Graham, TXThe approximate half tanks of fuel which the student pilot reportedly observed on board during his preflight inspection (and which should have been on board at that time) apparently leaked out through the broken fuel line fitting at the carburetor while the…Jul 20, 1987 · N64935 · Substantial damageNTSB DEN87LA191Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Portales, NMThe plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,…Jul 20, 1987 · N6419Z · Substantial damageNTSB CHI87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bad Axe, MIDuring a demonstration of an aborted takeoff, the 'power was cut' after the aircraft accelerated to about 75 mph. At about that time, the aircraft encountered a gust of wind and became airborne. A power recovery was initiated, but the aircraft touched down in…Jul 20, 1987 · N8049Y · Substantial damageNTSB CHI87LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Troy, MIThe plt lndd at ngt & taxied the acft to a hangar area for a passenger stop. After the passenger deplaned, the plt proceeded to make a u-turn around a t-hangar & onto an automobile service road that wasn't normally used for acft. Whilethe plt was attempting…Jul 20, 1987 · N6341D · Substantial damage