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 ATL93LA084Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamilton, ALThe pilot's failure to properly calculate fuel consumption at an increased power setting, which resulted in fuel exhaustion and loss of engine power. Trees at the forced landing area were a factor in the accident.Apr 29, 1993 · N9696 · DestroyedNTSB ANC93LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Delta Junction, AKA loss of control for undetermined reasons.Apr 29, 1993 · N2578P · DestroyedNTSB NYC93LA094Accident · Minor injuriesLimited investigationFinal reportSteven Kurtis Rand S 12 · E Stroudsburg, PAA forced landing in trees as a result of a complete loss of engine power for unknown reasons.Apr 28, 1993 · N6784J · Substantial damageNTSB MIA93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · La Belle, FLThe pilot in commands failure to correct for wind conditions during landing rollout resulting in the aircraft flipping over during wind gust encounter.Apr 28, 1993 · N5712Z · Substantial damageNTSB MIA93LA111Accident · No injuriesLimited investigationFinal reportCessna 172P · Orlando, FLThe pilot-in-command's failure to compensate for wind drift while landing, resulting in the aircraft going off the side of the runway and colliding with a pond.Apr 28, 1993 · N51202 · Substantial damageNTSB LAX93LA209Accident · No injuriesLimited investigationFinal reportBell 47-G2 · AntarcticaThe pilot's poorly planned approach.Apr 28, 1993 · N1437 · Substantial damageNTSB LAX93LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeport, CAthe student pilot's misjudging the landing flare altitude. A factor relating to this accident was the student pilot's lack of total experience.Apr 28, 1993 · N6273Q · Substantial damageNTSB FTW93LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Palacios, TXThe pilot's selection of unsuitable terrain for landing. A factor was the hidden culvert.Apr 28, 1993 · N2880Z · Substantial damageNTSB FTW93LA139Accident · No injuriesLimited investigationFinal reportBell-K Copter 47G-2 · Walnut Ridge, ARWas the pilot's failure to maintain clearance of wires. A factor was the unsuitable terrainApr 28, 1993 · N7766 · Substantial damageNTSB FTW93IA141Incident · No injuriesIncident investigationFinal reportCommander 114B · Oklahoma City, OKThe pilot of the pitts, N51ST, misunderstanding of the tower's instructions and clearance, and his failure to see and avoid the Commander 114B, N194A.Apr 28, 1993 · N194A · 2 aircraft · Minor damageNTSB DEN93LA051Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Truman, ARA power loss for undetermined reasons. A factor was: the lack of suitable terrain for the forced landing.Apr 28, 1993 · N31182 · DestroyedNTSB ATL93FA082Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Statesboro, GAInadequate visual lookout by the pilots of both aircraft. Factors related to the accident were: failure of the pilot of N9317L to illuminate his aircraft navigation lights, and improper radio communications by the pilot of N47WD by selecting the wrong UNICOM…Apr 28, 1993 · N9317L · 2 aircraft · Substantial damageNTSB NYC93LA096Accident · No injuriesLimited investigationFinal reportAir & Space 18-A · Paducah, KYThe inadequate supervision by the flight instructor resulting in a loss of directional control while conducting a simulated emergency, and the subsequent collision with the terrain during a roll over.Apr 27, 1993 · N6126S · Substantial damageNTSB NYC93LA093Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Murraysville, PAFailure of the pilot to maintain rotor RPM, which resulted in a hard landing and rollover. A factor related to the accident was the pilot's lack of total helicopter experience.Apr 27, 1993 · N2618Z · Substantial damageNTSB MIA93WA113Accident · No injuriesForeign investigationCessna 401 · Middle Caicos, Turks & Caicos IslandsApr 27, 1993 · N666L · Substantial damageNTSB MIA93LA130Accident · 2 fatalLimited investigationFinal reportSmith FW2C80TD · Lucedale, MSThe pilot in command's operation of the aircraft in a manner which exceeded design limitations which resulted in inflight failure and separation of the wings.Apr 27, 1993 · N912WB · DestroyedNTSB MIA93LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Miami, FLThe failure of the pilot-in-command to anticipate turbulence in observed weather and request that flight attendants be seated, before encountering the observed weather.Apr 27, 1993 · N646DL · No damageNTSB LAX93LA189Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Sacramento, CAfailure of the pilot in command to maintain adequate airspeed during a low altitude maneuvering turn which resulted in an inadvertent stall.Apr 27, 1993 · N8307K · Substantial damageNTSB DEN93FA049Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COA vibration in the right main landing gear, for undetermined reasons, which resulted in collapse of the right main gear. A factor was failure of the pilot in command to ensure deployment of the ground spoilers.Apr 27, 1993 · N72822 · Substantial damageNTSB ATL93LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Myrtle Beach, SCThe pilot's improper compensation for wind conditions during the approach and landing. Factors were the gusts, turbulence, and tailwind conditions at the landing site.Apr 27, 1993 · N96DM · Substantial damageNTSB NYC93LA092Accident · No injuriesLimited investigationFinal reportCessna P337 · Holland, VAThe pilot's improper inflight planning during the approach for landing, resulting in a touchdown too FAR down the runway, and the subsequent collision with objects off the end of the runway.Apr 26, 1993 · N9CV · Substantial damageNTSB LAX93LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Las Vegas, NVThe pilot's failure to maintain directional control of the aircraft during the touchdown. Factors in the accident were the pilot's lack of experience and his failure to maintain a balance between the wing fuel tanks.Apr 26, 1993 · N83364 · Substantial damageNTSB LAX93FA190Accident · No injuriesField investigationFinal reportCessna 172 · Bullhead City, AZa fatigue failure of the crankshaft due to improper assembly of the engine during the major overhaul.Apr 26, 1993 · N6698A · Substantial damageNTSB LAX93FA186Accident · 2 fatalField investigationFinal reportBeech 58 · Tucson, AZThe pilots improper preflight inspection, his failure to compeltely secure the aft utility door, and his failure to reconfigure the trim tabs to a takeoff setting. The utility door's sudden opening just after rotation and the effect of the nose up trim…Apr 26, 1993 · N158WB · DestroyedNTSB DEN93LA046Accident · No injuriesLimited investigationFinal reportCessna 172M · Meeker, COThe pilot's improper compensation for wind conditions. A factor was: gusty crosswinds.Apr 26, 1993 · N4472R · Substantial damageNTSB DEN93FA047Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inflight encounterwith a microburst at an altitude insufficient to effect recovery.Apr 26, 1993 · N14816 · Substantial damageNTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.Apr 25, 1993 · N1406Y · DestroyedNTSB MIA93FA109Accident · 1 fatalField investigationFinal reportCessna TU206D · Culebra, PRFatigue failure of the engine crankshaft that originated from a heat check crack in the journal, adjacent to the #2 main journal forward fillet.Apr 25, 1993 · N72158 · DestroyedNTSB LAX93LA192Accident · No injuriesLimited investigationFinal reportCessna 182C · Tucson, AZThe excessive approach speed and failure of the first pilot to flare the airplane properly. A factor was the failure of the second pilot to properly supervise the flight.Apr 25, 1993 · N8813T · Substantial damageNTSB DEN93LA048Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Newark, TXAn inadvertent stall. A factor was: the pilot's diverted attention.Apr 25, 1993 · N2510F · Substantial damageNTSB CHI93LA164Accident · No injuriesLimited investigationFinal reportGrumman TBM-3E · Spooner, WIThe pilot's failure to maintain directional control.Apr 25, 1993 · N93818 · Substantial damageNTSB CHI93LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Lake Village, INThe pilot in command's inadequate preflight planning.Apr 25, 1993 · N4559U · Substantial damageNTSB CHI93LA146Accident · No injuriesLimited investigationFinal reportChampion 7GCBA · Duluth, MNPilot in command failed to maintain directional control.Apr 25, 1993 · N9902Y · Substantial damageNTSB SEA93LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Forest Grove, ORThe pilot in command's inadequate preflight planning. Factors contributing to the accident were the wet terrain, tailwind, trees, and wires.Apr 24, 1993 · N9637P · Substantial damageNTSB NYC93LA091Accident · No injuriesLimited investigationFinal reportHomer Davis RV4 · Danville, VAThe loss of engine power due to a stuck carburetor needle valve; subsequent forced landing in unsuitable terrain, and impact with a tree.Apr 24, 1993 · N22DD · Substantial damageNTSB LAX93FA185Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Twin Peaks, CAThe pilot's inadvertent flight into IMC, the radar controller's issuance of incorrect terrain information, the controller's failure to issue a low altitude safety alert, and the controller's failure to provide emergency services.Apr 24, 1993 · N6884P · DestroyedNTSB FTW93FA138Accident · 1 fatalField investigationFinal reportSnobird 532 · Early, TXThe pilot's inadvertent porpoise. A factor was the improperly adjusted trim springApr 24, 1993 · N6147N · DestroyedNTSB DEN93IA044Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Denver, COThe pilot-in-command's failure to maintain adequate separation from the Boeing 757, and his failure to stay above the probable path of the Boeing's wake vortices, which resulted in the vortex encounter. Factors related to the accident were: the crosswind, and…Apr 24, 1993 · N905UA · No damageNTSB CHI93LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Yankton, SDThe pilot in command's failure to maintain proper clearance. Gusty wind conditions were a factor.Apr 24, 1993 · N5548W · DestroyedNTSB CHI93LA147Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Middle River, MNThe total failure of the ignition system's magneto.Apr 24, 1993 · N81HF · Substantial damageNTSB ANC93FA054Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kashwitna, AKThe pilot in command not maintaining control of the airplane and his inadequate preflight preparation for high mountain terrain big game operations. Factors contributing to the accident were: the high terrain condition and the lack of total experience in the…Apr 24, 1993 · N3741Z · DestroyedNTSB NYC93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe improper flare by the pilot allowing the airplane to balloon and land hard. A factor in this accident was pilot's lack of recent flying experience.Apr 23, 1993 · N734QF · Substantial damageNTSB NYC93LA089Accident · No injuriesLimited investigationFinal reportBoeing E75 · Zanesville, OHImproper use of the throttle by the pilot.Apr 23, 1993 · N181RF · Substantial damageNTSB LAX93LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Needles, CAthe total loss of engine power due to the failure of the magneto in the ignition system. The magneto failure resulted from the operator's lack of voluntary compliance with the manufacturers suggested overhaul cycle.Apr 23, 1993 · N6292D · Substantial damageNTSB FTW93FA137Accident · 2 fatalField investigationFinal reportBell 206B III · Austin, TXAircraft control not maintained by pilot in command. Factors were unfavorable winds and pilot's lack of recent experience.Apr 23, 1993 · N2205X · DestroyedNTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.Apr 23, 1993 · N3917Z · Substantial damageNTSB ANC93LA053Accident · No injuriesLimited investigationFinal reportCessna A185F · Goose Bay, AKThe instructor pilot's delay of remedial action during the simulated forced landing. Factors were the dual student's failure to maintain the proper descent rate, and his failure to attain proper alignment with the runway prior to touchdown.Apr 23, 1993 · N5077G · Substantial damageNTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.Apr 22, 1993 · N3163X · Substantial damageNTSB LAX93LA188Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 · Calistoga, CAThe balloon's encounter with higher than forecast winds which resulted in a hard landing. A factor in the accident was the design of the balloon basket with a recessed area which prevented any lateral movement of the injured passenger's foot during the…Apr 22, 1993 · N63164 · No damageNTSB LAX93LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe loss of engine power for undetermined reasons.Apr 22, 1993 · N1060X · Destroyed