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 ANC89LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Eagle, AKThe pilot-in-command was attempting to air drop groceries to a mining site and a box of bread hit the horizontal stabilizer. The aircraft returned and landed uneventfully at Eagle airport.Oct 6, 1988 · N734GW · Substantial damageNTSB MIA89LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLWhile practicing maneuvers near a grass airstrip, the left side of the engine cowling opened. The plt elected to perform a low pass to observe wind direction, then a precautionary landing at the airstrip. After touchdown, the acft became airborne and drifted…Oct 5, 1988 · N91323 · Substantial damageNTSB MIA89FA004Accident · No injuriesField investigationFinal reportHughes 269C · Vero Beach, FLThe plt stated that while doing a stuck left pedal maneuver, the helicopter was flown with a 5 degree yaw to the left. As the airspeed zeroed, the collective was brought in to bring the nose around and light contact was made with the ground. He then stated…Oct 5, 1988 · N8602F · DestroyedNTSB LAX89LA009Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Alpine, CADuring a telephone interview, the pilot stated that he had just recovered from a one turn spin and was in level flight when he felt the airplane pitch up. He added a small amount of nose down trim and the airplane pitched down. He stated that at this point…Oct 5, 1988 · N5508H · DestroyedNTSB DEN89FA007Accident · 3 fatalField investigationFinal reportMooney M20E · Walsh, COThere is no record plt obtained wx briefing, filed flt plan, or obtained in-flt wx advisories. Plt and two pax departed san marcos, TX, at 1400 CDT in VMC, enroute to springfield, CO. Acft was seen by two witnesses at aprx 1630 MDT, 11 mi w of Walsh, CO,…Oct 5, 1988 · N5997Q · DestroyedNTSB ATL89FA005Accident · Serious injuriesField investigationFinal reportCessna 120 · Monroe, GAThe pilot was returning to land when he experienced a complete engine failure. The pilot reported completing a before landing check and rechecked the carburetor heat following the initial power loss. The sequence of events were typical of carburetor ice…Oct 5, 1988 · N77458 · DestroyedNTSB SEA89LA007Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Fields, ORThe plt rprtd that as he was in a slow descending turn to the left at about 20 KTS (translational lift). The helicopter suddenly rotated to the left without warning. He estimated that this occurred at about 30 ft AGL. He applied right pedal & the rotation…Oct 4, 1988 · N401S · Substantial damageNTSB SEA89FA006Accident · No injuriesField investigationFinal reportBeech B-99A · East Sound, WAThe crew elected to depart the airport under a special VFR clearance. Wx at the departure airport was 700 ft ovc with visibility 1 and 1/4 miles. The destination airport was within 25 nautical miles of the departure airport and was reporting a bkn ceiling of…Oct 4, 1988 · N803BA · Substantial damageNTSB LAX89LA008Accident · No injuriesLimited investigationFinal reportCessna 182A · Visalia, CAA Cessna 182A & a Boeing A75 collided on the rwy. The pilot of the Boeing stated that he was doing touch & go ldgs & had the ldg Cessna in sight. The Boeing plt then lost site of the Cessna after it touched down on rwy 30. The Boeing plt assumed the Cessna…Oct 4, 1988 · N5888B · 2 aircraft · Substantial damageNTSB LAX89LA007Accident · No injuriesLimited investigationFinal reportHughes 269C · Fontana, CAThe pilot was demonstrating a run-on landing for his passenger when the accident occurred. The pilot reported that he allowed the tail of the helicopter to get too low and it collided with the terrain. There were no mechanical difficulties reported prior to…Oct 4, 1988 · N1090Z · Substantial damageNTSB DEN89LA006Accident · No injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Rawlins, WYThe pvt plt in command and his atp-rated pax were ferrying the newly-purchased acft from FL to WA. They departed scottsbluff, NE, and were enroute to rock springs, WY, when the pax advised the plt insufficient VFR fuel reserves precluded continuing to rks.…Oct 4, 1988 · N21SP · Substantial damageNTSB DEN89LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe commercial Balloon plt and one pax were participating in a Balloon fiesta. The acft took off from Albuquerque, on a local flight in light winds. At altitude, the Balloon encountered easterly winds that carried the Balloon southwest of Albuquerque, where a…Oct 4, 1988 · N3678E · Substantial damageNTSB DEN89LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally II · Rio Rancho, NMThe commercial balloon plt and one pax were participating in a balloon fiesta. The acft took off from albuquerque, on a local flight in calm winds. At altitude, the balloon encountered south winds that carried the balloon to Rio Rancho, where a landing was…Oct 4, 1988 · N4098G · Substantial damageNTSB NYC89FA003Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Barnstead, NHThe Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite…Oct 3, 1988 · N9569E · DestroyedNTSB LAX89FA006Accident · 2 fatalField investigationFinal reportBeech A24R · Mt. Baldy, CAPilot's improper in-flight decision and altitude.Oct 3, 1988 · N8065R · DestroyedNTSB LAX89FA001Accident · 1 fatalField investigationFinal reportBeech B23 · Scottsdale, AZThe pilot's mismanagement of fuel. Contributing to the accident was the inadequate lighting of the fuel selector valve.Oct 3, 1988 · N7621R · DestroyedNTSB DEN89LA003Accident · Minor injuriesLimited investigationFinal reportPiccard AX-6 · Albuquerque, NMThe commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,…Oct 3, 1988 · N99US · Substantial damageNTSB ANC89LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Healy Lake, AKAfter waiting for more favorable wind conditions, the student pilot and his passenger attempted a departure from a dirt strip surrounded by trees. The non-rated passenger stated that 'after becoming airborne and climbing slightly above the treetops, it felt…Oct 3, 1988 · N3421A · Substantial damageNTSB ANC89LA004Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Eureka Lodge, AKThe pilot was attempting to land at dusk on a snow covered, unlighted private airstrip. He stated that he was attempting to land as close to the landing threshold as possible to avoid a large bump in the middle of the runway. He misjudged his approach and…Oct 3, 1988 · N98109 · Substantial damageNTSB ANC89LA003Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKWhile flying through a mountain pass the pilot encountered a high wind condition. The pilot lost control of the airplane, and the airplane crashed at the 900 foot level.Oct 3, 1988 · N122SC · Substantial damageNTSB SEA89LA003Accident · No injuriesLimited investigationFinal reportLet L-13 · Enumclaw, WAThe pilot allowed the aircraft to become too close to terrain while soaring. A steep turn to reverse direction resulted in entry into an accelerated stall at low altitude. The pilot lowered the nose of the aircraft to recover, however, while lowering the nose…Oct 2, 1988 · N9241Z · Substantial damageNTSB SEA89FA002Accident · 2 fatalField investigationFinal reportCessna T210M · Prosser, WAThe flight was on initial climb after takeoff at 400 AGL when the engine quit. During the ensuing forced landing, the aircraft impacted on an interstate highway perpendicular to the roadway, bounced into open pasture land, impacted a rock berm and burst into…Oct 2, 1988 · N1817M · DestroyedNTSB SEA89FA001Accident · 3 fatalField investigationFinal reportCessna Robertson 337A · Eliza Island, WAThis Cessna/robertson 337 was departing from a 1600 foot grass strip in VFR conditions. There were gusting head winds estimated at 15 knots. At the midpoint of the runway the aircraft made a steep climbing left turn, stalling after about 180 degrees of turn.…Oct 2, 1988 · N6314F · DestroyedNTSB NYC89LA002Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Derry, NHThe acft collided with trees after takeoff from a private airstrip with a rwy which has 1,200 feet useable length. The field elev is 425 ft and the plt EST the temp to be 60 deg f. the plt said the takeoff was made to the NE. The wind was reported to be out…Oct 2, 1988 · N2715A · DestroyedNTSB MKC89LA002Accident · No injuriesLimited investigationFinal reportCessna 140 · Quinter, KSThe pilot was flying at reduced power without the use of carburetor heat. The aircraft engine began to run rough. The pilot added carburetor heat and full throttle which resulted in the engine backfiring. The pilot elected to execute a precautionary landing.…Oct 2, 1988 · N73051 · Substantial damageNTSB MKC89LA001Accident · No injuriesLimited investigationFinal reportSchweizer TG3A · Yoder, KSAn abrupt maneuver resulting in a stall/spin and subsequent aircraft control not being maintained by the pilot in command.Oct 2, 1988 · N73483 · Substantial damageNTSB LAX89LA005Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZThe acft collided with the terrain shortly after an intersection tkof from the Tucson international airport. The plt reported that during the initial climb the a/c was not producing sufficient lift in order to maintain alt to clear obstacles. The plt aborted…Oct 2, 1988 · N8998U · Substantial damageNTSB LAX89LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Auberry, CAThe pilot was unfamiliar with the area that he was attempting to land in and circled to familiarize himself with the terrain. He then made a low pass over the dirt runway and circled to land. The first attempt was discontinued because the pilot felt that he…Oct 2, 1988 · N20680 · DestroyedNTSB LAX89LA003Accident · No injuriesLimited investigationFinal reportCessna 150F · Payson, AZThe aircraft collided with an obstacle during a go-around from the red creek private dirt strip. The plt reported that he had never landed at the 2000 ft, dirt strip and had no other short or soft field takeoff/landing practice beyond his instruction at an…Oct 2, 1988 · N8681S · DestroyedNTSB LAX89LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Palmdale, CAAt approximately 6000 ft MSL two airplanes collided in flight. N49382 was climbing to altitude, N31386 was descending in a shallow left turn. The airplane descending colliding with the climbing airplane from behind and to the right. Both airplanes were able…Oct 2, 1988 · N31386 · 2 aircraft · Substantial damageNTSB FTW89LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXOct 2, 1988 · N89745 · Substantial damageNTSB CHI89LA001Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Tell City, INThe pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…Oct 2, 1988 · N8157Q · DestroyedNTSB BFO89LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cumberland, MDThe pilot stated that shortly after takeoff at an altitude of aprx 150 ft AGL, the engine sputtered and lost power. According to the police report, the pilot attempted to return to the airport. During the turn the wingtip contacted the ground and the airplane…Oct 2, 1988 · N7653D · Substantial damageNTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…Oct 2, 1988 · N6176K · Substantial damageNTSB ATL89FA004Accident · 1 fatalField investigationFinal reportPiper PA-30 · La Follette, TNThe pilot reported an autopilot problem and was not able to maintain control of the airplane. The airframe components were scattered in a circular pattern. All fractures displayed overload failures. The wreckage examination failed to disclose any system or…Oct 2, 1988 · N7484Y · DestroyedNTSB ANC89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Levelock, AKThe airplane was at approximately 250 to 300 feet above sea level, and was executing a 360 degree turn to the left when the airplane stalled and crashed in the river. The pilot reported that he has never held a FAA pilot or medical certificate.Oct 2, 1988 · N4724M · Substantial damageNTSB ANC89LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · Wasilla, AKDrg arrival to land on a lake at night, the plt began a 180 deg turn from a NE heading at aprx 500' AGL to a final apch on a sw heading. As the acft was in the turn, it began losing altitude rapidly. The plt applied power to stop the descent, but the acft…Oct 2, 1988 · N420SB · Substantial damageNTSB SEA89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Fork, IDThe pilot flew the aircraft into a box canyon at dawn. The aircraft was unable to outclimb rising terrain. The aircraft impacted heavily wooded terrain at a slow airspeed at 8,000 feet MSL about 50 yards short of the crest.Oct 1, 1988 · N7548R · DestroyedNTSB SEA89LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Bellingham, WADrg the initial climb after takeoff, the eng lost power. Subsequently, the acft was damaged drg an emergency landing in a rough field northwest of the arpt. A post-acdnt eng run-up was made with a club prop installed. The eng operated normally to 1500 RPM…Oct 1, 1988 · N2068Q · Substantial damageNTSB SEA88LA191Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Troutdale, ORThe plt rprtd that soon after takeoff, he realized there was insufficient power. Subsequently, the acft mushed into trees & a raspberry field & was damaged. An exam of the eng revealed a piece of the carburetor heat muff had broken off & was ingested into the…Oct 1, 1988 · N9550W · Substantial damageNTSB NYC89LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mayville, NYWhile on short final for landing, the flt encountered turbulence and began settling over trees located near the end of the runway. In the attempt to go around the plt allowed the acft to decelerate. The acft drifted 30 degrees right of the runway and crashed…Oct 1, 1988 · N3112Z · Substantial damageNTSB MKC88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Harrison, ARWhile in normal cruise flt, the plt declared an emergency. He stated the eng had failed & that he thought it had 'thrown a rod.' Subsequently, the acft was extensively damaged drg an emerg landing in a wooded area. An investigation revealed the #6 connecting…Oct 1, 1988 · N3943S · Substantial damageNTSB MKC88FA183Accident · 3 fatalField investigationFinal reportBeech D55 · N. Little Rock, ARThe pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC…Oct 1, 1988 · N7826R · DestroyedNTSB MIA89LA002Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Fort Lauderdale, FLThe plt stated that aprx 15 minutes after takeoff from Fort Lauderdale, the eng quit completely & he was unable to make it back to the arpt. While attempting a forced landing in a field, he landed nose down, the nose gear collapsed, and the acft slid to a…Oct 1, 1988 · N8076R · Substantial damageNTSB MIA89LA001Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Orlando, FLWhile practicing hovering the helicopter began to drift. The instructor plt corrected this & returned control to the student plt. The helicopter then began to descend & the instructor plt attempted to correct this with collective, but the student plt applied…Oct 1, 1988 · N2628B · Substantial damageNTSB LAX88DVA17Accident · No injuriesFinal reportHiller UH12E · Mcfarland, CAOct 1, 1988 · N46991 · Substantial damageNTSB FTW89DPA01Accident · Minor injuriesFinal reportShannon J-BIRD · Mckinney, TXThe plt rprtd he was making a high speed taxi test of his gyroplane after installation of a different eng & prop. He said the gyroplane enctrd a bump on the rwy which caused it to become airborne at about 35 mph (takeoff speed was 45 mph). He added power to…Oct 1, 1988 · N151JS · Substantial damageNTSB DEN89LA002Accident · Minor injuriesLimited investigationFinal reportCessna TP206B · Durango, COThe private plt was practicing landings in his acft. During takeoff ground run, while making a touch and go landing, the plt reported experiencing vibrations from both main gear and his acft departed the 5,000 x 50 ft rwy to the left. The plane traveled 100…Oct 1, 1988 · N4732F · Substantial damageNTSB DEN89FA001Accident · 2 fatalField investigationFinal reportCessna 152 · Eden, UTBefore takeoff, the plt told ramp psnl that he & his wife were planning to take some pictures of the beautiful fall colors. A witness near the crash site observed an acft (matching the description of N48926) flying at low altitude. Subsequently, the acft…Oct 1, 1988 · N48926 · DestroyedNTSB CHI88FA249Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Columbus, OHAerodynamically stalled lifting surface causing an uncommanded pitch over at an altitude too low to affect a recovery.Oct 1, 1988 · N14HR · Destroyed