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 CHI87FA058Accident · 1 fatalField investigationFinal reportPiper PA-31T · Merrillville, INThe acft was enroute to the chicago midway arpt. While letting down to 16000 ft the pilot reported he was shutting down the right eng. ARTCC cleared the acft to 5000 ft. ten minutes later ARTCC lost radio transponder and mode c contact. 15 minutes later the…Dec 30, 1986 · N74NL · DestroyedNTSB CHI87DEP04Accident · No injuriesFinal reportMooney M20F · Greenwood, WIThe aircraft lost engine power during a descent due to a loose throttle linkage and the pilot was forced to make an emergency landing in a field. On landing roll the aircraft struck a reflector post with the right wing.Dec 30, 1986 · N9627M · Substantial damageNTSB SEA87LA039Accident · No injuriesLimited investigationFinal reportHughes 269 · Matlock, WADuring takeoff the aircraft nosed over inverted and then struck the ground. The pilot found after the accident that a strap had hooked under the skid of the aircraft.Dec 29, 1986 · N9365F · Substantial damageNTSB NYC87DNE01Accident · Serious injuriesFinal reportKosch Whitehead #21 · Stratford, CTThe experimental aircraft was making taxi tests on an abandoned taxiway when it became airborne. A photographer rushed out from a marked safety area directly in the flight path of the aircraft and was struck by the aircraft receiving a broken arm. The…Dec 29, 1986 · N1901G · Minor damageNTSB DEN87FA038Accident · Serious injuriesField investigationFinal reportCessna 172N · Central, UTThe plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts…Dec 29, 1986 · N5153K · Substantial damageNTSB DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.Dec 29, 1986 · N4388X · DestroyedNTSB CHI87FA057Accident · No injuriesField investigationFinal reportPiper PA-32-301 · Wheeling, ILThe pilot attempted flight although pirep's for icing had been issued during weather briefing from fss and aircraft was not equipped for icing conditions. Shortly after takeoff, pilot reported to ATC problems with aircraft flight instruments and then reported…Dec 29, 1986 · N8281Y · Substantial damageNTSB NYC87LA052Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Broadalbin, NYThe pilot of a Taylorcraft BC-12D experienced a loss of power while cruising. He selected a field for a landing, however he was short and struck a tree on final. The aircraft received substantial damage and the pilot and passenger received serious injuries.…Dec 28, 1986 · N43239 · Substantial damageNTSB FTW87DRD02Accident · No injuriesFinal reportCessna A-188-B · Ft.Polk, LAExamination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the…Dec 28, 1986 · N49220 · Substantial damageNTSB ATL87FA051Accident · 2 fatalField investigationFinal reportBeech 35-33 · Blountville, TNDrg vectors for a ILS rwy 23 apch, the plt allowed the acft to get 400' below the assigned alt of 3700'. The controller (ctlr) queried the plt about his alt & the plt replied he had gotten a little low, but was returning to the assigned alt. After…Dec 28, 1986 · N210M · Substantial damageNTSB SEA87LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, ORA power loss occurred during takeoff at about 100 feet AGL due to fuel exhaustion. A turn to the left was made so that a landing could be made on a field. During landing roll the aircraft's wing struck two trees.Dec 27, 1986 · N11537 · Substantial damageNTSB NYC87LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Leominster, MAThe Piper PA-28-181 departed on a cross country flight with full tanks (48 gal) according to the pilot. Enroute the pilot experienced a power loss at night after flying for 3.9 hours. The pilot landed in a residential area and struck a house on landing roll.…Dec 27, 1986 · N8720C · Substantial damageNTSB NYC87DNC04Accident · Serious injuriesFinal reportTaylorcraft BC12D · West Farmington, METhe aircraft climbed in a steep attitude after takeoff to an alt of aprx 100 ft AGL. The acft then stalled and impacted the terrain in a left wing low attitude.Dec 27, 1986 · N95575 · Substantial damageNTSB MIA87WA061Accident · No injuriesForeign investigationCessna 402 S/N 402B1031 · Treasure Cay, BahamasDec 27, 1986 · N11RP · Substantial damageNTSB MIA87FA062Accident · 2 fatalField investigationFinal reportPiper PA-34 · Ft. Lauderdale, FLThe pvt plt had been cleared for 27R ILS apch and was on the localizer at 1,600 ft when the controller noticed the acft north of the localizer course and in a right turn headed east. The controller querried the plt as to his heading and the plt replied,…Dec 27, 1986 · N84136 · DestroyedNTSB LAX87LA070Accident · Serious injuriesLimited investigationFinal reportRaven S55A/AX7 · Peoria, AZPrior to lift-off the pilot noted that the wind conditions were calm. During the flight, the surface winds began to increase. The pilot prepared his passengers for a high wind landing and began to lightly vent off hot air. The balloon began descending at…Dec 27, 1986 · N5561P · Minor damageNTSB LAX87FA071Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Gorman, CAThe aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…Dec 27, 1986 · N50U · DestroyedNTSB LAX87FA069Accident · 6 fatalField investigationFinal reportBeech E-55 · East Palo Alto, CAThe pilot and 5 passengers departed for a planned vacation in Mexico in dark night conditions. The aircraft was observedto depart from runway 30, turn from the crosswind to the downwind leg and the aircraft 'lost altitude rapidly' and impacted in the san…Dec 27, 1986 · N111FC · DestroyedNTSB FTW87LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Loreauville, LAA private pilot substantially damaged his aircraft while attempting a landing in a field following a engine failure due to water contamination in the fuel system.Dec 27, 1986 · N5788E · Substantial damageNTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…Dec 27, 1986 · N78475 · DestroyedNTSB CHI87LA055Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Harrison Twp., WIDuring cruise flt the plt attempted to add power and carb heat with no immediate response in eng power. The plt then tried to make an emergency landing in a field but did not have sufficient altitude and airspeed. The acft collided with trees. The plt…Dec 27, 1986 · N37926 · DestroyedNTSB ATL87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · High Point, NCThe plt landed on the wet turf/gravel rwy with a slight quartering tail wind. Rprtdly, the acft touched down about 1/3 of the way down the rwy with an airspeed of 4 to 9 KTS above the recommended speed. The plt was unable to stop on the remaining rwy &…Dec 27, 1986 · N8389C · Substantial damageNTSB ATL87DEG02Accident · No injuriesFinal reportCessna 150H · Harrison, OHThe engine quit after takeoff at about 200 ft AGL. A ldg was made in a plowed field where the acft flipped over inverted. The CFI PIC reported that, prior to takeoff, he had calculated there was adequate fuel on board for the flt; his calculations were based…Dec 27, 1986 · N7190S · Substantial damageNTSB MIA87WA060Accident · Minor injuriesForeign investigationBeech C-45H · St. Barthelemy, WNDec 26, 1986 · N17MM · Substantial damageNTSB MIA87LA059Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Key West, FLShortly after takeoff on an IFR flt, the flt lost all electrical power while in VFR conditions. The flt returned to the arpt and the plt completed the pre-landing checklist placing the gear handle in the down position. The gear, being electrically operated,…Dec 26, 1986 · N2197X · Substantial damageNTSB LAX87MA068Accident · No injuriesMajor investigationFinal reportPiper PA-28-181 · Long Beach, CAA Piper PA-28-161, N7646F, and a Mooney M-20K, N231LY, collided near pader intersection abt 16 miles southwest of lgb airport. Both airplanes were conducting instrument flight training and none of the occupants were injured. N231LY had conducted an ILS…Dec 26, 1986 · N7646F · 2 aircraft · Substantial damageNTSB FTW87FA037Accident · 1 fatalField investigationFinal reportCessna 150L · Altus, OKThe pilot was circling about 40-50 feet above the ground at a slow rate of airspeed while searching for a lost dog. He was using 10 degrees of flaps and most probably operating at a reduced power setting. Carburetor icing conditions were present and…Dec 26, 1986 · N18227 · DestroyedNTSB DEN87FA037Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Lewistown, MTOn the morning of the day of the accident the private plt/owner and his friend took off on an all day coyote hunting flt. When the acft failed to return that evening an air and ground search was begun. The burned wreckage of the acft was found 3 days later…Dec 26, 1986 · N6712L · Substantial damageNTSB CHI87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIWhile practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy.Dec 26, 1986 · N4325E · Substantial damageNTSB MKC87FA035Accident · Serious injuriesField investigationFinal reportCessna 414A · Olathe, KSThe plt stated that this was not a charter flt and, as such, he decided to attempt the LOC 17 apch to Olathe even though the area was forecasting zero-zero conditions. According to the plt, the last thing he remembers during the flt is bracketing the LOC and…Dec 25, 1986 · N414LL · DestroyedNTSB FTW87LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Lindale, TXA private pilot substantially damaged his aircraft while attempting a landing on a grass strip in Lindale, TX. The pilot overshot the airstrip, and crashed in a field off the end of the runway.Dec 25, 1986 · N12525 · Substantial damageNTSB DEN87LA034Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Ovid, COThe plt saw smoke from engine compartment on climb to cruise. He made a forced landing after cirling the field. During landing roll, the plt applied excessive braking and the acft nosed over. There was a post accident fire.Dec 25, 1986 · N1068E · Substantial damageNTSB SEA87LA041Accident · No injuriesLimited investigationFinal reportDouglas C-54/DC-4 · Pacific Ocean, WAThe plt reptd that he ditched his DC-4 in the Pacific Ocean on the evening of December 23 after experiencing an uncontrollable no. 3 eng fire at the conclusion of a tng flt. The ditching occurred in dark night conditions with minimal 10 foot swells having a…Dec 24, 1986 · N96361 · Substantial damageNTSB MIA87LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident.Dec 24, 1986 · N65484 · Substantial damageNTSB FTW87LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Marble Falls, TXA pilot on a cross country flight in the local area at randolf afb, TX. Was flying low over the llano river about 50 ft. AGL and contacted a power line, substantially damaging the right wing. The pilot continued on to randolf afb and landed without incident.Dec 24, 1986 · N53384 · Substantial damageNTSB ATL87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt had suspected a hydraulic problem prior to departure when hydraulic fluid was found on the hangar floor. The acft was flown to a nearby arpt for repairs. The acft then departed and aprx 1 hr into the flt a heater problem was experienced. The plt…Dec 24, 1986 · N3577U · Substantial damageNTSB MKC87IA034Incident · No injuriesIncident investigationFinal reportEmbraer Brasilia EMB-120 · Fort Smith, ARThe flight crew stated that they were initiating a descent into final approach for a landing when the right engine gearbox chip detector lgith illuminated followed by a loud bang and severe vibration. When the propeller was feathered and the engine shut down…Dec 23, 1986 · N223AS · Minor damageNTSB MIA87LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sarasota, FLTwo ldg attempts were made at the physician plt's private arpt but were abandoned due to strong shifting violent winds. The plt later stated the last thing he remembered was seeing 500 ft on the altimeter & telling himself 'to get up & out of there' the acft…Dec 23, 1986 · N737ZB · DestroyedNTSB DEN87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Nathrop, COThe canadian registered acft, with a pvt plt and instructor rated pax and two paxs aboard, took off from canon city, CO, enroute to gunnison, CO, to refuel. This was a cross-country flt to allow the plt to build necessary flt time towards a commercial…Dec 23, 1986 · CGYDG · Substantial damageNTSB ATL87LA056Accident · No injuriesLimited investigationFinal reportCessna 172G · New Philadelphi, OHThe acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…Dec 23, 1986 · N380LA · Substantial damageNTSB ATL87LA046Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Dublin, VAWhile clbg to FL 350, usair flt 95 enctrd cont 'light chop,' so crew lvld at FL 310 & left the seat belt sign on. They inquired about turbc ahead & were adzd of rprtd lgt/mod chop & 1 enctr with svr turbc at FL260. Clnc was rcvd to dscnd to FL 240. Drg dscnt,…Dec 23, 1986 · N369AU · Minor damageNTSB ATL87FA047Accident · Serious injuriesField investigationFinal reportCessna 310N · Savannah, GADuring ILS rwy 9 appraoch acft disappeared from radar at one mile short of rwy. Acft impacted in level attitude with landing gear extended on a northerly heading one half mile short and about one quarter mile left of rwy centerline. Plt and CFI both stated…Dec 23, 1986 · N4137Q · Substantial damageNTSB MIA87LA055Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Ocala, FLThe acft dragged a wing during lndg according to the plts statement. The acft came to rest beside the rwy. The plt said he lost control of the acft due to a fuel imbalance. After the accident the left wing tip tank was found full of fuel. According to the…Dec 22, 1986 · N151CD · DestroyedNTSB MIA87LA053Accident · No injuriesLimited investigationFinal reportCessna 150F · Tunica, MSThe plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed.Dec 22, 1986 · N6907F · Substantial damageNTSB MIA87FA056Accident · 1 fatalField investigationFinal reportCessna 172N · Middleburg, FLThe flt was receiving flt following services from jacksonville apch control. Radar and radio contact was lost shortly after the plt reported to apch control he was descending out of 4,500 ft in preparation for his landing at st. augustine, FL. A witness…Dec 22, 1986 · N739SV · DestroyedNTSB LAX87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Chico, CADuring an ILS apch to rwy 13L, the plt thinking he was at the missed apch point collided with the terrain 200 yrds west of the arpt. The route of flt was determined to be in a north westerly direction. Exam of the navigational instruments revealed that the…Dec 22, 1986 · N64533 · Substantial damageNTSB CHI87FA054Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · West Chicago, ILAt 0850 CST, the plt got a wx briefing for a flt to the dupage arpt. At that time, the current dupage wx was in part: partial obscn, 2 mi vis with fog; also, the plt was given svrl pireps for lgt to mod icing in southern Wisconsin. At 1231, he got a wx…Dec 22, 1986 · N1253R · DestroyedNTSB ANC87LA022Accident · No injuriesLimited investigationFinal reportCessna 206 · Ruby, AKThe pilot stated that during the landing roll on the frozen river, he lost control of the aircraft causing the aircraft to ground loop.Dec 22, 1986 · N734WE · Substantial damageNTSB NYC87LA051Accident · No injuriesLimited investigationFinal reportCessna 201A · Scotias, NYThe flight experienced an engine power loss when the throttle was reduced and the pilot turned the aircraft in an attempt to make the field, the aircraft was landed in a swampy area off the arpt when the field could not be reached. Investigation revealed no…Dec 21, 1986 · N6615X · Substantial damageNTSB NYC87FA049Accident · 1 fatalField investigationFinal reportCessna 172M · Kingston, NYCessna 172M, N64342, was on his initial climb after taking off on runway 33 at the uncontrolled Kingston-ulster airport when the pilot failed to see Cessna 177, N2981X, or hear, on the UNICOM frequency, the transmissions by N2981X who was on his final…Dec 21, 1986 · N64342 · 2 aircraft · Destroyed