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 MIA88LA237Accident · No injuriesLimited investigationFinal reportMooney M-20E · Punta Gorda, FLThe plt stated he kept his acft outdoors & he had not flown it for 7 days. He stated he had not refueled the acft after the last flt & had parked it with 1/2 tanks. Fss personnel stated there had been rain showers in the area during that time. The plt stated…Jul 26, 1988 · N9369M · Substantial damageNTSB LAX88DVA09Accident · Serious injuriesFinal reportStephenson U-2 · Porterville, CADuring a pleasure flight, while soaring with the engine at idle, the flying wing motor glider inadvertently entered a stall. The pilot did not recover from the stall and the airplane began to spin. The pilot was able to regain control at approximately 50 feet…Jul 26, 1988 · N9192V · DestroyedNTSB FTW88IA141Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Kenton, DEA flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section…Jul 26, 1988 · N14336 · Minor damageNTSB DEN88IA167Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Denver, COWhile taxiing to the cargo ramp, the left wing collided with a lightpole as the flight crew were directed by gnd pers. One taxi director attempted to handoff the flight to another but the second misunderstood and turned away. A third person, who was not a…Jul 26, 1988 · N1973 · Minor damageNTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…Jul 26, 1988 · N3016V · Substantial damageNTSB NYC88FA193Accident · 1 fatalField investigationFinal reportCessna 150J · Palmyra, NYCessna N51413 departed Palmyra airpark with full flaps and crashed into a barn about 75 feet past the departure end of runway 35. Afterward, the flap actuator was found in the flap up position. The pilot said that the engine lost 200 to 300 RPM about 300 feet…Jul 25, 1988 · N51413 · DestroyedNTSB MKC88LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Underwood, IAThe CFI and student were performing maneuvers near Underwood, IA as part of 14 CFR 61 stu pilot trng. The acft was flown for abt 1/2 hr, prior to the CFI taking control of the acft when the stu experienced a loss of eng pwr during recovery fm a maneuver. The…Jul 25, 1988 · N69240 · Substantial damageNTSB MIA88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Sanford, FLThe CFI stated they had completed 2 touch & go ldgs without incident. On the next, the acft 'suddenly yawed to the left & the side load must have weakened the gear as the gear warning horn began to sound indicating the gear was no longer down & locked'. He…Jul 25, 1988 · N2197K · Substantial damageNTSB MIA88LA236Accident · 1 fatalLimited investigationFinal reportPiper PA-60-700P · Cocoa Beach, FLFlt entered near vertical descent while flying in area of level 1 and 2 thunderstorms just after plt had called requesting permission to deviate around rain showers. A level 5 thunderstorm was present 8 miles west. The acft descended at rates up to 13,800…Jul 25, 1988 · N69RB · DestroyedNTSB LAX88LA291Accident · No injuriesLimited investigationFinal reportCessna T210K · Huntington Bch, CADuring the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an…Jul 25, 1988 · N8273M · Substantial damageNTSB LAX88LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CAThe student plt rprtd that drg a lndg on a solo instructional flt, his final apch was a little fast. Drg the lndg, the airplane began to porpoise. However, before the student regained control, the nose gear collapsed.Jul 25, 1988 · N68342 · Substantial damageNTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…Jul 25, 1988 · N5266J · Substantial damageNTSB DEN88LA166Accident · No injuriesLimited investigationFinal reportKrall Dragonfly · Mitchell, SDDrg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but…Jul 25, 1988 · N42JK · Substantial damageNTSB ATL88FA220Accident · No injuriesField investigationFinal reportPiper PA-28-151 · La Grange, GAThe PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the…Jul 25, 1988 · N4506F · Substantial damageNTSB ANC88LA151Accident · 1 fatalLimited investigationFinal reportCessna U206F · Lake Minchumina, AKThe plt said he was taxiing the floatplane from a windy/wavy location to a small protected cove for a final preflt. While taxiing, the top cap of the left float was open & the float began filling with water. Subsequently, the float- plane rolled over & sank.Jul 25, 1988 · N401SU · Substantial damageNTSB NYC88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Smoketown, PAThe plt reported that the eng lost power at about 300 ft AGL after takeoff. A forced landing was made in a corn field. During the landing roll the aircraft nosed over. The wreckage was examined after the accident and water was discovered in the fuel system.…Jul 24, 1988 · N33743 · Substantial damageNTSB MKC88LA135Accident · No injuriesLimited investigationFinal reportMooney M20-F · Lawrence, KSThe pilot said the engine quit due to fuel exhaustion during a personal cross country flight. He said he tried to glide to his final destination airport, but made an emergency ldg in a farm field about 2 miles short of the airport.Jul 24, 1988 · N6347Q · Substantial damageNTSB MIA88LA233Accident · No injuriesLimited investigationFinal reportCessna 310 · Homestead, FLWhile on a personal flt during normal cruise both engs quit due to fuel exhaustion. The plt attempted to land the acft on a road, after which it departed the road surface, and collided with trees. The plt did not file an acc report.Jul 24, 1988 · N638E · Substantial damageNTSB MIA88IA231Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Miami, FLFlt experienced failure of the number two engine shortly after takeoff when the combustion outer case ruptured. Metallurgical examination revealed the ruptured case had a 1/2 inch crack in it when it went through overhaul 16 cycles before the failure. It was…Jul 24, 1988 · N69AF · Minor damageNTSB MIA88FA234Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Daytona Beach, FLThe acft departed spruce creek arpt and aprx 2 minutes later lost power and crashed into trees just west of the volusia county landfill aprx 4 miles northeast of the Daytona Beach regional arpt. Postcrash examination of the engine revealed the drain line on…Jul 24, 1988 · N28140 · DestroyedNTSB MIA88FA232Accident · 1 fatalField investigationFinal reportRockwell S2R · O'Brien, FLThe purpose of the flt was to spray a soybean field about 1/2 mi n of the airstrip. There are no known witnesses to the crash, but a person in the area heard the eng 'pop', then eng sound ceased; seconds later the sound of impact was heard. The acft struck…Jul 24, 1988 · N4222X · DestroyedNTSB FTW88DRD16Accident · No injuriesFinal reportPZL-Mielec M18 · Bastrop, LAThis ag airplane has a hydraulic system that operates the brakes and flaps. The engine driven hydraulic pump provides pressure to the primary system for normal use and also provides pressure to an accumulator for emergency use. The pressure in the accumulator…Jul 24, 1988 · N46831 · Substantial damageNTSB CHI88DEX10Accident · No injuriesFinal reportWilliams Waco · Madison, INThe plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the…Jul 24, 1988 · N810TW · Substantial damageNTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…Jul 24, 1988 · N6590Z · Substantial damageNTSB BFO88LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Windsor, VAWhile on long final after a glider tow flight the eng lost power. A forced landing was made in an open field and when the plt applied brakes, the acft nosed over. Post accident exam of the acft revealed 1 gallon of fuel remained. The plt reported that he…Jul 24, 1988 · N31253 · Substantial damageNTSB BFO88FA068Accident · 2 fatalField investigationFinal reportCessna R182RG · Stevensville, MDThe acft departed bay bridge arpt at aprx 0415 EDT. The passenger, also a plt, was reading back an IFR clearance to ATC when communication ended in the middle of a sentence without any sign of distress. Comparison of ATC and radar tapes indicates that N9997C…Jul 24, 1988 · N9997C · DestroyedNTSB SEA88LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Coeur D'Alene, IDAfter low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at…Jul 23, 1988 · N8109B · Substantial damageNTSB NYC88LA191Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Pendleton, NYLoss of control of the aircraft after the pilot had hooked the banner.Jul 23, 1988 · N53784 · Substantial damageNTSB MKC88LA122Accident · No injuriesLimited investigationFinal reportRockwell S2R · Brinkley, ARDuring the take-off roll for an aerial application operation, the pilot said he lost his left wheel braking capability. He continued the take-off, flew to the farm field to be treated, applied the load, then returned to a near by alternate landing strip…Jul 23, 1988 · N4080X · Substantial damageNTSB MIA88LA235Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLAfter a normal lndg, during the lndg roll at aprx 50-55 mph, the acft rolled through a 1-2' deep puddle of water. The acft slowed & at aprx 35 mph, the rt main lndg gear slowly began rotating aft. The acft came to rest supported by the rt horizontal…Jul 23, 1988 · N12840 · Substantial damageNTSB LAX88DUD01Accident · Minor injuriesFinal reportFerris VARI-EZE · Hawthorne, CADuring a local flight, while on final approach, the pilot reported that a gust of wind from the right raised the right wing resulting in the left wing contacting the runway. The pilot lost control of the airplane which nosed over during the landing roll.…Jul 23, 1988 · N7YE · Substantial damageNTSB FTW88DRA15Accident · 1 fatalFinal reportAir Command Elite 532 · Baytown, TXAcft was observed to takeoff and turn right crosswind. Drng the crosswind, the RPM increased suddenly. The acft pitched nose downwards, impacted the ground in a vertical descent and burned. The plt/builder had a total of 5 hrs in the new acft. No evidence of…Jul 23, 1988 · N91359 · DestroyedNTSB FTW88DPA05Accident · No injuriesFinal reportLuscombe 8A · Burleson, TXThe airplane was on downwind when the pilot pulled on the carburetor heat and reduced the RPM. When he reapplied power, the engine would not respond. During the forced landing, the pilot got the airplane on the airport but hit the right wing and tailwheel on…Jul 23, 1988 · N25236 · Substantial damageNTSB CHI88LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Greenfield, INDuring a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…Jul 23, 1988 · N83430 · Substantial damageNTSB ATL88FA219Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Winston-Salem, NCN7942N crashed into a building shortly after liftoff from runway 21. The pilot was cleared for a left turnout over runway 33. A witness estimated that the airplane had reached 300 feet when the pilot lost control and crashed. The investigation failed to…Jul 23, 1988 · N7942N · DestroyedNTSB ANC88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe aircraft touched down approximately 2/3 of the way down the runway. During the ldg roll, aircraft hit a rut on the runway. The plane nosed over and came to rest on its back, off the departure end of the rwy. The FAA flt info publication states that this…Jul 23, 1988 · N1773U · Substantial damageNTSB SEA88LA194Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Ephrata, WAThe pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft.Jul 22, 1988 · N33713 · Substantial damageNTSB LAX88LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Redlands, CADuring the takeoff ground run on a solo instructional flight, the student pilot lost control of the airplane. The airplane veered to the left. The pilot applied right rudder, however, the airplane continued to the left, exited the runway and collided with the…Jul 22, 1988 · N9850J · Substantial damageNTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…Jul 22, 1988 · N8719S · Substantial damageNTSB LAX88DUJ06Accident · No injuriesFinal reportGrumman G-164B · Chandler, AZDuring an aerial application flight, the engine experienced a loss of power. A forced landing was made in an open field and during the landing roll the airplane nosed over. Inspection of the engine revealed that the number five cylinder dome separated from…Jul 22, 1988 · N66890 · Substantial damageNTSB FTW88LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Oklahoma City, OKThe air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…Jul 22, 1988 · N2970M · Substantial damageNTSB FTW88LA138Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Sayre, OKThe pilot said that shortly after takeoff, at 200 feet AGL, the engine quit. He tried to land on the remaining runway but the airplane went off left side, then through a ditch. No problems could be found to cause the loss of engine power. The engine was later…Jul 22, 1988 · N771RB · Substantial damageNTSB FTW88DPA04Accident · No injuriesFinal reportAtkins ACRO-SPORT · Fort Worth, TXDuring a personal flight, the engine failed and the pilot made a forced landing into an open field. During the landing, the airplane flipped to the inverted position. Investigation revealed no fuel in the tank or fuel system and no fuel spilled on the ground.Jul 22, 1988 · N5897 · Substantial damageNTSB CHI88LA173Accident · No injuriesLimited investigationFinal reportPiper J-3 · Minneapolis, MNWhile practicing a landing on a solo instructional flight, the student pilot allowed the aircraft to drift off the left side of the runway and strike the VASI lights. The student pilot had only flown 2 hours, including 10 takeoffs and landings, in the past 90…Jul 22, 1988 · N25WF · Substantial damageNTSB CHI88LA171Accident · No injuriesLimited investigationFinal reportCessna 182E · Cedar Springs, MIDuring cruise flight the pilot reported that a total power loss occurred. The pilot executed a forced landing in an open field. On rollout the aircraft struck a stump and then a small shed. The post accident investigation revealed loosefuel caps and no fuel…Jul 22, 1988 · N2859Y · Substantial damageNTSB CHI88DEP07Accident · No injuriesFinal reportCessna 182B · Burlington, WIDrg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but…Jul 22, 1988 · N2486G · Substantial damageNTSB ATL88LA218Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Somerville, TNThe CFI was attempting a demonstration of a forced landing following a simulated loss of engine power. Just as he started to recover and climb back to altitude, the student plt spotted wires and yelled. Company policy required a recovery at 500 ft. the…Jul 22, 1988 · N757YP · Substantial damageNTSB ANC88LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKThe pilot reported that he lost control of the aircraft. The plane crashed approximately 500 feet off the departure end of the airstrip. The flight was a part 135 on-demand air taxi flight. At the time of the accident, the aircraft was above maximum certified…Jul 22, 1988 · N29148 · Substantial damageNTSB SEA88LA135Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Colfax, WAOn departure with a load of chemical, ag plt attempted to outclimb rising terrain ahead. The aircraft collided with terrain in a stall/mush.Jul 21, 1988 · N8974H · Substantial damageNTSB NYC88LA190Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Greenland, NHThe intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…Jul 21, 1988 · N20973 · Substantial damage