NTSB investigations, 2000
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA00LA115Accident · No injuriesLimited investigationFinal reportCessna 182B · Laurel, MTThe pilot's selection of unsuitable terrain for the precautionary landing. Wet and soft terrain, and the pilot's failure to maintain directional control of the aircraft during the landing roll were factors.NTSB SEA00LA096Accident · No injuriesLimited investigationFinal reportAS+ AS-4 · Ephrata, WAThe pilot's improper in-flight decision by not immediately seeking a safe landing site upon encountering the sink. A factor was the high vegetation (sagebrush).NTSB IAD00LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe pilot's failure to attain a proper touchdown point.NTSB CHI00LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Plainwell, MIthe pilot exceeded the proper touchdown point during the landing. Factors associated with the accident were the fence and the ditch which the airplane contacted.NTSB SEA00LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Johnson Creek, IDThe pilot's failure to maintain clearance from the rising terrain. Factors include his poor decision to depart without assurance that he could clear the surrounding terrain under the ambient conditions, his failure to adhere to the accepted procedure of…NTSB LAX00FA208Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Hawthorne, CAA partial loss of power due to water contamination in the fuel system and the pilot's inadequate preflight inspection, which failed to detect the water. The pilot's failure to perform an engine run-up before takeoff is also causal. Additional causes are the…NTSB FTW00LA165Accident · No injuriesLimited investigationFinal reportHard Capella XLS · Taylor, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's lack of experience in the make and model of the accident aircraft.NTSB FTW00LA160Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Kaufman, TXThe failure of the left magneto, which resulted in a partial loss of engine power. Factors were the fouled number 3, 4, and 5 rear spark plugs and the lack of suitable terrain for the precautionary landing.NTSB FTW00LA158Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sand Springs, OKThe pilot's failure to maintain directional control during the takeoff. A factor was the fence struck by the aircraft.NTSB MIA00LA176Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe unsuitable terrain encountered by the pilot-in-command during the forced landing and the loss of engine power for undetermined reasons.NTSB MIA00LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, NCThe inadequate supervision of the student pilot by the CFI for his failure to note that the student was performing a go-around from a low pass with 30-degree of flaps extended instead of the POH recommended 20-degrees. A factor in the accident was the failure…NTSB MIA00LA174Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Milledgeville, GAThe operation of the airplane by the pilot-in-command in an over gross weight condition, the failure of the pilot to maintain airspeed (Vs) after takeoff, and the intentional stalling of the airplane by the pilot-in-command for his attempting to bank while…NTSB MIA00LA173Accident · No injuriesLimited investigationFinal reportRawdon T1 · North Miami Bch, FLThe failure of the pilot to change the fuel selector position after experiencing surging of the engine. Contributing to the accident was the partial loss of engine power due to fuel starvation and the incorrect reading of the left fuel gauge.NTSB MIA00FA172Accident · 2 fatalField investigationFinal reportAvions Mudry ET Cie CAP 10B · Bunnell, FLA midair collision due to the failure of the wingman to maintain proper clearance between his aircraft and the lead aircraft while conducting formation aerobatics and the subsequent loss of control of both aircraft resulting in an uncontrolled descent and…NTSB LAX00FA207Accident · 2 fatalField investigationFinal reportCessna 172RG · Prescott, AZThe flight instructor's delayed remedial action, and his failure to correct an inappropriate descent during maneuvering flight, while engaged in commercial flight training maneuvers.NTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB CHI00FA145Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Taylor, MOflight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…NTSB NYC00LA145Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Hammonton, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind condition.NTSB NYC00LA143Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Pittsfield, METhe pilot's improper use of unsuitable terrain for landing. A factor in the accident was the soft terrain.NTSB MIA00LA183Accident · No injuriesLimited investigationFinal reportHayes LONG-EZ · Collegedale, TNThe pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.NTSB MIA00LA179Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Windermere, FLan in-flight collision with a tree. A factor in this accident was high wind conditions.NTSB LAX00FA206Accident · 2 fatalField investigationFinal reportBeech F33A · Columbia, CAThe pilot's failure to abort the downwind takeoff and his failure to attain flying speed.NTSB IAD00FA044Accident · 1 fatalField investigationFinal reportKurzenburger Stuka JU-87 · Urbana, MDThe pilot's failure to obtain/maintain aircraft control after takeoff.NTSB FTW00WA173Accident · Minor injuriesForeign investigationCessna A185F · Mixcolaja, GuatemalaNTSB DEN00FA095Accident · 3 fatalField investigationFinal reportCessna T210K · Buena Vista, COthe pilot's disregard of the weather forecast, and his VFR flight into IMC. Contributing factors were snow showers, fog, and the mountainous terrain.NTSB CHI00LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Sublette, KSthe failure of the pilot to attain aircraft control. Factors to the accident were the uneven terrain, the failure of the pilot to maintain directional control on the ground, and the crop.NTSB ATL00LA057Accident · No injuriesLimited investigationFinal reportJohn Thomas Cloud Dancer 2 · Franklin, NCThe pilot's failure to maintain directional control of the gyroplane during takeoff roll, resulting in a roll over.NTSB ANC00LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Nenana, AKThe pilot's inadequate compensation for wind conditions during landing. A factor in this accident was the tailwind.NTSB SEA00LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200 · Seattle, WAThe failure of the B-767 flight crew to ensure their aircraft's jet blast was not a hazard to the Cessna. A factor for the Cessna was the B-767 moving on the taxiway. A factor for the B-767 was the Cessna standing in the runup area. A factor for both aircraft…NTSB SEA00LA092Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58 · Buhl, IDThe pilot's inadequate visual lookout, and his failure to maintain adequate clearance from the power lines. The pilot's diverted attention, a dirty windshield, power lines, and light rain were factors.NTSB SEA00LA091Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Wolf Point, MTIn flight collision with birds.NTSB SEA00LA090Accident · No injuriesLimited investigationFinal reportCessna T210M · Boise, IDThe deterioration and subsequent leakage of a hydraulic line which resulted in the total loss of hydraulic fluid and the inability of the pilot to extend the landing gear into the locked position.NTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.NTSB MIA00LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe failure of the CFI to delay his landing until the approaching line of thunderstorms passed, causing the flight to encounter severely gusting wind conditions resulting in the loss of altitude control and collision with the terrain.NTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.NTSB DEN00LA098Accident · No injuriesLimited investigationFinal reportRosenvall Avid MK IV · Salina, UTThe pilot's failure to maintain aircraft control during landing roll. A factor was gusting winds from nearby thunderstorms.NTSB DCA00WA054Accident · No injuriesForeign investigationMcDonnell Douglas MD-80 · Paris, FranceNTSB NYC00LA147Accident · No injuriesLimited investigationFinal reportLet L 33 Solo · Waynesville, OHThe pilot's failure to maintain aircraft control. Factors were gusty winds, and the pilot's lack of experience in the make and model accident glider.NTSB NYC00LA141Accident · 1 fatalLimited investigationFinal reportCarlson Criquet · East Palestine, OHThe failure of the powerplant to produce adequate power for undetermined reasons, and the pilot's continued operation of the airplane with known deficiencies.NTSB MIA00LA170Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Fort Pierce, FLAn in-flight separation of a tail rotor blade tip weight resulting in tail rotor assembly imbalance and separation due to the installation of an unapproved rotor blade by company maintenance personnel, and the subsequent collision with trees during an…NTSB LAX00LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tonopah, NVThe pilot's failure to attain the proper rotation airspeed during initial takeoff and his improper aborted takeoff procedures.NTSB LAX00LA203Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Pacific Ocean (Pacific Ocean)Physical incapacitation of the pilot from improper handling of a pesticide.NTSB FTW00LA169Accident · 1 fatalLimited investigationFinal reportCecil Thorp T-18 · West, TXThe loss of control for an undetermined reason.NTSB FTW00LA153Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Patterson, LAthe failure of the tail rotor spider bearing, the pilot's failure to follow the proper emergency procedures as stated in the helicopter's checklist by not performing a run-on landing, and the inadvertent deactivation of the hydraulic system.NTSB CHI00LA143Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Green Bay, WIthe improper compensation for the wind conditions. A factor in the accident was the wind shear.NTSB NYC00LA142Accident · No injuriesLimited investigationFinal reportHeli-Eagle Ultrasport 496 · Newport News, VAThe pilot's failure to maintain control of the helicopter.NTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.NTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.NTSB CHI00LA141Accident · No injuriesLimited investigationFinal reportCessna C310R · Hibbing, MNthe deer incursion on the landing runway.