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 CHI94LA058Accident · Serious injuriesLimited investigationFinal reportMooney M-20E · Chesterfield, MOthe pilot's failure to assure an adequate fuel supply for the planned flight. Factors associated with the accident were the trees, unreliable fuel gauges and the pilot's decision to operate the airplane with the known unreliable fuel gauges.NTSB ANC94LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot-in-command not maintaining the proper clearance from the terrain during the approach.NTSB LAX94LA076Accident · No injuriesLimited investigationFinal reportHughes 369D · Waimea, Kauai, HIAn inadequate engine compressor cleaning procedure specified in the manufacturer's service letter, which resulted in the total loss of engine power due to contamination, blockage, and collapse of the fuel nozzle inlet screen. Factors in the accident were: the…NTSB FTW94FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Franktown, COWas the pilot's disregard of forecast icing conditions and delayed application of carburetor heat, resulting in structural and induction icing. Factors were the icing conditions and unsuitable terrain for a forced landing.NTSB CHI94LA056Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Mcintosh, SDwas continued VFR flight into IMC and the failure to maintain clearance with the terrain. Factors associated with this accident were an inaccurate weather evaluation by the pilot, snow and the rising terrain.NTSB CHI94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Centerville, IAthe pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.NTSB FTW94FA050Accident · 1 fatalField investigationFinal reportCessna 172M · Lancaster, TXwas THE FAILURE OF THE PILOT TO MAINTAIN AIRCRAFT CONTROL DUE TO PHYSICAL IMPAIRMENT (ALCOHOL).NTSB CHI94LA055Accident · No injuriesLimited investigationFinal reportCessna 185 · Grand Island, NEthe pilot's failure to maintain directional control of the airplane. A factor related to the accident was the gusty quartering tailwind condition.NTSB NYC94LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-301T · Norwood, MAThe pilot's delay in aborting the takeoff which resulted in a overrun of the runway. Factors were a snow covered runway, takeoff speed not attained, brakes not used, and a ditch.NTSB MIA94IA040Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Melbourne, FLWas inadequate quality control by the engine manufacturer which resulted in failure of the second stage low pressure turbine disk due to a machining anomaly and reduced fatigue strength due to sub standard heat treat processing.NTSB FTW94LA054Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Madisonville, TXThe pilot's continued flight into adverse weather. Factors were weather conditions and collision with a sign.NTSB CHI94LA065Accident · No injuriesLimited investigationFinal reportCessna 210M · Festus, MOImproper planning/decision by the pilot. Factors related to the accident were: the icy runway, crosswind and snowbank.NTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI94LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the pilot's lack of total flight experience.NTSB NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.NTSB MIA94LA039Accident · Minor injuriesLimited investigationFinal reportGrumman G-44A · Leesburg, FLThe pilot misjudged his altitude over glassy water during landing and inadvertently touched down in a flat attitude.NTSB LAX94LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Showlow, AZthe pilot's poorly planned approach, improper emergency procedures, and his failure to feather the propeller. The inoperative fuel selector valve was a factor in this accident.NTSB FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.NTSB CHI94LA052Accident · No injuriesLimited investigationFinal reportCessna 404 · Big Rapids, MIThe pilot's descent below the minimum descent altitude.NTSB SEA94LA041Accident · No injuriesLimited investigationFinal reportCessna 150J · Tonasket, WAThe pilot's failure to attain a proper touchdown point. Factors include an inadequate preflight, fuel exhaustion, and an icy landing area.NTSB NYC94FA040Accident · 2 fatalField investigationFinal reportAero Commander 500A · White Mills, PAwas the fracture and separation of the airplane wing, and the subsequent loss of control and collision with trees, as a result of the pilot's repeated performance of acrobatic maneuvers, which exceeded the design limits of the airplane.NTSB LAX94FA073Accident · 5 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Santa Ana, CAThe pilot-in-command's failure to maintain adequate separation behind the Boeing 757 and/or remain above its flight path during the approach, which resulted in an encounter with wake vortices from the 757. Factors related to the accident were: an inadequacy…NTSB SEA94FA040Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Spokane, WAThe pilot's failure to maintain proper alignment with the instrument landing system approach course. The pilot's failure to perform a missed approach was a factor.NTSB NYC94LA049Accident · 3 fatalLimited investigationFinal reportMooney M20J · Jones Beach, NYwas the pilot's failure to maintain control of the airplane, resulting in the airplane impacting with the water. Also casual in this accident was the pilot's total lack of experience in this type of aircraft, and operations. A factor in this accident was the…NTSB NYC94LA039Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Wilkes-Barre, PAwas the loss of engine oil for undetermined reasons and the subsequent engine failure, resulting in a forced landing and collision with trees.NTSB FTW94LA055Accident · No injuriesLimited investigationFinal reportEbershoff Steen Skybolt · Erie, COWas flutter of the flight controls.NTSB CHI94FA050Accident · 3 fatalField investigationFinal reportMitsubishi MU-300 · Goodland, KSThe pilot-in-command's inadvertent stall of the airplane. A factor associated with the accident is the pilot-in-command's poor IFR procedures.NTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.NTSB LAX94LA071Accident · No injuriesLimited investigationFinal reportRans S-14 · Riverside, CAthe pilot incorrectly selecting the wrong fuel valve and the subsequent engine failure due to fuel starvation.NTSB CHI94LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lacon, ILThe pilot misjudged the landing flare. Factors related to the accident were: the dark night, the pilot's lack of recent night experience, and the failure of the airplane's electrical system.NTSB FTW94LA048Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · El Paso, TXThe pilot's inadvertent flight into clear air turbulence.NTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.NTSB ANC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Lions, AKImproper inflight planning and decision-making by the pilot in command. Factors contributing to the accident were the icy runway condition and the tailwind.NTSB LAX94LA075Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flagstaff, AZThe pilot's improper initiation of an emergency autorotation into unsuitable terrain and subsequent hard landing and rollover. A false annunciator indication, a failure of the N1 tach generator, the pilot's continued flight with a known aircraft defect, and…NTSB FTW94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · C0rnell, ILthe pilot-in-command's misjudgment of fuel supply. A factor was fuel exhaustion.NTSB ATL94FA030Accident · 3 fatalField investigationFinal reportBeech M35 · Chapel Hill, NCThe improper engine overhaul by maintenance personnel. A factor in the accident was the failure of the engine crankshaft.NTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.NTSB ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.NTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.NTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.NTSB LAX94LA070Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Santa Paula, CAA failure of the pilot to maintain directional control of the tailwheel airplane following touchdown. The pilot's lack of total experience in the type of airplane was a factor in the accident.NTSB CHI94LA047Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Ashley, INInadequate aircraft preflight by the pilot-in-command. A factor relating to this accident is the dark night.NTSB ANC94LA025Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7AC · Circle City, AKThe pilot in commands intentional flight into known adverse weather conditions which lead to an inadvertent aerodynamic stall of the aircraft. Factors contributing to the accident were the ice fog and the icing conditions.NTSB LAX94LA069Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Chandler, AZThe flight instructor's failure to properly follow the aircraft ballasting procedures that resulted in a loss of control when the helicopter's center of gravity limits were exceeded. Inadequate supervision of the training flight was a factor in the accident.NTSB FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.NTSB ANC94LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Juneau, AKThe pilot in command's selection of a sight unsuitable for landing. A factor in the accident was the ditch on the beach.NTSB SEA94LA039Accident · No injuriesLimited investigationFinal reportHiller-Soloy UH-12D · Sublimity, ORFuel exhaustion due to inadequate preflight and refueling not acomplished.NTSB NYC94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lumberton, NJThe pilot's failure to maintain a proper glidepath due to improper compensation for the wind conditions. A factor was a crosswind.NTSB NYC94IA035Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Newark, NJThe separation of the right outboard translating cowl on the #2 engine thrust reverser as a result of inadequate bonding material.