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 MIA89LA242Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Perry, FLFuel starvation due to wear and restricted movement of the carburetor float, which resulted in loss of engine power. Soft terrain in the emergency landing area contributed to overload failure of the nose gear.Sep 3, 1989 · N4CD · Substantial damageNTSB MIA89LA241Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Booneville, MSLoss of engine power for an unknown reason. Trees in the emergency landing area were a factor.Sep 3, 1989 · N3724A · Substantial damageNTSB MIA89LA240Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Cayey, PRLoss of engine power for an unknown reason. A factor related to the accident was: the presence of trees in the emergency landing area.Sep 3, 1989 · N37870 · Substantial damageNTSB MIA89LA239Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Orlando, FLRetraction of the right main landing gear for an unknown reason.Sep 3, 1989 · N1072L · Substantial damageNTSB LAX89FA295Accident · Serious injuriesField investigationFinal reportNorth American P51D · Mar Vista, CAThe pilot's poor in-flight planning in attempting to immediately return to the airport and not following established procedures after the loss of power after takeoff. The failure of an intake valve was a factor in the accident.Sep 3, 1989 · N51MR · Substantial damageNTSB FTW89LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Dallas, TXPilot's failure to accurately calculate the necesary fuel for the flight and assure that the aircraft had been refueled to provide that quantity.Sep 3, 1989 · N60062 · Substantial damageNTSB FTW89FA159Accident · 3 fatalField investigationFinal reportCessna 152 · Houma, LAThe failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.Sep 3, 1989 · N24516 · 2 aircraft · DestroyedNTSB SEA89LA163Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Paradise Valley, NVThe pilot's inadequate preflight planning/preparation, and his failure to abort the takeoff. The high density altitude, soft runway, and fence were related factors.Sep 2, 1989 · N83TL · Substantial damageNTSB SEA89FA156Accident · 1 fatalField investigationFinal reportCessna TU206C · Skykomish, WAThe pilot's decision to continue the flight into IMC. The pilot did not adequately plan and prepare for the flight and was unable to maintain a proper altitude above the terrain for VMC. Fog was a related factor.Sep 2, 1989 · N21NW · DestroyedNTSB NYC89LA211Accident · No injuriesLimited investigationFinal reportCessna 150M · Colts Neck, NJFailure of the pilot to maintain directional control during a rough field takeoff. Contributing factor(s) was: the crosswind and he sunglare in the pilot's eyes.Sep 2, 1989 · N3668V · Substantial damageNTSB NYC89LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sanbornton, NHVFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.Sep 2, 1989 · N9334J · Substantial damageNTSB NYC89FA206Accident · 4 fatalField investigationFinal reportCessna 172P · Northfield, NHThe pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.Sep 2, 1989 · N65595 · DestroyedNTSB MKC89LA195Accident · No injuriesLimited investigationFinal reportBell 47G · Ozark, MOThe failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.Sep 2, 1989 · N182JR · Substantial damageNTSB MKC89FA194Accident · Serious injuriesField investigationFinal reportCessna 206A · Lees Summit, MOEngine partial power loss due to water in the aircraft fuel system, and an inadequate preflight.Sep 2, 1989 · N8705Z · DestroyedNTSB MIA89LA238Accident · No injuriesLimited investigationFinal reportCessna 177 · Woodville, MSImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: darkness and the ditch.Sep 2, 1989 · N2921X · Substantial damageNTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.Sep 2, 1989 · N24580 · Substantial damageNTSB LAX89LA299Accident · No injuriesLimited investigationFinal reportCessna 150M · Riverside, CAThe student pilot's failure to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's lack of recent experience and improper training by her flight instructor.Sep 2, 1989 · N6289K · Substantial damageNTSB LAX89DUQ05Accident · 2 fatalFinal reportRuppercht Varieze · California City, CAThe wing failed due to the pilot/owners overtorquing the wing bolts and the improper installation of the wing attach plates/cones.Sep 2, 1989 · N393D · DestroyedNTSB FTW89LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Bellville, TXImproper flare by the pilot and his improper recovery from a bounced landing, which resulted in an inadvertent porpoise and subsequent nose gear failure.Sep 2, 1989 · N13620 · Substantial damageNTSB DEN89LA215Accident · No injuriesLimited investigationFinal reportCessna 180K · Englewood, COFailure of the pilot to maintain directional control, which resulted in a ground swerve. The crosswind was a related factor.Sep 2, 1989 · N2705K · Substantial damageNTSB DEN89LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Philip, SDLoss of engine power for an undetermined reason. Factors related to the accident were: the power line & pole.Sep 2, 1989 · N2685G · Substantial damageNTSB BFO89DID02Accident · Serious injuriesFinal reportRotorway Exec · Palmyra, VAInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel.Sep 2, 1989 · N27TB · DestroyedNTSB ATL89LA210Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Hanceville, ALImproper flare by the pilot/owner and his failure to obtain/maintain proper airspeed for the go-around; and inadequate supervision and remedial action by the instructor pilot (other crew member). The uneven surface of the private strip was a contributing…Sep 2, 1989 · N666KH · Substantial damageNTSB ATL89LA208Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Spruce Pine, NCA loss of power for undetermined reasons. The power loss may have been due to a sticking valve(s).Sep 2, 1989 · N7174M · Substantial damageNTSB ATL89LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hickory, NCPilot's failure to adequately monitor the engine fuel consumption in flight.Sep 2, 1989 · N5210P · Substantial damageNTSB ANC89LA156Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Sheenjek River, AKFailure of the pilot to go around when he was unable to attain the proper touchdown point and his excessive application of brakes during the landing. Contributing factors were: the downdraft, excessive remedial action, and soft terrain.Sep 2, 1989 · N17689 · Substantial damageNTSB ANC89FA155Accident · Minor injuriesField investigationFinal reportCessna 180 · Anchorage, AKOil leak in the oil cooler. Contributing factors were: oil film on the windshield, which obscured the pilot's vision (visual perception) and hampered his ability to attain proper runway alignment, an object (rock), and high vegetation beside the airstrip.Sep 2, 1989 · N2137Z · Substantial damageNTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.Sep 1, 1989 · N62JE · DestroyedNTSB NYC89LA215Accident · No injuriesLimited investigationFinal reportBeech 1900C · Boston, MAThe failure of the ground personnel to safely guide the aircraft so that it would have cleared the jetway.Sep 1, 1989 · N318BH · Substantial damageNTSB NYC89LA209Accident · Serious injuriesLimited investigationFinal reportCessna 210 · No. Windham, VTThe pilot's failure to assure an adequate supply of fuel was available.Sep 1, 1989 · N2054S · DestroyedNTSB LAX89LA298Accident · No injuriesLimited investigationFinal reportStinson 108 · Cool, CAFailure of the #2 piston. Failure of the mechanic to properly overhaul the engine was a related factor.Sep 1, 1989 · N97628 · Substantial damageNTSB DEN89LA211Accident · No injuriesLimited investigationFinal reportCessna 182L · Moab, UTInadequate compensation for the wind conditions by the pilot, and his failure to attain a flare. The unfavorable (variable & gusty) wind condition was a related factor.Sep 1, 1989 · N42027 · Substantial damageNTSB DEN89LA204Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTFailure of the pilot to maintain directional control which resulted in a ground swerve. Soft terrain beside the runway was a related factor.Sep 1, 1989 · N6372K · Substantial damageNTSB ATL89FA207Accident · 2 fatalField investigationFinal reportCessna 152 · Tiptonville, TNThe pilot's failure to maintain a proper climb rate after takeoff. Factors related to the accident were: darkness, the pilot's lack of visual cues, his habit of making shallow climbs after takeoff, his lack of recent night flying experience, and the trees.Sep 1, 1989 · N25799 · DestroyedNTSB ANC89LA159Accident · No injuriesLimited investigationFinal reportCessna 172H · Sparrevohn, AKThe bucket which was blown into the flight path by a crosswind.Sep 1, 1989 · N2459L · Substantial damageNTSB ANC89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Trading Bay, AKSelection of unsuitable terrain (landing area) by the pilot. Contributing factors were: improper information provided by other personnel and a hidden obstruction (log) in tall vegetation (grass).Sep 1, 1989 · N4482E · Substantial damageNTSB ANC89LA154Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of unsuitable terrain for an off-airport operation. Factors related to the accident were: the adverse terrain conditions.Sep 1, 1989 · N64273 · Substantial damageNTSB SEA89LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Burns Junction, ORThe pilot did not maintain proper airspeed during takeoff.Aug 31, 1989 · N83330 · Substantial damageNTSB SEA89FA155Accident · No injuriesField investigationFinal reportCessna 402B · Seattle, WAThe landing gear down lock mechanism failure.Aug 31, 1989 · CGRKR · Substantial damageNTSB NYC89LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly · Hatboro, PAImproper in-flight planning/decision by the pilot which resulted in his failure to maintain clearance obstructions. A related factor was: the low level of propane (fuel), which resulted in low burner pressure.Aug 31, 1989 · N7406F · Minor damageNTSB NYC89LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Wolfeboro, NHInadequate compensation for wind conditions by the owner/pilot-in-command (PIC), his failue to maintain proper altitude on the approach, and failure of the other pilot (owner's instructor pilot) to take remedial action. Factors related to the accident were:…Aug 31, 1989 · N21353 · DestroyedNTSB NYC89LA205Accident · No injuriesLimited investigationFinal reportCessna 210N · Westerly, RIThe pilot-in-command's failure to properly ensure a sufficient quantity of fuel for the intended flight.Aug 31, 1989 · N873PJ · DestroyedNTSB LAX89LA292Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullhead City, AZFailure of the pilot to adequately perform inflight fuel consumption calculations to ensure the adequacy of the fuel supply for the flight's completion. Contributing to the accident was the failure of the pilot to consider the impact of the stronger than…Aug 31, 1989 · N6270E · Substantial damageNTSB LAX89FA294Accident · 1 fatalField investigationFinal reportBeech V35TC · Fort Jones, CAThe failure of the pilot to maintain sufficient altitude.Aug 31, 1989 · N6225V · DestroyedNTSB CHI89LA178Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Brooklyn, MIFailure of the pilot to see-and-avoid power lines in his flight path during a go-around. The power lines and his lack of familiarity with the airport were contributing factors.Aug 31, 1989 · N2101V · DestroyedNTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…Aug 31, 1989 · N490AA · 2 aircraft · No damageNTSB BFO89LA078Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Parkersburg, WVThe pilot's inadvertent use (movement) of the collective control during engine operation before shutdown, and a subsequent lift-off, loss of control, roll over, and collision with the ground.Aug 31, 1989 · N58281 · Substantial damageNTSB ATL89LA205Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Hertford, NCPilot's failure to properly flare the airplane during landing. Factors contributing to the accident were the high obstructions at both ends of the runway.Aug 31, 1989 · N5796V · Substantial damageNTSB ANC89LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilots improper use of brakes during the landing roll.Aug 31, 1989 · N13931 · Substantial damageNTSB ANC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKImproper planning/decision by the plt. Contributing factors were rough terrain, rain, high density altitude, tailwind, gusts, and the pilot's improper use of brakes.Aug 31, 1989 · N150LT · Substantial damage