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 LAX88LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Agua Dulce, CAThe pilot attempted a takeoff from a 2,900 ft MSL elevation airport when the observed unofficial outside air temperature was a reported 105 degrees fahrenheit. Although no exact pressure altitude was available an approximate density altitude of 6,300 was…Jul 16, 1988 · N33043 · Substantial damageNTSB LAX88LA259Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Corona, CADuring takeoff the engine failed to develop full power & the acft collided with trees located approx 500 ft beyond the runway. Exam of the engine revealed the mixture control arm at its fuel pump housing attachment point had restricted movement & was…Jul 16, 1988 · N736HQ · Substantial damageNTSB LAX88FA258Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Compton, CAThe student plt was taking his 2 grandchildren & 1 of their friends on a local flt. Ground witnesses observed the airplane lift off and continue in an excessively high angle of attack climb attitude. When the airplane reached abt 150 ft a.g.l. it stalled,…Jul 16, 1988 · N40808 · DestroyedNTSB LAX88DUG05Accident · No injuriesFinal reportCosta TEENY-TWO · Corona, CAThe homebuilt teeny-two acft was built with a 40 HP, british reliant, hawk ae eng, rather than a volkswagon eng which builders normally used. It had been flown only one time before the acdnt flt. The 1st flt was made in cooler temp conds without incident; the…Jul 16, 1988 · N5428R · Substantial damageNTSB FTW88DRG11Accident · No injuriesFinal reportEnstrom F28A · Port Isabel, TXThe pilot reported that he had accomplished a max-performance takeoff, cleared an obstacle, and when he attempted forward flight, the main rotor RPM decreased. He stated he was unable to recover the RPM and maintain altitude so he selected a landing area. Due…Jul 16, 1988 · N9087 · Substantial damageNTSB FTW88DRD14Accident · Serious injuriesFinal reportGrumman G-164A · Crowley, LAThe agricultural pilot was working in a field which had telephone lines at one end and power lines at the other. On his last run, as he started his pull up, the airplane struck the power lines at one end of the field. The airplane went through the power…Jul 16, 1988 · N8580H · DestroyedNTSB CHI88LA168Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Menominee, MIDuring a demonstration of an autorotation to a run-on landing, the helicopter skids dragged in the soft grass upon touchdown, and the helicopter veered to the left. The pilot failed to maintain aircraft control when the helicopter veered left, the right skid…Jul 16, 1988 · N280FX · Substantial damageNTSB CHI88DEM07Accident · No injuriesFinal reportSilliman Hatz CB-1 · Battlecreek, MIWhile attempting to execute a forced landing due to an engine failure, the pilot misjudged his emergency procedure and collided with trees then the gnd during the descent to the fairway he had selected for landing. The engine failure was due to fuel…Jul 16, 1988 · N24DS · Substantial damageNTSB SEA88LA132Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Wrangell, AKPlt attempted flight through a mountain pass in the presence of low clouds and fog. Visual ground reference was lost and the acft collided with a snow bank. Plt cited personal and company-induced pressures as factors. Operator completed accident report.Jul 15, 1988 · N55CX · Substantial damageNTSB MKC88LA127Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Lowell, ARAbout one hour after takeoff, the plt noted that the eng began to run rough. He reduced the power to 2000 RPM & enriched the mixture. He continued flying for about another hour, then the eng lost power. The plt attempted an emergency landing on a frontage…Jul 15, 1988 · N3738X · Substantial damageNTSB MKC88LA126Accident · No injuriesLimited investigationFinal reportRockwell S2R · England, ARThe plt said he had been flying under power lines during an aerial application operation, and while performing his downwind pass, an updraft caused him to collide with the bottom wires. He lost control of the aircraft and collided with the terrain.Jul 15, 1988 · N4186X · Substantial damageNTSB LAX88LA268Accident · No injuriesLimited investigationFinal reportRaven S-60A · Bakersfield, CADuring a sightseeing flight, while on final approach, the balloon collided with power lines. The wires arced starting a fire which damaged the balloon envelope. The plt did not file an acc report. The plts last medical exam was on 7/3/79.Jul 15, 1988 · N2789Z · Substantial damageNTSB LAX88LA257Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmdale, CAWhile cruising at 9500 feet, the pilot noted that the oil pressure was low. Shortly after, the engine quit. The pilot turned toward an airport, however, the airplane was landed short of the runway and nosed over in soft sand during the landing roll.…Jul 15, 1988 · N46373 · Substantial damageNTSB FTW88LA134Accident · No injuriesLimited investigationFinal reportBell 47G2 · Port O'Connor, TXThe pilot stated that he turned downwind during hover practice, allowed the main rotor RPM to decrease, and settled with power to a hard landing. The front portion of the skids impacted first and the main rotor blades struck the tail boom. The pilot was not…Jul 15, 1988 · N47WJ · Substantial damageNTSB DEN88LA159Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Gallup, NMJul 15, 1988 · N772WM · Substantial damageNTSB DEN88LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gallup, NMThe private plt & his wife were starting a cross-country personal transportation flt. The acft was loaded to near max gwt, & the fss had reported a density alt of 9,600 ft to the plt. After takeoff on a 6,300 x 100 ft, asphalt rwy, the plt said the acft…Jul 15, 1988 · N1578J · Substantial damageNTSB DEN88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Gillette, WYJul 15, 1988 · N5903B · Substantial damageNTSB CHI88DEX09Accident · Serious injuriesFinal reportSollars Rotorway Executive · Newburgh, INThe eng lost power as the homebuilt helicopter was on an apch to land at a private heliport. The student plt rprtd the helicopter was at aprx 50 ft AGL when the power loss occurred. Subsequently, during an autorotation, the helicopter touched down hard. No…Jul 15, 1988 · N3047 · Substantial damageNTSB ATL88DKG10Accident · No injuriesFinal reportCessna 188 · Douglas, GAJul 15, 1988 · N91217 · Substantial damageNTSB SEA88LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Athol, IDThe student pilot was practicing full stop landings. He failed to raise the flaps from full down after the previous landing. On the subsequent takeoff, the aircraft became airborne prematurely. The pilot reduced the power and the aircraft stall/mushed onto…Jul 14, 1988 · N2886S · Substantial damageNTSB NYC88FA181Accident · 1 fatalField investigationFinal reportCessna 421 · Taunton, MABfr rchg his destn, the plt adzd apch ctl that his rgt eng was 'blowing some smoke' & losing oil pressure. Vectors were provided for a visual apch, but there were low clouds in the area & vis was restricted due to haze. After reaching the vcnty of the arpt,…Jul 14, 1988 · N825DW · DestroyedNTSB LAX88LA255Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Pilot Hill, CADuring a local sightseeing flight, just prior to touchdown, the Pilot reported that a gust of wind caught the balloon. The Pilot made a high wind landing. The balloon was dragged several feet before coming to rest. The Pilot stated that afterward the winds…Jul 14, 1988 · N2614M · No damageNTSB LAX88FA256Accident · Serious injuriesField investigationFinal reportCessna T210M · Carson, CAThe pilot failed to follow the emergency procedures as outlined in the pilot operating handbook by switching the fuel selector to the fullest tank. Contributing to this accident was fuel exhaustion of the right wing tank as a result of fuel siphoning.Jul 14, 1988 · N732QZ · DestroyedNTSB FTW88FA131Accident · 1 fatalField investigationFinal reportAerospatiale SA330J · Gulf-Of-MexicoNone submittedJul 14, 1988 · N47307 · DestroyedNTSB FTW88DRD13Accident · Serious injuriesFinal reportGrumman G-164A · Kinder, LAThe pilot was spraying a fungicide on the field and the owner of the field was flagging for him, on the top of a dike, on the west end of the field. During normal operation, the flagman stayed in position until the airplane was 300 feet away, at which time he…Jul 14, 1988 · N8512H · Minor damageNTSB DEN88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallup, NMPrior to takeoff from the 6469 ft MSL airport, the pilot leaned the mixture at 2000 RPM. Density altitude was aprx 9100 ft MSL. The 10-DEG flap takeoff and climbout to 300 ft AGL was said to be normal initially; then the aircraft began losing altitude…Jul 14, 1988 · N48055 · Substantial damageNTSB CHI88IA165Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Chicago, ILJul 14, 1988 · N253A · No damageNTSB ATL88LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Michie, TNWitness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…Jul 14, 1988 · N19632 · Substantial damageNTSB SEA88LA129Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA315B · Oakridge, ORWhile slinging a log the pilot allowed the log/sling line to contact a tree. The momentum of the log and helicopter bowed the tree over when the line contacted it. The pilot chose to release the log from the sling line rather than disengage the entire line…Jul 13, 1988 · N3128G · DestroyedNTSB SEA88LA127Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Haines, AKThe pilot purchased the helicopter with an undocumented modification designed to restrain the collective. Reportedly, hereceived no guidance regarding the use of the collective hold-down device. According to the aircraft manufacturer there existed no Enstrom…Jul 13, 1988 · N8620C · Substantial damageNTSB SEA88LA126Accident · Minor injuriesLimited investigationFinal reportBeech C23 · The Dalles, ORCFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing.Jul 13, 1988 · N18823 · Substantial damageNTSB NYC88LA201Accident · No injuriesLimited investigationFinal reportBell 206B · Plymouth, MAA loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area.Jul 13, 1988 · N543CC · Substantial damageNTSB MKC88FA124Accident · 1 fatalField investigationFinal reportCessna 172G · Sarcoxie, MOWitnesses at the acdnt site characterized the wx as having a low ceiling with fog. They rprtd they saw the acft 'appear out of clouds' in a steep descent. The acft then began to 'pull up;' however, during recovery from the dive, the acft struck trees &…Jul 13, 1988 · N4288L · DestroyedNTSB MIA88LA221Accident · No injuriesLimited investigationFinal reportHahn RV-4 · Zellwood, FLFlt experienced rough running engine and loss of power. As acft was turned toward agricultural strip for an emergency landing the engine failed completely. The plt touched down short of the runway and bogged down in tall grass and muck causing collapse of the…Jul 13, 1988 · N144TH · Substantial damageNTSB MIA88LA220Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Key West, FLWhile turning the acft around at the operator's establishment after completing a sightseeing flt, the lower left wing collided with a vehicle.Jul 13, 1988 · N99Y · Substantial damageNTSB LAX88FA254Accident · Serious injuriesField investigationFinal reportSikorsky S-58BT · Marina Del Rey, CAMismanagement of the fuel system by the pilot which resulted in fuel starvation and a duel engine flameout. Contributing to the accident was the pilot's lack of total experience in the Sikorsky S58T.Jul 13, 1988 · N94AH · Substantial damageNTSB LAX88FA251Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Compton, CAStudent pilots failure to adequately remove moisture from the fuel system during his preflight inspection which led to a loss of engine power during a critical phase of flight.Jul 13, 1988 · N6926B · DestroyedNTSB DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…Jul 13, 1988 · N3541Z · DestroyedNTSB CHI88LA166Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-21-G · Elyria, OHJul 13, 1988 · N77AQ · Substantial damageNTSB SEA88LA128Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVAcft were ascending in the same thermal during national soaring competition and collided in flight. N554T sustained loss of the horizontal tail in collision, followed by loss of control in flight. The pilot parachuted safely. N130JB sustained minor damage and…Jul 12, 1988 · N554T · 2 aircraft · DestroyedNTSB NYC88IA186Incident · No injuriesIncident investigationFinal reportMBB BK-117 · Manhattan, NYFailure of the main rotor blade appears to be the result of a static downward bending overstress, caused by another helicopter hovering over or very close to the main rotor blade as it was in a static/stopped position.Jul 12, 1988 · N135CP · Minor damageNTSB MIA88LA219Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Palm City, FLThe plt stated that he landed long on a dirt and grass road. During landing roll, he applied heavy brakes to stop the acft. The acft swerved to the left. He unsuccessfully tried to regain control. The a/c went down an embankment and the left wing dug into a…Jul 12, 1988 · N8502V · Substantial damageNTSB LAX88LA253Accident · No injuriesLimited investigationFinal reportCessna T210L · Bakersfield, CADuring the landing roll, the right brake failed to hold. The airplane veered to the left, off the runway and collided with a runway light. Inspection of the brake revealed that there was no fluid in the system. No leaks were discovered during the exam of the…Jul 12, 1988 · N60856 · Substantial damageNTSB LAX88FA252Accident · 1 fatalField investigationFinal reportBeech A35 · Lompoc, CAPilot's improper use of the fuel system and his failure to maintain control of his aircraft. Contributing factors were the pilot's intentional operation of an aircraft with known deficiencies in equipment, his improper emergency procedure and his lack of…Jul 12, 1988 · N27EB · DestroyedNTSB FTW88LA130Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot landed on the private strip to pick up a passenger. The pilot reported that after takeoff he smelled smoke and almost immediately, the engine started cutting out. The airplane impacted the tops of tall trees, thena fence, and then impacted…Jul 12, 1988 · N25999 · Substantial damageNTSB FTW88DRD15Accident · No injuriesFinal reportCessna A188B · Patterson, LAShortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…Jul 12, 1988 · N4825Q · Substantial damageNTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…Jul 12, 1988 · N6083A · Substantial damageNTSB DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…Jul 12, 1988 · N7940Z · Substantial damageNTSB CHI88DEP06Accident · No injuriesFinal reportHuntley Challenger II · Platteville, WIAfter climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…Jul 12, 1988 · N51012 · Substantial damageNTSB ATL88FA213Accident · Serious injuriesField investigationFinal reportBell TH-1L · Walterboro, SCThe military surplus helicopter experienced a 42 degree gear box failure while lifting a load of logs. The helicopter subsequently landed hard as the plt was attempting to autorotate to a ldg. Metallurgical examination of the gearbox revealed that a gear…Jul 12, 1988 · N465JR · Substantial damage