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 LAX93LA203Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Davis, CAThe pilot's failure to follow a safety tip in the pilot's operating handbook to never make a downwind takeoff, his failure to maintain rotor RPM, and his improper use of the helicopter flight controls. A factor which contributed to the accident was the…May 5, 1993 · N80156 · Substantial damageNTSB LAX93LA201Accident · Minor injuriesLimited investigationFinal reportT.R. Bristol RV-6 · Trinity Center, CAThe pilot failure to obtain enough airspeed for takeoff which resulted in a loss of aircraft control, and his failure to compensate for the crosswind conditions.May 5, 1993 · N15TP · Substantial damageNTSB LAX93LA200Accident · 1 fatalLimited investigationFinal reportGrumman 164A · Biggs, CAFailure of the number 2 engine cylinder. A factor related to the accident was the lack of altitude for the pilot to make a successfull forced landing.May 5, 1993 · N5249 · DestroyedNTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.May 5, 1993 · N61306 · Substantial damageNTSB CHI93LA162Accident · 1 fatalLimited investigationFinal reportBeech A33-35 · Theodosia, MOPoor preflight planning/preparation by the pilot. Factors related to the accident were the tailwind, a heavy weight load, and unsuitable terrain in which to land the airplane.May 5, 1993 · N397Z · DestroyedNTSB CHI93LA160Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Muskegon, MIThe pilot-in-command's misjudging the flare.May 5, 1993 · N254AT · Substantial damageNTSB CHI93LA159Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe pilot's improper use of collective in recovering from a loss of control due to ground resonance.May 5, 1993 · N7504D · Substantial damageNTSB CHI93FA161Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paoli, INThe pilot-in-command's inadequate preflight preparations and his failure to maintain airspeed. Factors were the instructor's inadequate training of the pilot-in-command, unqualified maintenance personnel's inadequate inspection of the aircraft and the…May 5, 1993 · N2487T · DestroyedNTSB MIA93WA115Accident · No injuriesForeign investigationPiper PA-32R-300 · West End, BahamasMay 4, 1993 · N96RJ · DestroyedNTSB MIA93LA116Accident · No injuriesLimited investigationFinal reportBeech A23A · Fort Myers, FLTotal loss of engine power due to fuel exhaustion and poor preflight planning/preparation by the pilot in command. Contributing to the accident was the pilot's failure to request winds aloft during the weather briefing.May 4, 1993 · N2312W · Substantial damageNTSB FTW93LA149Accident · Minor injuriesLimited investigationFinal reportHaltom Avid Flyer · Houston, TXEngine power loss with cause undetermined. A factor was the lack of suitable terrainMay 4, 1993 · N567WH · DestroyedNTSB FTW93LA148Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lookeba, OKThe loss of engine power for undetermined reasons. Factors were the smoke in the cockpit and loss of outside visual reference.May 4, 1993 · N424OX · Substantial damageNTSB CHI93FA158Accident · 1 fatalField investigationFinal reportBeech E-18S · Lone Rock, WIwas a pre-mature extension of the landing gear by the pilot which resulted in the inability of the pilot to maintain the minimum descent altitude. Factors related to the accident were the loose cylinder and loss of oil.May 4, 1993 · N80CB · DestroyedNTSB BFO93LA069Accident · No injuriesLimited investigationFinal reportBeech B100 · Clarksburg, WVThe pilot's failure to maintain adequate clearance from the hangar. Contributing to the accident was the dark night.May 4, 1993 · N130AT · Substantial damageNTSB ATL93LA087Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Apex, NCThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.May 4, 1993 · N761CQ · Substantial damageNTSB LAX93FA202Accident · 1 fatalField investigationFinal reportCessna 175 · Jackson, CAA failure of the pilot to adequately calculate the required fuel for the flight and the pilot's continued visual flight into instrument meteorological conditions. The failure of the non-instrument rated pilot to obtain a weather briefing, and adequately…May 3, 1993 · N9494B · DestroyedNTSB FTW93LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Waco, TXThe students pilot's failure to maintain clearance from an object and inadequate supervision by the instructor pilotMay 3, 1993 · N46285 · Substantial damageNTSB ATL93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Macon, GAThe pilot's failure to attain the proper touchdown point. A factor was the pilot's failure to select another airport for landing and the intermittant runway and VASI lighting system.May 3, 1993 · N9911M · Substantial damageNTSB ANC93LA058Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe failure of the right brake due to improper installation of the brake line. Factors were the pilot's improper in flight planning/decision by not checking the brakes prior to landing, and the berm.May 3, 1993 · N82231 · Substantial damageNTSB MIA93WA117Accident · Serious injuriesForeign investigationMaule M-5-235C · Fowl Cay, BahamasMay 2, 1993 · N6171M · Substantial damageNTSB MIA93LA114Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Fort Lauderdale, FLThe pilot-in-command's failure to insure the aircraft contained adequate fuel to complete the flight, which resulted in loss of power in both engines due to fuel exhaustion.May 2, 1993 · N7656Q · DestroyedNTSB LAX93LA199Accident · 1 fatalLimited investigationFinal reportCanadair F-86E MK.6 · Santa Ana, CAThe pilot's inadequate planning/decision concerning performance of an aerobatic maneuver, and his failure to maintain adequate altitude/clearance above the runway during recovery from the maneuver. A factor related to the accident was: the pilot's lower…May 2, 1993 · N3842J · DestroyedNTSB LAX93LA196Accident · No injuriesLimited investigationFinal reportDornier DO-28 · Paradise, CAThe poor in flight fuel consumption calculations by the pilot and the pilot's in flight decision not to switch fuel tanks which caused the total failure of both of the airplane's engines. Factors relating to this accident were fuel starvation and the high…May 2, 1993 · N12828 · DestroyedNTSB BFO93LA068Accident · 1 fatalLimited investigationFinal reportLeveck Vancraft · Hebron, OHFailure of the pilot to maintain rotor RPM, which resulted in a loss of aircraft control. A factor related to the accident was the pilot's lack of experience flying the gyroplane with a body enclosure.May 2, 1993 · UNREG · Substantial damageNTSB BFO93LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Willimantic, CTFailure of the pilot to follow emergency procedures to ensure that the gear was locked. A factor related to the accident was the total electrical failure and the construction site located beside the runway.May 2, 1993 · N81529 · Substantial damageNTSB BFO93LA066Accident · No injuriesLimited investigationFinal reportQuickie 200 · N. Kingstown, RIImproper flare by the pilot.May 2, 1993 · N687EA · Substantial damageNTSB ANC93FA056Accident · 1 fatalField investigationFinal reportBell 204B · Copper Harbor, AKFatigue failure of the tail rotor gearbox, and improper helicopter operations being conducted by the operator resulting in repetitive at and over maximum loads. Factors in the accident were: material defect of the tail rotor gear box (inadequate quality…May 2, 1993 · N204AQ · DestroyedNTSB LAX93LA194Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Oakland, CAthe pilot's poor decision to continue flying the airplane with a known deficiency and the poorly performed major overhaul of the engine. The failed crankshaft due to fatigue are factors in this accident.May 1, 1993 · N731HP · DestroyedNTSB LAX93IA198Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot's improper flare and improper recovery from a bounced landing.May 1, 1993 · N803DE · Minor damageNTSB LAX93GA195Accident · 2 fatalFinal reportMooney M20J · Sedona, AZUndetermined.May 1, 1993 · N201GK · DestroyedNTSB FTW93LA147Accident · No injuriesLimited investigationFinal reportRaven S-55A · Bentonville, ARAircraft control was not maintained by the pilot. A factor was unfavorable windsMay 1, 1993 · N6465K · Substantial damageNTSB FTW93LA146Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec PZL-M-18 · De Witt, ARCompensation for wind improper by pilot. Factors were tailwind and downdraftMay 1, 1993 · N28587 · DestroyedNTSB DEN93FA053Accident · 2 fatalField investigationFinal reportBeech 65-A90 · Mount Ida, ARThe pilot's failure to establish an adequate climb rate. Factors in the accident were: pilot fatigue from lack of sleep, and the weather conditions.May 1, 1993 · N530N · DestroyedNTSB CHI93LA156Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B2B · Greencastle, INContamination of the fuel system by particulate matter of an unknown origin.May 1, 1993 · N2257U · Substantial damageNTSB CHI93FA153Accident · 2 fatalField investigationFinal reportCessna 150L · De Kalb, ILThe failure of the pilot flying the airplane to maintain an airspeed above stall speed.May 1, 1993 · N6783G · DestroyedNTSB BFO93LA080Accident · No injuriesLimited investigationFinal reportMcmillin Fisher 404 · Wampum, PAThe overtorque of a safety wire on a plastic fuel line, causing the line to split.May 1, 1993 · UNREG · Substantial damageNTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.May 1, 1993 · N49394 · Substantial damageNTSB BFO93LA064Accident · No injuriesLimited investigationFinal reportBeech E18S · Xenia, OHInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.May 1, 1993 · N665M · Substantial damageNTSB ANC93LA059Accident · No injuriesLimited investigationFinal reportCessna 172 · Kasigluk, AKThe pilot's poor judgement in attempting a takeoff from a narrow, wet, soft gravel runway with a crosswind. The runway conditions and the crosswind were factors in the accident.May 1, 1993 · N6332D · Substantial damageNTSB NYC93LA095Accident · No injuriesLimited investigationFinal reportMacphee RV6 · Farmingdale, NJThe pilot's improper starting procedure, which caused the airplane to nose down.Apr 30, 1993 · N726WM · Substantial damageNTSB FTW93LA145Accident · No injuriesLimited investigationFinal reportCessna 310H · Brookshire, TXThe pilot's failure to attain proper runway alignment. Factors were the dark night and weather conditions.Apr 30, 1993 · N48AA · Substantial damageNTSB FTW93LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXUndetermined.Apr 30, 1993 · N7485 · Substantial damageNTSB CHI93LA155Accident · No injuriesLimited investigationFinal reportMaule M5 · Green Bay, WIThe pilot's failure to maintain control of the airplane.Apr 30, 1993 · N5644D · Substantial damageNTSB CHI93LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Oshkosh, WILoss of engine power for an undetermined reason.Apr 30, 1993 · N50963 · Substantial damageNTSB LAX93LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Monica, CAThat the pilot misjudged the flare and failed to properly recover from the ensuing bounced landing. The pilot's failure to attain the proper touchdown point was a factor.Apr 29, 1993 · N401KA · Substantial damageNTSB FTW93MA143Accident · Minor injuriesMajor investigationFinal reportEmbraer EMB-120 RT · Pine Bluff, ARThe captain's failure to maintain professional cockpit discipline, his consequent inattention to flight instruments and ice accretion, and his selection of an improper autoflight vertical mode, all of which led to an aerodynamic stall, loss of control, and a…Apr 29, 1993 · N24706 · Substantial damageNTSB DEN93FA052Accident · 2 fatalField investigationFinal reportBeech 58 · Telluride, COFailure of the pilot-in-command to plan and/or assure selection of an altitude/course combination that would provide terrain clearance, and failure of the other (second) pilot to adequately monitor the situation. Darkness, high (mountainous) terrain, and…Apr 29, 1993 · N5650N · DestroyedNTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…Apr 29, 1993 · N115GP · DestroyedNTSB CHI93FA149Accident · 2 fatalField investigationFinal reportCessna 421B · Valley Park, MOImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and the pilot's failure to maintain control of the airplane during approach to an emergency landing. A related factor was: failure of the pilot to…Apr 29, 1993 · N4939M · DestroyedNTSB ATL93LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Arden, NCThe loss of engine power, and the pilot's premature flare during landing, which resulted in a landing stall. Factors were the high obstructions (trees) trees near the landing site, and the uphill terrain conditionsApr 29, 1993 · N2971J · Substantial damage