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 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.Mar 31, 1991 · N308SC · Substantial damageNTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.Mar 30, 1991 · N2899E · Substantial damageNTSB 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.Mar 30, 1991 · N8656F · DestroyedNTSB LAX91LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lake Elsinore, CAUndetermined engine power loss. A factor ws the soft terrain.Mar 30, 1991 · N6315A · Substantial damageNTSB 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…Mar 30, 1991 · N584B · Substantial damageNTSB 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.Mar 30, 1991 · N99255 · Substantial damageNTSB DEN91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Collins, COThe loss of directional control by the pilot in command.Mar 30, 1991 · N8543D · Substantial damageNTSB 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.Mar 30, 1991 · N2071R · Substantial damageNTSB 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…Mar 30, 1991 · N7457P · DestroyedNTSB ANC91LA041Accident · No injuriesLimited investigationFinal reportBell 47 · Thompson Pass, AKThe pilot's failure to maintain aircraft control and improper flare during landing.Mar 30, 1991 · N73279 · Substantial damageNTSB 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.Mar 29, 1991 · N2601Y · Substantial damageNTSB 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.Mar 29, 1991 · N7133Y · Substantial damageNTSB 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.Mar 29, 1991 · N7454J · Substantial damageNTSB LAX91TL#05Accident · No injuriesClass 3Final reportBell 47GIII B1 · Tonopah, NVMar 29, 1991 · N3FG · Substantial damageNTSB 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.Mar 29, 1991 · N3851C · DestroyedNTSB 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.Mar 29, 1991 · N6216U · DestroyedNTSB SEA91FA076Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Chehalis, WAA loss of engine power due to an improper overhaul.Mar 28, 1991 · N6044P · DestroyedNTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.Mar 28, 1991 · N9462S · DestroyedNTSB 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.Mar 28, 1991 · N8050B · Substantial damageNTSB 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.Mar 28, 1991 · N51100 · Substantial damageNTSB BFO91LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Clinton, MDThe lost of engine power for undetermined reasons.Mar 28, 1991 · N5335Z · Substantial damageNTSB 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.Mar 28, 1991 · N76RL · Substantial damageNTSB 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.Mar 27, 1991 · N371RF · Substantial damageNTSB 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.Mar 27, 1991 · N4065J · DestroyedNTSB MIA91TL#03Accident · No injuriesClass 3Final reportBell 47-G5A · Titusville, FLMar 27, 1991 · N7925J · Substantial damageNTSB 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.Mar 27, 1991 · N55516 · Substantial damageNTSB LAX91FA143Accident · 2 fatalField investigationFinal reportBeech 58P · Vail, AZThe failure of both pilots to maintain control of the airplane.Mar 27, 1991 · N27L · DestroyedNTSB 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.Mar 27, 1991 · N1743V · Substantial damageNTSB 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).Mar 27, 1991 · N5FC · Substantial damageNTSB BFO91LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Martinsburg, WVFuel exhaustion which resulted in the loss of engine power.Mar 27, 1991 · N8738E · DestroyedNTSB 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.Mar 27, 1991 · N9884X · Substantial damageNTSB 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.Mar 27, 1991 · N9968M · Substantial damageNTSB 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.Mar 27, 1991 · N173RV · Minor damageNTSB 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.Mar 26, 1991 · N2107X · DestroyedNTSB MIA91LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Quincy, FLThe pilot's inadequate preflight.Mar 26, 1991 · N10860 · Substantial damageNTSB 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.Mar 26, 1991 · N9845P · DestroyedNTSB 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.Mar 26, 1991 · N9692M · DestroyedNTSB 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.Mar 26, 1991 · N7224L · Substantial damageNTSB 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.Mar 25, 1991 · N6237Y · Substantial damageNTSB 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.Mar 25, 1991 · N704SN · Substantial damageNTSB LAX91LA145Accident · Serious injuriesLimited investigationFinal reportAeronca 7-AC · No. Las Vegas, NVThe pilot's failure to maintain airspeed.Mar 25, 1991 · N84025 · DestroyedNTSB ATL91LA070Accident · No injuriesLimited investigationFinal reportCessna 150G · Villa Rica, GAA loss of engine power for undetermined reasons.Mar 25, 1991 · N3798J · Substantial damageNTSB 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).Mar 24, 1991 · N19102 · Substantial damageNTSB 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.Mar 24, 1991 · N59BH · Substantial damageNTSB 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.Mar 24, 1991 · N95BE · DestroyedNTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.Mar 24, 1991 · N841DP · Substantial damageNTSB 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.Mar 24, 1991 · N383VU · Substantial damageNTSB 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.Mar 24, 1991 · N5463D · Substantial damageNTSB 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.Mar 24, 1991 · N7010K · Substantial damageNTSB 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.Mar 24, 1991 · N2503A · Substantial damage