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 NYC00WA271Accident · 1 fatalForeign investigationBell 206B · Mattawa, CanadaNTSB LAX00GA185Accident · Serious injuriesFinal reportBeech 65-90 · China Lake, CAthe inadvertent early deployment of the test parachute lines and dummy and it's entanglement with the horizontal stabilizer, which resulted from the operator's inadequate test plan substantiation process for shortening the parachute's static line. .NTSB DEN00FA085Accident · No injuriesField investigationFinal reportde Havilland DHC-6-300 · Monument Valley, UTThe pilot-in-command's failure to maintain directional control. A factor was wind shear.NTSB ANC00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Haines, AKThe pilot's failure to attain a proper touchdown point.NTSB SEA00LA082Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Ephrata, WALoss of engine power due to failure of the number three cylinder exhaust valve push rod. Soft terrain encountered during the landing roll-out was a factor.NTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.NTSB DEN00FA084Accident · 3 fatalField investigationFinal reportAerospatiale AS-350B · Blanding, UTthe pilot's loss of aircraft control due to abrupt flight maneuvering. Contributing factors were the high density altitude weather condition, the total loss of engine power due to the pilot manually introducing excessive fuel into the engine and over temping…NTSB SEA00LA083Accident · No injuriesLimited investigationFinal reportde Havilland U-6A · Kenmore, WAThe pilot's failure to maintain control of the aircraft during the landing roll. Contributing factors were the power wave created by the nearby yacht, the rough water conditions, and the pilot's loss of visual contact with the wave during the rollout.NTSB DEN00LA083Accident · No injuriesLimited investigationFinal reportHughes 269C · Loveland, COThe pilot misjudged the run on landing during a full autorotation. Factors were a total loss of power for unknown reasons and soft terrain.NTSB CHI00LA131Accident · No injuriesLimited investigationFinal reportHughes 269C · Aberdeen, SDthe ground resonance encountered by the pilot.NTSB LAX00LA182Accident · No injuriesLimited investigationFinal reportSmith Arthur Fox Long EZ · Fallon, NVThe pilot's failure to maintain runway alignment and directional control during a crosswind landing that resulted in a touchdown off the runway surface in soft sand. A factor in the accident was an earlier improper repair, which weakened the landing gear…NTSB IAD00RA041Accident · 2 fatalForeign investigationLearjet 35A · Lyon, FranceNTSB DEN00FA082Accident · 2 fatalField investigationFinal reportMcDonnell Douglas 369E · Bloomfield, NMThe pilot's intentional buzzing (low level flying), and his failure to maintain clearance with the static wire. A factor was his physical impairment by a contraindicated drug controlled substance.NTSB CHI00LA130Accident · Minor injuriesLimited investigationFinal reportGrunska Kitfox IV · Neenah, WIthe pilot's failure to maintain driectional control of the airplane while landing. A factor associated with the accident was the tree that the airplane contacted.NTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.NTSB ATL00LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marco Island, FLThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a nose over.NTSB ATL00LA050Accident · No injuriesLimited investigationFinal reportCessna 501 · Orlando, FLThe pilot's failure to follow the landing checklist that resulted in the delay of lowering the landing gear before touchdown.NTSB SEA00LA079Accident · No injuriesLimited investigationFinal reportMorton Christavia Mark I · Salem, ORThe pilot/builder's failure to correct the center of gravity computations after a weight increase. A contributing factor was the pilot/builder's exceeding the forward CG limit in fuel weight, of which both conditions resulted in a degradation of aircraft…NTSB NYC00IA124Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · White Plains, NYThe pilots of the CRJ were conducting a visual approach at night. As the wing flaps were extended from 30 degrees, to 45 degrees, there was an uncommanded extension of the right wing flight spoiler. A roll to the right accompanied the extension, which was…NTSB LAX00LA181Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Rialto, CAThe student's misjudged altitude and failure to maintain rotor rpm while practicing an autorotation, and, the instructor's delayed remedial corrective action and inadequate supervision of the flight.NTSB DEN00IA080Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Denver, COThe accumulation of ice on the supercharger exit guide vanes that reduced core engine airflow, resulting in a loss of power. Factors were the clouds and icing conditions.NTSB ATL00LA049Accident · No injuriesLimited investigationFinal reportde Havilland DH-82C Tigermoth · Daytona Beach, FLThe pilot's inadequate pre-flight inspection of the fuel supply that resulted in the loss of engine power due to fuel contamination.NTSB ANC00LA053Accident · No injuriesLimited investigationFinal reportBell 206B · Homer, AKThe pilot's misjudging the landing flare in whiteout/flat light conditions. Factors associated with the accident are the whiteout and flat lighting conditions.NTSB ANC00FA052Accident · 1 fatalField investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in the accident were weather conditions consisting of low ceilings, fog, a whiteout, and the…NTSB SEA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hillsboro, ORAn inadequately planned approach. Misjudging distance/altitude and improper remedial action were factors.NTSB NYC00LA126Accident · No injuriesLimited investigationFinal reportCessna 185F · Pottstown, PAThe second pilot's inadequate compensation for wind conditions and the inadequate supervision of the flight instructor. Factors related to the accident were the crosswind and gusting wind conditions.NTSB NYC00LA125Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Nassawadox, VAA loss of engine power caused by detonation of the #2 piston.NTSB DEN00LA079Accident · 1 fatalLimited investigationFinal reportGreen GTX-SE-FI · Gillette, WYThe pilot's abruptly pulling the nose up at an excessive airspeed, resulting in the rotor blades striking the vertical stabilizer and a subsequent loss of aircraft control.NTSB DEN00FA086Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Estes Park, COA descent below the surrounding terrain, by the pilot, in IMC conditions. Factors were high mountainous terrain, clouds, inaccurate weather evaluation by the pilot, and the pilot's flight into IMC conditions.NTSB DCA00WA046Accident · 12 fatalForeign investigationDouglas DC-10-30 · Entebbe, UgandaNTSB CHI00LA127Accident · Minor injuriesLimited investigationFinal reportFairchild PT-26B · Winn, MIthe pilot's inadequate fuel management. Factors to the accident were fuel starvation, the low altitude at the time of the loss of engine power, remedial action not possible by the pilot, and the unsuitable terrain for landing encountered by the pilot.NTSB ATL00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-200 · Mt. Pleasant, SCThe airplane collision with a deer during a night landing.NTSB ATL00LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Clinton, TNThe pilot's inadequate in-flight planning necessitating an intentional ground loop maneuver on landing. Contributing factors were the pilot's misjudgment of distance/airspeed, the high terrain surrounding the runway, and the tailwind condition.NTSB SEA00FA080Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Fort Smith, MTThe pilot's failure to maintain clearance from the terrain. Factors include low ceilings, snow, rain, and rising, mountainous/hilly terrain.NTSB MIA00WA142Accident · Minor injuriesForeign investigationBell 206A · Chascomus, ArgentinaNTSB LAX00LA180Accident · No injuriesLimited investigationFinal reportTracy Lancair 235 · Redding, CAThe pilot's loss of directional control during takeoff for undetermined reasons.NTSB LAX00LA179Accident · Serious injuriesLimited investigationFinal reportCone Questair Venture · Delano, CALoss of directional control during landing for undetermined reasons.NTSB LAX00LA177Accident · No injuriesLimited investigationFinal reportCessna 180 · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his improper positioning of the flight controls.NTSB FTW00LA137Accident · No injuriesLimited investigationFinal reportBell 206L3 · Salt MarshThe company mechanic's failure to replace the bolt's cotter key properly and the subsequent loss of the nut, which then resulted in the tail rotor control disconnection and the pilot's inability to maintain aircraft control.NTSB CHI00LA126Accident · No injuriesLimited investigationFinal reportBeech UC-45J · Urbana, ILthe pilot not maintaining directional control on the ground and the abrupt brake application during the landing roll.NTSB ANC00LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seldovia, AKThe pilot's failure to maintain directional control of the airplane. A factor in the accident was an inadvertent ground swerve.NTSB ANC00LA050Accident · No injuriesLimited investigationFinal reportCessna 182 · Wasilla, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a soft area of runway.NTSB MIA00FA141Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Elk Park, NCThe inflight loss of control for undetermined reasons resulting in the airplane colliding with mountainous terrain during the uncontrolled descent.NTSB LAX00LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Buckeye, AZThe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the uneven runway surface.NTSB LAX00FA178Accident · 4 fatalField investigationFinal reportCessna 172P · Chester, CAThe pilot's encounter with a wind shear at low altitude, which resulted in a loss of control and a stall/spin. Factors in the accident were the high density altitude and the pilot's lack of experience and training in high density altitude operations. The…NTSB LAX00FA176Accident · 2 fatalField investigationFinal reportCessna T210L · North Las Vegas, NVThe pilot's failure to maintain control of the airplane during a go-around in a crosswind condition.NTSB FTW00LA134Accident · No injuriesLimited investigationFinal reportCessna 140 · Tulsa, OKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the runway sign struck by the aircraft.NTSB FTW00LA133Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Claremore, OKThe pilot's premature raising of the flaps.NTSB DEN00LA081Accident · No injuriesLimited investigationFinal reportHutchins RV4 · Los Alamos, NMThe pilot's failure to maintain control of the aircraft after initiating a go-around following a hard bounced landing. Factors were variable shifting winds and a high-density altitude.NTSB DEN00FA078Accident · No injuriesField investigationFinal reportDouglas DC-8-62F · Denver, COThe failure of the clamp that secured the high-pressure bleed air duct to the high-pressure relief valve. Factors were the resulting excessive pressurization of the engine nacelle, and the subsequent separation of the engine cowling.