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 ATL87LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Andalusia, ALThe CFI was giving instruction to a beginning student. During preflight he noted that the lt tank fuel gauge indicated 'full' while the rt tank gauge inidated '1/2 full '. After about 40 minutes of flying the engine began to run rough, during climbout after a…Jun 1, 1987 · N22553 · Substantial damageNTSB NYC87LA157Accident · No injuriesLimited investigationFinal reportPiper J-3 · Mercer, PAThe flight departed from runway 27 uphill with the wind at 180 degrees in uncut grass. There were trees on the left side of the departure end of the runway. The plt stated that he lost lift as he approached the departure end of the runway.May 31, 1987 · N38346 · Substantial damageNTSB MIA87LA199Accident · No injuriesLimited investigationFinal reportLet L-13 · Plymouth, FLThe plt misread the altimeter by 1000 ft when the flt entered the initial point of the traffic pattern. He then began circling to dissipate alt & realized that the acft was low. He then proceeded downwind, turned base then final & landed hard buckling the…May 31, 1987 · N99946 · Substantial damageNTSB MIA87LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Wales, FLThe plt selected 20 degrees of flaps for a short field takeoff. At aprx 75 ft AGL he raised them 10 degrees resulting in a nose high altiude. The acft then stalled and crashed uncontrolled in a nose low altitude causing the nose gear to collapse. The acft…May 31, 1987 · N63597 · Substantial damageNTSB MIA87LA167Accident · No injuriesLimited investigationFinal reportNorth American Navion · Defuniak Spring, FLThe plt reported that after takeoff, at aprx 500 ft, the eng lost power. He then turned on the electric fuel pump in an attempt to restore it. Unable, he then elected to land the acft, during which, it collided with trees, fell to the ground & came to rest.…May 31, 1987 · N4007K · Substantial damageNTSB DEN87LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monticello, UTThe plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…May 31, 1987 · N7744P · Substantial damageNTSB CHI87LA137Accident · No injuriesLimited investigationFinal reportAircoupe A-2-DEX · Iola, WIThe aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a…May 31, 1987 · N6509Q · DestroyedNTSB CHI87DEX06Accident · Minor injuriesFinal reportCessna 172E · Huntingburg, INWhile on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…May 31, 1987 · N5514T · Substantial damageNTSB BFO87FIG04Accident · No injuriesFinal reportAyres S2R-T15 · Grantsville, MDThe acft was second in a flt of three spraying forest area with dimilin when it contacted a power line suspended between two hilltops. The prop severed the single strand of cable and shortly after the engine lost power. The plt maneuvered for an emgcy lndg,…May 31, 1987 · N40184 · Substantial damageNTSB SEA87LA105Accident · No injuriesLimited investigationFinal reportBeech BE18 · Glenns Ferry, IDWhile at crz, plt encountered turbulence. Shortly thereafter, experienced elevator control difficulties and yoke vibrations. Plt declared emerg, requested vector to closest airport. Mtn home afb rapcon gave vector to Glenns Ferry airport. On approach, plt…May 30, 1987 · N503CW · Substantial damageNTSB NYC87LA156Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Cooperstown, NYThe pilot stated he departed farmingdale with two plus hours of fuel on board. After approximately 40-50 minutes of flight, the right low fuel pressure light and right fuel pump light flashed steady red. The pilot rechecked his calculations and determined he…May 30, 1987 · N59728 · Substantial damageNTSB LAX87LA224Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAWhile on final apch to lnd on rwy 28, a glider (Schweizer sgs 2-32, N242DB) & a tow plane (Bellanca 7KCAB, N88314) collided in flt at an alt of about 200' AGL. The tow plane was returning fm a LCL tow mission & the glider was returningfm a LCL sightseeing…May 30, 1987 · N88314 · 2 aircraft · Substantial damageNTSB LAX87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Avenal, CAA Cessna 182G collided with trees during landing rollout on a dirt road. The pilot indicated during a telephone interview that the manifold pressure gradually dropped to 18 pounds. The aircraft was unable to maintain altitude and the pilot landed the aircraft…May 30, 1987 · N3274S · Substantial damageNTSB LAX87LA220Accident · No injuriesLimited investigationFinal reportRyan ST-A · Mariposa, CAAt the start of a pleasure flight, the plt reported that during the takeoff roll the acft started to veer to the left. The plt applied right rudder to correct, however, the acft did not respond before the left main left the edge of the rwy and dug in the soft…May 30, 1987 · N14954 · Substantial damageNTSB DEN87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wolf Point, MTThe pilot was on approach to his private strip at approxiamtely 25 feet AGL when the aircraft stalled. The aircraft dropped onto the runway, the pilot added full power attempting to recover, the left wing dipped and struck the ground.May 30, 1987 · N9128D · Substantial damageNTSB DEN87LA137Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Sawyer, NDThe commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private…May 30, 1987 · N1677V · Substantial damageNTSB CHI87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Plymouth, INWhile on final approach about 200 feet from the end of the runway, the right front seat passenger told the pilot she thought she saw a deer. The pilot added power for a possible go-around. Since he did not see any deer, the pilot continued his landing. He…May 30, 1987 · N8231D · Substantial damageNTSB CHI87IA135Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Chicago, ILAmerican flt 637 was on departure from Chicago-o'hare intl arpt (ord), climbing thru 7300' MSL, when it passed American flt 393 with aprx 500' vertical sepn & 1/4 mi horizontal sepn. This occurred after an air traffic assistant, who was working the clnc…May 30, 1987 · N224AA · No damageNTSB BFO87LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fredericksburg, VAThe CFI stated that drg tkof, the acft accelerated slower than normal. After rolling abt 1800', the student rotated the acft to a normal climb attitude & it climbed aprx 5' to 10'. At about that time, the CFI noted that the airspeed indcn had dropped to abt…May 30, 1987 · N25448 · Substantial damageNTSB BFO87DID03Accident · No injuriesFinal reportHam Wizard · Chesapeake, VADrg flt, a portion of the exhaust stack broke off & struck the wooden prop. Aprx 1/3 of the prop separated & a severe vibration started. The plt shut down the eng & headed for an open field. Due to lack of altitude, he was barely able to clear nearby trees.…May 30, 1987 · N39583 · Substantial damageNTSB ATL87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Murfreesboro, TNWhile climbing thru 6,000 ft, the plt heard & felt a 'thud' & then realized the eng had failed. Drg a subsequent emerg landing in a muddy corn field, the nose gear mired in soft terrain & the acft nosed over. A teardown of the eng revealed the crankshaft was…May 30, 1987 · N4965Y · Substantial damageNTSB ANC87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe pilot landed on an asphalt surfaced runway with a Cessna 185 airplane that had been modified to accept extremely large 'tundra' tires, which are intended primarily for off-airport and gravel runway landings. The pilot lost directional control during the…May 30, 1987 · N177BM · Substantial damageNTSB SEA87LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Prospect, ORThe acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…May 29, 1987 · N4173F · Substantial damageNTSB SEA87LA103Accident · No injuriesLimited investigationFinal reportAyres S2R · Walla Walla, WADuring takeoff run the right main gear collapsed. The right wing dropped and the aircraft spun to the right. The plt discovered that the right main gear failed at the weld. The pilot, who is also an a & p mechanic, stated that this was an original weld from…May 29, 1987 · N3693X · Substantial damageNTSB NYC87DGT01Accident · Minor injuriesFinal reportSchleicher ASW-20L · Mt Holley Sprgs, PAJust before touchdown, during an off-arpt landing, the plt tried to extend the flaps from a 30 deg position to full down (55 deg). He said that due to his short stature & seat position, he had difficulty positioning his left arm to do this. As he tried to…May 29, 1987 · N705X · Substantial damageNTSB MKC87LA113Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Paragould, AREn route to a local aerial application operation PIC experienced a total engien failure. During subsequent emergency landing in a farm field the acft was substantially damaged. No reason could be determined for the engine failure.May 29, 1987 · N4197X · Substantial damageNTSB MIA87IA166Incident · No injuriesIncident investigationFinal reportBoeing 747-245F · Caracas, VenezuelaFlight experienced leakage of a five gallon container of glutaraldehyde listed by the shipper as a class 8 corrosive on the aircrafts upper deck enroute miami, Florida to Caracas, venezuela. The chemical was later found not to be corrosive and the aircraft…May 29, 1987 · N813FT · Minor damageNTSB CHI87LA134Accident · No injuriesLimited investigationFinal reportCessna U206C · Grand Rapids, MNThe plt rprtd that drg a water lndg, the left float dug in & caused the left wing to strike the water. Subsequently, the acft nosed over. The plt did not rprt any abnormal wind or water condition.May 29, 1987 · N3970G · Substantial damageNTSB ATL87LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Trenton, KYThe dual instruction flight was practicing soft field landings at a private grass strip. The aircraft stalled during a go-around attempt on the second approach when the student pilot executed a steep pullup to clear powerlines. The aircraft pitched down,…May 29, 1987 · N68163 · DestroyedNTSB ANC87LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe private pilot elected to land at an abandoned arpt on an unmaintained dirt taxiway adjoining the gravel rwy inorder to reduce the crosswind component. The acft hit a soft spot during the landing roll and nosed over. The U.S. Dept of commerce's Alaska…May 29, 1987 · N2940C · Substantial damageNTSB SEA87FA106Accident · 1 fatalField investigationFinal reportHiller UH-12E · Shelton, WAThe pilot was properly certificated for the flight; however, due to operator insurance restrictions, all prior commercial flights had required the owner/operator to accompany this pilot, therefore this was the pilot's first commercial flight as sole pilot.…May 28, 1987 · N28875 · DestroyedNTSB MIA87LA165Accident · No injuriesLimited investigationFinal reportCessna 210L · Tallahassee, FLThe eng quit aprx 6 miles from the arpt. During the landing roll following the forced landing the nose gear collapsed & the acft collided with trees. Imspection of the acft revealed that the fuel selector was positioned to the left tank which did not contain…May 28, 1987 · N121PL · Substantial damageNTSB ATL87DLQ02Accident · Minor injuriesFinal reportHughes 369HS · Hawesville, KYDuring a weed control spraying operation, the pilot experienced a power failure 45 feet above the ground. The autorotation attempt resulted in the helicopter impacting the ground on it's left side. The investigation disclosed that the flexible fuel line to…May 28, 1987 · N9180F · Substantial damageNTSB MIA87LA164Accident · 1 fatalLimited investigationFinal reportCessna 402C · Missing Acft, BahamasOn 5/27/87 at about 0915 EDT, the plt departed palm beach intl arpt (pbi) on a flt to marsh harbour, great abaco island, Bahamas. When the Acft did not arrive at the destination, a search was initiated. The Acft was not fnd & was presumed to have been…May 27, 1987 · N2652B · DestroyedNTSB LAX87LA218Accident · Serious injuriesLimited investigationFinal reportCessna 150L · San Jose, CAWhile on final apch to land on rwy 31R at night, the acft flew too low, struck trees, then collided with the terrain. The plt was taken to a hospital with serious injuries & a blood sample was drawn at 0205 PDT. A check of his blood showed an alcohol level of…May 27, 1987 · N6669G · Substantial damageNTSB FTW87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Grand Prairie, TXDuring landing roll the right main landing gear tire failed causing a loss of directional control. The acft departed the right side of the rwy, and the right main landing gear collapsed.May 27, 1987 · N41788 · Substantial damageNTSB FTW87FA130Accident · No injuriesField investigationFinal reportGrumman AA5A · Malakoff, TXThe acft impacted the terrain near Malakoff, Texas. Following an engine failure the pilot attempted to execute a forced landing to a road crossing a dam. The aircraft touched down and bounced into the lake. Examination of the engine revealed that the exhaust…May 27, 1987 · N26378 · Substantial damageNTSB FTW87FA129Accident · Serious injuriesField investigationFinal reportBeech B-60 · Wall, TXAcft was destroyed during an attempted off airport emergency landing following a dual eng failure while leveling off at crz flt. Plt stated that left eng, then right eng surged and quit as he was leveling off at 9000' MSL. At the time of the eng failures the…May 27, 1987 · N4314W · DestroyedNTSB DEN87LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Upton, WYThe plt reported completing a cross wind landing with strong gusts. While taxiing from landing, the wind lifted the acft from the right and it nosed over. The rwy used was 13, and the FBO reported winds as 210 degrees at 20 knots, gusting to 40 knots.May 27, 1987 · N2933C · Substantial damageNTSB ATL87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Erwin, NCThe acft impacted level grassy terrain short of rwy 04, while on short final during a practice short-field ldg. The CFI reported that the student plt had stabilized the acft on the appch at 70 mph; a high sink rate was subsequently encountered as the acft…May 27, 1987 · N1696T · Substantial damageNTSB ATL87LA151Accident · No injuriesLimited investigationFinal reportBeech A36-TC · Winder, GAThe plt reported experiencing a complete electrical failure shortly after takeoff. All systems were shut down and the plt declared an emergency. The flight descended to visual conditions for a landing at Winder. The plt shut down the engine and attempted a no…May 27, 1987 · N18HB · Substantial damageNTSB SEA87FA102Accident · 3 fatalField investigationFinal reportSocata TB10 · Battle Mountain, NVAfter receiving a weather briefing calling for mountains occasionally obscured, occasional moderate icing from 18000 ft & below, and ceilings across north & central Nevada, the noninstrument rated pilot filed a VFR flight plan and departed salt lake city for…May 26, 1987 · N20FU · DestroyedNTSB MKC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Carbondale, KSThe PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,…May 26, 1987 · N5868D · Substantial damageNTSB MIA87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-180D · Astatula, FLThe plt became disoriented and performed a precautionary landing. During the landing roll, the pilot taxied into a ditchand the nose gear collapsed.May 26, 1987 · N6406J · Substantial damageNTSB LAX87LA215Accident · No injuriesLimited investigationFinal reportCessna 150F · Bermuda Dunes, CAThe flt encountered strong head winds while cruising x-country at 6000 ft MSL. The engine lost power aprx 14 miles east of the intended destination and during descent toward the destination the power returned several times but could not be maintained. The…May 26, 1987 · N8978S · Substantial damageNTSB DEN87LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student plt & CFI were practicing slow flt & stalls. Carb heat was applied before the start of each stall series. During the recovery from the last stall the student plt applied only partial pwr. The CFI applied full pwr & the eng began to run rough. The…May 26, 1987 · N48590 · Substantial damageNTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…May 26, 1987 · N5448Z · Substantial damageNTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…May 26, 1987 · N331CY · DestroyedNTSB ATL87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Maxwell Afb, ALDuring the landing roll, the pilot lost directional control of the acft. The right main and nose gears collapsed. Inspection of the acft failed to reveal any system malfunction/failure.May 26, 1987 · N6857J · Substantial damageNTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…May 26, 1987 · N704YK · Substantial damage