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 ANC98LA073Accident · No injuriesLimited investigationFinal reportLake LA-4 · Saint Mary'S, AKThe pilot's diverted attention during takeoff, and his failure to maintain a proper climb rate. A factor associated with the accident was the presence of birds.Jun 15, 1998 · N19AK · Substantial damageNTSB SEA98LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Independence, ORA loss of power due to fatigue failure and cracking of an engine cylinder barrel.Jun 14, 1998 · N9514P · Substantial damageNTSB LAX98LA198Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Riverbank, CAThe pilot's inadequate visual lookout for on-coming ground traffic.Jun 14, 1998 · N48576 · Substantial damageNTSB LAX98LA197Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe aircraft's encounter with settling with power, which resulted from the pilot's decision to perform a steep downwind approach.Jun 14, 1998 · N110DT · Substantial damageNTSB LAX98LA196Accident · Minor injuriesLimited investigationFinal reportBeech 76 · San Martin, CAFailure of the instructor to adequately supervise the flight, which included ensuring that the student maintained the proper airspeed during the attempted go-around.Jun 14, 1998 · N912KA · Substantial damageNTSB LAX98LA195Accident · 1 fatalLimited investigationFinal reportBlackmore RV-4 · Sedona, AZThe pilot's attempt to perform aerobatics with insufficient terrain clearance altitude available to complete the maneuver. A factor was high density altitude.Jun 14, 1998 · N813R · DestroyedNTSB FTW98LA264Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Hempstead, TXThe pilot's failure to maintain the proper rate of descent. Factor were the pilot's inadvertent lowering of the flaps instead of extending the spoilers, and his lack of experience in gliders.Jun 14, 1998 · N73534 · Substantial damageNTSB DCA98WA055Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Manila, PhilippinesJun 14, 1998 · JA858NTSB ANC98LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Nikiski, AKThe pilot's use of excessive brake application during landing roll.Jun 14, 1998 · N54247 · Substantial damageNTSB LAX98LA194Accident · No injuriesLimited investigationFinal reportScott Dragonfly · Mecca, CAThe pilot's inadequate preflight inspection and his failure to ensure sufficient fuel was in the airplane, which subsequently led to fuel exhaustion. A related factor was the soft terrain.Jun 13, 1998 · N824JC · Substantial damageNTSB FTW98LA268Accident · No injuriesLimited investigationFinal reportCessna 150L · Taft, TXThe pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…Jun 13, 1998 · N10519 · Substantial damageNTSB FTW98LA266Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARA loss of engine power for undetermined reasons.Jun 13, 1998 · N4911R · Substantial damageNTSB FTW98LA265Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Midland, TXThe inadvertent ground loop during the landing roll. A factor was the sudden windshift.Jun 13, 1998 · N42559 · Substantial damageNTSB CHI98LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Albion, MIthe pilot's improper preflight planning/preparation and his not refueling the airplane to avoid fuel exhaustion. Factors were the pilot's lack of certification, his not feathering the engine, and the trees.Jun 13, 1998 · N4617P · Substantial damageNTSB CHI98LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Gregory, SDthe pilot's not maintaining control of the airplane during landing.Jun 13, 1998 · N3596L · Substantial damageNTSB ATL98LA083Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Destin, FLThe pilot's failure to maintain directional control and her failure to maintain adequate obstacle clearance during an attempted go-around. A factor was the pilot's inadequate compensation for the crosswind conditions.Jun 13, 1998 · N55369 · Substantial damageNTSB ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.Jun 13, 1998 · N46129 · Substantial damageNTSB ANC98LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe total loss of engine power for undetermined reasons.Jun 13, 1998 · N70195 · Substantial damageNTSB SEA98LA095Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Starbuck, WAThe pilot-in-command's failure to maintain adequate visual lookout. A contributing factor was the unmarked transmission lines.Jun 12, 1998 · N8252K · DestroyedNTSB FTW98LA267Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Edna, TXThe pilot's inadequate compensation for the existing wind conditions. Factors were the crosswind, the dust devils, and the confined landing area.Jun 12, 1998 · N6107W · Substantial damageNTSB ATL98LA087Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Pensacola, FLThe pilot's inadvertent activation of the parking brakes which resulted in the nose over during the landing roll.Jun 12, 1998 · N53954 · Substantial damageNTSB ATL98LA081Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Nicklesville, GAThe loss of engine power for undetermined reason. A factor was that weather conditions were favorable for the formation of carburetor ice.Jun 12, 1998 · N87027 · Substantial damageNTSB ANC98LA081Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Homer, AKThe loss of engine power due to fuel starvation, and an improper fuel selector valve. Factors in the accident were turbulent wind conditions, the improper replacement of the fuel selector valve by an airplane mechanic, and the failure of an FAA inspector to…Jun 12, 1998 · N1023H · Substantial damageNTSB ANC98LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Angoon, AKThe pilot's failure to maintain directional control during the aborted takeoff. A factor associated with the accident was rough and uneven terrain.Jun 12, 1998 · N171Q · Substantial damageNTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.Jun 11, 1998 · N65918 · Substantial damageNTSB FTW98LA262Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6A · Green River, UTThe pilot's failure to maintain airspeed. Factor's were the unforecasted weather (tail wind) and the inadvertent stall/spin.Jun 11, 1998 · N511M · Substantial damageNTSB SEA98LA093Accident · 1 fatalLimited investigationFinal reportCessna 150 · Amboy, WAThe pilot's failure to maintain adequate altitude and/or clearance from terrain during a go-around attempt. Factors included a short landing area and trees in the landing area.Jun 10, 1998 · N7759E · Substantial damageNTSB NYC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Taunton, MAa delayed decision by the pilot to abort the takeoff, which resulted in an overrun. A factor was false reading from the airspeed indicator.Jun 10, 1998 · N6977P · Substantial damageNTSB NYC98FA127Accident · 3 fatalField investigationFinal reportPiper 601P · Martinsburg, PAThe pilot's failure to maintain airspeed due to spatial disorientation, which resulted in an inadvertent stall and subsequent collision with terrain. A factor in the accident was the low ceiling.Jun 10, 1998 · N60721 · DestroyedNTSB IAD98FA068Accident · 2 fatalField investigationFinal reportBeech F33A · Delaplane, VAThe pilot's inadequate in-flight decision which led to VFR flight into instrument meteorological conditions. Also causal was the pilot's failure to maintain adequate terrain clearance resulting in collision with mountainous terrain. Contributing factors were…Jun 10, 1998 · N6033U · DestroyedNTSB FTW98LA261Accident · Minor injuriesLimited investigationFinal reportGisclair Murphy Renegade SP · Galliano, LAA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.Jun 10, 1998 · N96VG · DestroyedNTSB DCA98WA068Accident · No injuriesForeign investigationBell 205A1 · Paderborn, GermanyJun 10, 1998 · DHAFH · Substantial damageNTSB CHI98LA198Accident · Serious injuriesLimited investigationFinal reportBell 47G · Le Center, MNthe pilot's failure to maintain clearance with the wire. A factor associated with the accident was the wire which the helicopter contacted.Jun 10, 1998 · N73284 · DestroyedNTSB CHI98LA196Accident · No injuriesLimited investigationFinal reportCessna 172K · Omaha, NEThe aircraft modification not being in compliance with the Supplemental Type Certificate. A factor to the accident was the fracture of the landing gear axle during landing.Jun 10, 1998 · N758FY · Substantial damageNTSB CHI98LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Demotte, INThe pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.Jun 10, 1998 · N3933S · Substantial damageNTSB ANC98LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are wind gusts, and a crosswind condition.Jun 10, 1998 · N2902Q · Substantial damageNTSB SEA98LA091Accident · 1 fatalLimited investigationFinal reportStephens Vortex · Chinook, MTThe pilot's failure to maintain aircraft control for an undetermined reason.Jun 9, 1998 · N9261N · DestroyedNTSB SEA98FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Hillsboro, ORImproper installation (bushing), mechanical binding (bushing), mechanical binding (connecting rod), and fatigue within the crankshaft. Contributing factors were inadequate major (engine) overhaul and trees.Jun 9, 1998 · N199JM · DestroyedNTSB CHI98LA194Accident · Serious injuriesLimited investigationFinal reportLeone Smith Mini Plane · Northport, MIthe pilot's not maintaining airspeed, and his lack of total experience in this type of aircraft.Jun 9, 1998 · N5281U · Substantial damageNTSB ANC98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKThe pilot's inadvertent ground loop.Jun 9, 1998 · N5280H · Substantial damageNTSB ANC98LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Chickaloon, AKThe pilot's inadvertent activation of the fuel boost pump selector switch during final approach, which resulted in an overly rich mixture and subsequent loss of engine power.Jun 9, 1998 · N9855X · Substantial damageNTSB ANC98FA069Accident · No injuriesField investigationFinal reportCessna 207A · Juneau, AKThe failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…Jun 9, 1998 · N96AK · Substantial damageNTSB MIA98LA180Accident · No injuriesLimited investigationFinal reportRobert E. Bean Wittman Tailwind W10 · Daytona Beach, FLThe pilot's poorly planned approach for not planning the intended touchdown point farther down the runway to avoid an area of known turbulence caused by terrain. Contributing to the accident was the turbulence.Jun 8, 1998 · N173RS · Substantial damageNTSB LAX98LA193Accident · No injuriesLimited investigationFinal reportSaab-Scania 91B · Redding, CAThe failure of the pilot to maintain control of the aircraft during an aborted takeoff, which resulted in a ground loop. A factor is the pilot's improper use of carburetor heat during takeoff.Jun 8, 1998 · N6370L · Substantial damageNTSB LAX98LA190Accident · No injuriesLimited investigationFinal reportFones Z-MAX 1300 · Buckeye, AZthe failure of the pilot to maintain control of the aircraft during the landing approach, and his poor in-flight planning in making an off-airport landing at an unsuitable landing area.Jun 8, 1998 · N140FF · Substantial damageNTSB LAX98FA189Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Lytle Creek, CAthe pilot's intentional VFR descent into instrument meteorological conditions, resulting in a collision with mountainous terrain.Jun 8, 1998 · N16344 · DestroyedNTSB LAX98FA188Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Bangor, CAThe pilot's attempted flight into instrument meteorological conditions, loss of spatial orientation, and the resultant loss of airplane control. Contributing factors were his improper preflight and in-flight decisions, overconfidence in his personal ability,…Jun 8, 1998 · N9703C · DestroyedNTSB ANC98LA066Accident · No injuriesLimited investigationFinal reportCessna 188B · Talkeetna, AKThe pilot's failure to identify an unsafe/hazardous taxiway condition. A factor associated with this accident was the presence of rough and uneven terrain conditions.Jun 8, 1998 · N9247G · Substantial damageNTSB SEA98FA089Accident · 1 fatalField investigationFinal reportMooney M20A · Canyon Creek, MTThe design stress limits of the aircraft was exceeded. The pilot's inadequate preflight planning/preparation, lack of an instrument rating, poor weather evaluation and low ceilings and mountain obscuration were factors.Jun 7, 1998 · N1048B · DestroyedNTSB MIA98WA183Accident · No injuriesForeign investigationAero Commander 681 · Fresh Creek, Congo - KinshasaJun 7, 1998 · N100GL · Substantial damage