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.

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.Jul 15, 1989 · N8301F · Substantial damageNTSB 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.Jul 15, 1989 · N7404M · Substantial damageNTSB NYC89LA165Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lancaster, NYWater contamination of the fuel, and an inadequate preflight by the pilot-in-command.Jul 14, 1989 · N6171B · Substantial damageNTSB 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.Jul 14, 1989 · N5913W · Substantial damageNTSB MKC89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Camdenton, MOAircraft control was not maintained by the pilot in command.Jul 14, 1989 · N2892A · Substantial damageNTSB 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.Jul 14, 1989 · N29162 · DestroyedNTSB FTW89LA141Accident · Minor injuriesLimited investigationFinal reportBeech 35-C33A · Fort Worth, TXFuel exhaustion due to pilot mismanagement.Jul 14, 1989 · N9497S · Substantial damageNTSB 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.Jul 14, 1989 · N7037K · DestroyedNTSB 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.Jul 14, 1989 · N6144H · Substantial damageNTSB 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.Jul 14, 1989 · N2706T · Substantial damageNTSB 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.Jul 14, 1989 · N3146T · DestroyedNTSB ANC89LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Naknek, AKThe pilot failed to maintain airspeed and inadvertently allowed the airplane to stall.Jul 14, 1989 · N5745W · Substantial damageNTSB 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.Jul 13, 1989 · N5014H · Substantial damageNTSB 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.Jul 13, 1989 · N961WW · Substantial damageNTSB 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.Jul 13, 1989 · N3905L · Substantial damageNTSB 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.Jul 13, 1989 · N9913Y · DestroyedNTSB FTW89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Granite, OKThe pilot did not maintain directional control.Jul 13, 1989 · N23414 · Substantial damageNTSB 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.Jul 13, 1989 · N699PC · Substantial damageNTSB 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.Jul 13, 1989 · N950R · Substantial damageNTSB 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.Jul 13, 1989 · N24378 · Substantial damageNTSB CHI89DEX05Accident · No injuriesFinal reportTexas Helicopter OH-13H/M74A · New Richmond, INThe pilot's misjudgement of the fuel supply which resulted in fuel exhaustion.Jul 13, 1989 · N10002 · Substantial damageNTSB 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.Jul 13, 1989 · N5354G · Substantial damageNTSB 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.Jul 13, 1989 · N27024 · Substantial damageNTSB 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…Jul 12, 1989 · N10659 · Substantial damageNTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.Jul 12, 1989 · N79291 · Substantial damageNTSB MIA89LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Deland, FLImproper flare by the pilot and his improper recovery from a bounced landing.Jul 12, 1989 · N5814G · Substantial damageNTSB 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.Jul 12, 1989 · N921FE · Substantial damageNTSB 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.Jul 12, 1989 · N7062A · No damageNTSB 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.Jul 12, 1989 · N69224 · Substantial damageNTSB 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.Jul 12, 1989 · N3269L · DestroyedNTSB 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…Jul 12, 1989 · N4054J · Substantial damageNTSB 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.Jul 12, 1989 · N57417 · DestroyedNTSB 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.Jul 12, 1989 · N2153K · Substantial damageNTSB 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.Jul 12, 1989 · N5577G · Substantial damageNTSB 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.Jul 11, 1989 · N5571X · Substantial damageNTSB 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.Jul 11, 1989 · N4967X · Substantial damageNTSB LAX89FA238Accident · No injuriesField investigationFinal reportEnstrom F28F · Oakland, CAFailure of the pilot to properly maintain rotor RPM throughout the autorotation.Jul 11, 1989 · N288 · Substantial damageNTSB 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…Jul 11, 1989 · N17250 · Substantial damageNTSB FTW89FA133Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-D · Galveston, TXFailure of both pilots to see-and-avoid the other aircraft (inadequate visual lookout).Jul 11, 1989 · N3595B · 2 aircraft · DestroyedNTSB 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.Jul 11, 1989 · N49056 · DestroyedNTSB 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.Jul 11, 1989 · N6663Z · Substantial damageNTSB 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…Jul 11, 1989 · N64087 · Substantial damageNTSB 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…Jul 11, 1989 · N8855B · DestroyedNTSB 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…Jul 11, 1989 · N91052 · Substantial damageNTSB MKC89LA158Accident · Minor injuriesLimited investigationFinal reportBristow KR-2 · Perry, IAFuel starvation caused by fuel contamination.Jul 10, 1989 · N1066 · Substantial damageNTSB 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.Jul 10, 1989 · N4453 · Substantial damageNTSB 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.Jul 10, 1989 · N4427Q · Substantial damageNTSB LAX89LA335Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Napa, CASuicide.Jul 10, 1989 · N77969 · DestroyedNTSB 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.Jul 10, 1989 · N2545A · Substantial damageNTSB SEA89LA131Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Prineville, ORThe pilot's failure to maintain adequate clearance from trees.Jul 9, 1989 · N36532 · Destroyed