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 MIA95WA017Accident · No injuriesForeign investigationPiper PA-23-250 · Mangrove Key, Congo - KinshasaNov 2, 1994 · N5860Y · Substantial damageNTSB CHI95LA056Accident · No injuriesLimited investigationFinal reportCessna 206G · Butler, MOthe pilot's inadequate visual lookout. A factor associated with the accident was the dark night lighting conditions.Nov 2, 1994 · N9924R · Substantial damageNTSB CHI95LA029Accident · No injuriesLimited investigationFinal reportHughes 269C · Garden City, KSinadvertant engagement of the rotor drive system, while the helicopter had been left unattended by the pilot.Nov 2, 1994 · N9294F · Substantial damageNTSB CHI95IA028Incident · No injuriesIncident investigationFinal reportBoeing 747-251B · Chicag0, ILinattentive maintenance service of the airplane by the mechanic who failed to disengage the constant speed drive (CSD) after the engine runup had been completed. A factor in this incident was the lead mechanic not performing maintenance record keeping after…Nov 2, 1994 · N631US · Minor damageNTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.Nov 2, 1994 · N48720 · Substantial damageNTSB SEA95LA014Accident · No injuriesLimited investigationFinal reportCessna 205A · Lowell, IDThe pilot in command's long and fast landing. A factor was the wet runway surface condition.Nov 1, 1994 · N4801U · Substantial damageNTSB MIA95LA016Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe failure of the left main landing gear upper barrel and trunion assembly due to overstress separations, resulting in the collapse of the left main landing gear on landing rollout.Nov 1, 1994 · N5715C · Substantial damageNTSB MIA95LA015Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Madison, MSThe pilots improper use of brakes during a precautionary landing.Nov 1, 1994 · N8456V · DestroyedNTSB LAX95LA030Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · Willits, CAthat the pilot misjudged the distance between the helicopter and the trees.Nov 1, 1994 · N5088J · Substantial damageNTSB LAX95FA029Accident · Serious injuriesField investigationFinal reportCessna 421A · Sparks, NVThe pilot's improper use of the fuel selector and subsequent fuel starvation.Nov 1, 1994 · N421WB · DestroyedNTSB FTW95WA037Accident · No injuriesForeign investigationBell 212 · Cozumel, MexicoNov 1, 1994 · XASVS · DestroyedNTSB LAX95LA025Accident · No injuriesLimited investigationFinal reportCessna 172F · Tonopah, NVthe pilot's excessive taxi speed and improper remedial action after the nose gear began to shimmy. The nose gear shimmy (nose gear vibration) and the berm were factors in this accident.Oct 31, 1994 · N8210U · Substantial damageNTSB DCA95MA001Accident · 68 fatalClass 1 · MajorFinal reportATR ATR-72-212 · Roselawn, INthe loss of control, attributed to a sudden and unexpected aileron hinge moment reversal that occurred after a ridge of ice accreted beyond the deice boots while the airplane was in a holding pattern during which it intermittently encountered supercooled…Oct 31, 1994 · N401AM · DestroyedNTSB ATL95FA009Accident · 4 fatalField investigationFinal reportCessna 172N · Gerton, NCThe pilot's inadequate weather evaluation and his intentional visual flight into IMC.Oct 31, 1994 · N5338D · DestroyedNTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.Oct 31, 1994 · N7207C · DestroyedNTSB NYC95LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · Nunda, NYthe pilot-in-command's failure to assure that an adequate runway length was available.Oct 30, 1994 · N9235J · Substantial damageNTSB NYC95LA019Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Westfield, MAthe pilot's improper in-flight planning and inaccurate fuel consumption calculations, resulting in fuel exhaustion and the subsequent forced landing at night.Oct 30, 1994 · N85JW · Substantial damageNTSB MIA95LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Crystal River, FLA partial loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Oct 30, 1994 · N19264 · Substantial damageNTSB LAX95LA024Accident · Serious injuriesLimited investigationFinal reportKaman HH-43F · Willits, CAthe pilot's improper fuel consumption calculations resulting in fuel exhaustion. The hilly terrain was a factor in this accident.Oct 30, 1994 · N90944 · DestroyedNTSB BFO95LA009Accident · No injuriesLimited investigationFinal reportCessna 150D · Paducah, KYThe student pilot's failure to maintain proper alignment and the certified flight instructor's inadequate supervision of the flight.Oct 30, 1994 · N5962T · Substantial damageNTSB NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.Oct 29, 1994 · N4070S · No damageNTSB MIA95LA013Accident · Minor injuriesLimited investigationFinal reportSemco Challenger · Miami, FLFailure of the basket suspension cables due to corrosion and overstress separations. Contributing to the accident was an inadequate annual inspection of the basket suspension cables by an authorized FAA repairman.Oct 29, 1994 · N2048J · Substantial damageNTSB LAX95LA028Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Mariposa, CAthe unqualified student pilot's improper use of the brakes and his failure to maintain directional control of the aircraft. The pilot's lack of total experience is a factor in this accident.Oct 29, 1994 · N7MM · Substantial damageNTSB LAX95LA023Accident · No injuriesLimited investigationFinal reportGlen A. Senecal 5151 · Apple Valley, CAthe manufacturer's (owner/operator) improper balancing of the aileron flight controls which resulted in a cable separation due to overload from the aileron flutter. The rough/uneven terrain was also a factor.Oct 29, 1994 · N5246G · Substantial damageNTSB LAX95IA027Incident · No injuriesIncident investigationFinal reportFairchild SA-227AC · Oakland, CAthe company maintenance personnel's improper installation of the aileron cable.Oct 29, 1994 · N191AF · No damageNTSB FTW95LA036Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COThe pilot's improper landing flare, the resultant porpoise and an inadequate recovery from the bounced landing.Oct 29, 1994 · N52521 · Substantial damageNTSB FTW95LA035Accident · Minor injuriesLimited investigationFinal reportCessna T-210M · Tyler, TXLoss of engine power due to inadequate fuel management and fuel starvation. A factor was the lack of suitable terrain available for the forced landing.Oct 29, 1994 · N533CA · Substantial damageNTSB FTW95LA034Accident · 1 fatalLimited investigationFinal reportBrisendine Pterodactyl/Ascender · Las Animas, COA failure of the right wing into the propeller.Oct 29, 1994 · UNREG · DestroyedNTSB BFO95LA008Accident · Serious injuriesLimited investigationFinal reportAmerican General AA1 · Beach City, OHthe pilot-in-command's failure to maintain adequate control of the aircraft during the takeoff. The pilot's inadequate compensation for unfavorable wind conditions is a related factor in this accident.Oct 29, 1994 · N6114L · Substantial damageNTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.Oct 28, 1994 · N80NW · Substantial damageNTSB NYC95LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pillow, PAThe pilot did not attain the proper touchdown point on a grass runway covered with frost, which resulted in inadequate braking, and runway overrun.Oct 28, 1994 · N81478 · Substantial damageNTSB MIA95T#A01Accident · No injuriesClass 3Final reportBell 206L4 · Miami, FLOct 28, 1994 · N407MP · Substantial damageNTSB MIA95LA012Accident · No injuriesLimited investigationFinal reportCessna 210L · Jacksonville, FLThe pilot's decision to depart an airport and continue flight with a known deficiencies in equipment. Contributing to the accident was the failure of company maintenance personnel to adjust the down lock mechanism prior to flight.Oct 28, 1994 · N732CQ · Substantial damageNTSB LAX95LA022Accident · No injuriesLimited investigationFinal reportForney F-1 · Searchlight, NVthe pilot's failure to maintain directional control by improperly compensating for the existing wind conditions. The leaking cylinder, the prevailing crosswind, the soft terrain, and the dirt bank were factors in this accidentOct 28, 1994 · N3019G · Substantial damageNTSB LAX95LA021Accident · No injuriesLimited investigationFinal reportNorth American-Barene P-51-D · Victorville, CAthe pilot's failure to maintain directional control during a crosswind landing.Oct 28, 1994 · N4451C · Substantial damageNTSB LAX95FA020Accident · 2 fatalField investigationFinal reportCessna T337H · Douglas City, CAThe improper in-flight decision of the pilot to fly in dark night time conditions in mountainous terrain during adverse weather conditions.Oct 28, 1994 · N1497S · DestroyedNTSB FTW95LA033Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Midlothian, TXThe pilot-in-command's misjudgment of altitude and distance to the runway, while on final approach to land, and his failure to ensure altitude and clearance from obstacles, while allowing the student pilot to be on the controls. Darkness was a related factor.Oct 28, 1994 · N86781 · Substantial damageNTSB SEA95FA012Accident · 2 fatalField investigationFinal reportUnited Consultant UC-1 · Pinedale, WYAircraft control was not maintained. Factors to the accident were: rough water and downdrafts.Oct 27, 1994 · N9501U · Substantial damageNTSB SEA95FA011Accident · 4 fatalField investigationFinal reportCessna 310R · Rawlins, WYThe pilot-in-command's not maintaining clearance with terrain. Factors contributing to the accident were high terrain, dark night conditions, and the pilot-in-command's not obtaining/ maintaining the proper climb rate.Oct 27, 1994 · N69350 · DestroyedNTSB LAX95LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · La Verne, CAthe student pilot's poor recovery from a bounced landing and improper use of the elevator control. The lack of total experience is a factor in this accident.Oct 27, 1994 · N64851 · Substantial damageNTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.Oct 27, 1994 · N206SF · Substantial damageNTSB MIA95FA010Accident · 2 fatalField investigationFinal reportCessna 182P · Raymond, MSThe pilot's impairment of judgment and performance due to alcohol, and his resulting failure to maintain altitude after takeoff.Oct 26, 1994 · N58792 · DestroyedNTSB FTW95FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Aurora, COTHE CFI's FAILURE TO MAINTAIN AIRCRAFT CONTROL DUE TO SPATIAL DISORIENTATION. FACTORS WERE: A DARK, MOONLESS NIGHT WITH NO VISIBLE HORIZON AND RECENCY OF NIGHT EXPERIENCE BY THE FLIGHT INSTRUCTOR.Oct 26, 1994 · N8954W · DestroyedNTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.Oct 26, 1994 · N505KS · DestroyedNTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.Oct 26, 1994 · N526HK · Substantial damageNTSB CHI95IA030Incident · Minor injuriesIncident investigationFinal reportCessna 150 · Chesterfield, MOthe cracked heater exhaust muffler which resulted from an improper repair. Factors were the physical impairment of the solo flight student as a result of her inadequate training concerning carbon monoxide hazards.Oct 26, 1994 · N7XC · No damageNTSB SEA95FA010Accident · 2 fatalField investigationFinal reportBeech 58 Foxstar · Shaw Island, WAFailure of the pilot to maintain adequate airspeed during takeoff and initial climb, which resulted in a stall and subsequent collision with the ground. Factors related to the accident were: darkness, the pilot's improper decision to take off on an unlighted…Oct 24, 1994 · N333KS · DestroyedNTSB MIA95LA008Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLFailure of the pilot to refuel resulting in loss of engine power due to fuel exhaustion.Oct 24, 1994 · N3629X · Substantial damageNTSB LAX95LA019Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350D · Kaupo, HIa total loss of engine power by the corrosion fatigue failure of the compressor impeller due to the failure of company maintenance personnel to perform the prescribed daily compressor wash procedures and the inadequate maintenance inspections, which failed to…Oct 24, 1994 · N5771L · Substantial damageNTSB FTW95LA029Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Tomball, TXA partial power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Oct 24, 1994 · N2166U · Substantial damage