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 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.NTSB ANC93LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Delta Junction, AKA loss of control for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB LAX93LA209Accident · No injuriesLimited investigationFinal reportBell 47-G2 · AntarcticaThe pilot's poorly planned approach.NTSB 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.NTSB FTW93LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Palacios, TXThe pilot's selection of unsuitable terrain for landing. A factor was the hidden culvert.NTSB 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 terrainNTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB MIA93WA113Accident · No injuriesForeign investigationCessna 401 · Middle Caicos, Turks & Caicos IslandsNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB DEN93LA046Accident · No injuriesLimited investigationFinal reportCessna 172M · Meeker, COThe pilot's improper compensation for wind conditions. A factor was: gusty crosswinds.NTSB DEN93FA047Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inflight encounterwith a microburst at an altitude insufficient to effect recovery.NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.NTSB 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.NTSB 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.NTSB DEN93LA048Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Newark, TXAn inadvertent stall. A factor was: the pilot's diverted attention.NTSB CHI93LA164Accident · No injuriesLimited investigationFinal reportGrumman TBM-3E · Spooner, WIThe pilot's failure to maintain directional control.NTSB CHI93LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Lake Village, INThe pilot in command's inadequate preflight planning.NTSB CHI93LA146Accident · No injuriesLimited investigationFinal reportChampion 7GCBA · Duluth, MNPilot in command failed to maintain directional control.NTSB 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.NTSB 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.NTSB 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.NTSB FTW93FA138Accident · 1 fatalField investigationFinal reportSnobird 532 · Early, TXThe pilot's inadvertent porpoise. A factor was the improperly adjusted trim springNTSB 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…NTSB 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.NTSB CHI93LA147Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Middle River, MNThe total failure of the ignition system's magneto.NTSB 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…NTSB 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.NTSB NYC93LA089Accident · No injuriesLimited investigationFinal reportBoeing E75 · Zanesville, OHImproper use of the throttle by the pilot.NTSB 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.NTSB 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.NTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB 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.NTSB 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.NTSB 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…NTSB LAX93LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe loss of engine power for undetermined reasons.