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 MIA88LA053Accident · No injuriesLimited investigationFinal reportBeech C-45H · Miami, FLWhile practicing short field landings the plt flared the acft for landing after which it stalled, descended right wing low, then crashed onto the rwy. The acft then touched down on the nose landing gear causing it to collapse, & slid off the rwy.Dec 4, 1987 · N4209V · Substantial damageNTSB FTW88DPA01Accident · No injuriesFinal reportBell 206B · Dallas, TXThe fuel pump warning light came on and the pilot headed for a local airport. Enroute, the engine surged and flamed out. During the landing, the rotor blades hit trees, and the helicopter made a hard landing. The fuel gage indicated 11 gallons. Later the gage…Dec 4, 1987 · N206DW · Substantial damageNTSB ATL88FA052Accident · Serious injuriesField investigationFinal reportPiper PA-60-600 · Mansfield, OHThe pilot departed louisville, KY reportedly with a known oil leak in the right engine and was on the second leg of an on-demand air taxi cargo flight. About 14 minutes after entering Mansfield approach control airspace, the pilot requested and received an…Dec 4, 1987 · N500TS · DestroyedNTSB NYC88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pottstown, PADuring soft field takeoff, the instructor pilot who was watching from the ramp, said the the student plt seemed to have excessive angle of attack and stalled the aircraft. The aircraft crashed on airport property about 1,000 feet from the start of the takeoff…Dec 3, 1987 · N16491 · Substantial damageNTSB MIA88IA052Incident · No injuriesIncident investigationFinal reportBeech 58 · Vicksburg, MSWhile on a part 135 on-demand domestic passenger flt, the acft landed gear up. The plt stated that he forgot to lower the landing gear. There was no mechanical failure or malfunction.Dec 3, 1987 · N3012W · Minor damageNTSB FTW88IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-243 · Houston, TXImproper drilling of the cross hole in the slat track bearing bolt, which led to its failure from fatigue cracking.Dec 3, 1987 · N571PE · Minor damageNTSB MIA88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Antonio, FLThe student plt became lost while on a solo x-c training flt. He attempted to contact his non control tower destination airport via UNICOM. He stated that he flew around for 20 or 25 mins attempting to make UNICOM contact & was unsuccessful in doing so. He…Dec 2, 1987 · N2405F · Substantial damageNTSB MIA88LA050Accident · No injuriesLimited investigationFinal reportCessna A185F · Naples, FLThe plt stated that the flt was low and slow on final apch. As a result the main landing gear collided with a dirt bank located short of the rwy. The gear then collapsed and the acft slid to a stop.Dec 2, 1987 · N60925 · Substantial damageNTSB LAX88DVG02Accident · No injuriesFinal reportGrumman G-164A · Williams, CAShortly after takeoff, the engine experienced a loss of engine power. The pilot made a forced landing and collided with a fence on hilly terrain during the landing roll. The engine was inspected with no reported mechanical failures or malfunctions. Wx…Dec 2, 1987 · N673U · Substantial damageNTSB FTW88LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Mangum, OKAccording to the pilot, the engine started running rough during cruise flight. He elected to make a forced landing and intentionally stalled the aircraft into some trees to cushion the impact, substantially damaging the aircraft. The pilot further stated that…Dec 2, 1987 · N3888V · Substantial damageNTSB ATL88LA051Accident · No injuriesLimited investigationFinal reportCessna 172F · Eden, NCThe student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…Dec 2, 1987 · N8674U · Substantial damageNTSB NYC88LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Middletown, PAAfter landing the pilot was cleared to taxi to the parking area at stanbaugh's general aviation. During a maneuver between a de-icer truck and a parked airplane, the pilot allowed the aircraft to become too close to the truck and caught the wing tip on the…Dec 1, 1987 · N32307 · Substantial damageNTSB MIA88FA049Accident · 1 fatalField investigationFinal reportBeech K-35 · Crescent City, FLThe pilot experienced a partial engine failure at lift off with 1/2 of the runway remaining in front of him. The pilot then attempted to do a 180 degree teardrop back to the runway, stalled and crashed. Investigation revealed water contamination of the fuel…Dec 1, 1987 · N125LE · DestroyedNTSB LAX88IA064Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Los Angeles, CADelta flt 1605 landed on rwy 25L. After crossing rwy 25R, the local controller instructed the flt to contact the gnd controller. The ground controller instructed the flt to turn west on the outer taxiway. The capt became disorientated and inadvertently…Dec 1, 1987 · N4571M · No damageNTSB ATL88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Paducah, KYAbt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…Dec 1, 1987 · N2522L · Substantial damageNTSB SEA88LA026Accident · No injuriesLimited investigationFinal reportCessna 206 · Funter Bay, AKShortly after takeoff, with a right quartering tailwind of 20 knots gusting to 25 knots, a downdraft was encountered. The pilot flew the aircraft away from rising terrain but the aircraft settled into small trees at full power in the takeoff configuration.Nov 30, 1987 · N9303R · Substantial damageNTSB NYC88LA023Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJThe Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…Nov 30, 1987 · N4533Q · Substantial damageNTSB LAX88LA063Accident · Minor injuriesLimited investigationFinal reportCessna 177 · San Carlos, AZThe plt added pwr on final approach and later stated that the eng seemed to be losing pwr. He said he noticed that the fuel selector was l of ctr abt 1/2 inch, ctrd it and added carb heat, however the eng still quit. The acft was too low to land on the rwy so…Nov 30, 1987 · N2313Y · Substantial damageNTSB LAX88FA060Accident · 1 fatalField investigationFinal reportPiper PA-46 · Long Beach, CAPilot's failure to land the aircraft after experiencing the pilot's faulty decision was his previous experience with a gear up landing a couple of years before.Nov 30, 1987 · N4369V · DestroyedNTSB CHI88DEP02Accident · Serious injuriesFinal reportBeech V35B · Waukesha, WIShortly after liftoff in IMC, the acft descended to the ground. The plt had been cleared for a rt turn but the controller noticed the acft turning left at about 50 ft AGL. The plt later could not stop the drifting to the left. The lndg gear was raised and the…Nov 30, 1987 · N6679J · DestroyedNTSB BFO88FA009Accident · 1 fatalField investigationFinal reportCessna 182D · South Hill, VAThe plt was on the third leg of a trip between tampa, FL and sussex, NJ. The previous two stops were made because of adverse wx conditions. Before this flight he was advised by fss that VFR flight was not recommended. He filed a VFR flight plan but did not…Nov 30, 1987 · N8886X · DestroyedNTSB ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…Nov 30, 1987 · N4463W · DestroyedNTSB MIA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLThe pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted.Nov 29, 1987 · N84613 · Substantial damageNTSB MIA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Quincy, FLThe plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He…Nov 29, 1987 · N9492T · Substantial damageNTSB MIA88LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172P · New Port Richey, FLThe pilot experienced an engine failure due to a heavily coked #4 cylinder exhaust valve while on climb out at 500 ft AGL. He attempted a turn back to the airport and stalled in the turn and crashed.Nov 29, 1987 · N62083 · Substantial damageNTSB ATL88LA047Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northport, ALBefore reaching the arpt, the eng lost power. Subsequently, the acft was damaged during an emerg landing on an embankment about 1.5 mi short of rwy 29. Only about 1 cup of fuel was found in each fuel tank. The plt thought there was about 12 gal of fuel…Nov 29, 1987 · N8121T · Substantial damageNTSB NYC88LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · E.Harwich Port, MAThe pilot departed chatham airport for a local pleasure flight. Shortly after takeoff and while turning left in the pattern, the engine suffered a power loss. The pilot prepared for an emergency landing and transmitted a 'may day'. The aircraft crashed in a…Nov 28, 1987 · N9714J · DestroyedNTSB MKC88LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Springdale, ARDrg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps…Nov 28, 1987 · N201CQ · Substantial damageNTSB LAX88FA061Accident · 2 fatalField investigationFinal reportPiper PA-11 · San Marcos, CAThe 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…Nov 28, 1987 · N4767H · DestroyedNTSB FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…Nov 28, 1987 · N5934S · DestroyedNTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…Nov 28, 1987 · N6547A · Substantial damageNTSB CHI88LA031Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, ILEarlier in the day, the acft was flown from Danville to rochelle, IL. While on a return flt without refueling, the eng began losing power, so the plt moved the fuel selector to the rgt tank (which indcd 1/4 full) & power was restored. However, about 2 min…Nov 28, 1987 · N5611P · Substantial damageNTSB SEA88LA027Accident · No injuriesLimited investigationFinal reportCessna 172M · Tacoma, WAThe Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor…Nov 27, 1987 · N9134H · 2 aircraft · Substantial damageNTSB SEA88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Cornelius, ORThe pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The…Nov 27, 1987 · N4523Z · Substantial damageNTSB LAX88WA067Accident · No injuriesForeign investigationPiper PA46 · Guaymas, MexicoNov 27, 1987 · N4367K · DestroyedNTSB LAX88LA062Accident · No injuriesLimited investigationFinal reportBeech P35 · Maricopa, CADuring a pleasure cross country flt, a precautionary landing was made due to smoke in the cockpit and a low oil pressure indication. After landing, it was found that the oil line to the oil pressure gauge was broken. After repairs, the plt took off and 10…Nov 27, 1987 · N413EE · Substantial damageNTSB LAX88FA058Accident · Minor injuriesField investigationFinal reportCessna T210N · Fullerton, CAWhile on final appr to runway 24 at Fullerton arpt, the pilot experienced a total engine power loss. The airplane's alt was insufficient to land on the runway & the plt elected to land in an open area adjacent to the arpt. The airplane's left wing collided…Nov 27, 1987 · N7627N · DestroyedNTSB DEN88LA031Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Conner, MTOn takeoff from a private, grass strip the pilot stated the engine began to lose power at approximately 20 to 30 feet AGL. A ravine was ahead and he attempted to stretch his glide to the FAR side of the ravine; however, the aircraft stalled and crashed into…Nov 27, 1987 · N2926D · Substantial damageNTSB BFO88FA008Accident · 3 fatalField investigationFinal reportPiper PA-32-260B · Willis, VAThe acft was on a night IFR flight at 7000 ft MSL in IMC when the plt reported the directional gyro was inoperative. The acft was outbound from the pulaski VOR on V45 headed southeast. The plt further reported the turn&bank and the mag compass were operative.…Nov 27, 1987 · N4832S · DestroyedNTSB ATL88FA046Accident · 1 fatalField investigationFinal reportCessna 152 · Oliver Springs, TNThe plt had deptd from a small airport nr kingston, TN mid afternoon and had landed at another about 30 nmi to the NE. He remained on the ground 30-45 min departing between 1530-1545. According to info gathered, the aircraft was observed to fly over the oak…Nov 27, 1987 · N98BS · DestroyedNTSB ANC88FA021Accident · 3 fatalField investigationFinal reportCessna 185 · Fairbanks, AKThe pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that…Nov 27, 1987 · N4056Y · DestroyedNTSB NYC88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gloucester, NJThe flight departed leddon's farm for an engine check in an extended traffic pattern. Shortly after takeoff, the engine suffered a power reduction from 2200 RPM to about 1000 RPM. A short plowed farm field was selected for a forced landing. The aircraft…Nov 26, 1987 · N1590R · Substantial damageNTSB NYC88FA045Accident · 4 fatalField investigationFinal reportCessna T210N · Skaneateles, NYPrior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to…Nov 26, 1987 · N5136Y · DestroyedNTSB MIA88LA045Accident · No injuriesLimited investigationFinal reportMooney M-22 · Fort Pierce, FLPlt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the…Nov 26, 1987 · N7739M · Substantial damageNTSB LAX88WA068Accident · Minor injuriesForeign investigationCessna 182 · Punta Pescadero, MexicoNov 26, 1987 · N313DF · Substantial damageNTSB LAX88LA059Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Lihue, Kauai, HIPilot failure to maintain adequate main rotor RPM.Nov 26, 1987 · N77DJ · Substantial damageNTSB DEN88FA030Accident · 2 fatalField investigationFinal reportBeech J35 · Knolls, UTThe last comm with the flt was when the plt contacted elko radio and requested the salt lake city wx. He reported that he was at 11500 ft and VFR on top. The specialist on duty was unable to provide the wx info due to a computer sys outage but recommended…Nov 26, 1987 · N2EE · DestroyedNTSB SEA88FA023Accident · Serious injuriesField investigationFinal reportCessna 172M · Hillsboro, ORThe daily radio traffic reporting flight was cleared for an IFR departure from Hillsboro airport in IMC. The owner/ operator of the aircraft stated the company had a 'no ifr' policy. On takeoff witnesses observed the aircraft to be lower and slower than…Nov 25, 1987 · N21460 · DestroyedNTSB LAX88LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAA Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to…Nov 25, 1987 · N75825 · Substantial damageNTSB LAX88FA057Accident · Serious injuriesField investigationFinal reportBoeing 737-387 · Los Angeles, CAThe Boeing 737-387, N383AU, operating as usair flt 20, a regularly scheduled domestic flight, returned to lax shortly after takeoff, when the capt was advised of a bomb threat. After landing on rwy 24L, the capt parked the airplane on the west end of the rwy.…Nov 25, 1987 · N383AU · No damage