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 FTW88FA032Accident · 3 fatalField investigationFinal reportBeech H35 · Port Mansfield, TXThe plt rcvd svrl wx briefings bfr tkof & was adzd of convective activity along the initial route of flt north of the arpt. The planned dep route was twd the wx. While discussing altn routing possibilities, the plt indcd he would ask ATC for deviation arnd…Nov 25, 1987 · N5568D · DestroyedNTSB DEN88LA029Accident · No injuriesLimited investigationFinal reportCessna 182RG · Boulder, MTWhile on a cross country flt at 6000 ft MSL, the eng lost power. Exam of the acft revealed that the left fuel tank contained 23 gallons while the right was empty. The fuel selector was found on the empty tank. The acft was destroyed during the emergency…Nov 25, 1987 · N2283T · DestroyedNTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…Nov 25, 1987 · N1380Q · Substantial damageNTSB SEA88LA022Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Las Vegas, NVDuring practice autorotation the pilot flared excessively high and the tail boom struck the ground. The pilot then lost control of the aircraft. The density alt was 2616 feet. A rt quartering tailwind was present.Nov 24, 1987 · N22730 · DestroyedNTSB NYC88LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Mendham, NJThe flight instructor had simulated an engine failure. The instructor pulled the throttle to idle and the student went through the checklist procedure for emergency landing. When the student plt applied power for the go-around the engine restarted for about…Nov 24, 1987 · N5520H · Substantial damageNTSB NYC88LA044Accident · Minor injuriesLimited investigationFinal reportBell 206B · Beverly, MAThe helicopter was on a normal approach to Beverly airport and was cleared to cross runway 27 from the southeast. The pilot entered an autorotation but realized that the ground was under construction and was very muddy. In an attempt to shift directions at…Nov 24, 1987 · N3888Q · Substantial damageNTSB MIA88FA044Accident · 1 fatalField investigationFinal reportCessna 172N · Palm Coast, FLThe student plt was flying the acft on a solo instructional flt in the north practice area & was assigned to practice landings, takeoffs, stalls & slow flt. Witnesses stated they observed the acft flying at a very low altitude just before it collided with a…Nov 24, 1987 · N246ER · DestroyedNTSB LAX88LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · San Clemente, CAA partial loss of eng power occurred while the student plt was on a solo x-country flt. He applied carb heat, but to no avail. The eng continued to run rough & the plt made an emergency landing on upward sloping terrain. During the landing roll, the nose gear…Nov 24, 1987 · N5418P · Substantial damageNTSB FTW88LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · New Orleans, LAThe pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller.Nov 24, 1987 · N6463F · Substantial damageNTSB ATL88LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Waynesboro, GAThe student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm.Nov 24, 1987 · N4081V · Substantial damageNTSB ATL88FA044Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Commercial Pt, OHThe acft crashed on a wheat field during a night instrument training flt. The plt had declared a vacuum system failure about 40 minutes after take-off but he declined ATC assistance for a no-gyro approach to columbus. Two minutes after the radio call radar…Nov 24, 1987 · N8046X · DestroyedNTSB ATL88FA043Accident · 1 fatalField investigationFinal reportCessna 172N · Blanchester, OHThe aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the…Nov 24, 1987 · N5548J · DestroyedNTSB NYC88LA039Accident · No injuriesLimited investigationFinal reportWaco ZKC-5 · No. Canaan, CTThe aircraft touched down in a 3-point landing attitude at north Canaan, Connecticut. The left landing gear wheel rotated 90 degrees and the left gear was dragged 144 yards before the aircraft became inverted. It was revealed that the braze joint at the top…Nov 23, 1987 · N14164 · Substantial damageNTSB DEN88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…Nov 23, 1987 · N7291P · Substantial damageNTSB DCA88MA005Accident · 18 fatalMajor investigationFinal reportBeech 1900C · Homer, AKDrg arr, the acft (ryan flt 103) crashed short of rwy 3. The fuselage stayed intact drg impact, but the belly structure was compressed & vertical deceleration forces exceeded the design capability of the seats. Rescue psnl had difficulty shutting off the…Nov 23, 1987 · N401RA · DestroyedNTSB ATL88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Hazel Green, ALThe airplane hit a tree and crashed about 300 yds short of the rwy while on final appch to land. The plt indicated that he became preoccupied with the airspeed indicator and allowed the airplane to descend below the proper glide path. The plt had less than 1…Nov 23, 1987 · N8504T · Substantial damageNTSB SEA88FA021Accident · 1 fatalField investigationFinal reportCessna 210E · Port Townsend, WAThe aircraft flew into the side of maynard mountain, the point of a coastal land mass, while on a night VFR flight in IMC wx conditions. Radar data showed the aircraft on a straight course at cruise airspeed.Nov 22, 1987 · N4956U · DestroyedNTSB LAX88LA053Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · San Diego, CAAs the plt was completing a banner towing opn, he applied pwr to climb from 500' to 1500' to return to the arpt. As he advanced the throttle, the eng began running rough, then lost pwr. He said the cockpit filled with smoke & he released the banner. He…Nov 22, 1987 · N53917 · DestroyedNTSB LAX88FA052Accident · 4 fatalField investigationFinal reportCessna T210L · Camp Verde, AZNov 22, 1987 · N42CR · DestroyedNTSB FTW88IA029Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Newark, NJImmediately after the hard landing the captain was observed by the copilot and flight engineer to be incapacitated. The copilot took control of the airplane and guided it onto a high speed taxiway. With the aid of a flight attendant and the flight engineer…Nov 22, 1987 · N121AA · No damageNTSB CHI88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake City, MIThe student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10…Nov 22, 1987 · N9817W · Substantial damageNTSB ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…Nov 22, 1987 · N7109L · Substantial damageNTSB LAX88LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAAt the conclusion of a cross country instructional flight, the pilot made three approaches to land. On the first two attempts, the aircraft touched down on the nose wheel and porpoised, then the pilot initiated a go-around. On the third landing, the aircraft…Nov 21, 1987 · N9568G · Substantial damageNTSB LAX88DUQ02Accident · Minor injuriesFinal reportIsgrigg Elite · Tehachapi, CAThe homebuilt gyroplane became uncontrollable during take-off roll on runway 27R. The aircraft pitched up and then rolled on its left side. The national weather service reported the winds in the area at the time of the accident to be from 290 degrees at 12-15…Nov 21, 1987 · N333JE · Substantial damageNTSB CHI88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Kankakee, ILThe pilot was attempting to land on runway 22 at an uncontrolled airport when he heard another pilot transmit he was about to depart from the same runway. According to the pilot, while he was turning on to final approach, he observed an aircraft taxiing to…Nov 21, 1987 · N6255F · Substantial damageNTSB ATL88FA040Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Lewisburg, KYThe pilot experienced a loss of engine power at 5500 feet. He was not able to start the engine after completing an emergency procedure. The pilot established an approach to a landing area, and stalled the aircraft on short final. The aircraft moved about 30…Nov 21, 1987 · N6450P · Substantial damageNTSB MKC88FA019Accident · 2 fatalField investigationFinal reportPiper PA-32R · Fayetteville, ARThe airplane was cleared to land while on downwind. Tower saw lights and said airplane appeared to be flying around hill north of airport. Investigation revealed airplane had turned left and impacted trees below the top of the hill.Nov 20, 1987 · N3578G · DestroyedNTSB MIA88LA043Accident · No injuriesLimited investigationFinal reportNorth American 500 · San Juan, PRWhile on a part 135 non-scheduled domestic passenger flt in VFR conditions, the plt landed the acft gear up. Operational check of the landing gear & warning horn revealed no failure or malfunction.Nov 20, 1987 · N4111P · Substantial damageNTSB LAX88LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot estimated that the aircraft's reduced fuel quantity was adequate for the flight during his preflight inspection. As the aircraft descended for the traffic pattern near the destination airport both engines failed. After the loss of power the pilot…Nov 20, 1987 · N27512 · Substantial damageNTSB FTW88LA030Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnet, TXDuring landing roll, the aircraft drifted to the left of the runway centerline. Witnesses then observed the aircraft veer to the right and ground loop coming to rest off the end of the runway. Attempts to contact the student plt have not been successful.Nov 20, 1987 · N7370H · Substantial damageNTSB SEA88LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sequim, WADuring dark night visual meteorological conditions, the aircraft struck trees while in cruise flt at about 2,000 feet MSL. Although the pilot had requested VFR traffic advisories, he did not solicit the use of the low altitude alert system. This system was…Nov 19, 1987 · N70334 · DestroyedNTSB MKC88FA018Accident · 1 fatalField investigationFinal reportCessna 310Q · Augusta, KSThe airplane departed to the south and made a left turn. Approximately 1/4 of a mile east of the airport, the airplane impacted straight down with gear down and flaps at 15 degrees. No preimpact problems were found with airframe or powerplants. No indication…Nov 19, 1987 · N7735A · DestroyedNTSB MIA88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Roseland, FLThe acft was preflighted approx 20 min after refueling with no discrepancies noted. The plt had difficulty starting the acft. Mechanics flushed the acft fuel lines and declared the acft ok. No water was found in the fuel sumps or strainer during the plts…Nov 19, 1987 · N36066 · Substantial damageNTSB MIA88FA042Accident · 2 fatalField investigationFinal reportCessna 152 · Okeelanta, FLThe acft crashed into a wildlife management area in a steep nose down attitude with about 20 degs flaps extended. The stated purpose of the flt was to spot deer & a suitable area in which to hunt. Torsional damage to the airframe suggested that the acft was…Nov 19, 1987 · N89741 · DestroyedNTSB LAX88FA033Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Rialto, CAThe pilot lost control of the recently painted helicopter during the takeoff. The paint shop personnel had moved the helo to a airplane parking spot. The helo skids straddled the tie-down chains. Two wing tie-down chains were incorrectly attached to the right…Nov 19, 1987 · N66WL · Substantial damageNTSB DEN88LA026Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Albuquerque, NMWhile attempting to retrieve a parachute retarded rocket that came to rest in a tree by hooking the right front skid shoe under the chute, the parachute got hung up in the tree. The helicopter lifted the rocket approx 6 ft into the air before it swung into…Nov 19, 1987 · N1073N · DestroyedNTSB DEN88LA025Accident · No injuriesLimited investigationFinal reportHughes 269C · Grand Forks, NDThe CFI was instructing the pvt rated dual student in simulated forced landings. During the power recovery following a practice autorotation, the engine failed to regain RPM at full throttle. During the forced landing, the helicopter nosed over at touchdown…Nov 19, 1987 · N11079 · Substantial damageNTSB CHI88LA028Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Belle Plaine, MNAfter the acft was in the traffic pattern, the instructor (CFI) initiated a simulated forced landing. Just before touchdown on final apch, the student (a rated pvt plt) allowed the acft to drift to the right. The CFI attempted a go-around, but was delayed in…Nov 19, 1987 · N2716Z · Substantial damageNTSB CHI88FA024Accident · Serious injuriesField investigationFinal reportBeech TC-45J · St Clair Shores, MIWhile enroute to home base after delivery of revenue cargo, the pilot experienced a total loss of engine power in both engines due to fuel exhaustion. The pilot performed emergency procedures and set the aircraft up for a forced landing in a grassy field on…Nov 19, 1987 · N10AS · DestroyedNTSB BFO88FA007Accident · 2 fatalField investigationFinal reportCessna 152 · Warrenton, VAThe acft was observed to be flying straight and level when the sounds of the eng were heard to increase. The only witness saw the acft nose over and dive into the ground. Radar tracking of the acft flt path confirms this. Investigation revealed that the this…Nov 19, 1987 · N757ER · DestroyedNTSB ANC88LA017Accident · No injuriesLimited investigationFinal reportCessna 208 · Atmautluak, AKThe pilot stated that he landed at a distance approximately one-third of the way down the 2,000 foot ice covered gravel runway. After touchdown the pilot lost directional control of the aircraft causing the aircraft to exit the departure end of the runway.…Nov 18, 1987 · N9370F · Substantial damageNTSB SEA88IA019Incident · No injuriesIncident investigationFinal reportBeech 99-A · Port Angeles, WABoth generator lights came on along with the left and right fuel pressure lights. The aircraft was being flown back to the airport for a precautionary landing, when the annunciator panel lights began to flicker. When landing flaps were selected they did not…Nov 17, 1987 · N806BA · Minor damageNTSB LAX88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe pilot stated that the engine lost power while he was flying low over the ocean on a fish spotting flight. Subsequently, he ditched the aircraft in the ocean & it was not retrieved.Nov 17, 1987 · N2973V · DestroyedNTSB CHI88LA027Accident · No injuriesLimited investigationFinal reportCessna 150J · Patoka, INWhile enroute to Patoka airport for fuel the aircraft experienced fuel exhaustion and the pilot was forced to make an emergency landing in a field. The aircraft landed approximately two miles northeast of the airport. The nose gear of the aircraft became…Nov 17, 1987 · N86WA · Substantial damageNTSB NYC88LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Montoursville, PAAfter takeoff, the plt remained in the traffic pattern to practice takeoffs & landings. He made a touch-&-go, then rprtd on a right downwind for another landing. He acknowledged a clearance to continue, but moments later, an ELT signal began transmitting.…Nov 16, 1987 · N9055F · DestroyedNTSB MKC88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mena, AROn the day of this accident, there was a well-publicized weather system affecting the weather along the pilot's route: warm moist gulf air was moving northward toward a cold front that extended from Mexico to Canada. Residents in the area said the region had…Nov 16, 1987 · N9131J · DestroyedNTSB MIA88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLDuring an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear…Nov 16, 1987 · N539FT · Substantial damageNTSB MIA88LA037Accident · No injuriesLimited investigationFinal reportMandley Steen Skybolt · Placida, FLWhen attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.…Nov 16, 1987 · N44JM · DestroyedNTSB LAX88FA047Accident · 2 fatalField investigationFinal reportCessna 152 · Bakersfield, CAThe recently rated private pilot and his passenger were flying low and waving to people on the ground. As the aircraft neared electrical service lines across its flight path ground witnesses observed it to enter an abrupt climb, roll left and dive into the…Nov 16, 1987 · N5478L · DestroyedNTSB LAX88FA045Accident · 2 fatalField investigationFinal reportCessna 441 · Mexicali, MexicoA Cessna 441 operated by the uscs collided with terrain while on a authorized night tactical flight. The copilot did not meet the currency standards as required by uscs and was not qualified in the acft. The flight originated during the daylight hours and…Nov 16, 1987 · N2484B · Destroyed