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 MKC89LA173Accident · No injuriesLimited investigationFinal reportMooney M20C · Fouke, ARThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion, at night. The ensuing forced landing resulted in a collision with a fencepost, ground swerve, and collapse of the right main landing gear.NTSB LAX89WA260Accident · No injuriesForeign investigationCessna P206 · Punta Abriejos, MexicoNTSB LAX89LA255Accident · No injuriesLimited investigationFinal reportBeech A35 · Hemet, CALoss of engine power for undetermined reasons.NTSB CHI89FA155Accident · 2 fatalField investigationFinal reportLancair 235 · Fond Du Lac, WIFailure of the pilot-in-command to assure that adequate airspeed was maintained during the turn to final approach, which resulted in an inadvertent stall/spin.NTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.NTSB ATL89LA186Accident · No injuriesLimited investigationFinal reportCessna 172L · N Myrtle Beach, SCWater contamination of the airplane fuel supply, and the pilot's failure to adequately preflight the aircraft. A factor related to the accident was: swampy terrain at the emergency landing site.NTSB SEA89LA145Accident · No injuriesLimited investigationFinal reportCessna 177 · Fall City, WAThe pilot misjudged his landing flare and then did not properly recover from the resulting bounce.NTSB SEA89LA144Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAThe pilot's inadequate in-flight planning. The helicopter skid contacted the water as a result of the pilot's misjudgement of clearance above the water.NTSB NYC89LA181Accident · No injuriesLimited investigationFinal reportCessna 185D · Wolfeboro, NHLoss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.NTSB MKC89LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft Smith, ARInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.NTSB LAX89LA254Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Oceanside, CAThe failure of the pilot-in-command to attain proper airspeed during the go-around. The lack of airspeed did not permit the airplane to climb and the pilot intentionally stalled the airplane into the trees. Contributing to the accident was the pilot delaying…NTSB LAX89LA253Accident · No injuriesLimited investigationFinal reportBell 206B · Rialto, CAFailure to install two of the four required nuts which retain the high speed coupling input drive shaft to the transmission.NTSB CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…NTSB BFO89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28R-201T · College Park, MDFailure of the pilot to maintain aircraft control due to spatial disorientation, and his exceeding the design stress limits of the aircraft, which resulted in overload failure of the stabilators and wings. Factors related to the accident were: the pilot's…NTSB ATL89DKG05Accident · Minor injuriesFinal reportGrumman G-164A · Dawson, GAFailure of the number three cylinder head.NTSB ANC89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Tozitna River, AKImproper preflight planning/preparation by the pilot. High obstructions, unfavorable wind conditions, and trees were contributing factors.NTSB SEA89LA146Accident · No injuriesLimited investigationFinal reportAbbott Gyroplane · Newport, WAThe pilot's selection of unsuitable terrain and the delay in aborting the takeoff.NTSB SEA89LA142Accident · No injuriesLimited investigationFinal reportCessna 172E · Yerington, NVThe pilot's failure to maintain adequate airspeed during a landing go-around in high density altitude conditions.NTSB SEA89FA143Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Haines, AKImproper in-flight planning and decision by the pilot, which resulted in inadvertent flight into instrument meteorological conditions (IMC). The weather conditions and terrain were related factors.NTSB NYC89LA218Accident · No injuriesLimited investigationFinal reportCessna 305A · Chalfont, PAThe pilot's improper use of carburetor heat, which resulted in a power loss due to carburetor ice. Factors related to the accident were: carburetor icing conditions and rough/uneven terain in the emergency landing area.NTSB NYC89FA177Accident · 7 fatalField investigationFinal reportBeech A36 · Salisbury Twp, PAThe failure of both pilots to see and avoid each other. A contributing factor to the accident was that neither pilot was heard over the radio announcing their position and intentions.NTSB MKC89LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Cedar Rapids, IAThe failure of the pilot in command to maintain alignment with the runway and excessive aircraft control in close proximity to the ground. Contributing to the accident was the pilot's diverted attention which resulted from having to shut down the left engine.NTSB LAX89LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Corona, CAContinued buildup of carburetor ice due to the pilot's improper use of carburetor heat, and his improper use of emergency procedures. Factors related to the accident were: carburetor icing conditions, the pilot's lack of recent flight experience, and trees in…NTSB CHI89FA153Accident · No injuriesField investigationFinal reportCessna 182Q · Oshkosh, WIThe pilot of Cessna N95914 misjudging the distance necessary to avoid collisions with a the standing Piper N5937W.NTSB BFO89LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Williamsburg, VAThe pilot's failure to maintain aircraft control by improperly flaring the airplane during the landing approach.NTSB BFO89DIG03Incident · No injuriesFinal reportSmith Miniplane · Cumberland, MDFailure of the pilot to maintain directional control of the airplane during high speed taxi tests.NTSB BFO89DIG02Accident · Minor injuriesFinal reportPiper PA-28 · Cumberland, MDThe pilot's improper decision to takeoff in deteriorating weather conditions. Related factors were: the pilot's failure to obtain a weather briefing prior to departure, and his lack of an instrument rating.NTSB SEA89LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVThe student pilot's improper compensation for wind conditions, and improper recovery from a bounced landing. Factors related to the accident were: the adverse wind condition and the student's lack of total flying experience.NTSB NYC89LA178Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt Pleasant, PAAn improper flare by the pilot that resulted in a hard landing.NTSB NYC89DNC01Accident · Serious injuriesFinal reportBonds & Bungey HP-14 · Warren/Sugarbus, VTFailure of the pilot to maintain adequate airspeed while maneuvering in shifting/turbulent air, and his inadequate remedial action to avoid or recover from the inadvertent spin. The shifting/turbulent/gusty wind condition was a related factor.NTSB MKC89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, MOControl interference by the dual student as the instructor tried to recover from the student's bounced landing, and failure to maintain proper runway alignment. Contributing factors were: improper flare by the student, the crosswind, the student's…NTSB MIA89LA209Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Ackerman, MSThe pilot's selection of the wrong runway and his improper inflight planning/decision which resulted in a situation from which he could neither go-around nor stop on the remaining runway. The thunderstorms, inoperative (disrepaired) wind sock, and rough…NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB CHI89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Watertown, WIImproper planning/decision by the pilot and his misjudgement of distance and speed during the landing, which resulted in failure to attain a proper touchdown point. Contributing factors were: the weather conditions, the pilot's continued flight into…NTSB CHI89FA151Accident · Minor injuriesField investigationFinal reportCessna A152 · Oshkosh, WIThe pilot's poor judgement, and poor evaluation of the weather due to self induced pressure and overconfidence in his personal ability. Contributing factor was the experimental aircraft association's inadequate supervision of the operation.NTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.NTSB CHI89DEP08Accident · No injuriesFinal reportJames Eggleston Varieze · Cottage Grove, WIThe pilot misjudged altitude and distance to the runway and failed to attain the proper touchdown point for a landing. Factors related to the accident were: adverse weather conditions and uneven terrain short of the runway.NTSB BFO89FA064Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Bradshaw, MDAn engine power loss due to fuel starvation for unknown reasons.NTSB ANC89FA130Accident · Serious injuriesField investigationFinal reportCessna 180A · Wasilla, AKInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel and his failure to maintain adequate airspeed while maneuvering back toward the lake which resulted in an inadvertent stall. The house & trees were…NTSB MKC89LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Portland, AREngine failure due to failure of an engine cylinder.NTSB MKC89DPG03Accident · 1 fatalFinal reportPZL-Mielec M-18 · Parkin, ARThe failure of the pilot to maintain a visual lookout adequate to have avoided the powerlines.NTSB LAX89LA256Accident · No injuriesLimited investigationFinal reportCessna 172M · Marana, AZInadequate preflight by the student pilot, inadequate supervision by the flight instructor (CFI), and fuel exhaustion due to lack of fuel. Related factors were: inoperative left fuel quantity gage, the cfi's decision to make the flight with a known deficiency…NTSB LAX89LA249Accident · No injuriesLimited investigationFinal reportBeech C24R · Lower Lake, CAPilot-in-command's failure to identify the sink rate soon enough to take corrective action.NTSB DEN89LA181Accident · No injuriesLimited investigationFinal reportCallair A-9 · Cartwright, NDA total loss of power due to an improperly adjusted carburetor which resulted in an excessive rich fuel-air mixture. This required a forced landing in an area where no suitable terrain existed.NTSB DEN89LA180Accident · No injuriesLimited investigationFinal reportCessna 150G · West Jordan, UTInadequate preflight by the pilot, which resulted in fuel exhaustion, due to his misjudgement of the fuel supply. Factors related to the accident were: a false fuel gage indication, and the ditch in the emergency landing area.NTSB CHI89DEP09Accident · No injuriesFinal reportCabrinha/Free Spirit 412 · Waukesha, WIThe plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.NTSB BFO89FA063Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · True, WVThe pilots failure to properly monitor the fuel supply which resulted in fuel starvation. The aircraft stalled as the pilot performed an evasive maneuver to avoid the mountain top.NTSB SEA89LA141Accident · Minor injuriesLimited investigationFinal reportKing Osprey II · West Linn, ORThe pilot did not properly recover from a bounced water landing.NTSB MIA89LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Homestead, FLImproper repair of the fuel cap (seal) by the pilot, which resulted in a blocked fuel system (cap) vent and subsequent fuel starvation, and his failure to see-and-avoid the telephone line. The telephone (transmission) line was a contributing factor.NTSB LAX89LA328Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3201 · Bullhead City, AZThe deplaning passenger's failure to observe a raised and marked area in the passenger cabin floor exit aisle. Contributing factors to the accident were: darkness and the fuselage floor exit aisle was designed with a raised area which partially obstructed its…