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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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.NTSB DCA99RA084Accident · 6 fatalForeign investigationDassault Falcon 900 · Bucharest, RomaniaNTSB DCA99RA083Accident · Serious injuriesForeign investigationBoeing 757 · Gerona Spain, SpainNTSB 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.NTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.NTSB 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.NTSB IAD99WA066Accident · Minor injuriesForeign investigationKaman K1200 · Austria, AustriaNTSB 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.NTSB 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.NTSB ANC99LA144Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Heiden, AKThe pilot's selection of unsuitable terrain for landing.NTSB 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.NTSB 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.NTSB 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.NTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.NTSB 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.NTSB NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI99LA339Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Ann Arbor, MIThe pilot's improper touchdown during a water landing.NTSB 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.NTSB 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.NTSB MIA99WA254Accident · No injuriesForeign investigationPiper PA-23-250 · Gustavia, WNNTSB MIA99LA256Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, GAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during.NTSB 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.NTSB CHI99LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Daleville, INA loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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…NTSB 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)…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.NTSB MIA99WA262Accident · No injuriesForeign investigationPiper PA-31-310 · Nicholls Town, Bahamas