NTSB investigations, 2000
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE year(c.\"eventDate\") = 2000 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 WHERE year(c."eventDate") = 2000 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 IAD00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Owingsville, KYA loss of engine power due to water contamination of the fuel. Also causal in the accident was the pilot/owner's failure to repair the inoperative fuel cap.NTSB DEN01LA005Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COTotal failure of the right forward inboard landing gear door hinge pin for undetermined reasons.NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.NTSB ANC00LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll. A factor associated with the accident was the presence of tall brush alongside the runway.NTSB SEA00LA191Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Auburn, WAThe pilot's failure to adequately secure the aircraft prior to a manual engine start. A contributing factor was the excessive throttle setting on start.NTSB MIA00LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLan in-flight encounter with turbulence.NTSB MIA00LA270Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Charlotte, NCthe right main brake locked after touchdown causing the airplane to yaw and depart the runway, resulting in the landing gear collapsing.NTSB LAX00LA348Accident · Serious injuriesLimited investigationFinal reportCulver LFA · Ione, CAThe failure of the right brake during the landing roll resulting in loss of directional control and subsequent nose over of the airplane.NTSB DEN00LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Broomfield, COThe pilot's failure to maintain adequate clearance from a vehicle parked beside the ramp while he was taxiing the aircraft from landing.NTSB CHI00LA309Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILThe student pilot's inadequate compensation for the crosswind that resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the ditch, the student's lack of experience, and the poor…NTSB ATL00LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Adel, GAThe pilot's selection of a closed runway for landing. Contributing factors were his inadequate inflight planning/decision and the wood block on the runway..NTSB SEA00LA189Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Corvallis, ORThe instructor pilot's delayed remedial action. Factors include the student's failure to properly initiate a flare, and the soft terrain immediately adjacent to the taxiway.NTSB FTW00FA268Accident · 2 fatalField investigationFinal reportCessna 152 · Navasota, TXthe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributory factors were the clouds, dark night light conditions, the pilot's lack of total instrument flight time, and the pilot's self-induced pressure to complete the…NTSB DEN01LA006Accident · No injuriesLimited investigationFinal reportNorth American T-28D · Heber City, UTthe failure of the nose wheel landing gear shimmy damper, which resulted in failure and collapse of the nose wheel landing gear during landing roll.NTSB SEA00LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Burlington, WAMintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…NTSB NYC00LA266Accident · Serious injuriesLimited investigationFinal reportMorrison RANS-12 · Warrenton, VAThe pilot's inadequate airspeed which resulted in the inadvertent stall. A factor related to the accident was the gusting wind condition.NTSB LAX00LA349Accident · No injuriesLimited investigationFinal reportWoodruff Lancair 360 · Kernville, CAThe pilot failed to maintain an adequate airspeed margin, resulting in a stall/mush and hard landing, and failed to maintain directional control and the left main landing gear separated when it struck a rock.NTSB SEA00LA187Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberg, ORThe pilot's failure to maintain a proper glide path on final approach. Factors include a vehicle on the roadway and a downdraft.NTSB SEA00LA186Accident · 1 fatalLimited investigationFinal reportde Havilland DH-100 MK.6 · Ontario, ORThe pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.NTSB SEA00LA185Accident · Serious injuriesLimited investigationFinal reportRowe Pietenpol · Raymond, WAThe pilot's failure to maintain an airspeed above power-off stall speed (Vso) while attempting a forced landing after a total loss of engine power, and his failure to move the fuel selector switch to the 'ON' position prior to takeoff. Factors include the…NTSB NYC00LA265Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Greenville, METhe pilot's improper in-flight decision to continue his descent without visual contact with the runway, and his inattention to his altitude, in relation to the airport elevation.NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.NTSB LAX00LA351Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty and variable crosswind conditions. Factors were the variable and gusty crosswinds.NTSB LAX00FA347Accident · Minor injuriesField investigationFinal reportCessna 207A · Valle, AZImproper maintenance and adjustment of the engine magnetos resulting in a loss of optimum performance during a critical takeoff that required peak engine performance.NTSB LAX00FA346Accident · 2 fatalField investigationFinal reportCessna 182G · Tuba City, AZthe pilot's inadvertent descent into terrain on the downwind leg for landing. Contributing to the accident was the dark night and sparse population.NTSB FTW00LA269Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Tomball, TXThe student pilot's abrupt lowering of the collective. Factors were the student pilot's lack of experience in helicopters and the CFI's delayed remedial action.NTSB DEN00LA177Accident · No injuriesLimited investigationFinal reportCessna 340 · Broomfield, COThe pilot landing the aircraft hard exceeding the design stress limits. Factors were: Low ceiling, freezing rain, dark night, excessive descent rate, and improper glide path.NTSB ANC00LA132Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-3 · Ketchikan, AKThe pilot's inadvertent activation of the collective flight stop/emergency fuel augmentation switch, which resulted in engine and main rotor overspeeds, thereby precipitating failures of the tail rotor drive shaft coupling and power turbine blades. A factor…NTSB SEA00LA183Accident · No injuriesLimited investigationFinal reportBeech B99 · Missoula, MTA loss of directional control due to a brake locked as a result of snow and ice contamination.NTSB LAX00RA358Accident · Serious injuriesForeign investigationde Havilland DHC-2T · Clearwater, CanadaNTSB LAX00LA345Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CALoss of engine power due to failure and separation of the number one connecting rod.NTSB DEN00LA176Accident · No injuriesLimited investigationFinal reportBell 206B · Rawlins, WYThe company dispatching, and the pilot initiating, flight into known adverse weather with an aircraft which did not have the required anti-ice equipment installed. A factor was snow conditions.NTSB DCA00WA088Accident · Minor injuriesForeign investigationBoeing 707-312B · Niamey, NigerNTSB CHI00TA306Accident · Minor injuriesFinal reportBell 47G-5A · Economy, INThe pilot failed to maintain control of the helicopter while attempting a landing on unsuitable terrain. A factor associated with the accident was the grass covered, down slope in the terrain.NTSB CHI00LA304Accident · No injuriesLimited investigationFinal reportCessna 182S · Wichita, KSthe pilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the pilot's improper recovery from the bounced landing and his failure to go-around.NTSB SEA00TA182Accident · No injuriesFinal reportBell 206-L4 · Atlanta, IDThe pilot's failure to maintain clearance from an object. Trees and inadequate ground communications were a factor.NTSB LAX00LA344Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Corcoran, CAThe pilot's inadequate preflight inspection and his failure to maintain directional control during takeoff. Factors were the pilot's failure to ensure that the fuel tank cover was replaced properly, fuel contamination of the windscreen, and the sun angle that…NTSB FTW00LA267Accident · Minor injuriesLimited investigationFinal reportPZL-Mielec M-18A · Jacksonville, ARthe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight. A factor was the failure of the operator to perform the recommended wing attachment fitting inspection.NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.NTSB ATL00LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Deland, FLA partial loss of engine power during initial climb following takeoff, due to the restricted movement of the number two cylinder's exhaust valve.NTSB ANC00LA129Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Anchorage, AKThe pilot's inadequate compensation for high, gusty wind conditions during water taxi. Factors associated with the accident are high and gusty wind conditions.NTSB SEA00LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brookings, ORThe pilot's loss of control during the landing attempt. Trees, a crosswind condition, the pilot's inadequate compensation for the wind conditions, and a delayed remedial action were factors.NTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.NTSB DEN00LA172Accident · No injuriesLimited investigationFinal reportBoeing Stearman D75N1 · Englewood, COthe flight instructor not maintaining supervision. Contributing factors were the student's hard landing due to excessive flare and subsequent inadvertent stall, and the student's failure to maintain directional control during landing roll.NTSB CHI00LA303Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · Jeffersonville, INthe pilot's inadequate normal braking and the pilot's inability to stop the airplane on the runway. Factors relating to this accident were the hydroplaning conditions, wet runway, the tailwind, the trees, and the ravine.NTSB CHI00FA302Accident · 2 fatalField investigationFinal reportCessna 150G · Jasper, INthe inadvertent stall by the pilot in command. Contributing factors were the approach airspeed not obtained/maintained by the pilot in command and the wind gusts.NTSB ANC00LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Galena, AKThe pilot's inadequate compensation for the wind conditions. Factors were the crosswind, and a snow-covered ridge.NTSB ANC00FA128Accident · 1 fatalField investigationFinal reportCessna 207 · Aniak, AKThe pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…NTSB LAX00LA343Accident · Serious injuriesLimited investigationFinal reportBell 206BIII · Ojai, CAthe pilot encountered a loss of tail rotor effectiveness which led to an uncontrolled rotation and subsequent hard landing. Factors were unfavorable wind conditions, density altitude, and uneven terrain.NTSB IAD00LA084Accident · No injuriesLimited investigationFinal reportCessna 150G · Conesus, NYthe pilot's inadequate preflight performance planning.