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 CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…Nov 16, 1987 · N334DP · DestroyedNTSB NYC88FA041Accident · 4 fatalField investigationFinal reportMooney M20C · St. Marys, PAWhile getting fuel, the pilot of the Mooney M20C and his 3 pals were attempting to remove frost with paper towels and plastic credit cards after being told by the fuel truck driver that the arpt had no ice removal solution. A witness stated that as the…Nov 15, 1987 · N3644H · DestroyedNTSB LAX88LA044Accident · No injuriesLimited investigationFinal reportBeech D18S · Mokuleia, HIThe plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…Nov 15, 1987 · N802H · Substantial damageNTSB LAX88FA042Accident · 4 fatalField investigationFinal reportMooney M20C · Grand Canyon, AZWhile cruising en route all engine power was suddenly lost and the plt attempted an emergency ldg at the Grand Canyon arpt. During the glide, the acft crashed into an outcrop of rocks on a steep cliff, 0.5 mi from the end of the rwy. Exam of the engine…Nov 15, 1987 · N6670R · DestroyedNTSB DEN88LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260B · Akron, COBfr tkof, snow was melted off the acft in a heated hangar. The flt was bgn in blowing snow with a forecast of ocnl mod icing to 20,000'. The plt said the snow lasted only 5 to 10 min & only a trace of ice (less 1/16 inch) accumulated drg the 1st 15 min of…Nov 15, 1987 · N9039P · Substantial damageNTSB DCA88MA004Accident · 28 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-14 · Denver, COThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…Nov 15, 1987 · N626TX · DestroyedNTSB ATL88LA038Accident · No injuriesLimited investigationFinal reportCessna 172A · Dayton, OHThe plt rptd that the engine began to sputter and lose power shortly after takeoff. A forced ldg was subsequently made in a nearby river. The acft nosed over on ldg and came to rest partially submerged in about 4 feet of water. Post-crash exam of the airplane…Nov 15, 1987 · N7623T · Substantial damageNTSB ATL88IA037Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Cleveland, OHWhile descending into Cleveland from 25,000 feet the pilot, experienced a violent lurch in the airframe. The flight continued and landed without incident. An aircraft examination disclosed that the right upper thrust reverser drive link was broken. Further…Nov 15, 1987 · N8988E · Minor damageNTSB SEA88FA024Accident · 2 fatalField investigationFinal reportCessna 180G · Cambridge, IDDuring a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe…Nov 14, 1987 · N4613U · DestroyedNTSB NYC88LA040Accident · No injuriesLimited investigationFinal reportCessna 210 · Schenectady, NYDuring landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and…Nov 14, 1987 · N9568T · Substantial damageNTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…Nov 14, 1987 · N8993L · Substantial damageNTSB NYC88FA042Accident · 2 fatalField investigationFinal reportMooney M20K · Danby, VTThe pilot was on a VFR cross country flight when the aircraft descended rapidly and collided with trees. Several witnesses reported hearing extensive engine surges. Witnesses reported seeing the acft maneuvering in a highly erratic manner, then begin a nose…Nov 14, 1987 · N252ZF · DestroyedNTSB NYC88DGM03Accident · 1 fatalFinal reportPiper PA-28-161 · Spartansburg, PAThe pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of…Nov 14, 1987 · N8318L · DestroyedNTSB LAX88LA048Accident · No injuriesLimited investigationFinal reportBeech 58 · Jackson, CAThe plt rprtd that prior to reaching the destn, he received an adzy on the UNICOM freq that rwy 19 was in use & that there was a direct x-wind. Drg arrival, he tried to contact UNICOM again to get a wx update, but was unable. He elected to lnd on rwy 19.…Nov 14, 1987 · N9106Q · Substantial damageNTSB LAX88LA046Accident · No injuriesLimited investigationFinal reportCessna T210M · Colusa, CAThe pilot executed a missed approach at the destination because of fog and reduced visibility. The pilot elected to divert to Colusa due to the weather and on approach to calusa the engine quit. Attempts to restart the engine were unsuccessful and the pilot…Nov 14, 1987 · N761MX · Substantial damageNTSB LAX88LA043Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe plt rprtd that during an external load operation, the helicopter ran out of fuel. Subsequently, it was damaged when it touched down hard during a forced landing.Nov 14, 1987 · N1113L · Substantial damageNTSB LAX88DVG01Accident · 2 fatalFinal reportStoopin Scorpion · Browns Valley, CADuring the local flight, the acft was observed at 300 ft when a power loss apparently occurred. The aircraft descended steeply into a wooded area. The witness stated that the pilot/manufacturer had performed maintenance on the aircraft,s engine immediately…Nov 14, 1987 · N19NS · DestroyedNTSB FTW88FA028Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Lancaster, TXThe pilot received a weather report indicating that IFR conditions prevailed. After takeoff the airplane traveled approximately 1/2 mile before it crashed. Pilot was not instrument rated and had very little total time. He did have three hours of night time…Nov 14, 1987 · N8980J · DestroyedNTSB CHI88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manitowoc, WIThe pilot and his two pax were on takeoff roll at the local, uncontrolled arpt. The pilot stated that just prior to rotation a deer ran onto the runway and the right wing struck the deer. The pilot aborted the takeoff without incident.Nov 14, 1987 · N47622 · Substantial damageNTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…Nov 14, 1987 · N8382M · Substantial damageNTSB ATL88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Murfreesboro, TNThe rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…Nov 14, 1987 · N41298 · Substantial damageNTSB ATL88IA036Incident · No injuriesIncident investigationFinal reportLockheed L-188C · Atlanta, GAAfter two aborted takeoffs for a RPM fluctation problem at takeoff pwr, the crew retd to the cargo ramp. They parked the acft, with engines running, adjacent to the gnd pwr cart used for starting the engines. The pwr cart had been left unattended with the…Nov 14, 1987 · N861U · Minor damageNTSB ATL88DKG02Accident · No injuriesFinal reportCrump 512 · Parrish, ALWhile cruising at 5500 ft, the propeller separated from the aircraft and struck the left wing. During the resulting forced landing, the pilot had difficulty controlling the aircraft and was unable to maneuver to a selected field. He said the aircraft would…Nov 14, 1987 · N512FC · Substantial damageNTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…Nov 13, 1987 · N6644P · Substantial damageNTSB CHI88DER01Accident · No injuriesFinal reportPiper PA-22 · Mcgrath, MNDuring a solo cross-country flight, the aircraft sustained a power loss due to failure of the #3 connecting rod. Subsequently, the student pilot made an emergency landing in a swamp and the aircraft was damaged.Nov 13, 1987 · N77PL · Substantial damageNTSB SEA88LA016Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Turner, ORWhile on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not…Nov 12, 1987 · N35HA · Substantial damageNTSB SEA88IA017Incident · No injuriesIncident investigationFinal reportBeech E18S · Reno, NVShortly after takeoff, and after the landing gear was raised, the pilot noticed an over-temperature of the right engine. A power reduction was made and afterwards symptoms of a compressor stall occurred. The pilot then shut down the right engine. A 180 degree…Nov 12, 1987 · N25SM · Minor damageNTSB NYC88LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jeannette, PAThe aircraft suffered an engine failure during approach and crashed short and to the right of the runway. The acft then nosed over. Post acc investigation and engine exam by the FAA revealed no reason for the eng malfunction.Nov 12, 1987 · N8450F · Substantial damageNTSB NYC88LA036Accident · No injuriesLimited investigationFinal reportBeech 36 · Utica, NYThe flight was enroute from bridgeport, Connecticut to old forge, new york when adverse weather conditions were encountered. A request for lower altitude to escape weather was no improvement and a request to land at oneida was made. During radar vectors…Nov 12, 1987 · N9230Q · Substantial damageNTSB MIA88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLAfter successful completion of 6 dual touch-and-go landings, the student plt departed to perform 3 touch-and-go landings for her first solo flight. The instructor plt stated that the apch to the first landing appeared to be low & after touchdown, the acft…Nov 12, 1987 · N6369H · Substantial damageNTSB MIA88FA032Accident · Serious injuriesField investigationFinal reportAirbus Industrie A310 · Atlantic Ocean (Atlantic Ocean)The capt said he expected some wx drg the 1st 2 hrs of flt. After lvlg at FL 330, the acft was in clear wx, but lgt turbc contd for a time. After the turbc had stopped & there were no wx rtrns on the radar, the seat belt sign was turned off, although the capt…Nov 12, 1987 · N813PA · Minor damageNTSB LAX88LA041Accident · No injuriesLimited investigationFinal reportBeech C23 · Fallbrook, CAThe student pilot was on his first solo flight in the Beech C23 aircraft. On landing the pilot pulled back on the elevator control and the aircraft began to porpoise. The aircraft touched down hard and the nose gear collapsed. The aircraft slid off the side…Nov 12, 1987 · N37188 · Substantial damageNTSB LAX88LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Jamestown, CADuring a local sightseeing flight over a lake, the plt reported after circling for some time at a low altitude, the engine lost power. The plt made an emergency landing on the lake where the acft sank. Several days later, the acft was retrieved and the engine…Nov 12, 1987 · N7797X · Substantial damageNTSB LAX88LA039Accident · No injuriesLimited investigationFinal reportCessna 210A · San Luis Obispo, CAWhile approaching the arpt the plt stated that he slipped the acft from 1800 feet to 1400 feet, leveled the wings, still descending, and entered the pattern at 1200 feet. While on final approach the engine quit. Unable to land on the rwy, the plt landed in a…Nov 12, 1987 · N9505X · Substantial damageNTSB FTW88LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawton, OKThe student pilot stated that during flare/touchdown the aircraft bounced and came down hard on the nose gear collapsing it and damaging the prop and firewall. The majority of the student pilots flt time was obtained while in the military.Nov 12, 1987 · N65584 · Substantial damageNTSB CHI88DEE01Accident · No injuriesFinal reportAlexander Volksplane VP-1 · Dekalb, ILThe plt had little experience flying tailwheel equipped acft & had only 10 hrs flt time in this make & model. During arrival, he landed on rwy 27 with a quartering left x-wind that was gusting to 20 KTS. Just before touchdown, a gust of wind caused the acft…Nov 12, 1987 · N99VP · Substantial damageNTSB ATL88LA035Accident · No injuriesLimited investigationFinal reportMooney M20A · Southport, NCThe airplane lost engine pwr shortly after takeoff. A forced ldg was subsequently made in a nearby waterway. Post-crash exam of the airplane revealed that the fuel selector was in the left tank position, and that the left tank contained about 1/2 gallon of…Nov 12, 1987 · N1051B · Substantial damageNTSB SEA88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Winnemucca, NVThe plt was attempting to land close to the approach end of the rwy. He made the approach with full flaps at 85 mph the rate of descent became excessive and before recovery was affected the acft collided with a fence near the rwy threshold. The acc site was…Nov 11, 1987 · N400TT · Substantial damageNTSB NYC88LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver Falls, PADuring hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury.Nov 11, 1987 · N8364N · No damageNTSB MIA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · West Palm Beach, FLThe plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…Nov 11, 1987 · N112AG · Substantial damageNTSB LAX88LA038Accident · No injuriesLimited investigationFinal reportCessna 172E · Placerville, CADuring a telephone interview the student pilot stated that he was practicing takeoffs and landings. On the landing prior to the accident, the aircraft bounced and the student pilot attempted a go around. During the go around attempt the aircraft drifted to…Nov 11, 1987 · N5577T · Substantial damageNTSB LAX88DUJ02Accident · No injuriesFinal reportSadler Vampire · Mesa, AZDuring a local pleasure flight, while climbing to altitude, the engine quit. A forced landing was made on a dirt road where during the landing roll the aircraft collided with a ditch. Examination of the engine revealed that the rear cylinder next to the gear…Nov 11, 1987 · N3153Y · Substantial damageNTSB FTW88LA026Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dallas, TXThe plt reported that the acft was no. 3 in the pattern for landing on rwy 17. He said carb heat was applied on downwind and eng power was used until the acft was on a 3 mi final. At that point pwr was reduced and a glide was established. A short time later…Nov 11, 1987 · N876Q · Substantial damageNTSB ATL88LA034Accident · Serious injuriesLimited investigationFinal reportBoeing 737-232 · Raleigh, NCThe acft encountered moderate to severe turbulence during the nighttime flt, when it passed through clouds momentarily at FL225. A flt attendant sustained a broken ankle. The captain rptd that radar gave no indication of any wx ahead prior to the encounter.…Nov 11, 1987 · N315DL · No damageNTSB MIA88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Miami, FLPlt stated that shortly after starting the left engine he heard an explosion and saw flame spreading from the accessory area of the left engine toward the left wing tip and the cabin. He shut down the engine by turning off the magnetos and he and his…Nov 10, 1987 · N5086Y · DestroyedNTSB MIA88LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · St. Petersburg, FLThe plt, familiar with the arpt, overflew it 2 times in an attempt to activate the rwy lights using the acft's radio as well as to observe the wind sock. After observing a northerly wind & being unable to activate the lights he elected to land on rwy 36…Nov 10, 1987 · N82811 · Substantial damageNTSB MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…Nov 10, 1987 · N4612C · Substantial damageNTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…Nov 10, 1987 · N65110 · DestroyedNTSB CHI88LA022Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Decatur, ILThe aircraft experienced a landing with the gear retracted. The pilot stated that he perceived the yellow light indication for the landing gear to mean 'down', instead of looking for a green light.Nov 10, 1987 · N7865Y · Substantial damageNTSB LAX88LA036Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Carmel Valley, CAThe plt & passenger were on a flt to an arpt with a 2475' rwy & a displaced threshold of 665'. The plt rprtd that when he entered the apch to lnd on rwy 11, the acft was higher than necessary. He contd the apch, but when the acft had not touched down, after…Nov 9, 1987 · N6920F · Substantial damage