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 ANC91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Kenai, AKThe failed nose gear shimmy dampner, contributing to the accident was the rough ice and snow covered ramps where the airplane had been operating and the lack of maintenance on the runways.NTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.NTSB LAX91LA152Accident · No injuriesLimited investigationFinal reportHughes 269C · Honolulu, HIThe instructor's improperly planned approach. A factor was the pilot's failure to observe performance data for the helicopter.NTSB LAX91LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lake Elsinore, CAUndetermined engine power loss. A factor ws the soft terrain.NTSB LAX91LA150Accident · No injuriesLimited investigationFinal reportBeech A35 · Hilt, CAThe application of a sealant instead of a lubricant to the internal 'o' rings seals in the fuel selector by maintenance personnel. Factors contributing to the accident were the pilot's inability to select a fuel source and fuel starvation that resulted in an…NTSB LAX91LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jean, NVFuel starvation due to the improper fuel management (positioning of the fuel selector) by the pilot, and his improper emergency procedures. The pilot's lack of experience in this make and model of aircraft was a related factor.NTSB DEN91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Collins, COThe loss of directional control by the pilot in command.NTSB CHI91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burwell, NEDirectional control not maintained by the pilot. Factors related to the accident were a gusty crosswind and lack of recent experience by the pilot.NTSB ATL91FA073Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Franklin, TNThe pilot's failure to select a proper fuel tank for flight, resulting in fuel starvation to the engine, and subsequent engine stoppage. Factors were the pilot's inadequate evaluation of the weather conditions along his route of flight, and his flight into…NTSB ANC91LA041Accident · No injuriesLimited investigationFinal reportBell 47 · Thompson Pass, AKThe pilot's failure to maintain aircraft control and improper flare during landing.NTSB SEA91LA074Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Friday Harbor, WAThe pilot's failure to maintain a proper climb gradient and rate as a result of his inadequate compensation for wind conditions.NTSB SEA91FA073Accident · 1 fatalField investigationFinal reportPiper PA-30 · Butte, MTInadequate inflight decisions, fuel starvation, and failure to perform alternative IFR approach procedures. Factors include operation with known deficiencies in equipment, disorientation, and lack of familiarity with the geographic area.NTSB MIA91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · New Port Richey, FLIn-flight encounter with wind gusts while flaring to land and failure of the pilot to maintain directional control and failure to perform a goaround.NTSB LAX91TL#05Accident · No injuriesClass 3Final reportBell 47GIII B1 · Tonopah, NVNTSB DEN91FA056Accident · 5 fatalField investigationFinal reportCessna 421C · Cortez, COThe pilot's improper IFR procedures. Factors were: the existing weather conditions and the pilot's failure to obtain a preflight briefing.NTSB ANC91FA042Accident · 4 fatalField investigationFinal reportCessna 206 · Homer, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude, while maneuvering over water. Factors related to the accident were: the snow shower and probable whiteout conditions.NTSB SEA91FA076Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Chehalis, WAA loss of engine power due to an improper overhaul.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB FTW91LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Spring, TXPower loss due to carburetor ice, the pilot's failure to use carburetor heat, and his failure to apply adequate cushioning collective pitch during the flare segment of the autorotation. A factor in the accident was the pilot's improper autorotation technique.NTSB DEN91LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Watkins, COLoss of engine power for an undetermined reason, and failure of the pilot to maintain airspeed during the forced landing, which resulted in a stall/mush.NTSB BFO91LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Clinton, MDThe lost of engine power for undetermined reasons.NTSB ANC91LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kasigluk, AKThe pilot's failure to maintain directional control of the airplane on landing. Contributing to the accident was the snowbank.NTSB SEA91LA070Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Everett, WAThe pilot did not maintain control of the airplane during the landing roll. Factors tot he accient were the pilot inadequately planned the approach, and uncontrolled ground-loop, and the pilot's lack of total experience in this type of aircraft.NTSB SEA91FA069Accident · 2 fatalField investigationFinal reportCessna 150G · Kennewick, WAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.NTSB MIA91TL#03Accident · No injuriesClass 3Final reportBell 47-G5A · Titusville, FLNTSB MIA91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sanford, FLExcessive flare by the dual student during the forced landing following a simulated engine failure shortly after takeoff. Also, failure of the student to maintain vs, and failure of the CFI to take remedial action.NTSB LAX91FA143Accident · 2 fatalField investigationFinal reportBeech 58P · Vail, AZThe failure of both pilots to maintain control of the airplane.NTSB CHI91LA117Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankton, SDFailure of the pilot to maintain directional control of the aircraft during landing. The adverse wind condition and the pilot's lack of total experience were related factors.NTSB BFO91LA036Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, MDThe pilot's inadequate visual lookout, which resulted in his failure to see-and-avoid the obstruction (fence post).NTSB BFO91LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Martinsburg, WVFuel exhaustion which resulted in the loss of engine power.NTSB ATL91LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Greer, SCThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ANC91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Saint Marys, AKThe pilot-in-command's failure to maintain VFR flight in instrument meteorological conditions while maneuvering on a VFR flight plan. Factors related to the accident was the pic's failure to evaluate the weather conditions that existed.NTSB ANC91IA046Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600 · Anchorage, AKA jammed nose gear due to incorrect installation of the shear pin. Contributing to the accident was the insufficiently defined maintenance procedure.NTSB SEA91FA071Accident · 1 fatalField investigationFinal reportCessna 337 · Boise, IDThe pilot's failure to remove the aircraft control locks prior to attempting flight. Factors include an inadequate preflight.NTSB MIA91LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Quincy, FLThe pilot's inadequate preflight.NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI91FA116Accident · 1 fatalField investigationFinal reportMooney M-20C · Prior Lake, MNFailure to maintain airspeed while executing a forced landing. Factors related to the accident were the pilot's improper inflight planning/decision, and fuel exhaustion.NTSB ATL91LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Chamblee, GAThe hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.NTSB NYC91LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Milleville, NJThe total loss of engine power caused by mechanical failure, which resulted in the pilot landing the airplane on unsuitable terrain.NTSB MIA91LA109Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Crystal River, FLThe loss of power because of oil pump failure due to contamination. Unknown maintenance personnel performed a component change without using appropriate publications and procedures and failed to clean contaminants from the engine.NTSB LAX91LA145Accident · Serious injuriesLimited investigationFinal reportAeronca 7-AC · No. Las Vegas, NVThe pilot's failure to maintain airspeed.NTSB ATL91LA070Accident · No injuriesLimited investigationFinal reportCessna 150G · Villa Rica, GAA loss of engine power for undetermined reasons.NTSB NYC91LA093Accident · No injuriesLimited investigationFinal reportCessna 150L · Chambersburg, PACarburetor ice and the pilot's improper use of carburetor heat. A factor related to the accident was: carburetor icing (weather conditions).NTSB MIA91LA108Accident · Minor injuriesLimited investigationFinal reportGlassair SH-2TD · Bay St. Louis, MSThe loss of power due to vapor lock of the fuel system on takeoff. Contributing to the cause of the accident was the improper decision of the pilot-in-command to attempt to take off with known deficiencies in the airplane.NTSB MIA91FA107Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Chassahowitzka, FLThe pilot in commands continued VFR flight into IFR conditions resulting in an inflight loss of control and an inflight collision with the ground.NTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.NTSB FTW91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Floresville, TXThe failure of the engine due to a jammed valve, incorrect maintenance procedures, and the pilot's improper compensation for the existing wind conditions. A factor was the tailwind.NTSB DEN91LA054Accident · No injuriesLimited investigationFinal reportBeech H35 · Greeley, COThe pilot's inadvertent activation of the landing gear switch causing the landing gear to collapse while the aircraft was still on the landing roll.NTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.NTSB CHI91LA113Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Augusta, KSAn improper autorotation was performed by the dual student and remedial action was delayed by the CFI. Factors related to the accident were: inadequate airspeed and rotor RPM.