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 NYC92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Beekmantown, NYAn inadvertent stall due to the pilot's decision to prematurely retract the wing flaps. A factor related to the accident was the lack of altitude for recovery.Oct 31, 1991 · N5889E · Substantial damageNTSB MIA92LA019Accident · No injuriesLimited investigationFinal reportBeech C-45H · Fort Lauderdale, FLHard landing due to failure of the pilot-in-command to maintain the proper descent rate. Contributing to the accident was the turbulence encountered during the apch.Oct 31, 1991 · N6640R · Substantial damageNTSB LAX92LA030Accident · 1 fatalLimited investigationFinal reportBell 47-G5A · KosraeThe pilot-in-command's improper preflight inspection of the helicopter resulting in a tiedown strap not being removed from the right skid and subsequent roll over on takeoff.Oct 31, 1991 · N7162R · DestroyedNTSB FTW92LA016Accident · Serious injuriesLimited investigationFinal reportBalkema/Boven Kestrel Hawk · West Memphis, ARThe pilot allowed the aircraft to enter an inadvertent stall during flare at excessive altitude while executing the forced landing. Factors were the pilot in command and unauthorized person performed carburetor maintenance adjustments prior to flight, and the…Oct 31, 1991 · N601AS · Substantial damageNTSB FTW92FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman F9F-8T · MissingUndetermined.Oct 31, 1991 · N24WJ · DestroyedNTSB CHI92FA020Accident · Serious injuriesField investigationFinal reportCessna 172P · Zion, ILWater contamination of the fuel, and the pilot's inadequate preflight of the aircraft. Factors related to the accident were: darkness and obstructions (trees & transmission lines) in the emergency landing area.Oct 31, 1991 · N5411K · DestroyedNTSB BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.Oct 31, 1991 · N8855J · DestroyedNTSB ANC92LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Ekuk, AKThe pilot's improper in flight planning and decision in that he attempted to touchdown too close to the log.Oct 31, 1991 · N46279 · Substantial damageNTSB NYC92LA021Accident · No injuriesLimited investigationFinal reportRobinson R22B · Millville, NJThe pilot's failure to maintain control of the helicopter. A factor related to the accident was the pilot's improper compensation for wind conditions.Oct 30, 1991 · N502TH · Substantial damageNTSB DEN92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Ellicott, COA power loss for undetermined reasons, the pilot's poorly planned approach, and excessive airspeed. Factors were: the pilot's intentional flight into IMC, accumulation of wing ice and his becoming lost disoriented.Oct 30, 1991 · N6815P · Substantial damageNTSB DEN92IA007Incident · No injuriesIncident investigationFinal reportDouglas DC-10-10 · Colorado Spring, COThe captain's inadequate supervision and the copilot's failure to maintain directional control. Factors were: the crosswind and snow/ice on the runway.Oct 30, 1991 · N1808U · Minor damageNTSB SEA92LA029Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F1 · Billings, MTThe unlatching and subsequent opening inflight of the left-rear engine cowl door. A factor contributing to the accident was the failure of company maintenance personnel to execute the manufacturer's service bulletin.Oct 29, 1991 · N101UC · Substantial damageNTSB NYC92LA023Accident · No injuriesLimited investigationFinal reportBeech B23 · Bombay, NYFailure of the pilot to use all the available take off area.Oct 29, 1991 · N6119N · Substantial damageNTSB CHI92LA019Accident · No injuriesLimited investigationFinal reportCessna 182U · Rolla, MOThe pilot in command's failure to attain a proper flare on landing. A factor contributing to the accident was the pilot in command's inadvertent encounter with instrument meteorological conditions.Oct 29, 1991 · N2412Q · Substantial damageNTSB ATL92FA019Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Darden, TNThe pilot's failure to maintain control of the airplane. The pilot exceeded the design limits of the airframe.Oct 29, 1991 · N3559J · DestroyedNTSB MIA92LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper flare & failure to recover from a ballooned landing.Oct 28, 1991 · N69250 · Substantial damageNTSB LAX92LA028Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pauma, CAFuel starvation due to a restricted fuel tank vent line. Contributing to the accident was inadequate maintenance.Oct 28, 1991 · N664U · Substantial damageNTSB LAX92IA027Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Las Vegas, NVRupture of a forward pressure bulkhead because of cyclically induced metal fatigue. Factors which contributed to the incident were: the operator's decision not to structurally modify its airplane in accordance with the manufacturer's but rather to rely on the…Oct 28, 1991 · N1820U · Minor damageNTSB FTW92FA015Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Cotulla, TXThe pilot's failure to maintain aircraft control. Factors related to the accident were: darkness, and a short in the electrical system which resulted in partial failure of the instrument lights and a malfunction of the autopilot.Oct 28, 1991 · N6307Y · Substantial damageNTSB CHI92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bellaire, MIThe pilot's improper remedial action after ballooning during a landing flare. Factors associated with the accident are gusty crosswinds and the pilot's lack of total experience.Oct 28, 1991 · N3795A · Substantial damageNTSB ATL92LA018Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1D · Brewton, ALA blockage of the fuel vent system which prevented the pilot from topping off the fuel system. A factor in this accident was the inadequate design by the manufacturer of the fuel vent system.Oct 28, 1991 · N78006 · Substantial damageNTSB ATL92LA017Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Rome, GAThe failure of a tail rotor blade for undetermined reasons.Oct 28, 1991 · N925V · Substantial damageNTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.Oct 27, 1991 · N14256 · Substantial damageNTSB LAX92LA026Accident · 2 fatalLimited investigationFinal reportGlassair III · Scottsdale, AZThe certified flight instructors decision to fly into known forecast weather conditions specifically prohibited by the airplane's owner's manual and decision to allow an unqualified pilot with limited instrument flight experience to occupy the left seat…Oct 27, 1991 · N121ST · DestroyedNTSB LAX92LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Chiriaco Summit, CAThe delayed actions of the pilot-in-command in selecting a go-around ND subsequent loss of directional control which resulted in the airplane drifting off the runway centerline and colliding with terrain. Contributing to the accident was failure of the pilot…Oct 27, 1991 · N3771K · Substantial damageNTSB FTW92LA019Accident · No injuriesLimited investigationFinal reportCessna 150J · Hatch, NMFuel exhaustion as a result of the pilot's failure to refuel and his poor preflight and inflight planning. Factors were the unsuitable mountainous terrain at the pilot's disposal and the unfavorable winds aloft.Oct 27, 1991 · N50472 · Substantial damageNTSB FTW92FA014Accident · 2 fatalField investigationFinal reportBeech A36 · Marble Falls, TXThe pilot's performance of acrobatic maneuvers at an altitude too low to allow for recovery.Oct 27, 1991 · N7246H · DestroyedNTSB ATL92LA016Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA5A · Burnsville, NCThe pilot's inadequate preflight planning and the selection of takeoff runway with an upslope for takeoff. Factors were the pilot's lack of experience with the geographical area and the high density altitude.Oct 27, 1991 · N74279 · Substantial damageNTSB NYC92LA019Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Manchester, VTThe pilot's inadequate aircraft preflight. A factor was the pilot's lack of flight experience.Oct 26, 1991 · N70548 · Substantial damageNTSB MIA92FA017Accident · Serious injuriesField investigationFinal reportCessna 152 · Valkaria, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented and an in-flight collision with terrain. Contributing to the accident was the pilot's decision to operate the airplane with known…Oct 26, 1991 · N24431 · DestroyedNTSB LAX92LA029Accident · 3 fatalLimited investigationFinal reportBell 206B · Vallejo, CAThe pilot's intentional flight into known adverse weather, continued flight into instrument meteorological conditions, and improper altitude. Contributing to the accident was low ceilings, poor visibility, and restricted visual lookout.Oct 26, 1991 · N3456M · DestroyedNTSB LAX92FA025Accident · Minor injuriesField investigationFinal reportAerospatiale AS350B · Scottsdale, AZAn undetermined malfunction of the hydraulic system in which the system was locked, preventing the movement of the flight controls, and loss of directional control.Oct 26, 1991 · N9001S · Substantial damageNTSB LAX92FA017Accident · 2 fatalField investigationFinal reportCessna 414 · Long Beach, CAThe pilot's improper emergency procedures by not retracting the landing gear when he shut the engine down and his failure to maintain airspeed. The scavenge pump failure, shutting down the engine and the inadvertent stall were factors in the accident.Oct 26, 1991 · N3843C · DestroyedNTSB BFO92LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, WVThe engine failure caused by fuel starvation and the pilot's improper fuel management.Oct 26, 1991 · N6466N · Substantial damageNTSB BFO92LA003Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Waynesboro, VAImproper in-flight planning/decision by the instructor (CFI). Contributing to the accident was the instructor's failure to properly monitor the student's performance.Oct 26, 1991 · N34396 · Substantial damageNTSB ANC92LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain airspeed.Oct 26, 1991 · N1887A · Substantial damageNTSB ANC92LA010Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-6 · Chevak, AKThe high crosswind condition, the pilot in commands inability to compensate for the wind conditions, and his failure to follow company procedures and the procedures recommended in the aircraft flight manual. Factor relating to the accident was the captain's…Oct 26, 1991 · N724CA · Substantial damageNTSB LAX92LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Willits, CAThe pilot's poor in-flight decision to continue his flight in deteriorating weather, and his misjudged weather evaluation.Oct 25, 1991 · N24237 · DestroyedNTSB CHI92TL#01Accident · Serious injuriesClass 3Final reportCessna 337 · Eau Claire, WIOct 25, 1991 · N2461S · Substantial damageNTSB SEA92TL#03Accident · No injuriesClass 3Final reportBell 206L-3 · Kent, WAOct 24, 1991 · N911KP · Substantial damageNTSB MIA92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Daytona Beach, FLThe failure of the pilot in command of N136AT to maintain clearance from N3110R while diverting her attention to close her door during taxi to takeoff.Oct 24, 1991 · N136AT · 2 aircraft · Substantial damageNTSB DEN92IA005Incident · No injuriesIncident investigationFinal reportBoeing 747-122 · Denver, COA malfunction in the stabilizer trim control module.Oct 24, 1991 · N4719U · No damageNTSB ATL92LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Thomasville, GAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain a proper descent rate during the forced landing attempt.Oct 24, 1991 · N7501Z · DestroyedNTSB NYC92LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-4B7 · Boston, MAA latch failure on a door in the aft galley which allowed a liquor kit to roll forward.Oct 23, 1991 · N441US · No damageNTSB NYC92DHA01Accident · 1 fatalFinal reportJesse Knight Long EZ · Milford, PAThe pilot's inadequate visual lookout.Oct 23, 1991 · N172JK · Substantial damageNTSB CHI92LA017Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas MD369D · Beech Grove, INImproper installation of the flight control linkage during maintenance. Complacency and inadequate inspection of the helicopter by maintenance personnel and the pilot are factors in the accident.Oct 23, 1991 · N88SE · Substantial damageNTSB NYC92LA017Accident · No injuriesLimited investigationFinal reportBeech A23 · Fairfield, NJThe loss of engine power for undetermined reason's which resulted in a forced landing on unsuitable terrain.Oct 22, 1991 · N1425L · Substantial damageNTSB FTW92LA013Accident · No injuriesLimited investigationFinal reportCessna 150M · Matagorda, TXThe pilot's failure to maintain adequate flying speed during the attempted takeoff.Oct 22, 1991 · N9293U · DestroyedNTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.Oct 22, 1991 · N4616R · Substantial damageNTSB ATL92FA013Accident · Serious injuriesField investigationFinal reportBeech 58 · Pelham, ALThe pilot's failure to correct the position of the fuel selector before takeoff, and her inattentiveness to fuel consumption during the flight, which resulted in fuel starvation. Factors were the non-performance of engine out emergency procedures and the…Oct 22, 1991 · N99CK · Substantial damage