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 LAX99LA303Accident · 1 fatalLimited investigationFinal reportNye KR-2 · Mariposa, CAThe pilot's failure to maintain an adequate airspeed margin while performing an intentional steep right bank turning maneuver, which resulted in a stall/mush and descent into terrain.Sep 15, 1999 · N71KN · DestroyedNTSB ANC99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKCorrosion and a fatigue failure of the lower end of the landing gear strut. Factors in the accident were the manufacturer's and the FAA's insufficient standards/requirements for life limits and inspection procedures.Sep 15, 1999 · N85LC · Substantial damageNTSB LAX99LA307Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Azusa, CAthe pilot's delay in recognizing the settling with power condition while performing a pinnacle approach, thus delaying his attempted go-around.Sep 14, 1999 · N8328Q · Substantial damageNTSB DEN99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Greeley, COThe pilot's inadvertent ground loop during landing roll. Factors were the malfunctioning self centering locking device on the tail wheel, the right rear quartering tail wind, and the 3 to 4 inch high berm along the edge of the runway.Sep 14, 1999 · N3329A · Substantial damageNTSB DCA99RA084Accident · 6 fatalForeign investigationDassault Falcon 900 · Bucharest, RomaniaSep 14, 1999 · SXECHNTSB DCA99RA083Accident · Serious injuriesForeign investigationBoeing 757 · Gerona Spain, SpainSep 14, 1999NTSB ATL99LA130Accident · No injuriesLimited investigationFinal reportCessna 182P · Summerville, GAThe missing throttle linkage bolt from the carburetor due to an improper engine installation by maintenance personnel. Factors were the tailwind present during the landing roll and the trees.Sep 14, 1999 · N6863M · Substantial damageNTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.Sep 13, 1999 · N5337L · Substantial damageNTSB MIA99LA253Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homestead, FLThe pilot's failure to obtain the proper touch down point on landing and excessive airspeed resulting in an overrun, and subsequent collision with a fence post and clippings.Sep 13, 1999 · N2145N · Substantial damageNTSB IAD99WA066Accident · Minor injuriesForeign investigationKaman K1200 · Austria, AustriaSep 13, 1999 · DHFZA · DestroyedNTSB FTW99LA257Accident · No injuriesLimited investigationFinal reportCessna 150J · Frisco, TXFuel exhaustion due to the pilot's inadequate preflight and his failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Sep 13, 1999 · N50495 · Substantial damageNTSB ATL99LA129Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Caledonia, MSThe failure of the fuel control gear train due to oil contamination. A factor was Inadequate maintenance.Sep 13, 1999 · N45205 · Substantial damageNTSB ANC99LA144Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Heiden, AKThe pilot's selection of unsuitable terrain for landing.Sep 13, 1999 · N3017G · Substantial damageNTSB ANC99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKA loss of engine power for an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.Sep 13, 1999 · N1886P · Substantial damageNTSB SEA99LA159Accident · 2 fatalLimited investigationFinal reportGentry Series 5 Vixen · Naples, IDThe pilot's failure to maintain adequate airspeed during a turn back toward the departure surface, resulting in a stall.Sep 12, 1999 · N199DG · DestroyedNTSB NYC99LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Manassas, VAThe pilot's failure to recover from a sideslip maneuver, and flare the airplane before touchdown.Sep 12, 1999 · N5125Z · Substantial damageNTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.Sep 12, 1999 · N8313R · Substantial damageNTSB NYC99LA224Accident · 1 fatalLimited investigationFinal reportNorth American T6-G · Falmouth, KYThe pilot's misjudgment of altitude/clearance on approach which resulted in an in-flight collision with trees.Sep 12, 1999 · N7767C · Substantial damageNTSB NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.Sep 12, 1999 · N3508R · Substantial damageNTSB NYC99FA222Accident · 2 fatalField investigationFinal reportCessna 337C · North Adams, MAthe failure of the pilot of the Cessna 305 to follow the instructions issued, and maintain a low altitude. A factor was the delay in evasive action by the pilot of the Cessna 337 after he was first advised that the Cessna 305 was climbing.Sep 12, 1999 · N973FS · 2 aircraft · DestroyedNTSB MIA99LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · St. Petersburg, FLthe pilots improper use of the hand brake during the landing roll out and his failure to maintain directional control, which resulted in the airplane exiting the runway and incurring substantial damage.Sep 12, 1999 · N8051P · Substantial damageNTSB MIA99FA252Accident · No injuriesField investigationFinal reportBoeing B737-300 · West Palm Beach, FLThe fatigue fracture and separation of the high pressure turbine forward rotating air seal due to a manufacturing defect in a bolt hole that was not detected by the engine manufacturer due to inadequate and ineffective inspection techniques. Contributing to…Sep 12, 1999 · N17356 · Substantial damageNTSB LAX99LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe pilot's failure to maintain an adequate visual lookout during taxi. Sun glare was a factor in the accident.Sep 12, 1999 · N534CA · Substantial damageNTSB LAX99LA305Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Klamath, CAA loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in conditions conducive to icing.Sep 12, 1999 · N3348F · Substantial damageNTSB LAX99LA304Accident · Minor injuriesLimited investigationFinal reportGlover Teenie TWO · Chino, CAThe in-flight separation and loss of the carburetor fuel jet resulting from the pilot's improper installation of the component. Also causal was the pilot's failure to maintain an adequate airspeed margin following the loss of power, which resulted in an…Sep 12, 1999 · N925SG · DestroyedNTSB LAX99LA302Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · Los Angeles, CAThe lavatory service driver's failure to follow established company procedures and directives. A factor in the accident was the airline's use of a one person pushback procedure.Sep 12, 1999 · N388UA · Substantial damageNTSB FTW99LA270Accident · No injuriesLimited investigationFinal reportAeronca 7-AC · Fort Worth, TXThe failure of the pilot to maintain directional control of the airplane during the landing roll.Sep 12, 1999 · N81800 · Substantial damageNTSB FTW99LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Jeanerette, LAThe pilot's failure to attain the proper touchdown point resulting in the aircraft overrunning the runway on landing roll. A factor was the gusty crosswind condition.Sep 12, 1999 · N2751F · Substantial damageNTSB FTW99LA258Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Smith, ARThe failure of the electric pump motor/hydraulic power pack resulting in the collapse of the right main landing gear upon landing.Sep 12, 1999 · N9724B · Substantial damageNTSB FTW99FA256Accident · 1 fatalField investigationFinal reportSpagnoletti AIR Command 582 · Conroe, TXThe pilot's failure to maintain aircraft control during the takeoff/initial climb. A factor was the pilot's lack of recent experience in the type of aircraft.Sep 12, 1999 · N813AC · DestroyedNTSB CHI99LA339Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Ann Arbor, MIThe pilot's improper touchdown during a water landing.Sep 12, 1999 · N1137L · Substantial damageNTSB SEA99LA163Accident · No injuriesLimited investigationFinal reportStinson V77 · Tacoma, WAThe pilot-in-command's inadvertent use of heavier than normal braking during the landing roll. A contributing factor was the gusty wind conditions.Sep 11, 1999 · N69386 · Substantial damageNTSB SEA99LA160Accident · No injuriesLimited investigationFinal reportCessna 172M · Tahola, WAThe pilot's inadequate directional control and his failure to maintain clearance from trees along the side of the landing area. Factors include a landing area surrounded by tall trees.Sep 11, 1999 · N8995V · Substantial damageNTSB MIA99WA254Accident · No injuriesForeign investigationPiper PA-23-250 · Gustavia, WNSep 11, 1999 · N5966Y · Substantial damageNTSB MIA99LA256Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, GAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during.Sep 11, 1999 · N6757W · Substantial damageNTSB MIA99LA251Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30 · Athens, GAThe pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.Sep 11, 1999 · N6676V · Substantial damageNTSB CHI99LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Daleville, INA loss of engine power for undetermined reasons.Sep 11, 1999 · N172DJ · Substantial damageNTSB ATL99LA131Accident · Minor injuriesLimited investigationFinal reportHiller UH-12A · Satartia, MSThe pilot's failure to maintain control of the helicopter while on approach which resulted in the uncontrolled collision with the ground. A factor was the pilot's physiological condition.Sep 11, 1999 · N212W · Substantial damageNTSB ATL99FA127Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Carthage, MSThe pilot-in-command's failure to maintain altitude clearance while maneuvering. A factor was the pine trees.Sep 11, 1999 · N26801 · Substantial damageNTSB ANC99LA146Accident · No injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot/mechanic's improper damage repair, and intentional operation (ferry) of the airplane with known deficiencies. Factors in the accident were the installation of the improper nose gear assembly, and the inadequate surveillance and issuance of a special…Sep 11, 1999 · N1881X · Substantial damageNTSB ANC99LA143Accident · No injuriesLimited investigationFinal reportDiehl Interstate S-4 · Anchorage, AKThe pilot's inadequate planning/decision, and his failure to maintain directional control of the airplane. Factors in the accident were a short runway/lake area for departure, and the pilot's extension of the landing gear steering system (water rudders)…Sep 11, 1999 · N4BZ · Substantial damageNTSB ANC99LA141Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, snow-covered terrain, and self-induced pressure to continue the search.Sep 11, 1999 · N6099Y · Substantial damageNTSB SEA99LA161Accident · No injuriesLimited investigationFinal reportWild Goose A1 · Keizer, ORA loose fuel line fitting resulted in a loss of engine power. An intentional wheels down landing was a factor.Sep 10, 1999 · N3451 · Substantial damageNTSB SEA99LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, WALoss of directional control due to deficient brakes and tailwheel. Factors include leaking brake cylinder, loose tailwheel casting, and obstructions (VASI lights) in the path of the airplane as it left the runway.Sep 10, 1999 · N3476D · Substantial damageNTSB MIA99FA250Accident · Serious injuriesField investigationFinal reportMbb BO105CBS · Kenansville, FLThe pilots failure to recognize entry into settling with power during approach to land and his failure to take remedial action to escape from settling with power resulting in the helicopter descending and colliding with trees and swampy terrain.Sep 10, 1999 · N911HR · Substantial damageNTSB CHI99LA337Accident · 1 fatalLimited investigationFinal reportReichert MJ-77 · Owosso, MIthe pilot's improper preflight which resulted in a takeoff with the oil cap not secured and the subsequent loss of engine power.Sep 10, 1999 · N51MJ · Substantial damageNTSB ANC99LA140Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, snow-covered terrain, and self-induced pressure to continue the search.Sep 10, 1999 · N6052C · Substantial damageNTSB ANC99FA139Accident · Serious injuriesField investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's continued flight into instrument meteorological conditions (IMC), and inadequate altitude/clearance. Factors associated with the accident were flat light and whiteout conditions, snow, and snow-covered terrain. An additional factor was the FAA's…Sep 10, 1999 · N6007S · DestroyedNTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.Sep 9, 1999 · N4065P · Substantial damageNTSB MIA99WA262Accident · No injuriesForeign investigationPiper PA-31-310 · Nicholls Town, BahamasSep 9, 1999 · N6579L · Destroyed