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 DEN88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Conrad, MTThe plt reported that he was making a lt turnaround to begin a swath run. He said the acft slowed while in a steep lt bank at the highest part of the turn and he was unable to raise the lt wing as the acft approached the ground. The lt wing and main landing…Jun 27, 1988 · N9856P · Substantial damageNTSB DEN88FA141Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Capitan, NMJun 27, 1988 · N29318 · DestroyedNTSB BFO88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Cambridge, MDThe pilot had departed ocean city, MD aprx 20 minutes after takeoff when nearing the chesapeake bay at an alt of 3000 ft MSL, a total loss of engine power was experienced. The plt attempted to restart the engine to no avail and a forced landing was made in a…Jun 27, 1988 · N21312 · Substantial damageNTSB ATL88IA195Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124A · Hebron, KYDuring en route climb, the left engine failed and the crew executed a safe single engine landing. Examination of the engine revealed an uncontained HP turbine failure in the engine. Metallurgical examination of the failed parts indicated improper steel alloy.…Jun 27, 1988 · N600J · Minor damageNTSB ANC88LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Barter Island, AKThe 5100 hour commercial pilot had landed at a remote lake on an air taxi flight to pick up three passengers. On the ensuing takeoff attempt, he elected to abort the takeoff due to what he felt was an insufficent amount of lake remaining for a successful…Jun 27, 1988 · N53042 · Substantial damageNTSB SEA88LA118Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov IS-29D · Athol, IDPlt was on third flt in make/model. Witness stated approach was too low and slow to make airport. Acft made a turn to the left and then to the right. Wing dropped and acft entered stall/spin to the right and continued rotation to the ground.Jun 26, 1988 · N91419 · DestroyedNTSB LAX88LA235Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Agua Dulce, CAThe plt completed his participation in the 'bomb drop' portion of an air show and he attempted to land on rwy 22. The plt reported that his touchdown was normal but he lost control of his acft during the landing rollout. The wind direction was variable & its…Jun 26, 1988 · N96384 · Substantial damageNTSB LAX88LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · La Grange, CAJun 26, 1988 · N4833E · Substantial damageNTSB FTW88FA125Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Anson, TXInadequate weather evaluation-pic; flight into known adverse weather, inadvertent-pic; design stress limits exceeded by PIC; thunderstormJun 26, 1988 · N2889N · DestroyedNTSB DEN88LA137Accident · No injuriesLimited investigationFinal reportBell 206B3 · Missoula, MTA check airman and a commercial plt were performing an instructional flt. During climbout after a practice autorotation, the engine out audio and light warning activated. Both pilots verified an actual engine out and entered an autorotation. The helicopter…Jun 26, 1988 · N2754A · Substantial damageNTSB DEN88FA138Accident · 2 fatalField investigationFinal reportDouglas A-26C · Cimarron, NMThe plt rcvd a wx briefing before takeoff, but did not file a flt plan. Drg the flt, the acft (Douglas A-26C, N4813E) crashed in mountainous terrain at an elev of about 11,200' near baldy mountain. Scouting personnel, who were camped in the vicinity, rprtd…Jun 26, 1988 · N4813E · DestroyedNTSB BFO88LA061Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Salisbury, MDBefore the flt, the crew received a severe wx warning concerning wx along the route of flt. The captain informed the flight attendants to be prepared to have passenger service completed early and to be seated before the descent. Before encountering…Jun 26, 1988 · N9040U · No damageNTSB ATL88LA201Accident · No injuriesLimited investigationFinal reportCessna 172M · Meridianville, ALThe plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…Jun 26, 1988 · N5075R · Substantial damageNTSB ANC88LA071Accident · No injuriesLimited investigationFinal reportCessna 180H · Big River, AKWhile taxiing on the lake the aircraft's right float struck a log causing the aircraft's left wing to strike the water.Jun 26, 1988 · N9939V · Substantial damageNTSB SEA88LA117Accident · Serious injuriesLimited investigationFinal reportCessna 210G · Bend, OROn arrival in area of planned fuel stop, pax did not feel well. Plt determined that adequate fuel remained to continue to final destination. However, exhaustion occurred 8 miles short of destination. Plt diverted from initial forced lndg site (road) due…Jun 25, 1988 · N5923F · DestroyedNTSB NYC88LA170Accident · Serious injuriesLimited investigationFinal reportBell 47J2 · Newburyport, MAThe helicopter departed runway 10 at plum island airport, turned left over the plum island river and shortly thereafter the engine quit. The pilot stated that no warning was noted and a check of the instruments indicated no problems. He further stated that…Jun 25, 1988 · N51711 · DestroyedNTSB MIA88FA206Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Madeira Beach, FLWitnesses stated that the acft was flying about 20 feet above the bay when the left wing dipped into the water. The airplane cartwheeled and sank. Witnesses said the aircraft had been buzzing homes and boats all along the coast, from clearwater south to the…Jun 25, 1988 · N15986 · DestroyedNTSB LAX88LA233Accident · No injuriesLimited investigationFinal reportHughes 269B · Big Bear, CAWhile cruising, the plt perceived he was experiencing a loss of engine & rotor RPM. The plt stated that he attempted to regain RPM by autorotating. The RPM was regained in the autorotative descent. The plt elected to continue the descent to a landing. Upon…Jun 25, 1988 · N9350F · Substantial damageNTSB FTW88LA126Accident · No injuriesLimited investigationFinal reportCessna 150F · Temple, TXAfter the descent, the pilot applied power and the engine started running rough. The pilot was able to get the engine running at full power within several minutes but it quit completely approximately 3 to 4 miles from the airport. The airplane was landed in…Jun 25, 1988 · N8979S · Substantial damageNTSB DEN88LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Ogden, UTThe low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…Jun 25, 1988 · N5113W · Substantial damageNTSB DEN88LA135Accident · Serious injuriesLimited investigationFinal reportBell 47G · Terry, MTThe aircraft was on a ferry flight from alpine, WY. To belfield, ND. The plt departed alpine at approximately 0950 and made several enroute stops to refuel. The plt intended to land at miles city, MT to refuel but he got lost and flew to Terry, MT, located 38…Jun 25, 1988 · N2243W · Substantial damageNTSB CHI88LA142Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kenosha, WIThe pilot was picking up the aircraft after being serviced when approximately 20 minutes after taking off the engine quit. The pilot was forced to make an emergency landing in a field. During the landing sequence the aircraft contacted some trees at the edge…Jun 25, 1988 · N84405 · Substantial damageNTSB CHI88FA143Accident · No injuriesField investigationFinal reportShort Brothers SC.7 · Cleveland, OHFatigue failure on the radius between the body of the nose landing gear and the portion containing the arms.Jun 25, 1988 · N30GA · Substantial damageNTSB BFO88LA059Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talcott, WVAccording to a witness, the acft was maneuvering at a low altitude when it contacted trees. The acft then descended, impacting the terrain 45 ft from the trees and slid aprx 110 ft before coming to rest. The plt stated that due to injuries he is unable to…Jun 25, 1988 · N9504S · DestroyedNTSB ATL88LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Andrews, NCThe pilot failed to establish a proper apch profile and experienced a hard landing. The hard landing caused the main landing gear to collapse, and the airplane veered off of the left side of the runway. A witness located near the runway confirmed that the…Jun 25, 1988 · N59039 · Substantial damageNTSB ANC88LA072Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Creek, AKAccording to the pilot he made a landing on the gravel bar. Shortly after touchdown the pilot lost directional control and ground looped. The acft struck a tree stump and collapsed the left lndg gear.Jun 25, 1988 · N2987G · Substantial damageNTSB SEA88LA116Accident · No injuriesLimited investigationFinal reportTeratron Tierra 2 · Kent, WAPlt was intentionally taxiing on grass between paved runway and taxiway for better tailwheel control. The acft struck an unseen obstruction in dusk conditions.Jun 24, 1988 · N488JL · Substantial damageNTSB MKC88LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Trousdale, KSDuring a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,…Jun 24, 1988 · N6525F · Substantial damageNTSB MIA88LA205Accident · No injuriesLimited investigationFinal reportCessna 182R · Tampa, FLThe plt rprtd that drg the takeoff roll, he 'rotated aircraft at 65 kts' but it would not become airborne. He then aborted the takeoff, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit a ditch & nosed over. An exam of the flt…Jun 24, 1988 · N9658X · Substantial damageNTSB LAX88LA232Accident · No injuriesLimited investigationFinal reportBeech B35 · Weaverville, CAJun 24, 1988 · N5354E · Substantial damageNTSB FTW88LA124Accident · No injuriesLimited investigationFinal reportMooney M20J · Portland, TXThe pilot dragged the lower empennage on the runway during the takeoff rotation. A premature liftoff resulted and the aircraft recontacted the runway twice before the aircraft passed the runway end. Thereafter, the aircraft collided with a powerline before…Jun 24, 1988 · N201ZP · Substantial damageNTSB LAX88WA237Accident · No injuriesForeign investigationBeech A33 A · La Piedad, MexicoJun 23, 1988 · N25FP · Substantial damageNTSB LAX88LA231Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stonyford, CADuring a cross country flight, the pilot was flying 500 feet AGL over mountainous terrain when a strong downdraft was encountered. The airplane was unable to climb out of it and subsequently collided with the terrain.Jun 23, 1988 · N4792B · Substantial damageNTSB LAX88FA230Accident · 4 fatalField investigationFinal reportCessna 310 · Big Bear Lake, CAThe recently certificated multiengine pilot and friends flew to big Bear airport for lunch. The density altitude at the airport was about 8,000 feet. The pilot entered a south downwind leg for runway 07 at the airport following a Mooney 231. Ground witnesses…Jun 23, 1988 · N170R · DestroyedNTSB LAX88DVG06Accident · No injuriesFinal reportCessna 188 · Upper Lake, CAThe acdt occurred drg an aerial app flt. The pilot reported that he had flown 6 or 7 flights earlier in the day. Each flight the load was reduced due to the increasing temperature of the day. Just prior to the accident, the pilot reported that the takeoff…Jun 23, 1988 · N4946Q · DestroyedNTSB FTW88LA123Accident · No injuriesLimited investigationFinal reportBeech B-24R · Blanchard, OKAccording to the private pilot in the left front seat, this was a training flight set up by the commercial pilot flight instructor in one of the rear seats. The private pilot in the left front seat was to practice for his commercial flight test and the…Jun 23, 1988 · N9162S · Substantial damageNTSB CHI88LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Portage, WIDuring taxi from landing the pilot failed to maintain adequate visual lookout and taxied onto a runway in front of an aircraft on its landing roll. The pilot stated that as he approached the other runway his visibility was restricted by a stand of trees, and…Jun 23, 1988 · N44753 · 2 aircraft · Substantial damageNTSB CHI88DEX05Accident · No injuriesFinal reportBeech V35A · Seymour, INAircraft was in cruise flight at 6500 feet when engine began to run rough. Pilot navigated to nearest airport and made intentional gear-up landing with cruise power. Postcrash investigation revealed number 2 exhaust valve had failed and become wedged between…Jun 23, 1988 · N7892R · Substantial damageNTSB BFO88LA058Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Moundsville, WVThe helicopter contacted power lines shortly after takeoff from a mine site. The nose gear of the helicopter contacted an uninsulated static wire. This wire was strung with one other static wire and two black insulated power lines. Both crew members stated…Jun 23, 1988 · N54C · DestroyedNTSB ANC88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Bethel, AKThe 276 hour private pilot attempted to take off from the Bethel airport, Bethel, AK., on runway 36 in a left crosswind condition given by the tower as 280 degrees at 10 knots. The pilot stated that shortly after the takeoff roll began, the left wing lifted…Jun 23, 1988 · N5630H · Substantial damageNTSB MKC88LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARThe pilot did not adequately secure the aircraft prior to hand-propping the engine. The engine started and resulted in the aircraft taxiing without a pilot at the controls. The pilot-less aircraft impacted a utility pole causing substantial damage.Jun 22, 1988 · N8644H · Substantial damageNTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.Jun 22, 1988 · N3634C · DestroyedNTSB LAX88LA229Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dorris, CADuring a local pleasure flt, just as the airplane touched down, an antelope ran across the rwy. The plt swerved the airplane to avoid the animal, exited the runway and collided with the terrain. There were no mechanical failures or malfunctions with the…Jun 22, 1988 · N5042P · Substantial damageNTSB DEN88LA134Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Big Timber, MTThe plt said he was spraying 2,4,d on two barley flds. He had completed one fld and was turning around when the acft began to settle. He said when he attempted to avoid ground contact the acft stalled and collided with the ground. During a telephone…Jun 22, 1988 · N4970J · Substantial damageNTSB CHI88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Noblesville, INDuring initial climbout the pilot stated that he experienced a partial loss of power and was unable to maintain sufficient rate of climb to continue flight. The pilot executed a forced landing in a field, striking trees. Post-accident investigation failed to…Jun 22, 1988 · N36472 · Substantial damageNTSB CHI88LA138Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Howell, MIJun 22, 1988 · N757CD · Substantial damageNTSB CHI88IA141Incident · No injuriesIncident investigationFinal reportSwearingen SA226-TC · Chicago, ILFailure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke.Jun 22, 1988 · N329BA · No damageNTSB ATL88FA200Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Myrtlewood, ALJun 22, 1988 · N780GM · DestroyedNTSB ATL88FA199Accident · 1 fatalField investigationFinal reportLuscombe 8A · Horse Shoe, NCA witness reported that he was irrigating a newly cultivated corn field with a spray irrigation machine. He heard and then observed the accident airplane fly through or just over a gap in the trees at the northeast end of the field. The airplane proceeded to…Jun 22, 1988 · N1144B · DestroyedNTSB ATL88FA198Accident · 1 fatalField investigationFinal reportCessna 150 · Eastman, GAThe accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.…Jun 22, 1988 · N4282U · Destroyed