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 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…NTSB 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.NTSB 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.NTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.NTSB 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.NTSB CHI93LA160Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Muskegon, MIThe pilot-in-command's misjudging the flare.NTSB 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.NTSB 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…NTSB MIA93WA115Accident · No injuriesForeign investigationPiper PA-32R-300 · West End, BahamasNTSB 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.NTSB FTW93LA149Accident · Minor injuriesLimited investigationFinal reportHaltom Avid Flyer · Houston, TXEngine power loss with cause undetermined. A factor was the lack of suitable terrainNTSB 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.NTSB 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.NTSB 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.NTSB ATL93LA087Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Apex, NCThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB 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…NTSB FTW93LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Waco, TXThe students pilot's failure to maintain clearance from an object and inadequate supervision by the instructor pilotNTSB 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.NTSB 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.NTSB MIA93WA117Accident · Serious injuriesForeign investigationMaule M-5-235C · Fowl Cay, BahamasNTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB BFO93LA066Accident · No injuriesLimited investigationFinal reportQuickie 200 · N. Kingstown, RIImproper flare by the pilot.NTSB 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…NTSB 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.NTSB LAX93IA198Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX93GA195Accident · 2 fatalFinal reportMooney M20J · Sedona, AZUndetermined.NTSB FTW93LA147Accident · No injuriesLimited investigationFinal reportRaven S-55A · Bentonville, ARAircraft control was not maintained by the pilot. A factor was unfavorable windsNTSB FTW93LA146Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec PZL-M-18 · De Witt, ARCompensation for wind improper by pilot. Factors were tailwind and downdraftNTSB 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.NTSB CHI93LA156Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B2B · Greencastle, INContamination of the fuel system by particulate matter of an unknown origin.NTSB CHI93FA153Accident · 2 fatalField investigationFinal reportCessna 150L · De Kalb, ILThe failure of the pilot flying the airplane to maintain an airspeed above stall speed.NTSB BFO93LA080Accident · No injuriesLimited investigationFinal reportMcmillin Fisher 404 · Wampum, PAThe overtorque of a safety wire on a plastic fuel line, causing the line to split.NTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB BFO93LA064Accident · No injuriesLimited investigationFinal reportBeech E18S · Xenia, OHInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB 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.NTSB NYC93LA095Accident · No injuriesLimited investigationFinal reportMacphee RV6 · Farmingdale, NJThe pilot's improper starting procedure, which caused the airplane to nose down.NTSB FTW93LA145Accident · No injuriesLimited investigationFinal reportCessna 310H · Brookshire, TXThe pilot's failure to attain proper runway alignment. Factors were the dark night and weather conditions.NTSB FTW93LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXUndetermined.NTSB CHI93LA155Accident · No injuriesLimited investigationFinal reportMaule M5 · Green Bay, WIThe pilot's failure to maintain control of the airplane.NTSB CHI93LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Oshkosh, WILoss of engine power for an undetermined reason.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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 conditions