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 MIA89IA008Incident · No injuriesIncident investigationFinal reportCessna 210M · Orlando, FLAfter takeoff when the ldg gear was raised, the plt noted that the gear motor circuit breaker popped and that he could not lower the landing gear using the emergency gear extension procedures. He landed gear up in the grass. Post accident investigation…Oct 11, 1988 · N9064M · Minor damageNTSB FTW89LA003Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Fairfax, OKThe plt reported that the engine locked and he made a forced landing in a muddy, plowed field. The airplane landed hard and the plt received a fracture to the skull just above his right eye. During engine teardown, the head from the exhaust valve on the…Oct 11, 1988 · N11191 · Substantial damageNTSB CHI89LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Indianapolis, INThe pilot and his family of three were returning from a vacation in Florida. They made a fuel stop at columbus, Georgia, then tried to fly non-stop from there to kokomo, Indiana. About 50 miles short of the intended destination, the engine lost power due to…Oct 11, 1988 · N8112T · DestroyedNTSB ANC89LA018Accident · No injuriesLimited investigationFinal reportCessna 182C · Akiachak, AKThe air taxi pilot landed long and was unable to stop the aircraft before it ran off the runway and came to rest in a ditch. A 30-40 kt gusty crosswind and turbulence existed at the time. The pilot stated that during the landing roll, he discovered that the…Oct 11, 1988 · N449SA · Substantial damageNTSB SEA89LA011Accident · 1 fatalLimited investigationFinal reportRoman LONG-EZ · Salmon, IDThe purpose of the flight was to spot wild game during feeding time (at dusk). The surviving passenger estimated the flight visibility was about one to two mi with smoke. While flying in close proximity to rugged, mountainous terrain, the acft struck a tree…Oct 10, 1988 · N38AJ · DestroyedNTSB NYC89LA010Accident · No injuriesLimited investigationFinal reportBeech 77 · Farmingdale, NYThe pilot of the Beech 77 had just started the engine and was checking the gauges, when the aircraft started moving forward. The pilot tried to turn the aircraft onto a taxiway. The aircraft continued straight ahead and hit two parked aircraft.Oct 10, 1988 · N37273 · Substantial damageNTSB FTW89DPJ01Accident · 1 fatalFinal reportAutra Scorpion/133 · Mcalester, OKThe homebuilt helicopter was departing on a local flight, when, on initial climbout, the low time, inexperienced student pilot made an abrupt maneuver which sent the helicopter into an uncontrolled descent. It impacted trees and a post crash fire occurred.Oct 10, 1988 · N137A · DestroyedNTSB ANC89LA007Accident · No injuriesLimited investigationFinal reportCessna 207 · Perde Bay, AKThe pilot experienced a power loss during cruise flight and during his descent the engine stopped producing power. He landed on the tundra and the airplane was substantially damaged. An engine teardown revealed that the number 4 piston was burned past…Oct 10, 1988 · N9965M · Substantial damageNTSB SEA89LA009Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Skykomish, WAThe plt made an apch over tall trees to land on a 2050 ft strip. The acft touched down on wet turf with about 500 ft of rwy remaining. The plt was unable to stop the acft on the remaining rwy. Subsequently, it contd off the departure end & went into a large…Oct 9, 1988 · N6651N · Substantial damageNTSB NYC89LA018Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-35C · Methuen, MAPilot uncontrolled contact with a tree during a landing after the pilot failed to connect his aileron controls and accepted a tow to get airborne.Oct 9, 1988 · N2737H · Substantial damageNTSB NYC89LA009Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Rutland, VTThe accident sequence was observed by two pilots who were awaiting takeoff at the approach end of the rwy in use. One of the pilots reported that the plt of the acdt acft advised him that the acdt acft had encountered ice during the flight. The acdt acft was…Oct 9, 1988 · N9431R · DestroyedNTSB NYC89LA008Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5B · Wrightstown, NJThe plt said that the battery ran low while he was attempting to start his acft. He said he hand-propped the eng for several minutes and when he became fatigued, the passenger, who is also a pilot, began to hand prop the eng. When the passenger turned the…Oct 9, 1988 · N666GA · No damageNTSB NYC89FA007Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Akron, NYThe Piper PA-18-135 stalled on takeoff and crashed. Witnesses said they observed the aircraft nose high, not climbing, and at a slow airspeed. They reported that the aircraft banked left and struck trees. The aircraft descended through the trees to the ground…Oct 9, 1988 · N8179C · DestroyedNTSB MKC89LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · West Memphis, ARThe pilot said he was unable to activate the runway lights on the designated frequencies during a night personal flight. He attempted to land without the aid of the runway lights, and touched down on the FAR end of the runway subsequently running off the end…Oct 9, 1988 · N734BK · Substantial damageNTSB DEN89LA013Accident · Minor injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe plt, with two pax aboard a hot air balloon, participated in the 1988 Albuquerque, NM international balloon fiesta. The plt said he received a wx briefing and then departed in VFR wx conditions. After aprx 45 min of flt, the plt said he encountered…Oct 9, 1988 · N3592C · Substantial damageNTSB DEN89FA010Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Albuquerque, NMPlt-rated pax told plt, coronado arpt 'in sight'. Plt was suspicious because loran indicated arpt was 3 mi away but trusted former instrument student's judgment & landed at closed alameda arpt instead of coronado arpt. Coronado UNICOM had told plt 'multiple…Oct 9, 1988 · N7228P · DestroyedNTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILOct 9, 1988 · N4717D · Substantial damageNTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…Oct 9, 1988 · N98395 · Substantial damageNTSB CHI89LA006Accident · No injuriesLimited investigationFinal reportBeech 55B · Quincy, ILThe pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise.Oct 9, 1988 · N8769R · Substantial damageNTSB CHI89LA003Accident · No injuriesLimited investigationFinal reportChampion 7EC · Bainbridge, OHOct 9, 1988 · N9836Y · Substantial damageNTSB CHI89LA002Accident · No injuriesLimited investigationFinal reportCessna 152II · Ashland, OHWhile enroute on a cross country flight from buffalo, new york to mansfield, Ohio, the aircraft experienced a total loss of engine power. The pilot performed emergency procedures and executed a forced landing in a farmer's open field. The pilot stated that…Oct 9, 1988 · N49135 · Substantial damageNTSB ATL89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Hatteras, NCThe plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &…Oct 9, 1988 · N17223 · Substantial damageNTSB MKC89FA004Accident · Serious injuriesField investigationFinal reportHughes 500C · Branson, MOThe flight was conducted for sightseeing with 5 passengers onboard. The pilot turned on final approach with 35 knots of airspeed and encountered a high rate of descent. The pilot reported that he noted a split tach and initiated an autorotation, but was…Oct 8, 1988 · N506WW · Substantial damageNTSB MIA89LA007Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Flora, MSAfter dispensing a chemical load, the plt was rtrng to re-load when the eng began running rough. He said he noted the fuel flow was erratic, so he turned on the boost pump. The eng stabilized momentarily, then smoke entered the cockpit & the eng began…Oct 8, 1988 · N2896J · DestroyedNTSB LAX89LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Concord, CAThe pilot stated that during the landing roll he lost directional control of the airplane and veered left of the runway centerline. The pilot stated that the left rudder was stuck in a fully deflected position and his attempt to add right rudder was…Oct 8, 1988 · N8162T · DestroyedNTSB FTW89LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Navasota, TXAcft struck a tree during a night forced landing following an eng failure in cruise flt. The eng failure was caused by fuel exhaustion. The flt had been airborne for 4 hours and 44 minutes; however, the plt had calculated that he had sufficient fuel to make…Oct 8, 1988 · N51112 · Substantial damageNTSB FTW89DRG02Accident · 1 fatalFinal reportDouglas A-20G · San Benito, TXIncapacitation of the pilot while flying an aircraft due to loss of consciousness from a cardiac rhythm disturbance.Oct 8, 1988 · N67921 · DestroyedNTSB DEN89LA012Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pueblo, COThe commercial plt & his pvt plt wife were flying x-country on vacation. While en route, the eng began running rough & lost power. Drg an emergency dscnt, the plt restarted the eng & initiated a climb to select a better lndg site, but the eng lost power…Oct 8, 1988 · N102EC · Substantial damageNTSB DEN89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Delta, UTOn a x-country flt, the plt elected to make a refueling stop at Delta, UT. He transmitted on UNICOM freq & got no reply,but noted a light wind favoring rwy 30 & rwy 34. He elected to land on rwy 30. He said that on final apch, he looked fortraffic to rwy 34,…Oct 8, 1988 · N75666 · Substantial damageNTSB CHI89FA005Accident · Minor injuriesField investigationFinal reportPiper PA-28 · Schaumburg, ILEngine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence.Oct 8, 1988 · N4608R · DestroyedNTSB CHI89DET01Accident · 1 fatalFinal reportVolksplane VP-1 · Coldwater, MIA stall with entry into the incipient stage of a spin with insufficient altitude for recovery.Oct 8, 1988 · N131JT · Substantial damageNTSB ATL89LA010Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greensboro, NCThe plt had landed at southeast Greensboro earlier. He departed on rwy 35 and remained in closed traffic for landing. The td was made in the first 100 feet of the downsloped rwy at about 70 mph. The flaps were retracted and the plt reptd that a gust of wind…Oct 8, 1988 · N29550 · Substantial damageNTSB ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.Oct 8, 1988 · N7704C · Substantial damageNTSB NYC89IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Newark, NJThe #3 eng suffered an uncontained turbine blade failure during a takeoff roll. The takeoff was aborted at 120 KTS without further incident. Investigation revealed that all 12 tierods for the 2nd stage low compressor suffered a progessive failure. This…Oct 7, 1988 · N118FE · Minor damageNTSB NYC89FA006Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Renovo, PAImproper VFR procedures the pilot's visual lookout was improper and he collided with a static wire.Oct 7, 1988 · N7293W · DestroyedNTSB LAX89T#A01Accident · Serious injuriesFinal reportMcdonnell Douglas F-18A · Edwards, CAOct 7, 1988 · N844NA · DestroyedNTSB LAX89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Porterville, CADuring a dual instructional flight, the pilot lost directional control of the airplane while landing. The airplane veered left. When the pilot corrected to the right, the left main landing gear collapsed. The airplane nosed over and came to rest on the right…Oct 7, 1988 · N2141C · Substantial damageNTSB LAX89FA010Accident · 1 fatalField investigationFinal reportCessna 182R · Salinas, CAThe pilot failed to follow published missed approach procedures. Factors contributing to the accident were the pilot lack of recent experience in type of operation, instrument go-around procedures, and the cloud covered mountainous terrain.Oct 7, 1988 · N1787R · DestroyedNTSB DEN89FA009Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMBefore dawn, witnesses (who were preflighting an acft) saw N732QP taxiing to rwy 4. They heard an eng run-up; however, they were unable to see the acft takeoff due to heavy fog that had just moved over the arpt. (The witnesses decided to cancel their flt due…Oct 7, 1988 · N732QP · DestroyedNTSB ATL89LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lexington, NCDuring final approach to rwy 26 a crosswind shifted to a tailwind. The plt rprtd a full flap/carb heat touchdown was made despite 14 knots airspeed. Insufficient rwy remained and full throttle was applied for go-around. Flaps and carb heat were not…Oct 7, 1988 · N736EK · Substantial damageNTSB ATL89LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Savannah, GAWhile landing with a left x-wind, the acft veered to the left & went off the rwy. Subsequently, the nose gear collapsed in soft terrain. The plt thought tower personnel had told him the wind was from 030 deg at 9 KTS. A check of the transcript revealed that…Oct 7, 1988 · N7769N · Substantial damageNTSB ATL89FA006Accident · 1 fatalField investigationFinal reportCessna 210N · Alexander City, ALThe airplane crashed about 2 mi short of the destination arpt. Witnesses reported that it impacted nose down after clearing trees; no engine sounds were heard. According to rescue personnel, the plt indicated that there were no engine or other mechanical…Oct 7, 1988 · N6510N · Substantial damageNTSB SEA89LA008Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Cashmere, WAPlt landed short of hard surface, collapsing lndg gear.Oct 6, 1988 · N75107 · Substantial damageNTSB NYC89LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAThe CFI and student plt were practicing touch and go landings. The CFI said the landing was long and the aircraft was not quite aligned with the rwy. By the time the aircraft was realigned and under control the CFI thought there was insufficient rwy to stop…Oct 6, 1988 · N2542D · DestroyedNTSB MIA89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · La Belle, FLThe pilot while on a ferry permit flight experienced a failure of the #4 cyl of the left engine and did not attain the vyse speed and the aircraft started to descend. The pilot ditched the aircraft in a lake and it was not recovered. No records on the engines…Oct 6, 1988 · N6815Y · Substantial damageNTSB MIA89LA005Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Miami, FLThe pilot stated that he was having problems with the elevator trim and elected to land the amphibious acft in the bay. He acknowledged and witnesses observed him lower the landing gear prior to attempting to land on the water. The aircraft flipped inverted…Oct 6, 1988 · N3263G · Substantial damageNTSB LAX89DVG01Accident · Serious injuriesFinal reportGlasair FT · Redding, CAOn takeoff, plt's canopy came open. When plt diverted attention to close canopy, acft collided with a tree, then terrain. Investigation revealed no canopy latch malfunction. Post acc exam showed that the plts canopy latches were undamaged.Oct 6, 1988 · N197RL · DestroyedNTSB FTW89DRG01Accident · No injuriesFinal reportShamgaugh Pitts Special · San Benito, TXImproper torquing of the 'b' nut fitting on the main fuel supply line to the powerplant at the firewall and the pilot's inadequate pre-flight inspection.Oct 6, 1988 · N3S · Substantial damageNTSB DEN89LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Price, UTThe pilot was performing a business flight over mountainous terrain. About 1 hr into the flight, he noticed smoke or oil vapor in the cockpit. He saw oil on the lower cowling and wing and communicated his position and problem to the salt lake city ARTCC. The…Oct 6, 1988 · N7335N · Substantial damageNTSB BFO89LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sandston, VAThe plt said he was on final apch about 600 to 800 ft AGL when power loss occurred. He forced landed on an open field about 1/2 mi short of the rwy. The eng exam revealed that two teeth of the idler gear had separated. This resulted in a loss of continuity…Oct 6, 1988 · N739PE · Substantial damage