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 FTW95LA296Accident · No injuriesLimited investigationFinal reportCessna 210D · Bentonville, ARThe pilot's failure to attain the proper touchdown point. Factors were the mown grass and the high density altitude.NTSB FTW95LA295Accident · No injuriesLimited investigationFinal reportCessna 172L · Porter, TXThe loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed resulting in overshooting the landing.NTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.NTSB FTW95LA292Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Buren, ARA partial loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed during the precautionary landing resulting in an overshoot.NTSB FTW95FA294Accident · Serious injuriesField investigationFinal reportCessna 310D · Alamosa, COTotal loss of power in both engines due to flooding after the pilot had placed both fuel pump switches in the high boost position and moved the mixture controls to the full rich position. A factor related to the accident was: the lack of suitable terrain for…NTSB ANC95LA100Accident · No injuriesLimited investigationFinal reportCessna 180K · King Salmon, AKFailure of the pilot to adequately compensate for wind conditions, which resulted in a failure to maintain directional control. The downdraft and crosswind were related factors.NTSB SEA95LA146Accident · No injuriesLimited investigationFinal reportMooney M20G · Rigby, IDThe pilot's premature liftoff and failure to attain adequate airspeed during takeoff. The high density altitude was a factor.NTSB NYC95LA155Accident · No injuriesLimited investigationFinal reportBeech 77 · Celina, OHfailure of the pilot to maintain control of the airplane during the landing.NTSB NYC95LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, OHA loss of directional control during takeoff for undetermined reasons.NTSB LAX95LA252Accident · No injuriesLimited investigationFinal reportPitts S-1S · Livermore, CAthe pilot's failure to maintain runway alignment and subsequent collision with some bales of hay.NTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.NTSB CHI95LA218Accident · No injuriesLimited investigationFinal reportBeech C24R · Freeport, ILthe pilot's failure to maintain control of the airplane during the aborted takeoff.NTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.NTSB ATL95LA132Accident · No injuriesLimited investigationFinal reportCessna 310 · Ridgeland, SCThe pilot's failure to assure that the airplane's alternators were on which led to a complete loss of electrical power, and his failure to attempt to lower the landing gear by emergency procedures.NTSB ANC95TA102Accident · No injuriesFinal reportCessna 185C · Bettles, AKThe pilot-in-command's failure to properly judge the height of the airplane above the water during landing. Contributing to the accident were the glassy water conditions and an excessive descent rate at touchdown.NTSB SEA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mccall, IDImproper planning/decision by the pilot, which resulted in his failure (or inability) to remain clear of terrain after initiating a go-around. Factors relating to the accident were: the unfavorable terrain and wind conditions (including downdrafts).NTSB SEA95LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Esterbrook, WYThe pilot's failure to attain the proper touchdown point and airspeed for landing. Contributing to the accident were high density altitude, the short landing area, and the pilot's failure to initiate a go-around in time to allow recovery from the situation.NTSB NYC95LA157Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Queenstown, MDfailure of the fuselage longeron tubes due to fatigue, which resulted in partial separation (distortion) of the fuselage, partial loss of aircraft control, and a partial loss of engine power.NTSB NYC95LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Belmar, NJThe student pilot's (1) misjudged flare (2) inadequate recovery from a bounced landing (3) failure to maintain directional control and the certified flight instructor's inadequate supervision.NTSB NYC95LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Minersville, PAthe student pilot's improper go-around procedure, which resulted in an inadvertent stall/mush into trees.NTSB MIA95LA181Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Lambert, MSUnsuitable terrain encountered during the forced landing. Contributing to the accident was the partial loss of engine power due to failure of the no. 4 cylinder intake valve rocker arm bosses.NTSB LAX95LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Van Nuys, CAfuel starvation resulting from the failure of the pilot to properly configure the fuel selector to a tank containing fuel during the landing approach.NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA289Accident · No injuriesLimited investigationFinal reportCessna 182 · Port Sulphur, LAThe pilot's misjudgement of his short field landing resulting in an intentional ground loop to avoid an overrun. Factors were the reduced braking effectiveness on the wet grass runway.NTSB FTW95LA288Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARThe pilot delayed pull-up from a swath run and failed to maintain clearance from the obstruction (grain elevator). A factor relating to the accident was: the pilot's use of medications that were not approved for use while flying.NTSB CHI95LA217Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Kenmare, NDthe pilot's not obtaining/maintaining proper climb rate.NTSB NYC95LA147Accident · 1 fatalLimited investigationFinal reportBell 47G-3B-1 · Hammonton, NJfailure of the collective yoke bearing, which resulted in an uncontrolled descent and collision with trees. A factor relating to the accident was: the manufacturer's inadequate inspection interval of the yoke bearing.NTSB MIA95WA179Accident · 1 fatalForeign investigationAero Commander 500 · Treasure Cay, BahamasNTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB MIA95GA178Accident · 2 fatalFinal reportPiper L-21A · Lorida, FLThe pilot's failure to maintain airspeed while his attention was diverted.NTSB FTW95RA287Accident · 3 fatalForeign investigationAerospatiale AS355F · Mexico City, MexicoNTSB FTW95LA290Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · De Witt, ARThe pilot's failure to maintain airspeed and the resulting inadvertent stall/mush.NTSB FTW95LA285Accident · 2 fatalLimited investigationFinal reportMeyer Pulsar XP · Spring Branch, TXThe pilot's improper positioning of the fuel tank selector and his failure to maintain airspeed. A factor was the pilot's diverted attention to the power loss.NTSB FTW95FA277Accident · 4 fatalField investigationFinal reportBellanca 17-31A · Hot Springs, ARThe partial loss of engine power as a result of the disengagement of the throttle cable housing due to improper maintenance. Factors were the night condition and the lack of suitable terrain.NTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…NTSB SEA95LA145Accident · 2 fatalLimited investigationFinal reportWheeler Kitfox V · Silvana, WAThe pilot's failure to maintain aircraft control. The emergency ballistic parachute not being deployed was a factor in the accident.NTSB NYC95LA156Accident · No injuriesLimited investigationFinal reportSchweizer S-2-33A · Elmira, NYThe pilot's delayed decision to return to the departure airport, which resulted in insufficient gliding altitude, and the subsequent off airport landing in the trees.NTSB NYC95LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Stormville, NYThe reported pothole in the runway.NTSB NYC95LA149Accident · No injuriesLimited investigationFinal reportMooney 20E · Burlington, CTthe pilot's failure to extend the landing gear resulting in a wheels up landing. A factor relating to the accident was the inoperative gear warning horn.NTSB NYC95LA145Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Monogahela, PAThe failure of the pilots of the monney M20C, N2763W, and the Piper PA-28, N7416R, to see and avoid each other.NTSB NYC95LA144Accident · 1 fatalLimited investigationFinal reportKoval Quickie II · Akron, OHthe pilot's improper maneuver during the turn to final approach, which resulted in an inadvertent stall/spin, and collision with the terrain. Factors in this accident were the pilot's lack of experience in this make and model, and his lack of recent…NTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.NTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.NTSB LAX95LA247Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Columbia, CAthe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control.NTSB LAX95LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rubidoux, CAthe pilot's inadequate preflight planning/preparation in that he attempted to fly an aircraft without first verifying the aircraft's gross weight and published performance capabilities.NTSB LAX95FA243Accident · 1 fatalField investigationFinal reportCessna 152 · Miramar, CAThe pilot's failure to maintain proper altitude (or clearance) above the terrain, while attempting to perform VFR flight in instrument meteorological conditions (IMC). Factors relating to the accident were: darkness and the adverse weather conditions.NTSB FTW95FA278Accident · 2 fatalField investigationFinal reportNorth American T-28B · Ramah, COThe aircrew allowed the airplane's design stress limits to be exceeded.NTSB CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.NTSB ANC95LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Kotzebue, AKFuel exhaustion due to the pilot's improper planning/decision. The unfavorable (stronger than forecast) headwind was a related factor.NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.