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 FTW86FRD11Accident · No injuriesFinal reportGrumman G-164A · Crowley, LAThe acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng…Mar 31, 1986 · N4561 · Substantial damageNTSB DEN86LA108Accident · Minor injuriesLimited investigationFinal reportLuscombe T-8F · Watkins, COWhile practicing ground reference maneuvers at 500 ft AGL a total loss of engine power was experienced. The pilot rated passenger in the rear seat performed the emergency landing while the PIC attempted to restart the engine. The landing was made on open…Mar 31, 1986 · N1593B · DestroyedNTSB CHI86LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Veedersburg, INThe pilot was attempting a short field takeoff from a 1080 foot wheat field that he had mistaken for a private airstrip 1 1/2 miles to the northeast. The pilot said the engine had a slight RPM loss and then developed full power but he was unable to clear the…Mar 31, 1986 · N9910W · Substantial damageNTSB CHI86FEP02Accident · Serious injuriesFinal reportPiper PA-38-112 · Dexterville, WIOn the fourth flight of the day carrying relatives in the vicinity of another relatives house the pilot admitted that he allowed the airspeed to decay during a 55 degree bank and did not recognize an impending stall. When the aircraft stalled there was…Mar 31, 1986 · N23854 · Substantial damageNTSB CHI86FEC03Accident · No injuriesFinal reportCessna U-206B · Tecumseh, MIThe acft collided with terrain following a landing on rwy 18. According to the plt, a gust of wind lifted the right wing of the acft during roll out. The propeller then struck the ground and the acft rocked back onto the right wing.Mar 31, 1986 · N3855G · Substantial damageNTSB ATL86LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Fort Rucker, ALThe x-c flt departed killeen, TX, with an intermediate stop at alexandria, LA. A passenger was disembarked at cairns aaf and during departure for dothan, the aircraft's engine sputtered and lost power. The aircraft collided with trees near the airport. Prior…Mar 31, 1986 · N8140Y · Substantial damageNTSB ATL86FEI04Accident · No injuriesFinal reportPiper PA-38-112 · Wauseon, OHThe acft landed & nosed over about 770 ft upwind of the rwy it had used for takeoff. The CFI thought that the sod strip was too soft for the student to make the takeoff so he took the controls. The acft was unable to gain proper airspeed or alt and landed in…Mar 31, 1986 · N2572C · Substantial damageNTSB SEA86LA089Accident · No injuriesLimited investigationFinal reportHiller 12E · Walla Walla, WAA catastrophic failure of the planetary gear of the transmission occurred about 51 flight hours after overhaul. During forced landing a hard landing occurred severing the tail boom. A fire then erupted.Mar 30, 1986 · N87595 · DestroyedNTSB SEA86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Warm Springs, ORA precautionary landing was made due to the pilot becoming lost, the aircraft's navigation radio not working, and low fuel. A gusting crosswind was present during landing. On rollout the aircraft's wing tip caught a fence and the aircraft nosed over.Mar 30, 1986 · N6958B · Substantial damageNTSB SEA86LA086Accident · Minor injuriesLimited investigationFinal reportMaule M5-180C · Sand Point, IDWhile attempting to take off in strong gusty crosswinds, the plt lost control of the acft. The acft veered off the rwy, struck a fence post, and nosed over inverted. The reported winds at coeur d'alene, ID, 33 nmi ssw of Sand Point, were reported as being…Mar 30, 1986 · N119JC · Substantial damageNTSB NYC86LA097Accident · No injuriesLimited investigationFinal reportMooney M20 · Lockport, NYThe cross country flight was departing runway 28 at Lockport, new york in strong quartering wind conditions. At rotation and climb out, the pilot retracted the gears and flps. However as the aircraft flps retracted the aircraft began to drop. The nose was…Mar 30, 1986 · N6433Q · Substantial damageNTSB MKC86LA076Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St.Charles, MOThe PIC was nervously concerned about an acft that was close behind him in the traffic pattern. The PIC landed fast on the rwy and the right main gear axle broke. The gear leg dug into the rwy and the acft veered off the left side into the soft terrain which…Mar 30, 1986 · N5055G · Substantial damageNTSB LAX86LA156Accident · No injuriesLimited investigationFinal reportCessna 210P · Ontario, CAA Cessna 210P collided with the runway surface after a total loss of engine power. Examination of the aircraft revealed that the right fuel tank was empty. The pilot indicated that he had a total of 60 gallons of 100LL on departure and he had selected the…Mar 30, 1986 · N3896P · Substantial damageNTSB FTW86FA051Accident · 4 fatalField investigationFinal reportCessna 172N · Del Rio, TXThe pilot was doing aerobatic maneuvers in the Cessna 172 airplane with three passengers and a heavy load of fuel aboard. The maneuvers consisted of buzzing boats on the lake at very low altitude, at least one complete aileron roll, several very abrupt…Mar 30, 1986 · N8423E · DestroyedNTSB DEN86LA109Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Santa Teresa, NMThe plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main…Mar 30, 1986 · N43139 · Substantial damageNTSB ATL86FKG08Accident · Minor injuriesFinal reportJoachim Hoehne Pazmany PL-4A · Canton, GAThe acft struck a powerline wire during an attempted go-around after a bounced landing. The plt aborted the landing and turned left at low alt until impact with a wire occurred at a distance of about 300 ft left of the rwy and 1200 ft from the approach end.…Mar 30, 1986 · N3942U · DestroyedNTSB ATL86FEI03Accident · Minor injuriesFinal reportCessna 170B · Columbia Stat., OHThe acft made a hard landing during which the left main gear was sheared off at the fuselage. Weather was not a factor. In the 90 days preceding this accident the plt had only flown 1 hour in this make & model of acft.Mar 30, 1986 · N2894C · Substantial damageNTSB ATL86FA102Accident · 2 fatalField investigationFinal reportNorth American NA219 (T28B) · Luthersville, GAAfter takeoff the acft was observed to climb straight out toan alt of about 500-700 ft. it then turned to a northerly heading. After a short time on the northerly hdg, the acft was observed to initiated a left aileron or barrel roll, dishout and end up on an…Mar 30, 1986 · N544E · DestroyedNTSB SEA86LA085Accident · No injuriesLimited investigationFinal reportCessna 188-A · Warden, WAWhile at cruise, the pilot was distracted and had his head turned when he inadvertently flew into the ground.Mar 29, 1986 · N4736Q · Substantial damageNTSB NYC86LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsfield, MAThe Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial…Mar 29, 1986 · N49107 · Substantial damageNTSB MKC86LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lytton, IAThe acft was departing from a 2,500 ft long, grass, farm strip. The plt said he noticed after take off that the eng was not developing full power and he could not maintain alt. He attempted to land in an adjacent fld, but the ground was soft and the acft…Mar 29, 1986 · N6167D · Substantial damageNTSB MIA86LA108Accident · Serious injuriesLimited investigationFinal reportEasley Pitts S2-E · Homestead, FLWhile climbing through 600 feet after departure, the flight experienced loss of engine power. While returning to the airport altitude could not be maintained and the aircraft crashed short of the runway. Post crash inspection revealed the number 4 cylinder…Mar 29, 1986 · N777GH · Substantial damageNTSB MIA86LA107Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ft. Lauderdale, FLThe non-certificated student plt was making an unauthorized night solo x-country flt. He attempted a landing at his destination with a left 60 deg, 12 kt x-wind. During the landing roll the acft veered to the right and the plt correctedby applying 'extreme'…Mar 29, 1986 · N28007 · Substantial damageNTSB LAX86LA158Accident · 1 fatalLimited investigationFinal reportCessna 150L · Kailua Kona, HIGround witnesses observed the acft spiral into the pacific ocean. Neither the plt nor the acft have been recovered.Mar 29, 1986 · N7384G · DestroyedNTSB LAX86FA160Accident · 2 fatalField investigationFinal reportBeech C35 · Etiwanda, CAThe flt was receiving radar advisories & was routine until the acft was aprx 15 mi east of the destination arpt. After radar svc was terminated, the acft subsequently turned toward the northwest & flew into rising terrain at an elevation of about 3000 feet.…Mar 29, 1986 · N717D · DestroyedNTSB FTW86LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Sallisaw, OKThe pilot stated that on approach into an unfamiliar airstrip he encountered turbulence and a tail wind. He attempted a go-around at a low altitude with full flaps. Before sufficient airspeed could be reached and flaps retracted, the aircraft collided with…Mar 29, 1986 · N7341A · Substantial damageNTSB FTW86LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Houston, TXA flight instructor was showing his student how to takeoff from a crass strip when he noticed another aircraft taking off on an intersecting runway. He elected to abort the takeoff, and the aircraft collided with a ditch, damaging the main gear, left wing and…Mar 29, 1986 · N71611 · Substantial damageNTSB FTW86FA050Accident · 3 fatalField investigationFinal reportLockheed L-402-2 (LASA-60) · Seagoville, TXAcft crashed immediately after takeoff on a flt to discharge jumpers over a drop zone located on the arpt. Witnesses stated that shortly after liftoff the acft entered a steep left bank estimated between 45 and 70 degs. After about 120 degs of turn the acft…Mar 29, 1986 · N3381G · DestroyedNTSB DEN86LA107Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider L53 · Colorado Spring, COThe acft was making a landing due to an approaching thunderstorm. On final, the glider encountered moderate to severe turbulence and at 300 ft AGL, the glider was forced onto the ground by a microburst.Mar 29, 1986 · N96JH · Substantial damageNTSB DEN86LA106Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Tioga, NDThe plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was…Mar 29, 1986 · N51156 · Substantial damageNTSB DEN86LA105Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Aztec, NMPlt and one pax departed eston, saskatchewan at 0600, en route to guaymas, Mexico for a vacation. Acft was refueled in billings, mt at 0900 and at grand junction, CO. Plt checked wx, filed VFR flight plan and departed grand junction at 1430, en route to…Mar 29, 1986 · CGIJZ · Substantial damageNTSB CHI86LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, MIThe eng quit during climb out shortly after takeoff. The plt switched tanks and tried a restart with no success. The acft then experienced a nose gear collapse and nosed over during a landing roll in a field. Investigation revealed the fuel line to the…Mar 29, 1986 · N3900P · Substantial damageNTSB CHI86FER03Accident · Minor injuriesFinal reportHughes 269A (TH-55A) · Lakeville, MNThe CFI reported the accident occurred during a demonstration of wind effect during turns around a point. The CFI reported that as the helicopter was turned downwind it began descending from an alt of aprx 200 ft AGL. It continued it's descent until the right…Mar 29, 1986 · N10415 · DestroyedNTSB CHI86FER02Accident · Minor injuriesFinal reportMonnett Moni · Winona, MNThe acft crash landed off the arpt due to a reported loss of power. The plt landed in a small field surrounded by hills. The acft sink rate during the landing was high and the acft was damaged. Inspection of the eng after the acc was not accomplished due to…Mar 29, 1986 · N295MM · Substantial damageNTSB CHI86FEP01Accident · 2 fatalFinal reportCessna 177 · Portage, WISeveral witnesses stated that upon climbout following a low pass, smoke came out of the engine and the engine sputtered. The aircraft was then seen in a steep turn. During this turn the wings reached a vertical position and the aircraft descended to the…Mar 29, 1986 · N29849 · DestroyedNTSB FTW86FA054Accident · 1 fatalField investigationFinal reportCessna 150G · Salina, OKA night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that…Mar 28, 1986 · N6306S · DestroyedNTSB FTW86FA049Accident · Serious injuriesField investigationFinal reportSpencer Pitts S-1 · Mckinney, TXAs a pitts special, N66D, was in the traffic pattern to lnd, a Cessna L-19E towplane, N4431B, was on the 1300' grass overrun near the apch end of the rwy with a glider being readied for tow. The glider (sailplane) was a grob 103, N226BG.the plt of the pitts…Mar 28, 1986 · N66D · 2 aircraft · Substantial damageNTSB CHI86LA110Accident · No injuriesLimited investigationFinal reportCessna 172MM · Middleton, WIThe 94 hour private pilot was attempting a landing with a crosswind component of 90 degrees and a wind velocity of 15 to 18 KTS gusting to 22 KTS when he touched down with the right main gear & 2 feet off the right side of the runway. The right main gear came…Mar 28, 1986 · N20866 · Substantial damageNTSB CHI86FEX06Accident · Serious injuriesFinal reportPiper PA-32-260 · Henryville, INShortly after leveling the acft off at 9000 ft MSL, the plt experienced an engine failure. During the subsequent forced landing the acft struck a tree and was further damaged during the forced landing roll. Metallurgical exam revealed the crankshaft failed…Mar 28, 1986 · N4804S · DestroyedNTSB SEA86LA084Accident · No injuriesLimited investigationFinal reportBob White AJ1 · Vancouver, WAA loss of power occurred due to a failure of the fuel pump while at cruise. A forced landing was made onto a soft, farmers field where the aircraft nosed over during the landing roll.Mar 27, 1986 · N363JW · Substantial damageNTSB SEA86LA083Accident · No injuriesLimited investigationFinal reportCessna 150K · Las Vegas, NVWhile on final VFR approach to landing, total loss of power occurred. Acft landed short on rough terrain, collapsing the nose landing gear, and acft nosed over. Investigation found a quart of water in the fuel system. Acft had been parked outside three days…Mar 27, 1986 · N6355G · Substantial damageNTSB NYC86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Boston, MATwo of 3 reqd flt attendants (f/a's) were distributing passenger (pax) coats as the acft was being taxied after lndg. Smoke fm an overheated air cond (a/c) pack bgn entering the cabin & the f/a's returned to their duty stations. The flt crew stopped the acft…Mar 27, 1986 · N52311 · No damageNTSB MIA86OA106Accident · Minor injuriesClass 4Final reportCessna 172F · Santo Domingo, PROn March 27, 1986, at 1120 ast, a Cessna 172, N5111F, registered to marcos dominici, a/k/a marcos dominici hilario, of bayamon, p.r., crashed near herrera airport in the dominican republic. The purpose of the flight is unknown and a VFR flight plan had been…Mar 27, 1986 · N5111F · Substantial damageNTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.Mar 27, 1986 · N3187T · Substantial damageNTSB SEA86LA082Accident · Serious injuriesLimited investigationFinal reportSocata MS894A · Wasco, ORThe plt stated that he encountered a wind shear on final. At the time of the accident the wind was recorded to be from the south/southeast at two knots with peak winds at four knots. When the plt noticed that his airspeed had deteriorated to 50 mph, he went…Mar 26, 1986 · N54BF · Substantial damageNTSB MKC86LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Salem, ARThe acft was landing on a 2,050 by 100 ft asphalt rwy. The plt said the touchdown was not hard but not smooth. The acft traveled about 300 ft after touchdown before the r MLG collapsed. The broken parts which were removed from the landing gear assembly were…Mar 26, 1986 · N2889M · Substantial damageNTSB MIA86LA109Accident · 6 fatalLimited investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)The acft failed to arrive at it's destination on a VFR flight from miami FL, to west end, Bahamas. The acft's last reported position was 10 miles west of west end. There was no further contact with the acft. U.S. Coast guard initiated search on March 26, 1986…Mar 26, 1986 · N3527E · DestroyedNTSB FTW86LA047Accident · No injuriesLimited investigationFinal reportBell 206BIII · Gulf Of MexicoThe pilot failed to assure the cabin door was properly closed before flight, or the cabin door just popped open during flight, allowing an unsecured life vest to blow out the door and into the tail rotor blades. This resulted in the entire tail rotor assembly…Mar 26, 1986 · N3181Y · Substantial damageNTSB FTW86FPJ07Accident · No injuriesFinal reportSchweizer G-164A · Red Rock, OKThe acft nosed over during a forced lndg after a power loss. The plt was enroute to a spraying operation and attempted a landing in a pasture after the power loss. An on scene investigation revealed no discrepancies in the engine or fuel system. A successful…Mar 26, 1986 · N991X · Substantial damageNTSB CHI86FEX05Accident · 1 fatalFinal reportChristen Industries Eagle II · Aurora, INThe aircraft impacted the ground when an unsuccessful aerobatic loop maneuver was attempted on takeoff. The pilot of the aircraft was issued a statement of acrobatic compentency which allowed all maneuvers within the limitations of the aircraft and with a…Mar 26, 1986 · N39RH · Destroyed