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 CHI89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Grayslake, ILThe pilot's improper flare and recovery from a bounced landing, and his failure to go around (when there was sufficient speed and runway remaining). A contributing factor was his lack of recent experience in type of aircraft.NTSB CHI89DEM04Accident · No injuriesFinal reportCessna 175 · Lawton, MIThe pilot's delay in aborting takeoff and his excessive rate of descent at touchdown. A factor in the accident was the pilot's inadequate preflight planning.NTSB NYC89LA165Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lancaster, NYWater contamination of the fuel, and an inadequate preflight by the pilot-in-command.NTSB NYC89LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Hammond, NYThe pilot's decision to abort the takeoff with insufficient runway remaining. Contributing to the the accident was a wet grass runway and the faulty tachometer which influenced the pilot's decision.NTSB MKC89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Camdenton, MOAircraft control was not maintained by the pilot in command.NTSB LAX89FA239Accident · 1 fatalField investigationFinal reportChristen Industries A-1 Husky · Somerton, AZFailure of the pilot to maintain adequate airspeed, which resulted in a stall. The lack of altitude for recovery was a related factor.NTSB FTW89LA141Accident · Minor injuriesLimited investigationFinal reportBeech 35-C33A · Fort Worth, TXFuel exhaustion due to pilot mismanagement.NTSB FTW89DRA07Accident · 1 fatalFinal reportLowe/Bensen KB-2 · Wharton, TXPoor judgement by the student pilot by performing excessive/low altitude maneuvers, which resulted in his failure to maintain sufficient clearance (altitude) above the open field. His lack of familiarity with the aircraft was a contributing factor.NTSB DEN89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Salt Lake City, UTThe pilot's improper use of the parking brake and his delay in aborting the takeoff. Factors related to the accident were: the fence & vehicle.NTSB CHI89LA136Accident · No injuriesLimited investigationFinal reportCessna 335 · Pontiac, MIFailure of the right main landing gear extension/retraction component resulting from unacceptable loads incurred due to improper adjustment.NTSB CHI89FA135Accident · 3 fatalField investigationFinal reportCessna 177 · Lockport, ILThe pilot's inadequate preflight planning/preparation, and his failure to attain adequate airspeed, which resulted in a stall or mush. A factor related to the accident was: the aircraft's excessive gross weight.NTSB ANC89LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Naknek, AKThe pilot failed to maintain airspeed and inadvertently allowed the airplane to stall.NTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.NTSB NYC89LA162Accident · No injuriesLimited investigationFinal reportBeech F33A · Waterville, METhe pilot's disregard of NOTAMS and the excessive landing speed which resulted in a long landing roll.NTSB MIA89LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Forest, MSFailure of the pilot to maintain runway alignment and partial loss of power from water in the fuel. Contributing factors were: uneven runway, pilot's improper recovery from a bounced landing, a gusty crosswind condition, and trees.NTSB MIA89LA195Accident · Serious injuriesLimited investigationFinal reportCessna 210N · Atlantic Ocean (Atlantic Ocean)A gunshot wound, which resulted in a loss of the pilot's ability to effectively fly and navigate the aircraft, and a subsequent loss of engine power due to fuel exhaustion.NTSB FTW89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Granite, OKThe pilot did not maintain directional control.NTSB FTW89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Okmulgee, OKFailure of the nose gear extension assembly and the pilot's improper precautionary landing procedures that included securing the engines prior to a point where a safe landing was assured.NTSB CHI89MA132Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC8-63F · Vandalia, OHFailure of the left main landing gear, bogie trim cylinder, and malfunction of the emergency airbrake control valve.NTSB CHI89LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Grosse Ile, MIThe student pilot's not correcting the porpoise on the first landing. A factor in the accident is the lack of experience of the student pilot.NTSB CHI89DEX05Accident · No injuriesFinal reportTexas Helicopter OH-13H/M74A · New Richmond, INThe pilot's misjudgement of the fuel supply which resulted in fuel exhaustion.NTSB ANC89LA123Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Kodiak, AKPilot-in-command's continued VFR flight into know IFR flt conditions, resulting in a collision with rising terrain.NTSB ANC89LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Parker Lake, AKImproper preflight planning by the pilot and his failure to attain and/or maintain adequate speed, which resulted in a stall/mush after lift-off.NTSB NYC89LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Doylestown, PAImproper preflight preparation by the pilot by taking off with the flaps extended, which resulted in an inadequate rate of climb to clear obstructions beyond the end of the runway, and the pilot's delay in aborting the takeoff and his failure in maintaining…NTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.NTSB MIA89LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Deland, FLImproper flare by the pilot and his improper recovery from a bounced landing.NTSB MIA89LA193Accident · No injuriesLimited investigationFinal reportCessna 208B · Fort Myers, FLImproper flare by the pilot for landing and improper remedial action. A contributing factor was the lack of airspeed on final approach.NTSB MIA89FA194Accident · 1 fatalField investigationFinal reportAirbus Industrie A-300 · San Juan, PRFailure of the ramp guide (ground personnel) to follow normal safety procedures. His over confidence in his personal ability was considered to be a contributing factor.NTSB MIA89FA192Accident · No injuriesField investigationFinal reportCessna 152 · Miami Lakes, FLThe failure of the pilot to visually inspect the airplane fuel tanks during the preflight inspection to assure adequate fuel to conduct the flight was available.NTSB DEN89LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Hatton, NDImproper in-flight planning/decision by the pilot and his failure to maintain sufficient clearance above the ground. The tailwind, high obstruction (shelter belt), and downdraft were contributing factors.NTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…NTSB BFO89FA057Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Berlin, MDPilot failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident was the low altitude at which the stall occurred.NTSB ATL89LA178Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Columbus, OHThe improper installation of the propeller governor idler-gear shaft retaining set-screw, which led to an engine oil leak and resulted in a loss of engine power; and the reduction of the pilot's ability to see outside the airplane due to oil on the windshield.NTSB ANC89DAG01Accident · No injuriesFinal reportScorpion II · Anchorage, AKUnqualified person at the flight controls, who was unable to maintain control of the helicopter. The nearby building (airport facility) was a contributing factor.NTSB SEA89LA132Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Middleton, IDThe pilot did not maintain an adequate visual lookout. A factor was the guy wires at the edge of the field.NTSB MIA89LA196Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Minter City, MSFailure of the pilot to see and avoid the powerline. The power line was a contributing factor.NTSB LAX89FA238Accident · No injuriesField investigationFinal reportEnstrom F28F · Oakland, CAFailure of the pilot to properly maintain rotor RPM throughout the autorotation.NTSB FTW89FA134Accident · Serious injuriesField investigationFinal reportCessna 150L · Fort Worth, TXA loss of control of the airplane due to the pilot's inability to raise the flaps which resulted in a stall. The flap failure and subsequent full flap takeoff were the result of the operator's improper maintenance of the airplane and the operator's use of a…NTSB FTW89FA133Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-D · Galveston, TXFailure of both pilots to see-and-avoid the other aircraft (inadequate visual lookout).NTSB FTW89FA132Accident · 1 fatalField investigationFinal reportCessna 152 · Arlington, TXPoor judgement of the pilot, due to impairment from consumption of alcohol, and his failure to maintain proper altitude while maneuvering. Factors related to the accident were: darkness, the pilot's recent use of drugs, and his lack of flight experience.NTSB DEN89LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wh Sulphur Spgs, MTThe pilot failed to maintain adequate airspeed during an aerial application maneuver and inadvertently allowed the aircraft to mush into the ground. Unfavorable wind and turbulence were considered to be contributing factors.NTSB CHI89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Logansport, INPoor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…NTSB ANC89FA119Accident · No injuriesField investigationFinal reportCessna 207 · 44 Nw Fairbanks, AKImproper planning/decision by the pilot, which resulted in fuel starvation. Factors related to the accident were: inaccurate fuel consumption calculations, inadequate fuel supply, turbulence, tailwind, terrain conditions, and trees (willows) in the emergency…NTSB MKC89LA158Accident · Minor injuriesLimited investigationFinal reportBristow KR-2 · Perry, IAFuel starvation caused by fuel contamination.NTSB MIA89LA191Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Pahokee, FLThe pilot's inadvertent loss of airplane control, while on the water, which resulted in a swerve and subsequent accident.NTSB MIA89LA190Accident · No injuriesLimited investigationFinal reportCessna 172M · Perry, FLFailure of the number three exhaust valve which necessitated a forced landing. The trees were considered to be a contributing factor.NTSB LAX89LA335Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Napa, CASuicide.NTSB CHI89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INImproper recovery from a bounced landing and failure to maintain directional control by the pilot. The student pilot's lack of flight experience contributed to the accident.NTSB SEA89LA131Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Prineville, ORThe pilot's failure to maintain adequate clearance from trees.