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 LAX96LA182Accident · No injuriesLimited investigationFinal reportCessna 402C · St Johns, AZthe pilot's inadequate compensation for the wind conditions, his use of an overly excessive approach speed, and his misjudged distance/altitude relationship to the runway. The wind was a factor.NTSB LAX96LA165Accident · No injuriesLimited investigationFinal reportCessna T210N · Paradise, CAthe pilot's failure to follow landing gear extension procedures by not confirming that the gear was fully extended prior to touchdown. A contributing factor was the interference/alteration of the pilot's customary habit pattern due to his response to a…NTSB ANC96LA046Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Anchorage, AKThe pilot's failure to select the proper fuel tank prior to takeoff resulting in fuel starvation. A factor in the accident was the pilot's failure to follow the checklist.NTSB MIA96LA113Accident · 2 fatalLimited investigationFinal reportSnowbird 636D4 · Okeechobee, FLthe failure of the main rotor control connecting rod, which rendered the control stick unusable and led to a loss of control.NTSB MIA96LA111Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Plains, GAthe pilot misjudging distance and speed during the approach, and his failure to obtain the proper touchdown point on landing.NTSB IAD96LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot's failure to maintain control of the accident aircraft during the landing roll. Factors were the wet portion of the grass runway and the pilot's selection of a landing runway with a 10 knot quartering tailwind.NTSB FTW96LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Silver City, NMthe student pilot's failure to maintain directional control. A Factor was the crosswind.NTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.NTSB CHI96LA129Accident · Minor injuriesLimited investigationFinal reportCessna T310Q · Minneapolis, MNthe inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.NTSB FTW96LA173Accident · No injuriesLimited investigationFinal reportAeronca 65-TAF · Roanoke, TXthe pilot's failure to maintain directional control during landing.NTSB FTW96LA167Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Akron, COa total loss of engine power due to failure of the number 2 cylinder. A factor was the limited cockpit visibility due to windscreen damage and engine oil coating.NTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…NTSB LAX96LA163Accident · No injuriesLimited investigationFinal reportCessna 185F · Placerville, CAthe CFI's failure to take adequate remedial action to preclude the loss of direction control during landing rollout.NTSB IAD96LA058Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlantic Ocean (Atlantic Ocean)the in-flight encounter with unforecast, unexpected turbulence.NTSB FTW96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Boerne, TXThe pilot's improper planning/decision, and his failure to use all of available runway. Factors relating to the accident were: the pilot's overconfidence in the ability of the airplane, the high density altitude, the tailwind, and trees at the departure end…NTSB MIA96WA110Accident · Minor injuriesForeign investigationde Havilland DH6 · Virgin Gorda, British Virgin IslandsNTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.NTSB LAX96LA159Accident · Serious injuriesLimited investigationFinal reportGage VARI-EZE · Chino, CAthe pilot's excessive initial climb attitude and his failure to maintain adequate airspeed. The pilot's diverted attention to the unlatched canopy warning light, and his lack of familiarity with the aircraft were factors.NTSB FTW96LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bellville, TXthe pilot's excessive approach/landing airspeed and his failure to perform a go-around.NTSB FTW96LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Midlothain, TXthe pilot's failure to maintain obstacle clearance.NTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…NTSB SEA96LA078Accident · Minor injuriesLimited investigationFinal reportSport Flight Talon · Salem, ORloss of engine power for undetermined reason(s), and failure of the pilot to properly flare the aircraft during the emergency landing.NTSB NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.NTSB NYC96FA084Accident · 1 fatalField investigationFinal reportPitts S-2B · Freehold Twsp, NJthe pilot's improper fuel management which resulted in a power loss due to fuel exhaustion, and his failure to maintain airspeed during a forced landing which resulted in an inadvertent stall.NTSB LAX96LA158Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Jean, NVthe pilot's poorly planned approach. The flight's encounter with a downdraft is a factor in this accident.NTSB LAX96LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Sedona, AZthe pilot misjudged the flare.NTSB LAX96LA156Accident · 1 fatalLimited investigationFinal reportTwibell Tangent 65 · Lucerne Valley, CAthe pilot's failure to maintain altitude. Factors in the accident were: the pilot's decision to buzz the area and his ostentatious display.NTSB LAX96FA155Accident · Serious injuriesField investigationFinal reportCessna 182RG · Beaver Dam, AZan engine failure due to oil starvation resulting from the pilot's improper aircraft preflight. A factor relating to the accident was: failure of the operator to ascertain that proper maintenance was performed after the airplane's high oil consumption rate…NTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…NTSB ATL96LA077Accident · No injuriesLimited investigationFinal reportCessna 210M · Everglades City, FLthe pilot's excessive airspeed and misjudgment of the landing distance. A factor was the right brake not working due to a hydraulic leak.NTSB ANC96LA045Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas H-369 · Delta Junction, AKloss of engine power for an undetermined reason.NTSB ANC96LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB LAX96LA161Accident · No injuriesLimited investigationFinal reportVan Dyke GVD1 · Sacramento, CAthe pilot's failure to maintain adequate airspeed during a low altitude turn after takeoff.NTSB FTW96LA162Accident · No injuriesLimited investigationFinal reportCessna T210R · Albuquerque, NMthe pilot's failure to extend the landing gear. Factors were his failure to follow the checklist and his diverted attention due to other traffic.NTSB CHI96LA138Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Pontiac, MIfailure of the pilot to maintain control of the airplane during the landing roll. A factor relating to the accident was: the crosswind condition.NTSB ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.NTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.NTSB SEA96FA076Accident · No injuriesField investigationFinal reportBell UH-1H · Rainier, WAfailure of the forward power shaft (number 21) bearing. A factor relating to the accident was: the lack of suitable, unobstructed terrain for an emergency landing.NTSB NYC96GA083Accident · 2 fatalFinal reportBell 206L-1 · Charleston, WVthe helicopter manufacturer's inadequate maintenance service bulletin inspection interval which failed to provide timely detection of preexisting fatigue cracks in the tail boom. Factors were: the manufacturer's failure to develop a modification of the failed…NTSB LAX96LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Palm Springs, CAthe pilot's inadequate compensation for the crosswind condition and subsequent failure to maintain directional control. The crosswind was a factor.NTSB IAD96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Roanoke, VAthe pilot's misjudged estimation of the airplane's fuel supply for the flight. Related factors are the inadequate preflight inspection, the pilot's expectation that the airplane had been topped off, and the soft terrain encountered during the forced landing.NTSB FTW96LA161Accident · 1 fatalLimited investigationFinal reportBensen Gyroplane · Carthage, TXthe pilot's inadequate coordination with the spectator, concerning the spectator's need to remain clear of the takeoff area, and the spectator's failure to remain clear of the takeoff area. A factor relating to the accident was: the spectator's distorted…NTSB LAX96LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Chandler, AZThe failure of both the engine driven and hand wobble fuel pumps, which resulted in fuel starvation to the engine.NTSB FTW96LA160Accident · No injuriesLimited investigationFinal reportCessna 172K · Danville, ARthe student pilot's inadequate compensation for the crosswind. Factors were the crosswind and the soft terrain.NTSB FTW96LA159Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A · Hughes, LAthe pilot exceeding the maximum authorized crosswind component of the airplane. Factors were the crosswind and the side sloping runway.NTSB DCA96RA046Accident · 33 fatalForeign investigationBoeing CT-42A · Dubrovnik, CroatiaNTSB CHI96LA124Accident · No injuriesLimited investigationFinal reportCessna 210 · Marshall, MIA deer that wandered onto the runway. Darkness was a related factor.NTSB CHI96IA125Incident · No injuriesIncident investigationFinal reportATR 42 · Traverse City, MIimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.